Vijay Waghmare
Data Analyst at New Aim Pty Ltd- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
UGC NET
UGC NETJan, 2019- Nov, 2024 -
Equity research modul from NSE
National Stock Exchange of India LimitedJun, 2012- Nov, 2024 -
Investment advisor
National Institute of Securities Markets (NISM)Nov, 2017- Nov, 2024
Experience
-
New Aim
-
Australia
-
Retail
-
100 - 200 Employee
-
Data Analyst
-
Jan 2022 - Present
• Transformed marketplace data into rich and actionable insights for stakeholders to decide on competitive products pricing and promotions. • Collaborated and worked cross-functionally to define problem statements, collect data from multiple marketplaces, build analytical models, and make recommendation to increase product listings market share on first page of respective marketplace. • Created ETL pipeline to extract data from multiple marketplaces and APIs using Python and Azure SQL. • Created ETL pipeline to extract data from Jira API, built PowerBI dashboard for IT managers to enhance operational and staffing decisions. • Developed business and operational KPI’s for Executive Leadership Team and Department Heads to guide strategic and operational decisions. • Created analytical and interactive reports for inventory quantity and dollar value for buying team to make informed purchase orders to vendors. • Created actionable insights for product QC team to report faulty products and related loss to vendors/suppliers. • Performed simulations using Python, MS Excel, SQL, Databricks to optimize shipping cost by analysing multiple carriers rate card. • Worked on BAU/ADHOC requests from various stakeholders and troubleshooting failure of ETL pipeline. • Provided inputs to stakeholders using experience gained as retail customer service associate and warehouse associate.
-
-
-
Probe CX
-
Australia
-
Outsourcing and Offshoring Consulting
-
700 & Above Employee
-
Customer Service Associate
-
Sep 2021 - Jan 2022
Answering/resolving customer queries/issues related to reward cards and promotions for a retail chain in Melbourne. Answering/resolving customer queries/issues related to reward cards and promotions for a retail chain in Melbourne.
-
-
-
lululemon
-
Canada
-
Retail
-
700 & Above Employee
-
Casual Warehouse Assistant
-
May 2021 - Sep 2021
Picking products from isles as per the task sheet and stack on pallets. Picking products from isles as per the task sheet and stack on pallets.
-
-
-
Deakin University
-
Australia
-
Higher Education
-
700 & Above Employee
-
Casual Data Analyst
-
Dec 2020 - May 2021
Responsibilities: 1. Conduct literature review on signal processing, time series classification using machine learning/deep learning algorithms. 2. Implement statistical / mathematical techniques using Python for feature extraction from collected accelerometer signal captured while performing physical activities. 3. Design and implement machine learning / deep learning models using Python to classify fatigue level reported by participants while performing physical activities. 4. Draft thesis and research report. 5. Co-ordinate and provide progress report on research to various stakeholders. Achievements: 1. Developed human activity recognition model for three activities in workplace using Linear Discriminant Analysis with ROC of 98% for two activities and 96% for third activity as a part of research. 2. Developed machine learning model for multi-class time series classification problem which reduced MAE to 1.33 from MAE of 2.16 achieved by original research paper on unseen data. 3. Developed machine learning model for time series binary classification problem which achieved sensitivity and specificity to 92% on unseen data. Outperformed original research paper which achieved 65% and 70% respectively on unseen data.
-
-
-
-
Data Analyst
-
May 2018 - Dec 2020
Responsibilities: 1. Liaise with principal consultants on finalising analytical solution provided to clients. 2. Liaise with client to finalize project requirement and available resources. 3. Assist in identifying and collecting data from financial systems and other related data sources. 4. Assist in assessing and determining the techniques and tools to be used in collection, analysis, and communication for a project. 5. Apply selected analytical techniques and tools to achieve project outcomes. 6. Extracting and analysing data from complex financial data sets from SQL database and presenting key business performance metrics to stakeholders using excel/Tableau dashboard. Achievements: 1. Developed integrated and interactive “Borrower’s Risk Rating Model” for working capital loan in MS Excel using VBA macros for service, manufacturing, and trading industry for a PAN ASIA Bank, Sri Lanka. Extracted financial statements using SQL ETL and VBA macros followed by model till risk rating. Reduced default and operational risk due to automation. Received appreciation on email from CEO of the bank. 2. Developed project financial feasibility for start-ups with Sensitivity analysis and Monte Carlo simulation in MS Excel using VBA for a leading bank in Nepal. 3. Developed machine learning model to predict personal loans and credit card defaults. 4. Automated MIS for bank loans using SQL queries and Power BI dashboard. 5. Developed product wise customer sentiment analysis based on feedback provided by customers on various services. SQL ETL/ELT pipeline was used for data extraction, cleansing, wrangling and Python was used to perform NLP and LDA analysis.
-
-
-
-
Deputy Manager
-
Apr 2014 - Sep 2016
Responsibilities:1. Manage team size of 50 people performing trade settlements and cash reconciliation for mutual funds, bond funds, super funds across APAC region including Australia.2. Perform operational and process analysis to proactively identify staffing and operational issues. Liaise with multiple stakeholders to resolve potential operational risks.3. Contribute towards process improvement via creative thinking and analytical skills.4. Design and present operational MIS and routine reports using dashboard to various internal stakeholders including onshore team.5. Documenting/updating SOP and seeking approval various stakeholders.6. Achieve agreed SLA and operational cost targets.
-
-
Team Leader KPO operations
-
Jun 2011 - Mar 2014
Responsibilities:1. Training and providing feedback to team members on product knowledge.2. Prioritizing processing and work allocation for optimum utilization of available manhours.3. Maintain MIS and reports for all stakeholders.4. Achieve SLA and processing time per transaction targets.
-
-
-
Suma Soft Pvt Ltd
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
Assistant Manager BPO Operations
-
Nov 2008 - Jan 2011
Responsibilities:1. Manage team size of 10 to 100 people process across auto finance, and logistic domain for leading US based companies.2. Perform operational and process analysis to proactively identify staffing and operational issues. Liaise with multiple stakeholders to resolve potential operational risks.3. Contribute towards process improvement via creative thinking and analytical skills.4. Design and present operational MIS and routine reports using dashboard to various internal stakeholders including onshore team.5. Documenting/updating SOP and seeking approval various stakeholders.6. Achieve agreed SLA and operational cost targets.
-
-
Team Leader
-
Nov 2006 - Oct 2008
Responsibilities:1. Demonstrate thorough product and process knowledge.2. Provide training and feedback to team members.3. Provide input on process improvement to manager.4. Maintain MIS, reports and dashboard.
-
-
Customer Support Associate
-
Apr 2004 - Oct 2006
Responsibilities:1. Processing data with required accuracy and speed.2. Demonstrate thorough product knowledge.
-
-
Education
-
2019 - 2020
Deakin University
Master's degree, Data Science -
2016 - 2018
Gokhale Institute of Politics and Economics
Master of Science - MS, Financial Economics -
2010 - 2012
Suryadatta Institute Of Management
PGDBM, Finance
Community
