Post Job Free

Resume

Sign in

ETL Technical Lead

Location:
United States
Posted:
August 26, 2016

Contact this candidate

Resume:

NAGA SRAVAN KUMAR TATA

+91-996-***-****

+1-602-***-****

acwcly@r.postjobfree.com

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