SUMMARY

• 10 years of Industry experience as a DataAnalyst and Data Modeler with solid understanding of Data Modeling,Data Analysis,Data Profiling, creating Data Mapping documents and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Excellent Analytical skills to understand the Business Process and Functionality. Developing Functional Specifications for business process refinement and automation,Data Modeling, system architecture, and conducting feasibility studies.
• 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.
• Work on Background process in oracle Architecture. Also drill down to the lowest levels of systems design and construction.
• Comprehensive knowledge and experience in process improvement, normalization/de - normalization.
• Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT & Dimension tables.
• 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.
• As anArchitectUML models and leverage the advanced executable code generators to target different domains.
• 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.
• Determine the physical architecture of oracle ( Datafiles"*.dbf", Controlfiles " *.ctl") EST.
• 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, Woonsocket, RI

Sr. Data Modeler/ Data Architect

Responsibilities:

• Actively involved in the Design and development of the Star schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Defined and implementedDataGovernanceand MDM strategy, framework and roadmap at an insurance client (AJG).
• Worked with the developers in deciding the application architecture.
• Worked with reversed engineer Data Model from Database instance and Scripts.
• Responsible for Dimensional Data Modeling and Modeling Diagrams using ERWIN.
• Designed semantic layer data model. Conducted performance optimization for BI infrastructure.
• Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
• ConfiguredSybaseReplication Server to manage synchronization of data across the enterprise.
• Involved in the integration ofdatacoming from different sources.
• Involved in the creation, maintenance ofDataWarehouse and repositories containing Metadata.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating newdataelements.
• As anArchitectimplement MDM hub to provide clean, consistentdatafor a SOA implementation.
• Deliver value to client by re-architecting their Data warehouse and institutingdatagovernance.
• Designed different type of STAR schemas like detaileddatamarts and Plandatamarts, Monthly Summarydatamarts using ER studio with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Developed and maintaineddatadictionary to create metadata reports for technical and business purpose.
• Preparation of data dictionary / business glossaries and also integrating Data dictionary into data models
• Developed strategies fordatawarehouse implementations,dataacquisitions, provided technical and strategic advice and guidance to senior managers and technical resources in the creation and implementation fordataarchitecture anddatamodeling.
• Involved in extensiveDatavalidation by writing several complex SQL queries and Involved in back-end testing and worked withdataquality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and tested the testing programs.
• Design and development of ETL routines to extractdatafrom heterogeneous sources and loading to ActuarialDataWarehouse.
• Involved in preparing LogicalDataModels/PhysicalDataModels.
• Identify source systems, their connectivity, related tables and fields and ensuredatasuitably for mapping.
• Expertise in creating and maintaining the requirement documentation like system use cases, supplementary specification documentation, andbusinessglossaryas per the industry standards.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using in Transact SQL of bothSybase& SQL Server.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Worked on HL7 2.x file format (ADT and clinical messages) onMEDIFAXand a thorough understanding of how interface development projects work.
• Developed company-widedatastandards,datapolicies anddatawarehouse/business intelligence architectures.
• Designed and documented Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Performeddatacleaning anddatamanipulation activities using NZSQL utility.
• Excellent knowledge and experience in Technical Design and Documentation.
• Designed and Developed OraclePL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2.
• Worked withdatainvestigation, discovery and mapping tools to scan every singledatarecord from many sources.
• Designing Logical data models and Physical Data Models using Erwin.
• Developing the Conceptual Data Models, Logical data models and transformed them to creating schema using ERWIN.

Environment: DB2, CA Erwin 7.0, Oracle 11g, MS-Office, SQL Architect, TOAD Benchmark Factory, SQL Loader, PL/SQL, SharePoint, ERwin r8.0 and Erwin r9.0, MS-Office, SQL Server 2008/2012.

Confidential, Boston, MA

Sr. Data Modeler/ Data Architect

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.
• Evaluated theDataGovernancematurity level within the client organization and scoped thedata governanceimplementation to addressdataquality on Infosphere platform.
• PrepareDataArchitecture &Datadesign to present it to client.
• 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.
• Build the Dynamic module to extract and load thedataintoEDWin Data Stage.
• Involved in integration of multiple source systems into MDM and Participated actively indata profiling and mapping exercises to defineDataArchitecture.
• Involved in preparing modeling estimates, DFD, Volumetric, defining enterprise standards for best practices.
• Experienced with integration of heterogeneous data sources likeSybase, SQL Server, Oracle and Flat Files (Fixed & delimited) into Staging Area.
• 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.
• Used IBM info Sphere and Metadata Workbench fordatamapping, data governance anddatalineage purpose.
• Researched and documented data dictionary,glossaryvia interviews.
• 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.
• Lead the development, documentation, and implementation of process enhancements reports using SAP, CRM and BW to ensure masterdatagovernance.
• 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.
• Working directly with client leadership. Worked on different scenarios with respect to DataGovernance.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating newdataelements.
• Created aBusinessGlossarythat defined the terms used during modeling.
• 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, Logical Data models and transformed them to creating schema using ERWIN.
• Worked very close withDataArchitectures and DBAteam to implementdatamodel changes in database in all environments.
• Involved in migration ofdatastage8.7 to IBM Info SphereDatastage.
• Developed data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Developed enhancements toMongo DBarchitecture to improve performance and scalability.
• 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.
• Researched and documented data dictionary,glossaryvia interviews.
• Worked with Data governance, Data quality, data lineage, data architect to design various models and processes.
• 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.
• Involved in preparing the design flow for theDatastageobjects to pull thedatafrom various upstream applications and do the required transformations and load thedatainto various downstream applications
• 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.
• DevelopedDataMapping,DataGovernance, Transformation and Cleansing rules for the Master DataManagement Architectureinvolving OLTP, ODS and OLAP
• 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.
• Designing & Creating ETL Jobs throughDataStageto load huge volumes ofdatainto HBase, Hadoop Ecosystem and Relational databases
• 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.
• BusinessProcessEngineerfor the Infrastructure Team that supports VES’s global network ofdatacenters and portfolio of secure cloud-based solutions.
• 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

Data Modeler/Data Analyst

Responsibilities:

• Demonstrated strong analytical skills in identifying and resolvingdataexchange issues.
• Developed new buisnessprocessesor revised existingprocessesto ensure compliance with corporate, security and privacy policies.
• Executed SQL queries to retrievedatafrom databases for analysis.
• Extensively used reverse engineering feature of Erwin to save thedatamodel with production.
• DevelopedDataMapping,DataGovernance, and Transformation and cleansing rules for theMasterData Management Architecture involvingOLTP, ODS
• 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

Data Modeler/Data Analyst

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.
• Optimized utilization of IT Enterprise Architectural resources through the design and implementation of a pre-project mode Resource businessprocess.
• Created documents for technical & business user requirements during requirements gathering sessions.
• Create thebusinessvision document andglossary, mock reports.
• 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.
• Participated in an IT wide Requirements Management Program as a Project Manager, deploying the buisbess processto Product Managers and their teams.
• 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.
• Collaborated with the Manager of businessProcessDevelopment in creation of metrics for theprocess
• Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA.
• Possess strong documentation skills including creating user manuals, training manuals, data glossaryand data dictionaries
• 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