Systems Analyst /pl/sql Developer Resume
Oakland, CA
SUMMARY:
- Sr. Programmer Analyst with over 40+ years of IT system development experience in mainframe applications.
- Diverse background includes system design in Retail, Finance, Banking, Health insurance, Manufacturing, Utilities, and Health industries. (38 years Cobol/Cobol - II/JCL, 37 years CICS, 22 years DATACOM, 35 years VSAM, 4 years IMS,
- 5 years SQL, 5 years Oracle/PLSQL, 2 years DB2 SPUFI…etc.) Key strengths include strong analytical and interpersonal skills combined with the technical creativity to design quality systems. Excellent problem solver with result-oriented track record.
- Proven leadership.
TECHNICAL SUMMARY:
- CICS/ESA Command Level, Cobol, COBOL II, BMS, FTP, Crystal Reports, RPGII, CA-DATAQUERY, MQ, OS/MVS JCL, DOS JCL. IBM Utilities, SYNCSORT, S/36 OCL, Interactive Cobol, VSAM, DATACOM/DB, ORACLE, IMS/DB, HTML DB2/SQL, store procedures, TSO/ISPF, Change Man, CA-IDEAL, Java Swing, CHPS, FILEAID, EYEWITNESS, CMS,
- INTERTEST, EXPEDIATER, CA-7, DBUG-AID, ADR/ROSCOE, PANVALET, TRMS, ENDEVOR, LIBRARIAN, TPX
- Info Man, OPTIMIZER, IBM Z/OS, OS/390, ES/9021-982, 3090-600s, 9021-720, 3081, 3083…etc. Windows 10, 7, XP.
PROFESSIONAL EXPERIENCE:
Confidential, Oakland, CA
Systems Analyst /PL/SQL Developer
Responsibilities:
- Worked with the development and support of Legacy Health and Welfare, Pension, Annuity and Vacation pay, utilizing COBOL, CICS, VSAM, Oracle SQL and PL/SQL store procedures.
- Developed health care 834 eligibility enrollments.
- Developed and Implemented Participant eligibility, Work History, and Pension, under HIPAA Compliance standards.
- Key Developer in the conversion of all Legacy systems to Oracle based systems.
- Define system requirements and develop program specifications.
Confidential, Keene, NH
Sr. Programmer Analyst
Responsibilities:
- Worked with development of the Procurement Merchandise chain supply and Reclamation and replenishment system utilizing Cobol-II, CICS, DATACOM, VSAM, SQL, JCL, Inter-Test…etc. Including Time Projections, Order recommendations,
- Order Processing, EDW extract, and Inventory reduction based on recommended vs. purchase differentiations, overlapping promos and daily chain inventory reductions.
Confidential, Concord, CA
Consultant Application Programming Engineer
Responsibilities:
- Developed and implemented on-line credit scoring process for Consumer Lending Application Processing, Credit loan
- Applications and loan Origination systems, utilizing COBOL-II, CICS, VSAM, JCL, LU6.2 and MQ connectivity to Credit Bureaus (TRW, TRU, EFX) for consumer credit scoring.
- Using 6 sigma SSP CMM Level 2 maturity model Methodology.
- Captured credit reports and score them on the BureauLink3.2 summary to determine delinquency level and overall score credit rating. Worked with National-Heloc, NW CA scorecard, implementation projects.
- Integrated BureauLink3.2 functionality into Credit Application Processing System (CAPS) increasing effectiveness, productivity, and control of credit operations by providing instant information.
- Developed, Implemented the USA Patriot Act project in CAP and INS systems.
- Received Confidential Spirit Higher Standard Award for implementing the project very smoothly, giving an example of teamwork and doing the right thing.
Confidential, San Francisco, CA
Senior Staff Engineer
Responsibilities:
- Responsible for designing, developing, implementing and supporting the Confidential Trading System, utilizing Cobol-II, CICS, Datacom, JCL and IBM Utilities and DB2 APIs, FILEAID, EXPEDITER.
- Developed and implemented the Multi-POR system to be connected and process inbound messages in multiple POR-CICS regions for the Confidential Trading system. The connectivity to CICS is utilized using DPL and MQ resulting in:
- Improved system availability, throughput, and performance at market open by 85%
- Saved $9,000,000 per month by providing 93% system availability.
- Maintain current operating cost while increases volume 45%.
- Received two recognition awards of excellence.
- Converted the PCRA accounts system from Datacom to DB2 to improve accessibility and eliminate redundancy.
- Worked in all phases of system development life cycle from the analysis of system requirements phase to production installation and support. Also, I contacted technical interviews.
Confidential, Duluth, GA
Programmer Analyst
Responsibilities:
- Responsible for the overall development, design and coding of the FSG INFOREM replenishment system, utilizing CICS COBOL-II, DATACOM, VSAM, SQL, JCL and IBM Utilities, Inter-Test, FILEAID. Forecasted future needs of stocks by Considering seasonal sales patterns.
- Developed and implemented the following Merchandising systems:
- Profiling System
- Deseasonalized Demand
- Simulator system
- Replenishment system
- Promotional Ordering
- INFOREM System Exceptions
- Online Query reporting
- New store Processing
- Worked in all phases of the system development life cycle, including extensive interface with users to identify business requirements.
- System provided review of item performance over the past 13 weeks. SKU/locations with negative sales and determine stock requirements based on demand, lead-time and order frequency.
- Converted system to meet Confidential compliance requirements for 403 stores with 100% system availability.
- Ensure 403 Federated Department stores received accurate merchandise based on seasonal forecasted needs and current sales trends.
Confidential, San Francisco, CA
Senior Programmer Analyst
Responsibilities:
- Responsible for On-line system development and implementing Online and Batch Retail application systems addressing a range of retail business applications, utilizing COBOL CICS, DATACOM, IDEAL, VSAM, JCL IBM Utilities, Inter-Test and DB2/SQL. Participated in all phases of system development life cycle, from project definition stage through the implementation of the project. Duties include design, writing program specifications, development, unit-test, documentation, installation of the project and extensive interface with users.
- Developed and implemented the Merchandise Order processing and Replenishment systems.
- Designed systems to provide real-time data for Stock and Sales by Season, SKUs with zero sales and accurately forecasted merchandise for selling season maximizing sales and reducing stock shortage.
Confidential, Sand Ramon, CA
Programmer Analyst (Sr. Programmer Analyst)
Responsibilities:
- Responsible for Online Retail System development and design using COBOL, CICS, IMS/DB VSAM, S/36 On-line Interactive COBOL, JCL IBM utilities and Inter-Test.
- Designed, developed and implemented Big Ticket Stock Reservation system coordinating all merchandise request to ensure stock availability, accurate order delivery and customer satisfaction.
- Designed, developed and implemented the Inter-store Transfer and Pricing systems increasing ease of merchandise movement and stock rotation.
- Designed, developed and implemented the Purchase Order Entry and Purchase Order Processing systems to provide automated merchandise ordering, shipping and inventory item control management.
Confidential, San Francisco, CA
Senior Programmer Analyst
Responsibilities:
- Responsible for On-line systems development using COBOL, CICS, DLI/DB, VSAM, JCL and IBM utilities.
- Designed, developed and implemented Order Item on-line system to provide on-line item query capabilities.
Confidential, San Francisco, CA
Lead Programmer Analyst
Responsibilities:
- Responsible for the development and implementation of on-line Plant Payroll, Cost Accounting and other financial systems.
- Specifically responsible for assisting tanning and supervising programmers on On-line CICS advance concepts, and structure COBOL programming utilizing VSAM, IMS, JCL, IBM Utilities and On-line dump solving.
- Minimized clerical work and time associated with paying employees by 80%.
- Minimize the delay in updating and accessing employee records from different plant locations, and the exposure to fraud.