Azim Lanewala

Experience

• 

  Tata Consultancy Services

  Mar 2007 - now

  - SQL server development, SSIS implementation and DBA activities. - Interaction with Development Team in fine Tuning the SQL Codes and Database design. - Responsible for logical and physical design of SQL Server databases.

  • Lead MSBI Consultant

    Mar 2007 - now

  • MSBI Consultant and Lead Non-Production DBA

    Jul 2012 - Jun 2013

  • MSBI Consultant and Developer DBA

    Mar 2007 - Jun 2012
• 

  Lex Autolease

  Jul 2013 - Jun 2014

  Lead MSBI Consultant and Production DBA

  - Responsible for SSIS development.- Developed Universe using SAP business objects.- Code review & testing in various environments like development and pre-production Resolving day to day production/data loading issues. Performance tuning (query optimization) of existing database objects.- SQL Server Performance tuning, Sever configuration and Index maintenance.- Exposure to DBA related activities like creating users, roles, and permissions for the entire server and the other servers which are linked upon.- Monitoring the Live database server through spotlight and daily checking database email alerts. Show less

• 

  Qatar Islamic Bank (QIB)

  Jul 2014 - Nov 2015

  Lead MSBI Consultant

  Working as Lead MSBI Consultant.- Responsible for all SSIS related development and Deployment.- Developed complex reports with SSRS.- Developed and maintained crystal reports using SAP business objects.- SQL Server Performance tuning, Sever configuration and Index maintenance.

• 

  The Rank Group plc

  Jan 2016 - now

  Lead Business Intelligence Consultant

  Role Working as Lead Azure Data Engineer DBA- Developing Azure Data Warehouse using WhereScape Red Data warehouse automation tool.- Developed Azure Cost Analysis report using PowerBI.- Automated the Azure Analysis Cube Refresh using Azure Runbooks.- Migrated Database from SQL 2008 to Azure SQL Database.- Created Azure Analysis service to generate datasets for Power BI.- Developed master data management (MDM) load automation.- Worked on Configuring SQL Server in Always on Availability groups (Always On). - Azure Machine Sizing for Cost Optimization.- Worked on Configuring Log-shipping in production environment- Worked on Maestro tool from Profisee for Matching and Survivorship strategy design.- Created and managed OLAP Cubes using SSAS.- Involved in analyzing, designing building & testing of OLAP cubes with SSAS and in adding calculation - Worked on address standardization using match code Batch processor tool. - Worked on Auto cleanup of MDS Batches post processing.- Developed and maintenance of SSIS packages. Show less