Candidates About

 

Nagendra R Kondeti

PROFESSIONAL PROFILE:

Highly motivated and enthusiastic Oracle Applications Consultant/Developer with proven expertise in both Technical and Functional capacities. Outstanding technical skills in implementing Oracle Financials (several modules).Experienced in writing functions, procedures, packages and database triggers, Unix Shell Scripting. Experienced in Data Conversion Strategies Experienced in tuning SQL statements using proper Hints. Ability to work autonomously as well as a team player.  Easily  adaptable  to change with an eagerness towards learning and expanding capabilities.

 

SOFTWARE SKILLS:

ERP/CRM:

Oracle Applications 10.7SC/11.0/11i/12i AOL, GL, AR, AP, INV, ONT(Order Management) , Shipping, PO. SYSADMIN,EDI Gateway(Oracle EC-Gateway), BOM, WIP, MFG, WORK FLOW, Oracle Data warehousing, Service Contracts, salesforce.com, Working knowledge in BPEL(Business Process Execution Language).Retek(10.6)

OS:

MSDOS, UNIX (HP,SOLARIS,IBM AX), LINUX, WINDOWS9x, NT,WINDOWS 2000,Windows XP, Windows Vista, Windows 7

 4GL/Case Tools:

C, SQL, PL/SQL, COBOL, PERL, SED, AWK, B-SHELL, K-SHELL CL/400, Cobol/400, RPG/400, FORTRAN, BASIC. DEVELOPER 2000(FORMS4.5/5.0/6.0(6i)/9i, REPORTS 2.5/3.0/6.0(6i)/9i),VISUAL    BASIC, HTML, CICS,  Synon 2e. SQL * Loader, SQL Trace, TKPROF utility, JCL, MVS, SQL Navigator, TOAD ,Procedure Builder.PL/SQL Developer. GNOME, KDE, CDE. Pro*C, Designer/2000/6i/9i, Discover3i/4i/9i,A/S400,Synon4(e), Oracle Warehouse Builder, XML, JAVA2, Oracle JDeveloper,(Developing RIA Web applications with ADF), Working knowledge of BPEL(Business Process Execution Language),  Cloud Computing, Informatica (ETL)10.X, Oracle BI Enterprise Edition(OBIEE)

DBA Skills:  

Installation of 9i, 10g, 11g Databases. Creating RAC instances. Administering the DBA tasks using Oracle OEM. Configuring Net using Oracle Net configuration assistant (configuring listeners, Naming methods configuration, Local net service naming configuration, Directory usage configuration). Creating databases, modifying the existing database parameters etc. Creating different kinds of tablespaces, users etc. Exporting, importing data files. Monitoring Users activities.  Configuring web based isql* plus etc. Creating Backup schedules, exporting and importing Database Tables info. Web logic Server Configuration.

 

PROFESSIONAL EXPERIENCE:

 

Client:                   IBM-Cooper Vision Victor, NY

Period:                2015 Aug - Present

Project:                 CVI EDI.

Title:                      Sr. Oracle EBS EDI Lead/EDI Architect

 

 Cooper Vision is one the reputed company that manufactures contact lenses. Its business operations spans  more than 70 Countries around the world that includes Asia pacific, Europe Organizations US/Canada, Mexico, Brazil, South Africa etc.

 

Ø  Designed Inbound, outbound directory structures and associated archive, error directories. Where sterling to drop the files and from where sterling to pick up the file.  Bank files (Payment Order files) to capture in separate directory structure for security reasons.

Ø  Designed and developed automation process for inbound files. Inbound files are coming by country wise. Automation process is designed to handle all files of particular transaction by country are grouped and make a bulk file and file has to be pushed to native process to process.

Ø  Designed and developed the EDI files audit process. In order to keep the data processing in sync we need auditing the files process (file received vs files sent by Sterling and File generated by EBS vs files received by Sterling.) etc. Inbound files are batched by country. 

Ø  Designed and developed EDI850 Purchase orders inbound process for stagnated documents.

Ø  Designed and developed the item derivation Process based on lens parameters.

Ø  Designed outbound director process for handling all edi outbound transactions that are created files in outbound directory.

Ø  Incorporated the functionality of auditing the outbound files.

Ø  Designed and developed the EDI850 POI Wrapper program to process the EDI850 file with legacy address ref and without EDI Location Code.

Ø  Designed and developed ASN wrapper Program.

Ø  Designed and developed INO wrapper program and extension process.

Ø  Designed and developed POAO/POACO wrapper Programs.

Ø  Designed Audit files report, Stage Documents Report, Item validations and deletion of interface data report.

Ø  Designed multi-threaded triggering process for all inbound files.

Ø  Designed multi-threaded triggering process for all outbound transactions.

Ø  Assisted 3PL transactions (940/945) etc.

Ø  Designed ASN, INO re-con reports.

Ø  Designed Inbound ASNI wrapper program.

Ø  Provided Use cases and user training in Oracle EDI.

Ø  Resolved several issues with Oracle through Oracle SRs.

Ø  Managed and trained several countries EDI personal for the client.

 

Environment:

Oracle Applications 12i (12.2.3)/ (Oracle Payments, Oracle Field Service, Oracle Depot repair, Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory,  Receivables, Purchasing, Payables, Service Contracts,  Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i,  9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

 

 

Client:                   IBM-TOSHIBA

Period:                2014 Feb – 2015 Aug

Project:                 TGCS Plan B Project.

Title:                      Sr. Techno-Functional Consultant/EDI Tech Manager

 

 TOSHIBA is entering into POS sale world. IBM is one of the prime vendor in implementation of Oracle EBS V12.1.3. Involved primarily in Integration and Interfaces. Main tasks completed as follows.

 

Ø  Integration of Oracle Payments System with Third Party Payments System (Tsys) for Credit Card Authorization Funds Capture and Funds Disbursement.

Ø  Configuration of Oracle Payments System.

Ø  Developing the interface INT-CSP001-I for Inbound Scrap Adjustments to Oracle Field Services.

Ø  Developing INT-CSP002-O outbound Interface for sending Scrap Pos and Requisitions to UPS.

Ø  Developing INT-CSP015-I for Vendor Scrap Adjustments for REPAIR and SORT vendors importing for repair and scrap items into Inventory Miscellaneous Transactions

Ø  Developing the second part of the above interface for REPAIR sourced items to create internal requisitions into Oracle Field Service.

Ø  Coordinating with Other functional teams for information gathering for developing the interfaces.

Ø  Coordinating to peers for their development for interfaces.

Ø  Coordinating Oracle Corp for SR creation on Oracle Payment Systems and follow ups.

Ø  Coordinating DBA team for Oracle recommended setups and generating logs and debug files and uploading to Oracle etc.

Ø  Coordinating off shore team for integration.

Ø  Developing Technical docs (TDD), DOUs etc.

 

Environment:

Oracle Applications 12i (12.1.3)/ (Oracle Payments, Oracle Field Service, Oracle Depot repair, Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory,  Receivables, Purchasing, Payables, Service Contracts,  Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i,  9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

 

 

Client:                   Sonoco Products Company, Arlington Heights, IL

Period:                2013 Nov – 2014 Feb

Project:                 Oracle EDI/Oracle Release Management (EBS 12i Implementation)

Title:                      Sr. Techno-Functional Consultant

 

About Sonoco

Founded in 1899, Sonoco is a global provider of a variety of consumer packaging, industrial products, protective packaging and supply chain services. With annualized net sales of approximately $4.8 billion, the Company has more than 19,900 employees working in 34 countries, serving some of the world’s best known brands in 85 nations.  Sonoco is a proud member of the 2013/2014 Dow Jones Sustainability World Index.

Sonoco has many manufacturing plants in US, scattered across many locations. Some are in Orlando, FL, New Bern NC, and Tiffin OH etc. Sonoco acquired automotive customers like Toyota, Honda, Hyundai, KIA, Chrysler etc., for their packaging needs. Also they have other customers like Whirlpool, Bosch etc. for their freezers and washing machines packaging needs.  Automotive industries use Release Management as their gateway for their demands. They send demands in the form of EDI transactions

a)     Planning Schedules (EDI 830).

b)    Shipping Schedules (EDI862). 

 

As a Techno Functional consultant, I worked on

Ø  Training the Sonoco team in RLM setups for Frozen, Firm, Forecast demand needs,

Ø  EDI gateway setups.

Ø  Correcting Customer, Item X refs, Customer Cross reference setups.

Ø  Correction of Forecast Source lists by customer etc.

Ø  Creation of mapping templates for the above two transactions.

Ø  Guiding X12 mapping team for Oracle ERP suitable file translation.

Ø  Unit testing, flow through testing for the above two transactions.

Ø  Developing Gap Documents for Customer ASN transactions.

Ø  Developing technical document Using Extensible Architecture for Customer ASN Transactions.

Ø  Whirlpool Consignee order shipments and ASN Customization.

Ø  Assisting Whirlpool IRSO transactions etc.

Ø  Assisting Order Management/Shipping related issues etc.

Ø  Designing Inbound Product activity Data Transaction EDI852.

Ø  Developing Process for EDI852 Process.

Ø  Assisting Auto-invoice issues.

Ø  Assisting Receiving Transaction issues.

Ø  Toyota Customer DSNO Pre-Validation Report Process design.

Ø  Honda Customer DSNO Pre-Validation Report Process design.

Ø  Developed RLM Transactions Trouble Shooting Strategies.

Ø  Designed Testing Strategies for RLM Transactions.

Ø  Creation of MD50, MD70s for Consignee Order DSNO process.

Ø  Creation of MD50, MD70s for Consignee Org Receipt Process.

Ø  Creation of Oracle SR for Global Forecast List usage for RLM and resolving the issue.

Ø  User Training for RLM transactions.

 

Also acted as Tech Manager for EDI Integration. Coordinating Sterling Team, Middleware Team and End customer and supplier EDI Teams for effective input and outputs of  EDI Transactions integration. Conducted several meetings among the teams and gathering the tasks info and diversifying the tasks. Assigning the tasks to team members and monitoring the task progress. Presenting the EDI Integration status to Client side functional and other stake holders. Estimation of man hours and costs involved in the development of custom objects and maps etc. Effective delivery of deliverables and user trainings. Co-ordination among Functional and development teams etc. Arranged daily standup calls with the development team. Resolving issues in development team for hurdles faced while development. Discussion alternate solutions with development team and presenting it to clients team etc. Presenting the project plan and % of completion and pending in bar diagrams, pie diagrams etc. Scaling down any un-necessary development tasks and seeing the cost based development activities to protect the implementation with in the budget lines.

 

 

 

Environment:

Oracle Applications 12i (12.1.3)/ (Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory,  Receivables, Purchasing, Payables, Service Contracts,  Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i,  9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

 

 

 

Client:                   Tervis Tumbler Company, Venice, FL

Period:                2012 Jun – 2013 Nov

Project:                Project Sherpa (EBS 12i Implementation)

Title:                      Sr Technical Consultant.

 

Tervis Tumbler Company is mid-size manufacturing company over 65 years of age that manufactures double walled tumblers, ice buckets and water bottles. Tervis has wide variety of customers like Bed Bath and Beyond, Belk, Sam’s Club, Macy etc. and also individual residential customers. 75% of their business runs on Edi (EDI850, EDI810, and EDI856). Also they have 3^rd Party Warehouse for 3PL Logistics dealing with EDI940, EDI945, EDI943, EDI944, and EDI947 transactions. Tervis planned to expand their business and current software will not support lot of activities. Tervis planned to go for Oracle EBS 12i with Order Management, Purchasing, Inventory, Flow Manufacturing, BOM, WIP, Shipping, Receivables, and Payables etc.

As one of the Sr technical consultant, my responsibilities involved in designing custom processes, modifications of existing processes, designing discoverer reports and OBIEE Answers and Dashboards etc. Primary tasks completed are

 

·         Designed  and Created Wip to Bom Sub inventory Transfer process for Decoration and Label Items.

·         Designed and created Discoverer Reports (Many of them have the Pre-process PLSQL packages). Some of them are,

a)        ‘Tervis Sales Results Info Report’

b)       ‘Tervis Manufacturing Data Collection Report’

c)       ‘Tervis Sales By Territory Report for BBB’

d)       ‘Tervis Vendor Purchases By Item Report’

e)       'Tervis Demand Lines Info for Production Scheduling and Planning'

f)        'Tervis MRP Quality RMAs and Warranties Info Report'

g)       'Tervis Credit Memos by Reasons Report'

h)       'Tervis Customer Accounts Segmentation Report'

i)         'Tervis Orders Daily Count Info Report'

j)        'Tervis Pipeline Report'

k)       'Tervis Top Customers Sales Comparison Report' etc.

·         Enhancements for EDI 944 Transaction for Blanket Pos.

·         Enhancements for EDI943 Transaction.

·         Enhancements for EDI945 Transaction.

·         Flow Testing from 3PL warehouse to EBS and EBS to 3PL warehouse via Biz Talk services.

·         Configuring the Dunning Letters of different degrees using Advanced Collections/Receivables.

·         Modifying the Dunning Letters suitable to Tervis Needs.

·         Creating Different Kinds of FSG reports.

·         Enhancements for Integration processes for Flow Schedules, Price Lists, Items, BOMs, Store Locations etc.

·         Designed and created process for internal requisitions integration and receipt against internal requisitions.

·         Creating Migration Scripts to move database objects from instance to instance to instance.

·         Data reconciliation for deliveries, orders, customer, items, requisitions  between EBS, RMS, MES, WCS etc.

·         Creation of data discrepancy reports across instances and across multiple platforms.(EBS, RMS,MES,WCS, EMU , SIT, UAT etc.).

·         Creation of SRs with Oracle and resolving them.

·         Creation of process for Internal Org Transfers.

·         Resolving Freight Amounts info from 3PL Warehouse Ship Confirmation Messages on Invoices.

·         Performance and Tuning for Sales Orders Outbound View and Manufacturing Data Collection Pre-Processor.

·         Provided User Training on RMS -> EBS -> RMS internal requisitions and internal sales orders.

·         Configuring Smart Bare QA Complete/Test Complete. Selenium software for Testing.

·         Configured Oracle Data Integrator (ODI) for data imports into custom tables from Flat Files, to replace informatics tool.

·         Configuring Ignite Software for Database Performance monitoring.

·         Configuring Web-logic Server for SOA.

·         Configuring BAM and SOA servers.

·         Developed standalone ADF pages for Manufacturing Data Collection, Integration Processes, EDI Processes.

·         Technical Resource planning and Tasks Planning.

·         Organized Technical discussions with other peers and associates. Functional discussions with end users.

·         Trained end users in Applications Navigation, and running reports etc.

·         Involved in designing ‘Double Blind Shipments’ process. And modifications for Pick slip and Pack slip reports for this kind of shipments.

 

 

Environment:

Oracle Applications 12i(12.1.3)/ (Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management(EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory,  Receivables, Purchasing, Payables, Service Contracts,  Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i,  9i and 10g. SQL Navigator, PL SQL Developer,  HP UNIX., RICE . Gentran 4x, XML Publisher(BI Publisher). Biz Talk B2B translator.

 

 

 

 

 

 

 

Client:                   Elkay Companies, Oak Brook, IL

Period:                2012 Jan  - 2012 Jun

Project:                ELKAY Plumbing EBS/EDI

Title:                      Tech Lead Oracle EDI

 

Elkay Company is 92 Year Old Manufacturing company, that manufactures facets, stainless steel sinks etc. Elkay has wide variety of customers like Star Bucks, Home Depot, Menards etc. and getting products from variety of suppliers like North American Corp, North American Stainless Steel, Great Lakes Packaging etc. This project is the fresh implementation of Oracle EBS version 12i for their legacy ERP people soft. 

 

Main tasks completed in this assignment.

 

·         Designed and created process for Account Receivables and Account Payables finance documents uploading and downloading from various banks.

·         Designed and created reconciliation process for their day to day EDI transactions between Oracle EBS suite and IBM in-flight.

·         Designed and created Supplier ASNs (EDI856 Inbound) post process, to bring the suppliers purchasing sites from purchase orders and triggering mail system to send mails for AP department if the Purchase order is for PRE-PAID terms etc.

·         Designed  and created Supplier Invoices (EDI810 Inbound) Post Process to get the functionality of bringing GL accounting structures for Miscellaneous Charges, Freight Charges, Taxes etc.

·         Designed and created Consolidation/Automation process for all EDI transactions, except Customer Pos

·         Designed and created Consolidation Process as a separate process for Customer Pos.

·         Designed and created custom EDI945 Process to do ship-confirmation automatically.

·         Created XML Publisher Reports for Customs submission purpose, Supplier ASN receiving, Ap Invoices, Customer Trading Partner Setups and Supplier Trading Partner setups and Reconciliation reports for various EDI transactions

·         Designed and Created secure ftp process from Oracle EBs to ITC servers followed by ITC to City Bank Servers.

·         Created MD120s, MD80s for the implementation.

·         Provided User Training

·         Designed and created adhoc Process for re-generating the various EDI transactions after first pass.

·         Provided queries to users for day to day enquiries.

·         Created OBIEE Answers and Dashboards.

·         Involved in Trading Partner data conversion, and Transactional data conversions like Open Pos, and Open Sales Orders and Open AR and Open AP Invoices.

·         Developed several crystal reports for EDI transactions.

 

Environment:

Oracle Applications 12i(12.1.3)/ (Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management(EAM), Custom schemas XXELKAY_TOP, XXDAZ_TOP, Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory,  Receivables, Purchasing, Payables, Service Contracts,  Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i,  9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher)

 

 

Client:                   Hollander Home Fashions Inc., Boca Raton, FL

Period:                   Sept 2010 - 2012 Jan

Project:                HHF EDI

Title:                      Techno-Functional Consultant

 

 

Hollander Home Fashions is one of the leading company in home fashion products like Pillows, Blankets and Mattresses Pads etc. It is a multinational company, ranging from Canada, Mexico and India etc. HHF is going to be on Oracle ERP wit