SUMMARY:

• My computing skills are Intermediate and Advanced, in designing / coding, testing and maintaining front - end Enter Recourse Planning applications.
• ERP Developer: 20 years in Visual Basic 6 w/ ADO; Client /Server, VBA, MS-Access, Excel (Office 2000, 2005, 2007, 2010)
• 15 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.
• 15 years WSH script, VB Script, VBS, HTA, JavaScript, HTML, Regular Expressions.
• 15 years Project Management and Enterprise Resource Planning .
• 10 Year Perl, ASP.NET w/ C# Forms, XML, C++
• 10 years Java-Script, XML, HTML languages and Internet security, Crystal Reports (6-9)
• 5 years SharePoint 2010, Info Path
• 2 PowerBuilder 2012
• 2 Year (workflow engine software) Pipeline Pilot, Knime, Sample manager (LIMS)

MY MEDICAL INSURANCE SKILLS ARE:

• 5-6 years HIPAA Medical Claims processing and Adjusting: HMO, Medicare, and Workers Compensation investigation and collections.
• 7 years Medical Billing and *Electronic Coding (*ICD-9-CM CPT/ HCPCS, *UB/92Revenue Coding)
• 2+ years HIPAA terminology

PROFESSIONAL EXPERIENCE:

Application Analyst / Programmer

Confidential, Houston, TX

Responsibilities:

• Develop business logic process and application for determining global expenditures for all computer applications.
• I developed an auditing application to calculate the cost for purchasing and to maintaining every application used globally by Confidential .
• This process estimated a saving of 2.5 million dollars yearly, by using multiple levels of invoice data and Tpmc2 (Slice) calculated formulas. The logic allows for applications to be identified for removal or expense savings.
• This process involves an (ETL) processes and parsing data from various data tools such as, EMPIS, APEX, SPOTFIRE, and FlexNet. The major database used is MS Sql Server 2012. The Application is written in VB.net app (Bata).
• 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.

Enterprise Resource Planning Architect /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.

Application Specialist Analyst

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.