Information Technology Project Manager
Resume:
PERSONAL INFORMATION
Name: Wayne Chang
Address: **** ********** ** ********* ** 20853
Phone: 240-***-****
eMail: *******@*****.***
EDUCATION
Colleges Attended/Degree:
• University of West Florida Pensacola FL Master of Science (MS) Systems Analysis
• San Jose State University San Jose CA Computer Engineering Postgraduate
• Soochow University Taipei Taiwan Bachelor of Arts (BA) Music SKILLS SET
IBM: z/OS, TSO, ISPF, QMF/SPUFI, CICS, DB2, VSAM, QSAM, eJES, ChangeMan, AbendAid, IDCAMS, FTP, AFP
BMC: Control-M, XPEDITER, File-Aid, File-AID/DB2, File-AID/RDX Broadcom: Unicenter, Endevor, DataCom, IDEAL, DYL280, CA7, Easytrieve SoftBase: TestBase for DB2
SAS Institute: SAS
MacKinney Systems: CFA
Precisely: SYNCSORT
Proginet: CyberFusion
Programming Languages: COBOL, SQL, Stored Procedures, JCL, REXX, HTML, JSON, MQ, Python, Assembler, SDF/CICS, Pascal, PL/1
MicroSoft: Windows 11, Office 365, BizTalk
PRESENT POSITION
Company Position: Social Security Administration Information Technology Specialist Dates: August 2022 to Present
Skills Used: z/OS, TSO, ISPF, CICS, DB2, VSAM, QSAM, eJES, AbendAid, IDCAMS, Control-M, XPEDITER, File-Aid, File-AID/DB2, File-AID/RDX, Unicenter, Endevor, TestBase, CFA, SYNCSORT, COBOL, SQL, JCL, REXX, JSON, FTP, CyberFusion, Windows 11, Office 365
Duties:
Used System Development Life Cycle (SDLC) and Agile Methodology. Maintained and developed the Social Security Administration’s Representative Payment System (RPS) and Representative Payment Accounting (RPA) systems.
Developed project plan, business/functional requirements, technical requirement, programing specifications and test scripts. Coded the COBOL programs from the programing specifications Page 2 of 6
with structure and efficiency. Coded the COBOL programs that update DB2 tables, VSAM files, and QSAM files. Integrated the newly available API calls into the current production run programs. Designed and built JCL procedures and run decks. Conducted end-to-end testing in the development, validation, integration, and user training regions. Used Xpeditor and FileAid tools for quality assurance. Served as a technical lead, worked with the project manager, and delegated tasks with the team members for project completion. Worked with the data analysts, provided the test files and the FileAid tool layout files for their analysis and testing. Present the technical details to the team members and helps them for task completion. Implemented the DB2 database schema upgrades including adding columns, constraints, alias, and triggers. Maintained DB2 objects and code tables. Loaded and unloaded the DB2 databases by using the DB2 utilities and the FileAid RDX (Relate Data Expert) components. Used Endevor tool for maintaining COBOL, copybook, JCL, REXX, SYSIN, parameter, procedure and job run deck. Coded Endevor SCM members for generating objects including COBOL source file, object, executable program, and DB2 plan and package. Designed and constructed Control-M database and tables. Monitored daily production job runs on Control-M for COBOL and JAVA jobs. Reviewed job run issues by using the DB2 SQL return codes, XPEDITER, and ABENDAid for determining the corrective actions. Provided instructions to the production control staff.
Integrated the MacKinney’s CFA tool in the batch run decks for sharing the uses of the VSAM files with the CICS. Participated in the agency’s annual disaster recovery test and the Title II Basic Rate Increase (BRI) test.
PRECEDING POSITION 1
Company Position: Leidos Database Engineer
Dates: June 2012 to August 2022
Skills Used: z/OS, TSO, ISPF, CICS, DB2, VSAM, QSAM, eJES, AbendAid, IDCAMS, Control-M, XPEDITER, File-Aid, File-AID/DB2, File-AID/RDX, Unicenter, Endevor, TestBase, SYNCSORT, COBOL, JCL, REXX, JSON, CyberFusion, Windows 10, Excel Duties:
Used the System Development Life Cycle (SDLC), Agile, and DevOps methodology. Designed and built File-AID/RDX extract/transform/load (ETL) components for the Social Security Administration’s EDCS, CPMS, SSR, MSSICS and eIAR DB2 validation data storage systems under the Enterprise Testing Data Management Systems (ETDMS). Anticipated the database schema changes and composed project plans. Assigned resources to the project tasks. Executed the tasks in the project plan for the successful completion of the project. Configured, integrated, tested and deployed software components in the production region. Used Control-M software to monitor the daily production job runs and resolved the job run issues. Designed and developed REXX script for scanning the more than 1,000 production job files to identify and correct the JCL errors. Designed and coded REXX script for encoding and decoding the JASON (JavaScript Object Notation) and MQ (Message Queue) files for data exchanges. Page 3 of 6
Worked with the stakeholders to automate the manual operations that resulted in great organizational improvements. Designed and developed complex REXX scripts that read PDS, VSAM, QSAM, and DB2 tables. Used SAS to collect COBOL programs’ bind date for assembling the JCL jobs correctly and dynamically. Embed artificial intelligence in the REXX script--this replaced the human intervention from the daily manual operations and allowed the machine to execute the jobs effortlessly and correctly non-stop. Provided out-of-the-box thinking in providing the data on the Enterprise Test Data Management Systems (ETDMS). Used Endevor tool for maintaining the COBOL programs, copybook members, JCL procedures, REXX scripts, SYSIN members, parameter members, and job run deck members. Interacted with Compuware (now BMC) software vendor for providing the work-arounds of their software.
PRECEDING POSITION 2
Company Position: Advanced Performance Materials (APM) ETL Subject Matter Expert Dates: November 2011 to March 2012
Skills Used: MVS, TSO, ISPF, JCL, Windows 7, IDEAL, DataCom, DataQuery, FTP, Excel Duties:
Designed and developed extract/transform/load (ETL) software to transform the ERP data from the legacy ERP system to a new global ERP platform. Analyzed the existing ERP data storage and documented the system architects. Performed extraction of the production data and transported the extracted data in the desired format. Established Intranet sites and staged the transformed data there. Used Excel software tool to transform the extract files suitable for loading. Uses Excel to examine and analyze the transformed data before loading. Produced multiple levels of the load files to match the target ERP system. Transformed the existing mainframe based legacy ERP data to a global ERP platform successfully.
PRECEDING POSITION 3
Company Position: National Rural Electric Coop Association (NRECA) ETL Specialist Dates: May 2008 through August 2009
Skills Used: MVS, TSO, ISPF, JCL, Windows 7, IDEAL, DataCom, DataQuery, FTP, BizTalk Duties:
Used the Systems Development Life Cycle (SDLC) and Agile Methodology. Performed the system analysis, software design, development, implementation and execution. Reviewed and consolidated the system architects of the Automatic Check Clearing (ACH/TSYS) system that transfers 2 to 8 million dollars daily from the individual banks to the State Street Bank in Boston. Used Microsoft BizTalk Server for the contribution records processing -- the transaction record included 401-K contributions, pension contributions, and IRA contributions. The transaction records are consolidated and transmitted to the State Street Bank (SSB) in Page 4 of 6
Boston via the Microsoft BizTalk server. Built the new procedures and jobs to transport the ACH/TSYS transaction records on the BizTalk server. Maintained Benefit Administration System (BAS) -- a complex employee benefit management system that handles 60,000 association members. Corrected data-integrity problems in the BAS database by identifying the missing records, duplicate records, and inaccurate records. Maintained Data Warehouse Tables. Produced error-correction update files from the transactional database tables. Finetuned the production jobs to optimize the performance. Maintained the existing COBOL programs, JCL procedures and run decks. Solved the COBOL and IDEAL program run time errors and corrected the programs’ errors. Developed the new IDEAL reports. Built BAS annual insurance plans, determined retirement payoff amounts, defined organizations, and provided the insurance/benefit plans. Developed procedures for NRECA's benefit enrollment processing. Developed the new COBOL programs, procedures and jobs to complete NRECA’s annual benefit enrollment processing. Documented the BAS system and processes. PRECEDING POSITION 4
Company Position: Federal Deposit Insurance Corporation (FDIC) Senior Programmer Analyst Dates: December 1992 to December 2005
Skills Used: MVS, TSO, ISPF, CICS, DB2, IDEAL, DataCom, DataQuery, Easytrieve, VSAM, QSAM, AbendAid, IDCAMS, Control-M, Endevor, SYNCSORT, COBOL, JCL, REXX, Windows 7
Duties:
Served as a project lead at the Federal Deposit Insurance Corporation (FDIC). Developed and organized project plans. Assigned resources of the project tasks. Executed the project for successful completion. Supported the FDIC Call Report System for 32 quarters (8 years) consecutively.
Anticipated and identified the US banking industry's quarterly report processes—the Call system. Create and build business solutions to collect US banking industry government quarterly report data. Maintain data-editing software for the collected bank data. Find alternative solutions that have resulted in organizational improvements. Develop new and maintain existing REXX script and integrate with existing CLIST in Mainframe TSO. Extract, transform, load, and maintain FDIC Call Report’s 20-years’ metadata.
Under the z/OS platform, develop and maintain COBOL programs, Meta COBOL programs, COBOL SQL/DB2 programs, CA-IDEAL programs, and EazyTrieve reports. Develop and maintain JCL job members. Maintain Data Warehouse tables. Produce update files from the transactional database tables. Code statistical reports using SAS software tool. Design and maintain computer programs to process unstructured transaction data and convert it into formatted and organized information for subsequent processing. Provide technical expertise analyzing customer requirements. Transform requirements to technical and program specifications.
Handle the Call System’s Trillion Number Table Expansion Project. Identify the banking Page 5 of 6
industry enlarging reporting numbers. Provide technical solutions by using the COBOL compiler options. Successfully completed the project and briefed the executive management. PRECEDING POSITION 5
Company Position: Federal Energy Regulatory Commission (FERC), Programmer Analyst Dates: October 1991 to December 1992
Skills Used: MVS, TSO, ISPF, CICS, IDEAL, DataCom, DataQuery, AFP, VSAM, AbendAid, IDCAMS, SORT, COBOL, JCL, ChangeMan, Windows
Duties:
Redeveloped the Hydropower Annual Charges System (HACS) and received letters of appreciation from the FERC.
Studied the system and automated the land billing cycle production, allowed the bills to be issued ahead of schedules. Redesigned the system architects, implemented the system with COBOL, JCL, DataCom, IDEAL, and Advanced Function Printing (AFP) for the bills. PRECEDING POSITION 6
Company Position: Federal Deposit Insurance Corporation (FDIC) Programmer Analyst Dates: October 1987 to December 1991
Skills Used: MVS, TSO, ISPF, CICS, IDEAL, DataCom, DataQuery, Easytrieve, VSAM, SAM, AbendAid, IDCAMS, SORT, COBOL, JCL, Windows
Duties:
Adapted Method/1 SDLC methodology for completing the Failing Bank Assist Transactions
(FBAT) system, the Banking Information Tracking (BITS) system, and the Growth Monitoring System (GMS). Received appreciation letters from the FDIC. Coded and tested the COBOL and IDEAL programs from the programming specifications for completing the FBAT system.
Participated in the BITS system. Wrote the COBOL, IDEAL, and SAS report programs. Used analytical skills, provided the system architects, requirement and technical documentation. Converted the DYL280 processes to the COBOL applications. Developed and tested the new COBOL programs, SAS reports, and EazyTrieve reports. Completed the GMS successfully with minimum maintenance.
PRECEDING POSITION 7
Company Position: Aeronautical Radio Inc (now Collins Aerospace) Software Engineer Dates: October 1984 to October 1987
Skills Used: Pascal Application Language (PAL), COBOL, SCOBOL Duties:
Performed task lead duties for designing and coding of the real-time programs by using PAL
(Pascal Application Language) on the Perkin-Elmer computer, and COBOL and SCOBLE Page 6 of 6
programs on the Tandem computers.
Provided system architect designs. Used structured analysis methodology and relational data modeling for implementing the SPEC 2000 Procurement database. Provided production support for the CARD (an Airlines credit card authorization system), UATP
(the Airline industry credit card), and AIRS (an Airline industry parts re-distribution system) real-time transaction processing systems.
PRECEDING POSITION 8
Company Position: Morisons Inc Staff Programmer
Dates: October 1983 to October 1984
Skills Used: VSE, CICS, IDEAL, DataCom, DataQuery, Easytrieve, VSAM, SAM, AbendAid, IDCAMS, SORT, COBOL, JCL
Duties:
Developed CICS COBOL programs. Built new CICS screens using SDF/CICS. Developed the online and batch systems using COBOL and IDEAL. Created the JCL job members. Built the batch reports by using the EazyTrieve tool. Provided production support for the online and batch systems.
Contact this candidate