SUMMARY

• Around 8 years of IT experience with a strong background in Financial, Retail and Health - care industry performing business analysis, design, development, implementation, testing, and maintenance of application systems in the Client Server environments and Web based Applications utilizing SQL Server 2000/2005/2008/2008 R2 in both OLTP and OLAP environments.
• Experience with Data Management, Analytics and compliance.
• Hands on experience with Migrating Data from Mainframes to SQL Server, migrating data from DTS (SQL2000) to SQL 2005/SQL2008.
• Experience in Installation and Configuration of SQL Server 20005/2008 technology, service patches and hot fixes.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, common table expressions (CTEs), user defined data types and functions to facilitate efficient data manipulation and data consistency.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands for monitoring and tuning MS SQL Server performance.
• Expert in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS and Bulk Insert).
• Created complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Expert in developing web applications, windows services and web services in Microsoft Visual Studio.Net IDE using C#.Net, ASP.NET, ADO.NET, CSS, HTML and JavaScript.
• Good understanding of software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Will work "hands-on" when required but understands the value and importance of delegating work and responsibilities, a team builder who motivates staff to excellence using a proactive management style.

TECHNICAL SKILLS

Operating Systems: MSWindows95/98/NT/2000/XP/2003/Vista, MS DOS

Programming Languages: C, C#, ASP.Net, ADO.Net, PL/SQL and T-SQL.

WebTechnology: CSS, HTML,JavaScript,ASP.NET

Databases: MS-SQLServer 2000/2005/2008/2008 R2, Visual Studio 2005/2008

BI Tool: SSIS, SSRS

Other Software: MS Office, MS Project, MS Visio

PROFESSIONAL EXPERIENCE

SQL Server Developer

Confidential, Dallas, TX

Responsibilities:

• Working as a SQL Server Developer writing complex stored procedures using T-SQL, building SSIS packages and SSRS reporting services.
• Working on BI project for clients such as FDC(First Data Co), NPC(National Processing co) by processing the data received in files such as.xls format, .csv format, .pdf format, files that are generated from mainframes, etc., into SQL Server tables.
• Working on resolving various file issues which are provided by the clients. Some of those files are Merchant Information, Authorizations, deposits, charge backs, Retrievals and so on.
• Provided the analysis on the various areas of Credit card Processing services using SSIS packages.
• Working on PCI (Payment Card Industry) product by generating reports to clients regarding the merchant statuses on daily and monthly basis using SSRS reporting services.
• Worked on migrating the data using T-SQL scripts, stored procedures for clients such as ORI (Orion Payment Systems), MPS (Mercury Payment Systems) from DTS(SQL2000) to SQL2008R2, debugging issues related to migration.
• Responsible in writing complex matching rules on various string manipulation logics.
• Developed Query for generating matrix reports, drill down reports in SQL Server Reporting Services (SSRS). Also prepared adhoc reports through report builders.
• Handled the Datasets using complex queries and stored procedures for generating reports using SQL Server Reporting Services (SSRS).
• Working with the higher management closely to provide additional scope and depth in the current BI Project.
• Performed DBA duties such as Index tuning, query optimizations using SQL Server
• Profiler, Execution plans, Database Tuning Advisor.
• 24/7 production watch throughout the project.
• Involved in unit testing and bug fixing

Environment: SQL Server 2000/2005/2008/2008 R2, T-SQL, Data Transformation Services (DTS), Business Intelligence MS SQL ServerIntegrated Services (SSIS), Business Intelligence MS SQL ServerReporting Services (SSRS), MS Excel, Visual Studio, SQL Job Agent.

SQL Server Developer

Confidential, Addison, TX

Responsibilities:

• Participated in gathering the business requirements and Database Specifications.
• Created Database objects using T-SQL - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Worked extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into OLAP
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Conduct unit tests of ETL processes, and reports.
• Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server.
• Production Support and maintenance.
• Worked with end customers and non- technical staff to resolve incident tickets.
• Ensure crucial project deadlines/milestones are met without compromise on Quality of the work Product.
• Involved in fixing the acceptance bugs reported, coding based on the enhancements.
• Performed complete impact analysis on system software due to suggested modifications/ enhancements and prepared detailed design documents identifying program and database design changes required for successful implementation of change module.
• Resolve the issues and update the correction documents in intranet to share the information using SharePoint.

Environment: SQL Server 2005/2008, T-SQL, Business Intelligence MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), Visual studio 2005/ 2008.

Software Developer

Confidential, Irving, TX

Responsibilities:

• Worked as a SQL Server Developer writing complex stored procedures using T-SQL and .Net Developer building web applications.
• Created few add-on web pages using HTML and JavaScript for Web applications.
• Responsible for writing many business consolidations logics through complex stored procedures coming from various data sources using MS SQL Server 2000/2005/2008.
• Used multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Oracle, XML, flat files to SQL Server databases using SSIS
• Developed features for an ASP.NET Tricolor Auto website using C#, HTML,Javascript, Visual Studio 2010, .NET 3.5.
• Performed DBA duties such as Index tuning, query optimizations using Sql Server profiler, Execution plans, Database Tuning Advisor.
• Used VSS and TFS as the Source Control.
• Knowledge in developing Client/Server and Web Applications.

Environment: MS SQL Server 2005/2008, T-SQL, Business Intelligence - MS SQL ServerIntegrated Services (SSIS), Visual studio 2005,SQL Agent, SQL Profiler, Database Tuning Advisor -DTA, T- SQL, Asp.NET, HTML, Java Scripting

BI Developer

Confidential, Los Angeles

Responsibilities:

• Worked as a SQL Server Developer writing complex stored procedures and SSIS packages, SQL server reports (SSRS).
• Used Erwin for data modeling.
• Responsible for writing many business consolidations logics through complex stored procedures coming from various data sources.
• Responsible in writing complex matching rules on various string manipulation logics.
• Developed various integration Services packages using SSIS for the first time in the company to automate and make user friendly applications for which I was appreciated.
• Generated weekly reports for higher product management team using SSRS
• Performed DBA duties such as Index tuning, query optimizations using Sql Server profiler, Execution plans, Database Tuning Advisor.
• Used Visual Source Safe (VSS) as the Source Control.
• 24/7 production watch throughout project.
• Involved in unit testing and bug fixing

Environment: SQL Server 2000/2005/2008/2008 R2, T-SQL, Data Transformation Services (DTS), Business Intelligence MS SQL ServerIntegrated Services (SSIS), SQL Server Reporting Services (SSRS)

Software Engineer

Confidential

Responsibilities:

• Involved in Development and Production Support of the application.
• Worked on PAHub product which provides security and reliability for patients, pharmacies using the .Net framework technology with integrated Microsoft SQL Server.
• Involved in the complete life cycle of the project.Gathered requirement from the client, then created Business Requirement Document.
• Involved in developing business and data access layer for Domain Health care related products using C# and ADO.NET
• Used ASP.NET validation controls (Required Field Validator, Regular Expression Validator, Compare Validator, Range Validator), User Controls, Custom Controls, Data Grid Web Control.
• Involved in building WebForms with functions using ASP.NET, C#.
• Implemented Data List and Data Grid controls for displaying data in customized format.
• Developed flexible, more user interactive and user-friendly GUIs, reusable classes, functions using C#.
• Created complex stored procedures, sql scripts, functions, cursors using MS SQL Server 2005.
• Implemented Stored Procedures to call in the business layer (ADO.Net) for use of Web layer.
• Used ETL (SSIS) tool to extract data from various data sources and built adhoc medical reports and involved in performance optimizations.
• Good experience in working directly with clients/users in gathering the requirements and document it well accordingly.
• Knowledge in developing Client/Server and Web Applications.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), T-SQL, HTML, CSS, Java Scripting, C#.NET, ASP.NET, ADO.Net