SUMMARY

• Having around 7 years of IT experience in Microsoft Technologies SQL Server 2012/2008which includes Administration, System Analysis, Design, Development, Testing, Security and Support in Microsoft Database Technologies with various Industry verticals like Education, Banking and Financing.
• Experience in all phases of Software Development Life Cycle (SDLC).
• Experienced in using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
• Experienced in using Microsoft SQL Server Management Studio (SSMS)
• Excellent in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Expertise in writing T - SQL (DDL, DML) queries, stored procedures, database triggers and exception handlers.
• Involved in creation and debugging of Complex SSIS packages using different kinds of sources and destinations.
• Knowledge of relational and multi-dimensional database schemas.
• Having good knowledge on creation and scheduling of SQL server agent jobs to run daily ETL’s.T-SQL (Design & Development)
• Experience in Normalization and De-Normalization techniques
• Performance tuning of stored procedures and slowly running queries
• Experienced in upgrading DTS packages to SSIS 2005, 2008 and 2008 R2 Packages
• Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS and Bulk Insert utilities.
• Experience in providing logging, error handling by using event handler and custom logging forSSIS Packages.
• Experience in performance tuning in SSIS packages by using row transformations, block and unblock Transformations
• Experience in scheduling and monitoring ETL processes using DTS Exec utilities and batch files.
• Extensively used control & data flow transformations like OLEDB command, execute SQL task, sequence container, derived column, conditional split, lookup and script component task etc.,
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports, filters, charts using SQL Server Reporting Services, MS Excel.
• Experienced in creating Ad-hoc reports, data driven subscription reports by using Report Builder
• Experienced in using global variables, expressions and functions for the reports.

TECHNICAL SKILLS

ETL Tools: SQL Server 2008,2012 Integration Services

Reporting Tools: SQL Server 2008,2012 Reporting Services, SSMS, Query Analyzer, Profiler, SQL/Database MAIL, SQL Agent, ETL

Analysis Services: SQL Server 2008,2012 Analysis Services

Database: SQL Server 2012/2008/2005/2000 , MS Access 2007/2003/2000 , Oracle PL/SQL

Languages: T-SQL, Store Procedures, Trigger, Web Design, HTML, JavaScript, Asp.Net, C#

Operating Systems: Windows server 2008 R2, Windows server 2003, Windows8/7

SQL Server Utility: SSMS,SSIS/DTS, Jobs, ODBC, OLEDB, DBCC

Web Servers: MS Internet Information Server, Apache.

Ticketing Tools: Team Foundation Server(TFS2010)

PROFESSIONAL EXPERIENCE

Confidential, CA

Business Intelligence Developer (SSIS, SSRS)

Responsibilities:

• Involved in translating business requirements into technical design specifications.
• Followed the different phases of Data Warehouse development lifecycle (converting business requirements to logical design and translation to physical design)
• Designed and implemented stored procedures, views and triggers for automating tasks in TSQL.
• Created permanent tables, temporary tables, variables and indexes.
• Created ComplexStored Procedures, User Defined Functions, Views, and Alter, Insert Update statements for the User Interface, Reports and SSIS Packages.
• Used Query Profiler to optimize SQL queries.
• Developed and executed several optimized queries in SQL.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.
• Developed and tested ETL Packages usingSQL Server 2012 Business IntelligenceDevelopment tools - Integration Services, Analysis Services & Reporting Services
• Designed and developed various SSIS packages to import data from Excel and Flat files to SQL Server 2012/2008 R2.
• Designed and deployed various complex reports using MS SQL Reporting Services.
• Developed various types of reports as Drill Down, Drill Through, tabular, chart reports etc with SSRS.
• Prepared Documents of each process involved, Developed complex stored procedure using T-SQL to generate reports using SSRS 2008.
• Created subscriptions for the reports in SSRS.
• Involved in Designing and deploying cubes in SSAS environment using Star Schema Designs.
• Involved in Rebuilding Partitions for cubes.
• Involved in writing scripts and transactions to manipulate data in the database.
• Involved the technical review of SQL code with peers and design review with end-user audience.
• Involved in documentation of Reports, SSIS Packages, Tables, Stored Procedures, and User Defined Functions etc.

Environment: Windows server 2008 R2,MS SQL server 2012,MS SQL Server 2008 R2, Windows 7, SQL server management studio, SQL server business intelligence studio, SQL Server Integration Services (SSIS), MS Reporting Services, T-SQL, Query Analyzer, MS Access 2010, MS Excel 2010,MS office 2010.

Confidential, MN

MS SQL Server Developer/BI Developer/SSIS/SSRS

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Designed a complex SSIS package for data transfer from different firm sources to SQL Server 2008 R2.
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Extensively worked on SCD transformation in SSIS package.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Successfully deployed SSIS packages with defined security.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Drill-down, Sub reports and parameterized reports.
• Generated reports on employee information, department information, performance reports using ad-hoc reporting to be used by the clients and advisors.
• Created number of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Indexes.
• Performed development support, document reviews, test plan, integration of the system.

Environment: Windows server 2008 R2, Windows server 2003, MS SQL Server 2008 R2, SSIS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profiler, MS excel, Visual Studio 2010/2012 (BIDS),TFS.

Confidential, MI

MS SQL Server Developer/ SSIS, SSAS, SSRS

Responsibilities:

• Extensively worked with the Business Users gathering their requirements and actively cataloguing and supporting various issues and providing their solution.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing and transferring the data from different systems.
• Used linked server to access the objects from the Oracle data source for the mapping of source tables to destination tables.
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures various kinds of reports using SSRS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view
• For the users automation exported the SQL Database to Access and migrated the Access Database from users into SQL 2005
• Used SharePoint for deploying .rdl files and uploading of the internal business documents.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.
• Created web forms using .NET components, on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data-sources.
• Experience in developing Life Cycle using Agile Methodology.
• Experience in optimization of queries, improving the performance and maintaining the database consistency with DBCC at regular intervals.
• Supported the front application developers for queries for development hierarchies, file upload and validations using ASP. Net.
• Extensively used T-SQL statements and created multidimensional cubes for the analyzer and used pivot table to help the end-user get familiar with cube.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Used indexes to enhance the performance of individual queries and enhance the stored procedures.
• Provided information and assistance to the database administrator on physical models, setup and maintenance of database.

Environment: MS SQL Server 2008, SQL Server 2005 Analysis Service, MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008, T-SQL, SSMS

Confidential, OH

MSBI Developer

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within the company.
• Responsible for making sure reports are scheduled and delivered in a timely manner
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Created ad Hoc and parameterized various reports using SQL server 2005 reporting Services with data from SQL Server as data source
• Scheduling reports using Reporting services to e-mail with an attachment in the desired format of report to the top management.
• Designed and built the dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)

Environment: Microsoft SQL Server 2008, Microsoft SQL server 2005, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Windows server 2008 R2, Windows Server 2003, Microsoft Excel, Microsoft Visual Studio, VB.net

Confidential

MS SQL Server Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Configured Exchange Server for sending automatic mails to the respective people when a job failed or succeed
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and also used Bulk Insert.
• Created documentation as required.
• Performance tuning, and optimization of procedures and queries.
• Responsible for the creation and maintenance of entity relationship diagrams

Environment: MS SQL Server 2005/2000, Windows 2000/NT/XP, DTS, T-SQL, Query Analyzer, SQLProfiler and Enterprise Manager