JOEL L Franco
Fort Worth,TX
Summary
Business administration graduate with over 15 years of experience in accounting and finance. Proven track record in compensation analysis and process optimization, driving a 15% increase in service profitability. Expertise in managing complex data systems while ensuring compliance with financial regulations.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Commission Analyst/ Finance
Triple-S Salud Inc
San Juan, PR
01.2015 - 03.2026
- Compiled and analyzed sales activity data to prepare monthly compensation statements for commercial roles, ensuring compliance with contractual obligations.
- Enhanced commission systems to align with business requirements.
- Managed compensation systems and tools to streamline operations.
- Collaborated with auditors on commission accrual procedures to maintain accuracy.
- Cultivated relationships with brokers, regional sales managers, and senior management to support compensation strategies.
- Performed audits of commission calculations and other financial data for validation of payment arrangements.
- Streamlined health insurance administration within compensation frameworks to ensure compliance and efficiency.
Service Accounting Analyst
Carrier Enterprise
Guaynabo, PR
01.2009 - 01.2015
- Boosted service profitability by 15% through margin analysis and cost tracking.
- Resolved billing issues in coordination with the finance department to streamline processes.
- Led billing operations and generated daily sales reports for Puerto Rico & Miami associates.
- Coordinated SOXA testing and oversaw service department closing processes, including SG&A analysis and cost projects, ensuring compliance and accuracy.
- Conducted cost analysis for installations, repairs, and preventive maintenance to support strategic decision-making for management.
- Managed essential documentation to facilitate communication between vendors and technicians.
Accountant
BP Puerto Rico Rental
San Juan, PR
01.2009 - 01.2013
- Managed accounts payable and vendor relationships, ensuring timely payments and compliance.
- Administered accounts receivable and online banking, streamlining financial operations.
- Prepared bank reconciliations, maintaining accurate financial records.
- Monitored and recorded company expenses, ensuring adherence to budget constraints.
- Managed payroll for 50 employees, ensuring timely and accurate processing.
- Supervised a team of 6 employees, enhancing collaboration and productivity.
Education
BBA - Business Administration with a major in accounting
Universidad Politécnica De Puerto Rico
San Juan, PR01-2006
Skills
- Financial modeling
- Compensation analysis
- Data analysis
- SQL management
- Python programming
- Power BI
- SAP software proficiency
- Microsoft Excel
- Microsoft PowerPoint
- Analytical skills
- Written communication
- Verbal communication
- Accounting support
Accomplishments
- Enhanced Compensation Accuracy: Improved compensation accuracy by 50% annually through data analysis and system enhancements.
- Strategic Reporting Impact: Provided reports influencing strategic decisions, achieving 10% increase in service profitability.
Languages
English: C2
Spanish: Native
Certification
Postgraduate Program Artificial Intelligence and Machine Learning: Business Application.
Timeline
Commission Analyst/ Finance
Triple-S Salud Inc
01.2015 - 03.2026
Service Accounting Analyst
Carrier Enterprise
01.2009 - 01.2015
Accountant
BP Puerto Rico Rental
01.2009 - 01.2013
BBA - Business Administration with a major in accounting
Universidad Politécnica De Puerto Rico