Sparsh Bijawat

214-***-**** adly93@r.postjobfree.com https://www linkedin.com/in/sparshbijawat

EDUCATION

The University of Texas at Dallas May 2018

M.S, Information Technology and Management GPA 3.5 Rajasthan Technical University, Kota, India June 2014

B. Tech, Electronics and Communications GPA 3.2

TECHNICAL SKILLS

Certifications: Udacity Nano Degree Data Science, Data Analytics-R, Python, Machine Learning, Power BI, MS Excel

Analysis Tools: MS Excel, Tableau, Web Intelligence Tool, Universe Design Tool, PyCharm, RStudio, Macros

Programming: R, Python, Pandas, NumPy, Seaborn, Ggplot2, Matplotlib, Regressions, Machine Learning

Software: SAP CRM, Microsoft Office Suite, SAP Business Objects, Information Design Tool

Databases: MongoDB, MS Access, MS SQL Server, ER Win

Project Management: Jira, SharePoint, Visual Paradigm, Microsoft Project, Edraw Max

Other: Web Crawling, Hadoop Stack, Data Warehousing, Linux, Google Analytics

BUSINESS EXPERIENCE

DNV GL, Okemos, US Aug 2018-Present

Data Analyst

Forecasted site-level consumption using predictive models such as logarithmic, linear regressions and random forest

Automated reports for batch processing across large datasets using R, Python, and MS SQL Server

Designed and implemented process improvement tools to reduce work hours by 24% and increased the efficiency of the team by 30%. Tracked progress of project deliverables and timelines using JIRA and batch processing tools

Managed and enhanced Small Business Energy Efficiency Program by constructing SQL data queries, reporting, analytical dashboard creation, and solved ad-hoc user issue requests using JIRA ticket management system

Performed quality assurance data analysis checks to ensure the accuracy and defensibility of the analytical products

Interpreted the results of data analyses to produce concise, meaningful conclusions and recommendations for client-facing reports and professional papers for external and internal business stakeholders

Nuway Solutions LLC, Plano, US June 2018-August 2018

BI Analyst

Transformed data using DAX functions and external data connections like web, CSV, Excel, SQL Server, Azure Blob Storage, Azure Database to create pipelines to ensure data flow and maintain dynamic row-level security

Designed actionable reports and dashboards using visualizations such as Power KPI matrix, Stacked bar, Clustered Bar, Donut, Waterfall, Gauge, Tree-map, Pie charts, Heat-maps, Histograms, Box-and-whisker plots, etc.

Streamlined data flow and automated scheduling various reports in Power BI like Tabular Models

MMI Inc., Dallas, US July 2017- August 2017

IT Analyst Intern

Optimized data collection through Python for competitive analysis using advanced Excel-like VLOOKUP, VBA, Solver

Consolidated data for price cost analysis in local ERP tools like Seller Cloud to run competitive intelligence on products

Maintained data dictionary by revising and entering definitions for user reference and data governance

DevU.in, Bangalore, India August 2015-August 2016

Business Development Analyst

Created reports on Client interaction, Business Analysis, and Requirement Gathering, and Web Content portfolio

Extracted, transformed, and analyzed datasets to generate reports using python libraries such as Pandas, NumPy, SciPy, Requests. Implemented decision trees and clustering to rank top 5 best clients of the region

Cognizant Solutions, Bangalore, India April 2015 - July 2015

Program Analyst Trainee

Designed and modeled database solution in MS SQL SERVER 2016 for APB Hotel Database Project

Constructed complex SQL queries integrating PLSQL procedures & functions for report generation outcomes

Designed ER and dimensional models using MS SQL SERVER, MS Access, Erwin, SAP BO, Webi, IDT, UDT

Antz Age Pvt. Ltd, Delhi, India July 2014 - March 2015

Jr. Business Associate

Prepared a project-level analysis and design for e-learning training process for web and mobile platforms

Developed a project charter, scope Statement, and Work Break Down Structures (WBS) to manage the timeline. Created class, use case and sequence diagrams, control objects, test strategy cases to improve project functions

Contact this candidate