sai sandeep

sai sandeep

Data Engineer
India
Full-time Hybrid

About Me

Data professional with 7 years in data and analytics and 13 Alteryx certifications (4 Designer, 2 Cloud, 7 Micro-Credentials). Builds Alteryx workflows that profile, cleanse, deduplicate and blend messy data from SQL, Sn…

Experience

Senior Business Intelligence Developer

DiLytics · Hyderabad, India
Aug 2023 - Present · 3 years 3 months

<p>Built Alteryx workflows to profile, cleanse, deduplicate and blend data from SQL Server, Snowflake, Excel and API sources, standardising schemas so downstream reports run on one consistent dataset.</p><p> Added validation steps that flag missing values, duplicate records and price outliers before data reaches reporting; payment data is reconciled against settlement reports as the single source of truth.</p><p> Helped migrate on-premises data warehouses to Snowflake, cutting infrastructure costs and improving scalability, with row-count and totals reconciliation before cut-over.</p><p> Built a Python ETL pipeline that turns raw NoSQL user logs into structured JSON with append logic, scheduled with Windows Task Scheduler, feeding retention, cart abandonment and session analysis.</p><p> Automated recurring loads with Alteryx, Snowflake Tasks and Python scripts, removing manual data preparation and the errors that came with it.</p><p> Built duplicate-booking logic and merchant-volume anomaly alerts so the risk team could investigate fake bookings and data errors early.</p><p> Classified repeat vs. new customers by Payment ID matching across bookings, and built channel, AOV and referral conversion measures.</p><p> Wrote KPI definition sheets and report user guides so each metric has one agreed definition and owner.</p><p> Built Python and Snowflake ETL pipelines combining energy, water and greenhouse gas data from multiple external sources and APIs across nine counties.</p><p> Tuned SQL and Snowflake queries and automated workflows with Snowflake Tasks.</p><p> Rebuilt reporting in Tableau and Power BI, cutting report generation time by 50%.</p>

Business Analyst

Best Buy Deals · India
May 2022 - Jul 2023 · 1 year 2 months

<p>Analysed marketing spend and ROI through dashboards, contributing to a 5x increase in sales revenue.</p>

Production Analyst

TCL Industries (CSOT) · China and India
Aug 2019 - Apr 2022 · 2 years 8 months

<p>Built data pipelines for near real-time monitoring of production and supply chain KPIs.</p><p> Used Python and SQL to extract, clean and analyse manufacturing data, raising production efficiency by 15% and cutting operational costs by 10%.</p><p> Built Random Forest predictive maintenance models that reduced unplanned downtime by 18%, saving about $500,000 a year.</p><p> Forecasted demand with ARIMA and Prophet to align production plans with market needs.</p><p> Automated SQL reporting for senior management, improving team efficiency by 30%, and trained non-technical staff on Power BI and Tableau.</p>

Skills

Alteryx Designer Alteryx Cloud Workflow automation Data profiling Data cleansing Deduplication Data blending Cross Tab Transpose Join/Union strategies Validation and reconciliation Duplicate detection Anomaly detection Outlier detection Schema checks SQL Window functions CTEs Query tuning Snowflake SQL Server NoSQL Python Pandas PySpark ETL ELT Snowflake Tasks Windows Task Scheduler Microsoft Fabric JSON Excel API data Power BI DAX Power Query Tableau Random Forest ARIMA Prophet
Report this Profile?