Sql Server Engineer

+Akanksha Jain

Mobile: +1-425-***-****

Email: ***********@*****.***

Objective

Seeking assignments in Testing, Development & Support with a technology driven organization that

could utilize my knowledge, experience and ability in a competitive environment; thus working

towards growth of organization multiplied with satisfaction thereof.

Summary

• 4.5 years of IT experience in Testing Development and Support various types of applications across

different platforms

• Experienced in working through the complete software development life cycle with specific focus

around Test planning, automation, execution and metrics

• Very good understanding on SDLC life cycles along with the Waterfall, V and Iteration methodologies.

• Authoring Tests in C# using NUnit and MS Test framework.

• Performed White box, Black box, Unit, GUI, functional, performance, usability, accessibility,

compatibility & security testing

• Experienced in software bug life cycle, opening, resolving, closing and prioritizing bugs and also

triaging them to assign to appropriate teams

• Knowledge of SQL. Experienced in testing SQL queries, Stored Procedures.

• Experienced in Database Administration and providing 24x7 support.

• Experienced in managing and leading the team and was involved in costing, prioritizing and effort

tracking

• Excellent analytical, problem solving skills.

• Ability to work in a fast paced environment, adaptable team player with strong communication and

interpersonal skills

• Experienced in System Integration Testing and release support.

TECHNICAL SKILLS

Programming Languages C#, PL SQL, Visual Basics

Testing Tools/Framework Test Director, NUnit, MS Test,

Performance Tools Windows Perfmon, .Net Memory Profiler

Bug Tracking Tools Team Foundation Server,Product Studio, Bugzilla, TFS

Database MS SQL Server 2008

Operating Systems Windows8, Windows 7, Server 2008 R2

Scholastics

• Master of Science in Computer Science in 2011 from Herguan

University USA.

• Masters of Computer Application (MCA): Dr. Hari Singh Gour

University, Sagar.

• Bachelors of Computer Application (B.C.A.): Dr. Hari Singh Gour

University, Sagar.

Employment Profile

Software Development Engineer in Test Shubh Solutions LLC,

Client: Microsoft Corporation Redmond USA

Responsibilities

• Automated the daily report generation for SI Health Check.

• Manually running BI Jobs and performing Functional Testing.

• Periodic deployments in the System Integration environment using MSBuild, Octopus.

• Automated MSI and DB deployments using cooper Lab Infrastructure.

• Developed and tested Archiving tool for SI servers

• Automate Email alerting system for various services.

• Responsible for adcenter SI database and pipeline deployment, issue resolution and incident

management.

• Debugging environment failures and Escalating issues to respective team.

• Working closely with stake holders of the project for improving the overall project quality and

standard.

• Collaborate with Apps and Infra team to resolve environment and infrastructure issues

• Automation of daily infrastructure tasks using Powershell & batch scripts.

• Managing servers in SI team and working with Infra team on issues.

• Created process documentation for new team members.

Software Tester. Vasu infosec Pvt. Ltd.

Technology: C#.Net, SQL Server 2005, Crystal Report, ASP.Net

Client: Cool Home Construction Company

Responsibilities:

Responsible for testing of signal from different security device to software with no data loss.

Reported 50 + bugs on software and communication layer.

Responsible for testing different reports generated using admin software.

Responsible for testing user interface for Admin.

Design a protocol to communicate with CMS panel to get the information about the faults

(Gas, smoke etc).

Design a GUI to get information about each fault and generate Report for each fault.

Send SMS via Code again to the flat owner regarding the fault.

Design Database and Store procedure for master entries form and transaction.

Established PL/SQL programming standards.

Generated various reports Crystal Reports.

Responsible for the database design, development.

Installing, configuring, administering and securing our as well as our clients' production

servers

Support in Production and development database.

Software Engineer. Ethix Software

Technology: C#.Net, SQL Server 2005, Crystal Report, ASP.Net

Client: Mega Mall

Environment: C#.Net, SQL Server 2000, Crystal Report.

Responsibilities:

Designed and developed application using C# .Net

Install, configure and upgrade MS SQL Server.

Porting the old data in to the new database using of BCP

Assisted for Development and design the GUI with ActiveX Controls like MS Flex Grid, List

View, Tree View, etc.

Generated reports using Crystal Reports.

Coding, Testing, designing the Active X controls.

Client side implementation and testing.

Performed unit test at the time of development.

Responsible for stress testing and performance testing.

Requirement gathering and analysis of user requirements Maintenance of application

Major Projects:

Bing AdCenter:

Bing Adcenter is a Microsoft online system for advertisement. BI is a core part of Microsoft

Advertising team. BI Systems include services, Datamart Database and infrastructure required to

acquire, transform, deliver and present data and analytics through internal and external reporting

applications. More than just a data processing layer, more than just a reporting or analytics

framework - this is the foundation layer of the ad platform, and related services that enable

Microsoft to operate in the advertising industry BI is an ETL system which runs hourly with SLA

bound. This System designed for processing collected logs from Microsoft online system. Extract,

transform, load are the three basic part of this system.

Building Management System (BMS)

The Integrated Building Management System is a central computerized system for

monitoring, controlling and operating systems within a building. A building could mean

factories, industrial units, commercial units; data processing environments etc. An IBMS

usually incorporates controls for air conditioning, for energy management, maintenance

management, security, and access and fire systems. An IBMS allows the entire building system

to operate effectively and efficiently, saving costs considerably.

Central Monitoring System (CMS)

Description: The security at every flat is achieved by installing Security system which then

needs to be monitored by CMS system. Once the alarm is generated, there should be SMS

notification to the flat owner on the predefined mobile numbers. The Person who is managing

the CMS should be able to acknowledge the alarm. Once the alarm is acknowledged and CMS

gets the ‘OK’ feedback again from the security panel, there should be SMS notification again

to the flat owner regarding the ‘normal’ mode of the flat security.

Smart Park:

Description: Managing secured, efficient and disciplined Parking System, automatically. This

will help to keep a track about parking charges collections, with respect to different system

user with concern shifts. Every Visitor is permitted to get inside parking space only after,

furnishing all data.

Contact this candidate