SUMMARY:

• Over 17 years of Technical Project Management and Solution/Data Integration/Data Warehouse Architect experience with specialization in the areas of Data Integration, Data Warehousing and Business Intelligence.
• Played Technical Project Manager/Solution Architect roles working with clients across - North America, UK and Germany
• Worked across different domains/sectors - Financial Services Domains (Investment Banking, Card Services and Credit Risk Management - 9 years), Consumer Goods/Manufacturing & Logistics (3 Years), Life sciences (3+ Years) and Health Care (1.5 Years)
• Worked across clients: Kaiser Permanente (USA), Abbott Diabetes Care (USA), Confidential (USA), Confidential (UK), Confidential (UK), Schwan’s Food Services (USA), and Triumph International (Germany)
• Exposed to multiple geographies, nationalities, work cultures and delivery models. Ability to direct complex projects from concept to fully operational status.

TECHNICAL SKILLS:

DA & DW Tools: Informatica Cloud data loader, Data synchronization, Data replication, Informatica (7.x/8.x/9.x - Powercenter, PowerExchange, Data Integration Hub, IDQ, MDM and B2B Data Exchange/Transformation), Oracle Designer, S-Designer, ERWIN

Databases: Greenplum, ORACLE (11g/10g/9i/8i), SQL Server 2000/2012

BI Tool: Cognos, Business Objects

Programming Languages: PL/SQL,Unix

Scheduling Tool: Control-M Scheduler, Tivoli Maestro, Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Datawarehouse Manager/Architect

Responsibilities:

• Lead multiple projects from inception through completion
• Managed coordination across multiple stakeholders from both IT and Business to ensure project objectives are met
• Lead a team of consultants to rollout Traditional SDLC/Agile/RUP projects/programs
• Strong experience in Stakeholders management, client communication, organization and people management.
• Responsible for managing all aspects of assigned projects - full life-cycle (planning and requirements through construction, testing, Implementation and Governance Check-point processes)
• Responsible for providing work direction and leadership to assigned project teams, including scheduling, assignment of work and review of project efforts.
• Implemented PM artifacts like Risk Management Plan, Software Configuration Management, Stakeholder Analysis, Communication plan, RACI matrix, and support process
• Responsible for effectively initiating, planning, scheduling, estimating, forecasting, coordinating, controlling, managing and delivering all activities for projects and related release initiatives
• Responsible for proactively monitoring the project plan (milestones and critical path dates), identifying and resolving issues and assessing variances.
• Developed solutions strategies and roadmaps to address customer goals, innovation needs and constraints
• Addressed IT resources and capacity including local, global, offshore and outsourcing (third party vendor) as part of the strategic planning
• Provided ongoing thought leadership for the architecture, engineering and service delivery associated with all existing and new DW/BI platforms.
• Managed total project/program budget (up to $3 - $5 million) with at least 25-35 FTE’s. Also managed/mentored internal as well as external resources
• Demonstrated hands-on experience and expertise; and comprehensive knowledge and understanding of software development, testing, change and project management methodologies, concepts, practices, procedures and standards
• Established the processes to support the engagement, including defining the project calendar, and defining deliverable acceptance and reporting procedures, conducting project kickoff and holding Conditions of Satisfaction (COS) discussions with stakeholders
• Provided significant contributions, as well as technical leadership to high visibility projects to identify & resolve issues of strategic importance to the organization
• Responsible for gathering metrics, as well as developing and implementing changes (per standard approval processes) to ensure that the project remains within scope, and is within time, cost and quality objectives.
• Responsible for providing the team with constructive feedback pertaining to project performance.
• Improved the workflow process followed in the day to day sustenance activities
• Monitored and reported to Senior IT management on the status of project efforts (such as weekly status reporting, weekly budget tracking, forecasting, and risk prevention/mitigation)
• Directed or developed the quality/testing strategies for the project. Provided best practice recommendations and trade-off scenarios for consideration
• Responsible for measuring and reporting 'on budget' metric for assigned scope.
• Was instrumental in leading multiple RFP/SOW Process alongside managing multiple clientele projects
• Strong experience in architecting and leading DW & BI Solutions using INFORMATICA, Oracle, DB2, SQL Server, Greenplum, Business Objects and Cognos DW & BI Tools.
• Built robust Data warehouses using Enterprise Data Warehouse Architecture, Hub and Spoke Data Mart Architecture, Operational Data Store Architecture and Distributed Data Warehouse Architecture.
• Built largest BI Implementation and multiple Customer Facing Reporting and Analytics platforms.
• Hands-on experience with INFORMATICA ETL tool (Powercenter, Power Designer, MDM, B2B, IDQ), as well as Cognos Enterprise and SAP Business Objects BI tools
• Provided road maps for designing and building robust and scalable enterprise data warehouse and Business Intelligence solutions to serve the future business needs.
• Experience in Data Analysis, Data Quality Analysis, Dimensional modeling, Conceptual, Logical and Physical Data modeling in multiple business domains (Life Science/Banking/Consume Goods).
• Involved in designing Application Architecture, as well as LLD, HLD of end-to-end DW BI solution delivery.
• Derived Data Lineage and Business Rules to drive critical ETL architecture & design
• Currently managing and executing Health Plan Data Integration and Business Intelligence Reporting Project at Kaiser for their National Medicare and Medi-Cal Finance Claims Division...
• Responsible for creating a plan to deliver the roadmaps using client methodology, scheduling and facilitating workshops with key client stakeholders, capturing outputs and producing a roadmap
• Responsible for leading the DWBI architecture and development team in delivering large scale Data Migration of members and Claims from Legacy systems to Enterprise Operational Data Store as well as Data Marts (using Informatica, B2B and Oracle)
• Responsible for Implementing Risk Adjustment Reporting and Analytics (using Cognos and Tableau)
• Responsible for Developing Operational Data Model as well as Data Marts for Medicare and Medi-Cal Lines of Businesses.
• Collaborating with client business leaders, executives, SMEs, information technology, business users on full life cycle engagements
• Developed solutions strategies around Informatica, Oracle and BI tools to address customer goals, innovation needs and constraints
• Managed and coordinated between multi-shore teams and multiple interdependent work tracks
• Managed coordination across multiple stakeholders from both IT and Business to ensure project objectives are met
• Responsible for effectively initiating, planning, scheduling, estimating, forecasting, coordinating, controlling, managing and delivering all activities for projects and related release initiatives
• Responsible for providing timely tracking of deliverables to all stakeholders and escalate issues to the appropriate management level
• Assessed current practices of the Build organization and proposed organization, and process improvement areas
• Managing projects in a cross functional matrix organization
• Guiding and tracking a multi-shore team of about 25-30 FTE/Contactors
• Monitored and reported to Senior IT management on the status of project efforts (such as weekly status reporting, weekly budget tracking, forecasting, and risk prevention/mitigation
• Managed and executed Data Integration and Business Intelligence Reporting Project at BSC for their Shield Advance Billings and Claims Division
• Mapped out future state business requirements by actively consulting with business ant IT Partners.
• Provided a highly scalable technical architecture (on Informatica and Business Objects)
• Responsible for effectively initiating, planning, scheduling, estimating, forecasting, coordinating, controlling, managing and delivering all activities for projects and related release initiatives
• Orchestrated activities across all internal and external teams as well as managed delivery challenges
• Managed the execution of the project, including assigning tasks to project development staff, managing project scope and project finances, as well as ensuring the quality of deliverables.

Confidential

Responsibilities:

• Managed and executed large scale Data Integration/Migration (on Informatica Powercenter and MDM, Oracle and SQL Server 2012) and Customer Facing Reporting and Dashboard Analytics (on Business Objects) projects at Pfizer for their Oncology and Primary Care divisions in the areas of clinical trials and sales and marketing across 16 European Countries and 4 Business Units
• Lead the architecture and development team teams with the integration of Pfizer’s Oncology and Primary Care data from across 16 EU countries into their centralized Data warehouse as well as Distributed Data Marts.
• Planned and executed agile adoption strategy from modeling through system integration testing
• Executed a large scale satellite user acceptance testing across 16 European countries.
• Established a roadmap to streamline the build organization & achieve increased productivity, quality and improved time to market objectives
• Managed and coordinated between multiple sites and up to 6-7 interdependent work tracks
• Managed coordination across multiple stakeholders from both IT and Business to ensure project objectives are met
• Implemented PM artifacts like Risk Management Plan, Software Configuration Management, Stakeholder Analysis, Communication plan, RACI matrix, and support process
• Assisted in qualitative/quantitative risk assessments
• Directed and developed the quality/testing strategies for the project
• Managed a multi-shore team of about 30-35 people

Confidential

Responsibilities:

• Lead the architecture, analysis and development phases of Franklin’s Enterprise Data Warehouse (EDW) Product Data load as well as Data validation projects
• Responsible for building robust Data Warehouse using the Enterprise Data Warehouse Architecture
• Provided Highly customizable, robust, efficient and Scalable ETL/BI solution framework built using reusable components in Informatica, Unix, Business Objects and Greenplum/Oracle database objects, that could be later extended across other LOBs.
• Responsible for building robust process for fixing the data quality problems and anomalies discovered using the Informatica Data Analyst tool by developing cleansing and standardization mappings as well as building mapping for address validation using postal data.
• Responsible for building automatic consolidation strategies and data cleansing, using the Data Quality Assistant in the Informatica Analyst as well as Integration of IDQ mappings with Powercenter mappings
• Responsible for proactively monitoring the project plan (milestones and critical path dates), identifying and resolving issues and assessing variances.
• Responsible for gathering metrics, as well as developing and implementing changes (per standard approval processes) to ensure that the project remains within scope, and is within time, cost and quality objectives
• Worked with offshore development team, coordinating the hand-off process from design onwards to offshore team, checking and validating development progress and status
• Deployed Usage of detailed logging enabling, efficient debugging of production issues, effective lineage tracking of data (using ASG Rochade) and efficient restart ability for the system.
• Provided logical modeling, star schema design, data model release management, metadata management, data model version support, and month end data dictionary updates.

Confidential

Responsibilities:

• Rolled-out one of the world’s largest data and BI migrations from legacy (mainframe) to DWBI Hub and Spoke Data Mart Architecture
• Lead the architecture, analysis and development phases of Schwan’s DWBI releases
• Lead/developed ETL/Reporting applications using INFORMATICA, Cognos 8 and SQL Server 2000
• Extracted Data Transformation Rules and flow diagrams in large data integration projects.
• Provided Data Quality Assessment, planned and implemented successfully within large data integration projects
• Derived Data Lineage and Business Rules to drive critical ETL architecture & design
• Provided Analytical and Canned Reporting Solutions to business users

Confidential

Solution Architect

Responsibilities:

• Provided a road map for designing and building robust and scalable enterprise data warehouse and Business Intelligence solutions to serve the future business needs.
• Strong experience in architecting DW & BI Solutions using INFORMATICA, Oracle, DB2, and Cognos DW & BI Tools.
• Experience in Data Analysis, Data Quality Analysis, Dimensional modeling, Conceptual, Logical and Physical Data modeling.
• Involved in designing Distributed Data Warehouse Architecture, as well as LLD, HLD of end-to-end DW BI solution delivery.
• Derived Data Lineage and Business Rules to drive critical ETL architecture & design

Confidential

Responsibilities:

• Designed and architected DB SMART - Strategic Management Analysis and Reporting Tool, a Bank Wide Central Relational Data warehousing system using Distributed Data Warehouse architecture which holds terabytes of trade information from multiple banking systems such as DB-Trader, Mantec, Computron & Front Office Systems.
• Involved in the application & technical architecture design, analysis, design, development and implementation of new releases and enhancements.
• Developed reusable components and complex Informatica Mappings and Cognos Reports.
• Lead project teams for the new application releases and provided mentoring and to the team members through functional and technical sessions.
• Interacted with DB Integration Engineering Teams to launch the applications in staging and productions environments.
• Coordinated and managed various Production support and Knowledge Transition activities.

Lead Developer

Confidential

Responsibilities:

• Designed and Developed Credit Automation and Marketing System (CAMS) is a ‘Decision Support System’ for Banks
• Provided multithreaded functionality of the user requests to enhance site performance.

Confidential

Lead Developer

Responsibilities:

• Developed and rolled-out Product Data Management software for Triumph International Germany
• Developed remote data entry system for Smith Kline Beecham Biological, Belgium