SUMMARY

• Over 8 years of Experience inDataAnalysis and developing Conceptual, logicalmodels and physicaldatabase
• Experienced working withdatamodeling tools like Erwin, PowerDesigner and ERStudio.
• Experienced in designing starschema, Snowflakeschema forDataWarehouse, ODSarchitecture.
• Experienced in Requirementgathering, Systemanalysis, handlingbusiness and technicalissues& communicating with both business and technicalusers.
• Designed theDataMarts in dimensionaldatamodeling using star and snowflakeschemas.
• Very proficient withDataAnalysis, mappingsource and targetsystems fordatamigration efforts and resolving issues relating todatamigration.
• Experience DataScrubbing/Cleansing,DataQuality,DataMappingDataProfiling,DataValidation in ETL.
• Experienced in creating and documenting Metadata for OLTP and OLAP when designing a systems.
• Excellent knowledge of RalphKimball and BillInmon's approaches toDataWarehousing.
• Extensive experience in development of T - SQL, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for businesslogic implementation.
• Proficient in System Analysis, ER/DimensionalDataModeling, Database design and implementing RDBMS specific features.
• Experience in developing Entity-Relationshipdiagrams and modeling Transactional Databases andDataWarehouse using tools like ERWIN, ER/Studio and PowerDesigner.
• Excellent experience with modeling using ERWIN in both forward and reverse engineering cases.
• Efficient in enterprisedatawarehouses using Kimballdatawarehouse and Inmon's methodologies.
• Solid experience inDatawarehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.
• Excellent Team player to work in conjunction with Businessanalysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions.

TECHNICAL SKILLS

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

ETL Tools: Informatica Power Center, Data Stage 7.5, Ab Initio, Talend

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 2013, DB2 V9.5, Teradata V2R6.1, MS Access 2000

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

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

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant

Tools: MS-Office suite (Word, Excel, MS Project and Outlook), VSS

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, VB.NET

PROFESSIONAL EXPERIENCE

Confidential, Southfield, MI

Sr. Data Analyst/Data Modeler

Responsibilities:

• Interacted with business users to understand the business requirements.
• Coordinated with Business analysts to understand the business challenges anddatafor reporting.
• Designing, Installing & Configuring core Informatica MDM Hub components Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter and IDD & Data Modeling.
• Worked on EDW of More than 12 TB.
• Justified and installed PowerDesigner data modeling product suite and used to develop major business subject data models, as a basis for conformed dimensions and master data.
• Documented the design conventions used for performing database modeling.
• Reverse engineered the new EDW using PowerDesigner and fully documented the enterprise warehouse including definitions, domain values, relationships, indexes and annotative information.
• Responsible for ensuring and providing consistent metadata across all the models.
• Knowledge in NCQA HEDIS measures and specifications
• Educate staff on HEDIS measures, share best practices and collaborate on ways to close care gaps.
• Created partitions and indexes for the tables in thedatamart.
• Maintained metadata(datadefinitions of table structures) and version controlling for thedatamodel.
• Administration & Support of all the BI servers and technologies (Informatica, Informatica Cloud, Business Objects, PowerDesigner).
• Conducted design reviews with business analysts, Enterprisedataarchitect and solution lead to create proof of concept for the reports.
• Developed SQLscripts for creating tables, Sequences, Triggers, views and materializedviews.
• Developed SQLscripts for loadingdatafrom staging area to target tables.
• Conducted performance analysis and created partitions, indexes and Aggregate tables.
• Developed SQL scripts for loading the aggregate tables and rollup dimensions.
• Performed unit testing, system integrated testing for the aggregate tables.
• Performeddataanalysis on the target tables to make sure thedataas per the business expectations.
• Studied the existing BI architecture and analyzed the existing systems to propose the alternate solutions.
• Wrote programs to model econometric regressions on statistical software (SAS, Stata) to solve complex economic problems
• Using the current Alpha Roster and TAA database as reference sources; pulled reports from SAS.
• Proposed the EDWdatadesign to centralize thedatascattered across multiple datasets. The proposal also address thedataduplications,datain consistencies,dataquality management etc.
• Performed theDataMapping,Datadesign (DataModeling) to integrate thedataacross the multiple databases in to EDW.
• Involved in the creation of reporting universes in SAP Business Objects, SAP Netweaver and SAP Solution Manager

Environment: Oracle 12c, Toad for Data Analysts 2.5.1, Toad for Toad Data Modeler 3.4, SQL Plus, Erwin Data Modeler 8.2, Erwin Model Manager 8.2, MS Visio, Powerdesigner, Source Offsite (SOS), Windows 7, QC Explorer, Business Objects, Share point workspace 2010, Oracle SQL Developer.

Confidential, SFO, CA

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and PhysicaldataModels.
• Translated the business requirements into detailed production level using WorkflowDiagrams, SequenceDiagrams, ActivityDiagrams and UseCaseModeling
• Identified and compiled common business terms for the new policy generating system and also worked on contract Subject Area.
• Created a high-level industry standard, generalizeddatamodel to convert it into logical and physical model at later stages of the project using Erwin and Visio.
• Notified the supervisors of Limited Duty employees of their permanent restriction status and MAB Core Doc changed and updated employee records in SAS
• Identified and Defined entities, relationships and attributes in thedatamodel as per new specifications in Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.
• Enforced referential integrity in the OLTPdatamodel for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed DataMapping, DataGovernance& transformation and cleansing rules for the MasterData Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions todataissues and other challenges while implementing the OLAP model.
• Prepared analytical and status reports and updated the project plan as required.Responsible for migrating thedataanddatamodels from SQL server environment to Oracle environment.
• Designed the physical model for implementing the model into oracle physicaldatabase.
• Used Erwin to create logical and physicaldatamodels for enterprise wide OLAPsystem.
• Generated comprehensive analytical reports by running SQLqueries against current databases to conductdataanalysis.
• Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Extensively used MSVisio for representing existing and proposeddataflow Diagrams.
• Participated in JADsessions to solve the revolving issues between the executive teams and developers.

Environment: Erwin R8.2.5, MS Visio, Oracle 11g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, DATAFLUX 6.1, PL/SQL Developer, SQL/PL SQl, SQL Navigator Crystal Reports 9.

Confidential, Gardner, KS

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.
• Used Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in the creation, maintenance ofDataWarehouse and repositories containing Metadata.
• Involved in the study of the businesslogic and understanding the physicalsystem and the terms and condition for database.
• Responsible as a member of development team to provide businessdatarequirements analysis services, producing Logical and Physicaldatamodels using Erwin
• DevelopedDataMigration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW)
• Created documentation and testcases, worked with users for new module enhancements and testing.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Utilized PowerDesigner'sforward/reverseengineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensionaldatamodels. Designed thedatamarts in dimensionaldatamodeling using star and snowflake schemas.
• Developed SQLQueries to fetch complexdatafrom different tables in remote databases using joins, database links and Bulk collects.
• Used DataStage Manager for importing metadata from repository, new job categories and creating newdataelements.
• Developing reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by the team and satisfying the business rules
• Written Procedures and Functions using Dynamic SQL and written complex SQLqueries using joins, sub queries and correlated sub queries.
• Designed and developed UseCases, ActivityDiagrams, SequenceDiagrams, OOD (Object oriented Design) using UML and Visio.

Environment: Erwin7.3, Oracle10g, SQL server, MS Excel, MS Visio, Rational Rose, Requisite Pro, Rational, Oracle 10g, Developer 2000 with Forms 5.0 and Reports 3.0, O, Windows XP, PL/SQL,, SQl Server, MS Office, MS Access, MS Visio.

Confidential, Westchester, PA

Sr. Data Analyst/Data Modeler

Responsibilities:

• Created project plan by gathering the requirements from the management.
• Used SybasePowerDesigner tool for relationaldatabase and dimensionaldatawarehouse designs
• Conduct HEDIS provider chart request calls and faxes to support medical record capture for HEDIS supplemental data review and abstraction
• Requirement gathering from the users by conducting a series of meeting with the business system users to gather the requirements for reporting.
• Identification of risks in schedule and marking them in the Use Cases.
• Extensively used Star Schema methodologies in building and designing the logicaldatamodel into Dimensional Models
• CreatedBest-Fit PhysicalDataModel from the LogicalDataModel using Forward engineering using Erwin
• Generated scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)
• Identify source systems, their connectivity, related tables and fields and ensuredatasuitably for mapping.
• CreatingDataDefinitions and the MetaDataRepository
• Validated the model and ran alternate scenarios/sensitivity analysis.
• Implemented the model and communicated it to end-users and stakeholders.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Performance tuning of the database, which includes indexes, and optimizing SQLstatements, monitoring the server.
• Used SQL to run ad-hoc queries and prepare reports to the management.

Environment: SQL Server 2005, Sybase12, Sybase Power Designer, UML, Business Objects 5, Teradata, Windows NT/2000, SSIS, SSRS,, DB2, Informatica, Query Management Facility (QMF),DataStage, Clear Case forms, Unix and Shell Scripting.