Data Project Manager

Phone: 732-***-****

Chinmayi Email: *********.********@*****.***

Page 1 of 8

SUMMARY

Over 6 years of professional experience in data modeling, designing, and data analysis with

Conceptual, Logical and Physical Modeling for Online Transaction Processing and Online

Analytical Processing (OLTP & OLAP).

Proficient in Data Analysis, design using ER modeling and implementing RDBMS specific

features.

Experience in Financial, Medical, Telecommunication, Pharmaceutical, Airline and

Banking Domains maintaining Databases.

Well versed in Normalization to 3NF/Denormalization techniques for optimum

performance in relational and dimensional database environments.

Can effectively use CASE tools like ERwin, Power Designer and ERStudio.

Done a lot of modeling using ERwin in both forward and reverse engineering cases.

Experience in Data Warehousing, Data Modeling, Data Migration, Data Conversion, OLTP

and OLAP.

Developed Data Warehouse designs, working with staging, star schemas and dimensional

reporting.

Experience in dealing with different data sources ranging from flat files, Excel, Oracle,

Sybase, and SQL Server.

Experience in design reviewing and validation of final data models.

Strong performance tuning abilities. During the tuning process developed various indexes

and Hints as needed.

Very good understanding of Object Oriented Programming and Professional GUI

designing.

Worked in many Software Development Life Cycle (SDLC) implementations, performing

process-planning, documentation, functional and system design, implementation, unit,

integration, regression testing, and system maintenance.

Quick learner, self motivating and enthusiastic to work with new technologies. Good team

player and have strong ability to work under high stress environments.

Strong communication, organizational and interpersonal competencies along with detail-

oriented and problem solving skills in the technology arena.

TECHNICAL SKILLS

Modeling Tools:

ERStudio Data Architect, ERwin, Rational

Rose, MS Visio, Sybase Power Designer, ERStudio

Software Architect.

Oracle Methodologies and Documentation:

Applications Implementation Methodology

(AIM) 2.0 & 3.0 and other Client specific

documentation like, User training docs, promotion

or migration instruction docs, Version Control

docs, etc.,

Reporting Tools: Oracle Reports, XML Publisher, Business

Objects

Databases: Oracle7/8i/9i/10g/11g,MS SQL

Server2000/2005,

MS Access, Teradata, DB2.

Operating Systems/Platforms:

2

Windows NT, 2000 & XP, Vista, AIX, UNIX,

Linux and Sun Solaris.

Other Tools: SQL Navigator, TOAD, PVCS, JIRA,

Clearcase

and Clearquest

Languages: C, C++, VB, Java, .NET, PL/SQL and SQL.

EDUCATION

Bachelor of Technology in Electrical Engineering, Kakatiya University, Warangal, AP, India.

WORK EXPERIENCE

T-Mobile

Bellevue, WA 02/11 –Present

Role: Jr. BI Data Architect

Project Summary: T-Mobile is a German mobile telephone provider, owned by Deutsche

Telekom. It operates several GSM networks in Europe and the United States. Involved in mutilple

projects which are driven by the businesss requirements. Dimensional modeling using star schema

architecture was implemented for achieving the task.

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical

specifications detailing new features and enhancements to existing business functionality.

• Involved in gathering user requirements along with Business Analyst.

• Created the Source System Analysis documents and Architectural Solution documents.

• Developed the logical and physical data model for the proposed solution.

• Part of team conducting logical data analysis and data modeling JAD sessions, communicated

data-related standards.

• Interacted with end users to identify key dimensions and measures that were relevant

quantitative.

• Involved in the complete life cycle of the product from requirements gathering to end of system

testing.

• Created views to support the Business Objects.

• Responsible for creating the staging tables and source to target mapping documents for the ETL

process.

• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined

the hierarchies in dimensions.

• Extensively used the dimensional normal form for the dataware house design.

• Involved in many of the integration projects.

• Created Indexes and capacity planning and worked closely with the DBA’s.

• Created Summary and Aggregate tables for better performance of the query.

Environment: Oracle Database 10g, Teradata 12.0, Windows XP.

Page 3 of 8

Tools: TOAD for Data Analysis, Erwin 7.3, Teradata SQL Assistant 13.0, AccuRev

American Airlines

Dallas Fortworth, TX 05/10 – 01/11

Role: Logical Data Modeler/Data Analyst

Project Summary:As a global airline carrying more than 100 million passengers and more than

500,000 tons of cargo a year, AMR promotes commerce, trade, and economic prosperity, as well as

a sense of global community and citizenship. Involved in the migration of the existing EJB Services

to the Web Services. Migration involves validating the correctness of the existing data and

designing the domain models required for understanding the existing structure and integratiing new

functionality. Designed the LDM and PDM for the enterprise reference data.

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical

specifications detailing new features and enhancements to existing business functionality.

• Developed the UML class diagrams for the proposed system using ER/Studio Software

Architect.

• Performed data modeling using data modeling tool Embarcadero Data Architect.

• Created the data models for OLTP and Analytical systems.

• Performed in depth data analysis on Oracle and Teradata systems.

• Extensively worked with the Teradata SQL Assistant and Toad.

• Involved in data profiling to integrate the data from different sources.

• Extensively performed the gap analysis and impact analysis.

• Interacted with SME, developer to gather database requirements, actively participated

in functional requirement gathering, system requirement gathering, application design

• Worked with DBAs on support needs and provide guidance on architectural issues.

• Assisted development teams with loading data, extracting data etc.,

• Assisted QA for developing test plans and test cases for Unit Testing, System Testing

and Enterprise testing.

• Created the data mapping document from source to target and the data quality

assessments for the source data.

Environment: Oracle Database 10g, Teradata 12.0, Windows XP.

Tools: TOAD 9.6, ER/Studio Data Architect 8.5.3, ER/Studio Software Architect 1.0, ER/Studio

Portal 1.5.2, Teradata SQL Assistant 13.0, JIRA.

J. Knipper Health Care Marketing Solutions

Lakewood, NJ 02/09 – 04/10

Role: Sr. Data Analyst/Data Modeler

Project Summary: J. Knipper and company, Inc. has been dedicated to provide a broad array of

healthcare marketing solutions, including comprehensive direct mail, fulfillment, sampling,

database, and sales force management. The task was to develop a relational database system for

improving marketing strategies and report generation. The data models developed were analyzed

and value added.

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical

specifications detailing new features and enhancements to existing business functionality.

4

• Developed project plan with project manager’s assistance for the first two phases of the

project.

• Developed system flow and data flow diagrams for the proposed system.

• Designed conceptual and logical data models.

• 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 ERwin tool.

• Normalized the tables up to 3NF.

• Involved in the critical design review of the finalized database model.

• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise

testing.

• Involved in designing and implementing the security for the databases.

• Helped in migration and conversion of data from the Sybase database into Oracle 10g

database, preparing mapping documents and developing partial SQL scripts as required.

• Created stored procedures, functions, database triggers and packages as per the business

needs for developing adhoc and robust reports. Incorporated Dynamic SQL, for generation of

the where clauses dynamically based on the lexical parameters passed.

• Responsible for development and testing of conversion programs for importing data

from text files into Oracle database utilizing PERL shell scripts & SQL*Loader.

• Involved in the daily maintenance of the database that involved monitoring the daily

run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Oracle Database 10g, SYBASE, Linux, Windows XP.

Tools: ERwin, TOAD, SQL*PLUS, SQL*LOADER, Clear Quest

National City

Columbus, OH 04/08 – 01/09

Role: Junior Architect

Project Summary: National City is now a part of The PNC Financial Services Group, Inc., one of

the nation's largest diversified financial services organizations providing retail and business

banking, specialized services for corporations and government entities, including corporate

banking, real estate finance and asset-based lending, wealth management, asset management and

global fund services. We undertook a relational database project that would enable management to

better leverage information collected within current operational systems to help in their day to day

decision making.

Responsibilities:

• Involved in all phases of SDLC including analysis, designing, developing, testing and

maintenance.

• Performed in-depth analysis on the business objectives.

• Part of team conducting logical data analysis and data modeling JAD sessions,

communicated data-related standards.

• Used class diagrams (UML) to model the logical data models and then to physical data

model.

• Extensively used Normalization techniques (up to 3NF).

• Mapped the data between Source and Targets.

• Experience in Data Extraction and Conversion and in preparing the Gap Analysis.

• Used ER/Studio to generate SQL code for creating database.

• Maintained Design document and performed testing.

Page 5 of 8

• Gathered user specifications and system requirements for development process.

• Converted Data stored in flat files into Oracle tables.

• Used MS Visio for Creating Process flow diagrams.

• Worked with the implementation team from the design to the implementation phase.

• Provided architecture/development for initial load programs to migrate production

databases from Oracle data marts to Teradata data warehouse.

• Good experience in data analysis querying and writing in SQL and TOAD.

Environment: Oracle Database 10g, UNIX, Windows XP, Teradata.

Tools: ER Studio, MS Visio, TOAD.

Pencor

Broussard, LA 08/07 – 03/08

Role: Data Modeler/Developer

Project Summary: 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. Well coordinated changes among

developers, technical writers and End users for as per the business requirement.

Responsibilities:

• 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 PLSQL

objects.

Environment: SQL server 2005, Linux, Windows XP.

Tools: ERwin, MS Visio, TOAD

SoftTech Inc

Pune, India 03/06 – 07/07

6

Role: Data Modeler

Project Summary: The task of this project was to build a central repository of historic data

warehouse that could support the various reporting and information needs. Data was spread out in

multiple and diverse sources in databases located in different regions. The requirement demanded a

unified data pool. Dimensional modeling using the star schema architecture was implemented to

achieve the task.

Responsibilities:

• Involved in gathering user requirements along with the Business Analyst.

• Used Star schema methodology in building and designing the logical data model in the

dimensional Models.

• Part of the team responsible for the analysis, design and implementation of the business

solutions.

• Gathered and Translated business requirements into detailed, production-level technical

specifications, new features and enhancements to existing technical business functionality.

• Prepared business case for the data mart and then developed and deployed it.

• Part of team conducting logical data analysis and data modeling JAD sessions, communicated

data-related standards.

• Designed and Developed PL/SQL procedures, functions and packages to create Summary

tables.

• Used MS Visio for creating of process flow diagrams.

Environment: Oracle Database 8i, SQL, PLSQL, Linux.

Tools: ERStudio, MS Visio, TOAD.

ICICI Bank

India 01/05 - 02/06

Role: Data Modeler/Designer

Project Summary: This project is about the Centralized Retail Banking host system which is a

total bank automation system for retail banking operations with multi branch support on a single

database. It covers all the branch front office and back office system.

Responsibilities:

• Interacted with Users and CRM team to understand the Data structure in source database.

• Analyzed functionalities and Assisted in Data correction process on the Source systems.

• Involved in business process modeling in UML using Rational Rose.

• Created a logical design and physical design of the centralized relational database.

• Monitored quality of data received from the lines of business and work with business

representatives to resolve issues with input data.

• Worked with sourcing from various data sources like DB2 and SQL server.

• Involved in testing and updating the code as required. Developed the testing procedures to

monitor the data quality.

• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact

tables for reporting purpose.

• Performed tuning of SQL queries to improve the response time. Created new indexes and

provided hints in the process of tuning for better cost based tuning.

Page 7 of 8

• Built reports for better formatting and ease of use by the client end users. New reports like

Customer Address Label report, Customer Transaction report, Track Call report, etc, are built

from scratch in different formatting styles to meet client’s complex reporting needs.

• Designed and developed user test scripts for the UAT and migration of the developed codes.

Environment SQL server 2000, DB2, Linux, Windows XP.

Tools: TOAD, Rational Rose.

References are provided upon request

8

Contact this candidate