• Creates ad-hoc queries to identify and analyze bottleneck, inefficiencies, and clinical and operational trends• Develops Microsoft Access applications using VBA to address complex reporting needs• Reviews operational procedures to develop recommendations for process improvement and issue resolution • Develops html pages equipped with javascript and css with hand-written code• Creates Access database with tables, queries, switchboard form and modules.• Writes VBA with embedded SQL to import member information on national and state levels; separate Excel worksheets by county; export into Excel.• Develops Visual Basic applications to sort flat files containing phone numbers. • Maintains phone line and pager activation/deactivation reports as well as end-of-month and end-of-year financial reports in MS Access and VBA. • Performs data cleanup in MS SQL of addresses and phone numbers.• Performs data updates on Sybase-SQL for category/sub category tables.• Creation of a Client Server Access database using VBA to track sales and rental information. • Creation of an MS Access client server database to track budgets, time and general expenses. Also taking various aspects of the business currently in paper form and incorporated them into the database. • Creation of reports and modification of existing reports using Crystal Reports with Access and SQL Server backends.• Installs, maintains and upgrades databases and teaches the use of the program to end users.• Designs and develops a custom MS Access application to optimize telecommunications phone rates.• Created an in-house database program to manage the consolidation of entire corporate financials for operating expenses (budget vs. actuals).Clients Include: Comcast, Doubleclick, Qualcomm, Qwest, Level 3, Time Warner Telecom, Agilent Technologies, Spectrum, LaradonTechnologies used: VBA, SQL, Access, VBA, MS Access, MS SQL, Sybase, VBA RedGate SQL Toolbelt