Sign in

Data Analyst Engineer

San Jose, CA
October 05, 2018

Contact this candidate


Ranjana Jain

Data Analyst


San Jose, CA

Professional Summary:

4+ years of technical expertise working on Relational databases, visualization tools, Oracle SQL, Python and Unix shell scripting.

Worked in telecommunication industry concentrating in network and subscriber data using various analysis and visualizing tools.

Hands on experience implementing dash boarding, data visualization and analytics using Tableau Desktop and server.

Experience in dashboard designing with large data volumes from data sources like SQL server.

Worked with BI (Business Intelligence) teams in generating the reports and designing ETL workflows on Tableau.

Good experience in writing SQL queries as per requirement.

Hands on exposure of using Sqoop for data ingestion in hdfs and hive on Cloudera Hadoop system.

Good hands on Python and completed various courses and done projects.

Used python data visualization libraries: Matplotlib, Plotly and Numpy for data computation.

Worked on python data analysis libraries Pandas, Sklearn.

Knowledge of machine learning models through coursework and current project.

Expertise in Excel with large amount of network and other data for troubleshooting and reporting purposes.

Working on documenting project flow and benchmarking various vision APIs against result.

Worked as engineer and trainer at the same time to train teams for usage of new tools and techniques.

Analyzed and resolved the incidents raised by the application users on priority (low, medium and high) through Enterprise support tickets.

Knowledge of Big data framework.

Technical Skills:

BI Tools

Tableau Desktop, MS Excel

Scripting Languages

Python, SQL, Hive, Bash


MS office, Google docs, JIRA, BMC Remedy, Bitrix


Oracle, My SQL Server




Windows, Unix, Mac


Agile, Waterfall

Academic Experience:

Data analysis – Citi Bike data visualization Project

Analyzed the most used bikes and stations. Suggestion to rebalance the bikes.

Set up, inspect and imputation of data using Pandas library.

Used matplotlib pyplot to describe data using histogram, boxplots.

Visualize patterns in age, speed, genders and days of weeks using bar graphs.

Riders and their activities patterns. Observed correlation using regression in age, gender and speed.

Observed popular paths using scatter plots by visualizing on area maps.

Big Data project- Customer engagement with brands

Analyzed customer engagement and behavior based on google ads for 10 random brands.

Load customer click stream datasets and google ads datasets in hdfs using sqoop.

Create hive queries to identify relationship between customer and google ad data.

Create dashboard to visualize customer behavior with respect to ad shown.

Mobile app Project Business plan

Working as Project manager and involved in multiple tasks starting from Initiation step.

Using Bitrix24 as for task tracking and collaboration.

Responsible for Business architecture and design, requirement gathering.

Responsible for Business requirement gathering.

Professional Experience:

Client: ZetaMetrics (Startup) Aug 2018 - Present

Role: Data Analyst


Involved in analyzing business requirements and prepared detailed specifications that follow project guidelines required for project development.

First phase of project. Acquiring data from primary, secondary data sources and maintaining databases.

Data preparation including public URL generation with correct labels to be fed in various vision APIs.

Manual acceptance of labels to get acceptable level of accuracy.

Writing standard of procedures.

Preparing and editing Python codes for result visualization and data preparation.

Working with UI development team for changes and updates in the interface.

Client: Ericsson Global India Pvt Ltd. Dec 2012 – Mar 2015

Role: Data Analyst


Examining the source system and data samples to determine the structure, content and quality of data.

Create, modify SQL queries, stored procedures and jobs.

Execute and maintain reports for external clients and internal support.

Converted existing BO reports to Tableau dashboards.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Identified opportunity to automate manual data pull.

Prepare dashboard using calculation parameter in Tableau.

Set up cron jobs for Shell scripts that run SQL queries.

Write and modify existing data ingestion scripts as per the requirement.

Client: Ericsson Global India Pvt Ltd. Jan 2011 – Dec 2012

Role: RAN Optimization Engineer


Worked on GSM/WCDMA/LTE for monitoring and analyzing network clusters.

Monitoring KPIs, Traffic, Alarms and Throughput on daily & weekly bases and analyzing the poor performance cells.

Audit the Network for license, parameters and features requirement.

Drive routes preparation, log collection and coverage analysis using TEMS Discovery. Recommending electrical and mechanical tilts for optimizing the coverage issue.

Analyzed propagation maps with tools like MapInfo for site candidate comparison, propagation and coverage review selection.

Rectifying Neighbor discrepancies, non-symmetrical Neighbor, PCI clashes.

Worked on LTE KPIs as RRC and RAB setup success rate, RAB drop rate, handover failure.

Implemented and installed new Ericsson Optimi tool: xNet Manager (ERCM) and xNet Healing (ERA). Involved in the initial data extraction, loading from databases.

Tools and Skills: Map Info, Tems Discovery, BMC Remedy, ITK, Google Earth, OSS RC, Moshell


Master of Science in Engineering 2016 - 2018

Bachelor of Technology in Electronics and Communications 2006 - 2010

Contact this candidate