SUMMARY

• Over 11 years of experience in Business Intelligence & Analytics and application development projects across various technologies specifically on Tableau, SSIS, SSRS, SSAS, SQL Server 2012/2008 R2, .net, Tibco Spotfire.
• Experience includes Development, Implementation and Production SQL DBA activities for various domains such as Tax, Capital Market, Health care’s, Education and e - commerce projects.
• Expertise on BI Architect (SSIS, SSRS, SSAS and Tableau) and Data Modeling and worked on multiple end to end DWH Projects.
• Expert in Data visualization using Tableau tool for Dashboards and Ad-hoc reports.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Expert in complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expert in Business Intelligence and Analytics using ETL/Reporting/Analytics tools to provide Business Intelligence solutions.
• Strong experience on design and providing solutions on ETL, Reporting, Analytics and Data Visualization.
• Responsible for defining the complete data warehouse architecture (ETL Design, Reports Design, Performance Management, Data Quality and Data Marts).
• Extensive experience in customer interaction, Architecting and High-Low level design.
• Expert in ETL design, Cube development, implementation and Standard, Summary, Ad-hoc reports.
• Performed Query optimization & Performance Tuning in complex SQL Queries, Stored Procedures.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Expert in creating Indexes, Views, complex Stored Procedure, Triggers, effective Functions, Cursors and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
• Performance Tuning: Hands-on experience on T-SQL script reviews, analyzing Query plans for stored procedure optimizations.
• Expert in automation scripts for DB maintenance and SSIS package using a scripting language such as Powershell, VBScript.
• Strong Understanding of the Hadoop and its Eco-system /Architecture and associated sub-projects sitting on top of Hadoop like Hive/ Pig /H-Base /Sqoop etc.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Participated in Daily scrum meetings, sprint planning, sprint review, and sprint retrospective.
• Flexible enough to adapt new environments and Sound knowledge in analysis of functional issues.

TECHNICAL SKILLS

Relational Databases: SQL Server 2005/2008/R2/2012/2014, PDW and Big Data - Hadoop Ecosystem

ETL Tools: SQL Server Integration Service 2005/2008/R2/2012/2014, Informatica 8.6

Reporting Tools: SQL Reporting services 2005/2008/R2/2012/2014, Tibco Spotfire 6.0

Analytic Tool: Tableau 8.0/8.5/9.0, SSAS 2008R2/2012/2014, and Tibco Spotfire 6.0

Schedulers: Control-M, SQL Server Agent

Version Control Tools: TFS, Visual Source Safe 2005

Languages: Dot net (C#.net and VB.net), Java, C, C++ and T-SQL

Web Languages: XML,HTML

Web / Application Server: IIS 6.0/7.0

GUI Tools / IDE: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, MS SQL Enterprise Manager, SQL Query Analyzer, SQL Server Profiler, Database Engine Tuning Advisor, MS Visual Studio 2008/2012

Project Mgt. Tools: SharePoint 2010/2013, Microsoft Project

Performance Monitoring Tools: SCOM 2007 & 2012

Software/Utilities: ODBC, FTP, SFTP, MS Office 07/10/13

Operating Systems: Windows 2010/2008/2007 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

BI Architect(ETL/Tableau)

Responsibilities:

• Played a role of BI architect - ETL Design, Cube design, Reports design and Dashboard design.
• Created Dashboards and Ad Hoc reports to Business users, Architect and Operational team.
• Generated Dashboards with Quick filters, calculated fields, Parameters and sets to handle views more efficiently.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data in Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic in Operational module and application usage module.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Involved in standard reports and dashboard integration with SharePoint.
• Developed common framework in SSIS package to bring the data from PDW servers to EDW Metadata Reports database.
• Created complex Stored Procedures in comparison and data profiling module.
• Prepared Solution Design and Solution Architecture documents
• Involved in troubleshooting and resolving database integrity issues, Performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
• Created Comparison, Impact analysis and data profiling reports.
• Involved in MDX Cube and Tabular model development for Structured Metadata and data profile module.
• Involved in stored procedures and ETL performance tuning.
• Participated in Daily scrum meetings, sprint planning, sprint review, and sprint retrospective.

Environment: Parallel Data Warehouse (PDW), SQL Server 2012, SSIS, SSRS and Tableau 9.0

Confidential, Alpharetta, GA

BI Architect (ETL/Tableau)

Responsibilities:

• Involved in Dashboards and ad hoc reports in Calculation module for Product owner.
• Played a role of ETL Design- Designed and developed SSIS package for Partnership Form data from excel to EYPTS database.
• Created complex Stored Procedures in Calculation module.
• Involved in Data Analyzing and created Source to Target mapping for Partnership module.
• Enhanced Entity and Partner module reports such as Balance sheet, Financial Amounts by Attribute, Partner Allocation by Attribute and Partner Allocation Report.
• Involved in stored procedure performance tuning for Calculation module.

Environment: SQL Server 2012, SSIS, SSRS, Tableau 8.2, Visual studio 2012

Confidential, Alpharetta, GA

ETL Architect

Responsibilities:

• Study of the existing CRM System and Design functionality.
• Created Dashboard for EDW Job status to Business users and production support team.
• Prepared Solution Design documents
• ETL Design and developed SSIS package to export data as flat files from GFIS and IS system to feed the EDW system.
• Created Data mapping documents and operational manual for EDW feeds.
• SFTP setup created for files transfer from CRM server to EDW server.

Environment: SQL Server 2012, SSIS, Tableau 8.2, Visual studio 2012

Confidential, Seattle, WA

Data Architect

Responsibilities:

• Study of the existing System and Design functionality.
• Understanding the existing Business and Index structure.
• Played a role of ETL Architect and Dashboard Report design.
• Designed and developed master package for Data migration from Global and US index to IPC system.
• Involved Data Analyzing and create Source to Target mapping for all process.
• Involved in the implementation of the mappings in various layers (stages).
• Involved in managing security level through logins, users, permissions, certificates, credentials, encryption schemes per organization's security policies.
• Involved in troubleshooting and resolving database integrity issues, Performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Attended Stand-up and weekly status meetings with client and provided detailed status report to the client.

Environment: SQL Server2008 R2, SSIS, SSRS, Visual studio 2010 and Tibco Spotfire

Confidential, Schaumburg, IL

Data Architect

Responsibilities:

• Gathering requirements as part of new reports addition to the existing Business Warehouse reporting scheduler.
• Played a role of ETL Architect and DBA.
• Involved in new Cube creation and modify existing cube.
• Involved new finance report creation in SSRS and Crystal report for all module.
• Created complex Stored Procedures, triggers, cursors, and views and other SQL joins and statements for applications.
• Involved in Data Extraction, Transformation and Loading (ETL Process) from Source to target systems using SSIS.
• Involved in creating SSIS packages for weekly and monthly loads.
• Analyzing or identifying Data Issues If any be it related to SSIS and fix the same.
• Involved in managing security level through logins, users, permissions, certificates, credentials, encryption schemes per organization's security policies.
• Attended weekly status meetings and provide detailed status report to the client.

Environment: SQL2008 R2, SSIS, SSRS, SSAS and Tibco Spotfire.

Confidential

BI developer

Responsibilities:

• Understanding the client requirements by studying functional document.
• Played a role of ETL Architect and Developer.
• Played a role of Report developer
• Involved Database design and created stored procedures.
• Providing support and enhancements for ETL data load.
• Implementation and maintaining the application with Enhancements.
• Interacting with the onsite people and resolving the offshore issues.
• Attended weekly status meetings and provide detailed status report to the client.

Environment: Visual Studio 2005(ASP.net with C#.net), SSIS, SSRS, SQL Server 2005

Confidential

ETL developer

Responsibilities:

• Understanding the client requirements by studying functional document.
• Designed Database and created complex stored procedure and views.
• Frame work design for front end.
• Involved in the implementation of the mappings in various layers (stages).
• Interacting with the onsite people and resolving the offshore issues.
• Attended weekly status meetings and provide detailed status report to the client.

Environment: Visual Studio2005 (ASP.net with C#), SQL Server2005 and Informatica 8.6

Confidential

.Net developer

Responsibilities:

• Understanding the client requirements by studying functional document.
• Involved Tables design and created stored procedures and Views.
• Frame work design and client side code.
• Implementation and maintaining the application with Enhancements.
• Interacting with the onsite people and resolving the offshore issues.
• Attended weekly status meetings and provide detailed status report to the client.

Environment: Visual Studio 2005(ASP.net with C#.net), SQL Server2005

Confidential

.Net developer

Responsibilities:

• Understanding the client requirements by studying functional document.
• Involved Tables design and created stored procedures and Views.
• Involved Client side code and validations.
• Interacting with the onsite people and resolving the offshore issues.
• Attended weekly status meetings and provide detailed status report to the client.

Environment: Visual Studio 2005(ASP.net with C#.net), SQL Server2005, Java Script and HTML

Confidential

.Net developer

Responsibilities:

• Involved in front end design and coding.
• Client side code and validation.
• Implementation and Enhancements.

Environment: Visual Studio 2005(ASP.net with C#.net), SQL Server2005 and Java Script.