SUMMARY

• 6 years of IT experience in Design, Development, Support of MS SQL SERVER 2008/ 2005/2000 BI Suite in development, Test and production environments.
• In - depth knowledge of T-SQL (DDL, DML), Business intelligence (BI), Integration Service (SSIS), Reporting Service (SSRS) and Crystal Reports.
• Experience in creating Dynamic SQL, joins, views, indexes, Unions, Merge, stored procedures, triggers, functions, constraints at various stages of migration, reports and data validation.
• Experience in creating complex Crystal reports and scheduling the report automatically.
• Expertise in Job scheduling and deployments so as to update changes in the Files, SQL Queries and Packages using SQL server agent.
• Expert level skills in Data massaging and cleansing of data by Extraction, Transformation and Loading (ETL) of packages using Business intelligence (BIDS), in Database and Packages Wizards like Import and Export, and Package Migration.
• Experience in requirement analysis design and development of a dimensional data model (star schema and Snowflake) and the development of ETL processes using SSIS.
• Experience in creating Master and Child Packages and worked with XML and SQL Table configurations for modifying the SSIS packages from a test/development environment to the production servers for day to day operation.
• Expert in error handling techniques and then trouble shooting them by Error Logging, Breakpoints, Event handling, precedence constraints and Package configuration.
• Developed multiple packages using Slowly Changing Dimension Transformation by using changing and historical attributes.
• Expert in creating weekly different types of reports like Tabular, Drill-Down, Parameterized and sub-reports using variables and expressions.
• Expert in Report Subscriptions and Reporting Services Configuration Manager tool.
• Creation and maintenance of Databases, Creating Roles, and Managing User Permissions.
• Experience in using tools like SQL Profiler, Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Good communication, problem-solving and multi-tasking abilities.

TECHNICAL SKILLS

Operating Systems: Windows 7, Windows Vista, Windows XP, Windows 2003

RDBMS/DBMS: MS-SQL Server 2008/2005/2000 , MS-Access 2000,2003

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (SSIS/SSRS/SSAS), Reporting Services Configuration Tool, Data Transformation Services, SQL Server Profiler, SQL Server Agent, Erwin4.x

Reporting Tools: SSRS, Crystal Reports 10.0,XI, HTML

Programming Languages: T-SQL, PL/SQL, C++.

Business Tools: Word, Excel, Power Point, Outlook, Adobe, Photoshop

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SQL - BI Developer

Responsibilities:

• At the staging server, data was loaded from different sources like flat delimited text files, and Excel spreadsheets to the SQL Server database tables and from SQL server database to output flat files, pipe (|) delimited HL7 messages.
• Extensively used store procedures and UDF functions such as scalar and inline functions for complex queries, Triggers, indexes involving multiple tables from different databases.
• Worked on Evaluation of SSIS packages and did error handling.
• Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Migrated Sql server 2000 DTS packages to 2008 SSIS packages.
• Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, and multicasting.
• Interacted with Strategic Development Team, Business analyst and Nurse Managers to analyze business needs and developed technical specifications.
• Created lot of custom reports for the pathologist using complex stored procedures and Crystal reports.
• Created Standard, Cross-tab, Sub reports and TAT reports for Pathology department management.
• Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS).
• Interacted with the existing database developers and DBA to understand the existing schema.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQLstatements before deployment to the productionserver.

Environment: MS SQL Server 2000, 2008R2, MS SQL Server Integration Service, Crystal Reports 10 and IX, MS SQL Server Reporting Services, T-SQL, Windows XP, Visual Studio 2008, MS-Access 2010.

Confidential, Bridgewater, NJ

SQL/BI Developer

Responsibilities:

• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Management Studio.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Configure the SSIS Package for run time Parameters and Configuration file.
• Created store procedures to calculate net return and Gross return of the Funds.
• Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation.
• Developed the Mailing Label Reports for the management by using the Crystal Reports.
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Creating dynamic Stored Procedures for Reporting in SSRS.
• Maintained scheduling of subscription reports with the subscription report wizard.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front end application.

Environment: MS SQL Server 2005, MS SQL Server Integration Service, Crystal Reports 10, MS SQL Server Reporting Services, Windows XP, MS-Access 2000.

Confidential, Boston, MA

SQL /BI Developer

Responsibilities:

• Interacted with business analyst, Development Team and Managers to analyze business needs and developed technical specifications.
• Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, fuzzy lookups, and multicasting.
• Created Standard, Couple Cross Tabs in Crystal reports for the Nurse Manager.
• Created and developed Parameterized, Drill Down, sub and linked reports and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS).
• Developed database objects such as Joins, Union All, Sub-Queries, procedures, Functions, Triggers, and Indexes using T-SQL, SQL Analyzer and SQL Server Management Studio.
• Created various complex reports for the different department by using Crystal reports 10.
• Data was loaded from different sources like flat delimited text files, CSV and Excel spreadsheets to the SQL Server database tables.
• Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, Derived column, Slowly Changing Dimension mechanism in different environments.
• Created staging environment in SQL 2008 for the data migration from different heterogeneous sources (CSV, Excel).

Environment: MS SQL Server 2008R2, MS SQL Server Integration Service, Crystal Reports 10, MS SQL Server Reporting Services, T-SQL, Crystal Reports 10,Windows XP, Visual Studio 2008, MS-Access 2010.

Confidential

SQL developer

Responsibilities:

• Monitored all activities of the server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
• Using T-SQL statements, worked with DML and DDL for retrieval and modification of the data.
• Created & used stored procedures for database transactions in SQL Server.
• Developed backup & restore scripts for SQL Server as needed.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler and creating index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: MS SQL server 2000, Query Analyzer, Windows server 2000, SQL server Profiler, T-SQL, MS Access.