Home

Sanjeev G - Sr. Oracle EBS / Fusion Cloud Techno-Functional Consultant

[email protected]

Location: Alpharetta, Georgia, USA

Relocation: Yes

Visa: h1b

Resume file: Sanjeev_Galla_1787239649048.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

SANJEEV GALLA Sr. Oracle EBS / Fusion Cloud Techno-Functional Consultant [email protected] +1 (734) 821-5129 PROFESSIONAL SUMMARY Over 19+ years of extensive experience in designing, configuring, Implementation, Enhancement, Migration, Customization, Upgradation, Rollout and Support of various modules in Oracle Applications with major focus in Supply Chain Modules(SCM) Purchasing (PO), Inventory (INV), Order Management, and Finance Modules Payables (AP), General Ledger (GL), Costing, Global Order Promising, Shipping, Receiving, Project Portfolio Management, Work Definitions, Work Execution, Project Billing, Accounts Receivables(AR), Fixed Assets (FA), Oracle Lease Management (OLM), Application Object Library(AOL) Good knowledge in Bill of Materials (BOM), Work in Process (WIP), WMS, MES (Manufacturing Execution System), Cost Management. Extensive experience in different Oracle Cloud and E-Business flows in Order to Cash (O2C), Configure to Order (CTO), Quote to Cash (QTC), Return Material Authorization (RMA), Drop shipment, Procure to Pay (PTP), Work order Creation, Work order execution, Report Orderless Completions, Transfer Orders, Assemble to Order (ATO), Make to Stock (MTS), Make to Order, Internal Requisition / Internal Sales Order (IR ISO) and Planning to Execution. Thorough understanding of As-Is Process, designed To-Be Process, gathered business requirement, performed gap analysis, throughout all phases i.e. CRPs, UAaT, SIT Testing, Go Live and Production Support. Have worked on Oracle Cloud SCM, End to End R12 implementation, R12 migration/upgrades. Worked on 11.5.10 to R12.1.3, R12.2.3, 12.2.4, 12.2.5, 12.2.6, 12.2.9 Implementation, Upgrade and extension, Support Projects. Technically proficient in implementing RICE (Reports, Interfaces, Conversions, Extensions), ITR (Interface Table Reference), Oracle OIC, Oracle OCI, Oracle BI Reports, Oracle OTBI, XML Publisher Reports, Oracle Discoverer Reports, SQL Reports and PLSQL packages. Having complete understanding and Experienced in Procure to Pay (P2P), Order to Cash (O2C), Record to Report(R2R) business flows. Substantial Oracle PL/SQL Development experience in creating stored Procedures, Packages, Functions, Triggers, Tables, Flex fields, Profiles, Value sets, lookups, Indexes and Views. Worked on Version Control software tools to check-in codes and integrated with KINTANA, Serena PVCS management tool, CVS for file migration and well versed with Defect tracking using spread sheet and testing tool such as HP Quality Center (QC) and requirement tracking tool such as JIRA Followed Onsite-Offshore testing models and prepared Logical and Physical Data Model Diagrams, code review/self-review checklists, and Impact Analysis documents to prevent defect reoccurrence. Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV040& CV070) and Migration documents (MD0120) using AIM Methodologies, Agile methodology and DevOps methodology. CERTIFICATIONS Oracle 11i (1Z0-007, 1Z0-147) SQL, PL/SQL Developer Certified Associate. Oracle E-Business Suite SCM (Supply Chain Management) Certified Implementation champion. Oracle Partner Network certified for Oracle E-Business suite Essentials for Implementers. Oracle E-Business Suite Financials Certified Implementation champion. TECHNICAL SKILLS ERP: Oracle Cloud SaaS (Fusion) and Oracle E-Business Suite (11i, R12.1, R12.2) across Purchasing, Order Management, Inventory, Finance (GL, AP, AR, FA, CM), Project Accounting, WIP, BOM, SLA, and AOL; Procure-to-Pay, Order-to-Cash, and Record-to-Report business flows. Databases & Tools: Oracle Database (8i-12c), PL/SQL, SQL*Plus, SQL Developer, TOAD, SQL*Loader; Oracle Forms & Reports, BI Publisher, OTBI, Oracle Integration Cloud (OIC); Kintana, PVCS, HP Quality Center. PROFESSIONAL EXPERIENCE Aspen Aerogels, Inc., Northborough, MA Apr 2022 Present Sr. Oracle Business Analyst Partner closely with business leaders and cross-functional stakeholders to analyze business processes, gather and document functional requirements, perform gap analysis, and design Oracle Fusion Cloud ERP solutions that align with business objectives. Lead Oracle Fusion Cloud ERP implementation projects from requirements gathering through design, configuration, testing, deployment, and post-production support, ensuring successful delivery and user adoption. Define functional specifications, configure standard Oracle Cloud applications, perform fit-gap analysis, prepare solution design documentation, and provide end-user support across Finance and Supply Chain modules. Design, configure, and support Oracle Cloud integrations using Oracle Integration Cloud (OIC), including integration testing, troubleshooting, deployment, and ongoing maintenance between Oracle Fusion and third-party applications. Support Oracle Fusion Cloud implementation and migration projects by managing data conversion activities using FBDI, ADFDI, and Spreadsheet Data Loader (SDL) templates, ensuring accurate migration from legacy ERP systems. Execute Conference Room Pilots (CRPs), System Integration Testing (SIT), User Acceptance Testing (UAT), end-user training, production deployment, and hyper-care support for Oracle ERP implementations. Configure, support, and enhance Oracle Fusion Cloud Financials and Supply Chain modules, including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Procurement, Purchasing, Inventory Management, Cost Management, Order Management, Shipping, Receiving, and Supply Chain Execution. Lead the organization's transition from Oracle Classic UI to Oracle Redwood User Experience, configuring Redwood pages, validating functionality, and delivering user training to improve productivity and system adoption. Configure and maintain Subledger Accounting (SLA) rules, Accounting Methods, Accounting Event Classes, and Chart of Accounts (COA) structures, including implementing new accounting segments and financial reporting enhancements based on evolving business requirements. Design, develop, and maintain Oracle BI Publisher, OTBI, operational reports, dashboards, and analytics to support executive reporting, financial analysis, procurement, inventory, and operational decision-making. Activities Performed During Oracle Quarterly Patch Testing Analyze the impact of new features on existing business processes, custom configurations, reports, integrations, and extensions. Execute end-to-end business process testing, including: Procure-to-Pay (P2P), Order-to-Cash (O2C), Inventory Management, Cost Management, Shipping and Receiving, General Ledger. Validate production readiness checklists before quarterly patch deployment. Communicate release status, known issues, and new feature adoption recommendations to business stakeholders. Month-End and Quarter-End Activities Support Inventory period-end close by ensuring all inventory transactions are processed and accounted for. Support Cost Management period close by reviewing costing exceptions and resolving pending cost transactions. Ensure Purchase Orders, receipts, supplier invoices, and matching processes are completed before financial close. Validate Order Management transactions, shipping confirmations, fulfillment, and invoicing before closing the accounting period. Reconcile Procurement, Inventory, Cost Management, and Order Management transactions with Finance modules. Enterprise Integrations Built Supplier Invoice Automation (AP Invoice Integration): Designed and implemented an end-to-end invoice automation solution where suppliers submit invoice images via email. The invoices are automatically routed to Lexion for legal and business validation. Once approved, the invoice files are transferred to a secure file server, where the OIC processes the files and imports supplier invoices into Oracle Fusion Accounts Payables, ensuring accurate invoice creation, validation, and accounting. Purchase Order Integration: Designed and implemented an outbound Oracle Integration Cloud integration that automatically sends approved Purchase Orders from Oracle Fusion Procurement to suppliers through email interfaces. The integration supports supplier purchase order acknowledgment and acceptance, improving procurement efficiency and supplier collaboration. Salesforce Oracle Order Management Integration: Designed and supported integrations between Salesforce CRM and Oracle Fusion Order Management to automatically create Sales Orders in Oracle based on approved opportunities and customer orders. Enabled seamless synchronization of customer, order, and product information while supporting end-to-end Order-to-Cash business processes and order fulfillment. Manufacturing Quality Integration: Designed and implemented integrations to extract Oracle Manufacturing Quality Inspection results and publish inspection data to Microsoft SQL Server through Oracle Integration Cloud. The SQL Server database serves as the reporting repository for Spotfire, enabling near real-time quality dashboards, manufacturing analytics, and operational reporting. TE SubCom, Portsmouth, NH Jan 2019 Mar 2022 Oracle EBS Techno-Functional Consultant Program and roll out developed solutions in Oracle /ERP based environment. Provide technical consultation to business units and IT management to ensure development of efficient application systems. Define requirements, configure standard applications, and provide gap analysis and design, and end-user support. Design and document Oracle ERP based solutions to meet business requirements. Design and build Custom Oracle RICEW components and unit testing. Assist in the design, configuration, and deployment of Oracle SCM/ Finance Planning applications in the e-Business suite. Manage Oracle data conversion activities. Assist in migration from legacy systems to Oracle e-Business Suite. Perform conference room pilots, user acceptance and other required activities for Oracle ERP implementation projects. Utilize Oracle Databases 11g, Oracle Applications R12.2.5, Oracle Manufacturing Modules - Inventory, Account Receivables, Account Payables, Costing, Work in Process, Bill of Material, Quality, Production Scheduling,Oracle MES, Oracle SCM Modules C&S Wholesale Grocers, Keene, NH Mar 2018 Dec 2018 Oracle EBS Developer Program and roll out developed solutions in Oracle based environment R12.2.5. Provide technical and functional consultation to business units and IT management to ensure development of efficient application systems. Perform RCA and other causal analysis techniques to identify the Root-Causes of the process failures. Developed the out bound Interface to bring the CS_ITEMS from Oracle Ebusiness suite name called MDM to reclamation through ODI. Developed the Extensions for reclamation system Inbound stage tables Integrating the Angular and webservices with Oracle Reclamation system Project migrations across different DB and OS environments and Development to QA, QA to UAT, UAT to Production environments Neopost USA, Milford, CT Jul 2017 Mar 2018 Sr. Techno-Functional SCM & OLM Consultant Senior Technical Consultant for enhancement, rollout, and support of Oracle PO, OM, Advanced Collections, AR, and OLM during the Neopost US R12.2.5 upgrade. Worked on New Enhancements in RMA, drop shipment, Order to Cash process. Involved in the customizations of Procure to Pay process in PO and REQ Workflow Approval Process which also consists of Time out feature, Termination policy. Developed the interface dash report to see the Interface Errors based on the date. Worked on Interfaces to get the Legacy data from SAP using ITR Process. Developed Late Fee reconciliation report. Developed the custom JTF grid to show the delinquent accounts based on customer account in ERP and developed the JTF grid to show the delinquent account details based on Lease number in OLM. Worked on performance tuning on Lease Detail process, and Lease Detail Program was running for 15 hours to get the lease details and brought down to 5hours. GE (General Electric) Oct 2012 Feb 2017 Oracle Apps Sr.Technical Consultant Employer: Genpact India, Hyderabad, India One continuous multi-year engagement delivering Oracle EBS enhancement, rollout, and production support for GE Capital and GE Healthcare, spanning Oracle Leasing Finance Management (OLFM), AP, AR, FA, and Oracle Contracts. GE Capital RTS As a senior technical developer, I have involved in code migration activities from one database to another database by Analyzing of the requirements provided by the business/end users, Coding and reviews and issues resolution. Worked on Contract integrate the data between Oracle Contracts and Receivables Developed Amortization reports for France and Germany Operating Units Worked on Sev1 issues and applied one shot to make contract booked status if any change in the existing contract or if any change in stream element Sending the Billing details to super trump and receiving xml files from super trump Worked on Integration between AR and Oracle Contracts Training and guidance to Trainee s in Process and technical Knowledge. GE Healthcare CDDT R12 Enablers Contributed to technical design, development, enhancements, and support, including code migration between databases and offshore production support. Worked on BOM splitting functionality to enable user to break down a PTO model at option level to make necessary changes while placing quote Developed WIP JOB Kitting reports, Developed Move Order report, Developed the Purchase Orders Report. Worked on Drop shipments, IR/ISO, Back to Back order process Developed the code for GPRS process Visited Client Location (Milwaukee, WI) for R12 Go live GPRS Status tracking OAF Page and Developed customer discount OAF Page. GE GAMS Vector Gray Global Applications Maintenance and Support Responsible for production support, custom process analysis, API/report maintenance, and unit testing to ensure high-quality, timely resolution of open tickets. Ability to manage multiple poles simultaneously within GE GAMS-Juliet like fusion, gasification, C2C, Germany & Spain. Smoke tested multiple RICE items prior to each testing session including the customized mobile forms such as PO input value copy , the barcoded custom reports such as BOL report and expected receipt report. Performed Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution. Coordinated with 3rd Party (WCS) Systems for Integrations. GE Pressure Control Senior Technical Developer for the upgrade of Oracle OM, PO, INV, AP, and AR components from 11i to R12, including code migration, testing, and offshore production support. This role will be the primary R12 implementation and worked on OM, PO, INV, Shipping Modules Worked on Order Management processes like Back 2 Back Order and Assemble to Order and Engineering Change orders. Upgraded Oracle 11i to R12 in different environments for latest features. Worked on Epims interface, Worked on Primavera Interface. Worked as DP (Defect Prevention) Anchor to find out the possible solutions and action items to prevent those defects from recurring. Emaar Technologies, Dubai, UAE Feb 2012 Jun 2012 Senior Oracle Technical Consultant Arowana Consulting, Dubai, UAE Preparation of Detailed designs, Build, Code walkthrough, resolving technical and design issues and performing independent unit testing. Prepared Data Flow Diagrams for existing PL/SQL code. Created scripts to create new tables, views for new enhancement in the application using TOAD. Created PL/SQL stored procedures, functions and packages for moving the data from staging tables into interface tables. Worked extensively in tuning SQL statements to optimize the performance by using collections. Brocade Communications Inc. Apr 2009 Jan 2012 Technical Developer App Solutions, Hyderabad, India. Technical Developer implementing Oracle reports and technical design documents across the AP, PO, and GL finance modules. Developed Reports and Customized as per the CR s. Developed AR Dunning letter report Created indexes on the tables for faster retrieval of the data to enhance database performance. Created database objects like tables, views, synonyms, indexes, and sequences. Develop & debug PL/SQL, Create Execute and Optimize SQL queries while providing an interactive community to support the user experience by using TOAD. Rosetta Stone Nov 2007 Mar 2009 Associate Consultant iGATE Global Solutions, Hyderabad, India Technical Developer preparing technical specifications and developing packages and reports across the AP, PO, and GL finance modules. Created scripts to create new tables, views, Synonyms and triggers. Developed custom reports and interfaces that are registered as concurrent programs and which are run from SRS form. Created SQL*Loader control files for moving the data from flat files to staging area tables. Developed XML Reports using XML Publisher. Univision Feb 2007 Oct 2007 Analyst Deloitte Consulting, Hyderabad, India Involved in the Implementation and Post-Implementation Support Created Technical design and implemented appropriate system setups and security rules. Customized account generator, Supplier invoice account generator. Developed the Auto Invoice process in AR for importing sales orders. Developed a Custom Forms in Inventory to maintain different projects and accounts handled by the company. Developed Shell script for Oracle to Saba Outbound Interface, which is scheduled to run daily that extracts transaction details and Sales Order details for all the Customer POs in Saba Application. TCA Conversion Developed a conversion program to load all the Customers from the external legacy system into the TCA Architecture including HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_RELATIONSHIPS, HZ_CONTACTS, HZ_CONTACT_POINTS, etc. EDUCATION Bachelor of Engineering in Electrical and Electronics Engineering, Gulbarga University, India. Keywords: quality analyst user interface business intelligence database information technology golang hewlett packard purchase order procedural language Arkansas Connecticut Massachusetts New Hampshire Wisconsin