SUMMARY:

• 8 years of consistent experience in the following areas: Ability to Elicit, Analyze, gather and document Business Requirements, experienced in writing Use Cases. Proficiency in SDLC life cycle, understands the workflow concept, ability to gather and document the 'As - Is' and 'To-Be' processes
• Strong knowledge in Insurance Industry like Underwriting, Worker’s Compensation, Billing and claims in Life Insurance, Annuity, Life Insurance, Property and Casualty, Auto and Personal Insurance and Financial Service Industry.
• Experienced in gathering and documenting test Scenarios and ability to train users to translate technical requirements and translate them to a business audience
• Analyzed and documented the limitations of the billing and Claims system.
• Using project management tools like MS-Project for status reporting and planning.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments
• Gathered requirements in compliance with Sarbanes-Oxley Act (SOX).
• Maintenance of Test Matrix and Traceability Matrix, source to data mapping documents, also worked extensively with ETL process for data migration to new EDW.
• Strived to understand not just the technical needs of the client but also gained an understanding of the businesses
• Writing Use cases and producing Use Case Model, Analysis model, Behavior diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology & Business process flow diagrams using Visio Using Rational Unified Process (RUP), Rational Rose, Requisite Pro, Software Development Life Cycle (SDLC) processes and methodologies
• Requirement gathering through interviews, workshops, JAD sessions with clients, developers and QA Analysts and referring to existing system documentation and procedures
• Writing & documenting Business Plan, Requirements Document, Functional Specification Document, and Test Case
• Defining Test Cases, analyzing bugs, interaction with team members in fixing errors and User Acceptance Testing (UAT)
• Highly motivated, organized and results and detail oriented with excellent interpersonal, communication and presentation skills. Proven capability of adapting to new and fast changing technologies.

TECHNICAL SKILLS:

TOOLS: Project Methodologies: Rational Unified Process (RUP), UML

Business Modeling Tools: Rational Rose, MS Visio

Requirement Management Tools: Rational RequisitePro

Defect Tracking Tools: Rational Clear Quest, Quality Center, Trac, HP Service Manager

Operating Systems: Windows NT/XP/2000, UNIX

RDBMS: Oracle, SQL Server, IBM DB2

Quality Assurance: Software Application Testing Life Cycle

Business Applications: Microsoft Office Suite

Design Tool & Languages: Microsoft Visio, SQL, COBOL, and JAVA

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, Iowa

Sr. Technical Business Analyst

Responsibilities:

• Responsible for Gathering Requirements from business users through interviewing groups, one-to-one sessions and Joint Application Development (JAD) session.
• Participated in Primary and Secondary Research in the Identification of User’s Specifications needs.
• Documented Business Requirement Document and transformed into Technical Requirement document which was used to implement the solution.
• Produced System Diagrams, Business Requirements, Report Specifications, Workflows and other documentation as required for Project Analysis, Planning and Design.
• Performed the GAP Analysis and Impact Analysis for all business requirements having an impact on the existing application.
• Ensured that relevant UML diagrams and Tools (Requisite Pro) were used in all requirement documents e.g. User Requirements, Functional Specifications.
• Transferred of data from source systems to IAS (Insurance Annuity schema) was tested.
• All the Annual Statements, Renewal Letters, Policy Pages and all letters in PDF were tested manually with the templates provided by the Business
• Performed Data Driven Testing on Personal and Commercial Line Insurance Quote page by inserting different value manually in data table.
• Prepared Flow Diagrams, Sequential Diagrams in MS Visio.
• Involved in working with the developers and the environment support teams to resolve issues.
• Conducted the final user-acceptance testing (UAT) and usability testing.
• Met with client groups to determine user requirements and goals. Utilized Agile to configure and develop process, standards, and procedures
• Assisted the development team during the second and third iteration using the Agile model.
• Managed critical paths and bottlenecks in conjunction with Project Tracking Reports for Senior Management with the help of UML.
• Extensively involved in mapping data from various sources and formats (flat files, XML files and web services) to the target database.
• Created data model that visually represents the nature of data, business rules governing the data, and how it will be organized in the database.
• Extensively used HP Quality center for defect tracking management of test cases.
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting.
• Worked with ETL (Informatica) developers for creating real-time data interfaces and DB extracts (ETL Design).
• Planned the UAT testing, test plans, test cases and worked with the business users for UAT test execution in developing the training documentation.
• Responsible for planning the SIT (System Integration Testing), Defect tracking & closure.
• Participated in developing and executing Test Plans, performing functional, usability testing and ensuring that the software meets the system Requirement.
• Raised, tracked and analyzed defects in HP Quality Center.
• Maintained Requirement Traceability Matrix (RTM) and managed requirements.
• Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue.
• Involved in data dictionary management, extraction, transformation and loading (ETL) of data from various sources. Participated in ETL requirements process during data transition from source systems to target systems.
• Assisted the team members to develop Service Oriented Architecture (SOA), and data warehouse system (EDW) to utilize data mining for data analysis.
• Continuously worked with database while gathering the business requirements for the inbound data feeds and outbound data feeds for the finance department
• Worked with Data Warehouse for data mining, making consolidated reports and finding relationships & correlations
• Documented business processes, operational processes and fulfilled test case and testing plans
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data. Used Data mapping for collecting the data.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
• Articulated UML through Use Cases, use case document by specifying actors, normal flow, sub flow, alternative flows.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Involved in Database Driven Testing executed SQL Queries.
• Performed SQL queries for retrieving, organizing the database with general commands like select, create, update, and joins.
• Conducted Data analysis using SQL on the backend databases for producing mapping documentation and transformation rules for developers

Great west Life & Annuity Insurance, Denver, Colorado

Business System Analyst

Responsibilities:

• Conducted interviews, document analysis, design workshops, surveys, use cases, and workflow analysis for gathering requirements. Also, analyzed Software Requirement Specification and designed documents.
• Addressed all aspects of the claim processing lifecycle, starting from identifying a claim right up to closure.
• Interacted with product specialists for each line of business to gather requirements to be defined for the new system.
• Designed a new replacement requirements template which could be used across all lines of businesses to maintain consistency.
• Performed GAP Analysis of the older legacy system and the required screens for Commercial Lines Replacement System and created a document that identifies the screen changes with description and values of each field of every screen.
• Facilitated Focus Group Meetings and (JAD) Sessions to adequately access business needs.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Workers Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Interacted with Product Specialists and Product Analysts to identify the changes in the existing system and additional features required in new system.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Prepared Insurance Services Office (ISO) manuals for each commercial lines of business.
• Created documentation related to business processes, functional requirements and workflows creating technical diagrams, artifacts, mockups, etc., to accompany business requirements documents.
• Created and maintained Business Requirements document and System Requirements document. In addition, was responsible for getting appropriate sign-offs and approvals.
• Experienced in gathering detailed requirements for new products, products enhancements, rate level and regulatory changes for different lines of business including auto, home, commercial property and commercial auto.
• Initiated business re-engineering process to implement long-term business objectives regarding product, price and automated decision in the existing application.
• Made use case to generate functional requirements.
• Extensively used Rational Rose for process flow diagram (data flow), sequence diagram and collaboration diagram.
• Performed Requirements Analysis and Design using Rational Rose, analyzed and documented the System specifications, Business requirements and detail design of the business using Requisite Pro for the requirement tracking and analyzing.
• Created progress and completion reports for 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 to manage schedules, deadlines, resources for the project.
• Recommended a reporting solution in the Oracle Data Warehouse that would minimize the impact on the system from evolving business needs.
• Conducted and participated in walkthroughs to generate consensus, maintaining quality and resolve issues among different stakeholders in the SDLC.
• Setting up Enterprise Data Warehouse (EDW) and associated ETL service to generate business reports.
• Involved in writing Data Mapping Documents for the system and involved in documenting the ETL process and writing SQL Queries for the retrieval of the data.
• Performed Data Analysis, Data profiling and Data validation by writing SQL queries using TOAD.
• Reported and tracked defects using Quality Center.
• Work with business users, systems analysts, and developers to create and analyze test scripts, plans, scenarios, and cases for execution.
• Designed and executed Test Plans and Test Cases and generated Test Scripts and Test scenarios.
• Handle the tasks of explaining UAT scope, criteria and entry/exit strategy to less train professional.
• UAT process by reviewing test requirements, assessing business impacts of systems development, coordinating testing teams and developing and reviewing test scripts to ensure users conduct thorough and careful testing.
• Provided inputs to the project plan so that project plan exactly reflects the status of the project.
• Performed Data analysis from the data warehouse along with business intelligence solutions delivery team.
• Worked extensively on Business Requirements, Functional Specification, Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards.
• Very strong in Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying.
• Prepared the requirements traceability matrix to ensure that all the business requirements are traced to system requirements and all system requirements are traced to one or more test cases.

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Analyzed System and Functional Specification documents.
• Created a Test Strategy to be implemented across the web integrated system.
• Implemented Agile for managing requirements.
• Involved in UML diagrams and design of Use Case Diagram, Class Diagram, Sequence Diagram, and State Diagram for project documentation using Select Enterprise.
• Tested security privileges of the application for individual users as well as group access. Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing efforts on their applications.
• Using SQL and TOAD analyzed the Business by performing data analysis and also monitored the databases during production support.
• Collaborated with developers as needed to determine the root cause of defects, report software bugs and re-tested the fixed issues.
• Interacted with developers to get involved in meetings and walkthroughs and was responsible for weekly status reports.
• Understanding of the as-IS Systems (Current Environment) and the development of the To-Be Systems (Target Environment).
• Created Data Mapping to document to migrate data from the existing system to the new system
• Assisted team with Data Mapping and Data Extracting Strategies for data migration.
• Performed Data Analysis to make sure its correctness and completeness in test environment.
• Hands on experience with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling and database/data warehouse experience.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Wrote SQL queries to validate that actual test results match with expected results
• Developed timelines for project delivery, and managed enterprise projects and resources to successful completion.
• Worked closely with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Coordinated User Acceptance Testing with the UAT group to ensure the correct business logic.
• Developing the test strategy based on the provided Test Planning and Test specification Documents.
• Analyzed and Executed Test Cases and Test Plans based on software requirement specifications and Functional specifications.
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Quality Center.
• Created test plan, test data and conducted manual testing to validate functionality and performed regression testing
• Performed Systems testing, GUI/Usability Testing, UAT (User Acceptance Testing).
• Worked with user to define user acceptance test cases. Involved in UAT testing (User Acceptance Testing) and Implementation.

Confidential, Minneapolis, MN

Business System Analyst

Responsibilities:

• Conducted mass user interviews with application user representatives and SMEs.
• Created business requirement documents (BRD) and integrated the high-level user requirements for the underlying platform functionality.
• Conducted walkthrough of BRD in the JAD Sessions with users and developers. Collected specific information to include in the Functional Requirements Document (FRD).
• Facilitated meetings among the Change Management, Problem Management and other relevant teams to discuss the impact of the changes, problem tickets and prepare project milestone plans.
• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage
• Data analysis/mapping/modeling reference data repository project to improve quality of credit risk exposure information across business units for a leading fixed income financial guarantor. Key drivers for the project were parallel operation in traditional Muni guarantor, CDO guarantor, and asset management business units. Focus was on designing the RDB, use cases requirements, activity, and class/data models. Follow up included ETL rules modeling, workflow analysis, and SQL queries.
• Designed and developed all Use Cases and UML models using Rational. Developed Sequence Diagrams, OOD using UML.
• Designed and implemented basic SQL queries for QA testing and report / data validation.
• Conducted User Acceptance Testing (UAT) to ensure all the business requirements have been fulfilled by the application.
• Coordinated QA team for Unit testing, System Testing for Pilot and New release implementation and support.
• Exposure to Performance and Quality of Service in the process flow.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions, which included developing detailed documentation for training and testing.
• Created Business Flow Diagrams, Dataflow diagrams, Activity diagrams using MS Visio.
• Defined ETL SQL Server data cleansing rules to support feed consolidation and process modeling for integration with key firm application platforms.
• Created and maintained procedures and documentation.
• Developed and managed the Business Intelligence Blueprint and BI roadmap for the Business Intelligence team and worked closely with business, development, architecture, and support teams to ensure timely design and delivery of Business Intelligence solutions.
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
• Managed scope and deadlines and managed the project using the MS project extensively.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Collaborated with developers as needed to determine the root cause of defects, report software bugs and re-tested the fixed issues.
• Checked validation of the application against the requirements, was involved in writing several test cases for UAT and Unit Testing.
• Interacted with developers to get involved in meetings and walkthroughs and was responsible for weekly status reports.
• Conducted and Participated in Business requirement gathering and walk thru.
• Performed Data verification and validation against the user requirements.
• Performed Gap Analysis of business requirements and reported the GAP to the management.
• Assisted other team member extract data from the data ware house and any data related issues.
• Assisted UAT testing for Projects and Enhancements including legacy testing and HIPAA requirements and compliance mandates.
• Managed scope and deadlines and managed the project using the MS project extensively.
• Assured entry/exit criteria are met for the different phases of testing (e.g., Unit testing defects closed before hand off to System/Integration testing, high severity S/I anomalies are closed before start of UAT, successful UAT prior to production deployment).
• Monitors the production environment and responds to event alerts from the production monitoring tools.
• Responsible for creation of Root Cause Analysis (RCA) for production events.
• Manages tickets and move cases into a higher level of solution agreement.
• Responsible for tracking of trouble tickets and resolution of escalated incidents.
• Answer technical support queries and implements fixes for application problems.
• Used ETL methodology for supporting data extraction, transformation and loading process.
• Worked with solutions/delivery teams to implement data quality processes during acquisition, ETL, and delivery stages for Business Intelligence solutions and changes to Data Warehouses.
• Documented the dimensional models of ETL system.
• Involved in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams to depict the business process workflows.
• Developed comprehensive system test scenarios and test scripts. Responsible for performing back-end analysis and testing using SQL queries.
• Used Defect Tracking System in Quality Center to report, update and analyze the defect.
• Facilitated the User Acceptance Testing (UAT) and documented any issues or defects and eventually got sign off from the relevant parties.

Confidential, CT

Business Analyst

Responsibilities:

• Designed IT solutions for specifications and requirements surrounding data extracts from administrative systems across the enterprise while validating data consistency and accuracy.
• Interpreted and implemented IT solutions that meet the needs of the customer based on application and operational requirements.
• Created functional specification documents and data mapping to capture the functionality and data movement from source to target environment.
• Utilized Agile methodology in the implementation of the system analyzed and designed business process flow diagrams using Visio.
• Interacted closely with business liaison, subject matter experts (SME), and stakeholder for the requirements gathering.
• Analyzed, collected and prepared user requirements, definition, scope and expectations for deliverable plans for system modifications and enhancements.
• Worked with business users to gather requirements.
• Worked as a liaison between the Business and Technology Department.
• Performed GAP analysis and documented dependencies and risk and provide mitigation strategies.
• Identified and communicated project risks and gaps and worked with other teams members to mitigate risk.
• Documented project change request and align the requirement document and the scope of the project upon its approval. Also created Glossary and data dictionary to maintain the data integrity of different life insurance admin systems.
• Wrote data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents.
• Developed and executed QA test plans and performed a functional and a regression testing as per the requirement.
• Wrote SQL queries to pull data from different tables and views in order to perform the data validation for testing.
• Logged defects on Quality Center and worked closely with developers and test lead to resolve the issue.
• Collaborated with both IT and Business project team members to test IT construction and to record, track and resolve any identified defects.
• Participated in UAT triage meetings and worked with the team to resolve the defects.
• Worked closely with Project manager, Test lead, Developers, and stakeholders and provided lesson learned for future releases.
• Experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts while ensuring data quality and integrity.
• Analyzed the Business Process to capture the dynamic aspect of the application by identifying the Actors and prepare use cases.
• Utilized MS Visio to design User Interface mockups (screen) and process flow diagram.
• Involved with the requirement validation for Enterprise Data Warehouse (EDW) with the state stakeholders.
• Extracted data from Teradata and Oracle and created pivot tables in Excel.