Power Bi Sql Server

Proficient in: SQL Reporting Services (SSRS), Power BI, Tableau, Business Intelligence, TFS, Jira, Service Now, Smartsheet, Azure, AWS cloud, Visual Studio 2017, Power View, MDX, tabular and cube models, Microsoft SQL Server 2018. data warehousing, T-SQL, Business Objects, software implementations, CRM, Cognos Consolidation, Fixed Asset Software, Microsoft Navision G/L, SOX Compliance issues, Practice Management software Big 6, Microsoft Office, Crystal Reporting, TotalHR payroll software, qa testing, user acceptance testing, Embrace e-commerce software, system documentation, second and third level application support, software upgrades, user training, problem solving, customer service, ad hoc reporting.

Platforms:

SQL Server 2018, SQL Server 2008 R2, Visual Studio 2017, Power BI On Premise server, Azure, and AWS. Postgres, Microsoft Windows 10, Oracle 10g, SharePoint

Experience

Senior Data Engineer/BI Consultant – February 2024 – Present

Archwell Healthcare

Re-engineering data set for growth efficiencies concerning Medicare data. Re-creating data sets to be used in Power BI for executive dashboards and operational dashboards. Performance tuning sql code for fast rendering for Power BI data sets. Building new data structures to account for growth and data clean up.

Senior BI Report Consultant/Contract- January 2023 – January 2024

Inovalon Inc.

Working with Insurance Payer team to improve productivity. Manual processes with pdfs and chase records. Daily operational status reports. Working with EHR vendors such as Allscripts, HSX, Konza, and Moxe. Moving and processing of doctor (medigroup) charts for Payers such as BCBSFL, BCBSAZ, UHC, and Aetna. Process improvements and reporting with Power BI and Tableau.

Senior BI Report Developer- June 2022- December 2022

WellPath Inc.

Reporting Team Lead, operational & KPI metrics and external reporting with Tableau, back-end SQL Server data warehouse. Change control management, requirements gathering (operational reporting & executive level dashboards), internal testing, user training (coaching) and demonstrations. SQL view and stored procedure creation, report mock-ups, end-user training. SSRS maintenance and report upgrading.

Senior BI Report Developer- January 2020- June 2022

Aspire Healthcare, an Anthem company

Reporting Team Lead, operational, KPI Metrics and external reporting with Tableau, back-end Postgres SQL. Change control management, requirements gathering from executives as well as middle-managers. Automation of old manual Excel processes. Implementing report standards and communicating data needs with ETL and development team. View creation in Postgres SQL. Internal testing and report maintenance.

Senior BI Report Developer- December 2014- December 2019

AdhereHealth LLC.

SQL Server 2014 BI Stack with BI Power & Power View, DAX, Tabular models, Cubes, creating SSRS reports. Executive Dashboard creation on new Power BI on premise server. Business analysis work, documentation, change control. Stored procedure creation, assisted in data mart development and Tabular model. Data focus on HEDIS medication adherence.

Senior BI Report Developer- Contract April 2013 – November 2014

Express Scripts Inc.

SQL Server 2012 BI Stack with Power View, using Tabular models, creating SSRS reports from legacy Microsoft Access databases. Dashboard building using SQL Server 2012 with SharePoint 2013. SQL stored procedure creation.

Senior BI Report Developer- Contract November 2012- 2013 February

HealthStream Inc.

Creation of BI Reports in Tableau. Creation of extract reports, both internal and external customers.

Support and creation of analytic reports, using Izenda report writing tool. Second tier support and training for reporting.

Senior SSRS Consultant- Contract June 2011 to October 2012

Metro Water Services

Re-creation of Access reports into a SSRS platform for operational reporting. Creation of custom reporting needs as it pertains to asset management system (Hansen 8) for all organizational units. Gathered user requirements, documented requirements, developed reports in SSRS. Collaborated with DBA to setup development and production environments for SSRS. Back-end is Oracle 11g. Moving key data tables from Oracle to Sql Server using SSIS. Created stored procedures in Oracle as well as SQL Server 2008 R2. Composed user training manuals for reporting needs by business unit and held training classes with end-users.

Business/Report Analyst March 2009 to June 2011

Active Outdoors/Outdoor Central

Developed licenses and other reports in SSRS. Authoring of store procedures for license templates and DFG accounting reports as it

relates to license sales. Data warehousing and business intelligence. Defining, documenting and gathering requirements

for Department of Fish and Game for three state contracted projects. Work with the .NET development team to offer a sales solution for IPOS, Agent and Internet generation of hunting and fishing licenses for the states of California, Connecticut and Massachusetts

BI Business/Systems Analyst May 2008 to Feb. 2009

Spheris Inc.

Development of Executive Dashboard reporting for new data warehouse, and general reports which are browser based with Oracle’s Business Objects and Webi Reports. Financial reporting needs for CFO, Billing and Accounting, as well as general purpose management reports for middle managers. Data concerning all facets of the medical transcription process. Authoring of report specification documents, test documents and instructions. Administration duties of Jira application, used to track software releases, testing of DI jobs and report methodology.

BI Business/Systems Analyst April 2007 to April 2008

HealthSpring Inc.

Development of Executive Dashboard reporting for new data warehouse, and general reports which are browser based with SQL Reporting Services, using SharePoint as entry way and security. Summarizing key data elements for Medicare Advantage and Medicare Part D, revenue reports and membership reports for decision makers. QA testing, data transformation packages (DTS jobs), system, SOX, and testing documentation. Defining scope and business requirements from end users as well as user training. Authoring of stored procedures that run behind SQL Reporting Services. Change control documentation and testing. Self-study of new concepts with regards to data warehousing and business intelligence.

Systems Analyst/System Administrator 2004 – 2007

CLARCOR Inc.

Fine tuning and software upgrades SOX reporting compliance issues. Crystal Report writing and SQL Reporting Services for accounting and finance. Access, Visual Foxpro, custom c/al and SQL programming

Configuration of WebTrends reporting software for

Made recommendations for corporate IT direction and innovations, CRM evaluation and customization

End-user support for 50 corporate employees

Backup to Senior Network Engineer – Microsoft shop

System Support Analyst 2003 – 2004

First Consulting Group

General software and network support for hospital and healthcare systems

Custom report writing- Crystal and SQL

System Support Analyst 2002

MediFax EDI

Software and network support for medical electronic billing, MediCLAIM software

Assisted users in sending claims to Medicare, BlueCross BlueShield, commercial carriers, HMOs, PPOs, and third-party administrators (TPAs) in standard or proprietary formats according to the payer requirements

CRM Implementation Consultant 2000 - 2001

Computer Science Corporation

Siebel Administration duties, upgrades, custom builds and second level support for United Technologies Corporation’s top 325 executives. On-site in Newington, Connecticut

Team member in the re-architecture of Siebel CRM, Oracle back-end

QA testing on custom changes of Siebel product as well as upgrades

Aided in adding a custom discussion board to Siebel package

Computer Science Corporation 2000 - 2001

Integration, administration and QA testing of Siebel CRM 2000 for Saturn of General Motors

Software installed in client/server environment

Installation and testing of Siebel Resonate Dispatch/Connection Brokering services

Writing test scripts and running test scripts against customized Siebel Sales module

Practice Management Implementation Consultant 1998 – 2000

Solution6 Sydney, Australia/On-site at Deloitte & Touche

On implementation team for Practice Management software D & T USA and D & T Sydney

Global project with over 28,000 end-users

Load test software, QA software, support QA teams, customize software, document design papers

Team member of the planning of infrastructure team

Experimented with replication between Oracle 7 and SQL server 6.5

Data Processing Manager 1993 – 1998

Davidson County: Community Services Agency

Administrational duties for database which tracks children in state custody

Assisted in the planning and installation of a new client/server Novell network

End-user support as well as training of Windows 95 and Microsoft Office

Trained end-users of State system for tracking children in custody as well as state policies

Weekly, monthly, and ad hoc reporting, as well as backup processes

Lotus Notes development and administration

Computer Operator 1992 – 1993

American HomePatient Inc

DEC/VMS environment with Digital 3400 series with approximately 30 users

Mesta Med software (home healthcare billing software)

Daily processing of Medicare and private pay bills for home healthcare products in thirty Southern locations, month-end A/R reporting, general trouble-shooting, backup procedures and end-user support.

Education

Middle Tennessee State University

Master of Science, Computer Information Systems:

Emphasis on database management, decision support systems, analysis and design, information systems assessment, problem solving, and accounting systems. Management of information systems.

University of North Alabama

Bachelor of Science, Computer Information Systems:

Emphasis in COBOL applications, SQL, systems analysis and design (SDLC), database design.

Community

Youth Football coach (AAA) for 22 seasons in Middle Tennessee, 10 Championship titles and 18 playoff appearances.

STEVEN G. SIGMON

SENIOR BI REPORTING ANALYST

Contact this candidate