Shahid is available for hire
Hire ShahidShahid Thaika
Verified Expert in Engineering
SQL Developer
Dubai, United Arab Emirates
Toptal member since October 11, 2018
Bio
Shahid designs and develops systems and databases, presents data with stunning visualizations to easily see the big picture, and performs deep-dive analysis to make key decisions. A US MSIT and MBA dual-degree graduate, he is fluent in English and has 12 years of professional experience across many industries. Shahid focuses on understanding requirements and identifying root causes to plan and execute the best course of action for business needs.
Portfolio
Jun Group
Google Cloud Platform (GCP), Google Cloud Composer, Google Cloud Storage...
BCG Gamma
Microsoft Power BI, PostgreSQL, Azure Synapse, Microsoft SQL Server, DAX...
Heimstaden
PostgreSQL, Microsoft SQL Server, Microsoft Power BI, Microsoft Access...
Experience
- Microsoft Excel - 18 years
- SQL - 16 years
- Data Engineering - 12 years
- Data Warehousing - 8 years
- MySQL - 7 years
- Google BigQuery - 5 years
- Google Cloud Platform (GCP) - 4 years
- Microsoft Power BI - 4 years
Work Experience
Senior Data Engineer
2022 - 2026
Jun Group
- Built data pipelines to support business analysis and reporting for a digital advertising company, using Airflow on GCP Composer for regular workloads and Apache Beam on Google Dataflow for higher-throughput workloads at a terabyte scale.
- Created prototypes and evaluated multiple reporting platforms before driving adoption of Holistics as a more cost-effective, semantic-layer-based alternative to Looker for scalable enterprise reporting.
- Designed and developed a new star-schema data model in BigQuery, replacing a legacy architecture with hundreds of report-specific tables and simplifying maintenance.
- Optimized queries to reduce processing overhead, pipeline failures, and backfill requirements, and implemented built-in error checks and alerts to improve pipeline reliability.
- Migrated legacy Looker Studio reports to Holistics and built new dashboards as needed.
- Proactively designed analytical solutions that enabled deeper user analysis, expanded segment targeting, and predictive modeling population by 6x, and supported adaptation to new PII regulations.
Technologies: Google Cloud Platform (GCP), Google Cloud Composer, Google Cloud Storage, Google Cloud Dataflow, Apache Airflow, Google BigQuery, Java, Google Data Studio, Looker Studio, Python, Holistics, MySQL, PostgreSQL, Apache Beam, SQL, Data Warehousing, Data Engineering, Data Visualization, Databases, Business Intelligence (BI), Data Pipelines, API Integration, ETL Pipelines, Integration, Pub/Sub, ELT, Bootstrap 3, CSS, Transact-SQL (T-SQL), Google Cloud SQL, Identity & Access Management (IAM), Cloud
Power BI Data Engineer
2021 - 2022
BCG Gamma
- Built Power BI reports that were embedded in a broader UI to compare predicted vs actual pricing strategy for a retailer with 9,000+ stores. Data sourced from Azure Data Lake and PostgreSQL.
- Coded and optimized SQL views that populated the Power BI model, benchmarked performance, and improved load times by reducing query count and limiting inefficient DirectQuery usage.
- Integrated and aggregated data from CSVs, Spark outputs, application data, and modeling outputs.
Technologies: Microsoft Power BI, PostgreSQL, Azure Synapse, Microsoft SQL Server, DAX, Azure Data Lake, Azure SQL Databases, Data Engineering, Data Visualization, Business Intelligence (BI), Windows, Power BI Desktop
Senior Data Engineer
2021 - 2021
Heimstaden
- Designed and implemented Power BI dashboards for a leading European real estate company.
- Optimized reports and data models, reducing report count and improving performance and size.
- Consolidated data across multiple countries and reporting frequencies into simplified structures, and implemented time intelligence with change-based loading to reduce unnecessary data writes.
- Planned tasks and oversaw two junior developers, while leading knowledge transfer and cross-team discussions to resolve reporting and information systems issues.
Technologies: PostgreSQL, Microsoft SQL Server, Microsoft Power BI, Microsoft Access, Microsoft Excel, Business Intelligence (BI), SQL Stored Procedures, Power Query, DAX, Data Engineering, Data Visualization, Relational Databases, Integration, ELT, Windows, Inventory Management, Power BI Desktop
Power BI Data Analyst
2021 - 2021
Yara International
- Aggregated data from multiple product solutions, developed SQL and dbt transformations, and built a reporting database in Amazon Redshift for a global agricultural solutions company.
- Remodeled and optimized Power BI data structures by simplifying multiple fact tables into a star schema, improving performance, reducing file size, and enabling new metric calculations.
- Used Tabular Editor to streamline measures and implement reusable time-intelligence calculations, including YoY, YTD, monthly, and all-time views.
Technologies: Redshift, Microsoft Power BI, Data Build Tool (dbt), Business Intelligence (BI), Power Query, DAX, Data Engineering, Data Visualization, Relational Databases, Windows, Power BI Desktop
Redshift Query Specialist
2021 - 2021
The Hustle
- Developed reports using Sisense for an online email-based newsletter business.
- Wrote queries against a Redshift database used by the company against the Sisense cache.
- Optimized existing queries that the business users already wrote.
Technologies: Redshift, Sisense, JSON, APIs, Windows
MySQL Database Administrator
2020 - 2020
Jun Group
- Diagnosed performance bottlenecks in a high-traffic production MySQL v5.7 RDS instance and partnered with developers to implement fixes that reduced database load by 20%.
- Optimized MySQL server configuration using InnoDB engine analysis, reducing disk reads to one-third of prior levels, increasing write requests before flushing by 2–3x, and improving buffer pool utilization.
- Built a custom monitoring solution and analyzed query logs to identify high-frequency queries, caching opportunities, and indexing gaps, improving query efficiency and reducing aborted connections.
- Planned and executed an automated 60-step migration using dynamic queries and Bash scripts to move the production database from a 4.4 TB to a 2.5 TB RDS instance with zero downtime.
- Further reduced database size by at least 250 GB (10%) by removing redundant indexes and correcting oversized field definitions, collations, and non-scalable table designs.
- Built a load-aware online schema change solution using triggers and procedures to alter large production tables with millions to billions of rows with zero downtime.
Technologies: Amazon EC2, SQL, Amazon Web Services (AWS), Linux, Database Administration (DBA), Bash Script, MySQL, Database Development, Amazon S3 (AWS S3), Databases, SQL Stored Procedures, Python, Amazon RDS, Google Data Studio, Google BigQuery, BigQuery, Database Optimization, Apache Airflow, Relational Databases, Cloud
Data Engineer
2019 - 2020
Decentral Park Capital
- Designed and built the data warehouse and reporting systems for a digital assets fund management company.
- Aggregated data into MS Azure SQL Database using PHP scripts to consume APIs from various third-party data vendors.
- Designed and developed various dashboards and reports and transformed and modeled the data using a combination of SQL queries, Power BI modeling, and DAX.
- Built regression models and charts based on user inputs to help analyze trends in crypto trading markets and make informed investments.
Technologies: Data Analysis, Azure SQL, Azure, jQuery UI, SQL, SQL Server 2016, jQuery, Yii 2, Linux, Excel VBA, Data Engineering, Database Administration (DBA), HTML, Data Warehousing, Data Warehouse Design, Excel 2016, Microsoft Excel, Microsoft Power BI, Azure SQL Databases, PHP, Database Development, JSON API, JSON REST APIs, Data Architecture, Data Modeling, Dashboards, Data Visualization, Databases, REST APIs, JSON, Microsoft SQL Server, Business Intelligence (BI), SQL Stored Procedures, Power Query, DAX, APIs, API Integration, Integration, Windows, Transact-SQL (T-SQL), Cloud, Power BI Desktop
SQL Developer
2018 - 2020
SelectQuote Insurance Services, Inc.
- Migrated legacy SQL Server procedures to MariaDB and developed new ones required by the business.
- Optimized procedures, reducing execution times in some cases from 20–40 minutes to 2–3 minutes.
- Developed ETL packages using SSIS to process and export data for marketing and sales campaigns.
- Analyzed historical sales data and developed applications to identify upsell opportunities.
- Delivered reports and dashboards using AWS QuickSight, Microsoft SSRS, and Power BI, including real-time streaming datasets populated via PHP APIs.
- Developed JavaScript and PHP applications for customer communications and third-party vendor data exchange and deployed them on AWS using EC2 and Secrets Manager.
Technologies: Data Analysis, .NET, SQL, SQL Server Integration Services (SSIS), Visual Studio, SQL Server Reporting Services (SSRS), Amazon Web Services (AWS), SQL Server 2016, C#, Business Analysis, MySQL, Microsoft Power BI, Microsoft SQL Server, MariaDB, Database Development, ETL, Amazon S3 (AWS S3), JSON API, JSON REST APIs, Data Modeling, Dashboards, Data Visualization, Databases, JSON, Amazon QuickSight, SQL Stored Procedures, Power Query, DAX, Data Pipelines, Relational Databases, ETL Pipelines, ELT, Windows, Bootstrap 3, CSS, Transact-SQL (T-SQL), Power BI Desktop
Business Consultant
2016 - 2018
One Affiniti
- Designed and implemented a data warehouse integrating in-house and third-party data, and wrote queries to analyze subscriber behavior across 50,000+ campaigns and support invoice attribution.
- Evaluated multiple reporting tools before delivering solutions using Domo and Microsoft SSRS.
- Analyzed marketing and operational data to improve subscriber conversion and resource allocation.
Technologies: Data Analysis, Amazon EC2, SQL, Amazon Web Services (AWS), Linux, Excel VBA, Data Engineering, Business Analysis, Database Administration (DBA), HTML, Wufoo API, Campaign Monitor API, Data Warehouse Design, Data Warehousing, MySQL, Google API, Microsoft Excel, Google Data Studio, Domo, PHP, Database Development, ETL, JSON API, JSON REST APIs, Data Architecture, Data Modeling, Dashboards, Data Visualization, Databases, REST APIs, JSON, Business Intelligence (BI), Amazon QuickSight, SQL Stored Procedures, APIs, Amazon RDS, Database Optimization, Data Pipelines, Relational Databases, ETL Pipelines, Integration, ELT, Windows, Excel Macros
Business Analysis Advisor
2012 - 2015
Dell International Services
- Delivered sales and marketing analytics for Dell’s Global Demand Center, providing reports and insights that improved sales funnel visibility and helped increase lead conversion and revenue.
- Independently designed and launched Leakage Reports, a dynamic dashboard that visualized the sales funnel and highlighted lost revenue opportunities, helping drive pipeline growth.
- Streamlined and automated recurring deliverables, reducing manual effort by hundreds of hours.
- Introduced Microsoft SSAS within the team to reduce report file sizes and improve report delivery.
- Developed a campaign planning tool with data validation and auto-correction, and established a process used by 25 users across seven countries for forecasting, resource allocation, and CRM loading.
- Received two awards for performance and contributions, including a Partner Silver Award.
Technologies: Data Analysis, SQL Server DBA, SQL, SQL Server Integration Services (SSIS), SQL Server 2016, Business Analysis, Excel 2016, Microsoft Excel, Salesforce, Tableau, SQL Server Analysis Services (SSAS), Microsoft SQL Server, Database Development, ETL, Data Modeling, Dashboards, Data Visualization, Databases, Business Intelligence (BI), SQL Stored Procedures, Visual Basic for Applications (VBA), Database Optimization, Relational Databases, ETL Pipelines, ELT, Windows, Excel Macros, Transact-SQL (T-SQL)
Senior IT Executive
2009 - 2012
Coastal Energy Private Limited
- Served as a member of a team that implemented enterprise systems modernization across a multinational group with five subsidiaries using Microsoft business platforms, helping standardize business processes.
- Implemented Microsoft Dynamics CRM – contact management, activity tracking, sales opportunity and quotation, and integration with Microsoft Dynamics NAV and in-house logistics systems.
- Played a techno-functional role translating complex business scenarios into technical design and worked with business users to refine processes and improve adoption, usability, and business value.
- Served as task lead and primary liaison with channel partner for MS Dynamics NAV implementation, including completing one subsidiary rollout independently after the initial go-live phases.
- Developed CRM/NAV enhancements using ASP.NET and JavaScript for custom user requirements.
Technologies: SQL Server DBA, .NET, ASP.NET, SQL, Visual Studio, SQL Server Reporting Services (SSRS), SQL Server 2016, jQuery, C#, Excel VBA, HTML, Excel 2016, Microsoft Excel, JavaScript, Microsoft SQL Server, Microsoft Dynamics NAV, Microsoft Dynamics CRM, Database Development, Data Architecture, Databases, REST APIs, JSON, SQL Stored Procedures, Visual Basic for Applications (VBA), Finance, Relational Databases, API Integration, Integration, Windows, Bootstrap 3, CSS, Inventory Management, Excel Macros, Transact-SQL (T-SQL)
Project History
Simple Password Manager
https://play.google.com/store/apps/details?id=in.shahidthaika.android.simplepassmgrSimple Password Manager stores your various passwords, for websites, bank pins, lock numbers, etc., in a secure manner. It is easy to use without any ads or frills attached.
Have trouble remembering your numerous passwords? Now, remember only the master password for Simple Password Manager, and the application will remind you of the other passwords you store within.
This application uses Password-Based Key Derivation and AES Encryption to securely store your passwords and gives you full control and visibility into the encryption method used.
Note: Due to the application's security design, it is not possible to retrieve a lost master password.
Have trouble remembering your numerous passwords? Now, remember only the master password for Simple Password Manager, and the application will remind you of the other passwords you store within.
This application uses Password-Based Key Derivation and AES Encryption to securely store your passwords and gives you full control and visibility into the encryption method used.
Note: Due to the application's security design, it is not possible to retrieve a lost master password.
CRM Lead Lifecycle Visualization
https://imgur.com/a/9rzDRivThis interactive and dynamic dashboard created entirely in Excel gives you an overview of the point at which the relationship between your company and the potential customer ended in the CRM's lead process lifecycle.
Supply Chain Planning and Visualization Tool
A supply chain planning and visualization tool I built using Excel. You need to configure the various raw material inputs and manufactured output at various nodes. It automatically simulates the entire supply chain activities of procuring raw materials, producing semi-finished and finished goods, and distribution to various customers. It's completely dynamic and supports any number of nodes and complexity, and supports various statistical distribution methods.
Education
2006 - 2008
MSIT + MBA Dual Degree in Management Information Systems
Bentley University - Waltham, MA
2004 - 2006
Master of Commerce Degree in Banking and Finance
Sydenham College - Mumbai, India
2001 - 2004
Bachelor of Commerce Degree in Business Management
Sydenham College - Mumbai, India
Skills
Libraries/APIs
JSON API, REST APIs, Wufoo API, Campaign Monitor API, jQuery UI, jQuery, Google API
Tools
Microsoft Excel, Microsoft Power BI, Excel 2016, Power Query, Power BI Desktop, Domo, Microsoft Access, Power Pivot, Amazon QuickSight, BigQuery, Apache Beam, Apache Airflow, Visual Studio, Microsoft Dynamics CRM, Microsoft Dynamics NAV, Tableau, Sisense, Google Cloud Composer
Languages
SQL, PHP, Excel VBA, Transact-SQL (T-SQL), Visual Basic for Applications (VBA), Java, CSS, HTML, JavaScript, Python, C#, Bash Script
Paradigms
Database Development, ETL, Business Intelligence (BI)
Platforms
Windows, Linux, Amazon Web Services (AWS), Salesforce, Amazon EC2, Azure, Android, Azure Synapse, Google Cloud Platform (GCP), Holistics, Microsoft Fabric
Storage
MySQL, Microsoft SQL Server, Azure SQL Databases, MariaDB, SQL Server 2016, Databases, JSON, SQL Stored Procedures, SQL Server Integration Services (SSIS), Database Administration (DBA), SQL Server DBA, Azure SQL, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Pipelines, Relational Databases, Amazon S3 (AWS S3), Redshift, PostgreSQL, Google Cloud Storage, Google Cloud SQL
Frameworks
.NET, Bootstrap 3, ASP.NET, Yii 2
Other
Data Engineering, Excel Macros, JSON REST APIs, Web Extensions, Dashboards, Data Visualization, DAX, APIs, API Integration, ETL Pipelines, Data Warehousing, Google Data Studio, Data Analysis, Data Architecture, Data Modeling, Data Warehouse Design, Chrome Extensions, Inventory Management, Business Analysis, Amazon RDS, Google BigQuery, Database Optimization, Integration, ELT, Identity & Access Management (IAM), Cloud, Finance, Business Management, Data Build Tool (dbt), Encryption, Azure Data Lake, Google Cloud Dataflow, Looker Studio, Pub/Sub
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