Experience as System Analyst / Programmer

• Employer

  Karachi Port Trust

• From

  01 August 2002

• To

  31 August 2008

• Detail

  Functioned as Project Coordinator, Team Lead and Team Member) for developing various business applications of Karachi Port Trust aimed at ship cargo discharging, loading, clearance and other allied shipping port activities
  Worked on tools like Erwin, SQL Developer, Pl/SQL Developer, Oracle Forms, Oracle Reports and Visual Source Safe
  
  Applications developed in the capacity of a System Analyst / Team Leader (9 Applications)
  Pension Gratuity Advances & Loans Dual Duty Refund and Sanction
  IGM EGM Cargo Clearance Application ePAS (Electronic Port Access System an EDI) ETA(Electronic Time of Arrival an EDI)
  Tools used to design these applications included Star UML, Erwin, SQL Developer, Pl/SQL Developer, APEX, Oracle Forms, Oracle Reports and Visual Source Safe.
  
  Applications developed in the capacity of a Team Member (10 Applications)
  Wharfage Billing Financial Budget Contract Agreements Application Plan & Estimates Application Tender Information Module
  Port Activity sTravel Authorization Law cases Refund, Payments to third parties Payment to employees and
  
  

Experience as Senior Software Engineer

• Employer

  emaratech

• From

  01 April 2012

• To

  31 March 2015

• Detail

  Performed ETL activities like complex mapped using connected/unconnected lookup, aggregate and Router transformations for populating target table, scheduled tasks, Work Flows and Batch processes, etc
  Analyzed Business Requirements and translated them into Technical Design Document for (fawri / eform / ednrd) front ends
  Addressed application performance and locking issues for ETL, Replication, Scheduled Jobs and front ends (fawri / eform / ednrd)
  Coached (fawri / eform / ednrd / ETL) teams on technical issues like LDAP implementation, distributed transaction processing. Messaging and best practice guidelines)
  Implementing Technical Frameworks aimed at reducing CTC and enhancing business performance
  Performed numerous impact analyses.
  Resolving Critical Issues by analyzing trace files/TKPROF, using DBMS_PROFILER for Procedures / Functions, query AUTOTRACE and EXPLAIN PLANS FOR statements to tune queries, used ASH reports for resolving latch contention (lock) issues, AWR for improving application health, resolving IN-DOUBT distributed transactions etc.
  Developed reports for Visio Project using IBM Cognos Report Studio. These IBM Congnos reports contained report features like filters, drill through functionality, advanced prompting, master details, multiple queries and graphing.
  Created Tranformer Models using IBM Cognos Tranformer and published cubes later to be used in Analysis of “Vision Border Control” and Vision Black List” projects
  Used Informatica, IBM Datastage for ETL solutions like visa /residence status sharing, sharing MOL data to front ends and establishment profile data. Also developed BI Dashboards using COGNOS. Also coordinated and managed EDI and data centers.
  

Experience as Scrum Master

• Employer

  emaratech

• From

  01 April 2015

• To

  30 January 2020

• Detail

  Gathered requirements, planned, managed and resolved issues for 3 projects.
  Involved in Sprint Planning, Conflict Resolution, Agile Project Management, Coaching, Team Activities, Sprint Reviews, Sprint Ceremonies, Sprint Standup, shielding the team, Forecasting and remove impediments etc. for 5 Scrum Teams.
  Improved Application and Performance of 5 Scrum Teams by using tools like “BPG”, “Kaizen” ,“Story effort calculator”, etc.
  Coached 3 “eChannel” teams for SCRUM practices and aided them with application tuning and deadlock conflict resolution methods.
  For all 3 “eChannels” Created detailed project road maps, plans, schedules and work breakdown structures, implemented artefacts to ensure on-time Project in compliance to project timeline and quality of deliverables, helped application Support Team with business mapping to the technical components.
  Developed artifacts to measure and better utilization / improvement of resources such as Technical Time Estimations, Code Reviews, Technical Designs and BPG .
  For eChannels whenever required coached coding, code reviews, TD writing, System Analysis, Application Tuning, ETL Mapping and Migration.