SUMMARY

• 17+ years of IT software industry experience Operational and Business Intelligence systems.
• 10+ of hands on technical experience in Data Modeling, Analysis, SQL, Data Architecture, ETL Design, Data Migration and Conversion projects
• 5+ years of Program Management/Project Management experience
• Worked in multiple business verticals including Manufacturing, Order Management, Product Management, Gaming and Hospitality, Banking, Insurance
• Extensive experience in handling Data Quality issues, Source Systems analysis, and conducting JAD sessions wif subject matter experts, data stewards and project stakeholders
• Experience in coordinating Offshore/Onsite teams as Global Implementation Model
• Strong Interpersonal & Communication skills and teh ability to work in a multi - disciplinary team environment and manage a wide variety of engineering staff
• Experience in Quality Control, Quality Assurance Practices, ISO, CMM processes.
• Exposure to Big Data, Hadoop

TECHNICAL SKILLS

RDBMS: Oracle 9i, Oracle 10g, SQL Server 2005, Teradata 13.10

Data Modeling Tools: Erwin 7.3, Oracle Designer 2000, Embarcadero ER/Studio

Datawarehousing: Oracle Warehouse Builder, Informatica Designer, MicroStrategy

Database Tools: SQL*Plus, SQL Navigator, Teradata Manager, Toad

Project Management: Microsoft Project

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

Quality: Conversance wif ISO, CMM & CMMI Procedures

PROFESSIONAL EXPERIENCE

Confidential

Data Architect / Data-warehouse Consultant

Responsibilities:

• Documenting functional and technical requirements for Confidential Finance Data-Warehouse
• Performing Data Analysis wifin Teradata and SQL Server environments
• Working wif business, users to understand end customer needs
• Performing gap analysis between existing systems and new requirements
• Working wif Analysts, ETL team on finalizing technical requirements
• Data Modeling - Conceptual Logical & Physical Data Modeling using Embarcadero ER/Studio
• Data Mapping between Source and Target Database systems
• Writing test cases, and performing testing in Data-warehousing environment

Environment: Teradata 14.10, SQL Server, Win 7.0, Erwin 7.3

Confidential

Datawarehousing Architect/ BI Lead Consultant

Responsibilities:

• Datawarehousing solutions implementation for gaming and hospitality clients for their campaign management systems, property and product-wise revenue reporting, marketing reports
• Requirements Analysis, Data Analysis and Design activities for gaming systems
• Working sessions wif data stewards, project stakeholders, architects to finalize technical requirements.
• End to end project lifecycle management, estimation, progress reporting
• Designing Logical Model and Physical Data Models
• Gap analysis between existing systems and new requirements
• Performed Reviews, System & Integration Testing
• Source Systems analysis and data mapping
• Working wif business analysts and SME’s on business requirements

Environment: Erwin 7.3, Informatica, Teradata 12, Teradata 13.10, Win 7.0

Confidential, San Francisco, CA

Project Manager/Data Architect

Responsibilities:

• Project life-cycle management, progress reporting, estimation
• Systems Analysis and Study of Facets Healthcare application
• Requirements Analysis, Data Modeling and Design for IDS Healthcare system
• Gap analysis between Facets and IDS (3NF ODS Later)
• Enhancement of IDS database for different subject areas including Membership, Claims, Accounts, Billing, Cases, and HIPAA.
• Designing Logical Model and Physical Data Model for ODS Layer
• Source Systems analysis and data mapping
• Conducting JAD sessions wif Subject Matter Experts, data-source stewards and other stakeholders
• Experience working in Offshore-onsite model for project implementation

Environment: Embarcadero ER/Studio, Oracle 10g, PL/SQL, Win XP/2k.

Confidential, TX

Project Lead/Solution Architect

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 wif Sales and Quotes data in teh Datawarehouse
• Designing Logical Model and Physical Data Model for teh Solution Reporting using Embarcadero ER/Studio
• Source Systems analysis and data mapping

Environment: Embarcadero ER/Studio, Teradata 12, Oracle 10g, SQL Server 2005, PL/SQL, Win XP/2k.

Confidential, TX

Data Architect

Responsibilities:

• Requirements Analysis, Data Modeling and Design for Home Loan Database.
• Working wif data stewards, Business Analysts and other stakeholders to understand database related requirements
• Designing Logical Model and Physical Data Model using Erwin
• Source Systems analysis and data mapping

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

Confidential, Sunnyvale CA

Program Lead/Architect

Responsibilities:

• Managing end to end project cycle from requirements to implementation
• Leading a team of developers, testers, and business analyst and salesforce consultant.
• Working on Application Integration Design of Channel Application wif Salesforce.com
• Coordinating testing wif other development groups and operations.
• Conducting JAD sessions wif Subject Matter Experts, data-source stewards and other stakeholders
• Managing Offshore-onsite model for project implementation
• Task planning, monitoring, and progress reporting
• Managing Data Migration from Oracle to Salesforce.com

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

Confidential, CA

Data Architect

Responsibilities:

• Data Modeling for Business Dashboards, Consumer Acquisition Dashboards, Product Release Management system, Defect and Productivity Metrics
• Worked on gathering & documenting requirements in JAD sessions wif customers, stakeholders
• Defined technical requirements, technical and data architectures for teh data warehouse
• Project Implementation using Agile methodology
• Designed Concept, Logical & Physical ER Model for Datawarehouse using ERWIN
• Performed ETL, Data Mapping & Design for Business Metrics/Dashboarding projects

Environment: MS Project, Teradata, MicroStrategy, Informatica

Confidential, Santa Clara CA

Solution Architect

Responsibilities:

• Worked for Revenue Audit Reporting system at Confidential
• Datawarehouse Design/ETL/Implementation for Revenue Data Reporting Project
• Conceptual, Logical & Physical Data Modeling on ERWIN
• Dimensional Modeling (Star & Snowflake Schema) using ERWIN
• Reporting Experience in Sales, Customers, Products, Pricing, Rebates, Returns
• Reviews, System & Integration Testing
• Data Modeling for Business Dashboards, Product Release Management system, Defect and Productivity Metrics

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

Confidential, Des Moines, IA

Lead Consultant/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, Redwood City, CA

Technical Project Manager

Responsibilities:

• Managing Data Migration & Conversion project for Excite@Home, broadband company
• Onsite/Offshore Team Management for multiple India based projects
• Data Reengineering for Customer Account Provisioning System
• Quality Management & Reviews

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