SUMMARY

• 10+ years of Database development experience using Microsoft technology.
• Strong background and experience in MS SQL SERVER 2000, 2005, 2008 R2, 2012 and 2014.
• Experienced in writing complex stored procedures, MDX Queries, user defined functions, cursors and triggers.
• Rich experience in SQL Query Optimization using Query Execution Plan, SQL Profiler and DMV (Dynamic Management Views).
• Very good knowledge of using SQL Server 2008 R2 and SQL Server 2012 in .NET Framework 2.0.
• Hands on experience in Database Operations like partitioning, views, Indexes, stored procedures, user defined functions, triggers, cursors and Database Administration.
• In depth experience with DTS/SSIS and Intermediate experience with SSRS.
• In - depth proficiency in C# Programming with MS SQL SERVER and MS Office Suite - MS Access 2010/2007/2000/97 , MS Excel, MS Outlook MS PowerPoint.
• Rich Experience in developing middleware components and Business Logics.
• Proficient in configuring, administering and deploying the database components.
• Extensive knowledge of Software Development Life Cycle (SDLC), methodologies and test processes.
• Extensive experience in developing, debugging applications using ASP, ASP.NET, C#, ADO.NET, XML, XSLT, SQL Server 7.0/2000/2005/2008 R 2/2012/2014.
• Possess good analytical, problem solving skills, ability to meet deadlines, and work on multiple projects.
• Excellent verbal, written communication and presentation skills, strong analytical and problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/2000/XP, Windows 7, Windows Server 2003, Windows Server 2008 R2, Windows Server 2012 R2 and MS DOS.

Languages: C/C++, C#, Visual Basic 6.0, PYTHON, ASP.NET, TSQL, MySQL, PL/SQL.

RDBMS: SQL Server 7.0/2000/2005/2008 R2/2012/2014, Oracle 8i/Oracle 9i, and MS ACCESS.

Development Tools: Visual Studio 6.0, Visual Studio.NET, Visual Studio 2005, 2008, 2010 and 2012, Pentaho Data Integration, Gentran Integration Suite (GIS) and Sterling Integrator (SI)

Application: MS Word, MS Excel, MS Power Point.

Scripting Languages: ASP, Java Script, VB Script.

Markup Languages: HTML, DHTML, XML.

Others: ADO.NET, ADO, ASP.NET.

PROFESSIONAL EXPERIENCE

Senior SQL Developer

Confidential, Atlanta, GA

Environment: MS SQL Server 2008 R2, MS SQL Server 2012, MS SQL Server 2014, Windows Server 2008 R2, Windows Server 2012 R2, Sage 500 (MAS 500), ASP.NET, ADO.NET, Visual Studio.NET, HTML 4.0, JavaScript, XML, XSL.

Responsibilities:

• Involved in the Analysis, Design, Coding and Implementation of the Power BI Project, which is schedule to go ‘live’ by the end of third quarter of 2016, with the help of our Data Warehouse.
• Creating tables, indexes, views, Store Procedure, cursors and User Defined Functions to support back end of Power BI.
• Maintaining and supporting Daily, Weekly and Monthly SQL JOBs which are designed to support finance team.
• Integrating SQL Server scripts/store procedures with ASP.NET and C# pages to support internal UI.
• Created SSIS packages with SQL Server 2008 R2 and SQL Server 2012 to dump data on the FTP server for end users.
• Integrated SSIS packages using SQL 2008 R2 and SQL 2012 to support in-house data warehouse with ETL method.
• Creating/created Stored Procedures and triggers to perform automated rules, updating to related tables using SQL Server 2008 R2 and 2012.
• Extensively working with complex report design and implementing them using SSIS for internal and external needs.
• Supporting SSRS team by creating tables, indexes, Store procedures and cursors as well as Database management and Back-Ups.
• Working as a Senior SQL Server developer and Data Analyst (Maintaining SQL server 2008 R2, 2012 and 2014).

Senior SQL Developer & Analyst

Confidential,Atlanta, GA

Environment: ASP.NET, ADO.NET, MS Visual Studio. NET, HTML 4.0, JavaScript, XML, XSL, PENTAHO, GIS (Gentran Integration Suit), MS SQL Server 2008 R2, MS SQL Server 2012, Windows 2003, Windows 2013, SSIS, SSRS, MS Office 2010.

Responsibilities:

• Involved in the Analysis, Design, Coding and Implementation of the Database related Projects & handled various activities.
• Wrote database components to access Database using ADO.NET, mail components.
• Created tables, indexes, views, Store Procedure, relations and user defined functions.
• Integrated SQL Server Reports with ASP.NET and C# pages.
• Configured and implemented .NET Class Framework environment along with application.
• Created DTS packages with SQL 2000 to dump data on the FTP server for end users.
• Created SSIS packages for reporting, using SQL 2008 R2 and SQL 2012, for internal and external use.
• Supported existing integration process using PENTAHO as well as created them.
• Created Stored Procedures and triggers to perform automated rules, updating to related tables using SQL Server 2008 R2 and 2012.
• Implemented Security using Forms authentication.
• Extensively worked with complex reports design and created many cubes.
• Worked as a Senior SQL developer and Data Analyst (Maintained SQL server 2008 R2 and 2012 Database).

Database Developer

Confidential, Atlanta, GA

Environment: ASP.NET, ADO.NET, Visual Studio. NET, HTML 4.0, JavaScript, XML, XSL, MS SQL Server 2000, Windows 2003, Adobe Photo Shop5.5, SQL Server Reports.

Responsibilities:

• Involved in the Analysis, Design, Coding and Implementation of this Project & handled various activities.
• Wrote database components to access Database using ADO.NET, mail components.
• Created tables, views, relations and user defined functions.
• Integrated SQL Server Reports with ASP.NET and C#.NET pages.
• Configured and implemented .NET Class Framework environment along with application.
• Created Stored Procedures and triggers to perform automated rules, up dating to related tables using SQL Server.
• Implemented Security using Forms authentication.
• Extensively worked with complex reports design and created many cubes
• Worked as a database Developer (Maintaining SQL server 2000 Database).
• Worked as a Server Administrator (maintaining Windows 2003 Server web server).

Database Developer, QSS

Confidential, Atlanta, GA

Environment: MS SQL Server 2000, Windows 2003, C#, ASP.NET, ADO.NET, Visual Studio .NET, HTML 4.0, JavaScript, XML, XSL, Adobe Photo Shop5.5, and IIS 5.0

Responsibilities:

• Involved in the Design, Coding and Implementation of this Project & handled various activities. Implemented validation using validation controls and JavaScript.
• Wrote database components to access Database using ADO.NET, mail components.
• Wrote user controls (Pagelet Controls) for content building. Involved in unit testing and extensive involvement in Bug fixing.
• Configured and implemented .NET Class Framework environment along with application.
• Created Stored Procedures and triggers to perform automated rules, up dating to related tables using SQL Server. Implemented Security using Forms authentication.
• Created tables, views, indexes and relations using SQL Enterprise Manager.
• Implemented web services using XML to decode information from Patient identification number (PIN).

Environment: Included Visual Basic 6.0, MS-SQL Server as the database on WinNT4.0.

Confidential

Responsibilities:

• Developed a Software Package for local Book Store Visual Basic 6.0 and MS Access
• Set up and administered NT based Server/Workstation
• Designed and implemented LAN and WAN solution
• Built a web page for Billy’s Bits & Bytes by using HTML, DHTML, ASP