Proactive Business Analyst with 8+ years on data analysis, visualizations, dashboards, and client's profitability experience in the Banking Industry with customer driven experience of over 2 years in the Consumer Packed Goods industry. Computer literacy in: SQL (SQL Server) , MS Office 365 (Access (SQL, Reporting, Macros), Excel (Macros, Power Query, Power Pivot, Power BI, Power Automate, and Power APP), Word, PPT,), SAS (Base and Miner), DAX, M, IBM Cognos Analytics, VBA, VBScript, SPSS (Statistics), Business Object, BW, and SAP.
Hi, I’m
Jorge Escobar
Business Analyst
Carolina
Summary
Overview
17
years of professional experience
Work History
BANCO POPULAR DE PUERTO RICO
Business Analyst – Business Banking Division
02.2016 - Current
Job overview
- Managed and maintained commercial credit and deposit monthly database processes using SAS platform
- Analyzed application’s logics and data integrity on commercial reports and database on a monthly and Ad Hoc basis which included updates in SAS, Power BI, and Power Query, improving processes, execution time, and end user utility
- Designed and customized dynamic reports and tables in Power BI and Excel to be updated automatically by month with Power Query parameters, VBAs, and Power Automate for easy-to-use visualizations and data filters for Regional Managers, Top Management and Customer Knowledge business units
- Developed quarterly dashboards and reports for Regional Managers on delinquency by client, new deposit customer profile by product mix, credit disbursement rate, and credit fees opportunity by Branch
- Owned Pricing Tool application processes and calibration to meet business profitability targets
- Developed trainings and workshops to Business Analysts from basic to intermediate level in SAS Enterprise Guide, Cognos IBM Analytics Studio, and built-in Power Query reports
- Minimized by 20% commercial delinquency rate by targeting possible weak performance clients with the creation of a delinquency report and dashboards
- Made savings of more than $44K worth in SAS trainings in 2019
- Automated reports and data updates in SAS using SAS data step and SQL for weighted measures on KPIs YTD or Full Year, and P&L by commercial segment and client
- Led the migration of commercial database and calculations from SAS and Power Pivot to Cognos IBM Analytics, improving a 5-day data process into one monthly load with data dictionary and logic glossary
- Developed Power BI Dynamic Profitability Dashboard for the Middle Market and Corporate segments of Business Banking Division for Credit Pricing decisions
ROVIRA FOODS
Category Manager
07.2015 - 1 2016
Job overview
- Developed yearly strategies and tactics by channel to grow category sales on US and local accounts including Walmart, Kmart and big chain supermarkets in Puerto Rico like Econo, Supermax, Selectos, Pueblo and Mr
- Special, coordinating any POS implementation with the category team
- Owned yearly category reviews with US and local clients, discussing sales opportunities using POS data from both the stores and market, providing recommendations on product assortment, positioning, and strategies to maximize category sales
- Conveyed monthly price studies and analyses, disclosing price opportunities and threats giving price recommendations on core products to Rovira executives and commercial clients
- Gave monthly reviews to Top Management and Key Account Managers on market insights for the Cookies and Crackers categories, identifying opportunities and trends on consumer buying behaviors
- Increased space for Export Soda category in Kmart by 5% by maximizing space and product assortment
- Maximized space by 33% of the Tin Can segment in Supermax supermarkets by repositioning Foil Plastic Cans with its corresponding segment, representing 4% of POS volume to the client
NESTLE PURINA PETCARE
Category Management Analyst
05.2013 - 06.2015
Job overview
- Analyzed local commercial Pet Food sales with market data shared by clients and IRi, identifying opportunities for developing strategies and tactics to be implemented in Big Chain and Independent clients, resulting in category sales growth and profitability on over 120 stores, maximizing selling mix on product portfolio by channel, customer and product
- Led quarterly meetings with clients and monthly updates with NPPC team to discuss market insights, data and category trends with prior performance comparisons
- Developed and implemented Planograms based on my recommendations, maximizing sales and profitability within client’s category sales, assigning resources, and supervising in each store monthly
- Developed and owned Price Study Project, analyzing market price and company’s target and strategies by category, segment, size, and perceived values between brands and life stages of the pet discussing results and action plans with Top Management and Key Account Managers in a quarterly basis
- Obtained assessment pilot programs in Supermax Supermarkets in 2013, and in 2014 obtained captaincy on Dog Food Category for all Supermax stores
NESTLE PURINA PETCARE
Commercial & Sales Administrator Analyst
08.2010 - 04.2013
Job overview
- Owned the Sales Force Incentive Process by calculating, paying, and reporting Sales Commissions
- Owned Caribbean region commercial reporting, analyses and processes, measuring performance and variances on customer's receivables, total trade spend, contribution, gross and net sales, marginal contribution, allowances, profitability, growth rate, and marketing expenses by brand, communicating results in monthly meetings with operations, sales, finance and marketing managers
- Owned Pre and Post Evaluations on Total Trade Spend activities to measure profitability and make recommendations
- Forecasted monthly and yearly total trade spend and allowances by Key Customer discussed in team meetings with Sales and Finance Department, validating customer’s performance and amounts to be considered in a Dynamic Forecast preparation
- Analyzed invoices for price and discount validation to reduce differences that causes overestimations on client’s receivable
- Gave visibility to Top Management by generating projection of commercial allowances, thus lowering expenses 1% of sales in a monthly basis
- Created Queries, Tables and Reports in Microsoft Access for Reporting Sales Commissions and Customer Incentives, reducing completion time by 20%
- Developed procedures on product Price and Discounts that minimized Receivables Totals by 10%
LA CRUZ AZUL DE PUERTO RICO
Statistics and Actuarial Services Manager
04.2008 - 07.2010
Job overview
- Responsible for the monthly reports related to company’s enrollment, claims, premiums, costs, and other performance measures (MTM)
- Calculated actuarial impact of renewal contract fees with Puerto Rico hospitals to ensure at most a 5% increase
- Supervised audits to ensure compliance with company’s performance measures
- Analyzed and calculated monthly cash reserve amounts for unpaid incurred claims
- Estimated utilization for new hospitals and assigned contract rates
- Analyzed, discussed, and provided statistical data reports to executives, insurance commissioner, insurance agents, and other company departments (Finance, Contract Administrator, Marketing, and Providers)
- Provided claim reports with reconciliations with the GL for external auditors
- Successfully reduced task time up to 80% by designing and implementing an excel spreadsheet with conditional formulas which calculated the deductibles from organ transplants reinsurances claims
- Created Queries, Tables and Forms in MS Access for every new project to generate reports to executives and insurance commissioner about membership and paid claims
Education
University of Puerto Rico, Rio Piedras Campus
MBA from Quantitative Methods
University Overview
University of Puerto Rico, Rio Piedras Campus
BBA from Finance & Accounting
University Overview
Double Major
Skills
Data Analysis
Awards
Awards
- Banco Popular de Puerto Rico Excellence Award for Performance (2019)
- Banco Popular de Puerto Rico Excellence Award for Profitability (2016)
Timeline
Business Analyst – Business Banking Division
BANCO POPULAR DE PUERTO RICO
02.2016 - Current
Category Manager
ROVIRA FOODS
07.2015 - 1 2016
Category Management Analyst
NESTLE PURINA PETCARE
05.2013 - 06.2015
Commercial & Sales Administrator Analyst
NESTLE PURINA PETCARE
08.2010 - 04.2013
Statistics and Actuarial Services Manager
LA CRUZ AZUL DE PUERTO RICO
04.2008 - 07.2010
University of Puerto Rico, Rio Piedras Campus
MBA from Quantitative Methods
University of Puerto Rico, Rio Piedras Campus
BBA from Finance & Accounting
Similar Profiles
Beckia PazBeckia Paz
Operations Analyst, Subpoena Processing at Banco Popular De Puerto RicoOperations Analyst, Subpoena Processing at Banco Popular De Puerto Rico
Javier Alvarez BenitezJavier Alvarez Benitez
Internal Auditor at Banco Popular de Puerto RicoInternal Auditor at Banco Popular de Puerto Rico
Stephanie Marie Rivera RodríguezStephanie Marie Rivera Rodríguez
FHA Claims Specialist at Banco Popular de Puerto RicoFHA Claims Specialist at Banco Popular de Puerto Rico