| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Temple, Texas Street Address
Summary Delwin has more than 30 years of experience in application program development. Extensive expertise in Cobol, JCL, GitLab, Endeavor, DB2, TSO/ISPF, VSAM, IMS, Z/OS, and Oracle.
Proficient Application and Programs Developer with expertise in various technologies including SQL, COBOL, EDI, and PL/SQL. Excecutes back software solutions, design, development, and technical troubleshooting Experience in modifying, and updating Medicare and Medicaid enrollment applications with coding
Address basic code quality issues Break down routine technical tasks to troubleshoot and solve issues ensuring compliance with the latest government healthcare policies (RadGov, Inc: Highmark Health). Expertise in managing projects through the entire Software Development Life Cycle (SDLC) Skilled Technology Lead and SQL Developer proficient in various databases, including Oracle, Business Objects XI, Sybase, Ideal, Informix, Rochade, IDMS, and RapUp.
Actively applies automation to reduce toil in the Software Development Life Cycle Experience with ACH/NACHA processing Results-oriented Technology Lead with expertise in developing and updating Basic programs and macros on the proprietary system Metropolis-ABW, optimizing order entry, warehouse, inventory, and distribution processes. Proficient in utilizing applications like Microsoft SQL Server, DBeaver, NextGen, Visio, Office 365, Service Now, MS Project, and SharePoint.
Experienced in mainframe technologies including JCL, ISPF/TSO, IMS DB/DC, DB2, SPUFI, PL/1, PL/SQL, Roscoe, MVS, and debugging tools like Xpeditor, File-Aid, Abend-aid, and Changeman.
Managed networks by setting up routers, switches; configuring and connecting computers, and printers;
Proven track record in creating efficient test scenarios, documenting data flow, and managing teams.
Skilled in client collaboration, providing technical insights, and offering support for program maintenance, demonstrating strong leadership in project development and technical issue resolution Extensive knowledge of programming languages such as COBOL, COBOL II, AS400/COBOL, CICS, VSAM, SQL, Easytrieve, Perl, RPG, PL/1, Z/OS KIX, Tandem and more. Results-oriented IT professional with expertise in unit testing, data correction, and debugging using tools like IBM debugger and File-Aid.
Experienced in attending design meetings, providing valuable insights, and implementing necessary changes in Cobol programs for process enhancement.Education:DeVry UniversityB.S. Computer Information SystemsCertification:Techskills (2006)Oracle OCASkills and Technical Expertise: Application Developer Programs Developer Technology Lead SQL Developer Databases: Oracle, Business Objects XI, Sybase, Ideal, Informix, Rochade, RapUp, DGM Languages: COBOL, COBOL II, COBOL 74, AS400/COBOL, COBOL/370, COBOL/390, Focus, ACUCOBOL, COBOL, CICS, VSAM, SQL, Easytrieve, Easytrieve Plus, Perl, Tandem, Panvalet, RPG, PL/1, Z/OS KIX, Micro Focus, Korn shell, spufi, FORTRAN, TPF, Sabretalk Applications: Microsoft SQL Server, DBeaver, Next Gen, Visio, Office 365, Service Now, MS Project, MS Office Professional, SharePoint, Bomgar, Remedy, Etracks, Xtend, Lotus Notes, Active Directory, Exchange, VMware, McAfee Anti-Virus, Malwarebytes, QuickBase, Crystal Reports, InfoView, Ghost, WebEx, VNC, SQL Loader, Lync, CA7, SCCM, SMS, PowerShell, Credit Check, Version One, Agile, Cerner Millennium Software, Business Basic- PRO5, Confluence, EHR, Gentran, JIRA, EDI/X12, Btrade, Vans, AVG, SonicWall Firewall, ERP, ETL, FoxPro 7, ACH / NACHA, UNIX, LINUX Mainframe: JCL, ISPF/TSO, IMS DB/DC, IMS DLI, IDMS, SPUFI, PL/1, PL/SQL, Roscoe, MVS, Xpeditor FiIe-Aid, Abend-aid, Changeman, IMS/DLI, DB2, Telon, HP Manager, Debugger, File Manager, Fault Analyzer, RACF, Endeavor, VSE, IBM debugger, CA-ADS Hardware: Dell desktops/laptops/server, HP desktops/laptop/server, Wyse Thin Client Toshiba desktops/laptops, IBM/Lenovo laptops and desktops, IMac, Macbook pro/air, IPAD, IPhone, and Android, AS400, IBM Mainframe, MQ Series, iSeries, DNS, DHCP, TCP/IP, Modems, Switches, printers, plotters, PBX, Avaya,Professional Experience:Insight Global: UCLA (Remote) Nov 2023 to Feb 2024Senior Application Developer Designed and used Endeavor to create and update VSAM, JCL, DB2, SQL, FTP, and Cobol applications. Used IBM Debugger to gain insight and resolve productions. Conducted meetings and provided staff insight Collaborated with cross-functional teams to analyze system requirements and propose innovative solutions, ensuring alignment with project objectives and business needs.Infosys Limited (Remote) Sep 2021 to Jun 2023Technology LeadProject - Verizon (May 2023 to Jun 2023) Attended meetings and training on the projects. Set up and configured virtual machines (VMs) to support data management tools, ensuring optimal performance, security, and scalability. Actively participated in project meetings, collaborating with cross-functional teams to discuss project objectives, progress, and challenges. Collaborated with system administrators and IT teams to troubleshoot technical issues, ensuring seamless data management tools and systems operation. Designed and modified EDI documents Modified Linux with SED scripting Modified Cobol, JCL, FTP, DB2 and VSAM. Attended Lineage Management meetingProject - American Electric Power (Jun 2022 to Apr 2023) Developed and Modified Cobol, JCL, DB2, FTP, IDMS and Install 1.
Created rebill files for production processing.
Modify SQL scripts to include PL/SQL logic Implemented Rochade
Managed and trained the Offshore and Onshore teams and assigned and reviewed projects before installing them into production.
Conducted project and support meetings.
Use Jira to track projects and progress.Project Verizon (Sep 2021 to Apr 2022) Developed and Modified Cobol, DB2, FTP, and JCL. Supported production support and provided data changes to correct issues and abends.
Attended meetings and provided insight where needed.
SQL was used to get data for testing and verifying changes. Modify SQL scripts to include PL/SQL logic Create SED scripting Attended Lineage Management meetingRadGov, Inc: Highmark Health Pittsburgh, Pennsylvania (Remote) Jan 2022 to Feb 2023Senior Application Developer Developed in Cobol, JCL, GitLab, EDI, Endeavor, DB2, TSO/ISPF, VSAM, IMS, Z/OS and Oracle. Created test scenarios for unit testing and produced results. Planned, changed, and updated the Medicare and Medicaid enrollment applications with coding by the latest government healthcare policies. Used ServiceNow for tracking tickets and Jira for project development. Attended meetings about existing Cobol programs and what changes need to be updated or created. Documented the flow of data being passed through the systems. Designed and implemented Rochade. Designed, updated, and installed programs; tested and produced documented results. Managed and coached teams Lead meetings with clients providing insight as needed. Worked with their EHR to provide data for the billing application. Supported programs after hours and provided help to others on Gitlab and other technical issues. Used Xpeditor for program checking/debugging. Used File-Aid for creating and managing files.OneStop Inc Grand Rapids, Michigan (Remote) Aug 2020 to Jan 2022Senior Application Developer Developed and updated Basic programs and macros on a propriety system for Order entry, Warehouse, Inventory, and Distribution. The application name is Metropolis- ABW which runs on a Unix server. Developing on a remote server and installing on to a remote development server for testing, then moving to a remote production server. Manage the operation for the XML invoice processing and coding.
Manage the Metropolis database by creating and updating tables, and data. Conducted meetings to present a prototype to management for sign-off. Designed and Implemented Rochade
Created and Modified Micro Focus programs
Deloitte: State of Indiana, Indianapolis, Indiana (Remote) May 2020 to Oct 2020Senior Application Developer Created and modified COBOL, IMS DB/DC, DB2, FTP, DB2 and Z/OS programs and supported them after installation. Read existing COBOL programs to document what needs to change per the new specification. Modified Cobol with IMS GN to process the IMS database and produce reports and files Incorporate PL/SQL procedures into existing SQL operations Created test scenarios for unit testing and produced results. Made changes to production data that needed correcting. Changed various JCLs to improve the unemployment process's performance and batch cycle time.
Debug and Trace programs via the IBM debugger tool. Debugged program with Xpeditor and created/managed files with File-AidTexas Farm Bureau, Waco, Texas Aug 2019 to Feb 2020Senior Application Developer Created and modified COBOL, IMS DB/DC, and DB2 programs and supported them after installation. Created test scenarios for unit testing and produced results. Created and Modified Cobol with IMS GN Made changes to production data that needed correcting. Attended design meetings and provided information as needed Attended meetings about older Cobol programs and what was needed to change in the code for the new process. Debug and Trace programs via the IBM debugger tool. Edited and managed file via File-AidMcLane, Temple, Texas Mar 2019 to May 2019Senior Application Developer Worked with COBOL and DB2 to develop and update a variety of programs. Received updated training in File-Aid and Xpeditor.Fremont Insurance Fremont, Michigan Nov 2018 to Jan 2019SQL Developer Created and updated information for a data warehouse mapping document, utilizing tools such as the DBeaver application and Microsoft SQL Server. Developed comprehensive data mapping for the Cloverleaf application, streamlining data integration and enhancing operational efficiency. Collaborated with cross-functional teams to gather and synthesize essential data information from in-house applications, including POINT, NextGen, and Stream, contributing to a holistic data landscape. Designed, optimized, and implemented SQL queries for the Data Warehouse team, facilitating data extraction, transformation, and loading processes. Engaged in continuous learning by thoroughly reviewing Java application development documentation and queries, ensuring alignment with database processes and requirements. Played a pivotal role in knowledge dissemination by providing well-structured documents and facilitating productive meetings. This contributed to the smooth flow of data for the ETL process. Actively participated in the ETL process by assisting in selecting and extracting relevant data, subsequently aiding in loading meticulously processed data into the Data Warehouse through the Staging process.Insight Global: MEI Telecommunication Delton, Michigan Feb 2018 to Jun 2018Senior Developer Created and updated FoxPro applications and SQL scripts, contributing to the development of versatile and efficient software solutions. Generated comprehensive system documentation, utilizing tools like Visio and SQL Server, to design and structure SQL databases effectively, ensuring data integrity and accessibility. Attended meeting for conversion to IDMS Assumed a pivotal role as an Assistant to the Project Manager, actively participating in the documentation of the existing system and conceptualizing a novel Billing system. Leveraged skills in Cobol and DB2 to craft new files and reports catering to management's needs, thereby enhancing decision-making processes. Proficiently handled data processing tasks involving ACH/NACHA formats for seamless banking transactions, contributing to secure and efficient financial operations.Insight Global: Notions Marketing Grand Rapids, Michigan Feb 2017 to Dec 2017Senior Developer Created and updated documentation via Confluence, establishing a comprehensive repository for essential information. Utilized Unix/Linux and Business Basic (Pro5) to proficiently set up new partners and vendors, streamlining onboarding processes. Developed ad-hoc programs catering to upper management, providing a clear product sales and tracking overview. Innovatively designed a process to establish parent-child relationships even when platforms or files were unavailable, enhancing data organization. Leveraged SQL to manage products and pricing effectively, seamlessly integrating with other programs in the workflow. Tracked and managed project ticket statuses through the JIRA Development system, ensuring timely progress and issue resolution. Spearheaded the creation of new Trading Partners by generating essential documents like 850 (Order inbound/outbound), 855 (inbound/PO Ack outbound), and 810 (inbound/Invoice outbound) for both vendors and customers. Orchestrated the transmission of trading partners with EDI documents like 846 (Inventory list), 856 (Shipping Manifest), and 857 (ship and billing notice) through Gentran. Established AS2 connections via BTRADE and configured SFTP connections for secure data exchange. Developed and consistently maintained EDI/X12 documentation, ensuring accuracy and adherence to industry standards. Employed ETL processes to efficiently transfer data from files to Oracle, rigorously testing Oracle data post-conversion to ensure program functionality. Regularly updated and optimized scripts on Unix and Linux platforms to uphold system efficiency and reliability.Alert IT Solutions, Inc.: IDES Chicago, Illinois Sep 2015 to Dec 2016Legacy System Developer Created and updated documentation for the Department of Unemployment Services to facilitate the transition from Easytrieve, COBOL, and IMS to Java. Developed Cobol programs for converting IMS by processing GN and VSAM databases into DB2 tables. Formulated comprehensive project plans outlining migrating CICS applications to Java on the Unix platform. Thoroughly documented existing JCL (Job Control Language) for daily, weekly, quarterly, and yearly processes. Detailed the execution process of Jobs by providing a comprehensive list of inputs, processes, and output elements, all vital for the Java conversion. Modernized and enhanced existing programs, concurrently establishing a test VSAM environment essential for testing reports and generated letters. Successfully converted VSAM files into DB2 tables, while also creating a specialized program for meticulously comparing data between VSAM and DB2, ensuring the accuracy of results. Devised various test scenarios crucial for unit testing, meticulously executing them and documenting the outcomes. Produced insightful management reports that offered valuable insights and information.Collabra: Capital One Rolling Meadows, Illinois Dec 2014 to Apr 2015Application Support Developer Using the agile process, created and updated RapUp and Credit Check files that were transferred to the mainframe for CICS testing and placed into production. Migrated load files to the mainframe iSeries to create datasets for testing in different CICS regions.
Created file for legacy attribute removal on the CICS program. Created sync sort for analyzing and gathering data via VSAM files and created Changeman packages. Trained Version One to keep track of project status. I created PPV (Pre-Project Validation), Back Out processes, and Project Implementation. Created HP Manager quotes for production processes. Use RACF to define datasets, add users to datasets set, and maintain passwords for datasets.Artech: Nsource, Hammond, Indiana May 2014 to Dec 2014Technical Support Contacting customers to schedule the deployment of their new equipment, effectively coordinating work orders for the technical staff's seamless installation. Proficiently imaging laptops and desktops using SCCM (System Center Configuration Manager). Skillfully overseeing the entire equipment deployment process, from installation and delivery of computers to hands-on troubleshooting of desktops, laptops, printers, plotters, iPhones, Android phones, and various versions of Microsoft Office (e.g., Microsoft Office 20xx). Conducting comprehensive training sessions for staff, imparting essential operational knowledge and best practices for efficient system usage. Efficiently managing computer assets and appointment scheduling via HP Manager, ensuring optimal resource utilization and timely service. Work on identifying the CL-class of RAM and ask that other RAM be ordered Pioneering the development, documentation, and successful execution of a disaster recovery plan tailored to the call center environment, ensuring business continuity and minimizing potential disruptions.Hewlett Packard: Arcelor Mittal Burns Harbor, Indiana Aug 2012 to Nov 2013Svc Info Developer II Created Oracle tables and proficiently loaded data using SQL Loader and ETL processes. Developed specialized COBOL, IDMS, DB2, and IMS programs with accompanying JCL for steel manufacturing and customization purposes. Orchestrated the seamless conversion and transfer of files to the Oracle server by integrating FTP processes within the COBOL, DB2, and IMS workflows. Effectively utilized KIX scripts to facilitate data loading into Oracle tables, streamlining the data ingestion process. Demonstrated expertise in creating, enhancing, and maintaining triggers, functions, stored procedures, and complex queries within the SQL environment, contributing to data manipulation and retrieval efficiency. Played a pivotal role in the upkeep of programs within the CICS environment, collaborating with fellow developers on multifaceted projects. Employed debugging techniques, including tools like Xpeditor and desktop checks, to identify and resolve issues within the developed programs. Provided essential production support, addressing concerns within Cobol/JCL programs and ensuring uninterrupted system functionality on a 24/7 basis. Innovatively conceptualized, established, and implemented a document server to facilitate the seamless conversion from Accello to Form Port, enhancing document management efficiency. Ensured data security through the utilization of RACF, effectively restricting dataset access to authorized personnel only. Skillfully employed DSMON to generate critical control reports, providing insights into system performance and data management. Leveraged ETL processes via KIX scripts for daily file conversions to Oracle data, ensuring timely and accurate loading of Oracle tables.Seaton Corporation Chicago, Illinois Jun 2011 to Jul 2012Desktop Support Level III Coached and closely monitored support for Level I and II employees, offering guidance and fostering professional growth. Conducted interviews to assess candidates for Level I and II positions, ensuring the team's continued effectiveness. Played an instrumental role in the creation and maintenance of Standard Operating Procedures (SOPs), providing clear guidelines for operational processes. Provided comprehensive technical support across various levels, assisting recruiters, in-house staff, remote workers, and even the CEO in resolving technical issues. Took charge of creating and managing system images and backups for staff laptops and desktops using Ghost, ensuring data integrity and continuity. Skillfully administered Active Directory and Exchange email accounts, effectively managing user access and communication systems. Undertook software installations, printer setup, VPN configuration, and computer security maintenance, contributing to a seamless and secure computing environment. Demonstrated expertise in troubleshooting a diverse range of technical problems, covering desktops, laptops, printers, Wyse Thin Clients, and smartphones. Leveraged tools like WebEx and VNC to provide remote assistance, offering efficient solutions by accessing user computers remotely. Maintained an accurate inventory log of laptops requiring software updates and those that had been loaned out, ensuring resource tracking and proper management. Provided dedicated support to a substantial user base of over 1500 clients, both on-site and remote, extending assistance to navigate technical challenges. This included support for the Avaya phone system.Marriott International Rosemont, Illinois Oct 2010 to May 2011Area Technical Support (NE) Supported over 1000 sales representatives, providing technical assistance to teams both in-house and remotely across a vast geographical span encompassing four states: Illinois, Michigan, Wisconsin, and Ohio. Managed the imaging, and installation of software and hardware, and conducted modifications within Active Directory and Exchange email accounts for laptops and desktops. Displayed proficiency in troubleshooting a diverse range of technical issues involving laptops, desktops, printers, and smartphones, ensuring smooth operations for sales representatives. Took charge of overseeing the backup processes for both desktops and servers, ensuring data preservation and business continuity. Conducted comprehensive training sessions for sales representatives, facilitating their smooth transition to new software installations and updates. Actively managed technical improvements and addressed staff needs, effectively coordinating the shipping of hardware across the expansive four-state region to ensure optimal equipment availability.University of Chicago, Chicago, IL Jun 2007 to Feb 2010Lead Technical Support
Provided comprehensive technical support to staff members and over 100 university police patrolmen, catering to their unique technology needs and challenges. Supported the deployment, configuration, and troubleshooting of Toughbook laptops, catering to specialized requirements for police operations. Addressed connectivity issues, particularly those tied to cell signals via AT&T. Imaged and effectively addressed issues spanning laptops, desktops (Mac and Windows XP, and 7), printers, and smartphones, ensuring operational efficiency across diverse devices. Assisted in the installation and setup of security cameras within the building and across the entire campus, enhancing surveillance capabilities and security measures. Displayed project management capabilities by leading staff meetings to configure and install HP servers. Developed comprehensive timelines and task lists to ensure efficient project execution. Facilitated training sessions in collaboration with the training department, enabling police patrolmen, dispatch personnel, and staff to effectively use the newly implemented police system. Created multiple Service Level Agreements (SLAs) tailored to the specific needs of the police department, establishing clear guidelines for technical support and issue resolution. Demonstrated effective vendor management skills by initiating contract negotiations that resulted in substantial cost savings for the University Police Department. Negotiations led to a five-thousand-dollar savings upfront and over a thousand dollars per month in ongoing expenses. Coordinated and maintained a network dedicated to an online gaming system (Quake), which the Renaissance Society supported. This effort contributed to the fostering of a vibrant gaming community.Chicago, Illinois Mar 1999 to Jun 2007Data Warehouse Developer Gathered comprehensive business and technical requirements to drive the creation of Business Object reports, ensuring alignment with user needs and data-driven insights. Designed, developed, and troubleshot Business Object reports and universes, enabling efficient data visualization and analysis for various stakeholders. Skillfully crafted and optimized SQL queries within the Business Object environment, facilitating data retrieval and reporting accuracy. Took the initiative to create, enhance, and troubleshoot COBOL, CICS, and JCL programs, enabling seamless data transfer from the mainframe to the Oracle server, and streamlining data accessibility for Business Objects reporting. Conducted comprehensive training sessions for user communities, empowering them to effectively utilize Business Object XI and leverage prewritten reports for informed decision-making. Leveraged ETL processes to convert data from flat files to Oracle, enabling smooth data processing for Business Object reporting needs, ensuring data accuracy and relevance. |
