Pl Sql Ms

SAMUEL KOLAGANI

Cell: 614-***-****

*********@*****.***

Samuel Kolagani LinkedIn

SUMMARY:

Programmer Analyst/Project Lead with 20+ years’ experience in AS400 technology and 2+ years in enterprise web applications using J2EE technologies.

AS400, iSeries/GITHUB, Bitbucket implementation.

Expertise in Property and Casualty Insurance, Manufacturing, Logistics, Distribution and Banking domains

Expertise in System Analysis, Design, Development, and Maintenance skills of AS/400 platforms and IT systems running RPG/IV ILE (Free Format), RPG 400, RPG III, CLP, SQL/400, ALDON, MKS(Implementer), Hawkeye. Python, PHP, WEBSMART, Zebra language, Cognitive language, Bartender Label designer

Experience in trouble shooting database files using SQL.

Excellent in Integration, System and Manual testing and providing UAT Support.

Technical Management of complete End to End software project life cycles and leading teams to meet the defined targets with high standards of quality.

Good experience in documentation; have created System Appreciation Document, Functional specifications, User Manual, Technical Design documents, Integration Test Plan, Unit Test Plan documents.

Evaluated numerous complex system problems and user requirements. Developed the ability to provide structured and modular solutions.

Proficient in managing multiple priorities and projects within tight deadlines.

Excellent analytical and problem-solving skills.

Expertise in Production support, solving production problems and providing permanent solutions.

Possess excellent communication, interpersonal skills and ability to work in a team as well as individually.

Excellent client relation skills and the drive to complete tasks effectively and efficiently where customer services and technical skills are demanded as well as the ability to communicate effectively with all levels of management and client community.

Authorized to work in the US for any employer

Technology Details:

Language: ILE RPG, RPG IV, RPG-FREE, (Embedded/Dynamic)/SQL, RPG/400, RPGIII, CL/400, COBOL/400, Embedded-COBOL/400,

Job Control: CL Programming (CLP), SQL-Triggers, iSeries Navigator

Systems: AS400, iSeries(V7R2)

Tools: Query/400, RLU, DFU PFE, PDM, RSF, HAWKEYE, APLUS, STRANT,DBU40,ALDON, MQ, Lotus Notes, WDSC,FTP,SFTP, WebSphere

Implemented Database constraints (primary, unique, referential and check), SQL Stored procedures, Triggers.

DB2/400: DDS-Physical Files, Logical Files, Join Files, Data Dictionaries

Screen Design Aid (SDA): Menus, Display Files, Sub-file Programming

File Transfer Protocol (FTP) : Query/400 and Open Query File (OPNQRYF)

System Administration-PTFs: System Values, Basic Configuration

Security Administration-User Profiles, Authorization Lists, Object Authority

ROBOT Job Scheduler.

Operations- Backup & Restore, Print Management, Job Scheduler

UIM User Interface manager, IBM MQ Series API set, WebSphere

DDM Distributed Data DS, DDL HTML, XML

VISIO Flowcharting Software,

Change Management software -ALDON, MKS(Implementer), Hawkeye

Clarity, Lotus Notes, HP-ALM, Service Now, Peregrine, WDSC, JIRA

Web Technologies: JAVA2.0, WebSphere, Tomcat, Eclipse, DAO, HTML and XML, JSF,NODE.JS

SYNON

Professional Certifications:

●Oracle Forms Developer Certified Professional (OCP)

●Oracle PL/SQL Developer Certified (OCA)

●Master RPGIV certification- Brain bench

●Oracle Certified Professional, Java SE 6 Programmer

EDUCATIONAL QUALIFICATION:

Masters of science Degree in Electronic from ANDHRA UNIVERSITY,

VISAKHAPATNAM, 2000, A.P INDIA.

PROFESSIONAL EXPERIENCE

Wipro, May 2023 to till date

Optum, FAX

Worked on iSeries/Fax to implement FAXMAN in .net and modify storeProcedures and programs at iSeries. worked on re-routing of vpay360 application to faxman instead of DB2 for many endpoints. Coordinated with iSeries Architecture team on the rerouting of the end points. The development is completed with the proper code review and coordinating with QA team for the deployment to stage environment and as well in Production.

In addition im working on Obsoleting DB2 unused tables and their dependencies.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CLLE, DB2/400, IBM-RDI.9.5.1, ACOM, MQ

Sysco Corporation Sr. RPG Developer

Infosys, Remote Oct 2020 to May 2023 date

SUS development and Enhancements

This is an end - end application maintenance and Production support project which involves requirement elaboration, design, build, testing, and implementation.

Increase in number of customers lead to increased load/volume to existing SUS application. A performance improvement team has been formed to analyze the system thoroughly to identify the long running jobs and areas which will affect as part of this volume increase. The team’s responsibility is to analyze the programs and provide

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CLLE, DB2/400, IBM-RDI.9.5.1, ACOM, MQ

ACCO Brands Sr. RPG Developer

Cognizant, Chicago, IL March 2020 to May 2020

ACCO Brands Corporation (NYSE: ACCO) is one of the world's largest designers, marketers and manufacturers of branded academic, consumer and business products.

Order to cash application will be processed using SAP and The logistics functionality to pick and ship orders utilized the automated pick system in Sidney Pick Module (SPM-AS400)

SPM will process to pick, pack, batch and print Labels. SAP ECC, FedEx Integration, Cross border system, Manifest process, RF devices, label print solutions.

Responsibilities: Actively participated in

Working as an on-site coordinator

Requirements gathering from the client and concerned teams

Analyzing and translating business requirements to technical requirements

Designing the programs and screens required

Guiding off-shore team and Developed programs using RPGLE, CLLE

Purolator Label processing

Design FedEX Labels using bartender software

Enhance UPS Labels by ACOM and TL Ashford

Handling MQ issues.

Involved with SAP team with day2day Incidents, and enhancement projects

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CLLE, DB2/400, IBM-RDI.9.5.1, Bartender Label designer, ACOM, TLAshford, MQ

American Textile Sr. RPG Developer

Teklibrium LLC Jan 2020 to Feb 2020

Responsibilities:

Implemented AS400 Production/test Libraries to GITHUB, Bitbucket.

IBM RDI installed and given training to the team members.

CDW SYNON/ RPG Developer

ASPIRE SYSTEMS Sep 2019 to Dec 2019

Responsibilities:

IBM i ERP Architectural Modernization of SYNON.

Modified entire database Logical files to remove FIFO access path on SYNON.

Hub Group Sr. RPG Developer

Aptude, Chicago, IL June 2018 to April 2019

Hub Group (NASDAQ: HUBG) is a transportation management company in North America, providing intermodal, truck brokerage and logistics services.

Hub Group customers and Vendor extracted and setup in the new Cloud ERP Financials database. From that point forward ERP Financials will be the source system for Hub to updates and new accounts will be sent from the Cloud ERP Financials system and shared with the TPS customer database for as long as customer invoicing will be run in TPS.

Projects:

Import TM/TPS Customer/Vendor to ERP

Import TM/TPS -AR/AP Invoice to ERP (65K Invoices per day)

Import TM/TPS Shipments to OTM (SAW- Shipment-Invoice-PO and Carrier invoice

Import TM/TPS Purchase orders and Carrier Invoices OTM

OTM to matches the SAW (TPS purchase order) to the Carrier invoices and approves and creates voucher to ERP

Involved in design, enhancement and development for Implementation of Web services on applications

Create new RPG and SQLRPGLE programs to Migrate the Financial (AR and AP Invoices) from AS400 to third party vendor ERP System.

Coordinate with the business partners in designing the XML Schema definitions (XSD) and worked extensively on XML to transfer/receive Inbound and Outbound feeds.

Mentor and assisted team members in understanding the about Interfaces connected to Applications thru Webservices.

Efforts entail architecting platform with ability to connect to the following: AS400 DB2 Database; REST Web Services; HTTP Request/Response Model Services.

Projects were managed in an Agile (Scrum) framework and ticketed with JIRA.

Responsibilities:

Analyzing and translating business requirements to technical requirements

Involved Requirements gathering and created mapping documents for ERP XML tag/DB2 fields.

Used Jira/Agile methodology to develop the project.

Created complete Architect design and development.

Involved in developing 12 Programs without deviating to organization standards.

and used latest AS400 concepts to populate xml files 1MB size

Involved in different testing like unit testing, DA testing, Client QA testing, UAT

AS400/GITHUB, Bitbucket implementation.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, Fully Free RPGLE, (XMLSERIALIZE, XMLTABLE, XMLPARSE, XMLAGG, XMLELEMENT

,XMLFOREST) DDL and DML, Web Service, RPG/400, CLLE, DB2/400, MKS, IBM-RDI.9.5.1, XML, SOA, OTM, ERP, NetBeans, GITHUB

Follett, Chicago, IL Tech Lead /Architect

Integrative-systems Sep/2017 to March/2018

Follett has more than 2000 bookstores across US in different universities and involved in retail business. As all the applications are migrating from JDA to MMS (material management system). Currently Tickets/labels are being created and printed by using a windows-based application WINDSS, But Now this project is to migrate to MMS and have capable to print tickets from web-based application.

Ticket printing project is mainly classified as 4 parts depends on the time of generation and printing the labels.

When PO receiving (either fully/partial receiving), system will generate ticket batch

During PO Adjustment (Positive adjustment), ticket batch will be generated

During detail and ASN receiving, ticket batch will be generated

Manually user can create/maintain ticket batches(On-demand)

Basically, this project intended to create labels for the required SKU based on its UPC/ISBN, department details to handle 8 different ticket types and need to send to different types of printers (using Zebra and Cognitive printers). Batches will be created and can be maintained with many validations when required. Labels contain different parameters like barcode (EAN13+5 / Code39), item description, Author description, price etc., All these details will be fetched from the system at real time and is achieved by using SQLRPGLE programs.

Responsibilities: Actively participated in

Working as an on-site coordinator

Requirements gathering from the client and concerned teams

Analyzing and translating business requirements to technical requirements

Designing the programs and screens required

Guiding offshore team and Developed programs using RPGLE, CLLE, Websmart, Presto screens

Involved in developing 15 Programs without deviating to organization standards.

Involved in different testing like unit testing, DA testing, Client QA testing, UAT

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CLLE, DB2/400, MKS, IBM-RDI.9.5.1, Zebra language, Cognitive language,

WEBSMART 11.3, Presto 5.6

Hardware: Barcode Scanners -Motorola

Label Printers: Cognitive-Advantage LX, Zebra-LP2824

Werner Enterprises, Omaha, NE Sr. RPG Developer/Architect

CSS, Inc. May 2017 to Oct 2017

Werner Enterprises is a very large transportation and logistics provider. Its core transportation software, billing, accounting, truck/trailer maintenance, and other software applications rely on multiple IBM System i's which are AS/400-based. Modernizing and web-enabling its applications has been an important goal for Werner, which is one of the i it has engaged CSS’s IT consulting services. On the IBM i platform, modernizing includes web enabling database applications that are written in Integrated Language Environment (ILE) RPG.

Currently on TLE- EDI 6.1 in a logistics environment (204,210,214,990…etc) on ISeries. With a base of 500+ trading partners, active, trading partner setup, mapping

Architectural design for Processing EDI Transaction into DB2 files using

MQ Series and XML.

Converting old TrustedLink System i (TLi) web database system with a newer RPG IV system.

Understands transportation industry EDI X12 standards and transaction sets for transportation and logistics.

Created SQL Scripts and MQ programs and Updated Production Programs

To complete 204,990 and 210, 214 transactions.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CL/400, DB2/400, MKS, IBM-RDI.9.5.1,MQ Series, EDI X12 and XML, NetBeans, MQExplorer, Sterling B2B Integrator, SoapUI, Note++, RFHUTIL v7.5.0, X-Analysis 12.0.6

USFOODS, Rosemount, IL Sr Programmer/Analyst

Apex Systems, Inc. March 2016 to Dec 2016

ACOP: US Foods is one of America's leading foodservice distributors to restaurants, healthcare and hospitality facilities, government operations and educational institution.

Application ACOP provides for cut floor operations, finished goods costing, and analysis of yields. ACOP seamlessly integrates orders, invoices, and prices between Stock Yards districts and their customers, both broad-line division customers and direct customers. ACOP also provides the tools for counting and valuing WIP (work in process) inventory.

Developed order fulfilling process for RF-Guns to scan Barcode- UCC128.

Developed a process to deliver weights and quantities to Tandem to support order updates

Distribution Center (DC)/warehouse- maintenance Setup for stock orders for different stock yard.

Spilt order process for Fish/Meat for different DC.

Printing barcode labels and reports, Pick-order reports, In/Out of Room reports

Modified Butcher's Cut Test Yield formula at Maintenance screen

Loading data for new Yield formulas from Canopy into ACOP system.

Analyze newly converted data to establish a baseline measurement for new requirement.

Used agile methodology for project implementation using Jira.usfood.com

Used usfoods.sharepoint.com for documentation.

Worked with architects and subject-matter experts to design comprehensive solutions.

Tuning SQL Statements at SQL/400

Change Management software -ALDON.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CL/400, EMBEDDED SQL, DB2/400, MKS, IBM Rational developer for iNavigator.

Motorola MC9200-Guns, wavelink telnet- software.

TAG Chicago, IL Sr Programmer/Analyst

Apex Systems, Inc. April 2015 to Dec 2015

Infor-APLUS Distribution: TAG (Trade associates group, ltd.) is a forty-year-old gift and home decor company based in Chicago, Illinois. tag's premium distribution to better independent retailers in both design and production.

Developed PROD Warehouse and Distribution batch programs and interactive screens.

Developed programs that reads from an Integrated File System (IFS) and converts to DB2 and emails reports in excel format using JAVA programs

Designed and developed subfile process for the Returns and Credits of products

utilizing the Infor-APLUS Distribution Software package for an EDI-based project centered on automating the processes for EDI Transaction sets 940/945 and 943/944 (Returns and Pre-Receiving). Knowledge of iSeries.

Change Management software -ALDON.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CL/400, EMBEDDED SQL, DB2/400, MKS, IBM Rational developer for iNavigator.

Bank of America Merrill Lynch, Chicago IL Systems Analyst

Tata Consultancy Services. Oct 2014 to Mar 2015

GMI (Global Market Infrastructures) experience which includes business analysis, planning, preparing, documenting steps, performing testing, GMI upgrades, and various customized applications to accompany GMI Sungard software.

Good understanding with the futures & options markets and exchanges.

Good understanding of trade lifecycle and back office functions like Client allocations, collateral, pricing of futures products, clearing, margining, settlement, etc.

Provided various GMI related reports for higher management

Experience in GMI Technical Production Support and troubleshooting with various aspects of GMI batch issue, user query, Client feeds etc.

Have ability to solve critical problems in an effective manner.

Writing utilities, Very Strong SQL expertise, can slice and dice GMI data in many ways based on user needs.

To support GMI system and business related queries.

Analysis, specification creation, testing, implementation, developments are mostly done using RPG free, RPG/400, RPGIV, ILE, CLLE, CL400 and other IBM iSeries tools and X-Ref Utility.

GMI Batch Processing: Jobs: FEMAINC, NPMAINC (PreBatch), OCMAINC, CDMAINC,N1MAINC at Job scheduler, and Monitor Jobs at Robot & AC.

Vendor interactions with Sungard for daily exchanges and LME,CME for daily batch files.

Change Management software -ALDON.

CIGNA, Raleigh, NC TechLead/Analyst

CGI Group Inc. Feb 2014 to Oct 2014

CIGNA– Power Managed Health CARE System (Pmhs) The system is also responsible for generating the statements for employees and also the reports for the employers. The Employee Statements gives a detail explanation of all the claims that were submitted by the employee in a quarter. The Employer Reports gives a report of all the employees and their claims.

PMHS is basically a development, maintenance and enhancement project

Team Size: 30 team members (10 members at Onsite + 20 members at Offshore).

Technical Lead/Developer:

Managed Offshore team by providing guidelines with Program Specification-PGS and SQL queries based on performance based.

Coordinated Code management and Deliverable on timely manner.

AS400/iSeries support position managing testing environments in RxClaim.

Modified and performed analysis of SYNON programs.

Set up FTP processes to move data from external sources to RxClaim iSeries files/tables.

Supported MQ Network, which grew from 5 to over 100 Queue Managers Troubleshoot and resolved MQSeries problems

Worked with MQ developers, assisting with architecture, design, development and implementation of messaging and integration applications designed to turn business needs and requirements into technology solutions.

Technical Environment: AS/400, ILE-RPG, SQL/400, ILE-COBOL, RPG/400, CL/400, COBOL/400, EMBEDDED SQL, MQSeries, DB2/400, ALDON, HAWKEYE, HP-Quality Center, GUI, iSeries.

Mapfre Insurance, Columbus, OH Sr Developer/ Analyst

CGI Group Inc. Nov 2012 – Jan 2014

Agency Port Application: Mapfre USA is a leading provider of personal lines in about 11 States in the continental US primarily through a unique partnership with AAA Club Agencies. The Insurance Business is run through two major applications Agency Portal (Agent web font-end) and SIS (Specialty Insurance System, back-end legacy application on AS/400) system. AgencyPortal application is a vendor application initially customized by a combination of in house and Vendor resources and currently maintained by in house resources.

Designed and developed server-side component called “Reverse Mapping” in Web Based Endorsement projects for varies states.

Designed and developed “Effective Date” driven functionality in Agency Portal.

Developed MVP -Rules engine to handle better tier.

Developed xml tags for “Forward Mapping” in Agency Port application that interacts with legacy system’s middle-tier.

Developed DAO (DataAccessObjects /Store procedures) and deployed in

WebSphere

SIS-T21 (Agency Port will initiate Policy Quote transaction and will send ACORD XML request to XTS Server then it will be Parse Agency Port XML to T21 format data queue and populated into SIS database.

Bulk data transfers and MQ Websphere to fulfill immediate single policy data requests from AAA agents.

Developed functionalities “Viewing Policy Billing Information”, “Agency Payment Report” and “View Policy Documents” for Agency Port application.

Production Support.

Change Management software -MKS(Implementer)

Environment: AS/400, RPG/400, SQL/400, RPG-Free, ILE, AgencyPortal, SIS, J2EE (Servlets, JSP, JavaScript, HTML,XML), WebSphere, Tomcat, Eclipse, DAO,Tech21,

iSeries.

Mapfre Insurance, Columbus, OH Sr Programmer/Analyst

Oct 2008 – Nov 2012

SIS- V2/V12 (Specialty Insurance System), which handles the overall Insurance functions like quote Processing, Policy issuance, renewal, endorsements and policy declaration printing for personal Auto, Home Owners and Mobile Homes..etc, Working as a part of team that is responsible for maintenance and enhancements of the product,

Worked on Rating engines (MVP /Artius System) continually demonstrate my ability to analyze, design, and code. Make the Rating systems versatile enough to help retro fit all new Auto States into the current system, ability to detach and plug into any new system.

Coordinate Implementation through standard test levels to production of RPG, Java and Rating DSL components as Implementation Coordinator phases of all rating related projects in company, which requires coordination with business analysts, developers from multiple platforms, and business partners. Oversee testing efforts for the New Product/New States project as Testing Coordinator.

Senior Programmer Analyst:

Developed Instruction and resultsets for MVP/Artius Rater Engines (Java Script).

For each state based on rate-filling.

Developed Interface Programs to pass/receive data though IBM's XML Toolkit supports

writing, via the DOM parser, SAX = Simple API for XML xmls to Raters-

MVP/Artius in Java

Developing MVP Instructions and validating MVP and Artius tables and Uploading to SIS System for New-Business and Endorsement, Renewal.

Developed New Rate Filling Projects to merge policies from different systems.

Worked as Implementation coordinator using MKS,

Working closely with DBA’s and Operations team and while code Management.

Change Management software -MKS(Implementer)

Bulk data transfers by FTP and MQ Websphere to fulfill immediate single policy data requests from AAA agents.

Prepared statistical data from reporting for AAIS /NAII for different sates

Prepared all statistical exhibits supporting increases/decreases to insurance rates/loss costs for several property and casualty personal line insurance.

Automated and streamlined creation of actuarial exhibits.

Automated assigned Risk policies for RI state.

Environment: AS400, RPGIII, RPGII, RPG/400, RPGIV -ILE, CL/400, XML, SQL/400 on AS/400, Lotus Notes, ADM, MKS (Implementer), Java, iSeries, MQ-Series

FedEx Ground, Pittsburgh, PA. Programmer/Analyst

ABSI Inc. June 2007- Sep2008

Vision project in extreme scheduling constraints from Seattle facility turns. AWAD (Automated Work Area Design-Vision Data) Store (Daily Operations Data) to AWAD, Download Daily operations Data – Full Refresh of Package.

AWAD populates its daily operations stop and package tables from the Vision Data Store. The first time data is ever loaded into AWAD or whenever there is a critical problem with the data, AWAD will need to fully refresh its data set to replicate exactly what is in the Vision Data Store’s stop and package tables. AWAD will request this from the Vision Data Store. Import Raw Historical Data to Create ADS AWAD queries the Vision Data Store Historical Database to build an aggregate data set. The required records will be migrated in their raw form from the Vision Data Store to AWAD. AWAD will then perform all the required calculations internally to build at a high level; AWAD will perform the following calculations:

oAggregate total stop/package counts for stops

oCalculate variances in stop/package counts for stops

oCalculate historical Work Area #/vehicle information

oCalculate Zip9 Disbursements (w/variance)

Programmer Analyst:

Created new ILE Programs and Service Programs

Written various Trigger programs based on the Business flow

Created SQL to the extent of designing and creating tables and indexes.

Automated programs to update Files different systems

Created Webservice Programs to get for address cleansing Stop Id and Stop Id type

Written complete DIRE process

Created BrokerQue Programs to for Extract and Transform Multiple DATAQ for Varies Jobs

Which in terns Update and insert Business Objects

Change Management software -MKS(Implementer)

Hands on experience in MQSeries triggering, handling messages from Back out queues and Dead letter queues.

Environment: AS/400,SQL (Embedded/Dynamic), Free-Format, ILE, SQL/400, RPG/400, CL/400, DB2/400, Query/400, DBU/60,Lotus Notes, using I-Series V5R4 WDSC 7.0.

Commerce Insurance Company, Webster, MA Programmer/Analyst

ABSI Inc. Dec 2006- April 2007

The Commerce Insurance Company provides personal and commercial property and casualty insurance in Massachusetts and New Hampshire. In Massachusetts, Commerce Insurance is the leading provider of both private passenger and homeowners insurance and is the second leading provider of commercial automobile insurance. Project’s scope was to develop a process at Commerce Quality Assurance Environment for Commerce Company, involved in all the phases of project life cycle development, which includes defining scope of the application, development, testing, and implementation.

Programmer Analyst:

Updating production applications in CQA removing hard coding.

Test Data gathering utilities, number of utilities that have been created and put to use in order to generate test data sets for the various CQA Environment.

Execution of jobs, cycles, under ROBOT, for the operational aspects of the applications in the CQA Environment.

Enable each Application and related jobs to run on CQA Environment fixing the failures

Facilitated Requirement gathering sessions with business users Departments like Underwriting, Premium accounting and Claims.

Liaised with Tech lead and other team members in analyzing the system, files, programs and reports, and prepared the System Impact Analysis Document

Extensive use of programming abilities in SQL/400, ILE, RPG/400 CL/400, QUERY/400.

Designing the screens and menus using Screen Design Aid and Sub file programming.

As part of Quality assurance and testing Using Report Layout Utility generate reports or generating it through programs.

Testing every Application, Jobs and program fixes and module.

Compare the test reports with production data to ensure the system is validated.

Written data pulling Programs and refreshing the Environment.

Environment: AS/400,SQL (Embedded/Dynamic), Free-Format, ILE, SQL/400, RPG/400, CL/400, DB2/400, Query/400, ALPLUS, STRANT, DBU/40,Lotus Notes, using iSeries V5R3 WDSC 6.0, iSeries

Accretive Commerce. Roanoke, VA. Programmer/Analyst

ABSI Inc. Jun2006- Dec 2006

Direct Marketing Management System(DMMS): Development in the areas of inventory management and supply chain management system. Worked on Inventory adjustment report to generate the list of all inventory adjustment by code on daily basis Also worked on ACT (Accounting Reconciliation Package) to reconcile inventory receipts, customer shipments, inventory adjustments and cost changes to validate the ending inventory value in the WMS (ware house management system) Involved in development of module involving unloading of shipment off the truck into a staging area and reconciliation of the same with the expected inventory and match the truck seal with seal numbers(license number) Also involved in modifying the merchandise inventory for forward pick locations to be assigned automatically to a location by WMS and assigning the new items or reserved items to a location based on the size of the item

Clients: American eagle, LLBeans, French toast, New York &company, CWDKids...etc

Programmer Analyst:

Debug/Design/Modify System Fixes and Programming,

Modification and Creation of new ILE Programs for RF(Scanner)and BARCODE Printing

Actively involved in bug fixing across the system

Warehouse Management Custom invoices with A/R Statement Information.

Done the modification of’ Pick batch module for verifying the item description and SKU of the merchandise item matches the Pick / Unpick items

Creating package slips, Stock reports for various locations

Unit testing, Aggressive testing DMMS system in AS/400

Change Management software -ALDON

Environment: AS/400,RPG/400, ILE, CL/400, DB2/400, Advanced DDS, Query/400, ALDON, WRKDBF, PFE, PDM, F, ACMS, HAWKEYE, RSF, iSeries, V5R3

First Chicago Insurance, Chicago, IL. Programmer/Analyst

ABSI Inc. July 2005 – May 2006

SIS- V2 (Specialty Insurance System), which handles the overall Insurance functions like quote Processing, Policy issuance, renewal, endorsements and policy declaration printing for personal Auto, Home Owners and Mobile Homes..etc, Working as a part of team that is responsible for maintenance and enhancements of the product, Currently use Jwalk, a Java based tool to transform the front-end green screens to GUI, which execute RPG Programs at the Backend.

Programmer Analyst:

Involved in Analysis and Design of the automated agent application

Development of interface programs using RPG ILE and CL on IBM AS/400

Analysis and design of CLUE display programs and screens development

Rater and Report generation.

Upload the data files to the system file through interfaces

Setting up different tables defined in the system, developing complex coverage formulas involving the driver information, discounts, and surcharges.

Developed programs in RPGIV & CL/400 to interact with the tables to generate the premium for different coverage defined for policy and/or business functionality

Production support and custom modification of the SIS 250 system that includes billing, claims, policy administration, and SRS reporting.

Change Management software -MKS(Implementer)

Environment: AS/400, RPG/400, ILERPG,

Contact this candidate