Goutham Dasari, Developer in Dubai, United Arab Emirates
Goutham is available for hire
Hire Goutham

Goutham Dasari

Verified Expert  in Engineering

Microsoft Power BI Developer

Location
Dubai, United Arab Emirates
Toptal Member Since
June 24, 2020

Goutham is a senior BI developer with over ten years of experience in building strong analytical solutions for clients like Coca-Cola (retail), Chi Square Analytics (gaming), and a leading conglomerate in Dubai (retail, fashion, cinema, and finance). He specializes in data modeling, ETL, data warehousing, business reporting, and advanced analytics. Goutham is currently working on tools like Azure Databricks, Spark, Azure Data Factory, Microsoft SQL Server, Microsoft Power BI, and SSIS.

Availability

Part-time

Preferred Environment

Visual Studio, Python, SSAS, SQL Server Integration Services (SSIS), Microsoft Power BI, Microsoft SQL Server, Azure Databricks, Azure Data Factory, Azure Data Lake

The most amazing...

...thing I've recently developed is a recommendation engine based on collaborative filtering that gives tailor-made recommendations for every customer.

Work Experience

Manager Analtyics & Data Engineering

2022 - PRESENT
Hyper Market Retailer from Middle east
  • Developed a highly scalable and optimized data warehouse solution on Azure from the ground up for driving customer analytics, commercial insights, and human capital analytics across 20+ countries.
  • Created a one-of-a-kind Microsoft Power BI solution enabling businesses to analyze 10 billion records. This solution provided a detailed understanding of customers and products.
  • Developed various customer analytics solutions, including customer segmentations, stratification algorithms, and marketing impact measurement across 20+ countries.
Technologies: Microsoft Power BI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory, Spark SQL, Customer Loyalty, Data Engineering, Databricks, Azure Synapse, Data Management

Power BI Developer

2021 - 2022
Visual Data Media Services Limited
  • Developed end-to-end Power BI platform for the business.
  • Implemented several API data integrations for reporting.
  • Launched complex finance reports with accruals, sales projections, and other KPI preparations for over 1,000 customers.
Technologies: Microsoft Power BI, ODBC, FileMaker, MySQL, Microsoft SQL Server, Data Analytics, Dashboards, CSV File Processing, Data Transformation, Dashboard Design, Data Management

Data Engineer and Analyst

2017 - 2022
Retail Conglomerate in Dubai
  • Collaborated with a team of three to develop a Power BI platform tracking over 5,000 KPIs across 200+ reports, managing over 5 TB of ERP data.
  • Engineered complex ETL processes and reporting aggregations, handling 2 billion records.
  • Developed dashboards with insights, combo identification with advanced SQL, NPS, cinemas F&B analysis, leasing analysis, investment analysis, etc.
  • Developed applications like market basket analysis, time series forecasting, recommendation system based on MBA and collaborative filtering, markdown optimization, predictive out-of-stock, inter-branch transfer, and sales forecasting.
  • Spearheaded the development of a one of its kind IFRS reporting for complex VAT reconciliation and VAT filing for over 100 ERP company entities.
Technologies: Python, TimeXtender, SSAS, SQL Server Integration Services (SSIS), Microsoft Power BI, Microsoft SQL Server, Data Analytics, Dashboards, CSV File Processing, Data Transformation, Dashboard Design, APIs, Data Management

Senior Data Engineer

2017 - 2017
Chi-Square Analytics
  • Developed customer behavior analysis over 300 million records on an online gaming and betting platform.
  • Developed customer segmentation based on monitory and campaign personalization and customer RFM models.
  • Tracked all the BI issues and fixed them using the ServiceNow tool.
Technologies: Microsoft Power BI, SSAS, SQL Server Integration Services (SSIS), Scala, Spark, Teradata, Microsoft SQL Server, Data Analytics, Dashboards, CSV File Processing, Data Transformation, Dashboard Design, APIs, Data Management

Senior Software Engineer

2013 - 2016
Capgemini India
  • Developed a BI solution to track and intensify the performance of around 1 million outlets and business sales executives across Australia for a leading soft drinks firm.
  • Developed a global Business Intelligence solution for daily sales and bottling production for all the brands in a leading bottling company.
  • Provided level-3 tech support for a global BI solution responsible for bottling production and distribution across North America and the Asia Pacific region.
Technologies: Microsoft Power BI, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Data Analytics, Dashboards, CSV File Processing, Data Transformation, Dashboard Design, APIs, Data Management

Product Recommendation System for a Retail Firm

A Middle East-based home furniture firm has recently ventured into an online presence. For effective marketing campaigns, I have developed a recommendation solution using collaborative filtering (a technique used by most online streaming providers like Netflix and Amazon) and complex descriptive analytics. This gives the most suitable product recommendations for each customer individually based on their purchase pattern.

Data Warehouse and Power BI Set Up for a Leading Media Company

Developed the financial dashboards for a media services company specializing in media inventory services for globally renowned OTT platforms such as Netflix, Disney Plus, and others. I've fully automated the data flow using Python, Azure VMs, and PostgreSQL, optimizing available resources.

The setup includes seamless integration with leading OTT platforms, allowing us to directly access detailed data from sources like Netflix. This enhances our workflow, enabling us to manage the quality of deliveries more effectively.

The financial dashboards provede a comprehensive overview of critical metrics, including total revenue and accruals. The forward-thinking approach ensured efficiency and accuracy in data processing. To further enhance their operations, we prioritized security and compliance, scalability for future growth, robust monitoring and alerting systems, and thorough documentation of our data engineering processes and integrations.

Languages

T-SQL (Transact-SQL), SQL, Python 3, Python, Scala

Tools

Microsoft Power BI, Microsoft Excel, SSAS, Visual Studio, FileMaker, Spark SQL

Paradigms

ETL, Business Intelligence (BI), Database Design, Database Development, ETL Implementation & Design, Data Science

Platforms

Databricks, Azure Synapse, TimeXtender, Azure, Azure Synapse Analytics

Storage

SQL Server 2016, SQL Server Integration Services (SSIS), Database Modeling, MySQL, PostgreSQL, SQL Server Analysis Services (SSAS), Microsoft SQL Server, SQL Server Reporting Services (SSRS), Teradata

Other

Data Warehousing, Business Reporting, BI Reports, Data Marts, Data, Data Visualization, Data Modeling, Complex Data Analysis, Data Analysis, Query Optimization, Data Engineering, Data Aggregation, Data Warehouse Design, Data Analytics, Dashboards, CSV File Processing, Data Transformation, Dashboard Design, Azure Databricks, Data Management, DAX, Performance Tuning, APIs, Azure Data Factory, Azure Data Lake, Customer Loyalty, Electronics

Frameworks

Spark

Libraries/APIs

ODBC

2019 - 2020

Postgraduate Diploma in Data Science

International Institute of Informational Technology - Bangolore, India

2009 - 2013

Bachelor's Degree in Electrical and Electronics

National Institute of Technology - Hamirpur, India

MAY 2020 - PRESENT

Statistics and Exploratory Data Analysis

International Institute of Information Technology, Bangalore

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring