Samir Ali - Software Engineer - Tata Consultancy Services Limited

Summary

Oracle System Engineer with 4+ years of experience in Oracle EBS development, data analytics, and CI/CD automation. Proven expertise in designing and enhancing applications for supply chain management and finance. Demonstrated ability to optimize system efficiency through PL/SQL development, report creation, and Oracle ADF integration with middleware such as SOA.

Overview

4

years of professional experience

4

Certifications

Work History

System Engineer

Tata Consultancy Services Limited

02.2022 - Current

Designed, developed, and enhanced Oracle packages, procedures, and functions based on MD60 functional documents for various regions and interfaces (e.g., OTM service shop).
Enhanced system efficiency by developing comprehensive data analytics solutions and streamlining SQL query performance according to client specifications.
Oversaw complete code lifecycle utilizing CI/CD pipeline, generating feature branches in GitHub and deploying code to development instances through Jenkins.
Constructed new reports and optimized existing ones utilizing Oracle Report Builder (RDF RTF) and BI Publisher, developing data models and collaborating with POS for unit testing.
Executed comprehensive unit testing through development of backend SQL scripts and utilization of Postman for API payload verification, ensuring data accuracy and process integrity.
Tailored Oracle applications R11i/R12 interfaces and engineered concurrent programs with custom parameter sets to automate backend processes.
Guaranteed data accuracy through validation and reconciliation of source and target tables following business transformations.
Coordinated with product owners and stakeholders by developing technical design documents (md70) and delivering regular updates on development progress and execution results.

Education

Bachelor of Technology - COMPUTER SCIENCE AND ENGINEERING

INSTITUTE OF ENGINEERING AND MANAGEMENT

KOLKATA

07.2020

Skills

Programming Languages: PL/SQL, Oracle SQL, Oracle APEX

Databases: Oracle Database (19c, 12c, 11i, 10i), MySQL

Oracle Development: Oracle Packages, Procedures, Functions, Oracle Reports (RDF, RTF), Concurrent Programs, Value Sets, Oracle Applications (R12, 11i)

BI & Reporting Tools: BI Publisher, OTBI, Report Builder

DevOps & Tools: Jenkins, GitHub, PL/SQL Developer, SQL, OTM, Putty, J developer, Oracle APEX

Technologies: Oracle Cloud Infrastructure Generative AI Professional, Oracle Database PL/SQL Developer Certified Professional Certification

Functional Domains: O2C Cycle, P2P Process, Order Management, Inventory Management, Supply Chain, Services Management

Certification

Certification: AWS Certified Cloud Practitioner

Timeline

System Engineer

Tata Consultancy Services Limited

02.2022 - Current

Bachelor of Technology - COMPUTER SCIENCE AND ENGINEERING

INSTITUTE OF ENGINEERING AND MANAGEMENT