Akshay Netalkar
Senior Data Analyst
Dubai
Summary
Seasoned data professional with a demonstrated history of crafting and executing impactful data science and analytics strategies, driving business growth, and elevating decision-making processes. Actively seeking roles to apply expertise in data science, management, analytics, and strategy.
Overview
11
11
years of professional experience
5
5
years of post-secondary education
3
3
Certifications
Work History
Senior Data Analyst
FirstScreen
08.2022 - 04.2023
- Subscriber Dashboard: Developed advanced Subscriber dashboard leveraging Power BI, integrating data sourced from diverse MS SQL databases. Employed DAX for intricate data transformations and calculations, complemented by SQL queries for deeper insights. This comprehensive solution accommodated 80 carriers across various regions, furnishing valuable business intelligence to management.
- Sales Manager Performance Dashboard: Crafted sophisticated Power BI dashboard offering insights into active carrier count per sales manager, alongside their aggregated revenue, incorporating crucial metrics such as Lifetime Value (LTV) and Cost Per Acquisition (CPA).
- African Carriers Billing Log Analysis: Conducted meticulous analysis of billing logs from African carriers spanning previous three months, identifying causes for unsubscribers and failed billing transactions. By optimizing billing processes, this initiative orchestrated impressive 18% surge in subscriber count and billing efficiency.
- Monthly Revenue Analysis: Performed in-depth comparison of financial data sourced from the finance department in Excel format and existing data within CUBE using Power BI. This facilitated comprehensive monthly revenue analysis, enhancing financial insights.
Senior Data Analyst (Power BI, SQL and Yardi)
Nakheel
06.2021 - 07.2022
- Tenant Analysis (Sales & Rent) and Comparison: Analyzed POS data from Retail Green and Yardi (ERP) to compare the sales and present timely reports. This report provided clear information related to best/worst performing tenants giving management deep insights for future leasing practices.
- Malls Leasing Revenue Forecast vs Budget: The dashboard meticulously compared leasing revenue projections to budgeted targets, harnessing PowerBI for dynamic visualizations, SQL for seamless data integration, and DAX for precise performance variance calculations.
- Future Tenant Leasing Pipelines by Malls: Tracked upcoming tenant leasing opportunities across malls, integrating current tenant data to provide forecasts for the next 3 to 6 months, facilitating decision-making.
- Leasing Performance Dashboard: Highlighted key leasing metrics but also utilized multilinear regression to rank leasing managers based on their performance against these metrics, enabling targeted performance improvement initiatives and maximizing leasing efficiency.
- Internal Process Enhancement Analysis: Identified workflow inefficiencies, enabling process streamlining and faster leasing to tenants, ultimately driving revenue growth for the organization.
- DragonMart Online Sales and E-commerce Dashboard: Developed a Power BI dashboard for DragonMart's online sales and e-commerce operations, integrating data from SQL databases. Provided real-time insights into sales performance and customer behaviour.
- Nakheel Digital Dashboard: Developed a Nakheel Digital Dashboard leveraging Power BI and Google BigQuery, utilizing DAX measures to analyze Facebook and Instagram data, distinguishing between organic and non-organic posts.
Data Analyst
Saal.ai
06.2019 - 06.2021
- COVID Dashboard with Location and Vaccination on Spatial Map: The COVID-19 Dashboard integrates Tableau's dynamic visualization with SQL database management, optimizing queries for efficiency. This reduced manual reporting efforts by 10 hours per week and enhanced data-driven decision-making processes.
- POCs: Abu Dhabi Municipality (Tableau), Dental Analysis Dashboard (Tableau) and ADNOC (Power BI)
- Tableau Server Administration: Managed user access, permissions, and data connections for secure data visualization deployment. I conducted backups and performed software upgrades to optimize performance and ensure smooth operation of the Tableau Server platform.
Senior BI Consultant (Tableau & SQL Server - Contract)
Nissan
03.2018 - 06.2019
- Car Sales, Market Share vs Budget Dashboard: Tracked car sales against budgeted targets and market share goals, providing actionable insights for decision-making and strategy optimization.
- Nissan Car Sales by Grade and Comparison with Budget: Tracked Nissan car sales by grade and compared them with budgeted targets. It provided detailed insights into sales performance.
- AMI HR Dashboard: Provided comprehensive insights into HR metrics and key performance indicators at AMI. It facilitated data-driven decision-making by presenting information on employee demographics, recruitment, retention.
- VIN Analysis: Implemented a VIN reporting dashboard in Tableau by integrating data from Salesforces and Excel into SQL Server. This meticulously tracked incentives per model with National Sales Companies (NSCs), highlighting and reducing the Sales incentives paid by Nissan.
- Tableau Server Administration (Similar to Saal.ai)
Senior BI Consultant
Edgematics
12.2014 - 02.2018
- Nissan Data Migration: Migrated data from Oracle to SQL Server using ERWIN for data modelling and schema mapping and transformation.
- ADGSEC Tableau Server Installation and Project Management: Implemented a robust 3-node Tableau Server installation seamlessly integrated with F5, while assuming a pivotal role in project management and ongoing support.
- Kudu: Developed Tableau dashboards including Like-for-Like sales, Saudization, and HR employee metrics. Implemented a robust data layer through materialized views.
- MAF Credit Cards/Loan: Worked as a junior resource on MAF Credit Cards/Loan data integration, utilizing Informatica and SQL to optimize data pipelines for efficiency and accuracy.
- Presales Activities: Managed presales for Tableau and data solutions, assessing needs, demoing capabilities, and tailored proposals. Addressed queries, collaborated on proposals, conducted Tableau training, and crafted RFP responses, showcasing effectiveness with POC projects for various clients.
- Al Fakher Tobacco: Created a dashboard for the C-suite to compare leasing revenue projections to budgeted targets, leveraging QlikView's dynamic visualizations and data modelling capabilities for seamless data integration.
PLSQL Developer
Capgemini
07.2012 - 11.2014
- Deutsche Telekom: Crafted comprehensive technical specification documents and developed or modified applications employing PLSQL scripts. Utilized ClearCase in a Unix environment to manage code updates across development, testing, and production environments. Leveraged ticketing tools like JIRA to efficiently resolve and log defects.
Education
Master of Science - AI - Architecture, Design, And Implementation
Georgian College
ON, Canada 05.2023 - 01.2024
Executive PG - Data Science
IIITB
Bangalore, India 06.2021 - 06.2022
Bachelor of Science - Computer Engineering
University of Pune
Pune, India 08.2007 - 05.2011
Skills
Teamwork, Stakeholder Engagement, Business Intelligence, Data Warehousing, Project Management, Requirement gathering, Advanced analytics, Documentation, KPI Tracking, Workflow Analysis, Process Improvement
Business Intelligence: Tableau, Power BI, Data Studio and Excel
DB: Oracle Server, SQL Server and Azure SQL
Programming Languages: Python and SQL
ETL: Informatica, SSIS and Azure Data Factory
Machine Learning: Linear Regression, Logistic Regression, Random Forest, SVM, Neural Networks, PCA, K-Means Clustering
Deep Learning: Keras, PyTorch, CNN and Multilayer Perceptron Model
AutoML: TPOT and MLJAR
Cloud Computing: Azure
Certification
Tableau Certified 10,9 Desktop Associate (Tableau)
Timeline
Master of Science - AI - Architecture, Design, And Implementation
Georgian College
05.2023 - 01.2024
Senior Data Analyst
FirstScreen
08.2022 - 04.2023
Executive PG - Data Science
IIITB
06.2021 - 06.2022
Senior Data Analyst (Power BI, SQL and Yardi)
Nakheel
06.2021 - 07.2022
Data Analyst
Saal.ai
06.2019 - 06.2021
Senior BI Consultant (Tableau & SQL Server - Contract)
Nissan
03.2018 - 06.2019
Senior BI Consultant
Edgematics
12.2014 - 02.2018
PLSQL Developer
Capgemini
07.2012 - 11.2014
Bachelor of Science - Computer Engineering
University of Pune
08.2007 - 05.2011