Candidates About

 

Mounika Kothapally

Oracle Apps Techno Functional Developer

PROFESSIONAL SUMMARY:

·         Around 8 years of Experience in Information Technology with good expertise in Oracle Applications including Implementing, Testing, Developing, and Customizing of Oracle Financial and SCM modules - Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Fixed Assets (FA) and Oracle Purchasing (PO), Order Management (OM), Oracle Process Manufacturing (OPM), Oracle Projects, Cash Management, Shipping, Inventory (INV), Advanced Pricing and Advanced Collections.

·         Extensive experience in implementation, support, upgrade and enhancements of Oracle Applications versions 11i/R12.

·         Worked on various phases of Software Development Life Cycle (SDLC) such as Project requirement study, Project planning, High-level design, Low-level design, Coding, Implementation, Testing and Quality Assurance Documentation. 

·         Experience in Application Object Library (AOL) for registration of concurrent programs, Request Sets, Interfaces, Forms, Reports, Value Sets, Profiles, Custom Menus and responsibilities etc.,

·         Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies. 

·         Extensive experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Triggers.

·         Hands on experience in designing, developing and testing various RICEW (Oracle Reports, Forms, Interfaces, Conversions, Extensions and Workflows) components, Oracle Alerts and Lookups as per Oracle standards. 

·         Expert knowledge in Oracle core financial modules and many years of exposures to O2C and P2P tracks in multi-org corporate environments.

·         Extensive working experience in Reports development using XML Publisher, Oracle Discoverer, Oracle Reports, EIS Reporting, OBIEE and Hyperion Reporting.

·         Good understanding of Data Conversion and Data Migration process including vast expertise in Global implementations and working with large group of business users and Onsite & Offshore model projects.

·         Proficient in using Multiple Reporting Currencies (MRC) and Multi Org feature and implemented them in interfaces, Oracle reports and custom processes.

·         Experience in various development tools like SQL Developer, SQL*Loader, TOAD, FileZilla, WINSCP, PUTTY.

·         Good Exposure to Oracle Application Framework (OAF) and Oracle Application implementation methodology (AIM) and expertise in creating inbound and outbound feeds, creation of automated processes using Application Program Interfaces (API).

·         Hands on experience in design and development in Extraction, Transformation & Loading (ETL) of data from multiple sources (oracle, flat file and ftp) using oracle pl/sql, sql loader, sql plus, UTL File package.

·         Experienced in Requirements gathering, GAP analysis, documentation, application technical design, and unit testing of custom module components.

·         Developed, customized and personalized Oracle Forms using Form Builder, and CUSTOM.PLL.

·         Worked with UNIX shell scripting to automate the execution of the batch processes.

·         Effectively made use of Materialized Views, Query Re-Write and Transportable table spaces, Ref Cursor, External Tables and Collections and Exception handling.

·         Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs, and worked on Interface/Conversions like GL Interface, Custom Invoice Interface. 

·         Experience in the preparation of Functional Design Specification Documentation, Technical Specification documents and System Test scripts for Extensions including: Data Conversion/Migrations, Inbound/Outbound interfaces, Reports, Forms and workflows. Utilized AIM Methodology and/or Oracle Unified Methodology as per client requirement.

·         Worked with Oracle support team Metalink to aid in resolving application problems and solutions. 

·         Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.

·         Ability to work under pressure, meet deadlines and work extra hours when needed.

 

TECHNICAL SKILLS:

Oracle Applications	E-Business Suite – Oracle R12 (12.2.4/12.1.3) Oracle 11i (11.0.3/11.5.3/11.5.8/11.5.9/11.5.10) Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA), Order Management (OM), Inventory (INV), Oracle Purchasing (PO), Oracle Project Costing, Advanced Pricing, Quoting, Pricing Agreement.
Languages	SQL, PL/SQL, JAVA, UNIX
Oracle Development Tools	Toad, SQL Developer, Putty, FileZilla, SQL*PLUS, WINSCP
GUI Tools	Oracle Reports 10g/9i/6i, Oracle Forms 10g/9i/6i, XML(BI) Publisher, Workflow Builder, Discoverer Administrator, Desktop, Plus and Viewer 4i/10g
Operating Systems	UNIX, Windows 8/7/XE, AIX, Sun Solaris, Oracle Linux.
Databases Tools	Oracle 12c,11g,10g,9i,8i, MS Access
Version Control Software	PVCS, Rational Clear Case, Visual Source Safe (VSS)
Ticketing Systems	HEAT, HP Service Center, JIRA, WEBSERVE, SMILE
Other Tools	Microsoft Office, Projects, MS Access, Erwin, MS Visio

 

 

PROJECT EXPERIENCE:

Marsh & McLennan Companies, Hoboken, NJ                                                   Aug 2017 to till date

Role: Oracle EBS Analyst/Developer

Responsibilities:

•         Designed and authored various Functional Design Documents (FSD) and Technical Design Documents (TDD) that would help any person in understanding the end-to-end design based on the Business Requirement Document. 

•         Worked on an implementation project in Oracle R12 (12.1.3) on integrating Suppliers, Invoices and Banks from multiple third party systems to Oracle Accounts Payable (OAP).

•         Gathered business requirements and worked on documenting the requirements for building a Generic AP Supplier Interface and AP Invoice Interface.

•         Created Visio’s for business flows, performed interface mappings and related documentation including BRD and BR100 for all AP (Accounts Payables) interfaces.

•         Documented and developed the Supplier Bank interface from multiple third party systems using Oracle Standard API’s based on the BRD.

•         Interacted on daily basis with Users on design requirement for data mapping from Legacy to Oracle R12.

•         Developed PL/SQL Packages required for implementation of all the AP inbound interfaces using oracle standard API calls. During the process, developed validation procedures, error handling and debug logic as per the client’s complex design specifications. 

•         Created staging tables required for loading the legacy data using SQL loader. Developed interface programs to load data from custom tables to interface tables and imported in to Oracle Application using Standard Open Interface Import Programs.

•         Worked extensively on defining Executables, registering Concurrent programs, creating custom Value sets, Lookups, Flexfields and Request sets as per client requirement.

•         Modified a complex trigger on AP Base table to incorporate a business logic on Supplier end date.

•         Supported the team with post production issues. Acted as a maintenance support for guiding the users understanding the new system and solve daily problems.

•         Interacted extensively with Users for the TO-BE Process and documented the complete end-to-end processes for GL and AP modules for validation and approval.

•         Defined test cases with QA team and coordinated user participation in final testing phases for all inbound interfaces.

•         Also tested Oracle upgrade instance by identifying issues, supporting business functionality & resolving issues by working in close proximity with business users and Oracle Support.

•         Designed the functional spec for the Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in AR by incorporating business mapping rules and validations.

•         Involved and provided production support on Oracle Accounts Payable (AP), Accounts Receivables (AR), Purchasing (PO), Fixed Assets (FA) and General Ledger (GL) modules.

•         Co-ordinated with offshore technical team for getting code fix, reports, and interfaces developed by providing test cases and functional specs as part of Conversion.

•         Involved in analyzing, designing and developing the various RICE components. Worked extensively on Interfaces, Data Conversions, developing and customizing Oracle Reports as per business requirements. 

•         Conducted weekly and bi-weekly meetings to track and share progress on IT Enhancements (Change Requests) and defects.

•         Interacted effectively with users, developers and peers to ensure the successful delivery and implementation of the solution.

Environment: Oracle Applications R12.1.3 (AP, AR, GL, PO, FA and FAH), Oracle 10g, SQL, PL/SQL, Forms10g, Reports10g, Workflow builder, WINSCP, SQL*Loader, TOAD and UNIX.

 

 

Lumentum Operations LLC, Milpitas, CA                                                         Sep 2016 to Jul 2017

Role: Oracle Apps Techno-Functional Developer

Responsibilities:

 

•         Proficient in preparation of the Functional Design Documents MD50, Technical Design Documents MD70 and Unit Testing Documents TE020. 

•         Worked on an enhancement project in Oracle R12 (12.1.3) on Oracle Reports and Oracle Workflows for modifying/extending existing functionality of components as per business needs.

•         Worked on OE workflow change for specific Line Type to modify and to stop AR invoice interface.

•         Effectively worked on various Form Personalization’s under PO and OM modules to accomplish specific business validations.

•         Provided various data fixes for Blanket PO’s and Unposted Assets according to clients requirement.

•         Resolved production issues on Cash Management Report, identified the issue and for the long-term fix, updated the code for this report as per the root cause analysis.

•         Worked on AP, AR, PO, GL, FA, CM, OM and Projects modules as part of enhancement and implementation projects.

•         Took part in implementing Integrated End-to-End Oracle solution, which enabled using an integrated platform. The new process provided opportunities to increase automation, increase transparency & collaboration, data integrity, and optimization (manual process reduction).

•         Created additional processes in the Projects workflow as a part of CAPEX Project to send workflow notifications for approval to the functional and finance users in hierarchical way.

•         Worked on fixing issues with Oracle Reports, PL SQL interfaces Customizations, Forms and Workflows. Customized the existing interfaces and import programs for Order Import, PO and Requisition Import. 

•         Developed few custom workflows from scratch for the custom logics to meet the client requirements to send the reminder and escalation notifications to the pending approval notifications.

•         Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects, which are being migrated into new instances.

•         Experience in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Lookups, Flex Fields, Value Sets, Form Functions, Reports by using Application Object Library (AOL) and  System Administrator. 

•         Created logical and physical database objects like tables, views, synonyms, indexes and triggers to meet development needs.

•         Extensively worked in Oracle Back-end PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using TOAD and SQL Developer as development tools.

•         Guiding an offshore team for technical and functional assistance from client location. 

•         Developed UNIX Shell Scripts for uploading/downloading files from the server and for moving objects between instances using FNDLOAD scripts.

•         Developed various Custom reports, Customized existing reports according to the functional specifications using Reports 10g and XML publisher. 

•         Work on the development activities as part of issue resolution. Performed Unit Testing, migrated to next environments, assisted users, resolved critical issues and closed tickets. 

•         Developed queries to meet the requirements as per functional specification, prepared the test cases, and made sure we got the sign off for all the reports. 

•         Involved in Project Checkpoint, CRP, UAT, Go-Live meetings and participated actively in CRP, UAT & Production Go-Live activities.

•         Completed the Go-Live including preparation of deployment documentation, coordinating with DBA/OMCS (Oracle Managed Cloud Services) for the movement of code to production and given warranty support for two months until the project stabilized.

•         Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.

•         Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.

Environment: Oracle Applications R12.1.3 (AP, AR, GL, FA, OM, PO, CM and Project Costing), Oracle 10g, SQL, PL/SQL, Forms10g, Reports10g, JDeveloper10g, Workflow builder, SQL*Loader, TOAD and UNIX.

 

 

AGL Resources, Naperville, IL                                                                              Apr 2016 to Aug 2016

Role: Oracle Techno-Functional Developer

Responsibilities:

·         Authored Technical Design documents (MD070), Unit Testing Documents (TE020) and Installation Document (MD120) for all the customizations and enhancements.

·         Designed new business logic, which triggers an email notification to investigate whenever the inbound file /outbound file, is missing for a particular utility as per the existing schedules.

·         Worked on various Form Personalization’s in AP, AR and OM modules to add/block few fields at different levels.

·         Involved in Performance tuning and increased the performance of custom reports by adding advanced concepts like Bulk inserts, which benefited the business to get data more frequently to resolve errors.

·         Worked on BI Publisher (XML Publisher) for Various Purchasing reports. Generated new reports as well as converted existing Oracle reports to XML, by creating RTF templates using Template Builder.

·         Worked on data fixes for invoice holds pending in the background in Accounts Payables (AP) and wrote API’s to release the holds.

·         Experience in customizing Oracle workflows such as the PO Approval process, Order/Line Flow to send user notifications based on the business requirement.

·         Tuned the code in custom utility business logics to stop the credit on invoices from being credited and extracted the output files at the time the code change goes in to correct the accounts that have credited incorrectly.

·         Upon change requests, simplified the options on third party screens, which increased the capture of customer details by phone representatives.

·         Experienced in creating Concurrent Programs, Request sets, Flex fields, lookups, Profiles, Value sets, User setup and defining responsibilities through Application Administrator responsibility. 

·         Worked on customizing the Lockbox interface for Account Receivables (AR).

·         Used CUSTOM.pll to customize the standard oracle Forms.

·         Extensively interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.

·         Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.

·         Worked on various data repair change requests to move the specific list of Inventory items from one sub inventory to another sub inventory.

·         Participated in technical design enhancement discussion, documented the requirements and finalized the approach of development of RICEW objects.

·         Worked on tuning the custom packages for better performance, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.  

·         Created number of RFC’s (Request for Change) on MOS (My Oracle Support) for deployment of code in monthly releases.

·         Fix the emergency issues occur during month end. Project the issue and get approvals from managers, migrate and close the issue before month end close. 

·         Resolved number of service requests from business by extracting the data requested.

·         Mainly worked on Oracle EBS Production issues related to AP, AR, GL, FA, INV, OM, and PO. 

·         Schedule meetings and assisting the business on time. Make business user friendly with the oracle ERP application.

·         Analyzes the feasibility and develops requirements for new systems and enhancements to existing systems, ensures the system design fits the needs of the client. 

Environment: Oracle Applications R12.2.4 (AP, AR, GL, FA, INV, OM, PO), Oracle 10g, SQL, PL/SQL, Forms10g, Reports 10g, JDeveloper 10g, Workflow builder, SQL*Loader, TOAD and UNIX.

 

 

Williams Companies, Tulsa, OK                                                                              Jan 2015 to Mar 2016

Role: Oracle Techno-Functional Developer

Responsibilities:

·         Authored design documents (CF250), technical specifications (MD200) and Installation documents (MD120) for all the customizations.

·         Involved in developing various SQL, PLSQL and UNIX shell scripts for conversion programs and interfaces, developed custom oracle forms and reports, performed forms personalization based on the functional specifications provided.

·         Developed and extended functionality of various RICEW components in modules like OM, INV, AR, AP, CM, GL and PO.

·         Worked on application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues. 

·         Created various concurrent request sets and scheduled them to run on predefined timing periodically, including: Order Import interface program, Auto Invoice Program, Payables Open Interface Import etc.,

·         Developed custom reports using Report 10g and XML Publisher. Customized various seeded reports to incorporate business functionality and generate spreadsheet outputs.

·         Developed Operational Dashboards for business to view current health of the organizations.

·         Involved in Preparing Design Documents for all Customizations with detailed solutions, development and implementation of all interfaces and conversions. 

·         Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.

·         Involved in some activities for Oracle System Administration module such as, creating new menus, responsibilities, value sets, descriptive flex-fields and defining the required system profile options. Extensively utilized the Application Object Library to register SQL*Loader programs, Shell Scripts, PL/SQL procedures, Forms and reports. 

·         Designed and developed Custom Trial Balance reports to help Business cross validate converted Journals and Balances before and after data conversion. 

·         Provided post go-live support and involved in user training sessions.

·         Experience in Building data conversion/migration strategy, mapping legacy system fields to Oracle Applications data fields.

·         Supported on Month end closing. Assisted users in completing the transactions. 

·         Documented all the work done for future reference. Also created various reference manuals for functional testers and users.

·         Resolved period closings issues in oracle General Ledger while performing one time translations and auto reversal at the end of the period.

·         Performed complete design and development of Custom Payment method 'VPAY' and the corresponding integration with Oracle applications.

·         Customized Order Management Header and Line Workflows for incorporating Role Based Approval for the pre-specified business conditions.

·         Worked on customization of PO Requisition Account Generator Workflow, Updated the logic for the accrual account for expense items to copy the company segment of the charge account to the company segment of the accrual account.

·         Resolved various General Data errors occurred by analyzing and applying GDF patches and the corresponding Root Cause Fix Patches.

·         Worked as a technical support for resolving various bugs for various service requests raised with Oracle Support.

Environment: Oracle Applications R12.1.3 (GL, AR, AP, PO, OM, CM, FA, INV, iProcurement, IExpenses, EB-Tax), Oracle 10g, SQL, PL/SQL, Forms10g, Reports 10g, JDeveloper 10g, TOAD and UNIX.

 

 

University of Minnesota, Minneapolis, MN                                                            Sep 2013 to Dec 2014

Role: Oracle Apps Techno Functional Developer

Responsibilities:

·         Worked on the upgrade process of Oracle 11i (11.5.8) to R12 (12.1.3). 

·         Extensively tested oracle upgrade instance, identifying issues, supporting business functionality & resolving issues working closely with business users and Oracle Support.

·         Worked on archive and purge process that will save the AR invoices in a file until a given date, and then deletes the records from tables.

·         Involved in Loading and importing credit card transactions and exporting the expense report into Oracle Payables in Oracle Financials.

·         Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.

·         In the GL module, designed and developed packages for Journal Import Interface to import journals information into the system. Developed PL/SQL package to validate and insert the validated data into interface tables.<