EDWARD R. SCHEID
Pittsburgh, PA 15213
********@***.***
SUMMARY
Extensive technical background in a wide variety of software tools for a diverse group of departmental applications. Experience in analytic problem solving as well as in communication and training. Critical writing and reporting have been published in a variety of sources.
TECHNICAL EXPERIENCE
Database Design and Support:
Access, DB2, Visual FoxPro, Oracle, Teradata, FoxPro, R:Base, FileMaker Pro on Mac, Visual Basic, Lotus
Notes, Client-server architecture, Interfacing a Visual FoxPro database with Lotus spreadsheets
Application Programming and Other Experience:
SAS, PL/SQL, Visual Basic, Visual Studio, UNIX, FORTRAN, COBOL, MPSX, Turbo-Pascal, Excel, PowerPoint, Word, Brio, TOAD, Novell, IBM Token Ring, JCL, RACF Security Administration
PROFESSIONAL EXPERIENCE
Mindteck 2014-2015
Business Analyst at Highmark
Provided business analysis support in a variety of tasks.
Prepared and revised business requirements documents.
Wrote user stories for a range of requirements and outcomes.
CompuGroup Technologies 2013-2014
Business Analyst at Allegheny County
Support over a variety of platforms.
Analyzed accounting system and prepared requirements document for conversion of system from mainframe to SQL-based system.
Converted Access database to a project in Microsoft Visual Studio.
Modis 2012-2013
Business Analyst at Direct Energy
Provided analysis for multiple projects.
Evaluated advantages of potential project options and scored vendors on meeting project requirements.
Prepared slide show, spreadsheets, and requirements documents to specifications.
CIBER 2007-2012
Business Analyst at Highmark
Member of support team for data reporting and analysis system.
Interface of SAS and DB2 data for system conversion.
Analysis, troubleshooting, and completion of requested enhancements.
Responsible for administration of claims data warehouse.
Provided ad hoc reporting and statistical analysis with SAS.
Ran SQL queries on Teradata.
Investigated user inquiries on warehouse data, deciding on any necessary program revisions for data correction.
Performed analysis for converting claims select requests to new claims data system.
Sapphire Technologies 2004-2006
Business Analyst at PNC Bank
Responsibilities included analysis and programming in PC and mainframe environments.
Analyzed business needs and translated detailed requirements into SAS and SQL programs to support major initiatives with competing deadlines.
Queried Oracle database to create leads for marketing opportunities.
iGATE 2003-2004
SAS Programmer
Provided analysis and a variety of software support for a retail sales data tracking system.
Designed, adapted, and enhanced SAS programs for the statistical analysis of project data.
Interfaced SAS programs with Oracle database and Excel spreadsheet data.
Produced PowerPoint charts in a variety of formats to client specifications.
Information Technology Consultant 2001-2003
Activities included software support and technical writing for a range of companies and individuals.
Supported a database and generated reports for a publishing company.
Provided technical writing for a start-up proposal.
Consolidated Natural Gas 1978-2000
Systems Analyst
Progressively responsible positions from Programmer/Analyst II through Systems Analyst. Provided production system support for a variety of applications. Activities included testing and troubleshooting while meeting competing deadlines. Experience with technical and network support.
Significant Accomplishments:
Managed a project with members of different departments that successfully tested and implemented a database that kept information of foundation grants and requests. All data options were tested.
Designed, adapted and implemented applications of projects including a labor billing system, a legal file management system, a flexible benefits system, simulation models, and cash flows.
Designed and adapted databases in Visual FoxPro, R:Base and Advanced Revelation. Also designed screens, forms and reports for use with the databases.
Extensive SAS programming including statistical studies, file merges, and ad hoc reports. SAS was used for a variety of departmental applications. Convinced supervisor to convert COBOL programs to SAS because of ease of use and adaptability of SAS.
Mainframe optimization and support including COBOL programming, JCL, batch jobs, and RACF security administration.
Trained and provided instruction manuals for employees with different technical backgrounds.
Developed a seismic analysis system for the Geology Department which, when implemented, saved $500,000 in one year in the prevention of dry hole drilling.
Freelance Journalist and Photographer 1991-Present
Have written about the Cannes, Telluride and Sarasota French Film Festivals. Work has appeared in the Pittsburgh Post-Gazette, Boxoffice Magazine, Eclectic Magazine, The Tribune Review, Pittsburgh City Paper, In Pittsburgh, Film Threat Magazine and The Rich/Poor Man's Guide to Pittsburgh.
Blog: Cinemasight.wordpress.com.
EDUCATION
Professional Development: Project Management, Business Analysis, Oracle, C++, UNIX, Cost Benefit Analysis, Economic Evaluation, and various seminars in effective communications
M.S. Industrial Engineering, Operations Research Option - University of Pittsburgh
Q.P.A.: 3.70
B.S. with Double Major in Computer Science and Mathematics - University of Pittsburgh
Q.P.A. Overall: 3.49, Computer Science: 3.70, Mathematics: 3.67