SHIVA CHEKURI
Northridge, CA
*********@*****.***
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