KRISHNA GANDHI

216-***-**** ● ac1hcp@r.postjobfree.com ● www.linkedin.com/in/krishnag1993

PROFESSIONAL SUMMARY

Enthusiastic database administrator with Master’s Degree in Computer and Information Systems. Successfully deployed 4 projects with Oracle and MSSQL. Ability to work with Management and Analysis Skills on SAS Enterprise Miner and SAS Enterprise Guide for Project and Data Knowledge in the field of Security related to threats, risk and related solutions for each security problem. Recognized for having strong analytical, problem solving, and communication skills as well as being a team player. Additional skill including:

● Oracle 11.2.0 ● SAS (Enterprise Miner, Enterprise Guide)

● SQL Server 2010 ● Project Management

● Microsoft Office Access ● Java

EDUCATION

Cleveland State University – Cleveland, OH

Masters of Computer Science & Information Systems

(Business Analytics with Database Management), 2015 – 2017 GPA: 3.55/4

Gujarat Technological University- Gujarat, India

Bachelors of Information Technology (Database Management Systems), 2011 – 2015 CGPA: 9.11/10

SKILLS

Relational Database Management System (RDBMS): Oracle 11.2.0, SQL Server 2010, MySQL, Microsoft Access 2007

Analytical Tools: SAS Enterprise Miner, SAS Enterprise Guide, SAS, Microsoft Office Excel, Tableau, Teradata

Technical Tools: Microsoft SQL Server Management Studio, MySQL workbench, Oracle SQL Developer, phpMy Admin, Wireshark, Eclipse, Apache Tomcat, Virtual VM Ware, Microsoft Visual Studio, Microsoft office suite (Word, excel, PowerPoint, access, OneNote, Crystal Ball, Visio)

Programming Languages: Java, C, C++

Client Side Programming: PHP, JavaScript, XML, HTML5, CSS3

Operating Systems: Windows, Android, Linux

EXPERIENCE

Cleveland State University Cleveland, OH 06/16 to 05/17

Computer Lab Assistance

● Guided Students with their software and hardware installation and working issues

● Helped professors with their research and books searching

● Coordinated scheduling of students and teachers to maintain computer lab operations and activities.

● Maintained computer lab (e.g. instructional materials, application software, set up materials for daily activities etc.) for ensuring availability of equipment and programs to enhance the instructional programs.

● Troubleshoot malfunctions of hardware & software applications

Ketads Pvt. Ltd Gujarat INDIA 08/14 to 07/15

Database Developer

● Designed and ran custom SQL database queries

● Gathered user requirements and designed appropriate database solutions

● Tested system performance and database capacity to ensure requirements were meet

● Generating reports and spreadsheets detailing database changes and performance

● Trouble shoot system errors and performance issues

● Optimized and Maintained Legacy System

Ketads Pvt. Ltd Gujarat INDIA 01/14 to 07/14

Software Engineering Intern

● Worked on projects for developing a website with PHP and MySQL with all basic functionality

● Built website by using PHP and HTML concepts

● Created and maintained a User Interface component library with CSS, HTML and PHP

● Gathered user requirements to proposed appropriate database solutions

● Prepared and presented a final project report

● Worked with Quality Assurance to ensure product quality

ACADEMIC PROJECTS

1.Oracle Database System

● Installed and Configured Oracle 11.2.0 on windows platform

● Built a database base on project specifications and assigned privileges to each user

● Connected and Configured Oracle with SAS

2.Fleet Management System

● As team of 5 members with a role of team leader, we developed a user system with requirements specified by users

● Developed a basic diagram in the form of E-R Diagram, Sequence Diagram, Use Case Diagram that shows the role of each user with their requirement satisfaction specified by company

● Created basic design of database with all relations and backed up it. (Visual Studio, MySQL, Microsoft office Power Point)

3.Prediction of Donors

● The goal in this project was trying to come up with actual number of donors based on historical dataset

● The predictive techniques like Decision Tree, Regression, Neural Network are used to predict the actual number of donors in nearer future

● Performance from each node is compared and best method is selected to make the further prediction about number of donors. (SAS Enterprise Miner)

4.Customer Segmentation role in Big Data

● Try to give a clear difference between customer segmentation and Predictive Mining techniques

● Developed a model for both to decide which one is better. Built a graph that shows performance of each of the tool with user requirements

● Described a clear outline what is the difference between them, use of each of them with specifications and result. (SAS Enterprise Miner, Microsoft Excel with Statistical Tools, CART Analysis, Microsoft office word and PowerPoint)

5.Risk Analysis and Security Solution for Retail Industry

● Founded problems in retail industry that comes under security.

● Focused on historical and current security problems faced by retail industry with available solutions

● Use additional tools to predict the future security problems for retail industry and try to propose solutions to overcome that problems

CERTIFICATIONS

Business Analytic – Cleveland State University 05/17

● A certification of Business Analytic form Cleveland State University after completion of courses in SAS.

● Introduction to Business Analytic, Applied Business Analytics, Managing Database for Business and Strategies for Business Analytics are the course content of the certificate.

Certification of Achievement- Sardar Vallabhbhai Patel Institute of Technology 06/15

● Certificate for 1st rank in the SARJAN 2015-16(Project Demo) organized by Sardar Vallabhbhai Patel Institute of Technology

● Final year project combining Android, Linux and Java with a connection to database for E-patient Care and Monitoring qualified for SARJAN project demo participation.

Contact this candidate