Oracle Cloud Supply Chain
Resume:
SAI SNEHA P
Oracle Cloud Techno Functional Consultant
@: ***********@*****.***
West Jordan, Utah
LinkedIn: https://www.linkedin.com/in/sai-sneha-pyapili/
Experience Summary:
●Overall, 9 years of experience in Oracle Fusion Platform playing a techno-functional role with BIP and OTBI Reporting using Oracle Cloud BI across various SCM and FIN modules and successful end-to-end implementations.
●Hands-on experience on technical and functional aspects in Order Management (OM), Procurement, Purchasing, Maintenance management (MM), Inventory Management (INV), Product Management (PM), Work Execution (WE), Cost Accounting (CA). Built various technical complex reports using SmartView and BI Publisher in GL, AR and AP modules.
●Handled multiple phases of implementation projects., fit/gap analysis, requirement gathering, solution design, Conference room pilot, System Configuration and Testing, End user Training (KUT, UAT), Data Migration for Go Live and technical support post Go Live.
●Successfully handled end to end implementation cycles from Discovery, Business Process Analysis, Process Redesign, Gap Analysis, solution, Configuration, and testing.
●Experienced in Data Mapping, Data Conversion using FBDI, responsible for key deliverables such as Solution Design Documents, Requirement Traceability Matrix, Configuration Workbooks, User manuals, Custom Report Design Documents. Expertise on delivering SCM Extracts and delivery options for the extracts and scheduling reports.
●Strong Functional Experience/Understanding of Oracle Financials & Supply Chain Management (SCM)
●Good knowledge on Oracle Cloud Infrastructure (OCI) and Oracle Integration Cloud (OIC)
●Worked on Bursting reports for multiple modules across SCM, Good knowledge on SmartView, FRS and Interactive layouts. Proficient in designing and developing various RTF templates and e-text templates, expertise in modifying and creating complex RTF Templates with Dynamic Logos and Content at runtime.
●Hands-on experience in Performance tuning for complex BIP extracts with bulk data. Provided page customizations using Sandbox, movement of technical objects from one instance to another.
●Worked extensively in developing Custom Reports and customizing seeded reports, Data Migration, Interactive Layout Report, SmartView. Having good experience in User Roles Creation, Role based Security Assignments.
●Participated in various code review meetings with the team, and provided alternatives and best practices for faster run times
●Good understanding of business processes in various ERP systems which includes Supply chain, O2C and P2P cycles, Financials, Procurement and Order Management.
●Expertise in interacting with various Technical and Functional Team members responsible for delivering reports, interfaces, user documents and lead technical brainstorming sessions and business requirement gathering sessions.
●Gained a bounty of knowledge through various project phases of development, implementation, functional support, go-live activities, and post-implementation support. Trained multiple batches of new Team members on Fusion SCM modules and aided in incorporating projects.
●Built a strong relationship with business experts and translated business requirements into system requirements and system settings. Documented business requirements, analyzed impact of the changes, prepared technical specifications, developed, configured, and performed unit tests as well as assisted the users in the UAT phase.
●Excellent Communication, Interpersonal, and Team Player Skill, Quick Learner and Self Starter, strong organizational and multi-tasking skills.
●Fast in learning new skills/tools to implement the same in business process improvements, Team player, Patient and Hard Working with excellent interpersonal skills.
Professional Experience:
Company
iMINDS Technology Systems Inc
Aug 2023- Present
Client
Prime Therapeutics
Role
Oracle Fusion Techno Functional Consultant Lead(SCM, FIN)
Responsibilities:
●Worked extensively on SCM modules (Order Management, Purchasing, Inventory, Procurement)
●Developed multiple Test scripts to test custom roles, created multiple custom roles based on security concerns and requirement
●Trained peers and offshore team across multiple modules, Handled Page customizations
●Developed technical documents including MD120, MD70, MD50
●As a Lead worked with multiple teams and members for defining Project scope, Requirements gathering, CRPs, deliver technical and functional solutions as per clients’ requirements
●Developed complex BIP reports and analysis extracts on Ad-hoc basis
●Developed reports to generate emails to various Buyers and suppliers notifying the Inventory stocks by developing Oracle Business Intelligence Data model and various reports with RTF template
●Aided in Data Migration activities using FBDI Templates
●Developed several e-text templates, complex reports, and data models as per the clients’ requirements
●Worked as Financials Analyst supporting the Oracle GL, FA, AR, AP modules
●Part of end-to-end ERP implementation for SCM modules (OM, Procurement, Product Management, Manufacturing, Maintenance, WOs)
●Worked with Onshore and Offshore teams at different time zones and ensured smooth operation
●Extensively worked on and supported in the Project Go-Live and User Acceptance Testing (UAT) and resolved any bugs on priority basis
●Perform day-to-day operational/production support
●Fixed the issues in the production environment related to missing data or wrong data generation in reports and extract used for interface and integrations by debugging the issue and modify their data mappings, data models, extract definitions, templates, Backend report SQL
●Gathered business requirements and utilized expertise in Oracle SCM for designing solutions
●Involved in complete documentation for the end users
●Developed complex BIP reports and extracts as per client’s requirements
●Designed complex RTF templates to display dynamic context and logos based on user regions
●Developed Test scripts for UAT and involved with users during Testing phase
●Involved in Performance tuning activities for complex time-consuming reports and improved the run-time. Resolved various bugs and issues in BIP reports on Ad-hoc basis
●Developed SQL queries to develop BI Extracts and troubleshoot data issues
●Worked with Oracle Support team on P1 issues to resolve Production issues
●Responsible for establishing and adhering to the projects communication plan and complying with all reporting requirements. Identified user training needs and devising user training programs
Company
Mastek
Aug 2022-Jan 2023
Client
Zamil Air Conditioners (zamilac.com)
Role
Techno Functional Consultant (SCM, FIN)
Enhancement Reports: Inventory Master Transactions, Safety Stock Performance, Item Balances and Reconciliation, Marketing and Cost adjustments, Material Transactions and Movements, Lot Expiry Notification
BIP Reports: Item Exception and Master Details report, Change Order, NIR Reports (PIM), Delivery Note, Gate Pass and Pick Slip Reports (shipping documents), Price List info, SO Per Invoice with Cost details, Previous Months Pending Orders to Cancel (OM), GL Voucher Report (FIN), AR Transactions Report (FIN).
Responsibilities:
●Developed Custom BIP reports on Landed Cost Management, Inventory Management, Cost Management, Product Model
●Built complex SQL queries to extract data across multiple modules for a given inventory transaction (Corresponding PO/SO/WO/Inventory transaction details)
●Developed Fusion Value sets, Lookups, Descriptive Flex Fields (DFFs), Custom ESS jobs
●Facilitated discussions with business users, and core ERP teams to establish business requirements for SCM modules
●Developed complex FIN reports like Customer Aging, Account Analysis, Trial Balance, AR, AP and GL
●Worked on complex RTF and Excel templates, displaying dynamic images and text based on Inventory Orgs
●Performed Page level customizations for each Module under DEV phase using Sandbox
●Worked on Role Based Access Control and Security of Users
●Created intricate queries to obtain complex calculations of inventory on-hand balances, opening and closing balances
●Prepared test scripts for Oracle GL, Trade Management, FA and AP modules
Company
Mastek
July 2021-Jan 2023
Client
Fine Hygienic Holding (FHH) (https://www.finehh.com/)
Role
Techno Functional Consultant
Description: FHH client manufacture, market, and distribute superior health and hygiene products for consumers, this project implemented Oracle Fusion for handling their supply chain executions. I was involved in analysis and development of various Supply chain related reports and customizations.
Enhancement Reports: Production Monitoring Report, LCM Shipment Status, Work Definition Extraction, Resource Utilization, Maintenance KPI.
Seeded Reports: Work Order Traveler Report, Work Order Print Label Report, PO Email Report, PO PDF Report
Responsibilities:
●Used tables and views from Common Work Execution, Common Work Setup, Maintenance Management, Asset Tracking, Landed Cost Management
●As a Functional Consultant and a team member played an important role in implementing SCM Modules (OM, PIM, Procurement, Supplier, Manufacturing, BOM).
●Well-versed with custom role creation and workflow configurations
●Responsible for issue resolution and bug fixing during different phases of Implementation
●Customized POs for Notification through Email Bursting (For Supplier communication and PO Approval).
●Created multiple setups in Frontend for Unit testing (PO, SO, WO, user roles setup as per client security restrictions)
●Worked on Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end requirements
●Created supporting MD150 documents for Integrations with Legacy systems, aided in Integration activities
●Worked in Data Migration activities using FBDI and Internal tool ‘Glide’
●Worked on displaying Barcodes for Labels under Manufacturing
●Part of OIC Team and aided in performing strategic orchestration integration with Legacy systems
Company
Bharat Electronics Ltd., Bangalore, India
Jan 2019-June 2021
Client
Ministry of Defense, India
Role
Project Engineer
Description: BEL is an Indian Government-owned aerospace and defense electronics company. It primarily manufactures advanced electronic products for ground and aerospace applications. BEL is one of nine PSUs under the Ministry of Defense of India.
Project Description: BEL is a public sector undertaking which was established to meet the specialized Electronic Equipment requirements of the Indian Defense Services. I was involved in Software department for SDRNC on inventory equipment update and created interface and scheduled jobs through AutoSys to sync eProcurement
Responsibilities:
●Creating Custom tables/Views as per the new inventory assignments for each equipment
●Maintaining parent and child Stock relations through daily scheduled Jobs
●Creating PL SQL Jobs and scheduling through Autosys Tool.
●Tracking Jobs and resolving issues during failures.
●Adhoc based Reports provided to Design engineers through SQL Queries.
Company
TATA CONSULTANCY SERVICES (TCS)
Jan 2017-Oct 2018
Client
Boeing
Role
Systems Engineer
Project Description: Developed Oracle Cloud implementation for the project’s various Supply chain modules, which includes developing custom BIP and OTBI reports and Page personalization using Sandbox.
Responsibilities:
●Status call updates, Plan tasks creation and Implementation
●Reports Development, BI Publisher, Pages Personalization.
●Creating Templates and Data Models with multiple data sets
●Code and Documentation Review, Responsible for Effective Onsite –Offshore Coordination.
●Worked on technical documents such as TE120, MD120
Company
TATA CONSULTANCY SERVICES (TCS)
Jan 2016-Dec 2016
Client
Cigna (Health Insurance)
Role
Systems Engineer
Project Description: Part of Oracle Fusion End-To-End implementation project, starting from defining project scope, requirements analysis, building supporting documents and core development, user acceptance and integration to Legacy system. Worked on PIM, Procurement and OM Modules extensively.
Responsibilities:
●Learnt Fusion from system perspective
●Involved in data setup and configurations
●Conceptual overview of Fusion architecture, OBIEE
●Direct Client interaction for solutions during project implementation phase
●Hands-on with OTBI reporting tool
●Performed various customized BIP reports as per client requirements
●Worked extensively on RTF templates
●Involved in providing and implementing Integration with Legacy system
Contact this candidate