SQL Server Developer

SkillsEmployment History:

• Exp. w/ SQL Server including 2005/2008 Create views, complex stored proceed.
• Experience working with asp.net, C
• Experience in Sql Server Reporting Services SSRS
• Expertise with T-SQL
• Experience with iText .Net
• Experience with performing database performance analysis, reporting, and configuration
• Strong understanding of framework/library design and best practice designs
• Knowledge of database sizing, capacity planning and full life cycle
• Experience with writing stored procedures, views, etc.
• Firm understanding on OO concepts and design patterns utilizing C
• Development in Visual Studio 2010 using Team Foundation Server, Work Items
• Expertise in data architecture
• Use of the Microsoft AJAX Toolkit
• Experience with Microsoft Unit Testing Framework or other Unit Testing tool
• Ability to lead and mentor a team
• Experience with Web services

Confidential

SQL Server DBA

Roles Responsibilities:

• Involving in gathering requirements, interacting with users.
• Reengineer Power Builder application into ASP.NET/MVC.
• Create Ad-Hoc reports using Telerik Report Designer 2008, SSRS and PowerBuilder.
• Upgraded Database from SQL Server 2000 to 2008.
• Database Administration activities like User Management, Security, Backup/ Recovery and Performance Tuning on SQL Server.
• Maintenance of backup and recovery plans for system and user databases. Developed automated backup procedure to ease the maintenance task of database administration.
• Monitor the Online log and analyze errors/warnings, monitor database activity and server parameters. Performance tuning of Online Server and monitoring transaction logs.
• Granting and revoking permissions on Windows NT files and SQL Server database/tables.
• Creation, manipulation and supporting application Schemas Database, Tables, Views and Indexes, SP's and Triggers .
• Import Export of data from one server to other servers using DTS.
• Developing Data Migration scripts and SSIS packages needed to Import Export data.
• Developing Aviation Safety Hotline Information System ASHIS application using Share Point Designer 2007.
• Supporting various Power Builder application
• FAA Safety Recommendations System FRS
• NTSB Safety Recommendations System NRS
• Duty Room System DRS
• Aviation Mishap Information System AMIS
• Major Accident Tracking System MATS
• NTSB Information Requests System NIRS
• Supporting Aviation Safety Hotline Information System ASHIS .
• Doing the Power Builder Migration build.
• Provide ongoing support to the AMIS/SQ analyst for data validation and custom queries and reports
• Involved in bug fixing and Unit testing.
• Provide ongoing support to the Duty room, particularly for the web generation process and troubleshooting problems.
• Maintaining AAI servers with updated patches.
• Deploying SharePoint application on MOSS server.

Confidential

PowerBuilder and SQL Developer

Roles Responsibilities:

• Involved in Full life cycle of Software Development, involved in design, development and Testing of the Application
• Analyzing the Power Builder based application and creating the functional requirement document.
• Coding, Testing, Modification in window script, data window, function and user object.
• Designing presentation layer, Business logic layer and database layer.
• Designing and creating database objects that include tables, views, triggers, cursors, stored procedures and queries.
• Responsible for code management using TFS Team Foundation Server
• Doing the Migration build and release of the new version
• Created different Involved in Full life cycle of Software Development, involved in design, development and Testing of the Application
• Transaction Objects to retrieve data from different Databases. User Object and Wrote Many User Object Functions.
• Worked with T-SQL and Visual Studio 2010.
• Wrote Power script function to manipulate the data in the database.
• Wrote a number of user defined functions and Stored Procedures using SQL, PL/SQL.
• Connected to several non-native databases using ODBC. Used Transaction Management to manage different databases.
• Developed web pages from scratch using C , ASP.NET, MVC.
• Database Administration activities like User Management, Security, Backup/ Recovery and Performance Tuning on SQL Server.
• Maintenance of backup and recovery plans for system and user databases. Developed automated backup procedure to ease the maintenance task of database administration.
• Monitor the Online log and analyze errors/warnings, monitor database activity and server parameters. Performance tuning of Online Server and monitoring transaction logs.
• Used C as a code behind for Web Services
• Granting and revoking permissions on Windows NT files and SQL Server database/tables.
• Import Export of data from one server to other servers using DTS.
• Created several Reports using Crystal Report and SQL Server Reporting Services SSRS .
• Confidential

PowerBuilder and SQL Developer

Roles Responsibilities:

• Coding, Testing, Modification in window script, data window, function and user object.
• Doing the Migration build and release of the new version.
• Created different Transaction Objects to retrieve data from different Databases.
• Wrote Power script function to manipulate the data in the database.
• Creation, manipulation and supporting application Schemas Database, Tables, Views and Indexes, Store Procedures and Triggers .
• Use of Ajax Updated panels for partial post backs.
• Wrote a number of user defined functions and procedures using SQL, PL/SQL.
• Developed numerous reports using Power Builder and Crystal Report.

Confidential

PowerBuilder and SQL Developer

Roles Responsibilities:

• Coding, Testing, Modification in window script, data window, function and user object.
• Designing and creating database objects that include tables, views, triggers, cursors, stored procedures and queries.
• Doing the Migration build and release of the new version.