Shahid Thaika, SQL Developer in Dubai, United Arab Emirates
Shahid Thaika

SQL Developer in Dubai, United Arab Emirates

Member since July 28, 2017
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+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.
Shahid is now available for hire

Portfolio

Location

Dubai, United Arab Emirates

Availability

Full-time

Preferred Environment

MS SQL Server, MS Power BI, Visual Studio, Excel, MySQL, PHP, JavaScript

The most amazing...

...project I've worked in was to implement end-to-end systems successfully for a company where many other big brand IT companies failed for over ten years.

Employment

  • Data Engineer

    2018 - 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 other charts, based on user inputs, to help analyze trends in crypto trading markets, to make informed investments.
    Technologies: PHP, MS Azure SQL Database, MS Power BI
  • SQL Developer

    2017 - 2020
    SelectQuote Insurance Services, Inc.
    • Contributed as a member of the team that migrated legacy SQL Server procedures to new MariaDB based system, and created new ones as required.
    • Optimized queries for both MS SQL Server and MariaDB procedures, including certain cases where procedures taking over 20-40 minutes were cut short to 2-3 minutes.
    • Analyzed data and created applications to find more leads to up-sell to, using historic sales data. Each system used different logic to find leads.
    • Designed and implemented various ETL SSIS packages to process and export data used in marketing and sales campaigns.
    • Designed and implemented custom dashboards and reports using Amazon AWS Quicksight, for MariaDB based application.
    • Designed and implemented reports and dashboards using MS Power BI for MS SQL Server-based data warehouse, including real-time streaming datasets and reports. Used PHP for the API that populates the streaming dataset.
    • Developed JavaScript and PHP applications to manage external communication with customers and data sharing with third-party vendors and deployed them via an AWS Virtual Machine and Secrets Manager.
    • Created reports on MS SQL Server Reporting Services and using custom PHP reporting applications as required for business users.
    Technologies: MariaDB, MS SQL Server, SQL Server Integration Services, MS Power BI
  • Business Consultant

    2016 - 2018
    One Affiniti
    • Designed and built the entire analytical environment from scratch, integrating data from various in-house and third-party solutions.
    • Designed and wrote queries to process email subscriber data from over 50,000 campaigns as of June 2018, and to incorporate data regarding prior campaign planning, post planning email marketing outcome, attribution to invoice, etc.
    • Built reports using Excel, DOMO, SSRS, etc.
    • Analyzed data to suggest ways to improve subscriber conversions, optimize the usage of resources, reduce inefficiencies, etc.
    • Worked toward getting an external consultant to implement Big Data solutions.
    Technologies: PHP, MySQL, DOMO, Google Data Studio, Excel, AWS, Campaign Monitor, Google API integration
  • Business Analysis Advisor

    2012 - 2015
    Dell International Services
    • Reported and analyzed the sales funnel for marketing campaigns and other factors driving demand for Dell's pipeline, revenue, and margin.
    • Designed and implemented ‘Leakage Reports’ – a dynamic dashboard to accurately and visually determine revenue loss at every point of the sales funnel.
    • Initiatives following insights and recommendations from above yielded a substantial increase in the pipeline to the company.
    • Designed and implemented data structure and many views in Tableau Dashboards.
    • Automated and optimized various deliverables and implemented systems to save hundreds of man-hours.
    • Designed and implemented a tool and a systematic process to accurately and efficiently plan campaigns created in our CRM, by 20-25 people across 6-7 countries.
    • Nominated and awarded a Partner Silver Award and another award within the department (Two in one year).
    Technologies: MS SQL Server, MS SQL Server Analysis Services, Excel, Tableau, Salesforce
  • Senior IT Executive

    2009 - 2012
    Coastal Energy Private Limited
    • Member of a team that implemented the IT Enablement vision of a multinational group of companies, with five subsidiaries, using Microsoft’s range of enterprise level software solutions.
    • Implemented MS Dynamics CRM 4.0, in a techno-functional role, across four locations of the company in three countries.
    • Customized MS CRM for additional functionality using ASP.NET and JavaScript.
    • Served as task lead and main liaison with channel partner for MS Dynamics NAV implementation.
    • Enhanced NAV functionality by implementing customization and add-ins for features such as “Hide Zero” in Analysis by Dimension, Dynamic Web browser control add-in, One to many invoice application, Excel to NAV mappings, etc.
    • Completed NAV implementation for a subsidiary, without channel partner, after GO LIVE of two main subsidiaries.
    • Supported the finance department to finalize business process, generate master data, evaluate alternatives, and assisted in deciding optimum transaction entries.
    Technologies: MS Dynamics CRM, MS Dynamics NAV, MS SQL Server, MS SQL Server Reporting Services, C#, JavaScript, Excel
  • IS - Project Management Intern

    2007 - 2007
    Staples, Inc
    • Assisted in providing support to PlanView (web-based IS Portfolio Management tool) implementation.
    • Analyzed metrics results and benefits realization from PlanView, and provided inputs to design further metrics.
    • Designed and implemented tools to enhance various processes such as PlanView compliance monitoring, customer satisfaction evaluation, project management and requirements feedback.
    Technologies: Project Manager, Excel

Experience

  • Simple Password Manager (Development)
    https://play.google.com/store/apps/details?id=in.shahidthaika.android.simplepassmgr

    Simple Password Manager stores your various passwords, for websites, bank pin, lock number, 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 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 APPLICATION'S SECURITY DESIGN, IT IS NOT POSSIBLE TO RETRIEVE A LOST MASTER PASSWORD

  • CRM Lead Lifecycle Visualization (Development)
    https://imgur.com/a/9rzDRiv

    This is an interactive and dynamic dashboard created entirely in Excel and 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.

Skills

  • Languages

    SQL, Excel VBA, CSS, HTML, JavaScript, PHP
  • Tools

    Microsoft Excel, Excel 2016, Microsoft Power BI, Domo, Gimp, Inkscape, Tableau
  • Platforms

    Windows, Android, Linux, Amazon Web Services (AWS)
  • Storage

    MySQL, SQL Server 2016, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), MySQL DBA, Database Administration (DBA), SQL Server Reporting Services (SSRS), AWS RDS, Microsoft SQL Server
  • Other

    Software Development, Chrome Extensions, Web Extensions, Inventory Management, Sales, Business Analysis
  • Frameworks

    Bootstrap 3, ASP.NET, Yii 2
  • Libraries/APIs

    Wufoo API, Campaign Monitor API, jQuery UI, jQuery
  • Industry Expertise

    Marketing

Education

  • MSIT + MBA Dual degree in Management Information Systems
    2006 - 2008
    Bentley University - Waltham, MA
  • Master of Commerce degree in Banking and Finance
    2004 - 2006
    Sydenham College - Mumbai, India
  • Bachelor of Commerce degree in Business Management
    2001 - 2004
    Sydenham College - Mumbai, India

To view more profiles

Join Toptal
Share it with others