KALEEM RAZA GILLANI
Business Intelligence Developer
Abu Dhabi,UAE
Summary
Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
3
3
Certifications
1
1
Language
Work History
SENION SOFTWARE ENGINEER (POWER BI CONSULTANT)
TECHVISTA SYSTEMS LLC
DUBAI, UAE, UAE
01.2020 - Current
- Gathered and documented business requirements for analytical reports.
- Participated in requirements meetings and data mapping sessions to understand business needs.
- Identified and documented detailed business rules.
- Developed at least two - three visual options for each report for discussion with united stakeholders (product owners and leadership).
- Integrated Custom Visuals based on business requirements using Power BI desktop.
- Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
- Developed complex calculated measures using Level of DAX and Power Query editor.
- Managed access of reports and data for individual users using RLS.
- Provided continued maintenance and development of bug fixes for existing and new Power BI reports.
- SSIS package design and development to transform data and load in data marts for reporting.
- Created complex stored procedures to perform various tasks including, but not limited to: Index maintenance, data profiling, metadata searches, and loading of data mart.
- Designed, developed, and tested ETL strategy to populate data from multiple source systems.
- Implemented SSIS packages to perform ETL data messaging operations.
SOFTWARE ENGINEER (BI DEVELOPER)
FUTURE NOW TECHNOLOGIES
LAHORE, PAKISTAN, PAKISTAN
11.2018 - 12.2020
- Documented requirements in Business Requirement Documents (BRD)
- Designed and developed schema data models.
- Updated and maintained logical and physical model using Erwin Modeler.
- Developed automated data dictionary for Enterprise Data Warehouse using SQL.
- Transformed business requirements into functional and nonfunctional requirements.
- Designed, developed, and tested ETL strategy to populate data from multiple source systems.
- Implemented DBT models to perform ETL operations
- Designed incremental loads to populate data mart with checksum and timestamp techniques.
- Implemented models configurations on development, test, and production environments utilizing parameters.
- Created Airflow DAGs to data load jobs orchestration
SOFTWARE ENGINEER (ETL/BI)
KAVTECH SOLUTION PVT LTD
LAHORE, PAKISTAN, PAKISTAN
01.2016 - 11.2018
- Interaction with project manager to finalize functional requirements.
- Implementation of functional requirements using SSIS and Tableau Desktop.
- AWS Redshift database design for storing multi-tenant data.
- Integrating and managing Redshift multi-tenant database.
- Designing ETL using SSIS for multi-tenant database.
- Integrated data to/from SQL Server, AWS S3, CSV.
- Creating elegant dashboards and reports using Tableau Desktop.
- Creating complex measure using calculated fields in Tableau.
- Writing store procedure using T-SQL.
- Managing and maintaining Tableau server.
- Implementation of Tableau Server REST API in C# to publish dashboard.
- Implementation of AWS SDK for C# to upload files on S3 bucket.
- Creating POC on different ETL tools to fast load data from SQL Server to columnar Redshift cluster.
Education
BS - COMPUTER SCIENCE
UNIVERSITY oF GUJRATGUJRAT
Punjab, Pakistan 01.2011 - 01.2015
Skills
MS Power BI
Websites
Accomplishments
- Motivated and results-driven Data Engineer with a proven track record in Business Intelligence(BI), Data Warehouse(DWH) and ETL related consulting projects.
- Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.
- Have excellent skills in Relational and Multidimensional databases, Data Migration, System & Data Integration, Reporting, Analysis and Data Management.
- Experience in developing, implementing, documenting, monitoring and maintaining the BI & ETL process in various industries like Insurance, Real Estate, Retail etc.
- Extensive professional experience in design, development, implementation and support of mission-critical Business Intelligence (BI) applications.
- Delivered BI reporting solutions using Power BI and Tableau.
- Experience using source control and product lifecycle tools, such as GitHub, Bit Bucket, TFS and JIRA.
- Worked on small and large scale projects.
- Believe in team work. Have delivered as a team member and as an independent consultant.
Certification
Power BI (DA-100)
Timeline
Power BI (DA-100)
08-2021
Microsoft Azure (AZ-900)
07-2021
SENION SOFTWARE ENGINEER (POWER BI CONSULTANT)
TECHVISTA SYSTEMS LLC
01.2020 - Current
Tableau Desktop Specialist
06-2019
SOFTWARE ENGINEER (BI DEVELOPER)
FUTURE NOW TECHNOLOGIES
11.2018 - 12.2020
SOFTWARE ENGINEER (ETL/BI)
KAVTECH SOLUTION PVT LTD
01.2016 - 11.2018
BS - COMPUTER SCIENCE
UNIVERSITY oF GUJRATGUJRAT
01.2011 - 01.2015
Similar Profiles
Babar IqbalBabar Iqbal
Senior Consultant App Development at TechVista Systems / Systems LimitedSenior Consultant App Development at TechVista Systems / Systems Limited
Mateen RasoolMateen Rasool
Senior Managing Consultant at Techvista SystemsSenior Managing Consultant at Techvista Systems
Preethi PerumalPreethi Perumal
Senior Quality Analyst at Techvista SystemsSenior Quality Analyst at Techvista Systems