KARTHIK KRISHNAPPA

SUMMARY: Over **+ years of IT experience in Analysis, Design, Development and testing of Software projects in AS/400(iSeries) with emphasis on RPGLE, RPG IV, RPG/400, CL/400, DB2/400, Query/400, SQL/400, BPCS (Business Planning and Control System).

Worked as Programmer/Senior Consultant in a wide variety of Industries including Transportation, Investment banking, manufacturing and Retail.

Creative self-starter with strong analytical and programming skills.

Expertise in data processing with responsibility for diverse industries and applications using IBM AS/400 with structured RPGLE, RPG/IV, RPG/400, RPGIII, Free Format RPG, CL and CLLE programming.

Expertise in Display files processing and sub file-programming techniques.

Expertise in Batch and interactive jobs programming.

Proven ability to quickly grasp client needs and implement successful strategic plans.

Proficient in planning and completing projects to high standards in time-critical situations.

Exposure in SDLC (Software Development Life Cycle), handling the projects in both Offshore and On-site developments and Strong organization skills and ability to meet deadlines.

SKILLS: Operating Systems: OS/400, Windows9X/NT/2K Languages: RPGIII, RPG IV, ILE RPG, RPG Free, CLP, Embedded SQL, SQL/400, Query/400 DB2/400, Python Tools/Utilities: SDA, DFU, SEU, RLU, THENON, Implementer, Turnover, DBU, PDM, Hawkeye, MS-Office, FTP, SFT and MFT. ERP Applications: BPCS (Business Planning and Control System)

CONTACT INFO:

Email: adkbpk@r.postjobfree.com

Phone: 631-***-****

EXPERIENCE:

CVS Healthcare, Buffalo Grove, IL Aug 2020 to till date

Part of the production support team, supporting Drug, Prescription and Eligibility areas on RxClaims application. As part of the responsibilities have been providing Level II support for the application, support business queries, resolve functional issues and triage application problems to the applications development team.

Environment: AS/400, RPG IV, CL/400, Query/400, DBU, COBOL/400, DB2/400

Werner Enterprises, Omaha, NE Oct 2017 to July 2020

Senior Consultant

Werner Enterprises, is a premier transportation and logistics company, with coverage throughout North America, Asia, Europe, South America, Africa and Australia. Werner is among the five largest truckload carriers in the United States, with a diversified portfolio of transportation services that includes dedicated; medium-to-long-haul, regional and expedited van; and temperature-controlled.

Was involved in a number of accounting and finance projects:

EFS Driver Fuel card: As part of a new initiative all drivers were provided with new fuel cards partnered with a third party called EFS. I was part of the team that developed and maintained the project. Implemented maintenance screens, weekly audit reports to verify the authenticity of cards between Werner and EFS. Verify the monthly card charges that were transmitted to Werner via csv and xml files and process them.

Driver Annual Achievement Bonus: As part of a driver retention policy, a new type of bonus was introduced. This would be paid annually based on the driver’s seniority date. To qualify the driver had have completed certain requirements. These requirements were broken down to individual modules. Due to certain business decisions, a kind of switch was provided to turn these modules on/off dynamically.

Driver Direct Deposit Transfers: Werner classifies drivers and employees into various divisions. This project was developed to provide them a feature to transfer their direct deposit between the various divisions when they transfer between divisions. There are certain criteria’s that has to be met for the transfer to be successful. These criteria were created as modules to make them more dynamic.

Excess miles deduction: Owner operated trucks have a certain number of miles allotted to them per quarter. When they quit in the middle of any quarter, the number of miles driven is calculated and checked if they have exceeded the allocated miles. A fixed amount per excess mile is set and deducted from the driver’s next payroll.

Responsibilities:

Developing the applications on IBM AS/400(iSeries) using RPGLE, Free Form RPG, Embedded SQL

Prepare unit test cases, participate in user acceptance test

Work with production support team in identifying and fixing production issues

Analyzing the existing code and prepare documentation for it

Environment: AS/400, RPG IV, RPG Free, CL/400, MQ-Series, Query/400, Embedded SQL, DB2/400, XML, SDA, DBU, Excel, Win XP, OS/400.

Mindtree Ltd. Phoenix, AZ Feb 2015 to Sep 2017

Technical Lead

Global Max (GMAX)

American Express Global Business Travel (AmexGBT) is a global leader in business travel management. The consumer travel network is one of the world’s largest with more than 2000 locations worldwide. Amex’ Global Travel Services consists of AmEx business travel and Global Foreign Exchange Services. It offers business travel products and services for corporate travelers. AmEx Travel Management provides Services mentioned below (mainly for corporate concerns) -> Flights/Cars/Hotels/Vacations/Cruises. American Express Travel Services offers the best self-booking tools available, allowing clients to save time while still managing their travel portfolio. GMAX (Global Max) is a Global Accounting system for AmEx Travel Services. It maintains the AmEx Travel Management financial services for different global markets (over 29 markets). Each market has many branches. GMAX application resides on the IBM system I AS400 server.

Responsibilities:

Provide Level II support for the application, support business conversion projects, resolve functional issues and triage application problems to the applications development or system support functions.

Manage data interfaces from various GDS front office (like Sabre, Amadeus, Apollo, etc.) via MQ into GMAX.

Manage data interfaces of card feeds (AMEX, VISA, MasterCard) to various partners for different markets

All file flows in and out of GMAX is via Managed File Transfer (MFT). Was part of migration from SFT to MFT. Have created and maintained file flows in MFT.

Recently the accounting part of GMAX was migrated from legacy system to cloud based system called NetSuite. Was part of the team that helped with this migration activity.

Provide 24/7 support during all migration activities.

Perform month end reconciliation to match the financials in GMAX and NetSuite.

Developed utility to check the flow of transactions from GMAX to NetSuite, report any errors to business for corrections.

Modifications, enhancements, bug fixes to the existing code

Environment: AS/400, RPG400, RPG IV, RPG Free, CL/400, MQ-Series, Query/400, Embedded SQL, DB2/400, SQL/400, SDA, DBU, Excel, Win XP, OS/400.

Mindtree Ltd, Ronkonkoma, NY Nov 2013 to Jan 2015

Technical Lead

NBTY (Vitamin World)

NBTY is a leading global and vertically integrated manufacturer, marketer and distributor of a broad line of high-quality, value-priced nutritional supplements in the United States and throughout the world. Under a number of NBTY and third party brands, the Company offers over 22,000 products, including products marketed by the Company’s brands such as Nature's Bounty®, Vitamin World®, Puritan's Pride®, Holland & Barrett®, Rexall®, Sundown®, MET-Rx®, Worldwide Sport Nutrition®, American Health®, GNC (UK)®, DeTuinen®, LeNaturiste™, SISU®, Solgar®, Good 'n' Natural®, Home Health™, Julian Graves, Ester-C® and Natural Wealth.

NBTY business spread across US, UK (H&B) and many other countries. NBTY’s sales channel can be classified as follows,

1. Direct Response – Mail Order, Web options (Example: Puritans pride, MET-RX, H&B, VWMO)

2. Retail – VW Stores, H&B, D.T. Stores, GNC UK

3. Wholesale – Wholesale, private label, exports

Responsibilities:

Provide Level II support for the application, support business conversion projects, resolve functional issues and triage application problems to the applications development or system support functions.

Unique environment where each store had an iSeries system, and they were all in turn connected to the Home Office, where all the business rules and promotions were maintained.

Manage store purchase orders, promotions, deals, coupons

Prepare and publish customer’s quarterly bonus rewards

Develop and document workarounds for functional issues that client have in Integration and User acceptance test environments

Deploying the Application in various environments such as Development, System test.

Modifications, enhancements and bug fixes to the existing code

Environment: AS/400, RPG400, RPG IV, RPG Free, CL/400, MQ-Series, Query/400, Embedded SQL, DB2/400, SQL/400, SDA, DBU, Excel, Win XP, OS/400.

Fidelity Information Services, Bangalore, India Aug 2010 to Oct 2013

Software Engineer

Horizon (Core Banking Product of FIS)

FIS is the world’s largest global provider dedicated to banking and payments technologies with a long history deeply rooted in the financial services sector, FIS serves more than 14,000 institutions in over 100 countries. FIS delivers the most comprehensive range of solutions for the broadest range of financial markets and holds leadership positions in payment processing and banking solutions, providing software, services and outsourcing of the technology that drives financial institutions.

Horizon is one of core banking product of FIS.

Responsibilities:

Worked on various conversion projects. Typically establishments which were acquired by existing HORIZON customers.

Develop/manage data in different bank setups and environments.

Modifications, enhancements and bug fixes to the existing code.

Report directly to management in US, provide current status on all resolved/unresolved issues

Deploying the Application in various environments

Environment: AS/400, RPG400, RPG IV, RPG Free, CL/400, Query/400, Embedded SQL, DB2/400, SQL/400, SDA, DBU, Win XP, OS/400.

Mindtree Ltd, Bangalore, India Jan 2010 to Aug 2010

Software Engineer

UNILEVER Application Support

BPCS (Business Planning and Control System) ERP is the main transaction processing system used by 11 Unilever companies in South East Asia region and Australia /New Zealand.

Responsibilities:

Enhancements to existing BPCS ERP application.

Modifications, enhancements and bug fixes to the existing code.

Analyzing the existing code and document.

Support data migration activities during enchantments to various versions of BPCS, as different markets had different versions.

Provide level 2 technical support for the application.

Environment: AS/400, ILE RPG, RPG/400, RPGIII, RPG IV, CL/400, Embedded SQL, Query/400, DB2/400, SQL/400, BPCS Ver6 to Ver8, SEU, SDA, RLU, Win 9x/NT, OS/400, THENON, Rumba, ASSET and MQ-Series

Mindtree Ltd, Bangalore, India Aug 2007 to Nov 2009

Software Engineer

Crate and Barrel

Crate & Barrel opened its first store in 1962 as a family business and today is one of the leading houseware and furniture retailers in US. Mindtree's relationship with Crate & Barrel started in 2004. The client manager responsible for all application development projects is situated at Bangalore facility. MindTree has worked on number of projects like Corporate Sales, Gift Registry, Vendor Chargeback, Merchandising Charge Backs, Trip Booking, Virtual inventory etc. These applications have been developed to run on the iSeries.

Virtual inventory: This project mainly deals with the inventory information.

As part of the project C&B decided that all the direct writes/updates to the inventory files were to be replaced by API calls.

The team was involved in identifying the programs which do either write/Update the Inventory files, and making the modifications to these programs by introducing the API.

Gift Registry System: Gift Registry is a very popular concept used in the retail industry. It involved options to create/maintain a registry.

The project was to completely rewrite the gift registry application to incorporate data coming from Green screen, web and the kiosk.

Foreign Trade Zone: The concept of FTZ was introduced to track the duty paid for import goods.

Responsibilities:

Developing the applications on IBM AS/400(iSeries) using RPGLE, Free Form RPG, Embedded SQL, CL, Open Query Files and Sub files.

Participate in applications design, database modeling, user interface design, program design, writing of technical specifications and design walkthroughs.

Was part of implementation team at C&B headquarters in Chicago IL for Gift Registry project.

Prepare details test cases, work closely with QA team in bug fixes and post implementation support.

Writing of technical specifications and design walkthroughs.

Modifications, enhancements and bug fixes to the existing code.

Analyzing the existing code and document.

Environment: AS/400, RPG400 ILE RPG, RPG Free, CL/400, Query/400, Embedded SQL, DB2/400, SQL/400, SDA, DBU, Win XP, OS/400.

Mindtree Ltd, Bangalore, India Oct 2005 to Jul 2007

Software Engineer

UNILEVER Development

BPCS (Business Planning and Control System) ERP is the main transaction processing system used by 11 Unilever companies in South East Asia region and Australia /New Zealand.

Responsibilities:

Developing the applications on IBM AS/400(iSeries) using RPGLE, Free Form RPG, Embedded SQL, CL, Open Query Files and Sub files.

Participate in applications design, database modeling, user interface design, program design, writing of technical specifications and design walkthroughs.

Writing of technical specifications and design walkthroughs

Prepare test cases and user notes.

Environment: AS/400, RPG400 ILE RPG, RPG Free, CL/400, Query/400, Embedded SQL, DB2/400, SQL/400, SDA, DBU, Win XP, OS/400.

Mindtree Ltd, Bangalore, India Sep 2004 to Sep 2005

Software Engineer

Labor Management

Labor Management is used within Spectrum for Arcadia to measure and report Operative Performance and Efficiency. The current Labor Management system used is PC-based and is written in a language (Visual Basic) that is no longer part of the Information Systems strategic tool set. The system is heavily dependent on manual data entry and is labor intensive and prone to inaccuracy. The entry of data relating to picking activity accounts for over 50% of Labor Management clerical time and represents the biggest win in terms of automating data capture.

Responsibilities:

Developing the applications on IBM AS/400(iSeries) using RPGLE, Free Form RPG, Embedded SQL, CL, Open Query Files and Sub files.

Participate in applications design, database modeling, user interface design, program design, writing of technical specifications and design walkthroughs.

Writing of technical specifications and design walkthroughs

Prepare test cases and user notes.

Environment: AS/400, RPG400 ILE RPG, RPG Free, CL/400, Query/400, Embedded SQL, DB2/400, SQL/400, SDA, DBU, Win XP, OS/400.

EDUCATION: MCA (Master of Computer Applications)

Contact this candidate