SUMMARY

• 8+ Years of prevalent IT experience Exceptionally in DataModeling working as an Data Analyst/Data Modelerin Analysis, Design, Data Modeling (Conceptual, Logical and Physical) for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Skilled in gathering business requirements, use cases and requirements analysis.
• Experience in modeling Transactional Databases and DataWarehouses using tools like Erwin, Oracle Designer, Power Designer and ER/Studio.
• Effective knowledge in forward and reverse engineering cases.
• Strong experience with Data Qualityinitiatives (Dataprofiling, improvement, accuracy, completeness, Data integrity, Data Stewardship and Data Governance). ETL Datamapping and validation/testing for Data migration
• Utilized Erwin's forward/reverse engineering tools and target database schemaconversion process.
• Expertise in Normalization to 3NF/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Experience in carrying out Software Development Life Cycle (SDLC) in relational and objectmethodologies.
• Proficient in Normalization/Denormalization techniques in relational/dimensional database environments.
• Excellent working knowledge of XML, DTD and XML Schematechnologies.
• Extensive knowledge in ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and DataWarehousing, OLAP tools.
• Efficient in Dimensional DataModeling for DataMart design, identifying Facts and Dimensions, creation of cubes.
• Skilled knowledge in developing Entity - Relationship diagrams, modeling Transactional Databases and DataWarehouse.
• Involved in design reviews and validation of the finalized datamodels.
• Data Acquisition strategies to extract datafrom different source systems, created data mappingsusing different transformations and executed workflows for dataloads to target systems.
• Expertise in database programming (SQL, PLSQL) MS Access Oracle 10g/9i, XML, DB2, Informix, Teradata, Database tuning and Query optimization.Experience using MapReduce, and "big data" work on Hadoop and other NO SQL platforms.
• Through knowledge in building reports using Crystal Reports and Cognos.
• Excellent problem solving and analytical skills with a proven ability to learn and understand newtechnologies efficiently.
• Effective team worker and can carry out individual tasks to meet the deadlines effectively.

PROFESSIONAL EXPERIENCE

Confidential, Newtown, PA

Senior Data Analyst/Data Modeler

Responsibilities:

• Gained understanding of ICD-9 versus new ICD-10 code sets. Studied and analyzed the ICD conversion information provided by the CMS (Centers for Medicare & Medicaid Services)
• Interpreted the ICD-9 to ICD-10 and reverse translation logic; Fully understand the GEM (cross walk bi-directional) for ICD-10 Dx, and ICD-10 Procedure codes. Facet Data Conversion to other communication servers.
• Established the enterprise HIPAA PMO and the strategic business planning approach for Privacy Rule, EDI, and Security Rule assessment and remediation. Designed the flow of feeds into the Database and then into CMS and finally to Users
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Assisted the development team with the design and implementation of the ICD-9 to ICD-10 GEM crosswalk tool. Executed manual test cases to confirm the logic was implemented as desired.
• Performed data profiling in the source systems that are required.
• Participated in weekly meetings and walkthroughs for project updates to detect bottlenecks and devised a plan to handle the bottlenecks. Involved in writing SQL queries to extract the data from Oracle database.
• Worked on key critical systems interfaces & testing (Lab /Radiology /Dictaphone /demographics /scheduling, Dragon), X12 EDI version 4010 transactions claims testing, post go-live audits, training, and master file builds.
• Accomplished projects and design documents on HIPAA 835 and 837 calculations and EDI transactions, Health Statements and Explanation of Benefits, Healthcare Reform and 5010 CMS occurrence and field expansion for 835 and 837 EDI formats. Coordinated the upgrade of Transaction Sets 837P, 835 and 834 to HIPAA compliance.
• Main resource for EHR applications and systems within HIM Department. Responsible for testing and rollout of new versions/upgrades and builds on EHR system to gain efficiencies.
• Used Normalization (1NF, 2NF&3NF) and De-normalization techniques for effective performance in OLTP and OLAP systems.Developed Logical Data Model with the help of Data Architect.
• Created both High level and detailed Data Profiling designs in IDQ based on the dimensions of Data Quality.
• Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams (SSIS, SSAS).
• Understood complete claims processing cycle from the payer/provider perspective and the processes impacted by the conversion to ICD-10. Involved in claim adjudication process of facets application.
• Used Erwin, Created Conceptual, Logical and Physical datamodels.
• Used forward engineering to create a Physical DataModel with DDL that best suits the requirements from the Logical DataModel.
• Analyzed functional and non-functional categorized dataelements for data profiling and mapping from source to target data environment.
• Coordinated the secure feed into a Medicity / Novo HIE product, unit testing, integration testing, obtained signoffs from business users & HIM (lab, transcription). Did gap analysis and impact analysis for the facets up gradation system.
• Developed, enhanced and maintained Snow Flakes and Star Schemas within datawarehouse and datamart conceptual & logical datamodels with also analyzed and designed XML Schema Definition (XSD) dataobjects in XMLSpy to standardize MDM.
• Analyzed ICD-10 project readiness and recommended best practices for ICD-10 transition based on research conducted.
• Worked with the team to create a project road map/blueprint ensuring effective remediation of all applications that participate in the ICD-10 transactions.
• Validated XML Schema for system data documentation including the data requirement document.
• Analysis and Design of existing transaction sets, and modification of these transaction sets to ensure HIPAA compliance.
• Conducted gap and impact analysis, strategic design of the solution, and implemented X12 EDI version 4010 Transactions, Code Sets, and Identifiers. Did gap analysis between ICD 9 and ICD 10.
• Did gap analysis for HIPAA 4010 837P and 835 transactions and HIPAA 5010 837P and 835 transactions.
• Worked on developing the business requirements and use cases for Facets batch processes; automating the billing entity and commission process.

Confidential, Southfield, MI

enior Data Analyst /Data Modeler

Responsibilities:

• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Worked withData Stewards and subject matter experts to research reporteddata anomalies, identified root causes, and determined appropriate solutions.
• Worked with datasource systems and Client systems to identify dataissues, data gaps, identified and recommended solutions.Worked in defining conceptualData Models and logicalData Models.
• Involved in development and maintenance work on DataModels, DataDictionaries, event models, CRUD matrix, and other artifacts to maintain currency with corporate standards. Retrieved appropriatedata from the web analytics tool.
• Conducted and performedData Modeling exercises in support of subject areas and/or specific client needs for data, reports, or analyses, with a concern towards reuse of existingdata elements.
• Worked with relational database models and XMLschemas to create technical/system design documents, and developed crystal reports. Worked ondata quality, dataprofiling, datawarehousing, datamodeling and ETL scripts.
• Compiled output either from theData Warehouse and the web analytics tool. Develop reports on Excel and Tableau.
• Wrote MySQL queries from scratch and created views on MySQL for Tableau.
• Created data transformations from internal and third party data sources into data suitable for handheld devices, including XLST, XQuery, XPath.
• Worked on web metrics (e.g. Visits, Bounce Rates, Page Views, Impressions, Clicks, CTR, CPC, etc.).
• Understood business processes, dataentities, dataproducers, and datadependencies.
• Developed, managed and validated existing datamodels including logical and physical models of the datawarehouse and source systems utilizing a 3NF model. Knowledge of web analytics and/or experience with business reporting.
• Developed and programmed test scripts to identify and manage data inconsistencies and testing of ETL processes.
• Analysis of functional and non-functional categorizedData elements forData profiling and mapping from source to targetdata environment. Developed working documents to support findings and assign specific tasks.
• Performed and coordinated System testing, Regression testing of various builds during integration, Performance and User acceptance testing using Rational Test. Configure and develop XML Schemausing Stylus Studio XML editor.
• Created datamasking mappings to mask the sensitive databetween production and test environment.
• Created, defined, and maintained datalife-cycle documentation representing data elements across multiple upstream and downstream systems.PerformedData Modeling and dataanalysis as required.
• Proactively communicated and collaborated with external and internal customers to analyze information needs.

Confidential, Dayton, OH

Senior Data Analyst /Data Modeler

Responsibilities:

• Validated datato ensure the quality, validity and accuracy of content.
• Worked with datainvestigation, discovery and mapping tools to scan every single datarecord from many sources.
• Experienced inData Integration, metadata management, ETL,Data Modeling tool sets.
• Implementing logical and physical datamodeling with STAR schema using Erwin in DataMart.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.Assisted SQL Server Reporting Services (SSRS) and SSAS team for generation of reports and data mining.
• Worked withdata investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed datamining on hugedata using very complex SQL queries and discovered claims pattern.
• Used Erwin and Visio to create 3NF and dimensional datamodels and published to the business users and ETL / BI teams.
• Created the static mock-up UI screen using Axure and helped the UI/UX team create the dynamic prototype. Coordinated with the developers to create the input and output XML Schema.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Datafrom various heterogeneousdata sources.Created DML code and statements for underlying & impacting databases.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.). Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Involved in project cycle plan for the source XML dataextraction process, dataanalysis, transformation and ETL loading strategy designing.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.Createddata masking mappings to mask the sensitivedata between production and test environment.
• Created SQL scripts to find dataquality issues and to identify keys, dataanomalies, and data validation issues.
• Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked withdata quality issues.
• Data mapping, logical datamodeling, created class diagrams and ER diagrams and used SQLqueries to filterdata within the Oracle database.Worked withdata analysis,data modeling and creatingdata models.

Confidential, Detroit, MI

Data Modeler/Database Analyst

Responsibilities:

• Worked as a Data Modeler for building the IDW (Integrated Data Warehouse). Involved designing the data warehouse and to develop data mart for improving marketing strategies and report generation.
• Liaised withbusinessAnalystandBusinessusers in gatheringbusinessrequirements.
• Design Data Models both Conceptual, Logical and then transform to Physical data model and developing the ERD using Erwin.
• Normalize data to 3NF and developing databaseschemain more efficient manner.
• Performed Forward Engineering data models forSchemageneration, Reverse Engineered on the Existing Data Models to accommodate new requirements.
• Involved in ETL(Extraction, Transformation, Load) Process.
• Creating Functional design document, developed detailed mapping document to provide reporting and data warehouse team with Source to Target mapping includes logical name, Physical name, data types, corporate metadata definitions and translation rules.
• Design and develop the Data dictionary and Metadata of the models and maintain them.
• Involved with the team to perform Data Profiling to ensure superior date quality.
• Designed Data Staging Area and Data Warehouse to integrate the data from various sources including Flat Files to facilitate management to make more fact based decisions.
• Involved in creating database objects like Tables, Views, Materialized Views, Triggers, Functions, Indexes etc.,
• Involved in tuning and performance enhancement.
• Performed analysis to detect and debug production data issues
• Conducted Learning sessions forbusinessusers,analysts, QA team to provide insight into data model and providing documentations.