PROFESSIONAL SUMMARY:

• Around 11+ Years of experience in the IT industry strong experience in Data warehousing, Data Modeling, ETL and BI tools.
• Good exposure to Oracle, DB2, MS - SQL, Netezza and Teradata databases.
• Ability to rapidly learn new concepts together with excellent interpersonal skills.
• Team and independent player with good communication, organizational and interpersonal skills.
• Performed multiple roles as a developer, modeler and database administrator.
• Hands on experience in Teradata FsLDM Data Models in banking domain.
• Hands on experience in Banking, Healthcare and Retail domain.
• Vast Experience in Data Modeling Tool, ‘CA ERwin Data Modeling Suit r7 and r9’.
• Expertise in BI technologies with AS/RPM and have hands on experience in MSTR and Tableau.
• Expertise in creating Conceptual, Logical and Physical Data Model.
• Have worked extensively in OLAP Dimensional Modeling.
• Expertise in creating and delivering Artifacts.
• Expertise in understanding the requirements of Data Elements from Business Analyst / Business and create an effective Data Model.
• Expertise in maintaining versions of Data Models and keep track of the changes made to the Data Model.
• Expertise in creating Normalized Logical Data Model and De-normalized Physical Data Model.
• Expertise in creating and maintaining the Naming Standard document to create the Physical Data Model.
• Extensive Knowledge in modifying the existing Data Models and manage the change history.
• Well acquainted with the Software Development Life Cycle (SDLC).
• Extensively worked on INFORMATICA Tools: Designer, Workflow manager and Workflow Monitor.
• Extensively worked on DATASTAGE Tools: Designer, Manager and Server Jobs.
• Proficient in the Design and Development of process required to Extract, Transform and Load (ETL) data into an integrated Data warehouse.
• Extensive experience in extraction, transformation and loading of data directly from heterogeneous source systems like flat files, Oracle, DB2.

TECHNICAL EXPERTISE:

ETL Tools: DataStage 8.1, Informatica 7.x

BI Tools: MSTR, AS/RPM

Operating Systems: Windows NT/2000/XP/Vista/7, UNIX

Databases: Oracle 9i/10g/11i, DB2, Netezza, Teradata

Data Modeling Tools: CA Erwin Data Modeling Suit

Languages: SQL

Tools: Used:: DB Vizualizer, Sql Developer, Designer, Director, Administrator, Information Server Manager and CDC Management Console.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior Data Modeler

Environment: ErWin 9.5, Oracle

Responsibilities:

• Participate in requirements analysis and meetings with Business team to understand the source module.
• Conducted one on one sessions with business users to gather data warehouse requirements.
• Determine optimal design strategy to implement requirements.
• The source data has been split into multiple Subject Areas as per the modules. For each module Conceptual, Logical and Physical data model is designed.
• Data analysis is done prior to the design of the data model. Each module data is analyzed and then design strategy is created.
• Develop Conceptual Data Model, Logical Data Model and Physical Data Model using ErWIN tool. Create standard abbreviation document for Logical and Physical Data Models.
• Generate SQL scripts DDL from the data models and coordinate with DBA’s to implement the database.
• Document Logical and Physical Data Models, i.e. Create Data Dictionaries by generating reports from data model.
• Created the Reverse Engineered model of the source.
• Develop and maintain the Data Transform Specification / design documents for developers and conduct session with the developers to walkthrough the model.
• Document Logical and Physical Data Models for future .
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards for data warehouse
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• 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

Confidential

Senior Technical Lead

Environment: Teradata, ErWin 9.0, MSTR.

Responsibilities:

• Participate in requirements analysis and meetings with Business team.
• Conducted one on one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in details with the project stakeholders by conducting Joint Requirements development sessions.
• Determine optimal design strategy to implement requirements.
• Develop Conceptual Data Model, Logical Data Model and Physical Data Model using ErWIN tool. Create standard abbreviation document for Logical and Physical Data Models.
• Generate SQL scripts for DDL from the data models and coordinate with DBA’s to implement the database. Work with Senior Data Architects to have the Data model reviewed and approved before being published for the developers.
• Document Logical and Physical Data Models, i.e. Create Data Dictionaries by generating reports from data model.
• Work with Senior Architects and SMEs to examine the data available in an existing data source, understand anomalies, and understand complex business logics that require one-to-many and many-to-one transformation rules.
• Develop and maintain the Data Transform Specification / design documents for developers and conduct session with the developers to walkthrough the model.
• Document Logical and Physical Data Models for future .
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• 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 Teradata Server database systems.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• 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

Confidential

Lead Engineer

Environment: AS/RPM (Analytic Server/Real-time Performance Management), MSTR, Windows Servers.

Responsibilities:

• Participate in requirements analysis and story boarding sessions in an Agile team.
• Determine optimal design strategy to implement requirements.
• Provide timing and sizing estimates to implement recommended design.
• Created dimensional model for the reporting system by identifying required dimensions and facts using AS/RPM.
• Gather the various reporting requirement from the business analysts.
• 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.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• 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.
• Worked closely with the ETL Informatica Developers to explain the complex Data Transformation using Logic.
• Conduct performance tests on implemented solution.
• Responsible for overall project related tasks like Resource Loading, Resource mentoring, Assigning task and monitoring the task status.

Confidential

Senior Data Analyst

Environment: ErWIN 7.3,ErWIN 8.

Responsibilities:

• Worked as Senior Data Analyst for the Trade Project under MaxCV Data Supply Chain Program since last six months and have gained Subject matter with the Detail Trade domain of the application.
• Work with Business Analysts, Senior Data Architects, SMEs and Business partners to understand the Business requirements, Use cases. Translate the Business requirements into Technical Specifications and Data Models (Logical and Physical).
• Prepare the Conceptual Data Model, Logical Data Model and Physical Data Model using the third party tool - CA Erwin v7.2. Create standard abbreviation document for Logical and Physical Data Models.
• Generate SQL scripts for DDL from the data models and coordinate with DBA’s to implement the database. Closely work with Senior Data Architects at onsite to create efficient database design by normalizing the Logical Data Model design by illustrating all subtyping & super typing and also resolve many-to-many relationships. Create de-normalized Physical Data Model design to improve the query performance and also ensure that subtypes and super types in the logical model must be eliminated in the physical model, typically by either rolling up the subtypes to the super type or rolling down the super type to the subtypes.
• Work with Senior Data Architects to have the Data model reviewed and approved before being published for the developers.
• Document Logical and Physical Data Models, i.e. Create Data Dictionaries by generating reports from data model.
• Work with Senior Architects and SMEs to examine the data available in an existing data source, understand anomalies, and understand complex business logics that require one-to-many and many-to-one transformation rules.
• Develop and maintain the Data Transform Specification using D&B’s proprietary tool - Data Transformation Specification Toolkit and 3rd Party tool - MapForce.
• Work with Senior Architects to have the Data Transformation specifications reviewed and approved before being published for the developers.
• Analyze and understand the complex data algorithms, Data Types and Relationships Play the role of Technical Data Stewardship and responsible for mapping data.
• Create and maintain the Business Definition Layouts (BDL) using D&B’s Proprietary tool - BDL Toolkit. Document and maintain GSRL8 BDL - D&B’s standard (canonical) structure for transporting inventory data, the data D&B collects.
• Provide expertise in data management. Conduct peer reviews; conform to D&B standards and practices. Document changes, maintain artifacts and get signoffs.
• Provide reviews and walkthrough on all deliverables during different phases of the development activities.
• Review Business requirement documents, use cases in coordination with Business Analysts and Subject matter experts. Work closely with Senior Data Architects and Subject Matter experts to perform Data Analysis and Functional Analysis of the data elements required in the Data Models.
• Prepare the Conceptual Data Model, Logical Data Model and Physical Data Model using the third party tool - CA Erwin v7.2.4, r8. Create standard abbreviation document for Logical, Physical and Dimensional Data Models.

Confidential

Designer / Lead

Environment: DataStage 8.1, Oracle, ErWIN 7.3, DB2 & Flat Files.

Responsibilities:

• Source systems have been analyzed mainly Confidential for domestic core banking business.
• Mapped SBI domestic core banking tables, trade finance tables and foreign offices tables to Teradata's FSLDM integrated data model.
• ETL instructions with appropriate Data Stage stages to be used.
• Designing Operational Data Store (ODS) Logical and Physical Model.
• Generation of DB2 Physical Model of ODS with appropriate distribution and partition keys.
• Designing Enterprise Data Warehouse (EDW) Logical and Physical Model.
• Generation of DB2 Physical Model of EDW with appropriate distribution and partition keys.
• Designing Data Mart Logical and Physical model and the generation of the DB2 Physical Model of the same with appropriate distribution and partition keys.
• Designing the tables for EDW and loading the appropriate data into them.
• Tested the loaded data in the EDW for the integrity and for the given business logic.
• Have helped the ETL developers to load the data properly according to the design specifications into the EDW.
• Worked with the Reports team in optimizing the queries.
• Used the ErWIN 7.3 tool extensively.
• Extensively used Processing Stages- Join, Funnel, Filter, Aggregator, Sort, Pivot Enterprise, Transformer and Lookup. File Stages- Dataset, Sequential File. Database Stages-Oracle Connector, DB2 Connector, ODBC Enterprise, DB2 Bulk Loader Stage and Parameter Set.
• Preparation and Execution of unit test cases.
• Worked with DataStage Director to schedule, monitor, analyze performance of individual stages and run DataStage jobs.
• Involved to implement the initial and incremental loading of the data.
• Performed Tuning of DataStage Jobs for better performance.
• Created source to target mappings as per ETL specifications
• Develop ETL POC jobs and assigning the implementation task to the team.
• Configuring Oracle/DB2 databases either through native or ODBC connections to DataStage.