Jonathan Rivera-Santiago Email & Phone Number

Houston, Texas, United States

Internal Client•Served as the primary onshore contact for the internal dashboard, ensuring timely refreshes, bug fixes, and biweekly data validation for 17 feeds, meeting SLAs with an average completion time of 26 minutes.•Delivered comprehensive updates on the internal dashboard to key stakeholders, covering completed and new requests, and development process queries.•Managed weekend refreshes for an internal dashboard, ensuring data integrity and timely updates for stakeholders' Monday calls, and provided crucial ad hoc support, resolving P1 bugs within one hour during the refresh process.•Led offshore Power BI developers in resolving bugs for two additional internal dashboards, fixing P1 issues within an hour and P2 issues within 3 hours, and conducted timely production deployments for bug fixes.

Houston, Texas, United States

Gas Retail Client•Supported the completion of a month-long deadline by co-developing 5 different dashboards, ensuring the project was delivered within budget.•Validated data from the client resulting in creating an additional dashboard for data validation problems.Utility Client•Developed 3 core Power BI reports to support manager-level client stakeholders from 2 different teams in understanding how the fuel economy programs (gas and electric) are impacting the business. Supported the creation of data models, data cleaning, DAX formulas, visualizations, UI, and knowledge transfer for the 3 dashboards.•Developed a solution for the client, allowing them to maintain certain financial information in Excel using Power Query as requested, rather than directly ingesting it into our data lake.Internal Client•Had a minimum viable product within 2 weeks (Based on the actual metric number for the week) so our main stakeholder could start the process of sharing it.•Lead data refreshed every 2 weeks for the internal dashboard and validated the results.•Became the liaison between Stakeholders, Data Engineers, and Data Owners.•Supported the creation of data models, data cleaning (for over 15 files), DAX formulas, visualizations, and UI for the dashboards.

San Juan, Puerto Rico

• Streamlined report generation, reducing lead time from 2 weeks to 1 day by automating Quarterly expense and litigation reports with Power Query and enhancing insights with Power BI visualizations.• Automated report creation through IBM Cognos scheduling and dynamic filters, enhancing accuracy while minimizing manual input.• Leveraged advanced IBM Cognos queries to enhance report accuracy and efficiency.• Designed a Power App to manage matter workload, introducing dynamic forms, and cutting average lead time by 50%.• Actively contributed to User Acceptance Testing (UAT) for the Cognos upgrade and Passport Home Dashboard project.• Spearheaded the creation of statistical analyses, reports, and presentations for three legal accounts.

Juncos, Puerto Rico

• Developed a semi-automated tool to simplify daily production meetings, ensuring 85% schedule adherence and aiding in root cause analysis.• Conducted a comprehensive time study for the In-Process Testing Laboratory, resulting in a labor model to optimize workload distribution.

Cataño, Puerto Rico

• Collaborated with an intern team to establish best practices for reducing chase (waste) in the grocery distribution center order filling process.• Performed statistical analysis using MINITAB on store sorter case volume to ensure uniform workload distribution among sorter arms.• Conducted a time study and capacity analysis for the Sam’s Club cross-docking operation, leading to the refinement of three productivity metrics.

San Juan, Puerto Rico

Facilitate inclusive learning environments by delivering comprehensive and precise lecture notes to support students with disabilities.

Cataño, Puerto Rico

•Spearheaded the design of a three-level order-filling module, boosting daily case volume from 20,000 to 30,000 units.•Significantly expanded the SKU count within the STKK building, enhancing product availability from 552 to 886 items.•Optimized warehouse operations by strategically redesigning the layout to maximize floor space utilization and segregate offline and module order-filling processes.

Master'S Degree, Business Analytics

Bachelor Of Engineering (B.E.), Industrial Engineering

Activities and Societies: Institute of Industrial and System Engineers