SUMMARY

• 7 years of Experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite SQL Server 2000/2005/2008 R2/2010/2012 (Development, UAT and Production Environment on various business domains like Financial, Banking & BPO).
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R 2/2010/2012.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server ( 2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Great ability to create and manage various database objects like tables, views.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in using T-SQL in SQL Server 2000/2005/2008/2012 platforms.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in creating Parameterized Reports.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2012, 2010, 2008 R2, 2005, 2000, SQLCMD, Microsoft Office 2007/2003, MS-Access.

Language: C,C++,HTML,XML,TSQL,MYSQL,DHTML,VB.NET,ASP.NET,.NET Frame Work, C#, JavaScript

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports8.5,10,XI,R2,BusinessObjects,Microsoft office 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, Iselin, NJ

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Actively Participated in developing logical models and implementing requirements on SQL Server 2008.
• Wrote custom T-SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc to migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).
• Worked on creating cubes, calculations, KPI’s, deploy of cubes using SSAS.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed Data Modelling and Developed ER Diagrams using Erwin
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008, SQL BI Suite (SSAS, SSIS, SSRS), DTS, SQL Profiler, MS Office, Erwin, Windows Server 2003.

Confidential, NY

SQL Server SSIS SSRS Developer

Responsibilities:

• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services 2008.
• Experience in writing MDX queries for cubes and Performance optimization of MDX queries.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Experience in creating Ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Experience in using XMLA protocol for SQL Server Analysis Services for interaction between client application and instance of Analysis Services.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.

Environment: SQL Server 2005, T-SQL, SSIS, SSRS, SSAS, TFS, Windows Server 2003.

Confidential

SQL Developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer)
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager
• Created and administered multiple development, training and production databases
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check
• Responsible for creating standards and operating procedures to maintain all databases
• Worked with development teams in the design of physical databases and in modification
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks

Environment: SQL Server 2000, Windows 2003/2000 Server, Data Warehousing, C, CPP, C#, .NET, Rational Rose Enterprise

Confidential

SQL Server Developer

Responsibilities:

• Designing and implementing the module based on the business requirements given by the business.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Generating Script files of the databases when ever changes are made to stored procedures or views or any other database objects and checking the object
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures & maintaining Referential Integrity.
• Monitoring MS SQL Server performance and network issues.
• Creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.
• Backing up system & user databases and restoring them whenever necessary.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, T-SQL, Windows 2003/2000 server.