SUMMARY:

• Nine plus years of experience in Development, Design, Working experience of MS SQL Servers in Production, QA, Development environments.
• Overall database design, such as creating normalized databases, tune queries, assigning proper indexes, creation of triggers and stored procedures.
• Experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services.
• Flexible and versatile to adapt to any new environment and work on multiple projects.
• Experience in creating Ad hoc reports and tuning of reports.
• Excellent knowledge in RDBMS concepts and constructs.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS and SSIS Packages.
• Extensive knowledge of MDX and creating cubes.
• Experience in Data cleansing or data scrubbing.
• Experience in working with version controlling tools for managing SQL scripts and changes that are going to production.
• Transformed data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Good understanding of capacity planning.
• Extensive knowledge of Relational Database Management Systems.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Experience in Database Backup, Recovery procedures.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Hands on experience in trouble shooting database issues.
• Experience in writing and debugging stored procedures and triggers.
• Experience in Data Modeling using ERWIN tool and normalization of tables.
• Creation of users, configuring permissions and assigning roles to users.
• Experience in scheduling SSRS reports using subscriptions.
• Hands on experience in writing T - SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and teh ability to think outside teh box.

TECHNICAL SKILLS:

Operating Systems: Windows 2003/2000,Windows XP, Windows NT 4.0 Server/Workstation, Windows 98/95, Terminal Server 4.0, Windows 2000 Advance Server, MS DOS, Unix.

Languages: C, C++, JAVA, XML, T-SQL, SQL Plus, ISQL, OSQL, VB Scripts, C#

RDBMSMS: SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0 and 6.5, Oracle, MS-Access

Front End: MS Visual Basic, Dream Weaver

Internet Technologies: ASP, Java Script, HTML

OLAP Tools: MS OLAP Services Manager

Version Control Tools: SVN, Visual Source Safe, TFS

Reporting tools: SSRS, Crystal Reports, Cognos Reporting

Other Tools: Idera Diagnostic Manager, Quest Spotlight, SQL Lightspeed, ERWIN 3.0, Toad, Crystal Reports, SQL Backup, SQL Developer.

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS),SSIS, Visio, SSAS,SSRS

WORK EXPERIENCE:

Confidential, New York, NY

Sr. Developer

Responsibilities:

• Developed stored procedures, views, triggers and user-defined functions using T-SQL.
• Created email and file share subscriptions on report manager to share teh reports to teh clients.
• Used monitor all subscription jobs and sends email alerts to teh reporting team.
• Developed and deployed and monitored SSIS Packages.
• Generated teh weekly, monthly, and quarterly report by using SQL Server Reporting Services.
• Tuned of Stored Procedures and SQL Queries and created some indexes on tables.
• Created SQL Server jobs for SSIS packages and scheduled them and monitored them.
• Created table, views and modified tables, views based on new requirement.
• Documented teh whole system and life cycle of teh project.
• Worked extensively with business analysts to gather requirements to generate customized SQL reports.
• Used stored procedures with parameters and SQL queries to generate teh reports.
• Created drill down reports based on teh requirement.
• Modified stored procedures and functions based on new business rules and deployed them.
• Generated reports using SSRS from cubes.
• Used Excel PIVOT tables to validate reports.
• Converted Crystal reports to SSRS reports.
• Created reports using QlikView and converted QlikView reports to SSRS reports.
• Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.
• Converted Oracle reports and procedures into SSRS reports and SQL Server stored procedures.

Environment: SQL Server 2008 R2/2012,SQL Server Reporting Services, SSIS, Windows Server 2003, Windows XP, C#, MS Office, VSS, Visio, Excel, QlikView, SSRS 2012.

Confidential, Boston, MA

Sr. Developer

Responsibilities:

• Created SSIS packages to export Data from Flat Files(IBM Mainframe) to SQL server.
• Created data driven subscriptions on report manager to use single subscription to distribute different reports to different clients.
• Created ER Diagrams for all tables which are used in SSIS packages and documented teh work flow.
• Used Views, Triggers, and Stored Procedures for updating and cleaning teh existing data and also teh new data.
• Generated Reports using SQL Server Reporting Services (SSRS).
• Deployed teh SSIS packages on different servers and tested those packages.
• Optimized Query Performance and Reliability.
• Created new tables and databases, normalized and indexed all teh tables.
• Written stored procedures for front end and halped teh front end application developers with their queries.
• Created Cube and Created reports using MDX queries.
• Created temp tables and table variables.
• Cleaned data and corrected corrupted data.
• Created all types graphs in reports using SSRS.
• Sent reports to teh clients using email subscriptions and file share subscriptions.
• Tuned of Stored Procedures and SQL Queries and created some indexes on tables.
• Created procedures using PL-SQL using SQL Developer.

Environment: Windows 7,VSS, MS SQL Server 2008,T-SQL,Visio, SSIS, MS Excel, MS Word, SSRS 2008 R2, C#, ASP.NET, DB2, Unix, MS Access, Oracle, PL-SQL,SSAS,MDX.

Confidential, Highlands Ranch, CO

Sr. Developer

Responsibilities:

• Created Data Sets and used teh data sets for different Reports.
• Created proper indexes for some tables for better performance of teh queries.
• Designed databases and tables for data warehouse.
• Created Mapping Excel Spread Sheets for export data between two databases.
• Created Visio diagrams for some data bases.
• Exported data from flat files to SQL server using SSIS packages.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Wrote complex SQL queries for data retrieval.
• Designed new data bases for Reporting purpose.
• Created stored procedures, tables, triggers, and views for data warehouse databases.
• Created new SSIS packages in place of old DTS packages.
• Documented teh guidelines for SQL programming.
• Worked on Exception Handling with @@error and with Try/catch.
• Created a report to notify teh status of all report subscriptions.

Environment: Windows Server 2003,Oracle,Cobol,IBM Mainframe, MS SQL Server 2005, VSS, SSIS, T-SQL, MS Excel,, MS Word, SSRS,C#, Sybase.

Confidential, Bloomington, MN

Developer

Responsibilities:

• Created Views and Extracted Data from teh Views and Modified some Reports also.
• Cleaned data in teh tables and removed some inaccurate records from tables.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Tuning of Stored Procedures and SQL Queries and created some indexes on tables.
• Loaded Data to Flat Files from SQL server using Integration Services.
• Created and Scheduling Jobs, Backups and Restore of Databases.
• Created stored procedures, triggers, views and Functions for front end requirements.
• Used XML data type in stored procedures.
• Created new tables and normalized.
• Created new ad hoc reports and tuned existing reports for best performance.
• Deployed all teh Integration Service Packages on Testing Server and successfully scheduled them.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.
• Suggested creating Clustered and Non Clustered indexes on tables.

Environment: Windows Server 2003, MS SQL Server 2005, T-SQL, MS Office Access 2003, VSS, SSIS, MS Excel, MS Word, C#, Sybase, DB2,Cobol.

Confidential, Montpelier, VT

Developer

Responsibilities:

• Extracted data from legacy system using SSIS(SQL Server Integration services)
• Wrote Store procedures to convert data logically as per teh business requirement.
• Created linked servers for multiple legacy systems using ODBC drivers and OLEDB Providers.
• Transform teh data using different components of SQL Server Integration Services.
• Loaded data into SQL Server using Integration Services.
• Wrote Triggers on to migrate teh data from current system to legacy systems
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints..
• Created Jobs and scheduled them for Backups and Restore of Databases.
• Loaded data through bulk inserts from Flat Files using Bulk Insert
• Analyzed teh current OLTP system to interface with legacy OLTP System
• Created Mapping Spread Sheet to map columns from current OLTP System (Source SQL Server) to legacy OLAP System (Target SQL Server)
• Converted some crystal reports to SQL Server Reports using SSRS.
• Wrote Triggers to Invoke Jobs to Transfer real-time data to OLAP.

Environment: Windows 2000, MS SQL Server 2005, T-SQL, MS Office Access 2003, VSS, MS Reporting Services(SSRS),SISS, MS Excel, Oracle, PL-SQL,ASP.NET.

Confidential, Nashville, TN

Developer

Responsibilities:

• Developed SSIS packages to export data from OLTP database to OLAP database.
• DDL Scripts for generating Tables, Views, Functions etc.
• Using Views, Triggers, and Stored Procedures for updating and cleaning teh existing data and also teh new data.
• Generated T-SQL scripts for application development.
• Created cursors and User Defined functions.
• Created Indexes to speed up teh queries.
• Created Views for Extracting Data.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Using Bulk Insert to move large data from Text files to SQL Server.
• Scheduling Jobs, Backups and Restore of Databases.
• Helped teh front end application developers with their queries.
• Generated SQL reports using MS Reporting Services.

Environment: MS SQL Server 2005, MS Outlook, TSQL, VSS, Visio, SQL Server Business Intelligence Development Studio, Informix, DbVisualizer 4.2.2, SSIS, MS Reporting Services(SSRS),C#,MS Access.

Confidential, Lexington, KY

Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000.
• Successfully migrated old data from legacy system into SQL Server2000 using DTS Packages.
• Filtered bad data from legacy system using complex T- SQL statements, and implemented various constraint and triggers for data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into teh database.
• Created Reports using SQL Server Reporting Services (SSRS).
• Wrote complex stored procedures to process drivers record and balanced teh processing load between front end and back end.
• Implemented batch processing for approval process using Jobs and DTS.
• Created Users and Roles, and managed security and permission of database.
• Documentation of all teh processes involved in maintaining teh database for future .
• Actively participated in User Acceptance Testing, and debugging of teh system.

Environment: SQL Server 2005, Active x script, T-SQL, MS Excel, MS Access 2000, Erwin, Windows NT.

Confidential, Hollywood, CA

Developer

Responsibilities:

• Created Logical & Physical Database modeling for in house development application.
• Wrote complex stored procedures and cursors to implement various business logics as per teh client requirements.
• Performed Database Design, Data Modeling using Erwin.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Environment: Windows NT 4.0, MS SQL Server 2000, MS SQL Server 2005