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/2008R2/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

PROFESSIONAL EXPERIENCE

Confidential

SQL Server BI Developer SSIS/SSRS

Description

• Confidential. is the largest provider of visual content in the world, controlling more than 60 million still images and more than 30,000 hours of footage. Getty Images is the leading provider of digital media worldwide, creating and distributing a range of assets from royalty-free stock photography and editorial images to footage, music and multimedia. The major role was that of migration of packages using SSIS and work on T-SQL, stored procedures to implement business logic.
• 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 with SSAS in creating cubes, 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 in MS Access and 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

SQL Server BI Developer SSIS/SSRS

• Responsibilities:
• Description:Confidential is the leading provider of incentive solutions to the health care industry. Incent One provides incentive programs that support wellness and preventive health plans for health care firms and employers ranging in size from small businesses to companies in the FORTUNE 1000.
• 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 of Agile, Waterfall and Scrum Methodologies ,Involved and participated in everyday testing Artifacts meeting, Process improvement, QC training meetings and Weekly status team meetings.
• Involved in Unit Testing, System testing and UAT Testing
• Designed SQL Database objects in .NET with SQL CLR programming. Created various Stored Procedures, Functions, Triggers, and User Define Data Types using C .
• Created SSIS packages to import data from MS Access, Excel to SQL 2008
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Developed Query for generating Gauge reports, drill down reports in SSRS and implemented report layouts
• 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

SQL Server BI Developer

Description:

• Confidential is a group of insurance and financial services companies in the United States. The company also has operations in Canada. The group's main business is State Farm Mutual Automobile Insurance Company, a
• mutual insurance firm that also owns the other State Farm Companies. The project involved migrating old legacy data to SQL Server 2008 using DTS, calculate different investment management business logics and generate reports for the Investors and managers.
• 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

Description:

• Responsibilities:
• Total self-reliance and ECIL was engaged in the Design, Development, Manufacture and Marketing of several products.
• Confidential was setup under the Department of Atomic Energy on 11th April, 1967 with a view to generate a strong indigenous capability in the field of professional grade electronics. The initial accent was on
• 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.