Josh Walker Email & Phone Number

Shelbyville, Tennessee, United States

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.

Brentwood, Tennessee, United States

• 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.
• 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.

Brentwood, Tennessee, United States

• 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.
• 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.

Brentwood, TN

Smyrna, TN

• 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.
• 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.

Franklin, TN

• 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.
• 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.
• 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.

Chattanooga, TN

• 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.
• 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.
• 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.