Summary

• 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.

Projects

Vitamin World
Kitara Media
Update Numbering Plan

Experience

Company Logo
Advisory Software Engineer (Business Intelligence)
Systems Ltd
Oct 2017 - Present | 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.

Company Logo
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.

Company Logo
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.

Company Logo
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.

Company Logo
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

Education

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

Skills

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

Languages

Expert Urdu
Expert English

Kazim Contacts

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