SHIVANJLI BHARDWAJ

ac2ci7@r.postjobfree.com https://www.linkedin.com/in/shivanjli-bhardwaj 801-***-****

EDUCATION

Master of Science in Information Systems GPA: 3.90/4

University of Utah, Salt Lake City, USA Graduation Date: August 2017

Graduate Teaching Assistant for the courses: Stats & Predictive Analytics, Data Mining

Coursework: Product Management, Business Intelligence, Cloud Computing, Data Warehousing, VBA.

Certification: MCSA SQL Server 2016 (Querying Data with Transact SQL - 70-761)

Bachelor of Engineering in Computer Science GPA: 3.9/4 (July 2013)

TECHNICAL SKILLS

Programming Language: C++, C#, Java, SaaS

Data Warehouse: Pentaho, Amazon - Redshift, S3, ETL

Data Visualization: Tableau, Micro-strategy, R Shiny

Statistical Programming:

R, Python, Hadoop(Basic)

Database Languages: SQL, PostgreSQL, T-SQL (SSRS)

Web Development: PHP(Basic), HTML5, CSS, JSP

WORK-EXPERIENCE

Technical Business Analyst Intern, Eccovia Solutions May 2017 - August 2017, Salt Lake City, Utah

Designed SQL reports and Client Forms with the Implementation Team to deliver better client-solutions.

Analyzing Client’s requirements and building Client-Forms & Reports using Report Builder tool (SSRS).

Communicate with Clients, Project Managers and internal teams to deliver product’s functional requirements.

Working with the Implementation Team. Responsible for data migration and integration using SSIS and SSAS.

Business Intelligence Analyst Intern, ConnexionPoint January 2017 - May 2017, Salt Lake City, Utah

Assisted the Data Warehousing Team in the designing the Database Architecture for a new project.

Evaluated the Dimensions, facts and measures from raw data. Wrote complex SQL queries to manipulate data.

Implemented ETL techniques using R - extraction, merging, filtering, validation and data loading into data lake.

Worked with Data-Science team in data transferring from multiple MySQL databases to HDFS environment.

Created Tableau reports and dashboards to visualize the trends and patterns of the Warehousing data.

System Business Analyst, IBM August 2014-September 2015, Bangalore, India

Analyzed the critical data for three major US clients. Data contained 1200+ customers on 500+ AIX, UNIX servers.

Contributed in successful transition of a new account “ACE” and Honored with Employee of the year award.

Improved business process and enhanced working efficiency by 40%, providing detailed solutions to customers.

Managed SLA/SLO (service level agreement/service level object) for thousands of customer data sources.

Experienced in issue and project tracking software. Worked on ARS (Action Request System) Ticketing Tool.

Worked closely with the Project Management team and attended project meetings, audits with the team.

Analyzed business requirements as they relate to the ETL processes and recommend alternative solutions.

Created dashboards, visualizations and reports for the project. Aided Clients in project audits, business meetings.

ACADEMIC PROJECTS

Geospatial Analysis of Salt Lake City’s Crime Data

Used clustering (K-Means, K-Median, Spectral, etc.) to figure out critical crime areas in Salt Lake City.

Grouped different of regions in SLC into clusters representing Low, Moderate and High-Risk Zones.

Data Visualization and Dashboard Design

Built the dashboards on UK Bank’s data and created visualizations (using Tableau 10.2).

Pulled the data insights according to the bank distribution in each city.

Advanced Regression Techniques to Predict House Price on Kaggle

Developed a Regression Model to Predict the house prices of the Ames house dataset.

Compete with Kaggle teams and achieved an overall rank 45 with Kaggle score 0.15.

Data Warehouse Implementation Using Amazon Redshift

Built a Data Warehouse from scratch for an Online Retail Store on the Amazon Redshift platform.

Analyzed transaction data to figure out most profitable market regions for the given retail store.

CAPSTONE PROJECT (Market Analytics): Technologies Used - R, R shiny, MYSQL

Built a predictive model to estimate the housing rents & occupancy rates of different properties in USA.

Visualized property data on an interactive application built using capabilities of R-Shiny and Leaflet packages

Contact this candidate