Vivek Selvaganapathy
- Oracle EBS Lead Consultant
- Marlborough, MA
- Member Since Apr 03, 2023
Candidates About
Vivek Selvaganapathy
Highlights
§ Over 11 years of IT experience in Oracle Supply Chain, Finance & Service ERP implementation, development, customization, post implementation support, problems resolutions and process Improvement projects
§ Over 6 years of experience in effectively managing remote and local development teams with Proven ability to quickly adjust to changes in project scope and lead team to focus on revised priorities
§ Liaison with all stakeholders in the methodologies used to create system functions and promoted partnership between users and technical staff.
§ Plan and manage multiple concurrent development releases making key decisions and prioritizing tasks to keep projects on schedule. Coordinated team meetings and facilitated negotiations amongst key players
§ Techno Functional expertise in implementing Oracle Applications R12/11x modules Purchase Order (PO), Inventory (INV), Order Management (OM), Shipping Execution (WSH), iProcurement, iSupplier, iExpenses, iStore, Pricing, Depot Repair (CSD), Install Base (CSI), Bill of Materials (BOM), Service contracts (OKS), e-Commerce gateway (EDI), Approval Management Engine (AME), Quality (QA) and System administration (AOL)
§ Strong ability to evaluate software system requirements, identify and define technical components including technical specifications, development tasks, system test plan, risk analysis and implementation plans
§ Expertise in Solution design for Business Flows and Functions such as Procure to Pay , Order to Shipment, Assemble to Order to Shipment , Supplier Return, Service Request to Resolution, Repair process, Quality management
§ Strong experience in Software Development Life Cycle (SDLC) process – Lead business meetings to gather requirements, perform feasibility analysis, design, technical specifications, development and unit testing, integration and production install and support
§ Extensively worked on developing Functional Design Documents (MD50), Technical Design Documents (MD70) and Installation Instructions (MD120) for customizing various modules in Oracle Applications
§ Strong experience in Oracle Application Framework (OAF) personalization
§ Technical expertise in Report, Interfaces, Conversions, Extensions (RICE) and Workflow components.
§ Strong programming experience in creating procedures, APIs, packages, functions, triggers, views, collections, records, sequences, materialized views and other database objects using SQL and PL/SQL
§ Provided thought leadership, mentor, resolve issues, foster a creative environment, and exceed client expectations. Leading Procure to pay team members on defect-resolution handling, organizing and addressing well in client meetings for the issues they are responsible for.
§ Strong Analytical, Inter-personnel, Problem-solving and Proven ability in meeting deadlines
§ Demonstrated strong leadership skills in managing Onsite and Offshore development teams and been instrumental in meeting schedules.
§ Ability to interact professionally with a diverse group, executives, managers and subject matter experts
§ Ability to deliver end to end solution for support problems and development works including identifying the issue, setup, programming and testing
§ Good experience in managing CRPs and User testing for prototypes, proposed solutions and developed solutions.
§ Dedicated professional with strong work ethics & self-motivation. Driven to learn, a go-getter with creative thought process
Certification
§ Oracle Certified Associate – 2009
Technical Skills
ERP Suite Oracle E-Business Suite R12/11.x; INV, PO, OM, AR, EDI, AME, CSD, CSI, OKS, AP, AR, GL and AOL
Development Tools SQL Developer, PL/SQL Developer, Toad, SQL Plus, SQL Loader
Oracle Tools Oracle Workflow Builder 2.6, BI Publisher, Oracle Developer Suite, Oracle Reports
Programming Languages SQL, PL/ SQL, Java
Document Methodologies MD.70, MD.50, MD.120, CV.60, BR.100
Operating Systems Windows XP/7 /8, DOS, UNIX, LINUX, SOLARIS
Other Tools Data Loader, Soap UI, HP ALM (Application Lifecycle Management), HP PPM (Kintana), IBM Clearcase, Oracle ACMP, SVN, Service now
Professional Experience
Masterminds Consulting Inc.
Dec-2014 – Present
Sunovion Pharmaceuticals Inc. Marlborough, MA
Oracle EBS Lead Consultant
Oct-2016 – Present
Sunovion Pharmaceuticals Inc. leads the way to a healthier tomorrow by creating medicines for respiratory diseases and central nervous system disorders.
Monthly Sales and Customer Extracts
Sunovion Pharmaceuticals Inc. requires the ability to produce two fixed position ASCII files containing customer and sales data. The files must be extracted and transferred to the IMS (Quintiles IMS Holdings, Inc.) server (via ftp) programmatically. This project was to build the required interfaces
§ Designed, Developed and Tested Sales and Customer Extract interface program.
§ This program extracts the Inventory, Customer Bill to, Customer Ship to and the revenue related information based on AR transactions (Invoices) that were created in a specific duration
§ Similar information is also extracted based on the Sales orders that were shipped in a specific duration
§ Interface was designed to extract only those items which are configured to be eligible based on NDC (National Drug Code) classification
§ This program was also designed to notify the support team/ administers at the end of its completion for both successful extract/ FTP and for any failures
EDI 812 Credit Memo Processing
The key requirements driving the design to submit credit memos individually to Oracle e-Commerce Gateway is the need to exclude Contract Sphere credit memos from EDI. This contrasts with the EDI 810 (Invoice) solution which submits all eligible invoices to e-Commerce Gateway at once.
§ Developed Oracle PL/SQL package to process EDI 812 inbound data file
§ Oracle e-Commerce Gateway view ECE_CDMO_TRX_NUMBER_V was used along with validations to eliminate Contract Sphere credit memos and get only the eligible ones
§ Seeded Oracle concurrent program OUT: Credit/Debit Memo (812) was used to process the eligible data
iProcurement and Customizations
§ Performed iSupplier related setups for Staples, defined direct punchouts (cXML) and integrated supplier’s catalog for buyers to purchase office supplies
§ Performed AME setups for payable invoice approval process. Defined rules, approver groups, attributes and conditions. The approval workflow was modified with AME rules to route the approval to Project manager for Invoices that were received against Project expenses
§ Reduced development effort by 10% by developing a generic utility PL/SQL program for loading any inbound files irrespective of its data structure. This program also gave the flexibility of including business logic during file loading process itself and eliminated its dependency on UNIX scripts and control files
§ Designed and built an Oracle BI publisher report to list all the EDI AR transactions (Invoices, Credit memo, Debit memo, Deposit, Guarantee, Bills Receivable) in PDF format
§ This report is based on Oracle seeded report – “Invoice Print Batch of Invoices”. A new report was developed for EDI transactions since the business requirement was to Print the report and send them as EDI transactions through EDI 810 and EDI 812 transactions
§ Enhanced all Interfaces from Oracle to Logility application to replace Novartis items with its equivalent Sunovion Items based on NDC (National Drug code). Sunovion’s Logility application had only Sunovion models being configured. So, Oracle interfaces were designed to replace all the Novartis items with Sunovion items under its transactions
§ This requirement was implemented by setting up items under Oracle Item Cross references
§ Designed and developed an Interface to pull all Actual costs and its relevant information from Sunovion Financial Data Warehouse to Planisware. This was done to implement a global project management system and track the expenses
§ Actuals cost interface from Sunovion’s FDW was designed to run on every 6th business day of the month
§ Implemented this program using oracle DBMS_SCHEDULER functionality. The program will run on 6th business day of the current month, will determine the 6th business day of next month and schedule itself to run on that specific day
§ This program will also notify the administrators the status of each run upon its completion
§ Modified Shipping confirmation process to create delivery by grouping all the order lines based on same shipping method, Warehouse, Tracking number for multiple Order lines, This eliminated the issue of multiple invoice creation for order lines within same Sales Order
§ The Invoice is created based on the Sales order information sent through EDI 945 transaction
§ Built a CSV report to list all the Return Material Authorizations (RMA) that was created in Oracle within a specific duration of time. This RMA report Customer, Price list, transaction date, related Sales Order number, Ordered date, return reason and warehouse related information in Comma separated format
§ Designed and Developed an Oracle BI publisher report to list all the Custom concurrent programs that were submitted by a specific list of Users. This was required by Sunovion Pharmaceuticals Inc. as it is under SOX compliance and has a mandate to report all Oracle application concurrent program behavior for SOX audits
§ Reduced more than 80% of the effort spent by IT-APPS team to identify the errors that were caused by concurrent programs
§ Oracle Lookups were designed to hold the list of users (Interface and Sysadmin) which submits the Custom programs
Kronos Inc. Chelmsford, MA
Oracle Applications Techno Functional Consultant
May-2016 – Sep-2016
Kronos is the global leader in delivering workforce management solutions in the cloud. Tens of thousands of organizations in more than 100 countries — including more than half of the Fortune 1000 use Kronos to control labor costs, minimize compliance risk, and improve workforce productivity.
Oracle Financials Reporting
Kronos has multiple business requirements for reporting on its sales and services. This project is to develop multiple reports which will provide performance insights to Business team.
§ Involved in iExpenses, project costing, integration, performed configuration setups related to project accounting for expenditures types, expenditure classes and categories.
§ Setup iExpense to enable project expense reports, Setup auto accounting for iExpenses related expense types, and expense templates.
§ Reduced the development time of Oracle reports 30% by developing a utility API to perform Oracle tasks in an effective way for non-Oracle integration (NetSuite OpenAir, Enterprise Data Warehouse EDW).
§ Designed and developed ‘Kronos Interim Tax trial balance for Mexico’ report. Kronos Mexico requires the use of deferred VAT and so a custom report was developed to list the tax balance of all open invoices or credit notes.
§ Developed ‘Kronos Contract Post Invoice Report’. This report is built to list the Invoice details (Invoice number, Bill-to, Ship-to and Transactional amount, currency) which is used by the business team to match all Service contracts against the Invoices that are raised against them.
§ Designed and implemented ‘Kronos Service Contract Depot Orders Created in Order Management Report’. This report is being used to identify Depot orders that are created in order management, in order for the service contracts team to update the contracts.
§ Developed ‘Open Purchase Orders report’ using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
§ Developed ‘Sales by Customer Ship-To Location’ report that shows the sales information with corresponding order number, invoice number, Item number, and PO and customer ship-to location.
§ Conducted workshops and training sessions for end users to provide them with shortcuts and point out lesser-known features for improvement of day-to-day productivity
Hologic Inc. Marlborough, MA
Oracle Applications Techno Functional Consultant
Dec-2015 – Apr-2016
Hologic Corporation is a developer, manufacturer and supplier of diagnostic and medical imaging systems related to women's health. It develops digital imaging technology for general radiography and mammography applications. Hologic is a leader in women's healthcare.
Access Remediation & Reporting – Phase 1
Hologic Inc has road map to implement a Role based access to its business users using Oracle AME. This is phase 1 of the plan to consolidate and restructure all Oracle Responsibilities based on Business need.
§ Accelerated ‘Oracle EBS user’s Access’ related issue resolutions to 20% less by discussions with Business team, IT managers and Auditors to consolidate and restructure the functionalities while ensuring the continuation of services.
§ Defined AME based Roles and created Grants for User access. Assigned these roles to users for the desired access level
§ Performed multiple OA Framework personalization on ‘Supplier’, ‘Customer’ pages to provide a controlled access for different sets of Oracle responsibilities. Deployed OAF personalization to multiple Oracle instances.
§ Involved in preparation of BRD for Oracle Pricing Overlap Report – A report to identify pricing overlaps for a given Customer/ Item/ UOM combination.
§ Prepared Technical design (MD.70) and Installation instructions (MD.120) for Oracle pricing Overlap report
§ Designed and developed an Oracle package using standard Pricing APIs to extract all the item, customer details for which there exists multiple pricing (Multiple pricing should exists for a combination of a Customer/ Item/ UOM/ Currency combination).
§ Designed a XML report to list all this information in Microsoft excel format. This report is sent to a configured list of users.
§ This report has helped to identify the pricing overlaps. Subsequently assisted the business team to update Oracle pricing setup which reflected in reduced revenue leakage.
§ Conducted workshops and training sessions for end users to provide them with shortcuts and point out lesser-known features for improvement of day-to-day productivity
GLOBALFOUNDRIES Inc. Malta, NY
Oracle Applications Techno Functional Consultant
Jan-2015 – Nov-2015
GLOBALFOUNDRIES is a semiconductor foundry that manufactures integrated circuits in high volume mostly for semiconductor companies such as AMD, Broadcom, Qualcomm, and STMicroelectronics. The firm owns eight fabrication plants. Fab 1 is in Dresden, Germany. Fab 2 through 7 are in Singapore, and a new plant, Fab 8, operational in Malta, NY (USA). These sites are supported by a global network of R&D.
Project NEXT
GLOBALFOUNDRIES has acquired two manufacturing plants from IBM. This project is aimed at extending the Procurement functionalities to these sites and to implement EDI functionality for Purchasing and Invoicing with Suppliers.
§ Designed and implemented EDI 810 (Invoice Inbound), EDI 850 (PO Outbound), 860 (PO Change Outbound), 855 (PO Acknowledgement) transactions.
§ Involved in discussions with Suppliers to derive at the Outbound (850, 860) and inbound (855) file structure.
§ Involved in EDI location setup of the suppliers and also its corresponding Trading Partner profile.
§ Modified and restructured Interface file definition for POO and POCO at Header, Line and Shipment levels to support the required file structure and to accommodate custom fields that are to be sent to EDI translator GENTRAN
§ Designed and developed a wrapper program to validate and invoke standard EDI API for outbound extraction.
§ Modified EDI 850 and 860 extension packages to include logic for extracting data on Custom fields.
§ Designed a custom framework for processing 855 from suppliers.
§ Developed alerts to notify the PO buyers through email with the data that was received through 855.
§ Designed and developed a reconciliation report (XML report) to be shared with PO buyers and EDI Gateway team with the details of the transactions (850, 860, 855 and Technical Acknowledgement).
§ Involved in communication with IBM team for obtaining Open POs and Supplier list that are to be converted.
§ Developed wrapper package with Oracle open APIs to import POs into Oracle R12
§ Setup Business diversity classification for suppliers by defining new Class category and class codes
§ Worked with Suppliers (Staples Inc) to setup iProcurement direct Punchouts for new operating units under GLOBALFOUNDRIES and implement procurement business logic
§ Involved in setting up direct Supplier punchout (cXML) to enable the requestors to create requisition directly from Supplier portal’s catalog
§ Involved in defining code conversion mapping (Item category and UOM) to receive data from Supplier portal through direct punchout.
§ Defined new attributes, action types and approver groups (the approvers are dynamically derived at from a custom table) to support approval process for Purchase requisition using Oracle Approval Management Engine (AME)
§ Developed approval rules based on Inventory items and Item quantities for ‘Purchase Requisition Approval’ transaction type using Oracle Approval Management (AME) for Parallel approvals. Configured the necessary action types and actions. This was used by Materials management team for overseeing the requisitions raised by buyers on a specific list of items
§ Defined new AME rule to send FYI notifications to super buyers for Requisitions that are created on a non-catalog item.
§ Conversion of Requisitions that were created in IBM SAP system to GLOBALFOUNDRIES oracle system.
§ Designed and built a XML report to list the maximum on hand quantity of all the Inventory part numbers in a specific duration of time.
§ Identified the changes required in Interface between Oracle ERP system in USA and SAP ERP system in Germany for new item categories
§ Developed an interface to create Move orders based on supplier lot number – Issue and return in Oracle is based on SAP work order request.
§ Designed solution for Supplier lot inconsistencies between different FABs
§ Performed OAF personalization on Supplier creation page to include Supplier diversity details
§ Created Oracle Alert to notify the support team when a new Item category related to Material connection Management (MCM) is created.
§ Did personalization on 'Subinventories Summary' form to list only a specific list of subinventories. The users can include item/ update it for Min max planning under these subinventories. But they cannot create a new subinventory.
§ Involved in setting up iSupplier user accounts and Created scripts for mass iSupplier oracle account enable/ disable.
§ Created custom responsibility for iSupplier (Suppliers can create Advance Shipment Notices only). Invoicing was established through EDI 810 process
§ Involved in writing Functional (MD50) design and was responsible for Technical (MD70) document based on discussions with business users.
§ Created test scripts for integration and User testing.
Tata Consultancy Services (TCS)
Feb-2006 – Nov-2014
Motorola Mobility LLC, Chicago IL
Oracle Applications Techno Functional Consultant
Jul '14 – Nov ‘14
Motorola Mobility is a global Fortune 500 company which fuses innovative technology with human insights to create experiences that simplify, connect and enrich people's lives. Its business consists of mobile device business which produces smartphones and home businesses which produces set-top boxes, end-to-end video solutions and cable modems. Motorola Mobility had generated revenue of $3.2 Billion on of 2013.
MX Gointerpay
Implement payment interfaces with GoInterpay systems for payments made in Mexico region. Initially, the payments were through Cyber Source but now switched to GoInterpay for MX locale.
§ Requirement analysis with Business users and Business analyst
§ Design and implement the technical components involved
§ Worked on Inbound & outbound interfaces with Gointerpay system to receive payments, send cancellation and Credit information using standard Oracle APIs.
§ Create receipts write off activities in case of cancellation scenarios
§ Create adjustment activities on Credit memos when we have any returns
§ Designed and implemented a XML report to send the consolidated data to GoInterpay on daily basis
§ Working on End to End Flow to see an impact with downstream systems.
§ Involved in System Integration and User acceptance testing with Business Users.
Motorola Mobility LLC, Chicago IL
Oracle Applications Techno Functional Consultant
Mar '14 – Jun ‘14
Promotional Credit
The scope of this project is to define process for virtually returning a unit and charge a different price due to promotion. Provide a Credit Memo to customer based on Sales Order and without bringing back device into Inventory and perform Process price adjustments to invoice when mobile device is returned for credit.
§ Designed and implemented Oracle Retro bill to fulfill promotional credit.
§ Performed a Proof of Concept for Oracle Retro bill functionality and demonstrated to business users.
§ Performed AS-IS Study, TO-BE Design, and GAP Analysis.
§ Performed various setups that are involved, Oracle Event Phase at Line adjustments specifically for Retro billing, Price modifier and the Price list to implement the price change that is required to make Sales Order eligible for Retro billing.
§ <span style="font-size:9pt;font-family:Calibri, 'sans-serif';color:#000