SUMMARY:

• Over 8years of working experience as aDataModelerandDataAnalyst wif high proficiency in requirement gathering anddatamodeling including design and support of various applications in OLTP,DataWarehousing, OLAP and ETL Environment
• A goods experience wif ACOs, PCMHs, EOCs and their Clinical measures wif Enterprise Data Models around Healthcare Claims
• Prepared status reports on project work and workplan progress wif Erwin 9.6.
• Experience in analysis, design, development and implementation of Data warehouses, data marts using Informatica Power Center wif Oracle, MS SQL server, DB2, Microsoft access and Teradata, Netezza databases
• A good experience in implementing and supporting Identity and Access Management environments comprised of Oracle Identity Manager (OIM), Oracle Internet Directory, Oracle Virtual Directory, Oracle Access Manager (OAM) and MS Active Directory.
• Excellence in delivering Quality Conceptual, Logical and PhysicalDataModels for Multiple projects involving various Enterprise New and Existing Applications andDataWarehouse.
• Experienced in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Proficient indatamart design, creation of cubes, identifying facts & dimensions, star&snowflake schemes
• Expert in developing transactional enterprisedatamodels dat strictly meet normalization rules, as well as EnterpriseDataWarehouses using Kimball and InmonDataWarehouse methodologies.
• Excellent experience wif Conceptual Data Modeling, Enterprise Data Modelling, Logical/Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design, Metadata, Data Quality, MasterData Management and Data Governance.
• Experienced inDataModeling using designed toolErwin, Oracle SQL Developer, SQlServer Management studio, MySQL, SQLPlus and Toad.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL. Performance tuning and query optimization techniques in transactional anddatawarehouse environments.
• Expertise inDatawarehouseData& ETL Architecture, Worked wif variousdatasources such as Oracle, SQLServer, Teradata&Netezza
• ManagementofDataintegrity,Datastandard,Dataenhancement,Datapublishing,datacapture,datamigration,Dataauditing,DataQuality,DataException Handling process,DataRejection process, Metadata, workflow
• Handled all oracle database development, PL/SQL,SQL programming, ETL, OLAPreporting, job automation, query tuning, replication, migration, conversion, performance tuning, backup
• Having experience in writing complex SQLqueries to perform end - to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.
• Excellent noledge on creating reports on SAP Business Objects, Webi reports for multipledata providers.
• Strong Database experience using Oracle, Teradata, DB2, SQLserver, Netezza.
• Used Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, Tableau, Microstrategy and Business Objects
• An excellent team player& technically strong person who TEMPhas capability to work wif business users, project managers, team leads, architects and peers, thus maintaining healthy environment in teh project.

TECHNICAL SKILLS:

Analysis and Modeling Tools: Erwin 8.0, r9, Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio

ETL Tools: Informatica Power Center 9.6/9.5, Talend, Pentaho

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, CognosPowerplay

Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C++, AWK

Databases: MS SQL Server 2005, DB2 V9.5, Teradata R14/R13/R12, MS Access 2000, Netezza

Operating Systems: Windows 8/7, UNIX (Sun Solaris 10)

Project Execution Methodologies: Ralph Kimball and BillInmondatawarehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

Sr. Data Analyst/Data Modeler

Responsibilities:

• Performed teh mapping effort for various development teams by mapping their applicationdatarequirements to teh model and providing consistent standardized language for communication between teh development teams.
• Developed ETL programs using Informatica to implement teh business requirements.
• Worked on re-creating Informatica cloud tasks in Informatica PowerCenter
• Worked on Integration OIM Application using Disconnected Approach and customizing reconciliation using Flat File Connector
• Worked wif data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
• Gathered and analyzed existing physicaldatamodels for in scope applications and proposed teh changes to thedatamodels according to teh requirements.
• Refined teh existing model resulting from project teams mapping theirdatarequirements for existing systems to thedatamodels as a part of teh SDLC project methodology.
• Worked wif teh Business and teh ETLdevelopers in teh analysis and resolution ofdatarelated problem tickets and other defects.
• Generated and DDL (DataDefinition Language) scripts using ERWIN and assisted DBA in Physical Implementation ofdataModels.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram) using Erwin
• Worked wifdatain teh tables to analyze and modify by writing DML scripts.
• Created Source- Target SQL scripts for all teh transformation rules mentioned in teh mapping document.
• Periodic checking of all databases wif DBCC commands for maintainingdataconsistency and integrity.
• Coordinated wif back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Worked wifdatain teh tables to analyze and modify by writing DML scripts.
• Supported teh DBA in teh physical implementation of teh tables in both Oracle and DB2databases.
• Transformed requirements intodatastructures which can be used efficiently to store manipulate and retrieve information.
• Created entity process association matrices, functional decomposition diagrams anddataflowdiagrams from business requirements documents.

Environment:ERWIN 9.5, Power Designer 16.5, DATAFLUX, PL/SQL Developer, Oracle 12c, SQL/PL SQl, SQL Navigator, Windows NT, UNIX, Microsoft Access, Microsoft Visio, SQL Server 2012, MS PowerPoint, MS Access 07, Microsoft Excel 07

Confidential, McLean, VA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Interacting wif business users to analyze teh business process and requirements and transforming requirements into Conceptual, logical and PhysicalDataModels, designing database, documenting and rolling out teh deliverables.
• Implemented & built mappings on Informatica On-Cloud.
• Supported Informatica Cloud Data Synchronization, Data Replication tasks
• Designed Role management process and customize workflows in OIM
• Involved in OIM installation and configuration and OHS installation
• Applied Data Governance rules (Class words and valid abbreviation in Table name and Column names).
• Involved in capturing data lineage, table and column data definitions, valid values and others necessary information in teh data models.
• Identifying teh facts & dimensions; grain of teh fact; aggregate tables, etc for Dimensional Models.
• Developing Snowflake Schemas by normalizing teh dimension tables as appropriate.
• Involved in importing, cleaning, transforming, validating or modelingdatawif teh purpose of understanding or making conclusions from thedatafor reporting purposes
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snowflakeSchemas
• Collaborated wif thedatawarehousing team, ensuring datdatainfrastructure supports teh needs of analytics team and validatingdataquality.
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Wrote complex SQLqueries for validating thedataagainst different kinds of reports generated by Business Objects XIR2
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flatfiles, SQLServer wif high volumedata.
• Present thedatascenarios via, Erwinlogicalmodels and excel mockups to visualize thedata better.
• Used Oracle and Toad to create and manage oracle schemas, Backup Oracle schema, exportData for Individual tables, tune SQL performance.
• Worked very close wifDataArchitectures and DBA team to implementdatamodel changes in database in all environments. Generated DDLscripts for database modification, TeradataMacros, Views and set tables.
• Worked extensively inDataAnalysis, Design, Development, Testing and Implementation of various Applications in UNIX environment.

Environment: Oracle12c, ErwinDataModeler8.6, Toad for Oracle 9.6.1, Informatica Power Center 8.6, Business Objects XI release 2 -Designer, Desktop Intelligence, WEBI, SQL Server 2008, Visio, PowerPoint, Cognos

Confidential, Columbus, OH

Sr. Data Analyst Data Modeler

Responsibilities:

• Involved in defining and managing enterprise-widedatasemantics
• Performeddatamodeling, logical and physical database design based on modeling tools available on teh project, and business functions of teh system.
• Involved in defining teh ETL process flow from teh OLTP to teh reporting database.
• Worked wif data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Participated in weekly technical huddle meeting wif development and DBA team. Participated in weekly data analyst meting and submit weekly data governance status.
• Designed & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Involved in database design for both online transaction 3rd normal form and dimensional models, DataWarehousing, DataMigration, Data Staging, Applications Design and Business Process Re-engineering.
• Prepared teh technical design document for teh complete ETL process and provided teh same to teh development team to work on.
• Worked wif Database Administrators (DBA) to build conceptual and physical database models and createdDDL for DBA/application team.
• Involved in implementing teh ETLprocess using PL/SQL and participated in discussions on thedata requirements for business.
• Performance tuning of teh database, which includes indexes, and optimizing SQL statements.
• Maintaining,datarepositories anddatanaming standards. This entailed identifying and documenting, business functions, activities and processes,dataattribute and table meta-data, and general and detail design specifications.

Environment: MS Project, MS-Excel, MS Visio, JCAPS, Oracle 11g, CA Erwin8.2, Informatica 8.1, Websphere MQSI, Websphere MQ, UML, Rational Rose, Win NT

Confidential, CO

Sr. Data Analyst/Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Responsible for teh analysis of business requirements and design implementation of teh business solution.
• Developed Conceptual, Logical and Physicaldatamodels for central model consolidation.
• Used Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Facilitated transition of logicaldatamodels into teh physical database design and recommended technical approaches for gooddatamanagement practices.
• Worked wif DBA group to create Best-FitPhysicalDataModel from teh LogicalDataModel using ForwardEngineering.
• Involved in designingDatamarts by using Star Schema and Snowflake schema.
• Extensive system study, design, development and testing were carried out in teh Oracle environment to meet teh customer requirements.
• Designed thedatamarts in dimensionaldatamodeling using star and snowflakeschemas.
• Redefined attributes and relationships in teh model and cleansed unwanted tables/columns as part ofdataanalysis responsibilities.
• Worked on teh reporting requirements and involved in generating teh reports for theDataModel.
• Identified/documenteddatasources and transformation rules required to populate and maintaindata warehouse content.
• Generated DDLstatements for teh creation of new database objects like table, views, indexes, packages and stored procedures.
• Used DataStage Manager for importing metadata from repository, new job categories and creating newdataelements
• Tuning and code optimization using different techniques like dynamic SQL, dynamiccursors, tuningSQLqueries, writing generic procedures, functions and packages
• Developing reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by teh team and satisfying teh business rules

Environment: Erwin r7.3, Informatica, Oracle, MS Excel, MS Visio, Crystal Reports, Teradata,, SSIS, Informatica Power Center, DB2 Version 9.0, Rational Rose

Confidential

Data Analyst / Data Modeler

Responsibilities:

• Analyzed Business Requirements and segregated them into high level and low level UseCases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UMLmethodology thus defining theDataProcess Models.
• Oracle SQL experience. Wrote SQLqueries for each Test case and executed in SQLPlus to validate thedatabetween EnterpriseDataWarehousing andDataMart Staging Tables.
• Created/Revieweddataflow diagram to illustrate wheredataoriginates and howdataflows wifin teh EnterpriseDatawarehouse (EDW).
• Worked on Performance, Tuning and loadingdatafor fast access of reports in Client/Database. Server balancing, business Rules Implementation, Metadata,DataProfiling.
• Collected business requirements to set rules for properdatatransfer fromDataSource toData Target inDataMapping.
• Used complexSQL query skills (Oracle and TSQL) in analyzing and validating ETL databasedataware house processes.
• Prepared teh logical and physical models for teh new database dat is being built.
• Develop and maintain sales reporting using in MSExcelqueries, SQL in Teradata, and MSAccess. Produce performance reports and implement changes for improved reporting.
• Database table review anddatamapping for large scaledataconversion project Mainframe to Oracle database.
• Written complex SQLqueries for queryingdataagainst differentdatabases fordataverification process.
• CreatedDataDictionary and ERdiagrams fordatamapping purposes.
• Responsible to design, develop and test teh software (Informatica, PL SQL, UNIXshell scripts) to maintain thedatamarts (Loaddata, Analyze using OLAP tools).

Environment: MS Access,DataFlux, Oracle, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata V2R6