PROFESSIONAL SUMMARY:

• 7+ years of professional experience as a Data modeler with expert in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERwin and Power Designer.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive experience in Conceptual, Logical and Physical Data Modeling, Comparing and merging, Reverse and Forward Engineering using various data modeling tools like Sybase Power Designer 15.2, Embarcadero ER Studio Data Architect 9.1/9.5, ER Studio Business Architect 1.7, Erwin 7.1 and Toad Data Modeler. Experience in designing conceptual model of COTS (Commercial off - the-shelf) package.
• Have a strong exposure and experience on Service Oriented Architecture (SOA) and object oriented methodologies.
• Developed Enterprise Canonical Data Model for messaging structure to support Master Data Management.
• Performed data analysis on source data to be transferred into an MDM structure. This analysis involved aspects of data profiling, reconciliation, quality assessment, and data definition.
• Worked extensively using TOAD, SQL*Plus, PL/SQL Developer and UNIX utilities.
• Strong experience in requirements gathering, analyzing business processes and requirements, creating ETL interface specification and technical design documents with led facilitated workshops and Joint Application Development (JAD) sessions to refine requirements.
• Experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Efficient in data mart design and creation of cubes using dimensional data modeling with hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Extensively worked with complex SQL queries, PL/SQL Stored Procedures, Functions and Packages using TOAD and SQL*Plus.
• Experience with Object Oriented Analysis and Design (OOAD) using UML, Rational Rose and MS Visio with proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Worked with various RDBMS like Oracle, SQL Server, DB2 UDB, and Teradata with expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS), and Informatica.
• Highly experienced in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions with expertise in automation of SAS processes, models and reports using SAS tools.
• Responsible for Data Validation, Data Mining, Data Analysis, ETL process analysis, ETL process implementation, Testing task delegation and management, and Test environment setup.
• Extensive experience in gathering requirements, gap analysis, design, development, testing and implementation of the OBIEE / ETL / Data warehouse projects.
• Designed an ETL process to load the XML file from source to target using XSD, SQL LOADER, PL/SQL Package and shell script with also worked on Data Modeling, E-R diagrams, Logical, Physical design, Star/Snow flake Schemas using Erwin.
• Analyzed Teradata data from sources such as Google analytics and used map-reduce algorithms to analyze textual data with extensive experience in numerous Data warehouse, Data mart, Client-Server Applications.
• Extensive experience in Business Analysis with excellent knowledge to the full Software Development Life Cycle (SDLC) methodologies and processes. Experienced in managing requirements from project inception through release.
• Design and implement data mapping and conversion/migration procedures using Transact-SQL, SSIS (DTS), PL/SQL and Unix shell scripts. Maintained Informatica and SSIS (DTS) based ETL architectures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse.
• Highly Skilled in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica/Business Data Director.
• Very experienced in the development of data integration and ETL processes, including schema design, data mapping, data extraction, data cleansing, interfacing with third-party software interfaces, email notification, and SQL development for databases (MS SQL Server, Oracle, Sybase,Terra-data, and MS Access).
• Deep understanding of enterprise data warehouses and also worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin 7.2.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.Possess strong ER Modeling and Dimensional Modeling skills for OLAP, OLTP, Enterprise Data Management (EDM), DSS, ODS using various databases like Oracle 10g/9i/8i, SQL Server 7/2000 and MS Access 97/2000/2002, very good knowledge of Teradata V2R5/V2R6. Experienced in configuration management.
• Expertise in modeling using case tools like Erwin, Power Designer, MS Visio, ER/Studio, development of PL/SQL, Functions, Stored Procedures, Triggers and ActiveX Scripts.
• Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects with also extensively worked Data Governance, i.e. Meta data management, Master data Management, Data Quality, Data Security.

TECHNICAL SKILLS:

• Microsoft Analysis Services
• Business Objects and Crystal Reports9 . Microsoft DTS/SSIS
• SSRS
• Data Stage 7.5
• Ab Initio and Informatica 7.1.3.SQL
• PL/SQL
• Base SAS
• HTML
• XML
• VB.NET
• C
• C++
• Erwin r 7.1/7.2/8.0/9.5
• Power Designer
• Clear quest
• TOAD
• Rational Rose
• MS Visio
• ER Studio
• Oracle BPA
• SA - System Architect
• Embarcadero ER/Studio and Oracle Designer
• OBIEE. AGILE SCRUM
• Waterfall
• Spiral
• Rational Unified Process (RUP)
• V-Model and Iterative waterfall
• UNIX and Shell Scripting.Microsoft SQL Server / 2005/2008/2011
• MySQL
• Oracle 11g/10g/9i/8i
• DB2
• Teradata 13
• MS Access 2011 and Teradata V2R6.1.Microsoft Office Suite
• Microsoft Project 2010
• SAP and Microsoft VisioMicrosoft Windows 9x/NT/2000/XP/Vista/7 and UNIX
• SAS9.0

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Data Modeler

Responsibilities:

• Developed, enhanced and maintained Snow Flakes and Star Schemas within data warehouse and data mart conceptual & logical data models with also analyzed and designed XML Schema Definition (XSD) data objects in XML Spy to standardize MDM.
• Performed Business Analysis and Requirements Gathering from high-end users and managers with designed data models based on business case documents provided by client and also developed / Reviewed conceptual, logical and physical data models using ER Studio.
• Involved in the extraction, transformation and loading of the source data to the target Teradata database.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Writing Complex SQL queries, SAS Base, SAS SQL and QlikView Business Intelligence Software to mine/extract data for the purpose of report-making and designing the report with also used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database.
• Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Experience in exploratory data analysis and data mining process of large, complex data.
• Analyzed data which included investigation and analysis, documentation, filtering of bad data through generation of crystal reports with designed 3rd normal form target data model and mapped to logical model with also created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE. worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Responsible for the collection of functional requirements, non functional requirements, data mapping, and light data modeling.
• Prepare high level business process modeling through data mining and data visualization
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design with used SAS/SQL to extract data from different databases and joining tables.
• Analyzed business requirements and translated them into detailed conceptual data models, process models, logical models, physical models and entity relationship diagrams. Gathered enterprise level data requi rements.
• Using Excel pivot tables to manipulate large amounts of data in order to perform data analysis, position involved extensive routine operational reporting and data manipulation.
• Responsible to create Canonical Data Model for loosely coupled systems that use different notations for the transaction codes.
• Coordinated project planning in Agile environment, development, team building, process improvement, BRD documentation
• Identify and pursue warranty claim remediation with various airline suppliers.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Extensively used Data Null to create macros, customized reports, reports on external files and debugging SAS codes with also using Erwin, designed Logical and Physical data model/meta data /data dictionary for business users and development team.
• Data modeling and data analysis with Teradata, Oracle, SQL Server, using Erwin for OLTP, ODS, EDW.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Created Data bases, table spaces, buffer pools in Power designer to create physical tables on the data base.
• Work closely with the DBA team to translate the model(s) from logical design to physical implementation.
• Design the Canonical model for the Financials domain of the Enterprise model with also creating Data Architecture Models, Entity Relationship Models (ERD) and Data Flow Diagrams (DFD) with lead the JAD sessions and project status meetings with the stake holders.
• Worked on Agile methodology for developing and integrating different business units.
• Set direction and analysis approach as well as maintain task assignments and report statuses to management as the Lead Data Modeler on new critical corporate initiatives with minimal or no management oversight.
• Analyzed the existing structures, ETL, database objects, Server infrastructure for the EDW and Data mart and then created system stabilization tasks to improve the data quality, avoid ETL failures and improve performance.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Design envelops canonical structure to enable integration across applications.
• Proficient in documenting business requirements, business use cases, application use case and system requirements specifications for both in-house systems and COTS products. Possess strong Enterprise Architectural skills with specialization in Enterprise Data Modeling, Enterprise Business Process Modeling, Enterprise State Event Modeling and Enterprise Canonical Message Schema Creation.
• Determined requirements, maintained legacy systems; led JAD sessions, developed conceptual and logical data.
• Conduct source data analysis of various data sources and develop source-to-target mappings with business rules.
• Execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System
• Architectural analysis of the data models and data analysis for the several source systems to populate the new canonical databases and the new dimensional EDM database.
• Perform logical and physical data structure designs and DDL generation to facilitate the implementation of database tables and columns out to the DB2, SQL Server, and Oracle DB schema environment using CA ERwin Data Modeler Release 7.3.

Confidential, OH

Data Modeler

Responsibilities:

• Performed data analysis and reverse engineering of data with provided data modeling support to the Marketing operations design team and also developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging area Data Models and Data Flow Diagrams.
• Involved in Data Migration from MS SQL server, Oracle, PeopleSoft, My SQL and Progress SQL to Teradata.
• Developed, integrated, managed and promoted enterprise level logical and physical data models and data model standards that source data from multiple origins (internal data sources, external data sources, third party data.
• Developed detailed mapping documents that will provide the reporting and data warehouse team with source to target data mapping includes logical names, physical names, data types, corporate meta-data definitions, and translation rules.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database.
• Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Developed Table Reports, Pivot Reports, Chart reports, Dashboards and Chart Reports from Pivot reports - vice versa and also worked with an architect to design target environment data structures, design source to target data mapping, and design logical and physical data models.
• Expertise in writing and collecting business requirements (BRD), technical report writing, test plans, project need assessments, organizational strategic vision, implementing contingency plans and improved performance goals in Agile Methodology.
• Developed relational model design, dimensional modeling, and ETL process in Data Warehouse (DWH) environment.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository with also aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users.
• Created Agile process flows, guides, and cheat sheets to support the conversion from Waterfall to Agile/SCRUM.
• Performed the logical data modeling necessary to produce the target data model, rationalized and integrated across subject areas, which formed the foundation for Data Warehouse initiatives with also creates test scenarios and test data to support both quality assurance and user acceptance testing.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Capture business requirements and rules, design the associated logical models, and create all required documentation to support, communicate, and validate the data model with also created design documents including metadata samples, use cases and data flows to facilitate the development group usage of the subject area.
• Analyzed several marketing programs using data analysis and mining, data integration and effectively built predictive statistical models
• Created database triggers, functions, procedures, cursors and packages also developed PL/SQL scripts to validate and load data into interface tables with extensively used Stored Procedures for handling the database operations.
• Educated users for data quality and metadata management and mentored targeted power users in BI with also participated in the business, information, and user interface requirements, participated in facilitating joint application development (JAD) sessions, designed logical and physical data model (dimensional modeling) utilizing ERWin CASE Tool and created the star schema.
• Develop, implement, and maintain OLTP and data warehouse data models. Increase the use of data modeling in development organizations with also assisted in data modeling JAD sessions with subject matter experts and the creation of the conceptual data models based on these sessions.

Confidential, OH

Data Modeler

Responsibilities:

• Designed Conceptual and Logical data models for MDM Provider and Member domains and reverse Engineering models from Databases, files, External metadata using ER Studio with maintained Physical models and created DB objects with the help of DBA.
• Worked closely with the Application development Team to Implement Security Master Data Management Solution using Informatica.
• Developed a template to provide estimate by the Modeling Process Steps to the management.
• Developed Work Flow Process to manage and track the issues raised by consumers to track and resolve the issues against the Enterprise Logical Model.
• Contributed to develop the Data Model Release process flow to provide transparency & visibility to the Management/Consumers.
• Implemented agile methodology for running the whole product life cycle in project.
• Developed small applications with Teradata at the backend.
• Supported the Data Governance activities by running the Compliance report on Application Models
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Performed data analysis based on the business logic in business Intelligence database coming from the various front end ERP applications through Informatica mappings.
• Created Enterprise Design Patterns which can be used as guidelines across the enterprise.
• Automated load run on Informatica sessions through UNIX Corn, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures with successful notification through email.
• Conducted Work Sessions with Business Architects/Business SME to understand the business requirements.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Designed scripts in SAS to be compatible with Teradata to load and access data from the Teradata tables.
• Worked closely with Application Modelers to customize the project logical models and help them align to Enterprise Model
• Created business requirements for a web based employee time tracking application using Agile user stories
• Involved in the full life cycle of project through design, development and maintenance of an enterprise data warehouse repository.
• Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.
• Data modeling and data analysis with Teradata, Oracle, SQL Server, using Erwin for OLTP, ODS, EDW.
• Worked with Subject Matter Experts in assigned areas and Business Users to analyze business processes and develop and document requirements.
• Provided data models and data maps (extract, transform and load analysis) of the data marts and feeder systems in the aggregation effort.
• Coordinated with Informatica ETL developers in providing data mapping and sql queries for bulk data load.
• Designed and developed the Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models and maintained them.
• Additionally participated in overall system design, data modeling, SQL and process design and tuning, UNIX scripting for processing loads, and PL/SQL development.
• Created Data model Diagrams (Physical & Logical), Entity relationship using Erwin.
• Engineered complex ETL processes to load large volumes of data on a daily basis.
• Involved in data quality and standardization processes and all metadata & ETL documentation that support business roles and detailed source to target data mappings.