Spandana Jadi
Hyderabad
Summary
Currently working as an Associate Technical Architect at o9 Solutions, having 4+ years of experience in data engineering. Skilled in implementing efficient ETL processes to extract, transform, and load data across diverse systems, using SSIS, SQL Server, Python, o9 Integration. Extensive expertise in designing and deploying robust data solutions. Proven ability to work collaboratively with cross-functional teams to understand business requirements, and deliver data-driven solutions that align with organizational goals.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Associate Technical Architect
o9 Solutions
03.2021 - Current
- Experienced Associate Technical Architect with 4+ years of experience in supply chain management with expertise in technical aspects along with the functional aspects of product/platform implementation.
- Having 4+ Years of experience in Microsoft Business intelligence tools, SQL and SSIS.
- Experience with all the phases of SDLC life cycle - requirement gathering, estimation, analysis, design, development and implementation, quality assurance, ETL, ETL processing.
- Worked in designing ETL data flows using creating mappings/workflows to extract data from heterogeneous sources.
- Assemble large, complex data sets that meet functional / non-functional business requirements.
- Strong analytic skills related to working with unstructured datasets.
- A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
- Experience in working with stakeholders including the Executive, Product, Data, and Design teams to assist with data-related technical issues and support their data infrastructure needs.
- Worked with SQL extensively by using tables, views, joins, sub queries, stored procedures.
- Designed and implemented more than 200+ dimension and fact tables to support enterprise-wide reporting needs.
- Experience in Performance Tuning and Query Optimization.
- Experienced in developing ETL packages using SSIS - SQL Server Integrated Services.
- Have passion for Data and deriving quick data driven insight/solutions to answer business problems.
Senior Technical Consultant
o9 Solutions
10.2023 - 04.2025
- Senior Integration Consultant for an American multinational food, snack, and beverages.
- Designing ETL data flows using creating mappings/workflows to extract data from heterogeneous sources.
- Strong analytic skills related to working with unstructured datasets.
- Building the SSIS Packages for Data Transformations, Data Quality check and Data Load to o9 Platform.
- Assemble large, complex data sets that meet functional / non-functional business requirements.
- Working with Pepsico stakeholders including the Executive, Product, Data, and Design teams to assist with data-related technical issues and support their data infrastructure needs.
- Experience in performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Deploy the SSIS solution, Schedule the batches, run and monitored the workflows/batches.
- Worked with SQL extensively by using tables, views, joins, sub queries, stored procedures and Jobs.
- Designed and implemented more than 200+ dimension and fact tables to support reporting and analytics needs.
- Collaborative team player with excellent communication skills, adept at translating business requirements into scalable and efficient data solutions by participating in requirement elicitation sessions.
- Interfacing with the product development team for the issues highlighted by the client to ensure the delivery of quality solutions.
- Successfully undertook the responsibility of deployment from preproduction environment to the production environment.
- Created detailed batch and integration documents.
- Took responsibility of SSIS batch monitoring during hyper care and SIT phases ensuring the correctness of data to the platform. Assisted in user adoption by providing training to the key stakeholders along with the documentation.
- Implemented Centralized Continuous Monitoring for batch performance status identifying critical issues promptly, leading to improved user satisfaction, enhancing system reliability and efficient problem resolution.
- Work with Clients, cross-functional teams, IT and business stakeholders to ensure successful planning and execution of projects.
- Mentor Juniors to familiarize them with the technical and business aspects of a project.
Consultant
o9 Solutions
03.2021 - 10.2023
- Integration Technical Consultant for multinational tyre manufacturer which became first customer of o9 in Europe for Integrated Business Planning.
- Designing and modelling daily/monthly/yearly processes for end-to-end data processing from the key stakeholders to the o9 platform, delivering impactful solutions for Demand Planning and Supply Planning.
- Use SSIS and SQL to synthesis, process and transform data for integration and reporting purpose.
- Optimized the performance of workflows and reduced the batch processing time to half of the original time.
- Debug identified issues and bugs raised by clients providing appropriate solution to a given problem statement. Implementing Leveraging cutting-edge technologies to extract actionable insights from complex dataset.
- Create and execute workflows, document the issues and track the progress at resolving issues.
- Designed and implemented more than 200+ dimension and fact tables to support reporting and analytics needs.
- Deploy the SSIS solution, Schedule the batches, run and monitored the workflows/batches.
- Responsible for Unit Testing.
- Experience in performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
Education
bachelor's degree - Electronics and Communication Engineering
Anna University
Chennai05-2020
Skills
- o9 platform
- Int30
- SQL
- PySpark
- IBP
- Python
- SSIS
- SSMS
- ETL
- Airflow
- GIT
- Platform Integration Using SSIS and Reference Product
- Data Transformation
- Data Management
- Data Analysis
- Delta Lake
- Jupyter Notebook
- Microsoft Azure Storage Explorer
- Visual Studio
- Good communication skills
- Problem Solving
- Proactive
- Teamwork
- Leadership
Accomplishments
- Awarded for smooth continuity of project.
- Exemplary feedback from the customer.
- Significant contribution to the project.
Certification
certification-Integrations-using-Int-3.0-and-EKG-Configurator-R2024.03
Languages
Telugu
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Tamil
Advanced (C1)
C1
Timeline
Senior Technical Consultant
o9 Solutions
10.2023 - 04.2025
Associate Technical Architect
o9 Solutions
03.2021 - Current
Consultant
o9 Solutions
03.2021 - 10.2023
bachelor's degree - Electronics and Communication Engineering
Anna University
Similar Profiles
Beau FisherBeau Fisher
Innovation Strategist - Retail, Distribution, Luxary, and Footwear at o9 SolutionsInnovation Strategist - Retail, Distribution, Luxary, and Footwear at o9 Solutions
SAIKAT DASSAIKAT DAS
Associate Solution Architect at o9 SolutionsAssociate Solution Architect at o9 Solutions
Vishnu VinodVishnu Vinod
Senior Product Manager at O9 SolutionsSenior Product Manager at O9 Solutions
Debeshi SadhukhanDebeshi Sadhukhan
Associate Delivery Manager at o9 SolutionsAssociate Delivery Manager at o9 Solutions
Nithin SaraNithin Sara
Sr. Product Engineer at TECHMAHINDRA LTDSr. Product Engineer at TECHMAHINDRA LTD