Name
Andy Chang
Home Address
***** ******** ****** **. *******, VA 20171
Home Phone
Cell Phone
Email Address
ac26l0@r.postjobfree.com
Summary (Describe type and number of years in a particular role or industry, unique characteristics, and area of expertise)
Senior System Programmer & IT Analyst with 20 years of Systems Analysis and Quality Assurance experience within the Airline, Financial, TELE COM Government industries.
Major strengths are in the areas of Requirement Analysis, Software testing and development in all phases of the project life cycle, development of system documentation.
Additional skills are in configuration management, and customer problem solving. Effectively communicates with all levels of management when delivering products or solutions to clients.
Management/Leadership Skills (if any)
Led a team of consultants to design and code Student Financial property applications at Sallie Mae, Inc.
Led team of consultants to resolve and implement historical inventory systems at AT&T, Inc.,
Implement and accomplish specific projects life cycle for management team assignment.
Methodologies Used (if any)
Information Engineering
Structured Development Methodologies
Strategic Information Planning
Project Tracking Techniques
Software Engineering
CM(Control-M)
Dimension
Agile (JIRA/Scrum)
Functional Skills
Systems Analysis
Quality Assurance
Testing
Technical Skills
Software, Tools, Languages
Databases
IBM mainframe software / tools : Strobe,Superwylbur,TSO/ISPF,Intertest,Expediter,BMS/GT,QMF,Platinum,LIBRANIAN,File Aid, CA-7, Endeavor, Pegasus, Lotus Note, Insync, Omegamon.
Languages:
SQL, Java script, HTML, COBOL, SAS, JCL, CICS/VSAM, PL/ SQL,
Pascal.
MS Office tools: Excel, Word, Power Point
Testing tools: Quality Center
Databases
IDMS, Data Com and DB2, Oracle, SQL
Hardware, Operating Systems
HW: HP 9000, IBM RS/6000 (P servers using AIX and UNIX), IBM AS/400, IBM System/390 Mainframes, and systems using Intel based IBM X series Blade servers.
OS: UNIX, HP/UX, AIX, Linux, Windows NT, Windows 2000, OS/390, and OS/400,
Education (Degree, Subject, Institution, Month/Year Attained)
BS in International Trade from Chung Yuan University, Taiwan, R.O,C. 06/1980
Master in Computer Science from Texas A&M University, Commerce, Texas, 12/1987.
Professional Development, /Training, Coursework (Subject, Institution, Month/Year Completed)
Oracle 7,PL/SQL,Forms 4.5 & Report 2.5 (Information Technology Advanced training center), 06/1997
SAS Programming and Report, Sprint training center, 08/2000
JAVA script and HTML, Sprint training center, 01/2001
DB2 Performance Tuning, Verizon training center, 03/2002
JAVA Programming Language, 08/2008
Oracle Developer SQL Language, 04/2011
Certifications (Subject, Institution, Month/Year Completed)
Task leader Process Analysis, Sprint training center, 09/1999
Problem Solving and Decision-Making, Sprint training center, 01/2000
Presentation Skill, Sprint training center, 07/2000
Task Leader Select Interview, Sprint training center, 01/2001
Citizenship
USA
Clearance (indicate if active or inactive)
CBP clearance (active)
Project History
Employed by
Date Range
Role
Project Name, Agency and Location (spell out acronyms)
Northrop Grumman
3/2015 - Present
Computer Specialist
Enterprise Reporting application in Treasury Enforcement Communications System (TECS), Customs and Border Protection (CBP), Springfield VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Responsible for the development of system documentation such as functional descriptions, maintenance manuals, tests and implementation plans, specification documents and/or data base feasibility studies.
Monitors and reports on the status and progress of work, checks on work in progress, and reviews completed work for compliance with supervisor's priorities, methods, deadlines/instructions, and audit requirements.
Participate in a full software engineering life cycle support for large-scale enterprise computer system.
Member of a mixed team of software engineers under the direction of a Scrum Master (Agile) or Project Manager in the design, development, and implementation of multiple applications on the mainframe / Oracle platforms.
Design, test, document, train, implement, and support user services
Conduct functional and/or integration testing of multiple programs in an IBM mainframe or Oracle/ JAVA environments
(Developing Test Cases/ Developing Test Scripts/ Reporting on Defects and Incident Reports)
Treasury Enforcement Communications System Modernization (Mar. 2015- Jun. 2017)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DATACOM, CICS, JCL, MQ, Batch, CA7 procedures and utilities.
Web based platform: DB Oracle, SQL Data Modeler,JAVA (User Interface)
Work on CBP Enterprise Reporting System. Develops analytical and methodology for
Legacy application software converted to TECS MODERIZATION (Oracle) development rules. Execute SQLunit test scripts and Software testing flows in ER testing team.
Work on data analytics examining raw data with the purpose of drawing conclusions about that information. Generate legacy mainframe or Oracle (SQL) statistics Data usages reports for management team review.
Work on legacy Pleasure Boat Systems (PBRS) business rules to implement TECS MODERIZATION HPPQ Manifest (High Performance Primary Query and Manifest Processing).
Work on legacy Private Air Enforcement Systems (PAES) business rules to implement TECS MODERIZATION HPPQ Manifest (High Performance Primary Query and Manifest Processing).
• Support legacy Port Tracking Systems (IOLN/IOFG) business rules for management team review.
Treasury Enforcement Communications System (Mar. 2015- Jun. 2017)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DATACOM, CICS, JCL, Batch and utilities.
• Problem resolved and technical support existing TECS Pleasure Boat (PBRS), Private Air Craft (PAES), PORT TRACKING applications. Provide technical and professional guidance to team members and clients.
Employed by
Date Range
Role
Project Name, Agency and Location (spell out acronyms)
Bart & Associates, Inc.
6/2005 – 3/2015
Computer Specialist
Pleasure Boat Applications System / APIS /ER in Treasury Enforcement Communications System (TECS), Customs and Border Protection (CBP), Springfield VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Respond to problem tickets, resolve issue, and create resolution documentation.
Serve as the primary technical expert within a mission critical application, acting as an internal consultant for all tasks in the analysis, design, testing and implementation of assignments.
Analyze, design, develop, document and test application programs and system components with varying complexities. Implements knowledge of the major peripheral systems that work in conjunction with assigned applications.
Provide estimates of work, assist with resource/time allocations, properly follow project life cycle, develop and document technical designs, support testing cycles and support software implementations.
Conduct functional and/or integration testing of multiple programs in an IBM mainframe or Oracle/ JAVA environments
(Developing Test Cases/ Developing Test Scripts/ Reporting on Defects and Incident Reports)
Treasury Enforcement Communications System Modernization (Jun. 2007- Mar. 2015)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DATACOM, CICS, JCL, MQ, Batch and utilities.
Web based platform: DB Oracle, SQL Data Modeler,JAVA (User Interface)
Work on CBP Enterprise Reporting System. Develops analytical and methodology for
Legacy application software converted to TECS MODERIZATION (Oracle) development rules. Execute unit test scripts and Software testing flows in ER testing team.
Work on (Advance Passenger Information System) MQ business rules to implement (High Performance Primary Query and Manifest Processing (HPPQ) for TECS MODERIZATION.
Analyze and download volumes of legacy DB (DATACOM) raw data files (Enterprise Statistics Reports Applications) into ORACLE / Informatics via SFTP (secure file transfer protocol).
Support TECS MODERIZATION standards for process criteria and responsibilities for the retirement or termination of (Electronic Data Interchange for Finance, Administration, Commerce, and Transport) TDED applications from TECS. Lead the technical planning, designing, coding and testing of the applications or system either retired or terminated. Provide leadership and technical guidance regarding programming/system related issues related to retirement or termination. Supports impact analysis and other retirement activities. Under the direction of the Retirement Project Manager, responsible for retirement planning and execution activities.
Treasury Enforcement Communications System (Jun.2005- Mar. 2015)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DATACOM, CICS, JCL, Batch and utilities.
Develop and design new application system for Pleasure Boat, Local Boater, Vessel Encounter and Cruise License Reporting projects. The system provides the technical information necessary to create or extract boater’s arrival data via Treasury Enforcement Communications Systems and the National Crime Information Center.
Problem resolved and technical support existing TECS Pleasure Boat, Private Air Craft (PAES), PORT TRACKING applications. Provide technical and professional guidance to team members and clients.
Employed by
Date Range
Role
Project Name, Agency and Location
Global Consultants, Inc.
3/2005 – 5/2005
Principal Database System Analyst
Expressing Billing in Verizon Corp., Arlington, Virginia
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Expressing Billing (Mar. 2005- May. 2005)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DB2, Expediter, BMS/GT, QMF, File Aid, CICS, JCL, VSAM, Batch and utilities.
Web based platform: GUI SMALL TALK front-end interface.
Wrote detailed test cases that were used for validating (front-end/backend) the application.
Responsible to all trainers who experienced in system problems or question for technical solutions under WEB-BASED Billing systems and DB2, CICS data implementation with GUI SMALL TALK front-end interface.
Worked with production service represent on occasion and provided guidance of technical skills.
Employed by
Date Range
Role
Project Name, Agency and Location
United Realty INC.,
6/2002 – 2/2005
Financial Service Consultant
Financial analyst, United Realty Inc., Vienna, VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Conducted financial analysis and recommended appropriate products to meet with clients needs.
Delivered informational sales presentation to clients. Provided real estate business contracts, closing and estate planning.
Prepared and filed legal contracts for real estate business.
Employed by
Date Range
Role
Project Name, Agency and Location
Verizon Corporation
3/2001 – 5/2002
Sr. Software Engineer
Performance improvement in Verizon Service Express Billing System, Arlington, VA.
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Expressing Billing (Mar. 01- May. 02)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DB2, Expediter, BMS/GT, QMF, File Aid, Pegasus, Insync, CICS, JCL, VSAM, Batch and utilities.
Web based platform: GUI SMALL TALK front-end interface.
Supported applications performance improvement for Service Express Billing systems. Worked with DBA team to standardize DB2 SQL codes changes or designs.
Managed and evaluated project phases of DB2 module changes.
Reduced the per capita IT operating system timing by 43% in one of tremendous Billing transactions.
Wrote detailed test cases that were used for validating (front-end/backend) the application.
Support DB2/ VSAM Billing statistic graphics charts of spread sheets to management team.
Maintained project timeline and resource allocation worksheets.
Employed by
Date Range
Role
Project Name, Agency and Location
Sprint Corporation.
4/1999 – 3/2001
Sr. Software Engineer
Sprint contract with Federal Government Phone Billing applications, Herndon, VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Federal Government Phone Billing FTS2000 system (Apr. 1999- Mar. 2001)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DB2, Expediter, BMS/GT, QMF, File Aid, Pegasus, CICS, JCL,VSAM, SAS, Batch and utilities.
Developed and implemented highly complex technical solutions for Federal Government Phone Billing applications.
Analyzed alternative approaches of system designs. Analyzed or considered systems interrelationships, or operating modules or system software or equipment configurations.
Monitored and Problem resoled onto Quality performance tracking system for FTS2000 Government Telecommunication control and inventory.
Provided technical and professional guidance to team members, consultants and clients.
Employed by
Date Range
Role
Project Name, Agency and Location
Litton/PRC Corporation.
4/1998 – 4/1999
Principal System Analyst
Contract with U.S. Post Service, Reston, VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
U.S. Postal Service Y2K Evaluation (Apr. 1998- Apr. 1999)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DB2, Micro Focus Cobol, QMF, JCL, VSAM, Batch and utilities.
Web based platforms: Visual Basic, DB Oracle/ SQL and FoxPro
Evaluated and analyzed Y2K DATE processes for U.S. Postal Service applications of COBOL, DB2, Visual Basic, Oracle and FoxPro.
Provided alternative solutions, recommendations and assistance to management team. Participated in Implementations, upgrades and conversion projects.
Employed by
Date Range
Role
Project Name, Agency and Location
Signal Corporation.
8/1997 – 4/1998
Sr. Programmer Analyst
Contract with U.S. Custom Inspector Overtime Scheduling Systems, Springfield, VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
U.S. Custom Inspector Overtime Scheduling Systems, (Aug. 1997- Apr. 1998)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DATACOM, CICS, JCL, VSAM, Batch and utilities.
Analyzed and maintained “Access Rules” changes for each level of supervisors on Inspector Overtime Scheduling Systems.
Implemented system test plans and volume of data verifications.
Analyzed systems functionality to specific programs requirements.
Employed by
Date Range
Role
Project Name, Agency and Location
Sunlight Technology INC.,
5/1997 – 8/1997
Sr. Programmer Analyst
Contract with AT&T Circuit Inventory Application, Dulles Corner, VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
AT&T Circuit Inventory Application (May. 1997- Aug. 1997)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DB2, Expediter, BMS/GT, QMF, File Aid, Pegasus, CICS, JCL, VSAM, Batch and utilities.
Performed Task leader to contract with AT&T Circuit Inventory Application Department. Proposed and implemented software solutions to maximize system productivity.
Planned and executed strategy to convert historical inventory files to standard DB2 Relational database systems. Managed work assignments within IT departments and accomplished project cycle.
Employed by
Date Range
Role
Project Name, Agency and Location
System Engineering Service Consultant Corp.,
1/1997 – 5/1997
Sr. Programmer Analyst
Contract with Sallie Mae Financial property project, Reston, VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Sallie Mae Financial property (Jan. 1997- May. 1997)
IBM mainframe software / tools: TSO/ISPF, Intertest, COBOL II, DB2, Expediter, BMS/GT, QMF, File Aid, SPUFI, CICS, JCL, VSAM, Batch and utilities.
Developed project specifications and participated to design application manual, financial systems. Developed new financial online systems for Florida State Government with contract of Sallie Mae Corporation.
Primary responsibilities were in strategic direction and business development. Recognized for successful completion of “Abandon student loan property” project ahead of schedule; coordinated with IT staff to install and configure applications to interface with clients and users systems.
Employed by
Date Range
Role
Project Name, Agency and Location
Airline Tariff Publishing Company
3/1990 – 1/1997
Sr. Programmer Analyst
Airline Tariff Publishing projects, Dulles, VA
Responsibilities and Accomplishments (bullet or narrative, provide as much detail)
Developed and maintained catalogue procedures and program libraries for airlines operation business systems.
Analyzed and technical led to design highly complex airlines business applications. Designed, coded and implemented full project life cycles.
Implemented multi-tasks of production problem solutions and user interfaces. Generated full project life cycle and implemented system test plans. Managed project phases and products migration configuration management.
International Fare Department (Oct. 95 – Jan. 97)
Analyzed, modified Passenger Fare system using DB2/SQL, CICS, COBOL II, MVS/ JCL Batch.
The system established new fares or adjusted existing ones through the use of complex algorithms.
Electronic Tariff/ Interline Pricing Department (Nov. 93 – Oct. 95)
Analyzed, designed, modified prorate and history fare system using IDMS/ DB batch, CICS/VSAM, COBOL II, MVS/JCL.
The system displays all current and future fare in a market oriented format or gives user online access to a history of fares. Worked with detailed project lifecycle, documentation procedures and standards.
Passenger Rules Department (Mar.90 – Oct. 93)
Analyzed, maintained, and developed a text history on-line system using IDMS/ADSO, COBOL II, and MVS/JCL.
The system had translation capability that translated the coded data back language (English phrases).
The translated text could be displayed online and also be sent to U.S. government and text subscriptions.