Summary

• Over Six years of strong experience in the IT industry as a MS SQL Server Developer.
• Experience with software development life cycle (SDLC) and Project Management Methodologies.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008.
• Experience in Data Warehouse Development environment using Microsoft DTS, SSRS.
• Expertise in Creation and Maintenance of Procedures, Triggers and Functions.
• Experienced in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
• Used XML with in Stored Procedures and complex queries.
• Excellent experience in Notification Services and Reporting services in SQL 2005/2008.
• Strong knowledge of Database Development and RDBMS Management Concepts, Practices and Procedures.
• Experienced in Data Loading using T-SQL, Fine Tuning of Database and improving Performance, Creating new Database, Creating and Modifying Table space and Optimization
• Experience in writing SQL Loader scripts for Extract, Transformation and Loading of Data.
• Expertise in SQL Query Performance Analysis skills and Ability to Redesign for Optimal Efficiency.
• Experience in performance tuning using SQL server profile and Database index tuning wizard.
• Knowledge of Software Development Life Cycle.
• Excellent Communication, Analytical skills and Interpersonal skills. Exceptional ability to learn new concepts. Skilled at accessing client needs, working in a group, suggesting ideas that enhance Efficiency and Maximize Performance, Implementing Cutting-edge Technology Solutions and Training/Supporting end users.

Education
Masters in Business Administration
Bachelors in Computer Applications

Technical Skills
Programming Languages: C, C++, T-SQL
Web Skills: HTML, XML, XSL, VBScript
Web Servers: MS Visual Studio
Databases Technologies: SSRS, MS-SQL, SQL 2005, 2008, 2008 R2
Databases\\Data Access: SQL Server 2000/2005/2008, Oracle, MS Access
Tools and Utilities: Divtalk, Visio, Crystal Reports, MS Visio 2003, Code
Analyzer, Query Analyzer, SQL Profiler, Database Engine Tuning Advisor
Operating Systems: Windows 2000/XP/7, Windows 2003/2008

Professional Experience

Confidential,NJ Nov 2011 – Present
SQL Developer
Project: Absolute Return Pool
Responsibilities:

• Created and modified stored procedures, functions, views and indexes to provide best performance.
• Used Stored Procedures in different complexes queries in SQL Server 2008 environment.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity
• Helped in developing a web application for the Absolute Return Pool which replaced the existing Excel application.
• Designed the Physical and logical data model.
• Wrote User defined functions, views and stored procedure for reports and application pool performance screens.
• Migrated data from Excel sheets to database using bulk load.
• Wrote stored procedures in SQL server.
• Deployed database builds in Development and QA systems.
• Maintained database scripts in Team foundation.
• Participated in Quality processes such as design reviews, code reviews, version control and documentation.
• Used SSRS to create customized reports and adhoc reports.
• Created scheduled jobs for daily process to migrate data from other servers.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary reports, Cross Tab reports using MS SQL Reporting Services 2005 & 2008
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan.
• Improved the performance of production reports by analyzing the underlying query and report objectives.
• Deployed and Scheduled the Reports in Report Manager using data driven subscription, Ad-hoc report using Report Builder.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS.
• Created Ad-hoc reports for managers using SSRS to immediately have them get access to the reports on the fly and generated reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Develop different account level and security level reports using SSRS.
• Build ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Performed debugging and resolved data issues occurred while accessing the reports in QA and Production environments.
• Created report models and deployed on report server.
• Exported the created reports into Excel and PDF.
• Experience in generating on-demand and scheduled reports for business analysis.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Created user defined functions in SSRS using VB script.
• Created SQL Server Reports using SSRS 2005 and exported them to Excel format for managers and Quality Assurance team for easy validation.

Environment: Windows 2003, Windows XP, MS SQL Server 2005 & 2008, MS Visual Studio, Team Foundation Server, T-SQL, SSRS.

Confidential,PA Jan 2011 – Nov 2011
SQL Developer
Virtual Inventory Management System
Responsibilities:

• Designed login and physical model for system using ER Studio.
• Wrote SQL job to generate pending orders using stored procedures.
• Generated the drilldown, drill through, Parameterized and linked reports using the SSRS.
• Done so many ad-hoc reports for one time purpose according to the customer requirement.
• Developed some SSRS Reports in the Production Environment.
• Wrote procedures for Health Center and pharmacy reports.
• Wrote User Defined Functions (UDF) required for application.
• Worked on performance tuning and maintained database and application.
• Wrote stored procedure to load data, drugs information, and drug database.
• Done the performance tuning which includes maintenance optimizing SQL statements and Stored Procedures and monitoring the server.
• Done the code reviews, maintained the version control and done the documentation for all the work I have done.
• Monitoring the event logs and Server error logs for troubleshooting purposes.
• Created views for drug and package size calculation.
• Also responsible for stored procedures code review.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced the database structures and database objects.
• Wrote several complex stored procedures for the ease of application.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Excellent command on subscriptions, report snapshot and report cache.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Environment: Windows XP, MS SQL Server 2005/2008, T-SQL, MS SQL Server 2005, SSRS 2005, SSIS 2005, T-SQL, Performance Point, Data Analyzer, Visual Studio 2005, VB Script, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2.

Confidential,CA Mar 2009 – Dec 2010
SQL Developer
Responsibilities:

• Created database scripts, stored procedures, triggers, tables, views, indexes using T-SQL in SQL Server 2000.
• Involved in design and generation of various reports using Crystal Reports.
• Used all Declarative Constraints for maintaining Data Integrity.
• Done the code reviews, maintained the version control and done the documentation for all the work I have done.
• Monitoring the event logs and Server error logs for troubleshooting purposes.
• Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.
• Involved in scheduling backups of databases and logs and restoring them when necessary.
• Involved in managing the replication environment.
• Improved the performance of production reports by analyzing the underlying query and report objectives.
• Documented the existing and newly created production reports and shared them through the share point server.
• Created SQL server Reports on different plans using SSRS for the manager and the brokers involved.
• Interact with the business community to functionally analyze requirements and design reports either from Legacy data sources or from the data warehouse.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created parameterized reports and ado reports using Report builder for the users and management.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
• Performed debugging and resolved data issues occurred while accessing the reports in QA and Production environments.
• Designed various test cases for migrated reports testing.
• Created views for security purposes, implemented rules, defaults, and user defined data types.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: MS SQL Server 2000, Windows 2000 server, Windows NT 4.0, DTS

Confidential,India. Apr 2007 – Oct 2008
SQL Developer
Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Provided information and assistance to the database architects on physical models, and the setup and maintenance of metadata.
• Performed backup/ restore, database objects such as tables, procedures, triggers, views, constraints and indexes.
• Identified the data source and defining them to build the data source views.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Performance tuning to optimize SQL queries using query analyzer.
• Hands on experience in rendering reports for online viewing, document management and for data exchange as excel, CSV file and XML file.
• Created indexes, constraints and rules on database objects.
• Created various weekly and monthly reports showing detailed information.
• Defined unknown members and null processing properties.
• Created indexes, constraints and rules on database objects.
• Transformed the complex business logic and calculations into coding.
• Worked in coordination with development team to deploy and test the application.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005, MS Access Windows XP.

Confidential,India Jan 2006 – Mar 2007
SQL Developer
Responsibilities:

• Worked with team members to define requirements for applications.
• Created data model for new tables using VISIO tool.
• Created database schema as per requirements.
• Written stored procedures and user defined functions for document management, discussion forums, user registration modules.
• Created user defined data types.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects.
• Created various weekly and monthly reports showing detailed information.
• Defined unknown members and null processing properties.
• Created indexes, constraints and rules on database objects.
• Transformed the complex business logic and calculations into coding.
• Worked in coordination with development team to deploy and test the application.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005, MS Access Windows XP.