| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Kittanning, PA Street Address
Cell PHONE NUMBER AVAILABLEEMAIL AVAILABLETECHNICAL QUALIFICATIONSPlatforms: IBM Mainframe, HP Server
Software: Oracle DB, SQL, SQL*Plus, PL/SQL, SQLNavigator, Princeton Softech Relational Tools, LINUX/UNIX, LINUX/UNIX Shell Scripting, ETL,MS Query, QBE, MVS Client, HTML, Visual Express, z/OS CICS, COBOL, COBOL II, COBOL 370, Realia Cobol, JCL, SAS, RPG, Eztrieve. Syncsort, VSAM, IMS DB, DB2, DATACOM DB, OS/MVS/ESA, JCL, ISPF, SDSF, File Aid, ADW, Endevor, Xpediter, Intertest, AbendAid, Toad, TMON, SDF, RPG, FileAid, DataExpert, Expeditor, Intertest, FTP, AGILE, MS Office, Python.
PROFESSIONAL EXPERIENCESDBSOLUTIONSKittanning, PA January 2023 to PresentNon Technical
Assisted enterprising family member in their business startup.Technical
Continuing support for former clients using my talent with Cobol, CICS and Oracle SQL and other legacy software to upgrade their existing systems and ad hawk reporting for potential new clients.Former/Current Clients Include: Benedum Interests Bradigans Inc Critchfield ConstrionExploring other employment opportunities.
Participating in Python software training.Paul s Auto PartsKittanning, Pa July 2023 to November 2023
Installed hardware and software for the client to support their business needs. Created custom reports in support of their packaged software.BNY Mellon July 2022 to December 2022Meet with customers in order to analyzing their BANK REPORTING initiative requests in order to create program and process specifications. Directing and assisting team members in development using Cobol, SQL, DB2 ,CICS, Oracle(PL/SQL) and analysis skills for testing the clients requests. Directing and assisting the team solution for success. Other tasks as requested.Signet, Akron Ohio March 2022 to June 2022Due to being the largest retailer of diamonds in the U.S. it became necessary for the development of processes for timely inventory control and sales reporting. The systems were assigned to myself as team leader for Signet employees to observe and participate the develolate process of: Developing ad Testing solutions for processing , development and processing for mass daily data downloads (100+ Locations) using our Cobol, SQL, Unix, Oracle(PL/SQL) skills supporting the client s needs in Sales Reporting.Critchfield ConstructionSomerset, Pa February 2023 to June 2023
January 2020 to February 2021
Using my Cobol, SQL, Mainframe, MS Office skills to support the Construction/Disaster Recovery industry, to produce software solutions for the client s needs. During the Covid situation. Providing Analysis, Design, Recommendations and Technical Services using COBOL, SQL, and Microsoft Office.Generated Work Flow for requirements and timelines for Recovery Tasks which are very time sensitive.Developed Billing system and other additions.HM Health Solutions,
Pittsburgh, Pa April 2019 to November 2019Consulting and providing direction to a project specifically for the Provider Demographic Management section.Providing Mainframe Cobol, DB2, Oracle(PL/SQL) and analysis expertise for designing and creating a process to upload sub-system data information and extract information to update the TITAN Database.
PNC,
Pittsburgh, PA January 2018 to September 2018Consulting in the Retail Banking Section. Working on the Outbound Campaign Management project reporting to functional manager. The project which collects customer data for future marketing efforts. Primarily coding in Mainframe COBOL, JCL Oracle(PL/SQL), and SYNCSORT exit routines to transform the collected data for loading into relational tables.Bradigan s, INC
Kittanning, Pa
June 2014 to Present
Working on projects for the Petroleum Sales and Distribution, Retail Services using COBOL and MS Access Programming to remote petroleum distribution locations to accept credit like cards to purchase products. Created Billing software for the remote product purchases.Forecast customer product needs in advance, and scheduled delivery. Installed their first Hardware/Network system.
Third party development using PL/SQL Procedures/Packages for the Electronics Industry.Highmark Blue Cross/Blue Shield, Pittsburgh, PA June 1997 to March 2014Assigned to the ICIS (Integrated Customer Information System) project. The project encompasses the ETL conversion of multiple Customer Information legacy systems using my Mainframe Cobol skills, into a single integrated Client/Server backbone application, using Oracle8i-12g DB.
Acting as a Database Application Analyst within the ICIS Database/Technical Team my responsibilities include:
Create and maintain Oracle Stored Procedures, Packages, Triggers, Views, Constraints and Functions. Created PL/SQL Procedures during various Database upgrades. Worked with Front End Developers to support the application with Back End PL/SQL Procedures and Packages. Involvement with some of the most critical projects, responsible for the generation of Design Specifications, Package and Trigger implementation. Lead the development of a JSP/Servlet WEB based reporting system to replace Oracle Reports Server. Replicate data to create development, testing and training databases using scripts and relational tools. Create routines to report database problems and business rule violations within the database. Production support for 10 instances of 700+ tables.
Database modeling and design. Performance tuning. Generate reports using Oracle Reports and Forms.
Design and implement (ETL) mainframe data scrubbing and extraction processes. Importing of scrubbed data into the database. Pursuit of Oracle Database Certifications.
Certifications: Introduction to SQL/PLSQL Advanced PL/SQL Database software product evaluations.ServiStar/ Coast to Coast, Butler, PA February 1984 to June 1997 Systems Analyst/Team Lead, Mainframe Cobol Developer
Created and introduced the company s first Data Warehouse. Served as the lead of the Data Warehouse Task Force. Worked closely with corporate sponsors to define data elements, establish business rules, create the metadata repository, relational database design, data extraction, cleansing, replication and summarization processes, as well as decision support and replication tool evaluation. Directed implementation of requisite technical solutions.
Additional accomplishments and responsibilities: developed functional specifications for Inbound EDI processing; developed on-line systems using ADW CASE technology; designed application solutions using Microsoft Access, maintained and enhanced the company s financial and distribution systems.
Served on ServiStar Quality Council.PNC Bank, Pittsburgh, PA July 1997 to February 1989 Lead Analyst Mainframe Cobol/CICS Developer
Reported to the functional and applications managers of the Retail Banking and Corporate On-Line Systems areas. Responsibilities included: analysis, design, programming and testing in a CICS/VSAM environment, area programming and CICS technical consultant, new technology assessment. Also responsible for capacity planning, representation of the Corporate On-Line Systems to the end user community, served on the Development Center Advisory Committee and on the CICS Support Group.ALCOA, Pittsburgh, PA August 1989 to October 1992 Consultant and Mainframe Lead On-Line Analyst
Assigned to ALCOA to develop its global Cost Accounting System. Responsibilities included: Analysis, design, programming and testing in a Cobol, CICS and DL/I environment. Provided additional client support through CICS instruction to designated staff members.
Benedum Interests , Pittsburgh, PA October 1992 to August 1989 June 1995 to March 2014Lead Analyst Cobol/Datapoint DeveloperImplemented the first Computer system and Netoork for a prominent Pittsburgh family. Developed various software for their Oil and Gas interests monitoring well performance and revenue. Also created reporting software for their Wall Street investments and general accounting software.USX and USX Pension Fund, Pittsburgh, PA and New York City August 1989 to July 1995Software Developer CobolImplemented software solutions for the Steel and Oil industries for approximate 40% of my time.The remainder of my time was spent on theUSS Pension Fund and developingInvestment software and connecting to investment systems.Other Full Time and Consulting Engagements
National Steel Corp Pittsburgh and Shawmut Railroad Mid-Continent / Alltel Telephone Additional information per request.
EDUCATION Institute of Computer Management, Pittsburgh PA.A.S. Computer Programming Ashland University, Ashland OhioBusiness
|
