Download PDF


Solution architect and database administrator with more than 12 years of experience in data-warehouse architecture, database management, query optimization, Teradata Active System Management (TASM), system administration, BAR and ETL methodologies.

Well-versed in designing, developing, implementing and managing database policies and procedures to ensure integrity and availability of databases and their accompanying software. Competent in designing, coding, testing and supporting database environments. Commended for handling demanding production support environment while managing large volumes of business-critical data. Committed team player with ability to communicate at all levels and perform production support administration tasks including proactive monitoring, troubleshooting, tracing, backup, recovery and on-call support to ensure availability and performance requirements are met.

Experience working in international markets and customer facing technical consultancy roles, worked closely with major credit card company in United Kingdom for 18 months. Delivered technical training to customer DBA team in Abu Dhabi, UAE. Attended and delivered various international technical training sessions.

Work experience

Feb 2019Present

Data Solution Architect

If Insurance Finland

Data architecture, data modeling and data organization for Enterprise Data Warehouse

  • Which data goes where? What should the data model look like?
  • Concrete modeling work : updating data model diagrams, physical data models

Technical solution design

  • Data Integration and Access Layer
  • Support developers with implementation issues, assist in source to target mapping

Investigating source system data and processes

Documentation & Training : user & technical

  • Ensure documentation is maintained and gets done for new solutions
  • Concrete steps to continuously improve documentation and organization of existing solutions.

Compliance (GDPR)

  • Ensure that solutions are compliant with GDPR requirements
  • Design and plan data retention and data protection

Consulting business on new requirements

  • Clarifying requirements
  • Overlaps with existing solutions or other planned new solutions

Marketing data based solution deliveries & pushing their area forward

  • Advise Product Owners and other stakeholders on how solutions within the area could be improved
  • Identify gaps in current and planned deliveries
  • Identify parts of existing solutions that most badly need refactoring

Development and other implementation work alongside developers

On-boarding of new developers

Dec 2016Feb 2019

Solution Architect

If Insurance Finland

I am working under the Reporting and Analytics unit at If Insurance with responsibility to oversee governance and day to day operations of our Teradata Platform. Recently involved quite heavily with migrating our on premises infrastructure to Microsoft Azure which is one of the premier public cloud offerings in the market.

  • Develop and maintain solution architecture practices, standards and communicate them within IT and business.
  • Review, analyse and evaluate ideas, projects and opportunities in order to support the development of new services, technologies and business models for the relevant IT and business areas.
  • Support our IT architecture in creating models demonstrating how products, operations and systems correlate within reporting & analytics as per business application strategy.
  • Conduct analysis to determine best way for solving IT and business challenges that include process improvements, system enhancement, user training or software procurement.
  • Ensure system projects requirements are in alignment with IT and business strategies and IT architecture road-maps.
  • Participating in reporting and datawarehouse development work
  • Maintaining datawarehouse system operations and doing performance improvements.
  • Actively involved in handling various development initiatives following agile methodology as a Scrum Master and developer.
Apr 2010Nov 2016

Global Delivery Control Consultant


I have been primarily engaged as a Teradata DBA in Teradata Global Delivery Center, Pakistan and have the privilege of providing services to Fortune 500 companies in offshore/onshore 24 x 7 delivery models. Major responsibilities include but are not limited to:

  • Database Operations and Administration
  • Data Storage Management
  • Security Administration
  • Teradata Database Optimization
  • Teradata Metrics Collection and Reporting
  • System Administration
  • Database Objects Release Management
  • BAR Environment Administration
  • BAR Operations
  • Physical Database Modelling
  • Basic Big Data/Hadoop Administration (Hortonworks Data Platform)
  • System performance assessment
  • Application performance review and tuning
  • Capacity forecast for current and new workload

Major client engagements include but are not limited to:

Unilever, Barclays, Telefonica O2 Ireland & UK, Emirates Integrated Telecommunications Company,Telenor Pakistan, Capital One UK, Mobilink Pakistan, Intesa SanPaolo Bank Italy and OP Pohjola Group Finland.

Key deliverables:

  • Developed and implemented end to end workload management strategies (TASM) at various client systems
  • Providing ongoing support of the environment by developing processes and executing object migrations and database performance monitoring.
  • Designing, building and maintaining the physical Teradata database objects (databases, tables, views, macros etc.) to support business requirements
  • Developed various Physical Data Models (PDMs) by following SDLC and ITIL best practices
  • Provided technical and business consultancy on best practices of managing and admnistering Teradata database system
  • Working knowledge of Teradata PDCR, CPPT, MSM and UDA
  • Providing leadership and mentoring to team members while adopting a broad business approach.
  • Providing basic administration services on Big Data, Hortonworks Data Platform (HDP)
Nov 2009Apr 2010

IT Executive

Earth Factor

I was extensively involved in development, optimization and end to end live deployment of different IVR based services for Pakistan’s leading telecommunication companies. Some of the services which I successfully developed and deployed were: Telenor’s Karo Mumkin, Music, Regional and health portals for Ufone, Telenor and Zong. 

Major tools utilized included Asterisk PBX, MySQL, Perl and Groovy.

Jun 2009Aug 2009

Research Assistant

Systems Research (Pvt) Ltd.

During my stay here, I worked on Open Source Java to assist development in the reporting module for the enterprise software which was a complete Telecommunication billing as a Service (TbaaS) solution for Telecommunication Companies. The billing solution was developed using Eclipse IDE, Java and Jasper Reports.


Apr 2016Present

AWS Technical Professional

Amazon Web Services
Aug 2015Present

Teradata 14 Certified Professional

Apr 2013Present

ITIL v3 Foundation Certified




  • Teradata GDC Quarterly Award (Q2 2011) 
  • Delivered hands-on workshop on Teradata Viewpoint Administration to Etisalat in Abu Dhabi, UAE on behalf of NCR Gulf.
  • Attended Teradata Unity implementation workshop in London, United Kingdom.
  • Attended HDP Administration workshop in Islamabad, Pakistan.
  • Attended Unity implementation workshop: Train The Trainer in Manila, Philippines.
  • Attended Teradata Performance Optimization workshop in Prague, Czech Republic.