SHIVA CHEKURI

Northridge, CA

217-***-****

ac1rns@r.postjobfree.com

EDUCATION

**** ****** ** ******* ** Computer Science

University of Illinois, Springfield, IL

**** ******** ** ***********, ****ialized in Information Science & Engineering

Visvesvaraya Technological University, Belgaum, India

PROFESSIONAL EXPERIENCE

Jan 2017 - Present

SQL BI developer

Denken Solutions Inc, Irvine, CA

Work closely with business users to congregate and comprehend requirements.

Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.

Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

Developed and created the new database objects like tables, views, index, stored procedures and functions, advanced queries.

Migrated 2005 SSIS package level projects to 2015 project level manually.

Used Pragmatic Works BI xPress to audit and test the packages.

Jan 2014 – Nov 2014

Data Analyst

Fourth Lion Technologies Pvt Ltd, Bangalore, India

Python developer in InstaVaani team which conduct rapid polling to measure the public sentiment to determine the social initiative.

Worked as Python developer to clean the data that has been collected, like finding null values and replacing with average, and finding supervised and unsupervised data.

Cleansing data generated from weblogs with automated scripts in Python.

Used regular expressions to filter the required data from the surveys.

Analyzing data by plotting graphs using Matplotlib.

Taking inputs from Data Scientist and Business Analyst to gather requirements and build development specification.

Identify questions that meet poll objectives, and got an opportunity to work with Business Analyst team.

Worked with Sample Design and Presentation Team to identify target demographics, though it’s not part of my job description. I got to learn some basic fundamentals of Business Analytics.

Helped to develop back-end of the companies web application using Python, Django for the access for the employees to the database.

Aug 2013 – Dec 2013

ASP.NET Developer, Internship

Supernal Technologies, Bangalore.

Worked as a ASP.NET Engineer to develop and build website for Bangalore Traffic Police.

Built Database backend systems including tables, views and stored procedures.

Alter existing .net applications including Windows Forms and Windows Services.

Assist with additional exceptional tasks as assigned.

Tools used: ASP.NET and My SQL.

PROJECT

2016 Data Science Essential: Data Analytics Making predictions using Random forest

The project aims to Annual number of AIDS deaths by Country.

Link for the project- https://github.com/rajuchekuri/AIDS-deaths-Project/blob/master/AIDS-deaths.ipynb

Performed data cleaning, prepping and finding missing values in a large data set.

Used machine learning techniques and scripting language – iPython (Jupyter).

Made predictions based on the data patterns and calculated ROC.

Used Pandas framework to import and work on huge data sets irrespective of format of the data. And worked better than excel in this project.

Plotted graphs to visualize the data using Matplotlib packages

Numpy was used to do mathematical calculations on data and to find the trends from the data, and used Linear regressions on train and test data for predictive analysis.

Implemented Machine-Learning to predict the future trends with p-value and this feature had huge impact on the finding the result in this project.

Databases

SQL Server Management Studio 2015, ETL., Oracle, MySQL

Programming

Python, IPython (Jupyter), R, SQL, java, C, C++, HTML, CSS, Django

Software

Tools

Microsoft Office (Excel, Word, PowerPoint, Outlook, Access), MS Visio, OpenOffice, WEKA.

Eclipse, WEKA and Jupyter

Operating Systems

Mac OS, Windows and Ubuntu

Contact this candidate