SUMMARY

• Over 8+ years’ experience in Information Technology with expertise in Data Modelling for Data Warehouse/Data Mart development, OLTP Applications, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• 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

TECHNICAL SKILLS

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 7.1.3

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

Database Tools: Microsoft SQL Server 2000/2005/2008 , DB2, Oracle 10g/9i, MS Access, Teradata<

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

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

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Modeler & Data Warehouse Analyst

Responsibilities:

• 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.
• 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.
• 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 Modeler/Data Warehouse Analyst

Responsibilities:

• 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. Data Modeler

Responsibilities:

• 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, Baton Rouge, LA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements.
• 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.
• Identified and compiled common business terms for the new health care system that become central part of communication among project stakeholders to avoid ambiguity
• 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