PROFESSIONAL SUMMARY:

• SQL Server/BI developer with over 8 years of IT experience in Database/Data Warehouse design, development & administration using Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS).
• Expertise in creating/modifying Tables, Views, Stored Procedures, Functions, indexes and Triggers and in depth knowledge in query optimization & performance tuning.
• In-depth experience of Transact-SQL (DDL and DML) operations and Experience in optimizing the database by creating various Clustered, Non-clustered indexes.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS), Bulk Insert, BCP.
• Experience in building robust Architecture to organize Data flow from various homogeneous and heterogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in migration of data from heterogeneous database like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS and SSIS / ETL.
• Proficient in using DTS packages and BCP utility including extensive knowledge of exporting and importing data to and from SQL Server to any OLEDB and ODBC provider.
• Experience in developing and deploying reports using MS SQL Server Reporting Services (SSRS) 2012/2008R2/2008/2005.
• Experience in creating ad-hoc reports by using Excel and Report Builder in SSRS 2012/2008R2/2008/2005.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Developed and deployed OLAP cubes using SQL Server Analysis Services (SSAS) 2012/2008R2/2008/2005.
• Experience in designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Expert in Database Normalization, DE normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Experience in developing physical database architecture using ERwin Data Modeler and MS Visio 2003/2007.
• Excellent Analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.
• Ability to work independently or as part of a team to accomplish critical business objectives as well as good decision making skill under high pressure complex scenarios.

TECHNICAL SKILLS

RDBMS / Databases: MS SQL Server 2012/2008R2/2008/2005, Oracle 11g/10g/9, MS-Access 2007/2003

Languages: T-SQL, PL/SQL, HTML 4.0, XML,XSL, VB.NET,C, C++,C#,.NET, ASP.NEThttp://asp.net/

Operating Systems: Windows Server 2008/2003/XP/2000/NT/98/95, MS DOS 6.2

Modeling Tools: Microsoft Visio 2007, ERwin Data Modeler 8/7/5

Reporting Tools: SQL Server Reporting Services ( SSRS ), Tableau

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

Analysis Service: SQL Server Analysis Services (SSAS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor ( DTA ),, DB2 Server, Sybase Server, SQL Assistance,, Red Gate SQL Compare, Toad for Data Analysts

Internet Tools: Internet Information Server ( IIS 5.0 / 6.0 ), FTP, TCP/IP

Other Tools: Microsoft Office 2003/2007, Tortoise Subversion 1.5

PROFESSIONAL EXPERIENCE:

Confidential, NewYork, NYC

Sr. SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for the entire project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Created ETL/SSIS packages to extract data from various sources FTP, Excel, Flat files to SQL Server systems using different SSIS components and used dynamic configuration files and variables for production deployment.
• Performed data cleansing by creating staging tables to eliminate the dirty data using MS SQL Server Integration Services 2008 (SSIS).
• Coordinated with the business users to design and develop the Price Challenge System as BAU.
• Coordinated with the business users to design and develop reports that improved the access to financial and order management data using SSRS 2008.
• Worked with advanced data regions like Tablix, Matrix, Gauges, Charts, Rectangle, and Textboxes and generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using MS SQL Server Reporting Services (SSRS).
• Generated report using different kinds of tools like Tableau, SSRS .
• Generated report in Excel Power Pivot..
• Developed SSRS solution for the business users to insert/update/delete the data directly into database tables using SSRS report and this solution helped in minimizing user requests.
• Designed the Data Model using MicroSoft Visio 2010.
• Involved in designing, reviewing, and creating primary objects like Tables, Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints using T-SQL in MS SQL Server Management Studio 2008.
• Build SQL Development environment for the users side of the business that helped the team to develop and test the applications/processes first in Development environment before deployment to Production environment.
• Handled Slowly Changing Dimensions(SCD) in order to maintain the history of the data.
• Performance tuning of the triggers and Store Procedures to attain optimization.
• Set up the initial DEV/QA/UAT Data Base environments .
• Backed up the Database during the User Testing.
• Solving QA defects, scheduling fixes, providing support to production application.
• Developed Test Cases for unit testing .
• Used JIRA to assign tasks to the team members for fixing the issues/ bugs and kept tracking of the issues.
• Involved in design and development of Aggregation services for all index queries
• Developed Production Data Reconciliation against data repository
• Developed Custom Index backfill process
• Daily load of Instrument Data from Bay Files with History
• Design& Implement Operational Data Repository for the Instrument DB.
• Created various ad-hoc reports by defining SQL queries within excel that helped refreshing the data directly from the SQL databases on weekly and monthly basis.
• Provided Production support.
• Experience in working with tools such as Toad for Data Analysts, SQL Assistant, Tortoise SVN (Subversion) and Red Gate’s SQL Compare.

Project Environment: Windows 2008 Server, Microsoft SQL Server 2008/2012, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), C#,MS SQL Server Agent, MS Excel 2007, MS SharePoint, Oracle11g, Toad for Data Analysts, SQL Assistant, Tortoise (SVN) Subversion 1.5.

Confidential, NewYork, NYC

Sr. SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for the entire project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Created ETL/SSIS packages to extract data from various sources like SAP, Teradata, Excel, Flat files to SQL Server systems using different SSIS components and used dynamic configuration files and variables for production deployment.
• Performed data cleansing by creating staging tables to eliminate the dirty data using MS SQL Server Integration Services 2008/2012 (SSIS).
• Coordinated with the business users to design and develop reports that improved the access to financial and order management data using SSRS 2008/2012..
• Worked with advanced data regions like Tablix, Matrix, Gauges, Charts, Rectangle, and Textboxes and generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using MS SQL Server Reporting Services (SSRS).
• Generated report using different kinds of tools like Tableau, SSRS, OBIEE.
• Generated report in Excel Power Pivot using SSAS Cube.
• Developed SSRS solution for the business users to insert/update/delete the data directly into database tables using SSRS report and this solution helped in minimizing user requests.
• Defined Multidimensional Expressions (MDX) Scripts for querying the data from OLAP Cube (SSAS) and build SSRS reports on top of cube.
• Developed MDX Scripts to provide a specialized syntax for querying and manipulating the multidimensional data stored in OLAP Cube (SSAS).
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints using T-SQL in MS SQL Server Management Studio 2008.
• Build SQL Development environment for the Accounts Receivable side of the business that helped the team to develop and test the applications/processes first in Development environment before deployment to Production environment.
• Created various ad-hoc reports by defining SQL queries within excel that helped refreshing the data directly from the SQL databases on weekly and monthly basis.
• Experience in working with tools such as Toad for Data Analysts, SQL Assistant, Tortoise SVN (Subversion) and Red Gate’s SQL Compare.

Project Environment: Windows 2008 Server, Microsoft SQL Server 2008/2012, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), C#,MS SQL Server Agent, MS Excel 2007, MS SharePoint, Oracle11g, Toad for Data Analysts, SQL Assistant, Tortoise (SVN) Subversion 1.5.

Confidential, West Chester, PA

Sr. Data Warehouse/SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with business analysts to identify, design and implement solutions for (ETL) extraction and integration of data to and from databases for the purposes of data extraction and reporting using MS SQL Server Reporting and Integration Services 2008 (SSRS/SSIS).
• Designed ETL/SSIS packages to extract data from various sources like DB2 Server, SQL Server database, Excel, CSV, and Flat files to the Data Warehouse.
• Applied various data transformations like Slowly Changing Dimensions, Conditional Split, Lookup, Fuzzy Lookup, Data Conversion, Derived Column, Sort, Merge, and Union All using SSIS/ETL.
• Secured and Configured ETL/SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
• Used C# Script to skip header in excel and loaded data into database using SSIS.
• Responsible for troubleshooting and problem solving during SSIS package development and deployment and also in scheduling jobs to call packages using SQL Server Agent.
• Involved in creating and maintaining data warehouse fact and dimension tables and views that provide sales data to SSAS Cube and finally to SSRS Reports.
• Generated report using different kinds of tools like Tableau, SSRS .
• Modified existing reports to accommodate changes in business needs using SSRS.
• Involved in testing SSRS reports for the sales amount values using Pivot table functionality in Excel by connecting it to SSAS cube.
• Designed Multidimensional Expressions (MDX) to create roles in SSAS database to limit the access of the SSRS report user to particular territory to which that user belongs.
• Created job schedules to run Full or Incremental load ETL jobs and to process SSAS database using SQL Server Agent.
• Created various work flow diagrams in MS Visio 2007 for IT Change Control meetings.
• Monitored SQL Server Agent Jobs created to load data into data warehouse and to process SSAS cube and was also responsible to troubleshoot for any error on job failure.

Project Environment: Windows Server 2008, DB2 Server, Microsoft SQL Server 2008, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), MS SQL Server Agent, iSeries Navigator, MS Excel 2007, MS SharePoint, MS Visio 2007.,C#

Confidential, Chicago, IL

SQL Server /BI (SSIS/SSRS) Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using ERwin Data Modeler.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the finance data from various source systems feeds usingSSIS.
• Worked Extensively with MS SQL Server Integration Services (SSIS)to import, export and transform the data between the linked servers.
• Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLE DB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports inSQL Server Reporting Services 2005.
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Worked with BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Detailed documentation on SharePoint of all the migrations, procedures and packages for future references.

Project Environment: Windows 2003 Server, MS SQL Server 2005, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL, MS Excel 2003, MS SharePoint and CA ERWIN DataModeler r7.2.

Confidential, Austin, TX

SQL Server/SSRS/SSAS Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• Upgraded SQL Server 2000 databases to 2005, using detach/attach, backup and recovery.
• Followed Microsoft recommendations, identified issues and analyzed SQL Server components from SQL Server 2000 using Upgrade Advisor Wizard.
• Created data models to be used by end-users so generated ad-hoc reports using SSRS.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• 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.
• Designed and implemented stored procedures and triggers for automating tasks.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Implemented SSAS cubes, facts and dimension tables to perform analysis.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Project Environment: MS SQL Server 2000/2005, T-SQL, MS Visual Studio 2005, SSIS 2005, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Windows XP, MS Office 2003, MS Access 2003 .

Confidential, CA

SQL Server/DTS/SSIS Programmer

Responsibilities:

• Interacted with business analysts to understand the business requirements
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Involved in creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Wrote complex T-SQL queries for data extraction.
• Migration of data from text files to SQL Server 2000 using BCP and DTS packages.
• Written DTS packages to move data between production, staging and QA environment.
• Created Backups for databases and automated the process.
• Performed T-SQL tuning using MS SQL Profiler and Index tuning wizard.

Project Environment: SQL Server 2000, Windows NT, Access 2000, MS SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS).