Oracle Developer
Resume:
NAGENDRA R KONDETI
***********@*****.***
407-***-**** (H)
Orlando, FL 32837
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 - ICU Medical, NY
Period: 2018 March - Present
Project: Hospira EDI.
Title: Architect/Tech Lead
Icu Medical Acquired the European Organizations (ES, FR, NL, AU, IR, UK etc). IBM is prime vendor to bring all these operating units to existing Oracle EBS 12.2.4. EDI is one of the means these organizations doing their business. I was hired to bring ES operating unit on live. ES deals with 850/810/855/856 and 861. 850/855/810/856 are core transactions and are supported by Oracle. Where as EDI 861 is customer receipt advice is unsupported transaction. Architected the EDI861 Inbound transaction. Also Designed the extensions for 810/855. Designed for EDI850 Pre and Post Process.
Successfully went live on June 2018. Currently working on FR to bring to live.
Bring the Sterling Mapping team, Oracle Offshore team to unison and conducted team meetings to monitor progress.
Allotted work tasks to Offshore team and mapping issues to SI team for. Monitored to complete them in time.
Bring the customer side translation team EDICOM (ES) and CEGIDEM (FR) on the same bench to discuss business needs and mapping issues European EDIFACT file formats and EBS Oracle formats.
Used Spec Builder to verify and validate the mapping info done by mappers.
Used EDIFACs Transaction Manager to track the documents in and out and source and translated documents etc.
Organized everyday tech meetings with offshore teams to monitor the progress, and to mentor them.
As an architect, designed the item derivation Process based on EAN/Catalogue Numbers
As an architect, designed customer TRN number derivation for Invoices.
As an architect, designed Customer EDI861 (Customer Receipt Advice info) custom process to hold the invoices until we get the customer acceptance info.
As an architect, designed the report for EDI861 for validating against Shipped Quantity vs Customer accepted quantity.
As an architect, designed for customer Correspondence To Address derivation and Correspondence to Address GLN derivation.
Trained users how to identify the issues and resolve the issues.
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.
Configured Oracle Integration Cloud Services (OICS) EBS cloud Adaptor for triggering XML gateway Purchase order Acknowledgment Extraction Process, Outbound Invoice extraction for NL.
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-Cooper Vision Victor, NY
Period: 2015 Aug – 2018 Feb
Project: CVI EDI.
Title: Tech Manger/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.
Organized internal Sterling team and Oracle team to discuss the business flows, organizational Sales order creation requirements, mapping sessions, etc.
Gathered the tasks info, divided among the Translation team, offshore team. Monitored the progress.
Conducted team meetings both on site and offshore with and without translation team. Monitored the progress and offered the suggestions for enhancements and to over come the hurdles in development.
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.
From 1999 to 2013 Worked several clients. Clients info and titles provided bellow.
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
Client: Tervis Tumbler Company, Venice, FL
Period: 2012 Jun – 2013 Nov
Project: Project Sherpa (EBS 12i Implementation)
Title: Sr Technical Consultant.
Client: Elkay Companies, Oak Brook, IL
Period: 2012 Jan - 2012 Jun
Project: ELKAY Plumbing EBS/EDI
Title: Tech Lead Oracle EDI
Client: Hollander Home Fashions Inc., Boca Raton, FL
Period: Sept 2010 - 2012 Jan
Project: HHF EDI
Title: Techno-Functional Consultant
Client: DS Waters Inc., Atlanta, GA
Period: Jan 2010 – Sept 2010
Project: SWGDD/SWGRTM
Title: Techno-Functional Consultant
Client: Hypercom, Phoenix, AZ
Period: Feb 2008 – JAN 2010
Project: HypEDI / Euro(Thales) Integration
Title: Techno functional consultant/Programmer Analyst
Client: Mercury Marine, Fond Du Lac, WI
Period: April 2007 – Feb 2008
Project: MMEC Wave2 OTC
Title: Techno Functional Consultant/Programmer Analyst
Client: United Components, Evansville, IN
Period: Nov 2004 – Mar 2007
Project: 11i Implementation/Upgrade
Title: Techno Functional Consultant/Programmer Analyst
Client: 3Implant Innovations Inc, West palm Beach, FL
Period: June 2004 – Nov 2004
Project: 11iUpgrade
Title: Application Consultant/Programmer Analyst.
Client: Imagistics Inc, Shelton, CT
Period: April 2004 – Jun 2004
Project: Symphony
Title: Techno Functional Consultant.
Client: Handleman & Co, TROY, MI
Period: Dec 2003 – April 2004
Project: Symphony
Title: Techno Functional Consultant
Client: Helen Of Troy, El Paso TX
Period: Sept 2003 – Dec2003
Project: HOTEDI
Title: Techno Functional Consultant
Client: Waterpik Technologies, CO
Period: March 2003 – AUG 2003
Project: WPIKEDI
Title: Techno Functional Consultant
Client: Schreiber Foods Inc., WI.
Period: Jun2002 - Feb2003.
Project: SFIEC(Schreiber Foods Inc Electronic Commerce)
Title: Techno Functional Consultant.
Client: ShopNBC, MN
Period: Jul l2002 - Sep 2002
Project: Value Vision (e-commerce/EDI Gateway/Drop Ship Invoices)
Title: Application Consultant
Client: Tupperware Corporation FL
Period: Aug 2001 - Jul 2002
Project: TUPEC(Tupperware Electronic Commerce)
Title: Application Consultant
Client: Fidelity Investments, MA.
Period: Jun/00 - Jul/01
Title: Application Consultant
Client: providence Gas Co, RI
Period: Jun/99- May/00
Title: Application Consultant
Education:
Master’s Degree in Applied Math with Computer Programming Languages (COBOL, BASIC, FORTRAN)
Status: GC
Contact this candidate