YASH SINGH
Pune
Summary
Experienced Data Analyst with over 4 years in telecom expense management, skilled in optimizing telecom spend and vendor negotiations. Proficient in Python, SQL, Excel, and visualization tools like Power BI and Tableau, known for streamlining reporting processes and identifying cost-saving opportunities. Proven track record in maintaining financial accuracy and enhancing operational efficiency through detailed data analysis.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Internal Auditor
Tangoe
Banglore
05.2024 - Current
- Analyzed telecom data to generate actionable insights, and optimize costs.
- Utilized analytical tools such as Excel, SQL, and Tableau to extract, cleanse, and visualize data, enabling effective decision-making and operational optimization.
- Led audits to ensure compliance with contract terms, contributing to significant cost savings.
- Conducted root cause analysis on billing discrepancies and presented findings to senior management, resulting in over $1 million in savings with four clients.
- Implemented basic forecasting models in Python to predict future telecom costs based on historical data trends and usage patterns, aiding in budget planning.
Senior Data Analyst - Optimization
Sakon
Pune
06.2021 - 05.2024
- Interpret and analyze the telecom data to identify key metrics, and transform raw data into meaningful and actionable insights.
- Facilitated communication with U.S. customers as the main point of contact, enhancing client relationships.
- Update and retrieve data by executing SQL.
- Processed and analyzed large datasets of telecom usage and expenses, identifying trends and anomalies to optimize costs.
- Employ Power BI (DAX) best practices formulating reports and created Power BI dashboards improving KPI by 30%
- Utilized SQL to efficiently extract and analyze data, improving data retrieval processes.
Process Associate
Smith & Nephew - India
India
11.2018 - 01.2020
- Managed the processing, distribution, accuracy verification, and maintenance of invoices, interfacing with UK and US vendors using SAP, IDMS, Ariba, Lotus Notes, and WinShuttle
- Created, changed, extended, and blocked vendors in SAP for UK and US
- Checked and audited travel and expense claims in SAP, Lotus Notes, and Ariba according to company policy
- Raised and modified vendor requests using Global Business Services tools
- Analyzed and evaluated potential errors before approving setup requests
- Participated in KPMG audits and contract analysis for reconciliation of customer accounts.
Accounts Payable Analyst
Metro Global Business Services - India
India
12.2016 - 09.2018
- Verified and processed up to 1,200 invoices per month in SAP, ensuring accuracy and timely processing
- Resolved accounts payable queries with vendors and collaborated on invoice errors, maintaining a strong customer service reputation
- Achieved a 20% improvement in processing targets by effectively utilizing SAP for accounts payable
Intern
Larsen & Toubro Ltd
Lucknow
05.2016 - 06.2016
- Handled Working Capital calculations and developed comprehensive MIS.
Education
MBA - Accounting & Finance
Singhad Institute Of Management
Pune2017
BBA -
St. Aloysius College
Jabalpur2015
Skills
Technical skills
- Python (Pandas, NumPy)
- R
- SQL (MySQL, PostgreSQL)
- Tableau
- Power BI
- Data Transformation
Analytical skills
- Cost Optimization & Trend Analysis
- Quantitative analysis
- Project Management
- Attention to detail
- Decision making
- Data visualization
- Vendor Management
- Financial Analysis
- Communication Skills
Projects
PwC Switzerland Power BI Job Simulation on Forage
Client - PwC
Skills: Power BI, DAX
- Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualisation needs.
- Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.
- Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.
- Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.
App Rating Prediction
Client - Google Play Store
Skills: Python (Programming Language) · NumPy · pandas
Identified the apps that are going to be good for Google to promote. App ratings, which are provided by the customers, is always a great indicator of the goodness of the app. The problem reduces to: Predict which apps will have high ratings.
Accomplishments
- Received three certificates of appreciation within my first year at Sakon India Pvt. Ltd. for consistency. Extra Mile award & being recognized as the "Star of the Quarter," and delivering exceptional insights to all customers.
- Acknowledged by the client Brookfield Properties for exceptional timeliness and accuracy in data analysis and reporting, receiving recognition within just six months of leading the process.
- Received an award for clearing backlogs in Metro GBS and Smith & Nephew GBS.
- Gave 3 lean ideas for process enhancement.
- Leading the team of 12 members in the savings confirmation process in Sakon to generate maximum savings of $1+ million within due timelines and presenting reports to the leadership.
Certification
1 - Masters Program - Data Analyst : Simplilearn Certified in Collaboration with IBM. - 2024
- Business Analytics with Excel.
- SQL
- Tableau Desktop Specialist Certification
- Data Analytics with Python.
- Data Analytics with R.
- PL-300: Microsoft Power BI
- Data Analyst Capstone
Timeline
Internal Auditor
Tangoe
05.2024 - Current
Senior Data Analyst - Optimization
Sakon
06.2021 - 05.2024
Process Associate
Smith & Nephew - India
11.2018 - 01.2020
Accounts Payable Analyst
Metro Global Business Services - India
12.2016 - 09.2018
Intern
Larsen & Toubro Ltd
05.2016 - 06.2016
MBA - Accounting & Finance
Singhad Institute Of Management
BBA -
St. Aloysius College
Similar Profiles
Stephanie KoskiStephanie Koski
Procurement Specialist/Mobile Order Reconciliation at TangoeProcurement Specialist/Mobile Order Reconciliation at Tangoe
Abby WilmAbby Wilm
Service Delivery Analyst at TangoeService Delivery Analyst at Tangoe
Sarah TuttleSarah Tuttle
Sr. SQL Developer & Data Architect at TangoeSr. SQL Developer & Data Architect at Tangoe