SUMMARY:

• Seeking continued growth and career maturity in mid - to-senior level Data Information Technology roles, while serving locally in Indianapolis.

TECHNICAL SKILLS:

• Azure, Data Factory V2, Cloud, T-SQL, SQL, SSMS, SQL Server 2008 R2 thru 2017, Microsoft Business Intelligence tools (SSRS, SSIS, SSAS), Visual Studio 2017, SAS, R, Tableau, PowerBI, C#, PowerShell, Excel Power Pivot, REDGate SQL Prompt, MySQL, Oracle, MS Office 365 (ie Excel, Access, PowerPoint), Visio, VBA, PHP, Java, SharePoint, Vanderbilt’s REDCap, SharePoint, Cardiff TeleForm, Assembly, PSpice, MatLab, Pro-Engineer, Java, C /C++, Adobe Acrobat, Photoshop, Illustrator, Skype for Business, SPSS, Informatica, Alteryx, Qlik, Qlikview, TFS, ServiceNow

WORK EXPERIENCE:

Application Developer

Confidential, Indianapolis, IN

Responsibilities:

• OLTP and OLAP Development, Testing, and Production SQL Database and Datawharehouse environments
• ETL/SSIS Integration design, maintenance, troubleshooting, implemenation
• Tableau and SSRS Reporting Development
• Data Architecture Design, Systems mapping, process workflows
• ServiceNow Ticket Resolution, Ad Hoc reporting, debugging, file standardardization, Website revisions, Image processing, Data Cleaning
• Financial reconciliation, Billing, Invoicing, Customer Accounts, Vehicle Registrations,

Application Developer

Confidential, Indianapolis, IN

Responsibilities:

• Application installations, ERP tech support, ERP process debugging and crash recovery.
• Data Systems Development Operations
• Data Warehouse Design
• BI Platform analysis and recommendations
• SQL Scripting and ETL migration, Ad hoc queries

BI SQL/ETL Developer

Confidential

Responsibilities:

• Performed Ad-Hoc T-SQL queries in SQL Server 2008 R2, 2012, 2014, and 2016 in support of State leaders
• Updated and maintained periodic dashboards, Tableau, PowerBI, and Excel reports
• Developed ETL processes in SQL Server 2008 R2 thru 2016, wrote T-SQL scripts and SSIS integration packages
• Performed data investigations, systems documentation using Visio diagrams, built data dictionaries

SQL Data Analyst

Confidential

Responsibilities:

• Developed MS Business Intelligence ETL utilities using MS BI stack (SSIS, SSRS, SSAS)
• Created Tableau, SSRS, and PowerBI reports, designing tiered data aggregations, report structuring and deployed via intranet and cloud platforms
• Developed SQL Server 2008 R2 thru 2016 objects, scheduled jobs, scripts, stored procs, triggers and functions
• Analyzed consumer sales via data integration, warehousing, and reporting using MS Office and BI tools

Sr. Implementation Engineer

Confidential, Indianapolis, IN

Responsibilities:

• Operated, Developed, and Documented large, complex OLAP and OLTP Data Warehouse environments, customer on-site production database systems, client SFTP sites and file transfers, Reporting objects and deliverables
• Performed troubleshooting of entire client ETL processes in SQL Server 2008 R2 thru 2016.
• Performed monthly ETL, Client data machine learning refreshes, OLAP object updates, report generation and refreshes, and other data warehouse extraction, archiving, loading, transforming, and processing tasks

Data Analyst

Confidential

Responsibilities:

• Migration management of reporting server: SQL Server 2008 R2 to SQL Server 2014
• Performed common DBA tasks, setting up Users, Schemas, Roles, Designing naming schemes, etc.
• Installation and setup of Visual Studio, server connectivity, publishing settings, agents, etc.
• Development of ETL processes, periodic data and report refreshing, data quality checking and maintenance

Senior SQL and BI Developer

Confidential

Responsibilities:

• Developed, tested, and deployed SSRS Reports supporting Governmental financing client
• Developed custom, extensive T-SQL scripts and SSRS calculations for combing Microsoft Dynamics CRM application data into custom “hybrid” source SSRS reports thru client-side publishing via internet hosting
• Interpreted report requests for feasibility of report writing and publishing across companies’ IT platforms

Senior Healthcare Data Analyst

Confidential, Indianapolis, IN

Responsibilities:

• Performed monthly data warehouse update procedures in SQL Server (archives and refreshes of DAX, Qubes, etc)
• Developed production T-SQL code used to analyze production performance and accuracy
• Designed client specific reports in Tableau, SSRS, and PowerBI for one-time requests and ongoing reporting needs.
• Designed, Developed, and Maintained supporting data elements (Tableau SSRS SSAS DAX Qubes)
• Ensured quality control procedures and documentation management were followed

Senior Data Analyst

Confidential, Indianapolis, IN

• Fulfilled Ad-Hoc, internal and external report requests by writing complex T-SQL scripts, Stored Procedures, SSMS Jobs in conjunction with SSIS/SSRS packages and reports to meet the precise, informational needs of requesting parties.
• Developed, shared, and maintained centralized SQL Server Data “mart” or “warehouse”, unifying multiple business application back-end database environments (both test and production).

Senior Data Analyst

Confidential

Responsibilities:

• Designed, Developed and Maintained a SQL Server data warehouse and database infrastructure unifying all internal and external data sources into a centralized Data Mart
• Designed, maintained, and documented automated reports and service utilizing all T-SQL functionality (Stored Procs, functions, triggers, SQL Server Scheduled Jobs) along with related SSIS processes/workflows
• Assured accurate and efficient integration of internal and external patient data

Data Manager

Confidential, Indianapolis, IN

Responsibilities:

• Created Analysis Data Sets (ADS) using SAS for statisticians and performed all necessary Data Management
• Designed and Performed ETL processes from many sources including SQL Server, Excel, Access, flat files, etc
• Administrative support of over 1,200 users and 2,000 projects in web-based DBMS and EDC system (Vanderbilt’s REDCap)
• Developed departmental utilities and Data Management tools for client data using SAS and T-SQL, VBScript, PowerShell, etc.