We provide IT Staff Augmentation Services!

Sr. Data Analyst/data Governance Analyst Resume

0/5 (Submit Your Rating)

Tallahassee, FL

SUMMARY

  • Highly motivated Information Technology professional with demonstrated experience inapplication development.
  • Strong analytic and problem solving skills in both new development and production support scenarios, solid experience in data mining and analysis of complex issues and business data to provide comparative analysis of alternative solutions.
  • Proven ability to learn new technology and concepts quickly. Frequently cited as a team player.
  • 6 years of professional experience as a Data Analyst/Data Governance/Business Analyst in Insurance Industry (Property & Casualty) related to Guidewire Implementation.
  • Worked on Data warehousing business Intelligence area dealing with data analysis, solution design Metadata management and MDM, ETL.
  • Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures
  • Strong hands on ability to use SQL in RDBMS (SQL Server, Oracle) for verifying source data preparation and assisting of data design input and trouble - shooting.
  • Worked on Master data management (MDM) and data governance for improving data quality. Extensive experience in Duck Creek implementation having worked on three large scale
  • Experience of serving as facilitator and Data Governance technical advisor to the Data Governance Council.
  • Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation and maintenance.
  • Managed timely completion of multiple projects in parallel- worked in close conjunction with the Project Management Office (PMO) to define scope of the project and its deliverables
  • Expertise experience in Guidewire Policy Center and Billing Center configuration and Integration.
  • Experience in Workers Compensation and Personal Insurance modules in Guidewire Policy Center.
  • Insurance experience includes Personal Property Casualty and Commercial Product knowledge, Reinsurance for Commercial Property Casualty.
  • Worked on URL Process extensions to develop Web applications, client server technologies andAgile Core Web Services.
  • Worked with Duck Creek user interface including Duck Creek Billing and policy administration Dashboard, Account Home, Policy Summary, Grids, Dates and Validation Controls
  • Extensive experience in analysing and requirements gathering and writing system functional specifications also had experienced in SQL Server Reporting Service, Executing Queries and Running Store Procedures.
  • Proficiency in Data Modeling tools like Erwin, ER Studio and Power Designer, developing and modeling Entity Relationship diagrams, Transactional and Data Warehouse Databases.
  • Translates data file formats (ETL) in Access, Microsoft Import/Export Wizard, SSIS, strong experience in RUP Business modeling process.
  • Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
  • Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
  • Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
  • Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to Enterprise Data Warehouse.
  • Extensively worked on store procedures for new system changes and troubleshoot the existing store procedures to work more efficiently.
  • Excellent knowledge and experience of creating source to target mapping, edit rules and validation, transformations, and business rules.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.
  • 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.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
  • Experience in Data Modeling, Data Mining and Data warehousing in SQL Server and Oracle environment.

PROFESSIONAL EXPERIENCE

Confidential, Tallahassee, FL

Sr. Data Analyst/Data Governance Analyst

Responsibilities:

  • Worked with subject matter leads on Data Governance and MDM assessment project including current state assessment, gap analysis, and future state business and architecture recommendations.
  • Develop 90-Day and Multi-Year Data Governance and MDM tactical and strategic roadmaps.
  • Lead client organization through successful implementation of a complete Data Governance framework and operating model.
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives
  • Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
  • Deliver Program Charter for Core Insurance Solution Implementation to define Program Vision, Guiding Principles, Risks and Governance Processes and Structured.
  • Involved in evangelizing the value of data governance and developing presentations for various levels of the organization.
  • Created an initial data governance charter and process diagrams for maintenance, change management, and issue resolution.
  • Performed interim and future state data governance workflow development and design for data elements based on Operational Finance Data Governance workshops.
  • Custom Code Design for integration to downstream ODS and Data Warehouse for BI needs. Identification of Data Domains for MDM such as Patient, Organization and Physician etc.
  • Created test scripts for Data driven, functional and regression testing using QTP.
  • Tested Data Integrity by executing SQL queries against Central databases.
  • Involved in complete testing life cycle including creation of Test Plan, Test Cases, collecting test data for various projects and documenting test results
  • Evaluation and selection of various MDM technologies and products in view of the client requirements.
  • Identify and execute improvements to the effectiveness, efficiency, and flexibility of data governance processes as assigned.
  • Create and maintain data model/architecture standards, including master data management (MDM)
  • Provide ETL logic to pull the data from Guidewire application database to ODS layer and into Guidewire data marts and Data warehouse.
  • Compare MDM to core ERP Purchasing and AP Systems for accuracy of Supplier Data to prevent PO discrepancies.
  • Created SQL queries to pull out data and metrics from the database and assisted in creating the Physical database for MDM and the Data Mart.
  • Responsible for reviewing the development standards; testing standards and processes.
  • Involved in development of Automation Testing Strategies & Test Process; developed automation testing requirements, prepared test scripts, running tests, collecting test results/ metrics.
  • Manage Centrally Managed Suppliers List for the MDM Team by keeping Category Managers, Payments Terms, Sub Categories, and PPRs up to date to match updated contracts
  • Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System
  • Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse) and wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Created and Designed logical database schema for data warehouse (Teradata) environment to prepare for ETL.
  • Worked as an MDM global Business Process Analyst ensuring the smooth flow of business activities for Asia pacific region.

Confidential, Iselin-NJ

Sr.Data Analyst/Data Governance Analyst

Responsibilities:

  • Gathered high-level requirement for all the external projects in a release and conducted evaluation of bank’s data governance structure and identified gaps in structure, data and systems.
  • Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution
  • Involved in various third party application migrations like Aprimo, Business Objects, Crystal Reports.
  • Proposed the development of Enterprise Information Management and Data Governance that would support the transformation of business practices into treating data as an asset instead of a by-product of the systems
  • Design, develop and provide unit test data loading and data transformation programs related to Netezza Data Warehouses and Data Marts
  • Participated in developing Source to Target mappings using ETL process into new Oracle database system.
  • Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
  • Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements
  • Conduct requirements gathering and creation of functional specification for development of the MDM model.
  • Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
  • Delivered final report with findings, recommendation and roadmap for Data Governance that was approved by the client
  • Implemented and validated the MDM Gold address for the Recipients. Documented Source to Target mapping details including business & transformation rules.
  • Executed PL/SQL on oracle table in order to view successful transaction of data and Built reports and report models using SSRS to enable end user report builder usage.
  • Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
  • Conducted meetings for the Data Modeling and Analysis and Helped with Data Mapping between the data mart and the Source Systems.
  • Created test cases, test plans for Charles River compliance rules for the algorithm tools.
  • Wrote the Functional specifications, Insurance product specificBusinessrules and Rating Engine.
  • Covered all kinds of testing like Regression, Retest, System, Functional and Performance testing.
  • Prepared scripts, running tests, Analyzing results in LoadRunner 9.1 for Performance testing.
  • In-charge of Usability testing on the product and making appropriate recommendations
  • Created the logical models and generated the physical models in the databases using Erwin.
  • Reviewed test results and coordinated with testing and development team to correct the issues and developed timelines for project delivery, and managed projects/resources.
  • Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in the process.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Confidential, Dallas, TX

Data/Business Analyst

Responsibilities:

  • Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
  • Writing SQL queries and stored procedures to identify fraudulent claims and data analysis and data validation for various health insurance clients.
  • Pre Go live data loads into MDM system -Analyzed the raw data provided by the end users, checked them for their quality and completeness and then loaded them into the MDM system using import manager and import maps.
  • Provides personal and commercialproperty&casualtyinsuranceand lifeinsuranceto families and business owners.
  • Collaborate withpropertyandcasualtyunderwriters as the liaison with customers.
  • Worked on Guidewire Billing Center with the Personal line, Test Definition workshop, Test Strategy, Test Planning using Insurance Test Framework for Guidewire.
  • Worked on the Guidewire Product model to include Coverage Terms and Questions sets
  • Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Gathered requirements and modeled the data warehouse and the underlying transactional database
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling
  • Created source table definitions in the DataStage Repository by studying the data sources by importing the data from Mainframe.
  • Involved in QA planning and testing of Enterprise Data Warehouse (EDW) for complex packages for data moving and summarization in a Reporting Data Mart.
  • Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.

Confidential, Austin, TX

Business Data Analyst

Responsibilities:

  • Worked as a Commercial line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
  • Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines
  • Assisting the Project Management Office (PMO) with Build-or-Buy decisions
  • 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.
  • Worked closely with the SME’s like Property & Casualty Sales Representatives, Account Managers, Underwriting Directors, Officers, SVP & Chief Underwriter, Loss/Risk Control Consultant and Sr. Security Administrator.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Developed test plans with QA team and helped to develop test cases for system testing, integration testing and performance testing.
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Identify business rules for data migration and Perform data administration through data models and metadata.
  • Designed and developed project document templates based on SDLC methodology and process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
  • Reviewed test results and coordinated with testing and development team to correct the issues.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS and Complete study of the in-house requirements for the data warehouse.
  • Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.

We'd love your feedback!