Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Corey Brammer

RANDOLPH,Iowa

Summary

Tech-savvy innovator with hands-on experience in emerging technologies and passion for continuous improvement. Skilled in identifying opportunities for technological enhancements and implementing effective solutions. Adept at leveraging new tools and methods to solve problems and enhance productivity. Excels in adapting to fast-paced environments and driving technological advancements.

Overview

17
17
years of professional experience

Work History

Software Developer (Pipeline Developer/SQL Developer)

Millennium Contractors
06.2021 - Current
  • Company Overview: KPMG
  • Collaborated with cross-functional teams to design, develop, and implement new features
  • Assisted in creation of project timelines, milestones, and deliverables for effective project management
  • Conducted unit testing to verify that each component of application functioned as expected
  • Participated in code reviews to maintain high coding standards and best practices within team
  • Responded promptly to customer inquiries regarding software performance and potential enhancements
  • Optimized existing code for improved efficiency, readability, and maintainability
  • Analyzed user feedback to identify areas for improvement and enhance functionality
  • Debugged software issues to ensure optimal performance and minimize system downtime
  • KPMG

SQL Developer/Web Developer (DBA)

Aureus Consulting
12.2020 - 07.2021
  • Company Overview: DotComm
  • Supported development, delivery and troubleshooting of client application products
  • Designed database tables, structure and storage procedures
  • Performed regular database backups and recovery operations as needed
  • Collaborated with cross-functional teams to gather business requirements for database design and development
  • Ensured data integrity by implementing referential constraints, foreign keys, primary keys, unique indexes, check constraints, etc., within database schema
  • Identified opportunities for process improvement through performance tuning and index optimization strategies
  • Wrote optimized SQL queries for integration with other applications
  • Created stored procedures, functions, triggers, and views to support application development
  • DotComm

SQL Developer (DBA)

The Green Technology Group LLC
06.2020 - 11.2020
  • Worked closely with project managers to deliver quality results within deadlines
  • Migrated legacy systems to modern platforms by developing conversion scripts and mapping data structures
  • Provided expert guidance on SQL standards, conventions, and best practices throughout organization
  • Developed complex SQL queries to extract, analyze, and manipulate data from multiple databases
  • Implemented database security measures to protect sensitive information
  • Created stored procedures, functions, triggers, and views to support application development
  • Rewrote 450 Oracle Reports to SSRS with strict Governmental requirements

SQL Developer (DBA)

Marianna Industries Inc
06.2020 - 06.2020
  • Analyzed large datasets using advanced querying techniques for reporting purposes
  • Created wide range of database queries, functions and actions using SQL
  • Worked closely with project managers to deliver quality results within deadlines
  • Improved database performance by tuning queries to retrieve information with minimal error or delay
  • Created stored procedures, functions, triggers, and views to support application development

SQL Developer (DBA)

Smart Chicken
06.2016 - 12.2019
  • Company Overview: Tecumseh Poultry
  • Backed up, restored databases to production and development;
  • Created Indexes, Triggers
  • Create complex T-SQL stored procedures, function and SSIS pkg using SQL 2008,2012,2016;
  • Developed ETL Project to transform Sales Data into useable information for daily operations for sales team;
  • Develop and test new reports and perform maintenance of existing reports;
  • Worked with 3rd Party vendors to resolve data issues
  • Maintained QLIK SENSE Server
  • Tecumseh Poultry

SQL Developer

American Alarm & Communications
02.2014 - 06.2016
  • Backup and restore production and development databases; Develop event and triggers in Infor(ISM);
  • DBA duties performance tuning, profiling security;
  • Create complex T-SQL stored procedures, function and SSIS pkgs using SQL 2008,2012;
  • Migrate data from legacy system to new system using ETL and SSIS packages on a time sensitive schedule;
  • Worked with closely with CEO and CFO and other team members to provide the best IT solutions for the company;
  • Used 5PM to track progress of projects;

Developer

Omaha Public School
02.2012 - 02.2014
  • SSRS Developer;
  • Create complex T-SQL stored procedures using SQL 2008;
  • Maintain data integrity of new and existing code;
  • Gather requirements from users;
  • Develop new reports and perform maintenance of existing reports;
  • Used Team Pulse to track progress of projects;
  • Advise proper SSRS standards and created documentation on standard set forth for report formatting;
  • Creating reports using SQL SSRS 2008;
  • Code and document new utility applications using VB.Net;

ITS4

State of Iowa
01.2008 - 01.2012
  • SQL/VB.Net/SSRS Developer;
  • Create complex T-SQL stored procedures using SQL 2005 and 2008;
  • Mentored ITS3 and ITS2;
  • Maintain SharePoint Site and Deploying reports, granting security to different directories;
  • Creating reports using SQL SSRS 2005;
  • Performed maintenance to ASP.Net applications and VB.Net applications;
  • Use web services to send email with Global 360;
  • Maintain C# applications designed by other developers;
  • Kept Iowa Medicaid Enterprise website up to date with current and relative information for clients;
  • Code and document new utility applications using VB.Net

Education

Bachelor of Science (B.S.) - Computer Science

Bellevue University
Bellevue, NE
05.2005

Associate in Science (A.S.) - Computer Science

Southwestern Community College
Creston, IA
05.2003

Skills

  • SQL 2017,68588
  • VBNET
  • C#
  • SSIS
  • SHAREPOINT
  • Azure
  • DevOps
  • PowerShell
  • Qlik Sense
  • Software Development
  • Object-Oriented Programming
  • Programming

References

REFERENCES ON REQUEST

Timeline

Software Developer (Pipeline Developer/SQL Developer)

Millennium Contractors
06.2021 - Current

SQL Developer/Web Developer (DBA)

Aureus Consulting
12.2020 - 07.2021

SQL Developer (DBA)

The Green Technology Group LLC
06.2020 - 11.2020

SQL Developer (DBA)

Marianna Industries Inc
06.2020 - 06.2020

SQL Developer (DBA)

Smart Chicken
06.2016 - 12.2019

SQL Developer

American Alarm & Communications
02.2014 - 06.2016

Developer

Omaha Public School
02.2012 - 02.2014

ITS4

State of Iowa
01.2008 - 01.2012

Associate in Science (A.S.) - Computer Science

Southwestern Community College

Bachelor of Science (B.S.) - Computer Science

Bellevue University

Similar Profiles

  • Ravneet Singh

    Ravneet SinghRavneet Singh

    Senior Manager, Sales at Millennium Place Doha - Millennium Hotels & ResortSenior Manager, Sales at Millennium Place Doha - Millennium Hotels & Resort

    View Profile
  • Raval Kishan

    Raval KishanRaval Kishan

    Export Executive at Millennium overseas (Millennium Group)Export Executive at Millennium overseas (Millennium Group)

    View Profile
  • Marc David

    Marc DavidMarc David

    Cluster Front Office Manager at Millennium Al Barsha & Millennium MontroseCluster Front Office Manager at Millennium Al Barsha & Millennium Montrose

    View Profile
Corey Brammer