We provide IT Staff Augmentation Services!

Sr. Mdm & Etl Analyst Resume

Atlanta, GA


  • Over TEN years’ experience in Information Technology with expertise in ETL and Data Architecture and Modelling for Data Warehouse/Data Mart development, OLTP Applications, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
  • Experience working with Big Data - Hadoop Ecosystem including Spark, HDFS, Hive, Kafka, Sqoop, Hbase NOSQL databases.
  • Experience in writing queries for moving data from HDFS to Hive and analysing data using Hive-QL. Good understanding of Partitions, Hive Query optimization, Bucketing etc.
  • Experience in data structure analysis, and development of ETL processes, SQL, and scripting in support of data transformation and delivery.
  • Experience in development in Master Data Management applications using MDM technologies such as Informatica, Profisee, etc.
  • Experience in designing corporate Data Governance Framework and creating data quality management policy & processes for large enterprises.
  • Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
  • Involved in various projects related to Data Modelling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
  • Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
  • Worked on EDI healthcare transactions such as 837-Institutional, 837-Professional, 837-Dental, 835-Claim Payment/Remittance Advise, 270/271-Eligibility Benefit Inquiry/Response, 276/277-Claim Status Inquiry/Response Transactions.
  • Experience in Business Analysis and Software Development Life Cycle (SDLC) methodologies such as Waterfall, Agile/SCRUM, RAD, Rational Unified Process (RUP) methodology.
  • Good knowledge of CMS Medicare and Medicaid (MMIS), HEDIS, quality reporting including the PQRS, Value Modifier, Hospital Reporting and Accountable Care Organizations.
  • Excellent knowledge of Health Insurance Portability & Accountability Act (HIPAA) standards, Electronic Data Interchange (EDI), transaction syntax like ANSI X12, Implementation and knowledge of HIPAA code sets, ICD-9, ICD-10 coding, HL7, HMO, PPO.
  • Good experience in creating Use Case Scenarios, process modelling using Use Case Diagrams, Data Flow Diagrams, Activity diagrams and Sequence Diagrams using MS Visio and Rational Rose.
  • Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables.
  • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
  • Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
  • Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
  • Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Informatica.
  • Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise datastores within a metadata repository.
  • Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
  • Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
  • Exceptional communication and presentation skills and established track record of client interactions


Data Modelling Tools: Erwin, ER Studio V8.0.1 and Oracle Designer

OLAP Tools: Microsoft Analysis Services, Business Objects

ETL Tools: Microsoft SSIS and Informatica

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML

Database Tools: Microsoft SQL Server 2000/2005/2008 , DB2, Oracle 10g/9i, MS AccessTeradata, Hadoop, HortonWorks, Cloudera, HIVE, Spark, Kafka

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX


Confidential, Atlanta, GA

Sr. MDM & ETL Analyst


  • Developed database designs and ETL Processes for QI, PA, Mediclaims, Pharmacy and Dental Claims, Risk for data ingestion.
  • Work across various teams in IT and the business to help define the requirements and drive adoption of the MDM solution.
  • Worked with ER/Studio Data Architect for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
  • Involved in performance tuning of targets, sources, mappings, and sessions.
  • Developer ETL transformation logic and jobs using Informatica PowerCenter and monitored sessions using workflow manager and workflow monitor.
  • Creates ETL mappings using reusable components like worklets, mapplets using other reusable transformations.
  • Developed Data Quality and Data Governance framework incorporating the Enterprise Data Architecture Standards to facilitate Data Organization effectiveness program.

Confidential, Albany, NY

Sr. Data Modeler & ETL Database Analyst


  • Working in liaison among stakeholders in order to elicit, analyse, communicate, and validate the requirements for changes to current business processes, policies, and information systems and for the development of HRS business processes. Policies and Information Systems.
  • Analysed the business requirements, business rules, and designed Conceptual, Logical and Physical Data Models for HRS, FHQP and FHDMS solutions.
  • Used CA Erwin to design Data Models and for reverse engineering to connect existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
  • Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
  • Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
  • Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
  • Developed Source to Target Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
  • Created Data Profiling strategy and data profiling rules documents for Data Quality tasks.
  • Provide technical and architectural expertise to various development teams, communicate architectural decisions, and mentor other technical staff around various development technologies and decisions.
  • Create, communicate and implement Data Governance for the sub programs within IES.
  • Developed enterprise-wide database naming standards and create Data Dictionaries, Business Glossary and Data Glossary Documents to support Data Governance and Database management initiatives across the State of NY IES modernization program.

Confidential, Omaha, NE

Sr. Data Architect/Modeler and MDM Database Consultant


  • Collaborate with stakeholders, business users, project sponsors for the extraction and abstraction of the requirements through requirement elicitation process which includes but not limited to interviews, white boarding, brain storming, JAD sessions etc.
  • Reverse and forward engineered highly complex Data Models for Big Data platforms such as Apache Hadoop - Cloudera, Hortonworks and MapR.
  • Design model information to develop ER & Dimensional diagrams; Conceptual, Logical and Physical Data Models using data modelling tools such as ERWIN for Order Management System, Transport Management System, and Intermodal systems.
  • Collaborate with ETL Developers, Application Development teams, Database Administrators and build robust and scalable dimensional and relational data models for Oracle, Informix, SQL Server, and DB2 specific databases.
  • Identify Entities, define entity relationships, implements Data Warehouse, Data Modeling, and Data Architectural best practices for NoSQL and SQL database platforms.
  • Responsible for Data Profiling and Data cleansing functions enhancing the quality of data and reduce data redundancy.
  • Implement Slowly Changing Dimensions (SCD), Change Data Capture and Data Audit mechanisms to ensure Data Quality.
  • Implement Data Governance and create enterprise-wide Data Dictionaries. Identify, Capture and maintain Metadata.
  • Build subject area Data Models, publish Data Models to cross functional teams, Users and Stake Holders for the review and approvals.

Confidential, Pittsburgh, PA

Sr. Data Architect/Modeler & Database Consultant


  • Developed Conceptual model using Erwin based on requirements analysis.
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
  • Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
  • Used forward engineering to create Physical Data Models with DDL that best suits the requirements from the Logical Data Model.
  • Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
  • Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
  • Responsible for gap analysis in changing old MMIS and Involved in testing new MMIS.
  • Analyzed HIPAA 5010 related to 837, 835, 270, and 271. Transactions and performed GAP analysis between the 4010 and 5010.
  • Assisted internal clients with data mapping and validation edits to guarantee complete adherence to HIPAA transaction and code set guidelines.
  • Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
  • Responsible for defining the naming standards for data warehouse.
  • Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
  • Exhaustively collected business and technical metadata and maintained naming standards.
  • Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
  • Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
  • Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
  • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
  • Integrated the work tasks with relevant teams for smooth transition from testing to implementation.

Environment: Erwin, Informatica, Windows XP/NT/2000, SQL Server 2005/2008, SQL, Oracle10g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential, Conshohocken, PA‎

Sr. ETL Analyst and Database Consultant


  • Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
  • Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
  • Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
  • Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
  • Created and maintained the Data Model repository as per company standards.
  • Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
  • Ensured the feasibility of the logical and physical design models.
  • Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
  • Worked on the Snow-flaking the Dimensions to remove redundancy.
  • Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: CA ERWIN, Oracle 10g, SQL Server 2005, PL/SQL, PeopleSoft V8, TOAD, Informatica, Power Centre 6.0, Business Objects

Confidential, Dallas, TX

Sr. ETL Data Analyst


  • Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
  • Used Change Data Capture (CDC) to simplify ETL process when working in data warehouse applications.
  • Designed ETL transformation mappings by using Informatica.
  • Created standard business process models as well as conceptual prototypes and mock-ups when necessary.
  • Managed System Integration testing, functional testing, Automation testing for delivery teams and User Acceptance Testing.
  • Managed and documented business, functional and non-functional requirements.
  • Worked at conceptual/logical/physical data model level using Erwin according to requirements.
  • Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions.
  • Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use
  • Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
  • Developed the required data warehouse model using Star schema for the generalized model.
  • Used forward engineering approach for designing and creating databases for OLAP model.
  • Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
  • Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
  • Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Created action plans to track identified open issues and action items related to the project.
  • Prepared analytical and status reports and updated the project plan as required.

Environment: CA Erwin, MS Visio, Oracle 9i, Oracle Designer, SQL Server2000/ 2005, Informatica, Crystal Reports 9, XML, Rational Rose and SQL Server Reporting Services


Data and Business Systems Analyst


  • Analysed the business requirements and system specifications to understand the application.
  • Interacted with business analysts on application design and specifications.
  • Performed manual tests at various levels of the SDLC.
  • Responsible for performing functional testing of the application.
  • Defined the scope of the testing process, goal-oriented scenarios and individual responsibilities of the team members. Estimated the possible test challenges based upon the business requirements and a proactive approach is followed in executing the test plan.
  • Responsible for writing SQL queries for performing backend testing of the application.
  • Developed Test Plan, Test case, Test Metrics and Test Reports using Mercury Quality Center.
  • Designed Test Cases using Functional Requirements Specification and Use Cases
  • Validated software functional specifications through testing to make sure the developers have coded according to functional specifications.
  • Generated Test Harness and Orthogonal Array Test case and Test plan documents.
  • Rigorously performed Regression Testing using Manual testing.
  • Performed Usability Testing of the application by conducting interviews, sessions and questionnaires with business users.
  • Mercury Quality Center was used to report the Defects.

Environment: Quality Center, DWH, C#.Net, ASP, Oracle 9i

Hire Now