Senior Programmer Analyst Resume
St Louis, MO
CAREER SUMMARY:
I am an Information Technology Professional with over 14 years of experience. I have experience with all phases of the System Development Life Cycle. Significant efforts include designing Business Intelligence applications with WebFOCUS on Linux and Unix platforms. I have also developed financial and HR applications in COBOL and FOCUS/ WebFOCUS on a VAX/ALPHA and Unix platform. Also, efforts include development of applications with SQL and PL/SQL in a Unix environment supporting a Banner ERP system (Finance, Student, and HR Banner modules). I have developed the following technical skills:
TECHNICAL SUMMARY:
HARDWARE:IBM PCs and compatibles
IBM Mainframe DEC/VAX DEC/Alpha
OPERATING SYSTEMS:VMS, TSOWindows 95, 98, 2000, NT Unix Linux
LANGUAGES:COBOL JCL JavaScript FOCUS
WebFOCUS HTML DCL SQL PL/SQL VB Script
SOFTWARE: MS Office MS Project MS Outlook PeopleSoft Banner GroupWise JDE TOAD
DATABASE:VSAM DB2 ORACLE SQL Server Access
EDUCATION:
M.B.A., emphasis in Management Information Systems
B.S., Management Information Systems and Marketing
MIS Coursework and Training Completed:
Database Management Systems, Systems Analysis and Design, E-Commerce Application Development and JavaScript, Managing Information Technology, Oracle and SQL, Oracle Forms, Oracle DB Warehouse Builder, FOCUS, WebFOCUS, COBOL, VB.Net, Visual Studio.
PROFESSIONAL EXPERIENCE:
Senior Programmer/Analyst; 1/08 – Present
Confidential
St. Louis, MO
Environment: Unix, Oracle, Data Warehouse, SQL, PeopleSoft, JDE, Business Objects
- Develops applications within PeopleSoft to generate Profit and Loss Statements reports in Business Object for Finance department
- Assisted with the project of integrating a newly acquired division within the company’s data systems by helping to create PeopleSoft processes that generated reports within Business Objects for a new product line
- Analyzes users financial information management problems and designs appropriate application development solution JDE end-users
- Develops applications within EPM and Data Manager modules within PeopleSoft
- Translates functional requirements into technical requirements to design application development solutions for users
- Troubleshoots data and process issues to generate technical solutions for end-user
- Resolved data issue that centered around a cost discrepancy associated with the company’s allocation costing methods of mixed pallet/case manufacturing
WebFOCUS Developer; 12/07 – 1/08
Confidential
Minneapolis, MN
Environment: Unix, Oracle, SQL Server, WebFOCUS
- Developed WebFOCUS applications and reports for Enterprise Business Intelligence Department
- Developed technical requirements to provide support for business analysts and end-users
- Analyzed multi-platform system to provide application development support for users
- Generated BI technical solutions for end-user based off of business analyst functional requirements
Business Intelligence Specialist; 12/05 – 10/07
Confidential
St. Louis, MO
Environment: Banner, Unix, Linux, VAX/ALPHA, WebFOCUS, Oracle, SQL, COBOL, DCL, VMS
- Managed the WebFOCUS Executive Dashboard project to created a fully integrated WebFOCUS reporting dashboard for executives at the university
- Migrated about 150 legacy mainframe WebFOCUS reports to WebFOCUS 7.1
- Enabled and provided support to WebFOCUS power and end-users throughout the University’s user communities; ensured information security policies were adhered to and enforced.
- Designed and developed WebFOCUS reporting applications
- Performed WebFOCUS MRE administration
- Collaborated with database administrators and the Business Intelligence Product Manager to plan and coordinate version upgrades and patches.
- Created and delivered WebFOCUS training and support plans for end users.
- Evaluated WebFOCUS 7.1 toolset vs. COGNOS 8 toolset as a part of the Analysis Phase of the Enterprise Data Warehouse Project
- Coordinated the integration efforts for merging BI platforms with enterprise systems and applications, including Banner ERP, the operational data store, and the enterprise data warehouse
- Evaluated and provided input to selection of database/data warehouse components, hardware, relational database management systems, extract, transform, and load (ETL) software, metadata management tools, and database design solutions; produced ETL design guidelines
- Managed user data requirements; designed functional specifications; developed BI reports and front-end applications, such as dashboards and portal channels;
- Provided technical support for Finance, Student, and HR Banner modules
- Created Appworx module and chain processes to accommodate Banner Finance nightly and monthly jobs
- Maintained Banner Finance nightly and monthend Appworx jobs (which include sleep/wake, forapple, etc)
- Modified PL/SQL code to enhance Banner Self Service applications
- Managed and provided technical support for WebXtender, the university’s document imaging system which fully integrates with Banner
Senior Programmer/Analyst; 10/97 – 12/05
Confidential
St. Louis, MO
Environment: Banner, Unix, Oracle, SQL, VAX/ALPHA, COBOL, FOCUS/WebFOCUS, DCL, VMS
- Assisted with a full-scale Banner 7 ERP implementation
- Performed data conversion from legacy system to Banner environment
- Loaded data into Banner tables through SQL Loader processes
- Developed SQL and Shell scripts to generate email notifications to Banner Finance end-users to approve departmental requisitions
- Troubleshooted Banner issues for users and created technical solutions
- Maintained Banner Finance nightly and monthend Appworx jobs (which include sleep/wake, forapple, etc)
- Analyzed user, departmental, and client information management problems and designed appropriate computer software solutions for the Financial Records System.
- Developed financial, accounting, and human resources applications in COBOL and FOCUS on a DEC/VAX platform.
- Developed WebFOCUS applications on a DEC/VAX and Unix platform
- Developed applications in SQL and PL/SQL related to the University’s Banner ERP application to support the Finance office
- Maintained and provides follow-up support for existing computer programs and systems.
- Train users of programs and system.
Computer Information Specialist/Programmer; 4/96 – 10/97
Confidential
St. Louis, MO
Environment: VAX/ALPHA, COBOL, FOCUS, DCL, OPEN VMS
- Developed and managed financial aid information systems with COBOL and FOCUS on a VAX platform
- Developed, designed, and distributed managerial, research, and ad hoc reports.
- Analyzed, enhanced, and maintained automated and manual systems.
- Identified needs, acquisition, and maintenance of microcomputer hardware and software.
- Evaluated new technology and its application in office functions.
- Coordinated and consulted with technical staff and directors and provided technical support, advice, and training to users.
User Support Intern; 5/93 – 9/93
Confidential
St. Louis, MO
Environment: IBM Mainframe, TSO, VSAM, JCL
- Designed a database on an IBM PC to increase efficiency when entering customer records.
- Provided documentation to the user support group through use of software on the IBM mainframe (TSO and VSAM).
- Modified COBOL and JCL programs to maintain specific applications
Computer-Aided Design and Machines Intern; 5/92 – 9/92
Confidential
- Worked on VAX computer systems performing file maintenance in a Computer-Aided Machines/Computer-Aided Design area.
Strategic Management and Financial Planning Intern; 5/91 – 9/91
Confidential
- Assisted with the strategic planning process by performing financial, competitive, and industry analyses.