Summary
Overview
Work History
Education
Skills
Timeline
Generic

Harika Reddy Patlolla

Tampa,FL

Summary

IT professional with 5 years of experience specializing in Requirement Analysis, Data Analysis, Application Design, Data Modeling, and the implementation and testing of databases. Skilled in Data Warehousing/ETL using Ab Initio GDE and EME, as well as Informatica. Expertise includes reverse engineering applications in Java, SQL, and COBOL. Well-versed in the data warehouse lifecycle and familiar with Big Data technologies like Hive and Hadoop. Strong analytical, problem-solving, and communication skills for effective interaction at all organizational levels.

Overview

6
6
years of professional experience

Work History

ETL Data Engineer

CVS Pharmacy
05.2023 - 06.2024
  • Implemented triggers, packages, procedures, and scripts to enhance data extraction and migration processes.
  • Utilized PL/SQL programs and ETL jobs to effectively load SAP R3 systems data files into DataMart.
  • Performed in-depth analysis of migration data.
  • Demonstrated strong analytical skills by effectively implementing business requirements related to Unicode characters.
  • Optimized efficiency through the creation of packages along with related procedures, triggers, and functions.
  • Oversaw the development and growth of team members.
  • Directed team members in their assigned tasks.
  • Contributed to improved teamwork by logging team members' efforts and actively participating in code review.
  • Achieved efficient execution of debugging and code deployment tasks
  • Implemented advanced techniques in creating triggers, table schemas, and views

ETL Specialist

Capital One
07.2021 - 08.2022
  • Engineered a custom shell script that parses sql scripts to create Comprehensive data requisites.
  • Implemented a consistent approach to project planning and execution in alignment with the EDW objectives.
  • Created and enhanced shared graphs for efficient loading of tables including mailing addresses, phone numbers, etc., in a joint project.
  • Streamlined the process of loading consumer data into warehouse by developing 90 sets of psets, sqls, and xfrs.
  • Implemented a system of plan and shell scripts to efficiently load consumer application related data
  • Demonstrated leadership skills by successfully leading research activities and resolving data mapping issues as a Data Steward in the UAT region.
  • Produced extract specification documents, high-level design documentation, and implementation plans for data consumption.
  • Implemented a referential integrity check script in SQL.
  • Successfully executed the plan by creating and executing effective shell scripts for loading all consumer history and Applicant related data.
  • Analyzed various options to manage the historical Moody's ratings information through XML and flat files.
  • Implemented graphical models to facilitate the parsing and loading of XML data for Basel 2 initiative

ETL Specialist

Wipro Technologies
01.2020 - 06.2021
  • Implemented various techniques such as developing graphs in Ab initio using different components and utilizing PL/SQL packages to ensure efficient data integration.
  • Ensured accuracy and integrity of database by resolving data anomalies.
  • Streamlined Query optimization to align with customer needs.
  • Ensured efficient data transfer to multiple systems and testing teams.
  • Utilized GDE to build graphs with a range of components including Rollup, Scan, Db components, and normalize. Incorporated concepts of MFS and parallelism to ensure improved performance.
  • Optimizing the Testing process.
  • Streamlined the preparation and review of technical specifications.
  • Utilizing data analysis to drive strategic decision making and optimize outcomes.
  • Experienced in coordinating and optimizing project tasks and resource allocation..
  • Executed successful data conversion and migration projects, transitioning from previous systems to Oracle/Teradata.

ETL Consultant

Nike
07.2018 - 11.2019
  • Increased effectiveness of data transfer process by developing PL/SQL scripts.
  • Identified and rectified inconsistencies in the Database records
  • Ensured accountable data transfer.
  • Optimized database by ensuring thorough cleaning and organization of activity.
  • Completed successful ETL processes for migrating data from legacy systems to Datawarehouse through Abinitio.

Education

Master of Science - Computer Science

University of South Florida
Tampa, FL
05-2024

Bachelor of Technology - Computer Science And Engineering

MLR Institute of Technology
Hyderabad, India
06-2021

Skills

  • Data Warehousing
  • Data Modeling
  • Scripting Languages
  • Performance Tuning
  • Data Migration
  • SQL and Databases
  • Database Administration
  • Big data technologies
  • Interpersonal Skills
  • Software Development Lifecycle
  • Version control systems
  • UNIX Shell Scripting
  • Databases: Oracle, MongoDB
  • RDMS Development
  • Object-Oriented Programming
  • Project Management
  • Data synchronization
  • Agile development methodologies
  • Data Security
  • Data Validation
  • Problem-solving aptitude
  • Organizational Skills
  • Agile Methodology
  • Linux
  • Project Planning
  • Leadership and task delegation
  • Excellent Communication
  • Communication and Interpersonal Skills

Timeline

ETL Data Engineer

CVS Pharmacy
05.2023 - 06.2024

ETL Specialist

Capital One
07.2021 - 08.2022

ETL Specialist

Wipro Technologies
01.2020 - 06.2021

ETL Consultant

Nike
07.2018 - 11.2019

Master of Science - Computer Science

University of South Florida

Bachelor of Technology - Computer Science And Engineering

MLR Institute of Technology

Similar Profiles

CREATE PROFILE
Harika Reddy Patlolla