Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic
Phanidhar Achalla

Phanidhar Achalla

Hyderabad

Summary

Project Technical Manager with over a decade of experience in designing and implementing tailored IT solutions. Expertise in optimizing system architectures and enhancing operational efficiency, leading to significant improvements in performance and reliability. Proven track record of managing cross-functional teams to deliver scalable infrastructure solutions that drive business growth and functionality. Proven ability to analyze RFP requirements, develop winning strategies and deliver high quality proposals within tight deadlines.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Western Digital

Deloitte Consulting
Hyderabad
08.2024 - Current
  • Primary Architect for a high-stakes engagement to design, implement, and manage a complex clone solution, aiming to replicate the client's existing architecture to ensure a seamless testing, development, and disaster recovery process.
  • Responsible for overseeing the design of clone infrastructure, ensuring it mirrors the client's existing setup accurately.
  • Assembled and led a team of developers for the development and execution of comprehensive testing plans to validate clone infrastructure.
  • Engaged with key stakeholders, conducted regular status updates, and presentations to senior management and client representatives.
  • Cloned and implemented more than 1,400 data pipelines within strict timelines from various source systems, creating a unified data warehouse, and enabling reporting for more than 450 reports.

Humana Health

Deloitte Consulting
Hyderabad
01.2023 - Current
  • Responsible for the overall design of the application, and ownership of the architectural vision of the solution
  • Led team of 12 to design and implement a centralized data warehouse for the data harmonization of various source systems
  • Implemented Oracle Fusion Data Intelligence for Finance and customized it for client-centric reporting needs.
  • Architect data integrations to extract data from multiple custom sources using Oracle Data Integrator and Oracle Integration Cloud.
  • Implemented a frequent refresh strategy to enable the end users to have near real-time data, helping to speed up the financial close process.
  • Interacted with functional users to gather requirements for the core reporting system to understand the exceptional features users are expecting with the ETL and reporting system
  • Handled project management activities, such as identifying engagement risks, issues, and dependencies, escalating them to leadership as needed, and resolving them as required.

Western Digital

Deloitte Consulting
Hyderabad
04.2019 - 12.2022
  • Responsible for the overall design of the application and ownership of the architectural vision of the solution, design, and implement a centralized data warehouse for data harmonization of various source systems.
  • Architected a data integration solution to extract data from SAP and Cloud ERP using Oracle Data Integrator, and to use the Oracle Analytics Cloud platform to meet their analytical needs.
  • Performed POCs and proposed a feasible, uncomplicated solution to re-engineer BIAPPS ODI 11g ETL mappings to ODI 12c.
  • Developed custom ODI knowledge modules to support BIAPPS functionality in ODI 12c.
  • Managed and led a team of 45 developers to design and customize the ETL and analytics for the modules: Procurement & Spend Analytics, Finance Analytics, Supply Chain Management, Manufacturing, Order Management, and Costing.
  • Provided technical expertise on data replication and integration strategy to move data between Oracle Cloud ERP and Exadata databases using Oracle GoldenGate and Oracle Data Integrator.
  • Performance-tuned ETL jobs improved the load execution timings from 15 hours to 3 hours in full load, and from 7 hours to 20 minutes in incremental.
  • Developed a frequent refresh strategy with a schema switch to enable the end users to have near real-time data.

Pioneer Natural Resources

Deloitte Consulting
Hyderabad
07.2017 - 04.2018
  • Architected a data integration solution to extract data from the client’s custom source system, and Microsoft SQL Server.
  • Responsible for the overall ETL design and data warehouse modeling.
  • Lead technology consultant providing development, testing, deployment, and production support for developing data integration pipelines, and supporting the reporting team for validations.
  • Developed complex logic to cater to the reporting requirements of the Top-Level Organization.

Cummins

Accenz LLC
Columbus
04.2016 - 04.2017
  • Worked extensively on Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition (OBIEE), Financial Data Management Enterprise Edition (FDMEE), and Data Relation Manager (DRM).
  • Migrated Hyperion Interactive Reports (IR) to OBIEE 11.1.1.9.1 using the Oracle Translation Workbench.
  • Developed ODI packages for automating data entry into DRM, and to perform data checks during the month-end close.
  • Responsible for end-to-end ETL and reporting design and development.

Meritor

Accenz LLC
Troy
08.2015 - 03.2016
  • Elicit requirements using document analysis, business process descriptions, use cases, scenarios, business analysis, task, and workflow analysis.
  • Responsible for creating custom facts and dimensions, subject areas, reports, and dashboards to meet the needs of the requirements.
  • Responsible for the design and creation of ETL interfaces, packages, and scenarios in Designer using Oracle Data Integrator.

Education

MASTERS IN ELECTRICAL AND COMPUTERS ENGINEERING -

Gannon University
Erie, PA, United States
05.2015

BACHELORS IN ELECTRONICS AND COMMUNICATION ENGINEERING -

Jawaharlal Nehru Technological University
05.2013

Skills

  • Fusion Data Intelligence
  • Oracle Analytics Cloud
  • Oracle Data Integrator 11g/12c
  • Oracle Cloud Infrastructure, Oracle Integrations Cloud
  • Azure Data Factory
  • Azure Data Bricks
  • SQL
  • Python

Accomplishments

  • Honored with the Outstanding Award for exceptional delivery of high-stakes engagement, ensuring timely completion and exceeding client expectations, resulting in an 80% reduction in data load run times and allowing users to access data near real time
  • Awarded Outstanding for delivering a complex project with zero defects, enhancing the client's operational efficiency
  • Recognized for delivering high quality RFP responses that resulted in a 55% win rate, significantly contributing to the company's revenue growth

Certification

  • Oracle certified OCI Data Science Professional
  • OCI Generative AI Professional
  • OCI Architect Associate
  • Oracle Cloud Fusion Analytics Warehouse Implementation Professional

Timeline

Western Digital

Deloitte Consulting
08.2024 - Current

Humana Health

Deloitte Consulting
01.2023 - Current

Western Digital

Deloitte Consulting
04.2019 - 12.2022

Pioneer Natural Resources

Deloitte Consulting
07.2017 - 04.2018

Cummins

Accenz LLC
04.2016 - 04.2017

Meritor

Accenz LLC
08.2015 - 03.2016

MASTERS IN ELECTRICAL AND COMPUTERS ENGINEERING -

Gannon University

BACHELORS IN ELECTRONICS AND COMMUNICATION ENGINEERING -

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Phanidhar Achalla