Post Job Free

Resume

Sign in

Data Sql Server

Location:
Cleveland, OH
Posted:
August 25, 2017

Contact this candidate

Resume:

SUMMARY

* ***** ** ********** ** Designer and Developer with extensive knowledge in various web scripting technologies and database systems. Developed the database SQL Server, CMS based and Responsive Web Design applications to meet requirements. Expert in implementing technical solutions that definitively improve scalability and performance with time management and problem solving skills.

TECHNICAL SKILLS

Languages: C, C#, Java, ASP.Net, JavaScript, HTML5, XML, SQL, HQL

Microsoft Tools: Word, Excel, PowerPoint, Access, Outlook, Publisher, Microsoft SQL Server

Technologies: CSS3, Hadoop, MongoDB, Drupal(CMS), Hive, JQuery, AJAX

Operating System: IOS, Android, Windows, Linux

Other: SQL Server 2008/2012, Oracle 11g, Photoshop, Netbeans, Eclipse, Visual Studio, Dreamweaver, Fireworks, R-tool, MySQL, AngularJS, MVC, SSIS, SSAS, Bootstrap, Wordpress

PROFESSIONAL EXPERIENCE

Web Design & Research Specialist Cleveland State University (Dec 2015 – May 2017)

Using HTML/CSS, JSP, JQuery, PHP, Drupal, Adobe Fireworks, JavaScript, Dreamweaver, Photoshop and Microsoft Office for creating dynamic webpages of Levin College of Urban Affairs.

Updating weekly college news, faculty blogs, added event posts and created forms on college website using Adobe Creative Suite and have developed live site for Nonprofit Academic Centers Council using Squarespace.

Software Developer (Intern) Tata Consultancy Services (Dec 2014 – May 2015)

Using Spring, Hibernate, HQL, HTML, CSS, JavaScript, AngularJS, Java and MVC developed government projects.

Developed the Document Management System live for tracking, managing, storing and versioning automated documents for the Payroll, HRMS, e-office parts of the system.

Worked on the Front End for the layout using the Web Design and for Backend using the Database Service & MVC.

Web Developer (Intern) SMG InfoTech Solutions (Dec 2013 – Dec 2014)

Added new feature to the existing web application with the help of HTML, ASP.net/C#, CSS, AJAX, JQuery, Photoshop, Bootstrap and JavaScript and have provided data management to users.

Worked on the data transfer feature for database to engines for that project using the MySQL database.

Using the UI Interface and the web application elements designed the websites.

EDUCATION

Cleveland State University, Cleveland, OH - GPA 3.58 (May 2015 – May 2017)

Master's Degree Computer & Information Science

U. V. Patel College of Engineering, Mehsana, Gujarat – GPA 4.00 (August 2011 – May 2015)

B. Tech Computer Engineering

PROJECTS

SQL Query Analyzer & Optimizer (Feb 2016 – May 2016)

Using Java, SQL, join methods evaluated query processing cost and optimization of the rewritten query.

Performed minimum cost for query evaluation, query performance, optimization backup facility, logging the query and calculated the Disk I/O cost using different join methods for possible query evaluation plan.

Twitter Data Transformation using Hadoop, MongoDB and R-Tool (Aug 2015 – Dec 2015)

Using R-tool, No SQL System- MongoDB, Hadoop & Linux worked with real time tweets using API key and Access tokens and performed various data mining queries with each tweet field.

Performed graphs and charts on the live hashtags of tweets for analyzing some results.

Text Mining using SQL Server Integration Service (SSIS) & MS Analysis service(SSAS) (Aug 2015 – Dec 2015)

Using SSIS and SSAS performed the Term Lookup and Term Extraction by integration of data from multiple sources and then performed various Data Mining Algorithms on it.

Used mining data models for mapping the transformed data based on original data.

Data Mining Model using BI tool, Data Warehouse and OLAP Cubes (Aug 2015 – Dec 2015)

Building multidimensional data models using OLAP database for querying and reporting.

Designed cubes from the extracted data based on the star schema staging layer and performed the data mining for hidden patterns and information using DMX and MDX queries.



Contact this candidate