Oracle R12 ERP Support Analyst supporting Supply Chain, Contracts and Financial Modules – National Industries for the Blind
♦ About 10 years of IT experience with more than 8 years of strong functional experience in design, Documentation, implementation, upgrade, Set ups, Configuration, Testing, Training and production support of Oracle Applications R12/11i (GL, AP, PO, AR, CM, SLA, Advanced Pricing, Projects, Payments, Oracle Order Management (OM) & Inventory, SCP and Service Contracts).
♦ Worked as Systems Analyst lead at XO Communications for 4 years.
♦ Participated in all aspects of software development Life Cycle, Implementation, Production Support, Procure to Pay and Order to cash cycles.
♦ Extensive experience as a Functional Analyst working on Oracle EBS (R12/11i) and their Configurations in Supply Chain Management (SCM), Manufacturing (MFG) , Advanced Pricing, Projects and Financial Modules.
♦ Exceptional ability in coordinating the onsite and offshore resources while achieving milestones and deliverables within time limits.
♦ Experience in development of concurrent processes, User set ups, Profile options, Approval groups and user management in Oracle.
♦ Hands-on experience with R12 upgrade and implementation.
♦ Gather business requirements, mapping business requirements to Technical Design, Documentation, Testing, Issue resolution and Conduct Project Team/End User Training.
♦ Set up New Inventory Organizations, operating units, sub inventories and all related set up’s.
♦ Worked on BR 100s, MD 50s, CR 50’s and different types of functional documentation.
♦ Strong perseverance and diligence towards attaining challenging goals and effective time management. Highly motivated team player.
♦ Excellent knowledge in Excel and Microsoft office, power point presentations and a good team Player.
♦ Simple Programming experience in creating Database triggers, Oracle Alerts, Procedures, Functions, Triggers and other database objects using SQL and sql loader in TOAD.
♦ Developed data conversion systems for various modules (AP, AR, PO, OM and INV) through interface programs using Data Loader and SQL*Loader.
♦ Good knowledge of System Administration (Sys Admin) & AOL in defining users, menus, responsibilities, request groups and maintaining concurrent programs.
♦ Good experience in dealing with Oracle SR’s
♦ Proficient in writing and fine-tuning complex SQL statements, complex joins, and sub-queries.
♦ Provide extensive functional support for post-production support in INV, PO, OM, Financial and MFG modules and Isupplier, iProcurement of Oracle Applications R12 and 11i.
♦ Strong Analytical, Inter-personnel, Problem-solving and Communication skills.
Oracle R12 ERP Support Analyst supporting Supply Chain, Contracts and Financial Modules
November 2012 to Present
Project: NIB is a Non Profit Organization that sells merchandise made by the blind People.
Role: Oracle R12 ERP Support Analyst supporting Supply Chain, Contracts and Financial Modules
Environment: Oracle Applications R12 OM, INV, GL, AP, PO, AR, CM, Service Contracts, Payments and Pre Payments, Advanced Pricing, SQL Developer, Data Loader Pro , BI reports (OBIE), ISupplier, Iprocurement, ireceivables, UPK’s and Approval management Engine.
♦ Set up Responsibilities, users, Menus and Request groups, Profile Options and Approval groups and user management in R12.
♦ Setup Customers, Suppliers and Price lists, Organizations and Grants for sales order.
♦ Setting up Blanket and Contract Purchase orders for Service contracts module.
♦ Set up Business unit and operating units.
♦ Set up Bank accounts and Approved supplier lists and sourcing rules along with related procurement set up’s.
♦ Did end to end testing for procure to pay and order to cash cycles.
♦ Resolved production issues in general ledger and payment modules.
♦ Support workflow issues in iprocurement.
♦ Provide production support and troubleshoot issues related to Purchasing, Payables, Receivables, Service contracts, Order Management, Inventory, and Financial modules.
♦ Setting up Value sets and values for DFF’s and also setting up values for key flexfields in GL and Inventory Pricing and Quotes.
♦ Wrote Adhoc SQL queries to the Business Intelligence reporting team.
♦ Set up Items, set up templates, Unit of measures and all item catalog related set ups.
♦ Trained end users in all modules.
♦ Set up Price lists, receipt classes, Organizations, Operating units and all Other set ups in all Oracle Modules.
♦ Set up Suppliers, Customers, Items, Item Categories, pick release parameters and run AR invoices against the Sales orders.
♦ Funds capture process for AR invoices, doing check run and setting up customers in oracle.
♦ Maintain and Monitor the concurrent programs on daily basis.
♦ Open/close of INV, PO, AR, AP and GL modules every month.
♦ Conducted Internal Meetings.
♦ Provided Documentation for end Users. (BR 100’s,MD 50’s etc)
♦ Developed test scripts for new enhancements.
System Analyst Lead
May 2008 to October 2012
Project: XO Communications is leader in providing Telecommunications in the corporate world.
Role: System Analyst Lead
Environment: Oracle Applications R12, 11.5.10, SQL Server, TOAD, Unix, Data Loader, Oracle SCP, AP, PO GL, INV, OM AR, costing, Projects
♦ First line of support to the client in supply chain management. Identify the problem and route it to the development team, by creating ticket, if required.
♦ Opening and closing of inventory periods at the beginning of the month.
♦ Involved in creation of complex table based value sets to meet the business requirement of being able to access accounting segment values
♦ Set up inventory organizations, loading items into new sub inventories, defining shipping Parameters, Min max Planning and other inventory related and Order related setups.
Set up shipping networks, internal customer sites and ship to addresses. Have done oracle cycle counts.
♦ Setting up Pricing for each item.
♦ Writing adhoc SQL queries for internal custom reporting and alerts.
♦ Did Average Cost updates and updated Approved Supplier Lists.
♦ Assign Approved suppliers to Blanket PO’s.
♦ Functional and User acceptance testing of extensions to applications.
♦ Training users on enhancements added by the development team.
♦ Did the functional setups and made changes to the existing setups per the business requirements in PO, INV and order management modules.
♦ Functional support for Oracle Inventory, Oracle Purchasing, Oracle Order Management, Warehouse Management and Advance supply chain-planning modules.
♦ Logged tickets in the Remedy system for the defects encountered during testing.
♦ Prepared Known error database for commonly occurring issues and developed reusable strategies to tackle them.
♦ Coordinated with Technical team and business in resolving the issue.
♦ Conducted Status meetings with onsite and offshore team.
♦ Lead the team in the Production Support for Oracle Supply Chain Modules.
♦ Ensure Issue-Free Inventory Period Closing for Inventory Organizations.
♦ Implemented ATO within Order Management.
♦ Approval Hierarchy for approving the PO is successfully created. (Change from Job Based to Position Hierarchy)
♦ Successfully troubleshoot Standard Purchase Order, Blanket PO and PO Releases.
♦ In shipping, set up Grant & Roles according to Business User roles, Shipping Parameters, Pick Release Parameters, Shipping Transaction Parameters, Delivery Parameters, Bill of Lading, Packing Slip, Shipping Document Sets, Pick Slip Grouping Rules & Release Rules.
♦ Setup Descriptive Flex Fields, Value sets for various components in OM, Inventory modules.
♦ Did the necessary setups in the test instances (CRP, UAT, etc.) and gave Demo to the Champion Users and End users where required.
♦ Configured the business process in the Test Instance and testing of various business scenarios.
♦ Developed context sensitive DFF on Item Master screen to show different descriptive columns based on the sales Item Category.
♦ Created adhoc queries for use by the user to fetch data from SCM website.
Oracle Applications Functional Consultant
April 2007 to May 2008
Project: Involved in Global implementation of oracle applications. BT implemented Oracle Applications 11i Suite and Oracle Projects for over 80 countries.
Role: Oracle Applications Functional Consultant
Environment: Oracle Applications 11.5.10, Oracle 10g
AP, GL, Projects, INV, OM, PO, AOL.
♦ Configured General Ledger Legal Entities, Organization & Sets of Books.
♦ Configured Purchasing & iProcurement modules.
♦ Configured Project Templates in Project Accounting module.
♦ Defined Mass Allocation formulae to assess a GL code combination level charge to the projects receiving certain types of revenue and to record the offset (internal income) in the accounts of certain Organizational units.
♦ Involved in creation of accounting flexfields and created complex table based value sets to meet the business requirement of being able to access segment values.
♦ Created tables, views and sequences related to data warehouse reports.
♦ Developed queries for comparing the data load in Oracle applications.
♦ Performed Integration testing on all reports.
♦ Set up of Inventory Organizations, Sub inventories, Item Sub inventory relationships, shipping networks.
♦ Performed debugging of the applications and helped team members in troubleshooting and debugging
♦ Responsible to coordinate with technical team for resolving the defects and/or for enhancing the functionality which were identified at each phase of testing
♦ Responsible for providing specifications, and test custom reports and programs
♦ Determined the process for Min-Max planning
♦ Comfortable researching issues on Metalink, reading source code and following eTRM’s.
Oracle Applications Consultant
April 2006 to March 2007
Project: N.E.W manages warranties on electronics issued by retail stores like Best Buy. N.E.W implemented Oracle CRM for customer and contract maintenance.
Role: Oracle Applications Consultant
Environment: Oracle Applications 11.5.10, Oracle 10g, Forms 6i, Reports 6i, TOAD. INV, AP, OM, Install base, Service Contracts, AR.
♦ System study, analysis and collection of information from various user groups.
♦ Developed interface programs to load customer and contract information into install base and subsequently move the data into CRM.
♦ Supported day-to-day business activities of the client.
♦ Imparted training to users on the sequence of concurrent programs and events to perform to load customer and contract information into the system and on making changes to the existing contracts.
♦ Developed & registered new custom reports and created new responsibilities.
♦ Troubleshot various interface programs and made changes per the data format of the retailer.
♦ Wrote SQL scripts to replicate the problem in Production and to test the fixes.
♦ Created Change Management requests to promote code changes to Production environment.
Bachelor of Science in environmental studies
Oracle R12, Oracle Applications R12, 11.5.10 (11i), Oracle Applications 11.0.3, Application Object Library (AOL) and System Administration
Accounts Receivables (AR), Accounts Payables (AP), Purchasing, Payments, General Ledger (GL) and SLA (FA),iprocurement, isupplier, Cash Management, ireceivables, UserManagement, Workflow
Oracle Manufacturing Order Management (OM), Purchasing (PO), Inventory (INV) , Projects (PA),Contracts and Advanced Pricing.
Oracle CRM Customer Management
Development Tools Developer 2000 (Forms 6i/4.5 and Reports 6i/2.5), Workflow Builder 2.6/2.5, Discoverer 3i/4i and TOAD
Languages Java, JSP, JDBC, HTML, XML
Databases Oracle […] MS Access
Operating Systems MS-DOS, UNIX, Linux, and Windows NT/XP/2000