Project Manager
Resume:
Bhargavi Kopparapu
***********@*****.***
. Over 8 plus years of experience in IT industry as a Business Analyst
profile with specialization in business analysis, system analysis,
data analysis, design, and implementation phases.
. Extensive experience detailing business solutions using innovative
approaches for Health Care and Insurance applications.
. Solid understanding of software development life cycle (SDLC) and
testing methodologies.
. Experience on Client server based applications and Web based
applications.
. Experienced in creating technical documents such as Data Conversion
Specification, Data Mapping Documentation, and System Interface
Documentation for Legacy to Current Data Migration Projects.
. Skilled in eliciting user needs and translating them into functional
and non-functional requirements.
. Extensive experience in creating UML and ER Diagrams to help visualize
the design of the system.
. Actively engaged in Gap Analysis, Feasibility analysis, Data Analysis,
Risk Analysis, Business Process Improvement and System Integration.
. Strong experience in RUP Business Modeling process, complete UML
artifacts related to Business Modeling and Requirements, which are
created as models to support Requirements Elicitation, Analysis,
Specification, Traceability, Validation and Verification, and
Requirements Management.
. Expertise in creating, editing, saving and invoking Microsoft Excel
Macros.
. Strong experience writing complex SQL and testing scripts for Backend
testing for Oracle 8i/9i.
. Strong communication skills working with developers, project managers,
SMEs, stakeholders, application end-users and third party vendors.
. Extensive experience in Quality Assurance Life Cycle (QALC) aspects
such as Establishing Project Standards, Writing Test Strategies, Test
Plans, Test Cases, Defect Reports and Developing Test Scripts,
Traceability Matrices and Test Environments.
. Experience in assisting UAT/end to end testing and user training for
customers.
. Strong team player with solid problem solving skills using innovative
methods.
. Project Management Skills.
Tools & Technologies: -
. Methodologies: SEI-CMM, CMMI, ISO 9001, RUP, Six Sigma, SOX, SDLC,
QA Process Cycle, Product Life Cycle, GAP Analysis.
. CASE Tools: Rational Requisite Pro, UML 2.0, Rational Rose 4.0, DOORS
. Tracking Tools: Test Director, Mercury Quality centre, Clear Quest,
and Clear Case.
. Query tools: Teradata SQL assistant 7.2, 12.0.
. Automation Testing Tool: Quick Test Pro.
. Workflow Tools: MS-Visio2003, MS-Project2003, MS-Excel, MS-Word, Power
Point, All Fusion Erwin.
. Environments: VBScript, PL/SQL, VB 6.0, HTML, XML, JAVA, J2EE, GIS,
SQL, UNIX,
. Databases: Oracle 8i/9i, MS SQL Server, MS-Access 2.0, Teradata
WellPoint Inc,
June 2009-Present
Anthem Blue Cross Blue Shield and Empire Blue Cross Blue Shield
Brooklyn, NYC
WellPoint, Inc. is the largest health plan company in the Blue Cross and
Blue Shield Association. It was formed when WellPoint Health Networks,
Inc. merged into Anthem, Inc., with the surviving Anthem adopting the
name, WellPoint, Inc.
I have worked on the Enterprise Client Reporting for Dental Vision
project where Dental and Vision claims and Provider data was extracted
from various source systems like WDS, ADV, DeCare and Eye med which
includes ACES, NASCO and FACETS and was sent to Thompson Reuters for
reporting purposes. I have participated right from inception through
deployment of the project.
Presently working on the Edward integration of the Dental Vision Claims
data project. Extensively involved in Healthcare and Insurance
processing.
Responsibilities:
. Arranged group sessions and one on one session with users and
source system SMEs to gather requirements and to understand copy
book layout.
. The data was moved from Legacy mainframes systems to Teradata
environment.
. Documented BTRD, BSD for the Dental Vision efforts.
. Documented use cases for the requirements.
. Responsible for data mapping from landing zone to target by
analyzing various fields.
. Analyzed MD5 logic to develop the member key logic enabling member
key match.
. Responsible for writing transformation rule and pseudo code by
closely working with data architects.
. Analyzed RDM code sets for mapping the code sets and also procedure
codes and ADA and CPT codes.
. Documented Test Plan and Wrote Test Cases which include SQL queries
for the business requirements of the project.
. Thoroughly queried Teradata (our data warehouse) for all analysis
purposes.
. Performed System Integration Testing once the product was
developed.
. Coordinated with users in User Acceptance Testing by analyzing
issues and once the UAT issues were fixed, helped retesting them.
. Tested IR data and also Sanity tested production data.
. Supported during warranty by analyzing the warranty fixes and
retesting them.
. Presently analyzing DV data for mapping into Edward to enable
integration of the claims and provider data.
Environment: MS Visio, MS Project, MS Access, MS Excel, Teradata,
Teradata SQL assistant 7.0, 12.0, UML, JAVA, J2EE, SQL, UNIX, Windows
2000, Mercury Quality Centre, Quick Test Pro.
INDEPENDENCE BLUE CROSS
Sept 2008- April 2009
PHILADELPHIA
Sr. Business Analyst
For more than 60 years, Independence Blue Cross (IBC) has offered quality
health care products and services designed specifically to meet the
changing health care needs of customers. I am working as a Business
Analyst reporting directly to the Project Manger. Participated in the
Gap Analysis of the CHBM EDI Portal Project. Handled three individual
components like claims processing, reporting system. Performed As-Is BPA
and To- Be BPA and identified Gaps and documented the Gap Analysis using
the client specific template. Acted as a liaison between the users and
the technology groups.
Responsibilities:
. Analyzed the current business process as to how the Reporting Tool is
generation reports within the EDI Portal.
. Interviewed internal users to understand the As-Is Flow.
. Involved in Project Management activities like Project Scoping,
Planning, Estimating Scheduling, Organizing, Directing, Controlling
and Drafting remedy procedures in addition to ensure on-time
deployment.
. Researched on the reporting, registrations and permit system at the
IBX and made a descriptive analysis.
. Worked extensively on the All Fusion Process Modeler to depict the
process flow by analyzing various methods of business.
. Closely associated with the Information Technology office and liaised
between the users and the technology groups.
. Worked extensively on the Benefit Codes while working with other BCBS
teams.
. Responsible for collecting information from different user groups by
interviewing them at various levels.
. Worked extensively on the claims processing and reporting system.
. Analyzed the current business process and depicted the same in All
Fusion process modeler.
. Used MS Visio to model the process flow diagrams.
. Interacted with the database administrators and the developers while
researching on the project.
. Served as a liaison between Clients and Technical Staff to resolve any
conflicts.
. Prepared test plan, reviewed test cases and mentored QA team.
. Lead QA team in regression and UAT testing effort.
. Validated the Data Extraction, Data Loading and Transformations.
. Validated the data using SQL/PL/SQL/T-SQL.
. Organized and prioritized requirements to maintain focus on project
scope.
Environment : MS Visio, MS Project, MS Access, MS Excel, VB 6.0, All
Fusion Process modeler, Erwin Data modeler, SQL Server 2005, UML, OOD,
.NET, Oracle, Mercury Quality Centre, Quick Test Pro
Department of Environmental Protection
November 2007- Sept 2008
Commonwealth of Pennsylvania
Harrisburg, PA
Business Analyst
I have worked as a Business Analyst reporting directly to the Project
Manager on the state's Electronic Water Data Exchange Project. The project
is the business process analysis of the As Is and the To Be process of the
Electronic Water Data Exchange between the River Basin commissions and the
DEP. The project involves the analysis of how the exchange is happening
currently between the various external, intermediate and internal entities.
The external entities involved are: The Susquehanna River Basin commission,
The Delaware River Basin Commission, the Interstate commission for Potomac
River Basin and the Great Lakes Commission. The United States Geological
Survey is the intermediate entity. Department of Environmental Protection
is the internal entity. The data involved is the water withdrawal data of
the facilities from various river basins of the facilities. To Be design is
being developed by recommending new architecture, infrastructure and
software. Trained junior business analysts in the team on business process
analysis and various tools.
Responsibilities:
. Analyzed the current business process as to how the water withdrawal
data is being exchanged between the various River Basin Commissions
and the DEP.
. Interviewed the River Basin Commissions and the Water Use Planning
Division and analyzed how the actual exchange happens, the entities
involved, the process flows and the underlying business process.
. Researched on the reporting, registrations and permit system at the
DEP and made a descriptive analysis.
. Worked extensively on the All Fusion Process Modeler to depict the
process flow by analyzing various methods of exchange between the
River Basin Commissions and the DEP.
. Closely associated with the Information Technology office and liaised
between the users and the technology groups.
. Responsible for collecting information from different user groups by
interviewing them at various levels.
. Analyzed the current business process and depicted the same in All
Fusion process modeler.
. Responsible for facilitating meetings between various River Basin
Commissions and the Water Use Planning Division.
. Used MS Visio to model the process flow diagrams.
. Interacted with the database administrators and the developers while
researching on the project.
. Served as a liaison between Clients and Technical Staff to resolve any
conflicts.
. Organized and prioritized requirements to maintain focus on project
scope.
. Involved in Project Management activities like Project Scoping,
Planning, Estimating Scheduling, Organizing, Directing, Controlling
and Drafting remedy procedures in addition to ensure on-time
deployment.
Environment : MS Visio, MS Project, MS Access, MS Excel, GIS, VB 6.0,
All Fusion Process modeler, Erwin Data modeler, UML, OOD, .Net, Mercury
Quality Centre, Quick Test Pro.
TRAVELCHANNEL, DISCOVERY, MD
April 2007- October 2007
Business Analyst
As a Business Analyst, I have worked on the portals development project for
the Travel channel at the Discovery head quarters. The portals are talent
management, producer's production guide, press code, program sales,
viewers' relations, and an all together new travel channel intranet portal.
The channel with the portals has been cloned with Cox Communications and
the portals are being developed as per the new client's requirements. I
have been designated to play a major role in the SDLC process.
Responsibilities: -
. Responsible for identifying scope, business and data requirements and
artifacts of the project.
. Interacted with cross-functional teams to facilitate gathering of
business requirements.
. Responsible for organizing meetings between various functional
departments and our team in order to understand what data they are
using, what dimensions are they grouping by, how often the reports are
generated etc.
. Analyzed Business Requirements and segregated them into high and low
level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness
Diagram using MS Visio.
. Assisted the business resource manager and the project manager
throughout the inception and elaboration phases.
. Determined the authenticity and viability of Artesia and Vignette for
the platform and content management system where Interwovens Teamsite
was being replaced by discussing with the developers after conducting
thorough sessions.
. Conducted user interviews, JAD session.
. Conducted the FRS, URS and LDM reviews and walkthroughs with
designers, developers and stakeholders. Also conducted feasibility and
adaptability study.
. Involved in Data analysis and Data mapping of existing reports to
identify and document iteration and business metrics.
. Responsible for understanding the functionality of the present
reporting server and then assisted in the modification and design of
reports to answers End Users unusual questions.
. Figure out to make queries yield comparable data and then took part in
the designing of queries for different DB in the Enterprise Data
warehousing.
. Served as a liaison between Clients and Technical Staff to resolve any
conflicts.
. Actively participated in the design and creation of quick databases to
store/manipulate subsets of data in conjunction with client reports.
. Developed Process flow diagrams to document the existing system.
. Organized, categorized and prioritized requirements to maintain focus
on project scope. Used customizable attributes such as priority,
status and difficulty for each requirement in order to organize and
prioritize.
. Sometimes responsible for project management.
Environment: - .NET, MS Visio, MS Project, MS Access, VB 6.0, Rational
Requisite Pro, UML, OOD, MS Excel, Hyperion, Mercury Quality Centre,
Quick Test Pro, Storyboards, Wire frames.
BROADER HEALTH CARE LLC, NY
March 2005 - March 2007
Business Analyst
The project facilitated Health Spring with a healthcare management system
to manage their provider network of physicians and hospitals. The system
streamlined patient registration, patient scheduling, and medical insurance
checking, claims processing, and reporting. It eliminated redundant, manual
data entry and provided up-to-date control of patient accounts and
physician practice. The system also provided reporting services to generate
internal business reports.
Responsibilities: -
. Analyzed Business Requirements Document and System Requirement
Specification to develop new QA procedures as per RUP (Rational
Unified Process) methodology and documented the requirements in the
Rational Requisite Pro.
. Implemented Configuration management strategies and reported
enhancements to ensure quality performance of the Rational Enterprise
Suite.
. Performed Requirements Traceability and managed changes to
requirements for this application using Rational Requisite Pro.
. Provided support for the implementation and maintenance of the Version
Control tool, Rational Clear Case; and Change management tool,
Rational Clear Quest.
. Held regular meetings with the system architects, developers, database
developers, quality testers during the entire project to assure that
the critical as well as the minute details of the project were
discussed and issues were resolved beforehand.
. Create Test Plans, Test Cases and Test Sets accordingly associated
with each requirement using Rational Test Manager and associated Test
Inputs and Iterations.
. Defined, communicated, institutionalized and continuously updated the
Software Configuration Management (SCM) plans.
. Assist system administrators in the setup, configuration and
maintenance of Requisite, Rose, Clear Quest and Test Suites.
. Responsible for Scheduling and Distributing the Testing effort among
different Test team members.
. Evaluate and approve the software changes for enhancements by
generating Modification Requests.
Environment: - MS Office Suite, MS Visio, Test Tracker 7.5.2, Oracle 7.0,
UNIX.
INTERACTIVE HEALTHCARE, NY
January 2004 - February 2005
Junior Business Analyst
My project involved the design and development of the prototype of the
Electronic Health Record System (EHRS) that would integrate the medical
records of the 4 centers as a first step. The purpose of this project was
to expand internal capabilities and efficiencies across centers in order to
sustain health centers in increasingly competitive and financially
constrained health service markets.
Responsibilities:
. Co-developed Master Business Plan and defined different types of
functional breakdown to conduct during
System Design & Development.
. Interviewed key users including providers, practitioners, clinical
nutrition specialists, triage personnel, and decision-makers, design team
and business analysts, for requirements gathering and analysis.
. Designed the initial functional specification and used Erwin to develop
the database prototype of the proposed system.
. Developed comprehensive EHRS business & infrastructure requirements, and
innovative conceptual & solution architecture, now approved by the US
Bureau of Primary Healthcare Attended HIPAA and HL 7 training so as to
ensure design conforms to guidance policies in healthcare.
. Developed a detailed financial plan template with multiple interlocking
analyses for the development and implementation of the EHRS. Played key
role in developing initial projections.
Environment: - MS Office, MS Visio, MS Project, Oracle.
SUN PHARMA, INDIA
April 2001 - December 2003
Associate Business Analyst
SunPharma developed an application that dealt with the management of
disability claims. This was a specialized application with the policy
management application.
Responsibilities: -
. Conducted interviews with business users to collect the business
requirements, standards, and security and service level requirements
and studied the business process.
. Involved in Project Management activities like Project Scoping,
Planning, Estimating Scheduling, Organizing, Directing, Controlling
and Drafting remedy procedures in addition to ensure on-time
deployment.
. Authored progress and completion reports, which were then submitted to
project management on a weekly basis
. Worked closely with management to keep track of the status of project
and draft strategies for the near future.
. Used MS Project Plan to manage schedules, deadlines, and resources for
the project
. Prepared test data for positive and negative test scenarios as per
application specifications.
Environment: - Windows 98, MS Office Suite.
Education: - Bachelor's in Computer Science
Contact this candidate