CAREER SUMMARY

Over ** years of experience Designing, Developing, Customizing, Data

Conversion, Integrations, Implementation and Upgrade of Oracle Applications R12, 11i and Oracle Fusion

Expert in Architect, Design, Administer, Monitor, Manage ERP Integration Tools. Integrate external Cloud/On-Prem Applications with ERP Systems using Integration Tools like Integrated SOA Gateway (ISG), Oracle Rest Data Service

(ORDS), Oracle Integration Cloud (OIC)

Hands on Experience in ERP (Fusion/EBS) modules like Finance, Supply Chain, Accounts Receivables, Pricing, Inventory, Warehouse Management, Purchasing, HRMS

Expert in SQL, PL/SQL programming, developing various RICEW components, Business Events, developing complex queries and performance tuning. Experience in leading/managing Development Team.

Experience with Tools or applications like Kafka, Splunk, OTBI (Oracle Transactional Business Intelligence), OAF Personalization/Customization, Administering Oracle Cloud Infrastructure (OCI), Oracle Notification Service, Oracle Event Service, Oracle Object Storage, Business Intelligence Cloud Connector (BICC, used to extract data from Fusion), BigQuery Excellent learning skills to adapt to the new technologies. Experience working in Agile Methodology. Participated and collaborated with other functional/application teams in Sprint Planning, Grooming, Scrum, to deliver the projects.

Self-motivated, architect solutions, drives results and keep up with the latest technology trends.

PROFESSIONAL EXPERIENCE

Senior Enterprise Application Developer

Dexcom San Diego, CA Sep’15 - Till Date

Dexcom is a company that develops, manufactures and distributes “Continuous glucose monitoring systems” for diabetes management. At Dexcom, my primary responsibility was to architect, design Integration solutions with various desperate systems (like, Kafka, Salesforce, OSC, Boomi, OIC, OCE, Oracle Service Cloud to ERP Systems (Like EBS, Fusion).

Worked on various Integrations with ERP modules like Receivables (TCA), Order Management, Suppliers, Purchase Orders, General Ledger, Receipts, Shipments, Inventory, Warehouse management.

Responsible to administer, monitor and manage Oracle Integration tools like Oracle Integration Cloud (OIC), Integrated SOA Gateway (ISG), Oracle Rest Data Service (ORDS)

Responsible in managing, monitoring OCI (Oracle Cloud Infrastructure) Tenancy, object storage, IAM policies, Compartments, Notification Service, Event Service, etc.

Lead Oracle Applications and Database Upgrade project from R12.1.3 to R12.2.9 and 11g to 19c. Responsible to successful migration of all custom RICEW components.

Lead/Manage Onsite and Offshore Teams effectively and efficiently. Worked closely with Scrum Master to deliver projects in a timely manner. KAMALENDAR REDDY KOTHA

ORACLE ERP INTEGRATION LEAD

CONTACT

361-***-****

adlano@r.postjobfree.com

9825 Mira Lee Way,

San Diego, CA, 92126

https://www.linkedin.com/

in/kamalendarreddykotha

EDUCATION

Master of Computer Science

Texas A&M University

Corpus Christi, Texas

2010 - 2012

Bachelor of Technology

Computer Science & Engineering

KITS, Warangal, India

2006 - 2010

C E R T I F I CATIONS

Oracle Cloud Infrastructure

Developer 2020 Certified

Associate

Oracle Autonomous Database

Cloud 2019 Certified Specialist

K E Y S K I L L S

Team leadership

Analytical thinking, planning

Communication

Tolerant and flexible

Problem solving

Adaptability

Lead OIC Gen 2 Upgrade and was responsible to co-ordinate and communicate with Business Partners and Oracle. Effectively worked with team in Germany (as we have OIC instances in multiple regions) in performing SIT, UAT and PROD rollout. Expert in parsing XML, JSON, CLOB, BLOB in the database, leveraging the new enhanced features of 19c.

Proficient in Building Self-healing, Resilient, Robust, Fault Tolerant Integrations processes.

Worked on tuning SQL queries or PL/SQL packages using Execution Plan or TKProf. Followed SDLC (Software Development Life Cycle) in delivering projects. Participated in requirement gathering, creating mapping document and developing, unit testing, System Integration Testing, User Acceptance Testing and Prod deployment.

Responsible to manage and maintain custom Oracle Reports, OTBI reports, Custom Forms, Apex Reports, Business Events.

Worked on Integrating Fusion data to BigQuery using BICC (Business Intelligence Cloud Connector) and Oracle Notification Service, Event Service, Object Storage and OIC.

Expert in developing Webservices, REST/SOAP endpoints using middleware tools/technology. Good knowledge on REST/SOAP APIs available in Supply Chain and Finance Module for Fusion ERP.

Worked on writing Shell Scripts, Perl Jobs, java scripts. Proficient in using Utility packages to send email or call REST endpoints from DB. Experience working in both Synchronous and Asynchronous environments. Expert in building robust, self-healing, reactive models for routing/handling exceptions in Asynchronous Model.

Worked on several POC’s and was successful in getting the Tools & Technology needed.

Oracle Techno Functional Consultant

Employer: FusionPlus Solutions Inc

Client: Commonwealth of Virginia, SCC Richmond, VA Feb’15 – Jun’15 State Corporate Commission was upgrading from 11i to R12.2.3. I was responsible to work with the team to develop and/or migrate Custom Objects for the Upgrade Project. As a functional Expert, responsible to migrate all the setups for Financial Modules and HRMS Modules from 11i to R12.

Worked on migrating all the CEMLI objects for Financials and HRMS modules. Customized Fast Formulas (PTO Carryover).

Developed Custom OAF page and worked on Customization, Personalization and Extension of several OAF pages as per the requirements in R12. Senior Oracle Developer

Employer: FusionPlus Solutions Inc

Client: Wellington Management Company Boston, MA Dec’13 – Jan’15 Wellington Management is a Financial Company which manages funds of its clients. As a Senior Oracle Developer, I was responsible to develop, enhance various Reports and fine-tune queries.

Experience working with Business Analysts in gathering requirements related to ETF’s, Funds, and loans. Follow SDLC in developing and delivering projects. Worked on migrating 250+ reports from Oracle 6i to 11g. Performance tuning was crucial while new reports were being developed. Fine- tuned and enhanced various reports to improve performance over 60%. Expert in writing complex SQL queries using Analytical Functions like LEAD, LAG, RANK, FIRST_VALUE, etc.

Proficient in working with Hierarchical queries using START WITH, CONNECT_BY_ROOT, etc.

Worked with Global Temporary Tables, converted report from STAR Schema to Snowflake Schema and improved its performance.

Provided best performance queries which gives historic and forecast analytics at deal level, collat level and tranche level (These analytics include: CDR, CPR, CRR, DELINQ30, DELINQ60, DELINQREO, DELINQFC, DELINQBNKRPT, SEVERITY, etc.) Oracle Applications (Fusion,

EBS R12, 11i)

ERP Modules (Supply Chain,

Financials)

Integrated SOA Gateway

Oracle Integration Cloud

Oracle Cloud Infrastructure

Oracle Autonomous

Database

Kafka

Splunk

Dell Boomi

Business Intelligence Cloud

Connector

Oracle Analytics Cloud

Google Cloud Platform

T E CH S K I L L S E T

C, C++

SQL, PLSQL

Python

Java

Shell Scripting

Perl

XSLT

COMPUTER

L ANGUAGES

Worked on writing Perl jobs, shell scripts to FTP reports to user specific locations. Oracle Techno Functional Consultant

Employer: FusionPlus Solutions Inc

Client: EMD Millipore Boston, MA Oct’12 – Nov’13 EMD Millipore has diversified offering of products in chemicals and pharmaceuticals domain operating in 68 countries. As Oracle Consultant, I worked as Developer and Production Support role.

Worked on developing RICE Components and have successfully delivered various projects like MDM Interface, CCT, Price Optimizer, POP, BRUECKE Worked on ServiceNow to resolve several issues in modules like OM, AR, INV, OPM, BOM, Advanced Pricing.

Responsible for customizing Oracle Forms, building workflow processes using Workflow Builder, developing BI Publisher reports. Customized several reports and forms. Customized OPTIO documents like Invoices, Order Acknowledgement and Shipment Notifications. Worked on developing Interfaces like TCA (Customer Master, Address, Partner, Sales), Sales BOM conversion for CCT Countries like Belgium and Netherland. Developed POP (Price Offer Program) conversion for CCT Countries. Developed shell script to FTP the generated files through Price Optimizer program Customized Cross Selling (To maintain the transfer cost of items over several Legal Entities) and Trackwise Interfaces

Worked on RIBS report, which shows Item creation, cost and the components used to the BOM Routings, total revenue made.

Worked on Alerts, XML Publisher Reports, SQL*Loader, XML Gateway, Business Objects and Business Events.

Worked with Onsite and Offshore Teams to effectively deliver projects and to provide 24*7 Support.

Graduate Research Assistant & CTS Lab Support

Texas A&M University Corpus Christi, TX Oct’10 – Feb’12 In a competitive environment, I worked as Graduate Research Assistant in Electrical Department and wrote several papers on SCADA Protocol and Smart Grid Designed and maintained a website http://www.sci.tamucc.edu/~nrcsch which is a scholarship website.

Designed flyers and posters for the scholarship program. Participated in several science fair and convocations and encouraged students to take the courses in Electrical Engineering

Took courses in Electrical Engineering to better understand Smart Grid and its capabilities.

Did research on SCADA protocol and was successful in putting all the thoughts into many resourceful papers

Helped students with WIFI or computer troubleshooting. Worked efficiently and helped students with patience to resolve problems like software installation, helping with tools installed. SQL Developer

TOAD

PLSQL Developer

SQL*Loader

XML Gateway

Oracle Reports 6i, 11g

Discoverer 10g

Workflow Builder

Forms 10g

JDeveloper

SOAPUI/Postman

SQL*Plus

STAT

T O O L S

Contact this candidate