Profile

Dedicated IT professional with over ** years of experience in the Information Technology field in the Pharmaceutical, Manufacturing, Distribution & Finance sectors, specializing in IBM Midrange system “IBM i” (AS/400, System i, iSeries) and System/38.

Skills Summary

Language/Technologies: RPG free, RPG CGI, CL ILE/400, COBOL ILE/400, MQ-Series, SYNON 2E, DDM files, Database Triggers, Journaling, API’s, HTML, CSS, JavaScript, Web Services, XML, IBM HTTP/Apache server.

Complex SQL Queries, Embedded SQL, Stored Procedures (RPG and SQL).

RDi, System i Navigator, IFS, Client Access, PDM, SDA, DDL, STRSQL, SEQUEL.

Web technologies like PHP, Web services (SOA), WSDL2RPG, LIBHTTP.

Change Management Software: Aldon, Implementer, Thenon and Turnover.

Databases: DB2/400, MySQL, SQLite

Hardware Platforms: IBM i, IBM PC, PDP 11/34, iPhone

Operating Systems: OS/400, WINDOWS, UNIX, iPhone OS.

Software: JDA, JDE, PRISM (MARCAM), SYNON/2E, SEQUEL, OptioDCS, SpoolMail, Excelerator, Hawkeye, QuickBase, MAC-PAC.

Trained on SAP BI.

iPhone Programming: Objective-C, Swift, X-Code, WatchOS, icon and screen design using Sketch, CORE DATA.

Currently seeking the AWS Solution Architect certification.

US Citizen

Experience Highlights

System development, application system analysis, design, programming, and technical management on many applications and application categories.

Support full life cycle of projects, from requirement gathering, design, develop, test to implementation and support.

Expertise in troubleshooting and resolution of application issues (batch or interactive).

Proven expertise with complex, large-scale applications at Fortune 100 companies.

Collaborate with business, technical and cross functional teams in evaluating end-user requirements and applying to complex information management solutions.

Strictly adheres to client coding, style, documentation standards and project processes on all projects to ensure maintainability and continuity of all code produced.

Experience with multiple development platforms and programming languages.

Expertise in iSeries administration and support

Provide project leadership, guidance and mentor team members

Well versed in Agile and Waterfall methodologies

Excellent verbal and written communication skills

Worked on SOX compliant projects.

Have ventured into iPhone applications.

Education

MS in Physics- Electronics, Bombay University, India.

Professional Experience

SAM MORE Inc. Buffalo Grove, IL (President-Self Employed) Feb 1997 to Current.

ASI Partners, Fremont CA. (Part time, remote)

JDE Sr. Consultant: Assisting client with customization of their JDE 7.3 for their customers. Working on analysis and customization of A/P, A/R, Purchasing, Sales Order, and Inventory systems. Project involves use of RPG, CL and use of JDE tools such as SAR, SDA, RDA, SVR, DW, VO, DD, and UDC.

Modify existing programs and create new programs using JDE standards. Use of FTP, to upload reports to PC folders as well as to web page in Excel and HTML formats. Used Dream Writers for reports.

CVS Health, Buffalo Grove, IL. Jul 2018 to Dec 2019.

Advisor, Application Development: Technical Lead/Project Owner

Provided project leadership to off-shore and on-shore tech resources.

Project involved use of RPG/ILE (RPG/free), Embedded SQL, RDi 9.5, X-Analysis 12 and Synon 2E. Required full understanding of CVS proprietary PBM system, to do modifications.

Projects included:

Parallel Processing with Anthem – During Anthem acquisition this key project ensured syncing the Anthem data from CVS IBM i to Anthem IBM i. Designed innovative way of using journals from source system to apply those on target system.

Kansas City Spenddown – The project was for Medicaid of Kansas City. The modification was to maintain the Real time accumulator against the Spenddown amount received.

Delta Adj Report modification – Stop report going in Email to Client.

Mock Claim modification – R76 and R70 error – Pre-Authorization and Non-Formulary drug errors should show together.

Remove Soft Calls from CDH module – To do better x-analysis.

SAM MORE Inc. Buffalo Grove, IL (President-Self Employed) Feb 1997 to Current.

Provided Consulting services to:

CDW, Vernon Hills, IL. Mar 2015 to June 2018.

Sr. Consultant: Analysis, Design and Development.

Projects included:

Wrote application to calculate Standard Cost and update Item Master (previously done in excel). Now standard cost is accurately calculated and is available daily.

APPLE device enrollment. Wrote external interface with APPLE server using web API’s.

Saved significant freight costs by checking for item weight and directing package to appropriate carrier.

Used embedded SQL to replace legacy database access code.

Conversion of old database files to new database tables.

Projects involved use of RPG/free including RPG service programs, modules, CL/ILE, Stored Procedures, Embedded SQL, RDi 9.5 and X-Analysis 12.

FTD, Downers Grove, IL. Oct 2014 to Mar 2015.

Sr. Consultant: Analysis, Design and Development. Worked on projects including Expand Codification for Member Extract and Future Delivery Date. Developed various modules including Create Member Definition, Delayed Response Penalty Fee assessment on AS/400 (System i). Project involved use of RPG/free including RPG service programs, modules, CL/ILE, CGIDEV2 to create XML files into IFS folder and Embedded SQL.

CRATE AND BARREL, Techny, IL. Nov 2012 to Aug 2014.

Sr. Consultant: Analysis, Design and Development of Data Warehouse System on AS/400 (iSeries). Also worked on about 20 other projects like WMS package interface, Financial Reporting, Virtual Inventory and Executive reports. Project involved use of RPG/ILE (RPG/free) including RPG service modules, CL/ILE, consuming web services with WSDL2RPG and Embedded SQL.

DICK BLICK HOLDINGS, Highland Park, IL. Aug 2011 to Oct 2012.

Sr. Programmer/Analyst: Analysis, Design and Development of Sales tracking and Analysis System on AS/400 (iSeries). Project involves use of RPG/ILE (RPG/free) including RPG service modules, CL/ILE and Embedded SQL. Re-written nightly process to improve data transfer between iSeries and stores in the nightly process.

Extensive knowledge of steps involved in converting IBM OS V5R4 to V6R1.

Supporting and maintaining various modules of Retail Merchandizing system (JDA).

FOLLETT HIGHER EDUCATION GROUP, Westmont, IL. Oct 2010 to Aug 2011.

Sr. Consultant: Analysis, Design and Development of Performance improvement of College Textbooks Rental System on AS/400 (iSeries).

ASI Partners, Fremont CA. (Part time, worked remotely) Aug 2010 to Dec 2013.

JDE Sr. Consultant: Assisting client with customization of their JDE 7.3 for their customers. Working on analysis and customization of A/P, A/R, Purchasing, Sales Order, and Inventory systems. Project involves use of RPG, CL and use of JDE tools such as SAR, SDA, RDA, SVR, DW, VO, DD, and UDC.

Modify existing programs and create new programs using JDE standards. Use of FTP, to upload reports to PC folders as well as to web page in Excel and HTML formats. Used Dream Writers for reports.

FOLLETT HIGHER EDUCATION GROUP, Westmont, IL. Jan 2010 to May 2010.

Sr. Consultant: Analysis, Design and Development of College Textbooks Rental System on AS/400 (iSeries). Typical project involves use of RPG/ILE (RPG/free) including RPG service modules, CL/ILE and QUERY/400, SQL/400, MQ-Series, and Embedded SQL. Development of interfaces between eFollett and AS/400 order processing system (JDA) using web services.

ABBOTT LABORATORIES, Abbott Park, IL. July 2000 to Sept 2009.

Worked on administration, analysis, design and development of various projects on AS/400 (iSeries). Typical project involved use of RPG/ILE (RPG/free) including RPG service modules, CL/400 and QUERY/400, SQL/400, MQ-Series, and Embedded SQL for development.

Single handedly worked on enhancements and support of TRACER – financial project tracking system. Main responsibilities included iSeries administration and application support.

One of the interfaces pulls data from TRACER on System I and pushes it on to the QuickBase database on the web (using PHP) as a daily scheduled job.

Follow SOX guidelines for documentation and processes.

Conversion of Labor Automated Reporting System (LARS) from green screen application to Web using RPG CGI, HTML and JavaScript. Java servlets, JSP, XML and XSLT.

Being a “validated system”, understand and follow strict guidelines and procedure imposed by FDA (Abbott) for documentation and processes.

KRAFT FOODS, Northfield, IL. Feb 1997 to May 2000.

Worked on design and development of various projects involving enhancements to the Resource Management, Planning, Procurement, Finance and Activity Costing modules of the Enterprise edition of the ERP software package PRISM (Marcam).

Typical project involved use of DB2/400, triggers, APIs, RPG/ILE, RPG/400, CL/400, QUERY/400, SQL/400, Embedded SQL and SEQUEL for programming.

Developed Web application (Self-Assessment for Plants) using AS/400 HTTP server, RPG CGI programming, API’s, Net. Data, HTML and Java Interface between PRISM and Shop Floor Production Management system (MATRICS) on AS/400 involving transfer and analysis of data related to schedules and Production receipts. Used DDM files and database triggers.

PRISM Data Warehouse project. Extraction of Resource Usage data and XCOM to the mainframe

Computer Discoveries Inc. Geneva, IL (Consultant) Apr 92 to Feb 97

Provided Consulting services to:

ABBOTT LABORATORIES, Abbott Park, IL. Nov ’95 to Feb ’97.

TRACER - financial project tracking system.

COLE-PARMER, Vernon Hills, IL. May ‘93 to Nov ’95

Sales Order Management system.

SILVON SOFTWARE, Westmont, IL. March ’93 to April ’93

Worked on various PTFs of software package “Implementer Ver 3.2” using RPG/400.

ANDERSEN CONSULTING, Chicago, IL. September ’92 to March ’93

Software package “MAC-PAC Ver 8.0” using RPG/400.

UNGERBOECK SYSTEMS Inc., St. Louis, MO. April ’92 to August ’92

Designing, development and testing of Convention Management Systems. Responsibility included studying all aspects of Convention management, designing database, various user interfaces, processes, reports using “SYNON/2E” as a case tool.

Other Achievements

Currently developed iPhone App called ‘PWD Wallet’ to store passwords securely– Available on iPhone App Store. This is a free App written in Swift.

Developed and sold iPhone applications – Sam’s Piano, Sam’s Card Trick, Sam’s Shopping List – Retired. These were written in Objective-C.

Designed Web Page sammoreinc.com using CMS WordPress to promote the Apps.

References

Furnished upon request.

Contact this candidate