• Develop automated dashboard and reports by exploiting SQL and manipulating data using calculated measures and columns in Power BI to provide a solid understanding of key business metrics and their impact on the business.• Automate the manual scrapping of Google Star Ratings and Reviews of furniture stores by using Google APIs in Python; automate the existing workflows and report deliveries to the business user using Power Automate based on the use case.• Analyze data gathered from various sources namely, Azure Cloud, SQL Server Database and use it for reporting purposes and communicate the effectiveness of new initiatives; draw insights and make performance improvement recommendations based upon the data sources.• Collaborate directly with the business teams across different pods and seniority level to understand performance drivers and trends in their area, provide insights, make recommendations, and interpret new data and results.• Utilize statistical and data visualization packages to develop innovative approaches to complex business problems and support the continuous improvement of the business by querying via coding in PySpark and SQL.• Create and evaluate important metrics to find patterns and the root causes of problems; conduct ad hoc in-depth analyses of current customer journeys to find the problems' causes and chances for improvement and present the findings to the business stakeholders.• Create and maintain development documentation and reusable test cases; Create Proof of Concepts (POCs) to pitch in new ideas and meet the center of excellence.

• Incorporated Python, ML and Tableau to develop a marketing mix solution to identify the best-performing media vehicles and to increase the ROI by 7%.• Performed data quality and hygiene checks to ensure good platform health to improve user satisfaction by 45%.• Work closely with product and business stakeholders to understand various products, consumer touch points, data streams, reports and draw insights to help the team make data informed decisions and cut operational costs by 15%.• Conducted in-depth analysis to report KPIs to senior leadership and stakeholders thus developing standard definitions, calculations, and generation structure saving ~2 FTE team effort.• Created interactive visualizations and dashboards and prepared slide-deck presentations along with recommendations by exploiting Tableau charts and tools to communicate the insights with logical and meaningful data flow to the clients and executives while contributing 7% overall efficiency.• Pulled data from various sources using SQL to generate ad-hoc reports and make informed decisions thereby reducing the IT workload from 5 hours to 30 minutes every week.• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.• Collaborated with DBAs and SQL developers to create, modify, and debug SQL scripts to generate data comparisons.• Conducted A/B tests to test marketing plans and improve user retention rates in ecommerce platforms.

• Analyzed data from multiple sources to draw actionable insights and identify relevant trends, resulting in an increase of sales efficiency by 40%.• Furnished insights, analytics, and business intelligence by synthesizing data points to inform business decisions that increased profits by 25% over a 3-month period.• Collated product usage data to craft optimization strategies for cross-functional teams, increasing the user experience by 25% for 25K customers.• Built predictive analytics models utilizing SQL queries & visualization libraries to forecast possible outcomes and optimize decision-making with 95% accuracy.• Created multi-dimensional dashboards to monitor key metrics and derived actionable insights to reduce manual reporting by 5 hours.• Built out a centralized data repository to support the analytics and reporting communities through data mining within the existing data warehouses to drive efficiency and consistency of entries.