SUMMARY:

• Highly driven technology delivery leader in Business Intelligence and Data Warehousing space with 15+ years of outstanding experience and proven capability in directing technology programs with globally distributed teams.
• Managing complex BI/DW projects from architecture/performance/upgrade and operational perspectives
• Project/Program/Delivery Management (of large/complex globally distributed projects)
• Responsibilities - Overall accountability, Plans & Schedules, Monitoring, Risks Management, Team management, Status calls, Dashboards, Resource Planning, Issue Resolution, Build Management, Cutover planning, Release Management, Environment Management, Sign-offs, Transition from/to other teams, Relationship Management
• Business Intelligence and Data Warehousing
• Project/Program/Delivery Management
• Data Integration / ETL and Data Quality/Analysis
• Data Modeling/Architect (OLAP/OLTP-3NF)
• Business/IT Consulting
• Onsite-Offshore Coordination & Disaster Recovery Planning
• Application software development SDLC/Agile (primarily for Database / Datawarehousing Projects)
• Financial (Revenue & Investment Banking) & Telecom domains

TECHNICAL SKILLS:

Data Modeling Tools: Erwin Data Modeler v4x/7x, Embarcadero ER Studio v7.1.3, DB Designer

Business & Analysis Skills: Business/System Analysis, Data Analysis, Requirement Gathering (BRD creation), Exceptional Client Relationship skills, Team building and Conflict Resolution, Continuous Process Improvement, JAD sessions, UML diagrams

ETL & Reporting Tools: Informatica 5.1 / 7.1.x ; Microstrategy 7.5.1

DBMS & Languages: Oracle 8i/9i/10g ; PL/SQL, C, C++, UML

Operating Systems: Windows 9x, NT, 2000, HP-Unix, Red Hat Linux

Tools: Beyond Compare, Remedy-ARS, MS Visio, Test Director, Mercury Quality Center

Methodology & Job Management: CMM Awareness, QA Processes, SDLC - Waterfall Strategy ; Autosys

Utilities (Database): TOAD, SQL Developer, SQL Tools

Source Code Control: Visual Source Safe, Win CVS 1.3, Documentum

PROFESSIONAL EXPERIENCE:

Principal Data Intelligence Engineer

Confidential

Responsibilities:

• Global Data warehouse for finance department. The data is used to report organization’s consolidated revenue for the quarter. Managing the teams involved in projects, operations as well as performance/enhancements/bug fixes. Managed the team involved in Propel initiative (Source system replacement - Oracle to SAP), 445 initiative (fiscal calendar modification from regular calendar format to 445 format).
• Global Data warehouse for Human Resources. The data is used to report organization’s HR data such as employees, benefits, stocks etc. Managing the teams involved in operations as well as performance/enhancements/bug fixes. Managed the team to move/integrate the entire dataset from one database to another database. Managed the team involved in Propel initiative (Source system replacement - Oracle to SAP).
• Informatica, Oracle and Control-M upgrades - Managing the teams involved in technology upgrades (from major version to newer version)
• Responsible for maintaining various SLAs for the different applications. Reporting the same to VP/Directors.
• Managing automation of various ad-hoc/recurring activities as well as providing users the flexibility to view the desired data via GUI.
• Auditor for applications data to be accessed for various users to make sure that the data access is for only valid users at any given time.
• Release Manager for various applications.
• Managing the teams responsible for all phases of SDLC for the applications. Providing them guidance as Project Manager (Application/Data Architect and Solution Delivery Lead).
• Project/Program Management (of large/complex globally distributed projects) Responsibilities - Overall accountability, Plans & Schedules, Monitoring, Risks, Team management, Status calls, Dashboards, Resource Planning, Issue Resolution, Sign-offs, Transition from/to other teams, Management & Relationship
• Using Erwin Data Modeler, Involvement in the creation/modification/maintenance of the conceptual and logical data model & data dictionaries for project layers - Staging, Data Warehouse and the Data Marts.
• Study and analysis of the source data, mapping of the source data (direct as well as the transformation)
• Involvement with the project management team about the business requirements closure in terms of all the facts and dimensions required for reporting.
• Work to gather Business Requirements through interviews and sessions with end users.
• Involvement in business meetings, understanding the requirements, creation of Business Requirements documents (BRD), reviewing & analyzing BRD and translating them into Technical Specification documents.
• Involvement with the DBAs, helped them creating the database objects on different environments.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations
• Worked on development of Oracle Database Packages, Procedures, Functions and Triggers using PL/SQL.
• Involvement in executing all the roles & responsibilities of a DBA.
• Worked on performance tuning of the SQL queries using Explain Plan.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Involvement in all the database releases (both scratch and patch) (On all environments - System / UAT / Production).
• Worked on Operating Systems Windows 9x/NT/2000, HP-Unix, Red Hat Linux, TOAD, Methodology QA Processes, SDLC
• Analytical expertise in the skills Business/System/Data Analysis, Requirement Gathering, Continuous Process Improvement
• Analysis, estimation, design, reviews, implementation, testing, support / interaction to/with clients, producing business reports for business users and preparing the client deliverables.
• Data Modeling (OLAP/OLTP-3NF) Business meetings, JAD sessions, requirements gathering, creation of UML diagrams, Business Requirements documents (BRD) & Technical Specification documents, Business Consulting Application software development SDLC/Agile & maintenance activities (primarily for Database / Datawarehousing Projects), IT Consulting, Production Support (24*7)
• Review of the unit/system/performance development test cases to make sure that the application would work for all the scenarios. Execute Business Test Cases and perform User Acceptance Test.
• Coordinating and assisting the offshore team to ensure that the tasks are delivered on schedule. Responsible for weekly dashboard creation and overall accountable for the delivery.

Confidential, Washington DC

Data Modeler ; System Analyst ; Developer; Production Support Analyst

Responsibilities:

• Fulfilling client requests to change business logic (addition/modification of the code) based on change in the guidelines of the governing bodies.
• Providing all the possible solutions along with the best approach option in terms of business profitability / process optimization to the clients.
• Loading data (with the help of input feed files) into the warehouse / data mart after all the required and possible validation.
• Producing business reports for business users based on the data mart data.