| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateProficient 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 Street Address , SQL Server 2008 R2, Visual Studio 2017, Power BI On Premise server, Azure, and AWS. Postgres, Microsoft Windows 10, Oracle 10g, SharePointExperienceSenior Data Engineer/BI Consultant February 2024 PresentArchwell HealthcareRe-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 2024Inovalon 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 2022WellPath 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 2022Aspire Healthcare, an Anthem companyReporting 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 2019AdhereHealth 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 2014Express 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 FebruaryHealthStream 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 2012Metro Water ServicesRe-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 2011Active Outdoors/Outdoor CentralDeveloped licenses and other reports in SSRS. Authoring of store procedures for license templates and DFG accounting reports as itrelates to license sales. Data warehousing and business intelligence. Defining, documenting and gathering requirementsfor 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 MassachusettsBI Business/Systems Analyst May 2008 to Feb. 2009Spheris Inc.Development of Executive Dashboard reporting for new data warehouse, and general reports which are browser based with Oracles 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 2008HealthSpring 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 2007CLARCOR 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 programmingConfiguration of WebTrends reporting software forMade recommendations for corporate IT direction and innovations, CRM evaluation and customizationEnd-user support for 50 corporate employeesBackup to Senior Network Engineer Microsoft shopSystem Support Analyst 2003 2004First Consulting GroupGeneral software and network support for hospital and healthcare systemsCustom report writing- Crystal and SQLSystem Support Analyst 2002MediFax EDISoftware and network support for medical electronic billing, MediCLAIM softwareAssisted 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 requirementsCRM Implementation Consultant 2000 - 2001Computer Science CorporationSiebel Administration duties, upgrades, custom builds and second level support for United Technologies Corporations top 325 executives. On-site in Newington, ConnecticutTeam member in the re-architecture of Siebel CRM, Oracle back-endQA testing on custom changes of Siebel product as well as upgradesAided in adding a custom discussion board to Siebel packageComputer Science Corporation 2000 - 2001Integration, administration and QA testing of Siebel CRM 2000 for Saturn of General MotorsSoftware installed in client/server environmentInstallation and testing of Siebel Resonate Dispatch/Connection Brokering servicesWriting test scripts and running test scripts against customized Siebel Sales modulePractice Management Implementation Consultant 1998 2000Solution6 Sydney, Australia/On-site at Deloitte & ToucheOn implementation team for Practice Management software D & T USA and D & T SydneyGlobal project with over 28,000 end-usersLoad test software, QA software, support QA teams, customize software, document design papersTeam member of the planning of infrastructure teamExperimented with replication between Oracle 7 and SQL server 6.5Data Processing Manager 1993 1998Davidson County: Community Services AgencyAdministrational duties for database which tracks children in state custodyAssisted in the planning and installation of a new client/server Novell networkEnd-user support as well as training of Windows 95 and Microsoft OfficeTrained end-users of State system for tracking children in custody as well as state policiesWeekly, monthly, and ad hoc reporting, as well as backup processesLotus Notes development and administrationComputer Operator 1992 1993American HomePatient IncDEC/VMS environment with Digital 3400 series with approximately 30 usersMesta 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.EducationMiddle Tennessee State UniversityMaster 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 AlabamaBachelor of Science, Computer Information Systems:Emphasis in COBOL applications, SQL, systems analysis and design (SDLC), database design.CommunityYouth Football coach (AAA) for 22 seasons in Middle Tennessee, 10 Championship titles and 18 playoff appearances.Candidate's Name
SENIOR BI REPORTING ANALYST |
