Sohaib Ali

Excellent knowledge and experience in PL/SQL programming including design and development of packages, cursors, triggers, stored procedures, functions, triggers. Design and development of shell scripting UNIX. Python Development Machine learning. Design the python program to extract faces from live video using machine learning. Design shell scripts,procedures,functions to streamline the process functionality. Biometrics and finger prints data ,worked on it with different international clients,Designing RFP.

Excellent knowledge and experience in PL/SQL programming including design and development of packages, cursors, triggers, stored procedures, functions, triggers Proficient in creating Tables, Views, Database Triggers, Synonyms, Sequence Working knowledge of Exception Handling mechanism using User Defined Exceptions Having knowledge of SQL Optimization and Performance Tuning    Experience in writing Complex SQL Queries, Advanced SQL (Group by functions, Analytical functions, Co- Related query)

• Boosted the efficiency and performance of the current system by incorporating critical requirements with sustenance of the existing customization with oracle E-Business suite. • Developed and lead the custom OAF module which integrates with AP and AR modules. • Involved in designing, writing and executing PL/SQL Queries which strengthened and simplified the performance of system. • Standard reports development in BI Publisher and Report Builder.

• Developed new custom modules for the HRMS module integrated with Oracle EBS in OAF. • Achieved the performance boosting by Designing, writing and executing PL/SQL Queries for complex requirements of client in Defense. • Completed Creation, updating of SIT’S, EIT’s dynamically through PL/SQL. Achieved integration of custom OAF modules with standard HR module using standard API’s and Interface tables. • Design and development of new reports in BI Publisher and Report Builder.

Computer science, algorithm, programming, data analysis, data sutructute, Java,. net