Michael Armentrout Email & Phone Number

Largo, Fl, Us

Wilmington, De, Us

• Fully remote position• Multi-node Qlik Sense November 2021• Qlik View April 2019 SR3• Implement enhancement requests for existing Qlik View applications• Create new Qlik View solutions to identify revenue opportunities• Create dbt models for ELT and data pipelines• Leveraged Snowflake DWH, lake and marts for data solutions• Create POC Qlik Sense applications• Agile work environment

Fort Lauderdale, Fl, Us

• Fully remote position• Work directly with data teams to identify, load datasets from disparate systems• Automated business processes to leverage Qlik Sense and NPrinting as a solution• Imbedded Qlik SME, directly for accounting initiatives• Qlik Sense September 2020 Patch 3• Creation of Qlik NPrinting April 2020 reports for corporate use

Dallas, Texas, Us

• Remote since March 2020• Developed solutions on Qlik View November 2017 SR7• Upgraded Qlik Sense from February 2019 Patch3 to February 2020 Patch 2• Star/Snowflake schema data modeling• Create streams and assign user access• Create QVDs, from various data sources, for Qlik View/Qlik Sense• Schedule hourly/daily/weekly/monthly data loads for Qlik View/Qlik Sense• Publish applications in Qlik View/Qlik Sense• Creation of NPrinting June 2019 reports for corporate use

Dallas, Texas, Us

• Team lead on Qlik Sense November 2018 Patch 2/Qlik View November 2017 SR7 related development• Upgraded PROD/DEV Qlik Sense environments to November 2018 Patch2 from June 2018 Patch 2• Upgraded PROD/DEV Qlik Sense environments to April 2019 Patch1 from November 2018 Patch 2• Star schema data modeling• Create streams and assign user access• Create QVDs, from various data sources, for Qlik View/Qlik Sense• Schedule hourly/daily/weekly/monthly data loads for Qlik View/Qlik Sense• Publish applications in Qlik View/Qlik Sense• Install/upgraded Climber/Vizlib extensions• Creation of NPrinting June 2018 reports for corporate use• Worked directly with the SVP of Risk & Portfolio Investment on IRR analysis

Princeton, New Jersey, Us

• Leveraged Tableau 2018.1/SQL Server to update existing workbooks to display new quarter analytics, impressions and spend• TSQL scripts creating pharmaceutical digital analytics extracts to be leveraged in Tableau• TSQL scripts creating on-demand SEO digital analytics extracts• TSQL scripts creating on-demand Bausch & Lomb digital analytics extracts

Mckinney, Texas, Us

• Corporate data literacy advocate• Developed Personnel Tracker application: Actual-vs-Budgeted headcount, new hires, overtime hours, average sales per employee, hourly budgeted compensation, sales per man hours and temporary labor spend, by region/branch• Developed P&L application: OPEX by category, 13 month trending, net sales, cost of goods sold, gross profit and EBITDA. Replaced static SSRS reports• Developed Fleet Mobility application: showing driver violations by region, branch, violation type, date and the associated fines• Developed Insurance Claim application: showing coverage type, claim, claimant, total paid, total incurred, by region, branch and policy year.• Developed multiple NPrinting reports distributed at the region/branch level at set intervals• Scheduled daily/weekly/monthly data loads of QVF documents using Qlik Sense QMC• Qlik Sense Nov 2017 Patch 2• NPrinting November 2017 v17.6• Qlik Maps 3.0

Provided remote, consulting support on QlikView applications, both upgrades and new development for Summit Health's healthcare systems.• Developer on enhancements to multiple existing QlikView applications• Developer on QlikView Hypertension application• Developer on QlikView Infection Control application• Developer on Professional Practice Report data feed• Developer on EMPI project to connect MedEnt patient data to Meditech patient data• SQLServer Medicare Cost Report data extracts from Meditech Data Repository• Best practices advisory role on multiple SQLServer instances (v2014 – v2008R2)• Upgraded multiple SQLServers 2008R2 to 2014• Leveraged Solarwinds DPA to identify opportunities for improvement• “Cradle to grave” SDLC. Requirements gathering, data identification, Qlik load script, QVD creation/storage, UI development and Qlik server-side administration; publishing, promotion and security.

Carbondale, Il, Us

• Technical Lead/Developer on enhancements to the Inpatient Nursing Dashboard QlikView application• Technical Lead on Glucose Management QlikView application• Technical Lead on Glucose Sepsis QlikView application• POC porting QlikView solutions to QlikSense• Epic Clarity/Caboodle ETL administrator• Senior DBA for multiple Microsoft SQLServer instances (v2014 – v2008R2)• Leveraged Solarwinds DPA to identify server-wide opportunities for improvement• “Cradle to grave” SDLC. Requirements gathering, data identification, Qlik load script, QVD creation/storage, UI development and Qlik server-side administration; publishing, promotion and security.

Carbondale, Il, Us

• MCSA SQLServer 2012/2014 certified• Liaison between business and technical groups to produce actionable data solutions• Taking multiple, disparate, data sources and creating solutions, solving challenges and answering operational questions for decision makers• Project Manager/Technical Lead/Developer on Surgical Management QlikView application• Technical Lead/Developer on Inpatient Nursing Dashboard QlikView application• Technical Lead/Developer on Expected Discharge Date Analysis QlikView application• Technical Lead/Developer on Pulmonary Analysis (COPD/Pneumonia) QlikView application• Technical Lead/Developer on Meditech Data Repository Data Dictionary QlikView application• Technical Lead on Sepsis QlikView application• Technical Lead on Glucose Management QlikView application• “Cradle to grave” SDLC. Requirements gathering, data identification, Qlik load script, QVD creation/storage, UI development and Qlik server-side administration; publishing, promotion and security.• Sole SQLServer DBA for Meditech Data Repository (SQL2012)• Sole SQLServer DBA for four iPeople servers (SQL2008R2)

Carbondale, Il, Us

• Provide production level DBA support, mentoring and expertise for 20 SQLServer instances (v2012 - v2005)• Automated processes saving time, money and human resources• All solutions leveraged with SQLServer (v2012 - v2005) on the backend, with varying tools ( SSIS, Excel, iPeople)• Sole SQLServer DBA for Meditech Data Repository• Implementation DBA Lead for Meditech Data Repository 5.66 PP8 upgrade• Developed visual metric for physician performance/productivity measures; compared to MGMA specialties• Automated monthly gathering of CPOE metrics for Meaningful Use adherence• Automated service line ranking process; reducing two weeks’ worth of mainframe processing to less than five minutes SQL processing time• Created system-wide nursing dashboards for urgent patient care metrics/vitals/test results. Savings equivalent of ~14,000 nursing hours annually

Dallas, Tx, Us

• Responsible for administration of five SQL Server 2000 database servers, two SQL Server 2005 servers and twenty five SQL Server 2008 servers• Upgraded production servers to SQL Server 2008• Lead teams of two to five DBAs on various projects supporting corporate initiatives• Supported senior management's needs through SSRS• Upgraded, tested and supported various methods of stand-by and disaster recovery servers through SQL Server 2008 log shipping• Balanced production workloads by instituting enterprise-wide transactional replication with one publisher and two subscribers• Promote application mining capabilities of CAST Workbench Suite 6.3.2.2246• Instituted Sarbanes-Oxley auditing through Idera's SQLCompliance Manger• Published in SQL Server Magazine August 6, 2002 - Synchronizing Logins - http://www.sqlmag.com/article/stored-procedures/synchronizing-logins

Dallas, Tx, Us

• Provided database consultation as a freelance database administrator• Responsibilities included SQL Server installation, administration and troubleshooting• Lead teams of two to five DBAs on various projects supporting corporate initiatives• Provided high-level SQL support through query analysis and working directly with the development team• Provided mentoring to junior DBAs• Supported project needs through DTS/ETL processes• Implemented, tested and supported various methods of stand-by disaster recovery servers through SQL Server log shipping and transactional replication to two subscribers

• Responsible for the installation, administration and monitoring of two SQL Server 6.5 servers as well as ten Sybase ASE 11.9.2 servers on a 24x7 basis• Responsibilities include physical database design, maintenance, security, disaster recovery and consultation support• Environment was 24x7 on call support• Ongoing performance an tuning reviews to include query optimization, index creation, row-level locking, data striping and growth assessments

Dallas, Tx, Us

• Responsible for the installation, administration and monitoring of four SQL Server 6.5 servers as well as twenty SQL Server 7.0 servers on a 24x7 basis• Testing and installation of appropriate service packs on all servers• Review and enhance security and access policies for all users• Developed views to segment customer data and ensure security• Worked with developers/end-users on query optimization• Implementation of enterprise-wide transactional replication with SQL Server 7.0

Dallas, Tx, Us

• Responsible for the installation, administration and monitoring of three Sybase 11.0.3.3 servers on a 24x7 basis• Developed backup, security and disaster procedures• Upgraded production servers to Sybase Adaptive Enterprise 11.0.3.3

• Responsible for the installation, administration and monitoring of eight SQL Server 6.5 on a 24x7 basis• Supported development, QA and production environments as well as release cycles• Company maintained strict SDLCs• Utilized ERWin 3.0 to create and implement logical/physical designs• Created record auditing process for production servers through the use of triggers• Modified Crystal Reports to support business needs

• Responsible for the installation, administration and monitoring of ten Sybase 11 servers on a 24x7 basis• Installation and testing of appropriate patches• Migrated production servers from Sybase 4.9 to Sybase 11• Responsible for the creation, maintenance and cleanup of data elements• Provided real-time and historical reporting for all levels and departments through ad-hoc queries and automated scripts• Supported users through investigation, troubleshooting and testing of automated systems• Used TSQL and SQR to satisfy user’s requests

Mba, Business Administration

Bachelor Of Science, Information Systems

74F Mos, Progamming