Sr. Data Architect/lead Datawarehouse Consultant Resume
CaliforniA
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
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.
Project Lead/Data Modeler
Confidential, Des Moines, IAResponsibilities:
- 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
Program Manager (Datawarehousing)Confidential
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
Project Manager
Confidential, CaliforniaResponsibilities:
- 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