Business Analyst Resume
Rocky Hill, CT
PROFESSIONAL SUMMARY:
- 10+ years of experience as a Business Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
- Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
- Expert in commercial Confidential and Personal Lines Insurance experience with national carriers.
- Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
- Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
- In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
- Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
- Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
- Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Highly experienced in DMAIC
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
TECHNICAL SKILLS:
Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, MS Project, MS Visio, MS Office Suite, Bloomberg,VBA for Excel, SQL, PL/SQL, Java, J2EE, C#, VB.NET, C++/CLI, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX
Databases: Oracle 8i/9i, MS SQL Server, MS Access
Environments: Windows 9x/NT/2000/XP, UNIX (Sun Solaris, AIX, HP - UX), Linux, Mainframe
PROFESSIONAL EXPERIENCE:
Confidential, Rocky Hill, CT
Business Analyst
Responsibilities:- Adjudication of Short Term and Long Term Disability Claims.
- Developed test scripts for the HR functionality like New Hires, Terminations, Promotions, Demotions, Transfers, short term disability, Long Term Disability, etc.
- Identification and Investigation of insurance fraud.
- Initiated independent medical exams and rehabilitation programs.
- Work closely with Business Owners and Stakeholders to outline Business Requirements using rational requisite pro.
- Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
- Work with System analyst and IS teams to understand the flow of data.
- Reviewed and analyzed data from various sources.
- Identified gaps and performed gap analysis with respect to CMS requirements
- Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
- Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
- Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend the most efficient solution for system design.
- Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
- Work with Compliance and Regulatory operations to follow and monitor different IT process bound by CMS Regulations.
Environment: Windows XP, Business Objects, MS Excel, Word, Visio, power point, SQL, DB2, SAS database
Confidential, East Rutherford, NJ
Business Analyst
Responsibilities:- Established a RUP (Rational Unified Process) centric business analysis methodology.
- Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
- Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
- Provided key initiatives in working with users in defining project and system requirements.
- Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
- Responsible for preparing the business rules for Split loss process, Billing process and Booking table.
- Responsible for the development of a Data Warehouse for personal lines Confidential insurance.
- Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
- Helped with Data Mapping between the data mart and the Source Systems.
- Worked on Commercial lines Confidential Insurance including both policy and claim processing and reinsurance.
- Exposed to Agile methodology.
- Processed annuitant transaction to move their payout investment from one separate account to another
- Tested validity and integrity of the calculation engines for Deferred Annuities, Past Services Pension adjustments.
- Extensively used Test Director to review and update the status of entire testing process.
- Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
- Design and develop the data load process using XML Style sheets and ACORD.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Performed requirement analysis, went through all the use cases and issue logs.
- Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
- Worked extensively with MS Excel
- Provide customer service and support for Confidential risk management needs
Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner
Confidential, NJ
Business Analyst
Responsibilities:- Reviewed and analyzed the business environment and identified process improvements.
- Interacted with Business Users to conduct thorough Requirements Analysis.
- Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
- 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.
- Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
- Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
- Developed Test Plans and Test Cases according to Business Requirements.
- Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
- 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.
Environment: RUP, UML, UAT, Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner
Confidential, NJ
Business Analyst/ Data Analyst
Responsibilities:
- Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
- Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
- Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
- Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
- Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
- Involved in development phase meetings for business analysis and requirements gathering for the Common Claim Layout (CCL).
- Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
- Collected information and requirements about different Entities and attributes from FDS.
- Completed GAP analysis in detail on all entities in CCL for a source system.
- Prepared questionnaire based on the System Analysis Performed for all entities.
- Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
- Managed Scope and change throughout the SDLC process of the product.
- Assigned tasks among development team monitored and tracked progress of project following agile methodology.
- Managed changes requests; controlled, tracked and monitored changes request using Rational Clear Quest to enable successful interactive development
- Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
- Configured the Data mapping between Oracle and SQL Server 2005.
- Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
- Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
- Provided data modeling support for numerous strategic application development projects.
- Documented the meeting minutes with issues of about discussed and solutions resolved.
- Completed the documentation of Claims Scenario’s for the source system.
- Presented the mapping document with all business logic applied for the system to Project Manager.
- Gathered information and documented on Conceptual design and Technical design for phase III systems.
- Prepared Use cases and activity diagrams for a source system using Enterprise Architecture (EA) tool.
- Created the test cases for all the Use Cases using EA tool.
- Created test scripts for all the test cases in PL/SQL.
- Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, Autosys 4.1, WinCVS 1.3,Microstrategy, Enterprise Architect 4.5, Sybase, Visio, Toad 8.0, Erwin, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, DOS and UNIX Sequential Files, Mercury TestDirector Agile, Waterfall, MS Access, CSV Files, XML File,
Confidential, Bethlehem, PA
Business Analyst
Responsibilities:- Conducted detailed and comprehensive business analysis using Agile methodology by meeting with stakeholders and end users to get familiarized with the system and its operational requirements
- Participated in Requirements Elicitation Sessions such as Interviews, Questionnaires and Observation in order to identify functionality and features that would improve the AAR application.
- Elaborated Use Cases based on the information gathered from speaking with business users.
- Performed both Formal and Informal Benchmarking in order to elaborate GAP Analysis.
- Provided As-Is and To-Be flow diagrams for different phases of the project
- Created Business Process Flows by identifying Business Cases and Use Cases, created UML diagrams including Activity Diagrams and Sequence Diagrams using MS Visio.
- Co-authored detailed Business Requirements Document (BRD), Business Requirements Specifications (BRS), Functional Requirements Document (FRD), and System Requirements Specifications (SRS).
- Amended new system formats to meet Functional Requirements for Data Migration.
- Assisted in creating User Interface Layout Prototypes using SnagIt and screen mock-ups.
- Monitored defects using Silk Central, and collaborated with Developers and Testers throughout the Defect LifeCycle.
- Performed Post-Production Validation (PPV)
- Updated User Manuals and instructions for new features of the AAR application using MS Word, and Robo Help; and also provided customer support.
Environment: Rational Unified Process (RUP) methodology, UML, IE 8, JavaScript, MS Word, Visio, PowerPoint, Excel, and Project, Adobe Acrobat, SnagIt, Adobe Robo Help, Silk Central, Built-In Report Tool, SQL and Oracle database
Confidential, Monmouth Junction, NJ
Business Analyst
Responsibilities:- Involved in developing the business model for expediting the claim settlement process
- Defined frameworks for the application development and analyzed the areas of improvement
- status report, charting out schedules, allocation and management of technical and human resources using MS Excel and Project
- Conducted walkthrough with the development team and stake holders
- Analyzed the security implementation of the application with respect to users perspective
- Wrote Business Requirements, analyzed them and tested them.
- Prepared test data for the functional test cases. Evaluated test results and prepared test summary reports
- Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
- Interacted with developers & various members of my team to discuss and resolve defects and their priorities
- Investigating the bugs and interfacing with the developers to resolve technical issues
- Performed bug tracking
- Communicate with users and technical staff to bring projects and issues to resolution.
- Work closely with management to support various projects through the SDLC methodology and knowledge management including analysis, requirements gathering, development, testing, implementation and training.
Environment: Windows NT, Power Designer, Oracle, Java, HTML, JavaScript, MS Office, Mercury Suite of Testing Tool.