Data Analyst Resume CA - Hire IT People

SUMMARY

Over 3+ years of experience in data analysis, customer behavior analysis, operations, web analytics and building analytical tools and reports.
Exclusively worked on data visualization, reporting, forecasting, building regression and classification models

TECHNICAL SKILLS

Programming: Python, R, JavaScript, SQL Queries, VBA, SAS, Linux Scripts, Hadoop, Hive

Data Warehouse: Snowflake, Oracle, My SQL, Hadoop HDFS, Hive, Big Query, Talend, Informatica, PL/SQL, Teradata

Cloud Technologies: AWS EC2, AWS Sage Maker, AWS Redshift, Google Cloud Platform, GCP Big Query, GCP Auto ML, GCP DataFlow, Amazon Web Service

BI Tools: SSIS, SSAS, SSRS Data Studio, Tableau, Looker, Power BI, Matplotlib

Analytics Tools/Libraries: Google Analytics, Google Sheets, Excel, NumPy, Pandas, Scikit Learn

PROFESSIONAL EXPERIENCE

Confidential, CA

Data Analyst

Responsibilities:

Worked exclusively for Strategy & Planning, People Operations, and Budgeting.
Automated Quarterly reports and Budgets forecast model for People Operations using SQL and Tableau Server
Organized, extrapolated, and disseminated data across departments, used for drawing conclusions about the success of current methods and policies.
Developed a dashboard to track Remote On - Boarding during COVID and Client Management using python scripts, SQL, and Tableau Server
Designed and developed database models for the operational data store, data warehouse, and federated databases to support clients.
Created Hive tables and worked on them using Hive QL
Importing and exporting data using Sqoop to load data to and from Teradata to HDFS on regular basis

Tools and Environment: SQL, Python, Tableau, Big Query, Google Cloud Platform, REST API, Data Flow, NumPy, Pandas, Matplotlib

Confidential, OH

Data Analyst

Responsibilities:

Developed analytical tool to reduce and optimize energy utilization by performing data analytics and statistical analysis on IoT data and energy transmission data.
Developed real time analytical dashboard to measure, estimate and forecast energy utilization across all facilities in the University, in order to optimize and reduce energy utilization.
Automated data collection from variety of data sources, data cleaning, organizing and preprocessing
Improved data retrieval rate by establishing data warehousing technics, and ETL pipelines

Tools and Environment: Python, R, MySQL, Tableau, Excel, VBA, S3 Buckets, AWS RedShift

Confidential

Data Analyst

Responsibilities:

Involved in all phases ofdataacquisition,datacollection,datacleaning, model development, model validation, and visualization to deliverdatascience solutions
Worked closely with marketing and product teams to build customer behavior analytics- tracking customer engagement, churn prediction models and Lifetime-Value models
Performed data management projects and fulfilled ad-hoc requests according to user specifications by utilizing data management tools like Python, SQL, and Google Sheets
Closely collaborated with sales and marketing teams for conducting A/B testing to improve and track sales from different channels, using tools like Google Analytics, Python, Tableau, and Big Query
Extracted data from Google Analytics and generated SEM reports to support effective campaigns
Generated campaign analytic reports, quarterly sales reports, and web analytic reports
Setting up and optimizing Google Analytics properties and views in line with current product structure

Tools and Environment: SQL, Python, Tableau, Big Query, Google Cloud Platform, Google Analytics