SUMMARY

• Over 9 years of IT industry experience in Application Design, Development, and Maintenance activities for financial organizations.
• Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT & Dimension tables.
• Solid hands on experience in creating and implementation of Conceptual, Logical and Physical Models for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Skillful in Data Analysis using SQL on Oracle, MS SQL Server, DB2 & Teradata
• Excellent experience in trouble shooting SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Expertise in performing User Acceptance Testing (UAT) and conducting end user training sessions.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Solid understanding and experience with Master Data Management (MDM) concepts and gathering requirements.
• Efficient in developing Logical and Physical Data model and organizing data as per the business requirements using Sybase Power Designer, Erwin, ER Studio in both OLTP and OLAP applications
• Comprehensive knowledge and experience in process improvement, normalization/de - normalization.
• Expertise on Relational Data modeling (3NF) and Dimensional data modeling.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Worked on datamodeling using ERWIN tool to built logical and physical models.
• Assist in creating communication materials based on data for key internal /external audiences.
• Skillful in Data Analysis using SQL on Oracle, MS SQL Server, DB2 & Teradata.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Trained end users, prepare related documentation (requirements, training materials, process and data flows, use cases, functional design, etc), and addressed critical questions from the user base involving the CRM.
• Experienced in Technical consulting and end-to-end delivery with architecture, data modeling, data governance and design - development - implementation of solutions.
• Heavy use of Access queries, V-Lookup, formulas, Pivot Tables, etc. Working knowledge of CRM Automation Salesforce.com, SAP.

TECHNICAL SKILLS

Data Modeling Tools: Erwin R6/R9, Rational System Architect, IBM Infosphere Data Architect, ER Studio and Oracle Designer

Database Tools: Microsoft SQL Server12.0, Teradata 15.0, Oracle 12c/9i, and MS Access

BI Tools: Tableau 7.0/8.2, Tableau server 8.2, Tableau Reader 8.1,SAP Business Objects, Crystal Reports

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server

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

Version Tool: VSS, SVN, CVS.

Tools: & Utilities: TOAD 9.6, Microsoft Visio 2010.

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Waterfall Model.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Understood source business process anddatamodel and doData Analysis and map the requirement to source system.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductData Analysis.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Experienced in Designing Database with prominent activities like maintaining sequences, index, primary key, foreign key, manipulating columns and tables.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Involved in preparing modeling estimates, DFD, Volumetric, defining enterprise standards for best practices.
• Data architect for large-scale pharmacy data management (PBM) data migration project from SAS to Teradata for the Enterprise Information Management (EIM) program. Redesigned database schemas and created conceptual, logical and physical data models.
• Implemented dimension model (logical and physical data modeling) in the existing architecture using ER Studio.
• Worked with Amazon Redshift and AWS
• Performed Data modeling using Erwin Data Modeler. Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using forward engineering
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Worked with Hadoop eco system covering HDFS, HBase, YARN and Map Reduce
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Excellent experience and knowledge on data warehouse concepts and dimensional data modeling using Ralph Kimball methodology.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Gathering the business requirements from the respective application team (Data Architect's / Application Owner's).
• Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions.

Environment: ERWIN 9.0.0, Windows 2010, UNIX, Oracle 12c, SQL SERVER 12.0, PL/SQL, DB2, Teradata SQL assistant, DQ analyzer, IBM Optim Tool, IBM Rational Clear Case and Clear Quest, Toad 9.7

Confidential, Bronx, NY

Sr. Data modeler/Analyst

Responsibilities:

• Worked on data mapping process from source system to target system. Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin
• Designed Logical Data Models and Physical Data Models using Erwin.
• Developed the Conceptual Data Models, LogicalData models and transformed them to creating schema using ERWIN.
• Developed data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Forward Engineering the Data models, Reverse Engineering on the existing Data Models and Updates the Data models.
• Performeddatacleaning anddatamanipulation activities using NZSQL utility.
• Analyzed the physicaldatamodel to understand the relationship between existing tables. Cleansed the unwanted tables and columns as per the requirements as part of the duty being aDataAnalyst.
• Experience in Unix Environment developing shell scripts and perl scripts.
• Excellent knowledge and experience in Technical Design and Documentation.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the Logical Data Model.
• Performed logicaldatamodeling, physicaldatamodeling (including reverse engineering) using the ErwinDataModeling tool.
• Extensively used NZSQL and NZLOAD utilities.
• Experience in developing dashboards and client specific tools in Microsoft Excel and Power Point.
• Responsible for the development and maintenance of Logical and Physical data models, along with corresponding metadata, to support Applications.
• Create enhanced report templates on regular basis

Environment: Oracle9i/11g, PL/SQL, Solaris 9/10, Windows Server 2003 & 2008. NZSQL,Erwin8.0, ER- Studio6.0/6.5, Toad 8.6, Informatica 8.0, IBM OS 390(V6.0), DB2 V7.1

Confidential, San Jose, CA

Data analyst/Data Modeler

Responsibilities:

• Designed Logical & Physical Data Model /Meta data/ data dictionary usingErwinfor development teams both offshore and on site.
• Developed and maintained an Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage the enterprise data warehouse. This effort involves working closely with the business.
• Created technical documentation such as data architecture design documents, ETL mapping specs and Data Model design and changes artifacts.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/datatransformations to facilitate impact analysis.
• Created Data Mapping documents which capture the source of data, any business rule to be applied to meet the internal customer needs of data.
• Designed OLTP system environment and maintained documentation of Metadata.
• Met with the data modeling team once every week and discuss the standards and other data modeling related issues.
• Performed ETL SQL optimization.
• Wrote PL/SQL statement, stored procedures and Triggers in DB2 for extracting as well as writing data.

Environment: Erwin r8.2, Oracle SQL Developer, OracleDataModeler, Teradata 14, SSIS, Business Objects, SQL Server 2005/2008, ER/Studio Windows XP, MS Excel.

Confidential, Ann Arbor, MI

DataModeler/DataAnalyst

Responsibilities:

• Demonstrated strong analytical skills in identifying and resolvingdataexchange issues.
• Executed SQL queries to retrievedatafrom databases for analysis.
• Extensively used reverse engineering feature of Erwin to save thedatamodel with production.
• Worked with Business Analyst during requirements gathering and business analysis to prepare high level LogicalDataModels and PhysicalDataModels.
• Created 3NF business areadatamodeling with de-normalized physical implementationdataand information requirements analysis using ERWIN tool.
• Deployed naming standard to theDataModel and followed company standard for Project Documentation.
• Resolved thedatatype inconsistencies between the source systems and the target system using the mapping documents and analyzing the database using SQL queries.
• PerformedDataModeling, Database Design, andDataAnalysis with the extensive use of Erwin.
• Led enterprise logicaldatamodeling project (in third normal form) to gatherdatarequirements for OLTP enhancements.
• Proficient in GUI, Relational Database Model (RDBMS), designing of OLAP system environment as well as Report Development.
• Extensively used SQL, Transact SQL and PL/SQL to write stored procedures, functions, packages and triggers.

Environment: CA Erwin 8, Oracle10g, SQL server 2012, IBM DB2, Informatica Power Center 8.6, SQL BI 2008, Oracle BI, Visual Studio, SSIS&SSRS, SQL server management studio 2012.ER Studio (8.0), Crystal Reports9, Windows XP, Excel, Power Point.

Confidential, RI

DataModeler/DataAnalyst

Responsibilities:

• Database Design (Conceptual, Logical and Physical) for OLTP and OLAP systems
• Created and developed Slowly Changing Dimensions tables SCD2, SCD3 to facilitate maintenance of history.
• Created documents for technical & business user requirements during requirements gathering sessions.
• Turned SQL queries to make use ofdatabase indexes, and analyzed thedatabase objects.
• Created Logical and Physical EDW models anddatamarts
• Experienced indatamigration and cleansing rules for the integrated architecture (OLTP, ODS, DW).
• Managed all indexing, debugging and query optimization techniques for performance tuning using T-SQL.
• Developed the logical and physical model from the conceptual model developed using a tool Erwin by understanding and analyzing business requirements.
• Handleddataloading operations from flat files to tables using NZLOAD utility.
• Experienced indatacleansing for accurate reporting. Thoroughly analyzed thedataand integrated differentdatasources to process matching functions.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.

Environment: ERWIN r7.2, PL/SQL, MS SQL, Sybase 12, Ms Visio, Business Objects, Windows NT, Linux, Sybase Power Designer.Oracle 8i, Erwin 4.1, SQL Server, Windows XP, MS Excel, Informatica.

Confidential, Chicago, IL

Sr. Data Modeler/Analyst

Responsibilities:

• Participated in all phases of project including Requirement gathering, Analysis, Design, Coding, Testing, Documentation and warranty period.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Analyzed the business requirements by dividing them into subject areas and understood thedataflow within the organization
• Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
• Created a list of domains in Erwin and worked on building up thedatadictionary for the company
• Created DDL scripts for implementingDataModeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, PublishedDatamodel in model mart, created naming convention files, co-coordinated with DBAs' to apply thedatamodel changes.
• Extensively used Normalization techniques (up to 3NF).
• Writing complex queries using Teradata SQL.
• Worked with the ETL team to document the transformation rules fordatamigration from source to target systems.
• Developed source to target mapping documents to support ETL design.
• Developed the logicaldatamodels and physicaldatamodels that capture current state/future state dataelements anddataflows using ER Studio.
• Created PhysicalDataModel from the LogicalDataModel using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Responsible for migrating thedataanddatamodels from SQL server environment to Oracle 10g environment.
• Designed the physical model for implementing the model into oracle 10g physicaldatabase.
• Used ER Studio to create logical and physicaldatamodels for enterprise wide OLAP system.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis.
• Supported QA/ETL teams in ensuring proper implementation of the requirements and developed and executed test plans and test scripts for testing and UAT (User Acceptance Testing).

Environment: Erwin r9.0, ER Studio, SQL, SQL Server 2000/2010, Rational Rose, Crystal Reports 9, Windows XP, PL/SQL, Business Objects XIR2, ETL Tools Informatica9.5/8.6/9.1 Oracle 10g, Teradata V2R13/R14.10, Teradata SQL Assistant 12.0, Netezza, Power Designer

Confidential

Data Modeler/Analyst

Responsibilities:

• Handled QA reviews are cutover activities very well.
• DevelopedDataMapping,DataGovernance, Transformation and Cleansing rules for the Master DataManagement Architecture involving OLTP, ODS and OLAP.
• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using Erwin.
• Analyzed thedataand provide resolution by writing analytical/complex SQL in case ofdata discrepancies.
• Tuning and code optimization using different techniques like dynamic SQL, dynamic cursors, and tuning SQL queries, writing generic procedures, functions and packages.
• Responsible for Relationaldatamodeling (OLTP) using MS Visio (Logical, Physical and Conceptual).
• Designed, developed and implemented solutions withdatawarehouse, ETL,dataanalysis, and BI reporting technologies.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using ER Studio.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Extensively worked on development of mappings with BODS Transformations like Map Operation, Table Comparison, History Preserving, Key Generation, Pivot, Reverse Pivot etc.
• Responsible for design of logical and physicalDatamodel for client's investment management ODS using dimensional modeling.

Environment: Erwin, Oracle 8i, Developer 2000 with Forms 5.0 and Reports 3.0, O, Windows XP, PL/SQL, MS-Access, Sql Server, MS Office, MS Visio, Informatica Power center 5.1, Teradata SQL Assistant