Gurpreet Singh Bons
Data Analyst
Dubai,UAE
Summary
To acquire a place in an organization, believes in providing high quality work, challenging assignments, meaningful carrier growth and opportunities for value addition through learning and professional development.
Overview
17
17
years of professional experience
4
4
years of post-secondary education
Work History
Sr. Data Analyst
DA-Desk FZE LLC
Dubai
10.2017 - Current
- Lead cross-functional projects using advanced data modelling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities
- Managed in automating the entire reporting to Power BI by importing data directly from SQL Server. This effective reporting system helped in improvising on communication, productivity, accuracy, and timeliness
- Ingest, Clean, Transform and Model data using M/Power Query and DAX queries
- Build, develop and maintain data models, reporting systems, data automation systems, dashboards and performance metrics support that support key business decisions
- Act as interface between IT development team and business by defining and communicating product requirements and use cases
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action
- Team Management – high personal standards in day-to-day conduct within the team
Data Analyst
S5 Agency World India Pvt. Ltd
Mumbai
10.2015 - 10.2017
- Catered various stakeholders including S5’s Global Regions, Global Hub (Mumbai and Rotterdam), Key account managers, VP sales, VP Hub and all Global Clients
- Primary responsibility in extracting and collating meaningful data from various sources to prepare customized reports and dashboards for extensive Clienteles
- Created weekly/monthly/yearly performance summary for Global Operations and Finance Hubs along with identifying trends and providing process improvements inputs
- Liaising with Agency system development team in ratification of data and ensuring maximum accuracy in data extracted from system before it’s been shared with various stakeholders
Supply Chain Analyst
Maersk Global Service Centres Pvt. Ltd
Mumbai
02.2012 - 10.2015
- Own and drive database creation and maintenance to optimize Supply Chain Development Management processes
- Analyze end-to-end global supply chain of clients for potential cost saving opportunities
- Perform Origin Consolidation analysis, Multi Country Consolidation, Port Rationalization, Load Optimization & network Optimization analysis
- Develop and produce user friendly Dashboards using VBA for each region to view sales pipeline with easy navigation and drilled down information from Country level to User level
- Work closely with counterparts across regions to improve data quality of CRM database by developing VBA projects for each region
MIS Executive
Siemens IT Solutions Pvt. Ltd
Mumbai
08.2010 - 01.2012
- Understand and analyze automation opportunities and provide VBA solutions using various components of Excel and Outlook Object Model
- Prepare Weekly review project performance presentation to discuss with project managers and community leads across India for improvisation of productivity and billability of consultants
- Analyze data received from various ticketing tools and co-ordinate with project managers with reports for any enhancements
- Integrate Error handling to log errors and notify users
MIS Executive
Sitel India Ltd
09.2006 - 05.2010
- Be vigilant while these reports are running and resolve any run-time errors when macros are running and report them to Edinburgh MI Team
- Developed VBA programs to connect to Business Object tool and extract billing reports in excel format, update and consolidate in one single excel file
Customer Service Professional
Sitel India Ltd
09.2004 - 08.2006
Education
Post Graduate Degree - Data Science
IIIT Bangalore
India 07.2019 - 08.2020
Bachelor of Science - Physics
University of Mumbai
04.2000 - 03.2003
Skills
Power BI
SQL
Python
Excel VBA
Google Analytics
CRM
Timeline
Post Graduate Degree - Data Science
IIIT Bangalore
07.2019 - 08.2020
Sr. Data Analyst
DA-Desk FZE LLC
10.2017 - Current
Data Analyst
S5 Agency World India Pvt. Ltd
10.2015 - 10.2017
Supply Chain Analyst
Maersk Global Service Centres Pvt. Ltd
02.2012 - 10.2015
MIS Executive
Siemens IT Solutions Pvt. Ltd
08.2010 - 01.2012
MIS Executive
Sitel India Ltd
09.2006 - 05.2010
Customer Service Professional
Sitel India Ltd
09.2004 - 08.2006
Bachelor of Science - Physics
University of Mumbai
04.2000 - 03.2003