SUMMARY

• Around 8 years of IT experience in Database designing /Database Administration and Development using MS SQL Server 7.0/2000/2005/2008/2012/2014 for both OLTP and OLAP Systems.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS in different fields.
• Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) for 2012, 2008 R2, 2005.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Strong working experience in SQL Server and T - SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data profiling and other database related activities.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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.
• Experienced in logical and physical data modeling, forward and Reverse engineering using Erwin, Normalization, de-normalization and building Referential Integrity Constraints.
• Involved in huge data migrations, transfers using Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experienced in Error handling of SSIS packages using transactions, check points (package restart ability features), break points and Error logging procedures.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Working experience in Relational Database Management systems (RDBMS), Star Schema, Snowflake schema in Multidimensional Data Modeling.
• Experience in SSRS reports - Report Services integration and deployment, Subscription.
• Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• A thorough professional with proactive attitude, out of the box thinking and generating new ideas.
• Expertise in creating and maintaining jobs in various job scheduling systems includes SQL Server Agent job, Maestro Scheduler and Tivoli Work Load Scheduler.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
• Ability to comprehend business concepts and translate them into technical requirements.
• Desires to show initiative in solving problems and can work both independently and in team environments.
• Has the ability to prioritize and adapt quickly to work load changes.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2008,2005,2000, 7.0, MS-Access, Oracle10.i/9.i/8.i

Database Technologies/Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, T-SQL, PL/SQL, DTS, SSIS, OLTP, ADO, SQL OLEDB, DBCC,, SSRS,SSAS, VERITAS Netback up 6.0, Light Speed, ERWIN 3.5/4.0,ER Studio 7.0, Visio 2002, Visual Source safe, TFS.

ETL & Reporting: SQL Server Integration Services (SSIS), SQL Server Reporting Services

Operating System: Windows 2008/2003/2000/ NT/Vista Datacenter and Advanced Server -32bit/64bit. Windows 2000/2003 Advanced Server, Windows Exchange Server 2003/2008,Windows NT 4.0/3.5, Windows9.x, Windows XP

Programming Languages: C/C++, HTML, JavaScript, C#, .NET, T-SQL, PL/SQL.

Others: MS Office 2000/2003/2007 , OutLook etc.

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior SQL BI Developer

Responsibilities:

• Involved in Database design, and create schemas, tables, views and indexes.
• Backend database development in MS SQL Server, writing complex ad-hoc queries, stored procedures, views, triggers, cursors, UDFs.
• Performed Database code Migration from SQL Server in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Experience in SQL joins, sub queries, tracing, and performance tuning.
• Extensive use of triggers to implement business logic and for auditing changes to critical tables in the database.
• Performed incremental data load packages in SSIS.
• Involved in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding data marts.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T-SQL and Visual Basic (VB) scripts.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experience in SSIS script task.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Played critical role in developing ETLs for loading dimension tables using Kimball methodology, creating SSRS reports, batch commands for scheduling.
• Provided back-end support for functional tuning and performance testing.
• Worked on data warehouse Analysis services and developed different reports for analysis.
• Involved in creating Tabular Cubes using SQL Analysis Services (SSAS).
• Used Tabular cubes since there are important calculations based on distinct count measures and complex calculations based on many-to-many relationships.
• Created cubes with full processing and partial processing capabilities.
• Created SSIS packages for custom processing of Partitions in SSAS cube.
• Created and maintained users, roles and groups and handled cube security efficiently.
• Trained End users to browse cube data using Microsoft Excel 2013/2010 and Power Pivot.

Environment: MS SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Data tools 2012, XML, MS Visual Source Safe and Windows Server 2003/2008/2012.

Confidential, Chicago, IL

Sr. SQL BI Developer

Responsibilities:

• Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel
• Spread sheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts and used C# and VB.Net scripts in process of designing the SSIS packages.
• Involved in complete Software Development Lifecycle (SDLC).
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.
• Hands on experience with tools like SQL*Plus, Export and Import Utilities along with PL/SQL, Oracle Enterprise Manager (OEM), and TOAD.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages and SQL Server Agent jobs.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
• Created Cross-Tabs, Drill-down and Sub-Reports in SSRS using different types of properties like Chart controls, filters, Interactive Sorting, SQL parameters etc. deployed RDLs to Report Server.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Involve in Unit testing, Integration testing and System testing.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production.

Environment: Microsoft SQL Server-2008/2012, Visual Studio-2008/2010, T-SQL, Team Foundation Server, SQL Server Analysis/Integration and Reporting Services, SharePoint 2010/2013.

Confidential, Montvale, NJ

SQL Server BI Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into database and Billing Systems.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Worked on Incidents in solving the issues arising in the PL/SQL Code, Reports and Forms 11g as support team.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in Unit testing of the Reports, Forms and PL/SQL Stored procedures.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Provided EDI expertise to the Limited Brands during a during a system wide upgrade
• Extensively usedTera DataSQLAssistant to extract data from Data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Designed Dimensional modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Made modifications and added new MDX queries to the cube
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.
• Worked with Business Analysts and Users to understand the requirement.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports and SSIS packages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2005, Windows 2000/2003,MDX,T-SQL, SSIS, SSRS, Tera Data, SQL Server Analysis Services, PL/SQL, EDI, SQL Profiler, MS Excel 2003.

Confidential, GA

Sr. SQL Developer (SSIS/SSRS)

Responsibilities:

• Involved in User Requirement Gathering and Technical Specification Documentation.
• Involved in Designing of the logical and physical database
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Creating transactional and merge replication on different servers.
• Performance tuning at Database level, T-SQL level and operating system level.
• Trouble shooting Problems by using SQL server profiler.
• Creating DTS packages to maintain central repository by extensively using different SQL2000 DTS tasks.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, and flat file, XML in order to create and maintain a centralized data warehouse.
• Plan and implement data roll-up from live site to data warehouse.
• Resolving the bugs in the database.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005 Enterprise Edition, SSIS, SSRS, T-SQL, Access 2000 & Windows 2K platform, MS Project.