ETL Technical Lead
Resume:
NAGA SRAVAN KUMAR TATA
******.****@*****.***
https://www.linkedin.com/in/sravan-tata-5a08028b
Technical Lead
Innovative software engineer offering over seven years of hands-on DW-BI professional experience in full software development lifecycle – from concept through delivery of next-generation applications and customizable solutions.
Expert in advanced development methodologies, tools and processes contributing to requirement analysis, design, development, testing and rollout of cutting-edge software applications for Internet card payments and banking domains.
Known for excellent troubleshooting skills – able to analyze code and engineer well-researched, cost-effective and responsive solutions.
Technical Tools
Ab-Initio 3.1.7.3, Talend, Teradata-13, Oracle, PL/SQL, Unix Shell Scripting, Basic Java, C,C++ Hive Scripting, Harvest - Software Configuration management, CA – Autosys (Job Information Language) and more..
Professional Experience
Project : CMIT/Cornerstone
Client : American Express
Duration : 18 months (Onshore – client location)
Role : Technology Lead
Requirement to support process to receive transactions data from multiple sources and load into hive tables for client usage. As part of this project, data needs to be massaged as per requirement for internal framework and create optimized and standardized metadata.
Project : CMLS-ETL
Client : Visa Inc.
Duration : 8 months
Role : Technology Analyst (acting lead)
Requirement to create ETL process to collect merchants and respective online transactions data from several sources and populate ORMB tables with single version of truth. Project also includes maintenance of the ETL process using “Web services”.
Project : ACAPS ETL Maintenance
Client : Wells Fargo
Duration : 12 months (client location)
Role : Technology Analyst
Requirement was to modify, maintain and support Automated Credit Application Processing System (ACAPS). ACAPS is the “System of Records” for the Consumer Loan Origination process which tracks the installment loans or line of credits from the moment it is entered into ACAPS through boarding and disbursement of proceeds.
Project : SHAW ETL Optimization
Client : Wells Fargo
Duration : 8 months (client location)
Role : Technology Analyst
Requirement was to redesign SHAW-IDS application by discussing with business users on their needs. The application deals with consumer’s installment loans or line of credits data, provided as a package from Shaw Systems Associates.
Project : Mortgage Integration Development Environment (MIDE)
Client : Wells Fargo
Duration : 10 months (client location) + 18 months
Role : Technology Analyst & Senior Systems Engineer
Requirements
a. To provide details of customers and mortgage loans to ETL application (MIDE - Sourcing).
b. To collect and transform mortgage loans and customer details for industry standardization.
c. To optimize existing ETL process to complete data collection & integration in SLA time.
d. To designed the process to pull demand / time deposit and daily transactions data from Hogan Integrated Deposits System for Infobank users.
Project : STOC ETL (Systematic Tracking of Collateral)
Client : Wachovia
Duration : 8 months
Role : Systems Engineer
Requirement was to develop ETL application for STOC (Systematic Tracking of Collateral) application which generates alerts on loan facilities by monitoring securities held as collateral.
Education
Bachelor degree in Computer Science and Engineering from Koneru Lakshmaiah University, affiliated / under Acharya Nagarjuna University, Vijayawada, Andhra Pradesh, India.
Contact this candidate