Post Job Free

Resume

Sign in

Data Sql Server

Location:
Chicago, IL
Posted:
May 30, 2017

Contact this candidate

Resume:

Ruthvik Jain J

+1-312-***-****, ac0jqj@r.postjobfree.com, https://www.linkedin.com/in/ruthvikjain

PROFILE SUMMARY

•Data Enthusiast with 3+ years of experience in Data Analysis, Application Design & Development

•Expertise in Python, SAS (Certified), Forecasting and Predictive Modelling, SQL, Big Data and Java(Certified)

•Drone and RC technology lover with intentions of being UAV certified Drone Pilot soon

EDUCATION

Master of Science, Management Information Systems Dec 2016

University of Illinois at Chicago, USA

Bachelor of Engineering, Electronics and Communication Jun 2012

NIE-Institute of Technology, India

SKILLS

Data Analytics: Python, SAS, R, IBM Watson Analytics, Spark(PySpark)

Databases: Oracle DB, SQL Server, MySQL, Mongo DB

Data Visualization: Tableau Desktop & Server, Bokeh, MS Excel

Tools & Utilities: Oracle SOA, MS Project management, Talend, Eclipse, Ipython, SVN

EXPERIENCE

Data Science Associate - Ativo Capital, USA Mar 2017 - May 2017

•Developed a forecasting model to predict cost to capital (COC) based on accounting parameters (Python)

•Designed a simulation frame work to predict portfolio distribution using Monte Carlo Simulation

•Created tasks & schedules to run predictive, forecasting models on weekly and monthly basis using Luigi

Data Science and Research Intern - Ativo Capital, USA May 2016 - Aug 2016

•Time series forecasting - predictive model to forecast portfolio returns using 10 years of daily returns data

•Built a regression model over price volatility to deduce trading opportunities (Scikit, Pandas, Numpy)

•Computed portfolio statistics against stock indexes and created a back-testing framework

•Created real-time interactive dashboards for portfolios using Information Coefficient & Factor Analysis (Tableau)

•Combined data from multiple data sources (Compustat & Xpressfeed) and corrected stocks data errors (T-SQL)

•Implemented proof of concept to test scalable analytical features in SQL Server 2016

Software Analyst - Accenture Services, India Feb 2014 - Jun 2015

•Developed segmentation model to provide solutions pertained to customer retention (SAS Enterprise Miner)

•Classified telephone customers based on monthly expenditure, data usage and plan subscriptions

•Designed reports to measure the effectiveness of promotion on new plans (PROC REPORT, PROC GRAPH)

•Collected data from five data sources and performed data analysis using SQL queries (Oracle, NoSQL)

Associate Engineer - Accenture Services, India Jan 2013 - Jan 2014

•Created workflows for monitoring the performance of project managers based on budget and deadlines

•Implemented fundamental mappings and documented operational run books for ETL operations

•Developed stored procedures, functions and triggers to support and monitor reporting frame work(PL/SQL)

Python Developer - Novell Software, India Oct 2012 - Dec 2012

•Reduced manual intervention by creating automation scripts for personality migration tool(Python)

ACADEMIC PROJECTS

Cognitive Application to Mentor Students (IBM Watson Analytics, Python, Google API)

•Designed a career counselling application for high school students using deep learning API’s of IBM Bluemix

Predict Defaulters for Credit Card Company (Apache Spark, Python, PySpark)

•Built predictive models to identify possible defaulters based on balance limit, billed amount, payed amount etc.

Classification of Products using Reviews (Python, NLTK, Pandas, Scikit, Kafka)

•Text analytics – Segmented a product into categories based on user comments and product reviews

Human Activity Recognition (TensorFlow, Recurrent Neural Network)

•Recognized various human activities like walking, standing using RNN and Long Short-Term Memory cells(LSTMs)

AWARDS & LEADERSHIP

Gold Miner Award at Accenture - Successfully handled a release in the absence of team lead

Star of the Term at Accenture - Mentoring the new team members



Contact this candidate