SUMMARY

Eighteen years of IT experience with strong Technical & Management skills. Experience as a tech lead and manager in managing development and support projects adhering to SDLC, CMM, ITIL and Agile processes. A self-motivated team player and leader with excellent communication, analytical and organizational skills with a result oriented approach. Extensive experience in Analysis, Design, Development, Testing, Implementation and Maintenance of ETL and Data Warehousing projects across difference business domains.

A key contributor who consistently seek to improve operational excellence and help provide cost effective solutions for company’s strategic goals. Ability to interact effectively with all levels of business leaders and application development teams.

EXPERIENCE SUMMARY

Successfully lead and managed Datawarehouse and ETL projects with onsite – offshore teams

Managed a DW ETL support team supporting 160+ ETL applications and supporting ETL infrastructure including 16 servers, 60 repositories and 20 cloud landscapes

Successfully managed development projects in Data Warehousing/Database Applications in Informatica, Talend, Snowflake Database, Teradata, Oracle, SQL Server, DB2, SAS, Mainframe, Unix adhering to SDLC and CMM processes

Project Management, Project Scheduling, Project Tracking and Team Management

Effective communication skills and experience coordinating and managing globally located teams

Delivered enhancements under stringent timelines and pressure

Managed projects with global implementation and evolving requirements

Maintain and build client relationships, able to comfortably converse with all facets in the client’s organization

Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences

Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing

Good understanding and implementation of ITIL concepts and CMM and Quality processes

TECHNICAL SKILLS

FUNCTIONAL

TECHNOLOGY

Certified ScrumMaster®

ITIL processes in support projects

S/W development life cycle methodologies

CMM and Quality processes

Retail Banking, Wholesale Banking

Travelers Cheques, Prepaid Cards & Networks

AML – Anti Money Laundering

Life Sciences & Pharma

Health Insurance Domain

Middleware Technology Support

Media & Marketing Automation

Campaign Management

Informatica, Informatica Cloud, Talend

Azure, AWS and GCP environment adoption

Snowflake Database, Teradata, Informatica, SSIS, Unix scripting, SQL/PLSQL, Mainframe, Cobol, SAS Reporting and Programming, Python

Unix Shell scripting, Mainframe technologies, IBM MQSeries, Python

Databases – Snowflake, Teradata, Oracle, Postgres, SQL Server, DB2, IMS DB, SAS DB

PROFESSIONAL EXPERIENCE

BCBS Horizon NJ (Cognizant) Apr 2020 – till date

Horizon Data Hub Data Warehouse Lead / Architect

Horizon Blue Cross Blue Shield of New Jersey, headquartered in Newark, New Jersey is a licensed Blue Cross and Blue Shield Association plan in New Jersey, providing health insurance coverage to over 3.2 million people throughout all of New Jersey. It is a not-for-profit health service corporation. Horizon Blue Cross Blue Shield of New Jersey is best known for their managed care and traditional indemnity plans for individuals and employers.

As a part of Data Hub project, a Data Warehouse application is maintained which houses key data like claims, membership and score data from various sources.

Hands-On Technical Project Manager. Leading the Data Hub Team – and playing a Project Manager / Data Warehouse Architect Roles

Architect, Design and Build ETL modules for the Data team in Informatica and multiple databases

Project Management duties include Managing Budget, resources, deliverables, scrum meetings and leadership reporting

Design data warehouse solutions to ingest varied data into the data hub application including dimensions and facts data. Design data pipelines from various types of applications and sources to handle a variety of data ingestion types like flat file sources, multi file sources, proprietary file sources, varied database sources like Teradata, Oracle, SQL Server. Prepare high level design documents and low level design documents that address data load designs, business logic, complex transformations, orchestration of job run schedules, Data, View and Stored Procedure structures, Data Archival design, Server maintenance designs, Production Support Standard operating procedure designs.

Build data pipelines and shell scripts for data loads into all the structured layers like Landing, Audit, Staging, Intermediate, Core, Semantic and Consumption layers. Physicalize data objects like databases, tables, and views and build data manipulation objects like stored procedures and BTeq scripts to load data into the Data hub. Implement required business transformation rules and logic using Informatica PowerCenter and/or PL/SQL, build exception handling, data standardization procedures and quality assurance controls.

Perform unit testing and collaborate with system integration testing teams and user acceptance testing teams to test functional, nonfunctional, performance requirements and ensure quality deliverables are deployed in development, system integration, user acceptance, pre production and production environments.

Perform production deployment activities in collaboration with business partners, development teams, data base admin teams, ETL admin teams and change & release managers and production support teams. Perform post production support activities to make sure first execution of jobs are successful and perform data checkout operations to ensure business partners conform to the data checkouts.

Perform data analysis in collaboration with business and downstream users to address data analysis, data validation use cases to help publish business requirement use cases which can be executed via project work requests.

Technologies used include Informatica, IICS for some cloud migration initiatives, Teradata, Scheduling tools, aws for hosting

Perform data profiling activities in collaboration with business analyst teams to elucidate requirement analysis and transformations logic in sttm or source to target mappings for various data layers in the Data Hub including Landing, Core, and Semantic layers of the data warehouse.

Comcast NBCUniversal (Cognizant) June 2018 – Mar 2020

NBCUniversal Analytics CoE, Data Warehouse Lead / Architect

NBCUniversal’s Analytics Centre of Excellence manages and establishes the roadmap for Analytics adoption in the organization including tool selection, installation, establish maintenance frameworks, and help Analytics adoption in the organization. As a part of ETL standardization Talend platform was chosen as the preferred ETL platform. Snowflake database was chosen as the preferred database. These are to be implemented on Azure and AWS environments. Analytics CoE handles infrastructure, tool adoption (talend / snowflake / Azure etc.) and implementation, communications to the business and technology audience, developing and cascading standards and best practices.

As a part of talend platform rollout, installation of talend was taken care. Standards and best practices were developed. Ingestion frameworks were developed. Build frameworks like data quality rules frameworks, stg load frameworks, dbo load frameworks, audit & archival frameworks, were developed which are available to be adopted by various application business and technology teams to ease the talend conversion and adoption process. As a part of the roadmap there are 25-30 applications that are identified to move to the new landscape in the next couple of years.

Hands On Project Manager and Data Warehouse Solution Architect

Architect Cloud Migration Framework for NBCU Comcast with Talend / Snowflake Cloud Framework

Build ETL pipelines in Talend and Snowflake for Analytics CoE

Build reusable talend frameworks in talend for various source ingestions including API sources, google sheets, s3, and azure blob sources along with traditional sources like ftp, database, and cloud and on premise sources. Reusable frameworks are built to be used by multiple application teams to easily integrate in the corresponding ETLs.

Build reusable talend frameworks for stg layer loads and dbo layer loads. These frameworks are built to be reused by multiple application teams across Analytics CoE landscape

Reusable audit frameworks that handles file validations, ETL load validations etc.

ETL Architecture and Design for two major application migrations which have close to 100 master jobs and 500 Snowflake tables

ETL Architect, design, build, test and deploy ETL applications in film, sports and home entertainment applications that source data from multiple sources and load the corresponding data marts

Main tech used are Informatica, IICS, Talend, AWS, Azure, GCP, Databricks, Snowflake,

New York Times (Cognizant) May 2016 – June 2018

New York Times–Marketing Technology, Data Warehouse Lead / Architect

Marketing Technology in New York Times consists of a number of applications that help Marketers segment, create programs and campaigns and reach out to the target marketable populations based on complex business needs. There are close to 200 different campaigns that are managed in the Marketing system.

The main applications that are involved as a part of the Marketing suite include Customer Marketing Data Mart (CMDM), Automated Intelligent Marketing Suite (AIMS), Marketing Operational Data Store (MODS), SAS Campaign Management Tools, SAS Visual Analytics (SAS VA). The Data Marts and Data Stores form the hub of the whole Marketing Suite, which drives segmentation, targeting and preparing a shippable files to the vendors. The Data Marts are sourced from various applications like Aristo, Plato, Regimart, Sugar, CIL, Sublink, DDW, and DSc among other applications. An ETL solution comprising of appx 100 jobs make sure that the correct rules are applied to the various source systems and data is loaded into the Data repositories. Campaign Applications and other consumers of the data will now access the data and create the list files which are sent to various vendors like Allant, Merkel, and Experian etc.

Hands On ETL Project Manager leading a strong offshore and onsite team of ETL engineers, Report Engineers and Marketing team

Build a new Marketing ODS called MODS from ground up

Informatica 10 on AWS Linux servers with PostgreSQL with Amazon RDS

Worked on aws and gcp environments to integrate source data from various sources

Performed data architecture for the MODS application

Conceptual, Logical and Physical Data Modeling

ETL Architecture and Design for MODS application with 3 TB of data ( 200 workflows approximately)

Build, Integration & Test – 200 workflows with 100+ user acceptance scenarios

Led a 10 member team(onsite & offshore) -Architecture, Design, Build, Integration, UAT & Support phases

Adept in agile implementations and certified scrum master

Sanofi Aventis(Cognizant) July 2015 – May 2016

Sanofi Quantum Workday MDM DSS Integration Discovery, Project Manager / ETL Lead

Quantum DSS (Quantum Decision Support System) is a Sales & Marketing custom built Data Warehouse. Quantum DSS supports Analysis & Reporting activities thereby delivering capabilities to home office and field personnel. Data is provided by various vendors to Quantum DSS where it will then be processed and loaded into the system via various interfaces. As a part of the Workday integration project, a new workday source was integrated into Quantum. As a part of the MDM DSS Integration Discovery project, functional analysis was done on all the Quantum processes that involve HCA and HCP data. The discovery exercise is to pioneer the planning and execution of the actual MDM DSS integration that is planned for 2016.

Project Manager / Technology Lead with the Quantum team taking care of both Data Hub and MDM project teams

Manage a team with onsite and offshore presence. Project Management activities include managing, forecasting and tracking the project. Taking care of end to end project delivery and weekly project status reporting to management.

Requirement Elicitation and Sizing, Project Plan, Schedule tracking and Forecasting, Resource Management, Project reporting.

Manage Change and Problem management for the ETL applications

ETL Application enhancements & Release Management. Executing development enhancements using minor enhancement capacity and executing major enhancements using SoW capacity.

Technology Lead Activities include design and build, design and build review, create and review test plan, scenarios, UAT, Deployment & Support Transition

Walt Disney Parks & Resorts(Cognizant) Oct 2014 – July 2015

WDPR Managed Services–Information Management, Project Manager / Technology Lead

WDPR MS IM is a Managed Services portfolio in the Walt Disney Parks & Resorts – Information Management tower. The Information Management tower consist of four broad areas called clusters which include Data Integration, Business Intelligence, Master Data Management and Content Management. The Data Integration cluster consists of the Informatica, Data Stage and Python technologies apart from scheduling tools. The Business Intelligence tower mainly comprise of Business Objects and Cognos technologies. The applications being managed are D3, ATSR, SMART, GABE and BO.

Project Manager / Technology Lead with the WDPR MS IM tower

Manage a 20 member strong team with onsite and offshore presence

Handle 24 x 7 production support for the ETL and BO support applications with a 20 member team

Incident and Service Request Management handling 20 % Priority 1 and 50% Priority 2 tickets with 2 hours and 4 hours SLA

Change and Problem management for the ETL and BO applications

Planning for Knowledge Transition, Scheduling Knowledge Acquisition, Shadow, Share, Lead and Steady State Phases

Knowledge Transition score card for each phase of the transition successfully completed

Adapted best practices during the Knowledge Transition viz. Knowledge Acquisition Tracker, ITIL trainings, Tool Identification and Adaption for tools like Platinum, Metadata Manager, Productivity Improvement Levers Identification like L1.5 team, performance tuning

ITIL process adaption in project life cycles

Manage small and medium project enhancements

Manage process orientation and implementing best practices in different projects in the unit

Worked on Application and performance tuning, data migrations and production maintenance activities

Handle the Knowledge Transition of appx 500 Informatica and Python jobs across multiple subject areas and job streams

Merck(Cognizant) Sept 2012 – Sept 2014

AMS,Application Management Services, Data Warehouse Application Service Manager, ETL Operations

AMS – Application Management Services Project is an integrated service delivery model for maintaining the operations at EIM organization at Merck. It is a unified platform for delivering services with the defined, standardized, and ITIL complaint processes. Application Support roles and responsibilities include the following

DW ETL Application Service Manager / Lead with the EIM AMS unit

First escalation point at for the North America DW ETL Support team

Manage & Lead a 20 member team supporting DW ETL Application portfolio consisting of 160+ applications across 3 regions ( Americas, EMEA, APAC) and multiple divisions

Manage the Informatica Infrastructure consisting of 16 servers, 60 repositories and 20 cloud landscapes

DW ETL Application Contract Management. Taking care of the full life cycle of ETL applications. Including Application onboarding, maintenance, metering and off boarding.

Managing the day to day activities of the team including Incident Management, Request Management, Change Management, Problem Management, Configuration Management, Release Management, Knowledge Management and Capacity Management.

ETL Application enhancements & Release Management. Executing development enhancements using minor enhancement capacity and executing major enhancements using SoW capacity.

Establishing end to end DW ETL support services, service models.

Pioneer a new process, methodology, and set of deliverables called STI ( Service Transition & Introduction) in AMS to align to SDLC, ITIL that prepares IT for production support

Managing the day to day activities of the team shown below

Account & Administration, User Management for ETL tools Such as Informatica 9x, Informatica, UNIX scripts.

Facilitating and coordinating work with client, third party vendor application teams, and offshore team.

Requirement gathering, analysis and design of all ETL work related to the project.

Perform Incident Management and Problem Management and collaborate with the customer team as required for the resolution.

Perform Incident Management and Problem Management

Maintain Authorized User Documentation and training of Customer Help Desk support.

Provide Authorized User support for routine queries (i.e. how-tos) not addressed by the Help Desk, and other activities as necessary to troubleshoot and resolve Incidents and Problems.

Perform error correction and preventative maintenance

Perform production control, scheduling and operations support

Develop necessary modifications and updates to support compliance with legal and regulatory requirements or other industry changes

Conform to Customer application development standards and recommend changes, where appropriate, to further optimize or promote maturity within the Applications.

Develop, modify and/or enhance Customer quality assurance processes to ensure quality and reliability of modifications or Enhancements injected into the portfolio.

Develop a mechanism for measuring productivity and report regularly to Customer; this should include recommendations for Enhancements to optimize the Application footprint and impact on Infrastructure resources

Perform a semi-annual test of disaster recovery plan in conjunction with Customer’s overall disaster recovery IT plans.

Collaborate with Customer team as required for resolution of Problems and Incidents

Merrill Lynch Bank of America June 2010 – Sept 2012

AML FIU / Anti Money Laundering Unit, Project Manager / Technology Lead

Anti Money Laundering is a division in Merrill Lynch Bank of America that deals with development, maintenance and administration of the AML program. The AML program includes practical, risk-based strategies designed to comply with applicable laws to prevent the company’s products from being used for money laundering, terrorist financing, and financial crime. The AML program is put into practice by the use of various tools and products which are a mix of in-house built and third party tools customized to meet the business needs.

Technology Lead / Project Manager with the AML / FIU unit.

Manage a 15 member strong team with onsite and offshore presence

Manage small and medium project enhancements.

Project management activities include Requirement Elicitation and Sizing, Project Plan, Schedule tracking and Forecasting, Resource Management, Project reporting.

Worked on SDLC life cycles and have rolled out some project using agile methodology.

Manage process orientation and implementing best practices in different projects in the unit

Closely work with the client to implement technology solutions while meeting business goals and timelines.

Technology Lead Activities include design and build, design and build review

Participate in full SDLC life cycle from requirement and design to development and deployment

Have demonstrated good knowledge of SDLC implementations in project life cycles.

Work extensively on Teradata on Unix and Mainframe platforms in Data Warehouse ETL environments.

Worked on Application and performance tuning, data migrations and production maintenance activities.

Bank of America Jan 2009 – May 2010

BoA ECRIS Program, Technology Lead

ECRIS program is an enterprise credit risk program which manages enterprise level credit risk oversight, and reporting, establishing credit risk management policies and standards, providing forward-looking analytics about the company’s credit portfolios, as well as monitoring and reporting of systemic risk issues

Worked as a project lead in ECRIS portfolio.

Managed teams with more than 10 resources in development projects.

Worked in ETL projects with Data warehousing environments

Very strong technologies implementations in Teradata, Mainframe, Unix

Managed projects driving the delivery in all SDLC cycles.

Implemented projects while making sure that the quality processes are implemented

American Express, Phoenix Jun 2007-Dec 2008

Communication Utilities Program, Technology Lead and Project Manager

Communication Utilities is an enterprise program which takes care of the outgoing communications of the consumer cards department in American Express. The communications taken care included messages, emails and letters. The system would take care of catering to different business units and had complexities of managing different email templates, paper templates, sources etc. CU or Communication Utilities, being the enterprise program has to deliver to a variety of business units meeting the demand for varied and different kinds of outgoing communication needs.

Worked on all the SDLC life cycles including Analysis and Design, Build, Deploy and Implement the Solution, Support and Enhancements

Project Management activities. Used clarity to manage, forecast and track the project. Project management activities include taking care of end to end project delivery and weekly project status reporting to management.

Participate in design and design review, build review, enforce best practices and standards across the project, uat and deployment.

Technologies include Mainframe, JCL, COBOL, DB2, SAS, SQL Server, Shell scripting

American Express, Salt Lake City April 2004 – June 2007

Travelers Cheques and Prepaid Services (TCPS), Programmer / Module Lead

TCPS group possesses a set of 73+ applications which supports travel related cheque products, processing sales and settlement, inventory management, sales tracking, accounting and marketing information of various Travel related products.

Mainframe migration project involves migrating all the TC Legacy applications from SLC environment to Phoenix environment to enables a much speeder (8 hrs) disaster recovery process. This involves changing around 130,000+ components according to the target environment standards, which involved extensive research to resolve the environmental issues.

Worked as mainframe developer.

Roles include requirement gathering, comprehensive study of both source and Target Systems, developing the data mapping rules

Developing design document and build activities

Technologies used include OS/390 IBM Mainframe, COBOL, JCL, DB2, IMS DB, IMS DC, XPEDITER, FILE-AID

EDUCATION

Bachelor of Technology (Computer Science & Engineering)

- Jawaharlal Nehru Technological University, Hyderabad, India

Contact this candidate