Tahir Badar，新西兰惠灵顿的开发者
Tahir is available for hire
Hire Tahir

Tahir Badar

Verified Expert  in Engineering

ETL开发人员

Location
惠灵顿，新西兰
Toptal Member Since
June 18, 2020

Tahir is a highly seasoned and creative ETL and BI consultant with an exceptional track record of accomplishment and customer satisfaction. He is highly experienced in the agile development process and has over eight years of experience in ETL and BI reporting, analytics, 和DWH技术.

数据仓库设计Data WarehousingData AnalysisSQLDatabases商业智能(BI)Oracle商业智能企业版11g (OBIEE)TeradataDatabase DesignTableauMySQLPL/SQL DeveloperMicrosoft SQL ServerData VisualizationTeradata DatabasesOracle OBIEE

Availability

Part-time

首选的环境

MySQL, Microsoft SQL Server, Tableau

The most amazing...

...project I've developed was a heart rate analysis in Tableau of different candidates made to watch horror VR video and questioned afterward.

Work Experience

Tableau Developer

2019 - PRESENT
弹跳咨询服务有限责任公司.
  • 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.
  • 使用计算的关键数字和参数创建不同的KPI.
  • Utilized Tableau server to publish and share the reports with the business users.
技术:表

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.
  • 在Microsoft SQL Server中设计并开发了迁移框架.
  • 通过分析数据，回答客户的疑问.
  • 根据客户端的请求通过SQL Server生成报表.
技术:房地产，Microsoft SQL Server

Data Analyst

2017 - PRESENT
ANZ Bank
  • 为obiee12c设置环境.
  • 参与表示层数据建模.
  • 负责开发不同的模型报告.
  • 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.
  • 在报告和指示板级别执行安全实现.
  • 建议不同的技巧和技巧，以提高报告的性能.
技术:数据仓库设计, Data Warehousing, 数据库应用程序, SQL, Teradata, Tableau, Oracle商业智能应用(OBIA)

Data Analyst

2017 - 2017
UBL
  • 实现了持久性聚合，使设计更高效.
  • 提供了obiee11g中数据级安全的解决方案.
  • 根据客户需求构建报告和仪表板.
  • Suggested different solutions to improve overall performance of the dashboards.
  • 在obie11g中实现了TAS的安全矩阵.
  • Developed YTD and MTD reports for TAS using runtime filters (alternate approach for AGO function).
技术:数据仓库, 数据仓库设计, Oracle商业智能应用(OBIA), Teradata

Teradata迁移专家

2016 - 2016
Simishen Net Bank
  • 参与迭代开发以提高吞吐量.
  • 估计TMA脚本的转换率.
  • 将Oracle中的ddl, dml, dcl和功能迁移到Teradata.
  • 使用Shell Scripting开发脚本执行框架.
  • 为脚本开发测试框架.
  • 开发正则表达式来测试脚本的格式.
  • 使用c++开发用户定义函数.
  • 开发Teradata SQL程序和Teradata SQL函数.
  • 与客户一起完成测试框架.
技术:SQL, Oracle, Teradata

领导obeee开发人员

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.
  • 在第三层视图之上开发BI视图.
  • 与客户和最终用户进行交互，收集需求列表.
  • Identified critical issues and processing faults to optimize BI dashboards and reports.
  • Developed a metadata repository using an OBIEE administration tool in the physical, 业务模型和映射, 表示层.
  • 创建新的逻辑列, 维度层次结构, 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.
  • 在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.
  • 与客户保持联系，确保UAT顺利通过.
  • 参与OBIEE项目的支持阶段.
  • Provided guidance and support to end users during the implementation and in production.
技术:数据仓库, 数据仓库设计, SQL, Teradata, Oracle商业智能应用(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.
  • 在第3层视图之上开发聚合表以优化报告.
技术:数据仓库设计, Data Warehousing, 数据库应用程序, SQL, Teradata

Data Analyst

2014 - 2015
PTSB
  • 验证和验证数据映射文档.
  • 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.
  • 为转换后的数据设计并执行全面的单元测试.
  • Utilized Jira for defects reporting and resolution by closely working with the development, test, data mapping, and modeling teams.
Technologies: 数据仓库，数据仓库设计，数据库应用，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, SAP-BI金融类股.
  • Created data reconciliation for the stats warehouse and SAP financial warehouse.
  • 在项目的整个生命周期中工作.
  • Developed and designed the complete BI architecture (RPD) in OBIEE for statistical and financial streams.
  • 在OBIEE中实现了缓存和数据级安全.
  • Developed the BI report for the statistical and financial data using OBIEE 11g.
  • 推出统计应用程序和BI报告，以及SAP-BI财务报表.
  • Oversaw the post production support of the statistical application and BI Reports, and SAP BI.
  • 对HEC终端用户进行OBIEE 11G培训.
  • Conducted training for the custom build statistical application for end users from different universities of Punjab and Sindh.
技术:数据库设计, SQL, PL/SQL, 数据仓库设计, Data Warehousing, Oracle商业智能应用(OBIA), Oracle Data Integrator (ODI)

表中的心率分析

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. 通过一系列的问题, 研究人员的目的是分析特定的刺激如何, such as clowns, 受影响的心率峰值.

Notably, the results demonstrated that individuals with a fear of clowns exhibited higher heart rates during the segments of the video featuring clowns, 与那些不害怕小丑的人形成对比. These findings provided valuable insights into the connection between external stimuli, emotional responses, 生理反应, 特别是与恐惧和心率波动有关.

为了可视化和分析数据，使用了Tableau.

Languages

Sql, Sql ddl, Sql DML

Tools

Tableau, Oracle商业智能企业版11g (OBIEE), Oracle商业智能应用(OBIA)

Paradigms

数据库设计，ETL实现 & 设计、商业智能(BI)

Storage

Databases, Database Triggers, Teradata, Microsoft SQL Server, MySQL, PL/SQL Developer, PL/SQL, Teradata Databases

Other

数据仓库设计, Data Warehousing, ETL Development, Data Analysis, 复杂数据分析, 数据质量分析, ETL Tools, 数据库应用程序, Real Estate, 认证Scrum专家, Agile Deployment, 软件开发生命周期(SDLC), 自动化框架开发, Data Visualization

Platforms

Oracle Database, Oracle Data Integrator (ODI), Oracle, Oracle Data Integrator 11g

2008 - 2012

计算机科学学士学位

通信卫星信息技术学院-伊斯兰堡，巴基斯坦

2018年12月至今

专业Scrum Master 1

Scrum.org

2017年3月- 2019年3月

Tableau Desktop 10合格助理

Tableau

JUNE 2014 - PRESENT

TEO 141: Teradata 14认证专业人员

Teradata

有效的合作

如何使用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 hiring