SUMMARY

• 8 years of IT experience in System Analysis, Application Design, Data Modeling, Implementation and Testing of Enterprise Data Warehousing and Database.
• Exposure in overall software development life cycle (SDLC) including requirement gathering, development, testing, deployment, documentation and production support.
• Excellent experience in Data Modeling using Erwin r 9/7.3/4.5/4.1.4/3.5.2 , ER Studio.
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Worked in developing data models which will serve both OLTP and OLAP functionality.
• Very good experience in Integration and design of complex OLTP database models using ER diagrams and handling performance issues of the OLTP databases.
• Studied the existing OLTP systems (3NF models) and created facts and dimensions in data mart.
• Designed databases involving complex views, triggers in Oracle 10g/9i/8i/8, Microsoft Access, DB2, and SQL Server 2012/2008.
• Experience in creating, maintaining and designing database diagrams, setting table relationships and indexes.
• Solid experience in Relational Modeling, Dimensional Modeling, Conceptual, Logical Modeling, Physical Modeling, Star Schema, Snowflakes Schema, ERD(IDEF1X and IE notation) ER Diagrams, Granularity, Cardinality and Database Reengineering.
• Excellent experience in Data analysis, Data migration, Data Cleansing, Transformation, Data import and export using multiple ETL tools like informatica PowerCenter.
• Extensive experience in ETL using Informatica 8.1 power center (Designer, Workflow Manager and Workflow Monitor).
• Experience in Extracting, Transforming and Loading data from spread sheets, database tables and other sources using Microsoft SSIS and Informatica
• Implemented Slowly Changing Dimensions type - I and type-II in dimension tables as per the business requirements.
• Deployed naming standard to the Data Model and followed company standard for Project Documentation.
• Expertise in Normalization techniques for data consistency and Flexible Database design.
• Good experience related to Agile and SCRUM methodologies.
• Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Expert in writing SQL queries and optimizing queries in SQL server 2008, Oracle and Teradata.
• Experience in creating Teradata stored procedures and functions to confirm the data and load it on the tables.
• Expert in writing Teradata Macros and usage of various Teradata analytic functions.
• Strong experience on Teradata SQL queries, Teradata indexes, Utilities such as Mload, Tpump, Fast load and FastExport.
• Expertise in creating Schema objects like Indexes, Views, and Sequences.
• Worked in a team environment and also coordinated with business/functional team.
• Excellent interpersonal and oral/written communication skills.

TECHNICAL SKILLS

Dimensional Data Modeling: Dimensional Data Modeling using Star Join Schema and Snowflake Modeling, Relational Modeling, OLTP, OLAP, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin r 9/7.3/4.5/4.1.4/3.5/3.2 , ER/Studio7.1.1/7.5, Oracle Designer, Visio and Sybase Power Designer.

Data Analysis: Requirement Analysis, Business Analysis, Data Quality Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Data Warehousing: Informatica Power Center, Power Mart,, Informatica Power Analyzer, Informatica Power Connect, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Datamart, OLAP, OLTP, Mapplet, Transformations, Autosys, SQL*Plus, SQL*Loader.

BI Tools: Business Objects 6.5/6.0/5.1/5.0 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite Data Reports, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports

Databases: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, Sybase 11.x, MS Access.

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Visual Basic, Java, J2EE, HTML, DHTML, C, C++, Unix Korn Shell Scripting, PERL

PROFESSIONAL EXPERIENCE

Confidential, Kansas city, Kansas

DW Data Modeler

Responsibilities:

• Gathering business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
• Created conceptual & logical models, logical entities and defined their attributes, and relationships between the various data objects
• Updated existing models to integrate new functionality into an existingapplication.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Developed normalized Logical and Physical database models to design OLTP system
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9
• Created DDL scripts for implementing Data Modeling changes.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs’ to apply the data model changes.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN r9
• Create and maintain Metadata, including table, column definitions
• Synched up the models by reverse engineering, compare model and merge model from database to the original models
• Responsible for defining the naming standards for data warehouse.
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data
• Eliminated errors in ERwin models through the implementation of Model Mart (a companion tool to ERwin that controls the versioning of models
• Tuned the SQL Queries by breaking down the predefined queries into smaller queries for processing, Pushed Query processing up from the client to application server level
• Gathering Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility

Environment: Erwin r9, SQL Server 2008, Oracle 11g, Informix 16, MS Excel, MS Visio 2010, Requisite Pro 7.1, TOAD, SQL, PL/SQL, Windows.

Confidential, Greenville, SC

DW Data Modeler

Responsibilities:

• Identified goals and objectives of projects. Created project plan by gathering the requirements from the management.
• Used ErwinData Modelertool for relational database and dimensional data warehouse designs.
• Requirement gathering from the users by conducting a series of meeting with the business system users to gather the requirements for reporting.
• Worked for a client in the company to build a website for e-booking of appointments Account setup, Payment, Billing..
• Responsible for creating, manipulating and supporting SQL Server databases.
• Wrote SQL prototypes for validating business rules prior to implementing them in SSIS.
• WroteTeradata Macrosand used various Teradataanalytic functions.
• Involved in data migration from data warehouses on Oracle/DB2 and migrated those toTeradata.
• Worked on theTeradata stored proceduresand functions to confirm the data and have load it on the table.
• Maintained data models with detailed metadata using ErwinData Modelerand Model Manager.
• Created views, table, sequences, indexes and synonyms database objects.
• Created partitioned tables and indexes.
• Maintained and enforce data architecture/administration standards, as well as standardization of column name abbreviations, domains and attributes.

Environment: ERwin 7.3/4.5, UNIX, Oracle 10g/11i, Teradata, Teradata SQL Assistant, SQL Server 2008, SSIS, SSRS, Toad for Oracle, OBIEE, Informatica 8.6.

Confidential, Bethlehem, PA

DW Data Modeler

Responsibilities:

• Requirement gathering and business analysis.
• Involved in Design and development of Data Model using Power Designer 12.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling.
• Generated SQL loader scripts and shell scripts for automated daily load processes.
• Developed triggers and stored procedures for data verification and processing.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Used PL/SQL to write stored procedures to increase the performance.
• Created logical & physical data models and Meta Data to support the requirements
• 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 Power Designer.
• Preparation of Data Dictionary/Meta Data of the data elements.
• Walked through the Logical Data Models of all source systems for data quality analysis
• Creation of reports like Reports by product, Reports by Customer, Reports by period, Demographic reports and Comparative reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Generated reports using Business Objects Report Designer.
• Created various geographical and time dimension reports.
• Responsible for Unit Testing of the Maps created according to the business requirements.

Environment: Erwin 7.2/4.5/4.1.4 , Power Designer 12, Informatica Power center 8.1.1/8.0/7.1 , SQL Server 2005,Workflow Manager, Workflow Monitor, Designer, Repository Manager, Power Exchange, Business Objects 6.5, Toad 8.0, Oracle 10g/9i,DB2 UDB 7.1, PL/SQL, Transact-SQL,UNIX AIX4.2, Windows XP/2000

Confidential, Madison, Wisconsin

DW Data Modeler

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing and Documentation. Gathered Requirements and performed Business Analysis.
• Participated team meetings and proposed ETL strategy.
• Identified the key facts and dimensions necessary to support the business requirements for dimensional modeling.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin / Star Schema.
• Responsible for removing Insertion, update and deletion anomalies by converting the table to Third Normal From.
• Led enterprise logical data modeling project (in third normal form) to gather data requirements for OLTP enhancements.
• Converted third normal form ERDs into dimensional ERDs for data warehouse effort.
• Analyzed IMS Data using IMS tools such as Xponent and Xponent Plantrak, regarding segmentation & profiling.
• Involved in mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping, inclusive of logical names, physical names, data types, domain definitions, and corporate meta-data definitions.
• Converted physical database models from logical models, to build/generate DDL scripts.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Implemented Meta Object Facility repository for persistent storage of metadata.
• Created Schema objects like Indexes, Views, and Sequences.
• Extensively used ETL to load data from DB2, Oracle databases.
• Worked on theTeradata stored proceduresand functions.
• Involved in design, enhancement, and development of applications forOLTP, OLAP, and DSSusingdimension modellingwithTeradata and Oracle
• Worked on optimizing and tuning theTeradataviews andSQL’sto improve the performance of batch and response time of data for users.
• Built, managed, customized ETL (Extraction, Transformation, and Loading) Mappings & workflows using Informatica workflow manager & Designer tools.
• Extensively worked on ETL transformations Lookup, Update Strategy, Joiner, Router and Stored procedure transformations.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Tuning the Informatica Mappings for optimum performance and scheduling ETL Sessions.
• Created various geographical and time dimension reports of Fiscal year, Quarterly, Monthly, weekly, Daily reports for all Domains and published through Web Intelligence.
• Generated Adhoc Reports using Business Objects free hand SQL.
• Analysis of Reporting requirements and User Interviews.

Environment: Data Modeling, Erwin 4.5, 3NF(third normal form), Informatica Power Center 8.1.1, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Toad 8.0, Oracle 10g, SQL, PL/SQL, Teradata V2R5 (Multiload, Fast load, Tpump, BTEQ), IMS Data, UNIX, Windows NT, MS SQL Server 2000/2005, Business Objects 6.5, Autosys, Unix, Win XP.

Confidential, New Jersey, NJ

Senior DW Data Modeler/Analyst

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Transformed project data requirements into project data models.
• Responsible as a member of development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin r7.0 and Power Designer.
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Involved in designing built Data marts by using Star Schema and Snowflake schema.
• Closely worked with ETL process development team.
• Experienced in designing the Data warehouse.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Generated the first cut physical design.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Generated ad-hoc repots using Crystal Reports 9, T-SQL.

Environment: Erwin Data Maker, Model Manager, SQL-Server, Teradata, Oracle, SSIS, Informatica Power Center, Cognos, Windows XP, Sun Solaris, Unix, Crystal Reports 9

Confidential

Software Developer

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Prepares and submit the summarized audit reports and taking corrective actions
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting