Professional Summary:

• Over 8 Years of extensive experience as SQL Server BI / Microsoft Business Intelligence applications developer specialized as an ETL Developer with expertise in SQL Server, Tableau, SQL Server Integration, Analysis and Reporting Services.
• High quality experience in ETL designing and development using Microsoft Business Intelligence and Tableau.
• Hands on experience on SSIS MS SQL Integration Services 2008 , SSRS MS SQL Reporting Services 2008
• Tableau Experience in Enterprise Environment, in Tableau 8.0 and 8.1 as a Developer and Analyst
• Tableau experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets , Groups, Parameters etc., in Tableau.
• Having basic working knowledge of SharePoint.
• Exceptional experience on .NET Asp.NET / VB.NET/ C .NET .
• Extensive experience in different types of Reports, Tabular Forms, Matrix cross Tab report form, conditional, List items, Charts and Sub reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in configuration of Report server and Scheduling in Report manager.
• Good knowledge of SSAS MS SQL Analytical Services2008 .
• Good Understanding in Data Warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP and Multi-dimensional Models for query and analysis.
• Proficient in using complex T-SQL/SQL Queries for Analysis.
• Experience in Package Configuration, Logging and Deployment on various Environments.
• Experience as offshore and onsite coordinator
• Experience in Client interaction, Requirements gathering, analysis, Effort Estimation. Code analysis, Design, Code change and testing for the requirements, resolving production issues
• Proficiency in .NET and SQL SERVER
• Good knowledge of software engineering concepts, techniques and development methodologies
• Good Analytical and problem solving skills

TECHNICAL SKILLS:

Professional Experience:

Confidential

BI Consultant

Confidential

• Project Description: CliMetrics Business software helps organizations create business value by measuring and optimizing energy consumption, water usage, waste management and emissions across mid-sized business and large enterprises. The solution empowers stakeholders by centralizing all greenhouse gas data including CO2, CH4, NO, and SH4 for Scope 1, 2 and 3 emissions.
• This information has to be transferred using SSIS from ORACLE source to SQL server Source, OLTP to DW and build the OLAP using SSAS, on the top of which we need to build SSRS reports. The initial source for already built DW was from ORACLE and we have to change the source to SQL Server including all the Data, Tables, Views, Stored Procedures and Triggers. We need to build Packages to do the ETL operation. This involves one time, daily, hourly scheduled packages. We need to build the reports for the data using SSRS. I have involved in building the SSIS packages and implementing some of the reports.

Responsibilities:

• Developed various SSIS Packages using Framework based on the requirements and functionality
• Developed various Packages with Exception Handling and explicit Transaction Mechanism.
• Configured variables and used the variables throughout SSIS project
• Developed reports based on the data migrated and according to the client requirement
• Extensively tested the packages and sql server queries based on the mismatch of existing production data and the data that is being pumped into DW from newly developed packages
• Has involved in writing the SQL server stored procedures, views, triggers and queries
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Embedded Tableau views in to SharePoint
• Has involved in testing of the SSAS cube after processing the cube from SSIS Packages
• Involved in Unit testing, Assembly testing and bug fixing in SSIS packages

Environment: SQL Server 2008 R2, SSIS, SSRS and Tableau

Confidential

MSBI Developer

Confidential

Project Description: Data Migration from Old System to New System based on the changed schema and functionality. Migration involved in 6 modules AX Customers, Finance and Feedback ,Card Master Cards, E-purse, Contracts and period passes ,OSR Operator Sales Report ,TUR Transaction Usage Report ,List and TRX Transaction .I have been involved in developing ETL functionality for Extracting the data from old system, applying transformations and load into the New System. Developed several SSIS packages based on the requirement.

Responsibilities:

• Developed various SSIS Packages using Framework based on the requirements and functionality.
• Developed Customer migration Packages which migrates all the customers data from old system to new system.
• Developed Card Order History migration Packages which migrates sales, cards, and purchase and vendor history from old system to new system.
• Developed various Packages with Exception Handling and explicit Transaction Mechanism.
• Configured variables and used the variables throughout SSIS project.
• Migration involved in three phases, Extract Data from old system applying transformations load into the staging and finally load into the new target system.
• Total 40 packages are developed along with a Grandmaster Package to integrate all modules. Number Sequences and Record IDs are generated on the fly in all Packages.
• Event handlers are developed to generate the stage, insert, update, error, ignore count of records in the report. Frame work will generate the migration staging report.
• Involved in Unit testing, Assembly testing and bug fixing in SSIS packages.

Environment: SSIS, SSRS, Crystal Reports

Confidential

Sr. Software Engineer MSBI

Project Description: Dixon is a retail business company of consumer electronic goods spread over United Kingdom U.K . The Data warehouse has many applications and it has a high volume of transactions and data. Data warehouse has many functional and technical groups and ETL is one among them performing the development activities for Data warehouse. Retail Business Process Management BPM project is to provide a single source of reporting for managing store/retail operations using data warehousing ETL SQL Server 2008 Integration Services. This will provide a mechanism to allow a uniform approach to manage all the retail operations. Users have flexibility to choose time periods and aggregation levels.

Responsibilities:

• Development of packages according to the ETL specifications for the staging area Warehouse data loading using SQL Server Integration Services.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Pivot, Union and Execute SQL Task to load data into Database.
• Implementing slowly changing dimensions to maintaining Historical data in required dimension table.
• Written the Stored Procedures and functions.
• Involved in the performance Tuning.
• Unit tested the packages.
• Creating Logging to manage the packages and Scheduling ETL packages from SQL server agent Jobs.

Environment: MSBI, SQL server2005/2008, SSIS

Confidential

Software Engineer, .NET

Project Description: The project is for St. Jude Children's Research hospital, Memphis, U.S.A. The project fulfills the requirement of automation of any Event happening in various departments of the hospital, launching complaints and investigation of the Event.

Responsibilities:

Deal with the client in gathering requirements. Handled the database designing. Has done coding in asp.net with vb.net as coding language using Ajax.

Environment: Asp. Net2005 SQL Server 2000

Confidential

Software Engineer, .NET

Confidential

Project Description: The project is for a company called Buckman private limited, U.S.A. The project is for Managing the entire database of the employees of the organization, which has branches across continents. The project covers handling the human resources and various Business Units of the organization.

Responsibilities:

Has worked on oracle 10g database concepts and handled the coding part using vb.net using Ajax toolkit.

Environment: Asp .Net2005, Oracle 10g