SUMMARY

• Expert in building Transactional, Dimension Data Modeling and ETL.
• Experience in various domains like Health care, Hospitality, Insurance, Pharmaceutical, Financial and Banking.
• Expert in gathering, analyzing the business requirements and creating Business Requirement Document (BRD), Technical Specification Document.
• Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experience in modeling OLTP and OLAP using tools like E - R Studio 10.0/11.0/2016 , Erwin r8/r7.1/7.2 and Sybase Power designer 12.1.
• Well versed in Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments.
• Expert in using Agile Data Modeling methodologies.
• Proficient in Software Development Life Cycle (SDLC), Project management methodologies and Microsoft SQL server database management.
• Experience in dealing with different data sources ranging from flat files, Excel, SQL server, Oracle, Sybase, and Teradata.
• Experience in data cleansing, data transformation and data mapping from source to target database.
• Well versed with Data-Extraction, Transformation, Loading (ETL) techniques. Experience with ETL Tools like SSIS, Informatica and leading the Informatica developers.
• Extensive experience in development of T-SQL, DTS, stored Procedures, triggers, functions, packages, performance tuning and optimization for business logic implementation.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.

TECHNICAL SKILLS

• ER Studio 11.0/2016
• Erwin r9.6/r9.5/r8.2/r8.0/r7.3
• Microsoft DTS/SSIS
• SSRS 2016
• Power-BI
• Business Objects
• Crystal Reports 9
• Microsoft SQL Server 2000/ 2008/ 2012/ 2014/2016
• Teradata
• Oracle 10g/11g
• SQL, T-SQL
• Informatica 7.1.3
• MS Access
• Microsoft Office 2010
• Microsoft Project 2010
• Microsoft Visio
• Share point Portal Server
• Base SAS and SAS/SQL
• HTML, XML, VB.NET
• Linux, UNIX, Windows 7/8/10/10.1

PROFESSIONAL EXPERIENCE

Data Modeler/ ETL Developer

Confidential, Lexington, KY

• Worked in Agile methodology and used Team Server Foundation (TFS).
• Developed, documented Data Modeling standards to establish in the organization.
• Developed, documented Naming Standards for naming conventions and established in organization.
• Worked with business analyst to understand the business and gather the requirements.
• Worked with Information Architect and developers to understand the current systems.
• Worked on ER Studio 11/16 for Conceptual, logical, physical data modeling and for generation of DDL scripts.
• Performed Reverse Engineering on existing databases in SQL Server 2014.
• Identified Gaps for each database and documented them.
• Participated in discussions and identified the solutions for each database and documented them.
• Fulfilled the Gaps and generated DDL script for the database.
• Worked on C# .net to verify the application code using Tables, Columns and Stored Procedures.
• Created Data Marts, identified various facts and dimensions.
• Designed and developed SSIS packages in migrating data and replaced code services.
• Designed and Developed
• Developed template for change request documents, mapping documents, gap documents and naming standards.
• Developed Logical and Physical data models for new requirements.
• Gathered definitions from developers and generated Data Dictionaries.
• Created and maintained Meta data throughout the databases and warehouse.
• Worked and maintained ER Studio Team Server to establish the models and reports.
• Created ER Studio Detail document for usage and settings to use it throughout the organization.
• Worked as data modeling committee member to make sure the developers understand and follow data modeling concepts.

Environment: ER Studio Data Architect 11.0/2016, Embarcadero Team Server, SQL Server 2014, Azure, Visual Studio SSIS 2012, Power-BI, MS Office 2013, SharePoint, Team Server Foundation.

Data Modeler

Confidential, Baltimore, MD

• Conducted meetings with the business users to gather the requirement for reporting.
• Designed Data Flow Architecture from multiple sources to Data Mart.
• Built Data Mart for Corporate section on HR Data for Reporting purpose.
• Developed Logical and Physical dimensional data models using Erwin9.6.
• Worked on Human Resources Data (HR) which is relying on people soft.
• Mapped fields from different data sources to the target Data Mart using excel spread sheets.
• Designed the data mart model using Star schema for reporting purpose.
• Worked in agile methodology in Team Foundation Server (TFS).
• Testing the data after loading it to the Data Mart using SQL.
• Provided Mapping Document to ETL team for transformations and loading.
• Reverse Engineered old legacy database using Erwin9.6.
• Identified the entities, attributes, relationships and redesigned the relational model to the new environment.

Environment: Erwin9.6, SQL Server Management Studio- 2008/2012/2014 , MS-Visio, MS-Excel, MS-Power Point.

Data Modeler

Confidential, Orlando, FL

• Involved in Dimensional modeling for Integrated Area.
• Involved in business meetings for requirements.
• Involved in meetings over Dimension modeling.
• Worked in Agile System.
• Worked on identifying Facts from Existing relational Models and sub Models.
• Worked on identifying Dimension tables from the existing models of data marts.
• Using ER Studio had designed the data mart using the Ralph Kimball’s Dimensional Data Mart modeling methodology.
• Also Designed different type of STAR schemas like detailed data marts using ER studio with various Dimensions and various FACT Tables for different subject areas.
• Worked in OLTP and OLAP environments.
• Conversion of filing system from API’s to XSD’s.

Environment: ER Studio11.0, Teradata, Oracle 11g, MS Excel.

Data Analyst

Confidential, Chattanooga, TN

• Involved in Mapping from source to target using excel spreadsheets.
• Worked on writing code in SQL for cleansing of data from the database.
• Worked on MDM 11.0 on requirements mapping and loading.
• Interacted with the client for the requirements on MDM.
• Worked on Teradata databases in profiling the data from the production tables from different sources.
• Involved in column profiling of the tables using Informatica Analyst Tool (IDQ).
• Analyzing the requirements for profiling from MDM.
• Developed XML mapping for ETL team for the transformation and loading.
• Analyzing the suspects in MDM while loading the data.
• Defining the code values and making changes according to values in mapping and explaining it to ETL team for the transformation rules.
• Worked on DB2 in testing the data after loading from Teradata.

Environment: MDM11.0, Teradata, MS Excel, IBM DB2, Informatica Data Quality.

Data Modeler/Analyst

Confidential, Spring Field, IL

• Developed a Conceptual model using Erwin based on requirements analysis.
• Produced functional decomposition diagrams and defined logical data model.
• Designed a logical and physical data model using database tool Erwin r8.0.
• Used forward engineering to create DDL from Physical Data Model, based on the requirements from the Logical Data Model.
• Conducted team meetings and Joint Application Design (JAD) session.
• Involved in implementing data warehouse along with architects and data governance teams and consulted the team on the design issues and implementations.
• Conducting the meetings with business users to gather data warehouse requirements.
• Interacted with the Business Analyst, QA team in their testing and DBA’s.
• 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.
• Designed multiple facts and dimensions and implemented data marts.
• Identified and tracked the slowly changing dimensions (SCD I and II) and determined the hierarchies in dimensions.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Gathering requirements form the client for MDM 9.5.
• Involved in Data Mapping activities for the MDM 9.5.
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Handled performance requirements for databases in OLTP and OLAP models.
• Used SAS/Interface to Teradata to extract data from Teradata and also used SAS/SQL pass through facility.
• Reverse engineered from Toad database to Erwin and generated SQL script through forward engineer in Erwin.

Environment: ERWIN, Oracle 11g, Teradata 13, SQL server 2008, SSIS, SSRS, MS Excel, Toad for MySQL 6.3

Data Modeler

Confidential , Minneapolis, MN

• Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing system.
• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards. Conducted Design discussions to come out with the appropriate Data Mart.
• Defined and processed the facts, dimensions. Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling methodology using ER Studio.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using ER studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Involved in the integration of data coming from different sources.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts to Teradata data warehouse.
• Mapped the data between Source and Targets.
• Created data model for the star schema using ER studio, created DDL scripts for static dimensions.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data Imported millions of records from .CSV files .TXT files using SQL * LOADER and Test Importer

Environment: Oracle 9i/10g, SQL, ER Studio, Teradata, HTML, TOAD, SQL * LOADER, MS OFFICE.

Data Modeler/Analyst

Confidential, Omaha, NE

• Built an Operational Data Store (ODS) for transactional system.
• Created Audit Balance Control (ABC) data model, which helps ETL developers to keep track of records from source to target.
• Provided Data quality reports to ETL developers.
• Involved in designing Golden records model, which is used for master data management.
• Created Conceptual, Logical, and Physical data models for operational data store.
• Reviewed Business Case Documents and Business Information Models in detail with Business Analysts, and created all created the data models based on these Business Information models.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models using Erwin - Forward/Reverse Engineer Databases. Performed the roles of data analyst & data modeler.
• Verify data model/schema designs against the business requirements.
• Performed highly complex data analysis for a business intelligence solution.
• Created Source to Target mappings for moving data from one platform to the other.
• Gathered Business Requirements & Business Process Analysis (User & Source Driven); Developed Use Cases; Performed the roles of data analyst & data modeler
• Created Data Flow diagrams for better understanding of data flow within the applications.
• Created Business Information Models.
• Reviewed Data Models with Business and Systems Analysts.

Environment: Erwin 8.2.5, Tortoise SVN, Toad Data Analyst, Oracle SQL developer, MS Visio, MS Excel.

Data Analyst/Data Modeler

Confidential, Denver, CO 

• Worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Analyzed and evaluated existing system for assessing how it supported functions
• Implemented Referential Integrity using primary key and foreign key relationships.
• Involved in Dimensional modeling of the Data.
• Identified the Facts and Dimensions.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Produced functional decomposition and logical models into an enterprise data model.
• Employed process and data analysis to model a Customer Information Business System.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Created physical data models using forward engineering.
• Modeled a database to store customer demographic and other data.
• Worked on IBM Netezza MPP Architecture.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• worked on snippet blades, FGPA in the IBM Netezza MPP.
• Developed Logical data model using ERwin.  
• Used Erwin for relational database and dimensional data warehouse designs.
• Involved in Data Mapping.
• Conducted logical data model walkthroughs and validation.
• Conducted team meetings and JAD sessions.
• Helped the DBA in creating the physical database design and QA team in their testing.

Environment: Oracle 10g, Toad, ERWIN, Crystal reports 9, Windows XP, Informatica Power Center, Teradata, DB2.

Data Analyst

Confidential

• Create logical and physical models using best practices to ensure high quality and reduced redundancy
• Optimize and update logical and physical data models to support new and existing data models
• Recommend opportunities for reuse of data models in new environments
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Validate business data objects for accuracy and completeness
• Examine new application design and recommend corrections if required.
• Write SQL code and debug them, unit testing was performed.
• Extensively used star schema methodologies in building and designing the logical data models into dimensional model.
• Written stored procedures and triggers extensively and working very closely with developers, business analysts and end users to generate various audit reports and troubleshoot their query
• problems.
• Provided maintenance and support to customized reports developed in crystal reports.
• Gathered statistics on large reports and redesigned indexes.

ENVIRONMENT: Oracle 10g, DB2, Erwin, Teradata, SQL Server, SQL, Pl/SQL, crystal reports, windows XP, SQL *PLUS.#.NET.