Kayla Schrecengost Email & Phone Number

United States

• Database Administration & Optimization – System Administer monitoring server and database performance for any preemptive & emergency maintenance needs. Update currently existing view designs to optimize reporting and create adhoc reports as needed by the team. • Legacy MS Access Database Management – Analyze network security requirements, VBA and SQL coding to optimize query execution. Perform weekly & monthly maintenance to ensure proper function by business unit. • Database Creation – MS Access and SQL Server for Utility Affidavit needs, ICE Physical & Financial deal management and Utility Enrollment/Billing File management • New Database Implementation - Project Management Lead for total system implementation. Coordinates setup, training and information management between customer & provider.• Serves as IT Helpdesk Support for the team utilizing the Natural Gas Electronic Bulletin Board and other software specific needs for the team. • Reporting Enhancements – automate repetitive tasks using VBA Macros in Excel and Access. Transform large utility datasets into usable information through the use of Pivot Tables, Charts, Spreadsheet Server etc. Create SQL and non-SQL based reports as needed by the team.• Organized Enrollment Processes for all utilities to be handled by a single individual increasing efficiency & accuracy and developed relationships with natural gas utility representatives to strengthen effective communication between stakeholders

Kittanning, Pa

• Oversee and organize the scheduling of natural gas from production, through transmission pipelines and LDC Utilities• Analyze production, transportation & end user data in an effort to find more efficient and cost effective scheduling solutions.• Collaborates in the operations planning process recommending strategies to: minimize cost while maximizing value, provide contingency plans for use during supply/demand disruptions, load forecasting, inventory storage management• Manage Crude Liquids transactions through scheduling and accounting of gasoline & distillate sales

Kittanning, Pa

• Schedule movement of natural gas through transmission pipelines and LDC Utilities• Manage and balance pipeline and customer accounts through the update of internal systems to reflect commodity movements, the applicable transportation fees and the best available volumetric data using information gathered from various sources including plants, supplier and transporters• Collaborates in the supply planning process including the recommendation of strategies to: minimize cost/maximize value, provide contingency plans for use during supply/demand disruptions, load forecasting, inventory storage withdrawal plans and reporting actual storage levels versus targets• Maintain Crude Liquids transactions through scheduling and accounting of gasoline & distillate sales

Pittsburgh, Pa

• Assist with transition of client duties from Client Relations team to Business Intelligence team.• Help manage client sales/trade marketing data and data processes• Interact with internal MSA teams• Create and maintain integrity of client deliverable for data and reporting• Provide quality assurance for data and reporting

Pittsburgh, Pa

•Help manage client sales/trade marketing data and data processes •Interact with clients, data suppliers and internal MSA teams •Accountable for planning and coordinating client project assignments •Coordinate functions and requests between internal areas •Create and maintain integrity of client deliverables for data and reporting •Assist in development of changes to existing deliverables and in creation of new ones •Provide quality assurance for data and reporting •Ensure successful completion of client data projects

Survey condition of guiderail, drains and shoulders along various state routes to ensure safe functionality.

Master Of Science - Ms Data Analytics, Management Information Systems, General

• Decision Support Systems Analysis & Design • Systems Analysis and Design • Networks & Data Computing Communication • Database Management.

Bachelor Of Science In Business Administration, Marketing

Geneva College Semester in Rome - Community Engagement Coordinator Future Business Leaders of America Tutor - Quantitative Analysis.

Technical Drafting Certification, Computer Aided Drafting And Design/Pre-Engineering Technology, 4.43 Gpa

Activities and Societies: Certified Technical DrafterComputer Aided Drafting and Design, Pre-Engineering Technology