PROFESSIONAL SUMMARY:

• Over 6.5 years of extensive IT professional experience with expertise in Business intelligence, TSQL, Database Development and Technical Management.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Excellent 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.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Highly skilled in creating dynamic and customized DTS packages and expert in designing, scheduling complex SSIS Packages, Jobs for MS SQL Server.
• Expert in creating various type of reports such as Gauge Reports, Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad - hoc reports using SSRS.
• Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

SQL Server Tools: SSMS,BIDS, MS Access, Enterprise Manager, DTS, Profiler

ETL & Reporting Tools: SSIS, SSRS, Crystal Reports, Business Objects

Databases: MS-SQL Server 2012/2008R 2/2008/2005/2000 , Oracle

Programming Languages: SQL,T-SQL,PL/SQL,C,C++,JAVA,VB script

Operating System: Windows 95/98,NT,Windows XP/2003/2000,Unix

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
• Experience in working withSSASin creatingcubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Prepare detailed statistical reports inMS Accessand MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split and Derived column.
• Responsible for implementation of creating complex SSIS packages using proper control and data flow elements with error handling.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).

Environment: SQL Server 2012/2008,XP, T-SQL,SSAS, SQL Profiler, Microsoft Dynamics, Agile, Report Builder, SSRS, SSIS, Visual Studio 2005/2008,VB script XML, Crystal Reports, Excel.

Confidential, New Jersey

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked with fuzzy grouping and Slowly Changing Dimension transformations to clean, insert and update the Dimension Tables of a data warehouse
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column and data conversions.
• Implemented the error threshold using precedence constraints and variables in SSIS packages
• Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS which involves nightly maintenance.
• Professional expertise in Implementation ofAgile, Waterfall and Scrum Methodologies, Involved and participated in everyday testing Artifacts meeting, Process improvement, QC training meetings and Weekly status team meetings.
• Involved inUnit Testing, System testing and UAT Testing
• Designed SQL Database objects in.NETwithSQL CLRprogramming. Created various Stored Procedures, Functions, Triggers, andUser Define Data TypesusingC#.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008
• Developed Query for generating Gauge reports, drill down reports in SSRS and implemented report layouts
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Deployed the created reports directly on the client’s reports into SharePoint and Report Manager, created data driven subscriptions for different users in desired format.
• Stored Procedures, User Defined Functions, Views, TSQL scripting for complex business logic. Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code

Environment: SQL Server 2005/2008,XP, T-SQL,SSAS, PL/SQL, SQL Profiler, Report Builder, VB script, SSIS, SSRS, 2005/2008, XML, Crystal Reports

Confidential, IL

SQL Server BI Developer

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2005/2008.
• Job operated within a very agile environment, with daily scrum meetings; stand up meetings, burn-down charts, presentations and review
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Involved in back-end testing and worked with data quality issues.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.

Environment: - MS SQL Server 2005,XP, Windows Server 2008, DTS, SSIS, SSRS, SharePoint, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008.

Confidential

SQL Developer

Responsibilities:

• Actively involved in Normalization & De-normalization of database.
• Created tables, Check constraints, Indexes, and Views
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Developed complex stored procedures to create various reports.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and involved in performance tuning of T SQL queries and stored Procedures.
• Create joins and sub-queries for complex queries involving multiple tables.

Environment: SQL server 2000 and 2005, T-SQL, PL/SQL.