| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes SQL DBA Chicago, IL Sql Server Business Intelligence Aurora, IL .Net Core Sql Server Hoffman Estates, IL Software Development Sql Developer Aurora, IL Sql Server Part-Time Wonder Lake, IL Python, C/C++, R, SQL, Pyspark, MySQL, Tableau, Power BI Chicago, IL Sql Server Web Developer Hinsdale, IL |
|
Click here or scroll down to respond to this candidateCandidate's Name
Cell: PHONE NUMBER AVAILABLEEMAIL AVAILABLECandidate's Name LinkedInSUMMARY: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 domainsExpertise 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 designerExperience 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 employerTechnology 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 NavigatorSystems: AS400, iSeries(V7R2)Tools: Query/400, RLU, DFU PFE, PDM, RSF, HAWKEYE, APLUS, STRANT,DBU40,ALDON, MQ, Lotus Notes, WDSC,FTP,SFTP, WebSphereImplemented Database constraints (primary, unique, referential and check), SQL Stored procedures, Triggers.DB2/400: DDS-Physical Files, Logical Files, Join Files, Data DictionariesScreen Design Aid (SDA): Menus, Display Files, Sub-file ProgrammingFile Transfer Protocol (FTP) : Query/400 and Open Query File (OPNQRYF)System Administration-PTFs: System Values, Basic ConfigurationSecurity Administration-User Profiles, Authorization Lists, Object AuthorityROBOT Job Scheduler.Operations- Backup & Restore, Print Management, Job SchedulerUIM User Interface manager, IBM MQ Series API set, WebSphereDDM Distributed Data DS, DDL HTML, XMLVISIO Flowcharting Software,Change Management software -ALDON, MKS(Implementer), HawkeyeClarity, Lotus Notes, HP-ALM, Service Now, Peregrine, WDSC, JIRAWeb Technologies: JAVA2.0, WebSphere, Tomcat, Eclipse, DAO, HTML and XML, JSF,NODE.JSSYNONProfessional Certifications:Oracle Forms Developer Certified Professional (OCP)Oracle PL/SQL Developer Certified (OCA)Master RPGIV certification- Brain benchOracle Certified Professional, Java SE 6 ProgrammerEDUCATIONAL QUALIFICATION:Masters of science Degree in Electronic from ANDHRA UNIVERSITY,VISAKHAPATNAM, 2000, A.P INDIA.PROFESSIONAL EXPERIENCEWipro, May 2023 to till dateOptum, FAXWorked 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, MQSysco Corporation Sr. RPG DeveloperInfosys, Remote Oct 2020 to May 2023 dateSUS development and EnhancementsThis 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 teams responsibility is to analyze the programs and provideTechnical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CLLE, DB2/400, IBM-RDI.9.5.1, ACOM, MQACCO Brands Sr. RPG DeveloperCognizant, Chicago, IL March 2020 to May 2020ACCO 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 inWorking as an on-site coordinatorRequirements gathering from the client and concerned teamsAnalyzing and translating business requirements to technical requirementsDesigning the programs and screens requiredGuiding off-shore team and Developed programs using RPGLE, CLLEPurolator Label processingDesign FedEX Labels using bartender softwareEnhance UPS Labels by ACOM and TL AshfordHandling MQ issues.Involved with SAP team with day2day Incidents, and enhancement projectsTechnical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CLLE, DB2/400, IBM-RDI.9.5.1, Bartender Label designer, ACOM, TLAshford, MQAmerican Textile Sr. RPG DeveloperTeklibrium LLC Jan 2020 to Feb 2020Responsibilities:Implemented AS400 Production/test Libraries to GITHUB, Bitbucket.IBM RDI installed and given training to the team members.CDW SYNON/ RPG DeveloperASPIRE SYSTEMS Sep 2019 to Dec 2019Responsibilities:IBM i ERP Architectural Modernization of SYNON.Modified entire database Logical files to remove FIFO access path on SYNON.Hub Group Sr. RPG DeveloperAptude, Chicago, IL June 2018 to April 2019Hub 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 ERPImport TM/TPS -AR/AP Invoice to ERP (65K Invoices per day)Import TM/TPS Shipments to OTM (SAW- Shipment-Invoice-PO and Carrier invoiceImport TM/TPS Purchase orders and Carrier Invoices OTMOTM to matches the SAW (TPS purchase order) to the Carrier invoices and approves and creates voucher to ERPInvolved in design, enhancement and development for Implementation of Web services on applicationsCreate 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 requirementsInvolved 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 sizeInvolved in different testing like unit testing, DA testing, Client QA testing, UATAS400/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, GITHUBFollett, Chicago, IL Tech Lead /ArchitectIntegrative-systems Sep/2017 to March/2018Follett 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 batchDuring PO Adjustment (Positive adjustment), ticket batch will be generatedDuring detail and ASN receiving, ticket batch will be generatedManually 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 inWorking as an on-site coordinatorRequirements gathering from the client and concerned teamsAnalyzing and translating business requirements to technical requirementsDesigning the programs and screens requiredGuiding offshore team and Developed programs using RPGLE, CLLE, Websmart, Presto screensInvolved in developing 15 Programs without deviating to organization standards.Involved in different testing like unit testing, DA testing, Client QA testing, UATTechnical 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.6Hardware: Barcode Scanners -MotorolaLabel Printers: Cognitive-Advantage LX, Zebra-LP2824Werner Enterprises, Omaha, NE Sr. RPG Developer/ArchitectCSS, Inc. May 2017 to Oct 2017Werner 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 CSSs 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,990etc) on ISeries. With a base of 500+ trading partners, active, trading partner setup, mappingArchitectural design for Processing EDI Transaction into DB2 files usingMQ 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 ProgramsTo 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.6USFOODS, Rosemount, IL Sr Programmer/AnalystApex Systems, Inc. March 2016 to Dec 2016ACOP: 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 updatesDistribution 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 reportsModified Butcher's Cut Test Yield formula at Maintenance screenLoading 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.comUsed usfoods.sharepoint.com for documentation.Worked with architects and subject-matter experts to design comprehensive solutions.Tuning SQL Statements at SQL/400Change 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/AnalystApex Systems, Inc. April 2015 to Dec 2015Infor-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 programsDesigned and developed subfile process for the Returns and Credits of productsutilizing 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 AnalystTata Consultancy Services. Oct 2014 to Mar 2015GMI (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 managementExperience 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/AnalystCGI Group Inc. Feb 2014 to Oct 2014CIGNA 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 projectTeam 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 problemsWorked 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/ AnalystCGI Group Inc. Nov 2012 Jan 2014Agency 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 systems middle-tier.Developed DAO (DataAccessObjects /Store procedures) and deployed inWebSphereSIS-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/AnalystOct 2008 Nov 2012SIS- 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 supportswriting, via the DOM parser, SAX = Simple API for XML xmls to Raters-MVP/Artius in JavaDeveloping 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 DBAs 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 satesPrepared 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-SeriesFedEx Ground, Pittsburgh, PA. Programmer/AnalystABSI Inc. June 2007- Sep2008Vision 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 Stores 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 stopsoCalculate variances in stop/package counts for stopsoCalculate historical Work Area #/vehicle informationoCalculate Zip9 Disbursements (w/variance)Programmer Analyst:Created new ILE Programs and Service ProgramsWritten various Trigger programs based on the Business flowCreated SQL to the extent of designing and creating tables and indexes.Automated programs to update Files different systemsCreated Webservice Programs to get for address cleansing Stop Id and Stop Id typeWritten complete DIRE processCreated BrokerQue Programs to for Extract and Transform Multiple DATAQ for Varies JobsWhich in terns Update and insert Business ObjectsChange 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/AnalystABSI Inc. Dec 2006- April 2007The 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. Projects 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 failuresFacilitated 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 DocumentExtensive 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, iSeriesAccretive Commerce. Roanoke, VA. Programmer/AnalystABSI Inc. Jun2006- Dec 2006Direct 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 itemClients: American eagle, LLBeans, French toast, New York &company, CWDKids...etcProgrammer Analyst:Debug/Design/Modify System Fixes and Programming,Modification and Creation of new ILE Programs for RF(Scanner)and BARCODE PrintingActively involved in bug fixing across the systemWarehouse 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 itemsCreating package slips, Stock reports for various locationsUnit testing, Aggressive testing DMMS system in AS/400Change Management software -ALDONEnvironment: AS/400,RPG/400, ILE, CL/400, DB2/400, Advanced DDS, Query/400, ALDON, WRKDBF, PFE, PDM, F, ACMS, HAWKEYE, RSF, iSeries, V5R3First Chicago Insurance, Chicago, IL. Programmer/AnalystABSI Inc. July 2005 May 2006SIS- 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 applicationDevelopment of interface programs using RPG ILE and CL on IBM AS/400Analysis and design of CLUE display programs and screens developmentRater and Report generation.Upload the data files to the system file through interfacesSetting 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 functionalityProduction 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, |
