Database Developer

DEEKSHA SINGH

**** **** **** ** **** Cleveland, OH 44114 +1-216-***-**** ****************@*****.***

SUMMARY

Experienced Database Developer/Data Analyst skilled in interpreting and analyzing data in a fast-paced environment.

Extensive experience in writing SQL queries, stored procedures, triggers, functions and views.

Ability to provide solutions for data analysis, coding, data collection and storage, preparing detailed documents and reports while managing internal and external data analysis responsibilities.

Proficiency in all aspects of Excel and Tableau, academic level experience of SAS University Edition.

Talented analytical thinker, proficient at identifying and resolving technical problems.

Ability to meet deadlines and handle pressure coordinating multiple tasks.

EDUCATION

Cleveland State University, Cleveland, OH Cumulative GPA: 3.67

Master’s in Computer and Information Science (CIS) Expected Graduation: May 2017

Hindustan College of Science and Technology, Mathura, India Cumulative GPA: 3.6/4.0

Bachelor of Science in Computer Science Engineering Graduated: June 2014

RELATED COURSEWORK

Relational Database Data Mining Big Data OOP’s with JAVA

Operating Systems Social Network Analysis Data Structures Software Engineering

TECHNICAL SKILL

Operating Systems: Windows, Linux, Mac

Languages: C, Core Java, C# .NET, R, SQL

T-SQL Queries: Stored Procedures, Triggers, Functions, etc,

Databases: MS SQL Server, Oracle, MS Access

Big Data (NoSQL): Hadoop, Hadoop Distributed File System (HDFS), Mongo DB

Tools: Eclipse, Microsoft SQL Server Management Studio (2008+), MS Office 365, Microsoft Visual Studio

Data Analysis Tools: R studio, Tableau, Microsoft Visual Studio – Extract, Transform, Load (ETL), Business Intelligence (BI) tools, Microsoft Analysis/Integration Services (SSIS), SAS University Edition

ENGINEERING EXPERIENCE

Parthenon Globalsystems LLC, Cleveland, OH, USA January 2017-Present

Data Analyst Intern

Working on 3 projects alternatively, Long Term Care (LTC) Software, Contract Management Software and BIP: Online Search Directory.

Examine data from OLTP databases & raw data from different sources, draw conclusions, discover potential areas of improvement, determine trends and patterns and report potential bugs.

Churn analysis of data received from different sources and in different format.

Involved in Data Management using SQL Server, import/export of data to/from SQL, writing SQL queries, stored procedures, views, functions and scripts to extract and populate data into different tables per different parameters.

Data Visualization, insight presentation, report design and dashboard creation using Excel, SQL and Tableau.

Coirfom (India) Pvt. Ltd., Faridabad, HR, India July 2014- March 2015

Junior Database Developer

Developed Java API utilizing MS SQL Server as per company requirements.

Coordinated with the management to discuss business needs and designed database solutions accordingly.

Involved in Import/Export of data to/from SQL, writing SQL queries, stored procedures, views and functions.

Assisted programmers in implementing code changes and server patches, troubleshooting system errors, and performance issues.

Bhartiya Computer Sansthan (BCS), Agra, India June 2013-August 2013

Summer Intern (Project: Electronic Publication)

Aim was to limit illegal copying, printing and sharing of e-books and documents.

Developed an algorithm to extract the unique ID related to a device and concatenated it with the e-books being

purchased by the customer.

With this implementation, the document failed to open, if it is transferred to someone else’s device, hence prevented illegal sharing of e-books.

Welkin Edu (subsidiary of Tata Consultancy Services), Agra, India June 2012-July 2012

Summer Intern

Trained and developed applications in Core Java on NetBeans and Eclipse IDE platforms.

Learnt basic Java features such as encapsulation, polymorphism, abstraction, etc. for efficient programming.

RELATED EXPERIENCE

Cleveland State University, Cleveland, USA June 2016-Present

Student Recruiting Assistant

Set up for Engineering recruiting events and speak with visiting middle or high school groups and provide hands-on demonstrations.

Assist with the management of prospective database, creation of department publications and forms related to the Fenn Academy and recruiting activities, tours for groups or individual students, mass mailings and telemarketing for the College of Engineering.

Outreached to large number of high school students and encouraged them to pursue one of the Engineering majors.

ACADEMIC PROJECTS

Sentiment Analyzer Spring 2016

Aim was to analyze and extract information from tweets, to forecast the presidential election & to predict a movie’s success.

Tweets were collected using twitter API and parsed the raw tweets to store useful data into database.

The result was based on the positivity and negativity hidden in the tweets.

Text Mining Using SSIS (SQL Server Integration Services) & Analysis Fall 2015

Created ETL package using Integration Services to extract the text file data, transform and load it to SQL Server.

Data obtained from Integration Services was used for Data Mining done using Analysis Services.

Analyzed how different mining algorithms can be applied to different data sets.

Twitter Message Data Transformation Fall 2015

Aim was to extract and analyze information from Social Networking Sites.

Downloaded Twitter data using R studio and parsed the raw data.

The data obtained in JSON format was stored in Mongo DB installed over HDFS and analyzed the Tweets over specific criteria (Data Mining queries) by writing Mongo DB queries.

Determined most trending topic, gender based comparison and other useful information.

SQL Query Optimizer Summer 2015

Aim was to simulate a SQL Query optimizer.

Wrote a module that choose the best query processing plan by iterating all the different join orders and join methods.

Evaluated query processing cost for a given SQL query and its optimized rewritten query.

Determined the best query plan, considering various join method and join order.

Relational Algebraic Query Handler Spring 2014

Aim was to execute Relational Algebraic (RA) statement.

Developed a Java application to convert RA statement into a SQL (Structured Query Language), which was executed on Relational Database Management System (RDBMS).

EXTRA CURRICULAR ACTIVITIES

Assisted in Game Design workshop in STEM event held at Cleveland Public Auditorium.

Participated in Manthan, a national level competition to tackle social issues in India.

Participated in the Microsoft Technovation Meet-Windows 8 Day.

Contact this candidate