Data Modeler

Summary

• 7+ years of experience in Data Modeling and Database Design for several clients.
• Experienced with all the major databases Oracle, Teradata and MS Access for OLTP, OLAP & ODS DBs.
• Strong Experience in ER & Dimensional Data Modeling to deliver Normalized ER & STAR/SNOWFLAKE schemas using Erwin r7.2, ER Studio 7.1, EA Studio 1.5.1, Sybase power designer 12.1 and Oracle designer.
• Proven Requirement Gathering & Analysis skills - talking to users & analyzing data.
• Experienced in Finance, Telecom and government clients.
• Excellent knowledge of Bill Inmon and Ralph Kimball methodologies to design database architecture.
• Excellent knowledge on logical application design and physical implementation for database application.
• Excellent knowledge of complete data warehouse life cycle, testing methodologies, OLAP and OLTP.
• Excellent knowledge of SDLC phases (Inception, Elaboration, Construction and Transition).
• Experienced with most of software deployments methodologies like Water Fall, Iteration, Agile and Rapid Application Development (RAD).
• Proven skills in designed and maintained the Detail design Document (DDD), Business requirement documents (BRD), Data Requirement Document (DRD), Data Flow Diagram (DFD), Data Management Plan Document, Data Dictionary, Meta Data Model, Logical and Physical Data Models, Full DDL, Alter DDL, Insert statement for all the applications.
• Experienced in Business requirements conformation, data analysis, data modeling, logical and physical database design and implementation.
• Experienced in Normalization and Demoralization processes, Logical and Physical data modeling techniques.
• Proven knowledge in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Designed the Partitioning for tables according to business logic. Creation of Local/Global indexes depending on the types of queries to be performed on the tables.
• Experienced in Working with product managers, project managers, Business users, Applications development team members, CM Team, DBA teams and Data Governance team on a daily basis to analyze requirements, and design and development technical solutions.
• Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.

SKILLS

• Databases & OS: Oracle 10g/9i, SQL Server 2005/2000, DB2 UDB 8.0, Teradata V2R6, Sybase, MS Access, UNIX, Windows XP/NT.
• Business Areas: Financial/Finance, HealthCare, Mortgage, Sales & Marketing.
• Tools: ERWIN 4.0/7.0, ER/STUDIO 7.x, PL/SQL, INFORMATICA Power Center 8.x/7.x, Ab Initio, Power Designer, BUSINESS OBJECTS XI, Toad, SQL*Loader, MS DTS, T-SQL,SQL*Plus, ER Studio, Oracle Designer, Sharepoint 2003, Teradata FastLoad, MultiLoad, Tpump.
• System Aspects: Data Modeling (ER & Dimensional), Database Design, Requirement Analysis, ETL Design, Object Oriented Design, Development, Testing, Data Mapping, Metadata Management, Master Data Management, Data Profiling, Deployment, Documentation, Project Management.
• Languages: PL/SQL, Pro*C/C++, Java, Perl, PHP, HTML, Java Script, JSP, VB.

EXPERIENCE

Client: Confidential, Richmond VA Aug '9 - Till Date
Data Modeler
Description: This project involves around various IT systems and credit card data that enable the collection department to track credit card payment and skip accounts.
Responsibilities

• Data Modeling, Data Analysis for OLTP and OLAP systems.
• ER Modeling - Developing Entity Relationship Diagrams (ERD).
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers
• Logical & Physical Data Modeling, which involved;
• Design & Implementation of Data Mart; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Normalization techniques to arrive at effective Relational Schemas.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Identifying the facts & dimensions; grain of the fact; aggregate tables, etc for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Create and alter SQL statements before sending database change request to DBA team.
• Maintained and documented all create and alter SQL statements for all release.
• Designing Data Flows & System Interfaces.
• Requirements & Business Process Analysis; Rapid Audit of the requirements and existing systems.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data models.
• Involved incapturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Documented all the information of application and saving them for future reference.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Documenting using Interface Diagrams, Flow Charts & Specification Documents.
• Coordinating with DBA team to implement physical models & to setup development, test, staging & production environments for MGP; BPR Management; DDL & DML Generation & usage.

Environment: Teradata V2R6, UNIX, Toad, Business Objects, Ab Initio, MS Office, MS Access.

Confidential, Herndon, VA Jun '07 - July '09
Data Modeler
Description: This project is about wireless broadband services - high speed internet and digital voice service and provides data to decision support system (DDS) in terms of signals (BSS), data packet, cell traffic as business metrics.

Responsibilities

• Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Rapid Audit of the requirements and existing systems; Requirements & Business Process Analysis.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using tools like ERwin Data Modeler 4.x, ER/Studio 7.x (ER Studio)- Forward/Reverse Engineered Databases.
• Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Compiles and maintains the Enterprise Schema across all applications. Enforces principles of good canonical data design.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Worked with data compliance teams, Data governance team to maintain the data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Participate in biweekly technical huddle meeting with development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Designing Data Flows & System Interfaces - Service Oriented Architecture (SOA) & Web Services.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Design EDW / CDW components.
• Metadata Repository, Data Dictionary; Documentation using Interface Diagrams, Flow Charts.
• Assist developers in Performance Tuning & discussing Design Patterns/high level application design.

Environment: DB2 UDB 8.x, Oracle 11g/ 10g, SQL Server 2005/ 2000, Sybase data server 12.5, UNIX, Toad, Business Objects, Ab Initio, Teradata V2R6, Embarcadero ER/Studio 7.5 (ER Studio), Business Objects, XML, XSD, AIX, Java / J2EE.

Confidential, Reston, Virginia Nov '05 - May '07
Data Modeler/Developer
Project: Confidential is a leading supplier of network equipment and services for telecommunications. In a joint venture with Sony Ericsson Mobile Communications, the company offers a range of cellular phones, including supporting multimedia applications and other personal communication services. In addition Ericsson has products for special applications within defense systems, enterprise, cables, mobile platforms and power modules.

Responsibilities:

• Design & Implementation of 2 Data Marts; Integration with the EDW & ODS.
• Data analysis - Delivered Normalized, De-Normalized & Dimensional schemas
• Logical & Physical Data Modeling.
• Source-to-target mappings and developed Informatica mappings/mapplets.
• Reporting (MS Analysis Services / Reporting Services) - Design & implement Analysis adhoc reports & scheduled reports - for ad hoc & canned requirements.
• Gathered Business Requirements & Analyzed Business Process (User & Source Driven); Performed the roles of Data Analyst & Business Analyst; Developed Used Cases.
• Develop, Implement & Maintain the Conceptual, Logical & Physical Data models using ER/Studio - Forward/Reverse Engineer Databases (for the Staging, Normalized & presentation layers).
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping; Apply SOA (Service Oriented Architecture) to share master data; Use of CASE tools; Data Analyst/Analysis duties.
• Designing Data Flows & System Interfaces - Implementing the same.
• Design & Implementation of Data Extraction, Transformation & Loading (using SQL*Loader, Informatica & other ETL tools); Analyze Oracle & SQL Server Data & Migration of the same.

Environment: ERstudio 7.6, SQL Server 2000/ 2005, MS Office, Informatica PowerCenter 7.1, SharePoint 2003, Crystal Reports, UNIX, Windows XP/ 2000, SQL*Loader, Visio.

Confidential, India Jan 04 - Oct '05
Data Analyst
Description: Confidential a private sector bank in India, which has been into corporate investments, portfolio management, retail banking, credit cards, mortgages, and credit rating for the
past 20 years.

Responsibilities

• Entities and their attributes are defined with their name and definitions.
• A logical data model was designed and populated with all entity and their relationships.
• Worked with developers logical data model was transfer into physical data model.
• DDL generated from physical data model was used to create tables in database.
• Data collected from different department were loaded into database in monthly basis.
• Different types of reports were generated for the management team.
• History of all data available archived and made available upon request.
• MS Visio, Erwin were used to design database and oracle was database for this application.
• Periodic maintenance and changes in data base were done without violating data governance.
• Data dictionary was maintained and documented for future use.

Environment: Oracle 8i/ 9i, SQL Server 2000, ERwin, UNIX, Windows NT, Crystal Reports, Toad, SQL*Plus, XML, Visio.