Badges
Certifications
romfrancisco has not earned any certificates yet.
Work Experience
Lead Software Engineer
NBCUniversal• January 2020 - Present
Played key roles in many projects. NBCU GEM awardee and Summit Award nominee. • Promoted for contributions to several major projects such as FlexPay, FlexPay Renewal, Costco Multi-Day Pass to name a few. • Served as technical lead and subject matter expert in building out the new Finance Back-of-House system that is 40 times faster than the legacy system. • Provided in-depth analysis of ticketing transactions that were posting to SAP. • Working with Universal Orlando in the adoption of DevOps in Universal Studios Hollywood.
Senior Application Engineer
NBCUniversal• March 2017 - January 2020
Played key roles in many projects. NBCU GEM awardee and Summit Award nominee. • Enhanced Finance's Back-of-House system to support major projects such as FlexPay, FlexPay Renewal, Costco Multi-Day Pass, and others. • Served as subject matter expert of Finance's legacy Back-of-House system. • Optimized the legacy Finance reports to run 12 times faster. • Provided in-depth analysis of ticketing transactions that were posting to SAP. • Partnered with Universal Studios Hollywood Finance in ensuring proper configuration of various ticket type products and its transactions to generate the correct journal entries that will be posting to SAP.
Senior Programmer Analyst
University of Southern California• March 2012 - March 2017
Recognized many times for delivering a multitude of projects and for customer-focused service. Tommy Trojan awardee. Trained and mentored teammates. • Implemented all iManage projects done in-house which saved the division more than $200K a year of vendor cost. • Lead in identifying business practices, HIPAA and/or FERPA regulatory requirements, and system integrations offering practical solutions – be it build or buy. • Served as technical lead in the analysis, design, development, and implementation of solutions based on the user’s scope and objectives. • Provided leadership, mentoring, and guidance to programmers and evangelized the adoption of new technologies, techniques, and best practices – Agile/Scrum, Git, C#, ASP.NET, ASP.NET MVC, Bootstrap, and others. • Managed all SQL Server provisioning, development, and performance tuning.
Business Intelligence Developer
ScoreBig• April 2011 - March 2012
Improved report generation times from several minutes to mere seconds using experience on SQL performance tuning techniques. SQL Rockstar. • Engaged with users to gather reporting requirements. • Developed, enhanced, optimized, and maintained SSRS reports using SQL Server and Visual Studio. • Developed and maintained stored procedures and ETL packages for automation, KPI metrics, and others. • Acted as QA for SQL queries, SSRS reports, and ETL packages developed by other developers.
Programmer (Contract)
PNB Remittance Centers, Inc.• January 2011 - April 2011
Enhanced and maintained the company’s kiosk-based remittance system. • Engaged with users to gather requirements for enhancements of the company’s kiosk-based remittance system. • Developed enhancements for the company’s kiosk-based remittance system. • Developed the device driver for the Verifone pinpads that enabled integration to the company’s kiosk-based remittance system.
Senior Programmer Analyst
Philippine National Bank• January 2004 - December 2010
Implemented key projects which include the bank’s first telephone, internet, and mobile banking systems in the Philippines. Delivered a web-based remittance system in the United Kingdom. Deployed a kiosk-based remittance system throughout the United States. Promoted to a senior role in delivering key projects and received the Service Excellence award for playing a key role in supporting the bank’s audit review by the federal and state regulators of New York. • Managed and mentored 20 developers and lead them in many projects. • Developed and implemented many systems which include the bank’s first telephone, internet, and mobile banking systems, internet-based and kiosk-based remittance systems. • Evangelized the adoption of new technologies – COM+, SSRS, VB.NET, ASP.NET, Web Services. • Handled the IT-side preparations for audit by the Federal Reserve Bank of New York, New York State Banking Department, Federal Reserve Bank of San Francisco, and the Department of Financial Institutions of several states. Received the Service Excellence award in 2010 for playing a key role during the NY audits. • Coordinated with head office in the Philippines in implementing projects that comply with BSA, AMLA, USA PATRIOT Act, and other financial regulations.
Software Engineer
IC Jacobsen, Inc.• December 2001 - January 2004
Designed, developed and implemented various systems and applications for the company and its clients which include the company’s website, many short messaging service applications and financial system for cooperatives. • Developed and managed the company’s website. • Developed custom applications for clients that run on the company’s own text messaging platform. • Handled QA for company’s custom GSM modem driver. • Lead development of financial system for savings and loans cooperatives.
Education
AMA University
Computer Science, BS• January 1998 - August 2001
Links
Skills
romfrancisco has not updated skills details yet.