Test Cases Sql
Resume:
Nikhil Bharadwaj
Duluth, Georgia – 30096.
*********@*****.***
PROFESSIONAL SUMMARY:
Professional and highly motivated with 2+ years of Development and DBA work experience in the software industry with MySQL(4.x,5.x) and SQL Server 2014/2012/2005.
Experience with databases in excess of 1 TB, Database Administration, design, development, and maintenance and production support of relational databases, business applications, MySql/Oracle Server installation, upgradation, and migration.
Understands architecture of storage engines like innodb, MyISAM, and third party storage engines like Rocks Db for Mysql and MongoDb.
Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
Experienced to write SQL queries, views and procedures out of MS SQL using Microsoft SQL Server Management Studio, MS Access, MS Excel and other database tools.
Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle10g.
Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
Hands on experience working with databases like Oracle 11g/10g, MySQL, Mongo DB, Mongo Lab.
Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
Hands on Experience with JDBC and ODBC architectures.Good with Unix/Linux commands and usage.
Good knowledge in Design Patterns like MVC, Abstract Factory, Business Delegate, Singleton, Data Access Object, Front Controller, Session Façade and Service Locator.
Creating SSRS reports and SSIS packages using Visual studio 2008 R2 - Business Intelligence Development Studio. Created and updated campus housing database using Microsoft SQL
Experience in SDLC, Agile (SCRUM) Methodology, Iterative, Waterfall and Object Oriented Application Design and Programming.
Experience in web technologies J2EE, Spring, EJB’s, Servlets, JSP’s, JSP Custom Tags Libraries, Java Beans, JavaScript, Jenkins, XML, DHTML & HTML.
Exposure to Client side Java Script frameworks like Angular JS, HTML5, CSS3, JQUERY. Exposure to Server side JS framework Node JS, Express JS.
Ability to pick up new technologies based on prior training and used Open Source technologies & tools extensively.
2
Excellent communication skills, team player, quick learner, organized, resilient and self-motivated.
EDUCATION:
M.S. in Computer Science
B.S. in Electronics & Communications
TECHNICAL SKILLS:
Database: Microsoft SQL Server, MySQL, Oracle, DB2, MongoDb. Operating System: Windows, UNIX, Linux
Server based: Servlets, JSP, JDBC, Spring MVC, Web Services, Node js, Express JS Client based: JSP, HTML, XML, JavaScript, Angular JS Operating Systems: Unix/Linux(Ubuntu) /Windows 2000/XP/7/8/8.1 Application Servers: Apache Tomcat 6/7.
Database IDE’s: Percona, SQL ways wizard, Workbench (6.3/6.1.7/6.0), phpMyAdmin. Java/other IDE’s: NetBeans, Eclipse, Visual Studio. Other Technologies: ASP.NET, C#, Jenkins (Testing tool). Certifications:
Certified as Microsoft Specialist for Programming in HTML5 with Java Script and CSS3.
Certified as Microsoft Solutions Developer and Microsoft Certified Professional.
Honored as Upsilon Pi Epsilon (International Honor Society for the Computing and Information Disciplines) sorority member.
PAPERS:
POODLE attack against SSL v3
University of Central Missouri Fall 2015
Presented a paper discussing about the POODLE attack of October 2014 against SSLv3 and the vulnerabilities that caused it.
Prevent measures were cited to stop the occurrence of such events and also the important security lessons that could be learnt from this incident. PROFESSIONAL EXPERIENCE:
University of Central Missouri-- Project Jan 2016 – May 2016 This is a core processing application of Infynite-Goldminers which is a financial organization operating across the globe. It facilitates mutual trading among the customers subscribed to the organization. It facilitates in effective transaction, settlement & reporting for its clients. I am part of a team and I handled database administration in developing TSR application
(Transact-Settle-Report).
Responsibilities:
Created Process and persistence of the trades file received from Front office along with settlement details at client level.
Audit trail is maintained for each of the data persistence items. 3
Hard coded settlement of trades in different currencies based on client locations.
Installed and configured MySQL on Linux and Windows environments.
Managing/Troubleshooting MySQL 5.7.5 and 5.7.6 in production and developer environments.
Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
Worked with JAVA/J2EE environment. To design webpages I used HTML5, CSS3 for styling and Bootstrap5 for giving a professional look.
Used JSP and Java Script to handle the functions and operations to control transactions of users.
For sending emails and alerts used SMTP protocol and also used Apache POI library in order to upload excel sheet and send notifications in excel format.
Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
For testing and deploying I used Jenkins hands on working experience in writing some customized test cases before deploying.
Database engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment. Environment: MySQL 5.7(Workbench 6.2.x), JSP, Java Script, JDBC, Apache POI, Tomcat 7, Eclipse IDE, MVC architecture.
Delta Technology Jan 2014 – Dec 2014
SQL Developer/DBA - Hyderabad, India.
Part of the team which involved in administration and supporting of TPD application (which is actually a Training and Placement Department Tool) for different colleges belong to one university. It is a multithreaded application. It takes data from different colleges about students in a university, process along with different recruiting companies and then sends to placement department of corresponding college.
Responsibilities:
Handle user interface based on the web browser and the application is developed using JSP and HTML along with DHTML.
Involved in migration of MySQL(5.0.9) databases to Oracle SQL 12c using the MySQL Migration Toolkit.
Responsible for the following tasks :
a) Notice generation via Email using SMTP
b) Providing student list generation
c) Providing view of student profile
d) Providing view of company requirements
e) Result analysis
Handling MySQL Cluster architecture for managing host and nodes.
Created database application using PHPMyAdmin and Orcale SQL 12c database as the database to monitor student profiles and fine-tuning of databases for its performance and concurrency.
Developed presentation layer using JSP, HTML, JavaScript, HTML5, JQuery and CSS3.
Creation of Database Objects: Tables, Store Procedure, Views, Triggers, Index, and Function.
Entitled to write the Oracle SQL queries for CRUD operations, and Stored Procedures. 4
To develop the application using Eclipse IDE.
Involved in trouble shooting/coding SQL queries on Web applications that are driven by Oracle SQL 12c database.
Hands on experience with testing tools like JetBrains and worked on creating customized test cases.
Environment: Oracle SQL 12c, PHPMyAdmin, Java/J2EE, HTML5, JavaScript, Spring MVC, Web Sphere v5.5, JetBrains.
Delta Technology(INTERNSHIP) Feb 2013 – Dec 2013
Junior DBA - Hyderabad, India.
I was the part of the administrator team who involved in maintaining and developing Human Resource database application. The objective of this project is to migrate to another database while maintaining data and providing an ability to retrieve information about the entire personnel and professional employee data framework of the Delta Technology. Responsibilities:
I was the teammember of the application and Involved in creating the web pages using html with class files wherever needed, connection to database, testing the created tables & involving the support to the users of the system.
Database designing, development using stored procedures, views, joins etc and performance enhancement activities.
Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
Involved in migration of Microsoft SQL database to MySQL using the Workbench Migration Toolkit.
Using MySQL database wrote queries for including search engine for all employees, departments, and also differentiated search engines based on department, authority-level and other parameter using Workbench(5.2.44).
Maintained data based on communications/meetings between employee and administrators time to time.
Creation of Database Objects: Tables, Store Procedure, Views, Triggers, Index, and Function.
Analyzed long-running/slow queries and tune the same to optimize application and system performance.
Computerized payroll generation, manipulation and management.
In order to build this application we considered the following practices: a) Accuracy b) Reliability c) Redundancy Check d) Retrieval of information
Developed user interfaces using JSP, Servlets for web development.
Automation tests are carried out before deployment.
Develop, test, implement and maintain application software working with established processes.
Deployed the application using Tomcat 7.
Hands on experience with manual testing with customized test cases using JetBrains.
Collaborating with team members on application development. Environment: MySQL(5.5.3), Java/J2EE (JDK: 1.5), JSPs, Servlets, Tomcat 7, Eclipse, HTML5, CSS3, XML.
5
Microsoft Jan 2012 – Nov 2012
Intern Programmer - Hyderabad, India.
Responsibilities:
Monitored running database server and performed tuning techniques.
Maintained data persistence for different users by creating corresponding tables and databases in MySQL database.
Carried out queries like inner-joins and outer-joins etc. to get the users details added LINQ to SQL files.
Made the module to detect who has entered chat room and redirect them to corresponding chat room.
It must also display the user about the other users who are online.
The chat history should be erased as the students leave chat.
The privilege of storing the chat is given to higher authorities.
Used Visual studio UI to build the chat window as well as the outlook of chat rooms.
Created ASP.Net web application.
Added an AJAX-enabled WCF service.
Adding the operations like storing the messages and giving a session to student chat rooms using Java Script and C#.
Environment: C#, ASP.NET framework, AJAX, Visual Studio IDE 5, MySQL, HTML, CSS.
Contact this candidate