Download PDF

CustomSmall

CustomSmall

CL CODE EXAMPLE

IP Address

PGM PARM(&DEV &IP)

DCL &RCVVAR*CHAR 2048

DCL &VARLEN*CHAR4 VALUE(' ')

DCL &DEV     *CHAR10 VALUE(' ')

DCL &IP*CHAR15

DCL &ERROR*CHAR180

IF COND(&DEV *EQ ' ' *OR +

%SST(&DEVICE 1 1) +

*EQ '*') THEN(RTVJOBA JOB(&DEVICE))

 CHGVAR VAR(%BIN(&VARLEN)) VALUE(2048)

 CALL QDCRDEVD PARM(&RCVVAR &VARLEN+

'DEVD0600' &DEV &ERROR)

 CHGVAR &IP VALUE(%SST(&RCVVAR 878 15)) 

EOJ: ENDPGM

SQL DATE EXAMPLE

SELECT DATE(NEXT_DAY('05/08/2009', 'MONDAY'))

FROM SYSIBM/SYSDUMMY1

Returns a date of 05/11/09

SQL EXCEPT EXAMPLE

to check if both tables are identical

SELECT FROM TBL1

EXCEPT

SELECT FROM TBL2

UNION

SELECT FROM TBL2

EXCEPT

SELECT FROM TBL1

FTP SCRIPT  EXAMPLE

ftp  s10a4155

userid password

cd lcust

put /lz01/DEV/ARPH  lcust/xhdr.xhdr(append

put /lz01/DEV/ARDT  lcust/xdtl.xdtl(append

put /lz01/DEV/ATXT  lcust/xtxt.xtxt(append

quote rcmd sbmjob cmd(call pcust/c85200)

quit

Summary

  •  
    • Efficient IT professional with over 18 years experience on AS400/iSeries, strong analytical, issue resolution and creative problem solving skills.
    • Extensive experience in multiple business environments: health care, financial and accounting systems, e-commerce, pharmaceutical and manufacturing industries.
    • Extensive experience with RPG/ILE, CL, DB2/SQL and 3rd party software.
    • Lead Developer on migration to and from the AS400, building cross-platform interfaces and data conversions.
    • Proven expertise in all stages of applications development, legacy systems support and system integration including architecture, design, development, testing and implementation
    • Ability to work on multiple projects and effectively prioritize and execute tasks in a high-pressure environment

HARDWARE/SOFTWARE:

IBM AS/400, PC, OS/400 V5.R4, QUERY/400, QM Query, QMQRYF, OPNQRYF, XCOM,Implementer, ALDON, Hawkeye, SDA, DBU, DFU, IQ, SUBFILES, OVLU/400, DataPlus3, HP Open view, Sequel, Serena Release Management.

.

LANGUAGES:

RPG, RPG ILE, CL, DB2/SQL  

CustomSmall

CustomSmall

MY CODE EXAMPLES

SQL ROLL UP, CUBE

Select coalesce(unvnam,'Total'), unvnam,coalesce(unvarct,'Subtotal)unvarct, count(*) countFrom gs4r5lib/arecunrc Where unvarag between 4 and 30Group by unvnam,unvarct WITH CUBEOrder by unvnam

Work History

Mar 2013Present

SSE

UST Global

SSE for Independence Blue Cross

·   24/7 Power MHS system support and enhancements.  System Handles:

  • Member enrollment and service
  • Benefit administration and premium billing
  • Provider management and reimbursement
  • Utilization management
  • Claims adjudication
  • Financial management
  • Reporting

·Lead developer for Contract to Calendar year enrollment conversion, member migration/termination.

Multiple tasks related  to Affordable Care Act support and synchronization (HCR

Jan 2011Feb 2013

Senior System Engineer

Randstad/eBAY/GSIT

·Lead developer of custom automated JDA/Credit Card processors reconciliation for

eBay/GSIT

·System provides analysis of the possible source of not reconciled transactions: failed settlements, ISD/ACI rejected settlements, exchange rate variances, etc. Procedure drills down to order shipment sequence level and split tenders.

·Architecture, technical design and gathering requirements from Credit Cards Processors - American Express, Bank of America, First data, PayPal, Bill Me Later.

·Daily, weekly detail and average reporting tool to analyze reconciled and not reconciled transaction.

Positive pay for PNC programmnig.

2010

RAS support specialist

Collabera/Accenture

·Responsible for Pfizer Revenue Accounting System Support. System handles:

Sales, Order and Inventory Accounting

Reconciliation between Order management, Polaris/Hyperion and Computron/Sun G/L

Cost maintenance and sales reporting

Product movement (sales, returns, write-offs) into accounting instructions for G/L

Intercompany product movement (IPM)

·Extensive use of RPGILE, CL, SQL, QM

20032009

Senior Programmer Analyst

Commtech Services Inc

·Responsible for full system lifecycle including analysis, coding, testing, and implementation of components for new and existing custom systems: Order Analysis, Sales, Commissions, Bonuses, Quote Entry for Lutron Electronics, Inc

·Participated in the development and implementation of series of applications to add new manufacturing facility to Lutron and incorporating it into JD Edwards.

·Designed and implemented Interbranch Orders analysis programs for assessment and G/L

manual adjustments.

·Developed Project Costing programs to integrate service expanses into G/L

·Coded, implemented and supported custom Credit Collection Management module to

streamlinebusiness-to-business and/or business-to-consumerCollections on past due

accounts.  System improved cash flow and collection performance by 20%.

·Developed, implemented and supported applications to control Orders fulfillment, Open

orders, Open invoices, Discounts and Auto write-offs.

·Created Commissions Evaluation tool to track the commissions paid versus sales revenue.

Procedure drills down to the region, contract, product class and sales representative level.

·Developed and enhanced Sales Journals, Corporate sales, Commissions and Discount reports and G/L audits

·Architected, designed and implemented robust ETL system to integrate VB based Quoting Tool data into JDE. System extracts, converts transfers and loads Quota data into JDE format order. FTP script and AS400 job is initiated from Quoting software

Over 75K quotas successfully processed since deployment..

·Developed and Implemented interfaces between 3rd party software and JDE.

·Developed numerous custom applications to pull data from JDE to help streamline the month/year-end closing process.

·Created and supported programs to monitor and track daily Sales Journals., Invoice printing and Quote data transfer executions.

·Applied CUM13 local enhancements for existing JD Edwards A 7.3

·Programmed additions to JDE A 7.3 base package functionality. Modules include Invoice Reprint, Transfer order entry for configured items, Custom systems data load.

·Coded and implemented upload and local exit validation programs for JDE Item configurator

·Designed, developed and delivered custom utilities for in-depth analysis and evaluation of

source code, libraries and files to field level, IQ, DREAM Writer and World Writer

·Extensive use of RPG, RPG ILE, CL, SQL, FTP

19982003

Senior Programmer Analyst

Alliance Consulting

·Responsible for redesigning, coding and supporting of new custom Worldwide Sales system for     Wyeth Pharmaceutical.

·Developed and implemented Price volume analysis package to analyze company performance

 based on sales, pricing, volume, exchange rate fluctuations and other factors. Package is

            used to identify seasonal or recurring trends for statistical analysis and graphical

            interpretation.

·Corporate reports for sales analysis, budgeting, and forecasting.

·Discontinued products metrics and reports.

·Developed, enhanced and supported numerous programs, reporting tools and interfaces

covering all aspects of the business including Product Structure, Accounting, legacy

Corporate pricing, Sales.

·Rewrote Data Tracker load module to cut processing time by 25%.

·Designed and implemented programs to automate and execute cross platform interfaces

and data interchangebetween multiple AS/400, PC and UNIX based applications.

·Participated in all phases of migration from AS400 platform to SAP.

·Outlined and interpreted system functional requirements and specifications on existing

AS/400 to be implemented on new SAP platform

·Recommended, architected, developed and implemented custom FTP based Data Collection

System (DCS). Utility installed at various Wyeth affiliate sites with the objective of

consolidating financial data in one central location. Collected data was loaded to SAP

Data Warehouse (BW)

·Automated DCS extracts, transfers and controls data load to AS400. RPG, CL and FTP source code is extracted from AS400 to PC (FTP) and send as e-mail attachment to affiliate sites. Received source code from PC is loaded to remote AS400 via FTP.

·Performed Year 2000 renovation and Euro currency conversion on existing applications

·Extensive use of RPG, RPGILE, CL, SQL, FTP

19961998

Programmer Analyst

ACS, The Reorh Group

·AsIBM team member participated in migration from M/F to AS400 for SKF (Svenska Kullagerfabriken) - the largest bearing manufacturer in the world.

·Worked on technical design, development, system integration testing and implementation of

Sales Company Service System for SKF.

·Responsible for development and implementation of system functionality including Order

Entry, Order Processing and Maintenance, Pricing, Invoice printing, Invoice journals,

Consolidated invoice reports, Stock analysis and shared availability, Forecasting, D&B

Financial.

·Developed interfaces, Data transfer, Data conversion and Data validation modules to upload

M/F databases to AS400.

·Coded, implemented and supported system to extract, upload and validate daily transactions

to synchronize M/F and AS400 data utilizing XCOM and custom software..

·Created programs for Invoices and forms printing utilizing Omni forms software and OVLU

·Performed unit testing using Oracle

·Provided technical support to users to resolve application issues.

·Extensive use of RPG, CL, SQL, QM Query, System Utilities and XCOM.

Jul 1995Nov 1995

Programmer Analyst

System Task Group

·Performed all phases of business analysis, design, coding, testing and implementation

of statistical reports and interactive programs for Medco Behavioral Care Corporation

using RPG, CL and SQL.

·Created and maintained comprehensive documentation outlining user specifications, business

       processes, functional specifications and system recommendations utilizing MS Office and  

        Visio.

19931995

Programmer Analyst

Info Source

·Responsible for development and implementation of interactive and batch software.

·Developed programs for A/P System.

·Modified Inventory Control programs to analyze, forecast and maintain an accurate status of

the inventory level.

Education

Sep 1969Jun 1974

BS

Frunze Polytechnic University

Skills

Special training
Special training with WIA and Tigrent learning: Mortgages and Discount Notes, Real Estate, Business Financing and Factoring, Trading and Cash flow Options, Asset Protection, Creative Finance  
RPG, RPGLE, CL,SQL