SUMMARY

• Over 8 years of diversified experience in Information Technology relating to T - SQL Development, Installation, Configuration and Migration SQL Servers 2000/2005/2008.
• Strong experience in MS SQL Server suite of products like Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Enterprise Manager, SQL Server Analytical Services (SSAS) and SQL Query Analyzer.
• Experienced in designing, developing and deploying complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Extensive experience in creating Tables, Views, Stored Procedures, Functions, Triggers using T-SQL.
• Updated and Migrated heterogeneous databases into SQL Server.
• Expertise in creating Indexes, Partitions and Query Optimization techniques to maximize performance.
• Experience in implementing SSRS solutions, dashboards, gauges and proven ability in defining Queries for generating drill down and ad-hoc reports in SSRS 2005.
• Developed complex cascading reports using SQL Server Reporting Services (SSRS).
• Experienced in designing and developing MS SQL Server DTS & SSIS packages.
• Experienced in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX Queries in SSAS.
• Knowledge of Object Oriented Programming, .NET Framework 2.0/3.5, ASP.Net, C#, ASP, HTML, CSS and XML.
• Experienced in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Development, and Testing.
• Critical thinker who is a self-starter and willing to take the initiative and work with little supervision.
• Systematic, disciplined and has an analytical and logical approach in problem solving.
• Ability to work in tight schedules and efficient in time management.
• Collaborate with client’s complex business requirements, and translate them into efficient database solutions.

TECHNICAL SKILLS

• T-SQL
• SQL
• C#.NET
• XML
• ASP.NET
• CSS
• HTML
• WINDOWS
• LINUX
• SQL-SERVER
• ORACLE
• MS-ACCESS
• ERWIN 4x
• ERWIN 7x
• Microsoft Visual Studio
• SQL Server Management Studio (SSMS)
• Business Intelligence Development Studio (BIDS)
• SQL Query Analyzer
• Microsoft SQL Server Query Analyzer and Enterprise Manager
• MS SQL Server Reporting Services (SSRS)
• SQL Server Integration Services
• SQL Server Analytical Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential, Westborough, Massachusetts

MS SQL Server Developer

Responsibilities:

• Completed tasks to specification and on time with minimal supervision.
• Upgrade DTS packages to SSIS packages.
• Utilized metadata to find table relationships and create queries to extract data for QA.
• Designed SQL jobs to perform maintenance on the SQL server.
• Aided in the retirement of a server that generated alias values for credit card numbers.
• Provided support for an ASP.Net application with a SQL Server 2000 Back End.
• Assimilated complex business logic requirements to design and implement Stored Procedures, User Defined Functions, Views and TSQL Scripts.
• Constructed technical documents for the stored procedure and schema requirements.

Environment: Windows XP, MS SQL Server 2000/2005, MS SQL Integration Services 2008, T-SQL, .NET

Confidential, Wilmington, Delaware

MS SQL Server Developer (SSRS/SSIS)

Responsibilities:

• Designed and developed database solutions based on functional requirements.
• Implemented database solutions that met expected quality standards.
• Monitored project status to meet milestones and resolve issues that might impact on quality or the ability to deliver to timescales or estimates.
• Produced technical design documents for the schema and stored procedure specifications.
• Troubleshoot production, real-time performance and concurrency issues.
• Deliver work on time and to specification, with minimal supervision.
• Created Stored Procedures, User Defined Functions, Views and TSQL Scripting for complex business logic.
• Created Stored Procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirements.
• Responsible for migration of data from SQL Server 2005 to SQL 2008.
• Migrated heterogeneous databases to MS SQL Server 2008.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Designed and created different ETL packages using SSIS from Oracle source to SQL server as destination.
• Created SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets.
• Designed and implemented SSIS packages for data integration.
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them.
• Extensively worked on Cross tabbed and Matrix reports using SSRS.
• Designed and implemented indexing to optimize transactional and reporting performance.
• Implemented data integration processes to handle XML file generation or processing.
• Coordinated with web development team in .Net framework programming solutions.
• Integrated ASP.Net Web Pages to the SQL Server 2008 Back End.

Environment: Windows XP, MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, MS SQL Integration Services 2008, T-SQL. ERWIN7x, .NET

Confidential, New York, NY

MS SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Created SSIS Packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, Bulk Insert Task, Data Flow Task, File System Task, and Send Mail Task.
• Migrated packages from Heterogeneous ETL tools to SSIS.
• Created AD-Hoc Reports, Standard Reports, Drill down Reports, and Parameterized Reports.
• Uploaded reports on to the report manager and organized them in folders using ‘pulled’ and ‘pushed’ methodologies.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Designed, and developed reports in MS SQL Server environment using SSRS-2005 and deployed reports to SQL Server Report Manager.
• Built effective queries for high-performance reporting and rendered them to HTML, XML and Excel format using Reporting Services (SSRS).
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Actively supported change requests from business users.

Environment: Windows XP, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Integration Services 2005, T-SQL.

Confidential, New York, NY

MS SQL Server Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Optimized existing schemas through normalization and de-normalization techniques.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, cross tabs and charts.
• Migrated homogeneous databases from SQL Server 2000 to SQL Server 2005.
• Created packages using SQL Server Integration Services (SSIS) from various database into different file systems.
• Involved in the installation and of the Reporting Services and its components.
• Configured and maintain Report Manager and Report Server for SQL Server Reporting Services (SSRS).
• Created Tabular and Matrix Reports using Report Wizard and Report Designer and identifying datasets, data regions and Report Items accordingly.
• Developed complex expressions to calculate, group, filter, and format the contents of a report.
• Created parameterized reports using Stored Procedures and Query report parameters and cascading parameters.
• Created complex reports and enabled drill down functionality and applied the required formatting.
• Developed Sub Reports and Master Reports accessible by bookmarks.
• Managed and scheduled Reports Subscription as well as added new users and assigning appropriate roles.
• Created various Report Models based on the business requirement.
• Created Ad-hoc reports based on the requirement.
• Tested, debugged and troubleshot reports.
• Deployed and published reports to the Report Server.
• Implemented high performance OLAP solutions for data mining (SSAS).
• Developed Cubes using SQL Server Analytical Services (SSAS) for better Business Analysis.
• Involved in cube designing using SSAS 2005 and involved in the cube optimizations, named set calculated measures, aggregations, partitions and Time dimensions.
• Created develop complex SQL queries using various joins, sub queries and stored procedures.

Environment: Windows XP, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Integration Services 2005, T-SQL.

Confidential, Ft. Lauderdale, FL

MS SQL Server Developer/ SSRS/SSIS Developer

Responsibilities:

• Maintained logical and physical data model, documented stored procedures and data flows.
• Responsible for optimizing queries with slow performance by use/nonuse of indexes, replacement of cursors wherever possible by other multilevel queries and by adding effective expressions.
• Deployed packages on different servers by configuring them.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Provided strong data consistency and integrity using various levels of constraints.
• Performed data massaging through queries.
• Wrote simple packages and stored procedures for the data migration.
• Redesigned the logical schema to meet the new requirements and to make it scalable for future needs.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Developed reports using SSRS like table control, matrix control for cross tab reports.
• SSRS installation and report server configuration and configured IIS and Deployed Reports and Analysis Project in to server.
• Wrote new stored procedures and updated old ones to support and provide accurate data back to the front end.

Environment: Windows XP, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Integration Services 2005, T-SQL.

Confidential, Fairfield, OH

MS SQL Server Developer/T-SQL Developer

Responsibilities:

• Involved in designing the data model using ERWIN 4.0 tool.
• Created Tables, Stored Procedures, Functions, Packages, and Triggers using T-SQL.
• Created database Constraints to ensure referential integrity and parent - child relationships.
• Performed Extraction and Transformation of data, using DTS, to support the data warehousing and reporting needs.
• Generated rollup and summary tables to present summarized views of transactional data.
• Created derived, computed columns by merging data elements.
• Developed reports in Crystal Reports 8.0.
• Created database Views and queries to combine data from multiple data sources including Excel.
• Created Indexes to optimize the performance of the SQL Server database.
• Used Triggers to Insert, Delete and Update data in the database and to enforce Data integrity.
• Assisted in preparing installation and technical documents.

Environment: Windows XP, MS SQL Server 2000, T-SQL,Data Transformation Services (DTS), ERWIN, Crystal Reports 8.0