SUMMARY

• 6+ years of extensive IT experience as a Data Analyst, Business systems analyst in Data Warehousing and Business Intelligence.
• 4+ years of experience in Tableau Desktop, Tableau Reader and Tableau Server in various versions like tableau(10.1,9.x,8.x,) and development of Tableau visualization solutions.
• Certified in Tableau desktop 9.0.
• Involved in Tableau server architecture for designing and maintained.
• Extensive experience on building dashboards in Tableau 10.1, and 9.3 andnecessitate in performancetuning of reports and resolving issues within tableau server and reports.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple data sources.
• Ability to connect to different data sources from Tableau, presenting Visualization ondata, utilizing filters, actions and parameters.
• Worked on Data Warehousing concepts not limited to dimensional modelling and reporting tools.
• Extensive knowledge in different reporting objects like Dimensions, Facts, Attributes, Hierarchies, Calculated fields, Transformations, filters, Sets, Groups, prompts, Parameters etc.in Tableau.
• Experience in Developing Performance Dashboards, Score cards, Metrics, what if analysis, Prompts, Drills, Reports/Dashboards for listed functional areasin Change Management, Order Management, Sales, Pricing, Purchasing.
• Installation, Configuration and administration of Tableau Server in multi - server and multi-tier environment.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights including slicing and dicing into the available data.
• Proficient in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Worked with Oracle, Microsoft SQL Server, Microsoft Access databases, and Excel Spreadsheet.
• Experienced in well designing staging tables at the data base level and performed data loads using ETL tools.
• Extensive experience indealing with Relational Database Management Systems, including Normalization, Constraints, Queries, Keys, Indexes, Data import/export, Joins, triggers, Stored Procedures, and Cursors.
• Experienced in managing schedules and scheduling workbooks and activities on Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

TECHNICAL SKILLS

Reporting Tools: Tableau, SQL Server Reporting Services, MS Excel, Power BI

BI Tools: Data Warehousing/BI Tools SQL Server Business Intelligence Development-SSIS, SSAS, SSRS, DTS, Power BI

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, Oracle PL/SQL, Cubes

Others: JIRA, SharePoint, GIT, Tortoise SVN, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

Data Analyst

Responsibilities:

• Designed Proof of Concept (POC) presentations and Adjusted views based on feedback. with the project lead, along with developing new Tableau Interactive Dashboards & Stories.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Analyzed extracts using MS Excel before using it in Tableau to build Reports, interactive Dashboards and Stories with insightful visualizations.
• Used Data Blending, created Calculated Fields, applied various conditions, quick /context/Global filters and parameters and multiple Filters at reports and dashboards level
• Expertise in creating various types of reports such as complex drill down reports, drill through reports, parameterized reports, matrix reports, sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases.
• Worked in different views: Dual Axis, Bar Graphs, Scatter Plots, Pie/Bubble/Funnel Charts, Heat Maps, Tree Maps, Box Plots, Waterfall, histograms, pie charts, box plots, scatter plots for inventory management, background maps and Geographic Visualizations per requirements.
• Worked with multiple data sources, using Data Blending, and Cross Database Joins in Tableau and Linked Servers in SQL.
• Gave KT in supporting stakeholders & Users to understand, use reports and dashboards to make their own analysis off the data.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Executed and tested required queries and reports before publishing dashboards.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created reports and dashboards with Power BI and delivered to the customers.
• Involved in Objects creation such as Table, Indexes, Stored Procedures and other SQL joins and query writing.
• Good experience with query tuning and optimization of complex SQL queries.
• Worked on Data from Reports generated by various vendors from various Databases, CSV and flat files.
• Developed and tested business and IT process automation jobs, agents and processes.
• Defined the report layout and identified datasets in all reports for the report generation.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Worked with QA team to execute the test plans and test scenarios to validate systems design and business requirements.
• Troubleshooting the issues in the reports as well as in T-SQL queries in the production server.
• Used BI tools like SSRS, Power BI to create reports in pivot tables and metrics related to critical information, i.e. performance, variance, and analyses used for making intelligent business decisions
• Worked on Production Support 24x7 coverage plan successfully.

Environment: Tableau10.1/9.3, SQL server 2012/2008R2/2008, Reporting services, Power BI, Windows 000 / XP, Windows 7, MySQL, DB2, Crystal reports, MS-Excel, PostgreSQL, Teradata, OraclePL/SQL, Macros

Confidential, Richmond, Virginia

Tableau/BI Developer

Responsibilities:

• Created Tableau workbooks usingactions, multiple types of filters including context filters, global filters, quick filters, parameters and calculated sets.
• Blended data from multiple databases into one report by using primary keys from each database through data blending and cross database joins for generation of reports.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau.
• Worked with the applicationdevelopersand provide necessary SQL Scripts using T-SQL.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Designed and developed the most suitable User Interfacesuch as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by using primary keys from each database through data blending and cross database joins for generation of reports.
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment in the developed dashboards.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server.

Environment: Tableau Desktop 9.1 / 8.2, Tableau server, Oracle SQL developer, SQLServer 2012, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007

Confidential, Hartford CT

MSBI/Tableau developer

Responsibilities:

• Involved in gathering business requirements, interacting with the client and preparing detailed design document.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Filtered bad data from legacy system using T-SQL and implemented constraints and triggers into new system for data consistency.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Effectively used data blending feature in tableau
• Executed and tested required queries and reports before publishing.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the SSIS packages. Identify and document the source to target packages.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Design and document the error-handling strategy in the ETL load process using Event handlers.
• Created OLAP cubes using SSAS and created reports from them.
• Created test data and unit test cases to ensure successful data loading process.
• Used Notification services to generate error messages and send them to the user through e-mails. Created report snapshots to improve performance of SSRS.
• Gathered data from multiple data bases across the organization and produced reports for different departments.
• Converted existing Excel based reports and crystal reports to SSRS reports.
• Created dashboards for Sales, Inventory, Performance and finance.
• Deployed and uploaded the SSRS reports to Report Manager &SharePoint Server for the end users and involved in enhancements and modifications.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.

Environment: MS SQL Server 2008R2, Tableau 8.2/8.3, T- SQL, Microsoft SQL Server Integration Services (SSIS) 2008R2, Microsoft SQL Server Reporting Services (SSRS) 2008R2, Microsoft SQL Server Analysis Services (SSAS) 2008R2, SQL Server Business Intelligence Development Studio, Star Team Version Control tool), Erwin 8.0/MS Visio 2010.

Confidential

SQL DEVELOPER

Responsibilities:

• Requirement gathering, creation of requirement specification documents for new reports.
• Involved in devolving documentation to reflect current design ETL processes. Worked closely with Business Users in identifying the gaps between existing code and the business requirements in the ETL projects.
• Developed various T-SQL scripts for transaction processing of Sales, Credit and Rebates.
• Interact with business users to refine the requirement and explain end to end change.
• Write T-SQL for PIVOT/UPIVOT, CTE.
• Created Linked Servers and send data across multiple Servers.
• ExecutedSQLcommands, wrote SQL commands, Stored procedures for existing intranet applications.
• Conducted database management, performance measurement and performance tuning for new and existing databases by using SQL Profiler, Database engine Tuning Advisor and execution plan.
• Writing client side programming usingHTML,JavaScript.
• Involved in testing of the system.
• Involved in building cubes from scratch using Microsoft SQL Server Analysis Services (SSAS) 2008R 2/2008/2012.
• Reviewing the code and performing quality check.
• Created stored procedures for module integrity and application.
• Managed ongoing activities like importing and exporting, backup and recovery.
• DevelopedSQL Queriesto check Data Quality.
• Design and develop new modules.
• Involved in System Integration testing andUnit testing.Developing the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Deploying scheduling and MonitoringSSIS packages.
• Daily, Weekly and Monthly production data processing, monitoring and trouble-shooting in an environment of mission critical operational systems.
• Writing complicated T-SQL queries and performing performance tuning checks on the existing ones.

Environment: MS SQL Server 2005, T-SQL, MS Excel, Visual Studio, ASP.net, SQL Server Reporting Services(SSRS),SQL Server Analysis Services(SSAS),SQL Server Integration Services(SSIS),Business Intelligence Development Studio(BIDS), T-SQL,MS Excel, and Visual Source Safe.