SKILLS/COURSEWORK:

Databases:

• Microsoft SQL Server (2008, 2012, 2016)
• Teradata (14.0, 15.1)

Software Skills:

• RightNow ticketing System
• Unicenter (CA) ticketing System
• Remedy ticketing System
• Tortoise SVN
• Artiva
• ActiveBatch
• Crystal Reports 2010
• Tableau
• Team Foundation Server (TFS)

Computer Languages:

• T - SQL
• Teradata SQL
• Visual Basic
• PowerShell
• C#

Other Software:

• SSMS
• SSIS
• SSRS
• SSAS
• TPT

PROFESSIONAL EXPERIENCE:

Senior Application Engineer

Confidential

Responsibilities:

• Developed PowerShell and TPT scripts to automate HBPMedReceivables process
• Worked with team to develop Teradata stored procedures for ACI measures used in MACRA
• Developed TPT scripts and Teradata stored procedures as deemed necessary by managers and team leads
• Developed ad-hoc Teradata SQL queries and other database elements as deemed necessary by managers and team leads
• Performed tasks as assigned from Kanban board and attended daily standups according to agile model

Nashville, TN

Consultant / Report Developer

Confidential

Responsibilities:

• Worked with team to analyze data for SSRS report development and began framework for Enterprise Data Warehouse
• Developed stored procedures and SSRS Reports to meet initial stakeholder requirements
• Developed ad-hoc SQL queries as deemed necessary by colleagues and managers
• Met with stakeholders and development team weekly to gather any new requirements and design/revise reporting solutions

Nashville, TN

App Development Specialist

Confidential

Responsibilities:

• Trained on ActiveBatch job scheduling software to learn how to automate various Operations Team processes and workflows
• Wrote PowerShell scripts to help automate workflows and Windows processes
• Developed ad-hoc SQL queries as deemed necessary by colleagues and managers.
• Worked with team to develop SSIS packages to perform ETL processes for Operations Database
• Developed ad-hoc SSRS reports of varying complexity as deemed necessary by colleagues and managers
• Analyzed SSIS packages, SQL Server jobs, and SQL queries to convert these processes into ActiveBatch applications

Nashville, TN

Applications and Interface Systems Developer

Confidential

Responsibilities:

• Developed SQL Queries to help automate healthcare payer mapping system
• Developed and troubleshot small to large Artiva applications for business users during sprints
• Worked with team to create scripts for Artiva processes and applications, (windows, lists, account notes, menus, etc.)
• Wrote ad-hoc queries as deemed necessary by colleagues and managers.
• Performed requirements gathering and developed design documents for application development.

Franklin, TN

IT Developer II

Confidential

Responsibilities:

• Worked with manager on SQL tasks such as creating stored procedures, complex queries, and SSIS packages
• Developed SSIS packages from Access files, Excel files, and flat files and performed various transforms on them to load the data into SQL Server Database.
• Troubleshot and debugged SSIS packages with checkpoints, auditing tasks, and other troubleshooting processes.
• Created Linked Server to access FactoryTalk Historian database from SQL Server and run T-SQL commands on the FactoryTalk database.
• Created reports of varying complexity using Report Builder and SSDT
• Worked with cross functional teams to complete various IT projects (installation of camera systems, revamping label system, re-organizing server room, switching out and maintaining servers, etc.)
• Learned specialized manufacturing software (Rockwell Software FactoryTalk Automation Suite) to assist with tracking historical trends and implementing business intelligence activities
• Performed and managed backup of Windows 2008 R2 Servers using Symantec BackupExec 2010
• Performed technical support tasks as deemed necessary for staff
• Managed and created the company wiki for information on IT processes and techniques

Nashville, TN

IT Manager

Confidential

Responsibilities:

• Installed, maintained, and troubleshot EMR system
• Upgraded EMR database from SQL Server 2005 to Server 2012
• Improved database performance through compression, indexing, partitioning, and file groups
• Monitored SQL Server with tools such as Activity Monitor, SQL Profiler, DMVs, Performance Monitor, Events, etc.
• Installed patches, service packs, and hotfixes for SQL Server when needed
• Tuned and optimized queries through analyzing Execution Plans
• Managed EMR security by creating logins, roles, and managing permissions.
• Worked with SSIS in creating SSIS packages (transforms and tasks, securing packages, parameters, expressions, etc.)
• Created reports for SSRS using SSDT (simple to moderate reports using Report Builder, Report Wizard)
• Performed database backup and recovery (full backups, database restores, etc. using SSMS, T-SQL)
• Performed database troubleshooting issues such as performance tuning with Database Tuning Engine Advisor, rebuilt and reorganized indexes, created maintenance plans, jobs, etc.
• Created queries, views, tables, and other functions as deemed necessary by office staff

Nashville, TN

Government Services Associate

Confidential

Responsibilities:

• Troubleshooting Microsoft Office 2007 (performing Office repairs, running Office diagnostics, fixing add-in issues, etc.)
• Desktop Issues: (mapping network drives, encrypting files, troubleshooting Internet Explorer, remote installation of printers, software, plug-ins, etc.)
• Troubleshooting Outlook issues (repairing, creating, and importing PST files, rebuilding Outlook profiles, Enterprise Vault issues, setting up Outlook Communicator, etc.)
• Blackberry issues (enterprise activations, basic Blackberry Administration Server issues, basic phone issues)
• Troubleshooting hardware issues and dispatching replacement parts (if necessary)
• Printer issues (mapping/installing network printers, fixing print spooler issues, installing local printers,
• Active Directory (password resets, enabling/disabling accounts, etc.)
• Imaging desktops and notebooks, etc.)

Consultant

SAINT LOUIS, MO

Confidential

Responsibilities:

• Formed team to study the commercial viability of a new tire technology for Confidential.
• Interviewed top executives to better grasp the capability of the new technology and to determine the project scope and requirements.
• Interviewed additional stakeholders to determine needs and value propositions of the technology for all stakeholders.
• Developed potential business models for the tire technology and presented findings to Michelin Executives

Consultant

Saint Louis, MO

Confidential

Responsibilities:

• Formed team tasked to benchmark industry safety best practices and perform a better cost/benefit analysis
• Surveyed and interviewed members of other practices to determine effectiveness based on level of adoption
• Developed framework to evaluate safety programs and identify safety best practices
• Presented results and findings to senior management and identified an additional form of savings