Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Richard Mendez

San Antonio

Summary

Dynamic Senior Consultant with extensive experience at Innovative Software Solutions, Inc., specializing in cloud-based solutions and SAP integration. Proven track record in developing robust web services and optimizing database performance. Strong analytical skills combined with a commitment to excellence drive successful project outcomes and enhance operational efficiency.

Overview

30
30
years of professional experience

Work History

Senior Consultant

Innovative Software Solutions, Inc.
San Antonio
10.2024 - Current
  • Analyzed, designed, developed, and maintained commercial, cloud-based enterprise-scale tax calendar filing and oil & gas pricing solutions integrated with SAP ERP for Fortune 500 corporations.
  • Developed and maintained an internal object-oriented class library and application framework to enhance component reuse and facilitate rapid prototyping.
  • Performed database modeling, administration, and programming, including constraints, indexing, stored procedures, triggers, views, and complex SQL for ETL and reporting in SQL Server and Sybase ASE.
  • Created SOAP and REST web services for state and federal tax filing, tailored to oil & gas clients.

Senior Software Engineer

CIT/First Citizens Bank (Tek Systems, Inc.)
07.2023 - 05.2024
  • Conducted analysis, development, maintenance, and migration of multiple critical internal systems, including Customer Credit Monitoring (CCM), Line of Credit Management Systems (LCM and LCCMS), and Credit Processing System (CPS).
  • Engineered and maintained an internal object-oriented class library and application framework to leverage and maximize reuse of existing components, enabling rapid prototyping and development.
  • Performed database modeling, administration, and programming, including constraints, indexing, stored procedures, triggers, views, and complex SQL for ETL and reporting in SQL Server and Sybase ASE.

Senior Software Engineer

Innovative Software Solutions, Inc.
San Antonio
03.2017 - 03.2023
  • Led the analysis, design, development, and maintenance of commercial, cloud-based enterprise-scale tax calendar filing and oil & gas pricing solutions integrated with SAP ERP for Fortune 500 corporations.
  • Engineered and maintained an internal object-oriented class library and application framework to enhance component reuse and promote rapid prototyping.
  • Performed database modeling, administration, and programming, including constraints, indexing, stored procedures, triggers, views, and complex SQL for ETL and reporting in SQL Server and Sybase ASE.
  • Developed web services for state and federal tax filing tailored to oil & gas clients.

Contractor U.S.A.A

TATA Consulting Services (TCS)
San Antonio
06.2015 - 03.2017
  • Analyzed, designed, and developed front-end user interface applications and event-driven programming for data entry.
  • Modeled and created a back-end relational database to store system data.
  • Developed scheduled back-end interface application programs to automate banking transaction processing by simulating business user data entry and transferring data between internal web-based and mainframe applications.
  • Conducted QA testing to verify system specifications were met.

Software Engineer IV

Lewis Energy Group
San Antonio
09.2012 - 01.2015
  • Well Scheduling System – A web-based application developed to schedule field operations (land, drilling, fracturing, and completions) and to calculate, project, and report estimated revenues.
  • Vehicle Reassignment/Replacement System – A web-based application developed to validate vehicle VIN numbers and facilitate reassignment or replacement of fleet vehicles for corporate employees.
  • Security Incident Tracking System – A web-based application developed to record corporate security incidents for the Security department and law enforcement.
  • Safety Incident Tracking System – A web-based application developed to record and report corporate safety incidents for the Safety department and OSHA.
  • Lodging Reservation System – A web-based application developed to manage multiple properties, buildings, rooms, beds, and tenants for field operations.
  • LEG Classes – A class library and application framework engineered to serve as the foundation for all corporate application development work.
  • Provided team mentoring and administration and support for Peloton WellView.

Lead .Net Developer

Tesoro Petroleum Corporation
San Antonio
10.2007 - 09.2012
  • HR Time Approval System – A web-based application that integrates with SAP via the SAP .Net Connector to retrieve, display, and approve vacation requests.
  • IT Ticket Tracker – A web-based application that integrates with SAP PM module via the SAP .Net Connector to retrieve and display service desk notifications for authenticated users.
  • Developed custom SharePoint pages with in-line C# code to read and display system alerts via scrolling marquees. Integrated SharePoint and Active Directory with external web applications through the consumption of SharePoint web services.
  • Developed a suite of ITIL Framework-inspired intranet and internet-based smart applications engineered to integrate with our ERP (SAP) and streamline internal operations, promoting maximum productivity and efficiency.
  • Administered SharePoint sites and resources and provided mentorship to junior development staff.
  • Customized Right Angle, a commercial, enterprise-scale, multi-tiered client/server database application used for managing supply, trading, and risk management.
  • Solarc Right Angle Monitor – An internal intranet-based application developed to monitor application servers, COM servers, pricing services, interfaces, and nightly database snapshots, as well as to provide health checks, technical landscape, and support information.
  • The Supply & Optimization Information Technology website which provides information regarding team members, vendors, technical landscapes, on-call support rotation schedules, and embedded portals to other systems.
  • Engineered various scripts and utilities for infrastructure support.
  • Provided technical support for various commercial and proprietary Supply & Optimization applications.

Lead Programmer/Analyst

Kinetic Concepts, Inc.
San Antonio
06.2005 - 08.2007
  • Maintained KCI Express, an internet-based customer order entry and reporting system designed to accept standard rental and claim orders for hospital and healthcare patients.
  • Maintained Genesis, a proprietary, enterprise-scale client/server customer service system designed to enforce quality assurance, manage company assets, and report standard rental and claim orders by service center.
  • Engineered and integrated all EDI interfaces between KCI and FedEx Corporation to initiate and track Express and Ground shipments between customer facilities and corporate service centers.
  • Designed Genesis security and an intranet-based administrative console to administer users, roles, and permissions at the screen element level.
  • Developed intranet-based database administration tools to maintain user accounts, security roles, and permissions for database objects and reports.
  • Modeled databases and programmed triggers, stored procedures, and functions using Oracle PL/SQL.

Lead Programmer/Analyst

World Savings
San Antonio
04.2005 - 06.2005
  • Maintained SharePoint and various internal portal applications and reports in direct support of the ISD Technical Services & Support Center.
  • Programmed applications using ASP, VBScript, ASP.Net, C#, VB.Net, JavaScript, and HTML.
  • Programmed databases using SQL Server DTS and Transact-SQL stored procedures.
  • Designed and maintained reports using SQL Server Reporting Services.

Lead Technical Specialist

Ultramar Diamond Shamrock/Valero Energy
San Antonio
10.1997 - 04.2005
  • Investment Recovery System: Internet-based auction platform for refinery assets.
  • Synergy Management System: Intranet application for corporate synergy and project management.
  • Sales Pipeline System: Enterprise application for evaluating convenience store rebranding ventures.
  • Refinery Lab Viewer: Portal for accessing and reporting lab testing results.
  • IT Application Manager: Tracks IT resources and impact analysis.
  • Project Management System: Manages departmental projects and statuses.
  • SAP Master Data Workflow Application: Automates master data creation and approval.
  • ODS Gateway System: Multi-lingual data system supporting SAP.
  • Branded Zone Pricing: Competitive pricing of wholesale gasoline products.
  • Lubricants Order Entry System: Maintains lubricant-related data.
  • Merchandise Rebates System: Tracks rebates on bulk purchases.
  • Government Reporting System: Reports gasoline sales for tax purposes.
  • Product Exchange System: Manages product exchange contracts.

Lead Technical Specialist

Valero Energy/PGE Gas Transmission Texas
San Antonio
06.1997 - 10.1997
  • Customized RightAngle, a commercial client/server database application, to manage bulk purchase contracts for product exchanges, and sales and purchases of natural gas and liquid products involving customers, third-party suppliers, and vendors.
  • Designed and developed heterogeneous system interfaces to extract, transform, and interface data from a production exchange system to a projection/analysis system.
  • Modeled databases programmed custom triggers and stored procedures and developed reports in SQL Server.

Senior Consultant

Southwest Business Corporation Insurance (SWBC)
San Antonio
02.1997 - 06.1997
  • Analyzed, redesigned, and customized WInsure 1995 – a mid-scale client/server database application used by the Real Estate department to manage various types of properties and produce monthly billing premiums, reports, graphs, and claims.
  • Authored a service-based, object-oriented class library and application framework to maximize reuse and leverage existing efforts for rapid prototyping and application development.
  • Modeled, administered, and optimized databases, including creating views, triggers, and stored procedures.

Senior Systems Engineer

Front-line Computer Systems, Inc.
San Antonio
10.1996 - 02.1997
  • Analyzed, designed, and developed a custom client/server and intra/internet database application used by the engineering department to maintain weapon system parts and report cost justification information to the budgeting office at Kelly A.F.B.
  • Designed and developed object-oriented software components and maintained existing commercial application class libraries.
  • Researched emerging technologies, specifically intra/internet development tools, for worldwide web database programming and publishing.

Systems Engineer

Electronic Data Systems (EDS)
San Antonio
11.1995 - 10.1996
  • Implemented new system requirements and maintained the military Readiness module for the Defense Medical Human Resource System (DMHRS) – an enterprise-scale, client/server team development effort for the Army, Navy, Air Force, and Marine Corps.
  • Designed and developed wide area system requirements, including functionality to web-enable existing technologies necessary for interaction with remote medical facilities worldwide.
  • Engineered reusable, object-oriented software components and optimized database views, queries, and reports using Watcom SQL Anywhere.

Education

Associate - CICS Computer Science

San Antonio College
San Antonio, TX
01.1991

Skills

  • Appeon Powerbuilder
  • Microsoft ASPNet, C#
  • Microsoft SQL Server
  • Sybase
  • Oracle
  • IBM DB2
  • Advanced SQL programming
  • Advanced object-oriented programming
  • Web service development
  • Data modeling
  • ETL processes
  • Query Optimization
  • Reporting

Timeline

Senior Consultant

Innovative Software Solutions, Inc.
10.2024 - Current

Senior Software Engineer

CIT/First Citizens Bank (Tek Systems, Inc.)
07.2023 - 05.2024

Senior Software Engineer

Innovative Software Solutions, Inc.
03.2017 - 03.2023

Contractor U.S.A.A

TATA Consulting Services (TCS)
06.2015 - 03.2017

Software Engineer IV

Lewis Energy Group
09.2012 - 01.2015

Lead .Net Developer

Tesoro Petroleum Corporation
10.2007 - 09.2012

Lead Programmer/Analyst

Kinetic Concepts, Inc.
06.2005 - 08.2007

Lead Programmer/Analyst

World Savings
04.2005 - 06.2005

Lead Technical Specialist

Ultramar Diamond Shamrock/Valero Energy
10.1997 - 04.2005

Lead Technical Specialist

Valero Energy/PGE Gas Transmission Texas
06.1997 - 10.1997

Senior Consultant

Southwest Business Corporation Insurance (SWBC)
02.1997 - 06.1997

Senior Systems Engineer

Front-line Computer Systems, Inc.
10.1996 - 02.1997

Systems Engineer

Electronic Data Systems (EDS)
11.1995 - 10.1996

Associate - CICS Computer Science

San Antonio College

Similar Profiles

CREATE PROFILE
Richard Mendez