SUMMARY

• 16+ years of experience in IT Software Industry and 9+ years as Data Modeler/Data Architect
• Data Modeling/Data Architecture/Database design on Oracle/SQL Server/Teradata 12 using ERWIN / ERSTUDIO / Designer 2000
• 5+ years as Project Lead/Project Management/Account Management
• Experience in designing ETL processes/Data Mapping
• Experience working on Oracle Warehousing Builder/Informatica
• Experience in OLTP/3NF as well as Star/Snowflake Schema Design
• Experience in conducting JAD sessions with Subject Matter Experts, data - source stewards and other stakeholders
• Experience participating in Offshore/Onsite model as well as Coordination & Management
• Strong Interpersonal & Communication skills and the ability to work in a multi-disciplinary team environment and manage a wide variety of engineering staff
• Datawarehouse experience in Order Management, Sales, Customers, Products, Pricing, Rebates, Returns, Metrics and Dash boarding
• Full Software Development Life Cycle experience with expertise in Systems Analysis, Applications Design, Database Logical & Physical Design, Development, Integration & System Testing, and Implementation, Maintenance & Enhancements.
• Experience in Healthcare, Mortgage, Manufacturing, Insurance, HR Applications, Data Conversion & Data Migration Projects, and Knowledge Management Projects
• Experience in Quality Control, Quality Assurance Practices, ISO, CMM processes.

TECHNICAL SKILLS

RDBMS: Oracle 9i, Oracle 10g, Teradata 12, Oracle Applications, SYBASE, MySQL, SQL Server 2005

Data Modeling Tools: Allfusion Erwin, QDesigner 11, Oracle Designer 2000, ER Studio

Datawarehousing: Oracle Warehouse Builder, Informatica Designer

Database Tools: SQL*Plus, SQL*Loader, SQL Navigator, Teradata Manager, Developer 2000, Toad

Project Management: Microsoft Project 2000

OS: Windows 9x/2k/XP/NT, Sun Solaris, HP UNIX, Linux, Aix, VMS

Other Tools: Rational Rose, VSS, PVCS, SCCS, Rational Clearcase

Quality: Conversance with ISO, CMM & CMMI Procedures Experience in Leading Quality Initiatives, Defining QA Standards & Procedures

Hardware: Hp-9000, Sun, Compaq Machines 1500, IBM PCs, VAX

Domains: Health, Insurance, Telecom, Banking, Airlines, HR

PROFESSIONAL EXPERIENCE

Sr. Data Architect/Lead Datawarehouse Consultant

Confidential, California

Responsibilities:

• Requirements Analysis, Data Modeling and Design for Business Value Solution project at Dell.
• Requirements Study of Dell Quote Generation application, and Product Advisor application
• Integration of Solution Advisor data with Sales and Quotes data in the Datawarehouse
• Designing Logical Model and Physical Data Model for the Solution Reporting using Erwin
• Dimensional Modeling with star & snowflake schema
• Source Systems analysis and data mapping
• Conducting JAD sessions with Subject Matter Experts, data-source stewards and other stakeholders
• Experience working in Offshore-onsite model for project implementation

Environment: Erwin 7.3, Teradata 12, Oracle 10g, SQL Server 2005, PL/SQL, Win XP/2k.

Project Lead/Sr. Data Architect

Confidential, California

Responsibilities:

• Designing Logical Model and Physical Data Model for CPLM::Salesforce.com using Erwin
• Documented ETL Source and Target data mapping
• Leading a team of 5 including developers, testers, and business analyst and salesforce consultant.
• Working on Application Integration Design of Channel Application with Salesforce.com
• Guiding developers in application design and performance tuning
• Managing end to end project cycle from requirements to implementation
• Coordinating testing with other development groups and operations.
• Conducting JAD sessions with Subject Matter Experts, data-source stewards and other stakeholders
• Managing Offshore-onsite model for project implementation
• Task planning, monitoring, and progress reporting
• Performed Reviews, System & Integration Testing
• Managing Data Migration from Oracle to Salesforce.com

Environment: MS Project, Oracle 9i, Oracle 10g, Rational Clearcase, Oracle Apps HR, XML, Visio, SQL Server 2000, Erwin, ER Studio, Salesforce.com, PL/SQL, Win XP/2k.

Datawarehouse Architect Lead/Sr. Data Modeler

Confidential, California

Responsibilities:

• Data Modeling for Business Dashboards, Product Release Management system, Defect and Productivity Metrics
• Worked on gathering & documenting requirements in JAD sessions with customers, stakeholders
• Defined project scope and gathered user requirements for Capital One Mortgage
• Defined technical requirements, technical and data architectures for the data warehouse
• Performed SSOT analysis, data analysis, and defining exception handing strategy.
• Designed Concept, Logical & Physical ER Models for Mortgage warehouse using Erwin.
• Performed Data Mapping/Data Migration from heterogeneous sources into the Datawarehouse
• Project Implementation using Agile methodology
• Dimensional modeling using star and snowflake approach.
• Defined technical requirements, technical and data architectures for the data warehouse
• Designed Concept, Logical & Physical ER Model for Datawarehouse using ERWIN
• Performed Dimensional Modeling (Star/Snowflake Schema) using ERWIN/Designer 2000
• Performed ETL, Data Mapping & Design for Business Metrics/Dashboarding projects
• Designed and directed the ETL process, including data quality and testing
• Performed Data Mapping/Data Migration from heterogeneous sources into the Datawarehouse
• Implemented Reporting on Quality Metrics, Business Metrics & Dash boarding
• Identified sources of data for the Datawarehouse
• Worked as Operations Lead for Teradata Accelerated Migration, Data Replication using Golden Gate, Deployment planning, Quality Assurance

Environment: Oracle 9i, Teradata, Erwin, Designer 2000, Oracle BI, Visio, ETL, Informatica Designer 8, PL/SQL, Win XP/2k, Siebel Analytics, Business Objects

Program Lead/Data Architect

Confidential, Santa Clara CA

Responsibilities:

• Worked for Revenue Audit Reporting system at Confidential
• Requirement Analysis, documenting requirements and signoffs
• Defined Logical Models and ETL Data Mapping.
• Datawarehouse Design/ETL/Implementation for Revenue Data Reporting Project
• Conceptual, Logical & Physical Data Modeling on ERWIN
• Dimensional Modeling (Star & Snowflake Schema) using ERWIN
• Design for 3NF databases as well as Star/Snowflake Schema Design
• Reporting Experience in Sales, Customers, Products, Pricing, Rebates, Returns
• Conducted JAD sessions with Subject Matter Experts, data-source stewards and other stakeholders
• Data Migration from Teradata to Oracle
• Maintain the Enterprise data model repository using Erwin Model Mart
• Dimensions: Customers, Products, Returns, Rebates, Sales
• Reviews, System & Integration Testing

Environment: Oracle 9i, SQL Server 2005, ER Studio, Visio, ETL, Informatica, Teradata, PL/SQL, Win XP/2k, Siebel Analytics, Business Objects

Data Architect/Project Lead

Confidential, Schaumberg, IL

Responsibilities:

• Data Architecture, Modeling & Design using Erwin/ERStudio for Legal & Wellness Care System
• Data Migration for Clinical Healthcare data
• Client Interface for Requirement Gathering, Analysis, Milestone Management & Signoffs
• Managing allocated resources from different organizations to achieve on-time and within budget performance objectives for the program
• Dimensional Modeling, Star & Snowflake Schema Design
• Design for 3NF databases as well as Star/Snowflake Schema Design
• Documenting Requirement Specifications, Design, Test Cases & Project Management Plan
• Offshore/Onsite Coordination & Management
• Prototyping, Case Study & Proof of Concept
• Data Migration and Mapping between Oracle Apps HR and Oracle 9i
• Datawarehouse Design/Dimensional Modeling for Customer/Region Module
• ETL Design, Mapping and Implementation

Environment: MS Project, Oracle 9i, Oracle 10g, Oracle Applications HR, SQL Server 2000, Erwin, ER Studio, Designer 2000, Oracle BI, Informatica, PL/SQL, Win XP/2k.

Confidential, Des Moines, IA

Project Lead/Data Modeler

Responsibilities:

• Data Architecture, Modeling & Design of Sample Tracking System for MDS Pharmaceuticals
• Data Modeling for Clinical Database, Patient data, Medicine Samples data, Sample Delivery data
• Requirements Study, Account Management
• Data Modeling for OLTP Pharmaceutical Application
• Review, System & Integration Testing, Acceptance Testing, Signoffs
• Unix Scripting

Environment: Oracle 9i, MySQL, Forms 6i, Reports 6i, QDesigner, Win XP/2k, Unix

Confidential

Program Manager (Datawarehousing)

Responsibilities:

• Managing Sales Datawarehousing project for SBC Telecom
• Datawarehouse Design, Reviews, Acceptance Testing
• Design, estimation, implementation and delivery
• Managing cost schedule performance of equipment for internal and external customers worldwide of Datawarehouse Group
• Identifying and resolving potential complications within the program and developing solutions for resolution
• Proactively identifying and managing key risks throughout the project life cycle
• Customer Account Management
• Change Management
• Providing technical leadership to team members to achieve program goals
• Quality management
• Contributes to effective performance management, employee development and retention
• Scheduling and Delivery

Environment: Oracle Warehouse Builder, Dimensional Modeling, ERWIN, PowerBuilder, MS Project, ERP. ETL

Confidential, California

Project Manager

Responsibilities:

• Data Migration & Conversion project for Excite@Home, broadband company
• Monitoring and reviewing the progress of the project team and providing regular feedback on project progress to the client director
• Data Reengineering for Customer Account Provisioning System
• Team management
• Quality Management & Reviews

Environment: Oracle 7.0.3, MS Project, PL/SQL, Data Migration