SUMMARY:

• Over twenty years of leadership and technical experience in information technology, business and healthcare. Expert in gathering, analyzing and defining business and functional requirements; creating global metrics, trend charts and other decision - making tools; and designing/re-engineering processes, workflows and technology solutions for business systems and networks.
• Medical Technology (Clinical Laboratory Scientist) and Computer Science degrees provide a strong understanding of healthcare and information technology requirements.
• Excels at designing innovative solutions to system issues, results driven, knowledgeable, and accommodating; applies an eclectic background to strategic and operational activities to create synergies between functions, teams, and systems that are both user friendly and highly effective.
• Network & Systems Administration
• Data/Business/Systems Analysis
• Data Flow & Process Mapping
• Complex SQL Queries & Data Modeling
• QA/QC/QI / Instrument Validation
• Advanced Troubleshooting of Hardware and Software
• Execute Data/Trend Analyses
• Database Design & Management
• Complex Software/Systems Implementations
• Systems Security & Disaster Recovery Planning
• Testing/Scripting/Documentation
• System/Application &
• Business Process Improvement
• Create/Build Business Solutions
• Decision modeling, forecasting, statistical programming, data mining, code production and documentation.
• Clinical, financial and business reporting
• Experience with primary data sets and large, national databases. Provided expert, organized data management and accurate, timely results for clients. Proficient in a variety of statistical programs and database management tools. SAS, PowerPoint, Excel, Access, Visual Basic, SQL (Microsoft SQL Server, Teradata, MySQL), Visual FoxPro, Business Objects(6.5, BOXI, DSKI), SQL Assistant, & Crystal Reports, SAP, SyteLine ERP
• As an IT manager for several multi-million dollar corporations was responsible for management of day-to-day computer operations, including troubleshooting and debugging various software applications. Implementation of systems, application and infrastructure updates and enhancements Administration of application security and backups. Performed updates to application data tables supporting: customer demographics, ordering, billing, accessioning, work-flow, data entry, results reporting, and shipping.

PROFESSIONAL EXPERIENCE:

Confidential

Customer Database Analyst

Responsibilities:

• Revisions to the POS workflow, resulted in significant improvements to the accuracy and accountability of the sales commission reporting.
• Utilized SAP queries to standardize distributor accounts and demographics, eliminating archaic or legacy corporate data structures. Automated the processing of e-mail attachments containing POS records.

Confidential

Mortgage Servicing IT Application Programmer

Responsibilities:

• Automated the maintenance and support of the reporting data warehouse, utilizing enterprise level SSIS, SSRS and SSAS tasks to perform scheduled jobs.
• Design and develop special reports needed by users created reports and extracts utilizing custom views as defined by user requirements.
• Performed complex conversion of legacy COBOL copybooks into SQL Server tables, used in the ETL processing.
• During two extended communication outages between Wilmington and Ann Arbor, served as onsite liaison and facilitator between multiple external vendors and Corporate IT staff in Ann Arbor MI.

Confidential

Contract VBA Programmer / Analyst

Responsibilities:

• Worked on team defining requirements to combine 3 divisional versions into a consolidated core release.
• Developed VBA modules adding functionality for revision of subject identifiers.
• Defined and created framework for direct interfacing of local laptop and remote server USB based measurement instruments. This included modules providing USB serial communications; UID/PID based device identification and serial port assignments. Performed analysis of current Windows Server 2008 configuration and documented work plan and server updates required to support remote USB device communication between remote laptops utilizing virtual windows sessions and the host server applications.

Confidential

Sr. Business Information Analyst

Responsibilities:

• Created a self-contained reporting suite in 45 days that documented physician visits for the Connecticut Husky Medicaid program. Provided remote and support for Connecticut associates. This project met state mandated reporting guidelines and a tight deadline. This was an Access application utilizing MS-Access forms and tables, SQL pass-thru allowed local data refreshes from the corporate data warehouse. Reporting utilized VBA and imbedded Excel worksheets and graphs.
• Created and utilized SAS and Business Objects XI applications that supported Ad Hoc reporting for corporate wide requests which allowed business partners to utilize information stored in the data warehouse. Extracted results were presented to the requestor as MS-Access tables/reports or as Excel workbooks. Returned information ranged from formatted raw data to highly summarized Excel graphs. As a result, productivity and efficiencies improved enterprise wide.
• Automated analysis and creation of semi-annual disease prevalence and utilization reports for all diseases monitored in managed care programs which reduced report generation time by 50-75% .The revised design utilized table driven updates. Settings stored in the table included values for worksheet titles, date ranges, table labels for section, column and rows. Additional graph layout and design settings allowed standardization of workbooks (cloning) across all the diseases monitored. Utilized VBA table changes propagated across all linked worksheets and graphs, eliminating the need for manual updates to individual fields within each worksheet and graph. Reducing manual updates of worksheets permitted a consistent master report to be published.
• Automated the Top 25 Diagnosis and Top 25 ICD-9 reports. Historically, each permutation of age and gender variables required manual updates to each worksheet. Redesigned these complex reports utilizing VBA to drive nested SQL queries. VBA permitted cycling of variables (age, gender, etc.) which passed to the imbedded worksheet queries, graphs and filters. This created over one hundred detailed workbooks for inclusion in each master report. This automation generated savings of over 1 month of production time. This process was applied to the Top 25 ICD-9 Diagnosis Annual report as well.
• Developed a monitor to identify members at risk for postpartum depression. Created an application utilizing Access, Excel and SQL queries to review member’s claims. Potential members at risk for postpartum depression were identified using CPT codes, ICD-9 codes, medication history and other factors. Identified members received al materials on postpartum depression and a health nurse follow-up. This pilot program was approved and was implemented nationwide.

Confidential

Manager Information Systems

Responsibilities:

• Utilizing VBA, FoxPro, Excel and Outlook, automated the order processing for laminated countertops and cultured marble products. Redesigned the order processing, created production management tools and processes to improved JIT inventory and assured 100% customer orders were correctly filled.
• Enhanced financial reporting processes utilizing VBA to link Excel, FoxPro and Peachtree Accounting systems to simplify/optimize usability. Automated financial postings reduced manual input postings by 95%.
• Created and implemented Visual FoxPro EDI application which reconciled cabinet vendor’s invoices back to original customer’s orders. This automation reduced manual invoice processing labor requirements by 95% and assured billing was correctly invoiced and paid promptly for purchase discounts to apply.

Confidential

Responsibilities:

• Assisted in the reconfiguration of a Laboratory Information System to support a new lab’s specifications.
• Using Progress 8.1, created over 200 complex applications and reports. This enhanced the SyteLine modules and met our changing business requirements. Implemented integration of production equipment (CNC, Automated Saws, and Routers)
• Completely revised Access based ERP inventory module to support bar coding. Redesigned form processing utilizing preprinted product and location barcodes on tally forms. Optimized and streamlined workflow of data processing. The external auditors felt this greatly improved the accuracy and consistency of the quarterly inventory process. Labor hours for data input were reduced 67% and Factory staff was released 4-6 hours earlier than prior inventories.
• Planned and led implementation of replacement of corporate communication systems including: T-1, frame relay links and Internet services. Lead implementation project replacing non-Y2K compliant telephone switch with new NEC IVS 2000 telephone switch; renegotiated Long Distance providers and contracts; reduced annual telecomm expenses/costs 75% or $72,000/year; redesigned workflow of voice mail; and implemented automated voice answering systems. Project included replacement of all original equipment and wiring. Project completed on time, on budget and with zero customers’ down time.

Confidential

Network Administrator / Systems Analyst

Responsibilities:

• Developed and enhanced applications to support a paperless design (blueprint) system for production factory.
• Supported all PC based corporate systems including: Hyperion Financials, Optika - Document imaging management, ADP Payroll / HR Partner, MS-Word, MS-Excel, MS-Access, MS Mail, MS-Back Office Suite and Solid Edge 3-D CAD.
• Supported an Access application for SWECO’s Macon, GA division which managed the site’s sales orders and production data. Implemented enhanced security, data backup, reporting and printer support. Developed barcoded application for Inventory management of Macon factory.

Confidential

Micro Systems Programmer Analyst

Responsibilities:

• Automated month end financial reporting using VBA linking Great Plains Accounting, Excel, and FoxPro applications which resulted in annual savings of over 1000 hours of Senior Accountant labor. Eliminated manual data entry of updated values for monthly financial reports. Workbooks were linked to a forecast or a plan database to populate worksheets with current values. All financial reports were driven from a common data warehouse.
• Created a policy/applicant payment tracking system, CASHTRACKER, which eliminated misfiled payments. Using Excel, FoxPro and VBA modules combined with barcode and MICR check readers, streamlined new application processing and implemented additional cash controls which resulted in reducing over $100,000/year in premium write-offs and eliminated labor intensive manual research of problems and auditing.
• Created a PC application to automate all annuity programs saving over $80K per year in labor costs. Received the Manhattan National Life's Star Performance for this project.

Confidential

Senior Financial Systems Support Analyst

Responsibilities:

• Automated posting of journal entries reducing data errors and reducing associate data entry time by 75%.
• Moved 45,000 pages of monthly P&L reports to in-house printing which reduced the fiscal reporting cycle by 2 days each month and reduced costs by 50%.
• As a Technical Project Leader, managed the conversion of a DOS-based Micro Control Financial Reporting application to the Hyperion Financial reporting system under Windows. Optimized and defined all business rules used for Financial Reporting. Redesigned all financial reports and automated posting processes. Upgraded all Accounting Associates’ PC’s from DOS to Windows 3.1. Provided user for all associates. Reduced the processing time spent during monthly closing and financial reporting from 2 weeks down to 4 days.
• Received the Annual LensCrafters Shining Star, received Accounting and Finance Associate of the Quarter for two quarters, and nominated to the President’s Horizon Club for optimizing corporate accounting and financial systems and implementing Hyperion Financials.

Confidential

Information Specialist

Responsibilities:

• Developed complex PC applications in FoxPro.
• Developed over 300+ SQL Applications (Cerner Command Language) for the Cerner LIS which included customized reports and enhancements to the PathNet applications and systems. Implemented and validated custom instrument interfaces integrated with the Cerner PathNet modules which enhanced the efficiency of the laboratory operations and clinical reporting.
• Developed a SQL sub-system for Cerner LIS automating the capture of all clinical testing results for all Hematology-Oncology patients during any hospital visits. This permitted the direct uploading of this data into the Hematology-Oncology research data server eliminating all manual data entry and eliminated 95-100% clerical errors.
• Performed advanced troubleshooting and support of clinical laboratory instrumentation
• Assisted in conversion from paper based reporting to Cerner LIS- based reporting.