InTouch Med Supply provides high quality healthcare options and services for patients, providers and insurers. Our process eliminates the challenges associated with traditional ordering of supplies - we make getting supplies easy and provide customized solutions to reduce costs, increase compliance and ensure better health outcomes. We are experts at identifying and filling care gaps with continued long term success. Keeping You Informed, InTouch, and In Control of Your Health.

Technology Consultant and Application Developer

Contractor for the U.S. Department of Interior National Park Services for developing and modifying new and existing MS Access applications in VBA and SQL using normalization, constraints and implementation standards.Assist with creating an Excel pseudo application to eliminate redundancy with data entry for multiple divisions.Create and implement MS Access modules as part of the implementation standards for developers on future projects including assisting in creating semi-add-on applications.

Contractor responsible for creating and modifying MS Access and Excel applications via VBA and SQL development including migration.Incorporate and create SQL stored procedures and views to improve efficiency and work flow.Other duties included analyzing current applications, software and process flow and providing a detailed outline of application infrastructure, recommendations of improvement and integrated solutions.Clients consisted of a furniture manufacturing company, Medical facilities, Electronics, Airlines and Global tax companies.

Develop a secure web portal for customers to display HOA property information. Web portal is a semi-conversion of a Microsoft Access Application and is linked through SQL Snapshot and MS Access.

Responsible for Departmentalization within the Company including functional and process restructuring of work flow while designing and redesigning desktop applications in MS Access, MS Excel, VBA, MS SQL and .NET.Responsible for documenting, modifying and designing Application Procedures, Manuals, Business Rules and Programming Techniques and Coding Logic to new and existing Applications.Collaborated with C-Level Executives and Directors to analyze, implement and train Developers and End-Users while assisting the CIO as acting Project and Department manager on team development and project leads.Worked with the Director of Finance on creating BI financial dashboards, operational statistics, forecasting and BI reporting tools for business investors.Designed and developed a Planning and Routing Mapping Application (S.M.A.R.T.) using MS Access, MS Outlook, C#.NET and Google Maps for both Web and Mobile Apps for the iPad and iPhone devices.

Software Developer/ Business Analyst and Liaison/ BI DeveloperMarch 2005 - July 2017Developed VBA MS Access/Excel and .NET/SQL Applications to assist in reducing over $21 million dollars in School District Transportation cost for multiple School Districts across the United States which included Hawaii, CPS, KCMSD, TUSD, RIDE, SSDMO, Arlington, EAA, GPS, Penn-Harris, PHILA, VICC, PennRidge, RSDLA, PMSD, PCCS, NPENN, OKCPS, MVUSD, MOORE, ELKHART and D300 School DistrictsDeveloped a GEO coordinates ERP application integrated with MapInfo and Transfinder applications including customized Student EDI imports and exportsDeveloped an Accident/Complaint System to track transportation incidents and Response ActivityDeveloped and Trademarked a Route Assignment Tracking SystemPayroll Manager/Software Developer/Data ArchitectSeptember 1999 – March 2005Responsible for processing payroll and billing for over 1,000+ employees in 12 states Designed an ERP System which integrated the Payroll and Billing Application, Dispatch Program, Scanning Application and ADP via MS SQL, MS Access and MS Excel which included customized EDI billing processes

Create ad hoc, metrics and analytics BQY (BrioQuery) reports using Hyperion Interactive Reporting Studio for Financial Data Analytics and Analysis from multiple Data Warehousing databases from different countries. Manage, organize, create and implement a standard process for query development and documentation including developing a meta and data dictionary. Restructure and optimize Hyperion queries by developing an application to automate user interaction and aggregated requests. Develop applications using Microsoft Office, SharePoint and Hyperion Reporting to automate, enhance and streamline process flows for the Enterprise Risk Solutions/ Risk Advisory and Assurance Services. Develop a Query Inventory Document (QUID), Query Request Support and Audit Transaction Status application.

Technology used: SAP BO/BI Crystal Reports for EnterpriseDuties: responsible for creating financial reports using Crystal Reports through ODBC Oracle Wire Connection. Schedule daily, weekly and monthly email distribution of Crystal Reports in Central Management Console (CMC). Created reports using multi-layer groupings, aggregated formulas, user prompts, records and group parameters with multiple queries, views and custom SQL

Technology used: VBA, MS Access/Excel 2003 – 2007, MS SQL Server 2003-2005, MySQL, Crystal Reports, Database Integration, MS SQL and queries. MS Visual Studio 2008, Visual Web Developer 2008, Photoshop, Flash and Dreamweaver CS3, C#, AJAX, JavaScript and iTextSharp, WCM, CMS, C#/ASP Web User Controls and Terminal ServicesDatabase/System Administrator/Acting Project Manager and Application AnalystNovember 2010 – January 2013Duties: Integration, migrations and interface development using Relo Assist from Move Assist International, UK, QuickBooks, MS SQL, MySQL, MS Access/VBA and ODBC.Web Application Developer Consultant September 2010 – November 2010 Duties: Develop multi-user .NET/C# application for U.S. Customs and Borders Protection (CBP).System/Business Analyst, Application/Web Designer/Developer, VBA and MS Access Developer ConsultantFebruary 2009 – September 2010 Duties: Develop and modify MS Access applications via ODBC, MS SQL, MySQL with Data Integration

SQL Server Reporting Services (SSRS) DeveloperThe United Cerebral Palsy of Greater Kansas City (UCP)March 2012Duties: Assist in developing a SQL Database from MS Access 2010 and redesigning schematics for an online Training application using MVC3 in C#.NET. Developed SQL Server Reporting Services (SSRS) using Visual Studio 2008 Business Intelligence.MS SQL DBA DeveloperJobs and Employment Support Services (JESS)October 2009Duties: Participated in the St. Louis Coders 4 Charities charity event. The organization I participated in with fellow developers was the Jobs and Employment Support Services (JESS). Our goal was to build a Client Management Application in a .NET Framework in an n-tier architecture system. We modified and created 164 stored procedures, generated over 40 tables with foreign constraints using MSSQL Server 2005 Query File and Microsoft Visual Studio 2008 in a Subversion repository environment. Flash Banner Developer, Flash Slideshow and ASP.NET forms DeveloperCass County Jobs Club, AdHoc Group Against Crime and Midwest Foster Care and Adoption AssociationApril 2009Duties: Participated in the Kansas City Coders 4 Charities charity event. The organizations I assisted with fellow developers were:Cass County Jobs Club - Flash and Graphic Design Header using Adobe CS3 Flash and PhotoshopAdHoc Group Against Crime - Flash slideshow using xml and Adobe CS3 FlashMidwest Foster Care and Adoption Association - Created Win Forms using Visual Studio 2008

C# Web DeveloperData Driven XML to Free Flash Video and GalleryOctober 2011Demonstrated how to build a Data Driven XML builder for different Free Flash Video and Flash GalleriesDemonstrated how to build a Traffic Tracker, events and newsletter email and mobile text generatorRich Text CMS EditorCMS with Text Control in C# ASP.NETSeptember 2009Presented a couple of sites in which I incorporated a Rich Text CMS Editor Demonstrated how to add and configure the editor by providing code snippets Demonstrated how to change the SQL statement to access the content from the database C# code snippet to use to verify authentication to edit the website

Technology used: CS3 Photoshop, Dreamweaver and Flash, JavaScript, HTML, Visual Studio 2008, MS SQL Server 2005, ASP.NET and C#, jQuery, AJAX, VBA, MS Access and Excel 2003-2010 and SSRS.Web Designer and Application DeveloperNew York Film Festival March 2011 – August 2011 Duties: .NET/C#, newsletter, email client, web tracker and text editorWeb Designer/DeveloperAlexiya LourdesNovember 2009 – November 2009 Duties: Performing Arts websiteWeb Designer/DeveloperBliss FestKC August 2009 – September 2009Duties: Build website for Kansas City 2nd Annual Raw Foods Bliss FestivalWeb Designer/DeveloperRaw Liberation July 2009 – August 2009Duties: WebsiteVBA/MS Access Application Developer Simple Solutions, Tamil Nadu, India May 2009 – July 2009 Duties: Modify MS Access application with SQL BackendVBA/MS Access Application DeveloperGas Installers Limited, United Kingdom, England April 2009 – January 2010Duties: Develop customer and service order invoicing systemMS Excel Macro Script WriterUS Army September 2006 – September 2006 Duties: Prepared an automatic script to update the status of Battle Command Training Support Program (BCTSP) Mission Essential Requirement (MER) elements in ten different excel workbooks with numerous spreadsheets in each.

• Handled all data entries using Windows NT for the integration of the New ATV Server.• Maintained client rosters and master lists.• Trained part time and full time employees with application cleanup.• Sat in as an instructor’s aide during classes for Domestic Violence.

• Processed payroll utilizing MIS and American Fundware System. (800+employees)• Prepared group control forms for US Healthcare, Pension, Prudential Life and Dental Applications.• Process wage withholdings, unemployment claims, lawsuits and employee verifications by phone or via mail.

• Processed payroll utilizing the OMNI System. (600+employees)• Process wage withholdings, unemployment claims, lawsuits and employee verifications by phone or via mail.

• Processed all customer receipts and down loading data from a handheld computer to the mainframe.• Serviced customer accounts, processed daily transactions and files via Lotus 1-2-3 and WordPerfect.