SUMMARY

• A Microsoft Certified Professional with around 5 years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2005/2008/2008 R2.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008.
• Experience in using temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in Microsoft Visual C# in script component of SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Worked with report manager for deploying the reports across all the environments.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Developed Word merge reports in MS Word.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Operating Systems: Win 2000/NT/2003/2008 server.

RDBMS: MS SQL SERVER 2008/2005/2000 , MS Access.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005, Query Editor, Reporting Server, MS-Access, ETL Tools Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

Reporting Tools: Crystal Reports XI/X, MS SQL Server Reporting Services (SSRS).

BI Tools: MS SQL Business Intelligence, Business Objects.

Programming Languages: VB.Net, C#.Net, Asp.Net, HTML and XML.

PROFESSIONAL EXPERIENCE

Confidential

Product Developer (SQL Server/SSIS/SSRS Developer)

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Developing ASP.net pages for front, creating services
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: SQL Server 2008/2005, SQL Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB

Confidential

Product Developer

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Prepared the complete data mapping and Report Definitions for the project which involved around 10 reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Conducting training sessions to new employee of SSRS.

Confidential

Programmer.

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Customize the crystal reports as per client’s requirements.
• Fixed data issues.
• Designing & developing stored procedures, functions, triggers & indexes etc database objects.
• Tuned SQL queries and procedures for better performance.
• Developing crystal reports, Excel reports, HTML/ASP pages for front end reporting & supportive data entry screens
• Involved in the client and account manager call.
• Conducting training sessions to new employee of crystal reports, coding guidelines.