概要

• Over 8 years Database experience with design, development and administration experience in both OLTP and OLAP
• Expert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Extensive knowledge of clustering environment.
• Data Architecture (Conceptual, Logical, Physical) experience involves Normal forms (RDBMS) & Star Schema, Dimension (Slowly Changing, Snowflake) & Facts.
• Excellent experience of managing BI environment (Microsoft Azure SQL Database/ Azure SQL Data Warehouse Parallel Data Warehouse ,Microsoft Business Intelligence Suit, Amazon RedShift, PolyBase), which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.

项目

Vitamin World
Kitara Media
Update Numbering Plan

工作经历

公司标识
Advisory Software Engineer (Business Intelligence)
Systems Ltd
Oct 2017 - 代表 | Lahore, Pakistan

-Design and Development of Data warehouse (Dimensional Modelling, Database design and ETL) and Business Intelligence (Report, KPI, Scorecards, Dashboards)

-Develop and Design the integration process for Data warehouse.

-Designed data marts.

-Tuned ETL stored procedures, triggers and user defined functions. Designed and developed SSIS packages, designed and enhanced OLAP cubes.

-Participated in numerous report development utilizing Microsoft Power BI and Tableau.

公司标识
Principal Software Engineer
NetSol Technologies Limited
Feb 2014 - Oct 2017 | Lahore, Pakistan

-Design and Development of Database
-Develop Store Procedure, Functions UDF, Packages and Triggers
-Maintain and Manage Indexes, Query Optimization, Database Configurations
-Good in performance tuning especially tuning complex queries, procedure and indexing strategies
-Analyzing data for quality and reconciling data issues.
-Resolving data integrity issues across stakeholders.
-Bug fixing Expert
-Prototype new applications to refine requirements.
-Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration.
-Creation and maintenance of technical documentation.

公司标识
Sr. Software Engineer (Database)
NetSol Technologies Limited
Feb 2014 - Jun 2016 | Lahore, Pakistan

- Design and Development of Database
- Develop Store Procedure, Functions (UDF), Packages and Triggers
- Maintain and Manage Indexes, Query Optimization, Database Configurations
- Good in performance tuning especially tuning complex queries, procedure and indexing strategies
- Analyzing data for quality and reconciling data issues.
- Resolving data integrity issues across stakeholders.
- Bug fixing Expert
- Prototype new applications to refine requirements.
- Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration.
- Creation and maintenance of technical documentation.

公司标识
Sr Software Engineer (Database)
CDocs - NorthBay Solutions
Jul 2013 - Feb 2014 | Lahore, Pakistan

- Design and Development of Data warehousing
- Design and Develop ETLs
- Handling of data over 100 million rows.
- Designing the dimension models using the star schemas.
- Schema Optimization and Data warehousing Optimization.
- Checking the data correction and consistency while loading the data into data warehouse
- Migrating the data from data marts & log files from S3 server to centralized data warehouse
- Finding and fixing the bugs (Redundant Data).
- Write complex SQL queries using condition statements for the generation of user reports.
- Designing and creating the aggregate tables for some huge data sets.

公司标识
Database Administrator
Apr 2011 - Jul 2013 | Lahore, Pakistan

- Initiated, prepared, implemented and now maintaining the security policies regarding database servers and databases.
- Standardized the privileges with respect of team and their needs for accessing the data.
- Responsible for the physical as well as logical design of physical configuration on the storage media.
- Data Modeling, Data Purging &Performance Tuning (Both OS and Databases).
- Optimization of Queries and database architecture.
- Taking Backups (Migration, Cloning, Full Backups and Incremental Backups).
- Reviewing queries which needed to be deployed on QA, SCM and Production servers. Also, standardized the rules for writing the queries and communicated it to developers.
- Preparing a plan of parent child hierarchy of DB so that all partners can come under one instance and we can move towards MySQL cluster.
- Providing Disaster Recovery Plan, Failovers and High Availability through different types of replication.
- Providing Level-3 Technical Support

学历

University of Central Punjab (UCP)
硕士, , MS Computer Science‎
Database Systems
2010
University of Central Punjab (UCP)
学士, , Bachelors of Science(HONS.)‎
Computer Science
2006

技能

初学者 ABAP
熟练 Ada
熟练 Agile Programming
中级 Algol
中级 APL
熟练 Architectural Designing Skills
中级 Asp
熟练 ASP.Net
初学者 Assembly
熟练 Bash
熟练 C#
熟练 Clarion
初学者 COM/DCOM/COM+
熟练 Continuous Integration
中级 Cross-browser Compatibility
熟练 Custom Software Development
中级 D
熟练 Database Clustering
熟练 Database Management Library
熟练 Database Replication
熟练 Delphi/Object Pascal
熟练 Distributed Development
熟练 DOM Scripting
熟练 Domain Modeling
熟练 Embedded Programming
初学者 Fine Art Teaching
熟练 Forth
熟练 Front-End Coding
熟练 Front-End Engineering
熟练 HTML and XHTML
熟练 Infobright
熟练 Infrastructure Management.
中级 Javascript
熟练 JScript.
初学者 Lex
中级 Lisp
熟练 Load Balancing
初学者 Lua
熟练 Microsoft SQL
中级 Microsoft Visual FoxPro
熟练 MS SQL Server
熟练 Multithreaded Application Development
熟练 Multithreading
熟练 MySQL
熟练 NDepend
中级 NewSQL
熟练 NosSQL
中级 Object-Oriented Software
熟练 OLAP
中级 OLE Automation

语言

熟练 乌尔都语
熟练 英语

Kazim 联系人

Aalishaan Mahboob
DMN Digital Agency
Hassan Ali
Telcologix
SyedAltan Haider
(Nust) National University of Science & Technology Islamabad