Contact Detail:

Mobile No: 804-***-****

Email: adbuhj@r.postjobfree.com

Career History:

Organization

Date

Position

Location

Infovision

Oct 2019

Consultant

Dallas, TX, USA

Ranstad Technologies

02/01/2019

Consultant

Dallas, TX, USA

FreeLancer

Sep 2017 to Feb 2018

Consultant

Bengaluru, India

Talteam Inc

March 2016 to Jan 2017

Tech Lead

Columbus, Ohio. USA

Infogain Corporations USA

August 2015 to March 2016

Tech Lead

Watsonville, California, USA

NTT data Americas

March 2015 to August 2015

AS400 lead

Dallas, Texas, USA

HCL Technologies Ltd.

Feb 2009 to March 2014

Senior Software Engineer

Noida, India

CGI Information Systems and Management Consultants Pvt. Ltd.

Nov 2006 to Feb 2009

Software Engineer

Mumbai, India

Primary Area of expertise:

CLLE, ILE RPG, CL/ 400, RPG/ 400, DB2/ 400, SQL/400

Profile and Experience:

●12 years of proven experience in Software Engineering involving role of Analysis, Design, Coding, Testing, Production Support, Conversion, Validation, Testing and Debugging.

●12 years of experience on IBM iSeries (AS/400) with proficiency in RPG (III/ILE/IV/Sub-File Programming), CL, SQL/400, Query/400, SQLRPGLE, rpgFree.

●5+ years of experience working as team lead and onsite coordinator.

●Extensive experience in Retail, Insurance, Banking domains.

●Experience in Waterfall and Agile software development methodologies.

●Extensive experience in AS400 Modernization

●Extensive experience with WMS, SCM, Truck building, HR, Payroll, GL, AR, AP, Cross Applications, Purchase Management, Order Entry, Materials, Inventory and Training modules.

●Extensive experience in developing High level design, Low level design, Requirement specification, Estimation, change request.

●Extensive experience in creating unit test cases and executing test cases as specified in testing document.

●Consult with Quality Assurance and the business analysts in the development and execution of test plans.

●Ensure a defect free delivery through extensive Unit testing and integration testing, on time delivery following project schedules, follows quality assurance procedures by touching base with Quality Assurance team.

●Prepare deployment plan to ensure all required objects are deployed correctly in Beta test environment and production.

●Proficient in Production Support, unit testing, integration testing and conversion scripting.

●Proficient in setting up test environment for Beta Testing, Integration testing and UAT.

●Exposure to EDI, Java and Salesforce.com

●Interfaces and networking with variety of platforms, including Selenium, Salesforce, SAP, Kronos, Oracle, SQL Server, Image Now.

●Team player with very good interpersonal relation skills. Informal training to staff and co-workers

●Team leader with strong management skills

Education Qualifications and Certifications:

●Master of Science in Information system and Security from Stratford University, USA

●Bachelor of technology (I.T.) from Uttar Pradesh Technical University.

Skill Sets:

Language

RPG/400, ILE RPG, CL/400, CLLE

Database

DB2/400, Query/400, SQL/400

Operating Systems

OS/400, XP, WIN7

Tools

Turnover, Aldon, MKS Implementer, Hawkeye, SDA, RLU, PDM, Robot

Project experience and description

Project – Project Outpost

Client: Frontier Communication Oct 2019 – Till Date

Role – Technology Lead (Onsite)

Frontier has to provide a replica of existing DPI system to WDC to run their business, but data which does not belong to four states needs to be purged from the new system before delivery. This project is being done to Purge data which does not belong to four sates from new WDC system and Purge Data from Frontier DPI system which belongs to 4 states. This will ensure WDC will have only have 4 states data and FTR will not have those 4 states data.

Analyze existing application to identify which files data needs to be purged

Analyze dependency and constraints of files to determine the order of purge

Design and Develop SQL statements to purge based on priority

Design and Develop SQLRPGLE and CLLE programs to execute SQLs automatically

Test and Deploy the purge process in different environment

Support UAT and fix UAT defects

Train new members to understand purge process

Enhance SQLs for better performance

Project – Escrow Account maintenance

Client: Bank of America Feb 2019 – Oct 2019

Role – Technology Lead (Onsite)

ESCROW account is an easy way to manage property taxes and insurance premiums for home. By collecting a fraction of these annual costs each month, the escrow account reduces the risk that customer will fall behind on their obligations to the government or insurance provider.

As a technical lead, I was responsible to maintain code changes in Manual analysis and Mass analysis jobs, Generate initial account disclosure letter, short year and annual year statements, on demand statements to customer.

RESPONSIBILITIES

Lead and monitor development and production support teams to ensure timely and well developed solutions to business problems and project needs

Work with business users to identify and document the issues/challenges faced in performing their daily activities and operations

Create and provide end user documentation and job aids required to use the new and improved system functionalities

Manage software development and enhancement activities - requirement gathering, creating design, and software framework for implementing required changes

Create and develop reports, user screens, reusable modules and system components using IBM I series technologies - Query/400, Screen design tools, etc

Support QA, UAT, implementation, post-implementation and production support activities

Analyze and prepare current system documentation to assist problem analysis and design documentation activities

Analyze functional requirements to prepare low level technical design and to perform coding and unit testing

Project Name: Aspen Dental

Client: Total Dental

Duration: Sep 2017 to Feb 2018

Description: Document existing AS400 system programs for Migration into newer technology.

Responsibilities:

●Assist in designing, planning and managing the data migration process.

●Work with customers in gathering business requirements for data migration needs.

●Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.

●Analyze existing custom RPGLE programs and document logic, program flow and relevance of custom program.

●Create format to extract data from source legacy system which will be acceptable to Target system.

●Create programs to transfer data from source system to Target system.

●Monitor milestones and provide timely updates to customer.

Environment: AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Project Name: SIS V12 Maintenance and Support

Client: MAPFRE Insurance

Duration: March 2016 – Jan 2017

Description: Development maintenance and support of customized insurance product SIS V12.

Responsibilities:

●Gathering business requirement with business users and providing support to business analysts in preparing Functional requirement document.

●Translate the Functional requirement document into high level design and explain design to offshore team members for development

●Review of developed code and documents by offshore team to ensure quality of deliverables

●Ensure offshore developers follow coding and programming standards to reduce defect counts.

●Create high level design, detailed design, deployment instructions, and cutover plan and explain the same to offshore team.

●Get daily development status from offshore team to ensure team is on track

●Provide status update to customer on regular basis.

Environment: AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Project Name: JDA MMS Maintenance and support

Client: West marine Corp

Duration: Aug 2015 – March 2016

Description: Payment Integration & Tokenization for PCI compliance: Integration with Payment Processor Chase Paymentech and changing the financial bank Chase for West Marine for Ecommerce (along with digital wallets) and Stores channel. The scope also includes integration with MerchantLink payment gateway to implement point to point encryption of credit card data and convert them in to tokens across enterprise.

Responsibilities:

●Gathering business requirement with business users and providing support to business analysts in preparing Functional requirement document.

●Translate the Functional requirement document into high level design and explain design to offshore team members for development

●Review of developed code and documents by offshore team to ensure quality of deliverables

●Ensure offshore developers follow coding and programming standards to reduce defect counts.

●Create high level design, detailed design, deployment instructions, and cutover plan and explain the same to offshore team.

●Get daily development status from offshore team to ensure team is on track

●Provide status update to customer on regular basis.

●Provide training to offshore team on technology and product.

●Design new RPGLE and CLLE programs to Implement Point to Point tokenization for PCI 3.4 compliance.

●Integrating hosted payment page with iSeries for tokenization.

●Creating new SQL store procedures to send and receive data from Hosted payment page

●Create new programs to interface with Java code to send payment settlement file to merchant link via HTTPS over SSL.

●Modify existing MQ and Socket programs to integrate with new payment processor.

●Follow all phases of SDLC in application development activities.

●Maintain service level agreements, performance metrics and outage resolutions for software applications.

●Maintain documentations for application coding, audit compliance and disaster recovery functions.

●Assist in interviewing, hiring and training candidates in their job duties.

●Organize project status meetings, review project reports and resolve issues timely.

●Maintain good relation with customer and address customer queries promptly and professionally.

Environment: JDA MMS, AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Project Name: STARS Maintenance/Conversion

Client: Service Experts LLC

Duration: March 2015 – August 2015

Description: Service experts LLC is USA largest service provider for HVAC Install and repair, Plumbing Company for commercial and residential customers. Service experts LLC extends their business to Canada for facility management, Heating & Air Conditioning. With North American Technician Excellence (NATE) trained technicians, innovative energy solutions, 24/7/365 live customer service and more, Service Experts LLC fulfills their customer’s expectations 100%rts in the HVAC industry.

Responsibilities:

●Provide directions to development team to code and develop software applications.

●Develop high level detailed design documents and project plans to meet business requirements.

●Development and support of WMS and Ticket management modules.

●Assist in developing project budget, schedule, risks, milestones and objectives.

●Determine resource requirements and maintain resource workload plan and timelines.

●Provide daily guidance to development team to ensure timely project delivery.

●Follow all phases of SDLC in application development activities.

●Maintain service level agreements, performance metrics and outage resolutions for software applications.

●Ensure developers follow coding and programming standards.

●Maintain documentations for application coding, audit compliance and disaster recovery functions.

●Work with customers on new developments, enhancements, contracts, pricing and troubleshooting.

●Assist in interviewing, hiring and training candidates in their job duties.

●Oversee performance evaluation, promotion, termination, compensation activities for employees.

●Organize project status meetings, review project reports and resolve issues timely.

●Develop project work plans and revise to meet changing needs.

●Address customer queries promptly and professionally.

Environment: AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Project Name: FOODSTAR Maintenance and Support

Client: Performance Food services

Duration: Dec 2011 – Feb 2014

Description: Performance Food Group is a leading foodservice distributor in the USA. PFG delivers food and food-related products to more than 130,000 independent and national chain restaurants, quick-service eateries, pizzerias, theaters, schools, hotels, healthcare facilities and other institutions across the United States through its four business divisions and 24 warehouses. PFG uses in-house ERP Foodstar for end to end solution of business needs

Responsibilities:

●Assigned work to offshore resources and focused On Time and defect free delivery.

●Getting knowledge transition from existing PFG resources and transition the knowledge to offshore team.

●Review of work delivered by offshore team to ensure quality.

●Daily status update from offshore team on incidents and enhancements.

●Offshore team query resolution and training.

●Provide timely status update to customer.

●Development and Maintenance of existing ERP system.

●Design, coding, testing and maintenance of programs using RPG (III/IV/Free), CLLE, SQL.

●Providing Production Support on critical issues and off- hours on call support.

●Develop new interface programs using RPGLE, CLLE and writing technical documentation for external Order management system following mapping document provided by mappers.

●Development and Support of WMS, Order management, Customer management modules.

●Prepare deployment plan to ensure all required objects are deployed correctly in Beta test environment and production.

●Provide technical support to IT managers and other software teams which were interfaced with ERP (SAP, ETL, OMS, Image Now)

●Provide extract files from AS400 to users and upload provided data through different sources to AS400.

●Always maintained good quality of deliverables.

●Peer review, Unit testing and UAT Support.

●Setting up test environments for Beta testing and UAT.

●Train and mentor end-users.

Environment: AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Project Name: HUB Maintenance and Support

Client: HSBC Bank, Malaysia

Duration: June 2011 – Dec 2011

Description: HSBC Bank Malaysia Berhad is a member of the HSBC Group and is its principal representative in Malaysia. HSBC is one of the largest banking and financial services organizations serving some 55 million customers across the globe.

Responsibilities:

●Design, coding, testing and maintenance of programs using RPG (III/IV/Free), CLLE, SQL.

●Retrofit existing program to support different country

●Production Support of HSBC HUB application for credit cards

●Customize credit card application interface to support different clients

●Modify existing credit card approval system to comply current standards.

●Estimation, design, coding, debugging and testing of applications.

Environment: AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Project Name: CWDirect Maintenance and Support

Client: Reader Digest Associates

Duration: March 2009 – Jun 2011

Readers Digests Association is America’s largest Books and magazine producer and publisher. I was involved in maintenance and support of their Magazine management system CWDirect. MICROS-Retail’s CWDirect is a powerful software solution that enables cross-channel retailers, and direct marketers to transact with, and support their customers at all points-of-touch from one integrated solution. CWDirect’s integrated suite of applications manages the entire retail transaction lifecycle — from informing, and attracting customers to merchandising, fulfillment, and customer service. The software enables true multi-channel commerce, allowing retailers to uncover new revenue, and growth opportunities, improve customer relationships, and increase profitability.

Responsibilities:

●Design, coding, testing and maintenance of programs using RPG (III/IV/Free), CLLE, SQL.

●Requirement analysis and Creation of Low Level Design for any changes/review Comments related to design.

●Development and support of existing WMS.

●Design and Implement code based on specifications provided by mappers.

●Making necessary changes to shift primary warehouse and remove warehouse hard coding from the custom code of application.

●Changed program in such a way that future warehouse change could be done easily.

●Incorporating changes in the Design specs and getting Sign-off of the Design Specs.

●Design and development of Important warehousing components

●Perform conversion scripting, unit testing, and integration testing.

●Setting up Test environment for Unit testing, Beta testing and UAT.

●Peer reviews, Unit testing, Code review, UAT support.

●Resolve any technical/functional issues of team members.

●Final delivery of the code to the client and Final Sign-Off.

Environment: AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Project Name: Life support plus Maintenance and Support

Client: Humana Insurance Company

Duration: Nov 2006 – Feb 2009

Employer: CGI information systems

Location: Mumbai, India

Responsibilities:

●Design, coding, testing and maintenance of programs using RPG (III/IV/Free), CLLE, SQL.

●Reviews, Analyzing, and preparing Technical Documents as per Client’s specific Format.

●Design and Implement code based on specifications provided by mappers.

●Conversion of existing LSP system to new Billing and Reconnaissance Insurance project for new Owner Humana Insurance Company.

●Perform conversion scripting, unit testing, and integration testing.

●Setting up Test environment for Unit testing, Beta testing and UAT.

●System Analysis, Design, Development.

●Preparation of Impact Analysis Report

●Analysis of enhancement or change request

●Modification of existing programs for change requests

●Testing and debugging all the designed components

●Created Low Level Design for the Tool and also construction of the conversion Tool.

●Cross testing of the modules and created the User Manual for the new TOOL.

●Knowledge Transfer to the Business Team that Travelled to Onsite for training

●Demonstration of the Tool and Implementation of the Tool at the Client Side.

Environment: AS/400, RPG400, RPG-ILE, RPG FREE, CL400, CL-ILE, SQL/400, QUERY/400

Contact this candidate