Home

poorna c - Oracle Cloud Fusion Financial Technical consultant

[email protected]

Location: Richmond, Virginia, USA

Relocation: yes

Visa: h1b

Professional Summary: Over all 12 years of experience in Oracle Fusion Cloud Technical, Oracle Ebs R12, 11i versions. As Oracle Fusion Cloud Developer I have developed BIP Reports and OTBI reports. Using FBDI process uploaded the details into Oracle Fusion System. Having experience in OIC integrations and FRS reports. As Oracle Application Technical Developer (EBS) worked on implementation, Support, and customization of Oracle e-Business Suite Applications (R12, 11i). Extensive experience in implementation, Migration, Customization, Production, and support of various modules in Oracle Applications with major focus in General Ledger (GL), Accounts Payables (AP), Accounts Receivable (AR), Purchasing (PO), IProcurement, Cash management (CM), Inventory (INV) and Order management (OM). Hands-on experience in Data Conversion, Report Generation and Developing Interfaces within several modules in Oracle Applications. Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows). Experience in Procure to Pay (P2P) and Order to Cash (O2C) cycle. Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader. Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, and software Development Life Cycle (SDLC). Expertise on designing and implementing Oracle Alerts and Lookups. Hands-on experience in developing and customization in RDF reports and BI reports. Good Exposure in writing SQL Queries, Procedures, Packages and Triggers. Exposure in developing or customizing the Discoverer repots. Exposure in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher). Developed new Concurrent Programs, Reports and Flex Field Customizations. Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle Forms, Oracle Reports, Workflow, Discoverer. Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs etc. Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews. Expert in developing technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120). Experience in customizing oracle workflows such as the Invoice approval process. Experience in doing Performance Tuning. Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Ability to handle user defined errors by developing Error-Handling Package using PL/SQL. Interacted with users, fixed the bugs, developed test plans and provides daily production support. Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF Certifications: Oracle Financials Cloud: Payables 2022 Certified Implementation Professional Oracle Cloud Platform Application Integration 2021 Certified Specialist Oracle Cloud Infrastructure Foundations 2021 Certified Associate Academic Profile: Bachelor of Engineering (B.Tech) from Jawaharlal Nehru Technological University, Hyderabad Technical Summary: Operating System : WINDOWS NT, WINDOWS 95, UNIX and Ms Dos Packages : MS Office (MS Word, MS Excel) Languages : SQL & PL/SQL, XML and HTML GUI Tools : Form Builder, Report Builder, jdeveloper (10.1.3.3.0), Discoverer, XML Publisher, TOAD, Workflow ERP : Oracle Fusion Technical, Oracle Applications 11i and R12 Project Details: PROJECT#1 Project Title: A&F Prod Support & Enhancement Client: Markel Corporation Inc Location: Richmond, USA Module: AP, GL, FA in Oracle EBS Fusion Cloud Duration: Oct 2020 to Till Date Description: With over 5,000 employees across the globe, finding creative solutions for complex risks is our passion. And our broad array of tools and knowledge allows us to create tailored coverage solutions for even the most complex needs. Responsibilities: Implemented and customized Oracle Fusion Cloud applications related to Financial modules (AP,GL,CM,FA) Developed custom reports and analytics using Oracle BI Publisher and integrated them into Oracle Fusion Cloud. Developed and customized OTBI analytics and supported FRS and SmartView Reports. Conducted data migrations and integrations between Oracle Fusion Cloud and OneInc, GLI source systems. Designed and implemented security models, including user roles and permissions, in Oracle Fusion Cloud applications. Executed patching, upgrades, and ongoing lifecycle management tasks for Oracle Fusion Cloud applications. Implemented REST API and SOAP to integrate Oracle Fusion Cloud with external systems. Collaborated with cross-functional teams to gather requirements and translate business needs into technical solutions. Provided technical support and troubleshooting expertise for Oracle Fusion Cloud applications, ensuring minimal downtime. Completed Oracle Fusion Cloud certifications, demonstrating proficiency in the latest Oracle Cloud technologies. PROJECT#2 Project Title: COX AMS Prod Support Client: Cox Enterprises Inc. Location: Atlanta, USA Module: AP, GL, PO, FA in Oracle EBS Finance. Duration: Sep 2019 to Sep 2020 Description: Cox Enterprises is a global company with approximately 55,000 employees and $21 billion in revenue. Cox remains a values-driven private corporation that can invest in long-term growth and is proud of its four-generation family leadership. Through our major divisions Cox Communications and Cox Automotive we lead in the communications and automotive industries. Our widely recognized national brands include Autotrader, Kelley Blue Book and Cox Homelife. Responsibilities: As onshore lead handles the teams (Oracle EBS, Web Center and DBA). Worked on P2 tickets and try to provide immediate data fixes to resolve the issues without missing SLA. Co ordinating with 3 party systems and try to resolve the issues. Engaging Oracle support and other teams and try to work on the high priority tickets. Gathering the requirement from client share those details to offshore to work on the enhancements. Attending status calls and provide the status on all the tickets. Worked on Month End critical issues and resolved them with in the timeline. Helping in Web-center related issues means co ordinating with business and engage third party systems to resolve the issues. PROJECT#3 Project Title: CIGNA ETSG Prod Support & Enhancements (Oracle EBS) Client: CIGNA Health Insurance (Onshore) Location: Philadelphia, USA and Hyderabad, India. Module: AP, GL, PO, AR, CM, FA in Oracle EBS Designation: Onshore Lead (2 years), Offshore (3 years) Duration: Feb 2015 to Oct 2019 Description: Established more than 50 years ago, in 1962, the Cigna Foundation carries out our corporate philanthropy goals of bringing Cigna's mission and brand promise to life for individuals and communities around the globe. This is accomplished through strategically focused charitable grants to nonprofit organizations whose work enhances the health of individuals and families and the well-being of their communities. Responsibilities: Developed the new interfaces and customized the existing interfaces. Handled all the production support/enhancement issues and try to close them with in the SLA time. Created new lookups and value sets based on the requirement. Developed and customized the reports, interfaces, and workflows as per the client requirement. Developed interface to load the workday payroll information into Oracle. created Outbound interface to extract the payroll information and send it to downstream system (Hyperion), Developed new interface to handle the R12 segments and load the data into GL for one of the source systems. Customized in invoice workflow to change the interval for the reminder notification. Developed Cigna invoice rejection xml report. Fixed the issues in loading the data from source systems to Oracle in all the module AP, AR, GL. Customized the interface to change 11i segment values to R12 segments and pass-through FAH. Drive the calls whenever there is any P2 incidents are going on and try to involve business and IT team and try to resolve the issues. Raised SRs to Oracle and used to update in timely manner. Handled the Month End and Quarter close issues. PROJECT#4 Project Title: OLD Mutual I support (Implementation) Client: OLD MUTUAL Location: Hyderabad, India. Module: AP, PO, GL, OM in Oracle EBS Designation: Sr. Software Engineer Duration: Jul 2014 to Jan 2015 Description: They provide innovative long-term savings and investment solutions which address both protection and retirement savings needs. They have a majority shareholding in Nedbank, one of South Africa's leading bank franchises, as well as banking interests in other countries in southern Africa. Responsibilities: Developed new XML and BI Publisher Reports based on the client requirement. Worked on AOL object to register the programs in Oracle Application. Created new RDF and Discoverer reports based on the client requirement. Developed invoice interface to load the data from source system to Oracle. PROJECT#5 Project Title: Clearorbit (Production Support & Enhancements) Client: GE-Energy (Oil & Gas) (Offshore) Location: Hyderabad, India Module: AP, PO, GL in Oracle EBS Designation: Sr. Software Engineer Duration: Jan 2013 to Jul 2014 Description: It s a GE Energy application that digitizes the procurement cycle. The application provides an efficient way for suppliers to receive and collaborate on purchase orders, create shipments, submit invoices electronically and view payment details over the Internet. Responsibilities: Involved in production support activities. Worked on various report level issues. Created data fixes to load the data into Oracle which were struck in the interface tables. Involved in working XML reports and debugging the XML reports. Worked on Interface program related issues in PO and AP related issues. Good knowledge on service now. PROJECT #6 Project Title: Dresser-Oracle-Cold-Short (Implementation) Client: GE-Energy (Oil & Gas) (Offshore) Location: Hyderabad, India Module: AP, AR, PO, GL, OM, INV in Oracle EBS Designation: Sr. Software Engineer Duration: May 2012 to Jan 2013 Description: With a world class portfolio of energy infrastructure solutions and leading product brands, Dresser, Inc. is a recognized innovator in the global power and fuel industry. From oil and gas production and processing to power generation and fuel distribution, Dresser, Inc. has been defining and leading energy markets for more than 130 years. The Waukesha Motor Company provides engines for boats, automobiles, trucks, and farm and construction equipment. Beginning in the 1980s, the Waukesha engine product line focused on large, gaseous-fueled stationary engines for power generation and gas compression applications around the world. Responsibilities: Design, Development and Customization of RICE components. Developed Vendor related information from source system to Oracle. Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface Doing feasibility analysis and preparing technical design documents MD-070. Coding and Development of RICE as per Naming and Coding Conventions. Define Concurrent program, Request Sets and Executable (AOL) Performing Unit testing and Code review for developed RICE Components Created Email Alter based on the item creation in MTL tables. Worked on Customization of AR interface Program. Customized the reports to replace the logo by using $OA_MEDIA Top. PROJECT #7 Project Title: OLM RTS R12 Client: GE-CAPITAL (Offshore) Location: Hyderabad, India Module: AP, Lease Management, PO, GL, OM in Oracle EBS Designation: Software Engineer Duration: Nov 2011 to May 2012 Description: GE Capital is a leading provider of business lending and leasing for companies of all sizes in a wide array of industries. They work closely with the customers to provide business financing to purchase, lease and distribute equipment. They provide business capital for corporate acquisitions, refinancing and restructuring as well as services to manage large fleets of cars and other equipment. Responsibilities: Developed code for Dashboard Report. Changed the reports as per the requirement. Worked on day-to-day production supporting issues. Worked on night batch monitoring. Worked on Discover Report issue and did some enhancements. Worked on the XML Report issues to find out the root cause and try to resolve them. Keywords: business intelligence information technology purchase order microsoft procedural language Arkansas Colorado Maryland