Senior Software Engineer - Data Analyst

• Aug 2022 - Present

At BOLD, I am an integral part of the Business Intelligence team, where we specialize in delivering data-driven analytical solutions to address the business's challenges.In my role, I provide valuable analytical insights into the day-to-day operations of the business. A significant portion of my work involves writing complex SQL queries to extract and manipulate data from databases such as Snowflake, Microsoft SQL Server, enabling me to offer comprehensive insights and summaries.Among various insightful reports, one of the key task was to develop an automated report that delivers weekly updates to the leadership team, highlighting anomalies in key performance indicators (KPIs) through statistical analysis and rule-based decision-making.Additionally, I have leveraged my expertise in Python, JupyterLab, and RShiny to develop custom-built tools that empower stakeholders to generate reports and access analyses for multiple AB tests. These tools have streamlined the reporting process and enhanced decision-making capabilities.I also conducted various analyses to comprehend customer behavior patterns following subscription cancellations and subsequent returns to our services. Additionally, I examined the cost-effectiveness and revenue implications of customer care center operations, providing insights to guide decision-making.Conducting thorough funnel analysis, I identified areas for improvement at both the top and bottom of the sales funnel for portals experiencing lower conversion rates. Through my recommendations, I have contributed to optimizing the customer journey and enhancing conversion rates.Furthermore, I have provided support to the Data Engineering team by building end-to-end ETL pipelines. This involved extracting data from diverse APIs, such as Google Search Console, BingAds, GoogleAds, and Conductor, to ensure the availability of accurate and up-to-date information for analysis. Show less

Software Engineer - Data Analyst

• Jul 2021 - Jul 2022

Business Analyst

• Mar 2021 - Jul 2021

Worked as the lead analyst of Central Revenue Team for OYO's India business. My role involved developing R/Python codes and SQL queries for preparation of key revenue deliverables like daily/monthly reports that track key business metrics on different levels, Budgeted vs Actual performance analysis, City, product, channel level financial and business analysis, Trending forecasts, AOP etc. Worked with different departments within the organization (Finance, Pricing, Conversion, Operations, Marketing) to understand their key reporting requirements, and suggesting best ways to present data for everyday tracking and business performance reporting. Created impact trackers for various sale campaigns that were launched and helped track the sale impact across cities and properties. Show less

Consultant I

• Jan 2020 - Mar 2021

Worked with one of the biggest utilities provider in United Kingdom.Was part of the Settlements & Imbalance Team that took care of the settlements side of the client company with Industry. My role heavily involved building process improvement tools, models & periodic reports in SAS, SQL Server, Python and performance dashboards using PowerBI.Worked on analysis of operations side of business to identify the fall outs and business areas which needed improvement in terms of tasks handling performance. Built forecasting models in Python which helped forecast the volume of tasks to be handled by various business areas and hence forecasting the number of FTEs required to handle the volume. Diminished process gaps and exercised critical thinking by closely supervising the Business As Usual activities to ensure optimal productivity.Helped automating deployments of existing MS Access reports to SAS and SQL, enabling faster and more portable deployments, reducing the number of man-hours from 8-10 hours to 2 hours on an average.Involved in day to day adhoc data analysis requirements from clients using SAS, SQL and Python. Show less

Business Analyst

• Jul 2018 - Dec 2019

Computer Vision Developer

• Jun 2017 - Jul 2017

Software Developer Internship

• Mar 2017 - Apr 2017