Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
SAMRA HAMID

SAMRA HAMID

New York,NY

Summary

Dedicated Senior Data Analyst with over 9 years of progressive experience in the fields of Business Intelligence, Market Research and Big Data Analytics spanning diverse sectors like E-commerce, E-learning, Tech Real Estate, Geospatial, and IoT Automation. Proven track record of leveraging data to drive strategic insights and informed decision-making. Proficient in data collection, analysis, and visualization techniques, with a deep understanding of transforming complex datasets into actionable recommendations. Skilled in utilizing advanced analytics tools and techniques to uncover trends, forecast market dynamics, and optimize business strategies. Adept at creating dynamic reports and dashboards that effectively communicate findings to diverse stakeholders, including senior management. Strong communicator with a demonstrated ability to collaborate cross-functionally and translate data-driven insights into actionable business strategies. Seeking to contribute expertise to an innovative team, driving impactful outcomes through data-driven solutions.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Sr. Data Analyst

AMP Agency, Advantage Solutions
08.2021 - Current
  • Working as Sr. Data Analyst with one of our largest client Zillow Group.
  • Started the projects from very beginning, understanding the requirements of the project by meeting with stakeholders.
  • Explored data thoroughly even when I didn't know where it was, proving that I can find and organize data effectively.
  • Developed Tableau & PowerBI dashboards to streamline and to empower stakeholder data self-service. Reduced ad-hoc requests and improved data accessibility.
  • Conducted ad hoc analysis and detailed modeling to surface opportunities for Zillow’s strategy and business.
  • Influenced key leaders in the business, product and data analytics using data driven insights.
  • Used advanced analytics with extensive experience in delivering solutions in the field of Omnichannel Marketing.
  • Used predictive modelling, A/B testing to forecast and analyze customer behavior in multichannel environments like Onsite-Messaging-Platform, Email and Paid Social.
  • Supported Marketing B2C and B2B teams by creating dashboards to measure revenue, lead conversions across multiple lines of business.
  • Analyzed and cleaned the data by querying into Hive data warehouse and fetching the output from social media platforms APIs.
  • Applied advanced analytics techniques and predictive modelling to inform CRM, loyalty, and lifecycle marketing strategies.
  • Worked on data analytics tools such as SQL Server, Presto, Google Big Query to perform day to day analysis and create underlying data sources for dashboards in Tableau & PowerBI.

Sr. Data Analyst (Business Intelligence)

Benchmark Education Company
05.2016 - 07.2021
  • Developed Reports & Dashboards: Created daily and ad hoc sales analysis and distribution reports using Tableau, PowerBI and SSRS for quantitative analyses.
  • Marketing Strategy Analysis: Engaged in technical marketing and statistical analyses, contributing to strategic marketing plans.
  • Data Analysis Expertise: Utilized Hive, Impala, and Apache Spark for data analysis, including sentiment analysis on large datasets.
  • Requirement Gathering & Documentation: Gathered business needs, documented requirements (BRDs), and designed system architecture in collaboration with stakeholders.
  • Data Consolidation & Visualization: Crafted queries for consolidating diverse datasets into visually comprehensible reports for stakeholders.
  • Automated Market Data Procedures: Engineered procedures to extract customer information from external market data, streamlining customer contact lists.
  • Thorough Market Research: Conducted comprehensive research on customers, contacts, prospects, vendors, and sales representatives.
  • Robust Reporting: Produced dynamic yearly, quarterly, weekly, and daily reports to guide strategic decisions.
  • Collaborative Software Development: Collaborated with development and DevOps teams, providing analysis, testing, and valuable feedback.
  • Efficient CRM Automation: Automated CRM & Marketing Database processes, managing over 800,000 potential customer records.
  • Workflow Optimization: Designed automated workflows for efficient case issue management.
  • Comprehensive Reporting: Generated reports catering to departmental as well as executive management levels.
  • System Documentation: Developed system documentation including ERDs, process descriptions, and materialized views.
  • NetSuite Customization: Designed custom searches, reports, and views within NetSuite to enhance data understanding.
  • ERP Data Enhancement: Enhanced data modeling, collection, and database management within ERP systems.
  • ERP Data Migration: Led data migration efforts to transition to new ERP system (NetSuite Oracle).
  • Data Accuracy Assurance: Verified copy correctness through data warehouse extraction for big data.

Adjunct Faculty

Monroe College
04.2017 - 04.2018
  • Instructed Database courses (SQL and NoSQL) to Undergraduate student.
  • Conducted workshops for Big Data Analytics and have trained students on HBase, Hive, Impala, Spark, and Kafka.
  • Organized and conducted laboratory works on Cloud computing on AWS and Big Data Training on Cloudera.
  • Trained students on Python Algorithms and Python ML Libraries.

Big Data Analyst

Rigmond Quantrial Pvt. Ltd
05.2014 - 04.2016
  • Worked on Ecommerce application which has over 200 million users classified geospatially.
  • Worked on statistical analysis which involved complex reasoning with various factor of consideration on each attribute information.
  • Worked in converting web application and mobile application which has SQL backend to Hive.
  • Impala Hybrid Backend on HDFS.
  • Worked with software architect for backend analytics.
  • Worked with R to generate KPI for large datasets.
  • Worked with Machine Learning Algorithms and libraries such as Numpy, Scipy, Panda, Keras.
  • Matplotlib on Python to train and test large volume of datasets Worked with NoSQL database for Ecommerce and Geospatial projects.
  • Worked with Teradata and Snowflakes for healthcare application.
  • Worked with NLP to generate graphs for performance monitoring and extract valuable information from voice data using spaCy.
  • Worked with IOT sensor data for Industrial automation project which needed real time dynamic reporting of machine data.
  • Worked with Excel and Power Bi and have generated models and relations for huge dataset to get required reports as graphs, data-tables and matrices.
  • Worked on getting statistical data from R script into the PowerBi environment.

Education

MBA - Information Technology

Monroe College
The Bronx, NY
3.89

Bachelors of Science - 3.42 - Accounting And Finance

Government College University
Lahore

Skills

  • BUSINESS INTELLIGENCE TOOLS: Tableau, Microsoft Power BI, SQL Server Reporting Services, SAP
  • BIG DATA ANALYTICS TOOLS: Cloudera, Hadoop(HDFS), Spark, Kafka, Alteryx, Snowflake, Google Cloud Dataproc
  • DATAWAREHOUSE: Hive, Impala, Google BigQuery
  • SQL DATABASES: MySQL, PostgreSQL, Microsoft SQL Server, Oracle Database, Presto, DataGrip, SQLite, Azure SQL Database, Google Cloud SQL
  • NOSQL DATABASES: MongoDB, HBase
  • DATABASE/DATAWAREHOUSE MANAGEMENT SYSTEM: Teradata, Snowflake, SQL Server Management Studio, MySQL Workbench, MS Access, Hue, phpMyAdmin, Robomongo
  • CLOUD PLATFORM: AWS (EC2, S3, LAMDA), Azure, BigQuery
  • ETL TOOLS: Informatica(PowerCenter), SSIS
  • PROJECT MANAGEMENT TOOLS: Jira, Workflow Rules, Reports, Dashboards, MS Project, Smartsheet
  • ERP SOLUTIONS: SAP, Sales Force, Netsuite(Oracle), Adaptive Insights (Workday Planning Solutions), Zoho
  • FRONTEND: HTML5, CSS3, BOOTSTRAP 3 & 4
  • LANGUAGES: JavaScript, jQuery, PHP, Python(Anaconda), R (R studio), Java(Eclipse)
  • MICROSOFT OFFICE TOOLS: MS Excel, MS Word, MS PowerPoint, Visio, Smartdraw
  • OPERATING SYSTEMS: Linux (Ubuntu, Red Hat, CentOS), Windows 10, Mac OS
  • HYPERVISORS: VMware, Oracle Virtual Box

Certification

  • Adaptive Insights - Product and Implementation (Cloud Based CPM)
  • Adaptive Insights - Customer Success
  • Adaptive Insights - Customer Support
  • Adaptive Insights - Sales
  • Sales Force Admin Training

Timeline

Sr. Data Analyst

AMP Agency, Advantage Solutions
08.2021 - Current

Adjunct Faculty

Monroe College
04.2017 - 04.2018

Sr. Data Analyst (Business Intelligence)

Benchmark Education Company
05.2016 - 07.2021

Big Data Analyst

Rigmond Quantrial Pvt. Ltd
05.2014 - 04.2016

MBA - Information Technology

Monroe College

Bachelors of Science - 3.42 - Accounting And Finance

Government College University
  • Adaptive Insights - Product and Implementation (Cloud Based CPM)
  • Adaptive Insights - Customer Success
  • Adaptive Insights - Customer Support
  • Adaptive Insights - Sales
  • Sales Force Admin Training

Similar Profiles

  • Kathleen Protz

    Kathleen ProtzKathleen Protz

    Administrative Assistant at AMP Insurance Agency & Consultancy, LLCAdministrative Assistant at AMP Insurance Agency & Consultancy, LLC

    View Profile
  • Thalia Navedo

    Thalia NavedoThalia Navedo

    Patient Care Associate at Amp Homecare Solutions LLCPatient Care Associate at Amp Homecare Solutions LLC

    View Profile
  • Brittany Ashley-Graser

    Brittany Ashley-GraserBrittany Ashley-Graser

    Insurance Sales Agent at Insurance Advantage Agency Llc.Insurance Sales Agent at Insurance Advantage Agency Llc.

    View Profile
SAMRA HAMID