SUMMARY:

• Over 8+ years of extensive experience in Business Analysis, Software Validation and business process re - engineering, with proven ability to articulate business values.
• Strong skills on Insurance Life/Annuity Business
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Designed software and solutions that empower an insurance company’s customers, agents, processing staff and management team to solve their current business challenges and support future growth.
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, gap analysis, risk analysis, effort estimation etc.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
• Strong Business Analysis Skills including In depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing and Practical knowledge of Rational Unified Process (RUP).
• Designed and implemented DataIntegration modules for Extract/Transform/Load (ETL) functions.
• Relevant Life & Annuities domain experience with an emphasis on policy back office and administration systems
• Extensive Knowledge of Systems Management, Design and Data Modeling.
• Hard-core experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
• Drive innovation to enhance the current software solutions available to our insurance customers
• Proven expertise in creating test plans, UML diagrams, flowcharts, screen mockups and systems requirements specifications.
• Excellent business writing skills in writing Preliminary Investigation Report, System Requirements document, Systems Design Specification and System Requirement Change Request.
• Demonstrated high capacity to learn new technologies rapidly with no formal training.
• Proficient at creating and transforming business requirements into software requirement specification (SRS) using Rational Requisite Pro and designing business models using UML diagrams such as use case model, Class Diagrams, Activity Diagrams, Sequence Diagrams and Collaboration Diagrams in Rational Rose and MS Visio.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.

TECHNICAL SKILLS:

Project Management Methodologies: SDLC, Rational RUP, Agile

Tracking Tools: Clear Quest, Clear Case, Visual Source Safe,, Rose, Quality Center, BMC Remedy, Blueprint.

Workflow Tools: MS Visio, MS Project, MS Office, MS SharePoint

Data Warehouse / Data Quality: Data Stage, Orchestrate, Data Flux, SAS, ETL, Teradata Data warehouse, Erwin.

Databases: SQL Server, Sybase, MS Access, MySQL, Oracle 11g, DB2 (8.1)

Programming Languages: Java, .NET, SQL, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Harleysville, PA

Sr. Business Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Designed and developed project document templates based on SDLC methodology.
• Designed and implemented Data Integration modules for Extract/Transform/Load (ETL) functions.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Participated in various stages of data and requirement analysis for project needs.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Developed business requirement specification documents as well as high-level project plan.
• Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Used Data Analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW).
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
• Conducted interviews with end-users to collect requirement and business process information.
• Developed business process models in RUP to document existing and future business processes.
• Performed extensive Requirement Analysis including data analysis and gap analysis.
• Designed and developed project document templates based on SDLC methodology.
• Participated in various stages of data and requirement analysis for project needs.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training classes.
• Developed business requirement specification documents as well as high-level project plan.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.

Business Analyst

Responsibilities:

• Managed the output requirement project for various Life insurance products.
• Accurately calculating and providing annuity prices using our in house pricing model
• Responding to complex illustration requests from the sales team
• Identifying, documenting, and communicating recommendations to improve efficiency or accuracy of our work
• Providing technical assistance and information to partner teams
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test
• Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
• Coordinated participation and sign-off of various business partners and customers.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Analyzed, documented, and managed all project requirements and changes to requirements throughout the software development lifecycle using Mercury Quality Center.
• Interfaced between Business new product builders and System platform builders.
• Worked with systems area to translate business needs into system requirements.

Business Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Develop test plans in conjunction with team leads and business personnel and perform unit, integration, regression testing.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational Clear Quest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Business Analyst

Responsibilities:

• Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Assisted with Test Cases and development strategies with Quality Assurance Group (QA) to implement them.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational Clear Quest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.