Muhammad Yasir Email and Phone Number
I am result focused full life cycle Techno Consultant with personal experience and expertise of Technology Industry specifically in Oracle's Realm. A dedicated and ethically aligned professional, who aims to shine in IT world. Commitment to client service and proficient technical handling is his forte, proven track record of successful implementation of HRMS, payroll, production, billing and inventory control module in 10g. Proven ability to self-manage multiple posts by multitasking to the utmost extent through identifying, developing, maintaining and modifying Oracle procedures. • 12+ years of experience in Information Technology as Oracle Technical Consultant and knowledge in Systems Analysis and Design, Development and Documentation at various levels.• Performed Oracle 6i/10g/11g to OAF & ADF software Development.• PL/SQL Programming, Database Triggers, Stored Procedures, Functions, Views & SequencesDiverse experience in Oracle world strengthened him to delimit his own expertise and keep on exploring and understanding a wide range of applications and automation solution to find suitable keys for successful implementation of high-tech solutions in the company.Technical Skills (ORACLE)-------------------------------1. SQL, PL/SQL 2. OA Framework (OAF)3. Oracle ADF4. Oracle Workflow (WF)5. Oracle Form (6i/10g/11g/12c)6. Oracle Reports (rdf, rtf)7. Query Tuning, Query Optimization8. BI Publisher9. Oracle Apex10. JDeveloper11. Custom Application Development (10g, 11g, 12c, OAF, ADF)12. AlertsFunctional Skills (EBS)-------------------------------1. SCM2. Financial 3. HRMSOracle Fusion Cloud - Technical-------------------------------1. BIP Report2. Oracle Transactional Business Intelligence (OTBI)3. FBDI Process4. REST API / Web Services (SOAP)5. OIC Integration + VBCS6. HCM (Inbound) Data Loader7. ADFdi8. Spreadsheet / Meta Data LoaderOracle Fusion Cloud - Functional-------------------------------Oracle Fusion HCM 1. Core HR2. Payroll3. Absence Management4. Profile, Goal and Performance Management, Talent Management5. Fast FormulaWeb Skills-------------------------------1. HTML2. CSS3. Java Script4. JQuery
Kinonah It Consulting Services
View- Website:
- kinonah.com
- Employees:
- 9
-
Sr. Oracle Techno Consultant | Government ClientKinonah It Consulting Services Mar 2023 - PresentRiyadh, Saudi ArabiaGathering & 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.
-
Oracle Technical ConsultantAlfalak Electronic Equipment & Supplies Co. May 2016 - Mar 2023Dammam, 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 -
Oracle Apps Technical Consultant | Government ClientInbox Business Technologies May 2014 - Apr 2016KarachiDevelop 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. -
Senior Oracle DeveloperMustaqim Dyeing & Printing Industries (Pvt.) Ltd. Aug 2011 - Apr 2014Pakistan, Karachi, S.I.T.E1. 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. -
Data EngineerAtco Laboratories Limited Dec 2007 - Nov 2010Karachi1. 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
Muhammad Yasir Education Details
-
Software Engineer -
Information Technology
Frequently Asked Questions about Muhammad Yasir
What company does Muhammad Yasir work for?
Muhammad Yasir works for Kinonah It Consulting Services
What is Muhammad Yasir's role at the current company?
Muhammad Yasir's current role is Oracle Techno Consultant | OAF | Apex | PL/SQL | OTBI | BIP | (HTML, CSS, JavaScript).
What schools did Muhammad Yasir attend?
Muhammad Yasir attended Bahria University, Virtual University.
Who are Muhammad Yasir's colleagues?
Muhammad Yasir's colleagues are Wael Fawzy, Abd Elmohsin Alhathal, Dima Al-Rafayia, Sultan Alasiri, Mamoun Al Shafie / T., Michelle Josephine, Osama Zaheer.
Not the Muhammad Yasir you were looking for?
-
Muhammad Yasir
Strategic Finance Leader | Delivering Financial Insights | Ex Deloitte & Ey | Digital Transformation | Esg EnthusiastRiyadh, Saudi Arabia -
-
Muhammad Yasir
Senior Electrical Engineer/Snr Design @ Al-Futtaim Engineering And Technologies |Dewa Approved |Sce—Ksa|Soe-Dubai | IoshRiyadh, Saudi Arabia -
Muhammad Yasir
Cisa | Cdpp | Pmp. Data Privacy, Digital Transformation & Grc Project Management ConsultantRiyadh, Saudi Arabia -
Muhammad Yasir
Head Hunting L Recruiting L Onboarding L Offboarding L Payroll Administration L Senior Human Resources Coordinator At Al Bawani ServicesRiyadh, Saudi Arabia
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial