Summary
Overview
Skills
Work History
Projects
Education
Certification
Affiliations
Timeline
Hi, I’m

AMIR SHABBIR SHAIKH

Technology Analyst
Dallas,TX
AMIR SHABBIR SHAIKH

Summary

Around 5 years of professional IT experience in Data Analytics, Quantitative analysis, model building and cloud computing. Possess good understanding of Business Analytics, Software development life cycle, Retail Operations, and IT infrastructure. With my current Analytical course, I have acquired exposure on Data Analysis, Profiling, handling the data using various statistical modelling techniques, making predictions, forecasting on the data sets further using correlations, model building using Logistic Regression, Decision Tree, Neural Network and Random Forest. I have gained efficiency in data analysis using Python, R, ETL, MySQL creating great visuals using R programming language and displaying the graphs and charts in Tableau and RShiny Dashboards.

Overview

6
years of professional experience
50

Certifications

2
years of post-secondary education

Skills

  • Programming Languages: R, RStudio, SQL, Python
  • Database: Oracle, RDS, DynamoDB, Redshift, ETL, MySQL, Snowflake, Dbeaver
  • Repository Tools: AWS S3, Amazon Snowball, Glacier and AWS Deep Archive, SharePoint
  • BI Tools: Power BI, Tableau, R Shiny, Cognos, Alteryx
  • Statistics: Regression, Hypothesis Testing, Correlation, Forecasting and Trend Analysis
  • CRM: Salesforce, Genesys, Siebel, ServiceNow
  • Cloud Technologies: Cloud Management, AWS Management Console, AWS Cost Explorer, EC2 Dashboard
  • Others: Adobe (Photoshop, Adobe Illustrator), Inventory Management, Microsoft Office 365 Suite, Data Pipeline

Work History

Fidelity Investments
, Texas

Technology Risk Analyst
09.2023 - Current

Job overview

  • Executed complex SQL database queries for data validation, maintaining precision and accuracy in information handling
  • Employed data visualization methods using Tableau and PowerBi to effectively communicate insights in reports and presentations, demonstrating a clear grasp of information presentation and strong communication skills
  • Troubleshooted database and analytics-related issues by leveraging SQL expertise, critical thinking skills and collaborating with cross-functional teams to swiftly resolve operational challenges
  • Collaborated across functional teams to design, deploy, and manage controls effectively, leveraging an in-depth understanding of cloud operations, SQL, and database management
  • Demonstrated comprehensive knowledge of industry standards and frameworks (e.g., SOC-1, SOC-2, ISO27001, HITRUST), integrating analytics and database understanding in control development and implementation
  • Utilized expertise in cloud security and technology environments (AWS/Azure) to develop and enforce appropriate controls and measures, leveraging analytical skills.

Fidelity Investments
Boston, MA

Data Analyst, Co-op
01.2023 - 06.2023

Job overview

  • Translated business requirements into technical specifications, achieving 90% of KPIs using Alteryx, Tableau, ETL, and Snowflake in an agile environment with stakeholders
  • Developed Python and SQL-based predictive models to ascertain Fidelity application source code confidentiality, achieving an 88% accuracy rate when committing differentiated code to Git
  • Reviewed and optimized SQL code in Fidelity's database environment, resolving 5 high-impact tickets in ServiceNow
  • Created and maintained Tableau/PowerBI dashboards for Cloud Fire-call Access monitoring for stakeholders
  • Analyzed data sources using ETL and Alteryx, creating Tableau dashboards for 24/7 key metric monitoring
  • Implemented data tagging in ServiceNow tickets, categorizing issues and reducing SLA time requirements by 70% through root cause analysis.

Northeastern University
Boston, MA

ITS People Data Analyst
10.2022 - 09.2023

Job overview

  • Working in collaboration with ITS Recruitment teams to create, manage job requisitions, job postings including creation, editing, removal, and hiring new and returning staff using Workday, Salesforce and ServiceNow.
  • Assisting the ITS CX Leadership to hire new and returning staff through canvas assessments, interviews, and trainings.

Northeastern University
Boston, MA

Budget Analyst
02.2022 - 04.2022

Job overview

  • Analyzed University provided mapping documents for data transfer using ETL data through IBM Cognos, performed exploratory data analysis, cleansed, derived new columns using feature engineering to forecast budgets
  • Built predictive models such as Logistic Regression, Decision Tree, Random Forest, and Neural Network to understand the significant variables impacting the budgets with an average accuracy of 85%
  • Populated the data and created interactive Dashboards in Tableau to discover the Northeastern University operational budget trend for 2025, to develop strategies for academic fiscal planning and budget allocation.

British Petroleum, Global Business Service
Pune

Data Analyst
01.2021 - 08.2021

Job overview

  • Transformed and cleansed large unstructured customer datasets into well-structured data format using ETL and MySQL and performed trend assessment of the information using Power BI
  • Performed data profiling, data exploration and using Power BI visualized the companies trend analysis, predicted allocation of resources and identified business improvements opportunities
  • Automated the merging process using stored procedures to perform data migration across two CRM platforms which reduced 12% of run time
  • Validated and resolved Data Quality issues within the Salesforce application post migration which decreased the production errors by 8%

Amazon Web Services, AWS
Bangalore

AWS Cloud Data Engineer
03.2019 - 01.2021

Job overview

  • Proactively managed applications, ETL, SQL databases, and web servers for 24/7 service availability, predicting and preventing issues
  • Utilized predictive modeling and CloudTrail logs to analyze business data for designing RDS architecture with AWS services
  • Created Tableau dashboards to identify trends, optimize IAM services, and improve SLAs
  • Supported data center migration to cloud infrastructure, dynamically adjusting architecture to meet business needs along with data integration and analysis from diverse sources, generating reports using ETL and MySQL for client solutions
  • Assisted enterprise customers with escalated AWS service issues and integrations, including VPC, Route53, IAM, and more
  • Developed automated reports using ETL, MySQL, Tableau, AWS CloudTrail, and SNS, reducing manual monitoring efforts by 70%
  • Enhanced reporting workflows with Tableau, ETL, and MySQL, cutting processing time by 75% and delivering valuable insights to clients.

Amazon Development Center India Pvt. Ltd
Pune

Retail Business Associate (Operations)
10.2017 - 03.2019

Job overview

  • • Utilized R and Python for ETL processes to transform raw customer order data, enabling analysis, data modeling, and predictions.
    • Monitored operational and supply chain performance to identify trends, efficiency gaps, and root causes, driving logistical process improvements.
    • Analyzed customer behavior using Big Data, MySQL, and Tableau to understand the customer experience and provide actionable recommendations through dashboard construction and enhancement.
    • Developed an Amazon.com product page using Excel, ETL, MySQL, and AWS Service Catalog along with managing technical escalations for Amazon Prime, Kindle, and Alexa, maintaining a 90% SLA.
    • Executed SQL queries to consolidate customer purchase data from multiple Amazon domains, profiling data to determine net revenue growth.
    • Leveraged CRM for operational front-end processes, including order placement, packaging, logistics, delivery, and service handling.

Projects

  • Working Algorithm for Student Risk Analysis Project: Python, MySQL, R, Tableau April 2022-June 2022

· Analysing Silicon Valley company dataset to conceptualize risk assessment algorithm based on forecasting metric.

· Creating a portfolio based on Predictive Modeling and Machine Learning to determine the retention rate of students in undergraduate education while comparing the standard metrics against national and global platforms.

· Proposing an algorithm built on current dataset provided for foreseeable future requirements based on supervised machine learning systems.

  • Dunkin database: ETL, MySQL, Tableau and Excel Feb 2022-April 2022

· Developed real time database application for Dunkin, modeled data using entity relationships diagrams, and database architecture.

· Applied the Structured Query Language (SQL) for accessing and manipulating databases to define, update, retrieve, and manipulate data.

· Implemented the use case scenarios of the food ordering application from signing up, selection of category of products and providing ratings for the order and employee along with creation of the research paper.

  • World Demographics and Bike sharing data Visualization: Tableau, Rshiny, Excel Jan 2022–Feb 2022

· Analyzed, filtered, and cleaned the dataset from UNICEF and Bike sharing using Exploratory Data Analysis (EDA).

· Prepared an initial analysis report to understand the parameters and trends of the dataset.

· Effectively used the various graphs like a bar graph, line graph, combination graphs, heatmap, map graph, etc., to visually represent the dataset to create storytelling using Tableau.

· Applied several principles like Z principle, proximity principle, and similarity principle to the dashboard for effective representation and understanding.

  • National Women’s Basketball Data Analysis: R Programming and Excel Jan 2022–Feb 2022

· Using R Programming Language, analysed, and interpreted the data using Exploratory Data Analysis and Regression techniques

· Effectively designed and implemented generalized linear methods to interpret data and answer strategic and operational questions

· Using correlation and logistic regression method to improve the predictive outcomes.

  • Predicting Bitcoin Price and Hashrate Variance: Python, SQL, Excel, Tableau June 2023-Sept 2023

· Developed a predictive model using machine learning algorithms to forecast Bitcoin network hashrate fluctuations, achieving 85% accuracy.

· Analyzed five years of historical blockchain data and external factors using data mining and SQL, identifying patterns affecting Bitcoin network hashrate variations through compelling visuals and reports using Tableau and Power BI to effectively communicate findings to stakeholders.

· Implemented statistical analysis and time series forecasting techniques, resulting in a 40% reduction in error compared to other models.

· Contributed actionable insights for risk management within the cryptocurrency mining industry based on predicted hashrate variances, employing data science skills.

Education

Northeastern University
Boston, MA

Master of Science from Analytics
09.2021 - 09.2023

University Overview

A Master's in Data Analytics program develops proficiency in a range of skills and technologies crucial for success in the field. I was able to gain expertise in statistical analysis, data visualization, and predictive modeling in addition to proficiency in programming languages such as Python, R, and SQL. The program also covered machine learning techniques, data mining, big data technologies (like Hadoop and Spark), and tools for data manipulation and analysis (such as Tableau or Power BI). Practical experience in handling real datasets, employing analytical tools, and communicating insights effectively was emphasized and focused throughout the program. I definitely have emerge equipped with a comprehensive skill set to tackle complex data challenges in diverse industries.

Brihan Maharashtra College of Commerce

Master of Business Administration (MBA) from Operations Management
Jun 2018

University Overview

An MBA in Operations Research cultivates a robust skill set in analytical thinking and strategic decision-making essential for streamlining business operations. I have developed proficiency in applying mathematical and statistical techniques to optimize processes. The program emphasized skills in quantitative analysis, data modeling, and simulation, empowering to solve complex business problems. Moreover, I was able to gain expertise in utilizing software and technologies such as mathematical modeling software, statistical analysis tools (e.g., R), and data visualization platforms. Case studies, practical projects, and industry applications are integral to the curriculum, have tremendously ensured me for careers in Technology, Operations management, Retail, Finance, and strategic planning, equipped with the practical skills to enhance operational efficiency in various industries.

Pune University

Bachelor of Science from Mechanical Engineering
May 2016

University Overview

A Bachelor's in Mechanical Engineering program offers a diverse skill set and familiarity with various technologies crucial for success in the field. I have gained expertise in subjects such as mechanics, thermodynamics, materials science, and design principles. The curriculum included proficiency in utilizing engineering software (e.g., CAD, MATLAB) for design and analysis, as well as exposure to emerging technologies like 3D printing and computer-aided simulations. Moreover, I was able to develop practical skills through hands-on projects, learning to analyze, problem-solve, and design mechanical systems and finally emerged with the ability to apply my knowledge to industries such as automotive, aerospace, manufacturing, and energy, ready to address complex engineering challenges and contribute effectively in these dynamic sectors.

Certification

  • CISCO - Data Analytics Essential (2023)
  • Interact with Tableau Dashboards and Reports (2023)
  • CISCO - Introduction to Data Science (2023)
  • AWS - Introduction to Compute, Storage, Database (2023)
  • Alteryx - Machine Learning Foundation (2023)
  • CISCO - Python Essentials (2023)
  • CISCO - Cyber Threat Management (2023)
  • IBM - Cloud Professional Architect (2023)
  • Foundation Micro Credentials Certified – Alteryx (2023)
  • LinkedIn - Introduction to Data Science
  • University of London - Introduction to Virtual Reality (2021)
  • Washington University - Machine Learning Foundations (2021)
  • Google Certified- Google Analytics for Beginner (2021)
  • Google Certified- Advanced Google Analytics (2021)
  • Certification in AWS Cloud Practitioner (2020)
  • AWS Technical and Business Professional (2020)
  • Certification in IBM- Introduction to Data Science (2020)

Affiliations

Active Volunteer Boston Athletic Association (2021-2022)

  • Coordinated pre-race events: youth activities, shirt/bib pick up, and distribution of food and beverage products for runners.
  • Assisted in the set-up and management of various facilities at the Start/Finish area, managing entrances and exits for athletes, press, spectators, and elite athletes.
  • Supported sustainability efforts by guiding spectators to appropriate locations for discarding items and ensuring immediate sorting of waste.
  • Provided assistance to spectators regarding sustainability initiatives and waste management.
  • Established and managed the setup of medical equipment and offered medical assistance to runners during the event.

Community Engagement coordinator - Brookline Mutual Aid (2021-2023)

  • Collaborated with community members to strategize and allocate resources for fulfilling needs like food, housing, medical care, and disaster relief.
  • Assisted in the development and implementation of a mutual aid plan to support emergency situations, working in conjunction with local organizations.
  • Administered and coordinated the execution of the mutual aid plan to address immediate community needs during crises or disasters.
  • Supported and engaged in emergency response efforts by leveraging local resources and community networks to provide aid where necessary.

Timeline

Technology Risk Analyst

Fidelity Investments
09.2023 - Current

Data Analyst, Co-op

Fidelity Investments
01.2023 - 06.2023

ITS People Data Analyst

Northeastern University
10.2022 - 09.2023

Budget Analyst

Northeastern University
02.2022 - 04.2022

Northeastern University

Master of Science from Analytics
09.2021 - 09.2023

Data Analyst

British Petroleum, Global Business Service
01.2021 - 08.2021

AWS Cloud Data Engineer

Amazon Web Services, AWS
03.2019 - 01.2021

Retail Business Associate (Operations)

Amazon Development Center India Pvt. Ltd
10.2017 - 03.2019

Brihan Maharashtra College of Commerce

Master of Business Administration (MBA) from Operations Management

Pune University

Bachelor of Science from Mechanical Engineering
AMIR SHABBIR SHAIKHTechnology Analyst