PROFESSIONAL SUMMARY

• 7+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitateddatarequirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprisedatastores within a metadata repository.
• Established and maintained comprehensivedatamodel documentation including detailed descriptions of business entities, attributes, anddatarelationships.
• Developed mapping spreadsheets for (ETL) team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, and corporate meta-datadefinitions.
• Exceptional communication and presentation skills and established track record of client interactions

Technical Skills

• Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0.1and Oracle Designer
• OLAP Tools: Microsoft Analysis Services, Business Objects, and
• ETL Tools: Microsoft SSIS and Informatica 7.1.3 ,
• Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML,XML, VB.NET
• Database Tools: Microsoft SQL Server 2000/2005/2008, DB2, Oracle 10g/9i and MS Access, Teradata
• Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects
• Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Nov 2011 - Present.
Redmond, WA
Role - Sr. Data Modeler

Confidential, is an American multinational corporation based in Redmond,
Washington, United States that develops, manufactures, licenses, and supports a wide range of products and services related to computing. It is the largest software corporation in the world measured by revenues.

Project: There were multiple projects launched as part of the MS Cloud Initiative and Cloud BI was aimed at creating an enterprise data warehouse and business intelligence solution for MS Cloud Services by integrating and consolidating the data of online services. Cloud BI was a long-term phased BI solution for an enterprise wide reporting platform for MS Cloud services.

Responsibilities:

• Gathered various reporting requirement from the clients and Solution Architects.
• Integrated the MS Cloud offerings and provided the core platform for the business Intelligence solution.
• Provided the preliminary set of metrics for report generation and Report Delivery mechanism through MS Reporting Analytics.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse Engineering the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving Confirmed dimensions.
• Created Test Cases and Helped ETL team in performing Smoke and Regression Testing.
• Created Source to Target mappings for Billing, Customer and Product related Dimensions and Facts.
• Created and maintained the Data Model repository as per company standards.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to Support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.

Environment: ER Studio 9.1, SQL Server 2008 R2, SSIS, SSRS, PL/SQL, Informatica
Power Centre 6.0, Content Management System, SharePoint, Teradata

Confidential, Sep 2010 - Sep 2011
Dover, NH
Role: Sr. Data Modeler / Data Analyst

Liberty Mutual's Personal Markets provides full lines of coverage for private passenger automobile, homeowners, valuable possessions and personal liability through its own sales force in more than 400 offices throughout the U.S

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for data warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation.

Environment: Erwin r7.1, Informatica 7.1.3, Windows XP/NT/2000, SQL Server 2000/2005, Teradata, Oracle10g,DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential, Jan 2009- Sep 2010
New York city, NY
Role - Sr. Data Modeler

Project: The objective of this project is to develop a data warehouse to fulfill reporting needs and develop new marketing strategies. The data comes from source systems such as life applications to feed the business intelligence system. Apart from this there was data coming from flat files and other databases too. Tracking insurance policies and investments in marketing tables to drive better decision making by integrating relevant data into the Data Warehouse is the requirement to be designed and implemented.

Responsibilities:

• Worked on multiple projects with different business units including Insurance actuaries
• Gather the various reporting requirement from the business analysts.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Created and maintained the Data Model repository as per company standards.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models;
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
• Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server usingSSIS.

Environment: CA ERWIN r7, Oracle 10g, SQL Server 2008,Teradata,PL/SQL, PeopleSoft V8, Toad, Informatica ,Power Centre 6.0, Case Management System, Business Objects

Confidential, Dec 2006 - Dec 2008
Cherry Hills, NJ

ACS client (Gannett) is a media and marketing solutions company with a diverse portfolio of broadcast, digital, mobile and publishing companies.).The Health and welfare benefits for Gannett employees were maintained by ACS.

Role- Data Analyst/Data Modeler

Project- The Project Involved building a centralized Data ware house to support the reporting projection analysis at corporate level.

Responsibilities:

• Conductedmajor stakeholder interviews involving SME's, Business Analysts and other stakeholders to determine the requirements.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Identified and compiled common business terms for the new health care system that become central part of communication among project stakeholders to avoid ambiguity.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use .
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Developed the required data warehouse model using Star schema for the generalized model.
• Used forward engineering approach for designing and creating databases for OLAP model.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required.

Environment: CA Erwin, MS Visio, Oracle 9i, Oracle Designer, SQL Server 2005,Informatica, Crystal Reports 9, XML, Rational Rose and SQL Server Reporting Services

Confidential, Aug 2005 - Oct 2006 Gurgaon, India
Role - Data Analyst

Responsibilities:

• Designed an OLTP database in 3NF to handle the day-to-day needs of the business, and database performance is tuned for those needs.
• Developed, tested, managed and documenteddatawarehouseoperations and tasks.
• Assisted in the design the overall ETL processes and architecture.
• Performed complexdataanalysis in support of ad-hoc requests.
• Analyzesdatato identify root-cause of issues related todatawarehouseand ETL processes and Provided troubleshooting expertise in resolving technical issues.
• Developed processes that define, support and enforce information anddataquality standards.

EDUCATION

B.E Computer Science