概要

Career Objective: 
To work as a Software Engineer, Data Analyst, BI Developer in a challenging environment where I can use my skills to deliver value added results by achieving the set objectives.

Career Summary:
• Business Analyst with the experience of Data Warehousing and Data Modeling using MySQL, MS Sql, Oracle Sql , Python & R.

• Create effective Dashboards using different BI Tools (Power BI, Tableau & Oracle Application Express).
• Data Filtration & Cleansing using different ETL Tools (Excel, Power Pivot ,Power Query, Sql).
• Having previously Database/ ERP experience will leads me to understand the business requirement in a mannered & systematic way.
• Applied Data Authorization/ Authentication (Security) to manage the Data Hierarchy.
•Working in a software house (consultancy)/ Organization as  Oracle E-Business Suite developer for last 2 year using Oracle Technologies.
• Worked on Various modules of Oracle Enterprise Resource Planning (Payable, Receivables, Inventory, and Human Resource Management).
• Concept of BI, Data Analysis, Data Modeling ,Dashboard creation, Dashboard Maintenance, Product Customization, Data Reconsideration, Reports Creation, Drill down Reports, Parameter Reports, Work flows, Alerts, Bursting Alerts, Data Management and SDLC.
• Working experience on Oracle APEX 5.1.
• Perform task according to the requirement of Client.
• Experienced the environment of Textile, distribution and manufacturing companies.
• Completed Bachelors In Studies In Computer Science From University Of Karachi.
• Enthusiastic about working on Data Sciences, BIG Data, Business Intelligence.


Career Objective: 
To work as a Software Engineer, Data Analyst, BI Developer in a challenging environment where I can use my skills to deliver value added results by achieving the set objectives.

Career Summary:
• Business Analyst with the experience of Data Warehousing and Data Modeling using MySQL, MS Sql, Oracle Sql , Python & R.

• Create effective Dashboards using different BI Tools (Power BI, Tableau & Oracle Application Express).
• Data Filtration & Cleansing using different ETL Tools (Excel, Power Pivot ,Power Query, Sql).
• Having previously Database/ ERP experience will leads me to understand the business requirement in a mannered & systematic way.
• Applied Data Authorization/ Authentication (Security) to manage the Data Hierarchy.
•Working in a software house (consultancy)/ Organization as  Oracle E-Business Suite developer for last 2 year using Oracle Technologies.
• Worked on Various modules of Oracle Enterprise Resource Planning (Payable, Receivables, Inventory, and Human Resource Management).
• Concept of BI, Data Analysis, Data Modeling ,Dashboard creation, Dashboard Maintenance, Product Customization, Data Reconsideration, Reports Creation, Drill down Reports, Parameter Reports, Work flows, Alerts, Bursting Alerts, Data Management and SDLC.
• Working experience on Oracle APEX 5.1.
• Perform task according to the requirement of Client.
• Experienced the environment of Textile, distribution and manufacturing companies.
• Completed Bachelors In Studies In Computer Science From University Of Karachi.
• Enthusiastic about working on Data Sciences, BIG Data, Business Intelligence.

工作经历

公司标识
Data Analyst
Love For Data
Sep 2019 - 代表 | Karachi, Pakistan

1- Gathered requirements from user and created analytic solutions Dashboards using Power BI (Microsoft Tool) based on the design.
2- Modeled data in support of ETL processing and reporting systems using advanced SQL, MySQL, MSSql concepts to implement complex ETL logic.
3- Performed Pre and post implementation testing of dashboard.
4- Created stored procedures, views, and triggers and constrains to implement the database consistency and integrity including primary key, foreign key for Data Warehousing.
5- Creation of Views, Materialized views, Aggregate functions, Tables and Query, Sub query, functions under SELECT.
6- Presented weekly and monthly data analysis and statistics using MS Excel, Power Pivot & Power Query and TOAD.
7- Experience of working as a Database Developer on Oracle ERP/EBS system previously to get the knowledge of Normalized ERP Standard System.
8- Design and customization of dashboard containing parameterized reports, Cross-tab reports, Drill down reports and Summarized reports, Bar charts and matrix reports using Oracle APEX tool, Microsoft Power BI, Tableau based on business requirement.

公司标识
Software Engineer
Shirazi Trading Company (Pvt) Ltd
Nov 2017 - Aug 2019 | Karachi, Pakistan

Appointed as a Software Engineer at Shirazi Trading Company (Private) Limited (STC) (An Atlas Group Company). Core responsibilities are :

1-Prepare new Reports using Oracle Tools.
2- Working on Oracle Core HRMS , SCM, OM, AR, AP module (Technical).
3. Development of new modules using Oracle Forms.
4- XML reports.
5- Oracle Alerts Development.
6- XML Bursting Reports.
7- Forms Personalization.
8- End to end forms and Reports Submission on Oracle E-Business Suite using TOAD, WINSCP.
9- Hands on working on Oracle APEX 5.1.
10- Maintain data management on TIS (Time Information System).
11- Form Customization.
12- Control User management using System Administrator Responsibility of Oracle E-Business Suite.
13- Data management along with functional issues.
14- End to end Process of SDLC.

公司标识
Oracle EBS Developer
Naveena Exports Pvt Ltd
Apr 2017 - Nov 2017 | Karachi, Pakistan

Appointed as an Oracle EBS Developer. Task was to create new reports according to the user Requirement, Changes in the implemented system, Defining/ opening of new Items in inventory.
RESPONSIBILITIES:
✓ Responsible for Oracle form developing.

✓ Oracle reports building.

✓ Create and Developed functions, packages, procedures using plsql.

✓ Working on Oracle alerts.

✓ Create XML reports using BI Publisher

✓ Changes in existing Forms/Reports on Order Management and Inventory Modules of EBS

✓ Managing Barcode and HRMS customized modules

公司标识
Oracle EBS consultant
Burque Corporation (Pvt.) Ltd.
Oct 2016 - Feb 2017 | Karachi, Pakistan

CLIENT OF SB-INFO TECH
It was my first experience in the field of Database As Oracle EBS developer.
Here i worked at Inventory, Vehicle Management System (Customized) and developed Reports using Oracle Report Builder 10g, Create custom LOVs, parameters, triggers . Also Create XML reports using BI publisher add-inn facilities. Registered reports successfully on user end on their responsibilities.

公司标识
Oracle EBS Consultant
M.N Textile
Feb 2016 - Sep 2016 | Karachi, Pakistan

M.N textile is a Textile company (Client Of SB-Info Technologies) located in Landhi, Karachi. Here i worked at AR (Account Receivable), Inventory, AP (Accounts PAyables) and developed arount 25+ Reports using Oracle Report Builder 10g . Also Create XML reports using BI publisher add-inn facilities. Registered reports successfully on user end on their responsibilities.

公司标识
IT Internee
Atlas battery limited
Jun 2015 - Jul 2015 | Karachi, Pakistan

A part of ATLAS group which manufactures battery for cars, bikes, UPS etc. I did 5 Weeks INTERNSHIP as an ORACLE developer on ORACLE EBS OR as a support Engineer.

学历

University of Karachi
学士, 商学士/理学士, BS‎
Computer Science, Database Management System
CGPA 2.6/4
2017
SB-Info Technologies
短课程, Oracle Develope‎
Database System
Completed
2015
Tech-Valley Institue
短课程, PHP Developer‎
Web Design
Completed
2014

技能

中级 Big Data Analysis
中级 Business Analytics
中级 Data Warehousing
中级 Enterprise Resource Planning
中级 Handling Assignments
初学者 Microsoft BI SSIS
中级 MS SQL
初学者 Oracle Apex
初学者 Oracle E-Business Suite
初学者 Oracle PL SQL Development
初学者 PL and SQL
初学者 Power BI
初学者 Tableau

语言

熟练 乌尔都语
中级 英语

Mohammad 联系人