JASON W. BUSH

**** ******** *****

Argyle, TX ***26

Mobile: 214-***-****

adypzp@r.postjobfree.com

SKILLS

Proficient in Data Warehousing and Analysis, ETL, SQL Server 2019, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008R2, SQL Server 2005, SQL Server 2000, Oracle SQL Developer, T-SQL, Powershell, Wherescape RED, Greenplum, DB2, PostgreSQL, SSIS packages, SSRS reports, TOAD, COBOL, C, C++, TFS, JIRA, Stonebranch, Cognos Impromptu, and Cognos PowerPlay Enterprise Server.

EXPERIENCE

Norwex, Coppell, TX June 2020 – Present

Business Analyst

Generate SQL queries, stored procedures, and SSRS reports for daily, weekly, monthly, and quarterly reports for various business units including Sales, Finance, and Marketing. Maintain regional mappings and report access for sales managers. Develop SQL queries for consultant incentives and fulfillment. Develop reports for conference registrations and awards recognition. Generate 1099 tax reports for sales consultants for Finance. Create ad hoc queries for special reporting projects.

Create and alter SQL stored procedures to support consultant tracking reports in the web applications.

Pier 1 Imports, Fort Worth, TX November 2019 – June 2020

Senior Developer

Conversion of SQL 2008 SSIS packages to SQL 2014 packages. Create and modify Stonebranch workflows and tasks for job schedules of these packages.

Development of SQL 2014 SSIS packages to upload Salesforce data into the current systems.

Create tables, ETL processes, and schedule workflows for customer reporting projects.

Heritage Auctions, Dallas, TX January 2018 – October 2019

SQL Developer

Development of SSIS packages, stored procedures, tables, views, and Powershell scripts and API calls for vendor data exchanges of coin indexes, grades, inventory, and images. Development of stored procedures for SSRS reports to track customer session data.

Create and alter stored procedures, functions, tables, and views to support web and internal applications for inventory, auction sales, and invoices.

Halo Companies, Plano, TX July 2017 – January 2018

Senior Database Administrator/Developer

Development of SSIS packages, stored procedures, tables, and views for various data extracts and data uploads. Development of stored procedures for SSRS reports to track student loan statuses, balances, and payments.

Jason Bush Page 2

Monitor nightly and monthly jobs for data interfaces and database restores for the databases housed in an AWS environment. Administer accounts in production and replication environments. Provide production support for data cleanup.

Teknion Data Solutions, Irving, TX June 2014 - March 2017

Senior Consultant

Data warehouse and SQL development with Wherescape RED and SSIS for banking, healthcare, and government housing clients. Managed deployment and testing of RED packages to test and production repositories. Improved deployment processes to a 98% success rate during initial deployment. Created database tables, views, schemas, keys, indexes, stored procedures, and jobs for data loading processes.

Data analysis and testing in Greenplum, SQL 2012, and Tableau reporting. Provided ad hoc reports for data discrepancies.

Managed data access through user account controls in SSMS.

DynCorp International, Fort Worth, TX April 2007 - June 2014

Principal Database Analyst

Data warehouse development in SSIS for supply chain, time and labor, finance, and human resources systems. SSAS cube development for supply chain,

project controls and accounting, human resources, and operations reporting. Migration of data warehouse environments from SQL Server 2008 to 2012. Data

architect for warehouse tables. Provided evaluations and demonstrations of data warehousing and business intelligence reporting tools to senior IT management, program managers, and senior executive management.

Database administration and support for business applications systems. DTS and SSIS development of data interfaces and stored procedures between various applications including accounting, purchasing, and time and labor.

Provided level 3 production and on-call support for data interfaces, purchasing, and time and labor systems. Created T-SQL queries for data cleanup and ad hoc reporting of supply chain and purchasing systems. Coordinated change management of data interfaces. Disaster recovery testing of data interfaces.

Served as deputy manager for business applications and development team. Mentored team members on data and application processes.

Cambridge Integrated Solutions, Carrollton, TX October 2006 - February 2007

Cognos Developer

Data warehouse report development in Cognos. QA testing of data warehouse reports.

Provided help desk support of published reports.

CitiFinancial Mortgage, Coppell, TX January 2006 - September 2006

Business Analyst

Published Cognos cubes and reports for the data warehouse development team. Assisted developers with reports. Provided on-call support of database job loads.

Maintained an inventory of production cubes and reports. Documented development procedures. Organized database access entitlement reviews.

Jason Bush Page 3

Gulf Insurance Group, Irving, TX October 1997 - October 2005

Senior Information Systems Specialist

Coordinated change management of systems. Underwriting systems development in COBOL and C with DB2. Provided technical support for the commercial system. Analyzed business specifications to provide technical designs for new projects. Performed database corrections with T-SQL queries. Converted generated ADW code to standard COBOL.

Disaster recovery and Y2K testing. On-call support for nightly batch processes. Trained consultants on the systems.

Data warehouse report development in Cognos.

EDUCATION & PROFESSIONAL TRAINING

Northeast Louisiana University, Monroe, LA

Bachelor of Science in Computer Science, August 1997

Continuing Education

Cognos Series 7 - Report Building with Impromptu, December 2004

Cognos Series 7 – Advanced Impromptu Reporting, December 2004

Maintaining a Microsoft SQL Server 2008 Database, July 2009

ITIL Version 3 Foundation, October 2010

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services, March 2012

Kimball University’s Dimension Modeling in Depth, February 2015

AWARDS & RECOGNITION

Y2K Project Award, 2001: for contributions made to prepare for the new millennium

STARter Award, April 2005: for outstanding performance and lasting contribution to the Information Technology Team based on extraordinary customer service

Lightning Bolt Award, November 2009: for relentless performance above scope of assigned duties by cross-training on applications outside of responsibility to more effectively support customers

Lightning Bolt Award, June 2010: for support of STS tax data integration project

Contact this candidate