Valmore Jarrell Email & Phone Number

Charlotte, North Carolina Area

Responsible for enhancing and supporting real-time Critical Infrastructure Networks (CIN) that manage the Piedmont natural gas pipeline systems, including the main Gas Control System, SCADA front ends, Data Historians, and other related systems along with the Liquefied Natural Gas and Compressor Station assets, and the automation and control systems associated with them.• Support: 325 RTU sites, 260 Pressure Recording Devices and 1300 LVRMR customer locations• Control systems in 3 three Liquefied Natural Gas Plants with 3BCF storage capacity, and 7 Compressor Stations comprising approximately 70,000 horsepower.• Monthly throughput of 17,000,000 DT’s ($75 MM in revenue)• Served as SQL Server Subject Matter Expert for SCADA team• Write SQL queries and reports for Engineering, system planning and business users• Collaborate with IT Data Architects to ensure accurate data for account billing for Large Volume Gas Customers task includes creating and troubleshooting stored procedures in SQL.• Worked on multiple projects for data integration between SCADA and the Natural Gas Business Unit. Account billing system and Spatial AnalyticsTechnical Skills used WonderWare, OASYs DNA 7.5, Microsoft Visual Basic,SQL Structured Query Language Microsoft BI, SSRS reporting, Microsoft Visual Studio.

Piedmont Town Center Charlotte Nc

Maintained current knowledge of the latest application upgrades and technologies, and assisted with system upgrades. Developed and improved departmental standards, procedures, and practices for application and database support. Principal Accountabilities include but not limited to the following. 1.) Providing proficient technical and functional knowledge of application.2.) Administering system access and security. 3.) Assist in managing the process of retrieving, analyzing, and applying application enhancements.4.) Work with the system owners to assess the impact of patches including system integrations. 5.) Recommend, schedule, and implement application patches, upgrades, and enhancements.6.) Install, test and document software patches and upgrades. Assigned systems include GSA, GSA Lite, ArcGIS Desktop, and FME which may hold data and business rules for facility inspection and maintenance compliance, gas system design, sales and marketing, property tax, field workforce management, and others. Techical skills used. SQL Server 2014, Visual Studio 2013, C# and GE Smallworld.

Responsible for managing and supporting high performing and sometimes highly visable applications.(Hyperion, PeopleSoft FDM, Microsoft BI Suite) Maintained comprehensive knowledge of application system implementation and system functionality through system upgrades and application patches. Also served as Security Administrator and was responsible for promotion of enhancement request. Maintained application accessibility, integrity, and recoverability. Resolved performance problems and recover from system outages.

Participated in the implementation of software applications and provided the necessary level of software support by: -designing more complex systems and program logic to meet the functional requirements of the End-user. Job Responsibilities included coding program logic, developing program test plans, testing programming work units and verifying results. Performing the appropriate level of systems and user testing, assisting in the completion of user acceptance testing to ensure that systems meet the design criteria, assisting in the maintenance of user, operations and technical documentation. Diagnosing and resolving reported problems with application software associated with assigned systems.

Charlotte, North Carolina Area

Design, code, test, and debug customized Interfaces, Reports, Crystals, Queries and Panel Changes. Prepare Scope Documents, Detailed Design Specifications and test plans for assigned projects. Responsible for all phases of Development Life Cycle. As the Senior Member on the Development team, provide Technical guidance and Training to less experienced team members. Assist with production support in resolving and troubleshooting program errors on a daily basis. Carried rotating pager to support payroll processing of over 17,000 checks on bi-weekly payroll. Served as Lead for the PeopleSoft 7.5 Upgrade Project. This included Design, Code and Test all Custom Reports, Interfaces, Queries. In addition Re-applied all Panel, Record, Field and Peoplecode modifications to the PeopleSoft 7.5 Environment using PeopleTools. Assisted with the Fit Gap Analysis for the Human Resources/Payroll/Benefits Modules. Assisted in writing Scope Document for 7.5 Upgrade Project, Coordinated Team Efforts regarding Analysis of 7.5 Enhancements.

Charlotte, North Carolina Area

Served as a member on Peoplesoft Implementation team. Created design specs for inbound/outbound interfaces. Made Modifications to SQR’S in 4.0 environments to accommodate version 6 environment, including table changes, environment variables and Logic changes these changes standardized sqr’s across the new databases. Wrote and executed unit and systems test plans for HRMS and Payroll inbound/outbound Interfaces.Performed compare analysis on set-up tables for HR/Benefits between PeopleSoft 4.0 and version 6.0. This included Reviewing Database structures in Data Designer and determining what’s available in delivered 6.0 and what is used in 4.0.Worked on Mergers and Acquisitions Team. Daily Task includes Analyze/develop/test programs to convert Data from The Money Store source data into First Union People soft Database. This included coding and testing SQR’s to convert all Personal Data, Employment, and Job Data, in addition to all Payroll related Data (Earnings, Deductions, and Taxes).

Bachelor'S Degree, Information Technology

Associate’S Degree, Business Administration