Sql Server Developer
Resume:
JASON W. BUSH
Argyle, TX ***26
Mobile: 214-***-****
******@***.***
SKILLS
Proficient in Data Warehousing and Analysis, ETL, Microsoft SQL Server (2019, 2017, 2016, 2014, 2012, 2008R2, and earlier versions), T-SQL, Oracle SQL Developer, PL/SQL, Greenplum, DB2, PostgreSQL, ANSI SQL, Powershell, Wherescape RED, SSIS packages, DTS, SSRS reports, Visual Studio, Unica, AWS, TOAD, C++, TFS, JIRA, Stonebranch, Agile and Waterfall methodologies, Cognos Impromptu, and Cognos PowerPlay Enterprise Server.
EXPERIENCE
Mr. Cooper Group, Coppell, TX December 2023 - Present
Senior Systems Developer
Generate SQL queries, stored procedures, and Unica workflows to configure and create population files for Email and Direct Mail Marketing campaigns. Maintain and process SSIS packages for transfer of Marketing results to Finance databases and maintain subscriber data from Salesforce. Write SQL queries to track emails sent from Salesforce for the Compliance team. Write SQL queries to track audit requests for Direct Mail campaigns.
Norwex, Coppell, TX June 2020 – December 2023
Business Analyst/SQL Developer
Generate SQL queries, stored procedures, and SSRS reports for over 250 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.
Process data corrections to consultant orders and recruiting and ensure the data quality is reflected in the incentive reward calculations and commission payouts.
Pier 1 Imports, Fort Worth, TX November 2019 – June 2020
Contractor/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.
Jason Bush Page 2
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.
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. Created scripts to correct data issues in inventory and the supply chain workflow. Coordinated change management tasks and deployments of data interfaces. Disaster recovery testing of data interfaces.
Jason Bush Page 3
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
Contractor/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.
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 for data quality issues in the underwriting systems. 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
Jason Bush Page 4
AWARDS & RECOGNITION
Travelers Property and Casualty 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