Goutham Dasari
Verified Expert in Engineering
Microsoft Power BI Developer
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.
Portfolio
Experience
- Business Reporting - 7 years
- BI Reports - 7 years
- Data Warehousing - 7 years
- Data Warehouse Design - 7 years
- SQL Server Integration Services (SSIS) - 7 years
- Azure Databricks - 5 years
- Microsoft Power BI - 4 years
- Azure Data Factory (ADF) - 4 years
Availability
Preferred Environment
Visual Studio, Python, SSAS, SQL Server Integration Services (SSIS), Microsoft Power BI, Microsoft SQL Server, Azure Databricks, Azure Data Factory (ADF), 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
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.
Power BI Developer
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.
Data Engineer and Analyst
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.
Senior Data Engineer
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.
Senior Software Engineer
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.
Experience
Product Recommendation System for a Retail Firm
Data Warehouse and Power BI Set Up for a Leading Media Company
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.
Education
Postgraduate Diploma in Data Science
International Institute of Informational Technology - Bangolore, India
Bachelor's Degree in Electrical and Electronics
National Institute of Technology - Hamirpur, India
Certifications
Statistics and Exploratory Data Analysis
International Institute of Information Technology, Bangalore
Skills
Libraries/APIs
Power BI REST APIs, Pandas, ODBC
Tools
Microsoft Power BI, Microsoft Excel, Git, SSAS, Visual Studio, FileMaker, Spark SQL
Languages
T-SQL (Transact-SQL), SQL, Python, Python 3, Scala
Paradigms
ETL, Business Intelligence (BI), Database Design, Database Development, ETL Implementation & Design, Requirements Analysis
Platforms
Azure, Databricks, Azure Synapse, TimeXtender, Azure Synapse Analytics
Storage
SQL Server 2016, SQL Server Integration Services (SSIS), Database Modeling, Data Pipelines, SQL Stored Procedures, MySQL, PostgreSQL, SQL Server Analysis Services (SSAS), Microsoft SQL Server, SQL Server Reporting Services (SSRS), Teradata
Frameworks
Spark
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, Analytical Thinking, Business Requirements, Data Architecture, Reporting, Troubleshooting, IT Support, Debugging, DAX, Performance Tuning, APIs, Data Governance, OAuth, Data Science, Azure Data Factory (ADF), Azure Data Lake, Customer Loyalty, Electronics
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring