خلاصہ

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
ستمبر ۲۰۱۹ - موجودہ | 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
نومبر ۲۰۱۷ - اگست ۲۰۱۹ | 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
اپریل ۲۰۱۷ - نومبر ۲۰۱۷ | 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.
اکتوبر ۲۰۱٦ - فروری ۲۰۱۷ | 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
فروری ۲۰۱٦ - ستمبر ۲۰۱٦ | 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
جون ۲۰۱۵ - جولائی ۲۰۱۵ | 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
مکمل
2015
Tech-Valley Institue
مختصر کورس, PHP Developer‎
Web Design
مکمل
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 آپکے جاننے والے