Ivan Justo Email & Phone Number

Support Retail Sales by performing preparation of sales, capital expense budget, operating expense, and trend analysis.

Responsible for ensuring network deployment milestone is properly aligned and met for the New Jersey market, as well as ensuring we are staying within budget for the market wireless network to be comprised of 1,000+ cell sites.

Dallas, Texas, US

• Oversee team of analysts supporting regional sales and marketing organizations by facilitating reporting analysis, budget and accounting management, and back-office support, driving efficient daily operations to.
• Establish controls and corporate store audits to avoid frauds, enhance customer experience and secure compliance of Master Dealer Agreements for 1200+ regional dealer door locations.
• Reduce time to redistribute inventory from 5 hours to 1 hour by automating using macros and VBA programming language.
• Conduct quarterly sales and marketing budget management and month end accruals, of $10M, to keep marketing personnel focused on formulating new tactics.
• Obtain annual rent savings of $20K through the negotiation of lease term renewals for corporate store locations.
• Reconcile inventory provisioning and sales reports resulting in uncovering $100K in fraud in 2019.

Dallas, Texas, US

• Delivered market insight, sales performance and budget analysis for regional sales and marketing teams, helping to drive up subscriber base to approximately 1.5M subscribers.
• Created new reports and analytical tools, such as customer forecast, Average Revenue Per Unit (ARPU), Churn, revenue; providing new feedback on state of business in order to assess return on investment from $7M.
• Preserved area average store audit scores between 93-100% mark by addressing concerns and regional pain points via quarterly store reviews for 15 retail locations to drive consistency and secure SOX compliance.
• Entrusted to assist in complex business practice issues, from strategy to execution, by partnering with legal and market directors to resolve fraud related investigations.

Dallas, Texas, US

• Performed financial and trend analyses of multiple aspects of revenue streams for 528 Dealer locations and 15 Corporate stores.
• Developed a cross-section of reports to ensure compliance of financial processes and General Accepted Accounting Principles (GAAP), including variance analysis and monthly accruals.
• Achieved efficiencies, including an automated dealer sales scorecard, decreasing production time from 4 hours to 45 minutes and check request process from 6 hours to 1 hour per week.
• Awarded MVP award in recognition of outstanding performance supporting sales organization.

Dallas, Texas, US

• Executed back office support and oversaw regional checking accounts to ensure compliance of financial requirements.
• Streamlined system to automate processes minimizing errors and significantly reducing labor time from three hours to 30 minutes.

Master Of Science - Ms, Finance, General

Bachelor Of Business Administration - Bba, Finance