Ashok Kumar Reddy Patel

Senior Software Engineer

Tata Consultancy Services•  March 2014 - January 2021

Citi Banamex México City, México Data Scientist & ETL Specialist February 2019 - January 2021 ● Collaborated with Citi Banamex to obtain, analyze and estimate business requirements ● Built ETL batch applications to load transaction activity data into Database/Data-warehouse after transformation of data gathered from different sources for reporting purpose ● Created Dashboards using Tableau to understand the business by fetching the data from Data-warehouse and other files ● Built Regression models to forecast the business using Python and R ● Designed and built Ab Initio continuous flow applications by extracting data from external servers via TCP networks, Web-sphere MQ queue or topic and other servers and transformed collected data to run payment services of bank ● Developed Python programs and Shell scripts embedded with SQL to automate supporting activities in different environments ● Scheduled applications to run in different environments by using Autosys scheduling tool ● Provided SQL and PL/SQL queries to create new database objects such as tables, views, indexes, sequences, triggers, stored procedures & functions, and to fetch data based on client requirements ● Identified root cause and provided fix for incidents raised in production for Managers Checks and Payroll applications of Citi Banamex ● Raised INCs, Tickets and Change Requests as part of code deployment in ServiceNow ● Developed Jenkins libraries using Groovy scripts and Python to build and deploy applications all the way to Production environment ● Documented project requirements and outcomes for every application ● Coordinated with different application teams to maintain smooth production process for Bank Payment services ● Managed switching activity between Prod and COB to avoid service breach due to issues with Production servers ● Led On-Site BAU team with size of 7 to monitor applications CITI Bank NA Guadalajara, Mexico Sr. Data Analyst & QA Lead December 2017 - January 2019 ● Gathered business requirements and identified business rules of different BAU and KYC Business Intelligence applications for CITI Bank North America ● Reviewed and validated ETL applications which are developed by using Ab Initio in CARDS domain o To extract the data from different file formats to transform and load into Teradata EDW tables for onboarding the new partners like Jelly/LLbean into CITI systems o To provide Customer information to the CITI KYC team as per the requirement by using the sources like CRS (Citi Retail Services) and BRANDS by using the applications like CMR (Customer Management Repository) and DQIP (Data Quality Integration Platform) ● Developed Python programs and Shell scripts embedded with SQL and HQL to validate the test data ● Validated the Talend code developed for database migration projects ● Ingested data from Teradata EDW tables to HDFS, Hive tables in EAP server to create standardised and Outlier hive tables as part of Migration project ● Created Visualization reports and dashboards in Tableau to know the customers behavior ● Monitored Autosys jobs in different environments to make sure of smooth business with help shell scripting. ● Devised Control scripts to schedule applications to run in different environments Resolved production issues in real time ● Carried out research activities to improve performance of applications worth of 65000 USD ● Led Offshore team for creating test plan and test scripts based on project requirements ● Mentored a team of 6 junior associates to train technically and professionally CITI Bank NA Hyderabad, India Data Analyst & ETL Developer March 2014 - November 2017 ● Examined business requirements from Citi Bank North America to design applications for one of the Business Intelligence teams ● Led a module consist of 6 associates to distribute and ensure the work completion in time ● Extracted data from Mainframe files, SAS Datasets, Different RDBMS tables and flat files to construct applications with help of ETL tools to cleanse, transform and Load into Data-warehouse ● Enhanced the existing graphs and created onetime processes as part of AML projects for G2C changes ● Created and deployed Ab Initio Tags from Dev server into testing and Production servers with help of ServiceNow ● Devised Control scripts to schedule applications to run in different environments ● Coordinated with Production support teams to deploy the developed applications in production ● Analysed, identified the root cause, and provided fix for incidents raised in production ● Carried out research activities to improve performance of applications worth of 24000 USD ● Conducted Knowledge transfer sessions on project to new teammates and mentored junior associates to train technically and professionally