SUMMARY:

• Highly motivated Data Analyst, Report Developer, Business Intelligence Consultant, Technical Trainer, Data Base Administrator, and SQL Software Developer using SQL Server 2005/2008/2012/2014, Microsoft Technologies, Business Objects, Crystal Reports, and Excel. Vast experience analyzing, manipulating, and reporting from various data sources to support Senior Management decisions. Demonstrated instructional abilities and teamwork skills.

TECHNICAL SKILLS:

Microsoft Technologies: SQL Server 2005/2008/2012/2014 Integration Services, Analysis Services, Reporting Services, Microsoft Office SharePoint Server 2007, Microsoft Excel and Excel Services, Microsoft Visio, ETL

Databases: MS SQL Server 2005/2008/2012/2014, Access, dBase, rBase, Oracle, Moodle

Software: MS Visual Studio 2012 BI, SQL Server Business Intelligence Development Studio, Microsoft Office Suite, Project Manager, Crystal Reports and Crystal Server (Business Objects), TOAD Data Base Modeler, SQL, T - SQL, DB Visualizer

Support environments: Healthcare, call center, marketing, teaching, financial, communications, legal

PROFESSIONAL EXPERIENCE:

Confidential, Deland, FL

IT Instructor and IT Lead

Responsibilities:

• Teach Associate level courses including A+ Hardware, A+ Software, Wireless and Network Security, Microsoft Exchange Server 2010
• Teach Bachelor level courses including Web Programming, JavaScript, PHP and Accounting
• Participate in faculty meetings to discuss curriculum development, retention, and job objectives
• Maintain grades, attendance, retention, re-entry, and drops records

BI & SQL Technology Training & Development

Confidential, Maitland, FL

Responsibilities:

• Use VS2008, SQL Server 2014, Notepad++ and Excel to extract text files from clients and save them in a standardized set of .csv files
• Transform and clean the data from the .csv files using SSIS and TSQL SSIS packages were designed for each ETL process and integrated into a master .dtsx package
• Load the enhanced data into SQL Server 2008R2 data tables on remote server data bases
• Completed 2 projects - Skamania and Marriage Licenses. The data bases were used by HRS Oncore and Accaim programs to scan and classify county documents

Confidential, Orlando, FL

Responsibilities:

• Use SQL, MySQL, and Excel to develop and modify WebChart table reports
• Create MySQL script reports for net wait analysis, certification types, incident aggregations, incident details, new resource name lookups, and location site lookups.
• Modify and enhance Enhanced Encounter Search and DOT Driver Exams reports

Confidential, Lake Mary, FL

Responsibilities:

• Prepare IT candidates for employment on BI contracts and projects.
• Design training schedules, training materials, lab exercises, and projects for Business Intelligence concepts, implementations and development
• Teach Microsoft T-SQL queries, SQL Server 2014 Management Studio, Visual Studio 2012 Data Tools, SSIS, SSRS, SSAS and Data Modeling

Confidential, Orlando, FL

IT SQL Report Writer

Responsibilities:

• Create 15 call center reports, modify 20 call center reports
• Use numerous report & delivery tools including TSQL, MySQL, Virtual Process Modeler, Link Vision report generator/visualizer SQLYog, TidySQL, MS SQL Server, Hip Chat, QQM Quick Query Manager

Confidential, Lake Mary, FL

Responsibilities:

• Upgrade system jobs, SSIS packages, and stored procedures using SQL Server 2012, SSDT, and Visual Studio 2010
• Document requirements, technical specs, test plans, test results, and deployments
• Re-design complete night job schedule to run at 10 - 12 pm, rather than 12 to 7 am to facilitate a more effective technical support plan.
• Create incremental extraction plan to streamline a significant nightly task from 45 minutes to 3 minutes
• Modify main GL and AP procedures to trap validation errors and create alerts

Confidential, Jacksonville, FL

Responsibilities:

• Develop Inbound Sallie Mae Recovery system. Completed all import SSIS packages.
• Create complex SSIS packages, Stored Procedures, and SQL queries using MS SQL Server 2008R2 and Visual Studio 2007/2010
• Design, modify, test, troubleshoot, and document components of the system development
• Export COBOL - IBM signed fixed length data records, transform records to work with Latitude collection interface, and load corrected data records into SQL Server tables

Confidential, Jacksonville, FL

Responsibilities:

• Maintain & modify interactive BIRT Customer Statements reports which run on an Apache Tomcat server from a web browser
• Develop documentation for changes, problems & fixes
• Use SSRS to create ad hoc reports and drill-down reports, and then export them into Excel spreadsheets for executive level analysis
• Use SSIS to import and aggregate financial data into SQL Server tables
• Train IT staff on SSIS, SSRS, SSAS, Microsoft BI tools, and BI reporting Tools
• Developed an SSIS package which updates a cross reference table from daily shipment orders and a master NDC table. This saves time for sales persons to create order invoices with current available vendor medications and prices, and also to fulfill orders from different vendors

Confidential, Longwood, FL

Responsibilities:

• Develop SQL queries, stored procedures and ETL import procedures to complete Confidential Open Acquisition project.
• Automate procedures in SQL Server 2005 from Access manual processes.
• Maintain time, project and summary documentation

Confidential, Jacksonville, FL

Responsibilities:

• Maintain Confidential legacy banking and financial reports until Confidential merger is complete
• Prepare and post weekly and monthly financial reports
• Use EssBase, Excel, Compaq SQL Server, and Access to reconcile monthly GL trial balance accounts with changing database structures
• Use Excel, Excel Services, MS SQL Server 2008 & BI suite, Performance Point Services, Project Server, and SharePoint 2010 to prepare and post KPIs, Dashboards, and BI reports on a BI SharePoint server

Confidential, Green Cove Springs, FL

Responsibilities:

• Manage corporate databases, backups and processes
• Analyze POS data on SQL Server 2005 system with Counter Point interface
• Add/change customers & employees
• Maintain daily replications, reports and postings for 80 stores and satellites
• Develop SQL queries
• Support Crystal Reports, Visual Cut, Counter Point, SQL Server 2005, Hamachi VPN, remote control, daily data exports and imports

Confidential, Lake Mary, FL

Online Math Instructor

Responsibilities:

• Teach College Algebra and Analytical Tools (Statistics) online classes
• Facilitate online discussions, and create supplemental course materials
• Create weekly grade and at-risk reports

Confidential, Columbia, SC

Field Systems Specialist

Responsibilities:

• Install and configure mail service software including SmartMailer, SendSuite Xpress, SendSuite Dashboard, Arrival and LobbyGuard.
• Support mail service software, printers, and data collectors.
• Travel extensively in South Carolina, North Carolina, Georgia and Florida
• Used Access and SQL Server for tracking client leads, project customizations, online reviews

Confidential, Phoenix, AZ

Information Technology and Math Instructor

Responsibilities:

• Teach online classes with students from coast to coast.
• Facilitate online discussions, and create supplemental course materials.
• Facilitate Management Information Systems, Databases, Programming Foundations, Java Programming, System Design and Analysis, Internet Concepts, Network Concepts, Math, World Religions, Telecommunications, Unix/Linux, Math and Algebra classes.

Business Intelligence Consultant & Trainer

Confidential, Parsippany, NJ

Responsibilities:

• Implemented a Labor Analysis Business Intelligence solution for a fictitious national construction company
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. SQL Server Integration Services was used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Created several MDX queries according to business requirements.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services.
• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
• Create a Data Warehouse as part of a project team, process it to include ETL, SSAS OLAP cubes, SSRS reports, and deploy it on a SharePoint Server.

Confidential, Orlando, FL

Responsibilities:

• Teach Microsoft Certified Business Intelligence classes including SQL Server 2005/2008 & SS Analysis Services
• Teach Project Management and Vista.
• Prepare desktops for VM Ware and presentations

Confidential, Lake Mary, FL

Responsibilities:

• Manage BI database management system
• Provide consulting and support for the Business Intelligence - Data Warehouse division.
• Maintain SQL Server tables for Infoblast reports.
• Integrate Oracle data base with Business Objects Infoview reports.
• Setup Infoblast documents, distribution and format lists, blasts, and schedules.
• Maintain users and rights using Business Objects Central Management Console.
• Document DataWarehouse logs.
• Monitor report benchmarks and web portal validations.

Confidential, Sanford, FL

Systems & Program Analyst

Responsibilities:

• Interfaced with various internal business units: developers, data base administrators, vendors, Juvenile Court system deputy clerks, Juvenile Court managers
• Produced and presented Functionality Gap Analysis report which compared new desired features in relation to the old Juvenile and Criminal Court systems.
• Create project timeline, SQL model and JSP menu system for Juvenile System
• Improve system reliability by created 40 Crystal Reports (Business Objects) for the Criminal System, including underlying SQL code and logic
• Schedule daily reports to run and print to Unix printers with Crystal Server (Troubleshoot and fix input errors by analyzing Informix data using DB Visualizer

Confidential, Daytona Beach, FL

Training Specialist

Responsibilities:

• Traveled coast to coast to provide on-site training for pharmacy technicians in hospital
• Used WebEx for remote training
• Instructed operators, new employees, product specialists, and field service engineers to operate and maintain syringe filling system
• Developed training agenda, materials, manuals, and online training modules
• Interfaced with all departments

Confidential, Deland and Jacksonville, FL

Network Hardware, Math and Programming Instructor

Responsibilities:

• Taught courses in A+, Networking, TCPIP, Switches and Routing, C+, Java, Digital Imaging (Photoshop), Applied Design (3D Studio Max), Math, and Computer Concepts
• Maintained network lab and class websites
• Served on curriculum development and career services advisory board

Confidential, Chattanooga, Tennessee

Network & Computer Systems Engineer

Responsibilities:

• Responsible for all computer hardware, software, peripherals, and networks with a scope of over 150 users in 5 locations.
• Program using QBasic, dBase and rBase to create menus, data extractions, and customized data bases and reports.
• Gathered new system requirements from accountants and managers.
• Created yearly upgrade proposals and options
• Implement and tested HW, NW and SW upgrades.
• Managed Novell and Microsoft database management systems for tax, audit, financial and IT divisions including backups, images, users, directories, files and programs