Data Sql Server

SHEBA REDDY KOTA

Phone No: +1-551-***-**** Email: *******@*****.***

SUMMARY:

Seeking a full-time position as a Database Analyst/ BI Analyst which would allow me to execute the technical, analytical and lucid communication skills gained from academic and professional experience to prove myself

Two years of experience as SQL Developer in Database Design, Development and support of Microsoft SQL Server for various business domains like Financial Services and Health Care

Experience in (DDL and DML) constructing Tables, Normalization techniques on database Tables using SQL.

Experience in using Sub-Queries, Joins, Merge Statement for complex queries involving multiple tables.

Basic Knowledge in Testing Methodologies like Unit Testing and System Testing

Also, have knowledge in Amazon Web Services(AWS) in building clouds

Expert in implementing the methodologies like Agile using Scrum and Test Driven Deployment

Strong communication & collaboration skills with proficiency in grasping new technical concepts quickly.

Self-starter always inclined to learn new technologies and Team Player with very good communication, organizational and interpersonal skills.

WORK EXPERRIENCE:

Integra Technologies LLC – SQL Developer February 2017 – August 2017

Developed complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related subqueries, Complex joins.

Used ETL to load the data from the source file.

Performed Data loading, Validation of data, Data mapping, Data transformation.

Involved in Data matching algorithms, Data warehousing like Star Schema, Snowflake Schema.

Deployed database application schemas and releases. Also, created users and maintained them.

Created and modified Functions, Indexes, Synonyms, Linked Servers.

Worked on SCRUM AGILE methodology with two-week iteration.

Performed analysis and reporting using Power BI and Tableau.

Graduate Teaching Assistant January 2016 – December 2016

Developed scripts in SQL which transforms the data based on the requirements.

Analyzed the data and report them using reporting tools like power BI and Tableau.

Developed and maintained website and database which consists of 20000 students’ information.

Monitored student’s academic, cooperative & behavioral performance, then reporting the progress

Developed overall technical strategy and documentation for projects from technical requirements

Took feedback from students in the form of informal assessments administered several times in a semester

Satya Technologies - Software Engineer Intern September 2014 to May 2015

Created tables, views, indexes based on the requirement of the project.

Worked on project documentation and updating changes in the project schema.

Created presentation, documentation for new projects which helped me in understanding the schema and the data in depth.

Enhanced my knowledge in working with Microsoft Excel.

Telecom Technology - Trainee August 2014 – September 2014

Implant training in Digital switching systems – CDOT, PCM, CAS, CCS7, broadband, DSL technology, OFC station, GSM, CDMA Technologies, Mobile communication principles, SDH, DWDM, Cellular data transmission

Jawaharlal Nehru Technological University January 2013 – August 2014

Teaching Assistant & Lab Coordinator

Maintain student data, schedule exams, provide data security.

Helping 120 students in their projects and lab assignments, helping professor with his experiments.

Correcting assignments, mid-term papers, conducting quiz, taking classes in the absence of professor

EDUCATION:

Fairleigh Dickinson University August 2015 – December 2016

Master’s Degree - Computer science GPA – 3.5

Course: Computer networks, Programming for the internet, Software Engineering and Data Structures in Assembly Language, Distributed Database systems, System programming, Operating system

Jawaharlal Nehru Technological University August 2011 – May 2015

Bachelor’s Degree – Electronics and Communications GPA – 3.6

Course: Java, Computer programming and Data Structures, Probability theory and Stochastic process, Computer Organization, Object Oriented Programming, Computer Networks, Digital Signal Processing, Control systems.

TECHNICAL SKILLS:

Languages : C, C++, SQL, JavaScript, C#, Python and HTML

RDBMS : MySQL, Microsoft SQL Server, Oracle, PostgressSQL/RedshiftDB2

Tools : Adobe Photoshop, Eclipse, Visual studio, GitHub, Brackets, MATLAB UXPin, Excel, Visio, Erwin

Operating Systems : Microsoft Windows, Apple Mac OS X

Reporting & Analytics:

SQL Server Reporting Services(SSRS), Power BI, Tableau

ACADEMIC PROJECTS:

Developed an application to retrieve data from files and save it in the Excel sheets

Application was built for Oil projects company where the machine and on-field reading are updates in a server

The Data is retrieved from the server and stored in the database in the form of excel sheets for future reference

It is developed using Java, SQL, Microsoft Excel, DB2 and is implemented in the company.

Library Management System (SQL, ETL)

Created a database to store the information of each user as object.

Validated user’s details before issuing books.

Maximized productivity and system efficiency while searching for books.

Swipe-in/ Swipe-out scanning system

Developed a Swipe-in/ Swipe-out scanning system to track employees entrance and exit from workplace

Applied JavaScript, C#, and SQL to successfully accomplish tasks.

Tested on database of about 43,000 student data at Fairleigh Dickinson University and was successful

Discussion Board

The Discussion Board is used to post questions with description and topic name for any user

The users can view, comment, like, save, share the post

Technologies like PHP, CSS, SQL, XAMPP are used to develop the project

Online Shopping Application - Ecommerce

Developed E-commerce web application where the user can register and shop online.

Implemented a WCF web service to authenticate the user and used Session state variables to handle the shopping cart of a user.

Developed the user interface using Razor engine, JavaScript, and HTML.

HTML5, CSS3 Animations

Utilized HTML5, CSS3 and created moving animations without the use of JavaScript.

Applied CSS3 properties like 2D and 3D transformations to elements.

Wireless Control Robot using TV Remote

Developed a methodology of robot direction system for robotics to control and achieve accurate direction for nonlinear systems in the presence of disturbances by using wireless communication technique.

We track the robot by using wireless communication and give the directions using TV Remote. Implemented by using Embedded C.

Design, Fabrication, and Investigation on Yagi Uda Antenna

The Yagi Uda Antennas are designed, fabricated, and tested for performance based on different cross section and arrangements and the results were observed for the 5 and 3 elements.

Developed an automated system to measure the performance of antennas.

Contact this candidate