Implementing a Data warehouse with Microsoft SQL Server 2012

Querying Microsoft SQL Server 2012

Administering Microsoft SQL Server 2012 Databases

Education

University Of Karachi,

BS in Computer Science, 2008-2011

Awards

Gold Medalist BS Computer Science 2011 University of Karachi

Publications

A COMPARATIVE STUDY OF DATA MINING TECHNIQUES FOR HCV PATIENTS’ DATA

ICCSS, Aug 2014, Rize Turkey

Applied different data mining techniques on hepatitis C patients’ data for observing the factors of high prevalence of risk of hepatitis C virus. Results obtained by the applied algorithms of this paper are superior to other techniques of related research papers.

Personal Details

Current Location: (Lat 24.906, Long 67.130), Karachi, Pakistan.

Father’s Name: Abdul Qadir

Date of Birth: 16-10-1989

Marital Status: Single

Languages: Urdu (Native Language)

English (Working Proficiency)

Muhammad Shoaib

Microsoft Certified Solutions Associate (SQL Server 2012)

Principal BI/DW Engineer, 360factors

Gold Medalist (BSCS, 2011)

ac707q@r.postjobfree.com

0092-321-***-****

mshoaib891

My LinkedIn Profile

Career Summary

Principal BI/DW Engineer, 360factors

May 2018 – Present

Senior Software Engineer, afiniti

Oct 2016 – April 2018

Senior Consultant – IM (ETL / DWH / BI), qordata

Sep 2014 – Oct 2016

Technical Consultant – IM (ETL / DWH / BI), Streebo

Jan 2012 - Aug 2014

Teacher Assistant, University of Karachi (Volunteered)

Jan 2013 - June 2013

Intern, Pakistan International Airline

June 2011 - July 2011

Profile

Around 7 years of professional experience in providing consulting services in Information Management practice for enterprise level customers over US and Europe, includes presales initiatives, Tech/Lead in projects through analyzing, requirement gathering, planning, designing, developing, go-live, documenting with implementation experience in pharmaceutical, insurance, telecommunications and compliance domains.

Traversing various successful Microsoft BI Stack’s projects by devising an absolute solution for accomplishing customers’ higher business goals and growing recursive businesses for my company by augmenting customer’s satisfaction level.

Proven skills of handling/leading critical projects independently, multiple threads concurrently.

Proactive, fast self-learning ability, innovative, interested in honing my skills and knowledge to act on an exciting role.

Skills & Competences

MS SSIS 2012 / 2008

MS SQL Server 2012/2008

MySql

Dimensional Modeling

Kalido DIW / MDM

MS SSAS 2012 / 2008

MS SSRS 2012/2008

TIBCO Spotfire

Power BI

Talend

IBM DataStage

Career Overview

Clientele

Pharmaceutical Clientele

Providing Consultancy services in ETL &DWH for following clientele over Spain with Streebo business partner IMS-Health.

(Europe)

Bayer

Sanofi Pasteur

Beiersdorf

Angelini

Rovi

Vifor Pharma

Effik International

Alcon

Other Clientele

(USA)

T-Mobile

Part of a primary team for the Implementation of AI Models by Engineer the ETL processes of loading and managing large scaled data

Medical Protective

American liability insurance

company

Part of a primary team for the Implementation of Master Data Management model using KLIDO MDM following a pre-sales effort of the proposed solution.

AWAC

Allied World Assurance Company

Provided offshore consultancy services which comprises end to end implementations of following projects

ETL Migration from IBM Data Stage to SSIS.

ETL Migration from IBM AS/400 to SSIS.

Load process optimizations.

Managed Services support.

References

Will be provided upon request.

Functions and roles

Principal BI/DW Engineer,360Factors

May 2018 – Present

Design, enhance, and implement Data Warehouse architecture, analytics data stores, and reporting and BI solutions, implementing data transformation rules and data validations into the data warehouses.

Troubleshoot issues and tune at all layers: database, ETL, and presentation.

Develop target data models including data policies for sensitive data assets, security policies, back-up, and recovery specifications.

Develop database solutions by designing proposed system, defining database physical structure, and functional capabilities.

Implement data strategy, data governance processes, and maintenance of business definitions, policies and glossaries for data assets.

Senior Software Engineer – ETL, afiniti

Oct 2016 – April 2018

Responsible to Engineer the process by

Creating and managing ETL jobs using Talend for transferring calls volumes in millions of records from different servers to centralized repository.

Optimizing performance on MySQL complex queries.

Advising industry standards implementation for process engineering.

Data purifications for the significant treatment of AI Models.

Senior Consultant, Streebo

Sep 2014 – Oct 2016

Responsible to provide top-notch consulting services by

Analyzing, designing, developing and implementing ETL, Data Warehouse and BI while integrating multiple ‘Data Sources’ effectively and efficiently, including testing and validation programs.

Designing and developing complex ‘ETL Routines’, writing complex SQL queries, procedures, functions and processes with technical documentations.

Executes end to end implementation of projects which involves requirement gathering, project planning, project estimations, development and providing deliverables over the committed timeline.

Participates in organizational growth by providing in house technical and soft skills trainings, making Pre-sales efforts, conducting interviews and standardizing the processes.

Working independently and managing team of consultants on various engagements.

Providing offshore consultancy services for around 2 years with Streebo’s business partner company IMS Health (Spain) for international pharmaceutical clients operational in Spain.

Technical Consultant, Streebo

Jan 2012 - Aug 2014

Responsible for

Part of the core team for project implementation of Data Warehousing, Master Data Management and BI for Enterprise level customers.

Initiated, lead and supported managed services activity for monitoring, bug fixing and documenting nightly build processes of an Enterprise data warehouse.

Assisted in preparing proof of concept (POC), standardizing the logging and configuration mechanism of ongoing processes and migrating operational systems across the platforms.

Implemented load process optimization for Kalido DIW, SSIS packages and SQL Server stored procedures.

Teacher Assistant at University of Karachi (Volunteered)

Jan 2013 - June 2013

Conducted practical labs for the course of ‘Artificial intelligence’ to the students of Bachelors of Science in Software Engineering and educated the implementation of theoretical concepts of AI in real life with examples using a tool called Prolog.

Executed multiple career counselling session sand mentorship programs for graduate students, intended for enabling them to grow personally and professionally.

Intern at Pakistan International Airline

June 2011 - July 2011

Proposed an online solution for Provident Fund Management by analyzing the current process and presented the real needs with advantages of transforming to online solution.

Derived the feasibility of solution by documenting project description, implementations aspects, project plan and suggesting best technologies to achieve the objective.

Consulting And Projects

Senior Software Engineer, T-Mobile (Oct 2016 to Present)

Projects

Responsibilities

T-Mobile

Part of a primary team for the Implementation of AI Models for better pairing.

Engineering the ETL processes of loading and managing large scaled data.

Advising industry standards implementation for process engineering.

Senior Consultant IMS Health (Nov 2013 to Oct 2016)

Projects

Responsibilities

Bayer

Managed end to end implementation of data mart and web-based solution.

Data mart has been prepared by transforming data of different sources, containing sales data of pharmacies, hospitals, doctors and prescriptions at national level of Spain which has then been integrated with Market’s data to form the resultant used in Spotfire based reports.

Web based solution / application enable the customers for manipulating with master data of markets so that the user can experience the applied changes directly on reports.

Effik

Vifor Pharma

Led the efforts of building standard reporting tables for Sales Force employees of EFFIK and Vifor pharma.

Generated ETL to integrate required information in database.

The data sources were a territorial SELL IN at sanibrick level and Target sales, reporting layer in Spotfire needs to be used by Sales Reps, Area Managers and National Managers.

Almirall

Led the standardization process of an international pharmaceutical company based on innovation and committed to health, headquartered in Barcelona, Spain.

The data of multiple countries are obtained in row formats which then transformed into single standard output using master files and automated queries.

Angelini

The purpose of this project is to replace and improve upon the "IMS Territory Planner" software, which reports sales versus objectives and in the future against activity for the sales force.

Integration of new data & reports design for a new product line and its associated SalesForce team.

Newly design system is capable for the access to whole SalesForce team (+100 sales reps).

Sanofi Pasteur

Development of ETL, Data warehousing part of vaccines division of Sanofi Pasteur.

DWH is the resultant of integration of multiple sources including several sales data, departmental expenses and budgeted data etc.

Used Microsoft SSIS 2012 for importing data from flat files and excel sheets to SQL Server 2012 database, transforming, loading into DWH and finally reporting tables have been prepared focusing the business and customer’s needs.

Beiersdorf

Prepared the mart of Dermo-cosmetics data of national level and created reporting layer to identify competitor’s sells all over the region.

Led the effort of customizing web-based solution for enabling user to manipulate with market’s factors.

Transactional data have been integrated with market’s data so that the user can familiarize the applied changes instantly.

Automated the process for identifying new products based on market’s properties.

Technical Consultant Medical Protective (July 2013 – Oct 2013)

Projects

Responsibilities

(Proof of Concept)

Designed and developed the POC using advanced feature of Kalido MDM Data matching in order to provide the solution of mapping reference data from different source systems deterministically and/or probabilistically for data consolidation and data lineage.

Implementation of MDM Model

Containing automated data import into the solution, Data Matching (deterministically and probabilistically), Data lineage and automated data export from the solution for data load into the data warehouse.

Technical Consultant Allied World Assurance Company – EDWH (Jan 2012 – June 2013)

Projects

Responsibilities

ETL Migrations

Migrated ETL system from IBM DataStage to Microsoft SSIS 2008, designed packages reflecting all the transformations, executions flow and business logics functional formerly by DataStage.

Implemented ETL solution for loading data from IBM AS/400 to SQL SERVER using Microsoft SSIS 2008, covers the features of restart-ability, logging, configurations and reusability.

Managed Services

Proposed successful managed services solutions which became an ongoing consulting service activity.

Logging and configuration mechanism for MS SSIS solutions were been standardized using custom logging approach which provides complete details of execution on success or failure with dynamic configurations through tables, xml files and environmental variables

Captivated the systems understanding for nightly build load processes, conveyed the knowledge and empowered support team to handle on call issues.

Contact this candidate