Richard M. Mendez

*** ******

San Antonio, Texas 78237-4206

210-***-****

adxbt3@r.postjobfree.com

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

Contact this candidate