Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vishnu Priya Konduru

Toronto,Canada

Summary

Senior Software Engineer with 8 years of extensive experience, specializing in SQL, Oracle Data Integrator, Analytics, and Reporting. Demonstrated success in performance tuning and executing complex project implementations. Strong problem-solving skills and ability to collaborate effectively with teams to deliver high-quality solutions on time. Proficient in data modeling and creating technical documentation.

Overview

8
8
years of professional experience

Work History

Sr. Consultant

Capgemini Technologies Pvt Ltd
04.2022 - Current
  • Implemented CDC mechanism to enhance data extraction processes using ODI 12C.
  • Supported hypercare during production to ensure seamless transitions.
  • Resolved P-1 priority problem tickets, delivering solutions within established timeframes.
  • Performed performance tuning for SQL queries, utilizing gather stats methods.
  • Developed stored procedures in ODI to automate data processing tasks.
  • Contributed to KSA eInvoice phase 2 project implementation, ensuring compliance.
  • Created documentation for various payloads and IM090 documents to maintain clarity.
  • Facilitated deployments across different environments, including production and testing.

Package Specialist ODI

IBM
05.2021 - 04.2022
  • Executed fusion adaptation with OBIA upgrade and retrofitment.
  • Designed data models while identifying facts and dimension tables.
  • Customized PVOs by extracting files from BIACM and UCM.
  • Developed load plans for full and incremental data loads.
  • Implemented co-existence reports based on client specifications.
  • Managed implementation of packages, procedures, and customized mappings for type 1 and type 2.
  • Produced technical documentation aligning with business requirements.
  • Utilized ODI 12c, OAC 12c, Oracle DB 19c, and Tableau for project execution.

ETL Developer

Dilytics Technologies Pvt Ltd
11.2017 - 05.2021
  • Installed necessary software for project implementation, including Oracle Data Integrator and OBIEE.
  • Gathered business requirements through daily meetings and delivered work to onsite team.
  • Developed interfaces, temporary interfaces, and SQL queries for data sourcing in ODI.
  • Identified facts and dimensions to build an efficient data model.
  • Created procedures, reusable mappings, scenarios, packages, and new load plans in ODI.
  • Extracted, transformed, and loaded data from various sources including relational databases and flat files.
  • Configured parameters like initial extract date and slowly changing dimensions for optimized loading.
  • Monitored full and incremental loads using Oracle Data Integrator (ODI) tool.

Education

Bachelor of Engineering - Computer Science

Osmania University
06-2017

Skills

  • Oracle Data Integrator 12c
  • OBIEE 12c
  • Power BI, Tableau, Qlik
  • ORACLE 11g,12c,19c
  • Linux/Unix
  • Python, Shell
  • SQL, PLSQL

Timeline

Sr. Consultant

Capgemini Technologies Pvt Ltd
04.2022 - Current

Package Specialist ODI

IBM
05.2021 - 04.2022

ETL Developer

Dilytics Technologies Pvt Ltd
11.2017 - 05.2021

Bachelor of Engineering - Computer Science

Osmania University
Vishnu Priya Konduru