Design, manage, improve and support SSIS ETL packages for Quote and Phone System Data Marts.

Designed, optimized and managed SQL Server Integration Services (SSIS) ETL packages to update the company's data warehouse.Created and managed Epicor ERP customizations, web service integrations, business process workflows, business activity queries and dashboards.Acquired, scrubbed, converted and loaded QuickBooks data for Epicor ERP9 Financial Implementation.Created SSIS package that imports billed invoices from two custom order systems into Epicor via web services.Created Epicor structure, process and reports to process customer rebates, SIP fees and group payment organization (GPO) payments.Created SSIS package to automate the delivery of Sales and AR reports to over 70 sales representatives via SSRS web services.Created SSIS package to automate the delivery of SSRS Equipment Repair Reports to customers via SSRS web services.Performed extensive Epicor ERP9 to ERP10 upgrade with only one half day down time for the Finance department.Converted Epicor ERP web services integrations, business process workflows, business activity queries and dashboards for ERP 9 to ERP10.Optimized stored procedures by analyzing execution plans, implementing proper design and creating appropriate indexes.Upgraded SQL Server databases from 2008 to 2012, which included migrating SSIS packages and reports.Created automated morning DBA reports that show the status of jobs, maintenance tasks (including SQL backup jobs), SSRS subscriptions, data warehouse ETL, SQL server database file sizes and the results of Epicor integration job.Created SSIS package that imports cleared check data and updates check records in Epicor via web services.Create SSRS dashboard for Contract Utilization that is used by customers and sales representatives.Created SSRS report solution to print Epicor barcodes for parts, bins and employees.Created customize Epicor form that allows technicians to quickly enter part transaction using a handheld scanner.

Designed SQL Server Integration Services (SSIS) packages to securely transfer data from various data sources including MySQL, MS Access and various file formats including Excel, Text and HL7.Used Fuzzy logic to match patients from external systems and to identify and clean duplicates patients.Optimized queries and helped design ETL process that created and sent data files to Teradata WarehouseMigrated Company's Integration Service packages from SQL Server 2008 to 2012, which included training the other members of our development team.Saved organization $10,000 annually by creating a process to perform vendor code updates in EMR system.Improved the quality of patient care by designing and implementing a system that exports data from Allscripts Enterprise system to provide point of care patient information on Quality Metrics.Developed patient demographic data import tool for merging medical offices.Created Integration Services package to update Active Directory accounts based on PeopleSoft database.Created ETL process and reporting solution for Shoretel phone system.Located and delivered information from various undocumented vendor database system including Allscripts Enterprise EMR, Allscripts Practice Management, MAS500, PeopleSoft, RIS Imaging, SOAPware, OneApp, Shoretel, Phonetree and ConnectR.Developed application to generate revenue projection spreadsheets based on medical charges and insurance payer mixes.Developed a task management system that automated the HR, IT, Risk Management and Accounting setup for new hire, transfer, termination and mergers.Developed IS ticket tracking system that coordinated IT outages and issues.Created Intranet Site with content management tool.

Responsible for administration, design and modification of Fox Pro Insurance Database SystemDeveloped applications using Visual FoxPro language and report designer Developed ASP.NET Web Applications for clients that enabled them to view information about Enrollment, Benefits, Eligibility and Claims.Maintained provider data from Preferred Provider Organizations Created Extract Transform and Load routines for medical claims, eligibility and accumulation data.

Performed repairs and preventative maintenance on security system and equipmentResponsible for training and pager response to emergency outages.Ordered parts and documented maintenance.Scheduled calibration of test equipment.