SUMMARY:

• Enthusiastic and result - oriented professional with 10+ years of diverse and progressive experience as a Data Analyst & Data Modeler
• High proficiency in requirement gathering and data modeling including design and support of various applications in OLTP/OLAP, Data Warehousing and ETL environment
• Extensive experience with E-R modeling developing database schemas such Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling
• Used the Ralph Kimball Methodology for Data Warehouse and Data Mart designs.
• Expert experience with Erwin and Infosphere Data Architect and utilizing features such as Forward and Reverse Engineering
• Developed Data dictionary and maintained Metadata for each model.
• Excellent knowledge of waterfall and spiral methodology of software development life cycle (SDLC).
• Experience in understanding the business needs and gathering user requirements by conducting and participating in JAD sessions, interacting with end-users and them on the applications developed for the organization.
• Excellent problem-solving skills using root cause analysis techniques to provide solutions to unique problems

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Data Modeler/Data Analyst

Responsibilities:

• Participated in JAD sessions, gathered information from Business Analysts, end users 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 Modelling.
• Involved in translating business requirements into data requirements.
• Migrated legacy system (Mainframe) to modern database
• Created and maintained Logical Data Model and Physical Data Model for the project, which included documentation of all entities, attributes, data relationships, referential integrity, domains, codes, business rules, glossary terms, etc.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Maintained data model and synchronized it with the changes to the database.
• Involved in the modeling and development of Reporting Data Warehousing System.
• Developed stored procedures and triggers, packages, functions and exceptions using PL/SQL
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: IBM Infosphere Data Architect 9, Netezza 7, IBM DB2 11.1, IBM Data Stage, AWS Lambda and S3, Informatica Data Quality, Oracle 11g, Erwin 8.2

Confidential, Columbus, OH

Sr. Data Modeler/Data Analyst

Responsibilities:

• Facilitated logical JAD sessions to discuss and gather business requirements for all assigned projects. This process included scheduling meetings with the business and application groups, documenting agendas and minutes.
• In data analysis and data dictionary and metadata management - Collaborating with business analysts, ETL developers, data quality analysts and database administrators.
• Designed Order provisioning business processes, target applications architecture and target data model as well as developed relational and dimensional model
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Validated and maintained the enterprise-wide logical data model for Data Staging Area.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements. Verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users.
• Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
• Conducted data profiling, qualities control/auditing to ensure accurate and appropriate use of data.
• Used Data Stage to extract data from relational databases, various file formats. Cleansed and transformed the data before loading it to target database.

Environment: ERWIN 7, 8, Oracle 10g, DB2 10.1, SQL Server 2012, SAP Business Objects Data Services 3.X, Talend

Confidential, Philadelphia, PA

Sr. Data Modeler

Responsibilities:

• Conducted JAD sessions, gathered information from Business Analysts, SQL Developers, end users and stakeholders to determine the requirements or various systems.
• Created and documented the models, data Workflow Diagrams, Sequence Diagrams, Activity Diagrams and field mappings of all existing system.
• Proficient in using ERwin Reverse engineering, Forward engineering and Complete Compare functions to create, updated and resolve issues with existing data models.
• Created and implemented ERwin Naming Standards and Domain in the design of creation of logical and physical data models in accordance with the company’s standards.
• Worked with other Data Modeler, DBAs and Developers in my projects using Microsoft Team Foundation Server to ensure that every aspect of the project is effectively considered and completed and on a timely manner.
• Prepared and presented graphical representation forms of Entity Relationship Diagrams with elicit more information.
• Created and maintained, conceptual, logical and physical data models that defines the information required for management and business intelligence purposes using Erwin Data Modeler.
• Worked with the DBAs and SQL Developers to deploy and maintain the developed physical data models.
• Used Erwin data modeler to design and implement the company’s health care domains
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from the source and SQL Server database systems.

Environment: ER Studio Data Architect, MS SQL Server 2012, 2014, ServiceNow, Sales Force, MS Visio, Microsoft Visual Studio 2012, 2013, Microsoft Team Foundation Server

Confidential, Bridgewater, NJ

Data Analyst/Data Modeler

Responsibilities:

• Attended and participates in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for Staging, Operational Data Store and Data marts applications.
• Performed gap analysis and dependency analysis for current & future systems.
• Designed Star Schema Data Models for Enterprise Data Warehouse using Power Designer.
• Created Mapping documents for Staging, ODS & Data Mart Layers.
• Created and maintained Logical & Physical Data Models for the project. Included documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate Models to process mappings, screen designs, use cases, business object model, and system object model as they evolved and changed.
• Created Model reports including Data Dictionary, Business reports.
• Generated sql scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.

Environment: Power Designer 11, Oracle 11g, Informatica, Toad

Confidential, Bridgewater, NJ

Jr. Data Analyst/Data Modeler

Responsibilities:

• Reviewed functional requirements and use cases to determine the necessary data requirements.
• Participated in creating realistic project plans with detailed tasks and ensuring their timely execution.
• Reversed engineered current system data model and subdivided it into work streams for analysis and generated data source to target mapping documents.
• Created process flows and data flow diagrams of the current and future systems.
• Performed dependency and gap analysis for data structure changes on other downstream applications and impact of new data elements on existing downstream processes.
• Designed and produced logical and physical data models for the financial platform and other in-house applications running on Oracle databases.
• Developed ETL procedures for moving data from source to target systems.
• Worked closely with both functional and technical team on the creation of data models which can seamlessly integrate with existing data structures on multiple Oracle databases integrated by database links.
• Generated Surrogate Key for the dimensions in the fact table for indexed and faster access of data.
• Maintain database standards documents example Naming standards document, Data dictionary to ensure consistency.

Environment: ERWIN 4, 7, MS Visio, Toad, Oracle 10g, PL/SQL, SQL*Plus, Toad, Data Stage