Upendar Kandragula

Results-driven Senior Data Engineer at Genpact with expertise in SQL and SAP HANA. Proven track record in leveraging advanced analytics and data integration to drive business insights. Adept at collaborating with cross-functional teams to deliver impactful solutions, enhancing data accessibility and decision-making processes. Passionate about optimizing data workflows and fostering innovation.

• English, Proficient
• Telugu, Native
• Hindi, Elementary Proficient

• Father's Name: Pallam Setty
• Date of Birth: 10/12/93

• Sports
• Traveling
• Reading

• Cisco, SAP HANA 2.0 SP07, Snowflake, SAP BODS, Elastic Search, Control-M, Spark, Business Analyst / Senior Data Engineer, 01/22 - 08/26, Collaborated with business stakeholders to gather and clarify requirements captured as JIRA stories; participated in sprint planning, daily scrums, and provided regular status updates on development progress., Designed and developed SAP HANA artifacts such as calculation views, table functions, and stored procedures using dynamic SQL; implemented input parameters and variables to enable flexible reporting., Built and scheduled ETL jobs in SAP BODS to orchestrate end-to-end data loads and trigger HANA procedures, integrating with Control-M for enterprise-level scheduling and monitoring., Processed and optimized large-scale enterprise datasets using SAP HANA, Spark, and Elastic Search to improve reporting performance and search capabilities., Migrated key HANA objects to Snowflake, redesigning models as Snowflake sequences, procedures, views, and table functions using SQL while following cloud data-warehouse best practices., Managed SAP HANA transport lifecycle using HANA Lifecycle Management and SAP ChaRM, ensuring controlled production deployments and release compliance., Performed performance tuning and optimization of complex queries and data models across HANA, Elastic Search, and Snowflake to meet SLAs., Authored Technical Design Documents (TDD), deployment guides, runbooks, and operational documentation for production support.
• Georgia Pacific, SAP HANA 2.0 Sp03, HANA Consultant Analytics, 03/19 - 11/21, Involved in full life cycle implementation, which includes, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support., Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models., Designed and developed multiple analytical dashboards including Dynamic Price Band Reports, Gross-to-Net Reports, and Deal Tracking Reports., Responsible for HANA modeling. Created multiple HANA models and table definitions. Experience in creating calculation views., Responsible for sending the Reporting Hana Models Template Created in ViZi to the Users., Developed SQLScript procedures, table functions, and complex SQL queries to support analytical reporting., Having Experience in Handling the Difference Type of Performance Optimization Techniques., Having Good Experience on Plan viz., Designed graphical and scripted Calculation Views using Join, Aggregation, Projection, Union, Rank, and Star Join nodes., Involved in Hana Transportation during Moving the Hana Modeling objects from one system to another system.
• AXFOOD, SAP HANA 1.0 Sp10, HANA Consultant Analytics, 01/18 - 02/19, Involved in business and blueprint gathering discussion., Worked very closely with SAP process teams in understanding the functional requirements., Imported and transformed business data from flat files into SAP HANA schemas for reporting and analytics., Designed both graphical & scripted Calculation View, Table Function, Stored Procedure to meet the business requirement., Strong understanding of HANA Join Types (Inner, Outer, Referential, Text)., Designed and developed HANA models like attribute view, analytical view, calculation view (both graphical and script based), calculated columns, and input parameters per the report requirements., Conducted peer reviews and performance tuning of developed models using best practices., Conducted knowledge transfer sessions and technical training for business users and support teams on SAP HANA reporting solutions., Involved in Postproduction go-live support., Developed and Executed queries in the back end.
• AMGEN, SAP NetWeaver 7.51 Sp2, Associate Consultant, 05/17 - 12/17, Developed CDS Views and AMDP methods to improve application performance by leveraging SAP HANA in-memory processing., Experience in CDS Views & AMDP., Provided post-production support by analyzing production issues, debugging ABAP/AMDP logic, validating fixes in QA, and coordinating production deployments., Good experience Preparing test plans like UTP, integration testing and updating the testing documentation.