I have a passion for learning about new technologies I have completed courses in Advanced Python and DSA
SUDIPTO DAS
Oracle Techno-Functional Consultant
Kolkata
Summary
Dedicated Oracle EBS Techno-functional Consultant and Oracle Cloud Technical Consultant with a successful career history comprising more than 4 years and 8 months of experience.
Have worked on Support/enhancement projects (both on-prem & Cloud)and Upgrade project (from R12.1.3 to R12.2.10) for international Industrial Sector Clients.
Overview
5
5
years of professional experience
7
7
years of post-secondary education
Work History
Oracle Cloud Technical Consultant
IBM
11.2022 - Current
- Have worked on end-to-end development of BI reports in Oracle Cloud.
- Have worked as an Oracle Cloud Technical Consultant on implementation, customization, and support of Oracle Fusion Cloud applications and Oracle OTM/GTM.
- Have implemented and customized various BI reports using complex SQL logic in multiple modules such as AP, Procurement, SCM, etc.
- Worked on customization and development of ESS jobs.
- I have worked on troubleshooting and support activities for Oracle OTM/GTM.
- Collaborated with cross-functional teams to complete complex projects on time and within budget constraints, meeting or exceeding project requirements.
- Created comprehensive documentation detailing technical specifications, system configurations, procedures, and user guides for reference purposes both internally and externally for clients.
Oracle EBS Techno-Functional Consultant
Tata Consultancy Services (TCS)
06.2019 - 11.2022
- Previously worked as a Techno-Functional Consultant in a Support cum Enhancement project for more than 2 years in AP and Purchasing module.
- Customized various Oracle SCM functionalities, such as AOL components, reports, concurrent programs, PL/SQL codes, Oracle Workflows and interfaces with third-party applications as per customer requirement.
- Designed and modified Oracle Reports using Reports Builder and Oracle XML Publisher Reports and created RTFs using BI publisher extensions.
- Worked on FMBs using Oracle Forms builder.
- Having expertise in Oracle SQL & PL/SQL.
- Created Tables, Views, Constraints, Indexes, Partitions.
- Developed Complex database objects as per business requirements like Stored Procedures, Functions, Packages, Materialized Views and Triggers using SQL and PL/SQL.
- Experienced in using, Dynamic SQL, Records, Varrays, Nested tables.
- Loaded Data into Oracle tables using SQL Loader.
- Extensively used bulk collection in PL/SQL objects for improving the performing.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Worked on OAF personalization and extensions.
- Designed interface logics and validations.
- Experienced in using tools like TOAD, SQL Developer, PL/SQL Developer, PuTTY, Oracle Workflow Builder, Ultraedit, etc.
- Experienced in using Kintana for Data Migration.
- Have also worked in an Oracle upgrade project (from R12.1.3 to R12.2.10).
- Remediated custom RICEW components as per Oracle R12.2.10 mandates.
- Developed codes in accordance with policies regarding secure coding & standards.
- Actively listened to customers' requests, confirming full understanding before addressing concerns.
- Responsible for all sorts of documentation (MD50, MD70) related to the project. Also documenting issues faced and resolution for support tickets for future references.
- Recognized for working at pace within challenging timescales to complete the design and development with the allocated timeline.
Education
Bachelor of Technology - Electrical Engineering
Techno India, Saltlake
Kolkata 01.2015 - 04.2019
General Science -
The Assembly Of God Church School
Kolkata 01.2013 - 04.2015
Skills
Oracle EBS Techno-Functional
BI Publisher - Reports & Analytics
Oracle Cloud Technical
Interests
Timeline
Oracle Cloud Technical Consultant
IBM
11.2022 - Current
Oracle EBS Techno-Functional Consultant
Tata Consultancy Services (TCS)
06.2019 - 11.2022
Bachelor of Technology - Electrical Engineering
Techno India, Saltlake
01.2015 - 04.2019
General Science -
The Assembly Of God Church School
01.2013 - 04.2015