S U M M A R Y

• Six Plus 6 years of total IT experience in the Business Requirements Gathering and Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Development and Testing of software systems in Health Care, Pharmaceutical, Financial, Retail Industries.
• Five 5 years of Data modeling experience using tools like ERWIN 7.3/9.1/9.5, ER STUDIO DATA ARCHITECT 9.0 Embarcadero , Visio and Oracle Designer. Experience in Star Schema/Snowflake modeling, Normalization techniques, Physical logical data modeling.
• Five 5 years of database experience using Oracle 11g/10g/9i, MS SQL Server 2008/2005, Postgre Sql, SQL, PL/SQL, SQL Plus, SQL Loader. Working knowledge in Oracle and PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Four Plus 4 years of strong Data Analysis, Data Cleansing, Data Governance, Data Profiling with various tools and methodologies in cleansing, profiling and segmentation of data.
• Two Plus 2 years of development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 8.x ,Oracle Data Integrator.
• Two Plus 2 Years of Business Intelligence experience using Cognos, Business Objects XI/6.5, MS Excel.

P R O F E S S I O N A L S U M M A R Y

Confidential

Enterprise Data warehouse Modeler / Architect

The main purpose of the project was to design and implement an extended reporting database that represents the target architecture for Operational BI including reporting analytics. Also to design EDW that focuses on strategic decision making such as reporting, OLAP, data mining and forecasting.

Responsibilities:

• Designed Conceptual, Logical and physical Data Models after conducting JAD sessions for requirements gathering and profiling source systems data.
• Designed the database for the change data capture CDC technology that helped reducing processing time, improving load times and Service Level Agreements.
• Converted Logical models to physical models and ensured proper implementation of DDL's and other data structures.
• Worked extensively on forward and reverse engineering processes. 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.
• Generated alter script or delta by using the model compare and merge utility to find the differences between varied environments like development, test , user and prod.
• Performed complete synchronization between different environments like development, test and production using Model complete compare and merge utility.
• Captured all major subject areas of the business in the reporting database like Claims, Providers, Member.
• Worked with DBA's to incorporate the right indexing strategy in a table Bitmap, B-Tree .
• Created Materialized views for backward compatibility.
• Established standards for data modeling including the use of naming standards to ensure consistency.
• Established standards providing a single what and how-to reference used to produce consistent and comprehensive artifacts for data requirement specification, database development, database population, and maintenance of both transaction processing and data warehousing applications.
• Maintained enterprise level data dictionary on that involved ACD Add, Change, and Delete from release perspective and also source to target mappings.
• Created physical data model PDM , conceptual data model CDM and keys only KO's image/pictures of all the models for better understanding the schemas both in a granular level and high level.

Environment: Erwin 7.3/9.1/9.5 , Oracle 11g, AQT, TOAD, Cognos, SQL Developer, Clear Quest.

Confidential

Enterprise DW Modeler / Architect

To build a metadata Repository that provides a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the merges of different Constellations acquisition and NAIT database architecture.

Responsibilities:

• Created, maintained and modified data base design document with detailed description of logical entities and physical tables. Performed in-depth data analysis of the source systems.
• Reverse Engineered other data structures associated with the table like relationships name, cardinality, triggers, definition , indexes name, PK/UK Constraint name, index options, storage locations, storage parameters, col.seq, partitioning options, etc , table columns, identity, constraints, capacity planning metrics, encryption information , partitions, views, procedures, functions, object types, packages, materialized view, sequences, synonyms.
• Performed capacity planning for the future schemas.

Environment: ER Studio, Informatica, Oracle 11g, SQL SERVER 2005, BO XI, ERP systems JDE UNIX.

Confidential

DW Database Modeler / Analyst

Implemented a centralized data base that collects and organizes and stores data from different operational systems to provide a single source of integrated and historical data for the purpose of end user reporting, analysis and decision support and to improve the client services by preventing errors, providing real-time data and updating records as transactions are completed for Billing and Payment purposes.

Responsibilities:

• Requirements Gathering and data analysis.
• Developed Logical and Physical Data Model using ER Studio, followed Star Schema to build the Datamart.
• Interacted with business users and team leads in correlating business specification, Identifying data sources and Development strategies.
• Helped in Consolidation, Cleansing, Integration, and customization of data.
• Implemented Slowly Changing Dimensions Type 1, Type 2, and Type 3.

Environment: Erwin 7.3 , Informatica, Oracle 11g/10g, Shell Scripting Bourne, Korn , PL/SQL, UNIX, AUTOSYS

Confidential

EDW Data Modeler/DW INFORMATICA DEVELOPER

The main purpose of the project was to build a Datamart on Sales and Marketing Department that would help the Sales Managers and Key Business Decision Makers of the company to make informed decisions.

Responsibilities:

• Designed procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Develop Logical and Physical data models that capture current state/future state data flows ER/STUDIO Data Architect.
• Analyzed and created Facts, Dimension tables.

Environment: Erwin 7.3 , Informatica 8.1, Oracle 9i/8i, SQL SERVER 2005, ORACLE 9i/10g, T-SQL