Scroll To View More
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

Experience

  • Excel 2016, 18 years
  • SQL, 12 years
  • SQL Server Reporting Services (SSRS), 8 years
  • Business Analysis, 6 years
  • SQL Server Analysis Services (SSAS), 6 years
  • AWS RDS, 3 years
  • Domo, 2 years
  • Microsoft Power BI, 2 years
Dubai, United Arab Emirates

Availability

Part-time

Preferred Environment

Windows, MS SQL Server, BI Studio, Visual Studio

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

  • 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

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

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

    SQL Server 2016, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), AWS RDS
  • Frameworks

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

    Wufoo API, Campaign Monitor API, jQuery UI, jQuery
  • Other

    Chrome Extensions, Web Extensions, Inventory Management, Sales, Marketing, Business Analysis

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
I really like this profile
Share it with others