PROFESSIONAL SUMMARY

Senior Data Modeler/Analyst with over 8 years of experience in data analysis with focus on Financial, and Healthcare Insurance domains.

SKILLS INVENTORY

• Strong background in business intelligence, reporting systems, data quality including ETL , and full life-cycle development.
• Extensive experience in designing robust data models using Erwin, Sybase Power Designer and VISIO.
• In depth Functional knowledge of customer's business, Process flow and procedures of various domains as well as building customer relationship skills.
• Involved in the various phases of software life cycle Analysis, Design, Development, Testing and Production/Maintenance for the projects using methodologies like Agile, RUP, Waterfall, and hybrid methods.
• Designed and developed Data models for Database OLTP , the operational data store ODS , Data warehouse OLAP , and federated databases to support client enterprise Information Management Strategy.
• Vast experience of working in the area of data management including data analysis, gap analysis and data mapping.
• Worked extensively with Erwin, Visio and ER Studio, Power Designer for Relational, Dimensional Modeling and Data Migration projects.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
• Extensive experience in Database Management in managing SQL Server Databases
• Developed reports on SSAS SSRS on SQL Server 2000/2005 . Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Supported team in resolving SQL Reporting services and related issues.
• Extensive experience in Performance tuning databases for optimum performance
• Coordinated and prioritized outstanding defects and system requests based on business requirements.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.
• Capable of managing project while leading cross-functional teams to meet and exceed overall IT initiatives.
• Proficient in SQL Server developing Stored Procedures, Triggers, T-SQL Statements, Cursors,User Defined Functions and Views.
• Solid problem-solving skills, with proven ability to create software solutions for diverse needs.
• Good team building skills acute ability to interface with senior management utilizing well-developed communication and interpersonal skills.

Skill Set:

WORK HISTORY

Confidentail

Project Role: Data modeler / Data Analyst

• Worked with the business teams completing tasks related to business solution planning as well as managing requirements throughout the SDLC. As the recognized expert, consults extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise level data/ database architecture and management strategies. Responsibilities:
• Gathered the business requirements by conducting a series of meetings with business users.
• Created logical data model from the conceptual model and it's conversion into the physical database design using Erwin.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Involved with data analysis using Teradata SQL assist from data source.
• Reviewed models with DBA have to best-fit physical Model Indexes for better DB performance.
• Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Developed the data warehouse dimensional models schema for the proposed central model for the project.
• Developed many subject models from scrap.
• Created Logical/Physical Data models in 3NF in the Warehouse area of Enterprise Data Warehouse.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Worked on the Snow-flaking the Dimensions to remove redundancy whenever required.
• In order of better understanding the requirement documents, carried out couple of JAD sessions with Management, SME Subject Matter Expertise , vendors, users and other stakeholders.
• Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
• Created, Designed Fact Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Maintained the integrity of data and data quality.
• Conducted data profiling for better understanding of joins in ER models
• Involved in high level ETL design review sessions and assisted ETL developers in the detail design and development of ETL maps using Informatica.
• Worked with project release meeting manager for UAT tables going to production.
• Handled metadata publish tasks to our internal data dictionary from internal DB MS Access
• Did Performance Tuning of the database that included creating indexes, optimizing SQL Statements monitoring the server.
• Assisted Reporting developers in building Reports using Crystal Reports. Environment: SQL Server 2000/ 2005/2008, Oracle11g, Teradata 13, Erwin Data Modeler 8.2.3, Windows XP/2007/2008, MS office 2010, Access, Visio, Informatica 9.1, and SharePoint.

Confidentail

Project Role: Data Modeler / Data Analyst

• Confidentail provides financial services to individuals and institutional clients through two segments: Investor Services and Institutional Services. The project involves working with the investor Services segment that provides retail brokerage and banking services to individual investors. The Institutional Services segment provides custodial, trading and support services to independent investment advisors. Responsibilities:
• Helped conduct meetings with the end users and facilitated meetings to gather the requirements from them and to convert those requirements into Requirements document for the development and testing teams.
• Analyzed the business requirements to get a thorough understanding of the testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of the requirements during testing.
• Designed Logical/Physical and Conceptual models of database using ERwin and VISIO
• Did extensive reverse engineering of databases using ERwin.
• Worked with the developers to understand the ERD Entity Relationship Diagram and thus create comprehensive test plans, following the RUP model, for the applications and also gather test data for the data driven test cases.
• Worked extensively on BI SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP.
• Extensively involved in using BI tools like Import and Export Wizard for developing the packages.
• Provided the sequence and flow diagrams for various modules in the project using Rational Rose.
• Created solid DSS databases for Reporting.
• Participated in weekly review meetings to report the documented test metrics and defects found in the System. Closed bug reports once they are resolved and verified.
• Involved in Training and Documentation.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from sources.
• Gather requirements and design of data warehouse and data mart entities.
• Used SQL to perform data analysis, data profiling and generating reports.
• Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
• Worked with business people, data stewards, SMEs as a part of data model designing and source to target mapping document creation.
• Identified opportunities for business process improvement and initiated efforts to make improvements.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
• Worked with Data Quality and ETL teams as part of my job responsibilities.

Environment:

ERwin, VISIO, SQL Server 2008, Microsoft Word, Excel, PowerPoint, SSAS, SSRS, SSIS

Confidentail

Role: Programmer Analyst

• A United Healthcare Medicare Solution Care Improvement Plus is insured through United Healthcare Insurance Company and its affiliated companies, a Coordinated Care plan with a Medicare contract Responsibilities:
• Designed, Developed and maintained web based platform for the E-Rebate System. It Includes the modules such as Rebate Contract Management, Data Management, Rebate Processing, Rebate Post Processing, Rebate Reconciliation, Rebate Reporting and contract Modeling
• Rebate Contract Managements the module that manages the rebate contracts dealing with the pharmaceutical manufacturer as well as the client for sharing purposes. This modules is essential to the identical of how much to bill and when, as well as how much to share with the client. The information housed in this module has a direct correlation to the efficiency of the other modules
• Rebate Contract Managements includes the components such as Client Global, Manufacturer Global, Client Contract and manufacturer Contract
• Global level module list all the clients and manufacturer details
• Client Contract is a legal arrangement between PBM and the client for processing the claims, pharmacy benefit design an as well as rates
• Manufacturer Contract is a legal arrangement between a pharmacy manufacturer company and a PBM, health plan, state or other entity where rebate reimbursement arrangements are defined for a drug or multiple drugs
• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company
• Created the conceptual model for the data warehouse using Erwin data modeling tool
• Reviewed the conceptual EDW Enterprise Data Warehouse data model with business users, App Dev and Information architects to make sure all the requirements are fully covered
• Analyzed large number of COBOL copybooks from multiple mainframe sources 16 to understand existing constraints, relationships and business rules from the legacy data
• Worked on rationalizing the requirements across multiple product lines
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model
• Implemented Agile Methodology for building an internal application
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements
• Worked with ETL to create source to target mappings S2T
• Worked with DBA to create the physical model and tables
• Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
• Had brain storming sessions with application developers and DBAs to discuss about various demoralization, partitioning and indexing schemes for physical model
• Worked on Requirements Traceability Matrix to trace the business requirements back to logical model

Environment:Erwin, Quest Central for DB2 v 4.8, COBOL copybooks, Mainframe DB2, SQL Server 2005,Oracle 11g SQL Loader, Mercury Quality Center 9, Informatica Power Center 8.1

Confidentail

Project Role: Data Modeler/Analyst

• Pencor is a private company categorized under Detection and Analysis Service, Gas. Pencor Laboratories Reservoir Description division is the world's largest and most technologically advanced independent provider of reservoir fluid and petro physical services to the oil and gas industry. It provides services and data that characterize the porous reservoir rock and all three-reservoir fluids - gas, oil and water. Involved in designing a data model and created reports to calculate the profit and loss margin by year, quarter and month.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Extensively used Star Schema methodology in building and designing the logical data model.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Prepared business case for the data mart and then developed and deployed it.
• Used ERwin to transform data requirements into data models.
• Performed Reverse Engineering of the current application using ERwin, and developed Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.

Environment:

SQL server 2008, Linux, Windows XP, ERwin, MS Visio, TOAD, Microsoft Office.

Confidentail

Project Role: Data Modeler/PL-SQL Developer

• AT T is a multinational telecommunications corporation headquartered in Whitacre Tower, Dallas, Texas, United States. It is the second largest provider of mobile telephony and fixed telephonyand is also a provider of broadband and subscription television services. The project aimed mainly at developing the utilities that can provide the status and can monitor the billing information. The application provides effective accounts management, Billing information, rapid customer order processing and timely customer order delivery, which in turn help to improve customer service.
• Documented business workflows textually as well as in UML diagrams Use Cases, Activity diagrams, State diagrams identified and documented attributes for entities and also defined domain for all attributes.
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Manage the scope and change control of project in coordination with management.
• Created business flow diagrams and charts for applications for all phases of the SDLC.
• Worked with Business managers to confirm logical models based on data requirements.
• Assisted the ETL team in extracting data from DB2 and collaborated efforts in generating source to target mappings.
• Worked on designing the conceptual and logical models by using the Erwin modeling tool.
• Reverse engineered existing database and refined existing database schema to make more effective and efficient database model using ERwin.
• Extensively performed Data Collection and Data Conversions while transforming data using custom SQL scripting as well as ETL applications from Relational Solutions.
• Discussed the data model with application users to refine the design and made changes accordingly.
• Created suitable data models for existing application data from XML and mapped it with new table schema.
• Participate in the Master Data Management MDM effort provide technical advice and support toward the development of strategic and tactical plans for client master data management strategy, data inventories, data governance, data management, storage, and distribution alternatives in support of client MDM strategy.
• Created DDL for various modules of data model for testing and implementation using TOAD.
• Wrote PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Created detailed source target database mapping with transformation required.
• Discussed migration policies with other developers and DBAs for quick and error-free migration using TOAD.
• Worked with DBA for performance tuning and space management.
• Assisted DBA for fetching data from OLTP using Oracle Export/Import.

Environment:

Teradata 12, DB2, Toad, PL/SQL, Erwin 7.2, Export/Import, Windows XP, UNIX, XML, MS Excel 2003.

Confidentail

Project Role:Data Modeler / Data Architect

• New database called the Operational Consumer hub OCH was built for the client Humana Inc to target all the potential customers. This involves engaging with people, campaigns etc.
• Person MDM is the solution to Master Data Management of Person demographics and other details that are received from multiple sources. The solution base has been an IBM Tool called Initiate .
• Enhancement was done to the existing SDR DB Enterprise DB . Infrastructure solution to make SDR and OCH DB's robust. Data Architecture for Lifesynch Databases and merging Humana data into Lifesynch Lifesynch, a behavioral health company acquired by Humana
• Responsibilities:
• Architected an enterprise solution and led a technical team of 6 to build the Person Master Data Management process and solution for Humana's insurance business.
• Person/Customer MDM Solutions
• Custom and Automated Maintenance Plans Optimization, Integrity Checks etc., for Very Large Databases. The first to be done in Humana.
• Architected an enterprise solution that provides data isolation capabilities around co-located data. This ensures that data is provided based on appropriate security context.
• Data Modeling for OCH DB
• Performance Tuning of the SDR/OCH DB's
• To build new servers with an enhanced architecture solution to accommodate ETL, OLTP, Reporting requirements for SDR
• Has been working on Application Design for Data Isolation, Preferences.
• Designed and developed Data Quality Reports, Chain of Trust Mechanisms for File processing.
• Built the system for non-functional activities like backup, restore, recovery, auditing and archival processes for the OCH DB.

Environment:

SQL Server 2005, Windows Server 2003, Windows XP, SQL Profiler, VSS, TFS, Erwin, Enterprise Architect Sparx 7.5, DBTA, Initiate IBM Tool for Person MDM, SQL Management Studio, DBTA, SSIS, Informatica

Confidentail

Project Role: Database Developer/Data Analyst

• Worked on a project for the college, which allows the management know about all the statistics of the students. Be it attendance or performance or anything regarding their activities. Generated various reports for students that made it easy for the parents and the management to easily take a peek into their performance at school. Responsibilities:
• Gathered user requirements.
• Identified high-level requirements for developing and documenting detailed business requirements
• Involved in meetings with SME subject matter experts and users for requirements gathering.
• Revised and updated the technical feasibility documents and created sequence diagrams.
• Utilized RUP Rational Unified Process to create use cases, activity, class diagrams and workflow process diagrams.
• Extensive development providing data integrated solutions using VB 5.0.
• Responsible for providing database solutions using MS Access/ SQL Server/ Oracle database.
• Proficient use of T-SQL/ PL/SQL in creating tables, views, triggers, stored procedures.
• Created reports using Crystal Reports and Oracle Forms/Report.
• Provided technical/Functional support to end-user.

Environment:

MS SQL Server 2000, Oracle 8.0/9.0, Visual Basic 5.0, TSQL, PLSQL, Windows NT /2000