SOFTWARE/LANGUAGES :

• COBOL II, 
• SQL, 
• DB2 v11, 
• JCL, 
• SAS, 
• CICS, 
• VSAM, 
• TSO/ISPF, 
• MVS, 
• File - Aid for DB2, 
• SPUFI, 
• BMC DB2 Utilities, 
• Changeman, 
• Endeavor, 
• XPEDITER, 
• Platinum, 
• C++, 
• Visual C++

PROFESSIONAL EXPERIENCE :

Confidential, Phoenix, A Z

Lead Mainframe Developer

Responsibilities:

• Design new DB2 database architecture and COBOL / SQL programs to assess and collect 1099 - K Federal and State Income Tax Withholding from payments to merchants
• Design and engineer new high-volume DB2 database architecture and COBOL / SQL software to summarize and report merchant submission data for IRS Tax Reporting Form 1099-K
• Establish Partitioning Strategy and Clustered Index setup for multiple DB2 tables, write programs to load and retrieve data using multi-row SQL Insert and Fetch
• Achieved average CPU time of 35 seconds and cost of $12 for a COBOL / SQL program that performs 1.2 million Selects and Inserts 1.2 million DB2 rows each day
• Create an automated process to purge data, establish limit keys, and rotate partitions for five DB2 tables partitioned by dates
• Tune batch and online COBOL / SQL programs that query DB2 data, to maximize performance by leveraging partitioned secondary indexes and run-time parallelism
• Develop DB2 Conversion process for 8 months of 1099-K data - approximately 250 million rows totaling over $370 billion - at a total CPU cost of $900
• Develop two new file interfaces to transmit 1099-K Reporting and Withholding Merchant data to an external vendor
• Create and teach 2 new internal training classes on COBOL programming with SQL and DB2
• Manage development teams across multiple projects - write Solution Architecture documents and Technical Specifications, delegate tasks to onshore consultants, perform code reviews, oversee progress and quality of programming
• Supervise project estimates written by onshore consultants, recommend changes to lower development costs
• Responsible for design and delivery of mainframe (MVS, COBOL, DB2 v11, SQL, JCL) financial software solutions under an offshore model for the Global Merchant Services Technologies group

Confidential, Greenwood Village, CO

Senior Systems Analyst

• Develop new COBOL / SQL / CICS socket programs to receive data from customer tax payment website and update DB2 tables
• Write COBOL / SQL / CICS socket programs to receive data from website, read DB2 tables, and transmit payment records back to internet
• Write new COBOL / DB2 batch programs to read DB2 tables and generate financial reports; develop new JCL Procedures to execute them
• Analyze DB2 EXPLAIN results from embedded SQL and recommend new index to improve software efficiency
• Perform extensive unit testing of all software written, provide detailed documentation of all testing activities

Confidential, Round Rock, TX

Senior Systems Analyst

• Design new DB2 tables to implement database structure supporting borrower loan tracking process, create new COBOL / SQL software to load tables with conversion data and update data during ongoing event processing
• Develop new COBOL / SQL programs to monitor borrower locate processes, update DB2 database, and send data to an external vendor
• Design and write new COBOL / SQL software to automate exchange of borrower address information from external vendor and update internal DB2 database
• Tune embedded SQL statements to influence data access path and decrease runtime
• Develop new batch processes to selectively migrate parameter DB2 table data from test database to production, across multiple tables and scenarios
• Analyze and translate business requirements; prepare functional and technical design specifications; code and test programs on student loan software system using COBOL, DB2, SAS, JCL, VSAM and embedded SQL on the IBM MVS mainframe platform

Confidential, Cheyenne, WY

Programming Coordinator

• Serve as programmer Team Lead and point of contact between Information Systems, Customer Service, and Accounting to receive and initiate software project requests
• Assign and coordinate programming projects, manage expectations with users, assist other programmers with software design, oversee progress and report to Director of IS
• Assume Technical Lead role on projects, responsible for helping users develop business requirements and designing software to efficiently meet them
• Develop new database files and online programs to automate loan consolidation process
• Work with end users to develop business requirements; analyze requirements and write design documents and technical specifications; code, test, and document new student loan software components using COBOL, SQL, and DB2 on the IBM AS400 platform
• Assist in reengineering of testing procedures, work with Quality Assurance Director to leverage technical expertise and improve testing efficiency

Confidential, Aurora, CO

Senior Software Developer

• Develop and implement software solutions to meet business rules within the student loan servicing industry
• Determine software requirements and specifications; write analysis documents detailing system functionality in a clear, concise manner
• Provide high-level budget estimates to users for software development and maintenance projects; assess overall feasibility and cost effectiveness
• Assume leadership role on technical side of projects; create timelines and oversee progress through the entire software development lifecycle
• Serve as Technical Lead resource for team of developers; responsible for coaching junior developers, advising them on system changes, approving design documents and reviewing code
• Research performance problems in a production DB2 database, recommend strategies for SQL optimization and improvement of table design
• Serve as DB2 expert resource for a team of developers working across multiple projects; mentor associates on database concepts and use SQL to administer test databases
• Design and program a series of new CICS / COBOL / SQL screens to list, browse, update, and delete data from multiple DB2 tables
• Code, test, and support software changes on new both new development and maintenance projects, using COBOL, DB2, CICS, JCL, VSAM and SQL on the IBM MVS mainframe platform

Confidential, San Francisco, CA

Senior Systems Analyst

• Support application software system employed in the tracking and billing of freight shipments
• Analyze enhancement requests from customer service managers and write technical specifications
• Code and test software changes, including unit and system testing, on IBM MVS platform

Confidential, Newport Beach, CA & Lincolnshire, IL

Programmer/Analyst

• Provide support for application software systems used to administer employee 401(k) Defined Contribution benefit plans
• Design specifications for software customizations, batch and on-line components
• Code, test, and document system changes on IBM MVS platform using COBOL, VSAM and JCL
• Write mainframe SAS / DB2 jobs for data analysis, reporting, and conversion tasks
• Serve as Team Lead for a small group of developers, allocate resources for project work and oversee progress and quality