Cory Mckee Email & Phone Number

Meriden, Connecticut, Us

Meriden, Connecticut, Us

Sparks, Maryland, Us

• Design, build, deploy, and maintain comprehensive, highly encrypted, ETL operations which import and export data from sources such as Snowflake, SQL Server, MongoDB, Excel and Access files, third party APIs and a plethora of different flat files• Build beautiful interactive dashboards, KPI notifications, and paginated reports for all units of the business with applications such as PowerBI, Tableau, Excel, SSRS and SQL Server Agent Jobs• Create and handle essential ad-hoc reports, emergency query requests, and data mining projects that are used by the business to quickly adapt to and address consistently changing regulations and client requests• Collaborate frequently with developers, business analysts, project managers, and other stakeholders to conduct requirement gathering for projects, discuss most efficient techniques available, and assist with quality assurance• Use SSIS packages, with custom C# script if needed, to create, read, and import paginated excel reports• Create and process SSAS cubes, design and populate numerous data marts, and generate files for MS Access• Leverage extensive version control with GitHub to properly stage, test, and deploy projects to production• Design and implement custom ETL solutions, using Python and SQL Server Integration Services to connect to third party APIs, convert JSON data to relational data, and ingest files into a data store• Recommend indexes, repair and optimize inefficient queries, troubleshoot and design stored procedures, views, functions, and triggers

West Palm Beach, Florida, Us

• Led an offshore database development team to create, validate, and maintain the company’s operations reports• Routinely monitored database performance and replication, addressed and repaired inefficient queries, and implemented indexing procedures with applications such as SolarWinds and SQL Server Management Studio• Designed and managed processes using SQL Server Agent Jobs for creating denormalized databases to speed up reporting, improve query performance, and maintain data history• Responsible for developing and maintaining SSIS packages and stored procedures required to extract, transform, clean, and load data and metadata into a data warehouse and various data marts• Implemented version control operations using Team Foundation Server for reports, stored procedures, indexes, tables, views, triggers, functions, excel documents, and SQL Server Job scripts• Created and maintained auditing applications using Excel Macros with Visual Basic to establish database connections for the company’s quality assurance department• Managed an internal reports site to host SSRS reports to assist company operations, provide performance updates, and enforce compliance policies• Built essential real time reports with minimal latency for key operations of the business with data safeguards, by leveraging automated security groups, manual permission structures, and data encryption

West Palm Beach, Florida, Us

• Assisted in SQL development for data validation, reporting, analyst inquires, and new application features• Collaborated with business analysts to create functional requirement documents for the development team• Maintained reporting subscriptions, created views for business analysts, and assisted in security permissions• Participated in team discussions on how to improve processes to increase efficiency of quality assurance testing• Created and documented test cases within an application’s UAT environment for quality assurance testing• Assisted users with various issues by utilizing an internal support site, including setting up new accounts with proprietary software, verifying and documenting system bugs, and contacting third party providers about issues• Migrated and validated data to support early-stage analytics with new datasets

West Palm Beach, Florida, Us

West Palm Beach, Florida, Us

Shippensburg, Pa, Us

• Assisted students with comprehending and applying various financial theories and models• Consistently used excel to help students build and understand complex equations, so students would have something to review on their own

Hyattsville, Maryland, Us

• Assisted with sales forecasting, implementing planograms, and general store maintenance• Routinely audited sections of inventory to help maintain warehouse efficiency

Mechanicsburg, Pa, Us

• Validated the functionality of various applications before final implementation, and provided detailed documentation of errors, bugs, and wrong calculations.• Used languages such as JavaScript to create code for automating processes used in quality assurance testing

Shippensburg, Pa, Us

• Aided students in understanding and applying principles of macro and microeconomics • Assisted with everything from the basics of supply and demand, to using the Lagrangian Multiplier to optimize output subject to a total cost constraint

Doylestown, Pa, Us

• Responsible for acting as a role-model and educating adolescents on the importance of nutrition, proper exercise practices, and good sportsmanship• Create and organize fitness programs and activities to promote better health practices and behavior change for both adult and youth members