SUMMARY

• Over 7+ years of experience in IT industry with a strong background in Power BI, Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and maintenance of business applications.
• Involved in full life - cycle Data Warehouse activities, including defining project roles and responsibilities, detailing project plans, requirements gathering and specification, logical and physical database design in both relational and dimensional, reporting requirements specification, and implementation/ongoing support tasks.
• Having 4 years of extensiveTableauExperience in Enterprise Environment, inTableau8.0, 9.0, 9.2, 10.0 as aDeveloperand Analyst.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized usingTableau.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Designed and developed cross-tab, conditional, drill-down, summary, sub reports, Ad hoc reports, parameterized reports, Complex Reports using SSRS.
• Extensive experience in usingTableaufunctionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Expertise in Data Warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Experience in creating complex Packages, Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Joins, SQL.
• Experience in UI application development using HTML4.0/5, XHTML, CSS2/CSS3
• Experience on working with CSS Backgrounds, CSS Layouts, CSS Positioning, CSS Animations, CSS Text, CSS Borders, CSS Margin, CSS Padding, CSS Table, Pseudo Classes and Pseudo Elements.

TECHNICAL SKILLS

Visualization Tools: TableauDesktop 10.3,10.1,9.5., TableauServer,TableauPublic

Reporting Tools: SSRS, PowerBI, EXCEL, Crystal Reports.

Languages: Java, C, C++

Databases: MSSQL, PL/SQL, ORACLE, TOAD, TERADATA.

Web Technologies: HTML/HTML5, CSS/CSS3, JavaScript.

DE/Text editor: WebStorm, Sublime, Visual Studio, Notepad++.

Operating Systems: Windows 2014,2012R2,2008R2,8,10., Ubuntu.

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential, San Ramon CA

Responsibilities:

• CreatedTableauworksheet which involves Schema Import, Implementing the business logic by customization.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in bothtableauand excel.
• Worked on Motion chart, Bubble chart, Drill down analysis usingtableaudesktop.
• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploadedtableaudashboards on to server and provided production support fortableauusers.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to installTableaudesktop in silent mode and best practices forTableaureport development.
• Interacted with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.

Environment: Tableau10.1TableauServer, MS SQL server 2014, MS Access, MS Excel, Teradata, oracle databases.

Tableau Developer

Confidential, Santa Clara, CA.

Responsibilities:

• Developed interactiveTableauvisualizations after gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• StretchedTableaulimits to create unconventionalTableaucharts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
• Worked on Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Context filters, User filters, Table Calculations and Trend Lines also calculated measures.
• Involved in Data modeling, designing, and building relational databases.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Designed and developed several mappings to load data from Source systems to ODS and then to Data Mart.
• Wrote and executed various MySQL database queries using Python MySQL connector and MySQL DB package.
• Created and maintained several custom reports using Business Objects.
• Understood underlying Data and reworked Data Analysis with PowerBI.
• Generated Dashboards with Quick filter, Parameters and sets to handle views efficiently.
• Developed & Implemented Reports usingTableauServer.
• Responsible for Creating of Users, Groups and Projects onTableauServer.
• Created Customized and interactive dashboards (pulling data from multiple data sources).
• Used Java Script API to customize the views, selects, filters, date and time.
• Leveragedtableaubuilt in graphical capabilities to create bar charts, tree maps, area charts and created custom visualization like donut charts, trellis plots.

Environment: TableauDesktop 8, 9.1,TableauServer 8.0, 9.1, MS Office Suite, Power BI, Teradata, Oracle, SQL Server, Visual Studio 2010/2012, MS Excel.

ETL SSRS DEVELOPER

Confidential - Alpharetta, GA

Responsibilities:

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS..
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports usingSSRS.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: MS SQL Server 2012, SSIS,SSRS, SSAS, Oracle11g, Visual Studio 2013, Erwin 9.0, Windows NT 3.5 Server, Microsoft .NET framework 3.5, C#, ASP.NET, XML.

ETL SSRS Developer

Confidential

Responsibilities:

• Developed SQL queries to Insert, Update and Delete data in Database.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Develop and test ETL components using MSBI
• Developed, monitored and deployed SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Created reports based on database usage and perform capacity planning.
• Worked on Informatica Designer tools like Source Analyzer, Target Designer, TransformationDeveloper, Mapping Designer and Mapplet Designer.
• 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 2008.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Generated various SSRS Reports based on requirements

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Studio 2012, Windows XP, Crystal Reports.