SUMMARY:

• Analytical, Proactive and Self - directed Business Analyst with comprehensive 15+ years of experience in business technology solutions and client management in the arena of all types of Insurance, Financial and Pharmaceutical with expertise in business analysis both in Waterfall and Agile methodology, project management and hands-on Systems, Regression, Integration testing.
• Elicits requirements using interviews, document analysis, requirements workshops, competitive product analysis, business process descriptions, storyboards, creation of Wire-frames, surveys, task and workflow analysis.
• Profound cognition in requirements gathering from the Business users and Stakeholders to develop Business Requirement document, Use Case, User Stories as well as test plan, test case and traceability matrix.
• Effectively communicates to the business customers and the technical team after analyzing existing anomalies in the current systems/process and recommends solutions.
• Expert in Data Analysis / Data Validation / Data mapping / Data Dictionary / Data Integration / Metadata management / BI Reporting application tools.
• Proven ability in data profiling at various internal and external legacy systems and the proposed Enterprise Data Warehousing model for standardizing the data.
• Good experience in Data Modeling with expertise in creating Star Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Accumulates business requirements through interviews, prepares Business case and Business Requirement Document (BRD) with the interaction of User Interface (UI) and User Experience (UX). Facilitates JAD sessions with System Architect, SMEs, Business stakeholders, Developers and QA team members to generate comprehensive requirement documents.
• Translates business needs into Technical and functional requirements in a complete and correct manner to design properly.
• Supports Business Requirements activities by providing end-to-end analysis of the entire system and takes onus with respect of metadata management, data requirements, data flows, workflow context and user interface design.
• Organizes and facilitates Agile and Scrum meetings that includes Sprint Planning and Review, daily stand-ups with a team of business representatives, software developers, and testing team to create snapshots of project velocity.
• Creates and maintains Business Use cases and System Use cases, Use Case diagrams, Workflow Diagrams, Business Process Flow Diagrams, Activity diagrams, Sequence diagrams etc. through MS VISIO tools.
• Expert in preparing Test Strategy, Test Cases and its execution and the entire systems testing through various ETL tools, like, Informatica, DataStage, Ab-Initio etc. in addition to UAT (User Acceptance Test) and Production support.

TECHNICAL SKILLS:

Applications: MS Visio, Excel, Power Point, Project, Guidewire, SQL, TOAD, Rational Requisite Pro.

Databases: MS SQL Server, ORACLE 11g, DB2, SYBASE, MS Access

Data warehouse ETL Tools: Informatica, DataStage, Ab-Initio

Business Intelligence Tools: Business Objects, QlikView, Tableau, MicroStrategy, Cognos 9.5 and SalesForce.com

Languages Acquainted: PL/SQL, XML, Java, ASP.NET, .Net Framework, C/C++, HTML, K-Shell, AWK, Perl

Error Tracking Systems: JIRA, Mercury HP Quality Center, Team Track, Rational Quality Manager, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst / QA

Responsibilities:

• Responsible for creating Use Case, User Stories and professionally maintaining Sprint Backlog in an Agile environment.
• Collaboratively exercising with the development team to ensure data specifications are understood and followed, supporting Quality Assurance and User Acceptance Testing (UAT) during design and implementation of major enhancements.

Confidential

Business Data Analyst / QA

Responsibilities:

• Elicited business requirements from business users and subject matter experts, defined and documented requirements, wrote functional specifications, and performed business process design in conjunction with operations teams.
• Served as liaison between the internal/external business community and the IT organization in order to provide technical solutions to meet user needs.
• Identified and translated business needs into clearly defined requirements for the policy administration and claim systems.
• Developed functional documentation inclusive of user stories/ use cases, process flows, data flows and report mock-ups.
• Responsible in formulating Data Dictionary from the existing SQL Script through the process of reverse engineering, maintaining integration between external and internal legacy systems, including data mapping and meta data management.
• Designed extensive reports on Policy System by navigating financial data Claims System using combination of charts and tables and comparing the turnaround times in extracting the data from EDW.
• Developed complex SQL queries for querying data against different data bases for data verification process. Analyzed the data, understood the data, standardized the data and documented the lineage of data across the Enterprise.
• Responsible to fulfil the delivery of information, demanded by the business users for accurate and meaningful standardized data for reporting on time.
• Performed data mapping among various source systems, transformation of data to meet internal system requirements.
• Compiled detailed documentation for technical team (Architect, Developers, QA etc.) and facilitated project/enhancement governance and prioritization.
• Involved in defining source to target data mappings, matching from Custom to Standard field elements and data definitions.

Environment: MS SQL Server, Unix, SharePortal, Toad, XML, JIRA, MicroStrategy, SoapUI, Informatica, HP Quality Center.

Confidential

Lead Consultant - Business Analyst / Data Analyst / QA

Responsibilities:

• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• Conducted user interviews and JAD sessions with end users, Stakeholders and Developers to gather functional and non-functional requirements of the system, and creation of Use Cases and Users Stories through JIRA tools.
• Performed feasibility analysis and adept in using Gap Analysis techniques to gain a clear understanding of the AS IS of the System and additionally derived new scenarios to understand the potential TO BE system.
• Created Use Case, Test Case and data mapping documents for the movement of data from Guidewire Policy and Claim Administration as well as Billing system to the Operational Data Source (ODS) and from ODS to down the various streams.
• Full accountability to define, execute and manage system testing and UAT during implementation of major enhancements.

Confidential

Responsibilities:

• Built strong relationships within the business units and support functions to understand the business needs and planed, facilitated, and conducted requirements gathering sessions, meetings, and presentations.
• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Identified and establish scope and parameters of requirements analysis in order to define impact, outcome criteria and measure-taking actions through interface analysis, prototyping and JRP/JAD sessions with Focus group.
• Created the entre workflow in processing the New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, Commercial) and generated User Stories for Sprint backlog using JIRA Tools.
• Collaborate with development and testing teams to provide subject matter expertise, ensure that out of the box functionality is leveraged and to assist in troubleshooting and resolving issues.
• Interacted with developers and various members of the team to discuss and resolve defects and their priorities.
• Maintained Requirement Traceability Matrix (RTM) for all business requirements and created User Guides and Manuals.

Confidential, New York City, NY

Responsibilities:

• Conducted Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Performed feasibility analysis and adept in using Gap Analysis techniques to gain a clear understanding of the AS IS of the System and additionally derived new scenarios to understand the potential TO BE system.
• Communicated with the clients to gather business requirement and workflow analysis and created functional specifications and various type of diagrams, like, Use Case Diagrams, Activity Sequence diagrams, Process Flow and Workflow diagrams.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed.
• Analyzed complex business problems and specify the functionality of solutions; provided technical expertise in identifying, evaluating, and developing systems and procedures that meet user requirements; Determined and communicated issues/risks and provided Project Management support across all phases of SDLC.
• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, sponsor, and stakeholders to baseline the scope of the work and enable development of the plan.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed.
• Established as point of contact for all technical data related issues and be able to troubleshoot those issues and solutions.

Confidential, New York City, NY

Responsibilities:

• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Identified and establish scope and parameters of requirements analysis in order to define impact, outcome criteria and measure-taking actions through interface analysis, prototyping and JRP/JAD sessions with Focus group.
• Converted consumer insights into out of box ideas to enhance user experience (UX) and presented it to marketing team.
• Provided man hour estimates to the management team and created road map for the mobile application development.
• Maintained a traceability matrix for all requirements and mapping to various Data Reporting Manuals, User Guides.
• Involved in creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team.
• Developed use case model using MS Visio. Created a development plan for the overall project and prototypes.
• Ensured that software faults are identified and documented and ensure interaction with development team so that testing issues are isolated and resolved.
• Professionally enforced ways to reuse requirements across projects, maintained a consistent terminology and data governance process.

Environment: Guidewire, JIRA, Oracle, Java, XML, SoapUI, Informatica, Cognos 9.5, Quality Center, Unix, SalesForce.com.

Confidential

Group Lead - Business Analyst / QA Analyst

Responsibilities:

• Actively involved in requirements traceability information and tracked requirements status throughout project.
• Collaborated with business users to test applications and implement workaround to feature issues, works with the business to recommend appropriate training, communication and scheduling as systems are deployed.
• Worked with business representatives to understand Data Mart requirements and ensured appropriate alignment with IT.
• Identified and clearly defined functional issues and support IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design.
• Analyzed software anomalies, provide clear and concise defect reports and follow defect tracking practices based on internal QA standards and processes and circulates among all the Project members and higher management.

Environment: Oracle 9.0, Visual Basic, Eclipse, QlikView, SQL Navigator, XML, .Net, Sun Solaris, Ab Initio, Business Objects.