SUMMARY

• Over 8+ years of Professional Experience in different environments and platforms including Data Analysis, datawarehousing, datamodelling,datamapping, data lineage,dataprofiling, 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.
• 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.
• 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 in Preparing data requirements 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 loadingdatato the database using tools such as GuidewireDatahub.
• 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.
• 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.
• 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.
• 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.
• 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.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Data Analyst

Responsibilities:

• Working as Sr. Data Analyst/DW Analyst for Guidewire PolicyCenter Implementation and integration of PolicyCenter with legacy systems, document output management systems and Rules & Rating Engine.
• Developed detailDataMapping document for generating Workers Compensation compliance reporting through Policy Center.
• Worked on Data migration and upgrade in different databases& Cloud and Amazon Web Services (AWS).
• 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.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Created reports from data warehouse using SSRS.
• Participated in review sessions on the GuideWire Data Model and coordinated testing of all data points in Data Model mapped in legacy system.
• Involved the implementation of MDM concept with upstream and downstream integration of different applications in agile environment.
• Worked on creating and designing reports framework with dimensional data models for the data warehouse and worked with the development team on SQL Server tools like Integrations Services and Analysis Services.
• Contributed to requirements and statement of work negotiations for various projects, including BOP and Workers Compensation.
• Worked on InformaticaETLDataIntegration tool to migrate thedata, to create mapping from source to ODS (Operational DataSource) and then to Target of Netezza Appliance.
• Documented data requirements for data and system integration of predictive models used in systems that managed
• PerformedDatamapping, logicaldatamodeling, created class diagrams and ER diagrams and used SQL queries to filterdata.
• Involved in implementing a MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap.
• 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 data requirements and modeled the data warehouse and the underlyingtransactionaldatabase
• Worked on development of new line of business - Commercial Auto, property and Umbrella.
• Worked with Data leads during Guidewire Policy Center implementation.
• Identified high level data 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 WorkersCompensation and Commercial Package which includes Commercial Auto,General Liability, Commercial Property, Crime, Inland Marine, Garage, ProfessionalLiability and Umbrella.
• Worked on data requirements 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.
• 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 andtroubleshootthe root cause of the discrepancies.
• 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.

Confidential, Harrisburg, PA

Data Analyst

Responsibilities:

• Developed DataFlow Diagrams and Data mapping documents for QAS integration with Guidewire application.
• Gathered all the required datafrom QAS integration and Involved in Logical & PhysicalDataModeling required in Guidewire applications.
• Integrated Guidewire with QAS.com using Web services for address verification functionality implementation.
• Working as a Data Analyst in EnterpriseDataWarehouse to support software application (Guidewire) functionality release.
• Worked on the Claim Center integrations - Acuity(Litigation Management), Contact Manager, External Accounting Systems, ISO, OFAC.
• Created several Data models and Reports, List of values and parameters, integrated it with OBIEE dashboards.
• Enhanced the out of boxGuidewirePolicyCenter, BillingCenter and ClaimCenterdatamarts as per clients requirement.
• Deliver end to end mapping from source (Guidewireapplication) to target (EDW).
• Created SSIS package to load data from Flat File to SQL Server 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 newETLtransformations, summary tables,datastaging areas based upon redesign activities with InformaticaETLtool.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Responded to production support issues and researcheddataanomalies indataware-house against theGuidewire Claim Center system escalating to IT when necessary and keeping business stakeholders informed.
• Performed data analytics on claims and membershipdataand the associated business processes.
• Conducted analysis of business and user needs for information, features, reports, and functions in order to develop requirements fordataanalytics 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 testing and took signoff from the Commercial line of Property & Casualty business users.
• Participated in meetings which reviewed the system/process which was put in place to show and analyze the best possible way to present the properdata.
• Designed and developedSQLServerReports based on differentbusinessparameters and governance compliance.
• Worked along with Project Manager in defining the Project scope, allocating resources, budgeting, creating the Project Charter.
• Wrote SQL queries fordatavalidation, 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 specificdataset from Operation database(ODS) by using PL/SQL query in order todatacleansing process and new feed processing purpose.
• Performed various ETL task Extracted thedatafrom Oracle, Flat Files, Excel, Teradata Transformed (Implemented requiredBusinessLogic) and Loaded into the targetDatawarehouseusing SSIS (SQLServer2008 R2).
• Involved inETLspecification designing for incoming feed coming from variousdatasource and Datamanipulation 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.

Confidential, Neenah, WI

Data Analyst

Responsibilities:

• Worked with Data Warehouse in the development and execution ofdataconversion,datacleaning and standardization strategies and plans as several small tables are combined into one singledata repository system MDM (Master Data Management).
• Worked on Developing / Auto deploy content using AWS (Amazon Web Services), GIT/Bitbucket, Maven, Jenkins.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Created scorecards for management reporting with Tableau analytics software, to allow prompt decision making for corrective actions as needed.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Involved in database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Performed source data profiling to verify that data meets the business requirements.
• Created new reports using SQL Server Reporting Services SSRS.
• Part of team conducting logical data analysis and data modelling, communicated data-related standards.
• Carefully examinedataand reports to make sureconversionis proceeding correctly, run test scripts with variousdatato see how new or customized transactions process through the software and verify and validate accuracy ofdatathrough the generation of a variety of reports.
• Responsible for defining the key identifiers for each mapping.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Designed workflows and within allocated permissions SharePoint.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.

Confidential, Jacksonville, FL

Data Analyst

Responsibilities:

• Created various data quality mappings in Informatica Data Quality (IDQ) tool and imported them into Informatica PowerCenter as mappings, Mapplets.
• Extensively used Informatica Data Quality transformations - Labeler, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.
• Provided support to the client team for the production implementation 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.
• CreatedDataFlow Diagrams and Process Flow Diagrams for various load components like FTP Load, SQL Loader Load,ETLprocess and various other processes that required transformation.
• 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.
• Analyzebusinessrequirements 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, Columbus, OH

Data Analyst

Responsibilities:

• 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.
• Reviewed the data model and reporting requirements forCognosReports with theDatawarehouse/ETL and Reporting team. Wrote several SQL scripts for massivedataextracts and manage thedataconversion and extraction process.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writingdata.
• Create packages using SSIS for data extraction from Flat Files, Excel Files, Oracle, XML, OLEDB to SQL Server.
• Analyzed largedatasets using MS SQL Server and Excel through SQL queries, VBA macros, and forms.
• 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.
• Gathered requirements and modelled the data warehouse and the underlying transactional database.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Program user interface and application of business intelligence solutions.
• Worked with Cognos reporting systems to extract thedatafor analysis using filters based on the analysis.
• Working Knowledge on data requirements for migrating data from Third Party Vendors/Internal System toODSthen 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.
• Created data warehouse,data mart/repositories for clinical systems and data analysis stored procedures and generate KPIs and dimensionaldata.
• 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.
• Designed and developed SQL Server Reports based on different business parameters and governance compliance.
• 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.
• 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.
• Responsible for defining and designing remedial process to optimize the process the business uses to meet customers’ needs.
• 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.
• Highly contributed to the enterprise metadata efforts by completing the data mapping repository (DMR) information.
• 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.