Jaya Pavani Kaligotla
Hyderabad
Summary
Dynamic Principal Consultant with Oracle, specializing in cloud solutions and strategic planning. Proven track record in driving tech transformation and enhancing project management efficiency. Adept at mentoring teams and delivering innovative solutions that align with client needs, ensuring high-quality outcomes and operational excellence.
Overview
15
15
years of professional experience
Work History
Principal Consultant
Oracle
Hyderabad
06.2015 - Current
- Specialized in Oracle SCM analytics, developing OBIEE dashboards and subject areas that support inventory, procurement, and order flow visibility with strong RPD and SQL skills.
- Led teams in delivering Oracle SCM analytics and OBIEE dashboards, ensuring high‑quality data models, KPIs, and on‑time delivery across multiple supply chain functions.
- Translated SCM business requirements into optimized RPD designs, subject areas, and executive‑ready dashboards for inventory, procurement, and order management.
- Developed OBIEE reports and dashboards as an individual contributor, including SQL tuning, data validation, and performance optimization.
- Acted as SME for Oracle SCM data structures, guiding teams on data modeling, KPI definitions, and reporting logic.
- Drove end‑to‑end SCM analytics initiatives, ensuring alignment with business priorities and data governance standards.
- Led requirement workshops with supply chain stakeholders to define metrics and improve visibility into order flow, procurement efficiency, and inventory health.
- Managed cross‑functional coordination with DBAs, ERP teams, and business users to resolve data issues and streamline reporting pipelines.
- Delivered scalable dashboard solutions that improved operational decision‑making and reduced manual reporting effort across SCM functions.
- Oversaw development standards, code reviews, and best practices while mentoring junior developers and supporting their technical growth.
- Facilitated Agile ceremonies (stand‑ups, sprint planning, retrospectives) as Scrum Master, improving team velocity, predictability, and collaboration.
- Removed delivery impediments, coordinated dependencies, and ensured smooth execution of sprints across development and QA teams.
- Partnered with Product Owners to refine user stories, clarify acceptance criteria, and maintain a prioritized, actionable backlog.
Senior Software Engineer
Infosys
Hyderabad
08.2011 - 06.2015
- Developed and optimized ETL workflows using Informatica PowerCenter, including complex mappings, transformations, and performance‑tuned data pipelines.
- Designed and implemented advanced SQL/PLSQL queries, stored procedures, and analytical logic to support reporting and downstream applications.
- Performed data validation, reconciliation, and root‑cause analysis to ensure accuracy and reliability across large datasets and production ETL jobs.
- Provided training and technical guidance to junior developers on Informatica best practices, improving team capability and delivery quality.
Education
Bachelor of Engineering -
Osmania University
Hyderabad Skills
- SQL, PL/SQL
- Jira
- Informatica
- ODI
- OBIEE
- RPD Modelling
- ETL Architecture
- Dimensional Modelling
- Git
- SCM Analyics and Reporting
- Unix
- Control M
- Jenkins
- OCI
- Golden gate
Languages
English
First Language
Telugu
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Accomplishments
- Received several On the Spot and Star of the Month awards for individual contributions and several Best Team awards for team performance.
Timeline
Principal Consultant
Oracle
06.2015 - Current
Senior Software Engineer
Infosys
08.2011 - 06.2015
Bachelor of Engineering -
Osmania University