Database administrator for SQL Server. Create reporting with Tableau, SSRS, SQL Server, and Oracle. Build and maintain SSIS ETL packages. Work with vendors to maintain third party software processes. Support internal client reporting needs. Provide occasional server support.

Developed reporting solutions with SQL, Qlik, Tableau, SSRS, Excel, and SSIS, including designing, creating, testing, and maintaining SQL queries, stored procedures, data warehouse tables, and indexes in a SQL Server 2016 environment. Presented reports to upper management and executives. Led training on reporting systems and various internally developed reports. Collaborated with internal teams and clients to gather requirements and feedback to ensure customer satisfaction. Trained junior analysts and new hires.• Led a project that combined data from two EMR databases with entirely different data structures. Built the necessary SSIS packages, data warehouse tables, stored procedures, and views to be able to report off of both systems seamlessly. Maintained created warehouses.

Developed reporting solutions with SQL, Qlik, Tableau, SSRS, Excel, and SSIS, including designing, creating, testing, and maintaining SQL queries, stored procedures, data warehouse tables, and indexes in a SQL Server 2016 environment. Presented reports to upper management and executives. Led training on reporting systems and various internally developed reports. Collaborated with internal teams and clients to gather requirements and feedback to ensure customer satisfaction. Trained junior analysts and new hires.• Responsible for installing, administering, and maintaining Tableau server• Rebuilt a classic ASP report in SSRS, which required redesigning the stored procedure and correcting errors in the existing SQL. The automated report saved 2 days of FTE work per week.

Produced ad hoc and scheduled reports for internal and external customers using Excel and SSRS in a SQL Server 2008 RS environment. Responsible for writing queries, creating views, tables, indexes, and stored procedures. Gathered specifications for new reports. Assisted and trained junior analysts.• Noted on performance evaluation for going above and beyond on mentoring fellow analysts.• Restructured the organization of the quality department reports and scripts, including documenting current reports, and archiving legacy reports.• Updated weekly and monthly Quality Business Review processes. Redesigned presentation format, built interactive Excel dashboard, using external connections, pivot tables, slicers, and formulas, and created other updated reports for the new format. Created a weekly review process to present current week analysis and to drive actions.

Gathered data from Access databases, proprietary financial software, Oracle databases with Toad, and Cognos reporting tools. Created financial reports with Excel and Access for executives, management and other internal and external clients. Performed invoice reconciliations in order to determine accounts payable to various clients, completed payment processes, and submitted documentation of amounts for book entries. Maintained relationships with various vendors.• Performed a large scale invoice reconciliation process which involved gathering 2 years of invoices and billing records. Updated Access database process to compare records more accurately and efficiently. Produced reports summarizing open, paid, and disputed amounts.• Created a new department process for paying vendor fees. Gathered specifications from management. Aggregated data from various sources and built tables, macros, and queries in several Access databases to perform the function going forward. Wrote documentation for the process.

Wrote and maintained data extract programs that created fixed length format data files utilizing SQL, COBOL, Easytrieve, and JCL in a mainframe DB2 database environment. Transmitted those files to third party vendors either via SFTP or hard copy and ensured that any PHI they contained remained secure. Maintained and ran batch reporting in Microsoft Access with Facets RUBI Reporting system. Provided customer service for third party vendors that received data from the company. Created and maintained documentation for new and existing programs, including test plans, job breakdowns, flowcharts, Statement of Work and Business Requirements documents. Performed project feasibility analysis and gave estimates on project resource requirements.• Managed a project to document all existing mainframe data extract programs and their fixed length data output layouts. Created documentation for current programs and layouts. Archived legacy programs. Functioned as subject matter expert on the programs and layouts after completion of the project.• Managed a project to add the National Provider Identification Number to all externally transmitted data extracts. Coded and tested the necessary changes. Maintained communication with clients concerning progress and data availability.