Business Intelligence Engineer at Amazon, Tek systems (2024-09 – 2025-02)
- Collaborated with cross-functional stakeholders to identify and automate complex manual workflows, streamlining operations and improving efficiency across the supply chain team.
- Designed and implemented analytical solutions to address critical business challenges, leveraging ETL and data visualization techniques to uncover insights and support strategic decisions.
- Leveraged AI powered tools including Amazon Quick and Claude to improve productivity in dashboard development and SQL query optimization, troubleshooting and reporting tasks.
- Developed and deployed scalable ETL pipelines using Quickbase, SQL, AWS and Excel, achieving a 70% reduction in data processing times.
- Built and maintained interactive dashboards in QuickSight to deliver real-time insights into key performance metrics, including quality, operational performance, and spend analysis.
- Automated recurring excel reports and data validation checks of OTIF reporting, reducing manual effort by 80% and ensuring timely reporting.
- Partnered with business teams to translate data insights into practical recommendations, driving improvements in productivity and reporting accuracy.
Data Engineer I at Amazon, Akraya (2022-10 – 2024-03)
- Designed and implemented scalable cloud-based data warehousing solutions using Redshift, Spark SQL, AWS EMR to support advertising analytics and machine learning-driven campaign measurement.
- Collaborate cross-functionally with product managers, engineers, and science teams to define hypotheses, run several A/B experiments, and analyze results to drive data-informed decision-making.
- Communicated findings and insights from A/B testing to stakeholders through clear and concise reports, optimizing campaign measurement operations with minimal latency.
- Regularly tracked KPIs using Quicksight and iteratively optimized test designs to enhance strategies and drive business improvements.
- Automated python modules to rigorously validate campaign reports, swiftly identifying and summarizing failed key metrics.
- Applied dimensional data modeling (star and snowflake schemas) to design analytics-ready fact and dimension tables in Redshift to support scalable BI reporting.
- Developed and maintained CI/CD pipelines using Git and AWS, automating the deployment of data pipelines and machine learning models to ensure seamless integration and continuous delivery.
- Boosted data pre-processing by 25% through on-demand scalable ETL jobs tailored to meet specific stakeholder requirements.
- Led large-scale customer segmentation and RFM analysis by extracting data sourced from on-premises databases (Andes), and performed optimization in Cradle using Spark SQL/PySpark (filtering, CTEs, window functions, joins), resulting in a 70% reduction in processing time.
- Supported data scientists and analytics teams with data ingestion, transformation, feature preparation, and ad hoc exploratory analysis for machine learning and reporting initiatives.
SQL Analyst at Apple, RMSI (2022-08 – 2022-10)
- Managed automated workflows and performed comprehensive geospatial data analysis, impact assessment, and gap analysis for Apple Maps utilizing a diverse tech stack including Maps SQL, Python (pandas), Regex, Hive, and pgAdmin.
Data Engineer at IBM India Pvt Ltd, Bangalore, India (2014-08 – 2018-01)
ITAC (India Tax and Compliance) Reporting System (Data Stage, Cognos, Netezza)
- Developed ETL pipelines for finance teams to track invoices billing generated across multiple OLTP systems and licenses using Datastage, Netezza and DB2.
- Responsible for automating the Invoice to Softex to BIRC mapping process with the help of DataStage jobs. Implemented data processing and transformation logic to generate outstanding AR and softex reports.
- Developed and maintained a suite of jobs for generating daily, weekly, and monthly reports, meeting business needs and ensuring timely insights delivery.
- Engineered high-performance SQL procedures optimized for handling large volumes of data, resulting in efficient data retrieval and analysis.
- Wrote scripts using CRON utility to schedule weekly email deliveries for sending the exception reports.
- Managed dashboards in Cognos Analytics, showcasing KPI trends through insightful visualization charts, facilitating data-driven decision-making.
Business Analyst at IBM India Pvt Ltd, Bangalore, India (2014-08 – 2018-01)
ATTAC (A-Team for Tax and Compliance) (QMF, Hyperion Intelligence Explorer, MySQL)
- Worked with Managers and WW SMEs to understand the business requirements and was involved in building a new employee data mart interface for regulars and SSPIS for contractors.
- Involved in the automation of the US BRANCH assignment movement which is currently handled through interim manual solutions.
- Responsible for writing complex SQL queries for data analysis to meet business needs.
- Wrote functional design documents to incorporate the product enhancements by analyzing their impact.
- Worked with a reporting team for automating some of the complex problems faced by tax and compliance teams.
