• Currently in charge of rolling out Power BI.• Leads the Business Intelligence (BI) Solutions group with the development, implementation, and maintenance of business intelligence solutions.• Defines system scope and objectives for assigned projects.• Devises or modifies BI solutions and procedures to solve complex problems.• Prepares or reviews detailed specifications and is responsible for the design, coding, testing, debugging and documentation of those solutions.• Instructs, directs, and checks the work of other BI Solution Developers while performing quality assurance reviews.

• Developing Business Intelligence solutions with SAP Crystal Reports 2016, SAP BusinessObjects Web Intelligence – Webi, Qlik Sense and NPrinting.• Pulling data with SQL Server 2014, SQL Server Integration Services – SSIS, Visual Studio 2015, and Toad for Oracle.• Main data sources are Epic (Clarity and Caboodle), Vizient, and PeopleSoft.

* Pulled all SSIS packages into Team Foundation Server (TFS) to run in Dev, Test, and Production environments. All data sources/destinations use variable connection strings depending on environment the package is pointing to.* Data Conversion Lead for migration to new student information system (SIS), Edupoint Synergy. This impacted over 8,000 staff members and nearly 50,000 students. Pulled data from various sources such as PeopleSoft, Infinite Visions, and in-house sources.* Implemented tracking of changing student data in a data warehouse environment. This can handle creation of new tables/columns in source database, and can successfully import thousands of tables.* Automated daily/hourly creation and FTPing of data files for various outside vendors via SSIS.* On multiple committees involved with evaluating/recommending/implementing new software packages to be used by the entire school district.

* Working with SQL Server 2008 and 2012 Integration Services (SSIS). Major points involve variable data sources and logins, decrypting passwords, looping through servers, variables, shredding recordsets, and logging results and errors.* Handling the DBA process which reviews correctness of all database change scripts.* Handling deploys in all environments (QC, Beta, Production)

* Create reports and dashboards with Xcelsius and Crystal Reports. Use SAP Business Explorer (BEx) Query Designer as data source.* Help with flow, validity, automation, and presentation of information.* Investigating new reporting formats such as Silverlight (using Visual Studio 2010, Deep Zoom, and PivotViewer).* Administrator of Kinaxis RapidResponse - supply chain management and operations management software.

* Perform a variety of data warehouse reporting functions.* Develop and modify corporate reports; verify information integrity; and design BI dashboards, scorecards, charts / graphs, drill-downs, and dynamic reports.* Knowledge areas include data marts, reporting, OLAP design, and analytics.* Use Oracle 10g, Oracle Discoverer, Toad, Cognos, and Informatica.

* Led move in migrating Coplink database from SQL Server to Oracle 10g and 9i. Converted by hand 40,000 lines of SQL code, covering 280 stored procedures and 80 functions, moving from T-SQL to PL/SQL.* Main tools used were Toad and SQL*Loader.

* Led move to new data warehouse format and indexing, decreasing query time and size of databases. Critical project since tables contained up to 150 million records each.* Created back-end data-marts for Business Intelligence dashboards for use with Business Objects and SQL Server Reporting Services.* Automated all data importing/exporting to DTS/SSIS packages and stored procedures.* Set up all database maintenance and backup/restoration processes.* Managed small team of one junior database administrator and two report developers.

* In charge of data migration project for new company-wide Customer Relationship Management (CRM) program with 360+ users. Moved all automated triggers to SQL Server.* Maintained SQL Server databases - performed operations such as optimizations, backups, standardization, data transformation services (DTS), and data scrubbing.* Instituted snapshot replication between business sites, created decision-support database to free resources of live database.* Created users and maintained security, both Windows based and SQL Server based.

* Created productivity tracking program in Visual Basic which allows management to comprehend exactly what 260 customer service employees accomplish during any time period. This allowed for clearer understanding of productivity, problem areas, and accurate goal setting, which has led to completely revamping employee evaluation.* Created OLAP just-in-time inventory planning system to help plan inventory levels and needs.* Trained 30 users on aspects of databases such as report running, importing of data via SQL and Visual Basic from AS/400, Call Management System, and data entry.* Managed one data-entry employee.

* Oversaw database management for entire call center. Created databases, reports based on need. Ensured databases were properly maintained and data was accurate.* Tracked monthly productivity of 240 employees using multiple databases and CMS.* Interpreted report data, made recommendations to improve operating efficiency.

* Responsible for researching, compiling statistical reports to summarize call center's productivity by using Call Management System, Excel, Access.* Responsible for reporting on four programs with roughly 200 telemarketers on a daily/weekly/monthly/project-to-date basis.