PowerBI Developer / SQL Data Analyst for Healthcare

Jerry Solon 317-***-****

E-Mail : **********@***.***

***** ******** *** ******, ** 46033

LinkedIN Profile : https://www.linkedin.com/in/jerry-solon-a4480216/ Microsoft PowerBI Developer/SQL Data Analyst - Extensive work building BI Dashboards. Especially Microsoft PowerBI, but also some PowerApps. Design and development on SSRS, SSAS and SSIS. Primarily focused on developing PowerBI Reports / Dashboards for internal users. Have also developed Epic Clarity and Reporting Workbench reports for Healthcare providers. Familiar with eCW ( Clinical Works ) EMR software. Objective : Database Analyst/BI Developer position with progressive company that stresses planning, design, testing, and effective implementation. Looking for an opportunity to continue building on core SQL and PowerBI Data Visualization knowledge along with PowerApps to deliver actionable data to internal and external Clients/Customers. Continue EMR knowledge like Epic and also work in Azure/DevOps

Summary : Several years of development of BI Dashboards, SSRS reports and SSIS packages along with general T-SQL development and programming, including stored procedures, user defined functions, triggers and views. Some PowerApps and also one-time data extracts in EXCEL. Healthcare Analytics BI Presentations to management. PROFESSIONAL EXPERIENCE

08/2021 – Current. IU Health. Indianapolis, IN. Microsoft PowerBI Developer : Created PowerBI Dashboards from SQL data for Healthcare metrics :

· Developed PowerBI Reports / Dashboards and Visualizations for users / Providers

· Used SQL Tables / SSAS Models and EXCEL files as source for the Reports. Some Web API

· Created Measures and Calculated Columns to craft and present the analytical data

· Very familiar with DAX and M Language as well as some PowerApps

· Shared code and tracked work in Azure DevOps

07/2019 – 07/2021. Macallister Machinery. Indianapolis, IN. PowerBI Developer : Created PowerBI Dashboards from SQL data for company and machine metrics :

· Built out PowerBI Dashboards and Visualizations for internal and external users

· Sourced external network TXTs, EXCEL files, CSVs, and SQL databases the for Dashboards

01/2018 -06/2019. Community Health Network. Indianapolis, IN. BI Tools/SQL Analyst : Create healthcare BI Dashboards from SQL data for hospital and Patient metrics :

· Built out QlikView Dashboards and Visualizations for internal Healthcare initiatives

· Create SQL Tables and Views via HC SAM Designer to feed Patient Encounter Dashboards

· Certified on basic Epic EMR software and familiar with real-time/actionable Workbench Reports

09/2015 – 12/2017. DWA/Avant HCG. Carmel, IN. Data Analyst : Develop and administer BI Dashboards and SQL 2012 SSIS packages and ETL’s, including :

· Used PowerBI Desktop and also PowerBI Gateway to publish / refresh data to the Cloud

· Administered and developed Dashboards and Reports for pharmaceutical clients / Managers

· Gathered Google Analytics info from several Web Sites for use in external/internal reports

· Integrated SharePoint and AD in SSRS Reports. Worked on internal Survey Web application

09/2012 – 09/2015. Angieslist. Indianapolis, IN. SQL Database Analyst II : Develop and maintain SQL 2008/2012 SSIS/ETL’s, DataWarehouses, including :

· Develop SSIS packages to populate DataWarehouses from multiple sources

· Create and update SSRS Reports on Reporting Server 2008/2012

· Import Web Analytics Data from Amazon Redshift via Segment.io for DataWarehouse

· Write T-SQL and MySQL Stored Procedures for data analytics. Integrated SalesForce data

07/2006 - 12/2009. DoubleTake Software - Indianapolis, IN Tech Support Engineer : Mirroring and Replication software support and QA testing for Server 2003 and 2008 :

· Mirroring and Replication software for SQL servers and Exchange 2003 and 2007 servers

· Configured and utilized VMWare/ESX. Some LINUX

· Installed, configured, and maintained SQL Server 2000 and 2005 - - including Clusters

12/1994 - 12/2005. Phillips/MedQuist - INDY, IN Corporate Enterprise Engineer : Corporate Technical Group that trained, organized, and scheduled software and hardware installations for over 80 offices nationwide, medical clinics, doctor’s offices, and hospitals :

· Application and O/S Software Training and Testing for Hospitals and Doctor’s offices

· Configuring Medical Dictation/Transcription/Coding hardware and software

· Windows and Exchange 2000/2003 Server set-up. Cisco PIX and 1700 or 2600 series Router EDUCATION

05/1980. Indiana University - Bloomington B.S Degree Public Admin 05/1990. Univ. of Houston - Associate Degree - Computer Technology Certifications include : Microsoft PowerBI Certified, Epic Cogito EMR suite (Clarity, Reporting Workbench, and Caboodle), as well as Cisco CCNA, CNE, and HP ASE REFERENCES : Upon Request

Contact this candidate