Ben Samuelson Email & Phone Number

Walkerton, In, Us

Hampton, Va, Us

Signed up health insurance clients for in home health evaluations for Signify Health

Paris, Île-De-France, Fr

Customer service representative for New York Life AARP Life Insurance

Repaired produce and egg crates for Polymer Logistics

Pursuing new opportunities and challenges

DB2 Performance and SQL Consultant analyst, developer, for Indiana FSSA Indiana Client Eligibility System in COBOL, IMS DB and DC, DB2, Easytrieve Plus and Telon. Increased proficiency with Omegamon DB2 for z/OS and gained working knowledge using IBM Data Studio Query Optum Tuner to identify and improve DB2 performance issues. Consulted with other team members on DB2 and IMS database access issues. • Corrected county, district, and state wide report totals out of sync with detail summaries that had been updated several times previously by 3 programmers with several years of system experience• Identified and documented how to use DB2 package version numbers to allow multiple developers to have valid DB2 programs in same test environment• Identified and implemented key timestamp in ICES online screen interface with eligibility determination rules engine that as defined to effectively be a constant• Identified excessive aborts in ICES online interface with eligibility determination rules engine and identified what may be happening • Identified severe performance issue with interface data from government FACTS system caused by inefficient SQL causing index scans on several tables when the complete index fields were available SQL was using index scans to access data Run time for 505 records in read only test improved from over 90 minutes to less than 1 minute. In DB2 CPU time improved from over 19 minutes to less than 1 minute with dramatic reduction in DB2 get pages.

DB2 DBA support for Delphi Electronics & Safety, production support and maintenance and Endevor administrator for numerous Delphi legacy mainframe systems. Team members in US, India, and Argentina.• Upgraded more than 10 Endevor instances to newer versions• Archived more than 15 retired systems and Endevor instances when no longer required eliminating systems charges for Delphi account and client

DB2 DBA, analyst, developer, and Endevor administrator for mainframe computer resource billing systems for GM, Delphi, Ally, and Nexteer clients. DB2 and system mentor for less experienced team members. Team members in US, India, and Argentina. • Created and maintained DB2 database and tables for GM and Ally billing with approximately 13 million monthly detail rows loaded on last working day with billing completed 100 percent on time on the first working day of the next month .• Saved approximately 65 percent of online DB2 data storage by compressing monthly detail data• Defined DB2 maintenance to minimize maintenance• Prepared and completed application DB2 database for DB2 v8 and v9 upgrades• Served as team interface to numerous system support teams including support outside the US• Completed many enhancements and maintenance coding assignments

Ongoing production support, maintenance, and enhancements for order processing, warehousing, scheduling, requirements planning, inventory control, and shipment systems in COBOL, DB2, IMS DL/I DB, IMS online, CICS, VSAM, PL/I, JCL. Technical lead or project manager for many enhancements. Planned and tested disaster recovery. Provided IMS and DB2 DBA support. Team members in US, India, and Brazil.• Served as technical lead, mentor, and project manager for replenishing labels for warehouse products when shipped to maintain stock at required levels ensuring sufficient product availability improving warehouse efficiency. Implemented project at 10 percent under estimate • Technical lead and mentor on projects for shipping labels and documents for client’s Honda America client, reusable container labeling to assist client in dramatically reducing packaging costs. • Completed complex testing and verification and testing of year 2000 changes made by the account year 2000 remediation team, finding and resolving discrepancies • Created numerous SAP load files for Delphi SAP transition getting transition complete on their schedule

Analysis, design, development, and implementation for new retail receiving system and existing distribution system in PACBASE, COBOL, DB2, IMS DL/I DB, IMS Online, CICS, VSAM, JCL• Completed design, coded, tested, and implemented labeling processing for new receiving system to meet implementation target that had been missed previously, restoring client confidence• Identified and corrected problem in online shipment processing dramatically improving system throughput eliminating manual intervention to complete the processing saving over $20,000 annually

Production support for network logon ID system in COBOL, VSAM, CICS, JCL. Development, implementation, production support, and numerous enhancements including analysis for new network logon ID system in COBOL, CICS, IMS DB, JCL, Easytrieve Plus, and, assembler. Analysis, design, and development for new security request system in PACBASE, COBOL, CICS. DB2, and JCL. Team based in US and Belgium.• Supported old system with little to no help freeing other team members for development while coding, testing, and implementing modules for new system• Created parallel processing in old system that identified critical issues in new system enabling quick resolution before causing any problems in production • Identified and resolved issues in batch maintenance saving over 75 percent in processing time and virtually eliminating on call issues saving over 100 effort hours annually• Reduced internal data distribution costs by approximately 80 percent saving over $50,000 annually • Created complex local processing in assembler with sort to capture and summarize network logon ID statistics and passwords returning to central system for more efficient processing• Completed complex integration of online request screens with request authorization sub system for new security request system to meet model office deadline• Designed local site subsystem architecture for new security request system to process ACF2 updates more efficiently than system being replaced

ACF2 Security administrator for GM mainframe systems creating and maintaining logon IDS, access rules, report distribution and resolving security issues • Resolved networking issues that networking support had identified as security• Reduced volume of security reports by 80 to 90 percent • Eliminated 80 to 90 percent of manual report distribution

Bs, Ma, Environmental Design, Computer Science Minor, Computer Science Masters

Advanced Topics In Computer Programming, Requirements, Ethics

Systems Engineer, Systems Engineer Development Program

Db2