It Analyst Resume
San Jose, CA
SUMMARY:
- More than 12 years of Technical/functional Experience in a large Engineering organization in various functions including Planning, Materials and Engineering.
- Over 12 years of experience in developing software programs for complete industry solution including Inventory, Order booking, Production planning, Materials, Stores & Purchase Management System including Analysis, System design, implementation and support
- Over 10 years of experience in Oracle ERP implementations with extensive experience in Functional and Technical areas of Oracle Applications.
- Design, Coding, Quality Assurance, Testing, Implementation and Database Administration.
TECHNICAL SKILLS:
Oracle Applications: ERP Release 12(12.1.3), 11i, 11.0.3 N.C.A. (3 Tire Architecture), 10.7 S.C Architecture), INV, PO, OM, Shipping, BOM (including Configurator), WIP, CST, DRP/MRP/ASCP, WSH, Quality, Install Base, Depot Repair, AOL, Alerts and System Admin.
Design Tools: Erwin, Bpwin
Front / Back End: Oracle 11g, 10g, 9.x, 8.x & 7.x XML Publisher and Developer 2000 (Forms - 4.5 & 6i & Reports - 2.5 & 6i)
Languages: C, C++, VB, PL \ SQL, SQL +, SQL Utilities (Import, Export, SQL * Loader 7.1, 8i), O/sWindows 2000, 95 & 98, NT 4 & WIN2003, MS DOS, HP 9000 UNIX and Sun Solaris 2.6
Hardware: IBM - PC (Intel Based Clients) Compatible SUN Solaris 2.6 System (Server) HP UNIX Server
PROFESSIONAL EXPERIENCE:
Confidential, San Jose, CA
IT Analyst
Responsibilities:
- Lead a prime role in implementing Customized Shipping Execution with tighter control to accomplish Customs Compliance globally. Most recently supporting LSS (R12 Implementation) and CE Projects (Country Enablement including India, Italy, CE - Bridge and MITG Waves.)
- Reviewing BRDs (Business Requirement Documents), Requirement analysis, Solutioning and addressing issues / gaps if any.
- Authored Functional Specifications for Customs Valuation for multiple releases interacted with X-Functional teams for clarification and approvals.
- Closely working with GTC (Global Trade Compliance) PMO Team, to understand business processes, gap analysis, requirement gathering and identifying application extensions and customization requirements.
- Extensively worked on configuration of Customs Valuation related set ups in Virtual Trader (VT), a third Party Product developed by virtualtrader.net
- Configuring and defining Valuation rules to obtain different valuation methods using complex logic involving multiple business attributes such as Booking and shipping Entity relationship, Order routing (Cisco Routed and Customer routed), Customer type, Default Sales Territory, Sales order discount and Trade-in Discount, Product group, Average Country Discount (ACD) etc., Output of these configuration is customs value to be used in the Commercial invoice, one of the key shipping document.
- Customization of Virtual Trader, to get key Commercial Invoice attributes such as CI Seller, Importer of record (IOR), Bill-to / Ship-to Parties etc.,
- Customization of Virtual Trader for Duty Billing, a process to get back the Customs duty paid by Cisco on behalf of customer through remittance invoice.
- Trained key users and Support team, in using Virtual Trader - Customs related functionalities.
- Worked on key business process improvements like ‘Custom Best Match Solution’, ‘Dual valuation’ and preparation of related functional specifications.
- Supported CRP and end to end functional testing (SIT, TCA, TCB, FPR) for Go-Live, coordinated with VT Vendor for bugs and related Service requests (SR).
- Customization, development and testing of Pl/sql programs for Global Customs Compliance reports and related custom utilities.
- Worked on Production support in the areas of Shipping Execution.
Environment: Intel Server with Linux OS, Oracle Applications R12, 11i (11.5.10), (OM, INV, PO, Shipping Execution, BOM, AOL) Oracle 9.x, 10g, Oracle, Web Server, Forms 4.5, 6i, Reports 2.5, 6i, Workflow 2.6.3 Discoverer 4i and SQL Loader