SUMMARY:

• Confidential has nearly twenty years of SQL and related Business Intelligence development and analysis experience.
• His skills focus within the Confidential Technology stack and include SQL Server, SQL Server Management Studio and Confidential Visual Studio (BIDS) 2005, 2008 and 2008 R2, 2012, and 2014.
• His experience includes manipulating various data sources to extract, organize, and then present required information to support business decisions.
• Developing both leadership and team skills during his service, Confidential has a dedicated work ethic with the ability to accomplish tasks under minimal direction and supervision while always keeping team work and project goals as priorities.

TECHNICAL SKILLS:

• SQL versions 2005, 2008, 2012, 2014
• SQL Server Integration Services (SSIS) 2008, 2010, 2012, 2014
• SQL Server Reporting Services 2008, 2012, 2014
• Crystal Reports 8.0, 8.5, 9.0, X, XI
• Confidential Scheduler
• Process Automation and improvement
• Confidential Power Pivot
• Product Migration
• Product Optimization
• Confidential
• Protected Health Information
• Disaster Recovery
• Cyber security
• Agile
• Waterfall
• Project Management
• Standard Confidential Office Suite
• System Architect
• DBA
• C#
• PHP
• Oracle 11g

PROFESSIONAL EXPERIENCE:

Business Intelligence Developer

Confidential, Charlotte, NC

Responsibilities:

• Designed and Created Fact and Dimension tables for new Data Warehouse
• Create and scheduled Extract/Transact/Load processes
• Converted old Stored Procedures and SSRS reports to utilize the Data Warehouse
• Optimized Stored Procedures
• Convert Crystal Reports to use Data Warehouse

Skills Used: SQL versions 2008 and 2012, TSQL, SQL Server Reporting Services 2012, SQL Server Integrated Services, Crystal Reports 2008, Confidential Scheduler, Process Automation and improvement, Product Migration, ETL, Business Intelligence, Data warehouse, Report validation, Standard Confidential Office Suite

Transact Structured Query Language Developer (T - SQL)/ Integration Services Developer

Confidential, Charlotte, NC

Responsibilities:

• 10 fold reduction in customer downtime
• 40% reduction in error rate as compared to manual process
• Identified and isolated abnormal or inconsistent data fields to facilitate data cleanup
• Created audit logs for process verification
• Script optimization of existing scripts to improve overall clinical staff productivity
• Improved system response time by as much as 50%
• Reduction of required network resources
• Analyzed customer system to identify scripts for atomization Table design and optimization
• Modeled new tables for application prior to development, and review with application developers, to insure all fields, keys, and constraints are understood and applied
• Reduced rework and modifications of the Data Definition Language scripts
• Design and build out of data access layer consisting of Stored Procedures and Views
• Cyber security implemented for Confidential and Confidential
• De-identified patient records allowing clinical database to be used in training and development environments, enhancing productivity and reducing development and training cost

Skills Used: SQL versions 2008, 2012, 2014, SQL Server Reporting Services 2012, 2014, SQL Server Integration Services (SSIS) 2012, 2014, Data Modeling, Confidential Scheduler, Process Automation and improvement, Confidential Power Pivot, Process automation and improvement, Product Migration, Product Optimization, Confidential, Protected Health Information, Disaster Recovery, Cyber security, Agile, Project Management, Standard Confidential Office Suite, System Architect, C#, Oracle 11g

Business Intelligence Senior Software Design Engineer

Confidential, Fairfax, VA

Responsibilities:

• Developed and completed on time and under budget, the Confidential system for senior management to reflect current sales and forecast three years based upon existing calculations.
• Managed project through full system lifecycle
• Organized and facilitated requirement gathering and status meetings with senior management on progress of the agreed upon list of requirements
• Designed an automated system that reduced time required for this manual process 40 fold (2 weeks to 2 hours)
• Improved accuracy of data reported by 100% by converting several manual process to an automated system
• Automated system to execute and distribute Pipeline reports to the CEO and department heads on a monthly schedule (utilized this graphical and textual information for planning purposes, contract negotiations, and meeting presentations)
• Database Administrator for various corporate application systems
• Maintained database backups and maintained disaster recovery procedures
• Scheduled and executed database maintenance on a routine basis
• Setup and maintained database security
• Data Table Architect for all new application
• Utilizing data modeling tools, designed application tables for new application
• Extraction of Data Definition Language scripts from Toad for building tables
• Wrote the Data Access Layer for the new application
• Implemented an Extract Transform Load (ETL) database package that allowed dissimilar data to be merged together and reside in an Operational Data Store
• Organized and designed new Confidential for reporting access to data
• This data store allowed for timely and meaningful reporting to take place across different database platforms
• This process allowed zero impact to applications and system users by providing a uniform platform for all reports to be generated

Skills Used: SQL versions 2005, 2008, 2012, 2014, SQL Server Reporting Services 2012, SQL Server Integration Services (SSIS) 2008, 2010, 2012, Confidential Scheduler, Process Automation and improvement, Confidential Power Pivot, Process automation and improvement, Product Optimization, Disaster Recovery, Cyber security, Waterfall, Project Management, Standard Confidential Office Suite, System Architect, DBA, C#

Business Intelligence Designer and PHP Developer

Confidential, Richmond, VA

Responsibilities:

• Worked with all business stakeholders to assess Application requirements to insure they meet Confidential requirements and managed the process from conception to full rollout of the system
• Designed and implemented data model to capture and validate all data entered into the system
• Designed and developed over 200 custom web pages utilizing PHP and HTML that allowed the system users to enter their information into the database while capturing their login information and timestamp
• Completion of this application on time insured compliance with Confidential requirements
• Created custom Confidential Reporting Services reports and setup and configured SQL Server Reporting Services server and security to allow only authorized users access to the reports
• Implemented Integrated Services for their internal operational processes allowing for the optimization of their database allowing for the system to operate efficiently

Skills Used: PHP, SQL versions 2005, 2008, SQL Server Reporting Services 2008, Toad Data Modeler, Toad for SQL Server, Confidential Scheduler, Process Automation and improvement, Product Migration, Waterfall, Project Management, Standard Confidential Office Suite, System Architect, DBA

Senior Business Intelligence Developer

Confidential, Roanoke, VA

Responsibilities:

• Configuration of full SQL Server 2008 Reporting Services environment
• Setting up Reporting Services security to restrict access to different reports
• Designed all SSRS reports, most with parameters and drill down capability (allowed Payroll department and management to monitor their labor costs as well as man-hours per piece of manufactured equipment in real time)
• Oversaw the moving of code from the Development platform to testing/Quality Assurance to Production environments
• Tasked with the responsibility of fixing some old Crystal Reports as well as creation of some new reports for the Human Resources department
• Upgraded many of the old legacy reports and added new functionality to them
• Fixed some known issues they had with the existing reports
• Worked with end users to determine new reporting requirements that were not in the legacy system that was needed
• Created several new Crystal Reports with drill-down capability, allowing the managers to view data at a high level and allow them to drill down to the details in the report as needed
• Configured the Business Intelligence scheduling process to automate some of the reports that are run on a set basis, while distributing the reports to the proper individuals
• Also tasked with Training small groups on configuration, and user training of the time clock application which involved traveling to other facilities around the US.

Skills Used: SQL versions 2005, 2008, SQL Server Reporting Services 2008, 2012, Crystal Reports XI, Confidential Scheduler, Process Automation and improvement, Product Optimization, Waterfall, Project Management, Standard Confidential Office Suite

Senior Crystal Reports / SQL Server Reporting Services Implementer

Confidential, Tempe, Arizona

Responsibilities:

• Analyzed, designed, implemented, and maintained of over 600 reports for the city courts, Police department, Water department, Development Services, Engineering department, Mayor and Council offices, and some outward facing reports that resided in a Confidential zone for citizen to access
• Provided Reporting ability for many departments that had limited if any reporting from their computer system
• Created matrixes for management to monitor their systems
• Designed and built reporting system that compiled building inspections for each building inspector on a daily basis and distributed to their tablets each morning, thereby eliminating the need for each inspector to spend the first hour each day compiling their own list
• Provided 25 hours a week that the inspectors could be in the field, reducing the time delay for permit inspections from 3 days to 1 day
• Produced critical dynamic reports using Crystal Reports on a Business Objects Enterprise system, eventually migrating to a SQL Reporting Services environment
• Served as Project Manager for the Business Objects Enterprise system implementation and upgrades overseeing many resources in the process
• Upon migration away from Business Objects to Confidential Reporting Services, reviewed each reports’ usage and met with stakeholders to determine if the reports still met all their current reporting needs
• Converted the legacy reports to the SQL Server Reporting Services and made any business rule changes necessary (ran parallel testing with the legacy system and then implemented into the system).

Skills Used: SQL versions 2005, 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services 2008, Crystal Reports 8.0, 8.5, 9.0, X, XI, Confidential Scheduler, Process Automation and improvement, Product Migration, Product Optimization, Disaster Recovery, Waterfall, Project Management, Standard Confidential Office Suite, DBA, MS Project