Amarnath Reddy Veeramreddy ad2m39@r.postjobfree.com

Data Engineering Lead 919-***-****

Summary:

•16 years of expertise in Business Requirements Analysis, Data Integration, Cloud Migration, Data Warehousing, Business Intelligence, ETL, Dimensional Data Modeling, and On-Cloud Applications like Oracle On Demand (OOD).

•Proficient in designing, coding, developing, testing, and implementing data engineering solutions using a diverse toolset, consistently delivering comprehensive Data Integration solutions

•Extensive database experience with Oracle, DB2 UDB, MS SQL Server, Sybase, and MS Access.

•Proficient in database tools like Microgen Aptitude Studio (8 months) and Data Virtualization software Composite Studio (3 years).

•Extensive background working across Wealth Management, Banking, Finance, and Healthcare sectors.

•Skilled in translating user requirements into functional, technical specifications, and ETL mapping documents, with expertise in Dimensional Data Modeling and tools like Erwin.

•Strong Scripting skill on SQL & PL/SQL, UNIX shell scripting, and Python

•Successfully executed complex migration projects using AWS services such as the AWS Schema Conversion Tool for database schema conversions, AWS Snowball for secure data transfer, and AWS DataSync for efficient data synchronization, ensuring seamless transitions to the cloud while minimizing downtime and ensuring data integrity.

•Expert in production support, including change management, incident handling, and coordination in onsite-offshore structures. Demonstrated aptitude for understanding business processes, exceptional communication skills, and experience in quality reviews, audits, and process improvements.

•Responsible for producing High Level and Low Level Design document along with System Maintenance documents.

•Successfully managed cross-geographical teams, optimizing onsite-offshore collaboration for efficient task coordination between teams, resulting in enhanced productivity and project success.

•As a Team Lead, responsible for overseeing and managing code reviews, use case reviews, requirement document approvals, and test case processes, ensuring project alignment and quality assurance

Education:

•Master of Computer Applications (MCA), SVU Tirupati-India

Technical Summary:

ETL Tools

Informatica Power Center 10.4/10.2 Hot fix/9.6/9.5/9.1/8.6/8.5/8.1/7.1/7.0/6.2, Informatica Power Exchange, Microgen Aptitude, Informatica B2B 8.6, Informatica Data Explorer, Informatica Power Connect/STRIVA 5.2

Database

Oracle 12c/11g/10g/9i/8i/7i, IBM DB2 UDB 8.0/7.0, MS Access 97/2000,

MS SQL Server 2000/2005/2008/2012& Sybase 12/15, Denodo 7

Reporting Tools

Oracle BI 11g/10.1.3.3,SQL Server SSRSs

Data Modeling

Erwin 7.0/4.5/4.0, Toad Data Modeler 5.2 &MS VISIO 2007/2003/2000

Programming

SQL, T-SQL, PL/SQL, UNIX Shell Scripting, Perl, Windows Batch Scripting, C & C++,

Python Scripting

Scheduling Tools

Autosys, Tidal, Cron

Versioning Tools

Tortoise SVN, Git

Environment

Windows 7/2003/2000/XP/98, MS DOS 6.22, Sun Solaris 5.8/5.7, IBM AIX V5 R2 & Linux

Employer: BANK OF THE WEST 2018 – 2023

Data Engineering Lead

Responsibilities:

•Collaborated closely with subject matter experts (SMEs) to gather business requirements, performing

data analysis and to provide a comprehensive solution.

•Lead Development effort for Various key projects and delivered successful integration solution

•Design, develop, modify, test, prepare and support pre and post implementation activities on software solutions.

•Create effort estimates, detail technical design documents, functional and non-functional specifications documents.

•Provide Guidance to onsite and offshore development teams in technical implementation, prioritize deliverables and perform code reviews.

•Hands on with Data and Technology to resolve High priority Issues supporting BAU for multiple projects.

•Implemented Data Quality Controls for Regulatory requirement using inbuilt framework using Informatica DQ and Batch Framework.

•Collaborated with diverse business units within the bank, including Finance, Treasury, Regulatory Reporting, Risk, and Commercial Banking, on strategic data projects aimed at meeting customer and business requirements effectively.

•Created and updated Data models to include new data sources into central warehouse (EDR) & DataMart (FARM) using Star and snowflake modeling techniques using Erwin Data Modeler.

•Implemented Data Virtualization solution using Denodo to meet the integration requirement for Customer 360 initiative like SRS

•Generated Data Extracts for Loans, Leases, Securities through batch processing in various formats like CSV, JSON for Quarterly reporting.

•Extensively used Informatica Power Center, Unix, Batch Framework, Python across the Data integration projects.

•Worked with Production Support teams in job scheduling using Tidal and Batch Framework.

•Performed and documented Unit testing of ETL jobs and worked with QA and UAT teams to analyze/resolve any questions/issues related to the data.

•Experience in Agile and Agile/Hybrid methodology by providing extensive support to Product Owner and Scrum Master during Sprint Releases, Sprint Planning Meeting and Sprint Retrospective Meetings.

Employer: Wipro 2005 – 2017

Senior Technical Lead

Clients: Bank of the West, GlaxoSmithKline (GSK), Johnson & Johnson (JNJ), Walmart, Dun & Bradstreet (DNB)

Responsibilities:

•Responsible for Design, Development, Deployment and Implementation of ETL Architecture for multiple projects.

•Authored comprehensive technical design documents, data flow documents, ETL mapping documents, runbooks, and system maintenance documents, offering essential guidance to project teams for seamless execution and support.

•Worked with business analysts for gathering requirements and analyzed gaps between requirements and availability of data in Source Systems.

•Analyzed source feeds to understand the data, relationships between multiple feeds and to identify potential quality issues.

•Leveraged various tools and technologies, such as Informatica PowerCenter, SSIS, and Microgen Aptitude, to achieve successful project outcomes and develop data solutions.

•Experience working with data from wide range of sources such as Flat files, XML files, Microsoft SharePoint Lists, SQL Server and Oracle.

•Proficient in implementing performance techniques to achieve high optimization for ETL mappings, sessions, and database tables, enabling efficient handling of insertion and updating of multimillion records.

•Built reusable and automation components, to improve development team efficiency

•Created executive level Reports (Informational & Actionable) and Dashboards using OBIEE.

Contact this candidate