Oracle Fusion Technical consultant
Resume:
CHANDANA MODUGULA
Oracle Cloud Techno-Functional Consultant
****************@*****.***
PROFESSIONAL SUMMARY
10+ years of experience in Architecture, Design, Development,Implementation and maintenance of Oracle Enterprise Applications.
Experience in designing and implementing Oracle Cloud Based solutions, specifically around Integration between Oracle SaaS applications and Third-Party Cloud providers, On-Premise Systems and other Cloud Native Systems.
Hands on Technical and Functional Knowledge on Procure-to-Pay (PTP), Order-to-Cash (OTC),Inventory, HCM, Payroll, Advanced Supply Chain Planning, AP, AR, BOM, IB, Fixed Assets and GL Modules.
Experience in performing Integrations between OIC and 3 party applications both Inbound and Outbound - File based, web service and XML based.
Experience in Data Migration activities of loading legacy data into Oracle Fusion Cloud using HCM Data Loader and File- Based data Import.
Performed Data Conversion of Customers, Bank, Bank Branches, Open AR transactions, GL balances using Oracle FBDI and ADFDI templates.
Experience in doing Customization/Personalization for Oracle Fusion Pages using SandBox.
Experience in creating Reports, scheduling or Extracting data using BI publisher.
Expertise in creating Dashboards or Drill Down Reports using Oracle Transactional Business Intelligence(OTBI).
Hands-on experience in creating BI extracts using rtf, excel templates and BIP bursting.
Automate the FBDI process using webservices like SOAP UI and REST API’s.
Gained Knowledge of Oracle Fusion Middleware technologies, including Oracle SOA Suite, Oracle WebLogic Server, Oracle ADF, and Oracle Integration Cloud.
Experience across multiple functional domains- Financial Business process and systems, multi GAAP environments, Accounting Rules, TCA, Localizations, Period Close, Reporting and Vertex.
Well versed in development and customization of PL-SQL Stored Procedures, Packages, Functions, Triggers, Views, PL/SQL advanced concepts, SQL Loader, and shell scripting.
Hand-on Experience in Design, Development, and customization of RICEW Components like RDF Reports, XML/BI Publisher Reports, Forms, Interfaces, Conversions and Workflows.
Good Experience in engaging Oracle team on SR’s, handling Critical migrations and Provide support for Production issues.
Well versed in using JIRA for defect management, Bitbucket for repository and Confluence for documentation.
Strong experience of leading and implementing all phases of SDLC Using Agile/Devops methodology.
Building relationships and collaborating with client stakeholders to align technical solutions with business objectives.
Experience in all phases of Software Development Life Cycle(SDLC) including analysis, specification, Development, Maintainenece, Testing and Documentation.
An Excellent Team Player with good problem-solving approach having strong communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
Flexible and versatile to adapt to any new environment and work on any project.
Excellent interpersonal and communication skills (both verbal and written). Lead and mentor Junior Team Members.
Reliable, Responsible, Punctual, Self starter, avid and fast at learning new technologies and software tools.
TECHNICAL KNOWLEDGE
Technologies
Oracle Fusion Financials Cloud R13 :- GL, Subledger accounting, Payables, Receivables Cash Management and Fixed Assets.
Oracle EBS Applications 11i, R12
Tools
Oracle Integration Cloud, BI Publisher, OTBI, Financial Reporting Center(FRS), File based data Import(FBD)I, ADFDI, SandBox Manager, SmartView, Oracle Report Builder, Oracle Forms Builder, XML Publisher, SQL Developer, TOAD, SQL Plus, Data Loader, SVN, JIRA, WinScp, Putty, Service Now, JIRA, Confluence
Databases
Oracle 10g/11g/12c /19C
Version Control Systems
Tortoise SVN, Git, Bitbucket
Programming Languages
SQL, PL/SQL, Unix Shell Scripting, Java
PROFESSIONAL EXPERIENCE
Oracle Cloud Techno Functional Consultant Jul 2024 – Current Teachers FCU, Smithtown, NY
Project: Teachers Federal Credit Union provides a platform for its customers with Personal banking, loans and Money transfers with an effective Online web solution. Develop public facing personal banking and financial application for the client in North America region.
Utilizing and managing Oracle suite of software and technologies for various purposes within an organization
Implement Agile methodology for faster time to market and improved productivity.
Environment:-Oracle Fusion Financials Application R13(GL, AP, AR, FA and Cash Mgmt), Smart View, FRS(Financial Reporting Studio),OTBI, BI publisher, ADFDI and FBDI- based data Conversion and Migration.
Role and Responsibilities:
Supporting the implementation of Core financial modules - GL, AP, AR, FA and Cash Mgmt.
Developed multiple BI/OTBI reports based on client requirement.
Executed Data Conversion for Customers, Suppliers, Invoices, GL balances, Budgets and Fixed Assets using Oracle FBDI and ADFDI templates.
Data Cleansing, transformation, apply conversion rules, perform validations and loaded into OCI target Assets.
Create Reconcilation reports in Analytics Publisher.
Worked on Automation of FBDI loading process through webservices like SOAP UI/REST
Involved in the customization of existing BI Publisher Reports and template changes depends upon the user requirements.
Developed BI extracts using rtf, excel templates and performed BIP bursting based on user requirement.
Developed a new Custom Account Analysis Report as per the client requirement.
Worked on FBDI&Excel Spread conversions for Invoice Upload.
Worked on Customization of pages using SandBox Manager.
Log issues&track their resolution and provide status&issue report to the PM/Client on a regular basis.
Provide Expertise for on-going Cloud support model, Standards and Procedures improvement.
Support client with the creation &execution of test scenarios,test scripts and Change Management.
Defined and tested chart of accounts, chart of account values sets, Account Hierarchies, Currencies, Conversion Rates, Messages for General Ledger and Daily rates.
Developed data fixes during conversions.
Support Period-Close Process: Standard JE&Adjustments, Reconcilation, Variance Analysis and FS review.
Scheduled the critical Reports to the client SFTP path with Current date time Stamp.
Handled security and created Custom Roles.
Oracle Cloud Technical consultant Aug 2020 – Jun 2024 Xerox Holdings Corporation, Norwalk, CT
Project: Xerox holdings corporation serves office and production print technology and related solutions to digital world and IT sector. Current effort is to provide support to the business users on their day-to-day PROD Instance issues across the financial modules
Environment: Oracle Fusion Supply Chain R13(Procurement, AP, AR and GL), SOA Composer, Oracle Integration cloud(OIC), OTBI, BI publisher, ADFDI and FBDI- webservices like SOAP UI, REST API’s.
Role and Responsibilities:
Resolve the Production support incidents on time to meet the SLA
Distribute the incidents, Service Requests and Problem Tickets across the team based on the band width.
Customized/ Personalized Oracle Fusion pages like Supplier Portal, Invoice creation page and AP modules by creating SandBox.
Created Oracle BI publisher reports/Analytics for Procurement, AP, FA, GL and AR modules.
Created SmartView and FRS reports for GL Module.
Created Custom Infolets,add content and configure them in Home Page.
Imported account data into Oracle Fusion application using Import Management.
Created common view only job role for Procurement, AP,AR and GL modules.
Configured the BPM Approval Workflow rules for AP, Procurement and AR using SOA Composer.
Created, scheduled and Monitor the ESS jobs to load data in interfaces.
Automated the FBDI load process through SOAP UI.
Prepare and Execute Hot Fixes in Production for data issues.
Coordinate with Business IT groups to ensure to provide the solution on time
Build new .RDF and XML reports as per Business requirement for Reporting purpose.
Tuned the long running jobs by enabling Trace and create INDEXES for faster access.
Extensively used UTL_FILE package to read and write operating system text files and for emailing the files for Business users.
Prepare scripts to Reprocess the stuck records in Staging and Interface Tables.
Provide support to Business users in Month End Period closure Activities.
Develop the code to Inbound and Outbound .csv,.txt .xls files from SFTP server into Oracle directories and vice-versa
Develop data fix scripts for Recurring issues in Production.
Oracle Technical Developer Jun 2015 – Jul 2020 Fruit of the Loom, Bowling Green, KY
Project: Fruit of the Loom manufactures clothing, particularly casual wear and underwear for men and women in the United States. Current effort is to provide new enhancements and support to the business users on their day-to-day PROD Instance issues across the INV, PO, OM,AP,AR,ASCP and financial modules.
Environment: Oracle 12c, SQL, PL/SQL, Linux, Business Objects, Jira, Confluence, Oracle Applications R12.1.3, Enhancement and support
Role and Responsibilities:
Developed a new Custom interface program(API) to load data into staging,validate and move into MSC tables(ASCP) as per client requirement.
Implemented the complete life cycles of Procure to Pay and Order -to-Cash.
Developed GL Inbound Interface to import the Journals from Legacy to Oracle Application GL base tables using standard program “ Journal Import”.
Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
Involved in preparation and migration of AOL objects through FND LOAD.
Customized PO Requisition form and PO form as per client requirement.
Developed Item Interface between JDE and Oracle e-business suite which also involves a PLSQL call
Created Control Files for SQL Loader to load data from Text,CSV Files into Oracle staging tables
Worked on Form Personalization for changing properties, adding new built-ins, displaying messages and adding menu entries in Oracle form based screens.
Involved in building of OAF pages through Jdeveloper as per business needs.
Creation of Lookup’s, ValueSets, Key FlexField’s, Descriptive Flexfield’s and Concurrent Programs based on client requirement in various Modules of the application.
Monitoring and Scheduling Control M jobs. Analyzing Health check reports and ensuring BEST PLAN has been assigned to the job.
Prepare Scripts to HOLD and RELEASE Control M jobs during Application Maintenance activities.
Perform Application Check-IN and Check-OUT during DR drill activities.
Involved in regular monitoring activities of Scheduled concurrent jobs
Worked on Performance Tuning, Table Partitioning of PL SQL objects to improve the better performance
Effectively involved in the Data migration and release activities for the SIT, UAT, PRODUCTION signoff
Mentoring the new joiners in team about custom objects and Business process flow of the application
Oracle Apps Developer Feb 2014 – May 2015 CIENA, Hanover, MD
Project: Ciena Corporation is an networking systems and software company based in Hanover, Maryland. The company has been described by The Baltimore Sun as the "world's biggest player in optical connectivity". Current effort is to upgrade entire application from 11i to R12
Environment: Oracle Applications R11i to R12, Upgradation
Role and Responsibilities:
Resolve the Production support incidents on time to meet the SLA
Involved in customization and extension of Reports to Retrofit the objects as per the application upgrade
Development and Customization of Oracle AUDIT reports for Banks, Customers and suppliers
Prepared MD-50, MD-70 for various custom objects
Coordinated to maintain Object History through Version control tool SVN
Involved in Transactional Data migration activities throughout the project life cycle
Revise of the custom objects as per the Oracle Coding standards and Naming Conventions
Extensively worked on different modules to Retrofit the existing custom objects with the application upgrade
Involved in SIT and UAT object migration and testing
Developed and enhancement of many value sets by replacing obsoleted tables with new tables and views
Worked on Functional setups for AUDIT trail for supplier Information
Involved in PROD support activities on post Go-live of the project
EDUCATION
Master of Science from Vellore Institute of Technology (VIT University) in collaboration with Wipro technologies, Chennai, India
Bachelor of Computer Science from Acharya Nagarjuna University, Guntur, India
Contact this candidate