Summary
Overview
Work History
Education
Skills
Certification
Locations
Timeline
Generic

Tej Pavan Chowdary Paturi

Hyderabad

Summary

Solution Architect with expertise in SAP BW/4HANA, Native HANA, Power BI, and Databricks. Led 2 Greenfield implementations and 5 large-scale upgrades for global clients, including Delta Faucet and GE, at GyanSys Infotech. Certified in ITIL and Tricentis Tosca, with a strong background in manufacturing, retail, and pharmaceuticals.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Delivery Lead & Solution Architect

Delta Faucet
06.2017 - Current
  • Executed S/4HANA 1610 and BW/4HANA Green Field implementations with zero downtime.
  • Designed ETL processes to BW/4HANA through ADSOs and Open ODS Views for real-time analytics.
  • Developed PLM/PM BI architecture using AO and WEBI, including KPI dashboards for sales and inventory.
  • Optimized HANA models, achieving 40% faster reporting while resolving P1 and P2 Hypercare issues.
  • Implemented Databricks Medallion architecture with ADF, resulting in 30% cost reduction.
  • Established CI/CD pipelines via Azure DevOps for automated deployments.
  • Created technical specifications and UAT cases to ensure compliance.
  • Reduced cloud expenses by optimizing Serverless Compute usage.
  • At present, designing the solutions for another integration of SQL Server and discovery and blueprint sessions is being progressed.
  • Also, leading the BW4HANA 2023 upgrade project.

Lead SAP BI Consultant

Stanley Black & Decker
09.2016 - 05.2017
  • Conducted frontend and backend testing during HANA Upgradation and documented new features.
  • Monitored data load and performed various tests, including record count checks and KPI validations.
  • Oversaw entire Upgradation process involving DMO, pre-DMO, post-DMO, and PCA activities.
  • Resolved issues encountered during data loads to enhance system performance.
  • Tested outbound files via APD and executed code fixes for hardcoded system entries.
  • Participated in daily status calls to track project progress.

Lead SAP BI Consultant

Stanley Black & Decker
06.2016 - 08.2016
  • Adjusted job schedules in Qlikview to improve workflow effectiveness.
  • Scripted changes to date variable parameters within Qlikview.
  • Developed Other Material types inventory to produce .QVD files in Qlikview.
  • Generated region-specific variants for .QVD file creation based on requirements.
  • Assessed backend and frontend logics for multiple inventory reports, creating comprehensive technical documentation.
  • Managed execution of 140 BEx Variants for Global Inventory Projections History report in Qlikview.
  • Contributed to Canadian Orderometer design modifications with logic updates.
  • Conducted data loads and ensured report accuracy through validation.

Senior SAP BI Consultant

Stanley Black & Decker
03.2016 - 05.2016
  • Done with the code remediation for the mapping rules like Transfer rules, Update rules, Transformations.
  • As part of the code remediation, worked with Start, End and Field routines extensively.
  • Prepared the test scripts for an UAT.
  • Prepared the UNIT and UAT documents with after and before images of code.
  • Done with the data loads for before and after images code executions test.
  • Participated in daily update calls with the client.

Senior SAP BI Consultant

General Electric
10.2015 - 02.2016
  • Involved in requirement gathering.
  • Done with GAP analysis and prepared the Functional Specification.
  • Created the test data along with the PPM Functional team.
  • Coordinating the team for the things (meetings with client, understanding the requirements, technical stuff) done in right way.
  • Created some Generic Extractors with Views and Function Modules.
  • Insisting the team for good modeling so that system could be smoother even after lots of data.
  • Helping the team for critical tasks like coding part, converting the requirement into functional design and complex reports design.
  • Insisting the team for well technical design so that it should be helpful as a further reference.

Senior SAP BI Consultant

HIBU
08.2014 - 09.2015
  • Monitored data loads and resolved issues on a regular basis.
  • Facilitated weekly and monthly status meetings with onsite teams.
  • Collaborated with third-party systems, including NMBI.
  • Executed performance tuning to enhance system efficiency.
  • Developed various APDs and OPHDs aligned with business requirements.
  • Reconciled sales data from R3 to BW for accuracy.
  • Participated in cutover activities to ensure smooth transitions.
  • Generated broadcasting reports utilizing BEx for clear insights.

SAP BI Consultant

AkzoNobel
01.2014 - 07.2014
  • Client facing role by sitting in NL (5 weeks) in which I closely worked with our counter parts (SMEs).
  • Worked on BO Security setup.
  • Worked on Incidents, KCRs (service requests) and RFEs (Change requests).
  • Worked with ALPHA project which deals with the query building based on the Global business as well as Local business requirements.
  • Given END-USER-TRAINING on query building and report usage.
  • Worked with HEAT tool (ticketing tool).
  • Prepared Knowledge Acquisition Plan (KAP) based on which effectively taken the KT and also coordinated with other team members and SMEs for effective KT.
  • Prepared BW AOD based on the knowledge received from SME.
  • Involved in SLO Conversion wherein we have done controlling areas merge into Single Controlling area and involved in Company code merging too.
  • Involved in creation of Broadcasts through BEx.
  • Attending Weekly Status Updates calls.

SPOC, Incident Manager and BI Consultant

Provimi, Essent, KPN and Maxxium
04.2011 - 12.2013
  • Managed support for over three clients during BW maintenance and rollouts.
  • Contributed to three global rollouts in Austria, Singapore, and Russia, including FS/TD documentation.
  • Engineered process automation from file to application server using APDs.
  • Produced stock reports in R/3-Warehouse with customized hierarchies.
  • Oversaw User Acceptance Testing and cutover activities achieving 100% SLA adherence.
  • Enhanced query execution speed by 30% via aggregate functions and partitioning techniques.
  • Addressed more than 50 P1-P3 tickets monthly, ensuring critical issue resolution.
  • Set up SMTP/SCOT email alerts and implemented BW archiving through SARA.
  • As an Incident Manager, owned cross-module issue resolution along with weekly exec reporting

SAP BI Consultant

Maxxium
07.2010 - 03.2011
  • Conducted GAP analysis and LO extraction for INIT and delta loads.
  • Enhanced data sources using RSAP0001 and created generic extractors.
  • Migrated R/3 data to BW with LO/CO-PA extractors.
  • Developed functional specifications and delivery checklists for project clarity.
  • Optimized performance through debugging of update and transfer rules.
  • Maintained database and OLAP statistics, achieving 20% faster queries.
  • Built BW objects including InfoCubes, ODS, and InfoObjects.
  • Designed reports utilizing CKFs, RKFs, RRI, and exception handling.

Education

MBA - Marketing and Finance

Acharya Nagarjuna University
Guntur

Skills

  • BW/4HANA and Native HANA architecture
  • Microsoft ADF and Databricks
  • Power BI and BOBJ
  • Business intelligence solutions
  • Requirements analysis
  • Problem solving
  • ITIL framework
  • Team leadership
  • Analytical thinking and listening

Certification

  • ITIL Certified
  • Tricentis Tosca

Locations

  • Mumbai, Maharashtra
  • Bangalore, Karnataka
  • Hyderabad, Telangana
  • Netherlands
  • US

Timeline

Delivery Lead & Solution Architect

Delta Faucet
06.2017 - Current

Lead SAP BI Consultant

Stanley Black & Decker
09.2016 - 05.2017

Lead SAP BI Consultant

Stanley Black & Decker
06.2016 - 08.2016

Senior SAP BI Consultant

Stanley Black & Decker
03.2016 - 05.2016

Senior SAP BI Consultant

General Electric
10.2015 - 02.2016

Senior SAP BI Consultant

HIBU
08.2014 - 09.2015

SAP BI Consultant

AkzoNobel
01.2014 - 07.2014

SPOC, Incident Manager and BI Consultant

Provimi, Essent, KPN and Maxxium
04.2011 - 12.2013

SAP BI Consultant

Maxxium
07.2010 - 03.2011

MBA - Marketing and Finance

Acharya Nagarjuna University
Tej Pavan Chowdary Paturi