Scott Rummel

Experience

• 

  Management Science Associates, Inc.

  Jun 1997 - Feb 2000

  Programmer IV

  • Developed and maintained several Visual Basic applications, as well as Oracle stored procedures, functions, packages, etc. for a cable television network, management system.

• 

  UPMC Health Plan

  Feb 2000 - Aug 2000

  Systems Analyst II

  • Developed data transformation logic and automation functionality for the enterprise-wide data warehouse. • Assisted colleagues with the development of several Visual Basic applications. • Administrated the SourceSafe database.

• 

  TEKsystems

  Aug 2000 - Feb 2003

  Senior Consultant

  • Developed and/or maintained numerous systems, spanning multiple technologies.• Clients Included:Allegheny Energy, Inc. (Jun 2001 – Nov 2002)Xerox Connect (Feb 2001 – Apr 2001)Matthews International Corporation (Aug 2000 – Feb 2001)

• 

  Pyramid Consulting Group, Inc

  Feb 2003 - Mar 2004

  Consultant

  • Designed and developed an integrated customer service system with searchable, web-based knowledgebase. • Responsible for the underlying structures of both the Oracle and Access databases. • Worked one-on-one with end-users and management to gather requirements, to test system acceptance and to manage project goals and benchmarks. • Provided extensive documentation for knowledge turnover. • Improved user productivity in the areas of service call management, field service requests, and repair management.• Clients Included:JeremiahGroup, L.P.ASIRobicon, Corp. Show less

• 

  McKissock LLC

  Mar 2005 - Dec 2005

  Independent Contractor

  • Managed three-person development team. • Worked one-on-one with end-users and management to ensure quality. • Designed and developed company-wide, customer service system. • Integral in design and development of database structure and stored procedures. • Improved user productivity and efficiency in many areas of the business process.

• 

  TEKsystems

  Jan 2006 - Sept 2006

  Programmer/Analyst

  • Developed and/or maintained numerous systems, spanning multiple technologies.• Clients Included:Equitable Resources (Jul 2006 – Sep 2006)Allegheny Energy, Inc. (Jan 2006 – Jun 2006)

• 

  EQT Corporation

  Sept 2006 - Aug 2008

  Senior Systems Analyst

  • Technical lead and developer on multiple projects, including Third Party Domestic Billing, Unit Downtime Manager, Flow-Cal, and the Contact Management System.• Worked one-on-one with team members, users, and management to develop the Field Data Management – Meter Test module.• Active in the Application Forum for establishing development and toolset standards to be used enterprise wide.• Active on the ITIL process improvement team for incident management.

• 

  Federated Hermes

  Sept 2008 - Feb 2020

  Lead Technical Specialist

  • Using Agile (SCRUM) methodology, developed and maintained Oracle used by the in-house developed, portfolio management system, FedPortS.• Developed Oracle procedures to generate valid XML streams to be sent as quarterly FINRA regulatory filings.• Developed and maintained over 300 batch jobs that include Linux shell scripts, PL/SQL scripts, and stored packages, procedures, and functions.• Responsible for documentation including, detailed designs, test plans, and support hand-off documents.• Responsible for following both in-house and third-party compliance and audit guidelines and policies. Show less

• 

  Lowe's Companies, Inc.

  Sept 2020 - May 2022

  Customer Service Associate - Electrical Department

  • Answered questions, provided solutions, assisted with purchases, and offered advice for customers, both in person and over the phone, concerning electrical needs.• Developed a reputation for being a reliable and flexible associate – working a widely varying schedule and covering other departments.• Received a Red Star award for excellence in customer service.

• 

  UPMC

  Apr 2022 - now

  Programmer - Senior