Orlando, FL ***** firstname.lastname@example.org (407) 733 – 3251
SQL, SSRS (12+ years)
Excel (10+ years)
DTS Packages for SQL (5+ years)
SSIS (4+ years)
Crystal Reports XI (4+ years)
University of Central Florida; Orlando, FL
Bs Management Information systems
Deans List award recipient through all but one semester of coursework
BioPlus Specialty Pharmacy 11/2016 – 3/2019
Building of SSRS reporting for all aspects of the business working closely with Payor Relations, Inside/Outside Sales, and Finance Teams for maximum efficiency and requirements gathering.
Revamped and built data extracts from top to bottom using SQL Stored Procedures, Views, and queries within SSIS packages with FTP transmissions for ETL procedures to data aggregators and manufacturers.
Axium Specialty Pharmacy/Kroger 9/2014 – 11/2016
BI Developer II
De facto lead among BI Developers introducing improvements in processes for testing new data extracts in a testing environment, primary trainer for new developers brought in during 2016 (8 so far), discovery of new protocol for building data extracts, improving automation and efficiencies within internal reporting, and contributing to a policy for deployment/coding for the BI team in transitioning to Kroger.
Coordinated delegation and resource designation for certain projects.
Built several data extracts from top to bottom in the ETL process using SQL Stored Procedures, Views, and queries as well as SSIS packages featuring FTP transmissions to data aggregators and manufacturers.
Led an effort to convert a battery off Crystal reports onto an SSRS platform for consumption via Sharepoint.
North American Risk Services 9/2013 – 8/2014
Database Report Writer
Designing and deploying reports using Toad, Crystal XI and Business Objects for delivery through an automated report subscription Intranet portal for export to internal and external users via various applications (Excel, .PDF, etc.)
Consulted with managers to meet the over-arching needs of monthly reports in order to improve productivity for them and their front line employees.
Managed monthly data exports to external clients via preprocessing and FTP.
Access Mediquip 10/2009 – 9/2013
Designing and deploying reports using either Excel, T-SQL, SSRS and SharePoint via Cubes (SSAS) or SQL Queries to provide either performance tracking or executive summary/dashboarding.
Consulting with Management to advise and assist with methods of deployment for said reporting as well as metrics and delivery of data within reporting.
SME for company data schema and reporting structure to consult best strategy for building of new system metrics and features with minimal impact to current reporting.
Software Techniques Inc 12/2008 – 5/2009
Served as a supporting entity for conversion teams in the field for clients providing query writing and data analysis in SQL 2005 and Toad. Also facilitating training to Clients and Project Managers via remote desktop sessions on how to use facets of the CAMA (Computer Aided Mass Appraisal) product while working closely with technical writers on documentation of said material.
Provided reporting writing in Crystal XI for various product clients (Lafayette Parrish, Louisiana as well as various Florida County Clients).
Global Travel International 8/2006 – 12/2008
Application Support Liaison II
Major responsibilities consist of writing SQL reports for company executives using Query Analyzer and 2005 Microsoft Studio Express and deploying these reports to an Intranet using Virtual Studio.
Responsible for maintaining a Membership Database and Commission tracking system through data manipulation and building DTS packages.
Responsible for communication between departments outside of IT including Accounting, Customer Service, QA, and Sales departments as the 'Face' of the IT department and using the ubiquitous company exposure to provide support and insight into the design and coordination of new business systems and processes.
Orlando Regional Healthcare 10/2003 – 8/2006
Data Support Tech
Within the Ancillary System Support Services Department at Orlando Regional Healthcare, audited charges for Orlando Regional Medical Center, Lucerne Hospital and the Ambulatory Care Center.
Kept statistics on Excel Pivot tables regarding charges.
Trained nurses how to use the new computer OR documentation system, SIS (Surgical Information Systems), at 9 facilities in ORH at multiple stages including Pre-Admission Testing, Pre-OP, OR, PACU, as well as light work assisting with Preferences cards and the Post-Op Module.
Ran and wrote Crystal 8 reports for charge specialists.
Started out as Data Entry worker inputting written OR records into the previous computer system.