Sql Developer Business Intelligence

Corey Brammer

Randolph, IA ***** 402-***-**** *************@*****.***

PROFESSIONAL SUMMARY

Thorough SQL Developer with expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances. Conversant in up-to-date and legacy programming languages, standards and tools. Adept in leading all stages of software development and troubleshooting.

SKILLS

SQL2019

SQL2016

VB.NET

C#

SSIS

Azure

DevOps

PowerShell

QlikSense

PaaS

SQL analytics

SQL development

Database design

Infor

Advanced SQL queries

Syteline

WORK HISTORY

SQL DEVELOPER 06/2021 to 09/2024

Millennium Contractors Remote

Responsible for configuring pipelines for deploying new Application Release to 13 environments

Created Stored Procedures to perform pre-deployment tasks, turn off and on backup jobs, verify configuration files had needed updates after deployment, check database rows for updates before and after deployments

Create jobs with SSMS to perform tasks to archive log shipping databases

Create T-SQL statements for ad hoc reporting for managers and other customers upon request approval within the ticket system

Troubleshoot Applications and Infrastructure resources hosted in Azure

Support all Cloud Resources in Azure

Started Implementing AI services to deployment processes

Develop, monitor and receive alerts for errors and performance

Develop and manage CI/CD process for different types of application and automate as many processes as possible

Completed ongoing training on Azure Cloud Technological aspects

Successfully collaborated with 50 peers to achieve the companies' goals

Mentored all new incoming applicants in configuring and working in the Azure environment, and general daily operations

Assisted Implementing PaaS and SaaS into the13 environments

Researched and Implemented PowerShell in conjunction with stored procedures to streamline deployment processes

Work in an Agile environment to support individuals on proper DevOps practices

Manage and support customer environments in Microsoft Azure cloud

Manage the full release process

Supported multiple countries with Production issues

Assisted in Smoke tests of deployed releases

Worked with vendor to resolve any bugs in the application

Support development teams in technical questions of continuous integration/continuous delivery

Consult customers on technical aspects of installation, sizing, scaling

Develop, implement and maintain CI/CD pipeline to system integration environment

Configured new servers to be released for production

SQL DEVELOPER/WEB DEVELOPER/DBA 12/2020 to 07/2021

Aureus Consulting Remote

Backup, restore databases to production and local SQL server development

Configured SSRS for reporting and Subscriptions

Developed stored procedures for reporting

Created data dictionary, and documentation SSRS2017

Create complex SQL stored procedures using SQL2019

Gathered Business requirements from end users for reports; Convert Oracle reports to SSRS

Analyzed existing SQL queries to identify opportunities for improvements.

Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.

Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.

Developed custom database objects, stored procedures, and delivered application support.

SQL DEVELOPER/SSRS DEVELOPER 06/2020 to 11/2020

The Green Technology Group LLC Remote

Backup, restore databases to production and local SQL server development

Configured SSRS for reporting and Subscriptions

Developed stored procedures for reporting; Created data dictionary, and documentation SSRS2016

Create complex SQL stored procedures using SQL2019

Gathered Business requirements from end users for reports

Converted Oracle reports to SSRS

Migrated data from Oracle12C to SQL2019

Analyzed existing SQL queries to identify opportunities for improvements.

Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.

Developed, implemented and optimized stored procedures and functions using T-SQL.

SQL DEVELOPER/DATABASE ADMINISTRATOR/DATA ANALYST 02/2020 to 06/2020

Marianna Industries Inc/ Omaha, NE /Remote

Backup, restore databases to production and Dev SQL server(development)

Install and configure SQL2019 database

Configured SSRS for reporting

Created data dictionary, and documentation of AS400 to SQL2019

Create Indexes, Triggers, PowerShell; Maintain Database security and integrity, Debug performance issues

Extract data from acquisitions to conform to AS400 data structure and SQL2019

Create complex SQL stored procedures triggers using SQL2019

Worked with 3rd Party vendors to resolve data issues, and create SSIS packages using Visual Studio2016

Business requirements gathered from end users

Installed High Availability, Publication, Always On

Develop Dashboards for all divisions within the company

Created connection to AS400 to QlikSense for real time reporting

Analyzed existing SQL queries to identify opportunities for improvements.

Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.

SQL DEVELOPER/DATABASE ADMINISTRATOR 12/2018 to 04/2019

F.E.S Lincoln, NE

Backup, restore databases to production and Dev SQL server(development)

Create Indexes, Triggers, PowerShell

Managed Postgres DBs and created stored procedures, tables, stored procedures

Maintain Database security and integrity

Performed ETL functions to bring Postgres databases structures and data to SQL

Debug performance issues

Create complex SQL stored procedures, function and SSIS packages using SQL2012,2017

Obtained vast knowledge of Data Modeling

Monitored and alleviated bottleneck in data usage, within poorly written stored procedures and indexes

Worked with 3rd Party vendors to resolve data issues

Gathered Business requirements from end users

SQL DEVELOPER/DATABASE ADMINISTRATOR/SSRS DEVELOPER 07/2016 to 11/2018

Smart Chicken Waverly, Ne

Backup, restore databases to production and development; Create Indexes, Triggers

Maintained Database security and integrity, Debug performance issues

Create complex SQL stored procedures, function and SSIS packages using SQL2016,2019

Developed ETL Project to transform Sales Data into useable information for daily operations for sales team

Implemented High Availability, Publication, Always On

Collaborated with Primary DBA while designing and implementing DW for QlikSense

Develop and test new reports and perform maintenance of existing reports

Created processes to extract sales data from email attachments and insert them into DW using CTEs and Stored procedures

Creating reports using SQL SSRS2016

Worked with 3rd Party vendors to resolve data issues

Designed PowerShell Script to pull Weather services near grower farms

Business requirements gathered from end users

Maintained QLIK SENSE Server

SQL DEVELOPER/SSRS DEVELOPER/ETL DEVELOPER 02/2012 to 06/2016

American Alarm & Communications Arlington, MA

Backup and restore production and development databases

Develop event and triggers in Infor Syteline

Edited, created new forms for Syteline Infor

Edited and created new buttons, dropdowns, radio buttons, including the code to edit and create new actions

Created ETL scripts to insert data into Syteline databases

DBA duties performance tuning, profiling security

Create complex SQL stored procedures, function and SSIS packages using SQL2008,2012

Migrate data from legacy system to new system using ETL and SSIS packages on a time sensitive schedule

Worked closely with other team members to provide the best IT solutions for the company

Develop and test new reports and perform maintenance of existing reports

Used 5PM to track progress of projects

Advise proper SSRS standards and created documentation on standard set forth for report formatting

Creating reports using SQL SSRS2008,2012

Worked with 3rd Party vendors to resolve data issues

Business requirements gathered from end users

Mentor Interns with editing SSRS reports and stored procedures

DEVELOPER 02/2011 to 02/2012

Omaha Public School Omaha, NE

Created complex SQL stored procedures using SQL2008

Maintained data integrity of new and existing code

Gathered requirements from users

Developed new reports and perform maintenance of existing reports

Used Team Pulse to track progress of projects

Advised proper SSRS standards and created documentation on standard set forth for report formatting

Created reports using SQL SSRS2008

Coded and documented new utility applications using VB.Net

Worked with a team of10 developers to deliver the best solutions

SQL/VB.NET/SSRS DEVELOPER 01/2007 to 01/2011

State of Iowa Des Moines, IA

Create complex SQL stored procedures using SQL2005 and 2008; Worked in a team of 26 to meet strict deadlines providing best front end and back-end solutions

Mentored ITSS3 and ITSS2; Maintain SharePoint Site and Deploying reports

Granted security to different directories

Edited and created new buttons, dropdowns, radio buttons, including the code to edit and create new actions in Syteline Infor

Edited code within the forms of Syteline Infor

Performed data pulls from DB2 to use in SSRS report by inserting into data warehouse

Linked SQL to DB2 for direct access to data

Created reports using SQL SSRS2005

Performed maintenance to ASP .NET applications and VB.NET applications

Use web services to send email with Global360

Maintain C# applications designed by other developers

Used LINQ within web site to efficiently display and retrieve data for providers to see

Kept Iowa Medicaid Enterprise website up to date with current and relative information for members and providers

Code and document new utility applications using VB.NET

EDUCATION

Bachelor of Science Computer Science 05/2005

Bellevue University, Bellevue, NE

Associate of Science Computer Science 05/2003

Southwestern Community College, Creston, IA

ACCOMPLISHMENTS

Achieved peer manual tasks by 30% through effectively helping with creating automated tasks to reduce manual scanning, and data entry.

First ever to receive profit sharing without 12 months of tenure.

.

C

B

Contact this candidate