VENKATA NAVEEN KUMAR REDDY MARELLA

PROJECT #2 DETAILS:

Client : GEHC (GE Health Care)

Role : Data Engineer (HVR & NIFI Developer& Python & Appflow)

Roles and Responsibilities:

• Design and implementation of data replication strategies using HVR
• Setting up Full loads , Incremental loads and Flat File loads using HVR Refresh and HVR Initialize option's
• Setting up batch loads using HVR Restrict Refresh conditions
• ·Creating HVR channels and configuring respective actions for HVR replication.
• · Scheduling HVR Jobs and Monitoring Jobs
• Writing sql queries for data validations
• Monitoring HVR HUB database and its Database Alert logs
• Knowledge on · Exporting/Importing HVR channels.
• Extensively worked on query based ingestion using HVR Agent Plugin Action with Python scripts
• Knowledge on API based data ingestion
• Writing python scripts to extract data via applications API and loading into S3 bucket and Redshift.
• Knowledge on using pandas library for Data Transformations
• Worked on Creating tables in target and applying table collation
• Creating Source and Target Connections for data replication in HVR.
• Knowledge on HVR Refresh
• Extensively Involved in creating NIFI Flows
• Starting, Scheduling and Stopping the NIFI Job flows.
• Using spark scala scripts to extract the data and loading in S3 bucket
• Involved in Data ingestion using NIFI & Python Scripts

Project #1 DETAILS

Client : Marsh

Role : DB Admin (Planview and Sass based tools)

Roles and responsibilities :

• Creating users and adding roles with required privileges
• Extremely worked on data loads using SOAP UI XML Scripts
• Worked on creation of xml scripts those supports WSDL Ur's'
• Writing Sql queries and building tile reports
• Worked on building Power BI Plain Dashboards and scheduling in Power BI Premium workspace
• Participated in One to one client calls for understanding on business requriments