Jennifer L. Gohlke
Cypress,Texas
Summary
Experienced technical and business oriented professional who has delivered a multitude of advanced technical solutions to complex business problems on time and under budget. In depth industry knowledge in the waste industry and the midstream oil and gas industries. Extensive experience in all phases of the software development life cycle including requirements definition, design, implementation/development, unit testing, regression testing, quality assurance, maintenance, and overall project management. Ability to estimate project hours, prioritize tasks, communicate status to upper management, and manage project schedules/plans efficiently and effectively. Experience in developing and maintaining test cases, documentation, user training guides, and other project deliverables in order to complete and manage project milestones. Known for delivering impactful solutions that streamline processes and improve performance. Focuses on team collaboration and adaptability to meet evolving business needs, excelling in both analytical and communication skills.
Overview
18
18
years of professional experience
Work History
Senior Technical Business Analyst
Environmental Solutions Group (Dover Subsidiary)
03.2021 - Current
- Summary: Key member of the Data Lake and BI reporting team responsible for requirements gathering, QA testing, documentation, leading projects, and development Power BI reporting solutions.
- Key Roles/Projects:
- Assisted leadership with project management responsibilities for complex projects to create new body alerts for front loading garbage trucks involving collecting sensor data from AWS cloud and pulling it into the corporate Data Lake. Assisting in the technical design and programming of alert logic from the raw sensor data which is then sent to third party portal for via APIs for dashboard display and customer consumption/interaction.
- Developed and executed test cases for custom alerting project to ensure project requirements were met and the new programs satisfied all standard software quality principals
- Aid in the support and new creation of Power BI dashboards to aid internal customers in day to day tasks for customer portal support. Worked in Snowflake Cloud Database to create stored procedures and views to develop power bi datasets.
Sr. IT Analyst
El Paso Corporation (Kinder Morgan/El Paso Corporation Merger in July 2012)
01.2013 - 03.2021
- Summary: Support enhancements of custom developed Mechanical Engineering system used for analysis and maintenance of compressors and other pipeline equipment.
- Major projects include:
- Assisted in implementation of custom tool to create maps and graphs that visually displayed compressor performance using real time data for engine maintenance and repair recommendations.
- Developed SCADA tag mapping tool used by IT and BU admins to automate process of bringing new data points into the system and mapping them to system fields which cut IT and admin support time in half
- Achievements: Received spot bonus for my work in project to enhance the Environmental Module to calculate Green House Gas Emission in accordance with EPA regulations
Senior Business/Systems Analyst/Project Lead
Kinder Morgan
05.2007 - 03.2021
- Summary: Manage and develop large enhancement projects and provide advanced system support for many custom developed applications used by the Kinder Morgan terminals business segment.
- Key Roles/Projects:
- Plays a key role on support and project efforts of major applications used by accounting for billing, reporting, and contract management. System is used to generate over 5,000 invoices every month for all terminal’s customers.
- Solely responsible for all cube maintenance and development used for the BI reporting of the Terminal’s business segment. Currently managing the migration of all cubes to the new company framework and new server environments.
- Initiated and implemented project to reduce time required for contract approvals and invoice retrievals by providing new custom screens. Programmed my own solutions and also managed a contractor to complete the 1000 hour project in 750 hours.
- Successfully automated complex contract requirements and accounting logic for major products pipelines including KMCC and Double H
- Successfully managed 2000 hour enhancement project to improve the system performance, enhance system functionality, and provide BI reporting to properly implement a system to manage terminal cycle time operations. Managed three developers and completed project in 1800 hours and under budget.
- Managed and developed project to enhance invoice crediting system by providing new screens for manual entry and automating auditing requirements which reduced IT and business support for 100s of contracts.
- Assisted in design of large enhancement projects to add new customer module to master data management system
- Support person of custom developed system used for forecasting and budgeting of Kinder Morgan terminals revenue and volume
- Assisted in support tasks for BI reporting, cube maintenance, and ETL processing
- Achievements:
- Completed the most over-time hours by any employee in the Terminals IT in 2020
- Received Spot Bonus Award for ASC 606 Project
- Department award for best idea to reduce IT hours by reinventing the way report company logos are changed
Education
Masters of Science - Management Information Systems
Texas A&M University
College Station, Texas05.2005
Bachelors of Science - Information and Operations Management
Texas A&M University
College Station, Texas08.2003
Skills
- agile methodologies, Microsoft SQL Server, T-SQL, Microsoft Visual Studio, database design, data warehouse development and design, VBNET, Outlook, Microsoft Windows Servers, C#, Microsoft Power BI, T-SQL, SQL Server, SSIS, SSAS, GIT, Snowflake Cloud Database,
Timeline
Senior Technical Business Analyst
Environmental Solutions Group (Dover Subsidiary)
03.2021 - Current
Sr. IT Analyst
El Paso Corporation (Kinder Morgan/El Paso Corporation Merger in July 2012)
01.2013 - 03.2021
Senior Business/Systems Analyst/Project Lead
Kinder Morgan
05.2007 - 03.2021
Bachelors of Science - Information and Operations Management
Texas A&M University
Masters of Science - Management Information Systems
Texas A&M University
Similar Profiles
Samantha PodgornySamantha Podgorny
Product Manager Digital Safety Solutions at Environmental Solutions GroupProduct Manager Digital Safety Solutions at Environmental Solutions Group
Siddharth SharmaSiddharth Sharma
Lead - Technology at Capital Technology Solutions (A Subsidiary of Falcon Group of Companies)Lead - Technology at Capital Technology Solutions (A Subsidiary of Falcon Group of Companies)
Katie KrzykwaKatie Krzykwa
Branch Operations Supervisor at Dover Grease Traps And Environmental ServicesBranch Operations Supervisor at Dover Grease Traps And Environmental Services
Joshua TrudellJoshua Trudell
Office Assistant at Righteous Royalty Ministries, Inc.Office Assistant at Righteous Royalty Ministries, Inc.
Edmond O. AtandareEdmond O. Atandare
Advanced Practice Registered Nurse at University of Texas, MD Anderson Cancer CenterAdvanced Practice Registered Nurse at University of Texas, MD Anderson Cancer Center