SUMMARY

• About 6+ years of professional experience on Design, Development and Maintenance of Database using tools of MS SQL Server 2005/2008/R2/2012 for both OLTP and OLAP Systems.
• Conversant with all phases of Software Development Life Cycle(SDLC) involving Systems Analysis, Design, Development and Implementation.
• Worked with organizations in diversified domains mainly Insurance and Healthcare.
• Design and implementation of Microsoft SQL Server 2000/2005/2008 , Microsoft Access databases. Extensive knowledge in coding of complicated T - SQL in Microsoft SQL Server, and in-depth working experience in Oracle.
• Command over implementation of TSQL functionality like Stored Procedures, Functions, Packages, Triggers, views, and created/modified tables for data extraction, data load and transformations.
• Experience implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages.
• Worked with different data sources in SSIS Packages like ADO .Net, OLE DB source, ODBC source, Excel, flat file source
• Extensive experience in designing reports using SQL Server Reporting Services (SSRS).
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Excellent Communications, problem solving and documentation skills, proven analytical skills with good communication skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, C#.Net

Databases: SQL SERVER, MS-Access, MY SQL, Oracle 10g and DB2

Operating Systems: Windows 2008, 2003, 2000, NT 4.0, 95/98/XP/Vista/7

Software Engineering: SQL Server Management Studio, SQL Server Visual Studio Business Intelligence,ASP.Net 4.0, ASP, HTML, AJAX, HTML5Agile, SDLC

PROFESSIONAL EXPERIENCE

Confidential, IL

SQL Developer

Responsibilities:

• Dynamically supported business users for given requirements and developed the reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and created/modified tables for data extraction, data load and transformations.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS

Environment: SQL Server Management Studio, SQL Server 2012, MS sql Profiler, Visual Studio 2012, Team Foundation Server, MS SQL Integration Services, MS SQL Reporting Services, Windows server 2003/2008.

Confidential, Alpharetta, GA

SQL Developer & SSBI

Responsibilities:

• SQL server 2008 R2/2010/2012 Production Database Administration for over 50 servers.
• Installation of the Microsoft SQL Server 2010 and 2012 on Production, Staging and Development servers in the VMWare hosted environments
• Develop and maintain maintenance plans, evaluated scheduled jobs and monitored performance during various job runs
• Designed and implemented customized high availability solution which included Transactional Replication, Failover clustering and database mirroring to support critical applications.
• Worked with SQL Server Profiler to generate traces and Performance monitor to generate counter logs to analyze various server issues.
• Authored T-SQL scripts for data partitioning, Error handling through TRY-CATCH statement, and Common Table Expression (CTE).
• Configure and maintain Report Manager and Report Server for SSRS
• Design/Build Extract Transform Load procedures in SQL Server 2008R2 to import/export data feeds to/from data warehouse and claim system.
• Implementing the snapshot isolation and DDL triggers.
• Perform SSIS error handling into a common console that contained job name, start time, run time, error messages and link to Meta data report
• Worked on Data center servers, Resource Capacity planning and handling 1.4 TB size databases
• Involved in Source Data Analysis and designing mappings for data extraction for ETL activity.
• Managed the metadata associated with the ETL processes used to populate the Data Warehouse.

Environment: Windows Server 2008 R2 - 2012, Enterprise, SQL server 2008 R2-2012, DB2,Management StudioT SQL, SQL Server Integration Services (SSIS), SSRS

Confidential, MI

SQL Developer

Responsibilities:

• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Programmed SQL Server 2008 Reporting Services using Microsoft Visual Studio 2008.
• Created database objects for improving the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Involved in creating SQL reports.
• Created new views, wrote stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• 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.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: Windows 2000/2003 Advanced Server, SQL Server 2000/2005, MS SQL Server Management Studio, T-SQL, SQL Server Integration Services (SSIS),SSRS.

Confidential

SQL Developer

Responsibilities:

• Developing packages to support Web services Application.
• Worked with development of SSIS package project with Fixed width Columns for text files output
• Worked on multiple files as input source and transformation applied based on one input source data to handle another source data in a single package.
• Worked with script task and script component with C# coding and also involved in debugging C# code.
• Implemented Lookup transformations in the packages
• Debugged packages and tuned packages
• Created Stored Procedures and SQL queries to support the packages
• Tuned stored procedures and SQL queries supporting packages and reports.
• Normalized database objects and implemented data integrity by constraints, unique indexes, default constraints, referential constraints.
• Implemented Pivot and Unpivot transformations in the package.
• Implemented merge SQL commands in SP’s and Packages.
• Worked with Pivot and un-pivot SQL for SSRS Reports
• Created SSRS reports with different chart styles
• Extracted data from XML columns to the packages as source.

Environment: Windows Server 2000/2003 Enterprise, SQL server 2000/2005, DB2, MS SQL Server 2005 Management Studio, T-SQL, SQL Server Integration Services (SSIS),MS Visual Studio.