Rebecca Coleman

Elmhurst, IL *****

630-***-**** adxpm8@r.postjobfree.com www.linkedin.com/in/rebecca-o-coleman

Professional Profile

Senior Business Systems Analyst, with over 30 years of experience in manufacturing in the electronics, food, publishing, hospital, and retail industries. Dedicated and talented Information Technology professional with extensive background in business applications solutions and relational databases. Skilled in analyzing problems, designing, and implementing solutions. Evaluate business requirements and identify areas for development. Suggest technical solutions to automate and improve business processes and provide recommendations for systems software. Help company stay technology competitive. Personable and knowledgeable with the ability to communicate effectively with the user community, as well as peers and management. Highly motivated to learn and apply new technical solutions and skills.

Core Competencies

Business and Systems Analysis

SAP ABAP ALV reports

ERP Conversions and Integrations

API’s

Toad for SAP

Microsoft SQL server

Data Analysis

DB2 relational database

MS Office Suite

TL Ashford and BarTender Label software

SDLC (Software Development Lifecycle Methodology)

RPGIV, RPGLE, RPGLE sub-procedures and service programs, RPG Free format, CL, CLLE, SQL400, Embedded RPGLESQL, QSHELL

Turnover, Aldon, Hawkeye, Abstract, RJS, Townsend FTP, Robot, Optio Forms, Eclipse

AS/400, iSeries, IBM System I, System I Navigator, IBM WebSphere,

Professional Experience

CTS CORPORATION, Lisle, IL 02/2012 – 02/2023

Manufacturer and designer of electronic components, sensors, and actuators in North America, Europe, and Asia.

Senior Business System Analyst (2018 – 2023)

Provided technical support to the SAP functional team during and after the implementation of SAP S/4HANA.

Responsible for all legacy data extractions. Created RPGLE programs for legacy delta data tracking.

Created RPGLE interface programs from SAP as needed. Including RPGLE interfaces to legacy bar code software (TL Ashford) and stand-alone accounts receivables software (Blackline).

Assisted the PTP functional team with SAP data loads, including working with users to cleanse legacy data and load legacy data to the IDDS upload templates.

Assisted the OTC/EDI functional team with tracking of test data, verifying, IDocs, EDI orders, and Scheduling Agreements.

Created Excel reports using Toad for SAP as needed.

Created ABAP ALV reports as requested. Sales Order and Customer notes report recognized as a valuable tool in the user community.

Performed analysis and maintenance of custom ABAP ALV reports.

Participated in meetings with overseas SAP development team.

Senior Business System Analyst (2015 – 2018)

Primary focus was PRMS ERP support of the Electronics components business unit, including financial, manufacturing, and supply chain business areas.

Worked with the business user community to define business system requirements and solutions.

Facilitated monthly status meeting with business managers to discuss projects, support, and other issues.

Developed business applications as needed. Including RPGLE applications such as embedded SQL program to create Excel pivot tables, SFTP application using QSH commands and the IFDS, APIs calling Java classes, creating SQL user defined functions.

Participated in multiple PRMS ERP integration projects, including Visual and M2M ERPs to PRMS.

FRESH EXPRESS (CHIQUITA BRANDS), Franklin Park, IL 2006 – 2012

Leading producer of fresh salads. Wholly owned subsidiary of Chiquita Brands International.

Senior IT Analyst

Supported the ERP PRMS Order Processing, HR, Payroll, Financial and Shop Floor applications. Also supported Kronos Timekeeping software.

Gathered user requirements and presented their requirements to technical managers. Wrote detailed technical designs and technical review of design with users.

Modified and created new RPGIV and ILE applications, conducted code reviews, wrote detailed test scripts and other technical documentation for SOX compliance.

Participated as a team member of PRMS HR to Workday HRMS conversion project.

Exposure to Enterprise Service Bus, Web services, XML, and SOAPUI.

Prior Experience:

LEVY HOME ENTERTAINMENT, Hillside, IL, Senior Programmer/Analyst

ARCHIBALD CANDY CORPORATION (Fannie May Candy), Chicago, IL, Senior Programmer/Analyst

COSTCO WHOLESALE, Issaquah, WA, Application Developer

BRITANNIA SPORTSWEAR (Levi Strauss & Co.), Renton, WA, Programmer Analyst

ST. JOSEPH HOSPITAL, Albuquerque, NM, Computer Programmer

Education

General Studies, 2 years, University of New Mexico, Albuquerque, New Mexico

Computer Information Systems Diploma, 18 months, Albuquerque Technical School, Albuquerque, New Mexico

Contact this candidate