Oracle Developer Resume
La Sfo, CA
Summary:
I have over 10 years of work experience which includes Eight years of experience in Oracle Applications. I was involved in various phases of Designing, Development, and Testing and Implementation of Oracle Applications projects. I have gained good experience in implementation, migration, up-gradation & customization and production support of Oracle Applications (R12, 11i). I am proficient in Oracle Financials (GL, AP, AR, PA, PO, FA, CE, OM, INV, PO, AOL, and Sysadmin) and gained good experience in Oracle Manufacturing [Discrete/OPM/Supply Chain]. I have also worked on migration, Conversion, developing interfaces between Oracle and legacy systems.
Education:
Bachelor’s Degree in Commerce
Confidentialcollege
Master in Business Administration
Confidential College
Master in Commerce
Confidential University
Technical Skills:
Oracle Applications:12/11i (Accounts Receivables, General Ledger, Accounts Payables, Fixed Assets, Purchasing, Order Management, Inventory, System Admin ,I Expense, I procurement, Cash Management , OPM Application, AOL, AIM Methodology
Oracle Tools:
Discoverer, Toad, ADI, Champs, Testing Tool (Mercury QC, QTP &Trunkey) Mark view 170 system.
Languages:
SQL
Packages:
Tally 5.0, Champ
Reporting:
Hyperion, Noetix, OBIEE & & Discoverer
Database:
Oracle 9i/8i
Tools :
SQL Loader, TOAD
Operating System:
Windows 95, NT, XP & Windows 7, MS DOS, UNIX.
Oracle Certifications:
- Oracle General Ledger –Release 12
- Oracle Payable – Release 12
- Oracle Receivable – Release 12
- Oracle Inventory – Release 12
- Oracle Purchasing – Release 12
Work Experience:
Confidential, LA&SFO, CA Mar’ 12 to Till date
Responsibilities:
- Working in Solution designs, enhance requests and projects for (Financial / Distribution as Business Analyst)
- Business process includes gathering requirement, analysis and solution designed, UAT & Go- Live which involves Documentation, testing and PROD support.( Financial module –GL,AP,AR,FA & CE)
- Project design and integration with third party system (Payment plus System)
- Production support OTC Cycle and Period close.
- Working Oracle support, patching.
- Initial R12 ground work and discussions with team.
- Project design and integration with third party system (Payment plus System)
Confidential. Feb’ 11 to Mar’ 12
Environment: R12.1.3
Responsibilities:
- Working in enhance requests and projects for Amazon (Financial /Distribution)
- Business process includes implementing Contra COGS and Vendor Returns process in Amazon.
- R12 upgrade project from 11.5.10 .2 to Release 12.1.3. (Involved in Training, Unit testing and UAT and Go – Live TG1 to TG5 instance and Post production support for Financial Modules)
- Worked on the roll out project on UK, DE and JP on Financial modules.
- Worked on Global Aging reports ( Detail and Summary )
- Worked on the AWS ( Amazon Web Services project on US and UK )
- KOR (Kindle Office Retail) implementation for Canada and Germany (Order to Cash –B2B process)
Confidential Feb’ 09 to Feb’ 11
Oracle Application 11.5.10.2
Responsibilities:
- Worked in enhancement requests and projects for POM & ROLL. (Financial Modules/OPM)
- Business process includes Financial, Distribution, OPM, Discrete, Supply chain Management.
- Worked on Mark view 170 system integration with oracle and support and implementation for UK operations.
- Gathering the Business requirements, implementing and developing solutions according Financial Business standards
- Supporting services and business users on application related support/ improvements and project related initiatives.
- Working with off-shore team on the technical deliverables.
- Working on ticket based system on production, Enhancement and project activities.
- Coordinating the deliverables with off – shore team. Leading and managing projects that helps improve efficiency and effectiveness for the business.
- Working on POM EDI process and responsible for functional designs and implementing EDI projects.
- Supporting day to day transactions with EDI setup/changes.
- Prioritizing ongoing projects and optimizing simple yet effective business processes and driving change within the organization through consensus-building.
- Managing on-time project delivery and business expectations and ensuring internal customer satisfaction.
- Working with OOD [Oracle On Demand] for patch activities and maintenance, refreshing instances and testing patches in Non Prod and moving them to PROD.
- Training Key business users before the deployment in production and taking Key reporting requirements on that project, working with the OBIEE / Hyperion/Noetix development resources to deliver a robust platform to enable end user report creation.
- Roll Out - Financials [GL, AP, AR, PO, CE,] projects for Korea and Japan and also implemented localization for Korea and Japan.
- Fixed Asset /SCM implementation for UK /Europe Legal Entities s.
- All the Reporting is done using Hyperion and Noetix.
Confidential Dec’ 08 to Feb’ 09
Oracle Application 11.5.10 (Financial) Payment Approval Process
Responsibilities:
- Custom workflow is develop to meet the Business requirement
- All the Payment batches are Approve/Reject through the Pay Group.
- Three level approval processes is setup base on the time out’s
- Workflow will be initiated automatically at the Build stage of the each batch.
- Testing all possible scenarios.
- Gathering the Business requirement and preparing AIM documents.
- Working with off shore team of the technical deliverable.
Confidential, CA Nov’ 08 to Dec’ 08
Oracle Application 11.5.10.2 Cash Management Implementation
Responsibilities:
- Business process includes getting the Bank file and uploading them through the SAMBA services and importing files in the APP schema.
- Auto reconciliation and Manual process has been configured
- Achieving & purging the data once the process is completed.
- Clearing entries setups
- Stabilizing the UAT and then moving into Prod instances and contact the day to day meeting with the business.
- Updating and maintaining AIM documents (BR100, MD050 & TE040).
- Setups and testing business process flows and doing end to end process with all integration.
- SOX Project implementation.
Confidential, IL Feb’ 08 to May’ 08
Oracle Application R12.0.4
Responsibilities:
- AMLI is Updradation Project from 11.5.9 to R12.0.4 Modules included (GL, AP, AR, CE, I supplier, Grants Accounting, Treasury and Financial Intelligence I Expense and I Procurement, SLA and Oracle Payment)
- Understand the existing system and mapping the requirements to new system.
- Understand them new functionality feature which are there in R12.
- Showing new process flow which can be adapted in the new system
- Stabilizing the UAT and Prod instances and contact the day to day meeting with the business
- Re- Engineer process as per requirement changes and Updating in the Documents
- Working with Off – Shore Technical team and understand them the requirements and checking develop custom report and program in CRP and showing same to Business and getting Approval .
- Updating and maintaining AIM documents
- Setups and testing business process flows and doing end to end process with all integrating with Legal Systems
Confidential, NJ Jun’ 07 to Jan’ 08
Oracle Applications 11.5.10.2
Worked as (Subject Matter Expert) SME
Project Name: GE –SSS Project:
Responsibilities:
- Creating Book Control, Asset Categories and running depreciation.
- Worked on the setup documentation for all the modules
- Completed the setup and Unit Testing
- Developed TE40 specific to the country and business
- Assisted the users to do the testing
- Developed Migration document to move the setup to production
- Configuration of Apps modules (I procurement, AP, AR, GL, FA,PA) for enhancement related issues
- Guiding the users in PROD/UAT instance
- Analysis, Design, testing and integration with Oracle Applications of interface programs
- Assisting the technical team for customization of reports
- Resolving the Apps related business issues
- End-to-end integration testing
- Function Design/ test scripts writing
- Developed and maintained extensive project plans, created status tracking mechanism for software development through Functional Specifications, Technical Specifications, Coding, Unit-Testing, Integration Testing, Cutover and Go-Live
Confidential, CA Nov’ 06 to Jun’ 07
Implementation Project on 11.5.10.2
Worked as Oracle Apps Functional Consultant
Responsibilities:
- Responsible for Requirement Gathering on Specific Operating Units related to AR and Advance Collections
- Providing specification and assisting the Tech team to validate and migrate data to Oracle AR.
- Setting up Intercompany transactions for AR and Advance Collections
- Defining Segments for intercompany transactions
- Setting Up and Testing the Auto Invoice process with all possible Adjustment entries
- Providing inputs on intercompany transaction setups and processes
- Done standard I procurement ,PO & AP setup
- Setup for Split payments and Advance collections at consolidation level
- Setting up all divisions and migrating the master data from the legacy system to Oracle AR using DATA LOAD.
- Leading and Testing the AR Process flow and Transactions
- Development of entire AR Test Scripts
- Develop the FSG Report
- Designed (MD50) specifications for Customization of Reports Development and Document Printing
- Updating and maintaining AIM documents
- Setup and testing of Account generator for a adjustment transaction (Customization)
- Creating Responsibilities, customizing menus, assigning to users using Functional Administrator (BR110)
- Resolving day to day issues on testing and changes in setup for Go Live stage