Harmeet Lamba

I'm a Data

About

Business Technology Solutions Associate @ ZS working side by side with clients, leveraging analytics, technology, and strategy to create solutions that work in the real world. Passionately committed to helping companies and their customers thrive, which drives better business results.

Business Technology Solutions Associate at ZS

Ensuring business value by leveraging data, technology and user experience.


  • LinkedIn
  • GitHub
  • Tableau
  • Acclaim
  • City: Los Angeles, California
  • Degree: Master of Science
  • Email: hhlamba@syr.edu

Total Experience of 4+ years that consists of all the below experiences:

  • 3+ years of work experience in the Insurance industry, data reporting, and software development
  • 2+ years of developing BI solutions and empowering data-driven decisions
  • 1+ years of teaching and mentoring students as a Graduate Teaching Assistant at School of Information Studies, Syracuse University
  • 5+ Dashboard solutions deployed
  • Fabricated 4 ETL pipelines for Data Warehouse and BI solutions

Skills

Tools & Services

Microsoft Excel 100%
Tableau Desktop / Tableau Prep 95%
SAS Studio 90%
MS SQL Server / PostgreSQL / MySQL 90%
Power BI 80%
GitHub 80%
SSIS / SSAS / SSRS 80%
Google Analytics 80%
Alteryx 75%
Microsoft Access 75%

Languages & Concepts

SQL / PL-SQL / T-SQL 100%
Python 95%
SAS 90%
R 80%
Exploratory Data Analysis 80%
Dashboarding & Data Visualization 90%
Extract Transform Load (ETL) 85%
Machine Learning 80%
Data Warehousing 75%
Data Mining 70%


Resume

Career Summary

Harmeet Lamba

Data professional with a focus in Business Intelligence and Data & Analytics, Data Warehousing, ETL, Machine Learning, and Data Visualization. 4+ experience in data reporting & analysis with expertise in SQL, Python, SAS, Excel, Tableau, and Power BI, with experience in stakeholder interactions.

Education

Master of Science (MS), Information Management

Syracuse University, Syracuse, NY

Relevant Courses: Business Analytics, Data Visualization, Data Warehouse

Certificate of Advanced Study (CAS), Data Science

Syracuse University, Syracuse, NY

Relevant Courses: Data Analytics, Statistics for Decision Making

Bachelor of Engineering (BE), Computer Engineering

University of Mumbai, Mumbai, IND

Relevant Courses: Big Data Analytics, Data Mining, E-Commerce, Distributed Systems, Cloud Computing

Professional Experience

Business Technology Solutions Associate

2021 - current

ZS, Los Angeles, CA

  • Business Technology Solutions Associate working side by side with clients, leveraging analytics, technology, and strategy to create solutions that work in the real world.
  • Passionately committed to helping companies and their customers thrive, which drives better business results.

Information Systems Consultant

2020 - 2021

iConsult Collaborative, Syracuse, NY

  • Convert user stories to granular technical requirements
  • Collaborate with cross-functional teams to brainstorm requirements
  • Ensure client's compliance with national standards through KPI evaluation and monitoring

Business Intelligence Analyst

2019 - 2020

iConsult Collaborative, Syracuse, NY

  • Identify & evaluate KPIs to track the department's performance
  • Create dashboards to help gain a holistic view of the organization
  • Present insights to the department officials and recommend strategies to ensure the organization complies with national standards

Associate Professional Product Developer

2015 - 2018

DXC Technology, Mumbai, IND

  • Led a team of 7 through a mission-critical development and ensured error-free deployment
  • Fabricated automated SQL scripts to generate monthly & yearly financial reports
  • Created department-specific report extractions reducing 40% information retrieval time

Certifications & Badges

Certifications are a stamp of excellence and Badges are an honor of knowledge. Below are a few of my accomplishments that mark the cornerstone of my career. You can find all of my certifications on my Acclaim Profile.

  • All
  • Certifications
  • Badges

SAS Certified Specialist : Base Programmer

Certification

AWS Certified Cloud Practitioner

Certification

SAS Essentials 1

Badge

Tableau Analyst

Badge

Hackerrank Python Gold

Badge

Tableau Desktop Specialist

Certification

Hackerrank SQL Gold

Badge

Google Analytics

Completion Certificate

Tableau Data Scientist

Badge

Portfolio

  • All
  • Reporting
  • Data Analytics
  • BI Dashboards and Viz
  • Machine Learning

Retail (POS) and Customer Analytics

Dashboards and Visualizations

People Analytics App

Analytics & Machine Learning

Trend shift in Music Industry

Dashboards & Visualizations

Clinical Trial Reports

Data Reporting using SAS

NYC311 - Issues in the Borough

Tableau and Power BI Viz

Retail Analytics using PowerBI

PowerBI, Data Warehouse & ETL

Bank Sub-Broker and Active Trader Services (ATS) reports

Data Reporting using SAS

Digit Recognizer

Machine Learning

Loan Eligibility Prediction

BI & Reporting

ETL Pipelines using SSIS

SQL, Data Warehouse & ETL

Personalized Stock Market Portfolio

BI & Reporting

NBA Injuries Hotspots

Dashboards and Visualizations

Password Strength Analysis

Data Analytics & ML

What can I do?

BI Dashboards

Create user-friendly dashboards on major platforms such as Tableau & Power Bi

Data Analytics

Uncover Insights through data preprocessing, distribution analysis & statistical significance

Machine Learning

Develop robust ML models and tune them for better predictive power

Data Reporting

Develop easy to digest reports using reporting tools such as SSRS, SQL, SAS, et cetera

Extract, Transform & Load

Create re-runnable scheduled ETL data flow packages using SSIS and SQL

Data Warehousing

Manufacturing data warehouses and OLAP cubes to store and analyze data

Testimonials