Sandeep Kumar Stothra Bhashyam
Oracle Apps Technical Specialist
Hyderabad
Summary
Results-driven professional with 15+ years of experience as an Oracle Techno-Functional Finance/SCM Consultant and Manager with a deep understanding of industry-specific challenges and the ability to drive impactful outcomes. Successfully delivered solutions for end-to-end implementation, ensured seamless supply chain management, order management and customized business requirements across diverse domains during tenures at UST Global, and Doosan. Proven expertise in Development, Enhancement, Maintenance, Support, Data Migration, R12 Upgrades, and Integrations.
Overview
16
16
years of professional experience
Work History
Oracle Techno Functional Consultant
Doosan Bobcat India Pvt Ltd
02.2021 - Current
- Played the role of Technical Design Architect for FIS GetPaid Credit & Collections application Implementation and travelled to Czech Republic in Sep-Oct 2022 to ensure successful project Go-Live
- Within the Global Team, Worked on multiple projects across regions.
- Implemented FIS GetPaid Credit & Collections application globally.
- Worked with different ERP teams and other business units to write functional design documents with a heavy focus on the Account Receivables and Order Management Holds.
- Participated in design workshops with key business contacts and ERP teams for creating and updating design documents for forms, extensions and conversion.
- Developed Integrations for end-to-end interface needs of GetPaid application.
- Tested custom solutions for new functionalities designed to fit client needs.
- Prepared and managed functional design documents for data conversion from legacy to oracle R12.
- Developed multiple custom complex SLA rules based on the business requirements.
- Global Finance Team.
Software Engineer
Doosan Bobcat India Pvt Ltd
06.2017 - 01.2021
- Playing role of Finance Technical lead, prioritizing, and delegating tickets along with mentoring the offshore team.
- Involve in requirement gathering with clients and walk through the new design for various components.
- Analyzing the Issues and enhancements raised in “Jira” Ticket management system and fixing those issues on priority basis.
- Fixed multiple code level issue in PL/SQL packages, Interfaces and Reports.
- Worked on Development various XML Reports, WEB ADI and Discoverer Reports.
- Create views bases on the Payloads received from SOA using XMLTABLE.
- Gather requirements from onsite and design solutions accordingly. Analyze the existing 11i system and develop the optimized solutions for R12.
- Fixed multiple code level issue in PL/SQL packages, Interfaces and Reports. Developed a daily EMEA Supplier Portal outbound interface which shall include all the new accounts/account updates information.
- Involved in code construction/changes to the existing programs for SQL, PL/SQL programs.
- Created Database Objects like Tables, Views, Sequences, Synonyms and PL/SQL Programs like Packages, Procedure, and Functions and modify the same as per the functional requirement.
- Co-ordinate with Onsite Coordinator for better understanding of requirement and for delivering quality products.
- Perform Unit testing of the module developed and checks for the overall functionality of the module.
- EMEA Region R12 Re-Implementation & NA Region- Application Development/Enhancements
Software Engineer
UST Global
05.2010 - 05.2017
- Worked on development of new custom reports using BI as per client requirements.
- Interaction with functional consultants, understanding the requirements and proposing solutions as per the business requirement.
- Customization of seeded reports as per the client requirement like to have custom PO layout and Custom Invoice layout.
- Responsible for enhancements depends on client requirements.
- Involved in customizing and developing the Reports.
- Involving the status call on weekly basis for the assigned defects.
- Involved in BI publisher (XML Publisher) Reports
- Gather requirements from onsite and design solutions accordingly.
- Developed Supplier Inbound & Developed XML publisher Purchase order summary report.
- Worked with project managers, developers, quality assurance and customers to resolve technic.
- Identifying the bugs in the existing system as a part of production support activities and provided code changes. Troubleshoot batch failures to determine cause (review Control-M logs) and correct/escalate.
- Monitor Production Jobs to ensure successful execution.
- User administration – Add, Edit and Delete users, assign users to groups, Change Password.
- Developed Subscription Update page to upload the Invoice Details into oracle Custom Tables.
- General Electric (GE)- GE SSS R12 Re-Implementation
Education
Master of Science -
Eastern Michigan University
Michigan, USABachelor of Technology -
Jawaharlal Nehru Technology University
HyderabadSkills
Professional Summary:
- Played the role of Technical Design Architect for FIS GetPaid Credit & Collections application Implementation.
- Involved in various phases of development such as requirement analysis, estimation, design, coding, documentation and testing.
- Prepared technical estimates, design documents, Unit Test Plan and Code Move documents as per AIM documentation methodology.
- Hands-on involvement in business requirement gathering, GAP analysis, process mapping, configuration, setups, work around, interfaces, user training.
- Ability to multi-task, work independently and with teams in fast-paced, high-volume environments. Playing role of lead, prioritizing, and delegating tickets along with mentoring the offshore team.
- Experience in reviewing the Functional Documents and preparing and modifying the Technical Design Document for the development work done like MD50, MD70
- CEMLI remediation of impacted custom objects.
- Provided Techno-Functional post-upgrade support in Accounts Receivable (AR) and Credit Management modules.
- Collaborated with Oracle Support for standard bugs by raising SR and tracking to closure.
- Excellent technical knowledge in developing SQL, PLSQL, Host, Oracle Reports, Discoverer Reports and XML Publisher Reports.
- Developed FTP and email host programs.
- Customization of forms using Forms Personalization.
- Mass update of legacy systems data to Oracle Applications using SQL *Loader and Interfaces and Conversions.
- Acquainted with Supply Chain Management (OM, PO), Financials (AP, AR), and SLA modules.
- Knowledge in Application Object Library (AOL) to define Form Functions, Menus, Responsibilities, Responsibility Menu Exclusions, Flex Fields, Value Sets and Concurrent Programs.
- Hands-on experience in code reviews and executing unit test plans
Timeline
Oracle Techno Functional Consultant
Doosan Bobcat India Pvt Ltd
02.2021 - Current
Software Engineer
Doosan Bobcat India Pvt Ltd
06.2017 - 01.2021
Software Engineer
UST Global
05.2010 - 05.2017
Master of Science -
Eastern Michigan University
Bachelor of Technology -
Jawaharlal Nehru Technology University