TECHNICAL SKILLS:

Platforms: S/38, S/36, AS/400, iSeries, IBM me, S/370, S/390, z/OS, PC, SAP R/3 (MM/IM, WM, RF)

Languages: COBOL/COBOL ILE, RPG/RPG ILE, DDS, CL/CL ILE, DB2/SQL, DDL, CICS, IMS, JCL, OCL, BAL (mainframe), Visual Basic, HTML, XML, PHP, MySQL

Software, Misc.: RxClaim Pharmacy system, PowerMHS Healthcare system, Aldon, TurnOver and Implementor change management systems, McCracken Strategy Mortgage system, Query/400, SEU, SDA, RLU, IBMi navigator, SEQUEL, Rational Developer for IBMi (RDi), MQ Series/Websphere MQ, GoAnywhere MFT (Managed File Transfer), AAMVA Net, X12, NCPDP, ROBOT scheduler, ISPF, NuBridges, MS Office (Word, Excel, Access, PowerPoint, Visio).

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, Texas

RxClaim production support/iSeries/AS400 Specialist

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, RPG, CL, DDS/DDL, SEQUEL. i5/OS v7r3.
• Production support/incident handling.
• Data extraction and ad hoc reporting. SEQUEL queries for user requests.
• ROBOT scheduler usage.
• Hawkeye analysis.
• Code bug analysis.
• On - call support services for production systems.

Confidential, Sterling, Illinois

Senior IBM me/iSeries/AS400 DB2/Programmer/Analyst (contractor)

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, CL, DB2/SQL, DDS/DDL, SEQUEL. i5/OS v7r3.
• Main project scope; convert GL system to PeopleSoft format.
• Converted over 550 programs, queries and files. dis included adding embedded SQL into existing programs, converting displays to a higher resolution and existing code to ILE.
• Produced new tools and methodologies for subprograms. Programs used embedded SQL for accessing DB2 database files. QM SQL queries were created for reporting and other intermediate processing of teh DB2 database.
• IBM advanced scheduler.
• MKS Implementer CMS.
• Used iNavigator SQL tools for DB2 file research and analysis.
• Designed SEQUEL queries for emailing reports to replace existing printed reporting.
• Production support for converted code.
• Provided consulting and staff mentoring.
• Assisted other teams wif overflow work. Demonstrated ability to handle multiple assignments for other projects.

Confidential, Jacksonville, Florida

Senior IBM me/iSeries/AS400 DB2/Programmer/Analyst (contractor)

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, CL, RPG, DB2/SQL, DDS/DDL, MQSeries. i5/OS v7r1.
• Created multiple tools as research and development aids including a string mass search application. Programs used embedded SQL for accessing DB2 database files. QM SQL queries were created for reporting and other intermediate processing of teh DB2 database.
• Assisted business analysts wif database research.
• Assuming support for RPG based database system.
• ROBOT scheduler.
• Used iNavigator SQL tools for DB2 file research and analysis.
• Converted SEQUEL ViewPoint queries to scheduled reporting processes.
• Created technical documents for upcoming projects.
• Assigned to FTP to sFTP conversion project.
• Designed and developed application that reads sFTP logs and calculate teh number of bytes transferred to determine if mainframe space allocation is adequate for remote system.
• Access mainframe (z/OS) to confirm file transfer as part of sFTP testing.

Confidential, Sacramento, California

Senior IBM me/iSeries/AS400 DB2/Programmer/Analyst (contractor)

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, RPG, CL, DB2/SQL, DDS/DDL, MQSeries. OS/400 v5r4 and i5/OS v7r1.
• Maintained and supported lien title systems for 22 states.
• Some system admin duties.
• Projects developed using Agile methodology.
• Played a major role in teh system upgrade to v7r1.
• Maintained MQSeries configuration and connectivity. Maintained teh v5r2 system functioning during teh upgrade to v7r1.
• IBMi Navigator, MS Office.
• ROBOT scheduler.
• GoAnywhere MFT (Managed File Transfer). Handled administration for configuration, monitoring and troubleshooting of software and local and remote files.
• EDI file transfers, X12 and AAMVA format.
• MQseries management and data transfers.
• Analysis and evaluation of systems jobs and operations. Documented steps to enable quick resolution of job issues and production fixes.
• Used iNavigator SQL tools for DB2 file research and analysis.
• Mentored junior programming team members and trained level 1, 2 and 3 users on procedures and usage of teh custom software system.
• Reverse engineering and analysis to assist teh legacy system replacement team wif design specifications.
• On call system monitoring.
• Design of system tools to assist wif day to day operations and troubleshooting.
• Created a job monitoring tool to send email and text alerts for job messages.
• Designed and implemented an import/export file monitor/dashboard to track overdue and missing client EDI files.
• New development used embedded SQL for accessing DB2 database files. QM SQL queries were created for reporting and other intermediate processing of teh DB2 database.

Confidential

Senior IBM me/iSeries/AS400 DB2/Programmer/Analyst (consultant)

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, CL, DB2/SQL, DDS/DDL,
• Aldon change management, Rational Developer for IBMi, IBMi Navigator, MS Office, Lotus Notes.
• Financial, loan systems.
• Mentored and assisted junior Confidential team members wif technical assistance to facilitate completion of their assignments.
• Assigned work and supplied technical support to teh offshore team.
• Used iNavigator SQL tools for DB2 file research and analysis.
• Coordinated screen design and layout wif LegaSuite developer.
• QM queries were also used for researching complex issues.
• Was involved wif several performance improvement projects.
• Developed me/O module standards for performance initiative. dis would simplify program logic and reduce teh amount of specialized me/O coding.
• Improved querying tools used for performance reporting.
• Developed and submitted recommendations for improvements to teh client’s me/O standards.
• Modified and tested existing programming as required by teh client.

Confidential

Senior IBM me/iSeries/AS400 DB2/Programmer/Analyst (consultant)

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, RPG, CL, DB2/SQL, DDS/DDL, WRKVIEW, Query Manager, Rational Developer for IBMi, IBMi Navigator, MS Office.
• Catamaran/RxClaim payer pharmacy system COBOL.
• Analyzed existing custom software functionality to develop additional features and improvements. dis also included analysis of teh RxClaim vendor database structure.
• System admin duties
• EDI file transfers, NCPDP format.
• Acted as RxClaim technical and programming support for teh pharmacy claims and technical services department.
• Designed a application to identify RxClaim database modifications and teh custom programs that are affected.
• New program applications used embedded SQL for accessing DB2 database files. QM SQL queries were created for reporting and other intermediate processing of teh DB2 database.
• Developed several applications to examine and synchronize pharmacy member prior authorization coverage.
• Mentored BCBSMS pharmacy staff and new programmers on teh RxClaim database structure, query logic and other technologies.
• Replaced Showcase and QUERY/400 queries applications to Query Manager queries and SQL statements for improved performance, which significantly reduce runtimes and runtimes errors.
• Created reporting from existing views for users as needed.
• Supplied instruction on SQL design to other programming teams for web application connectivity to teh RxClaim database and custom tables.
• Developed drug formulary extract processes to support web services applications. dis allowed BCBCMS to replace Catamaran’s RxPortal wif a more accurate application.
• Supplied systems support coverage when administrator was unavailable or needed assistance.
• Assisted technical services unit wif training and solving user issues related to teh RxClaim database.
• Established coding and code/data promotion standards.
• Developed user friendly data load processes incorporated into a dynamically generated menu system.
• Designed and developed a source member search utility.
• Created a user friendly utility to import data from IFS folders for teh RxClaim standard data loads.
• Designed and developed a dynamic menu system for custom software usage.

Confidential

IBM me/iSeries/AS400 DB2/Programmer/Analyst (contractor)

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, CL, DB2/SQL, DDS, Query Manager, IBMi Navigator, MS Office.
• PowerMHS payer system, healthcare insurance, claims.
• Developed robust CLP applications wif auto-continuation which allowed a batch application to continue from teh last successful step if re-submitted. dis would apply if teh program run is interrupted. Teh program ran multiple SQL/DB2 queries resulting in a single report.
• XML program maintenance.
• Produced stored procedures as part of web portal performance improvements, which replaced XML web interfaces.
• Maintained existing code and created new applications wif embedded SQL for accessing DB2 database files. QM SQL queries were created for reporting and other intermediate processing of teh DB2 database.
• Created a common utility to update transmission audit files. dis allowed any audit file to be updated wifout a dedicated program. Previous method used by teh programming staff was to clone and hard-code teh audit file information into each program.
• Mentored new programmers on database structure, programming techniques, variable length file processing and other related areas.
• Designed and coded a common utility that logically wraps long error message strings using a boundary length supplied by teh calling program. dis would allow teh wrapping point to be variable depending on need.
• Created a source code statistics utility. Teh application counted and displayed code change statistics that has been changed under teh Aldon Change Management System using teh Aldon database.
• Consolidated a 39 SQL query application into 14 queries while maintaining performance and in some cases increasing it.
• Gained experience wif XML COBOL.

Confidential, Houston, Texas

Senior IBM me/iSeries/AS400 DB2/Programmer/Analyst (contractor)

Responsibilities:

• Skills employed; IBMi, ILE, COBOL, CL, SQL, RPG, Query Manager, Operations Navigator, MS Office. AS/400 and S/36 environments. McCracken Strategy Mortgage system.
• Introduced ILE programming techniques to teh iSeries development team.
• Analyzed existing custom software functionality to develop additional features and improvements.
• NuBridges file transfers.
• ROBOT scheduler.
• Turnover CMS.
• System operations and admin duties.
• Maintain user profiles.
• Monitor batch and system status.
• Restore objects
• Maintain FTP applications.
• Verify and schedule backups.
• Create and save to save files (SAVF).
• Restore from backup as needed.
• Participate in DR drills.
• Maintain connected devices.
• Support users.
• Mentored RPG programmers on COBOL programming and programming techniques, CL programming techniques and other related areas.
• Mentored new programmers on database structure, programming techniques, variable length file processing and other related areas.
• Responsibilities involved creating new applications and processes, modifying and debugging existing applications and processes, code modernization, designing and creating utilities.
• Demonstrated competence wif Query/400 and SQL for reporting and updating database files and applied embedded SQL for COBOL programs.
• Created many applications involving display subfile processing, menus, message file and halp file usage.
• Supplied on-shift and on-call operations support which included monitoring active jobs and teh operating system, responding to job errors and managing user profiles.
• Accomplishments include designing a job stream mapper based on teh Hawkeye database and a scanner that would examine source code for file usage. dis saved many man-hours.
• Fully designed and developed a BCP utility that allows users to switch printer queues wifout IT staff assistance. Teh utility also maintained a history of their default and previously used printer queues.
• Completed several projects to replace existing programs wif more efficient and better structured programs.
• Created documentation for training, giving instruction for methods and techniques not previously used by teh programming staff such as null-capable fields, date formats and intrinsic functions for ILE COBOL.
• Considered teh “go to” person by IT staff members and users.
• Developed much of my DB2/SQL methods and noledge during dis project.

Confidential, Melville, New York

Senior iSeries/AS400 Programmer/Analyst

Responsibilities:

• Skills employed; AS/400, iSeries, COBOL, CL, DDS, MS Office.
• System admin duties.
• Performed applications programming, systems operations and administration on teh AS/400 and iSeries platforms. Extensive experience wif development of COBOL, RPG and CL programs for interactive and batch applications including embedded SQL for a DB2/400 database.
• DDS file creation of physical files, logical files, display files, subfiles, menus and report files.
• Developed a subfile list find routine, updated and replaced programs, streamlined program processes to improve application design and performance.
• Repaired programs and databases files corrupted by previous developers.
• Produced production and ad hoc reports via program creation and Query400.
• Coordinated teh installation, importation and configuration from AS/400 to iSeries system.
• Maintain system for post SAP go-live data extraction and archival reporting.
• Developed an online archive wif MS Access for users to view historical data.
• Created and maintained an MS Access/Visual Basic application that tracked warranty repair hours for special product recalls.
• Designed and developed an online customer service refund request .ASP form. Visual Basic was used to give additional function editing enhancements to teh entry screen.
• Solely responsible for maintenance and development of teh Warehouse Management module.
• Extensive exposure to teh Materials Management/Inventory Management module.
• Modifications to configuration, creation of info sets and queries to meet user needs and general technical support for users.
• Designing and creating specifications for new RF applications and processes.
• Also maintained teh RF Wavelink firmware and configuration.
• Streamlined teh custom RF process to initiate a more efficient warehouse process overall.
• Experience wif teh physical inventory process.
• Developed a paperless streamlined process for RF procedures and also SAP document clearing.
• Created reporting to facilitate real time tracking of teh annual inventory process and count variances.
• Designed teh unique warehouse architecture to maintain bin to storage location integrity.
• Architected teh entire RF process for customer consignment processing.
• Continually developed processes for increasing warehouse efficiencies.
• Fully involved wif implementation and development of teh current SAP R/3 4.6c system.
• Constructed teh data conversion process from teh legacy system.
• Created a majority of InfoPak business procedure documents during integration.
• Examined and manipulated data wif TextPad software.

Confidential, New York

Y2K Conversion Specialist/Programmer/Analyst

Responsibilities:

• Skills employed; S/390, AS/400, COBOL, RPG, BAL(Assembler), JCL, CL, IMS, CICS, DDS, MS Office.
• Acted as teh lead person and technical consultant for conversion technicians.
• Collaborated in teh development of teh tools, procedures and specifications for teh customized conversion software.
• Supervised teh conversion processed from data identification through QA.
• Sole person capable of applying conversion principles to multiple languages such as COBOL, DB2, IMS, RPG, BAL, Mark IV and CICS for both mainframe and midrange (AS/400) systems.
• dis enabled me to coordinate, instruct and monitor programmers in teh development of conversion tools for additional programming languages.
• Responsible for compiling and testing of converted programs for mainframe (OS/390) and midrange (iSeries) systems.

Confidential, Holtsville, New York

Computer Operator/Dispatcher

Responsibilities:

• Skills employed; S/38, AS/400, RPG, CL, OS/2, HyperAccess5, Word Perfect.
• Duties included AS/400 operations, PC applications using Lotus, Roadnet 5000 (routing and delivery scheduling software) and HyperAccess5 (transfer software) for teh OS/2.
• Responsible for disaster recovery preparation and implementation, technical support for teh night crew, submitting and running batch jobs, and assisting users wif workstation usage and problems.
• Monitoring all active jobs, users, and Job/Writer Queues.
• Recommended changes to production software, submitted recommendations for future programs and involved wif teh troubleshooting of production issues.
• Participated in migration from S/38 to AS/400.

Education and training