Sandeep Battu
Collierville
Summary
Over 12+ years of experience in IT, I have worked across multiple domains, gaining extensive expertise in various areas. Having 7.4+ years of experience in data engineering, cloud data warehousing, and analytics. Proficient in TIBCO/EAI components such as TIBCO Business Works (BW), Container Edition, TIBCO Enterprise Message Service (EMS), TIBCO Administrator. Strong expertise in Snowflake, SQL, AWS, DBT and ETL pipelines, ensuring seamless data integration and transformation. Load data from files stored in a staging area, whether in an internal Snowflake stage or an external stage like Amazon S3, then transfer the data into the target table and query the data warehouse (DW) for analysis. Configured the event management system in S3 by using Snow pipe integration in snowflake. Hands-on experience with JSON files load into VARIANT data type and Table Flattening to convert semi-structured data to a relational representation. Used COPY/INSERT, PUT, GET commands for loading data into Snowflake tables from internal/external stage. Implemented robust and scalable data pipelines in Snowflake, incorporating Snow SQL for efficient data extraction, transformation, and loading (ETL) processes. Well versed with Snowflake features like clustering, time travel, cloning, logical data warehouse, caching etc. Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table. Experience in building Snowpipe. Set up alerts and monitoring for data accuracy, load failures, and processing delays to ensure high-quality, timely data availability. Cloning of database schemas, tables, procedures from QA to Prod environment. Experience on Snowflake functions like Time travel, Data Sharing, Data Cloning, Secure views and multi-cluster, shared data architecture (cloud service, virtual WH, data storage). Responsible conducting Agile ceremonies like Release planning, Sprint planning, Daily scrums, Scrum of scrums, retrospective, iteration review and iteration demo ceremonies. Experience in understanding Oracle database and working with SQL.
Overview
10
10
years of professional experience
Work History
Technical Lead
FedEx-Express
12.2018 - Current
- Company Overview: Integrating FedEx data into Snowflake's cloud-based data platform for advanced analytics and business intelligence
- The goal of this project is to integrate FedEx's operational and shipment data into Snowflake to enable real-time analytics, reporting, and decision-making
- This integration will help FedEx improve supply chain efficiency, optimize shipping processes, and gain deeper insights into customer behavior and operational performance
- Use ETL/ELT pipelines or intelligent data pipelines to transfer raw FedEx data into Snowflake for processing and storage
- Consumed data from multiple sources using AWS services, applied complex transformations to ensure data quality, and enforced schema validation before loading into Snowflake
- Loaded data from files stored in a staging area, whether in an internal Snowflake stage or an external stage like Amazon S3
- Implemented automated pipelines to update data in real-time or according to scheduled intervals
- Optimize query performance through Snowflake features like clustering keys, result caching, and query profiling
- Set up alerts and monitoring for data accuracy, load failures, and processing delays to ensure high-quality, timely data availability
- Performed ETL procedure to load data from different sources into data warehouse using DBT tool and test them on regular basis
- Worked on process location and Segments data from S3 to Snowflake by using Tasks, Streams, Pipes and Stored Procedures
- DBT for transforming and loading data into Snowflake
- Performed DBT unit test cases on data validations in table and dataset level to ensure existing data is valid
- Configured and maintained connectivity between DBT and different cloud applications and platforms such as snowflake, Amazon S3, and Microsoft Azure
- Developing the synchronization, data replication, data mask task to transfer the data to downstream systems
- Bulk loading and unloading data into Snowflake tables using COPY command
- Responsible for facilitating SAFe Agile ceremonies (Daily Standup, Iteration Review, Iteration Demo, Retrospective, Architect Code walkthrough)
- Organize daily technical discussions with the Onsite team also including the individual offshore work stream leads and set expectations for offshore delivery
- Providing UAT support and Deployment support
- Worked in a Scrum Agile process with two-week iterations delivering new Snowflake objects and migrating data at each iteration
- Providing development and testing status to Client and other project stakeholders on regular basis
- Ensure ETL/ELTs succeeded and loaded data successfully in Snowflake DB
- Integrating FedEx data into Snowflake's cloud-based data platform for advanced analytics and business intelligence
- The goal of this project is to integrate FedEx's operational and shipment data into Snowflake to enable real-time analytics, reporting, and decision-making
- This integration will help FedEx improve supply chain efficiency, optimize shipping processes, and gain deeper insights into customer behavior and operational performance
- Environment: Snowflake, DBT, AWS, SQL, GIT, AZURE, SNOW PIPE
Sr TIBCO Developer
FedEx
12.2016 - 11.2017
- Company Overview: The Enterprise Notification Services (ENS) system will provide FedEx customers timely, accurate notifications regarding status about shipping, internal account managements and all kind of interactions with customers (get the 2second advantage), that enable a consistent experience in all notification channels while eliminating duplicate messages across disparate FedEx systems
- Involved in product backlog refinement and participation in PI planning
- Responsible to work with Business Owners/Architect/Stakeholders to ensure the backlog items are prioritized based on the business value and time
- Responsible to elaborate user stories for implementation
- Involved in migrating Tibco application from TIBCO Stack to JAVA Spring boot microservices
- Involved in different levels of testing with verification and certified Documentation
- Analyzing and reviewing the functional specifications, business verification and writing UAT test cases
- Accepting the results on behalf of the relevant business user and recognize the changes necessary to existing processes and take a lead role in ensuring that the changes made are documented and communicated
- Responsible for facilitating SAFe Agile ceremonies (Daily Standup, Iteration Review, Iteration Demo, Retrospective, Architect Code walkthrough)
- Involved in Service Virtualization for RESTful services automate and releasing to the next level
- Involved in Performance Validation to verify service throughput, response time and health check which are intended for move to production
- Monitoring App services using APP Dynamics, Splunk and Grafana (Monitoring Tools)
- Involved in Cross Train Integration Validation with multiple scrum teams
- Involved in analyzing production issues faced by downstream application teams
- Provided Solutions
- Weekly progress review with Business owner and Fortnightly status update to IT Manager/Release Train Engineer and publish reports
- Analyzing risks and providing mitigation plan in most of the projects involved
- The Enterprise Notification Services (ENS) system will provide FedEx customers timely, accurate notifications regarding status about shipping, internal account managements and all kind of interactions with customers (get the 2second advantage), that enable a consistent experience in all notification channels while eliminating duplicate messages across disparate FedEx systems
- Environment: TIBCO BW, BE, EMS, Admin, Oracle, AppD
TIBCO Developer
HERMES - T-Mobile Poland
06.2015 - 11.2016
- Company Overview: T-Mobile is Poland's largest mobile phone network operator
- The company is formally registered under the name Polska Telefonica Cyfrowa (PTC), meaning 'Polish Digital Telephony', and formerly operated under the name Era until being rebranded as T-Mobile on 5 June 2011
- Wipro has committed to T-Mobile a significant improvement of its legacy application consolidation & rationalization, transforming its operating model from application-focus to domain-focus leading to better customer service
- Over the next five years, Wipro will help T-Mobile systemize and standardize the IT architecture and operations of their Polish entity
- A significant portion of the services will be provided from Wipro’s Delivery Centre in Warsaw as a part of their development strategy for Poland
- Understanding the business needs and functional enhancements
- Involved In project planning and designing of application
- Involved in making documents like Design Document (LLD), Test scenario document
- Interacted with onshore counterparts for discussions related to Requirement Analysis, Design, Testing
- Designed and developed various Inbound and Outbound TIBCO BW processes and performed various data mapping and manipulation
- Subscribed messages from TIB/EMS, HTTP and Web Services implemented business logic, data validation and mapping fields using XPATH and published messages using TIB/EMS
- Involved in Unit and Integration testing, bug fixing and testing
- Deployment and Maintenance of all the BW processes in administrator
- Communicated with business customers to discuss the issues and requirements
- Developed mappings/sessions using Informatica Power Centre 10.2.0 for data loading
- Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor
- T-Mobile is Poland's largest mobile phone network operator
- The company is formally registered under the name Polska Telefonica Cyfrowa (PTC), meaning 'Polish Digital Telephony', and formerly operated under the name Era until being rebranded as T-Mobile on 5 June 2011
- Wipro has committed to T-Mobile a significant improvement of its legacy application consolidation & rationalization, transforming its operating model from application-focus to domain-focus leading to better customer service
- Over the next five years, Wipro will help T-Mobile systemize and standardize the IT architecture and operations of their Polish entity
- A significant portion of the services will be provided from Wipro’s Delivery Centre in Warsaw as a part of their development strategy for Poland
- Environment: TIBCO BW, EMS, Admin, ORACLE, Jenkins
Education
MCA -
Osmania University
Hyderabad, INDIASkills
- ETL Tools: DBT
- Data Warehousing: Snow-Flake
- Integration Tools: TIB-TRA 5X
- Integration Tools: TIB-BW 5X
- Integration Tools: TIB-EMS
- Integration Tools: TIBCO BW CE 2x
- Integration Tools: MULE ESB 37x/39x /4x
- Agile Management: Version One
- Agile Management: HP Agile Manager
- Monitoring Tools: App Dynamics
- Monitoring Tools: SPLUNK
- Monitoring Tools: Grafana
- Operating Systems: UNIX/ LINUX
- Operating Systems: Windows
- Programming Languages: SQL
- Programming Languages: PL/SQL
- Programming Languages: HTML
- Programming Languages: UNIX Scripting
- Programming Languages: Python
- Ticketing Tools: Service Now
Timeline
Technical Lead
FedEx-Express
12.2018 - Current
Sr TIBCO Developer
FedEx
12.2016 - 11.2017
TIBCO Developer
HERMES - T-Mobile Poland
06.2015 - 11.2016
MCA -
Osmania University
Similar Profiles
Christy WashingtonChristy Washington
Admin/Package Handler at FedEx Ground/ FedEx ExpressAdmin/Package Handler at FedEx Ground/ FedEx Express
Daniela CiteraDaniela Citera
Customer Technology Solution Specialist at Fedex Express / TNT ExpressCustomer Technology Solution Specialist at Fedex Express / TNT Express
Kamogelo LefakaneKamogelo Lefakane
Learning and Development Specialist Associate at TNT Express / FedEx Express South AfricaLearning and Development Specialist Associate at TNT Express / FedEx Express South Africa