Professional Summary

• Experienced in database design, development, administration and maintenance of SQL Server 2008 /2005 /2000 large scale databases .
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing, Data Scrubbing and Data Migration.
• Experience in Microsoft stack of BI solutions - SSRS, SSIS with MS SQL 2008/2005,
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Experience using Crystal Reports to create different types of reports from various sources.
• Good in Extracting, Transforming and Loading (ETL) data from various sources to several destinations using BCP utility, DTS and SSIS.
• Experienced in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2000 to SQL Server 2005.
• Experience in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

Education: Bachelor in Computer Application

Certificates:Base and Advance SAS,MCSA,MCSE,MCTS,MCITP,CEH,CHFI,CCNA

Skillset: MS SQL Server 2000/2005/2008, Server Reporting Services,Crystalreports SQL Server Integration Services ,SQL Server Analysis Services, SQL,OLAP,OLTP,ODBC,MS Access, C, Windows NT/2000/XP/Server 2003, T-SQL, PL/SQL, HTML,SAS programming

Projects Summary:

Confidential Jan 2011-Feb 2012
Jr SQL Programmer
CONFIDENTIAL is a business and technology service company,Confidential provides training for diffrentsoftwares across all industries.The main aim of the project was to write T-SQL queries,createtables,views andcreat reports.

Responsibilities:

• Installed and Configured SQL Server 2008 enterprise edition per client request and Successfully implemented indexes on tables for optimum performance.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Created SSIS package to extract data from MS Excel, Access to SQL 2008 and Creating report
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Created reports like drill down, drill through and parameterized reports using reporing services in SSRS.
• Used report builder to create reports from given data source.
• Transformed complex business logic into database design and maintaining it by using SQL objects like stored procedures, functions, views, T-SQL scripting and jobs.
• Developed stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting services.
• Good knowledge in normalizing and de-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split and Successfully managed Extraction, Transformation and Loading (ETL) process by pulling data from various data sources using BCP in staging database from MS Access, Excel.

Environment:MS SQL Server 2008, SSIS, T-SQL, SQL Reporting Services 2008, Crystal Reports,Visual Studio 2008,Report builder.

(Confidential) Sep 2012-Present
New York City, New York
SQL Developer/Support Analyst

Responsibilities:

• Using SQL Server Integration Service to extract data from various sources like Excel, Access to SQL Server 2008.
• Working on SQL Server Reporting Services 2008 to create reports like drill down, drill through and also parameterized reports.
• Also working on Crystal reports 10 to create report using SQL server, Excel, Access as data source.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Reports were scheduled to be executed and sent to the client via email.
• Using Data Transformation Service to extract data from various sources and load it to SQL server 2008 or from SQL server 2008 to Excel and Text File.
• Using DTS to transfer data from various sources to SQL server using VPN connectivity for respective client.
• Using SQL profiler to optimize the performance of created stored procedures using trace.
• Troubleshooting for company’s own software and to give support to the client including application itself and also from SQL server.

Environment: SQL Server 2008 and 2005, SQL Server Integration Service, SQL Server Reporting Services, Crystal Reports, Data Transformation Service