Project Developer

Name: Sathish Reddy Gannu

Email Id: *******.****@*****.***

Mobile: +1-941-***-****

CAREER OBJECTIVE:

Quality-oriented professional with 11 years of experience and a proven knowledge of application development, Application End to end testing, database design, electronic data interchange and Waterfall model of SDLC. As an IT professional with over 10+ years of experience in the AS400 I series Technology, DB2/400, SQL400 including advanced iSeries web services design/ development skills, small to medium scale IT project management skill, I am looking forward to an opportunity to leverage my leadership/communication skills, technical/project management knowledge and strong business acumen.

AREA OF EXPOSURE:

●Experienced and resourceful technical skilled in streamlining operations, maintaining schedules and managing the entire project from scratch to delivery by ensuring maximum customer satisfaction and business revenue.

●Modify existing software to correct errors, to adapt it to new hardware, or to upgrade interfaces and improve performance with AS400, SQL, Building APIs with stored procedures/RPGLE and parsing responses, Testing technology expertise, team management, team coordination, scheduling and organizing project details.

●Consult with other teams and stakeholders to evaluate interfaces between hardware and software, risks, develop specifications and performance requirements, or resolve customer problems. Expertise in coordinating diverse teams and resources to successfully complete objectives.

●Successfully handled and managed End to End business transnational processes by understanding customer needs, adding value to that by developing or direct software systems, testing or validation procedures and maintaining documentation as needed.

●Prepare reports or correspondence concerning project specifications, activities, or status.

●Coding, testing and monitoring the functioning of multiple projects to ensure the system operates in conformance with specifications.

●Worked in detail in change management (used tools as DAPTIV PPM, Remedy and Innotas), Requirement gathering, business process improvement.

●Gained extensive work experience of managing project by dealing with third party vendors, bank, financial organization regarding handling the business transaction

●Experience in OMS (order Management system) to control end-to-end-order processing, fulfilment, Billing/invoice transaction etc. as a Lead and a team member. Gathered knowledge about the Merchandise system to enhance the application new features for users. Vast domain expertise in retail & eCom and finance business models.

SKILL SET:

●Operating system/Environment : OS/400, Windows XP/7/10, UNIX

●Programming languages : RPG III, RPGLE IV/Free-format, Cobol 400,

Embedded SQL/SQLRPGLE, CLP, CLLE, SQL Stored procedures, iSeries API, Web services, REST, SOAP and XML, Data queues, User queues, multithreading, Journaling and IBM i

●Databases : DB2/400

●Tools : PDM, SDA, RLU, QUERY400, MIMIX, ABSTRACT, X-ANALYSIS,

ALDON, I-Navigator, Hawkeye, Turnover, Go Anywhere, POSTMAN, CURL

WORK EXPERIENCE:

Working as a senior software engineer at SARANSH INC from Jan-2019 to till date.

Worked as a senior software engineer at SOFTVISION LLC(formerly Known as SPI) from Nov-2013 to Jan-2019.

Worked as a Software engineer at SYNCHRO SYSTECH PVT LTD from Mar-2013 to Nov-2013.

Worked as a system engineer at NEOWEBX INDIA SOLUTIONS PVT LTD from Apr-2009 to Mar-2013.

Project #1

Client Name : Performance Food Group, Richmond, VA

Application : FoodStar ERP

Role : Team Member

Designation : Senior Developer

Project Period : Jan 28th, 2019 to April 13th 2020

Technology : RPG/RPGLE/SQLRPGLE/, CL/CLLE, SQL stored procedure, API calls,

Journaling, Java

Configuration Tool : TURNOVER, I Navigator

Project management Tool : Remedy, Innotas

Other Tools : HAWKEYE

Company : Saransh Inc

Synopsis: Performance Food Group (PFG) is one of the nation's largest foodservice distributors. Our network of distribution facilities process, package and distribute the finest quality food and food-related products to our customers. We're also the country's leading candy, snack and beverages distributor - our products end up in vending machines, concession stands, theatres and big box stores nationwide

Foodstar is an in-house ERP system developed on AS400 with extensive business logic which is available at different opco locations. Foodstar ERP will receive orders from various sources that PFG is having like PLINK-sales rep will send orders; PNET-customer based portal, EDI application etc. Active as400 jobs will transmit orders to foodstar Opco. Once order received into foodstar, will be fulfilled, labels will be generated, build routes, invoiced and shipped to customers by trucks.

Job Duties:

Involved in resolving problem tickets, developing enhancements

●Support team creates problem tickets in remedy tools based on issues reported by Opco IT users.

●Review problem tickets created by the support team in Remedy and start analysing the issues by looking at codes involved and talk to the opco IT users to replicate the production issue.

●provide innovative solutions to resolve the issues by and share with service owners to get approvals.

●Upon approvals modify existing/create new database files if required, modify RPG/RPGLE/CL/CLLE to fix the reported issues.

●Enhancement requests logged into Innotas tool, Analyse the requirement, do through impact analysis by using HAWKEYE tool. Prepare the impact analysis documents.

●Involve in meetings with various business analysts to notify any inbound/outbound applications impacted with enhancement

●If required create new indexes/LFs to improve the performance of the programs.

●Preparing Technical Requirement document accordingly and update/create detailed design document

●Develop RPG/CL/store procedure for the specified requirements and create test cases and perform Unit Testing for code

●Enhanced existing tax system using web service calls using REST API method for tax calculations from third party cloud-based application Vertex

●Create new AS400 reports by RLU and WRKQRY based on requirement.

●Create legacy modernization as requested using Java Scripts.

●Promote code to the next environment (Dev/ UAT /PROD) using TURNOVER tool.

●Provide support for the code developed by regularly monitoring the changes (monitor ROBOT scheduler/Jobs)

●Provide on-call production support for the foodstar application as per regular roasters.

Client Name : Bealls Inc, Bradenton, Florida .

Company : Softvision LLC

Application : OMS (Order Management System)

Synopsis: The Bealls has an iSeries-based system. The purpose of this application is to facilitate the customer to go for online purchase, which is developed on IBM WebSphere E-Commerce. With the help of MQ series all the customer order flows into ISeries based OMS applications. OMS will decide where the order needs to flow Store/ central fulfilment centre/Vendor drop ship based on the item availability. After order successfully allocated, processed the orders, payment confirmation and shipping the order to the customer. Front end being Java and the iSeries system served as back end. In which a credit card system is maintained by the merchandising company itself wherein various phases including Authorizations, Issuance, billing and statements, collections, cancellations are maintained.

Project #2

Project Name : Ship2Store

Role : Team Member

Designation : Senior Developer/Associated lead

Project Period : July 10th, 2018 to Jan 25th, 2019

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, External SQL stored procedure,

MQ, DB2

Configuration Tool : ALDON, I Navigator

Project management Tool : Daptiv PPM

Other Tools : X-Analysis, ABSTARCT

Company : Softvision LLC.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Responsible for planning and designing the Iseries part of project

●impact analysis done by using X-analysis and abstract tool

●Work with multiple teams (E-comm, MQ series) to gather the requirements which are feeding/syncing data to Iseries through External AS400 Stored procedures

●Design new database files/tables/indexes to capture the ship to store details and improve the database lookups

●Design new/modified RPGLE/SQLRPGLE/CL/CLLE/store procedures programs to capture inventory and determine the store details to improve overall system functionality.

●Assign work to Offshore team members, review the work done by team members.

●Modify existing external stored procedures to accept inbound data sent by MQ Series.

●Enhance existing systems to prioritise the store allocation based on customer pickup location.

●Write new SQL stored procedures, notify the customer events ready for pick up, pick up reminders, pick up confirmation, cancel when the customer is not able to pick up their order/items. Which will be sent through the synch order process.

●Promote developed code to test environments using FTP, DDM commands.

●Refresh test data from production and alter according to testing needs and supports for QA, UAT test users.

Project #3

Project Name : Sales and use tax

Role : Team Member

Designation : Senior Developer/Associated lead

Project Period : Sept 10th, 2018 to July 20th, 2019

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, External SQL stored procedure,

MQ, DB2, API calls with JSON and parsing data using JSON_TABLE

Configuration Tool : ALDON, I Navigator

Project management Tool : Daptiv PPM

Other Tools : X-Analysis, ABSTARCT

Company : Softvision LLC.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Responsible for planning and designing the Iseries part of project

●impact analysis done by using X-analysis and abstract tool

●Work with multiple teams (E-comm, MQ series) to gather the requirements which are feeding/syncing data to Iseries through External AS400 Stored procedures

●Design new database files/tables/indexes to capture the new payment details and improve the database lookups

●Design new/modified RPGLE/SQLRPGLE/CL/CLLE/store procedures programs to build JSON format data and send to SOVOS(A cloud based third party sales tax system) using web service call with secured credentials provided by SOVOS. Parse JSON data to Relational Data based using DB2 JSON_TABLE function.

●Code developed to encrypt/decrypt data using base64 version which is required for user credential for web service calls.

●Assign work to Offshore team members, review the work done by team members.

●Promote developed code to test environments using FTP, DDM commands.

●Refresh test data from production and alter according to testing needs and support for QA, UAT test users.

Project #4

Project Name : Paypal/Braintree payment method

Role : Team Member

Designation : Senior Developer

Project Period : Sept 10th, 2017 to July 20th, 2018

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, External SQL stored procedure,

MQ, DB2,

API calls with XML

Configuration Tool : ALDON, I Navigator

Project management Tool : Daptiv PPM

Other Tools : X-Analysis, ABSTARCT

Company : Softvision LLC.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Responsible for planning and designing the Iseries part of project

●impact analysis done by using X-analysis and abstract tool

●Work with multiple teams (E-comm, MQ series) to gather the requirements which are feeding/syncing data to Iseries through External AS400 Stored procedures

●Design new database files/tables/indexes to capture the new Brain tree payment authorization details and error logs to verify the payment details.

●Enhance the existing system to authorize payments using new/modified RPGLE/SQLRPGLE/CL/CLLE/store procedures programs to build XML format data and send to BrainTree using HTTPPOST CLUB VERBOSE REST API call .

●Parsing xml data to AS400 tables using DB2 XMLTABLE function

●Enhance Pre-authorization, Post authorization during order allocation, fulfilment, also enhance sales audit

●Encrypt the paypal token and store into Relational Data tables as per PCI compliances.

●work with Offshore team members, review the work done by team members.

●Prepare Unit test cases, documentations with all possible cases.

●Promote developed code to test environments using FTP, DDM commands.

●Refresh test data from production and alter according to testing needs and support for QA, UAT test users.

Project #5

Project Name : International Bill to project

Role : Team Member

Designation : Senior Developer

Project Period : April10th, 2017 to Sept 10th, 2017

Technology : RPG/RPGLE//SQLRPGLE, CL/CLLE, External SQL stored procedure,

MQ, DB2

Configuration Tool : ALDON, I Navigator

Project management Tool : Daptiv PPM

Other Tools : X-Analysis, ABSTARCT

Company : Softvision LLC.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Responsible for planning and designing the Iseries part of project

●impact analysis done by using X-analysis and abstract tool

●Design new database files/tables/indexes to store international address along with country name, zip code

●Enhance the existing system to authorize payments using new/modified RPGLE/SQLRPGLE/CL/CLLE/store procedures programs to accept international billing address and credit card detail token details.

●Enhance Pre-authorization, Post authorization during order allocation and fulfilment using global billing address.

●Refresh test data from production and alter according to testing needs and support for QA, UAT test users.

Project #6

Project Name : Credit Replat form

Role : Team Member

Designation : Senior Developer

Project Period : July 20th, 2016 to April 10th, 2017

Technology : RPG/RPGLE/SQLPRGLE, CL/CLLE, External SQL stored procedure,

MQ, DB2, API calling to ACI world web services

Configuration Tool : ALDON, I Navigator

Project management Tool : Daptiv PPM

Other Tools : X-Analysis, ABSTARCT

Company : Softvision india.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Responsible for planning and designing the Iseries part of project

●impact analysis done by using X-analysis and abstract tool, Work with multiple teams (E-comm, MQ series) to gather the requirements which are feeding/syncing data to Iseries through External AS400 Stored procedures

●Design new database files/tables/indexes to capture encrypted Payment details which are sent from the Front end application.

●Enhance the existing system to authorize payments using new/modified RPGLE/SQLRPGLE/CL/CLLE/store procedures programs to decrypt the payment details

●Enhance Pre-authorization, Post authorization using SQLRPGLE program

●Develop new SQL stored procedures to format payment data in XML and sent to ACI world (A cloud based third party payment authorization system)

●Used RESI APIs and SOAP to achieve the credit card tokenization and authorization.

●Parse the result of XML payment details into AS400 tables. Capture all events to store different levels of payment authorization.

●Refresh test data from production and alter according to testing needs and support for QA, UAT test users.

Project #7

Project Name : Channel advisor on boarding

Role : Team Member

Designation : Senior Developer

Project Period : March 15th, 2015 to June 10th, 2016

Technology : RPG/RPGLE, CL/CLLE, MQ, DB2

Configuration Tool : ALDON, I Navigator

Project management Tool : ADLON CMS

Other Tools : ABSTARCT, Find string PDM

Company : Softvision india.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Analyse the requirements shared by onsite project

●impact analysis done by using abstract tool and find string PDM

●Design new database files/tables/indexes to store or retrieve various channel advisor details like AMAZON, WALMART, EBAY etc.

●Enhance the existing CL/RPG/RPG IV programs to check Bealls inventory and If ordered item not available lookup at new channel advisor inventory. Based on product availability, send orders details to the channel for fulfilment.

●Create a new sync order process to notify the customer events like order placed, fulfilled and shipped details from the channel advisor.

●Prepare Unit test cases, documentations with all possible cases.

Project #8

Project Name : Crowd Twist and GK rewards

Role : Team Member

Designation : Senior Developer

Project Period : Sept 15th, 2014 to March 10th, 2015

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, MQ, DB2, REST API calls

Configuration Tool : ALDON, I Navigator

Project management Tool : ADLON CMS

Other Tools : ABSTARCT, Find string PDM

Company : Softvision india.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Analyse the requirements shared by onsite project

●impact analysis done by using abstract tool and find string PDM

●Design new database files/tables/indexes for bealls reward program

●Enhance the existing CL/RPG/RPG IV programs to call third part applications CT and GK to get the rewards on sales.

●Construct JSON format data and create new REST API calls to parse data to CT and GK. Store the response received at IFS path.

●Read JSON data stored at IFS folder and extract necessary data for the particular transaction,

●Read flat files stored at IFS path and convert into relational DB.

●Prepare Unit test cases, documentations with all possible cases.

Project #9

Project Name : CFC-VDS enhancements

Role : Team Member

Designation : Senior Developer

Project Period : Jan 10th, 2014 to Sept 15th, 2014

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, DB2

Configuration Tool : ALDON, I Navigator

Project management Tool : ADLON CMS

Other Tools : ABSTARCT, Find string PDM

Company : Softvision india.

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Analyse the requirements shared by onsite project

●impact analysis done by using abstract tool and find string PDM

●Design new database files/tables/indexes for Central fulfilment centre (CFC)/Vendor drop ship(VDS)

●Create new modules, capture CFC/VDS orders and modify the payment methods to pre-authorization, post authorization and reauthorization as per the technical design documents with the help of SQLRPGLE.

●Create new transaction tables to separate the fulfilment details from the store.

●Prepare Unit test cases, documentations with all possible cases.

Project #10

Project Name : Crown Jewel (Sensitive data Research)

Role : Team Member

Designation : Senior Developer

Project Period : Aug 25th, 2013 to Jan 10th, 2014

Technology : RPG/RPGLE/SQLRPGLE

Configuration Tool : ALDON, I Navigator

Project management Tool : ADLON CMS

Other Tools : ABSTARCT, Find string PDM

Company : Softvision india and synchro systech pvt ltd

Job Duties:

Involved in Analysis on I series system.

●Analyse the requirements shared by onsite project

●impact analysis done by using abstract tool and find string PDM

●As per PCI compliance, Bealls sensitive data stored across the Iseries system.

●Analysed data at all database file fields for PFs, SQL TABLES, flat files, RPG reports etc.

●Find out all programs which are dealing with sensitive data across the Bealls Application.

●Share all analysis details to the Onsite team and BA.

Project #11

Application : Merchandising

Project Name : Enhancement/Support

Role : Team Member

Designation : Senior Developer

Project Period : March 25th, 2013 to Aug 25th, 2013

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, DB2

Configuration Tool : ALDON, I Navigator

Project management Tool : ADLON CMS

Other Tools : ABSTARCT, Find string PDM

Company : synchro systech pvt ltd

Job Duties:

Involved in requirement gathering, developing enhancements, various testing phases and implementation.

●Analyse the requirements shared by onsite project

●Create a low level design document for code modification and share with onsite for client approval.

●Develop code to fix issues/enhance the existing system merchandise system.

●Prepare Unit test cases, documentations with all possible cases.

●Monitor the changes installed in production and support on call when required

Client Name : Scotia Bank, Canada.

Company : NEOWEBX INDIA SOLUTIONS PVT LTD

Project #12

Project Name : Basel 3 Enhancements

Role : Team Member

Designation : Developer

Project Period : March 1, 2012 to March 20th, 2013

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, DB2

Configuration Tool : Turnover, I Navigator

Other Tools : HAWKEYE, Find string PDM

Synopsis: Basel 3 regulatory committee has issued new regulations to strengthen Global Capital and Liquidity Requirements to promote a more elastic banking system. This requirement calls for the SG system to revise its overall funding and deposit strategies and product promotion. Currently, SG allows customers to early redeem their Deposits, which according to Basel 3 definition is a Cashable TD but not a fixed. Under Basel 3 regulations, A) Cashable TDs do not receive a better treatment than Fixed. B) Retail and Small business receive more favourable treatment than Commercial. However, currently, the SG system treats all these customers with the same price as they share the common rates.

As a result of this, we require to address the Basel 3 treatments.

Job Duties:

●Enhanced proper fixed term deposit portfolio which involves RPG/CL/RPGLE programs

●Prepare unit test documents and deliverables.

●Provide support for the code developed

●Provide Production support for the application that is working on

Project #13

Project Name : Debt Manager (Collections)

Role : Team Member

Designation : Developer

Project Period : July 1st, 2012 to Feb 25th, 2012

Technology : RPG/RPGLE/SQLRPGLE, CL/CLLE, DB2

Configuration Tool : Turnover, I Navigator

Other Tools : HAWKEYE, Find string PDM

Job Duties:

●Analysing the business requirements and preparing Technical Requirement document accordingly

●Develop code, prepare unit test documents and deliverables.

●Provide support for the code developed

●Provide Production support for the application that is working on

Project #14

Project Name : File Transfer Support

Role : Team Member

Designation : Developer

Project Period : Aug 10th, 2011 to June 30th, 2012

Technology : RPG/RPGLE, CL/CLLE, DB2

Configuration Tool : Turnover, I Navigator

Other Tools : HAWKEYE, Find string PDM

Job Duties:

●Analysing the business requirements and preparing Technical Requirement document accordingly

●Develop code, prepare unit test documents and deliverables.

●Provide support for the code developed

●Provide Production support for the application that is working on

Project #15

Project Names : Fraud Monitoring Role and Fee map maintenance

Role : Team Member

Designation : Developer

Project Period : Apr 27h, 2009 to Aug 10th, 2011

Technology : RPG/RPGLE, CL/CLLE, DB2

Configuration Tool : Turnover, I Navigator

Other Tools : HAWKEYE, Find string PDM

Job Duties:

●Analysing the business requirements and preparing Technical Requirement document accordingly

●Develop code, prepare unit test documents and deliverables.

●Provide support for the code developed

Visa: H1-B Approved.

B1 Approved.

Contact this candidate