Objective

• Seeking SQL Server Technical Leader position (.Net/MSSQL) in which to use my skills and talents to help company meet or exceed short and long - term goals.

SUMMARY

• Over 6+ years of experience in Analysis, Design, Documentation, Development, Testing and Implementation in Client/Server applications using Microsoft SQL Server 2005/2008/2008 R2 and BI Suite for various Business domains.
• Expertise in Relational Database Management Systems using SQL Server 2000/2005/2008.
• Extensively used SQL Reporting Services to generate reports and deployed reports to Report Server.
• Wrote queries to generate reports for analysis of data.
• Involved in generating summary reports; Tabular, Matrix, Parameterized and Drill down using SSRS.
• Expertise in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with Import/Export data, Bulk insert and BCP.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008R2/2005.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues.
• Expert in generating drill down Reports in SSRS 2005/2008.
• Created and modified attribute hierarchies within SSAS for accurate reporting purposes.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Expertise in using BI Reporting Tools like SSRS, Performance Point Server, ProClarity, Crystal Reports.
• Expertise in using Zena Application Tools like Design the Process, Co - coordinating with multiple servers.
• Experience in design, development, testing and maintenance using SDLC process.
• Excellent OO analytical, design and programming skills.
• Strong skills and experience in Object-Oriented Programming using the .NET framework.
• Demonstrated proficiency in development using Microsoft.NET technologies like VB.NET, ASP.NET, C#.NET, WCF, LINQ, ASP.Net MVC and AJAX Extensions with MS SQL Server (SQL ) and Oracle(TOAD, Oracle SQL Developer).
• Well versed with Source Control best practices and code management using TFS2010.
• Good experience in developing reports using Crystal Reports.
• Strong experience in developing Stored Procedures, Triggers, Indexes to improve performance of the site and to decrease the number of server side scripts to implement the business logic.
• Excellent Inter Personal, Leadership, Client Interaction and Communication skills.

TECHNICAL SKILLS

Computer Languages: C#, ASP.Net, VB.Net, ADO.Net, .Net Framework 2.0/3.0/3.5, C/ C++, SQL

Web Technologies: ASP.Net, ASP, ActiveX, HTML, DHTML, JavaScript, Web Service

Scripting and Markup Languages: JavaScript, VB Script, HTML, CSS, XML, XSL, XSLT, Silverlight

Project Management: MS Project

Databases: SQL Server 2008, Oracle 9i/10g, MS Access

Reporting Tools: Crystal Report 8/8.5/11, SQL Server Reporting Service 2005

ETL Tools: SSIS (MS SQL Integrated Services), Zena Application

Business & Portal Technologies: Microsoft Office 2010, Microsoft SharePoint 2010

IDE: Visual Studio 2003/2005/2008 , Visual Studio 6, Team Foundation Server 2010/2013

Operating System: Windows 2000/NT/XP/2003/Vista/7, Unix

Windows Frameworks: Windows Communication foundation (WCF), Windows Presentation Foundation (WPF), XML Web Service

Graphics: Photoshop

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL Developer

Responsibilities:

• Interaction with onsite client/business team to validate and clarify requirements for design/development
• Coding various enhancements of the modules in MS SQL, ASP.Net, .Net Framework and C#, WCF, Visual Studio 2010/2013 and other third party debugging tools and using TFS2010 as a source control.
• Reviewing and handling production defects in RMAS application
• Participate frequently in preparing IVB (Implementation, Verification and Backout) plans to deploy code in Production environment.
• Setting up source code and Scheduled Zena process for SQL related interface projects in Zena while working with multiple team projects.
• Creating and updating Zena processes with SSIS package usage, System Command, SQL Script usage, Zena agent access setup in multiple environments.
• Coordinate with Zena Admin team, DBA team, IIS Admin team to deploy code in multiple test and Production environment.
• Using multiple servers with Zena agents to coordinate with different interface process.
• Continuous improvement of process design and execution.
• Interactively participating during the client meetings and reporting project status to client regularly.

Environment: SQL Server 2008, Visual Studio 2010/2013, RedHat SQL Compare tool, MS Office 2010, MS SharePoint 2010, CASD Tool, HP Quality Center, Zena, Team Foundation System 2010. 2013

Confidential - Mclean, VA

SQL Developer (SSIS/SSRS)

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled this report to run on quarterly basis using SSRS (Reporting services).
• Have used Business Objects like crystal reports and Data ware housing.
• Have Migrated crystal reports to SSRS
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS)
• Created ad-hoc queries from SQL Server databases for custom reporting needs.
• Configure and maintain Report Manager and Report Server for SSRS.
• Used crystal reports along with visual basic to create design and test the reports
• Created SSIS Packages to retrieve PII user data from the Flat files on monthly and weekly basis.
• Created complex SSRS reports using data mart as well as from the SSAS Cube.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created views and restrict access to data in a table for security.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Worked on PL/SQL for extracting data from other oracle server database.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL.
• Promoted RDLs to Reporting Service Server.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Worked on other packages of the SQL server 2005 Edition SSRS (SLQ Server Reporting Services), SSIS (SQL Server Integrated Services).
• Used ETL tool to communicate with the many different relational databases and read the various file formats used throughout in the organization.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Performed Full and Differential backup with bulk-logged recovery models.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Used SQL Profiler for getting the trace activity for the Various Stored procedures and used Index Tuning wizard for performance betterment.

Environment: MS SQL Server2005,Visual Studio 2005, My SQL, Windows 2000, Windows XP, T-SQL, XML, ER Studio, SSRS, SSIS, PL/SQL, Oracle.

Confidential - Brentwood, TN

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Designed and created different ETL packages using SSIS to extract data and write the files to a mapped network drive or FTP it to cloverleaf.
• Applied Audits and Controls to all newly created SSIS jobs before PROD Deployment according to HCA’s Standards.
• Used SSIS, DMExpress to import data from two different sources (Teradata, Oracle) to a single destination like SQL Server 2008.
• Used various SSIS transformations like Derived column, Lookups, Conditional split to cleanse the data and used stored procedures for effective data transfer.
• Cleansed bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Created Visual Basic scripts in the Script task of SSIS for source file existence check, file move, compare file row counts.
• Used Remedy7.6 for all production deployment or changes.
• Created .bat files and .config files to run .dtsx packages and deployed it to production server.
• Schedule new jobs on daily or weekly basis by using doclib application, SQL Server Agent.
• Fixed Production job failures and documented them during the on call support week.
• Performance tuning of SQL queries and stored procedures using Execution plan, Query optimizer, SQL profiler, index tuning advisor and optimizing techniques.
• Wrote Dynamic SQL in stored procedures to extract data from each Region Databases.
• Worked on Union View stored procedures to include only object of schema type .dbo from the Region snapshot databases.
• Used Redgate to find the schema, object differences between any region snapshot databases before creating the Union Views.
• Wrote XQuery to extract patient data, stored in XML format.
• Extensively worked on the stored procedures and functions for creating the SSRS reports.
• Since they enhance the report performance and make it efficient to use.
• Developed and modified parameterized, drill down reports in SQL Server Reporting Services and rendered them to XML File, CSV, PDF, MHTML (web archive), Excel, TIFF and Word according to the Business requirement document.
• Involved in the PQRS project from planning stage to pushing codes to production.
• Designed ER Diagrams for the existing Physical model of the database using Embarcadero, Erwin.

Environment: MS SQL Server 2005/2008, Integration Services (SSIS), MS SQL Server reporting services (SSRS), T-SQL, Dynamic SQL, XQuery, XML, SQL Server Query Analyzer, Visual Studio, TFS, Embarcadero, DMExpress, FileZilla Client, Redgate, Windows XP, Window Server 2003/2008.

Confidential - Boston, MA

SQL Developer (SSIS/SSRS)

Responsibilities:

• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Fuzzy Grouping, Conditional Split, Bulk Insert, merge and union all.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Continuously interacted with users to gather business requirements.
• Actively involved in designing the logical and physical architecture for Liberty Mutual group database.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Designed, developed and troubleshoot the SSIS packages that implement complex ETL processes in the environments.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Experience in creating adhoc reports using Report Builder 1.0 and Report Builder 2.0.
• Created various reports by comparing the growth of employee appointment based on each quarter by using bar charts and Excel spreadsheets.
• Configured the report viewing security for various users at various levels using Report Manager.
• Data migration (import & export - BCP) from Text to SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Analyzed the Previous Data and predicted the forth coming Results.
• Documentation of all processes involved in maintaining the database for future .

Environment: MS SQL Server 2005/2008, Windows 2003 Advanced Server, MS SQL Server Integration Services (SSIS)2008, MS SQL server Reporting Services(SSRS), Microsoft Visual Studio 2008, SQL Server Management Studio(SSMS), MS Excel, T-SQL, MS Visio, Erwin Data Modeler, SQL Profiler.

Confidential

SQL Server Developer

Responsibilities:

• Completed the modeling architecture of the SQL server 2000 database.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on client/server tools like SQL server enterprise manager and Query Analyzer to administer the SQL server 2000.
• Configuring, tuning, and optimizing SQL server 2000.
• Performance testing on stored procedures, indexes, and triggers.
• Use of Insert, Delete, and Update statement as needs of business requirement.
• Data migration using bulk copy program and DTS.
• Helping the front end application developers with their queries.
• Perform low level scripting, fixing of codes and software enhancement process.
• Performed backup/restore, created database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Involved in Performance tuning, query-inventory, analysis and optimization.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.