PROFESSIONAL SUMMARY:

• Around 8 years of Experience in Microsoft BI tools (SSIS, SSRS)
• Experience in writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012 for Batch Processing using DDL, DML, DCL commands for various business applications and Data warehousing Systems (SSRS, SSIS, SSAS)
• Experience in database programming in writing T - SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Experience in developing SSIS packages to bring data from Claims databases to data warehouse tables.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL server 2008R2 and 2012.
• Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Good knowledge in Tuning SQL queries & improving teh performance of teh Database.
• Used TFS 2012, 2013, 2015 for restoring teh code and maintaining changes. Experience in creating tasks, check in and check out solution or code into TFS
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports.
• Experience in writing expressions in SSRS and Expert in fine-tuning teh reports. Created much Drill through, Parameterized Reports and Drill Down reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008)
• Experience in deploying Reports to Report Server. Creating user interface on Report Server for teh users to access reports on Report Manager.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Experience in Designing and Building teh Dimensions and cubes wif star schema using SQL Server Analysis Services (SSAS).
• Good understanding of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience in Creating number of cubes, dimensions and critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008r2/2012/2014

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS).

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008/2005

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

Languages: C,C#, T-SQL

Web Technologies: Web Services, XML, HTML

Operating System: Windows 98 /2003/NT/XP/7, MS DOS

Applications: MS Visual Studio 2010, MS office2003/2007/2010, HTML/DHTML, XML,Visual Studio IDE

Protocols: HTTP, TCP/IP, FTP

PROFESSIONAL EXPERIENCE:

Confidential, Naperville, IL

SQL BI Developer/SSIS/SSRS

Responsibilities:

• Analyzed data contained in teh corporate database and identify data integrity issues wif existing and proposed systems.
• Written Complex stored procedures to load teh form tables from teh client data. Created indexes and keys to improve database performance. Used CTE's, Table variables, Functions, triggers, views as per teh requirement
• Optimized teh stored procedures which are using cursors and increased teh performance.
• Designed SSIS packages to transfer teh data from Excel, CSV, XML, Text, database tables to database. Used data flow task, Script component, OLEDB command, derived column, data conversion,execute package task, for each loop container, sequence container.
• Used data flow task in parallel to improve performance. Also used some package properties to propagate errors.
• Identified teh potential Issues dat occur during teh package execution by redirecting teh rows from source component to Error Output.
• Used Expressions in Data flow task and for each loop container or looping over multiple files in a folder.
• Analyzed teh database tables and created Facts and Dimensions. Created ODS and BI database as per teh functional documentation.
• Developed ETL (SSIS) packages to load teh ODS tables and marking teh old data to inactive.
• Written Stored Procedures to transfer teh ODS data to BI and developed ETL’s to maintain teh BI data.
• Used TFS for storing code and packages. Good knowledge on checking in and checking out teh code and creating work items in TFS.
• Monitored teh existing DTS packages and migrated few to SQL server 2012.
• Developed Custom and Core reports as per teh end user requirements
• Developed drill down, drill through, Tablix, cascaded and parameterized reports using SSRS. Published teh reports on to SharePoint server.
• Created general and data driven subscriptions in SharePoint server
• Developed excel pivot chart reports and pivot tables. Monthly Refreshed teh Excel Dashboard Reports designed using Macros.
• Migrated SQL server databases to Azure and worked on Data factory to transfer teh data vice versa.
• TEMPEffectively involved in all scrum, agile and code review, daily standup meetings to understand teh business and discuss progress.

Environment: T-SQL, MS SQL Server 2012/2014/2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual studio 2012,2013,2015.Business Intelligence Development Studio (BIDS),C#,.NET Framework, Team foundation Server(TFS), SharePoint, MS Excel, Windows 2008 R2, Microsoft windows server 2012.

Confidential, Rosemont, IL

Sr. SQL BI Developer/SSIS/SSRS

Responsibilities:

• Designed SSIS packages to transfer teh data from flat files, Access database and excel documents to teh Staging Area in SQL Server 2012.
• Written Complex stored procedures, Functions, Triggers for data transfer and loading.
• Involved in high level architectural design discussions for designing teh MDF (Meta data framework) tables which store teh business and supplier data.
• Created T-SQL queries, Excel Macros to insert teh complete file information and layout to MDF tables.
• Developed SSIS package to automatically watch for teh files dropped into SFTP site and load them into data warehouse.
• Used ForEachLoop container, sequence containers, Execute package task, FTP to loop over all teh file formats and load them to database.
• Used various tasks like Execute SQL task which calls stored procedures wif parameters, Script component task for reading teh file and removing trailer records.
• Created source, stage and archive folders as per teh requirements using expressions in file system task.
• Used execute process task for unzipping teh zipped files.
• Created package configuration using parent package as variable and used them to deploy packages into SQL server and various environments.
• Developed master package which calls teh child packages and loads teh files to stage and history tables in GDW.
• Errors in teh file will be logged into teh DIF (data integration framework) tables and an email will be sent to business people to get back to suppliers wif correct file information.
• Avoiding multiple load of teh same file using flag column in MDF table. Accommodating MDF to handle new set of files.
• Scheduled Packages using SQL Server Agent Jobs to run every 5 min.
• Developed ETL Dashboard Monitoring reports, Execution summary reports.
• Developed parameterized, drill down, drill through and cascaded reports.
• Used TFS to check in and check out teh changes made to code.

Environment: T-SQL, MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS),Team foundation Server(TFS), SharePoint, MS Excel, Windows 2008 R2, Microsoft windows server 2012.

Confidential, Cary, NC

Sr. SQL BI Developer/SSIS/SSRS

Responsibilities:

• Designed SSIS packages to transfer teh data from DB2, flat files and excel documents to teh Staging Area in SQL Server 2012.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications. (Admin rights for dis operation).
• Used various Data Flow Transformations, like Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing teh packages.
• Used Event Handlers for Error Handling and Alert Operations.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in teh mapping document.
• Scheduled Packages using SQL Server Agent Jobs, Monitoring nightly jobs.
• Used SSIS Variables for storing teh values, which are used in various components of Data Flow Task.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Identified teh potential Issues dat occur during teh package execution by redirecting teh rows from source component to Error Output.
• Monitoring SSIS packages, Stored Procedures running in Agent job and support teh Production Team.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential - Durham, NC

MSBI Developer

Responsibilities:

• Extensively used T-SQL in constructing user functions, views, indexes.
• Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas.
• Good in script task. Validated teh records which was retrieved from teh database using c# code
• Got a good knowledge on Team Foundation Server (TFS) to maintain databases up to date and we also use TFS for storage of updated scripts and also to avoid teh data loss.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Trouble shoots same SSIS packages by logging method before forwarding to quality analysis (QA) testing.
• Separated teh body and header records using c# code in script task.
• Configuring SSIS packages when migrating packages from 2005 to 2008 R2.
• Validated teh header records using script task(c# code).
• Experience in refreshing teh databases and also know how to check wif orphan users.
• Experience in working wif SQL Server Agent Jobs and also scheduling teh jobs to SSIS packages is my daily job.
• Used integration services (SSIS) to extract data in to teh tables from XML files
• Involved in configuration and Maintenance of SQL server Agent Jobs
• Log files creation and improvement using Custom Component
• Developed SSRS report to analyze migrated data (Sales Force) for core objects and child objects.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: Microsoft SQL Server 2008 R2 Enterprise Edition, SSIS, C#, Share Point Windows Server, windows 7/XP, Visual Studio 2009 & TFS.

Confidential - Atlanta, GA

Programmer Analyst

Responsibilities:

• Generated and debugged complex stored procedures and functions for performance tuning and optimization.
• Created complex functions and views based on teh business requirements.
• Developed stored procedures for complex sub queries and joins using multiple tables.
• Migrated data from SQL server 2005 to SQL server 2008.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas.
• Created MDX queries to access teh cube information.
• Created and configured cubes using SQL Server 2008 analysis services.
• Coordinated wif source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Developed and maintained various cubes using MDX complex queries in SSAS.
• Extensively involved in teh SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve teh Problems.
• Tested and standardized teh data to meet teh business standards using Fuzzy /exact lookups.
• Designed and deployed various reports using SSRS.
• Worked closely wif business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2008 reporting services (SSRS).
• Built TEMPeffective queries for high-performance reporting and rendered them to HTML, XML, PDF and MS Excel format using Reporting Services (SSRS).
• Defined relationships between Measure groups and Dimensions.
• Deployed teh generated reports on to teh Report server and fine-tuned teh database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2008/2005, T-SQL, Windows Server 2008, SSAS-2008/SSIS-2008/ SSRS-2008.

Confidential

Database Developer

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned teh SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Designed teh Logical and Physical design of database for projects on basis of user requirements.

Environment: MS SQL Server 2005, T-SQL, SQL Windows Server 2003, and MS Access and Excel.