Muhammad Ali--
Present Address:
House 26 Street 11, New Super Town
Main Boulevard Lahore, Pakistan
Professional
Summary:
EXPERIENCE:
Permanent Address:
C-1, WAPDA colony, Gojra road,
Toba Tek Singh 36050, Pakistan
Almost 4 Years of experience in IT Professional career with about 3 years in ETL, ODS,
Business Intelligence and Data warehousing. Extensively worked on MS SQL Server and MS
Business Intelligence stack.
Experience in software development life cycle, business requirement analysis, and data
warehousing design.
Expert skills in data migration and ETL from various data sources like Excel, SQL Server, Flat
files using SSIS packages and SQL commands. Monitoring, debugging and tuning ETL jobs
and workflows.
Good Command on calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas.
Worked on creating test data and unit test cases. Writing test cases and system plans to
ensure successful data loading process.
Sr. Software Engineer, Northbay Solutions, Pakistan, 16 May 2016 to Present
Providing efficient solutions to our customers to get useful information from their enterprise
large data. Design and implement map reduce jobs to support columnar storage DWH/ BI
solutions using AWS Redshift. Ability to design and implement end to end solution with
exposure to AWS Lamda architecture, S3 files, scheduling, user maintenance.
Software Engineer, Innovation Group Global Solutions, Pakistan, 1 April 2013 to 11 May 2016
As business intelligence developer, I am responsible for gathering high level requirements from
client and finalizing them according to data warehousing needs. Involved in Designing,
Developing and Testing of the ETL strategy to populate the data from various source systems
feeds using SSIS and out of the box store procedures.
Additional responsibilities include:
1) Aggregating data from multiple sources in an efficient data warehouse
2) Designing and plan BI solutions
3) Debugging, monitoring and troubleshooting ETL process
4) Creating and deploying reports
5) Creating dashboard for business executives
Software Development Officer, Telenor Pakistan, 11 July 2012 to 29 March 2013
I had responsibility to develop the in house projects of Telenor. These projects had been
developed using. Net Framework and Oracle database. I was also responsible to handles CRs
(Change Requests) raised by different department of Telenor.
PROJECTS:
Wolverine Analytics at Innovation Group Global Solutions, Pakistan
Involved in complete Software Development Life Cycle (SDLC) process by analyzing
business requirements and understanding the functional work flow of information
from source systems to destination systems.
Implemented ODS system along with analytics application to extract transactional
level data from OLTP system.
Worked on transformation of OLTP data to the Data Warehouse using SSIS and SQL
commands.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and
executing the packages in both the environments (Development and Production).
Innovation Insurer Analytics- MWFBI at Innovation Group Global Solutions, Pakistan
Project is on production now. I got “Best Employee” slip from Innovation group US on
completing this project successfully. Currently providing live support in day to day
production issues, and troubleshooting ETL job failures.
CERTIFICATION:
Querying Microsoft SQL Server 2012
Awards:
Best Employee Award at Innovation Group Global Solutions
SKILLS:
Programming/Scripting Languages:
Tools:
T-SQL, MDX, VB.NET, ASP.NET, C#, ANT,
Python, JQuery
MS Visual Studio, MS BIDS, SSAS, SSIS,SSRS,
Jenkins, IIS, WebSphere
EDUCATION:
Bachelor of Engineering, Software Engineering ,-, 3.56/4.00
National University of Sciences and Technology, Islamabad, Pakistan.
INTERESTS:
Data Science, Distributed Computing, Machine Learning
