Prasad Katru

Project 1 : Point32 Health (BI & EDW) Client : Harvard Pilgrim & Tufts Health Group, US

Organization : NTT Data

Role : Team Lead & Production Support

Tools : Datastage, Teradata, Linux/Python, AWS, Snowflake

Period : Feb 2022 to Sep 2024

Project Description:

Point32health is the health service provider by the combination of Harvard Pilgrim and Tufts vendors. BI&EDW project is to manage the reporting with the goal of making better business decisions than their competitors about the business departments of Clinical, Care Management and Financial. BI turns the massive amount of Member, customer, product, provider, broker, Accounts & Receivable, behavioral & pharmacy claims data from various operational systems into the format that is easy to understand about the current and long-term trends of the business. All these functionalities helps to take instantly alerted opportunities against to the problems and to receive the continuous feedback on the effectiveness of the decisions to the daily ongoing business.

• Accountabilities:
• Being as a team leader to setup clear expectations, defining the roles and responsibilities for creating productive team environment.
• Facilitating the effective communication and making collaboration among the team members including resolving if any conflicts or issues with technical assistance.
• Collaborating with leadership team, stakeholders, business users, developers, admin teams to provide solution to the failures or issues and to do process improvement.
• Developed Datastage jobs for new and enhancements requirements with AWS Services for Teradata Cloud Migration, Salesforce to club Harvardpilgrim and Tufts vendors data.
• Working on Snowflake to develop and load Tufts vendor Transactions and profiles data into the SCD tables.
• Involved in to develop on Python scripts for Autosys JIL Cards auto cloning and Basic test requests run automation.
• Coordinating with the team for troubleshooting complex issues, preparation & execution of the infrastructure outages plan, analyzing the incidents with respect to permanent fixes for timely effective resolution.
• Maintenance and performance optimization of the ETL applications to implement the enhancements or optimizations as needed.
• Responsible for monitoring, establishing monitoring mechanisms about performance to keep inform leadership team about the status & health of the ETL environment.
• Motivating team to do Automation activities, guiding and track to build expected Automation code.
• Involved in providing training and mentoring to the team to fill the knowledge gap and skills.
• Preparing and review MMR (Monthly Metric Report) report to showcase number of efforts spent by team with respect to number of team members efforts.

Project 2 : Global Exposure Solutions (GES)

Client : AIG Insurance, US

Organization : Cognizant

Role : Production Support Lead

Tools : Datastage (11.7), Oracle (SQL/PLSQL), Linux, Autosys Period : November 2020 to Jan 2022.

Project Description:

AIG is an American multinational finance and insurance corporation. The product GES of AIG is used to calculate the potential loss for the particular property. Based on the property geographical location details application gives the inputs like risks to the particular property with various peril types, to decide the coverage values and premium rates. Also, it helps to identify the Geocode and Risk Accumulation modeling results for the bound/unbound policies, portfolio rollups for the executive Management, Board of Directors, reinsurance partners. So, this GES data warehouse module helps for decide possible losses to the properties by various perils and coverage premium rates, limit values.

Accountabilities:

• Playing role of ETL Lead with strong technical background in ETL processes, data integration and related technologies.
• Assist to customers and business users for their queries and Ad-hoc requests.
• Working on problem tickets to give permanent solutions to the re-occurring issues.
• Involving in monthly development and deployment releases for modifications or enhancements.
• Working with Linux scripts for application support and developing or making changes to the existing scripts as per the requirement.
• Working on enhancements and doing code reviews of the newly developed code to test deployment.
• Involved In analysis of job performance issues to find out the root cause and work around solutions.
• Extensively used Autosys scheduler tool for monitoring the jobs and to deploy the new jobs.
• Worked on the DevOPs tools Github & Jenkins to deploy the code and manage the versions control.
• Monitoring of daily and weekly jobs and fixing if any failures at run time to finish batch loads.
• Mentoring and assisting to team by involving in the technical discussions and issues analysis.

Project 3 : California Consumer Privacy Act Client : Fossil Group Inc, US

Organization : Cognizant

Role : Senior ETL Developer

Tools : Datastage (11.7), Netezza, Linux Period : September 2019 to October 2020

Project Description:

Fossil Group is a fashion designer and manufacturer company in USA. The California Consumer Privacy Act (CCPA) is a state statute intended to enhance privacy rights and consumer protection for the residents of California, United States. This CCPA act helps to the customer to know about what data is being collected, weather the personal data sold or disclosed to any outside vendors and to say don’t sale the personal data of consumer by the business teams.

Accountabilities:

• Understand business requirements from the user stories and customer calls.
• Prepared TDD documents for technical design illustration and reviewed with the onsite coordinator and customer.
• Using Datastage Designer for extracting, cleansing, transforming the data to develop jobs for CCPA accomplishment.
• Extracting customer behavioral and personal data from AWS S3 buckets to load data into customer data consent and sales analytics target tables.
• Performed unit testing for developed jobs to ensure that meets the requirements.
• Written Linux shell scripts to cleanse, validating the source file and to schedule the jobs.
• Worked on impact analysis for enhancements and ad-hoc requests by the business requirements.

• Project 4 : Consumer Value Solutions – CVS Client : Vodacom, DR Congo
• Organization: : Emagine/Comviva
• Role : ETL Senior Tech Support
• Tools : Talend (6.1), Oracle 11g, Python 3.0
• Period : July 2017 to August 2019
• Project Description:
• Comviva is a Telecom domain product based BI software services Company. In this Customer Value Solutions (CVS) is a Comviva's data warehouse ETL model for mobile telecommunications operators by covering business Intelligence requirements and Data Analytics. This application helps to business people to understand customer’s usage patterns, launching best campaigns to target new customers and constantly monitoring behavioral changes of customers in usage. So, all these notes helps to improve business profit and revenue according to market trends and against to the competitors.
• Accountabilities:
• Monitoring of daily, weekly and monthly Talend jobs and fixing if any failures at run time.
• Involved in the Talend jobs and Oracle SQL queries performance tunings.
• Created Source to Target mapping documents for Fact and Dimension tables load as part of enhancement development.
• Developed the Talend jobs for the Telecom real time business and Data Warehouse based on the business requirements.
• Performed unit & SIT testing for the developed jobs to ensure that meets the requirements.
• Extensively used TAC to create tasks, execution plans, deploy, scheduling and monitor the Talend jobs.
• Mentoring and assisting to the team technically, functionally about ETL framework & Telecom products.
• Worked on the campaign design, development based on the new business plans and offers

Project 5 : GMF Goldrush – FDW

Client : General Motors Financial, UK

Organization: : DXC Technology

Role : Production Support/ ETL Developer

Tools : Datastage (9.1), Oracle 11g, Linux

Period : August 2015 to July 2017

Project Description:

General Motors Financial Company is a financial service of General Motors, it is named as Goldrush application. This company is a global provider of auto finance, with operations in the United States. The company provides retail, commercial loans and lease programs through auto dealers for the customers. The GMF IO Business Intelligence (BI) program supports both the Commercial and Retail operations by encompasses a Financial Data Warehouse (FDW) with Retail & Commercial Data Marts. These data marts provide the information about Floor Plan, Dealer Risk Ratings and Vehicles to understand the dealer’s performance for providing the credit facilities, identifying the risk dealers and getting the information of vehicles sales and transaction details.

Accountabilities:

• Developing new cluster requirements jobs with the given specification document, testing and deploying into the UAT and PROD systems.
• Implemented parallel extender jobs for better performance using stages like Join, Merge, Sort and Lookup, transformer with different sources flat files, complex flat files and XML files.
• Involving in history data load and incremental data load for the newly developed jobs.
• Loading Commercial, Retail data marts daily and monthly manually or using the Autosys scheduler.
• Troubleshooting of production issues like data inconsistency, system configuration issues, performance tuning and enhancements.
• Working on Linux scripts and configurations to understand system design and making changes if needed to them.

Project 6 : ALLY-Anti Money Laundering (AML)

Client : ALLY Bank, US

Organization: : DXC Technology

Role : ETL Developer

Tools : Datastage (8.7), Teradata (13.0), Unix

Period : Jan 2013 to July 2015

Project Description:

The ALLY-AML (Anti Money Laundering) is an automated system to analyze all the relevant transactions and generates alerts for suspicious activities and to report suspicious activities to the Federal Authorities. The Federal Regulators have indicated that Ally Bank must report on all the activities which could lead to money laundering or terrorist activities by all the auto transactions and deposits. AML will maintain product coverage supporting their ability to detect, investigate and report suspicious activities.

• Accountabilities:
• Involved in the understanding of business processes and requirements to develop the system.
• Designing and development of the ETL Parallel jobs depends on the source to target mapping document and specifications.
• Splitting the Datastage jobs into subsets to handle bulk data by dynamically distribute to all available processors to achieve the best job performance.
• Developed job sequencers with proper job dependencies, job control stages and triggers.
• Prepared Unit test cases and tested the jobs according to test cases in SIT/UAT testing.
• Documented ETL designs, test cases, test scripts and validations based on design specifications for unit testing, system testing, functional testing.
• Project 7 : MCBC - Enterprise Information Warehouse (EIW) Client : Miller Coors Brewing Company (MCBC), US
• Organization: : DXC Technology

Role : ETL Production Support

Tools : Oracle (SQL/PLSQL), Unix, Autosys

Period : June 2011 to Dec 2012 Project Description:

Miller Coors is a joint venture between SAB Miller and Molson Coors beers brewing Companies. The joint venture has the responsibility of selling beer brands such as Miller Lite, Miller High Life, Miller Genuine Draft, Coors, Coors Light, Molson Canadian and Blue Moon in the United States. Information Warehouse (IW) is the Data Warehouse stream in the Miller Coors project and designed for the analysis of separate and combinational business results for SAB Miller and Molson Coors. Oracle, SQL, Flat Files, Web methods Interfaces and Tapes are the various types of data sources for Miller Coors. So, the business can analyze the business in various aspects like sales, quantity, quality, profit, revenue etc…

• Accountabilities:
• Monitoring of Autosys daily, weekly and monthly jobs and fixing those if any failures at run time by following SLA timelines.
• Opening the problem tickets for regular job failures and fixing them permanently through the problem ticket procedure.
• Applying the enhancements to the application through the Change Request process with Change Advisory Board (CAB) approvals.
• Extensively used the Zeke scheduler tools for the automation of scheduling jobs on daily, weekly and monthly basis with proper conditional and dependencies jobs.
• Involved in the infrastructure migration and applications testing.