Summary
Overview
Work History
Education
Skills
Certification
Locations
<Enter your own>
Accomplishments
Work Availability
Languages
Interests
Work Preference
Timeline
AdministrativeAssistant

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

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 Certified

Locations

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

<Enter your own>

Accomplishments

In a short span of time, completed the Tricentis Tosca training and certification.

Completed WEBI to PBI conversion project before the schedule.

Created Warranty solution comprise of SAP and Sales force data which is being used in Warranty Auditing.

Designing the different computes in Databricks, saved lot of costs.

Finetuned the PowerBi scemantics models having code pushdown into HANA CVs and Materialized Views.

Led BW4HANA 2.0 Upgrade with no errors and backlogs.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Languages

English
Bilingual or Proficient (C2)
Hindi
Advanced (C1)
Telugu
Bilingual or Proficient (C2)

Interests

Playing Cricket and listening Music

Work Preference

Work Type

Full Time

Work Location

RemoteHybrid

Important To Me

Work-life balanceCareer advancementWork from home option

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