Pam Shaw Email & Phone Number

Tampa, Florida, United States

• Responsibilities include arranging speakers, food sponsors and newsletters for our monthly meetings.
• Lead the meeting by informing our attendees of SQL related events available to them and moderate a question answer portion of the meeting.
• Verify that there are door prizes at each meeting.
• Verify there is a SQL related discussion when speakers are not available.

Taking the Scary out of Monster Reports~ MagicPASS User Group - Mar 2012~ SQL Lunch (online) - Mar 2012~ Space Coast Users Group - July 2012~ Delivered to 5 SQL Saturdays between Apr 2012 thru Oct 2012Tips and Tricks of Reporting Services~ Delivered to 22 SQL Saturdays between Nov 2007 thru June 2014~ Code Camp Tampa - Dec 2008 ~ Tampa Bay BI User Group.

Working From Home

• Using SSIS, loaded BI360 data warehouse for 8 clients
• Using SSIS, converted data originating in Access to table formats for reporting
• Created dashboards using Power BI
• Extracted data from Dynamics add on for analytics

Working From Home

• Created dashboards using Power BI

My responsibilities include the creation of data visualizations utilizing new tools. Currently I have been working with Tableau, Power BI and DataZen.I assisted with the implementation of the Power BI Enterprise gateway. I then worked thru the conversion existing Tableau dashboards to Power BI. I documented to Microsoft the gaps found between the.

Ocala, FL / Work From Home

Update existing reports to reflect new structure changes. Develop a data warehouse to support easier analysis of business needs. Resolve issues in an issue tracking system.Reviewed issues in queue to determine where multiple issues could be handled by a single process and developed the processes to resolve the issues involved. Created new reports based on.

Jacksonville, FL

Worked within the SCRUM process to improve existing reports, create new reports and migrate old reports.

Developed 10 reports as needed for a local client.

Home / Melbourne, FL

• Develop reports in SSRS 2005 against SQL 2008 and Oracle.
• Design dashboard style reports to deliver condensed data in a visually appealing package.
• Developed a process to move data from its raw form into report form on a scheduled basis thru use of On Demand subscriptions.

Clearwater, FL

• Develop reports off both transactional and analysis data.
• Design charts to better visually represent the data for better decision making.

Home / Cincinatti, OH

• Developed an SSRS solution using MDX against SSAS for Proctor and Gamble.
• Approximately 75 reports were generated against 7 cubes.
• Early development of the templates allowed for a common look and feel across multiple groups as well as easy development of the layouts. Technology: SQL 2008 - SSRS, MDX and SSAS.

• Rewrote 30 reports from Access to SQL Reporting Services.
• Developed 19 reports from the ground up.This was a project for LPGA with limited scope designed to fit within a tight time frame. It included mix of replicating existing reports with tried and true data backends and.

• Developed reports and worked on BI solutions for Great Plains data for a client in the healthcare industry.Technology: SQL 2008 R2 - SSRS

• Managed the implementation of multi currency for reporting on client sales related reports. This required developing a process in SQL to implement on over 30 reports as well as working with the UI team to implement a.
• Developed 20 compensation plans for new clients using SQL 2005.Technology: SQL 2005

Freelance consultant specializing in short term, SQL Server contracts.

• Created a process to aggregate statement information based on billing policies that Great Plains did not manage. This included an automated verification process. This was accomplished using complex T-SQL.
• Created multiple complex statement formats within the Great Plains data model using Reporting Services.
• Designed and implemented file share subscriptions on demand to generate PDF statements.
• Designed and implemented an email process to deliver statements to defined clients.Technology: SQL 2005 T-SQL, SSRS and Great Plains data

• IDEAL Software dba REPS Software was purchased in May, 2007 by Logibec of Canada. They have merged our group with other purchases forming MDI Achieve.
• Designed and developed the product’s first Business Intelligence solution. This included the design and creation of the data mart using SSIS and multiple cubes using SSAS. The more complex of the cubes had in excess of.
• Responsible for upgrading from SQL 2000 to 2005.
• Developed and deployed a data driven, web based report engine. Simple listings only require the population of tables. More complex reports utilize XML/XSL transformations. Allows users to generate custom report.
• Created and maintained stored procedures, functions, triggers and views as needed to support application and reports.
• Architected database design changes as new modules were added to the application.

• StarTech was a division of Insurance Software Packages (ISP) that was sold by CCN prior to CCN being purchased by Columbia. We created software for mostly small service brokers and self insured employers to track.
• Developed and deployed a data driven rule engine for Medical Bill Review. A non-programmer was able to implement ten state schedules in less than five months by populating data fields with conditional statements. This.
• Developed and deployed a medical bill review user interface for collection of both HCFA-1500 and UB-92 billing information.
• Developed the application of Focus PPO contracts to medical bills.
• Developed an EDI interface to adjudicate medical bill information with no user interaction according to the OH fee schedule and rules in partnership with SACIII. On current data, there was less than 2% deviation from.
• Managed project time lines and staff of six developers.Technology: Visual FoxPro and FoxPro 2.6.

• Implemented 12 state schedules. This included the complete PA Workers' Comp schedule for both outpatient providers and facilities. The user interface allowed for aggressive lookups into the outpatient hospital charge.
• Implemented MedView and OUCH-PPO contracts as an automated part of the repricing process. This included automated billing on the behalf of the PPO Network.
• Maintained and restructured reporting to empower the clients to identify sources of over utilization and other forms of abuse.
• Implemented numerous state reports to maintain compliance for our users.
• Developed a utilization review tool that allowed the user to define parameters to be monitored. Alerts would be, issued when the parameters were exceeded.
• Implemented state EDI package within bill review. This involved forcing collection and validation of data required for the transfer as well as translation of our data into the state defined layouts.Technology used.

• Developed an adjuster diary system that assisted in the maintenance of claimant files. Alerts for state reports were issued based on events and dates for each claim.
• Implemented a means of automating the FL DWC-13. This minimized fines imposed as a result of errors made when processing by hand.
• Acted as the liaison between, the MIS department and the newly formed cost containment division. This required learning FoxBase and developing the tools that were not supplied with the bill review package being utilized.
• Responsible for monitoring of data to identify abuse by adjusters and providers. Implemented tools to identify duplicate claims and providers for consolidation.Technology: Foxbase and RPGII

• Developed module for calculating the balances for Single Pay and Multi Pay Whole Life insurance policies.Technology: RPGII

• Developed a state reporting module for specially monitored state funded programs.
• Generated reports utilized for verification of MediCare and MediCaid billing. Based on audit results, implemented reports that would alert to potential fine situations.
• Translated data from the System 36 onto a PC platform to generate graphs and spreadsheets for use by the directors of each department. These were beneficial in identifying demographic groups that justified more funding.

• Maintained accounts receivables and the software that managed them.
• Developed and maintained the bill of lading system.Technology: Silicone Office

• Completed water utility management systems for both privately and publicly held utilities.
• Sped up the system to minimize time required. Initially, 250 man hours were required to generate bills and post payments for 1500 accounts monthly. The client was able to double accounts and maintain the system with.

Aa, Science/Math

General