SUMMARY

• Over 8+ years of Professional Experience in different environments and platforms including Data Analysis, data warehousing, data modelling, data mapping, data lineage, data profiling, Informatica Data Quality (IDQ), Informatica Data Analyst (IDA), Informatica Power Center and Client - Server applications in Insurance Industry.
• Expertise with Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling.
• Experience in Informatica MDM (Siperian), IDD (Informatica Data Director), IDQ (Informatica Data Quality), Address Doctor and Identity Matching.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modelling, Business Analysis and Testing various methodologies.
• Experienced in working with Data Resource Management team (DRM), Enterprise Metadata Repository team (EMR), Corporate Data Dictionary team (CDD), Integrated Governance Board (IGB) for data quality, data Integration of enterprise data assets.
• Experience gathering requirements through JAD sessions and JRP, Walkthroughs, Interviews, Questionnaires and Brainstorming with end-users, clients, stake holders and the IT group.
• Highly experience on implementation of Guidewire Billing Center, Policy Center integrations.
• Expert in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
• Experience Preparing requirements document for Commercial Auto, Inland Marine, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Good Knowledge on Cloud Computing with Amazon Web Services like EC2, S3.
• Proficient in developing parameterized reports, cascading reports, drill down reports, drill through reports, sub reports and ad-hoc reports in SSRS by pulling data from SSAS or relational database.
• Excellent technical skills in SQL to extract, transform and loading data to the database using tools such as Guidewire Data hub.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Ab Initio and Informatica Power Center, Informatica Data Quality (IDQ), Informatica Analyst, Informatica Master Data Management (MDM), Informatica Meta Data Manager, Data Stage, SSIS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS.
• Skills in developing Use Case diagrams, Sequence diagrams, State Chart diagrams, and Class diagrams. Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, navigational flows, story boards, UI specifications and Sequence Diagrams.
• Requirements Gathering, Requirements Elicitation, Requirements Engineering & Functional Testing
• Experience in Re-Insurance claims/Policy, banking applications, Personal Auto Insurance claims, Workers Compensation Insurance claims, General Liability claims, Property Claims, HR application, telecoms ticketing, standalone and Web applications.
• Expertise in Installation and Configuration of Informatica MDM Hub, Cleanse and Match Server, Informatica Power Center.
• Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
• Good Knowledge in Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules.
• Working knowledge and business experience in Retail-Point of Sale, Mobile end2end and Commercial insurance diverse domains (Guidewire).
• Experience in various LOB's such as Personal Insurance Including Auto, Dwelling and Home owner.
• Worked on new extensions, enhancements, GOSU classes, PCFs in Guidewire Billing Center.
• Experience working on Data warehouse, Data Marts and OLAP cubes.
• Expertise in understanding project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Good Knowledge in all phases of Software Development Life Cycle (SDLC) including Design, Implementation and testing during the development of software applications along with Data Analysis, Data Extraction, Data Transformation and loading, Data Mart &IBM Cognos Reporting tool to create cubes and reports.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Involved in extensive customizations on Guidewire Claim Center Financials (Reserves, Payments, Recovery, Recovery Reserves, Cash Flow Management) Knowledge of Auto Claims Processing and Underwriting of insurance products.
• Experience in working with My SQL database using TOAD for data validation testing.
• Solid understanding of Business Process definition and SDLC methodologies.
• Experience working on Project Management tools MS Project and Rally.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• Ability to blend technical expertise with strong Conceptual, Business and Analytical skills to provide quality solutions

TECHNICAL SKILLS

• Sybase
• Oracle and SQL Server 2000
• ETL tools
• SDLC methodologies
• RUP
• RAD
• Waterfall
• Agile

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Sr. Data Analyst

Responsibilities:

• Worked on the Claim Center integrations - Acuity(Litigation Management), Contact Manager, External Accounting Systems, ISO, OFAC.
• Working as Business Analyst on implementation of Guidewire Claimcenter for Auto, Property, General Liability and Workers Compensation lines of Business Developed Requirement Template to document User Stories.
• Involved in complete SDLC life cycle of big data project that includes requirement analysis, design, coding, testing and production.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Responsible for elaborating BillingCenter configuration user story such as Invoicing rules, Delinquencies, Policy Cancellation, Automated disbursements, Policy Rewrites, Policy Reinstatements, Billing Parameters, Fees, and Payment distribution rules, etc.
• Created reports from data warehouse using SSRS.
• Involved the implementation of MDM concept with upstream and downstream integration of different applications in agile environment.
• Contributed to requirements and statement of work negotiations for various projects, including BOP and Workers Compensation.
• Worked on Informatica ETL Data Integration tool to migrate the data, to create mapping from source to ODS (Operational Data Source) and then to Target of Netezza Appliance.
• Documented requirements for data and system integration of predictive models used in systems that managed
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Involved in implementing a MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap.
• Participated in review sessions on the GuideWire Data Model and coordinated testing of all data points in Data Model mapped in legacy system.
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Perform Gap Analysis of the processes to identify and validate requirements.
• Involved in the development of new line of business - Commercial Auto, property and Umbrella.
• Worked with Technical and Business leads during Guidewire Policy Center implementation.
• Extensively used Agile SCRUM Method for gathering requirements and facilitated user stories workshop.
• Identified high level requirements in Inception for Guidewire PolicyCenter and BillingCenter
• Facilitated Guidewire workshops for Guidewire suite display- BillingCenter, Product Model
• Identified high level requirements in Inception for Guidewire Guidewire BillingCenter
• Worked with Hadoop eco system - distribute, store and process data in a Hadoop cluster running in the cloud.
• Worked with the XML team and Creative design manager on the layout for various bills.
• Implemented multicurrency feature in Claim Center.
• Perform sophisticated ad-hoc and ongoing custom analyses against accounts payable vouchers and general ledger details to support business stakeholders.
• Develop functional requirement documents specific to enhancements, interfaces, and new projects as needed by the business.
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policycenter and Payment manager in Guidewire application based on the business requirements using LISA.
• Requirements development, test case development and testing of new state roll-outs in Workers Compensation and Commercial Package which includes Commercial Auto, General Liability, Commercial Property, Crime, Inland Marine, Garage, Professional Liability and Umbrella.
• Worked on risk reporting requirement for Commercial casualty lines of business, Product Liability, CGL Package and Pollution Legal Liability.
• Involved in the customization of Contact Manager - used as Vendor Management System.
• Participating/Facilitating Design/JAD sessions and provides input on the software solution.
• Assisted QA in Session based and Scenario based testing.
• Worked on Team Foundation Server (Coordinated with the external partners on Integrations with Claim Center
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Demonstrate the capability to utilize custom advanced Excel formulas to identify discrepancies between multiple, large data sets and troubleshoot the root cause of the discrepancies.
• Involved in Sprint Planning, Test Planning and Scrum Meetings.
• Involved in and worked on the integration of Policy Center with other applications of the Guidewire.
• Conducted Agile Scrum Meetings to review the day to day progress.
• Facilitated the Demo’s with the business at the end of the each sprint.
• Interacted with Guidewire Development team on the synchronizing the screens based on the customizations.
• Developed a matrix TFS to raise defects found in UAT.

Confidential, Greenville, SC

Data Analyst

Responsibilities:

• Working as a Data Analyst in Enterprise Data Warehouse to support software application (Guidewire) functionality release.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file and MS Access to data warehouse.
• Enhanced the out of box Guidewire PolicyCenter, BillingCenter and ClaimCenter data marts as per clients requirement.
• Deliver end to end mapping from source (Guidewire application) to target (EDW).
• Created SSIS package to load data from Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimension.
• Extensively involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts & claim counts.
• Review Business and Functional Requirements in the process of identifying the Data Elements associated at a Product level in Guidewire and was responsible for performing the Data Analysis.
• Created a road map for the client for the planning, developing, and implementing of MDM solutions, enabling consolidation of MDM data following Mergers and Acquisitions.
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines.
• Modify and develop new ETL transformations, summary tables, data staging areas based upon redesign activities with Informatica ETL tool.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Responded to production support issues and researched data anomalies in data ware-house against the Guidewire Claim Center system escalating to IT when necessary and keeping business stakeholders informed.
• Involved in Data migration and upgrade in different databases& Cloud and Amazon Web Services (AWS).
• Performed data analytics on claims and membership data and the associated business processes.
• Conducted analysis of business and user needs for information, features, reports, and functions in order to develop requirements for data analytics and reporting for operating units and corporate functions.
• Performed Data Analysis and validate the Data for the Personal and Commercial Line products and also participated in the Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy Center and Payment manager in Guidewire application based on the Data Mapping Requirements.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Completed the documentation of Claims Scenario’s for the source system
• Developed a system alongside Sr. Analyst which will run in the database and spits out the appropriate data that is needed.
• Participated in meetings which reviewed the system/process which was put in place to show and analyze the best possible way to present the proper data.
• Designed and developed SQL Server Reports based on different business parameters and governance compliance.
• Created several Data models and Reports, List of values and parameters, integrated it with OBIEE dashboards.
• Worked along with Project Manager in defining the Project scope, allocating resources, budgeting, creating the Project Charter.
• Wrote SQL queries for data validation, analysis and manipulation, and maintaining the integrity of the database.
• Analyzed the flow of data into downstream data warehouse which fed to data marts and end systems that support analytical and operational reporting.
• Responsible to extract specific data set from Operation database(ODS) by using PL/SQL query in order to data cleansing process and new feed processing purpose.
• Performed various ETL task Extracted the data from Oracle, Flat Files, Excel, Teradata Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008 R2).
• Involved in ETL specification designing for incoming feed coming from various data source and Data manipulation on it.
• Identified, researched, investigated, analyzed, defined and documented business processes, also worked closely with technical leads, information architects, and SQL developer team.
• Prepared Business Object Models and Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Created and handled sales reports, activity reports, forecasting, referral summaries and other miscellaneous ad hoc reporting.
• Created the DMD (Data Mapping Document) to specify the Data mapping from various data base sources to the target database and used Rational Rose for developing Unified Modeling Language (UML) diagrams like Use Cases diagram, Class diagram, Sequence and Activity based diagrams.
• Involved in creating and designing reports framework with dimensional data models for the data warehouse and worked with the development team on SQL Server 2005 tools like Integrations Services and Analysis Services.
• Played a key role in planning the UAT, implementation of system enhancements and data migration and conversions.

Confidential, Tucson, AZ

Data Analyst

Responsibilities:

• Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
• Part of team conducting logical data analysis and data modelling, communicated data-related standards.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Carefully examine data and reports to make sure conversion is proceeding correctly, run test scripts with various data to see how new or customized transactions process through the software and verify and validate accuracy of data through the generation of a variety of reports.
• Responsible for defining the key identifiers for each mapping.
• Involved in Developing / Auto deploy content using AWS (Amazon Web Services), GIT/Bitbucket, Maven, Jenkins.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and Microstrategy layer.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Involved in business meetings along with Architects and Data Modelers to help gather both the business requirements and the Data Mart requirements for the portal
• Created scorecards for management reporting with Tableau analytics software, to allow prompt decision making for corrective actions as needed
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Designed workflows and within allocated permissions SharePoint.
• Created new reports using SQL Server Reporting Services SSRS.
• Provided technical Expertise on the use of Rational Clear Case, Rational clear quest and Requisite pro, which were used for Data archiving and Requirements Management.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Review the logical model with Business users, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Performed source data profiling to verify that data meets the business requirements.
• Understood core processes of the departments to provide input on re-engineering or Streamline opportunities.
• Development of standard documentation package (Requirements, Specification, Design, Operations and Quality Testing Plans.
• Worked on Hadoop, big data technologies such as Hive, Pig map reduce, Yarn, oozi, sqoop and cloud environment such as AWS.
• Worked on different modules and analyzed the bugs in Defect manager in the Test Director reported by the users during the UAT.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Set up definitions and process for test phases including product test, integration test, and system test. Work to fully implement test phase entry and exit quality criteria, standard test reporting metrics and standard test artifacts.

Confidential, Redondo Beach, CA

Data Analyst

Responsibilities:

• Developed Data Flow Diagrams and Data mapping documents for QAS integration with Guidewireapplication.
• Gathered all the required data from QAS integration and Involved in Logical & Physical Data Modeling required in Guidewire applications.
• Integrated Guidewire with QAS.com using Web services for address verification functionality implementation.
• Provided support to the client team for the production implementation of Release 1 of GuidewireClaim Center.
• Provide ETL logic to pull the data from Guidewire application database to ODS layer and into Guidewire data marts and EDW (Enterprise Data Warehouse).
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• In charge of comprehensive Data Quality by making sure invalid, inconsistent or missing Obligor Risk Ratings are reported to portfolio managers for remediation and ensure that checks are in place to prevent the issue from re-occurring.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Creating TSQL 2008 Scripts to include them in the development of SSRS and Crystal Reports.
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Created Data Flow Diagrams and Process Flow Diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Generated Statements of Work for the Design and Implementation of CRM solutions based on Salesforce.com Methodology.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Transformed project data requirements into project data models.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, Metadata, Data Profiling.
• Generated reports through Business Objects and further analyzed data through Excel Used Pivot tables, Vlookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis.
• Analyze business requirements and segregated them into high level and low level Use Cases, Activity and Sequence using Rational Rose according to UML methodology.
• Produced functional decomposition and logical models into an enterprise data model.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Extraction of test data from tables and loading of data into SQL tables.
• Used Reverse Engineering to create data models of existing databases.
• Conduct data mapping sessions.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.

Confidential, Louisville, KY

Data Analyst

Responsibilit ies:

• Working as Data Analyst/DW Analyst for Guidewire PolicyCenter Implementation and integration of PolicyCenter with legacy systems, document output management systems and Rules & Rating Engine.
• Assisted in the creation of deliverables that are developed jointly with the user and technical Guidewire development team, including output definition, logical design (business process and rules, data elements and flows, screens and reports), implementation plan, documentation, and training needs.
• Developed detail Data Mapping document for generating Workers Compensation compliance reporting through Policy Center.
• Use analysis and experience to ensure data is properly mapped from the OLTP system to the staging area to the Claims Data Warehouse.
• Review business requirements to identify product gaps in the Guidewire.
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policycenter and Payment manager in Guidewire application based on the business requirements
• Developed data conversion programs for membership, claims, and benefit accumulator data -converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Design and maintain business intelligence tools, applications, databases, dashboards and systems methods
• Program user interface and application of business intelligence solutions
• Worked with Cognos reporting systems to extract the data for analysis using filters based on the analysis.
• Reviewed the data model and reporting requirements for Cognos Reports with the Datawarehouse/ETL and Reporting team. Wrote several SQL scripts for massive data extracts and manage the data conversion and extraction process.
• Working Knowledge on data requirements for migrating data from Third Party Vendors/Internal System to ODS then to DW to cater to the needs of Business Intelligence Users Team.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created data warehouse, data mart/repositories for clinical systems and data analysis stored procedures and generate KPIs and dimensional data.
• Create packages using SSIS for data extraction from Flat Files, Excel Files, Oracle, XML, OLEDB to SQL Server 2008R2/2014
• Created Technical specifications for the Business Objects Reporting Applications.
• Generated reports through Business Objects and further analyzed data through Excel Used Pivot tables, Vlookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Analyzed large data sets using MS SQL Server and Excel through SQL queries, VBA macros, and forms.
• Designed and developed SQL Server Reports based on different business parameters and governance compliance.
• 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.
• Reverse Engineered the existing ODS in to Erwin.
• Experience with complex SQL queries for data profiling for Data ETL Integration tool.
• Gathered data requirements and modelled the data warehouse and the underlying transactional database.
• Responsible for defining and designing remedial process to optimize the process the business uses to meet customers’ needs
• Interacted with the SME's to analyze the Data Extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
• Gathered requirements and modelled the data warehouse and the underlying transactional database
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Part of team conducting logical data analysis and data modelling, communicated data-related standards.
• Utilize Agile Jira to manage the Agile Scrum process for multiple teams concurrently
• Wrote specification documents to afford the company to meet the federal mandatory control deadlines
• Used Data warehousing for Data Profiling to examine the data available in an existing database
• Highly contributed to the enterprise metadata efforts by completing the data mapping repository (DMR) information
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Involved in preparation of technical design document and led the offshore team in the development process
• Collected business requirements to govern proper data transfer from data source to data target during the data mapping process