SUMMARY:

• My computing skills are Intermediate and Advanced, in designing / coding, testing and maintaining front - end (Enterprise Recourse Planning applications) and "SPECIALTY SOFTWARE."
• For the past 25 years I have established a history of building successful professional relationships.
• ERP Developer: 12 years in Visual Basic 6 w/ ADO; Client /Server, VBA, MS-Access, Excel (Office 2000, 2005, 2007, 2010)
• 12 years experience in database programming using SQL-Server w/MS-Access and Excel w/xla(Macros), w(SSIS/DTS), ORACLE-9i, and ODBC via DSN.
• 8 years WSH script, VB Script, VBS, HTA, JavaScript, HTML, Regular Expressions.
• 6 years Project Management and Enterprise Resource Planning .
• 5 Year Perl, ASP.NET w/ C# Forms, XML, C++
• 4 years Java-Script, XML, HTML languages and Internet security, Crystal Reports (6-9)
• 3 years SharePoint 2010, Info Path
• 2 PowerBuilder 2012
• 1 Year (workflow engine software) Pipeline Pilot, Knime, Sample manager (LIMS)

PROFESSIONAL EXPERIENCE:

Application Architect / Programmer

Confidential, Houston, TX

Responsibilities:

• I completed design, development and go live implementation of the "Procurement" creation, retrieval and tracking tool needed for concurrent manipulation of records by over 100 users . The program is VB.NET using SQL 2012 as the database. This project involved converting all data, logic and computations originating in excel sheets. Next the proof of concept was established, then the .Net application was created (in version 2012).

Application Analyst / Programmer

SHELL, Houston, TX

Responsibilities:

• Used advanced VBA (in Outlook, Access, Excel) for data retrieval, and reports. And Crystal Reports
• Created advanced views in Oracle, and used ORK (Operational Reporting Kit) to generate various financial/auditing reports.
• PowerBuilder development: Created MDI test applications for data retrieval, GUI based applications.
• Used Workflow Software (Knime and Pipeline-Pilot: both are module based Node Repositories) for creating test samples on how to easily model chemical/laboratory processes used for Fracking and Subsurface Well data/ reports.
• (Manager Carl Cadis and Jack Jones.)

Enterprise Resource Planning Architect /SQL Programmer

Confidential, Houston, TX

Responsibilities:

• This Application is used to estimate the cost of “Materials, Resources, and Time” needed to accurately charge/bill a client; and make a standard market profit. The database used is MySQL stored procedures and triggers. Created process specifications for a standard data-dictionary, application naming convention and programming /coding standards -for creating Queries and Routines.

Application /SQL Programmer

Confidential, Houston, TX

Responsibilities:

• Several automated scripts written in VBS to Update, Delete and Parse data on OHM SQL Database. It then returns data via CSV format and then Emails all designated recipients and users, and also creates a LOG file for archival audit. This script is run on the MS Task Scheduler.
• Several MOH Disclosure Forms, using Three Languages, C#, VB Application and ASPX.NET website. The data source is both SharePoint 2010 and SQL Server 2005. The data is parsed from SharePoint into a CSV, and Data is saved in SQL Server.

Application /SQL Programmer

Confidential, Houston, TX

Responsibilities:

• I maintained and updated the payroll process from a legacy system to a .Net compatible system. The application was created in MS Access and uses CSV data from UltiPro (Cognos) and SQL Server 2005 & 2008 and PL/SQL data. I maintained and stabilized the Access.mdb (by tweaking all the VBA code and sql code). First I created DTS Packages for converting the CSV files into the database, and SSIS packages to Create New Tables and special data manipulation. Next I updated it to a C# webpage GUI for navigating through the payroll process. I created multiple SSRS packages that automate -via email- new reports every Friday.
• I modified over 50 SQL queries consisting of Casting Date/time, strings and integers into proper data-types. I used Cursors, Nested statements, and Unions in both T-SQL and PLSQL to create Table, SP, Triggers, and Indexes. I created an ETL process that extracts, transforms and loads correct data from TSQL into PL/SQL, and Microsoft Dynamics AX views.
• I Created a VB form for uploading Tax-information data (from a CSV file) into SharePoint 2010. Also used SharePoint 2010 to create a data entry form to capture users comments and requests. I converted critical sales data reports, from Crystal Reports into SSRS Reports, while maintaining the same complex report format and data integrity. As an analyst I wrote Business logic to calculate critical Sales and Employee data used to accurate balance paychecks.

Advanced Access Programmer / SQL Developer

Confidential, Houston, TX

Responsibilities:

• I developed VB6 frontend application, with multiple MS Access database systems (both 2000 and 2007) into a Purchase Order tracking system.
• I designed all Vb6 and Macro programming, and forms that dynamically retrieves data, updates the database, and creates reports and Charts.
• My forms and reports, allow the user to login, enter & track purchase-orders, and to view very complex (Daily, Quarterly & Yearly) Charts.
• The Charts reflect Budget vs. Actuals (trending performance metrics) and critical incident-reporting Data.
• I improved the speed of the database by 40% by rewriting code, tuning the Database and transforming the Data (i.e. the Data contained Nulls, and incorrect Data-types).
• The Database is backed-up for recovery as an MDE file type.
• All of the coding procedures and processes were thoroughly documented.
• And the Module code is scalable for future conversions.
• I used SharePoint 2010 as a repository to store new releases of all Production applications.

Programmer

Confidential, Houston, TX

Responsibilities:

• I completed design development and code correction for SQL 2005 and Oracle, for Project “Budget Application”.
• This project involved fixing and creating the Interface, the modules and the SQL Code for multiple frontend applications (including, Javascript page, MS-Access, Excel, Outlook).
• Also I created new code, new queries for data retrieval, from the backend Essbase Hyperion database.
• The manager of the project is Stephen Yeatts:

PL SQL Programmer

Confidential, Houston, TX

Responsibilities:

• I preformed extensive T-SQL and Pl-Sql Programming.
• All programming was for Data verification in PL-SQL and MS SQL 2005 & 2008, for HL7 HIPPA data.
• The Data was migrated from NDO data warehouse to IKM (Iknowmed) data base.
• The queries I created, verify that all data was transferred correctly.
• Tools SQL-Squirrel, TOAD, PL/SQL Developer, SQL*Plus.
• I used DTS and SSIS packages for testing data conversions.

Programmer

Confidential, Houston, TX

Responsibilities:

• For SABRE (airline data) I Created a VB PowerShell server-side script for Transforming the XML and XSD files into a delimited flat file, to be used in a VB.Net application.
• The VB.NET app uses Crystal Reports, Excel, Access, and SQL 2005 to generate multiple reports and spreadsheet.

Application Specialist Analyst/ Project Management

Confidential, Houston. TX

Responsibilities:

• Programmer lead in (SDLC) Systems Development Life Cycle, process creation, using VB6, VBA and Excel for mapping, migration and creation of Data Safety purchase order Material Sheets.
• The project captures data input, and saved it as a text file; data is then used for Dashboards, and Excel reporting, and the following databases; SAP, SQL, Access and Fox Pro, and SharePoint 2007.

Application Systems Analyst

Confidential, Houston, TX

Responsibilities:

• Resolved Data migration issues from legacy system to SQL 2005.
• Created Update, Insert, Delete queries, and stored TRIGGERS on Test-box and Production-box. I utilized SSIS packages, SSRS, SQL-optimization tool, Access and Excel to map, and migrate data for testing and Reporting.
• I Created an HTA (intranet) Dashboard using Excel charts and reports as a Kiosk for daily-time log application.

Project Manager / Programmer

Confidential, Houston, TX

Responsibilities:

• Created SOA (service oriented architect) for migrating GDS data from Online booking tools -such as Sabre, Apollo and other legacy systems- into SQL 2000 & 2005 servers using WMI.
• The application has several phases: the “ETL” process using .Net w/C#, VBS, HTA/JavaScript, to instruct the Sabre server to return XML files. Next VBS parses the XML files (using RegEx,WMI, J2EE, Perl) into readable text files that are sent to SQL 2005 via SSIS package’s and FTP to the server.
• Once stored on the serve the data is transformed into business logic data. That data is viewed in an C#.Net application that prints out reports in SSRS format.
• The DATA is also used in HTA (a lite-web) VBScript DASHBOARD for internet data viewing; and also in desktop applications (including Access & Excel, for desktop frontend reporting).
• My process currently saves the budget 30k a month in outsourcing costs. Platform used: XP, w/ Office 2005, 2007.

Project Manager /VBA Developer

Confidential, Houston, TX

Responsibilities:

• Developed VBA code (Access and Excel 2005 & 2007) to obtain data for cumulative Oil and Gas production and Reservoir pressure by volume.
• The program strips Oil/ Gas data from a master file, parses the data (via VBScript code) and transfer the needed data to a new worksheet.
• This process saves users over 30 hours per week by automating an ‘Extract Transform and Load’ process within an excel environment.
• The program uses ODBC to store data to the secondary database in SQL 2005.
• The program has a frontend Dashboard (in Excel 2000) displaying charts, data, and images.

Project Manager/VBS, VB.Net Developer

Confidential, Houston, TX

Responsibilities:

• Develop solutions using SQL, C++ Dll, VBS, VB.Net, Access, VISIO and PowerPoint for (Office 2005 & 2007) programs to obtain data for Engineering product production, metric calculations and drawings.
• The applications are designed to retrieve data from Cognos, Oracle, SQL server, and websites via FTP. The programs are mainly created in VBS/HTA and JavaScript, (using RegEx, Send-Key, ODBC connection strings), and run across the local net and internet. This process saves users over 40 hours per week by automating an ‘Extract Transfer and Load’ process within an desktop environment.
• I use Data-Miner tools to retrieve data from PDF files as well.
• Used Cognos Impromptu to alter database tables for new reports requests.

Sr. Analyst / Project Manager

Confidential, Houston, TX

Responsibilities:

• Developed Reporting specification for Facets Database, and new Stored Procedures for SQL 2005 Data Management Protocol. Resolve issues related to Companywide reporting needs.
• Created Crystal Reports11 applications w/ advanced queries/triggers/stored procedures DSN/ODBC connections: used .Net frontend using C# and VB, for retrieving and displaying HIPPA, Medicare data for corporate users and customer requests.

Sr. Programmer Analyst/ Project manager/ Contract

Confidential, Houston, TX

Responsibilities:

• Developed office 2005 applications (Excel and Access) into ASP.NET pages. Scripted (VBS, HTA, JavaScript WMI, Shell, VBScript) ASP.Net, C#, with Ajax, VB6, VBA, ADO AJAX, XML and Windows Offices applications to communicate with; FTP sites, AS400 server, Oracle9 and, SQL server 2000 (using DTS packages ) & 2005 (SSIS packages).
• Main purpose is to create complex Queries, to generate specific information for Supermarket Analysis and reports.
• Project management of converting legacy VBA programs into VB.Net applications.
• Created several new business solutions for N-tare file transfer, and re-engineered VB6 programs using DSN/ODBC connections, into Oracle Data warehouse.

VBA Project management/ Contract

Confidential, Galveston, TX

Responsibilities:

• Created a new business solution by developing VB.Net frontend From for entering accounts payable data.
• I created multiple VBA applications (including VB6, Access, using ADO connections via DSN/ODBC, and complex Pass-through Queries, into Oracle and SQL server 2000, to pull a series of detailed specific information for (Financial Analyst) Annual reports.
• Reports are created and viewed in Access and Excel spreadsheets.

VB Programmer/SQL Developer

Confidential, Clear Lake, TX

Responsibilities:

• Developed complex, detailed specific production Stored Procedures for data migration from Oracle to T-SQL 2000, for Sentinel system.
• I developed frontend standalone form in VB.Net, using ADO.Net connections via ODBC, for viewing SQL 2000 Database information. I re-wrote error handling and logs in SQL.
• I used DTS Packages to automate the transformation of flat file data into SQL specific Data types.
• I used Crystal Reports 11 to generate error status reports. Use Seibel as tracking tool.

Project manager/ VB6 Developer/ Consultant

Confidential, Houston, TX

Responsibilities:

• Reengineered and Developed several VB6 Dashboard programs, for use with MS-Access as the backend.
• The Application allows for data to be entered and reports to be generated.
• The application contains Form navigation, and several Summary and Detail reports, which are generated using advanced numeric calculations and specific weighted averages.
• General Duty: coding, testing, and debugging.

VB6 Developer/ Consultant

Confidential, Stafford TX

Responsibilities:

• Developed project design, coding, testing and debugging.
• The Front-End/Back-end application is in VB6 w/ ADO.Net via (ODBC) commands, using numerous Grids and Tabs and ActiveX objects.
• The databases used are, Access 2005, D2K, MS-SQL Server and Congnos.
• This is an Order Entry Application for Storing and Retrieving data.
• The application uses MS-Access to connect to Profit-21/ D2K server, to get or “extract, transfer and load” (ETL) data, and sends it to a Citrix Network server. Later it retrieve that Data, from that Network server, back to the D2K secure server.
• The application also uses the Data-Reporter, Excel - with Pivot tables, and Crystal Reports 8, and Access for viewing data and creating Queries.
• Utilized Visual Source Safe for application version backups.
• Used VBS/HTA and JavaScript for automating backups and recovery tasks.

Programmer

Confidential, Buffalo, NY

Responsibilities:

• Production Coding for Visual FoxPro product, AccuClaim Plus software.
• Customized applications in FoxPro ODBC Queries using Pre-Processors, EDI functions, developed PRG’s, DBF’s, and Memo field operations, for Text-Data manipulation of ANSI files.
• Created automated VBS/HTA and JavaScript’s to back up database.
• Use Seibel & Relational ClearCase as data transfer tool to record routine transactions that improve application exchange.
• I also developed a software tracking system for Database GUI, using VB.net w/ Access.
• The software system is titled HIPAA-Plus. It is used for interpreting Transaction-Set standards as prescribed by HIPAA.
• The software reads, formats and writes HIPAA EDI files for submitting UB92 and HCFA Forms.
• The front-end is a VB6 form, w/ Microsoft Access as a temporary Database.
• The software also encrypts text for security over the internet.
• The Database is Oracle8. I use a C# form for updating XML code, within the database, for speed performance.
• I Utilized Visual Source Safe for versioning back ups.

Application Programmer

Confidential, New York Buffalo, NY

Responsibilities:

• Develop advanced customized applications in Visual Basic, MS-Access, complex VBA excel Macros, and VBS, HTML and JavaScript for client/server Data Warehouse Projects.
• Use DDL to Create and Update Transact-SQL Tables using MS-Query for ODBC, on MS-Server 2000 platform.
• Able to build Queries within ''Erisco-Facets for querying HIPAA, insurance data, pertaining to specific claims information, dollar amounts and dates of services.
• The operating system is Win-NT: The Data source was Lucent, Viking, SAS-C, Sybase SQL server). Additional Duty: Data Analyst. Created Ad-hoc reports using VB6 Data-Report, Excel using macros w/ create pivot tables, and flowcharts, Crystal Reports 8 w/ graphs.
• Maintain Data Warehouse, with accurate and proficient information. Utilized Visual Source Safe for application version back ups.
• Created applications and spreadsheets in VB6, Excel w/ MS-Access for an Intranet' storage and retrieval database and for passwords and secondary applications.
• Used SQL-Builder for creating ODBC /Pass-through Queries, for database manipulation.
• Created reports using VB6 Data-Reporter.
• Additional Duties: Preformed collections /investigation on Workers Compensation, Auto insurance.

Application Designer/ Claims Manager

Confidential, Pittsburgh, PA

Responsibilities:

• Created (DHTML w/ Visual Basic 6) data-base, for online Hospital Confidential t Demographics and Information retrieval system.
• Used MySQL for storage and ETL.
• Used VBS, HTML and JavaScript to build intranet pages and Applets to run third party software.
• Re-Engineered Erisco facets Data-dictionary, for use with Texan Database.
• Additional Duties: Performed Accounts Receivable and Accounts Payable inspections of claims to be billed to customers (used Medipac and Texan Legacy system).

Case Manager / Application Designer

Confidential, Pittsburgh, PA

Responsibilities:

• Performed Medical Billing duties, and Maintained small Hospital's database (in VB6, MS-Access, Excel, created and JavaScript) for retrieving Confidential ts hospital information.
• Created complex Queries and SQL scripts (Object Database Connectivity) with SQL-Builder 97,to be stored in VB6 application for Accounts Receivable and Accounts Payable billing dept.