Sql Server Computer Science

Ashok Reddy Kondapalli

908-***-**** ● ****************@*****.***

SUMMARY OF QUALIFICATIONS

Strong academic background in Information Technology as well as hands-on work experience

Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues

Tireless learning nature through which gained knowledge across multiple platforms.

Quickly learn and master new technology; equally successful in both team and self-directed settings; and proficient in a range of computer systems, languages, tools and testing methodologies

Outstanding research and analytical skills

Multi-tasking and able to work under pressure

TECHNICAL SKILLS

C, C++, SQL, MYSQL, Python, PHP, HTML, CSS, JavaScript, Oracle, Basic of Java& .Net

(SSIS, SSRS, SSAS), Tableau, Alteryx, PowerBI

Also have experience in ServiceNow tool

Database design, data backup and recovery system

System analysis, performance testing, security logs, account security maintenance

EDUCATION

Monmouth University, West Long Branch, New Jersey January 2017

Master of Science in Computer Science

Kakatiya University, Warangal, Telangana, India May 2014

Bachelor of Technology in Computer Science

Work Experience:

Monmouth University, West Long Branch, New Jersey January 2016-December 2016

Department of Computer Science, Graduate Assistant

Working with the Senior Vice President of the University on the University Catalogue. Responsible for revising curriculum information and updating course descriptions

Assisting undergraduate and graduate students in immigration matters.

Organizing cultural adjustment workshops, seminars, and social events.

Also worked under professor in academic projects through which gained coding experience in Python

Perform a variety of administrative tasks including preparation of Power Point presentations, data entry and analysis, web site development, collating marketing materials and presentations.

Provide assistance with event planning including supervision of undergraduate student workers

Supervise and tutor undergraduate computer labs

Assist faculty members with a research project; engage in literature searches

Assist faculty members with grading of student assignments

ACADEMIC PROJECTS

Coffee Shop Maintenance Database system: Developed a database for coffee shop to collect and store the details of customers, products and orders, tools used: MySQL workbench, SQL, PHP

Taxi Application & Maintenance system: Developed a database to collect and store the details of the driver, passenger and route options, tools used: MySQL workbench, SQL, PHP

Dice rolling simulator: this project involves writing a program that simulates rolling dice. When the program runs, it will randomly choose a number between 1 and 6. The program will print what that number is. It should then ask you if you’d like to roll again

to roll again. Tools used: python, PhP

Basketball Match Ticketing & Maintenance System: Developed a database for basketball match and stored the details of the audience, seating & discounts, tools used: MySQL Workbench, SQL, PHP

Customer Relationship Management System: Developed an application to maintain a relationship between the client and the customer, tools used: .NET framework, MS office, C.

Location Algorithm: wrote an algorithm to track the passage of a drone used in our group projects. Also performed testing on mobile application development project.

Professional Work Experience:

10X labs, Hyderabad, India June 2012 – Nov 2014

SQL/BI Developer

Responsibilities:

Created database objects such as Tables, Procedures, Functions, Indexes and Views utilizing T-SQL.

Implemented DML scripts to perform modification tasks such as Insert, update and Delete data in database tables.

Extensively implemented system as well as User-Defined functions to enhance the functionality of T-SQL code.

Implemented Dynamic SQL for user customizable queries to be answered by the SQL Server.

Created T SQL scripts for ad hoc requests from Business Analysts and Management.

Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.

Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.

Analyzed an ETL architecture for data migration from the OLTP to OLAP utilizing SSIS.

Analyzed complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SSRS.

Actively involved in gathering and analyzing requirements.

Implemented indexes, constraints and rules on tables for optimization of queries.

Used SQL Server Agent to create jobs, SQL Mail, Alerts and SSIS Packages schedule.

Created DTS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat files.

Contact this candidate