Home

Sruthi Thyvalappil - Senior Oracle Cloud Technical Consultant

[email protected]

Location: Exton, Pennsylvania, USA

Relocation: REMOTE

Visa: H1B

Sruthi Thyvalappil Summary: Over 17+ years of experience in requirement analysis, impact assessment, gap analysis, technical design, program development, code reviews, unit testing and supporting functional testing, implementation and support of software applications using Oracle EBS and Oracle fusion spread across implementations, version upgrades and customizations. 7+ years of core technical expertise in Oracle Fusion Applications. Focus areas have been building custom BI reports, customizing standard BI reports, building OTBI reports, sandbox customization, data migration using FBDI, HDL and web ADI and POC s for interfaces using SOAP/REST API s. 1+ year of experience in Integration Cloud Service. Worked on building services to invoke various reports, place/release order holds etc. Certified in Oracle Inventory Cloud Implementation Professional (1Z0-1073-22). Certified in Oracle Cloud Platform Application Integration Professional (1Z0-1042-22). Completed Oracle Cloud Platform Enterprise Analytics 2022 Certified Professional (1Z0-1041-22). Experience in four full lifecycle implementations in Oracle Fusion data conversion. Excellent functional knowledge in Inventory, order management, customer, Procurement, Account receivables, Projects and HCM Modules. Experience in four full lifecycle implementations Oracle SCM and HCM modules. Strong knowledge of oracle procure-to-pay and order-to-cash cycles. Good functional knowledge in Oracle TCA, Inventory management, order management, Purchasing modules. Expertise in designing technical solutions for complex business requirements. Reviewing the design with customer team and acquiring sign-off for project milestones and effort estimates. Technically strong in PLSQL, SQL performance tuning, UNIX scripting, Oracle Forms, Forms personalization s, Oracle XML publisher, BI publisher, and DATA loader tools. Extensively worked on major data migrations programs. Designed and executed the end-to-end flow starting from data extraction, validations, migrations using API/Interface programs and data reconciliations. Experience is developing functional and technical specifications as well as test plans and test scenarios. expertise in quality center tool as well. Leading a technical team of 12 members. Managing task allocations, capturing progress of components through the project life cycle, code reviews, preparing status dashboard and chairing the project status review meeting with the client teams. Worked with different client IT teams, across geographies and various roles like technical lead, technology architect, business consultant, software developer. Excellent communication skills and effectively managed various stakeholders, team leads, working/ focus groups and steering committees. Technical Skills: Primary Skills: BI/OTBI reports, data migration, sandbox customization, REST API s in oracle fusion, Integration Cloud Service( ICS / OIC), Oracle EBS technical development (RICEW components), conversion & interfaces (inbound and outbound), forms, reports, XML reports, workflow builder Packages: Oracle cloud application 22D, oracle EBS 12.2.3, 12.1.3, 12.0.6, 11.5.10 Modules: Order management (OM), inventory (INV), Purchasing (PO), account payables (AP), Account receivables (AR), HRMS, HCM, Projects, Fixed Assets. Operating Systems: Win 10, Win 8, UNIX Languages: PL/SQL, UNIX Development Tools: Toad, SQL * Plus, SQL developer, BI publisher, oracle forms 10g, oracle report 10g, putty, win-scp Database: oracle 11g, 10g Version Tools: SVN Education & Certification: Bachelor of Computer Science, 2003 2006 Completed leadership development programmer of Indian Institute of Management Ahmedabad in November 2022 Completed Oracle external certification - Oracle Inventory Cloud Implementation Professional (1Z0-1073-22) in Feb 2023 Completed Oracle External Certification Oracle Cloud Platform Application Integration Professional (1Z0-1042-22) in May 2023. Completed Oracle Cloud Platform Enterprise Analytics 2022 Certified Professional (1Z0-1041-22) in May 2023. Professional Experience: Client: Johnsons Control Inc, Boca (FL) Duration: April 2024 to till date Role: Oracle Data Conversion Lead Project: Oracle Fusion Implementation Description: Data migration from legacy ERP Systems to Oracle Fusion. Primary activities include working with stakeholders on requirement gathering, design, development until implementation for PIM, Item OnHand, Item Structures/BOM and Sales Order entities. Responsibilities: Lead the data conversion track for SCM entities such as PIM, Structures, On hand and Sales order. Worked closely with all Stakeholders including business analysts to establish conversion strategy, map out legacy system data sources and create scripts to ensure the integrity of the source data. Responsible for all data cleansing, conversion rule implementation and perform all data validation both before and post conversion cycles. Perform and document configurations such as UOM s, Item types/status, additional attributes, value sets/lookups and EFF to store legacy item details. Create templates for validation checkpoints to verify source data files before loading. Constantly monitor to make sure team is closely following checklists before loading the data to fusion application. Consolidated source data files from various legacy ERP systems after thorough validations. Build and implement road map to ensure data reconciliations against the source data files. Cost/$ value at elevated level and attributes at granular level were reconciled to ensure 100% data accuracy. Developed a range of unique OTBI/BI reports for data validation, data mapping and reconciliation activities. Recognize and anticipate business expectations, make sure their needs are satisfied, and manage expectations accordingly. Work directly with customers, functional Analysts, and integration teams to establish conversion approach, complete migration of configuration and to complete the data conversion. Environment: Oracle Cloud Application 24C, Technical PIM (Item), Item On-hand, Sales Order Client: Henry County Schools, Georgia Duration: May 2023 to April 2024 Role: Oracle Technical Solution Architect Project: Oracle Cloud Implementation Description: To implement HCM and Financial modules into Oracle Cloud. Activities includes design, development until implementation. Responsibilities: Detailed analysis of technical requirements and done multiple POCs in HCM and Finance modules and proactively provide recommendations to stakeholders. Strong Functional knowledge in HCM Modules and Finance modules like Projects, Fixed Assets, Account Receivables (AR), Account Payable (AP), General Ledger (GL) and Procurement (P2P) and SCM Modules like Product Information Management and on hand. Work closely with client s IT teams leading fit-gap analysis, as-is and to-be business process designs, testing, end user training and to ensure that integration of new, enhanced and existing applications meet client specifications. Preparation of detailed design documents based on functional specification, creating set ups & various configuration documents, development based on approved technical design, peer review of the code and perform all levels of testing like unit, system, integration to ensure high quality deliverable. Setup status meetings with all stakeholders at regular intervals to review the project status and deviation to milestones, if any. Monitoring and communicating progress for each task, highlighting slippages well in advance. Created custom BI reports and customized multiple standard reports. Created OTBI dashboards for analysis. Utilized sandbox customization for page personalization and managed data conversion using file-based data import process, HDI and web ADI. Experience in developing BI reports for various HCM, SCM and Finance modules. Develop ESS jobs, associate PVO s to ESS job parameters and schedule the jobs as per user requested schedule. Setup and maintain value sets, lookups for use by various custom reports and interface jobs. Hands on effort to deliver technical components on time. Environment: Oracle Cloud Application 23C, Technical HCM, Projects, Purchasing, PIM (Item), FA (Fixed Assets), AP (Accounts Payables) Client: Toshiba America Electronic Components, Irvine CA Duration: January 2023 to May 2023 Role: Oracle Technical Architect Project: Production Support and Enhancements Description: To provide production support for existing applications, handling change requests and enhancements, handling new projects which includes design, development until implementation. Responsibilities: Detailed analysis of production issues to determine root cause and proactively fix issues or provide recommendations for the fix to the development team based on the criticality. Strong Functional knowledge in SCM Modules including Inventory, Order Management (O2C), Shipping, Procurement (P2P) and Finance Modules including Account Receivables (AR), Account Payable (AP) and General Ledger (GL). Analyze and provide functional and technical support for Supply chain and OM related incidents. Responsible for leading and managing the development of all technical customizations (oracle forms, oracle reports, XML publisher, BI reports and interfaces) and implementing the best practice standards. Interact with business users to understand the business requirement and analyze the technical and functional feasibility. Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks, and products. Diagnosing system problems, disaster recovery testing and maintaining user accessibility Preparation of detailed design documents based on functional specification, creating set ups & various configuration documents, development based on approved technical design, peer review of the code and perform all levels of testing like unit, system, integration to ensure high quality deliverable. Involved in finalization of RICEW scope, performance testing and automation testing scope with client s team and all associated stakeholders. Work closely with offshore team members and client s IT teams on system strategy definition, requirement gathering, documenting business requirements, leading fit-gap analysis, as-is and to-be business process designs, testing, end user training and to ensure that integration of new, enhanced and existing applications meet client specifications. Worked on high level efforts for each of the development or enhancements tasks. Setup status meetings with all stakeholders at regular intervals to review the project status and deviation to milestones, if any. Monitoring and communicating progress for each task, highlighting slippages well in advance. Formalized various milestone reports on project progress against the project plan. Prepare dashboard with overall health of the project and publish it to various stakeholders on a weekly basis. In the event of any deviation in the existing project plan, produce mitigation plan and impact assessment report. Environment: Oracle applications R12.1.3, Oracle EBS Order Management, Inventory, HR, BI, AR Client: Alpha Theta (Japan, UK, US) Duration: May 2022 to December 2022 Role: Oracle Cloud Consultant Project: MS AX dynamics to Oracle cloud Conversion Description: Alpha Theta uses MS AX dynamics for all their enterprise planning solutions. As part of this project, they are migrating all the existing data into oracle fusion application. Responsibilities: Define cloud migration strategy from on premises to oracle cloud infrastructure. Analysis & assess cloud readiness design, cloud migration planning and migration execution. Perform business analysis, requirement gathering documenting business requirements, leading fit-gap analysis, as-is and to-be business process designs, testing, end user training. Work with customer representatives, both technical and non-technical, to produce a solution that fulfils their requirements. Created custom BI reports and customized standard reports Created OTBI dashboards for analysis. Utilized sandbox customization for page personalization and managed data conversion using file-based data import process, HDI and web ADI. In-depth functional knowledge of Cloud O2C flow, P2P Flow, Finance Modules and Manufacturing modules Worked on end-to-end testing for Item, Customer, Supplier, Order Management, Accounts Receivables (AR) and General Ledger Experience in developing BI reports for various SCM and OM modules. Develop ESS jobs, associate PVO s to ESS job parameters and schedule the jobs as per user requested schedule. Setup and maintain value sets, lookups for use by various custom reports and interface jobs. Created and reported daily status of projects, including in-house and on-site analysis and identified areas of improvement. Hands on effort to deliver technical components on time. Coordinate the offshore/onsite team for the design/development phase of the project. Project data metrics and estimations. Environment: Oracle Cloud Application 22D, Technical Order Management, Product Management, Procurement Client: Enphase (India) Duration: August 2021 to April 2022 Role: Oracle Cloud Lead Project: Oracle R12 to Cloud Implementation Description: Accelalpha provides IT services to implement and manage oracle cloud applications. It has implemented oracle finance cloud to manage their internal financials. Responsibilities: Analysis & assess cloud readiness design, cloud migration planning and migration execution. Good business analysis and strong technical technology skills Work with customer representatives, both technical and non-technical, to produce a solution that fulfils their requirements. Created custom BI reports in Supplier, GL, Customer, AP, Procurement, Order Management and Manufacturing (WIP) modules Customized standard reports in SCM like Generate EFT Payment Created OTBI dashboards for analysis. Manage data conversion using file-based data import process, HDI and web ADI for customer, sales order and account receivables (AR). Created rest API procedure for applying sales order holds. Worked on end-to-end testing for O2C flow. Expertise in sandbox customization for page personalization Hands on experience in data conversion using file-based data import FBDI and HCM (HCM Data Loader). Develop ess jobs, associate PVO s to ess job parameters and schedule the jobs as per user requested schedule. Scheduled and facilitated meetings between project stakeholders to discuss requirements, deliverables, schedules and conflicts. Verified quality of deliverables and conformance to specifications before submitting to clients Setup and maintain value sets, lookups for use by various custom reports and interface jobs. Created and reported daily status of projects, including in-house and on-site analysis and identified areas of improvement. Hands on effort to deliver technical components on time. Coordinate the offshore/onsite team for the design/development phase of the project. Project data metrics and estimations. Environment: Oracle Cloud Application 22C, Customer, AR, General Ledger Client: ICHOR, Fremont, CA Duration: March 2020 to July 2021 Role: Oracle Cloud Technical Lead Project: EBS to Cloud Conversion Project Description: This key objective of this project was to deploy a comprehensive end-to-end integrated oracle cloud ERP solution across all the sites identified by ichor. It involved conversion of all finance, SCM and manufacturing modules data from legacy system to ERP Cloud. Responsibilities: Experience in developing BI reports for various SCM and OM modules Develop ESS jobs, associate PVO s to ESS job parameters and schedule the jobs as per user requested schedule. Led the conversion team of 12 for the migration of data from EBS to cloud and manage day to day activities for offshore team. Experience in data migration to oracle cloud using FBDI and web ADI tools for all expert entities like Item, Supplier, Customer and transaction entities like Purchase Order, Sales order, Open AR, Open Work orders. Familiar with step-by-step process of data migration starting from extraction, validation/de-duplication, import and reconciliation. Experience in HCM data migration using HDI Performed cost reconciliation and WIP reconciliations after data migration to cloud. Solutioning and providing proof of concepts walkthroughs on various new offerings and out of the box solutions to the client team. Experience in setting up spoke systems and various BPM processes. Develop BI reports for outbound interfaces with various delivery options as per requirement. research and execute proof of concepts for inbound interfaces using REST and SOAP services. Customized standard reports like AR Aging Report Setup, maintain and migrate EFF s to accommodate various business requirements. Also, setup value sets, lookups for use by various EFFs, custom reports and interface jobs. Identify functional gaps, design, develop solutions to bridge the business process. Interacted with the business team on the requirements gathering and provided weekly project status report. Provide project plan, dependencies, delays, issues, risks and provide mitigation plan to timeline and scope. Project data metrics and estimations. Coordinate the offshore/onsite team for the design/development phase of the project. Hands on effort to deliver technical components on time. Environment: Oracle Cloud Application 21A, Modules - Product Management, HCM, Procurement, Inventory, Manufacturing Client: Parametric Technology Corporation (India) Duration: September 2018 to February 2020 Role: Oracle EBS Technical lead Project: Conversion and Integration Project Description: This project was executed using agile methodology. It involved conversion of AP and FA data from PTC legacy system to EBS, customization on AR module to include GST Tax and migration of global HR and compensation from EBS 11.5.10 to oracle HCM cloud with integrations back to EBS. Responsibilities: Led the development team of 12 for developing interface between oracle HCM cloud and EBS Identify functionality gaps and develop solutions to them. Interacted with the business team to finalize designs, formalize requirements and wrote/optimized user stories based on the requirements gathered from all the stake holders. Provide production support and full solution handover to the client business team. Prepare weekly dashboards and milestone reports to track the health of the project. Coordinate the daily stand-up meeting with onsite/offshore teams and update the story status. Conduct code reviews with the team and provide input on a regular basis. Involved in AP invoice conversion and FA assets conversion from legacy system to oracle interface. Customized auto invoice interface program to include GST taxes. Developed interfaces for location, job, department and organization tree integration from oracle HCM cloud to EBS. Environment: Oracle Applications 11i (AP, AR, FA, HRMS), Oracle Cloud HCM Client: Avery Dennison, Glendale, CA Duration: March 2017 to August 2018 Role: Oracle EBS Technical Lead Project: R12 Upgrade & Development project Description: Technical upgrade from version R11.5.10.2 to R12.2.6 and DBA upgrade from 11.2.0.4.0 to 12.1.0.2. Responsibilities: Leading the technical team of 15 for upgrading forms and interface track for CEMLI Retro-fitment - objects identified. Responsible for driving the development activities and ensuring on-time quality deliverables. Task assignment to the team, code reviews and track the tasks to completion. Setup daily calls to review the status, highlight deviation to the delivery ETA s and produce mitigation plans. Analysis to identify impact to CEMLI components due to upgrade. Upgraded old forms using forms builder 10g and migrated to destination instances with zero issues. Facilitate technical requirements discussions in CEMLI re-design, development and approach finalization. Involved in bug fixing, enhancements & deployment process. Design and build training documentation for new team members and arrange knowledge transition sessions for the business teams. Responsible for writing queries and tuning of queries required for retro fitment. Responsible for tech track planning, execution, issue identification/ communication & resolution Self-motivated and able to manage workload efficiently and effectively. Provide guidance to team members, project and product development support, process mentoring, and product technical assessments. Ensures projects and service offerings meet tight schedules and budgets while retaining high quality standards. Environment: Oracle Applications R12, Oracle EBS CRM, Order Management, Inventory, AR, AP, GL, Pricing Client: Ricoh Americas Corporation, Malvern, PA Duration: February 2007 to February 2017 Role: Oracle EBS Technical Project: Multiple Projects Description: Was part of multiple projects in the specific account for over a period of 10 years. Was the key team player in most of the critical programs in the account and worked in a team leader capacity at a later stage. With vast experience in the account was able to train myself cross functionally and pick up technically challenging development projects Below are some of the major programs that she was part of over the years- R12 upgrade project includes porting all the existing customizations from 11i EBS system to R12 EBS system after doing a feasibility and gap analysis. The whole program ran for around 2 years and completed with stabilizing the target system. One system data conversion project involved migrating data from the existing 11i system to the R12 application. The project was the result of the client acquiring a major office document industry company. Order management development project was a long running project primarily to handle enhancement requests from client s business team. understand the business requirements or process changes and suggest optimal solution designs. Responsibilities: As a Team Lead Order management, contribution covered the following areas: Identify the requirements and constraints in existing ricoh americas order management systems including the various business processes. Worked closely with key business process owners to understand process flows and conducted Cross functional meetings to identify fit gaps for the above modules. Developed inbound interfaces to fetch PO files, pick file and ASN file from legacy system to oracle base tables. Analyze and identify how much of the existing functionality of ricoh americas support the transition. Design an integrated business solution to maintain the service systems and order management in oracle coordinated and to deliver an optimized and cost-effective supply chain and service business. Design a robust interface which can communicate seamlessly to the third-party warehouse systems and the ricoh manufacturing hub. Arranging periodical training session for business users for newly developed customizations and interfaces. Coordinate with individual business groups for national service parts system and ricoh USA Company on requirements analysis and design approvals. Coordinate the offshore/onsite team for the design/development phase of the project. Environment: Oracle Applications R12 (Quoting, O2C, P2P, INV, AR, AP, Procurement, BOM, Manufacturing, Inventory, UAM), PL/SQL, SQL*Loader, Toad 9.5, quality center, PLSQL developer, adobe acrobat, MS Visio Keywords: business intelligence information technology purchase order microsoft procedural language Arkansas California Delaware Florida Pennsylvania