Learn Data Skills
Beta
Muhammad Usman Shahid

Muhammad Usman Shahid

BI Developer

Datamatics Technologies

Technologies

My Portfolio Highlights

My New Course

Introduction to Power BI

My New Course

Introduction to Power BI

Data sensei, guiding others on the path of analytical enlightenment.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Data Visualization in Power BI

course

Introduction to DAX in Power BI

course

Introduction to Power BI

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Microsoft Power Bi Data Analyst

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Power BI
Introduction to DAX in Power BI
Introduction to Tableau
Data Visualization in Power BI

My Work Experience

Where I've interned and worked during my career.

Datamatics Technologies | Apr 2024 - Present

Business Intelligence Consultant

N/A

NorthBay Solutions | Dec 2021 - Apr 2024

Principle Software Engineer

N/A

Inovalon | Jan 2023 - Mar 2023

Northbay Consultant - Looker/Snowflake Developer

N/A

Jazz | Apr 2022 - Oct 2022

Northbay Consultant - Data Engineer

Principle Software Engineer Adhoc development on L2/L3 based requirements from the customer Migration of reports and jobs from appliance machine to production Automation, Development and Scheduling of Teradata Optimization of the developed segments and already existing solutions to save resources and provide better results Managed and owner of Incident, Request, Change, Release and Escalation processes.
Show More

If Insurance | Sep 2020 - Dec 2021

Teradata Professional Services Consultant

Customer Interaction Manager CIM L1/L2 Support Monitor Big Batch operations and resolution upon failure along with L2 support. Reporting (Weekly/Monthly) to provide insight on the systems performance with the client, other than that some insights on their business e.g., number of leads dispatched, number of new registrations, type of registrations etc. Create and maintain Incident sheets upon failure and share with customer on their Incident Management System as well as on TD. Automation of housekeeping scripts through Shell. Provided L2 support in absence of L2 onsite resource. Performed ad-hoc requests from the client on CIM related issues. Daily reporting of the big batch performance to the client Overlooking and performing pre and post migration activities of the Teradata System on upgrade.

If Insurance | Jun 2020 - Dec 2021

Teradata Professional Services Consultant

Database Administrator Teradata administration (Creation, update and deletion of database objects such as Views, Users, Roles and Profiles) Follow DBA guidelines and best practices implementation as committed in each Sprint Cycle Analyzing overall system performance metrics and provide optimization resolutions wherever required Created stored procedures to support the continued functioning of the Teradata data warehouse Space management: setup the purging policy, implementing compression techniques Performed BAR operations (offline & online backups, iterative & delta backups) Overlooking and performing pre and post migration activities of the Teradata System on upgrade. Performance optimization of the batches through SQL tuning Workload management, creation and modification of TASM Reporting (Weekly/Monthly) to provide insight on the systems performance with the client

LähiTapiola | Jan 2020 - Dec 2021

Teradata Professional Services Consultant

Professional Consultant Developed & designed solution where information modelling is done in the data warehouse and data is provided to the report developers in data marts. Developed different components of BI solution with an end-to-end perspective Design, implement and secure flows from fetching raw data to quality secured models for our reporting and analysis Contributed in the team (BI) for development of business solutions and processes Owned and developed the physical information model Acted as a bridge between BI and the data integration team Worked closely with business analysts and report developers Overlooking and performing pre and post migration activities of the Teradata System on upgrade. Used Microsoft BI (Power BI) as a frontend for our report’s consumers. Performed as support to change and incident management Performance optimization of the batches through SQL tuning to fit the batches in the agreed time window. Automation, Development and Scheduling of Teradata housekeeping scripts. Automated Space management scripts for effective utilization. Reporting (Weekly/Monthly) to provide insight on the systems performance with the client

Manitoba Liquor & Lotteries Corporation | Jun 2019 - Dec 2021

Teradata Professional Consultant

Professional Consultant Lead MBLL team in order to deliver excellent and desired delivery as agreed in the services. Ensure data ingestion activities from different sources into different layers on Teradata. Perform ETL jobs implementation, testing and ingestion flow management (Monitoring, technical data quality checks, scheduling). Developed data transformations involving data-type conversions, joins, filters, translations, aggregation, de-normalization of large sets of data Developed jobs for DWH (initial loads/delta loads /audit columns/staging tables) Reporting (Weekly/Monthly) to provide insight on the systems performance with the client Contributor in modernizing (re-build) of client data warehouse. Management and troubleshooting of existing solutions Automated jobs/scripts with Linux shell scripting Managed and owner of Incident, Request, Change, Release and Escalation processes. Provided technical knowledge for Teradata platforms & utilities. Overlooking and performing pre and post migration activities of the Teradata System on upgrade. Performance optimization through SQL tuning and physical design in order to provide value to customer Workload management, creation and modification of TASM rules.

Gjensidige | Jan 2019 - Dec 2021

Tearadata Professional Services Consultant

Professional Consultant Analyzing overall system performance metrics and provide optimization resolutions wherever required Analyzing batch runs and provide continuous improvements Follow DBA guidelines and best practices implementation as committed in each Sprint Cycle Perform deployment support & enforce learning from previous deployment to improve efficiency on next Sprint cycle Teradata administration (Creation, update and deletion of database objects such as Views, Users, Roles and Profiles) Created stored procedures to support the continued functioning of the Teradata data warehouse Overlooking and performing pre and post migration activities of the Teradata System on upgrade. Hands on experience with installing, maintaining, using all the Teradata tools (BTEQ, SQL Assistant, TPUMP, TD Administrator, ODBC, MLOAD, Fast load, etc.) Reporting (Weekly/Monthly) to provide insight on the systems performance with the client Experience in Space management: setup the purging policy, implementing compression techniques Performed BAR operations (offline & online backups, iterative & delta backups)

AWT | Dec 2017 - Nov 2018

MIS Officer

Developing Software Solutions for Army Welfare Trust which meet the provided user requirements. This includes working on new solutions as well as amending existing projects to suit the user requirements. Devise better algorithms for already working solutions as well as implementing new features. Discussing and Designing solutions for current problems. Maintaining all assigned software, both new and old.

Interactive Group Of Companies | Apr 2016 - Dec 2017

Configuration Engineer (Websphere Application Server)

Key Responsibilities: -Installation and Configuration of WebSphere Application Server 7 and 8.5.5 (Linux & Windows) -Local and Live servers deployments - Application configuration, service, support and troubleshooting on Local and Live Servers . -Performance Monitoring and tuning -Technical Documentation - Release Management - Patch preparation and deployment on production servers - DB syncing. - Data Base Migrations - Server management through VSphere Client and VMWare Workstation 10

Interactive Group Of Companies | Sep 2015 - Mar 2016

Assistant Engineer

Key Responsibilites -Network Monitoring System, escalation and troubleshooting of various events/ tickets. -NOC team, troubleshooting of network and system related issue within the company. -Support team , providing support assistance to the company employees -Installation and configuration of Basic Software’s & Correlate problems by monitoring tickets.

My Education

Take a look at my formal education

Software Engineering in Software EngineeringUET Taxilla | 2016

About Me

Muhammad Usman Shahid

I'm a seasoned BI/ETL professional with a track record of success across diverse industries. My expertise lies in optimizing BI solutions and ETL workflows

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free