Data Analyst

Victor J. Doylida

Career Summary

Highly motivated, creative, and versatile Systems Engineer with 30+ years experience in Information Technology. Exceptionally skilled at establishing productive, working relationships with clients and staff. Excellent communication skills and extremely service oriented. Experienced in Service, Manufacturing, Transportation, Logistics, Order Entry, Billing, Accounting, Retail, POS, HR, EDI and the Derivatives/Futures Industry.

Technical Skills

IBM AS/400 Operations, Programming and database tools - CLP, RPG II, RPG III, RPG IV(ILE), RPG FREE, Embedded SQL, Binder Language, Service Programs, Modular Programming, EDI, FTP, SFTP, MKS Implementer, ALDON, TURNOVER, AGILE, Sharepoint, Confluence, X-Analysis, Abstract/Probe, CONTROL M, ROBOT, MQ series, MS-WORD, EXCEL, MS-VISIO, DB2/400, AS400 Query, DBU, DFU, EZVIEW, RDI, SDA, SEU and interactive/batch processing including extensive sub-file processing.

Work Experience

HSBC, Arlington Heights, IL I.T. Consultant Sept 2020 - Present

SR. PROGRAMMER/ANALYST: CRMS project development and Production support. Analyze, code, test and implement ETL process programs using CLLE, SQL and RPG free-format language.

Design, code and test process to delete potential customers records based on electronic data file per CCPA requirement.

DRE – Assist and monitor disaster/recover process exercise moving IBMi data processing from onsite to DRE site. Testing and troubleshooting existing applications at each level to ensure the integrity of the systems.

Analysis and development of API for data transfer to downstream server-based software packages. This will replace present MQ message processing. Work with JSON messages for ETL processing.

Monitor and investigate tickets for all CRMS based issues.

Tech Knowledge Partners, Lombard, IL I.T. Consultant Aug 2019 – June 2020

SR. PROGRAMMER/ANALYST: Set up and monitor EDI processing for a variety of businesses utilizing Mapics XA and Trustedlink EDI software. Analyze, code, test and implement programs using CLLE, SQL and RPG free-format language including maintenance processes using sub-files.

Design, map, implement and support EDI 810, 850, 855 and 856 data for multiple clients.

Analyze specs, design and create multiple User Exit processes to generate required data for incoming and outgoing EDI documents

Create, test and implement various green screen maintenance processes for managing User Exits and other EDI related processes.

Uline, Pleasant Prairie, WI I.T. Consultant Nov 2017 – Jun 2019

SR. PROGRAMMER/ANALYST: Custom software package. Analyze, code, test and implement programs using CLLE, SQL and RPG free-format language. Mature custom software consists of a mixture of RPG III, RPG IV, and RPG Free code. Modernized database, stored procedures and extensive exchange of data between I-series and other platforms. Use of ROBOT, Control M and MKS Implementer.

Permanent daily POC to receive initial help desk calls for immediate triage for users and interactive/batch jobs. Including rotating after hours POC responsibilities.

Primary EDI developer to design, implement and troubleshoot all transmission and reception of 810, 850, 855 and 856 data via VAN and/or direct FTP transmissions with vendors.

Work extensively with PMs and business holders to design & code RPGLE/SQL applications. Aggressively support UAT, implementation and post-implementation support with user community. This includes projects for Circulation, Finance, and Invoicing.

Catalog Cutover process - assist in bi-annual implementation of new catalog from IT perspective across SYS, UAT and Production environments. Testing and troubleshooting existing applications at each level to ensure the integrity of the systems.

Data Restore process - assist in bi-annual data restore of production data to the SYS and UAT environments. Testing and troubleshooting existing applications at each level to ensure the integrity of the systems.

Bank of America Merrill Lynch, Chicago, IL I.T. Consultant June 2016 – Nov 2017

SR. PROGRAMMER/ANALYST: GMI software package. Analyze code, test and implement programs using CLLE, SQL and RPG free-format language. Analyze existing IT processes and downstream data feeds. Work in conjunction with Project Manager to providing on-going tactical support for new and existing processes. Prepare extensive technical specification documents based on BA requirements.

Collateral Price Variation Process - In depth analysis of pricing processes for multiple Global and Tokyo Closing Price feeds for customer collateral. Design process to monitor day-to-day collateral price variations, produce variation data based on measurement criteria and delivery reports to key business recipients.

GMI Supported/Unsupported Product Reporting Process - Design, code, test and provide support process to produces multiple reports providing detail GMI support levels and restriction codes for traded products. Designed and coded separate maintenance process for establishing and maintaining supported products, support levels restriction codes and firm values. Process runs in both GMI batch and ROBOT jobs

F & O IM/VM Variance Reporting Project – Design, code test and implement processes to issue Margin Variance Report providing fluctuations in daily margin requirements based on type of margin, account type and base currency. Establish database structure and create maintenance process for static records that provide margin day-to-day variance threshold levels based on % change and exact dollar values. Process runs in batch and is also accessible via menu selection.

IPS to GMI Customer Account Interface - Design, code, test and implement modifications to IPS interface processes to update customer account information in GMI software. Modifications will provide the ability to accurately issue customer statements to the correct non-domestic accounts. In addition, this customer information data flows to other downstream applications via FTP.

CREDIT SUISSE, Chicago, IL I.T. Consultant Dec 2014 – March 2016

SR. PROGRAMMER/ANALYST: GMI software package. Analyze code, test and implement programs using CLLE, SQL and RPG free-format language. Analyze proposed strategic business plans impact to existing IT processes and downstream data feeds. Book of Work team member providing on-going tactical support for new and existing processes. Prepare extensive technical specification documents based on BA requirements. Assist colleagues by performing code and test documentation reviews.

CSSEL To CSi Project - In depth analysis of all custom written CLLE, RPGLE and SQL source code to identify and pinpoint all instances where process will require modification to handle conversion of GMI Firm values. Analysis includes all GMI batch processes in GMI based MMRUN and Control M. Document and convey analysis results to PMs and upper management. Modify, test and implemented identified programs and batch processes for GMI Firm conversion.

Pending Cash Upload Process - revise and re-write existing upload process based on new functional specs. Update code from older RPG code to RPG free format, provide new and extensive validations to include the ability for users to interrogate data prior to update. Data movement from IFS to DDL files and present data in XLS format via email.

CDR and OPUS related MQ data feeds - provide backup support for real-time based data transfers and trouble shoot issues.

JP MORGAN, Chicago, IL I.T. Consultant Sept. 2012 – Sept 2014

SR. PROGRAMMER/ANALYST: GMI software package. Analyze, code, test, and implement programs using CLLE, SQL, and RPG Free-format language with an extensive use of RPG prototypes, sub-procedures, embedded SQL and service programs.

Extensive in-depth analysis, design and programming for automated daily data file extraction from CCPs using FTP and SFTP file transfer

Execution of GMI applications in nightly batch processing using VBATCH (similar to GMI based MMRUN processing) for daily CCP extracted files such as Margins, PAI and Rates for LCH, CME, ICE, Eurex and OCC exchanges

Analysis, modifications and support for various in-house trade load processes using MQ and GMI API functions

Regression testing various in-house, batch and GMI processes prior to implementation

Provide code reviews and analysis of full life cycle project documentation prior to implementation by fellow colleagues

DSC LOGISTICS, Des Plaines, IL Sr. Programmer/Analyst Nov 2009 – Sept 2012

SR. PROGRAMMER/ANALYST: Analyze, code, test, and implement programs using CLLE, SQL and RPG Free-format language with an extensive use of RPG prototypes, sub-procedures, embedded SQL and service programs.

Consolidation of Cross Dock orders for Outbound Truck Loads.

Creation and modification of Zebra label layouts and printing functionality

Converting the current Inbound and Outbound processes to use an automated Calendar scheduling process.

Expansion of NMFC code values across entire AS400 system

New manifest creation process for Outbound Truck Loads

I.T. Consulting 1992 - 2009

Contract work providing programming and technical support for clients such Eagle Transport, Whitehall Jewelers, OCE USA, GE Rail Services, Abbot Labs, BA Futures, Schwarz Paper

Education

BS, Business Administration, Illinois State University

Contact this candidate