Tahir is available for hire
Hire TahirTahir Badar
Verified Expert in Engineering
Data Visualization Developer
Auckland, New Zealand
Toptal member since July 11, 2019
Bio
Tahir is an experienced data and analytics professional with over 15 years in Data Warehousing, BI, and analytical delivery across major financial institutions. At ANZ Bank, he guides analysis from problem definition to delivery, transforming complex data into clear insights. Skilled in SQL, BI tools, and data modeling, Tahir collaborates closely with stakeholders to enhance capability and drive better business decisions.
Portfolio
CQ Corporation
Real Estate, Microsoft SQL Server
ANZ Bank
Data Warehouse Design, Data Warehousing, Database Applications, SQL, Teradata...
Experience
- SQL - 8 years
- Business Intelligence (BI) - 8 years
- Data Visualization - 8 years
- ETL Implementation & Design - 8 years
- Complex Data Analysis - 8 years
- ETL Development - 8 years
- ETL Tools - 4 years
- Tableau - 3 years
Preferred Environment
MySQL, Microsoft SQL Server, Tableau, Teradata Databases, WhereScape RED, Databricks, Python 3
The most amazing...
...thing I've delivered is a secure card transaction reporting solution, developed in 4 months. This project combined my skills in data engineering and ownership.
Work Experience
Tableau Developer
2019 - PRESENT
Ricochet Advisory Services, LLC.
- Responsible to understand the Requirements and Functionality of the application from specifications. The project was for a US-based credit card company where we needed to answer several business questions to help the business make some important decisions.
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Created different KPI using calculated key figures and parameters.
- Utilized Tableau server to publish and share the reports with the business users.
Technologies: Tableau
Data Analyst
2018 - PRESENT
CQ Corporation
- Led a team of remote developers to build a data migration framework for an Australia-based real estate CRM.
- Designed and developed the migration framework in Microsoft SQL Server.
- Answered queries from clients by analyzing data.
- Generated reports through SQL Server as per requests from clients.
Technologies: Real Estate, Microsoft SQL Server
Data Analyst
2017 - PRESENT
ANZ Bank
- Set up the environment for OBIEE 12C.
- Involved in presentation layer data modelling.
- Responsible for developing different mock-up reports.
- Involved in meetings with the solution architect in designing the BI solution.
- Responsible for developing reports and dashboards as per customer requirements.
- Performed different formatting using HTML and JavaScript to change the layout of the dashboards.
- Performed security implementation at the report and dashboard level.
- Suggested different tips and tricks to enhance the report performance.
Technologies: Data Warehousing, Data Warehouse Design, Database Applications, SQL, Teradata, Tableau, Oracle Business Intelligence Applications (OBIA)
Data Analyst
2017 - 2017
UBL
- Implemented persistence aggregation to make the design efficient.
- Provided a solution for data level security in OBIEE 11G.
- Built reports and dashboards as per customer requirements.
- Suggested different solutions to improve overall performance of the dashboards.
- Implemented a security matrix for TAS in OBIEE 11G.
- Developed YTD and MTD reports for TAS using runtime filters (alternate approach for AGO function).
Technologies: Data Warehousing, Data Warehouse Design, Oracle Business Intelligence Applications (OBIA), Teradata
Teradata Migration Expert
2016 - 2016
Simishen Net Bank
- Involved in the iterative development to increase throughput.
- Estimated the conversion rate of scripts from TMA.
- Migrated DDLs, DMLs, DCLs and functions in Oracle to Teradata.
- Developed the framework for executions of script using Shell Scripting.
- Developed the testing framework for the scripts.
- Developed regular expression to test the formatting of the scripts.
- Developed user defined functions using C++.
- Developed Teradata SQL procedures and Teradata SQL functions.
- Involved with the customer to finalize the testing framework.
Technologies: SQL, Oracle, Teradata
Lead OBIEE Developer
2015 - 2016
Maybak
- Oversaw the entire life cycle of the project from requirements gathering to deployment.
- Enabled our team to increase its productivity through the use of Agile approaches.
- Developed the BI views on top of tier-3 views.
- Interacted with the client and end user to collect the list of requirements.
- Identified critical issues and processing faults to optimize BI dashboards and reports.
- Developed a metadata repository using an OBIEE administration tool in the physical, business model and mapping, and presentation layer.
- Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the business mapping and model layer as per the business requirements.
- Developed Time Series Objects using AGO and To Date functions for time series comparisons.
- Created various session and repository variables, and initialized them in the Initialization Blocks.
- Implemented cache and data level security in OBIEE.
- Led the SIT for BI to ensure that the OBIEE was generating correct scripts for reporting.
- Developed test cases and performed unit and integration testing of the repository.
- Liaised with the customer to make sure that the UAT passed out successfully.
- Involved in the supporting phase of OBIEE project.
- Provided guidance and support to end users during the implementation and in production.
Technologies: Data Warehousing, Data Warehouse Design, SQL, Teradata, Oracle Business Intelligence Applications (OBIA)
Data Mapper
2015 - 2015
MayBank
- Designed the mappings for the semantic layer according to the business rules given by the client.
- Engaged in requirements gathering with the client to verify business rules and reports.
- Developed views for the semantic layer and performed unit testing and data reconciliation.
- Developed aggregated tables on top of tier-3 views to optimize the reports.
Technologies: Data Warehouse Design, Data Warehousing, Database Applications, SQL, Teradata
Data Analyst
2014 - 2015
PTSB
- Validated and verified the data mapping document.
- Oversaw the ETL development for moving transformed data as per business rules mentioned in data mappings from the acquisition to integrated layer through GCFR ETL processes.
- Designed and performed comprehensive unit testing for transformed data.
- Utilized Jira for defects reporting and resolution by closely working with the development, test, data mapping, and modeling teams.
Technologies: Data Warehouse Design, Data Warehousing, Database Applications, SQL, Teradata
Data Analyst
2012 - 2014
Techlogic
- Oversaw the transaction database design and application development for the statistics module.
- Oversaw the warehouse design and implementation (including ETL) for the statistics module, and SAP-BI financials.
- Created data reconciliation for the stats warehouse and SAP financial warehouse.
- Worked during the entire life cycle of the project.
- Developed and designed the complete BI architecture (RPD) in OBIEE for statistical and financial streams.
- Implemented cache and data level security in OBIEE.
- Developed the BI report for the statistical and financial data using OBIEE 11g.
- Rolled out the statistical application and BI reports, and SAP-BI financials.
- Oversaw the post production support of the statistical application and BI Reports, and SAP BI.
- Conducted training on OBIEE 11G for HEC end users.
- Conducted training for the custom build statistical application for end users from different universities of Punjab and Sindh.
Technologies: Database Design, SQL, PL/SQL, Data Warehousing, Data Warehouse Design, Oracle Business Intelligence Applications (OBIA), Oracle Data Integrator (ODI)
Experience
Heart Rate Analysis in Tableau
This research project involved studying the relationship between external stimulation and changes in heart rate by conducting an experiment using virtual reality (VR). Participants were immersed in a VR horror video while their heart rates were monitored. Through a series of questions, the researchers aimed to analyze how specific stimuli, such as clowns, influenced heart rate spikes.
Notably, the results demonstrated that individuals with a fear of clowns exhibited higher heart rates during the segments of the video featuring clowns, in contrast to those who did not fear clowns. These findings provided valuable insights into the connection between external stimuli, emotional responses, and physiological reactions, specifically related to fear and heart rate fluctuations.
To visualize and analyze the data, Tableau was utilized.
Notably, the results demonstrated that individuals with a fear of clowns exhibited higher heart rates during the segments of the video featuring clowns, in contrast to those who did not fear clowns. These findings provided valuable insights into the connection between external stimuli, emotional responses, and physiological reactions, specifically related to fear and heart rate fluctuations.
To visualize and analyze the data, Tableau was utilized.
Education
2008 - 2012
Bachelor of Science Degree in Computer Science
Comsats Institute of Information Technology - Islamabad, Pakistan
Certifications
DECEMBER 2018 - PRESENT
Professional Scrum Master 1
Scrum.org
MARCH 2017 - MARCH 2019
Tableau Desktop 10 Qualified Associate
Tableau
JUNE 2014 - PRESENT
TEO 141: Teradata 14 Certified Professional
Teradata
Skills
Tools
Tableau, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Business Intelligence Applications (OBIA), WhereScape RED
Languages
SQL, SQL DDL, SQL DML, Python 3
Paradigms
Database Design, ETL Implementation & Design, Business Intelligence (BI)
Storage
Databases, Database Triggers, Teradata, Microsoft SQL Server, MySQL, PL/SQL Developer, PL/SQL, Teradata Databases
Platforms
Oracle Database, Oracle Data Integrator (ODI), Oracle, Oracle Data Integrator 11g, Databricks
Other
Data Warehouse Design, Data Warehousing, ETL Development, Data Analysis, Complex Data Analysis, Data Quality Analysis, ETL Tools, Database Applications, Real Estate, Certified Scrum Professional, Agile Deployment, Software Development Lifecycle (SDLC), Automation Framework Development, Data Visualization, Software
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring