Muhammad Khan

Senior Developer

Highly skilled Senior Developer/Data Analyst with over 20 years of experience in software development, data analysis, and database management. Proficient in utilizing tools such as Visual Studio, .Net Core, C#, and various design patterns like ASP.NET MVC. Strong expertise in web-based page and site designs using Angular, AngularJS, TypeScript, and Bootstrap. Extensive experience in SQL Server, including writing stored procedures, triggers, functions, views, and database design. Proven track record of creating and maintaining SSIS packages and utilizing SSRS and PowerBi for reporting. Committed to delivering efficient, maintainable code and driving improvements in project performance. Seeking challenging opportunities to leverage technical skills and contribute to the success of a dynamic organization. Contact

Address

Windsor, ON, N9B3V6

Phone

248-***-****

E-mail

adydmm@r.postjobfree.com

LinkedIn

www.linkedin.com/in/mak74

GitHub

https://github.com/mukhan

169/

Skills

SSIS (SQL Server

Integration Services)

SSRS (SQL Server

Reporting Services)

Power BI

SQL Server (versions

2000, 2005, 2008)

T-SQL (Transact-SQL)

Work History

2015-05 -

Current

Senior Developer/Data Analyst

Magna Powertrain, Troy, USA, MI

Designed and developed a robust ETL

process using SSIS to extract and load

warranty data from multiple OEMs into a

SQL database.

Automated the download of warranty data

files from BMW and Mercedes Benz portals

and implemented a weekly upload process

to populate the SQL database.

Achieved a significant increase in efficiency

by 65%, streamlining the data acquisition

and storage process.

Implemented error-handling mechanisms

and data validation routines within the SSIS

package to ensure data integrity and

accuracy.

Collaborated with cross-functional teams to

gather requirements, analyze data sources,

and design an optimal ETL solution.

Conducted performance tuning of the ETL

process, optimizing data transformations and

ensuring timely data loading.

Developed comprehensive documentation

and provided training to end users on utilizing

the ETL solution effectively.

Actively monitored data quality, performed

data profiling, and resolved any issues or

Database design and

optimization

Data integration and

ETL (Extract, Transform,

Load)

Stored procedures,

triggers, functions, and

views

Data Warehousing

Data Modeling

Performance Tuning

Data Analysis

Data Governance

ETL Tools (Informatica,

DataStage, Talend)

Database

Administration

Version Control

Scripting Languages

(PowerShell, Python)

Data Visualization

discrepancies encountered during the ETL

process.

Implemented best practices for ETL

development, including maintaining

version control and adhering to coding

standards.

Collaborated with stakeholders to identify

and implement additional automation

opportunities, enhancing overall workflow

efficiency.

Streamlined back-end database

communication between TLM and CRM,

reducing data entry time by 70%.

Released a web version of Global KPI,

decreasing data entry time by 60% and

providing immediate availability of reports.

Converted SSRS reports to Power Bi,

centralizing the report server for improved

manageability.

2014-08 -

2015-04

Senior Programmer / Analyst

Geometrix Rail Logistics Calgary AB Canada,

Calgary, AB

Imported Visual FoxPro data into SQL

database using SSIS, resulting in a 30%

reduction in application response time.

Directed software design and development

across multifaceted teams, meeting client

needs for functionality, timeline, and

performance.

2012-05 -

2014-07

Team Lead/ Senior Developer/

Systems Analyst

AGAT Laboratories, Calgary, AB

Increased productivity by 7% by assigning

daily employee tasks and monitoring activity.

Developed monthly and daily production

output plans to deliver on customer service

and financial metrics.

Audited team performance and compliance

with coding standards, improving readability

and standardization across applications.

Collaborated with cross-functional design

teams to create software solutions, improving

client-side experience and increasing usage

by 30%.

2007-01 -

2012-05

Programmer Analyst

Unity Builders Group, Calgary, AB

2003-02 -

2006-12

Senior Web/Application Developer

Inlets (Subdivision of Calgary Academy), Calgary,

AB

Education

Bachelor of Science: Mathematics,

Statistics, Physics

University of Karachi - Karachi, Pakistan

Certifications

Data Science Certificate by Microsoft.

Data Science from HarvardX.

Object-Oriented Software Technology Diploma

Security Clearance

Reliability Status

May 2023- Present

Contact this candidate