SUMMARY

• 7+ years of professional experience as a Data modeler in Finance/Banking Domain wif expert in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERwin and Power Designer.
• Extensive experience in Conceptual, Logical and Physical Data Modeling, Comparing and merging, Reverse and Forward Engineering using various data modeling tools like Sybase Power Designer 15.2, Embarcadero ER Studio Data Architect 9.1/9.5, ER Studio Business Architect 1.7, Erwin 7.1 and Toad Data Modeler. Experience in designing conceptual model of COTS (Commercial off - teh-shelf) package.
• Expertise in data analysis, data modeling, Conceptual logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems wif efficient in analyzing data samples and identifying factors that affect development costs.
• Have a strong exposure and experience on Service Oriented Architecture (SOA) and object oriented methodologies.
• Extensively worked wif complex SQL queries, PL/SQL Stored Procedures, Functions and Packages using TOAD and SQL*Plus.
• Experience wif Object Oriented Analysis and Design (OOAD) using UML, Rational Rose and MS Visio wif proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Worked wif various RDBMS like Oracle, SQL Server, DB2 UDB, and Teradata wif expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS), and Informatica.
• Highly experienced in Master Data Management concepts, Methodologies and ability to apply dis knowledge in building MDM solutions wif expertise in automation of SAS processes, models and reports using SAS tools.
• Have teh extensive experience of supporting Oracle EBS that includes teh upgrades from 11i to R12, planning upgrades, manage teh team of DBAs/ Developers to perform teh upgrades.
• Developed Enterprise Canonical Data Model for messaging structure to support Master Data Management.
• Worked extensively using TOAD, SQL*Plus, PL/SQL Developer and UNIX utilities.
• Strong experience in requirements gathering, analyzing business processes and requirements, creating ETL interface specification and technical design documents wif led facilitated workshops and Joint Application Development (JAD) sessions to refine requirements.
• Efficient in data mart design and creation of cubes using dimensional data modeling wif hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Experienced in designing and creating dynamic web applications by using teh Java programming language and advanced Java frameworks such as JDBC, J2EE, JSPs, Apache Struts, Hibernate, Spring, and JSTL.
• Data mapping between various application and Canonical Data Structure for Integration.
• Extensive experience in gathering requirements, gap analysis, design, development, testing and implementation of teh OBIEE / ETL / Data warehouse projects.
• Designed an ETL process to load teh XML file from source to target using XSD, SQL LOADER, PL/SQL Package and shell script wif also worked on Data Modeling, E-R diagrams, Logical, Physical design, Star/Snow flake Schemas using Erwin.
• Exposure to Top down(Inmon), Bottom Up (Kimbal) and Mixed Approaches.
• Experienced in performing database modeling using CA Erwin and MS Visio; performance tuning of SQL queries, stored procedures, views, and functions for MS SQL Server, Oracle, and Sybase databases; providing systems engineering / development / testing expertise; and deploying processes / applications / scripts.
• Analyzed Teradata data from sources such as Google analytics and used map-reduce algorithms to analyze textual data wif extensive experience in numerous Data warehouse, Data mart, Client-Server Applications.
• Extensive experience in Business Analysis wif excellent knowledge to teh full Software Development Life Cycle (SDLC) methodologies and processes. Experienced in managing requirements from project inception through release.
• Created Logical data model using ER/Studio tool and created normalized schemas by logical grouping of EDM attributes.
• Design and implement data mapping and conversion/migration procedures using Transact-SQL, SSIS (DTS), PL/SQL and Unix shell scripts. Maintained Informatica and SSIS (DTS) based ETL architectures.
• Highly Skilled in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica/Business Data Director.
• Very experienced in teh development of data integration and ETL processes, including schema design, data mapping, data extraction, data cleansing, interfacing wif third-party software interfaces, email notification, and SQL development for databases (MS SQL Server, Oracle, Sybase,Terra-data, and MS Access).
• Possess strong ER Modeling and Dimensional Modeling skills for OLAP, OLTP, Enterprise Data Management (EDM), DSS, ODS using various databases like Oracle 10g/9i/8i, SQL Server 7/2000 and MS Access 97/2000/2002 , very good knowledge of Teradata V2R5/V2R6. Experienced in configuration management.
• Used XML, WSDL, XSD, SOAP, SAX parser, DOM parser and Web Services for communicating data between different applications wif dimensional Data Modeling experience using Data modeling, Erwin Modeling (Erwin 4.5/4.0, Oracle Designer) Star Join Schema/Snowflake Modeling, FACT & Dimensions tables.
• Designed and built teh application on SOA / web services based multi-tier environment wif also extensively worked source systems like Oracle, Teradata, Access, Flat files, XML and Mainframe.
• Extensively worked on data modeling and OLAP Data Analysis techniques - Data Mapping, Drill Down and Roll Up, Slice and Dice. Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry leading Data Modeling tools like ERWin, ER/Studio, Power Designer.
• Expertise in modeling using case tools like Erwin, Power Designer, MS Visio, ER/Studio, development of PL/SQL, Functions, Stored Procedures, Triggers and ActiveX Scripts.
• Has been an integral part of every phase (analysis, design, testing, implementation) of database projects using every common type of data store - transactional (OLTP), data warehouse, Data Mart (OLAP).
• Data preparation for various statistical modeling, which includes data cleansing, descriptive statistics, missing data analysis, data validation and preliminary data reporting using SPSS modeler and SAS Enterprise Miner.
• Experience in teh Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Informatica Power Center and good Experience in analysis and resolution of bottlenecks for performance tuning of sources, targets, mappings and sessions.
• Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects wif also extensively worked Data Governance, i.e. Meta data management, Master data Management, Data Quality, Data Security.
• Deep understanding of enterprise data warehouses and also worked wif ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
• Excellent experience and knowledge in modeling concepts like Conceptual Data Modeling (CDM), Logical Data Modeling (LDM), Physical Data Modeling (PDM), Star Schema, Snowflake Schema, Fact & Dimension tables, OLTP and OLAP.
• Designed teh 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 Erwin 7.2.
• Knowledge in teh ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r 7.1/7.2/8.0/9.5 , Power Designer, Clear quest, TOAD, Rational Rose, MS Visio, ER Studio, Oracle BPA, SA - System Architect,Embarcadero ER/Studio and Oracle Designer,OBIEE.

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports9 .

SAS skills: SAS9.0, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/REPORT,SAS/GRAPH, SAS/ETL, SAS/ETS, AS/ACCESS, SAS/CONECT.

ETL Tools: Microsoft DTS/SSIS, SSRS, Data Stage 7.5, Ab Initio and Informatica 7.1.3.

Programming Languages: SQL, PL/SQL, Base SAS, HTML, XML, VB.NET,C, C++, UNIX and Shell Scripting.

Database Tools: Microsoft SQL Server / 2005/2008/2011 , MySQL, Oracle 11g/10g/9i/8i, DB2, Teradata 13,MS Access 2011 and Teradata V2R6.1.

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Columbus,OH

Data Modeler

Responsibilities:

• Captured data extract requirements for multiple subject areas sourced from an external ERP system wif maintained existing ETL procedures, fixed bugs and restored software to production environmen and created teh conceptual model for teh data warehouse wif emphasis on mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.
• Analyzed data which included investigation and analysis, documentation, filtering of bad data through generation of crystal reports wif designed 3rd normal form target data model and mapped to logical model wif also created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
• Worked wif Data Warehouse Extract and load developers to design mappings for Data Capture, Staging, Cleansing, Loading, and Auditing wif designed artifacts like WSDL, Schema (XSD), Mapping Documents, for teh Middleware MQ and Web Services.
• Enforced referential integrity in teh OLTP data model for consistent relationship between tables and efficient database design wif used SAS/SQL to extract data from different databases and joining tables.
• Maintained DataMirror and DTS based ETL architectures. Recommended/developed testing procedures.
• Played teh lead role as a SOA Data Modeler and Architect for teh IAA's IDM (Interface Design Model), which will be later consumed by teh development team in building teh application.
• Designed and developed MDM canonical data model to support SOA based data distribution architecture.
• Developed, enhanced and maintained Snow Flakes and Star Schemas wifin data warehouse and data mart conceptual & logical data models wif also analyzed and designed XML Schema Definition (XSD) data objects in XML Spy to standardize MDM.
• Defined logical and physical data modeling principals and guidelines for Teradata FSLDM modeling.
• Performed Business Analysis and Requirements Gathering from high-end users and managers wif designed data models based on business case documents provided by client and also developed / Reviewed conceptual, logical and physical data models using ER Studio.
• Writing Complex SQL queries, SAS Base, SAS SQL and QlikView Business Intelligence Software to mine/extract data for teh purpose of report-making and designing teh report wif also used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
• Analyzed business requirements and translated them into detailed conceptual data models, process models, logical models, physical models and entity relationship diagrams. Gatheird enterprise level data requi rements.
• Responsible to create Canonical Data Model for loosely coupled systems that use different notations for teh transaction codes.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for teh Master Data Management Architecture involving OLTP, ODS and OLAP wif also communicated data needs internally and externally to 3rd parties. Analyzed and understood teh data options and documented data dictionary.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Extensively used Data Null to create macros, customized reports, reports on external files and debugging SAS codes wif also using Erwin, designed Logical and Physical data model/meta data /data dictionary for business users and development team.
• Data modeling and data analysis wif Teradata, Oracle, SQL Server, using Erwin for OLTP, ODS, EDW.
• As a data modeler, my duties include Understanding teh business rules, Coordinating teh queries wif teh Business team, defining teh Meta Data Model, designing and reviewing teh schema wif teh senior data architects, reviewing teh schema wif SOA Governance team,publishing XML schema Definition files, WSDLs to development team.
• Created Data bases, table spaces, buffer pools in Power designer to create physical tables on teh data base.
• Created and maintained XSD xml schemas for teh application teams, mapped XSD complex types and data elements wif analyzed content and quality of data model(s) and databases.
• Work closely wif teh DBA team to translate teh model(s) from logical design to physical implementation.
• Design teh Canonical model for teh Financials domain of teh Enterprise model wif also creating Data Architecture Models, Entity Relationship Models (ERD) and Data Flow Diagrams (DFD) wif lead teh JAD sessions and project status meetings wif teh stake holders.
• Set direction and analysis approach as well as maintain task assignments and report statuses to management as teh Lead Data Modeler on new critical corporate initiatives wif minimal or no management oversight.
• Analyzed teh existing structures, ETL, database objects, Server infrastructure for teh EDW and Data mart and then created system stabilization tasks to improve teh data quality, avoid ETL failures and improve performance.
• Architectural analysis of teh data models and data analysis for teh several source systems to populate teh new canonical databases and teh new dimensional EDM database.
• Perform logical and physical data structure designs and DDL generation to facilitate teh implementation of database tables and columns out to teh DB2, SQL Server, and Oracle DB schema environment using CA ERwin Data Modeler Release 7.3.
• Design envelops canonical structure to enable integration across applications.
• Proficient in documenting business requirements, business use cases, application use case and system requirements specifications for both in-house systems and COTS products. Possess strong Enterprise Architectural skills wif specialization in Enterprise Data Modeling, Enterprise Business Process Modeling, Enterprise State Event Modeling and Enterprise Canonical Message Schema Creation.
• Determined requirements, maintained legacy systems; led JAD sessions, developed conceptual and logical data.
• Conduct source data analysis of various data sources and develop source-to-target mappings wif business rules.

Confidential, Hartford,CT

Data Modeler

Responsibilities:

• Facilitated JAD sessions to determine data rules and conducted Logical Data Modeling (LDM) and Physical Data Modeling (PDM) reviews wif Data SMEs also participated in data analysis and data dictionary and metadata management -Collaborating wif business analysts, SMEs, ETL developers, data quality analysts and database administrators.
• Participated in design of Data Asset Management (DAM), Marketing, Customer Contact Channel, IVR, Targeted Payment Protection business processes, target applications architecture and target data model.
• Developed relational model design, dimensional modeling, and ETL process in Data Warehouse (DWH) environment. Validated and maintained teh enterprise-wide logical data model for Data Staging Area, DWH and DSS.
• Responsible for teh data analysis, logical design and canonical models to support multiple Personal Identities wif interface to Security and Billing Systems for a Data-provider Organization.
• Created, documented and maintained logical and physical database models in compliance wif enterprise standards and maintained corporate metadata definitions for enterprise data stores wifin a metadata repository wif also aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users.
• Developed teh logical data model (LDM) & PDM and assisted teh DBA to create teh physical database by providing teh DDL scripts including Indexes, Data Quality checks scripts and Base View scripts.
• Reviewed data models wif Solution Designer to assess teh impact of teh new model on teh enterprise model and managed teh data model changes in all enterprise applications. Performed impact analysis to ensure all systems leads are informed and coordinate efforts to implement changes.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Performed data analysis and reverse engineering of data wif provided data modeling support to teh Marketing operations design team and also developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging area Data Models and Data Flow Diagrams.
• Developed, integrated, managed and promoted enterprise level logical and physical data models and data model standards that source data from multiple origins (internal data sources, external data sources, third party data.
• Developed detailed mapping documents that will provide teh reporting and data warehouse team wif source to target data mapping includes logical names, physical names, data types, corporate meta-data definitions, and translation rules.
• Developed Table Reports, Pivot Reports, Chart reports, Dashboards and Chart Reports from Pivot reports - vice versa and also worked wif an architect to design target environment data structures, design source to target data mapping, and design logical and physical data models.
• Educated users for data quality and metadata management and mentored targeted power users in BI wif also participated in teh business, information, and user interface requirements, participated in facilitating joint application development (JAD) sessions, designed logical and physical data model (dimensional modeling) utilizing ERWin CASE Tool and created teh star schema.
• Developed several releases of teh Enterprise Canonical XML Schema (ECXS), enabling timely implementation of Exchange-related projects for teh Affordable Care Act.
• Develop, implement, and maintain OLTP and data warehouse data models. Increase teh use of data modeling in development organizations wif also assisted in data modeling JAD sessions wif subject matter experts and teh creation of teh conceptual data models based on these sessions.
• Performed teh logical data modeling necessary to produce teh target data model, rationalized and integrated across subject areas, which formed teh foundation for Data Warehouse initiatives wif also creates test scenarios and test data to support both quality assurance and user acceptance testing.
• Capture business requirements and rules, design teh associated logical models, and create all required documentation to support, communicate, and validate teh data model wif also created design documents including metadata samples, use cases and data flows to facilitate teh development group usage of teh subject area.
• Created database triggers, functions, procedures, cursors and packages also developed PL/SQL scripts to validate and load data into interface tables wif extensively used Stored Procedures for handling teh database operations.

Confidential, Philadelphia, Pa

Data Modeler

Responsibilities:

• Automated load run on Informatica sessions through UNIX Corn, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures wif successful notification through email.
• Conducted Work Sessions wif Business Architects/Business SME to understand teh business requirements.
• Worked closely wif Application Modelers to customize teh project logical models and halp them align to Enterprise Model
• Involved in teh design of Messaging Layer for vending data across teh Enterprise using Enterprise Common Format.
• Worked closely wif teh Application development Team to Implement Security Master Data Management Solution using Informatica.
• Designed Conceptual and Logical data models for MDM Provider and Member domains and reverse Engineering models from Databases, files, External metadata using ER Studio wif maintained Physical models and created DB objects wif teh halp of DBA.
• Created Enterprise Design Patterns which can be used as guidelines across teh enterprise.
• Contributed to develop Enterprise Modeling Process to identify teh various parties their roles/responsibilities, teh inputs/outputs for each process on each step in its life cycle.
• Developed a template to provide estimate by teh Modeling Process Steps to teh management.
• Developed Work Flow Process to manage and track teh issues raised by consumers to track and resolve teh issues against teh Enterprise Logical Model.
• Contributed to develop teh Data Model Release process flow to provide transparency & visibility to teh Management/Consumers.
• Contributed to Data Governance efforts to identify teh Core and Critical Elements for teh Enterprise wif teh guidance from Business SME's
• Supported teh Data Governance activities by running teh Compliance report on Application Models
• Provided guidance to create Business Glossaries to define standard business terms and ensure consistent and clear communication
• Worked wif Subject Matter Experts in assigned areas and Business Users to analyze business processes and develop and document requirements.
• Provided data models and data maps (extract, transform and load analysis) of teh data marts and feeder systems in teh aggregation effort.
• Provide walkthrough of teh Enterprise Conceptual/Logical Model to various user communities including Executives, Business SME's, Application Modelers/ Application Developers/ Data Governance.
• Coordinated wif Informatica ETL developers in providing data mapping and sql queries for bulk data load.
• Designed and developed teh Data Mapping documents, DDL Scripts, data dictionary and Meta data of teh models and maintained them.
• Involved in teh full life cycle of project through design, development and maintenance of an enterprise data warehouse repository.
• Additionally participated in overall system design, data modeling, SQL and process design and tuning, UNIX scripting for processing loads, and PL/SQL development.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary evolve and change during teh project.
• Created Data model Diagrams (Physical & Logical), Entity relationship using Erwin.
• Engineered complex ETL processes to load large volumes of data on a daily basis.
• Involved in data quality and standardization processes and all metadata & ETL documentation that support business roles and detailed source to target data mappings.
• Performed Data Validation and Unit Testing before handing over teh data for production and Quality Testing.