OBJECTIVE:

To obtain employment with a consulting company for an onsite or remote Sr. IT Lead Consultant as a Technical Project Leader, or Data Architect, or Developer/Analyst. The ability to provide technical expertise in various coding, analysis, and project planning.

SUMMARY:

• Demonstration and facilitates the visualization of the business process for integration and migrations project.
• The design production work process includes automation of data warehousing (ETL).
• Mirroring Production offsite HMC server. BRMS and Disaster
• Rules of normalization databases or SQL views DDL tables or SQL INSERT, UPDATE, and DELETE.
• Evaluations of proposed project specification from an executive management designate.
• Feasibility data is gathering to obtain project estimate cost for services and vendor supplies.
• Marketing study provides baseline projections for supplies and services.
• The company organizational chart provides the analysis to designate business user roles in the SDLC life cycle.
• All object impact analysis to determine object usage, and objects affected by project implementation goals.
• Business rules, operations policies, users’ authorization defined, and documentation of business trading partner’s services.
• All software packages’ current levels and customization programming analyzed for future use. Minor and major components varied based on the projects.
• Obtaining resources that can give the project the skills needed to achieve project agreed upon goals. Technical and general interviews skills needed to understand a consultant skills, knowledge, and personality.
• Confidential DB2 OS/400 I - Series Power with vendors' software package (INFOR ERP LAWSON V7 - V10.1, ISLAND PACIFIC, MEDSERIES, INFININUM, TRUSTED LINK, GENTRAN, etc. to HP SERVER ORACLE DB R3 Architecture using SAP, PEOPLESOFT, TRUSTED LINK, and OPENTEXT.)
• Object Management of i5/OS: SBSD, JOBQ, OUTQ, Servers Configurations via Client Access I-Navigator, LINUX, UNIX, System Performance, Availability, and Business SLAs Communication, and Performance Management tools.
• Software development: ILE concepts in v5 I Power OS; Platform concepts of optimization performance RPG ILE programs using embedded SQL (Create DDL Tables or add records to existing DDS physical and logical files. SUBFILE design with options and function key. (Add, Change, Delete, Search).
• Objects design were usage of activation group, BINDIR, modules, prototypes, and Java programming languages for serving clients since 1991. Collaborate with all levels IT protocol to identify and implement improvement of applications. In most cases mentoring and leader in pointing out potential issues (Pro-active)
• Ability to translate the business changes, workload fluctuations and environmental changes into capacity planning and forecasting to ensure a reliable infrastructure.
• MQ Series middleware exposure to work flow for business processes, error message handling, and creating sender and receiver channels and queues.
• Multiple file transfer from one to many vendors on different operating platforms.
• Written and verbal communication skills, interpersonal skills, interfacing effectively with levels of business community and offshore teams. I-Series programming languages from Expert in RPG ILE, RPG Free, CL, and SQL (Interactive or embedded in RPG programs), DB2 usage in transferring data from or to non- Confidential I-Series Servers.
• Interface methods: FTP, SFTP, FTPs, Microsoft Access, Excel, XML/HTML, RPG ILE, stored procedures, CLLE programs, and APIs

TECHNICAL SKILLS:

GENTRAN, GIS, INOVIS TRUSTED LINK, OPENTEXT, PREMENOS, EDIFACT, SAP IDOCS, and native EDI PROGEN code generator, BCD Products

SYNON COOL 2E - Facilities 1 & 2 Developer and DB NORMALIZATION

INFOR ERP LAWSON LID & GUI Programming and INFOR ERP LAWSON application installs and upgrades releases

INFINIUM HR /FINANCIALS, INFOR ERP LAWSON

ISLAND PACIFIC Software

Microsoft Office Products: WORD, EXCEL, POWERPOINT, and Visual Studio

McAfee HELPDESK, SAP Oracle based Ticket systems, TFS with VB Studio

PROGEN BCD

ERP software specific programming experience:

RPG Tool Box, CLP, QTAATOOLS

HELPSYSTEMS SUITES: RODIN ETL, ROBOT SCHEDULER, SHOWCASE, SEQUEL

EXPERIENCE:

Confidential

IT INFOR ERP INFOR ERP LAWSON ISERIES Consultant

Responsibilities:

• Developed migration programs in RPGLE to populated hybrid INFOR ERP LAWSON DB2 tables for interfaces processing from several event venues. Duties included analyzing objects usage for files, programs, journals, and system objects.
• Review of migration documents per INFOR ERP LAWSON module usage for Financials, Time and Attendance, and Health Managed Services. Evaluation of all FTP processes and recommendations for either platform for off or on premises of AWS or ISERIES Cloud methodologies with possibly of using Salesforces computation for GL.

Confidential

IT Sr. Developer

Responsibilities:

• Assigned to telecommunications company, Confidential, in Richardson TX for their Fiber Auto Assignment project.
• Primary duties were to create source objects in RPGLE (copybooks), SQLRPGLE (service programs with embedded SQL statements, EXTNAME DS, cursor I/O), and SQLRPGLE SUBFILE Maintenance program using SQL I/O on DDL Table. Use of Turnover, TFS, and Visual Basic Studio.

Confidential, White Plains, NY

EDI Manager

Responsibilities:

• Assigned to DANNON North American headquarters in White Plains, NY to provide EDI TRUSTED LINK expertise in resolving EDI backlog issues and current on-going projects for onboarding new Trading Partners such as WALMART, AMAZON, and Dairy on AGILE methodology. Danone, French International Parent, used TRUSTED LINK for Sales orders, invoicing, procurement, and Warehouse transactions. INOVIS OPENTEXT vendor managed services on for HP Operating
• System with Oracle DB using EDI functionality of TRUSTED LINK in SAP. Oracle EBUSINESS Suites tools to managed current EDI processing reports and User Defined Data analytics to govern appropriate remedies for data issues and overlaying R/3 Architecture for current Onboarding projects and outline OPENTEXT managed services implementation versus project timelines and data segment issues.
• The EDI Transactions sets used 810, 812, 850, 820, 824, 860, 875, 876, and 880 including SAP IDOC creations.
• APO business processes for specialized business rules for type of Trading Partner required setup needs.
• Communications protocols AS2, VAN, and SFTP. Trading Partners in North America base of 120 and 50 suppliers.

Confidential, New Orleans, LA

IT Sr. Developer Contract Consultant

Responsibilities:

• Assigned to Confidential primary shipping logistics company that handles freight via shipping vessels, rail, trucking lines, and air cargo as assignee broker for customer.
• Export Department was undergoing a redesign effort to ILE architecture on V7R1 Power Series server.
• The custom design applications in production 10% RPG36 coding and 90% RPGIII source to RPGLE.
• Implementation of SQLRPGLE with embedded SQL using modules, copybooks (RPG source) and prototypes usage for fields attributes definitions for entry parameters, KLIST, and common variable fields names.
• The integrations involved adding audit fields and eliminating the System 36 environment. TCPIP communications interfaces programs using UNIX SFTP scripting
• Confidential copy commands to upload from IFS directory for Confidential Reports and copy to transactional DDS pf or DDL table via qTemp, ACH transmissions for Letter of Credit, and non-EDI documents via interfaces of INFOR ERP LAWSON v7.1 A/P, GL, & A/R modules.
• Redesigned application menu systems from ad-hoc to SOX standards to Data governance, users’ authorizations levels, and programming standards for new development templates in SQL, RPGLE, CLP, CLLE, SQLRPGLE, and bind modules in directory.
• UNIX, and LINUX scripting standards for source code tracking and
• Create deployment plan, implementation solution design using AGILE project planning techniques projects such as Third party screening process to adhere to each federal agencies and international treaties for prevention of shipments to Terrorist organizations both national and international.

Confidential, Greensboro, NC

Sr. Lead IT Integration Consultant

Responsibilities:

• All Server application topologies were created for the current production including EDI Mapping for INOVIS, GENTRAN, TRUSTED LINK, PREMNOS. Plan project strategies with software upgrades and applications solutions for custom programs affected. SYNON, INFOR ERP LAWSON V7.1 to V9.x, JDE ERP, ISLAND PACIFIC, INFINIUM, PKMS, VERTEX with detail object analysis for conversions of RPG36, RPG400, and CL for 6 I-Series platforms.
• Ensure business requirements are incorporated in the technical design using RODIN Help System ETL usage for WMS and DWS to Change Data capture extract, transfers, and load with error management control. Field attribute errors on fields in Db2.
• Lead Application Architecture design of integration process for 10 AS/400 platforms with over 30 various vendors DB2 packages at the incompatible Release Levels; and table fields with DB normalization by Primary and Foreign Keys designated in fields in fields to connect record event lifecycle. HELPSYSTEMS utilities and RODIN management of ERRORs capabilities were used in the automated processes of unit and user testing prior to implementation.
• This usage provided production input in data model design restructuring when modified in the development stages.
• All programs redevelopment was inclusive on project plan to assist offshore team’s development in ILE concepts.

Confidential, Oklahoma City, OK

Series Software Developer

Responsibilities:

• I-series development in RPG ILE, embedded SQL in RPG & CLLE (RUNSQL, and RUNSQLSTM).
• Sub files development for Dog Show Final internet result file. RDI, I Director, Confidential development for internet show entries for participants such as dog owners/Trainers/Jr Show handlers.
• Mentor staff on new sub file designs for options (change, delete, and display records) and function key usage for adding records, field prompting F4, and F5- refresh screen.

Confidential, Washington, DC

Data Mapping Conversion Consultant

Responsibilities:

• Business analysis of current Med Series 4 V2K HR/Payroll/Benefits Physical files compared to PeopleSoft V9.1 HCM Oracle tables for HR/Payroll/Benefits.
• Creation of data conversions programs to generate flat or non-delimited files to populate the appropriate PeopleSoft Oracle Databases.
• Data base normalization rules were checked, confirmed via table structure analysis. (1 to 1, 1 to many relationships as it applies to Parent to child/children or dependency tables to file fields correlation for dependent file fields for business rules integrity for records additions, maintenance (updates and deletions).
• These DB2 business rules were implemented in the program logic of all the RPG ILE, and the CL conversion programs handled the automated process to convert, populate flat files as IFS stream files, and transfer via V7R1 platform (FTP UNIX scripting) to the Oracle DB2 tables.

Confidential, Sioux Falls, SD

Sr. SYNON Cool 2E Data Mapping Consultant

Responsibilities:

• Analysis of all SYNON PRODUCTION objects for Confidential and their dependencies.
• Created test environment which should parallel production current environment.
• Convert SYNON generated RPGIII programs to RPG ILE V6R1 syntax.
• Eliminated Object dependency on all associated SYNON references or dependencies.
• Convert common subroutines to internal prototypes/modules.
• Use of Built-in-Functions replace numerical indicators for HI EQ LO values replaced with %EOF, %EQUAL, %FOUND, etc.
• Date calculation where restructure for %Date, %Time.
• Etc. Mapping legacy files field’s definitions (1992 versions) to .net db2 tables for windows frames.
• Data base normalization rules applied to the ILE program automated CL process for table population for Data Dictionary, Reference, and transaction files. Use of Turnover and Hawkeye.

Confidential, Oklahoma City, OK

Lead Senior I-Series Systems/Application Engineer

Responsibilities:

• System Management - Authorizations, User, Display, Printer, Writer, Users Setup, FTP/TCPIP communications configurations. Software Development/Maintenance - WDSC, RPG ILE, CLLE, Service Programs, APIs, BCD PROGEN WEBQRY DB2, and SQL (Embedded and Interactive).
• Project Management V5R4 to V7R1 (3/11), Date field conversions, and Standards for program architecture design, database normalizations standards, unit testing, user testing, and implementation. Mentoring: System Admin, CL programming, FTP scripting and AS/400 Concepts. (Open)1 project SQL Usage in V7R1 Operating System - 2012 1.
• Implemented Embedded SQL in RPGILE programs (Reduced Files in F-specs, avoid locking issues, elimination of I/O hits, and eliminating OPNQRYF command usage) 2. Utilized RUNSQLSTM in CLLE programs and SQL Statements in a Source Physical file...View. Cyber Security, Administration, Oracle PeopleSoft help desk, Design programming and project specifications. Liaison between Executive Director and three deputy directors.
• Collaborated with OBON IT Security Officer to review existing security policies and develop new policies as needed while conforming to the Office of State Finance’s published Information Security Policies, Procedures, Guidelines, for the security of sensitive data.
• Audited security logs as specified in IT Security Policy
• Evaluated security needs when/if new technology or services were added.
• System and Application Support
• Maintained the integrity of the Confidential I-Series (AS/400) platform Hardware and Client Devices; analyzed performance of disk drive and CPU through-put; customized devices based upon functionality and user requirement; supported the i5/OP Operating System and network; maintained PTF levels and i5/OS software compatibility; administered the TCP/IP protocol.
• Administered and managed the DB2 Universal Database for I-Series.
• Managed User Access to the ISERIES; modified and controlled user profiles based on personnel changes; maintained application software and data access using i5/OS authorization rules; installed, upgraded and maintained MS Windows Client Terminal and printer emulations; verified security and authority of external access through VPN, FTP, etc.
• Modified and maintained Application Software using PROGEN-PLUS program generator; developed, coded and implemented new Applications using ILE and RPG compilers; developed and implemented data-sharing functions between DB2.
• Developed and maintained custom developed software
• Created and tested: user data entry screens, reports, query and navigation tools, preprocessors and edits, procedures for database loading and verification (as well as for database updating), procedures for periodic re-indexing (adding fields or edits, software version upgrades, etc.); performed backups and restores; debugged problems.
• Business Process Enhancements
• Developed and implemented business policies and procedures.
• Analyzed, recommended, and developed work flow tools, automation, and improvements to existing hardware and software architecture.

Confidential, Oklahoma City, OK

Sr. AS/400 Software Developer

Responsibilities:

• Maintained and designed new RPG ILE software for the Oklahoma Board of Nursing. The current applications are in RPG III and RPG ILE. RDI development I - Director
• Redesigned programs to the current version of RPG for V7R1.
• Utilized FTP and stored procedure processing to download and upload files to several state government agencies.
• Utilized embedded SQL RPG ILE programs using RPG Free.
• Data handling of error messages and user support tickets.
• Performed AS/400 administration duties such as user profiles, job descriptions, operating/system commands, and system job scheduling, menu authorizations, and printer setups using Client Access.
• Created tables and indexes using SQL and DB2/400.

Confidential, Atlanta, GA

Sr. RPG/EDI Developer

Responsibilities:

• Maintained applications for EDI transaction types 204, 214, 490, 497 for warehouse development using RPG ILE and CLLE.
• Mapping in Premenos and Gentran.
• Modified current process to develop a virtual warehouse between the Portland, Oregon site to the Atlanta site for real time Comparison of shipment acknowledgements and inventory control locations of product for Johnsonville, Smithfield, and Pinnacle.
• Developed a virtual warehouse between Portland, Oregon site and Atlanta, GA site for real - time comparison of shipment acknowledgement and inventory control
• Utilized Microsoft PowerPoint for object analysis and data flow.

Confidential, Bondurant, IA

Sr. AS/400 Software Developer

Responsibilities:

• Expanded location and sales fields in their database system. In addition to replace and OPNQRYF commands with embedded SQL/400 in RPG ILE free form.
• Unit testing required verifying current results with enhancements.
• Microsoft Office, Lotus Notes, Windows XP Professional, Citrix, Visio and Adobe Acrobat 8 Standard software, RDI Editor Web Studio Development, and Turnover change management.
• Redesigned the entire sales process for data entry (Interactive) as well as day end, and month end batch process.

Confidential, Dallas, TX

INFOR ERP LAWSON Series Consultant

Responsibilities:

• Creation Created??of copybooks, Stored procedures, Green screen Subfield displays, BRMS backups, RPG Free, Embedded SQL, INFOR ERP LAWSON objects: PRNT and SCRN, CLP, WebSphere (WDSC), RDI Editor, QSHELL commands, CL and RPG ILE modules and object calls to Intranet and Internet web services.
• Performance Tuning and RPG ILE programs.
• Created INFOR ERP LAWSON program types of B, M, and E.
• Designed interfaces using FTP and the IFS drive to upload and download data to clients as well as Informatics sever. WDSC development for clients with several version of INFOR ERP LAWSON 7.25, 8.1, to 9.1.0.0 release.
• Installed BSI Tax factory, Technology Patches, ESP 7 and INFOR ERP LAWSON application patches.
• Created data conversion programs for version 7.x to 9.0. Created INFOR ERP LAWSON user profiles and various administration setups for menus and options.
• Utilized Hawkeye and Implementer for object usage and change management system.
• Install Upgraded?? INFOR ERP LAWSON Version from 7.0x to 8.25 to 9.X for all clients

Confidential

Sr. INFOR ERP LAWSON Technical Consultant

Responsibilities:

• Customized INFOR ERP LAWSON version 9.0 based programs for HR, AP, PR, BN and GL.
• Utilized COPYBOOK, PRNT, SCRN. CLP, COBOL, and RPG ILE programs. Created INFOR ERP LAWSON program types of B, M, and E.
• Designed interfaces using FTP and the IFS drive to upload and download data to clients as well as INFORMATICA server. I have worked with several clients from version 7.25, 8.1, to 9.26 releases.
• Installed BSI Tax factory. Created data conversion programs for version 7.x to 9.0.
• Created INFOR ERP LAWSON user profiles and various administrationsetups for menus, authorization, batch processing, system commands.
• Utilized Hawkeye and Implementer for object usage and change management system.

Confidential, Honolulu, HI

AS/400 Software Developer

Responsibilities:

• Designed conversion programs for the 10.1 release for claims processing
• Maintained and developed programs in RPGII, RPGIII, COBOL and RPG ILE. Operating languages were in OCL and CL.
• Utilized SQL and DB2 for table development for FTP transfers and report processing.
• Designed new applications using Progen for sub files development.
• Utilized Aldon, RDI Editor and Hawkeye for Change Management and object usage tools, respectively.

Confidential, Denver, CO

AS/400 Sr. Analyst

Responsibilities:

• Developed new software applications in Free RPG ILE, RPG4, CL, RLU, SDA, DB2, WDSC, RDI Editor, IFS, DB2/400 and SQL. Mentored programming staff on development concepts and database relationships in regards to FTP transfers, SAP, ERP JD Edwards V8.0and several phases of interface development from vendors and clients.
• Designed the current invoicing process along with Electronic Funds Transfer for Draft Notices.
• Redesigned Split Load process for haulers and refineries.
• Developed SQL procedures to generate Crystal reports.
• Utilized Implementer Change Management tool.

Confidential, Minneapolis, MN

Sr. Technical Consultant

Responsibilities:

• Installed INFOR ERP LAWSON software for upgrades and releases for current and new clients.
• Created new RPG ILE, RPG4, IFS, RLU, SDA, COBOL batch processing and CL programs as well as modifications for client
• Analyzed customer systems on the AS/400 for technical and system assessments.
• Worked with INFOR ERP LAWSON modules for AR, AP, HR, Benefits, and Asset management.

Confidential, Dodge City, Kansas

AS/400 Technical Architect

Responsibilities:

• Provided technical and consulting services to install INFOR ERP LAWSON Financial package from Release 7.2 to 8.1.
• Installation of LID (GUI), IFS and desk top web portals.
• Created three AS/400 environments and 9 product lines for production, test, and development.
• Assisted in functional training in the HR/Payroll ERP.
• Created data conversion programs in RPG ILE using service programs with embedded SQL and CLLE programs.

Confidential, Framingham, MA

Sr. EDI AS/400 Consultant

Responsibilities:

• Provided technical and consulting services support for validating and verifying 856 inbound transactions for 25 vendors who were currently not using GENTRAN EDI for " Pick and Pack" transactions.Communications were setup with vendors in regards to testing, notification of errors, element modifications.
• The vendors Setup of accepting outbound 824 application advice after receipt from Confidential .
• Data set transactions sets, use DBU (Data Base Utility), RPG ILE, RPG4, IFS,CLP and AS/400 queries to partition out segments and compare them with Confidential EDI requirements.

Confidential, Memphis, TN

CasinoAS/400 Consultant

Responsibilities:

• Designed manual testing procedures for AS/400 in the following locations: Las Vegas, Reno, and Atlantic City.
• Utilized Test Director and Win Runner.
• JD Edwards HR modification testing for RPG customized programing
• Created test scripts for accessibility to the Casino Management System based on user authorization.
• Designed AS/400 programs and CLP programs to alter workstation IDs and accounting information data for pits, group levels and Markers.

Confidential, Boston, MA

Sr. I-Series Developer

Responsibilities:

• Maintained APIs, sockets, DB2, WDSC, RPG4, and RPG ILE programs on software development.
• Assigned as Sr. Software Developer. All development work was for their ERP financial Prism systems.
• Heavy Jobs Upload transactions, Cost Ledgers, Cost Reports, Man - hour process, CSI Master Code screens for code listings, and Cost Recovery programs for equipment and quantity usage.
• All apps were written in RPG ILE and CL.
• Over 90% of all applications were new development. PROGEN was used for interactive screens for Data entry.
• Implementer and ALDON used for Change Management Tools in different system environments.
• Participates in development of requirement specification docs to identify and doc business requirement and objectives for software mods of the Parson Payroll system.

Confidential, Wilkes-Barre, PA

I-Series Programmer/Analyst

Responsibilities:

• Designed new APIs, RPG4/RPG ILE programs, sockets, Sub - procedures, Java objects bounded to RPG ILE service programs and prototypes for Cingular Wireless.
• Provided general QC/QA support for each new and production releases.
• Assisted designers for new release development by analyzing current production requirements and providing input on new create specifications.
• ALDNON and Hawkeye to create tasks and work list for each individual KINTANA/project objects.
• Reviewed system design documents, revalidated previously defined business processes, and defined acceptance test criteria.
• Reviewed requirement and design documentation and developed test scenarios, test plans, test scripts, test conditions and test data.
• Executed acceptance test and documented results.
• Submitted test results for review and approval, analyzed the results of the test and documented test scenarios, test scripts and test condition.
• Reviewed program specification documents in order to validate the accuracy of those documents.