Waseque Siddiqui
Business Analyst
Mumbai
Summary of Career
1. Creating data extraction and moulding applications using Python and MS-SQL.
2. Generating Insights for business evaluation & Strategic Planning
3. Designing & Optimizing processes used for budgeting & forecasting of sales
4. Creating models for Revenue forecasting using time series forecasting
5. Creating Management reports & dashboards using Advance Excel & Power BI
6. Created data aggregation and data sanitization processes
7. Lead ageing model using linear regression
8. Lead conversion model using Logistic Regression
9. Creating Ad-hoc report for senior management which includes Director, VP, CEO.
10. Macro-Economic Analysis reports of customer preference and market growth
Analyzing and Visualizing Data with Power BI by Microsoft
Data Analysis with Python by IBM
Essential Statistics for Data Analysis using Excel by Microsoft
IELTS BAND SCORE 8
Experience as Manager - Business Intelligence
Sodexo SVC India
01 October 2018
31 May 2020
● Creating data extraction and moulding applications using Python and MS-SQL.
● Generating Insights for business evaluation & Strategic Planning.
● Designing & Optimizing processes used for budgeting & forecasting of sales.
● Creating models for Revenue forecasting using time series forecasting.
● Creating Management reports & dashboards using Advance Excel & Power BI.
● Created data aggregation and sanitization processes.
● Automation of Business as Usual reporting tasks using VBA Macros & Advance excel formula.
● Creating potential revenue and cost analysis of various products and markets.
● Creating and maintaining large Datasets using MS-SQL.
● Creating Realtime dashboards & KPI Reports using Power BI.
● Writing and maintaining macros for process automation.
● Creating Ad-hoc report for senior management which includes Director, VP, CEO.
Experience as Network Planning Analyst
Jet Airways
01 December 2016
31 October 2018
● Creating data extraction and modelling applications using Python and MSSQL.
● Creating models for Revenue, Cost & P&L forecasting using time series forecasting.
● Creating Management reports & dashboards using advanced excel.
● Macro-Economic Analysis reports of customer preference and market growth.
● Conducting Ad-hoc demand supply and demand pricing reports senior management.
● Creating potential revenue and cost analysis of various products and markets.
● Creating and maintaining large Datasets using MS-SQL.
● Creating Realtime dashboards & BCG Reports using Power BI Desktop.
● Writing and maintaining macros for process automation.
● Creating Ad-hoc report for senior management which includes Director, VP, CEO.
● Creating cashflow analysis for existing and proposed markets.
Experience as Management Trainee
Motilal Oswal
01 February 2016
31 August 2016
● Creating Derivative Analysis worksheet for various derivative strategies and automating the calculation of various Greeks associated with the strategy.
● Analysis of processes and creation of process life cycle diagram.
● Creating VBA Macros to automate MIS report analysis.
● Generation of MIS reports using Advanced Excel.
● Analyzing the complete CRM tool Talisma used to log in query for operations department.
● Generating advanced analytics report using Power BI.
Experience as Analyst Programmer
Eclerx services ltd
01 August 2012
01 August 2013
● Creating application for automation of MIS using C# MVC & MS SQL & VBA Macros.
● Creating interactive dashboard for higher management using HighCharts & Advanced Excel.
● Requirement gathering & understanding of the entire operations process for automation of the same.
● Creating and Editing Requirement document.
● Writing unit as well as functional test cases for the processes defined.
Experience as Application Developer
Arshiya Limited
01 February 2011
30 April 2012
● Creating data analysis reports using Advanced Excel.
● Creating application for automation of MIS using C# MS SQL VBA Macros.
● Understanding & Requirement gathering of the entire operations process.
● Creating and Editing Requirement document.
● Writing unit as well as functional test cases for the processes defined.
● Creating interactive dashboard for higher management using fusion charts.
Experience as Trainee Developer
Synergy Tech Services
01 October 2010
01 February 2011
● Creating data analysis reports using Advanced Excel.
● Creating application for automation of those process using C# MVC & MS SQL.
● Understanding & Requirement gathering of the entire operations process.
● Creating and Editing Requirement document.
● Writing unit as well as functional test cases for the processes defined.
● Creating interactive dashboard for higher management using fusion charts.
Bachelor 01 May 2010
B.E. (Electronics & Telecommunication)Matric 01 May 2016
Master of Management Studies (Finance)