AddThis Social Bookmark Button
Pawan Bakhru ( Available )
Pleasanton, Alabama - 94566 USA
Expertise :Business Analysis
Status :Have Work Visa
Job Type :
All - Corp-to-Corp
Position :Computer Systems Analysts, Computer Systems Engineers/Architects, Computer Specialists, All Other

Resume
 
Summary





A professional Business Analyst with more than 10 10 years of Information Technology experience, Project Management, Business Analysis, Process Development, Systems and Technical/Database analysis, Quality Assurance, UAT/Change Management and End-User Training in Healthcare, Finance and eCommerce.
Proficient in MS SharePoint 2003/2007 : Customized SharePoint for clients based on their individual business needs. Good Understanding of SharePoint Designer tool.
Worked on Java based applications and .Net User Interfaces for eCommerce clients
Familiar with Waterfall and Agile methodologies
Proficient in Business Process Modeling : Conducted interviews to define business process for claims processing and authorization for Healthcare and service-oriented architecture SOA
Excellent knowledge of MSOffice, Visio and working knowledge of Testing tools, Rational Unified Process, RUP, Unified Modeling Language UML, Object Modeling and other web technologies.
Superior systems analysis and domain modeling skills with experience in gap analysis, requirements gathering, writing functional specifications and preparing technical documentation
In-depth understanding of the healthcare industry in terms of its structure, administrative processes and regulations like the HIPAA Privacy and Transaction and Code Sets.
Excellent analytical skills coupled with the ability to translate technical concepts and complex business requirements to user level terms.
Worked closely with product owners, developers and end users on process improvement activities and acted as a liaison between I.T, B2B and B2C customers and end users.
Expansive thinker and quick learner with excellent written and verbal communication skills and highly effective liaison.


Employment

July, 2009 -  Present
Business Analyst

Symantec/EDS Mountain View CA

Scope of Project : Define and document requirements for reconciliation of files, revise exiting system requirements, work on vendor files to identify how the data should be interpreted for existing and future vendor file.

Interviewed SME to gather necessary information to identify the impacted files
Identified key fields required to derive theory to understand and interpret files for reconciliation
Identified gaps in the files in an effort to improve the data quality and stability of the files
Tracked the project issues as needed on SharePoint
Documented traceability and UAT scenarios based on the information gathered through various procedures
Coordinated with Design and QA teams to define the actual file sharing process
Communicated effectively with users in defined intervals and based on the urgency

Environment : MS Outlook, Office Suite, Visio 6.0, SharePoint, Toad, SQL, Project 2003/2007


August, 2008 -  June, 2009
Business Process Analyst

Wells Fargo San Francisco CA

Scope of Project : As a part of Best Practices, create a Project Management process with right touch-points to B2B, technical/database queues from an end-to-end perspective enterprise wide for internal and external users, alliance vendors. Identify bottlenecks in the existing processes and suggest improvements using industry benchmarks to optimize the overall process. Worked on various departments to draft the as-is and to-be strategy, improvements of existing templates, documents and tools. Create a collaboration site using SharePoint to consolidate the existing documents after revising them based on the industry standards. Propose solutions for process improvements and enhancements.

Interviewed users and architects to gather necessary information to help create a process
Shared as-is and to-be strategy with users and updated the process based on their feedback
Worked with multiple project managers to understand how the manage their projects from inception to closure
Designed and documented prototype using Visio
Planned required tasks for a PM SharePoint site
Designed information structure at a high level for PM SharePoint site
Identified data sources to map and validate data between interfaces and evaluated cross functional impact
Mapped existing extracts to enhanced ones to pin-point changes meets requirements and proprietary specifications
Authored Project Plan and tracked the project issues as needed
Coordinated with QA strategy team to define a touch-point to the PM process

Environment : MS Outlook, Office Suite, Visio 6.0, SharePoint,. Net, HTML, Project 2003/2007


May, 2007 -  July, 2008
Business Process Analyst

eBay Inc San_Jose CA

Scope of Project : Analyzed existing process of on-boarding employee vs. contractor from an end-to-end perspective enterprise wide for human resource department, B2B and B2C touch points. Identify bottlenecks in the existing processes in HRMS and suggest improvements to optimize the overall eCommerce process. Worked on various projects, existing product and eCommerce process improvements, enhancements and creating SLAs for identified business workflows.

Interviewed and documented the existing vs. future process for on-boarding and off-boarding an employee or a contractor.
Created 72 workflows for 24 GSD Re-write of Forms ; front end of this application was .Net and back end was Remedy.
Worked with IPM/ITS team to analyze the to-be state and merge the existing Pageout tool with vNOC Incident Management.
Designed UAT Test Management Site for SAM/SUN IDM Operations using Sharepoint ; created lists as per requirements and consolidated the existing test scenarios based on release dates.
Created process flows, gathered product requirements and completed UAT successfully with users for LEP 2.0.
Conducted business and system analysis to document the to-be state for multiple projects and presented it to the higher management as needed.
Documented flow and mapped employee data between sources
Wrote functional requirement document to address the business needs
Documents were managed on SharePoint and files shared through this medium.
Created change request for specific adjustments needed to fulfill the requirement during UAT.
Shared artifacts and tracked project progress using SharePoint.
Used SharePoint for online collaboration between team members, stakeholders and project managers.
Identified business workflows impact on system performance and volume of data processed. Participated in creating Service Level Agreements to this effect.
Environment : MS Outlook, Office Suite, Visio 6.0, Remedy 6.x,7.x, SharePoint,. Net, Project server, Adobe Photoshop 8.1


October, 2006 -  April, 2007
Business Analyst

Wells Fargo Bank San Francisco CA

Scope of Project : This project was on radar at the CIO level. Lead business analysis and system analysis along with project management for Reconciliation of accounts and their balances between multiple systems. Project involved working with internal and external users to reconcile B2B and B2C accounts based on defined matching criteria in a system application. Also assist in producing customized reports as per business needs. Job involved understanding Hardware requirements for servers and creating sizing based on project needs and requirements.

Project Management for reconciliation of accounts and their balances using ReconSecurities Application.
Lead installation and configuration setup of Systems application for testing and production environment.
Created Conceptual/Technical Design documents based on the Business Requirements
Worked with system administrator, infrastructure, architecture, security and transmission experts to complete the setup of UAT and Production servers for setting up of Recon Application on specified server.
Monitored and escalated requests to the appropriate contacts in their respective departments as and when needed.
Data cleanup was required for employee, employer and carrier during the term of the project.
Environment : MS Outlook, Office Suite, Visio 6.0, Access, SQL Server, Oracle


July, 2006 -  September, 2006
Business/QA Analyst

WellPoint Thousand Oaks CA Wells Fargo Bank San Francisco CA

Scope of Project : Part of Medical Management IT team interviewed business users to gather Business Requirements. Project involved working on Test Plans after reviewing Business Requirement Technical Document BTRD. Perform quality assurance, verification and validation of test cases and trace them back to the business requirements on Business Requirement Traceability Matrix RTM. Create artifacts for CMS Compliance Projects. Participation in Business Requirements and Test Requirements gathering sessions was required.

Understand Business Requirements to create Test Plans and Test Scenarios reflecting the business and user needs
Involved conducting Quality Assurance sessions to validate System Testing outputs
Involved in User Acceptance Test UAT following the completion of the System Testing
Created RTM to trace the Test Scenarios back to BTRD.

Created Project Status Sheets for 15 resources to identify the priorities of the project and participated in status meetings
Assisted users in UAT as required
Environment : MS Outlook, Office Suite, Visio 6.0, Access. Java, J2EE


October, 2005 -  June, 2006
Business/QA Analyst

PacifiCare Cypress CA

Scope of Project : Part of Data Warehouse team interviewed business users to gather Business Requirements. Project required working on Test Plans after creating Conceptual Design documents based on the user requirements. Perform quality assurance, verification and validation of test cases and trace them back to the business requirements. Project involved working on 27 user requirements and participating as Team Lead in Matrix Projects CMS Compliance Projects. Attend JAD sessions as required. This project gave exposure to SDLC.

Understand Business Requirements and Conceptual Design to create Test Plans and Test Cases
Involved conducting Quality Assurance sessions to validate System Testing outputs
Conducted test of ETL software using PL/SQL, Unix Shell scripts and Toad.
Involved in User Acceptance Test UAT Management following the completion of the System Testing
Created Traceability Matrix to validate the Testing against the Conceptual Design and Business Requirements

Represented Data Warehouse Team in JAD Sessions and participated in Status meetings as required
Reviewed functional/technical specification documents to analyze the data transfer between systems
Documented and presented Business Requirements to Information Systems Team
Participated in implementation plan meetings as required
Created change request for specific adjustments needed to fulfill the requirement during UAT.
Environment : MS Outlook, Office Suite, Visio 6.0, COBOL, Access, Data Warehouse, Oracle, Unix Shell Script, Toad, PL/SQL, ETL


May, 2005 -  September, 2005
Business/Data Analyst

United Healthcare , NJ PacifiCare Cypress CA

Scope of Project : Performed data analysis and mapped data to an Object Model created for optimizing the resources accessed by different systems in United Healthcare. Interfacing of systems, understanding Class and UML diagrams, heavy data mapping and analysis, reporting findings and deliverables were part of the project

Reviewed functional/technical specification documents to analyze the data transfer between systems
Mapped data to HIPAA Layouts : 270/271 based on the business rules governing them
Documented the findings to be presented to the business and systems team at UHC
Documented required steps for implementation plan
Environment : Lotus Notes 6.5, Office Suite, Visio 6.0, COBOL, XML, COSMOS, Rational Requisite Pro., Java, J2EE


July, 2004 -  April, 2005
Business Analyst

United Healthcare , MN

Scope of Project : Introduction of new health plans and systems integration and management was the highlight of this project. As a lead provided consulting services to the client on different UHC interfaces eCommerce Portal. Drove requirements gathering JAD sessions, automation and matrix projects as needed.

Performed dual roles in multiple projects, Business/Systems Analysis, Business Process Modeling and overall Project Management
Created comprehensive Project Scope document for client and facilitated effective communication between client and vendor
Prepared High Level Diagram to document the data flow between systems

Involved in defining Work Breakdown Structure WBS and Time Estimates for completion of Project
Reviewed Conceptual Design documents and gathered Business Requirements
Involved in systems testing, interfacing of systems and mapping data based on HIPAA standards or Proprietary layouts : 837 I, 834 and 278
Conducted walkthroughs presenting Scope document and Business Requirements Specification to technical team and stakeholders
Conducted requirements gathering and mapping sessions with clients and vendors.
Created change request for specific adjustments needed to fulfill the requirement during UAT.
Wrote functional requirement document to address the business needs.
Environment : Lotus Notes 6.5, Office Suite, Visio 6.0, Cobol, COSMOS, Java,. Net


May, 2004 -  July, 2004
Business Systems Analyst

United Healthcare , NJ United Healthcare , MN

Scope of Project : Project required creation of Functional/Technical Specifications after analyzing existing systems to adopt the integration of GeoAccess provider directory application for myuhc.com eCommerce site. UHG wanted to replace their online provider directory to GeoAccess Provider Lookup Online. Specifications were needed for 2 eCommerce portals.

Reviewed business requirements on Visio wireframes mock-ups and documents presented by UHC for B2B and B2C portals
Analyzed the eligibility systems of UHC to understand the process flow related to Use Cases
Interacted with Developers and Business Analysts to gather the required data and parameters needed for the integration of GeoAccess with these portals
Worked on Use Cases and documented touch points to GeoAccess
Used United Development Process UDP format to document specifications as a part of UHG compliance
Conducted walkthroughs for Technical Specifications for technical team and stakeholders
Wrote functional requirement document to address the business needs.
Environment : Lotus Notes 6.5, Office Suite, Visio 6.0, Cobol, XML, COSMOS, Adobe Photoshop, ASP. Net


May, 2003 -  May, 2004
Business Process Analyst

The University Union Sacramento , CA

Improved online reservation process by 55%. Analyzed data bookings vs. cancellations to recommend solutions for overall business development
Improved data retrieval, analyzed the system and recommended to move database on the local server. Resulted in 75% improvement in performance
Designed a Decision Support System DSS for administration department to address issues based on importance and priority


January, 1999 -  May, 2003
Technical Analyst

University Computing and Communications Services Sacramento , CA

Upgraded systems from Win 98 to Win 2000 and fresh installs of Win XP.
Streamlined the deployment and migration of operating systems using Symantec Ghost 7.5
Maintained Lab equipment using Symantec Ghost imaging utility and assisted in cable routing in labs.
Worked graveyard shifts to provide customer support in lab.
Generated custom reports of Computer Usage per student logon for school management ; used Crystal s 8 reporting tool to run queries on a SQL server database.
Analyzed computer usage data and suggested required Lab Assistants at any given time
Tested and deployed utility patch for MS WordPerfect conversion to Word and vice-versa


January, 1998 -  December, 1998
Manual Tester

GrowMore Consulting Services India




Education

California State University , Sacramento
Bachelor of Science in Business Administration , concentration in Operations Management



Skills


SME : HIPAA Methodologies : JAD, RUP Business Tools : Visio 6.0, Word, Project, Excel, Access, MS Power Point, MS SharePoint Testing Tools : Familiar with Test Director and Silk Test Tracking Tools : Team Track, Lotus Reporting Tools : Business Objects, Crystal Reports



Miscellaneous

Assisted Developers in Black Box testing. Involved in troubleshooting and preparing Defect Reports and work with Developers for debugging
Generated Defect Reports for analyzing risks with Developers and Business Analysts
Involved in updating and maintaining Test product documents High-Level Acceptance Test Plans
Reviewed and provided feedback on User Manuals/Guides
Recommended a broad range of solutions to optimize various systems