Microsoft Excel
Ellis Capuyan
Commercial Analyst
Macquarie Park,NSW
Summary
As a highly motivated Commercial Analyst with over three years of experience, I have a proven track record of providing financial and commercial insights to support strategic decision-making for businesses in various sectors. I have developed a keen understanding of the retail, delivery, and managed services sectors while working for leading companies such as 4WD Supacentre, Sherpa Delivery, and NTT Ltd.
My proficiency in SQL, Looker, and Excel allows me to analyze large and complex data sets, generate insightful reports, and optimize the profitability and performance of products and services. I have a strong commercial and pricing analysis background, having worked on several multi-million dollar deals, developing and maintaining robust financial models, providing price recommendations, and assisting in contract negotiations and due diligence.
I am passionate about learning and applying new skills to solve real-world problems. My ability to work effectively in a team environment and maintain a high level of professionalism has enabled me to excel in every role I have held.
I am Seeking to leverage my expertise in a challenging role as a Commercial Analyst, Senior Pricing Analyst, Pricing Lead, or Business Performance Manager.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
2
2
Certifications
Work History
Commercial Analyst
4WD Supacentre
06.2023 - Current
- Utilizing SQL within BigQuery for sophisticated data analysis to enhance margin performance and drive strategic initiatives. Expertly creating comprehensive reports using Looker, focusing on analyzing wholesale market trends and optimizing product mix strategies for informed decision-making
- Expertly designing and delivering reports using Looker Studio, presenting complex data in a user-friendly format for executives and staff, and facilitating informed business decisions.
- Collaborating closely with the marketing department, ensuring expenditures align with the company's financial goals and integrating their insights into pricing and margin analysis.
- Playing a pivotal role in liaising with the marketing team, gathering critical data to understand fluctuations in profit margins during specific periods.
- Assisting the financial planning manager in maintaining the financial budget and forecast.
Pricing Analyst
Sherpa Delivery
05.2022 - 05.2023
- Ensuring financial integrity and accuracy in complex tendered solutions, aligning with senior management directives and providing financial advice for tenders to Proposal Leads and Senior Management.
- Developing and managing advanced price modelling and estimating tools, contributing to pricing strategies and decision-making processes.
- Recommending pricing strategies and guardrails for deals, utilizing robust Excel models to optimize price and margin opportunities.
- Pioneering improved pricing concepts, translating innovative visions into practical, sustainable strategies across various business functions.
- Analyzing large datasets using SQL and BI Tools to produce valuable commercial and financial reports and actively participating in client meetings and deal negotiations.
Commercial & Pricing Analyst
NTT Ltd.
11.2020 - 04.2022
- Providing financial planning, costing and commercial due diligence support to the Managed Services business as part of sales proposals for submission to clients
- Ensuring that client proposals and contracts incorporate necessary terms and conditions for optimal commercial and financial engagements
- Assisting or participating in the negotiation of deals with clients
- Assisting with the performance of detailed commercial contractual and financial analysis on existing clients and complex sales opportunities
- Engaging with and leveraging off the relationships between NTT and vendors or subcontractors and strategic alliances, including the Legal Team during the conception, construction and review of client proposals, soliciting information and escalating queries
Education
BBA - Business Administration And Management, Finance
S P Jain School of Global Management
Sydney 04.2015 - 01.2020
Skills
KPI Reportingundefined
Websites
Certification
The Complete Financial Analyst Course - Udemy, UC-68d3a2d7-bf80-4ecf-956b-4f0aebff041b
Software
Power Query
SQL
Looker
Tableau
Timeline
Commercial Analyst
4WD Supacentre
06.2023 - Current
Pricing Analyst
Sherpa Delivery
05.2022 - 05.2023
Commercial & Pricing Analyst
NTT Ltd.
11.2020 - 04.2022
BBA - Business Administration And Management, Finance
S P Jain School of Global Management
04.2015 - 01.2020
Similar Profiles
Jeanette RhodesJeanette Rhodes
Retail Sales Representative at 4wd supacentreRetail Sales Representative at 4wd supacentre
Hayden GreenHayden Green
Customer Service/ Sales Member at 4wd supacentreCustomer Service/ Sales Member at 4wd supacentre
Derek MassieDerek Massie
Retail Sales Associate at 4wd SupacentreRetail Sales Associate at 4wd Supacentre