Warehouse Engineer Database Analyst

Sheeraz Khalid Qazi

+923********* - ****.*******@*****.***

PERSONAL STATEMENT

Proven Data Warehouse expert having experience working in start-ups as well as established cooperate. 8+ year experience in telecom industry overall 15+ years’ experience. Expert in requirement gathering as well as problem solving to provide exceptional internal / external user support and assist in resolving conflict. Addressing business needs though data visualization by designing interactive dashboards. Highly adaptable, flexible professional who embraces teamwork, but also enjoys working independently.

KEY SKILLS

Motivated, tenacious, and excited about development and progression.

Fantastic communication skills and relationship building.

Proven ability to work independently and to deadlines.

SQL programming and optimization

Great organisational skills

Proven strong work ethic, simply passionate about doing a great job!

Well-presented and well spoken.

Demonstrated ability to plan, multi-task and prioritise.

Goal-oriented, proactive.

Excellent timekeeping.

Report Designing and Optimizing

Data Visualizations

Data Analysis

Requirement Analysis

Dimension Modelling

MS SQL Administration

Demonstrated teamwork, communication (written and verbal), and organisational skills.

WORK HISTORY

04/2021 – 06/2021

Enterprise Data Optimisation Engineer

Afiniti, Karachi, Pakistan

Identify strategic areas where data can be simplified, remove unnecessary costs and increase operational efficiencies

Provide detailed data design and data processing technical guidance

Identify & improve inefficient data designs/processes to improve the quality, efficiency and performance of data solutions.

Provide SME code reviews

Perform technical ’walkthrough’ of Data Deliveries

Work side-by-side with Data Architecture and DB Management to ensure all solutions follow good/best practice

Promote, communicate, implement and apply architecture governance processes and related organisational principles, standards and policies including all governance processes that ensure architectural alignment of all solution throughout the solution lifecycle.

03/2021 – 04/2021

Principal DBA

Shispare, Karachi, Pakistan

Design and review ERD for new version of Warehouse Management System (WMS).

Compiling Data Dictionary of ERD.

Helping developers by sharing the best practices and optimizing techniques of writing SQL queries.

02/2012 – 02/2020

Business Intelligence Senior Engineer

STC Specialized (Formerly Bravo – Public Telecom Company), Riyadh, Saudi Arabia

Facilitated the Dashboards for commercial / technical insights to the management.

Supported retention program by provide deep dive analytics to the commercial sector users.

Improved the end user experience and satisfaction by ensure the availability of BI services to the end users by optimizing reports execution procedures to 15 seconds instead of 15 minutes.

Achieved the BI project objectives by providing adequate knowledge, documentation, and support to the vendor for implementing the requirements.

Performed layer 1 for UAT for all the business requirements for all BI & BSS related projects.

Maintained and ensured 100% availability of corporate scorecard KPIs and the source data structures.

12/2010 – 11/2011

Data Architect

Saudi Network Service, Riyadh, Saudi Arabia

Increased the business end user experience by 20% through redesigning the existing INPATIENT Datamart analytics.

Understanding Business Processes and Requirement Analysis.

Redesign the existing Data Warehouse and OLAP model.

Identifying the SCD/RCD cases and defining CDC Methodology.

05/2010 – 10/2010

Database Analyst

Pragmetic Solution, Karachi, Pakistan

Increase the availability of database objects by 30% for internal customer by optimizing the database objects.

Designed and delivered the ETL methodology for the attendance management using Magnetic Card in Campus Management System (CMS)

06/2009 – 04/2010

Data warehouse Engineer

Tradekey, Karachi, Pakistan

Design and delivered the Data Warehouse and OLAP Model.

Maintained the availability of DWH Databases and ETL processes. Maintained, secured and backup of OLAP cubes.

Regularly followed the runbook with 0 failover. Increase the availability of database objects by 20% for internal customer by optimizing the database objects.

11/2008 - 03/2009

BI Developer

Royal Cyber Inc., Karachi, Pakistan

Ensured the 100% quality of the data after ETL process.

10/2007 - 10/2008

Database Administrator

Shams Software Service, Karachi, Pakistan

Increase the BI reports response time by 75% through optimizing the SQL scripting.

Reduced the 35% effort and time of developing teams by mentoring and coaching them on the optimization of database objects.

08/2005-10/2007

Database Administrator

Infinilogic Private Limited, Karachi, Pakistan

Reduced the failover and availability related risks of DWH source databases by centralizing the administration of fragmented databases. This resulted in merging of 1500 Customers Databases into Single Database.

Controlled the source database changes to be reflected through a controlled mechanism.

Implemented applications for the automation of administration and maintenance for database synchronization tasks. This reduced the time for maintenance and issue management.

EDUCATION

1999 - 2002

BS (Computer Science)

Mohammad Ali Jinnah University

CERTIFICATIONS

Since 2014

ITIL® FOUNDATION CERTIFICATE IN IT SERVICE MANAGEMENT

Contact this candidate