Sergio Antonio Mancillas Carrillo
Zapopan
Summary
Experienced Senior Financial Analyst with 12+ years of expertise in Financial Planning, Reporting, and Consolidating. Skilled in transforming financial data into actionable business insights, driving profitability and business growth. Proficient in forecasting, budgeting, and identifying trends and variances. Demonstrated leadership in leading cross-cultural teams to foster engagement, efficiency, and continuous improvement.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior Financial Analyst and Pricing Specialist
Continuum Global Solutions
08.2022 - Current
- Build pricing cases for new deals and renovations seeking to fulfill client requirements, whileensuring company's profit and competitiveness objectives are met
- Calculate and compare the financial impact of the alternative pricing strategies and billing formats
- Coordinate collaboration and communication between IT, Real State, Recruiting, Operations and
- Finance functions to validate inputs and data assumptions for the modeling process.
Worldwide Revenue and Gross Profit Consolidator
IBM
04.2018 - 12.2021
- Build Signings, Revenue and GP Reports in a Weekly, Monthly and Quarterly basis by Industry/Sector level.
- Lead and supervise the world-wide quarterly planning process for all Strategic accounts
- Coordinate an international team of seven analysts through multiple rounds of budget and planning cycles
- Provide Quarter End Attainment reports for executives on both Strategic accounts and Industries, which were part of IBM Consulting Earnings Release presentation
- Provide and load into trusted sources the financial data used by the strategy team to measure project executives' performance and calculate sales commissions
- Facilitate communication and collaboration among Finance Leaders, Strategy team and Partners Scorecard's owner.
- Continuous improvement of reports, by implementing VBA Macro, SQL language and SPSS tool.
Learning & Skills Enablement Focal
IBM
02.2018 - 02.2020
- Coordinate and oversee education program for Finance Center with a population of 160 resources
- Prepare quarterly agenda and full year plan ensuring to incorporate relevant and valuable topics oriented to develop technical and soft skills
- Measure client satisfaction regarding courses content and facilitators through NPS survey
- Develop action plan to improve metrics
- Present agenda, metrics and highlights to local management, the WW education coordinator and Finance transformation Vice president.
Cost FP&A Team Leader
IBM
04.2017 - 04.2018
- Lead and support a team of 8 Financial Analysts on their tasks and performance
- Pursue engagement and commitment among team members to generate a good working environment aiming to reduce rotation and attrition
- Measure team performance based on feedback from clients and internal metrics
- Provide guidance in establishing action plans to meet individual, team and organization goals
- Ensure that the on-boarding processes, transitions and day to day activities were completed effectively
- Consolidate quarter end results and present data for different levels of management
- Calculate Revenue under warranty accrual for WW sales of IBM Servers.
Revenue and Cost FP&A Team Leader
IBM
10.2015 - 04.2017
- Lead and guide a team of 17 financial analysts in their monthly activities and deliverables
- (Revenue, Cost and Invoicing) - Coordinate automated forecasting process using SPSS tool for +80 clients
- Promote team work and keep team members motivated to achieve common goals
- Facilitate on-boarding process for new hires & Monitor and manage workload - Evaluate team performance based on results and feedback from clients and define objectives and action plans
- Provide the resources to develop technical, financial and communication skills of the team
- Seek and provide resolution of escalated situations affecting client and team members
Revenue and Cost Analyst
IBM
10.2011 - 09.2015
- Consolidate, analyze and report financial information related to revenue, cost, GP, budget and targets during month close
- Analyze historical data and current scenarios to provide forecast for current and oncoming quarters performance
- Identify opportunities and actions to increase gross profit and achieve target metrics
- Coordinate client invoicing process and cash application of payment within different Lines of Business
- Present financial monthly results to account's Project Executive and Financial Manager
Education
Bachelor's degree - Financial Management
Instituto Tecnológico De Estudios Superiores De Monterrey
05-2011
Graduate Certificate - International Business
University of British Columbia
Vancouver, Canada12-2009
High School Diploma -
Henirich-Mann Gymnasium
Cologne, Germany08-2005
Skills
- Financial Analysis
- Financial Planning
- Forecasting & Budgeting
- Pricing
- Teamwork
- Leadership
- Customer Service
- Conflict resolution
- Effective Communication
- Emotional intelligence
- Cultural Awareness
- Excel
- Microsoft Office
- SQL
- SPSS
- LSS
- Agile Practices
- Trello
- Slack
Languages
Certification
- Six Sigma Certification - Yellow Belt
- Trusted Business Advisor
- Soft Skills Course. Developer & Facilitator
Timeline
Senior Financial Analyst and Pricing Specialist
Continuum Global Solutions
08.2022 - Current
Worldwide Revenue and Gross Profit Consolidator
IBM
04.2018 - 12.2021
Learning & Skills Enablement Focal
IBM
02.2018 - 02.2020
Cost FP&A Team Leader
IBM
04.2017 - 04.2018
Revenue and Cost FP&A Team Leader
IBM
10.2015 - 04.2017
Revenue and Cost Analyst
IBM
10.2011 - 09.2015
Bachelor's degree - Financial Management
Instituto Tecnológico De Estudios Superiores De Monterrey
Graduate Certificate - International Business
University of British Columbia
High School Diploma -
Henirich-Mann Gymnasium
Similar Profiles
Ja'Davien PoseyJa'Davien Posey
Customer Service Representative at Continuum Global SolutionsCustomer Service Representative at Continuum Global Solutions
Erin BurketErin Burket
Customer Service Representative at Continuum Global SolutionsCustomer Service Representative at Continuum Global Solutions
Janadia butlerJanadia butler
Customer Service & Sales Representative at Continuum Global SolutionsCustomer Service & Sales Representative at Continuum Global Solutions