Sql Server Test Cases

SARBANI PAUL

**** ***** ******** ******, *** **** * Chicago, IL 60616 Mail: *******.********@*****.*** Phone: +1-312-***-****

OBJECTIVE:

Seeking a position that will benefit from communication, multi-tasking, leadership and time management skills and contribute effectively to the performance of the organization and make optimum usage of the opportunities.

EDUCATION:

Masters – Information Technology and Management (Aug 2014 – May 2016)

Illinois Institute of Technology (IIT), United States GPA: 3.66/4

Bachelor of Engineering – Electronics and Communication Engineering (Jul 2007- May 2011)

Vellore Institute of Technology (VIT), India GPA: 7.46/10

TECHNICAL SKILL SET:

Programming Languages:

C, Java, SQL, PL/SQL, Shell Scripting

Web Development:

HTML, Javascript, JQuery, CSS

Data Analytics :

Excel macros, R Scripting

Databases Management:

Microsoft Access, MySQL, SQL Developer, SQL Server

Tools

Visual Studio, Eclipse IDE, Selenium, HP QTP, MS Office, Tableau, SAS, R Studio

PROFESSIONAL EXPERIENCE:

SUMMER INTERNSHIP (Jun 2015 - Aug 2015)

TTX Company, Chicago

Role: Data Analytics Intern

Analyzing data using Tableau that fall outside the respective SPLC range of the geographic location and to correct it by determining the latitude and longitude of the place. This project aims at expanding company’s business. Generating reports to make the analysis easier and faster.

Analyzing the business requirement and helping the team writing complex SQL queries and to create views in SQL Server to determine the errors caused.

Wipro Technologies (July 2011- July 2014)

Role: Project Engineer

Roles & Responsibilities:-

I was responsible to design the front-end of the web page and was proactive in error fixing. Wrote test cases and executed the test scripts as per the client requirement.

Executed test cases written by manual test engineers and automated those test cases using Selenium tool. Involved in automation testing, as a single point of contact between the business analysts and manual test engineers. Wrote SQL queries to verify testing.

Responsible in requirement gathering and client interaction, Software Requirements Specification and business validation.

Replaced existing automated test cases that were developed using Selenium tool by Easy Automate Selenium (Wipro’s internal tool).

Illinois Institute of Technology (Aug 2015 - Dec 2015)

Role: Graduate Teaching Assistant

Course: Data Modelling and Applications

Roles & Responsibilities:-

Assist Professor in preparing class lecture material.

Clarify student’s doubts regarding project and course work.

Involved in correcting exam papers, assignments and projects.

ACADEMIC PROJECTS (Aug 2014 - May 2015)

Data Analytics

Cleaned the crude data and loaded into R Studio to make an analysis over the Statistics of Base Ball Tournament. Used 3 Dimensional Bar Graphs, Pie Charts to depict a pictorial representation in R. Based on current statistics, created a planner for the tournament which would be held next year by using a Google Prediction API.

Databases

Created a Grocery database using Oracle 12c by designing the Database Schema and Entity Relationship Diagrams. Queried the Database using the concepts of Joins and Sub Queries. Created Stored Procedures, Triggers, Packages in PL/SQL and used Cursors to join tables without using Joins.

Created a web form in Microsoft Visual Studio in which we established connections to SQL server and Oracle 11G. Upon clicking, data would be retrieved from the respective databases and displayed in the form of data grid view.

Java

Created an IT help desk e-ticketing system which dealt with raising new tickets, update, close, purge and re-open ticket operations by designing a Graphical User Interface.

ACADEMIC PROJECTS (Jan 2011& Feb 2010)

Automated control of room temperature and lighting:-

Worked extensively to design a sensor which aimed at saving the electricity consumption and also to prevent continuous monitoring required for adjusting the hospital room parameters.

Webpage design for college Tech Fest Rivera:-

Developed a webpage to keep track of the ongoing events that took place during the technical fest during under graduation and record the number of participants participating in each event.

SUMMER INTERNSHIP (May 2009 & Dec 2009)

Bharat Sanchar Nigam Limited (BSNL):-

I was exposed to the structure of Global System for Mobile Communication (GSM) and its evolution of mobile telephone system. Learnt about the GSM network elements.

Fibcom India Limited:-

Learnt how Synchronous Optical Networking (SONET) or Synchronous Digital Hierarchy (SDH) replaced Plesiochronous Digital Hierarchy (PDH) system for transporting larger amounts of telephone calls and data traffic over the same fiber wire without synchronization problems.

CERTIFICATION

Successfully completed the requirements for EMC Academic Associate, Information Storage and Management.

EXTRA CURRICULAR ACTIVITIES

oAttended CNGU Student Workshop conducted by MICROSOFT.

oAttended National Level Technical Symposium on Secure Computing organized by SUTHERLAND GLOBAL SERVICES.

oPlanned and managed a number of events at BIHAR MUSAHAR SEWA SANGH, an NGO which works for underprivileged where people strive for education and a healthy standard of life.

oOrganized a Wipro outreach event “Make a wish” for providing school students with gifts provided by employees.

Contact this candidate