Project Manager Management

VANDANA RANA

***********@*****.*** * (***) *** - 7573

[pic]

EXPERIENCE SUMMARY

. Carrying strong business, technical and leadership skills with 7+ years

of experience in Business Analysis, Data-ware housing, Software Quality

Assurance on both IT and Business side.

. In-depth knowledge and experience of Data warehousing, ETL Tools, RDBMS,

SDLC and various methodologies such as Agile, Waterfall.

. Excellent client relationship management, problem solving and analytical

skills.

TECHNICAL SKILLS

TOOLS Microsoft Visio, Microsoft Project, Visual Source Safe

LANGUAGES PL-SQL/SQL plus, MS SQL, Visual Basic, HTML

ETL TOOLS Ascential 7.5/7.1

PEOPLESOFT TOOLS DataMover 8.x, Application Designer 8.x, Change Assistant

8.x

DATABASES Oracle 9i/8.0/8.i/7.x, MSAccess, IBM DB2, OS390, MSSQL,

Informix

DB TOOLS Query Analyzer, Rapid SQL, TOAD, Dun & Bradstreet

TESTING TOOLS Mercury Interactive Test Director SP2

PROFESSIONAL EXPERIENCE

Blue Shield of California, San Francisco Feb. 2009 - Present

Business Information Analyst (Business Intelligence Group)

Responsibilities:

. User Acceptance Testing (UAT) Lead for Rosetta Data Integration (Facets)

and Enterprise Data Warehouse (EDW) project.

. Performing requirement analysis for SAS, Business Objects and Crystal

Reports. Work with Users to modify their programs and reports. The entire

Blue Shield Business units will use the end product.

. Define, organize, clarify and perform analysis on business requirements,

business rules and workflow processes while working with multiple

internal teams/units.

. Document and analyze current business processes to identify gaps and

inefficiencies. Work with cross functional teams to formulate future

business processes.

. Perform data analysis, data mapping and organization of data structures

as well as general system Integration analysis.

. Create process and work flow diagrams, activity diagrams and general UML

modeling.

. Liaison between business management, technology and engineering teams to

achieve project objectives and provide SME services.

. Heavily involved in training and presentations to inform the user of the

technical changes that will impact their business continuity

. Create QA test plans and scenarios for QA and UAT testing of internal

applications.

. Worked with IT on creating test beds and ensuring environment is ready

for execution

. Review QA and UAT execution and perform gap analysis on results.

. Partnerships with cross-functional teams to prepare for UAT execution.

. Defining business requirements that are clear and actionable to the

engineering teams

. Prioritizing requirements in partnership with cross functional teams,

balancing business criticality with financial and technology constraints

. Work with Business users and developers to modify SAS programs and

Business Object Reports

. Gather requirements from end-users and work with Data Modelers to ensure

the requirements are met

. Work with IT to Work with end-users to understand issues and to mitigate

change management issues during UAT.

. Deliver information solutions that meet business needs for decision

making

. Standardize processes for capturing business needs for analytic data

. Maintain continuity of data in analytic marts. Integrate new source

systems into analytic marts

. Support the implementation of access tools and reporting platform that

promote ease of information use

. Provide training that helps end users and promotes best practices.

Promote security compliance

. Implement processes to manage the quality of analytic data

. Consult with end users about how to most effectively support their

business needs

. Excellent verbal, written and interpersonal communication skills with

ability to present complex ideas in clear, concise fashion to technical

and non-technical groups

. Experience working in a Matrix Environment

Performant Financial Corporation, Livermore California Oct 2005 - Jan.

2009

Business Analyst Lead / Senior QA Engineer

Responsibilities:

. Worked with CMS (Centers for Medicare and Medicaid services) claims.

Identifying patient's insurance(s) eligibility and validity.

. Maintain Integrity and security for CMS and EMR data and ensure proper

documentation for audits

. Validate client's medical insurance eligibility and demographics with the

EMR data.

. Used medical insurance information in the EMR for testing Medical Claims

transactions, transaction codes and flow of data through the application.

. Participated in security and HIPPA training provided by the company.

. Conducted Risk Analysis from previous Business Requirements documents and

examined them using Gap Analysis from the previous release.

. Serving as BSA Lead, managing both co-located as well as off-shore teams,

responsible for developing & implementing Test Strategy and Plans, and

managing execution through the QA phases.

. Involved in gathering and documenting the requirements that were critical

to the business process and help programmers create new reports for all

states.

. Assist Project Leads in all phases of the Project to review project

deliverables for completeness, quality and compliance.

. Successfully led multiple projects through QA phases, delivering high-

quality products.

. Extensively interacted with end users/project manager and several

business area experts, asking detail questions and carefully recording

their issues in call logging software called HEAT that can be reviewed

and understood by both business people and technical team.

. Interfacing with cross-functional teams and clients as single point of

contact

. RUP, UML Diagrams used for documentation to be precise and clear.

. Instrumental in standardizing Test Plan and Test Case documentation

across QA team that resulted in measurable efficiencies in QA execution.

. Created Requirement Specification Documents after conducting Interviews

with End Users, Conducting JAD Sessions and analyzing their current

systems.

. Organized and facilitated meetings with the management and development

team to and conducted the requirements gathering sessions with the

purpose of creating and defining the business and functional requirement

documents.

. Testing Web-based Applications, experience in Manual and Automated

Testing techniques

. Co-ordination of 'Business Review" and "Walkthrough" meetings to discuss

the project status

. Effective reporting to IT and Business senior management on the progress

of project development activities and performed extensive gap analysis

with IT management at each project milestone.

PeopleSoft, Pleasanton, California Dec 2004 - Sept 2005

Data warehouse QA Engineer

Responsibilities:

. Responsible for implementation of PeopleSoft EPM 8.9 ETL Enterprise

Warehouse Product

. Responsible for executing Base line testing, System testing, Platform

testing using Ascential (ETL Testing tool) for EPM8.9 release and doing

regression testing (Bundle testing) for the product.

. Responsible for making sure that the maps designed using Ascential

between Source and the target are correct as data passes through

different layers and transformations.

. Validate design and load of the data from source to the target as part of

the Enterprise Process Management (EPM)

. Review Technical Design Documents and Functional Design Documents

. Create Test cases in the Test Director before actual testing

. Execute Ascential jobs for data migration using automated tools like

Mercury Interactive Test Director

. Use PeopleSoft Application Designer for schema browser/creating schema.

. Use PeopleSoft Data mover (data import and export)

. Using and configuring the Peoplesoft Change Assistant for applying

packages to the databases.

. Query Analyzer, Rapid SQL, ORACLE, SQL plus, IBM DB2 command center for

trouble shooting and executing SQL queries.

. Performing platform testing on Oracle, DB2 Unix, DB2 OS390, MS SQL Server

. Interact directly with the development team. Prepare daily/weekly status

reports

Nortel Networks, Ottawa, Canada Aug 1999 - Aug 2000

Database Programmer Intern

I was Involved in a major project of business marketing Tier 1, 2&3 cities.

Comparison of cities in USA based on the population of businesses.

EDUCATION

San Jose State University, California, USA Sept 2000 - May 2004

Bachelor of Science: Management Information Systems (MIS): GPA: 3.7, with

honors.

Algonquin College, Ottawa, Canada Sept 1994 - May 1997

Diploma: Bio Engineering Technology GPA: 4.0

CERTIFICATION / COURSES COMPLETED

PROJECT MANAGEMENT May 2008

UC Berkeley, California Grade: A

Contact this candidate