SUMMARY

• Client-focused,strategic planner/leader, hands-on PM, solution architect and result oriented professionalwith 20 years of Information Technology experience including 15 years of full lifecyclemid to large scale Data Warehouse, Business Intelligenceand Analytics project management experiencefrom data driven organizations.
• Industry-leading expert specializing in the Enterprise Information Management areas including Data Governance, Business Intelligence, Enterprise Data Warehousing, Analytics, Kimball and Inmon Methodologies, Data Architecture, Data Quality, and Metadata.
• Led the design, development and implementation of over 10 Data Warehouse/Business Intelligence Systems at Fortune 100 companies including industry experience in Financial Services, Pharmaceuticals, Hospitality / Reservations, and Media.
• Excellent leadership and communication skills including interaction with C level management. Proven ability to work effectively within a highly matrix, global environment.
• Strong history of partnering with business / process groups to achieve goalsthat provides guidance, functional, and technical solutions.
• Ability to establish and maintain a high level of customer trust and confidence in the Data Warehouse/Business Intelligence team.
• Strong team-oriented interpersonal and people management skills ability to define team goals and objectives and motivate a high performing team to achieve them.
• Management style that exhibits high energy, strategic thinking, collaboration, direct communication and results orientation.
• Strong project management skills in strategic planningand monitoring projects in a cross-functional environment.
• Strong ability to maintain efficient relationship with off-shore, on-shore, and near-shore vendors and business partners.
• Strong knowledge and experience of structured analysis and technical design techniques.
• Extensive background in lifecycle development SDLC of Business Intelligence applications in compliance with Waterfall and Agile Development Methodology.
• Strong documentation skills especially preparing data/process/system flows, business/reporting requirements, technical specifications, etc. in compliance with CMMI level 3.

PROFICIENCY

Methodologies: CMMi Level 3 Agile, Waterfall, and RAD SDLC

Software: Collibra, Tableau, SAP Business Objects, SAP Xcelsius, Cognos BI, MicroStrategy, Microsoft SSRS, BrioQuery, Informatica, ERWin, Infoburst, Version Manager, Microsoft SharePoint, MS Office, MS Project, MS Visio, Toad, SQL Navigator, DBArtisan, Clarity, JIRA, Livelink and Remedy Change Management

Databases: Oracle, SQL Server, Sybase, DB2/UDB

Training: Managing Remote Employees, Credit Risk, InformaticaPowerCenter, Oracle 9i, CognosBI workshop, and referred Project Management books/materials including PMBOK.

EXPERIENCE

Data Governance Principal

• Responsible to establish technical vision, strategic planning, company growth, software vendor management, build on-shore and off-shore team, build technical research lab, capitalize employees' strength, client engagements, etc.
• Client: Fidelity Investments, Personal and Workplace Investing, Customer Knowledge and Strategic Insights
• Direct and collaborate with business, operational, and technical stakeholders on implementing data governance strategy, utilizing information governance, data quality, information architecture andinformation asset management capabilities in support of achieving business operations, strategic goals and objectives.
• Lead data quality efforts including the definition of business rules and the resolution of quality issues impacting critical data elements. Effectively communicate data quality metrics and performance indicators to data stakeholders.
• Drive the rollout of metadata and policy management tool Collibra across all data platforms.
• Implement data security processes and capabilities for applications and data platforms in accordance with Fidelity information security policies.
• Define and operationalize governance of critical data elements.
• Collaborate with Legal, Risk and Compliance Teams on the use of Data Governance to support regulatory compliance.
• Client: AIG, Enterprise Data Management
• Participated in Collibra Data Governance Solution implementation at enterprise level.
• Prepared required documents to comply with CDO, infrastructure team, and audit requirements.
• Prepared Collibra training materials and provided training to the platform and application system administrators.
• Participated in UAT sessions to receive sign-off from business units' data stewards, business SME, and business data owners to go-live with Collibra DGC.

Confidential

• Responsible for client facing, strategic planning, all aspects of BI technology management/leadership of multiple BI/DW projects in parallel, promoting BI awareness, defining data management strategy, and transforming data into a corporate strategic asset.
• Responsible for people management resource and capital expenditures budgets negotiations and development of guidelines, standards and procedures.
• Define, articulate, architect and deliver solutions to meet the Business Intelligence andAnalytics needs of key stakeholders including Compliance, Finance, Governance, HR, Loan Servicing, Prime Brokerage, Procurement, Risk and Controls, Tax, and Trade Finance.
• Responsible to work effectively with and influence business partners, IT management, BI team, technology service partners, Corporate and Data Governance, software vendors, and solution providers.
• Develop and communicate goals, strategies, roadmap, vision, project plans, timelines, milestones, and KPIsfor management review.
• Provided technical leadership and mentoring to BI team located in US, Brazil, Canada, and India develop team spirit motivate team members to achieve their career growth and achieve substantially quantifiable gain in productivity.
• Evaluated SAP and Informaticasolution for Data Governance to improve data discovery and data quality and to introduce master data management and business glossary.
• Defined data management strategy to improve processes regarding data flow and data quality to provide accurate and complete data.
• Worked on Cost Center Hub, a master data management MDM POC project for Finance Project Office FPO .
• Developed Analytics solution to project budget for next year, reduce financial expenses, technical resource optimization, softwarelicense cost savings, optimize spending on contingent resources, insights on HR data, and manage risk on institutional clients' loan activities.
• Initiated cultural change for Enterprise-wide Business Intelligence awareness through training programs to 400 business users,15 business leaders, 10 IT executives, and 15 IT managers.
• Led resource and infrastructure consolidation initiative to deploy Tableau visual analytics software.Slashed hardware, software, and services cost 30 by negotiating pricing and fees, while ensuring the continuation and enhancements of services.
• Responsible for all aspects of Tableau solution architect including design and implement user security layer, provide hands-on training, and promote data visualization awareness. Led design, development, andimplementation of 28 dynamic dashboard for Procurement team to get insights into vendor management.

Environment:Agile, CMMi Level 3, Tableau, SAP BusinessObjects, SAP Xcelsius,Cognos BI, Informatica, Infoburst, Version Manager, MS SharePoint, MS SSRS, Oracle 11g, Clarity, JIRA, Livelink, MS Project, MS Office Suite and MS Visio.

Confidential

Data Warehouse Project Lead

• Host weekly meetings with senior management and business partners to understand business and reporting requirements and demonstrate/UAT business intelligence application
• Assist the manager in keeping track of projects, timelines and issues
• Responsibilities included:
• Ledthe proof of concept phase of creating trading reporting database for Municipal Securities Group. The source databases are JJKenny bond reference data , marketing client holdings , research MSRB trades , and trading bond sales, trading volume, daily inventory of bonds, BMA/MMA.CPI, LIBOR, MMD yield curve, etc. .
• Evaluate and introduceSAP Business Objects software and design reporting database

Environment:SAP BusinessObjects XI R2, Sybase ASE 12.x, DBArtisan, MS Office Suite and MS Visio.

Confidential

Data Warehouse Project Lead

• Assisted the manager in keeping track of projects, timelines and issues.
• Led Data Architects, Ab Initio and SAS developers, and off-shore system testing resources. Managed 6 on-shore and 2 off-shore technical resources.
• Played a key role in the design, development, and architecture of building dynamic and high visibility data warehouse system for the Pharmaceutical Sciences group.

Environment: Oracle 10g, ErWin, Ab Initio, SAS 9.x, Toad, MS Office Suite, and MS Visio.

Confidential

Data Warehouse Project Lead/Architect

• Responsible for data warehouse architecture, implementation, documentation, quality assurance, and support end-to-end solutions, including dimensional data models, data integration, and business intelligence applications supporting international airline reservation system for 10 international airlines. The new system increased productivity, displace costs and enable airlines to maximize profitability.
• Analyzed and designed data warehouse sourcing strategy from OLTP system with 300 tables, 500 stored procedures, and 50 views.
• Focus on Business needs through participation with CEO, CTO, account managers and business leaders to identify Data Warehousing opportunities and leveraging Business Intelligence.
• Performed detailed BI assessment and BI vendor management that resulted in the introduction of CognosReportNet for providing analytical reporting, including revenue analysis, market analysis, tax liability, strategic planning, and data mining.
• Coordinated with Quality Assurance team to ensure data and reporting integrity.
• Education and preparation of training team to support internal business units and company's clients utilizing CognosReportNet analytical reports.

Environment:CognosReportNet, Oracle 9i, Oracle SQL Developer, SQL Navigator, MS Office Suite and MS Visio.

Confidential

Data Warehouse Project Lead

• Project Lead for MetLife Institutional Sales and Marketing Data Warehouse. Managed three resources.

• AssistedProject Manager in the project lifecycle from inception to the delivery stage of the projects.
• Committee member of QMS team and also responsible to implement CMM Level 2 Compliant standardized processes into the Institutional Data Warehouse and subject area Data Marts.
• Facilitated project planning sessions with business to analyze and document Business IT requirements. Develop Project Charter to define the scope of the project, and develop Quality Assurance and User Acceptance Test plans.
• Prepared system specifications documents including target-to-source data mappings and data warehouse load specifications. Work with Data Modeler to design dimensional logical/physical models, coordinate with DBAs, Informatica resources and business intelligence partners to implement new development and enhancement requests.
• Collaborated on adapting interfaces for Sales, Quotes and Product hierarchy for multiple business units originating from MetLife Sales and Marketing Data Warehouse to MetLife front end CRM application, SalesRadar. This effort has provided the MetLife Institutional Sales force a mechanism to achieve greater value from their Book of Business and Opportunity Data within a centralized application.

Environment:CognosReportNet, Siebel CRM,Informatica 6.x, ERWin, DB2/UDB, CMMi Level 2 and MS Visio

Confidential

Data WarehouseProject Leader

• Managed one front-end and one back-end data warehouse development resources.
• Strategy and Project lead for transitioning of Pharmacia's Consumer Healthcare and Contract Manufacturing Data Warehouse systems to Pfizer. The systems provided a global consolidated source for sales, financial, and customer information. Contributions include: defining conversion and interface requirements, identifying critical tasks, providing technical mentoring, designing and creating data extracts, updating data models, developing and executing systems retirement procedures, testing, and implementation.
• Established and Implemented best practices and standards for data modeling, extraction, transformation and loading ETL and business intelligence BI design and development.
• Primary responsibilities included system architecture, development and deployment of ETL solutions using InformaticaPowerMart, Oracle Sql, and Unix Shell scripts analyzing and defining data flow requirements developing a scalable architecture for integrating, staging and loading data capturing meta data and business rules associated with the ETL processes developing software components to support the transformation preparing and implementing data verification and testing methods designing and implementing data staging methods collaborating with Oracle DBAs and Unix production support personnel to automate the back-end environment and documenting the ETL processing.
• Technical lead for the overall design, development, implementation, and testing of the extraction, transformation and load process ETL for Data Warehouse systems with multiple subject areas.
• Primary contact for gathering/documenting business and reporting requirements.
• Led the Infrastructure Upgrade project. Contributions include: propose change in database design, change data models, modify Informatica 6.2 mappings/sessions, create Informatica work flows, coordinate MQ Series installation, coordinate change in Micro Strategy schema objects reports, and preparing/implementing data verification and testing methods.
• Worked extensively with complex mappings including type 1 and type 2 slowly changing dimension tables, outer joins, and customized queries in Informatica transformation objects.

Environment:Microstrategy,Informatica 6.x, ERWin, Oracle 9i, Unixand MS Visio

Sr. Data Warehouse Consultant

• Participated in building business driven Enterprise Data Warehouse EDW to analyze firm's market risk assessment in terms of margin debit and to exploit client information for competitive advantage.
• Provided effective and timely data analysis and database design services for data mart initiative.
• Designed and maintained dimensional data models using ERWin. Collaborated with database administrators and developers to implement optimal physical database models.
• Responsible for the overall design, development, and implementation of the processes to extract, transform and load the data into the data mart.

Environment:Business Objects v5, Brio, ERWin, Informatica, DB2/UDB and MS Visio

Data WarehouseSystems Manager

• Participated in designing Prudential Institutional Client Data Warehouse architecture for E-Commerce. The purpose of the Data Warehouse was to maintain data about institutional clients, products, and investment events to facilitate effective marketing, strategy decisions, and cross selling by each product area as well as the entire business unit.
• Performed business and data analysis for Retirement Services product area. Prepared business analysis documents consisting of business requirements, business and system flow diagrams, functional specifications, and transformation plans.
• Managed one ETL developer.

Environment: Informatica, Oracle and MS Visio

Sr. Data Warehouse Consultant

• Provided technical mentor in designing a long-term architecture for an integrated Enterprise Information Warehouse EIW .
• Managed the project to design, develop and deploy the HR Subject Area of EIW.

Environment:ERWin, Informatica, Cognos, Oracle and MS Visio

Assistant Vice President, Data Warehousing Group - Investment Banking

• Managed daily operations of the Data Mart environment for three business domains.
• Acted as Management Consultant for extending Data Warehouse environment to other groups.
• Managed all phases of web application development project including defining business needs, identifying critical tasks, preparing specifications, providing technical mentoring, testing, and implementation.
• Technically led the creation of Data Mart environment with three business domains. This involved defining the high level architecture: discrete components and process, defining scope of the project, defining business requirements, preparing functional requirements documents, re-engineering business processes, designing data staging process including preparation of dimensional data model - star schema, developing end user applications, designing application deployment strategy, implementation, and providing ongoing support and education to users.
• Worked with Y2K group for certification process and training group to prepare training materials for DWH applications.
• Worked with the Quality Assurance group in implementing Change Management and QA procedures to test Data Warehouse DWH applications.
• Used Cognos business intelligence tools for the development of DWH applications including configuring the tool metadata, providing the ideal reporting solution for both end users and IS, and delivering a robust OLAP reporting and analysis environment.
• Worked with consulting resources on product evaluation and prototyping proof of concept.
• Documented all the best practices with the DWH application.

Systems Analyst, Application Development Group - Investment Banking

• Implemented and enhanced a Client/Server SqlWindows system to interact with all the other Investment Banking applications in Merrill Lynch. This application maintains the relationship between all of Investment Banking clients and bankers. As a part of enhancement, streamlined and stabilized the application to be more user-friendly and used by over 750 clients worldwide.

Environment: Gupta SqlWindows, ERWin, Informatica, Cognos Impromptu/Powerplay, Oracle, and MS Visio

Sr. Programmer/Analyst

• Designed, developed and implemented Job management system for an Art Studio. The system was designed with OOP methodology for maximum code and component re-use. Worked with the users to create a logical and physical data model for the application using SqlServer and SqlWindows.
• Involved in the design and development of a Client Server application to monitor purchase, planning and budgeting for Telemedia.
• Developed Resource Allocation and Placement tracking system for HR personnel and project status for MIS department using LOTUS Notes and SqlWindows. Assisted DBA in periodic database maintenance.

Environment: Gupta SqlWindows, Oracle, and MS Office Suite

Programmer/Analyst

• Developed Financial Message System in IBM C/2 under OS/2 EE. Tasks included designing, coding, and testing of S.W.I.F.T. financial message system, authentication co-processor, ISAM type database and screen handling routines for the menu-driven system to work under both DOS and OS/2.
• Designed and developed PC data security and key management application system in Microsoft C to perform cryptographic services using the NBS Data Encryption Standard and financial message authentication using ANSI 1982, 1986 Financial Institution Message Authentication System. Tasks included installing, training, documentation, and support of several remote sites such as Domestic Money Transfer, Telecommunications, and Foreign Exchange departments.
• Converted a network data security system, written in Lattice C in conjunction with Btrieve and Xtrieve, to a stand-alone system, which interfaces with Racal-Guardata security card to authenticate transactions for the Foreign Exchange department.

Environment: C, DOS, MS Office Suite, and MS Visio

Student Aid Consultant

• Assisted students, faculty, and research personnel in designing, coding, and debugging programs and the usage of operating systems, hardware, and software.

Programmer

• Analyzed and automated the accounting system related to U.S. Treasury Bills tracking system for a portfolio of 90 million.
• Automated reports of Repurchase Agreement, Load Yield, and Consolidated Balance Sheet for Income and Expense.

Jr. Accountant

• Updated journals of foreign currency loans, loan participation sold, and Time deposits of bank and prepared monthly reports of same.
• Worked in groups to prepare Investment Analysis reports for NY state auditors.
• Involved in the project of auditing branches for foreign currency accounts.