SUMMARY

• Goal - oriented IT professional with strong background in Database development and designing data models, with particular emphasis on designing online transactional processing (OLTP) and Data Warehouse systems for Financial, Retail and Health Care domains.
• Excellent knowledge of waterfall and spiral methodology of software development life cycle (SDLC).
• Strong Knowledge of Data Warehouse Architecture and Star Schema, Snow flake Schema, FACT and Dimensional Tables.
• Participated in JAD sessions and requirements gathering & identification of business subject areas.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model.
• Used the Ralph Kimball Methodology for Data Warehouse and Data Mart designs.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
• Have worked with ETL tools to migrate data from variousOLTPdatabases to the data mart.
• Excellent knowledge inSQLand codingPL/SQLPackages, Procedures.
• Managed performance and tuning of SQL queries and fixed the slow running queries using utilities like Explain, Trace, and Tkprof.
• Proficient in creating Views, Materialized views & Partitions for the Oracle warehouse.
• I have excellent communications skills and work well with end users and management.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i/8.0, MS SQL SERVER 2005/2008/2012 , Sybase, Teradata

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data extraction, Integration, transformation and Migration, ETL Architecture and Design Data Warehouse, OLTP, OLAP, Report Design and Development.

Data Analysis: User Requirement Gathering, JAD Sessions, Gap Analysis, Data Cleansing, Data Transformations, Source Systems Analysis, Data Relationships.

Data Modeling: Erwin 9.x/7.x/4.x, ER Studio, MS Visio, Toad, Power Designer

ETL Tools: Informatica, BO DS 3.X, SSIS

Reporting Tools: Tableau

Programming: PL/SQL, JAVA, C/C++, VB 6.0

Scripting languages: Java script, PHP

Web technologies: HTML, DHTML, XML

Operating Systems: Windows 2000/XP, Vista/7/8

PROFESSIONAL EXPERIENCE

Confidential, West Chester, OH

Sr. Data Modeler

Responsibilities:

• Attended and participates in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for Staging, Operational Data Store and Data marts applications.
• Performed gap analysis and dependency analysis for current & future systems.
• Designed Star Schema Data Models for Enterprise Data Warehouse using Power Designer.
• Created Mapping documents for Staging, ODS & Data Mart Layers.
• Created and maintained Logical & Physical Data Models for the project. Included documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate Models to process mappings, screen designs, use cases, business object model, and system object model as they evolved and changed.
• Created Model reports including Data Dictionary, Business reports.
• Generated sql scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.
• Performance tuning

Environment: Erwin 9, Oracle 11g, Informatica, Toad

Confidential, Columbus, OHIO

Data Architect/ Modeler

Responsibilities:

• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Maintained data model and synchronized it with the changes to the database.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Experience in MPP architectures.
• Designed the database tables & created table and column level constraints using the suggested naming conventions for constraint keys.
• Used ETL tool SAP DS to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developedstored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• Reviewed the database programming for triggers, exceptions, functions, packages, procedures.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Erwin 7, MS Visio, Teradata, SAP Data Services, Toad

Confidential, Ohio

Enterprise Data Modeler

Responsibilities:

• Involved in JAD sessions with the Business Analyst, SME, Product Owner and Application Team in gathering Business Requirements.
• Designed Logical and Physical Model for REA (Regional Elite), Technician Self Assessment, Threshold Manager, Campaign Model, VSOW (Vendor Scope of work) Application, FABTR (Fare Base Award Ticket Redemption) Project using power designer and visio.
• Normalized the Data and also developed the Relational database for the different Subject areas (Order, Finance, Information Technology, Inventory, Pricing, Sales).
• Generated database scripts using Forward Engineer in using Data Modeling Tool.
• Created Domains and Metadata reports using Erwin 7.5 data modeler.
• Carried out effective data profiling to eradicate anomalies between source and target data
• Worked with the ETL team to ensure that the company’s data governing policy was adhered to
• Generated extracts for multiple downstream users.
• Experience in check-in and check-out of models using Model Manager and updating the MDCD file for auditing purposes.
• Provided support to application team in all environments (Development, Testing, and Production).
• Worked with the team in mortgage domain to implement designs based on the free cash flow, acquisition, and capital efficiency.

Environment: Erwin7.5, Microsoft Office, Oracle 10g/11g.

Confidential, HERDON, VA

Data Modeler/ ETL Developer

Responsibilities:

• FacilitatedJAD sessionsto determine data rules and conducted Logical Data Modeling (LDM) and Physical Data Modeling (PDM)reviews withDataSMEs.
• Participatedin data analysis and data dictionary and meta data management - Collaborating with business analysts, SMEs, ETL developers, data quality analysts and database administrators.
• Participated in design of Data Asset Management(DAM), Marketing, Customer Contact Channel, Order provisioning business processes, target applications architecture and target data model.
• Developedrelational model design, dimensional modeling, and ETL processes inDatawarehouse(DWH) and Decision support system(DSS) environment.
• Validated and maintained the enterprise-wide logical data model forDataStaging Area, DWH and DSS.
• Developed the logical datamodel (LDM) & PDM and assisted the DBA to create thephysicaldatabasebyproviding the DDLscriptsincluding Indexes, Data Quality checks scripts and Base View scripts.
• Aided and verified DDL implementation by DBAs, corresponded andcommunicated data and system specifications to DBA, development teams, managers and users.
• Ensureddelivery of LDM, PDM, Staging PDM and data lineage mapping documents.
• Managedthe data model changes in all enterprise applications. Performedimpact analysis to ensure all systems leads are informed and coordinate efforts to implement changes.
• Developed, integrated, managed and promotedenterprise level logical and physicaldatamodelsanddatamodel standards thatsourcedatafrom multiple origins(internaldatasources, externaldatasources, third partydata.
• Developeddetailed mapping documentsthat will provide the reporting and data warehouse team with source to targetdatamappingincludeslogical names, physical names,datatypes, corporate meta-data definitions, and translation rules.
• Conducted qualities control/auditing to ensure accurate and appropriate use ofdata.
• Performeddataanalysisonproductiondataissues.
• Createddatabase triggers,functions,procedures,cursorsandpackages.
• DevelopedPL/SQL scriptsto validate and load data into interface tables.
• Extensively usedStored Proceduresfor handling the database operations.

Environment: ERWIN 7, MS SQL Server, SAP Business ObjectsData Services3.X, PL/SQL, SQL*Plus, Toad, HTML, XML.

Presbyterian Health Care System, WASHINGTON, DC Jan 04 --July 08

Data Analyst/Data Modeler

Responsibilities:

• Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions to gathering the new requirements.
• Involved in all phases ofSDLCfrom requirement, design, development, testing and rollout to the field user and support for production environment.
• Translated business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• Developed Business and Subject Area LogicalDataModels,Physical Data Models, Physical Staging area Data Models andDataFlow Diagrams.
• Extensively used ERWIN to design Logical/Physical Data Models,forward/reverse engineering, publishing data model, applying DDLs to database, Data Modeling and restructuring the existing data Model.
• Applied Discover FinancialDataNaming Standards,created new naming standards,checked models in and out ofERWINModel Repository, and documenteddatamodel translation decisions.
• Generated database objectssuch asTable, Views, Synonyms, Database Linkby executing the script generated from ERWINwith appropriate privileges
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model.
• Used various levels oftriggers and proceduresto validate the data at each level.
• Extensively involved in writingPL/SQL stored procedures, functions and packages.
• Createddatabase tableswithcomplex constraintsapplicable to the business rules.
• Involved in Optimizing SQL queries involving large tables.
• Created Indexes and Materialized Views to improve the overall system performance.
• Tested the application to ensure proper functionality, data accuracy, and modifications had no adverse impact on integrated system environment.
• Involved in the maintenance and support of existing applicationswith the users.
• Involved in training and production support at various client locations

Environment: ERWin 4, Microsoft Office Suite, Microsoft Visio, Unix, Documentum, ETL, MS Word, MS Access, MS Excel, MS Visio, Windows NT/XP, SAS, Oracle, SQL, SQL Server,