SUMMARY:

• 9+ yearsin Information Technology with Expertise in Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Worked also as a Business Analyst and conducted Requirement Gathering Session, Joint Application Requirements (JAR), understanding Business Requirements and developing some functional documents like FSD, SRS etc.
• Well versed in conducting Joint Application Design (JAD) and Joint Requirement Planning (JRP) sessions,User Acceptance Testing (UAT), Gap analysis, Cost benefit analysis and ROI analysis.
• Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with UseCase Modeling and UML.
• Exposure in overallSDLCincluding requirementgathering, development, testing, debugging, deployment, documentation, production supportand Extensive experience in Project Management methodologies, MicrosoftSQL Server database management, OBIEE.
• Involved in various projects related toData 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 bothOLTP and OLAPapplications.
• Hands on experience in major RDBMS like Teradata, Oracle.
• Practical understanding of theData 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 ofviews, 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.
• Handled Multiple Projects at a time and successfully met several intersecting deadlines to yield Business Deliverables.
• Worked extensively on Spreadsheets, Word Documents, UML Diagrams (Use Cases).
• Complete understanding and hands on experience of Pharmacy Benefit Management System and Health Insurance in the United States, in depth knowledge of Health Care Laws and ICD Standards Updating ICD 9 to ICD 10.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r7.1/7.2,7.3 Erwin R8, ER Studio and Oracle Toad Modeler

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9

ETL Tools: Microsoft DTS/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/2008, Teradata, Oracle 11g/10g/9i, and MS Access

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Cedar Rapids, Iowa

Sr. Data Modeler / Analyst

Responsibilities:

• Thorough understanding and hands on experience of software development life cycle from Ideation to Implementation.
• Led Requirement gathering for retrofitting existing ODS to reflect the new Business Ask and Transformation Logic introduced by Transamerica in VANTAGE.
• Conducted online as well as in- person JAR Sessions, JAD Sessions and developed BRDs, FRS and RTMS and followed through the Sign-Off process.
• Worked comprehensively in VANTAGE in the Mainframe environment and involved in the analysis data and conversion logic in the entire migration effort.
• Developed conceptual, logical and physical model in the ERWIN Data Modeling Tool after thorough interaction with the SMEs and Business Sponsors and User Groups.
• Co-ordinated with ONSITE and OFFSHORE folks throughout the entire Project.
• Worked closely with PM, SMEs, BAs, Solution Architect, DBAs, Testers, Main Frame Developers and .Net programmers as well as with the higher leadership.
• Developed documents viz: BRD, HLR, DLR, FRS, RTM, MODELS (LOGICAL & PHYSICAL), DBA Requests, DDL Scripts through Forward Engineering and Reverse Engineering.
• Developed Data Warehouse Model in ERWIN, reflecting mostly the Dev ODS plus Business Ask.
• Involved in Keying-In Transaction and Test Data in VANTAGE and comparing to the ODS through Customized Automation Tool.
• Worked comprehensively in System Testing through the Comparison-Automation Tool.
• Executed Queries in Data Base to address Business Ask and Transformation Logic.
• Worked in Normalizing the ODS in DB2 and De-normalizing the Data Warehouse in SQL Server 2008.
• Heavily involved in Data Mapping from ODS (source) to DWH(Target)i.e VANTAGE (Mainframe) ODS (DB2) DWH (SQL Server 2008) Data Marts (SQL Server 2008)
• Developed DWH, DATA MARTS (Market Conduct, Audit and LIMRA)

Environment: Windows 2007, Microsoft Office SharePoint 2007, Cognos, Rational Requisite Pro, MS Office (Word, Excel and PowerPoint),MS Project,Main Frame, VANTAGE .Net FrameworkCA Erwin 7.3, IBM DB2, SQL Server 2008

Confidential, St. Louis, MO

Sr. Data Modeler

Responsibilities:

• Conducted live JAR sessions to Elicit, Analyze and Document Business Requirements from the Business.
• Conducted live JAR & JAD sessions with SMEs, and all the placeholders to develop High Level Requirement and then formalized those requirements to Detail Level Requirements.
• Conducted series of sessions with Business People and IT People to bridge the gap and to translate the Business Ask to the IT product.
• Worked in close co-ordination with Business People, Architects, Developers, Testers and Project Managers and also at times reported to the higher leadership.
• Principally authored the following documents: Business Requirement Documents, High Level Requirements, Detail Level Requirements, Functional Requirements Documents, Requirement Traceability Matrix, Quality Requirements, Functional/Stakeholders Requirements, User Stories and Testing Documentation like Test Plan, Test Cases etc.
• Perfect understanding of Express 1 Methodology (customized model of software development in Express Scripts Incorporation)
• Worked in Medicare Part D (Prescription Drug Plans Program), Health Care Reform under Medicaid Program, Direct Claims Reject Code Adjustments Program for Health Plan Clients and Explanation of Benefits and Language Impacts Project among others.
• Successfully worked on Pharmacy Claims Processing chiefly: Direct Claims, Retail Claims and Card/Mail Order Claims developing a complete understanding of Pharmacy Claims Gateway.
• Worked with SME’s and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
• Designed an Industry standard data Model specific to the company with group insurance offerings, Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
• Identified and compiled common business terms for the new policy generating system and also worked on contact Subject Area.
• Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using Erwin and Visio
• Identified and Defined entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.
• Developed logical data model using ERwinand created physical data models using forward engineering in generating DDL scripts and creating indexing strategies
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Conducted thorough data transfer from (OLTP to OLAP) source to target which is Teradata here.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed Data Mapping Document.
• 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.

Environment: Windows 2000/XP, Microsoft Office SharePoint 2007, Cognos, Rational Requisite Pro, MS Office (Word, Excel and PowerPoint), SQL Server,Teradata, MS Project, MS FrontPage 2003, MS Access, EDI, Documentum 2.0.,UML, Java, .Net FrameworkErwin R8.2.5,Erwin R9.0, MS Visio, Oracle 11g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, Crystal Reports

Confidential

Data Modeler

Responsibilities:

• Engaged with Business users Involved in gathering the related business requirements
• Documented the performance of the system by understanding the existing data model.
• Mapped the business requirements and new databases to the logical data model which defines the project delivery needs.
• Generated DDL statements and scripts from Physical Data Model to create objects like table, views, indexes, stored procedures and packages.
• Identified the measures and dimensions and organizing these into facts in creating the Dimensional Model within the business requirements.
• Designed Fact tables, Dimension and aggregate tables for Data warehouse.
• Implemented naming standards, and warehouse metadata for fact and dimension of Logical and Physical Data Model.
• Worked on the conversion process of data which is stored in flat files into Oracle tables.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Used Reverse Engineering and Forward Engineering techniques on databases from DDL scripts and created tables and models in data mart, data warehouse and staging.
• Worked on slowly changing dimension tables and hierarchies in dimensions.
• Worked on data mapping process from source system to target system.
• Worked with business analyst in generating weekly reports using Cognos.
• Reverse Engineered DB2 databases and forwardengineered them to SQL Server 2000 using Erwin.
• De-normalized the database to put them into the star schema of the data warehouse
• Created documentation and test cases, worked with users for new module enhancements and testing
• Understood existing data model and documented suspected design affecting the performance of the system
• Supported clients of the CSG and AMDOCS billing system and Report Store application in a Tier 2/3 capacity by addressing issues related to functionality, reporting tools, CSG, AMDOCS developments
• Identify the potential customers from the given data base and counsel the organization on ways of converting them to loyal customers as a part of CRM.
• Team Lead with end-to-end grasp of the entire software development life cycle (SDLC) including analysis, design, development and testing of software applications.

Environment: Erwin 7.3, Oracle 11g, SQL Server,Teradata, Crystal Reports, Windows 7, MS Office, Cognos

Confidential, Montvale NJ

Data Modeler/ Data Analyst

Responsibilities:

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Developed logical and physical data models for central model consolidation.
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Conducted data modeling JAD sessions and communicated data-related standards.
• Used Erwin r7.0 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Developed process methodology for the Reverse Engineering phase of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and Teradata.
• Involved in different team review meetings.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Worked with report developers for building OLAP Cubes for ad hoc reporting.
• Performed unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.
• Generating ad-hoc repots using Crystal Reports 9.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin r7.0, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000 servers, Oracle8i, SQL Server 2000/2005, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal Reports, MS-SQL server analysis manager.

Confidential, Chicago, IL

Data Modeler

Responsibilities:

• Involved in requirement gathering along with the business analysts group.
• Gathered all the Analysis report prototypes from the business analysts belonging to different Business units
• Gathered various requirement matrices from the business analysts.
• Participated in Joint Application Development(JAD) sessions
• Conducted Design discussions and meetings to come out with the appropriate Data Model
• Designed for the various reporting requirements
• Designed a logical data model using database tool Erwin r7.0
• Used ER Studio to create logical and physical data models for enterprise wide OLAP system.
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse
• Modeled the dimensions and facts using Erwin for centralized data warehouse
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
• Actively participated in data mapping activities for the data warehouse.
• Created summary tables using de-normalization technique to improve complex Join operations
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to Loan products
• Participated in the tasks of data migration from legacy to new database system
• Worked on Metadata exchange among various proprietary systems using XML.
• Conducted Design reviews with the business analysts, content developers and DBAs
• Designed and implemented a physical data model to handle marketing strategies and to satisfy reporting needs dynamically.
• Organized User Acceptance Testing (UAT), conducted presentations and provided support for Business users to get familiarized with Loan products application.
• Handled performance requirements for databases in OLTP and OLAP models.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
• Perform Data Loading and Transformation using Data Junction 6.0

Environment: ERWin r7.0, ER Studio, SQL Server 2000/2005, Windows XP/NT/2000, Oracle 8i, MS-DTS, UML, SQL Loader, Data Junction, Rational Rose 2000

Confidential

Data Modeler

Responsibilities:

• Worked with business analyst to gather information on requirements
• Documented Technical & Business User Requirements during requirements gathering sessions.
• Gathered business requirements through interviews, survey with users and business analysts.
• Involved in preparing logical data models and conducted controlled brain-storming sessions with project focus groups.
• Conducted team meetings and JAD sessions
• Involved in business process modeling using UML through Rational Rose.
• Used Rational Requisite Pro to document technical requirements and business user requirements.
• Worked with analysts to create reporting universes in Business Objects.Provide mentoring, guidance and on how to use the Business Objects reporting and analysis tools.
• Created logical data model from the conceptual model and its conversion into physical database design.
• Extensively used star schema methodologies in building and designing the logical data model into dimensional models.
• Implemented referential integrity using primary key and foreign key relationships
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
• Used ERwin tool for relational database and dimensional data warehouse designs
• Reverse Engineered DB2 databases and then forward engineered them to SQL Server 2005 using Erwin, Power Designer
• Produced entity / process relationship matrices, entity-relationship graphs, efficient decomposition diagrams and statistics flow diagrams
• Developed logical data model using ERwinand created physical data models using forward engineering in generating DDL scripts and creating indexing strategies
• De-normalized the database to put them into the star schema of the data warehouse
• Created documentation and test cases, worked with users for new module enhancements and testing
• Understood existing data model and documented suspected design affecting the performance of the system
• Conducted logical data model walkthroughs and validation

Environment: DB2, SQL Server 2000, HyperionSybase, Erwin r8, Microsoft Visio, Rational Requisite Pro, Rational Rose, Windows 2003 Server.

Confidential

Data Modeler

Responsibilities:

• Gathered and transferred business and functional requirements.
• Interacted with business users and studied available documents/application to understand the requirements.
• Worked with large sets of data to find rate flow trends and patterns, identify and fix data anomalies
• Used Erwin r7.0 for creating tables using Forward Engineering
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Involved in business process modeling using UML
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Identified facts and dimensions and designed the Star Schema.
• Designed logical database design and converted logical model into physical model on SQL Server.
• Cleansed, extracted and analyzed business data on daily basis and prepared ad-hoc analytical reports using Excel and T-SQL
• Done SQL Server configuration database size estimation, database creation logins & user’s creation, granting object level permission, estimation of indexes on tables.
• Wrote Stored Procedures and Triggers.
• Developed Data Mapping Documents for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Created scheduled jobs on SQL Server to transfer data from Ingres database to SQLdatabase through linked server.
• Generated ad-hoc reports using Crystal Reports
• Developed database backup & restore policy.

Environment: Erwin 4.0, SQL/MS SQL Server, MS OLAP Manager,, MS Analysis Services, Windows NT, MS Visio, XML, Informatica Power Center 6.0, Crystal Reports.