Muhammad Yasir Email & Phone Number

Riyadh, Saudi Arabia

Gathering & Analysis, System Design & Development, Testing, and Implementation.Provided APEX guidance and support to technical staff on application maintenance and SDLC process.Determines operational feasibility by evaluating analysis, problem definition, requirements, solution development, and proposed solutions.Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments, and clear code.Functional documentation to support the development and QA processes while driving Contact Routing solutions with the stakeholders.Design and Code reviews and providing input to the design recommendationsDesign and development of Data Conversion, Extension, Packages, Procedures, Views, Triggers, APIs, Packages, and Oracle Application Framework (OAF).Effectively made use of Pipelined Table Functions, Table Functions, Indexes, Table Partitioning, Collections, Dynamic SQL, Analytical Functions, Materialized Views, Query Re-Write, and Transportable table space.Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes.Performance Tuning for Oracle RDBMS using Explain Plan and Hints.Performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.Development of Customized RICEW(Reports, Interface, Conversion, Form Extensions, Workflows).Development of Integrations/Interfaces to Integrate 3rd party data sources.ETL procedures, ETL tools, and large amounts of data.EBS Custom.Pll to call custom Report and Form from MenuOracle Integration Cloud OIC (PaaS)OIC Built AdaptersREST Adapter properties definitionSOAP Adapter Properties definitionDefining and Configuring ConnectionsData Mapping and LookupsDevelop BIP and OTBI Reports into Oracle Cloud (SaaS)How to create data loading thru FBDI process with the help of OIC integration.

Dammam, Eastern, Saudi Arabia

• Gathering & Analysis, System Design, Development, Testing, and Implementation• Involving in the full development Cycle of Planning, analysis, design, development, testing, and implementation• Effectively use Table Function, Indexes, Table Partitioning, Collections, Analytical Function, Materialized Views, Query Re-Write and Transportable table space• Good knowledge on logical and physical Data Modeling using Normalizing Technique• Developed complex database object like Stored Procedure, Function, Packages and Triggers using SQL and PLSQL• Experience in Oracle Supplied Packages, Dynamic SQL, Records and PLSQL Tables• Expertise Collections and Exception handling• Create Packages and Procedure to automatically drop table indexes and create indexes for the tables• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and Hints• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.• Experienced with the design and development of Interface, Data Conversion, Extension, View, Triggers, API’s, Packages• Oracle 9i’s database management capabilities enable secure and efficient storage and retrieval of vast amounts of policyholder data. By utilizing PL/SQL programming, automate workflows, such as premium calculations, policy renewals, and claims evaluations, enhancing both accuracy and speed.• Personalization and Controller Extension.• Data loading through API’s.• OAF – MVC: • EO, AO, VO, AM, VL, Pop list VO, LOV VO & AM, LOV Region, Page & CO. • BC4J , UIX , AOL , MDS

Karachi

Develop form on OAF (J2EE) Java (scratch or Extension).Use Oracle standard API's for data loading in Oracle EBS. Personalization of Oracle EBS Standard page.Develop also Applet base forms on 10g/reports (10g). Develop Oracle Forms, Reports on XML, BI Publisher. Developed the PL/SQL codes on the basis of the requests for the change.Dynamic LOV, Programmatically Record Group handlingModified, maintained and developed the SQL codes to develop new enhancements.Personalized forms to fit the business needs.Triggers, Function, Packages, Stored Procedures, Views, Sequences etc.Developing PL/SQL procedures, packages, triggers, functionsDeveloped and performed the quality assurance activities and unit testing.Modified and maintained the oracle procedure.Develop web ADI for Data Integration.Good understanding of SDLC, R and D of new areas.Working on oracle standard workflow and design custom workflow.

Pakistan, Karachi, S.I.T.E

1. Good working expertise in all the stages of software development life cycle implementation (SDLC). 2. Analyzed the business process and collected the test cases. Executed the test cases as per the schedule. 3. Developed the PL/SQL codes on the basis of the requests for the change. 4. Modified, maintained and developed the SQL codes to develop new enhancements. 5. Developing PL/SQL procedures, packages, triggers, functions.6. Developed and performed the quality assurance activities and unit testing. 7. Modified and maintained the oracle procedure.8. Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting. 9. Strong knowledge of how the pieces of a program fit together for the purpose of meeting the requirements of the application. 10. Strong knowledge of programming (i.e. program design, flowcharting, coding, testing, debugging). 11. High level of PL/SQL programming.12. Dynamic LOV, Programmatically Record Group handling Triggers, Stored Procedures, Views, Sequences etc. 13. Designed highly complicated Reports using all important typical features Of Reports 2.5 like Placeholder & Formula columns, conditional Report Layouts, Group filters etc. 14. Define Workflow as per conditions.

Karachi

1. Managing master data, including creation, updates, and deletion.2. Commissioning and decommissioning of data sets.3. Managing and designing the reporting environment, including data sources, security, and metadata.4. Supporting data integrity and normalization.5. Helping develop reports and analysis.6. Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems7. Work with management to prioritize business and information needs8. Locate and define new process improvement opportunities9. Good skills in SQL and PL SQL.10. Working on Sales Analysis System (SAS) Oracle base Application.11. To maintain all secondary sales data received from distributors and generate respective reports through Sales Analysis System (SAS) program (Oracle).12. To generate and submit secondary sales of all teams on weekly basis.13. To keep follow-up with all distributors regarding secondary sales.14. Providing secondary sales statistic feedback to all BUH and Dir Marketing.15. To maintain and update statistic of territory wise and product wise sales (Oracle).16. Providing sale data through iSQL* Plus which are not available in the system.17. Maintain the territory of S.P.O in the Sales Analysis System (Oracle).18. Use graphs, info graphics and other methods to visualize data19. Establish KPIs to measure the effectiveness of business decisions20. Structure large data sets to find usable information

Ms, Software Engineer

Bs (I.T), Information Technology