Archana Vuppala

Ph: (775)-813-3760

Email:

Summary:

  • Over 8 Years of IT experience and major experience in Oracle Applications (E-Business Suite) with emphasis in Financials and manufacturing modules.
  • Expertise in Technical and Functional aspects of Oracle Applications R12, 11i Financial, Supply chain, Order to cash and ManufacturingModules which include Order Management (OM), BOM, General Ledger (GL), Service contracts, Accounts payable (AP), Inventory (INV), Pricing (QP), Shipping (WSH), Purchasing (PO), Fixed Assets (FA), AOL, Oracle E Business Suite logistics.
  • Have hands on experience in Oracle Release 12 Financial Modules and Order Management.
  • Good knowledge in order to cash (O2C) and procure to pay (P2P) business flows.
  • Developed Interface/Conversion Programs and Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
  • Extensive experience in Analysis and Design of Database.
  • Good Exposure to Oracle Application implementation methodology (AIM).
  • Expertise in creating inbound and outbound feeds, creation of automated processes using Application Program Interfaces (API)
  • Experience in Customizing Standard Oracle Workflows and Creating Custom Workflow.
  • Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loaderscripts.
  • Experienced in Developing Technical design documents (MD070), Conversion technical design documents (CV060) and Migration documents (MD0120).
  • Extensive experience in developing and customizing Reports using Oracle Reports 9i/6i/4.5
  • Comfortable working on SQL*Loader, SQL* Plus, UTL_FILE, CONCSUB Utility, Oracle Import/Export utilities and SQL* Navigator.
  • Developing Install scripts, copy scripts and fnd load scripts using Shell programming.
  • Good understanding of Oracle databases, Strong in Inventory, BOM, WIP modules. Comprehensive knowledge in Purchasing and MRP (Materials Requirement Planning).
  • Good Expertise in Query and Performance tuning in Oracle. Having working experience in analyzing the Oracle SQL Raw Trace and TKPROOF Trace files in working query and database performance issues.
  • Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
  • Experienced in requirements gathering, system analysis, design, development, testing, implementation, support, documentation and design reviews.
  • Professional experience in using External Tables and Temporary tables.
  • Capable of Performance Tuning, Optimizing SQL and PL/SQL scripts.
  • Registering of Custom Applications/Table/Schemas in Oracle Applications.
  • Worked on Oracle Alerts and exception handling.
  • Excellent analytical, problem solving, communication and inter-personal skills.
  • Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
  • Interaction with the offshore development team for development of reports and changes needed in the requirements.

Education & Certification:

  • Bachelors of Engineering from Osmania University, INDIA.
  • Oracle PL/SQL Developer Certified Associate.

Technical Skills:

ERP:Oracle Applications E-Business Suite of versions R12/11i (AP, AR, GL, WIP, BOM, OM, PO, INV, AOL, FA, Service Contracts)

Databases: Oracle 8i/9i/10g, MS SQL Server 2000, MS Access,MySQL
Scripting: SQL, PL/SQL, UNIX Shell Scripting
Programming Languages C, C++, Java, JSP, HTML/DHTML, XML, ASP, VB,

Operating SystemsMS-DOS, UNIX, Solaris, Linux (Red hat, SUSE 9.2/9.3), Macintosh,WINDOWS 98/2000/NT/XP/VISTA.

GUI: Oracle Developer - Reports 6i/9i/10g, Discoverer4i/9i/10g,XML/BI Publisher
Query Tools: TOAD, SQL Navigator, SQL*PLUS
Other Tools: SQL*Loader, Erwin, Smart Draw, MS Visio, MS ProjectProfessional 2003

Professional Experience:

Symantec Corp, Mountain View Mar ‘11 – Till Date

Oracle Techno Functional Developer

This project comprises the integration and, where applicable, enhancement of the Symantec ERP to support Symantec’s recent acquisition, Verisign, merging with Symantec’s existing systems. The primary benefit to Finance is business process efficiency and cost savings resulting from the migration of Verisign systems to Symantec’s applications.

The primary technical challenge is implementing the ordering process requirements for Verisign products as these requirements may involve changes to the Symantec’s Class Form/workflows.

Responsibilities

  • Involved with Business Services team and worked closely with the Oracle Accounts Receivables , Order Management and Quote to Cash Oracle systems.
  • Interacted with all Business users and Technical team to understand the right approach and Information to implement the integration between the Symantec and Verisign Oracle ERPs.
  • Developed the Hierarchy and design for creating all the Interfaces using Oracle Pl/sql.
  • Gathered business requirements and then translated business needs into functional specifications and technical documents MD 50 VeriSign UA Bookings and VeriSign QTC integration.
  • Prepared project-initialization documents, Mapping Information Guides and functional specifications.
  • Worked on complete integration between the Verisign and Symantec Oracle ERP.
  • Worked on Conversions to import orders and invoices from VeriSign Oracle ERP to Symantec Oracle ERP.
  • Designed and developed the Functional Docs (MD.020), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
  • Created Alerts which send mails to the support teams when any concurrent request runs for more than an hour.
  • Worked on the issues of Orders with Pick release, Ship Confirm processes, and Order status.
  • Worked on custom stored procedures using PL/SQL. Writing SQL scripts for identifying the issues related to Orders, Deliveries in the database.
  • Registered custom tables on Oracle 11i (Accounts Payable, Accounts Receivable and Order Management).
  • Conversion of Sales orders from VeriSign to Symantec Oracle 11i.
  • Imported the customers into Oracle Receivables using the CUSTOMER IMPORT form with in oracle applications.
  • Imported customer data into Oracle Receivables tables using TCA APIs
  • Creation of new custom reports and customizing of existing reports using Oracle XML Publisher
  • Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
  • Created AR reports like Seven buckets report, invoice register report, aging report.
  • Developed Auto lock Box (AR) interface program..
  • The APIs involved are BOM_BO_PUB.PROCESS_BOM and BOM_RTG_PUB.PROCESS_RTG
  • Created Trigger on AR_PAYMENTS_INTERFACE_ALL to generate receipt number automatically
  • Used API‘s to import legacy data from staging tables to base tables.
  • Expertise in Creating and managing customers Using TCA (Trading Community Architecture) in AR module.
  • Developed interface programs using TCA API’s to import customers into AR and defined relationships between parties.
  • Developed a pl/sql function to set the remit_to_address_id manually in RA_CUSTOMER_TRX_ALL and call the function in post Auto Invoice Process.
  • Worked with Journal Import to bring legacy journals from AP, AR and Posting in Oracle General Ledger.
  • Wrote interfaces like MGR_FPA.BOOKING_MAIN_DL_PKG , BOOKING_OM_DL_PKG, BOOKING_REGION_UPDATE_PKG, BOOKING_RENEWAL_DL_PKG to pull all the orders and invoices from Oracle VeriSign ERP into Oracle Compensation Modules.
  • Customized the code to change the Licensee Country, Sales territory, Compensation amounts for particular orders according to the functional specifications.
  • Ran scripts or wrapper like BOOKING_GLOBAL_DL_RUN_UA to pull the load on daily basis from VeriSign to Symantec Database.
  • Worked on pulling all the orders for Oracle Compensations Module in order to compensate Sales Representatives.
  • Worked on SQL Loader to load all the data given in flat files with various special characters and comma delimiters.
  • Worked in Data fixing for various duplicate and errors in data.
  • Worked on debugging the code to find the missing orders, missing sku descriptions, transaction types and various other order identifications.
  • Worked on missing data due to Shareplex issues.
  • Worked on verifying the various orders and invoices using the Order types, Item descriptions, Transaction types, etc.
  • Worked on gathering information from the business and the technical team to create test scripts for validating the Orders, Invoices and the Payments moving from the target to the source systems.
  • Worked on HP Quality center to upload the test scripts and work on test cases.
  • Worked closely with Functional testing team to resolve all the issues regarding code changes .
  • Worked on Perforce for version control, submitting and migrating code.
  • Worked with the Oracle middleware system i.e SOA and Oracle Fusion during the processing of invoices from the source (Oracle) to the target systems (Oracle Compensation).
  • Worked on XL reports for submission of reports regarding all the order local and international amounts.
  • Worked on executing various procedures to upload new and updated data into various tables.
  • Worked on various triggers, constraints, temporary tables procedures, Lookups table and DB links.
  • Worked on inserting or updating data into tables using various execute procedures.

Environment: Oracle E-Business Suite 11.5.10 (INV, AP, PO, AR, OM), Oracle 9i, PL/SQL, Reports 6i, Perforce, Share Plex, Hyperion, SQL Navigator, TOAD.

Gilead Sciences, San Mateo July ‘10 – Mar 2011

Oracle Techno Functional Developer

Gilead sciences Business Unit is migrating from JDE People soft to Oracle ERP. All their Supply Chain Management and Financial based modules are transforming into Oracle system.

Responsibilities

  • Involved with Business Services team and worked closely with the Oracle Accounts Payables, Project accounting and financial systems team supporting Oracle’s R12 ERP.
  • Interacted with all Business users and assisted Technical and testing team with the right approach and Information Guides.
  • Developed the Hierarchy and design for the Interfaces using Counsel Link and Brain ware as the Middleware.
  • Gathered business requirements and then translated business needs into functional specifications used by Application Development for technical approach/design.
  • Prepared project-initialization documents, Mapping Information Guides and functional specifications. Ensuring that the development team has a thorough understanding of the functional specifications and providing additional information to the Development Team as needed.
  • Worked on gathering information from the business and the technical team to create test scripts for validating the Invoices and the Payments moving from the target to the source systems.
  • Involved in the implementation of OM Shipping on Technical side
  • Worked on Conversions to import orders and invoices from legacy system
  • Wrote interfaces between OMand Shipping by using Shipping APIs
  • Customized various reports in OM, Shipping Reports (Bar Code used), Pre Pick LPN Detail Report, and Customer Sales Representative
  • Customized Discrete Jobs Dispatch report, Discrete Job Pick List Report, Discrete Job Routing Sheet report
  • Customized the Packing slip, Pick Slip and sales order Acknowledgement report
  • Developed Custom forms to modify License Plate information.
  • Customized Commercial Invoice and Bill of Lading reports
  • Worked on HP Quality center to upload the test scripts and work on test cases.
  • Worked with the Oracle middleware system i.e SOA and Oracle Fusion during the processing of invoices from the source (Oracle) to the target systems (Counsel Link).
  • Worked on creating MD50 Clinical Trial Data for Complete Spend and design documents using MS Word and Visio.
  • Worked on creating the Roadmaps for various business cases.
  • Worked for understanding, analyzing and reporting on general Counsel Link usage and behavior.
  • Worked for producing standardized, scheduled reporting as well as ad hoc reporting related to testing and changes to the Counsel Link Sandbox.
  • Worked for developing new insights and analyses that inform decisions and help improve Sandbox site.
  • Effectively communicate results of analyses to key decision makers.
  • Worked on mapping of various invoice, payments, Vendors, Suppliers, Allocation and Product IDs.

Environment: Oracle E-Business Suite R12, 11.5.10 (INV, AP, PO, AR, PA), JDE, People soft, Oracle Fusion,

SOA,Counsel Link, Sandbox, Oracle 9i, PL/SQL, Reports 6i, TOAD, MS Excel, Macros, Visio 2000.

Cisco Systems, San Jose Mar ‘10 – June’10

Oracle Developer

Responsibilities:

  • Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, documentation and implementation.
  • Worked on the development of Data Migration,InterfacesDeveloping new Forms, Reports, Customizing Oracle Reports in Order to Cash and Procure to Pay Cycles touching various modules such as PO, AR, AP, GL and FA.
  • Worked on Cisco Order to Quote cycle with Smart care systems.
  • Worked on various custom tables and custom API’s.
  • Interacted with various business users to get the data migration information on various tables to be fixed.
  • Worked on CDETs and Kintana Clear case to get most of the bugs resolved.
  • Developed Migration programs to convert data fix various numbers and location ids, names and party site ids etc.
  • Worked on various GUI’s working on Java with database backend using Oracle Plsql.
  • Worked on various Oracle forms like, Order Entry, Item Master, Material Transactions.
  • Involved in documenting technical and functional design for Cisco International Brazil project.
  • Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
  • Worked on application support.
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
  • Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.

Environment: Oracle E-Business Suite 11.5.10 (INV, OM, PO, PA, BOM, Routings), Oracle 8i, PL/SQL, Forms 4.5, Reports 2.5, ANT, UNIX, Apache Tomcat, TOAD.

Motorola, Schaumburg, Illinois Jan ’09 – Feb ‘10

Oracle Apps Consultant

Description: Involved in implementation of Manufacturing, Order management, Shipping, Purchasing and AR modules of Oracle Applications. Customizing reports, Data Conversion script creation. Interface program for Oracle Inbound Out bound. Design the interfaces between Oracle Applications and external systems.

Responsibilities:

  • Worked as a Oracle Applications Techno-functional consultant responsible for the implementation of Oracle Shipping, OM and MFG Modules: INV, PA, AR, OM and WMS.
  • Worked on creating requirement document and design documents. Designed various interfaces using MS Visio and MS Projects tool.
  • Worked on gap analysis using MS Excel and Word.
  • Involved in the implementation of Sales order Delivery Information on Technical side
  • Involved in creating various sales orders for domestic and internationalcustomers.
  • Involved in pick releasing and ship confirmation processes.
  • Worked on the requested ship dates and restrictions on the pick releasing accordingly.
  • Worked on Conversions to import customer data and pricelists from legacy system
  • Wrote interfaces on Sales orders and customer information for the delivery of information to third party logistics.
  • Worked on setting up various responsibilities requested for third party logistics team.
  • Worked on settingup menus, functions and user profile options for each responsibility accordingly.
  • Knowledge on various tables on Oracle R12 in TCA, Accounts Payable, Accounts Receivable and Order Management).
  • Worked on Documentation for the upgradation from Oracle 11i to R12.
  • Created various UNIX Shell Scripts for loading process. Maintained the batch processes using Unix Shell Scripts.
  • Created UNIX Shell Scripts during data conversion process.
  • Worked on creating variousalerts likeONTC_SP_3B13_SHP_NOTIFICATION, ONTC_SP_3B11_STAGING_ERROR, ONTC_SP_1A1_NOTIFICATION_EXP and all.
  • Customized various reports in AR and in shipping like Shipping execution Reports.
  • Customized Commercial Invoice and Bill of Lading reports
  • Customized Warehouse Inventory, Reverse Logistics report, Daily sales, Mtl Shortage Report, Shipped pending reportand many more
  • Involved in the technical design and coding for conversions, interfaces and custom application development. Several inbound tables, snapshots, views, procedures,triggers and packages were built during the application development. Was involved with OE-OM, AR, MRP, CRM, PO, FA and HR modules. The core part of the application development was in pl-sql.
  • Designed and developed strategy to capture the legacy data and API to ORACLE database. Ontc_ interface were populated during conversion and API inserts the information to Oracle base tables.
  • Populated base tables with legacy customer information. Developed orders interface to populate the oe_order_headers_all and oe_order_lines_all. Similarly a custom interface program is developed to inform shop floor about the open orders and related customer information from Oracle WIP and ORDER tables.
  • Worked on creating workflows and customizing workflow.
  • Coordinated testing team to get the testing information from all the tracks.
  • Worked on inbound and outbound interface testing
  • Resolved issues during the System Integration and Customer Acceptance testing phases.
  • Worked with Quality center for uploading requirements.
  • Worked with business users to analysis graphs as required.
  • Worked on the defect analysis and how to make various defect tracking.
  • Worked on the reporting team for pulling the data from the brio reports into the Enterprise DataWarehouse environment.
  • Worked on data mapping to check the tables on the DWH from where the data is being populated for reports
  • Worked on data mapping to get to the source of the tables in DWH(CGISS, SMS)
  • Worked on the servigistics extracts and analysis of data. Which table the data is coming from
  • Worked on the RPSD screens to check the VB.net backend and traced out the tables from which this data is getting extracted.
  • Worked as a Business System Analyst to analyze the data source for the RPSD screens, Servigistics and Brio Reports.
  • Developed MS Excel feeds using Discoverer Reports for Revenue Recognition, Product Shipped and various other requirements.
  • Developed functional mapping for existing legacy system to Oracle Apps. (Utilizing functionality of Key flex fields and Descriptive flex fields)
  • Worked on creating lookups according to the requirements.
  • Used Oracle TCA tables for Customer contact, Customer contact point’sinformation.
  • Worked on Kintana and clear case for moving from development to test instance.

Environment:Oracle Application 11.5.10, R12, Oracle Manufacturing (INV, BOM, WIP, PA, OTC, P2P, Shipping, Order Management, PO), TOAD 7.6.0.11, Visio 2000, Shell Script, Kintana and clear case, CGISS DWH, SMS DWH, Brio reporting tool, VB.net , Informatica, ORacle and Yantra.