Sql Server Developer

AMITA KAPIL

#**,******** ******, **********

Bangaluru(Karnataka) – 560066 Email: *****.*****@*****.*** Cell: 900-***-****

Seeking for an interesting and challenging role in the field of database development to integrate IT experience of 3 years (Including 6 Months Training) as Software Developer to add value to the overall organizational performance & objectives

Technical Expertise

Software Tools/Skills:

ODBC, C, C++, Microsoft Office- Word, PowerPoint, Outlook

Web skills:

C# .Net with Silverlight Application

HTML, JavaScript, XML/XSLT, Cold Fusion, Cascading Stylesheets(CSS),

Databases:

SQL Server 2008R2, SQL, PL/SQL, MS Access

Operating Systems:

Windows XP, Windows 2000, Windows 98, MS-DOS

Professional Experience

Open Access Technology India (OATI)

Sr. Software Developer June 2009 - Present

OATI provides the innovative software solutions to meet the needs of the North American energy industry. I am working in the webScheduling team of webTrans Product that sets the industry standard in North America for the most reliable scheduling and transmission management.

Role: Requirement gathering, Designing, Estimation, Planning, Development and Testing.

Job Responsibilities

• Over 3 years of experience in professional application and database development in multi tier and web based solutions.

• Earlier I was working in Visual studio C#.Net,JavaScript, Cold Fusion (CSS), HTML, and XML/XSLT to store and display client data.

• Involved in developing, testing, debugging and documentation.

• Designed and wrote the SQL queries, stored procedures to pivot the data and for many other operations in SQL Server 2008R2 to get the required data to be shown on display.

• Experienced in other RDBMS like Oracle (SQL, PL/SQL).

• Experienced Jobs through SQL Server Agent.

• Knowledge of SQL Profiler.

• Knowledge of Backup.

• Expertise in Joins(Equi,Non-Equi,Left Outer,Right Outer Joins), Indexes.

• Supported team in resolving SQL Reporting services and T-SQL related issues.

• Worked on Different products like Transodg, WIT, TVA, and BPA etc.

• Restored different databases and establishing connectivity through ODBC data sources.

• Solved problems, documented the code with proper comments and wrote test cases that how to test the problem.

• Debugged the code and fixed the bugs in display.

• Integrated the code of modified scripts from original code store.

• Performed unit testing of the problems by reviewing the code, checked for the efficiency of the code, indentation and the display functionality.

• Mentored a junior developer regarding the Scheduling and WebTrans work and helped them in re-producing the problems and any other issues.

• Positive attitude towards superiors & peers.

• Quick learner and good performer both in team and independent job environments.

Projects Handled While Pursuing Degree

Training Attended:

• Jan 2009 - June 2009

Training attended at OATI (Open Access Technology India Pvt..Ltd) which was six months industrial training. Learnt Coldfusion and other various web languages and also worked on other Various Technologies

Project Details:

Project / Organization : WebOMS, worked in scheduling team and worked on so many daily basis problems of different projects / OATI

Tools/ Languages : Using Team Foundation Server for C#.Net (Silverlight Application), ODG / Javascript,HTML/DHTML, XSLT, Ajax,PL SQL, SQL

Testing Tools : Arexis Merge, Win Merge, Tortoise Tool.

Team Size : 12

Description : We handle daily basis problems on different projects like RTOSS, SWPP, BCTC, WebOMS (SilverLight Application),WebTrans, BPA, AESON.

Role : The work comes as service request to each individual developer. To study the service request to have a clear idea what needs to be done. Draft a requirement Specification document. Coding, drafting technical Specification, test plan, test evidence according to end result of the coding.

Education

• B-Tech in Computer Science & Engineering from RBIEBT, Mohali (PB), affiliated to Punjab Technical University in the year 2009 with 74.6%.

• S.S.C (+2) in 2005 from Punjab School Education Board with 53.1%.

• Matriculation in 2002 from Punjab School Education Board with 70.7%.

Personal Dossier

Date of Birth : 02nd Nov.1986

Linguistic Abilities : English, Punjabi & Hindi

Phone no : +91-900*******

Father name : Mr. Anil Kumar

Mother Name : Mrs. Parveen Lata

Contact this candidate