Developer Oracle
Resume:
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
**********.*****@*****.***
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