Deepthi Sarikonda

9 years of experience in Software Development, working across the Manufacturing and Retail (Apparel) domains, with hands-on experience in database programming and data-driven analysis. Skilled in Oracle PL/SQL and SQL, experienced in building queries, procedures, packages, triggers, and views for business systems in the Apparel (Retail) and Manufacturing domains, including product lifecycle analysis. Experienced in Oracle advanced PL/SQL and SQL, developing and debugging stored procedures, functions, packages, and triggers using tools like SQL Developer.

Good experience developing reports using SSRS. Practical knowledge of creating ETL maps and troubleshooting SSIS packages. Expertise in different tools in Data Warehouse. Experienced in application testing, troubleshooting, and debugging, with a strong understanding of incident, problem, and change management Processes.

Recognized for delivering reliable and efficient code, improving systems, and quickly addressing critical issues to ensure smooth and continuous operations.

Lead software Engineer at Coforge Limited (2026-02 – 2026-07)

Project: Marketing Global Campaign Performance Domain: Marketing/Retail Project overview: Curated dataset for Marketing Business - Dashboard Measures the Funnel performance and campaign performance. Using Key Performance Indicators (KPI’s) – to track the funnel and campaign performance.

• Exploratory Data analysis, Data Curation.
• Understanding the Business requirement and working session with Business users and leads for clarification.
• Understand the mapping document and complete Hive SQL Migration on time.
• Worked on Data Validation, Code review and test result with User
• Reconciliation in case of data mismatch, fixing the reported Bugs reported by QA team.
• Responsible for validating the code, ingestion.
• Involved in loading and transforming large sets of structured data and analyzed them by running Hive queries.
• In case of data corruption, fixed the issues and reload if needed.
• As the resource allocation is limited, tuned the code and made them performant.
• Worked on the limited metadata, monitored and optimized based on dashboard requirement.
• Implemented Spark using Spark SQL for faster testing and processing of data.
• Implemented partitioning, dynamic partitions.

Lead software Engineer at UST Global (US Technology International Private Limited) (2021-11 – 2026-01)

CLIENT: Hanes Brands Inc.

Project: HBI BI Datawarehouse support and maintenance Domain: Manufacturing Project Overview: Hanes Brands Inc. is a global apparel manufacturer of essential apparel and activewear products. The Project focuses on Product Lifecycle Analysis (LCA), leveraging enterprise-wide data related to sales performance, margins, and inventory movement to support strategic planning and operational decisions. Data from Oracle, SQL Server, and SAP platforms is consolidated through automated ETL workflows and analytical cubes for cross-functional reporting and forecasting.

• Designed and developed PL/SQL procedures, functions, triggers, and ETL Maps enabling seamless integration and lifecycle data management across Oracle, SQL Server, and SAP systems.
• Implemented a data-driven predictive model using historical and forecasted sales to evaluate product demand and optimize production planning.
• Enhanced performance and automation of lifecycle update processes through efficient trigger logic, data validation, and stored procedure optimization.
• Streamlined data flow into sales, margin, and financial cubes, enabling accurate business reporting through SSRS and Power BI.
• Collaborated with business and analytics teams to design new procedures, materialized views, and data extracts aligned with evolving reporting requirements.
• Provided production support and issue resolution, ensuring data consistency, timely updates, and system reliability across lifecycle components.
• Contributed to continuous improvement by identifying performance gaps, refining database design, and ensuring alignment with enterprise data standards.
• Troubleshoot the issues in Datawarehouse including the data issues in different reports and tables.

Technical Engineer (IT Division) at Oblum Electrical Industries Private Limited (2017-07 – 2021-10)

Project: Surge Arresters Manufacturing and Demand Planning Domain: Supply Chain / Manufacturing Project overview: This project is about the demand that gets generated for purchasing the Products. Surge Arresters are basically used to protect the electrical equipment like transformers, circuit-breakers and bushings against the effects of over voltages caused by incoming surges.

• Worked on customized procedures like loading the history level details for different products.
• Worked based on the requirements specified by the customers.
• Worked on Custom Procedures, Packages, Triggers, Synonyms and other database objects.
• Automated the Daily Monitory Check Activity (DMC) through the job schedules.
• Analyzing and understanding the functional requirements.
• Created procedures based on the client requirement.
• Used DB Links for accessing other database objects.

M.Tech. in Electrical Power Engineering – CVR College of Engineering, Hyderabad

B.Tech. in Electrical & Electronics Engineering – Nalla Malla Reddy Engineering College, Hyderabad