Muhammad Sohail

Plot-33, Street-1, Sector-3, Haroon Bahria,

Navel Colony, Hub River Road, Karachi
Cell: (92) 0333-3981328
Email: sohail_baqali@yahoo.com

235 lakh
3 lakh

Objective:

To attain a suitable position in an esteemed organization where efficiently and optimally utilize my System Analyst, Software Development and Technical Consultant
skill for the fulfillment of organization objects. To nurture the constant desire to learn more and add to my skill for the advancement of the organization.

Career Snapshot:

I am I.T professional and I have over all 15 years I.T industry experience. I have worked in different organization on different positions with different responsibilities. I
have both sides Development and DBA experience. I started my career in 2006 as an Oracle Developer and DBA assistant.

Oracle R12 EBS Technical (HRMS,Financials, SCM) :

I have worked on Oracle Application Object Library and created Key Flex Fields, Descriptive Flex Fields, User profiles and Value sets. Developed customize reports
and forms. Customize database objects (Tables, Views, Function, Procedures, Packages and Sequences etc. and Knowledge of System Administrator
Responsibility.
Data Load through APIs, Web ADI and Data Loader and Work Flow. Knowledge of Oracle EBS Table structures and other objects.
Oracle Forms: Designed and developed interactive application using Template.fmb with advanced form features.
Oracle Reports/Self-Service Reports: Create, test and install various Oracle reports while mapping the business logic within the report itself or in stored
procedure/views. Attached the same with Self-Service / or Application itself.
SQL, PL/SQL, API: Interface Development coding PL/SQL program units. Using Oracle Apps APIs executable from Concurrent Programs, Forms and Reports.
Strong programming concepts, analytical skill & knowledge in Oracle database, SQL and PL SQL.

Technical Skills:
RDBMS: Oracle, Ms-Sql, My Sql
LANGUAGES: C#, Java, SQL, PL/SQL, T-SQL
DEVELOPMENT SUITES: Oracle Form, Report, Apex, Discoverer and JDeveloper for OAF and Visual Studio
Web Technologies: Asp.Net, MVC, ORM and JavaScript, JQuery , Ajex , CSS 3.0, HTML 5, Web Services
TOOLS: Toad, PL/SQL Developer, SQL Developer, Keep Tool (Hora)

WORK EXPERIENC:

Sybrid Pvt (Lakson Group) 01-Apr-2021 To Present

 Working as a “Senior Database Engineer” in Sybrid.

 Working on Oracle 11g, 18c and SQL, PL/SQL, Oracle BI and Ms-Sql , T-Sql.
 Managing Oracle , Ms-SQL and My Sql Databases.
 Working on Packages, Store Procedures, Functions, Triggers, jobs and etc…
 Designing database, schemas, tables, integrity constraints, indexes and normalizing, deformalizing.
 Optimizing queries and back-end processes.
 Migration data from legacy system/Ms Sql from Oracle.
 Performing DBA task. Backup, restoring, replication, import, export and etc…
  Preparing, Maintaining and Monitoring Production and UAT servers.

Sapphire Consulting 01-Jan-2020 To 31-Mar-2021

 Worked as a “Senior Technical Consultant” in Sapphire Consulting.

 Worked on SQL, PL/SQL, Apex, Form and Report, OAF and RICE.
 Worked on Oracle EBS R12, SCM and HRMS Modules.
 Supported different clients during implementation and after go live.

SilverlakeSymmetri (Previously SunGard) 14-Apr-2014 To 30-Nov-2019

 Worked as a “Software Engineer” in Silverlake Symmetri(Pakistan Office).

 I have worked and supported Core Banking Symbols 8.5.
 Worked on difference Core Banking Modules.
 Developed and tested programs according to functional and/or technical specification, as a part of a team and on
individual capacity during full development cycle or as per individual user request from clients.
 Analyzed and tuned programs to meet optimum performance and operational efficiency.
 Reviewed gap/functional specifications and mapping the requirement to standard functionalities of the products.
Analyzed the potential scope and risk of the proposed business requirements and preparing appropriate documents as
need, including justifiable estimated change effort for elementary and fundamental requirements.
 Troubleshoot and corrected software defects during development, implementation and maintenance.
 Referred unresolved problems to senior team members for technical and functional guidance.
 Provided technical and application support to clients and other internal groups.
 Assisted the bank in migrated their legacy data to ensure adherence to existing strategy.
 Assisted in any ad-hoc project tasks as assigned and necessary.
 Executed technical and functional tasks with minimum supervision from senior team members.
 Worked on APIs, Form, Report 10g/11g, Sql, Pl/Sql, .
 Supported (QA Testing, CRs, SIRs analysis/fixes) all three large banks, MCB, UBL, FBL in Pakistan.
 Troubleshoot day to day and critical issues

PROJECTS

MCB/NIB Merger
NIB branches were merged into MCB. Where data migrated from one system to our Symbols system and also new financial screens were developed
according to business requirement.

Internal / Islamic Development

We were adding Islamic functionality in existing system and changing terminologies

Supported RB/BT Modules

Work on RB/BT modules. Modified and add new functionality in Safe Deposit Box (Locker). Work on new CRs and also fixed different bugs.

BCI SERVICES(Pvt) Ltd. 07-Jun-2013 To 07-Apr-2014

DeputedIn FBL Bank

 Worked as a “System Analyst &Senior Software Developer”inFBL Bank through BCI Services.
 I worked on Oracle R12 E-Business Suite. Created different kinds of reports and attaché in EBS.
 Worked on customization, create forms, form functions, menu, request, data groups and responsibility.
 I worked on iMal Islamic and Core Banking ERP Symbols 8.5.
 Coordinating the activities of functional and technical analysts during all phases of a system development project.
 Worked on Symbols APIs.
 Coordinated the activities of functional and technical analysts during all phases of a system development project.
 Design various kinds of reports and finical screens in “Third Party Module” as per business requirement using Oracle
11g.
 I worked on Oracle 11g Form, Report and Discoverer and Database.

Clarus Consulting(Pvt) Ltd. 01-Jul-2011 To 06-Jun-2013

DeputedIn FBL Bank 27-Mar-2012 to 06-Jun-2013

 Worked as a “Senior Software Engineer”inFBL Bank through Clarus Consulting.

 Worked on user security, create users and assign specific form function using record groups and responsibility.
 Create different oracle reports and attaché these reports using new define executable and concurrent program in Oracle
EBS.
 Conducted and facilitated project activities related to requirements, scope, schedule, resources, communications, time
estimation, risk and development of business requirements.
 Coordinated the activities of functional and technical analysts during all phases of a system development project.
 Working with all aspects of in-house developed system.
  I worked on Core Banking ERP (Symbol 8.5) System.
 I worked on Oracle 11g Form, Reportand Discoverer, BI.
 Monitoring and creating back-end Process.
 Design various kinds of reports and finical screens as per business requirement using Oracle 11g.
 Integration to Oracle Siebel and iMal.
 Worked on Symbol APIs.

Deputed In UBL Bank 01-Jul-2011to 26-Mar-2012

 Worked as a “Software Engineer”inUBL Bank through Clarus Consulting.

 Worked on Core Banking Symbol 8.3 System.
 Worked on Oracle 10g Database and 10g Developer Suite.
 Query Optimization, Alter Execution Plan, Use different Hints.
 Identified Full Table Scan, Query Cost and use Indexes.
 Create and modify existing Packages, Procedures, Functions and Triggers.
 Read Data from oracle table or oracle form to excel or text file and from excel or
text to table or form.
 Creating Fact, Dimensional and Partition Tables.
 Creating different operation reports in oracle 10g.
 Create different screens according to business requirement in oracle 10g.
 UsedWebUtil Object for Client and Server side machines.

PROJECTS

Integration
I was work on integrations. We integrated different systems with Core Banking (Symbol 8.5). We had integrated synchronized different transactions
(like Clients, Accounts Opening and Transaction Incoming, Outgoing) to Core Banking System.

Third Party Module

Create Financial and Non-Financial Screens and Reports in this module. Develop on Oracle 11g Forms, Report and use SQL, PL/SQL.

S.M Denim Textile 02-Jan-2011 To 30-Jun-2011

 Worked as a“System Developer”.

 Handled PL/SQL Compile Time, Run Time Error.
 Both Technical and Functional support to users.
 Worked on Oracle Apex.
 Oracle Forms: Designed and developed interactive application using Template.fmb with advanced form features
 Oracle Reports:Create, test and install various Oracle reports while mapping the business logic within the report itself
or in stored procedure/views. Attached the same with Self-Service / or Application itself.

Al-Hamd International Container Terminal (Pvt) Ltd. 16-Feb-2010To 01-Jan-2011

 Worked as “Software Engineer”.

 Supervised, developed new applications and maintain various application/software.
 Ensure that applications meet Business Requirement, fulfill end-user requirement.
 Installation Oracle 6i, 9i, 10g, DatabaseCreation & configuration of init.ora parameter file.
 Performed Logical Backup (Import/Export).
 Responsible for establishing client and database server access through NET8 using
Tnsnames, Sqlnetand Listener.
 ManageDesign, Development, and Deployment of software and Provide Assistance to the users on issues.
 Business analyses and logical and physical database design.

Universal Shipping Company (Pvt) Ltd. 08-Aug-2008To 15-Feb-2010

 Worked as “Oracle Programmer”.

 Worked on Microsoft .Net Frame Work.
 Developed new application Container Tracking. Container Tracking application
is using our different Agents in Dubai, Singapore and our different Yards.
 Developed HR Payroll System (employee details, allowances, loan, advances and working days)
 Supported existing ERP(TCL) in Universal Shipping Company. This ERP use for Booking Request,Booking
Confirmation, Loading Program, BL, Payments, Invoices etc…

Coastal Converters (Pvt) Ltd. 01-Oct-2006 To 06-Aug-2008

 Worked as “Oracle Programmer and DBA Assistant”.

 Create and Manage all Database objects, including tables, indexes, views, sequences, functions, procedures and
packages.
 Create and maintains database constraints to ensure integrity of the database.
 Implement and maintain database security (create and maintain users and roles(assign privileges)
 Manage database storage structure.
  Performed Backup & Recovery and support senior DBA.
 Developed Inventory and Gate Pass Modules.
 Developed Purchasing and Sales Modules.
 General Ledger Module.

PROJECTS EXPERTISE :

As I have gone through different organizations and groups’ ERPs and culture I have worked, support and designed several
software modules.

 Inventory System(Factory Store Information, GRN, MIN, Positive & Negative Adjustment)
 Time Management System
 Raw Material Consumption System
 Production Information System
 D.C Information System
 Gate Pass & Weight Bridge Information
 Purchasing System
 Accounts Receivable
 Accounts Payable
 GL System
 Shipping
 Core Banking System

CERTIFICATION:

 Microsoft Certified (70-480) from Microsoft Corporation.

 Oracle 9i SQL Certified from Oracle Corporation.
 Oracle 9i Fundamental I Certified from Oracle Corporation.

PROFESSIONAL QUALIFICATION :

 Oracle 9i DBA from Orasoft Institute.

 Oracle 9i DS (Form, Report, SQL, PL/SQL) from Orasoft Institute.
 Oracle EB Suite R12 Technical, ADF and BI Training from Orabyte Institute.
 Visual Studio 2010, ASP.Net, Ajax, Silver Light,MySQL/SQL from AUC Technology (In Sir Syed University)
 Html5, Css3, JavaScript, JQuery (70-480)from AUC Technology (In Sir Syed University)
 Java,Jdbc Servlet, Jsp, Applet from Operation Badar.
 FoxPro for Window, Window, MS-Office Touheed Computer and Typing Center.
 FreeHand, Corel Draw, Illustrator, Inpage, Photo Shop from House of Multimedia and Computer Application.

ACADEMICS EDUCATIOIN:

B.Com From University of Karachi

H.S.C(Pre-Engineering) From Haji Abdullah Haroon College
S.S.C(Science) From Anglo Urdu Govt, BoysSecondary School.

PERSONAL PROFILE :

Date of Birth - 01-Jan-1980

Place of Birth - Karachi
Father’s Name - Muhammad Ibrahim
Domicile - Sindh
Nationality - Pakistani
Passport No. - CJ5195952
N.I.C. No. - 42401-1800595-9
Marital Status - Married
Contact No. - +92-333-3981328
Electronic Mail - sohail_baqali@yahoo.com
Postal Address - Plot-33, Street-1, Sector-3, Haroon Bahria
Naval Colony, Hub River Road Karachi, Pakistan.