SUMMARY

• Skilled software professional over 7 years of IT industry experience with Microsoft SQL Server, Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) environments.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
• Experienced using T - SQL in SQL Server platform.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL.
• Efficient in using Inner, Outer and Cross Joins, sub-queries for complex queries involving multiple tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environments and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Hands on experience in performance tuning, query optimization, and database optimization.
• Expertise in solving dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Experience in using Try Catch block introduced in SQL Server 2005.
• Good knowledge in using system tables such as sys indexes, sys processes, sys objects and sys comment in various queries and using Database Console Commands (DBCC).
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server databases.
• Migration experience with DTS to SSIS 2005.
• Well-versed in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, Send mail task, For loop container, For each loop container, Sequence container) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge, Multi cast, Derived column, Character map, Union all, Sort, Row count, OLEDB command).
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
• Experience in enhancing and deploying SSIS Packages from development server to production server.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Created Crystal Reports on daily, weekly and monthly basis for manager’s review.
• Strong experience in developing parameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS 2005/2008 using data from a variety of sources.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in Designing and Building the Dimensions and cubes with star and Snowflake schemas using SQL Server Analysis Services (SSAS).
• Experience in creating the MDX queries to access cubes and dimensions (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008/2005/2000/7.0, Oracle, MS-Access 2000/2003

Programming Language: T-SQL, C, C++,C#, PL/SQL, XML,HTML, VB .NET, Visual Basic 6.0

Operating Systems: Windows Server 2003, Windows XP/ 2000/ 95/ NT, Linux, UNIX

SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development, Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler Performance Monitor, Database Tuning Wizard, Import & Export Visual Studio Net

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

OLAP/ Reporting Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting services (SSRS) Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

SQL SSRS/SSIS Developer

Responsibilities:

• Create complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2008R2.
• Configured SSIS packages using Package configuration wizard to allow Packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, datamart databases.
• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created usage based aggregations in cube to minimize time for query retrieval.
• Create Different types of reports based on customer Request.
• Create Sub Reports and Drill-Through Reports and developer them to share Point Server.
• Working on performance tuning to Test the Query Execution.
• Created Ad-hoc Reports, Sub Reports, Drill-Through and Drill-Down Reports.
• Data migration using DTS services across different databases like Oracle, MS access 2003 and Flat Files and have experience in creating forms and templates.
• Created reports using the Morph-X development tools for Microsoft Dynamics AX and also create reports using Microsoft Dynamics AX reporting tools for Visual Studio.
• Have experience in Teradata and Teradata load utilities in SQL and in Oracle.
• Helped the tester in pay roll related data in data to decisions project.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.
• Worked with Walkthrough to Debugging a Batch that Runs on the AOS.
• Created Datasets inT-SQL, stored procedures forSSRS.
• Worked on Power View and Power Pivot and Share point 2010.
• Have knowledge on Unix-shell commands and basic knowledge on scripting (shell and Perl).
• Performed tests to identify and resolve performance related bugs. Designed and creation of performance test plans and test suites.
• Developed the test scripts and test scenarios.
• Involved in Testing Modules like: Dashboard, Reporting, Compliance, Sampling, Sourcing and Rules and Performed tests to identify and resolve performance related bugs.
• Created Reports in SSRSwith different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Coordinating with Team Lead & developers for defect analysis and their fixes.
• Involved in Integration, Regression, System, Non Functional Requirement, Ad-hoc, and Performance testing User Acceptance Testing phases for Release versions.
• Reviewed the Business Requirements document with the business and development teams to understand the architecture and functionality of the application.

Environment: Microsoft SQL Server 2008R2, Microsoft SQL Server 2012,Visual Studio 2008, Visual Studio 2010, T-SQL, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Team Foundation Server(TFS), Visual Source Safe and Share point 2010 MS Word, Ex-cell.

Confidential, Dover, NH

SQL Server BI Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business users.
• Created database objects like tables, views, stored procedures, functions, joins, indexes and triggers in T-SQL based upon the functional specifications.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code and optimized.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
• Involved in Data migration and legacy data cleansing validation.
• Involved in Building and unit testing production deployment packages and implementation plans for scheduled systems enhancements.
• Excellent skills in overall Defect Management/Problem solving including tracking bugs and reporting using Test Director.
• Performed Business Intelligence reporting and project management.
• Created documentation for SSRS reports and codes, and tested SSRS reports developed by other developers.
• Involved in Data Integration by identifying the information needs within and across functional areas worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Deployed SSIS package on the server and scheduled the packages using SQL Server Agent Services.
• Involved in populating data on various systems like Sybase Adaptive Server in linked server.
• Involved in populating data on various systems, generating data reports using Reporting Services (SSRS) and deploying them on the server.
• Worked on Power Pivot and Share point 2010.
• Designed and developed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS.
• Expertise in developing Ad-Hoc, Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Worked on Sybase Adaptive Server.
• Design and development of Business Intelligence Solutions using Informatica, Business Objects, Cognos and Erwin.
• Worked on Manual Testing tools like water fall and Agile Testing and Win Runner.
• Prepared test cases documents for data validation in SSRS reports.
• Tested T-SQL/ETL Testing based on requirement.
• Worked on Automation and manual testing for ETL.
• Written test cases tested them manually and automated test plans and scripts for regression testing using Win Runner.
• Well versed with all the testing concepts and methodologies and also involved in writing Test Scripts using QTP and Win Runner.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Reporting Services (SSRS), Windows 2003, MS Access, Report builder3.0, EXCEL,SQL Server Profiler, DTS, ASP.NET.

Confidential, NJ

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Created Database objects like Stored Procedures, Triggers, Cursors, Indexes, functions, views.
• Performed Index tuning for tables and used Scan and Seeks for performance tuning.
• Designed SSIS Package for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created dataflow and its relational models in Ms Visio.
• Migrated existing processes from SQL Server 2000/2005 to SQL Server 2008.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for the transformations.
• Performed data cleansing techniques using look ups, conditional splits, did data profiling.
• Migrated DTS packages of SQL Server 2000 to SQL Server 2005 to make them reused in new environment.
• Created SSIS package to fulfill the SQL Server maintenance tasks including rebuilding index, backing up database and updating statistics.
• Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
• Created event handlers on every executable in an SSIS package.
• Documented Processing times for each Module, developed Test Cases and used them to run through each Process.
• Involved in development of Business Intelligence Solutions using Informatica and SSIS.
• Involved in Designing moderately complex ETL and incremental updates supporting both OLTP and Data Mart environments.
• Developed T-SQL coding in Sybase Adaptive Server by using linked server concept.
• Database Design (Relational and Dimensional models) using Erwin.
• Performed database validation using SQL queries.
• Updated existing and created new reports using SQL Server Reporting Services.
• Built SSRS project to generate reports with desired formats (Word, PDF, Excel and etc) to present statistics information according to business requirement.
• Generated various reporting services RDL’S using reporting services for Account Aggregation reports. Identified and defined Fact relationships in SSAS for OLAP cubes.
• Created ad-hoc reports using Report Builder to provide a template for end-users for creating reports by themselves with preselected group of relational tables.
• Involved in full life cycle development of data mart and supported the existing BI platform for populating the data warehouse.
• Created perspectives, partitions, drill through actions and KPIs to enhance Cube’s utilization.

Environment: MS SQL Server 2000/2005/2008, SSIS/SSAS/SSRS, MS Access, Windows NT, Windows XP/ 2003/2000/98, MS SQL, ERWIN 7.0X, SQL Profiler, SQL Query Analyzer, T-SQL, MS SQL Server Integration Services 2008/2005, MS Office.

Confidential, New Jersey

SQL ETL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Created various Table and Views, Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Transformed the complex business logic and calculations into coding. Created and updated clustered and non-clustered indexes to keep up the SQL Server performance.
• Implemented T-SQL features like Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transformed data from various data sources like MS Access, MS Excel, and Oracle using OLE DB connection by creating various ETL packages.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Experienced with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Created List reports, Standardized Reports, On-Demand Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, Charts, Functions and Formulas.

Environment: SQL Server 2008/2005, Enterprise Edition, SSAS, SSIS, SSRS, T-SQL, MS Office 2003/2007, Share point Server 2007 (MOSS), T-SQL.

Confidential

MS SQL Server Developer

Responsibilities:

• Installed and configured SQL Server7.0 Servers and clients.
• Designed and developed the databases.
• Created a logical design and physical design of the data warehouse using star schema.
• Configured the DTS packages to run in periodic intervals.
• Extensively worked with DTS to load the data from source systems.
• Writing stored procedures and triggers extensively and working very closely with developers, Business Analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Created FTP connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.

Environment: Windows XP, SQL Server Business Intelligence, SSRS, T-SQL, MS Visual Studio 2005, Report builder.

Confidential

MS SQL Server Developer

Responsibilities:

• Interacted with end users to gather requirements, created technical, user documentation.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Write T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.

Environment: MS SQL server 2000, Windows 2000, HTML, SQL Server Management Studio.