PROFILE

• 8 years of extensive experience in the 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 the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the 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 the 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 that the 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 the Logical and Physical design of the 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, I 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 the 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 the 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

CAREER PATH

Confidential

Sr. Data Modeler / Business Analyst

Confidential is a publicly traded American multinational agrochemical and agricultural biotechnology corporation headquartered in Confidential. It is a leading producer of genetically engineered Confidential seed and of the herbicide glyphosate, which it markets under the Roundup brand.

• 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 the latest version for enterprise.
• Creating Conceptual, Logical and Physical data model as per enterprise standard.
• Designing the 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 the existing data marts and identified the Data Elements in the source systems , Dimensions, Facts and Measures required for reports.
• Cleansed unnecessary tables and columns and redefined various attributes and relationships in the 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 the appropriate Data Warehouse at the lowest level of grain for each of the 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 the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Mapping the business requirements and new databases to the logical data model, which defines the 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 the application team in determination and clarification of business data requirements and also identified problems at the 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

Sr. Data Modeler

Confidential mutual life insurance company with 1,800 offices and 13 million clients worldwide. Confidential is one of the largest life insurance companies globally and was ranked 93rd in the Fortune 500 list as of 2010 . The company has revenues of 25 billion 2010 and assets under management of 448 billion 2010 .

• 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 the key facts and dimensions required for the business support.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Designed Physical data base in the 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, then transformed those objects into physical model using Reverse Engineering in Erwin.
• Performed the Data Modelling effort for the gaps identified while data mapping.
• Developed SQL queries on Teradata in order to get the data from different tables using joins and database links.

Confidential

Data Modeler/Data Designer

Confidential About one of every five cars on the road is insured with state farm. It is also licensed to sell Life insurance and health insurance. State farm also has banking products and mutual funds.

• Worked with Business Architects and System Analysts to gather business data elements from business requirements and translate them into a Logical Data Model.
• During my tenure at State Farm, I 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 the projects had a team of 100-150 people and have also worked in a smaller team of 10-15 people.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the 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 the 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 the entire Development Center Data Mart.
• Applied organizational best practices to enable application project teams to produce data structures that fully meet application needs for accurate, timely, and consistent data that 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 the source to target mapping spread sheet which have all the information of source and target data types and all the necessary transformation rules which are in turn used for their metadata updates.
• Assisted the application team in determination and clarification of business data requirements and also identified problems at the 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 State Farm.
• Helped drive discussion around Data Placement Strategy with Data Architects and Application Architects.

Confidential

Data Analyst/Data Modeler

Confidential is specializing in credit cards, home loans, auto loans, and banking and savings products. The MIDE project is for migrating data from legacy systems like AS400, CORE, LIS, LPS, MSPBI to MIDE. Once all the data is migrated into MIDE, all the legacy systems will be shut down.

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 the tickets within the minimum time frame
• Generated reports using SQL from oracle database, which were used for comparison with legacy system.
• Created Temporary Tables to store the data from Legacy system.
• Transformations including aggregation, summation construct from operational data source to data warehouse.
• Normalized the database upto 3NF to put them into the star schema of the Data warehouse.
• Assisted Business analysts with Teradata Utilities
• Used Teradata Utilities BTEQ, Multiload, and Fast Load to maintain the database. .
• Developed test plans and assisted in System Integration Testing SIT .
• Developed, monitored the workflows and responsible for performance tuning of the 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 the 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 the data mart.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions and determined the 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 the database to put them into the star schema of the data warehouse.
• Understood existing data model and documented suspected design affecting the performance of the system.
• Involved in different team review meetings.
• Conducted logical data model walkthroughs and validation.

Confidential

Data Analyst/Data Modeler

Confidential is one of the nation's largest full-service providers of consumer and commercial banking, trust, securities brokerage, mortgage and insurance products and services. Project was to develop financial analysis data warehousing for analyzing customers, their transactions, accounts, balances and their authorizations between accounts of its customers. This project is developed for research analysis of Finance Department to assist them in their business. This system provides accurate and timely information on their portfolios on a daily and monthly basis, regarding credit gains and losses for potential candidates so that they may take appropriate actions proactively.

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 the 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 the Logical data model in the dimensional Models.
• Created data model for the 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 the 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 the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Created logical data model from the conceptual model and it's conversion into the physical database design using forward engineering in Erwin 4.0
• Extensively used Star Schema methodologies in building and designing the 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 the Source to Target Mapping documents with data transformation logic. Create Data Functional Design document.

Confidential

Data Modeler

The project was to develop a customized pricing solution for the organization's complex need and also to develop a Provider Network Management solution for managing complex contractual negotiations with the providers. Confidential Facets 4.31 as their health plan administration system and the Organization was looking for a pricing solution and network management solution to meet their growing customer demands for faster processing and simplifying administration.

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 the logical data model
• 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.
• 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 the creation and maintenance of repositories containing metadata.
• Did unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.
• 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.

Confidential

Business Analyst

Confidential Center provides healthcare in Ahmedabad, India and their goal is to provide quality healthcare and improved human life. As a Business Analyst Worked on the up-gradation of their database that has all the record of all the patients and customers. Including merging of several different data marts and building a new database so that managers can see all the information all together and then managed the database.

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 the development team, QA team and the Business team and resolved any conflicts due to change in requirements.
• Studied business requirements and conduced User Interviews to identify and document the 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 the existing projects and the proposed project to map the systems and evaluate their utility toward the new project.
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the 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 the 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 the existing modules are analyzed for optimum use of system resources.
• Reviewed test scripts and made sure that the Test scripts covered all scenarios of the 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 the process until the defects were closed.