Uploaded File
add photo
Sang
sang56732@hotmail.com
910-758-1345
1113 Patrick Drive
Fayetteville, NC 28314
Sr. Systems Analyst
31 years experience W2
0
Recommendations
Average rating
19
Profile views
Summary

Experience
Dec 2011 - present
A seasoned mainframe professional with over 20 years of experience in Systems Analysis/Programming/QA. C Changeman CICS CMM COBOL COBOL II / LE Connect: Direct DB2 EasyTrieve Endeavor File-Aid File-Aid for DB2 HTML IMS Intertest JAVA JavaScript JCL Librarian Linux LoadRunner MQ Series MS Office MVS Panvalet QMF REXX ROSCOE SPUFI SQL
CICS CHANGEMAN Cobol DB2 HTML IBM Websphere MQ JCL JavaScript Java Linux
Remove Skill
Sr. Systems Analyst - Contractor
Information Technology
Mar 2009 - Dec 2011
Project Lead/Business Analyst/Systems Analyst for the Bell Canada Customer Billing Services System (CBSS) development team. Interfaced with end-users to gather and develop business requirements for various billing system enhancements. Technical lead for a 5 member development and support team, responsible for providing application training for team members, requirements gathering, analysis, design, project management duties, and as liaison between the Verizon development support team and Bell management, users, and technical personnel. Analyzed and developed testing requirements and metrics, test scenarios, and detailed test cases for unit and system testing using SDLC development/testing methodologies. Performed 24x7 production system support as the primary contact for issues. This project is a profit-center for Verizon through maintenance contracts and enhancement projects for CBSS Bell Canada. SKILLS: SDLC, COBOL II, JCL, DB2, C, File-Aid/DB2, File-Aid, CICS, QMF, REXX, SQL, VSAM, XPEDITER, Endevor CM on a z/OS - TSO mainframe platform.
Business Analysis Project Management Requirements Gathering SDLC SQL System Analysis CICS Cobol DB2 ENDEVOR Database Maintenance Billing
Remove Skill
Business Analyst - Contractor
Nov 2008 - Jan 2009
Business analyst team member responsible for development, execution, and validation of system test cases and scripts for implementation of major enhancements to the existing offender administration system (OPII). SKILLS: SQL for iSeries on OS/400, and CICS for OS/400.
Business Analysis SQL CICS OS/400
Remove Skill
Software Developer - Contractor
Information Technology
Aug 2008 - Nov 2008
Member of a team of developers responsible for the timely design, development, and implementation of enhancements to the Hunting and Fishing POS/Mainframe system applications for a new client. SKILLS: COBOL II, JCL, DB2, CICS, SmartTest, and SQL on a MVS/TSO platform running Z/OS.
DB2 SQL Cobol CICS JCL
Remove Skill
Senior Programmer - Contractor
Information Technology
Nov 2007 - Jun 2008
Performed an integral role in the design and development of enhancements to meet regulatory National Provider Identification (NPI) requirements leading to a timely and successful implementation for Missouri Medicaid Management Information System. Performed as the sole analyst in gathering requirements with the users and development tasks for meeting state needs to Category and Category Status Code changes in the online and X 12 - 276/277 EDI claim transaction records. SKILLS: COBOL II, JCL, DB2, CICS, Endevor, Xpediter, File-Aid, File-Aid DB2, and SQL on a MVS/TSO platform running Z/OS.
CICS Cobol DB2 File-Aid JCL SQL XPEDITOR EDI
Remove Skill
Senior Programmer
Information Technology
Apr 2006 - Mar 2007
Solely responsible for requirements gathering and developing enhancements to the Subrogation mainframe interface as part of a strategic company initiative to replace a legacy claims system to a client/server claims platform. The Subrogation system generates approximately $20 million in annual revenues and consists of batch COBOL II applications and IMS onlines accessing IMS and DB2 databases. Accountable for application development, maintenance, production support, and user training. SKILLS: COBOL II, JCL, DB2, IMS, CICS, Changeman, File-Aid for IMS, Princeton Softech's Relational Tools, and SQL on a MVS/TSO platform running Z/OS.
CHANGEMAN CICS Cobol DB2 File-Aid IMS JCL SQL Requirements Gathering Application Development
Remove Skill
Business Analyst - Contract
Information Technology
Oct 2004 - Apr 2005
Responsible for the analysis of business needs for translation into business requirements for system development. Participated in the development of new customer information and billing systems to handle expansion of broadband products and services linked to mainframe legacy applications. SKILLS: COBOL II, JCL, DB2, and SQL on a MVS/TSO platform running OS/390.
Business Analysis SQL Billing Cobol DB2 JCL
Remove Skill
Systems Analyst - Contract
Information Technology
Nov 2002 - Jun 2003
Applied SDLC methodology to enhance batch/online claims and payment systems to meet HIPAA regulatory requirements. Maintained CICS/DB2 Cobol programs for support of on-going business and meeting HIPAA regulations. System areas include Cross, Shield, Major Medical, and Comprehensive insurance processing, including Medicare/Medicaid. SKILLS: SDLC, CICS, COBOL II, JCL, File-AID, File-AID/DB2, DB2, VSAM, REXX, and SQL on a MVS/TSO platform running Z/OS.
HIPAA SDLC SQL System Analysis DB2 Cobol CICS JCL VSAM
Remove Skill
Systems Analyst
Information Technology
Jun 2002 - Sep 2002
Utilized standard analysis and design methodology for enhancing CICS/COBOL/DB2 online and batch-based payment and financial systems pertaining to DHS public assistance programs. SKILLS: SDLC, CICS, COBOL II, JCL, File-AID, File-AID/DB2, DB2, InterTest, REXX, SQL, and QMF on a MVS/TSO platform, OS/390.
SDLC SQL System Analysis CICS Cobol DB2 JCL
Remove Skill
Systems Analyst/Software Developer - Contract
Information Technology
Apr 2000 - Oct 2001
(BellSouth Account) Systems Analyst/Software Developer - Contract Designed and developed the Adverse Action Notification Database (AAND) application to comply with specific guidelines of the Fair Credit Reporting and Equal Credit Opportunity. AAND is a real-time IMS transaction using embedded DB2 SQL code with a daily batch component, gateway between the on-line customer negotiation systems (SOCS and RNS) and the end-user billing system for handling customer acceptance of BellSouth terms and conditions for telecom services. Designed and developed a MS Access VBA GUI application to query AAND tables used for data analysis via DB2 Connect. SKILLS: SDLC, COBOL II, JCL, DB2, DB2 Connect, IMS, File-Aid/DB2, File-Aid, MQ Series, REXX, and Panvalet, Teradata, Connect: Direct, on a MVS/TS. PC development platform included Windows 2000, MS Access, Queryman (data access GUI tool), and Visual Basic for Applications.
Data Analysis DB2 IBM Websphere MQ SDLC SQL System Analysis Teradata Visual Basic Windows Cobol DB2 Connect Billing JCL VBA
Remove Skill
Programmer Analyst
Information Technology
Nov 1999 - Mar 2000
Designed and coded an asset portfolio risk analysis reporting application for small business and medium sized corporate loans. SKILLS: SDLC, EasyTrieve (EZTrieve) Plus, COBOL II, JCL, File-AID, File-AID/DB2, DB2, REXX, SQL, and QMF on a MVS/TSO platform, and OS/390.
Cobol DB2 File-Aid JCL SQL SDLC
Remove Skill
Systems Analyst/String Test Team Lead-QA Analyst - Contractor
Information Technology
Mar 1997 - Aug 1999
Analyzed and designed system enhancements for the Customer Record Information System (CRIS) - Guide Access DataBase (GADB). GADB is the customer information gateway between the front-end service order applications and toll/usage rating, and billing. Performed production system support responsibilities. Managed a twelve member integrated CRIS string test team as part of BST's CMM process. SKILLS: SDLC, COBOL II, JCL, File-AID, File-AID/DB2, DB2, REXX, SQL, and QMF on a MVS/TSO platform, and OS/390.
SDLC SQL System Analysis Cobol Billing DB2 JCL
Remove Skill
Programmer Analyst
Information Technology
May 1996 - Feb 1997
Designed sales databases for tracking customer and agent information with CICS and DB2 for customer services. System components included Sybase databases residing on a Unix server with synchronization triggers to DB2 databases on a mainframe. It also consisted of a policy quoting application that combined a CICS mainframe application with a PC-based interface composed of COBOL and a WordPerfect macro engine. SKILLS: SDLC, COBOL II, JCL, DB2, CICS, QMF, SQL, EasyTrieve, and Librarian on MVS/TSO and ROSCOE platforms, OS/390, and Unix.
CICS Cobol DB2 JCL SQL Triggers OS/390 SDLC
Remove Skill
Systems Analyst - Commercial Services
Information Technology
Jun 1990 - May 1996
Functioned as a key member of the Billing sub-application development team, responsible for the analysis, design, and implementation of business requirements to support the commercialization of the Customer Billing Services System. Provided production level support during CBSS system testing. Worked as part of a team of users, architects, business analysts and other technicians in requirements gathering and analysis/design. Performed production system support responsibilities. Project Leader of CRB (Customer Record Billing) responsible for establishing testing procedures, training, administration and eight test environments for the conversion of Contel Telephone Company's data to GTE billing format.
Business Analysis Project Management Requirements Gathering System Analysis
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
OTHER EXPERIENCE
UNIVERSITY OF SOUTH FLORIDA 1995
SYRACUSE UNIVERSITY 1989
Sun Educational Services: Java Technology for Structured Programmers
United Information Technologies
Visual Basic programming, and Yourdan Object Oriented methodology
HP Learning Center
Certifications
Certified Professional Tester
Skills
Cobol
2021
19
DB2
2021
19
JCL
2021
17
CICS
2021
15
System Analysis
2011
13
SQL
2011
11
IBM Websphere MQ
2021
10
Business Analysis
2011
9
CHANGEMAN
2021
9
Requirements Gathering
2011
9
HTML
2021
8
Java
2021
8
JavaScript
2021
8
Linux
2021
8
Project Management
2011
8
SDLC
2011
8
Billing
2011
7
Database Maintenance
2011
2
ENDEVOR
2011
2
Data Analysis
2001
1
DB2 Connect
2001
1
File-Aid
2008
1
Teradata
2001
1
VBA
2001
1
Visual Basic
2001
1
Windows
2001
1
Application Development
2007
1
EDI
2008
1
HIPAA
2003
1
IMS
2007
1
OS/390
1997
1
OS/400
2009
1
Triggers
1997
1
VSAM
2003
1
XPEDITOR
2008
1