SUMMARY

• Over 7 years of SQL Server Development and Reporting Services experience, Stored Procedure/TSQL coding, Performance and Tuning, Physical and logical Database Design.
• Proficient in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005/2008.
• Expert in development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005.
• Experienced in using Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005 for data conversion and data migration.
• Skilled in designing and developing Data Warehouses, Data marts and Business Intelligence using Star Schemas and Snow Flake Schema for developing Cubes.
• Strong experience in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse database.
• Highly experienced in creating scripts for monitoring and maintenance tasks, automated Database & transaction dumps, monitoring data received at 15 min interval and populating reporting tables.
• Proficient in creating and designing the report layout, sorting the data, defining subtotals and generated Reports like parameterized reports, drill down reports using SSRS 2005.
• Expert in SQL Server 2000/2005 Reporting Services.
• Expert in developing Stored Procedures and Triggers in SQL-Server.
• Excellent knowledge in developing interactive sort reports.
• Excellent experience creating/publishing Dashboard reports, KPI’s, Scorecards, using Report Center to SharePoint 2007.
• Strong experience in formatting and publishing the SQL Server Reports.
• Excellent knowledge in maintenance and change management to existing reports and in optimizes report performance.
• Extensively developed, implemented and documented production DTS, SSIS packages.
• Expert in performance tuning and trouble shooting on database objects.
• Expert in providing database maintenance for MS SQL Server 2000/2005/2008 database.
• Outstanding oral and written communication skills.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• SQL Server Reporting Service 2005/2008
• SQL Server Analysis Services 2005/2008
• MS Access
• Oracle 9i/10g/11g
• Sybase 8
• Crystal Reports Enterprise 9/10
• HTML
• Windows 9x/NT/2000/XP/Server 2000/2003
• T-SQL
• PL/SQL
• VBScript
• JavaScript
• ODBC
• ADO. Net
• C#
• VB.NET
• .NET Framework 2.0/3.0/3.5
• MS Visio 2003
• Microsoft Office SharePoint Server
• IIS 5/6.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Server Developer/BI Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirements.
• Created Views to reduce database complexities for different kinds of users like per month users
• Created database and data warehouse with data from various sources, both local and remote for reporting purposes.
• Created SSIS packages to extract data from various sources (eg. Excel files, Flat files, CSV files) for reporting purposes.
• Created checkpoints for packages and enabled logging for all packages.
• Created OLAP cubes for analyzing data for reporting purposes.
• Implemented MS Analysis Services tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Created and integrated User Defined Functions and Stored Procedures for reporting purpose.
• Created T-SQL Triggers and Stored Procedures to retrieve updated and deleted data from different servers from different locations for reporting purposes.
• Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created high quality reports, dashboards and analytics to meet the needs of various business clients such asOperations, Sales, Customer Service, Finance, and Executives.
• Created Sub-Reports, Drilldown-Reports for the clients.
• Scheduled Summary Reports, Parameterized Reports and Ad Hoc reports for viewing purposes by the managers for the analysis purpose.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.

Confidential, Roseland, NJ

MS SQL Server Developer/BI Developer

Responsibilities:

• Defined data source and data source views for each report as per client requirement.
• Created complex SSIS packages to extract data from various sources for reporting purposes.
• In the capacity of team lead, trained team members in developing ad hoc reports using report model designer, report builder and report manager
• Developed complex Stored Procedures, triggers, cursors, tables, constraints, views and other SQL joins and statements for applications.
• Developed cubes for OLAP reports
• Implemented cube partitioning and defined browsing perspectives within cubes
• Designed and implemented report layouts.
• Created SQL server Reports using SSRS 2005
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Created summary reports, sub-reports, drill down reports and drill through reports using the payroll OLTP database or the payroll OLAP database as per client requirement
• Developed forecast reports as per business requirements
• Developed high quality reports, dashboards and analytics to meet the business needs
• Responsible for Debugging reports using Stored Procedures.
• Responsible for debugging stored procedures using MS SQL Profiler
• Responsible for deploying the generated reports as per client requirement
• Created small .NET applications for querying database by integrating LINQ to Sql queries inside a WCF service.
• Created simple C# and VB.NET based web services in the .NET Framework for deploying reports
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Confidential, Bridgewater, NJ

MS SQL Server Developer/ETL/Analysis Services Developer

Responsibilities:

• Created scripts for the client’s requirements for reporting purposes.
• Performed in the capacity of team lead, with a team of three individuals (myself excluded)
• Performed R/3 Extraction from MM, SD, PP and created own data sources or customized the Inbuilt data sources and did unit test on data source whether it is working properly or not.
• Customized the SAP provided Function Module and generated views and extract structures for R/3 data extraction.
• Migrated scripts from SQL Server 2000 to SQL Server 2005.
• Created logical and physical data warehouse design for business purposes.
• Integrated SQL and SAP servers using SSIS 2005.
• Developed SSIS project for transferring the data.
• Created cubes and dimensions using SSAS 2005.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Automatic generation of grouping attribute members.
• Defined Granularity with in a measure group and drill through actions.
• Implemented calculations to aggregate physical measures.
• Defined the Browsing Perspective and Browsing Translations.
• Responsible for identifying KPIs in SSAS 2005.
• Responsible for Process Database Objects Security Role.
• Responsible for writing T-SQL code for creating cursors and handling the data validations.
• Developed complex T-SQL code for the application.
• Transformed the complex business logic and calculations into coding.
• Developed stored procedures, functions, tables, views and triggers.
• Created subscription and tabular reports using SSRS 2005.

Confidential, Atlanta, GA

MS SQL Server Developer/ BI Developer

Responsibilities:

• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created stored procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Implemented data mart, facts, dimensions, snowflake schema and OLAP cubes
• Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Responsible for converting reports from Lisa 98(Lumber Inventory Software Automation) to SQL Server Reporting Services.
• Worked in visually enhancing reports as per user requirements.
• Responsible for tuning and optimizing queries for the reports.
• Expert in SQL Server Management Studio interface for writing queries and stored procedures.
• Created and maintained Roles and Database users.
• Created database objects like views, indexes, user defined functions, triggers and stored procedures.
• Responsible for troubleshooting the reports.
• Maintained DTS 2000 Packages and migrated them to SSIS

Confidential, Atlanta, GA

MS SQL Server Developer

Responsibilities:

• Installed SQL Server 2000 on servers.
• Designed SQL Server 2000 database.
• Involved in Logical & Physical design, development and testing of the system.
• Administrated SQL Server 2000 under NT in an enterprise scale network.
• Responsible for understanding the customer requirements.
• Participated in meetings with the client and team members.
• Developed triggers and stored procedures to in corporate the business logic and process.
• Troubleshoot performance issues, fine-tuned queries and stored procedures.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Performed Data Integrity Validation.
• Developed a total of 100+ stored procedures for front-end application and reports.
• Involved in design, programming, deployment and Unit Testing of requested Reports.
• Involved in the creation of web services using VB.NET
• Designed, Developed and Deployed reports in MS SQL Server environment using SQL Server Reporting Services-2000.

Confidential

Database Developer

Responsibilities:

• Designed and develop Data warehouse on SQL Server 2000 involving data from various platforms including Oracle, Sybase, SQL Server 7/2000, MS Access and IBM AS/400 to enable enterprise-wide reporting and analysis.
• Developed DTS package to extract data from Sybase 8 and Oracle database and insert into MSSQL
• Created and scheduled Oracle jobs using Oracle dbms scheduler
• Setting up and maintenance of testing environment.
• Developed small .Net application for testing.
• Involved in the creation of web services using C#, VB.NET and ASP.Net in the .NET framework per client requirement