SUMMARY

• 8+ years of extensive experience in teh complete Software Development Life Cycle (SDLC) covering Requirements Management, Data Analysis, Data Mapping, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications, business analysis.
• Strong Data Mapping experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling using tools like Erwin, E/R Studio and Sybase Power Designer.
• Experience creating DDL scripts for implementing Data Modeling changes.
• Experience creating ERWIN reports in HTML, RTF format depending upon teh requirement, Published Data model in model mart, created naming convention files, co - coordinated with DBAs’ to apply teh data model changes.
• Very strong in using data modeling Tools like ERWIN, Power Designer and E/R Studio.
• Normalized tables and dimensions up to 3NF in order to optimize teh performance.
• Experience in Data Integration techniques like Data Extraction, Transformation and Loading(ETL) from disparate Data Source databases like Oracle, SQL Server, MS Access, flat files, CSV files and XML files into target warehouse using various transformations in Informatica, Data Stage, ODI.
• Collaborated with business analysts and data analysts for Data Conversions and to resolve Gaps in business specifications and ensured dat teh decisions are documented.
• Strong in Source to Target data mapping, Standardization Document Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, Building Data Marts and Meta Data Management.
• Created teh Logical and Physical design of teh Data Warehouse (both Fact and Dimension tables) using STAR Schema approach.
• Extensively worked on Teradata data modeling projects.
• Experience with Teradata SQL and Teradata Utilities and IBM DB2.
• Adequate knowledge in Health Administration - Claims processing (auto adjudication), COB, EOB/Drafts, Claims pricing and testing, HIPAA, enrollment, EDI, Medicare, Medicaid, CDHP (consumer driven health plans)
• Extensive experience in configuring data mapping between different Databases.
• Sound understanding of Gap Analysis, requirement management, risk analysis and project plans.
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
• Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
• Familiar with HIPAA EDI transactions such as 835, 837 (P, D, me) 276, 277, 278 etc
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Knowledge of teh Back-End processes like Voucher Creation, EOB, Letter generation and 835 etc.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Interacted with all levels of teh project development team, from end users to Software Architects, Technical Lead, Database Administrators, System Administrators, Senior Mangers and Partners
• Worked on integration and implementation of projects and products, database creations, Mapping, calculation of object sizes, table spaces and database sizes
• Well versed with SDLC software development life cycle. Experience in dealing with different data sources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, Ms Access and Excel.
• Experience with creating reports using Crystal Reports XI.
• Extensive experience in loading high volume data, worked extensively with data migration, data cleansing and ETL processes.

TECHNICAL SKILLS

Data Modeling Tools: E/R Studio, Sybase Power Designer, Erwin, MS Visio

Databases: IBM DB2, TeraData, MS SQL Server, MS Access

Languages: SQL, PL/SQL, T-SQL, HTML, Java, Visual Basic, C, C++

Operating Systems: Windows NT/XP/2000/7, UNIX, Linux, Sun Solaris

Others: MS Office, SharePoint, Lotus Notes, Mega

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. Data Modeler / Data Analyst

Responsibilities:

• Working with SAP Functional Analyst to gather information on requirements.
• Working with SAP Modules like MM, S&D, FI to mine data.
• Worked with PowerDesigner to upgrade and resolve upgrade to teh latest version for enterprise.
• Creating Conceptual, Logical and Physical data model as per enterprise standard.
• Designing teh Logical Model into Dimensional Model using Star Schema and Snowflake Schema on PowerDesigner 16.5 SP04 to build data warehouse.
• Creating views on Teradata 14 using SQL Assist.
• Creating ETL scripts to load tables.
• Reverse Engineering teh existing data marts and identified teh Data Elements (in teh source systems), Dimensions, Facts and Measures required for reports.
• Cleansed unnecessary tables and columns and redefined various attributes and relationships in teh Reverse Engineering Model.
• Creating data models and analytical systems for OLTP and assisted in data extraction, transformation and loading process (ETL)
• Conduct Design discussions and meetings to come out with teh appropriate Data Warehouse at teh lowest level of grain for each of teh Dimensions involved.
• Designing a STAR schema for sales data involving shared dimensions (Conformed) for other subject areas using PowerDesigner.
• Creating and maintaining Logical Data Model (LDM) for teh project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Mapping teh business requirements and new databases to teh logical data model, which defines teh project delivery needs.
• Generating DDL statements and scripts from Physical Data Model to create objects like table, views, indexes, stored procedures and packages.
• Conducting peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.
• Transformations including aggregation, summation construct from source to data warehouse.
• Profiling data to conclude primary index, secondary index and unique index.
• Assisting teh application team in determination and clarification of business data requirements and also identified problems at teh data modeling/design level and recommend solution to problems.
• Maintaining and enforce data architecture/administration standards, as well as standardization of column name abbreviations, domains and attributes.

Confidential, Enfield, CT

Sr. 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.
• Developed Logical Dimensional Models and processed teh key facts and dimensions required for teh business support.
• Designed teh Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Designed Physical data base in teh form of Star Schema for Data Mart Design.
• Generated DDL Scripts from Physical Data Model using technique of Forward Engineering in Erwin.
• Identified objects and its relationship from existing database which can be used as a reference for data mart, tan transformed those objects into physical model using Reverse Engineering in Erwin.
• Performed teh Data Modelling effort for teh gaps identified while data mapping.
• Developed SQL queries on Teradata in order to get teh data from different tables using joins and database links.

Confidential, Bloomington, IL

Data Modeler/Data Designer

Responsibilities:

• During my tenure at Confidential, me have been involved in many projects simultaneously, for example Report a Loss, Online Claim Services, Salvage Bill Management, Facilitate Claim Services, Work Load Balancer, Architecture Refresh, Segment - Tier, Life-Health Modernization, File Upload to name a few. Some of teh projects had a team of people and have also worked in a smaller team of 10-15 people.
• Worked with Business Architects and System Analysts to gather business data elements from business requirements and translate them into a Logical Data Model.
• Identified objects and relationships and how those all fit together as logical entities, these are tan translated into physical design using teh forward engineering in E/R Studio 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.
• Cleansed unnecessary tables and columns and redefined various attributes and relationships in teh Reverse Engineering Model.
• Created Conceptual Data Model, Data Flow Diagram, Data Topology, Logical Data Model and Physical Data Model.
• Created and maintained Data Elements dictionary for teh entire Development Center Data Mart.
• Applied organizational best practices to enable application project teams to produce data structures dat fully meet application needs for accurate, timely, and consistent data dat fully meets its intended purposes.
• Conducted peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.
• Documented teh source to target mapping spread sheet which have all teh information of source and target data types and allthe necessary transformation rules which are in turn used for their metadata updates.
• Assisted teh application team in determination and clarification of business data requirements and also identified problems at teh data modeling/design level and recommend solution to problems.
• Maintained and enforce data architecture/administration standards, as well as standardization of column name abbreviations, domains and attributes.
• Used Mega Tool as well as E/R Studio to create Conceptual Data Model. Mega tool was recommended by Enterprise Architecture team to ensure consistent Data Model quality across Confidential .
• Helped drive discussion around Data Placement Strategy with Data Architects and Application Architects.

Confidential, Minneapolis, MN

Data Analyst/Data Modeler

Responsibilities:

• Worked for a Production Support team as well as Data Modeling team.
• Responsible for solving problem tickets generated by Data Quality team
• Solved all teh tickets within teh minimum time frame
• Generated reports using SQL from oracle database, which were used for comparison with legacy system.
• Created Temporary Tables to store teh data from Legacy system.
• Transformations including aggregation, summation construct from operational data source to data warehouse.
• Normalized teh database upto 3NF to put them into teh star schema of teh Data warehouse.
• Assisted Business analysts with Teradata Utilities
• Used Teradata Utilities (BTEQ, Multiload, and Fast Load) to maintain teh database. .
• Developed test plans and assisted in System Integration Testing (SIT).
• Developed, monitored teh workflows and responsible for performance tuning of teh staging and 3NF workflows.
• Documentation involved design docs, sop, mapping specifications and process flowcharts etc.
• Involved in quality assurance to ensure quality, validity and accuracy of data across teh servers.
• Designed Data Marts using dimensional modeling and wrote pl/sql ETL packages with Oracle pl/sql to extract data from relational data store transform and load into teh data mart.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions and determined teh hierarchies in dimensions.
• Used Power Designer tool for relational database and dimensional data warehouse designs.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Denormalized teh database to put them into teh star schema of teh data warehouse.
• Understood existing data model and documented suspected design affecting teh performance of teh system.
• Involved in different team review meetings.
• Conducted logical data model walkthroughs and validation.

Confidential, Houston, TX

Data Analyst/Data Modeler

Responsibilities:

• Gathered business requirements through interviews, surveys with users and Business analysts.
• Involved in preparing Logical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Created a logical design and physical design of teh centralized relational database.
• Responsible for logical and physical data modeling, database design, star schema, snow flake schema design, data analysis, documentation, implementation and support.
• Used Star schema methodology in building and designing teh Logical data model in teh dimensional Models.
• Created data model for teh Star Schema using Erwin, created DDL scripts for static dimensions and ETL Mappings using DataStages.
• Widely used Normalization methods and have done different normalizations (3NF).
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Conducted team meetings and JAD sessions.
• Created DMR mapping spreadsheets, Source to Target mapping documents including teh transformation rules.
• Involved in business process modeling using UML through Rational Rose.
• Used Rational Requisite Pro to document technical requirements and business user requirements.
• Analyzed business requirements, transformed data, and mapped source data using teh Teradata Financial Services Logical Data Model tool, from teh source system to teh Teradata Physical Data Model.
• Created logical data model from teh conceptual model and it’s conversion into teh physical database design using forward engineering in Erwin 4.0
• Extensively used Star Schema methodologies in building and designing teh logical data model into Dimensional Models.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration using Informatica.
• Worked extensively in documenting teh Source to Target Mapping documents with data transformation logic. Create Data Functional Design document.

Confidential, Dayton, OH

Data Modeler

Responsibilities:

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Developed logical and physical data models for central model consolidation
• Worked with DBAs to create a best fit physical data model from teh logical data model
• Redefined many attributes and relationships in teh reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Developed process methodology for teh reverse engineering phase of teh project
• Used reverse engineering to connect to existing database and create graphical representation.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved in different team review meetings.
• Involved in teh creation and maintenance of repositories containing metadata.
• Did unit testing and tuned for better performance.
• Involved in teh critical design review of teh finalized database model.
• Involved in teh study of teh business logic and understanding teh physical system and teh terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Confidential

Business Analyst

Responsibilities:

• Gathered Business Requirements through brainstorming sessions on global calls.
• Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
• Documented and tracked requirements in Mercury Quality Center.
• Acted as a liaison between teh development team, QA team and teh Business team and resolved any conflicts due to change in requirements.
• Studied business requirements and conduced User Interviews to identify and document teh data discrepancies and their sources as related to Government Contract Compliance, Government Disclosures, Government Pricing, Customers, Products, Product pricing.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Conducted GAP Analysis between teh existing projects and teh proposed project to map teh systems and evaluate their utility toward teh new project.
• Used Requisite Pro for teh Requirement Documents Preparation and Prepared Business Process Models dat includes modeling of all teh activities of teh business from teh conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
• Documenting Data Dictionary of TRR Process which served as a complete requirements document for different sets of clients
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Developed straightforward DBMS queries, knowledge of HL7 and xml interface messaging.
• Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
• Involved in analysis for wide range of Six Sigma and Web-based initiatives, including user requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within teh Oracle database
• Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies
• Involved in DB2 Performance tuning projects where teh existing modules are analyzed for optimum use of system resources.
• Reviewed test scripts and made sure dat teh Test scripts covered all scenarios of teh requirements.
• Conducted group (JAD) sessions with business units and stakeholders to define project scope and deliverables.
• Logged defects into QC while doing Functional Testing and followed through teh process until teh defects were closed.