PresGarBusiness Intelligence Developer
Jan. 2002 - Jan. 2010• Created and administered Business Intelligence reporting using Crystal Reports 9.0 and Crystal Reports 11.0 and Business Objects XI SR2.
• Developed Executive and Management Dashboard Reporting with Benchmark levels of acceptable standards.
• Coordinated meetings with Site managers and V.P.s to review progress & status as it relates to Benchmark goals. Worked with all parties to develop a Solution plan to address each issue.
• Designed 1,000+ reports from Access, Oracle and SQL server databases that were used monthly/daily at all departments. This included auto delivery and auto printing of the reports/information to eliminate inefficient man hours. • Maintained a Solutions Forum for the IT Department and users for easy reference to commonly found issues.
• Designed, programmed and maintained the in-house Marketing CRM program which tracked Referring Doctor scan volume, Sales Call visit notes, pertinent individual and practice data using SSL technology to allow entry of information from mobile and other devices. Data from 3 databases were combined to allow data from Marketing, Billing and Accounting to show all details for each doctor in one place. • Designed, programmed and maintained a Maintenance Repair Request program from online entry, tracking and notification to the responsible party based on that data entry. Tracked expenses and tied them back to the original request for trending purposes.
• Developed, programmed and maintained numerous websites for the companies that comprise PresGar Companies. Set up Web page entry to allow Content Management of these sites by others Developed these websites using Classic ASP, Javascript & PHP.
• Handled overflow Help Desk calls regarding all Desktop and Windows/Active Directory issues along with calls regarding other proprietary programs in use at PresGar. Maintained data entry of these calls into Track-It! Developed customized reports from the data input by the entire IT department for Track-it!