Lead Engineer --> Sql Server

Gaurav Gosain

Sector ** House No. *** Vasundhra,

Ghaziabad-201012

E-mail ID: ******.******@*****.***

Cell +91-999-***-****

CAREER OBJECTIVE

To obtain a position in IT Industry that will utilize my technical experience and education in software development, and be a contributing team player in the overall success of a progressive and growth oriented organization.

My Strength: I learn things very quickly, and have strong logic skills.

My Expertise: In Database designing and logic design for Telecomm domain.

BRIEF OVERVIEW

1. Keen interest to work as Software Professional in a challenging environment which would offer me various opportunities for working on leading edge technology, handling business responsibilities and managing my career growth.

2. Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management and team building.

3. Achievement oriented with excellent communication & interpersonal skills.

4. Proven strength in trouble shooting, problem solving, coordination and analysis.

5. A good team player with ability to lead a team by example and motivate them to achieve desired objectives.

6. A keen learner with an ability to maintain focus; optimistic and persistent even under adversity.

PROFESSIONAL SUMMARY

I am Microsoft Certified Technology Specialist with more then Six years of rich experience in Database systems like MS SQL Server 2008, 2005, 2000 and MS-Access and Microsoft™ development technologies like VB 6.0, ASP which proves my technical ability in mentioned areas. I have good knowledge of telecomm domain (CDR Processing and NLD, ILD, ICB, ISP Billing). In SQL server, I have command over different tools like Enterprise manager/ Studio, Query analyzer, Tuning of Database, DTS, SQL Profiler. Above all I possess excellent communication skills and client interaction skills, which are important for both development environment and production environment.

PROFESSIONAL QUALIFICATONS

DEGREE: - M.C.A (First Division, Degree with honors) (BATCH 2002-2005).

INSTITUTE: - Jaipuria Institute of Management, U.P. Technical University, Lucknow.

PERCENTAGE: - 76.71%

DEGREE: - B.C.A (First Division) (BATCH 1999-2002).

INSTITUTE: - Institute of Management Education, CCS University, Meerut.

PERCENTAGE: - 69.4%

ACADEMIC QUALIFICATIONS

XIIth STD C.B.S.E. BOARD 1999 61%

Xth STD C.B.S.E. BOARD 1997 68%

OTHER CERTIFICATIONS

MCTS: SQL SERVER 2005 (Microsoft Certified Technology Specialist)

Transcript ID: 761033, Access Code: GAGSMCTS2007

Site: https://mcp.microsoft.com/authenticate/validatemcp.aspx

DNIIT Title (2 Year Diploma) from NIIT with 74%

ACHIEVEMENTS

• Received KAAPA AWARD “Annual Excellence Award” at GlobalLogic

• Stood 1st in MCA.

• Received Third Prize on my software Time Table Management System at All India MCA Meet held at Maharishi Institute (Bhopal).

COMPUTER SKILLS

Operating System: MS-DOS, UNIX, Windows-95/98, Windows NT and Windows 2000.

Languages: - C, C++, Visual Basic 6.0, and CRYSTAL REPORT, VB.Net, C#, XML.

RDBMS: - MS-SQL SERVER 2000, Oracle 9i, MS-ACCESS.

EXPERIENCE

Present at:

Organization: - GlobalLogic (Formerly Known as Induslogic).

Duration: - June -2006 till present.

Designation: - Lead Engineering.

Technology: - Microsoft SQL Server 2008, 2005 and 2000

Responsibility: - Database administration, Application level DB support (Production).

Previous:

Organization: - Sapient.

Duration: - January -2006 to May 2006.

Designation: - Associate Technology.

Technology: - Microsoft SQL Server 2000, Oracle 9i, Visual Basic Application.

Responsibility: - Database administration, Writing Stored Procedure, views.

Organization: - Greenfield Online.

Duration: - January-2004 to December-2005.

Designation: - T-SQL Programmer (Database Programmer).

Technology: - Microsoft SQL Server 2000.

Responsibility: - Database designing and Query, Stored procedure writing and report designing.

PROJECTS DETAILS

Current Project:

Organization: GlobalLogic (Formerly Know as Induslogic).

Technologies Used: Microsoft SQL Server 2008, 2005 and 2000

Client: Telarix (U.S)

Project: Telarix: Production Engineering

About GlobalLogic: GlobalLogic is a global services provider delivering value-driven software product lifecycle solutions that meet the strategic objectives of our clients. GlobalLogic has seven excellence centers and has pioneered the Distributed Agile Methodology that helps shrink the software product development life cycle and reduce total cost of ownership (TCO).

About Client: Telarix is the leading provider of Interconnect Business Optimization solutions to global wire line, wireless, broadband and VoIP communications service providers. Telarix has two award wining products in market iXTools and iXLink. Telarix allows service providers to leverage operational intelligence within their networks to enable real-time business decisions impacting operational efficiency, margin optimization, vendor agreement management and other mission-critical interconnect business processes.

Telarix was founded in 1996 by a group of seasoned industry veterans and, with strong and consistent growth, has grown the company globally to include tier 1 clients (Verizon, Vodafone, Aircel, Celcom, Telecom Italia, Rogers, PT, Sprint, JazzTel, Maxis, France Telecom and many more) in Asia, Europe, North and South America.

Responsibilities:

• Managing 7 members team and providing training to Telarix clients.

• Providing round the clock production support to various clients of Telarix around the globe.

• Currently managing more then 150 DB Servers with biggest db size 650GB and many above 100GB.

• Responsible for applying patches and doing HOTFIX in code on production.

• Database Administration activities like DB management, backup-recovery, preparing disaster Recovery plan.

• Involved in developing a number of Stored procedures, triggers and views using SQL Server 2008 and 2005.

• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

• Used Activity monitor, Prefmon, DMV’s to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.

• Used SQL Server Profiler to monitor and record database activities of particular users and applications.

• Used DBCC commands to troubleshoot issues related to database consistency.

• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

• Creation of database designs.

• Implemented trigger and stored procedures and enforced business rules via checks and constraints.

• Benchmarking of Application with Microsoft (at Seattle, WA) in MS Labs and implemented recommendations from exercise on all the clients.

• Sent on-site 4 times for migration and upgrade of application from MS SQL 2000 to 2005 and from MS SQL 2005 to 2008.

Organization: Sapient

Technologies Used: Microsoft SQL Server 2000, Oracle 9i, Visual Basic Application, MS Excel

Project: Enterprise Application - Report Center

About Sapient: Sapient is a leading business consulting and technology services firm that plans, designs, implements, and manages information technology to improve business performance for Global 2000 clients. Sapient was founded in 1991 based on a single promise: to deliver the right business results, on time and on budget. Sapient's fixed-price/fixed-time model, combined with industry, design, technology, and process expertise, provides clients with the highest business value at the lowest total cost of ownership. Headquartered in Cambridge, Massachusetts, Sapient has offices in Canada, Germany, India, the United Kingdom, and the United States.

Responsibilities:

• Database Administration, backup and recovery.

• Writing stored procedures and view for reports.

• Designing Report.

• Data Analysis, performance tuning and testing

Organization: Greenfield Online

Technologies Used: Microsoft SQL Server 2000

About Greenfield Online: GFOL is US based online market research company which has business in 13 different countries; still most of their business comes from US. The company has different servers and databases to maintain the data pertaining to around 2 Million Panelists that company possesses. Mainly there are 6 different servers with many databases (Live/Online); some of them are replication databases for OLAP processing and archiving databases, which are used in normal day today business.

Responsibilities:

• Creating databases (with constraints and indexes) for different surveys and populating them with requested data. Granting and revoking permissions on different database objects for survey programmers.

• Writing stored procedures for the data upload mappings and leads.

• Creating DTS packages for certain tasks which are easy to run using DTS as compared to Query analyzer.

• Providing different analytical data related to panelists and surveys, like demographic counts, survey respondents and completes counts, sample compositions counts etc. to sales managers, project managers and projects directors.

• Serving different types of panelist related requests like providing counts and pulls from database based on various complex criteria.

• Serving data modification and correction requests in both panelist databases and survey databases.

Training Projects:

Organization: POWER LINE & CONTROL PVT LTD (New Delhi)

Technologies Used: Visual Basic 6.0, Crystal Report and MS ACCESS.

Project Description:

Small ERP Pack v 1.0: Software that handles stock and payment (inwards and outwards). This provides facility to limit credit for particular Client. It also auto generates cheque for suppliers. And maintain records of payment received and make.

Organization: M.K.Overseas (Shahibabad)

Technologies Used: Visual Basic 6.0, Crystal Report and MS SQL.

Project Description:

Production cum billing v 1.2: Software that keeps record of production and raw material and generates bill for supplier on every Thursday. In this software there are 4 different type of billing report and also 4 different type of summary report.

Other Projects:

Title: Time Table Manager v 1.0: Project provides the facilities of generating time table for school, college or Institute. It is able to generate around 64000 combinations for each class and has provision for manual changes also.

Tools: Visual Basic 6.0 and Microsoft Access

Title: Splitter v 1.0: An Application to split a file into user defined number of parts and sizes of the different sub-parts of the file. It also merges a those fragmented files. It provides mouse enabled graphical user interface created using C graphics.

Tools: Using C

PERSONAL PROFILE

FATHER'S NAME: - Er G.D. Gosain

DATE OF BIRTH: - 23rd February 1982

SEX: - Male

LANGUAGES: - Hindi, English.

INTEREST: - Sports, Listing to Music.

PASSPORT: - Valid Upto 2015-Sep-14

VISA: - Country: US Type: B1 Valid Till Jul 2016

Type: L1 Valid Till Dec 2011

Country: Portugal (Europe)

Type: Schengen Visa

(GAURAV GOSAIN)

Contact this candidate