
Dennis Ravanzo
Full-Stack Software Engineer
For the last decade of my career at Chevron, I have focused on Microsoft-based solutions that included:
- .Net: C#, VB.Net, ASP.Net, MVC, LINQ, …
- Azure: DevOps, Ansible, CI/CD pipelines, Data Factory, …
- SQL: on-prem and Azure, complex T-SQL, stored procedures, ETL, SSIS, …
- Power Platform: PowerApps, Power Query, Power Automate, …
I also used various web-standards like HTML5, CSS3, JavaScript, TypeScript, CSS preprocessors (SASS) and various UI frameworks like jQuery and Angular with Material Design.
Major contributions:
- Reduced data loading times by at least 90% by creating a parallel processing model in Power Automate (PowerApps Flows).
- Reduced processing times by 50% (saving 2-4 hours per runtime) by optimizing data analytics reports (stored procedure T-SQL script).
- Reduced API calls by 90% with caching, production deployment downtime by over 99% (from minutes to under 5 seconds), and manual process by 100% with automated deployment using PowerShell; enabled scalability; and improved UI/UX by rewriting a payment app named GO-1627 using ASP.Net MVC (with Razor) and jQuery with custom JavaScript framework.
- Eliminated up to 100% of the manual process by introducing and training non-technical business users on Microsoft Power Automate for Desktop: enabling their departments to maintain, extend, and encourage development of new automations.
- Designed UI/UX and coding standards for new modern projects using Angular and TypeScript.
- Mentored interns who became employees and trained business analysts moving to technical roles on Microsoft PowerApps (canvas apps and flows) and Power Automate to support existing and develop new low-code apps and automations in their groups or departments.
My last role as a Technical Lead had responsibilities that included having to:
- Lead a team of five (5) developers in developing a modern inventory and accounting app, CCIAM.
- Contribute to resolving technical debt and continuous improvement of development processes using Agile methodologies.
- Collaborate with cross-functional teams to gather requirements and design solutions that meet business needs.
- Document technical specifications, implementation details, integration features, configurations, and best practices, ensuring clarity and accessibility for stakeholders.
- Demonstrate technical leadership through design and code reviews, and best practices.
- Mentor, train, and promote knowledge-sharing culture.
Employment History
Software Engineer 2 at Chevron Holdings, Inc. • Jan 2014 – Jul 2024
Responsibilities (continued from above):
- Design, prototype, implement, optimize, test, release, and support production-quality software with pragmatic and balanced approaches to complexity, performance, technology, and industry best practices.
- Debug and resolve application errors and performance issues in a timely manner.
- Stay current with industry trends and emerging technologies.
Relevant Projects:
- Technical Lead for Carbon Credits Inventory & Accounting Management (CCIAM)
Designed the architecture, UI/UX, and coding standards; onboarded and mentored members; and primary contact of the Product Owner. A web-based tool used to automate calculation and submission of carbon credits to stakeholders (worth more than USD 100MM annually), reducing 99% processing time compared with manual processes using Excel and improving accuracy. Used Azure Web API, Entity Framework, Angular, TypeScript, C#.Net, etc. to interface with SAP, EMTS, OPIS, Right Angle, etc. - Lead Developer, UI/UX Engineer for GO-1627
Rewrote and designed the architecture, UI/UX, and coding standards. A web-based payment tool which interfaces with SAP and external systems via APIs. Used ASP.Net MVC with Razor, C#.Net, jQuery, AJAX, Entity Framework, MS SQL, etc. - Lead Developer, UI/UX Engineer for Not Ready to Pay (NRTP)
Designed the architecture, UI/UX, and coding standards of the canvas app and related flows. A web-based system for tracking invoices pending payments which interfaces with SharePoint, MS SQL, and Dataverse using PowerApps and Power Automate, etc. Its success sparked interest in low code apps leading to development of more tools for non-critical business processes, reducing development time from months to weeks, and processing time and errors from manual processes. - SQL Developer for Audit Data Analytics
Created, maintained, optimized, and debugged stored procedures, views, functions, reports, etc. A purely MS SQL implementation that generates data analytics reports based on user parameters entered via a separate tool. Used ETL via SSIS to load data from various external sources.
Prior Employments
Web Developer III at Reed Elsevier Shared Services (Philippines) Inc. • Nov 2012 – Jun 2013
Senior Web Developer at Optimize Solutions, LLC • Jun 2011 – May 2012
Senior Web Developer at Emerson Electric Asia, Ltd. (ROHQ) • Jan 2008 – Jun 2011
Relevant Projects:
- Lone Developer for Chrono • Reed Elsevier
A web-based system for tracking operations-based employee metrics using ASP.Net MVC with Razor, C#.Net, jQuery, AJAX, Entity Framework, MS SQL, etc. - Lone Developer for Pipeline Tool • Reed Elsevier
A web-based reporting tool for human resources-related management and planning using ASP.Net, Entity Framework, MS SQL, etc. - Programmer, UI/UX Engineer for Liebert Utilization Information System • Emerson
A Windows and web-based system for monitoring personnel utilization of Liebert, an Emerson company, using .Net, Entity Framework, MS SQL, APIs, etc. - Programmer for Project Management Information System • Emerson
A Windows and web-based system that provides utilization statistics of personnel and the projects they handle using .Net, Entity Framework, MS SQL, APIs, etc. - Lead Programmer, UI/UX Engineer for Attendance Monitoring System • PUP ICTC
A Windows-based system that monitors the attendance of personnel in line with the PhilHealth project using .Net, Entity Framework, MS SQL, DirectX, etc. - Lead Programmer for Application Monitoring System • PUP ICTC
A Windows-based system that monitors applications running throughout the local area network of the PUP ICTC Laboratories.
Education
Bachelor of Science, Computer Science
Polytechnic University of the Philippines
Skills Summary
.Net, ABBYY, Agile, Ajax, Analytics, Angular, Ansible, Architecture, ASP, ASP.Net, Automation, Azure, Best Practices, C#, C++, Canvas Apps, CI/CD Pipeline, COBOL, Code Review, CSS3, Database, Data Lake, Design, Documentation, EMTS, Entity Framework, ETL, Ext.Net, Full-Stack, Graphics, Growth Mindset, HTML5, JavaScript, JIRA, jQuery, JSON, Leadership, LINQ, Low Code, Mentoring, MVC, MVVM, Node.js, OCR, OPIS, Pascal, PowerApps, Power Automate, Power Platform, Power Query, Problem Solving, Programming, Python, Razor, React, RDBMS, Research, REST, RPA, SAFe 4.0, SAP, Scrum, SCSS, SOAP, SQL, SSIS, SSRS, Stored Procedure, Technical Writing, TypeScript, UI, UiPath, Umbraco, UX, VB.Net, VB6, VBA, Visual Basic, Web API, WordPress, WPF, Writing, XHTML, XML
Certifications
ABBYY FlexiCapture 12 Basic
ABBYY
November 2021
SAFe 4.0 Practitioner
Scaled Agile
February 2019-2020
Microsoft Office Specialist
Microsoft
January 2000
Thank you for taking the time to look at my extended resumé here. I linked my resumé to this page to provide more details about my experience and background, share my writing style, highlight what I can do even with a limited platform, and show my other side apart from being a developer. I look forward to hearing from you to talk about the opportunity of working together.
