SUMMARY

• 16 years of working experience in various industries like financial, banking software, healthcare insurance and hi-tech.
• Ability t simultaneously handle multiple tasks and skills in the areas of: Financial Analysis, Business Analysis, Quality Assurance Analysis, Assessing Client Needs, Effective Presentations and Financial tools.
• Highly Proficient in different types of testing like Functional and Regression Testing, System Testing, Integration Testing, User Acceptance Testing Performance Testing,
• Extensive knowledge of Object Oriented Analysis and Design using UML, Rational Unified Process RUP and MS Visio.
• Data warehouse analyst, implementing data warehouse solutions and supporting data warehouse processes. Thorough understanding of extraction, Transformation and load ETL process and understanding of logic database design, modeling and data-mart processes, understanding of OLTP vs DSS systems.
• Lead analyst for the Financial Regulatory Authority's enterprise data warehouse responsible for gathering and analyzing enhancement requests from users, initiating change requests in Star Team, maintaining and expanding logical and physical data models in Erwin, and developing and documenting ETL specifications in DOORS
• Experience in carrying out Software Development Life Cycle SDLC life cycle in Relational and Object Methodologies.
• Well versed with SDLC methodologies like AGILE Scrum, RUP and Water fall
• Initiated Requirements Gathering, prepared the Software Requirement Specifications SRS document and used Rational RequisitePr t maintain the requirements.
• Proficient in developing Use Case Diagrams, Analysis Model, Design Model, Behavior Diagrams Sequence diagrams, Collaboration diagrams, Activity Diagrams , and Class Diagrams based on UML methodology using Rational Rose.
• Experience in design and development of test case scenarios, developing test plans. Excellent knowledge of Black Box Testing, User Acceptance Testing UAT , Unit, Integration, Functional, Load, Regression and Interoperability testing.
• Facilitated and participated in Joint Application Development JAD sessions, user workshops, interviews, conference calls and white board sessions t keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Experience with training and mentoring team members with product knowledge and business processes.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

• The Confidential Financing is a public consulting firm that takes a mission-driven approach t health care financing which is unique among health care consulting agencies. The Center is a public entity, focused solely on improving state and local health care. They are dedicated t helping state and local agencies maximize resources t better serve their clients.
• My project with Confidential of Massachusetts Medical School is about creating a new application t replace an existing application which is over 10 years and has become untrustworthy. I am currently working on three projects dealing with different set of users, subject matter experts and developers.
• Individual Education Plan File Upload - The project was related t the implementation of the IEP File upload for MA as and when the business wanted for existing and new students. Currently, schools typically send printouts of IEP system reports t the School Based Medicaid Operations SBM Ops , wh then enter the information manually int SBC. There were tw areas of focus for improving efficiencies in the process: Direct file transfer from IEP vendor systems t SBC Create an upload process for the MA school districts.
• Consolidated Billing Environment A new application is being developed in the place of existing application which is more than 10 years old and is not very trustworthy of the numbers it is providing and a lot of manual work is being done t reconcile numbers. The project includes analysis of the existing system and making improvements t the new system s that the same problems that are being faced now will not be repeated.
• Provider Compliance Unit The MMIS is a claims processing and information retrieval system. A vital part of each state's MMIS is the Surveillance and Utilization Review Subsystem SURS . SURS is a mandatory component of MMIS. The purpose of the PCU as the SURS unit is t safeguard against inappropriate payments for Medicaid services. This is done by analyzing and evaluating provider service utilization t identify patterns of fraudulent, abusive, unnecessary and/or inappropriate utilization. The project consists of collecting and creating specifications for the implementation of an application which currently exists in Access and t create standard Weekly, Monthly, Quarterly and Yearly reports for the upper management.

Responsibilities:

• Created and updated Business Requirement documents and Functional Requirement documents and included vision, scope and wire frames for web-based service application developed for streamlining office workflow processes involved in Electronic Data Interchange EDI transactions and benefits in claims management cycle based on HIPAA Guidelines..
• Effectively identified the end-user requirements.
• Acted as a liaison between the business units, QA and the technology team.
• Led JAD sessions and acted as the lead facilitator for various projects from start t finish through the SDLC.
• Validated Financial processing creation of 837 and reconciled it with the 999 and 835 from MassHealth.
• Validated technical designs created by IT developers against functional specifications.
• Worked with QA team t design test plan and test cases for User Acceptance Testing UAT .
• Coordinated work plans between project manager and client using MS Project.
• Created documentation for training.

Confidential

SR. BUSINESS ANALYST

• Confidential, a not-for-profit health maintenance organization HM , serves the health-care needs of members in 43 counties throughout central and northeastern Pennsylvania. Begun in 1985, the Health Plan has steadily evolved int one of the nation's largest rural HMOs by providing high quality, affordable health-care benefits.
• As a Business Analyst at Confidential, I performed pivotal role in multiple projects handling three releases at the same time. Release was web-based service application developed for streamlining office workflow processes involved in Electronic Data Interchange EDI transactions and benefits in claims management cycle based on HIPAA Guidelines. Release three was based on reporting the policy premium. There were seven reports, which were generated in Bri portal.

Responsibilities:

• Analyzed, developed and evaluated data mining in a data warehouse environment.
• Developed and evaluated data design, and repository creation.
• Used data extracting, BI and data analysis tools.
• Reviewed and validated data loaded int the data warehouse for accuracy.
• Interacted effectively with user community t produce analysis results and analytics requirements.
• Performed data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Performed and created database design, development, and maintenance.
• Analyzed, designed, and developed data modeling solutions.
• Effectively identified of end-user requirements.
• Mapped process flows assessed as-is processes through user interviews, data collection and analysis, design and evaluation of to-be process solutions.

Environment: Agile, MS Project, MS Access, Business Process, Crystal Reports, Rational Rose, MS Office, MS Visio

Confidential

SR. BUSINESS ANALYST

• Project Details: Worked with the Project Rewind which was established in anticipation of the possibility that the Federal Reserve Board or Congress might eliminate the exemption from Confidential capital requirements currently enjoyed by Taunus Corporation Taunus and/or create new requirements emanating from a designation of Taunus or its subsidiaries as systemically important.
• The Project rewind consisted of the following projects t overcome the potential of being subjected t heightened prudential standards including increased capital requirements including Basel rules , supervision, etc. and s the decision was made to:

1. De-bank Taunus

The PRSC, based on analysis performed t date, concluded, as Phase 1, t spin-off Deutsche Bank Trust Corporation DBTC and its subsidiaries from Taunus t DBAG. The distribution of the shares of DBTC from Taunus t DBAG will terminate Taunus' status as a bank holding company BHC . Taunus, n longer a BHC, will not need t implement the U.S. Basel II standards and, absent any other actions will not need t comply with the requirements of the Collins Amendment. Luna dependency - Implementation of New Tax Views.

2. Project Luna Dependencies

If the spin-off of DBTC and its subsidiaries were t occur before the completion of Project Luna, described more fully on the following pages, it would prevent the recombination, for Confidential tax purposes, of DBTC and its subsidiaries int the Taunus Group for a five-year period. Alongside the de-banking of Taunus requirement, the one tax payer view should be implemented in the Regional Consolidation System, which will ensure one taxpayer structure is in effect prior t de-banking.

Responsibilities:

• Created Master data Inf Sources for uploading attributes, texts, and hierarchies from SAP R-3 system.
• Performed query unit testing and worked with end-users t schedule and perform UAT for the queries.
• Created settings and process chains used in Information Broadcasting t send Consolidation reports and workbooks t multiple properties.
• Experienced with initial and delta loads from RCS systems, als scheduling and monitoring data loads.
• Participated in the requirements gathering of the client's business and documented the business processes.
• Created BEx Reports using Reporting variables like Characteristics, Text, Formulas, Hierarchies and nodes.
• Understood various process plans, functionality and business in detail t prepare integration test plan.
• Validations of the data from a business and IT perspective
• Ran reports out of the SAP BCS system t troubleshoot issues found during testing by the user.

Environment: SAP BCS, MS Office, MS Visio, eRooms, Metadata, Data Warehouse, RCS System , BEx, SQL

Confidential

SR. BUSINESS ANALYST / PROJECT MANAGER

PeopleCert is an employee and individual performance-improvement company with many years of experience in the technology-based, self-paced training arena. We provide personalized learning and certification that supports organizational success. Our on-site, online learning and online testing tools cover topics ranging from technology t finance t enterprise business skills.

Project Successfully Delivered:

• PeopleCert Company Portal
• PeopleCert Education Online Portal
• PeopleCertTesting Online Portal
• PeopleCert Member's Portal

Responsibilities:

• Interacted with business owners t identify business system needs, evaluated solutions or business problems and proposed alternate methods t increase efficiency.
• Analyzed and documented information system requirements and the corresponding impact on business processes using Business Process Models.
• Responsible for defining the scope using project backlogs and sprint backlogs and implementing business rules of the project, gathering business requirements and documenting user stories and personas.
• Responsible for writing Functional Requirement Specifications FRS and User Requirement Specification URS
• Provided people care for individual through career planning, training, compensation, and career advancement based on performance.

Environment: MS Office, MS Visio, AGILE Scrum

Confidential

SENIOR BA/ SR. QA ANALYST/ FINANCIAL ANALYST

For over 135 years, we have leveraged our life insurance and asset management expertise t help individual and institutional customers grow and protect wealth. Prudential Financial companies serve individual and institutional customers worldwide and include The Prudential Insurance Company of America, one of the largest life insurance companies in the Confidential These companies offer a variety of products and services, including life insurance, mutual funds, annuities, pension and retirement-related services and administration, asset management, banking and trust services, real estate brokerage franchises, and relocation services.

PRUDENTIAL FINANCIAL SENIOR BUSINESS ANALYST

Responsibilities:

• Business Analyst and Quality Analyst for multiple projects during the tenure
• Conducted JAD and facilitated brainstorming sessions with a diverse global group of SAP Users and Consultants t understand users' requirements
• Responsible for defining the scope using project backlogs and sprint backlogs and implementing business rules of the project, gathering business requirements and documenting user stories and personas.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams using UML and Visio
• Handled many design change and requirement changes in various versions and service packs of the product
• Represented end user t the development group for product prototype validation
• Created Product Quality Management Plan in MS project in parallel with the Product Development Plan created by Development Managers t fit int overall Project Plan
• Assisted in the coordination of the operational and functional planning processes for the Fixed Income Management group.
• Prepared reconciliation reports for the GAAP and STAT accounts.
• Analyzed plans and other financial information and trends for significant changes. Researched causes compiled explanations and reported t management.
• Completed various reports by retrieving data from the database by writing SQL statements t add, modify, copy and delete data.

Environment: AGILE Scrum, UML, MS Project, MS Visio, MS Office, SQL, Windows 2000/NT

Confidential

SENIOR QA ANALYST

Responsibilities:

• Participated in Feature Design review meetings and presented test case review, strategy and feature functionality and documented test cases and conducted manual testing.
• Translated the information t test cases and test procedures, based on use cases.
• Created Test Cases from Functional Requirement document and maintained traceability matrix
• Involved in planning, execution, coordination of entire testing QA life cycle
• Developed strategies for Test Planning, Test Case Designing, Test Scheduling, Test Estimation, Test Execution and Defect Tracking
• Created test scripts and performed interface, system, functionality, user acceptance testing and regression testing.
• Prepared the Cause and Effect spreadsheet based on the functionality of the application for easy analysis.
• Created various user-defined functions for script enhancements and t verify business logic.
• Utilized Issues Tracking Database for communication with the production personnel, developers and team members.
• Worked closely with software developers t isolate, track, and troubleshoot defects.
• Attended reviews and walkthroughs t better understand the requirement documents.

Confidential

BUSINESS SYSTEM ANALYST

Confidential offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, voluntary plans, group life and disability plans and medical management capabilities and health care management services for Medicaid plans. Our customers include employer groups, individuals, college students, part-time and hourly workers, health plans, governmental units, government-sponsored plans, labor groups and expatriates.

Responsibilities:

• Developed the prototype for Security Access Tracking System SATS
• Developed Templates t gather the requirements for applications t be added in SATS
• Facilitated the meetings with Business t gather the requirements
• Prepare the on boarding documentation, Coordinated the deployment of Applications in SATS
• Collected the queries from Access System On boarding AS and resolved the tickets making necessary changes
• Created business process workflow diagrams Activity diagrams in MS Visio.

Environment: SQL 2003, MS Visio, MS Office, Crystal Reports