SUMMARY

• Certified Scrum Master/Business Data Analyst with 6 years of IT experience in Health and Insurance(P&C) domains
• Skilled in identifying and documenting quality business requirements for new system implementations and major enhancements
• Experience in liaising between business and technical departments. Effectively able to translate and interpret business needs into functional requirements & Test scripts along with analyzing impact of changes
• Author for Guidewire Policy Center and Claim Center Integrations and Configuration User Stories& Acceptance Criteria for Test.
• Perform thorough data analysis by gathering requirements and using SQL extraction queries to build prototypes for the front - end users to verify the data for data profiling.
• Perform quality assurance testing on data loaded by ETL applications to ensure its accuracy and correctness and to work with the developers to help solve any underlining issues found by the testing.
• Extract, transform, and load data to a target system based on business requirements and/or mapping documents that are defined by the client or business analyst.
• Extensive understanding & experience in migration of Legacy System to Guidewire solutions (Policy Center, Claim Center & Billing Center).
• Experienced in the documentation of system, technical and business requirements and specifications, root-cause analysis, GAP analysis and forecasting the risk.
• Knowledge of health care services regulatory environment in compliance with HIPAA, ICD , and EDI
• Extensive knowledge on Address, Policy, Drivers/Properties/Workers/Liable, Coverages, Endorsements and Document screens in Guidewire Policy Center Screens.
• Extensive knowledge on Summary, Financials, Loss Details, Workplan, Activities, Endorsements, Documents etc, in Guidewire Claim Center
• Experience in Property & Casualty for Worker’s Compensation, General Liability, Commercial and Personal (Auto, Property) Lines of Business
• Experience in UML Modeling, writing use case documents, use case diagram, state diagram, object diagram, sequence diagram, boundary class diagram, and process workflows.
• Experience in working on Internal and External Data Reporting Solutions for Commercial and Personal Lines of Business with all three Guidewire Centers and databases
• Excellent organizational, communication and interpersonal skills while being Self-motivated, adaptive and able to work in a team or independently in a deadline-driven environment.

TECHNICAL SKILLS

Methodologies &Concepts: Agile, Waterfall, Wireframes, UML, Root cause Analysis, RTM, Risk Analysis, System Analysis

Business Applications: MS Office suite, Gherkin Documentation, Share point

Project Management: Microsoft Project, Microsoft Office, IBM RTC/RRC.

Programming Languages: SQL, PL\SQL, HTML, XML, UNIX, C

Databases: Oracle, MS SQL Server, TOAD, MS-Access

Other Technologies: ERWIN, Informatica

Testing Tools: Rational Enterprise Suite, Quality Center, HP ALM

Test / Defect Management: TFS/MTM - Test Foundation Server / Microsoft Test Management.

PROFESSIONAL EXPERIENCE

Confidential, Warwick, RI

Sr. Business Systems Analyst

Responsibilities:

• Works on implementation of Data Hub and Info Center from Guidewire for reporting purposes
• Attending business workshops for collection of mapping requirements for multiple sectors.
• Interacting with stakeholders’ various departments (Claims/Financials/Billing/Controllers/Commissions/Sales etc.,) for business requirements.
• Creating worksheets with mapping for developing and generating reports in Cognos.
• Testing reports in Cognos
• Participates in data modelling discussions with Data Architects for acknowledging dependencies
• Analyzes and work on defects, change tickets and clarifications between stakeholders and developers.
• Responsible for handling and maintenance of Change ticket/defect/Clarification tracker
• Works around Business Users, customers, and Subject Matter Experts (SME’s) such as Underwriters and Actuaries to understand the existing system and the current business processes.
• Creates target mappings with Data Hub/Info Center understanding both internal and external report data requirements and business rules.
• Conducts Show & Tell with Stakeholders, business, development and test teams upon implementation.
• Analyzes and document the Data Hub/Info Center to assess schemas and DIM/FACTS.
• Works and assists on analyzing production defects, change tickets, clarifications etc.,
• Works on SQL developer, MS Excel, Data Dictionaries for PC/CC for analysis and documentation.
• Participates in training end users (Adjusters/ Call Center Representatives etc.,) with Guidewire Suite application
• Trains and works with interns on Guidewire products (Policy Center/ Claim Center/ Billing Center/ Info center)

Confidential, Hastings, MI

Sr. Business Data Analyst

Responsibilities:

• Documenting reporting data related requirements for different UI screens for Policy Center and Series II(Mainframes)
• Gathered and documented business data and reporting requirements into detailed Business Requirement Documents (BRD), Data Mapping documents, and User stories.
• Worked in determining the deficiencies in current systems, areas to be improved and enhanced for the replacement systems.
• Reviewed target mapping requirements with the business to understand both internal and external report data requirements and business rules.
• Translated Business Requirements into User Stories, Data Flow Diagram (DFDs) and UML Diagrams (Use case, Sequence and Activity diagrams).
• Interacted extensively with customers and Report designers to determine ways to improve the delivery and formatting of the Business Intelligence solutions.
• Created TO - BE data process maps to communicate the solutions to the technical ETL team as well as to gain the approval of the SME’s and the management team.
• Conducted reporting requirement mock - ups with the development and test teams before development.
• Assisted ETL developers with unit testing for determination of appropriate data tests sets.

Confidential, Columbus, OH

Requirement Analyst

Responsibilities:

• Proficient in Property and Casualty Insurance concepts.
• Analyzed and documented for Functional and Non-Functional requirements for different UI screens for both Claim Center and Policy Center
• Developed Artifacts, Actors, Business Rules in RRC/RTC, based on the solution scoping and Business requirement document for data mapping cards
• Worked on testing UI data for Policy Center application for quote, new business and servicing screens to cross verify requirements and business rules.
• Preparing Wireframes using MS Visio for User Experience design for communicating the requirements.
• Working knowledge on Rate engine (rules) to calculate New Business Policy bind and Policy renewals.
• Responsible for recreating and testing all requirement Change Requests to ensure they are well-defined, properly traced and assessing the impact before making approval recommendation
• Conducted gap analysis between existing and future state systems and gathered various reporting requirement from the business analysts.
• Identify timelines for the different kinds of testing to be performed and estimate the risks involved.
• Analyzed SQL queries to interpret the data related acceptance criteria involved with data model and reporting requirements for Tableau Reports with the Data warehouse / ETL and Reporting teams.
• Interacted with SME's, asking detailed questions and carefully recording the requirements to make sure no outstanding requirements for RTM.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Wrote the SQL Queries on data staging tables and data warehousing tables to write system requirements.
• Written system requirements for building UI for viewing data through Guidewire Policy Center for different LOB’s (Personal/Commercial lines of Auto and Property, General Liability and Worker’s Compensation).
• Responsible for elaborating Policy Center configuration user story such as New Manual Policy creation, ISO Coverages mapping, rules for inclusive of quoting, rating and serving etc.,

Confidential

Systems Engineer

Responsibilities:

• Gathering detail requirements scoped the technical solution required to address end client requirements.
• Designing the Business Process Solutions by analyzing the Specifications provided by the Business Analysts.
• Confirm project requirements by reviewing program objective, input data, and output requirements with analyst, supervisor, and client.
• Reviewed the system requirements for installing the software, including supported databases, servers and browsers.
• Performed feasibility study to determine which proposed solution best fits the needs of the organization, and documents recommendations made by the business analysts.
• Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
• Involved in procuring the requirements from the client for the changes in the medical policies (CSRs) based on which the system needs to be modified and implemented them for CSR (change order).
• Developed SQL code for "Reference Data Maintenance" subsystem.
• Work on UNIX shell scripting and SQL environment which involves design, implementation and construction as per the changes in the medical policies (CSRs)
• Created, developed and maintained automated reporting processes in MS Access and Excel, also looking into running this in Oracle SQL Server.
• Process the XML files with C program and data from PL-SQL.
• Created Shell Scripts to transfer the data and to run the SQL Scripts and run the jobs.
• Created and documented test procedures and scenarios for the pre-UAT phases.
• Peer reviews of the Design and Source Code (C, C++, and Shell Scripts).
• Performed unit testing and testing documentation.
• Worked on Production issues: debugging and fixing errors, tuning SQL queries, checking indexes usage.
• Participated in Code reviews for teammates.

Confidential, Piscataway, NJ

Programmer Analyst

Responsibilities:

• Capturing Business Requirements by collaborating with Business owners and Application teams.
• Participated in development of functional enhancements for application to enhance the software in performance and features using Oracle PL/SQL.
• Worked on the Low Level and High-Level Design Documents.
• Writing SQL queries for implementation.
• Performing Data loads by using the SQL loader, Imports & UTL files based on file formats
• Using Explain Plan for Performance improvement.
• Performing Process Improvement Initiatives related to Data Collection and Analysis.
• Responsible to provide project work update to the higher management.
• Involved in resolving issues during UT/IT and UAT testing phases.
• Involved in documentation of various functional modules.
• Implementing shell scripts for multiple builds.

Confidential

SQL Data Intern/Steward

Responsibilities:

• Set up meetings, conducted Walkthroughs, JAD sessions with Management, SME (Subject Matter Experts), vendors, users and other stakeholders to flesh-out issues and to resolve open and pending issues and to develop specifications.
• Extracted for SQL Developer, Analyzed and documented current state workflow and developed future state using ERWIN
• Analyzed the requirements and created the Use Case Diagrams, Activity Diagrams, Sequence Diagrams, flow diagrams in Visio for data analysis using ERWIN.
• Conducted gap analysis between existing and future state systems
• Created and managed project templates, requirement types and traceability relationships.
• Ensured the feasibility of the logical and physical design models.
• Created mapping documents for integrating various systems through a common interface.
• Logged required technical enhancements, defects, and resolved requirement issues in Excel.
• Worked gathering requirements and used Gherkins for documentation and automated testing for data analysis in simplified notions.
• Attended weekly status reports for project planning and data analysis.
• Facilitated and participated in various meetings for planning, design and estimation.
• Checked Test Cases and developed strategies with testing team to track and resolve defects.
• Conducted familiarization, training sessions for business users.
• Excellent communication skills and problem-solving skills with the clients and non-technical persons.