Share this Job

Analyst Program/Sys 4

Apply now

Apply for Job

Date: Jul 13, 2019

Location: San Antonio, TX, US, 78205

Company: CPS Energy

We are engineers, high line workers, power plant managers, accountants, electricians, project coordinators, risk analysts, customer service operators, community representatives, safety and security specialists, communicators, human resources partners, information technology technicians and much, much more. We are 3,300 people committed to enhancing the lives of the communities we serve.  Together, we are powering the growth and success of our community progress every day!

Position Summary

CPS Energy is seeking a highly analytical and technical individual to provide reporting and support to Power Generation!

Responsible for system administration, hardware support, software support, maintenance, security, programming, troubleshooting, and enhancements.  Also, responsible for documenting and developing procedures.  Provides analytical support and reports for various projects, programs and portfolios to project managers, program/project team leaders and other internal and external stakeholders as assigned

*Posting extended, Position posted until filled

Grade 15

Tasks and Responsibilities

System Administration
•    Manage 8 servers (6 report generation servers and 2 web publishing servers) running Windows Server 2012
•    Maintain dual landscape reporting system for development and production
•    Monitor and manage SQL Database tables on hosted servers and systems in development and production
•    Monitor and manage Oracle Database tables on hosted servers and system
•    Manage Oracle APEX web application within Power Generation shared schema
Software Support
•    Completely manage Visual Cut application used for generating reports and web content on 6 reporting servers
•    Manage Task Monitor application (provided with Visual Cut) used in conjunction with Windows Scheduler for batch processing on reporting servers
•    Coordinate with software vendor to implement changes and enhancements to Visual Cut application
•    Monitor available updates to Crystal Reports application and apply enhancements as applicable
•    Work Management SAP support and annual testing as requested during system updates/upgrades
Maintenance
•    Monitor hourly updates to reports/webpages/dashboards and databases on Dev and Prod systems
•    Monitor monthly updates to servers/operating systems and ensure active account sessions are maintained for successful processing
•    Monitor operating system processing and storage capacity on Dev and Prod system servers
•    Monitor interfaces between SAP – SQL transferring work management data and resolve issues as necessary
•    Manage backups of all files and folders used for processing on report servers 
•    Monitor synchronization between Dev and prod system and resolve issues as required
Security
•    Maintain security on shared folders in web environment to limit access as required
•    Maintain security on web servers folder structure to allow access as required to web pages, reports and dashboards
•    Maintain and implement security constraints on Oracle Web Forms during and after development
 

Tasks and Responsibilities Continued

Programming
•    Generate batch processes using command lines to generate web pages, reports, emails, dashboards and update databases
•    Utilize Crystal Reports and its functionality to develop reports from multiple data sources as needed for Power Generation business requirements
•    Utilize Visual Cut in conjunction with Crystal Report to generate reports, web pages, database updates, highly formatted PDF and Excel files
•    Utilize Oracle APEX web application development tool to generate and host web forms for PG Business use
•    Utilize ETL (Extract, Transform, Load) processing as required to transfer data from multiple disparate data sources and merge as needed for reporting requirements
Troubleshooting
•    Troubleshoot network and database connections to multiple data sources on hosted servers
•    Troubleshoot processing errors and perform enhancements to Visual Cut application with vendor support
•    Troubleshoot Crystal Reports development and processing issues and assist Power Gen employees with application support
•    Troubleshoot SAP Work Order/ Work Management processing to SQL and resolve issues as applicable
•    Troubleshoot Time Posting/Order Update issues with WORMS time management application and time posting reports
Analytical Support
•    Develop and generate ad hoc reports as requested for PG Business Unit management and staff
•    Support PG Management and business teams with reports and content as needed, including support outside Power Generation when requested
•    Assist with defining requirements and capabilities in business process enhancements based on ability to provide information available as needed
•    Analyze generated reports and provide feedback to support results as required
 

Minimum Skills
Personal Computer Usage
Minimum Knowledge and Abilities
Extensive experience as a programmer/analyst in a field supporting and providing technical and analytical solutions.
Extensive experience in program/project management for Operational Units.
Exceptionally strong analytical and problem solving abilities
Demonstrated ability to multi-task various critical work assignments proactively and independently in a fast paced environment and in a professional manner.
Ability to identify alternative solutions for development of decision-making proposals, which support organizational goals/objectives and budget constraints
Initiative to work independently or as a member of a team, coordinating with others to achieve desired results
Demonstrated well-developed written and verbal communications skills for interaction within the section, across departmental lines to all levels of personnel, and vertically with management.
Ability to handle complex assignments, be a self-starter, be able to meet goals and deadlines on own initiative with minimum supervision
Demonstrated positive interpersonal behaviors toward CPS Energy, associates, and customers consistent with company core values.
Position content is substantially complex with diverse issues and problems
Possesses and applies comprehensive knowledge of a particular field of specialization to complete complex assignments.
Ability to make independent decisions and often makes recommendations which affect the section, department and/or division
High level of accuracy of work and attention to detail, to include the ability to perform precise mathematical calculations
Highest level subject matter / technical expert and may include limited supervisory responsibilities
Works with minimum supervision, conferring with superior on unusual matters. Incumbents have considerable freedom to decide on work priorities and procedures to be followed.
Ability to work at any location at any time with extensive time in the field working with business areas
Extensive experience in Information Systems, Reporting Solutions, Database Management and Web Development
Ability to translate business needs to technical specifications
Preferred Qualifications

•    Experience with Data Visualization software and techniques (e.g., Crystal Reports).
•    Experience with server based server scheduling solutions (e.g., Visual Cut, Business Objects).
•    Experience with data mining, trend analysis, & data analytics.
•    Experience with Enterprise Maintenance Management Solution (e.g., SAP).
•    Experience with Microsoft SQL Server query and database management
•    Experience with Oracle / APEX for data management and web form development
•    Experience with the electric or gas utility industry in Maintenance Management and Power Plant Operations
•    Extensive knowledge and experience in Microsoft Excel.

Competencies
Demonstrating Initiative
Working with Ambiguity
Driving for Results
Evaluating and Implementing Ideas
Driving Continuous Improvement
Communicating Effectively
Minimum Education
Bachelor's Degree in Information Technology, Computer Science, Environmental Science or related field from an accredited university OR Related area; proven working experience may be used in lieu of degree
Required Certifications
Working Environment
Work is performed indoors & outdoors. Manual dexterity, talking, hearing, and repetitive motion. Use of computing equipment, telephone, & printer/copier. Ability to travel to and from business related events. After hours work may be required
Physical Demands
Indoor/Outdoor Environment

CPS Energy does not discriminate against applicants or employees. CPS Energy is committed to providing equal opportunity in all of its employment practices, including selection, hiring, promotion, transfers and compensation, to all qualified applicants and employees without regard to race, religion, color, sex, sexual orientation, gender identity, national origin, citizenship status, veteran status, pregnancy, age, disability, genetic information or any other protected status. CPS Energy will comply with all laws and regulations.


Nearest Major Market: San Antonio

Job Segment: ERP, Oracle, Database, Programmer, Information Systems, Technology