Muhammad Adeel Shakir Adeel Shakir

Big Data Consultant at BCM Tech

• Saudi Arabia - Riyadh
• My current job since February 2023

Senior Data Engineer at Careem

• Pakistan - Lahore
• August 2022 to February 2023

Big Data Engineer at Munchon

• Pakistan - Lahore
• October 2021 to July 2022

Principal BI Engineer at Munchon

• Pakistan - Lahore
• January 2020 to September 2021

Data Analyst at Lunch:ON

• Pakistan - Lahore
• January 2019 to December 2019

Senior BI Developer at Soloinsight

• Pakistan - Lahore
• December 2017 to November 2018

Software Engineer at Modemetric

• Pakistan - Lahore
• September 2016 to December 2017

 Conducting business requirement analysis, data modeling and development. Interacting with clients and compiling requirement specifications from clients. Leading project teams, resolving T-SQL query performance issues by checking execution plan and rewriting query or adding missing indexes
 Utilizing T-SQL to pull data from various databases and creating various dashboards, scorecards and reports to support business decision making processes. Handling SQL queries, generating ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using LANTERN BI Suite. Applying various data transformations like merge, aggregate, sort, multicasting, conditional split and derived column
 Extracting data from SQL Server and Oracle tables into flat data files and Excel sheets. Creating database tables with various data types, constraints (primary key, foreign key, unique, check, default, etc.) and indexes (clustered index and non-clustered index) in Oracle DB & SQL Server.

Oracle Developer at Millat Equipment Limited

• Pakistan - Lahore
• October 2015 to September 2016

 Supported, maintained and developed customized ERP. Assisted in design of tables, databases, forms, procedures, functions and reports; connected forms and reports with Oracle ERP Applications
 Developed applications through Oracle using SQL, Pl/SQL. Updated company website and developed new reports and forms using oracle fusion Middleware 11g

Web Developer at Genuie Enterprises

• Pakistan - Lahore
• March 2014 to October 2015

Build and manipulate WordPress websites.
 Edit and repurpose WordPress plugins in accordance to customer’s needs.
 Perform quality assurance tests on all web projects.
 Perform activities to optimize websites for search engine optimization.