Richard M. Mendez
San Antonio, Texas 78237-4206
*******@***********.***
Honorable Mention
Lecturer on E-Commerce development at Alamo PC Organization’s ASP.Net user’s group 2004
Engineer of proprietary client/server and web-based class libraries, application frameworks and reusable code components to promote rapid application development
Contributing author to Powerbuilder Advisor’s Bernie Metzger’s Powerbuilder Slick Tricks Book © 1999 ISBN #096*******
Author of published articles in Sys-Con Publication’s Powerbuilder Developer’s Journal © issues November, December 1997
Author of published articles in Advisor Publication’s FoxPro Advisor Magazine © issues January, March, May 1996
Chairman of Microsoft FoxPro Special Interest Group, San Antonio, Texas 1995
Cutting Edge award from Air Force Surgeon General and numerous letters of recognition 1995
Summary of Qualifications
Intranet/Internet Application Development (31 Years)
Active Directory, AJAX Control Toolkit, ASP, ASP.Net, C#, Java, CSS, HTML, Internet Information Server, Javascript, JQuery/JQuery UI, MSChart, MVC, Reporting Services, SharePoint, SQL Server, SAP .Net Connector, Sybase Datawindow.Net, Telerik, VBScript, Visual Studio, Web Services, XML
Desktop and Client/Server Application Development (31 Years)
PowerBuilder Enterprise, Powersoft Foundation Classes (PFC), Financial Dynamic's Cornerstone Class Library, Metasolve's Powerframe Class Library, FoxPro/Visual FoxPro, Visual Basic, Access
Database Management Systems (31 Years)
ERWin, Oracle PL/SQL, Microsoft SQL Server Transact-SQL, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere Server, Adaptive Server Anywhere, DBase, Clipper, FoxPro, Access
Professional Experience
03/2017 – Present Senior Software Engineer
Innovative Software Solutions, Inc.
Technologies: Active Directory, C#, EDI, .Net 4.5, Appeon PowerBuilder Cloud, MS SQL Server Transact SQL, Web Services, XML
Analysis, design, development and maintenance of several commercial, cloud-based enterprise-scale tax calendar filing and oil & gas formula-based pricing solutions with full SAP ERP integration for many Fortune 500 corporations
Engineering and maintenance of internal object-oriented class library and application framework to leverage and maximize reuse of existing components for rapid prototyping and development
Database modeling, administration and database programming of constraints, index, stored procedures, triggers and views
Web service programming for our oil & gas clients for state and federal tax filing
06/2015 – 03/2017 Consultant U.S.A.A
TATA Consulting Services (TCS)
Technologies: VBScript, Microsoft Access, Internet Explorer, Mainframe, SQL
Analysis, design and development of front-end user interface application and event-driven programming for data entry
Analysis, design, modeling and creation of back-end relational database to store system data
Analysis, design and development of several scheduled back-end interface application programs to automate standard banking transaction processing by simulating business user data entry and transferring data to and from internal web-based and mainframe applications
QA testing to ensure that system specifications have been met
09/2012 – 01/2015 Lewis Energy Group
Architect / Software Engineer IV
Technologies: Active Directory, AJAX Control Toolkit, ASP, ASP.Net, C#, CSS, HTML, Internet Information Server, Javascript, JQuery/JQuery UI, MSChart, MVC, Reporting Services, SharePoint, SQL Server, Transact SQL, Team Foundation Server, Telerik, VBScript, Visual Studio, Web Services, XML
Analysis, design and development of the following applications:
Well Scheduling System – A web-based application created 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 created to validate vehicle VIN numbers and request reassignment/replacement of fleet vehicles for corporate employees
Security Incident Tracking System – A web-based application created to record corporate security incidents for the Security department and law enforcement
Safety Incident Tracking System – A web-based application created to record and report corporate safety incidents for the Safety department and OSHA
Lodging Reservation System – A web-based application created 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 behind all corporate application development work
Team mentoring and Peloton WellView administration and support
10/2007 – 09/2012 Tesoro Petroleum Corporation
Lead .Net Developer
Technologies: ABAP, Access, ASP, ASP.Net, C#, CSS, ERWin, HTML, JavaScript, Oracle, PL/SQL, PowerBuilder, SAP .Net Connector, SharePoint, SQL Server, Transact SQL, VBScript, Visual Basic, Visual Source Safe
Analysis, design and development of the following applications:
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.
Custom SharePoint pages with in-line C# code to read and display system alerts via scrolling marquees. Integration with SharePoint and active directory from external web applications through the consumption of SharePoint web-services.
A suite of ITIL Framework inspired intranet/internet based smart applications engineered to integrate with our ERP (SAP) and streamline internal operations promoting maximum productivity and efficiency. Administration of SharePoint sites and resources. Mentorship to junior development staff.
Customization of Right Angle © a commercial, enterprise scale, multi-tiered, client/server database application utilized to manage supply, trading and risk management. For more information, visit http://www.solarc.com/
Solarc Right Angle Monitor - an internal intranet based application created to monitor the application servers, the COM servers, the pricing services and interfaces, the nightly database snapshots, and provide health check, 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.
Engineering of various scripts and utilities for infrastructure support.
Technical support of other commercial and proprietary Supply & Optimization applications
06/2005 – 08/2007 Kinetic Concepts, Inc.
Lead Programmer/Analyst
Technologies: ASP, ASP.Net, C#, CSS, ERWin, HTML, JavaScript, Oracle, PL/SQL, PowerBuilder, VBScript, Visual Source Safe
Analysis, design and development of the following applications:
Maintenance of KCI Express ® - an internet-based customer order entry and reporting system created to accept standard rental and claim orders for hospital and healthcare patients
Maintenance of Genesis ® – a proprietary, enterprise-scale client/server customer service system created to enforce quality assurance, manage company assets and report standard rental and claim orders by service center
Engineering and integration of all EDI interfaces between KCI and FedEx Corporation to initiate and track Express and Ground shipments between customer facilities and corporate service centers
Genesis security and an intranet-based administrative console to administer users, roles and permissions at the screen element level
Intranet-based database administration tools to maintain user accounts, security roles and permissions to database objects and reports
Database modeling and PL/SQL programming of triggers, stored procedures and functions
04/2005 – 06/2005 World Savings
Lead Programmer/Analyst
Technologies: ASP, ASP.Net, C#, CSS, ERWin, HTML, JavaScript, SQL Server, Transact SQL, VBScript, Visual Source Safe
Maintenance of SharePoint and several other internal portal applications and reports in direct support of the ISD Technical Services & Support Center
Application programming in ASP, VBScript, ASP.Net, C#, VB.Net, JavaScript and HTML
Database programming in SQL Server DTS and Transact-SQL stored procedures
Report designing and maintenance in SQL Server Reporting Services
10/1997 – 04/2005 Ultramar Diamond Shamrock/Valero Energy Corporation
Lead Technical Specialist
Technologies: ABAP, Access, ASP, ASP.Net, C#, CSS, ERWin, HTML, J2EE, Java, JavaScript, Oracle, PL/SQL, PowerBuilder, SAP, SQL Server, Transact SQL, VBScript, Visual Source Safe
Analysis, design and development of the following applications:
Investment Recovery System – an internet-based application created to auction refinery assets to owned and operated refineries and outside entities
Synergy Management System – an intranet-based application written to solicit corporate synergy contributions/suggestions and maintain project management and best practice information
Sales Pipeline System - an enterprise-scale, intranet/internet-based application written for the wholesale marketing division to determine the viability of convenient store rebranding ventures through formula based calculations. This system currently serves hundreds of users internally and externally across the country via wireless devices
Refinery Lab Viewer - a portal-based intranet application created to access remote refinery data sources across the country and allow parameterized retrieval of refined product lab testing results for quality assurance through detailed reports to ensure adherence to government regulations
IT Application Manager - a intranet-based application used by the entire IT division to track all file servers, application servers and applications, database servers and databases, departments and support personnel, routers, switches, IP addresses, ports to effectively report impact analysis
Project Management System - an intranet-based application used by departmental managers to enter, maintain and report ongoing projects, weekly status' and assigned resources
SAP Master Data Workflow application - an intranet-based master data collection and workflow application seamlessly coupled and integrated with SAP to automate the creation and approval of new master data elements such as customers, vendors, plants and materials
ODS Gateway System – an multi-lingual, enterprise-scale data system supporting approximately 200 users throughout Canada and the United States engineered to act as a front-end to SAP and processes approximately six billion dollars in revenues annually
Branded Zone Pricing – a business-critical application utilized to perform competitive formula-based pricing of wholesale gasoline products by region daily for the west coast wholesale marketing division
Lubricants Order Entry System – an application used to maintain lubricant products, prices, suppliers, customers, purchase orders and invoices for A/R and A/P
Merchandise Rebates System – an application for tracking corner store merchandise and quantities purchased from suppliers to calculate and invoice rebates offered on bulk purchases
Government Reporting System – an application designed to report gasoline product sales by grade to the federal government quarterly for tax purposes
Product Exchange System - Mentoring, technical support, and maintenance of a system designed to establish product exchange contracts and to balance and report bulk movement
SAP Financial ABAP programming of inbound interfaces to preprocess general ledger and accounts payable invoice files from various vendors
Mentoring, training and support of internal development team members
Research and implementation of emerging technologies to help establish the corporate infrastructure
Engineering of corporate development standards, class libraries, application frameworks and code components to maximize productivity
06/1997 – 10/1997 Valero Energy/PGE Gas Transmission Texas
Senior Consultant
Technologies: Access, ERWin, Oracle, PL/SQL, PowerBuilder, SQL Server, Transact SQL
Customization of Right Angle © a commercial, client/server database application utilized to manage bulk purchase contracts for product exchanges, sales and purchases of natural gas and liquid products to and from customers, third-suppliers and vendors
Design and development of heterogeneous system interfaces to extract, transform and interface data from a production exchange system to a projection/analysis system
Database modeling, custom trigger/stored procedure programming, and reporting
02/1997 – 06/1997 Southwest Business Corporation Insurance (SWBC)
Senior Consultant
Technologies: ERWin, PowerBuilder, SQL Server, Transact SQL
Analysis, redesign and customization of WInsure © 1995 – a mid-scale client/server database application utilized by the Real Estate department to manage various types of properties and to produce monthly billing premiums, reports, graphs and claims
Authoring of a service-based, object-oriented class library and application framework to maximize reuse and leverage existing efforts for rapid prototyping and application development
Database modeling, administration and query optimization including the creation of views, triggers and stored procedures
10/1996 – 02/1997 Front-line Computer Systems, Inc.
Senior Systems Engineer
Technologies: ERWin, PowerBuilder, SQL Server, Transact SQL
Analysis, design and custom development of a client/server and Intra/Internet database application utilized by the engineering dept. to maintain weapon system parts and to report cost justification information to the budgeting office at Kelly A.F.B.
Design and development of object-oriented software components and maintenance of existing commercial application class libraries
Research of emerging technologies - specifically Intra/Internet development tools for world wide web database programming and publishing
11/1995 – 10/1996 Electronic Data Systems (EDS)
Systems Engineer
Technologies: ERWin, PowerBuilder, SQL Server, Sybase, Transact SQL
Implementation of new system requirements and maintenance of 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 Corp.
Design and development of wide area system requirements including functionality to web enable existing technologies necessary to interact with remote medical facilities world-wide
Engineering of reusable, object-oriented software components and optimization of database views, queries and reports
10/1993 – 11/1995 Diversified Technical Services Inc.
Senior Programmer/Analyst
Technologies: Access, FoxPro Windows, SQL, Visual Basic
Analysis, design and development of various mid-scale database applications including systems to automate the Medical Corp. Selection Board departmental processes, a vehicle registration system for the security police, an on-line surveying system and several modules for statistical and analytical reporting
Gathering of system specifications, instructing/training of personnel and major re-engineering of existing systems
On-line documentation and technical support
02/1993 – 10/1993 Net-X Software Solutions
Programmer/Analyst
Technologies: FoxPro DOS/Windows, SQL
Analysis, design and development of various commercial and in-house database applications in DOS and Windows including the Applicant Tracking System ATS © 1993 and several touch screen/bar coding applications to promote a paperless environment
Member of team development for Surveyor © 1993 modules for automated home health care systems and electronic billing
Gathering of system specifications, maintenance of existing systems, and technical support
09/1991 – 02/1993 Grant Thornton CPA Firm as receiver for Resolution Trust Corporation
Programmer/Data Preparation Analyst
Technologies: FoxPro DOS
Analysis, design and development of several financial utility programs and the creation of various reports and programming of special projects
Data processing entailing the downloading, masking and massaging of financial institution data
Computer operations and macro application programming
08/1990 – 09/1991 Sunbelt Savings, Federal Savings Bank
Adhoc Reporting Specialist
Design and development of macro applications
Technical support and special projects
Form design, word processing and reporting of banking information
09/1987 – 12/1989 San Antonio College
Work Study Program Student
Data entry and word processing
Information retrieval and aid in student registration
Processing and filing of student course drop requests
General office procedures
09/1986 – 05/1987 Datapoint Corporation
High School Co-op Student
Word processing and distribution of in-house product release schedule
Backing of information from system to magnetic tape for archive storage
Computer operations
Education
1988 – 1991 San Antonio College
Associate CICS Computer Science