Program Director Manager

Public

Srinivas Velappan Pillai

Sr. Program Director – Data & Analytics

Castle Pines, CO 80108 +1-720*******

https://www.linkedin.com/in/srinivas-velappan-pillai-3917b030? ********.*********@*****.*** Profile:

• Data Modernization & Analytics solution leader with a proven track record of successfully directing, managing, designing and execution of complex enterprise IT initiatives on varying platform & technologies

• 20+ years of experience with a strong background in Cloud Warehousing, Enterprise Data Warehousing, Data lake & Master Data Management. Worked in Large scale implementations of Information Architecture, Database design, Enterprise application integration and data Migrations

• 10+ years of experience in high-performance team building and lasting customer relationships by helping them solve existing problems and building focus on future

• 8+ years of experience in program management. Delivered large transformation programs focused on implementing strategic IT goals, improving business agility, & cloud transformation journey’s.

Professional Snapshot

Wipro Limited USA

Sr. Program Director May 2004 – Present

Key Roles & Responsibilities

• Program Director – Charles Schwab - Oct-2018 – Present (Responsible for Data and Analytics projects under Wipro. Leading a team of 350+ associates on multiple SOWs (90 + Onshore & 280+ associates at offshore. Managed multiple large programs – GCP Cloud Migration, TDA/USAA migration, Big data implementation, etc)

• Practice Delivery Manager- May-2015 to Oct -2018 (Played a Practice Delivery Assurance Manager Role for 3+ years at Wipro India location. Responsible for ETE delivery for MDM, Financial Risk and Compliance Projects across Wipro with team size of 300+ spreading across Multiple Customers)

• Program Manager - Target –Corp - Jan -2013 To May-2015 (Played a Technical Program Manager role for 2+ years for Target Corp, USA. A large Outsourced Program to Wipro. All types of Small, Medium, Large projects under Target EIM are grouped under this program. 70+ resources with Multiple technologies and Applications across 5 Portfolios. Responsible for end to end delivery ownership,Stakeholder Management and Operations)

• Technical Manager – Target Corp(USA)- Dec-2010 – Nov-2012 -(Played a Technical Manager role for Teradata Migration/implementation for Target Corp,USA at Onsite

− Program Management − Data Practice Management

− Google Cloud Migration − Technology Portfolio Management

− Enterprise Architecture − Distributed Data Platform Design

− Data Analytics & Reporting − IT Operations & Support

− Global Team Training & Development − Vendor Management / Partnerships Public

Education

− Bachelor of Engineering, Electronics and Instrumentation Engineering, National Engineering College, Manonmaniam Sundaranar University, Tirunelveli, TN, India ( 1999- 2003) Technical Skills

Cloud Platform – Google Cloud

ETL Tools -IICS, Informatica, Data Stage, Talend, PL-SQL MDM – Informatica MDM, IBM MDM

Database – Google -Big Query, Teradata, Oracle, MS SQL Server,DB2, Non Stop SQL, Leading Big Query,Data Modeling - ERWIN

Data Quality – IBM Qulaity Stage,

Development/Productivity Tools : Quality Center, Service Now Database Tools : Teradata SQL Assistant, SQL Developer & TOAD Big Data Technologies: Good exposure in Hadoop, MapReduce, Oozie,Hive, NoSQL, Programming -Languages :Tandem C/C++, TACL, ERP : SAP – Job Scheduler -, Maestro, Control M

Professional Experience

For Client Charles Schwab, Lone Tree, CO 2018 – Till date Sr. Program Director for Data & Analytics Unit

• Responsible for delivering $25 M+ Projects & revenue growth in the area of data & analytics for a client Charles Schwab Corporation’s

• Working with tenants and stakeholders from various departments to provide resolution on technical challenges and participating in an escalation call, improving, and optimizing the current intake, handoffs, and solution delivery execution process.

• Led Program governance meetings with client VP & Stakeholders. Managed risks & issues, team's allocation, capacity, performance evaluation, hires, promotions, compliance training and safety etc.,

• Responsible for technical solutioning for RFPs, Estimation and SOW creations for renewals and new opportunities

Key Programs/Projects Delivered

Google Cloud Migration (June,2022 to May,2024)

• Wipro’s Scope was to migrate ETL pipelines created in Informatica/Teradata/Bigdata from 2021 to 2023 Feb into IICS/GCP.

• ~2000 + Informatica PC workflows were migrated to IICS/GCP

• ~2 PB of data moved from Hadoop to GCP & ~100 TB data moved from Teradata to Big query

• Created multiple frameworks using IICS for various use cases

• Remediated BO/ Tableau reports to read from Big Query tables

• Data validation, Cutover planning and execution Cloud Platform & Production Support (Dec,2022 to Dec 2024)

• Oversaw Production support engagement (L1.5 & L2) for CDW batch jobs ( 7000 + jobs on 24/7)

Public

Managed below support engagements,

• GCP/Terraform platform support team to maintain the google cloud platform services on 24/7, and provided regular support for upgrade, patching, deployment support

• Big Query DBA support, 24/7

• IICS Admin support, 24.7

• DevOps – CI/CD support

TDA Data Integration – (Mar, 2022 to May,2024)

• Schwab’s acquisition of TDA, this includes huge scalability work and data integration

(Thinkpipes & iRebal data).

• Complete EDW & BDH were analyzed to identify the impacted objects & tables

• 2000+ data pipelines were tuned to process the increased data volume

• Converted 14.5 M accounts & 1.5T Assets, 1.3 M Trades.

• Migrated TDA Datawarehouse to Schwab’s Teradata DWH Other Key Projects managed,

• Talend to IICS Migration – Migration of 500 + Talend jobs to IDMC (Sep,2024 to Till date)

• Customer Interaction Depot – (Oct 2018 to Dec,2024) To translate customer behavior into intelligence to govern the customer experience. Implemented in bigdata

• Retirement Plan-401K – Analytics (Nov 2019 to Dec,2024) – Developed and maintained multiple Retirement Plan related use cases to integrate various source data into EDW/BDH & in CDW for reporting and downstream application feeds

• Party Master Data Management (Oct 2018 to Mar 2021) This program was to create single source of truth, to better customer retention, anti-money laundering, and to better serve customer. This MDM solution was implemented in SQL server using Informatica MDM

• USAA Integration (May 2019 to Mar 2021)

Schwab’s acquisition of USA. Converted 1.1 M accounts & 80B Assets, 0.1M Trades to Schwab

Wipro’s Information Management Practice, Chennai, India May-2015 to Oct -2018 Practice Delivery Manager

• Managed MDM programs for Wipro’s several large clients: Aviva, LBG Bank, UBS, Charles Schwab, Philips, Target Co, GSK, Optus-Australia,Hewlett-Packard, etc

• Designed and implemented many Customer MDM solutions for various customers like Aviva Insurance,LBG, Optus, Philips, HP

• Worked with the team to develop models as required, implemented data architecture platforms and solutions and data services

• Performed data profiling using IDQ to understand the data anomalies for Customer, Item, Location, Manufacturer and Supplier data.

• Done requirement gathering, Solution design for various MDM Hub implementations

• Designed the Search Strategy, Match rule sets,Match Columns for Match and Merge Process in improving data quality by match analysis

• With a focus on enterprise master data, established the framework for data quality, building trust and confidence in data assets

• Driving the solution design committee review to ensure all the technical solutions are adhered to the client’s standards

GART Program for Target Corp, MN, USA Jan -2013 To May-2015 Program Manager

Public

GATR One ofthe Largest Retailers (US Retailer),; Target Corporation was transforming the way it does business to meet the demands of a rapidly changing and increasingly competitive market. Customer has initiated a number of business initiatives such as expansion to Canada, newer store formats, strong focus in food andPharmacy. These initiatives have a direct impact on Target BIroadmap. Target has embarked on a Signature Program GATR -Global Acquisition ofTechnical Resources to outsource a portion of its development work within EIM. This is driven by the projected increase in development effort by 40%. GATR was a strategic initiative to develop a new BI execution channel to achieve faster and better delivery

I was responsible for :

• Played a Technical Program Manager role for Client Target Corp, USA.

• Responsible for end-to-end delivery ownership, Stakeholder Management and Operations for a large Outsourced Program to Wipro.

• All types of small, medium, large projects under Target EIM are grouped under this program.( Key projects are Implemented flexible fulfillment, Guest Contact Analytics,ETL Optimization, Coupons, Analytica DW enhancements, etc)

• Managed stakeholder’s expectations through defined Governance and communication framework. Responsible for Conducting Program/Projects progress reviews, manage delivery life cycle milestones and ensure mitigation of identified program and project level risks

• Responsible for Providing thought leadership and advisory services to customer in the areas of Business Intelligence; Data warehousing and Analytics subject areas

• Estimation, SOW creations and CR management for multiple projects under GATR program PARS Program for Target Corp, MN, USA Dec-2010 – Nov-2012 Technical Manager

PARS program is to Migrate the data from UDB/DB2 to Teradata and Datastage 7.5 to Datastage 8.5. All base lined data objects, Extract Transform Load (ETL) jobs and UNIXscripts will be migrated from UDB environment to Teradata. Need to Ensure consistent and accurate data & reports migration from

(Enterprise Business Intelligence) EBI (DB2) to EBI(Teradata) I was responsible for :

• Managed the delivery for Teradata data migration( ~5 TB data from DB2 to TD)

• Involved in designing the Architecture for EDW Teradata System

• Managed bulk Data migration from DB2 to Teradata through various Teradata utilities like Fastload, FastExport, MultiLoad & TPump.

• Involved in setting up application and environment

• Created and Managed project plan and delivery schedule for the applications under my are

• Prepared project implementation plan, roll-out activities by coordinating with different vendors teams

Project Simplify for Office Depot, FL, USA June-2008 – Dec-2010 Technical Lead

Project Simplify is a global initiative, of Office Depot to standardize business processes worldwide and to consolidate disparate systems across the corporation into a single global instance I was responsible for:

• New Datastage 8.0.1 environment setup for Client - Office Depo Client Public

• Installation of tool in new Linux Grid Environment and migration of jobs

• Coordinated with IBM for New environment setupand bug fixing

• Provide support to the developers for resolving the issues related to the tool

• Setup database connection configuration.

• Reviewing the new jobs and scripts and Worked With IBM to resolve the issues and bugs related to Data

EBS- Enterprise Business Solutions for Weyerhaeuser WA, USA April-2007 – May-2008 Technical Lead

Enterprise Business Solutions was the companywide effort to design and implement a demand-driven, standardized supply chain across Weyerhaeuser.

I was responsible for:

• Handled a Technical lead role for Client Weyerhaeuser for Enterprise Business Solutions program, company wide effort to design and implement a demand-driven, standardized supply chain across Weyerhaeuser.

• Participated in all the Business Process workshops to identify and understand the Business requirements, Involved in Requirements gathering &analysis and preparation of Business process mapping,

• Responsible for integration of all the business requirements with the technical architecture design during the design phase

• Involved in preparation of High-level design of the requirements and was responsible for end to end Implementation Activities

GODS- for Target, Corp, Chennai, India May-2004 – Mar-2007 Developer

The G-ODS project was to create Operational Datawarehouse in Tandem system I was responsible for:

• Worked as a Data Engineer for Client Target, Co

• Developed GODS – Data Warehouse application in Tandem system

• Developed ETL jobs using datastage PX to consolidate the customer information from various sources

• Developed C program with embedded SQL to load the data sent by ETL into TANDEM System. Also developed C program for merge process.

• Implemented all the projects in Production

Contact this candidate