Professional Experience - Phillip Morris International

About the Company

Phillip Morris International (PMI) is one of the world’s largest tobacco companies, with a global presence and a diversified portfolio of brands. The company is undergoing transformation, focusing on reduced-risk products and innovation.

Business Segments

• Tobacco industry
• Reduced-risk products
• Trade marketing
• Sales and distribution

Main Activities

• Manufacturing and distributing tobacco products
• Trade marketing and promotions
• Customer relationship management
• Sales and market analysis

Role and Period

• Role: Apprentice - Analytics / Salesforce
• Period: October 2018 - October 2019
• Duration: 1 year
• Location: Rio de Janeiro, RJ
• Work mode: On-site

Responsibilities and Activities

VBA/Excel Automation

• VBA/Excel automations for automated data collection
• Automatic generation of management reports
• Automated sending of executive emails
• Macro creation to optimize administrative routines
• Building complex spreadsheets with formulas and automations

Inventory Control

• Managing stock of promotional materials (trade marketing)
• Controlling distribution of office supplies
• Organizing and tracking materials
• Optimizing distribution processes

Sales Analysis

• Sales volume analysis and market trends
• Calculating and tracking commercial KPIs
• Creating analytical reports
• Supporting commercial decision-making
• Analyzing product and channel performance

Administrative Routine Optimization

• Developing macros to automate processes
• Reducing time spent on repetitive tasks
• Improving operational efficiency
• Standardizing administrative processes

Technologies Used

Automation Tools

• VBA (Visual Basic for Applications): Excel automations
• Excel: Complex spreadsheets, formulas, analyses
• Macros: Automation of administrative routines

Management Systems

• Salesforce: Customer relationship management (CRM)
• Internal Systems: Integration with corporate systems

Data Analysis

• Advanced Excel: Formulas, pivot tables, charts
• Data Analysis: KPIs, commercial metrics
• Reporting: Creating and formatting management reports

Achievements and Results

Automation and Efficiency

• Automations that reduced time on repetitive tasks
• Macros to optimize administrative processes
• Improved operational efficiency through automation

Analysis and Insights

• Building sales analyses and commercial KPIs
• Supporting decision-making through data
• Identifying trends and opportunities

Professional Development

• First experience in a multinational corporate environment
• Learning enterprise tools (Salesforce, advanced Excel)
• Developing analytical skills
• Understanding commercial and trade marketing processes

Skills Developed

Technical

• VBA: Excel automation programming
• Advanced Excel: Complex formulas, pivot tables, macros
• Salesforce: Customer relationship management
• Data Analysis: KPIs, metrics, reporting

Commercial

• Understanding trade marketing processes
• Sales and performance analysis
• Customer relationship management
• Inventory and distribution control

Soft Skills

• Teamwork in a corporate environment
• Communication across hierarchies
• Organization and multitasking
• Analysis and problem solving

Sector Context

Tobacco Industry

• Highly regulated sector
• Focus on innovation and reduced-risk products
• Trade marketing as a competitive strategy
• Data analysis for decision-making

Sector Challenges

• Complex regulation
• Need for market analysis
• Customer relationship management
• Optimization of commercial processes

Impact and Contributions

Operational Efficiency

• Automating administrative processes
• Reducing time on repetitive tasks
• Improving data accuracy
• Optimizing resources

Analysis and Insights

• Analyses that supported commercial decisions
• Identifying opportunities through data
• Better understanding of commercial performance

Professional Development

• First experience in a corporate environment
• Learning enterprise tools
• Developing analytical skills
• Foundation for future growth in technology

Transition to Technology

This experience was important for building skills later applied to tech:

• Process automation (foundation for RPA and development)
• Data analysis (basis for BI and analytics)
• Working with corporate systems (experience with Salesforce and integrations)
• Understanding business processes