Professional Summary:

• More than 8 years of IT experience with strong background in Database Design, Development, Integration, Testing and Implementation of complex OLTP and OLAP Systems.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering.
• Publishing ERWIN diagrams, analyzing data sources and creating interface documents.
• Extensively developed the Entity Relational Diagrams using ERWIN, MS Visio as the data-modeling tool.
• Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses and web applications.
• Possess strong ER Modeling and Dimensional modeling skills for OLAP, OLTP, Enterprise Data Management EDM , ODS.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWin.
• Very good background in understanding ER diagrams and implementing relational design with excellent concepts of 3rdnormal form.
• Good understanding of Ralph Kimball's and Inmon's dimensional approach to design large data warehouses and data marts.
• Guided team members in following the best practices.
• Familiar with all stages of the SDLC development life cycle: Requirements gathering, Design, Development, Construction, testing and Implementation.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Support and coordinate with DBA on data base build.
• Assisted with ad-hoc query and report requests to various customers.
• Assisted the Data Manager by leading and trained junior team members.
• Set standards and ensured that all processes follow the data methodology.
• Experience in training users and gathering user requirements.
• Strong team member with Excellent Communication and Analytical skills.

Skill Set:

Work Experience:

Confidential

Data Modeler

Confidential is an Confidential home improvement and appliance stores that has retail stores in the Confidential. Lowe's is the second-largest hardware Confidential, behind The Home Depot and ahead of Menards. I was involved as a data modeler for various transactional and reporting projects across various platforms like Sybase, oracle, db2, sql server and Teradata.

Responsibilities:

• Worked with the Business Analysts and development teams for requirements gathering, business needs analysis and project coordination and validated data requirements by conducting JAD sessions.
• Extensively used Erwin Data modeling tool to design Logical and Physical data models to suit the business needs.
• Designed Conceptual, Logical and Physical data models for OLTP, Data Warehouse and Data Mart Applications.
• Generated DDL scripts during the forward engineering process for the actual physical build of the database.
• Built data models to bring it in compliance with the 3rd normal form.
• Frequent meetings and brainstorming sessions in order to make sure that the data corresponds to the business needs.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Used Model Mart in order to maintain a library of all the development models in progress.
• Used Complete Compare in order to make migrate from development to production version.
• Reviewed Copybooks in order to make sure that the data adheres to the required standards.
• Maintained the data model and synchronized it with the changes to the database.
• Generated reports using the ERWIN Data browser in order to assist the ETL teams.
• Extensively used complex SQL queries for querying and analysis of data using the Teradata SQL Assistant.
• Created Triggers and Sequences in the Physical Data Model so as to meet the business logics as and when required.
• Assisted the DBA's by Looking at the tuning side by analyzing the queries using the EXPLAIN PLAN Auto-trace utilities.
• Provided other data analysis services as required.

Confidential

Data Modeler

Confidential is an Confidential and Telecommunications Company and a component of the Dow Jones Industrial Average. It provides various services like voice, voicemail, wireless, Verizon voice wing, high speed dsl internet services etc. I was involved in the customer order provisioning system project. My role in the organization was as a data modeler. I was involved in analyzing the business requirements and to build data models for a data warehouse that was to support reporting and analytics purposes.

Responsibilities:

• Worked with the Business Analysts for requirements gathering, business needs analysis and project coordination and validated data requirements by conducting JAD sessions.
• Performed data analysis to look at the reports being generated by the Business Intelligence team also did deep dive analysis on source systems.
• Primary role as a data modeler was to design a data warehouse so as to reduce the load on the OLTP server.
• Used the ERWIN tool to reverse engineer the data from the source systems.
• Designed Conceptual, Logical and Physical data models in order to build a star schema for the data warehouse.
• Designed a similar data model for the staging tables so as to further reduce the load at the source systems to support near real-time data.
• Assisted the ETL team in the transformation logics from the source systems to the staging tables and then to schedule a daily load from the staging area to the warehouse.
• Maintained the data model and ensured that it stayed synchronized to the changes in the database.
• Created reports in RTF, PDF and TEXT formats using the ERWIN tool to help the ETL team during the actual ETL process.
• Built complex queries and sub-queries using joins in order to integrate the data from various source systems for the purpose of loading the data into the warehouse.
• Created data models to design data marts on top of the data warehouse.
• Wrote SQL queries to capture pre-aggregated and derived data from the source systems into the staging tables.
• Created numerous views and materialized views based on the business requirement.
• Involved in creating stored procedures in order to meet complex business logics.
• Involved in tuning aspect of the database by analyzing the query performance using the Explain plan and coordinating with the DBA's on the server side performance.
• Provided trainings to ETL team members on Data models.

Environment: ERWIN 7.3, Microsoft Office, Oracle 11g, SQL, PL/SQL

Confidential

Data Modeler

Description: Confidential is a large retailer owning multiple brands. The company's products are available in over 2,900 specialty stores nationwide. Limited Brands recorded sales of 10 billion in 2007 and employs more than 90,000 associates throughout the United States. My role in the project was to build a star schema for the data warehouse in order to facilitate business intelligence reporting across all brands.

Responsibilities:

• Closely interacted with the business analysts in order to get gather the glossary, data requirement document and the Key Performance Indicator KPI documents. Attended JAD sessions.
• Interacted with the end users in order to understand the reporting needs.
• Designed a high level conceptual data model to identify all the business entities and the relationships between these entities.
• Designed a detailed logical model to capture all the business requirements, identify attributes, assign data types using the domain dictionary and eliminate the many to many relationships between the entities.
• Maintained different versions of the logical data model.
• Designed a physical data model to build database properties like indexes, table spaces, triggers, synonyms and sequences.
• Had to Reverse engineer the existing data from the source systems using ERWIN tool.
• Designed Star schema for the data warehouse.
• Created DDL scripts for different versions of the data model in order to accommodate change requests.
• Had to make sure that the model stayed synchronized to the changes in the database.
• Created reports in Text formats using the ERWIN tool to help the ETL team during the actual ETL process.
• Wrote SQL queries using various joins in order to fetch the data from various source systems.
• Created stored procedures in order to meet the business logics.
• Created partitions on large transactional source systems to improve query performance.
• Analyzed various aspects of tuning by analyzing the queries using the Explain plan.

Environment: ERWIN 7.2, MS-Office, Toad, Oracle 10g/9i, SQL, PL/SQL

Confidential

Data Modeler

Description: Confidential is one of the world's largest specialty retailers, with approximately 3,100 stores and fiscal 2009 revenues of 14.2 billion. They have operations at five of the most recognized apparel brands in the world Gap, Banana Republic, Old Navy, Piperlime and Athleta. My job here was to create a data model using ERWIN tool and to coordinate with the DBA for the build of the physical database.

Responsibilities:

• Translated Business Requirements into working Logical and Physical data models for OLTP, Data Warehouse and Data Mart applications.
• Designed data model for OLTP applications using the ERWIN tool.
• Attended JAD sessions with the business analysts in order to understand the client and the end user reporting needs.
• Designed Conceptual, Logical and Physical data models using the ERWIN tool.
• Generated DDL scripts during the forward engineering process for the actual physical build of the database.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Maintained different Versions of the Data Model to make sure that it stayed synchronized to the changes in the database.
• Generated reports using the ERWIN tool in order to assist the ETL teams.
• Provided training on data model to different application groups across the enterprise.
• Extensively used complex SQL queries for querying and analysis of data
• Created Stored Procedures in order to implement the business logics.
• Created Triggers and Sequences in the Physical Data Model so as to meet the business logics as and when required.
• Looked at the tuning side by analyzing the queries using the EXPLAIN PLAN Auto-trace utilities.
• Provided other data analysis services as required.

Environment: Erwin 7.1, SQL, PL/SQL, Oracle 9i

Confidential

PL/SQL Developer

Responsibilities:

• Responsible for creating the tables, enforcing the Constraints Indexes.
• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, database Triggers and Packages.
• Created various triggers in accordance with the business requirements.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Involved in the table partitioning, which had more than 2 billion records in it.
• Created numerous PL/SQL procedures using REF Cursors, which were used in developing reports.
• Worked with different types of sub queries Inline, correlated and used loops to suit the business logic.
• Written a number of Cursors to select various types of records.
• Moved data from the old tables into the new tables using Sql Loader
• Created indexes on the tables for increasing the performance by reducing the data retrieval timing.
• Extensively involved in knowledge transition to new team members in the project.
• Also involved in assisting my project manager in coordinating various stages of the project.
• Involved in Production Support, Problem resolutions and Bug fixing

Environment: Oracle 9i, PL/SQL, SQL,TOAD, SQL PLUS

Confidential

PL/SQL Developer

Responsibilities:

• Designed and developed PL/SQL Functions , Stored Procedures, Cursors, Packages, Triggers using PL/SQL.
• Involved in coding DDL statements for creation of tables, building the relationships between the tables by means of constraints.
• Created a number of database triggers in order to implement various business logics.
• Analyzed and tuned the queries in order to reduce the retrieval time of the results..
• Worked on creation of sequences for automatic generation of sequence numbers for column input.
• Extensively used ref cursors in order to fetch the data into records.
• Also performed partitions on tables containing a huge number of records.
• Written queries using joins from various tables in order to meet the business logics.
• Involved in the various meetings with the business users, business owner and the managers.
• Involved in extensively creating various views and materialized views in order to meet the business requirements.
• Created various PL/SQL procedures using REF cursors.
• Usages of bulk collect concepts in order to improve the performance of the queries.
• Worked extensively with Toad for developing Database objects like Stored procedures, functions, packages and triggers
• Involved in knowledge transition to new team members .
• Involved in all stages of the project right from the coding to production support and bug fixing.
• Environment: Oracle 9i, PL/SQL,SQL,TOAD, SQL PLUS