SUMMARY

• 5+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 4+ years of extensive experience working with Business Intelligence data visualization tools with specialization on Tableau and 2+ years of ETL experience using SSIS and DB experience on SQL Server, Oracle, MySQL.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6,7 and Tableau 8, 9.0.
• Strong knowledge in various reporting objects like Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups, Parameters etc.
• Experience in migrating all the reports, dashboards from Tableau 8.0 to Tableau 9.0.
• Experience in working with different enterprise data sources like Teradata, SQL, and Oracle.
• Expertise on tools likeToad, Autosys, and SQL Server Management Studio and involved in Unit testing, Functional testing and User Acceptance testing on UNIXandWindowsEnvironment.
• Experience inPerformance TuningofTargets, Sources, Sessions, Mappings and Transformations.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Effective Ability to create CustomTableaureports using SQL and advancedTableaumapping.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Expertise inDataAnalysis,DataExtraction,DataMart. Experience intabcmd&tabadmin, Email alerts, scheduling, data backup, SAML and drivers setup activities.
• Highly skilled inTableauDesktop for data visualization, using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Heat Map and Density Chart.
• Expertise in dealing with Relational Database Management Systems Including normalization, stored procedures, constraints, querying, joins, keys, indexes,dataimport/export, triggers and cursors.
• Worked extensively on multiple data connections using blending, worked on Data Extracts and managing queries.
• Provided Production support toTableauusers and Wrote Custom SQL to support business requirements.
• Experienced in handling on - going support & enhancements to reports and dashboards.
• Quick learner and good performer both in team and independent job environments.
• Strong interpersonal, Analytical and Problem Solving skills, Multi-Tasking abilities, demonstrable

TECHNICAL SKILLS

Business Intelligence: Tableau 9.x/8.x/7.x, SSRS, SSAS

ETL Tools: SSIS

Data Modelling tools: Star Schema Modeling, Snow Flake Modeling

RDBMS: Oracle 11g/10g/9i, SQL Server 2005/2008, DB2, Access, Excel, CSV, MySQL

Database Tools: SQL Server Management Studio, Toad

Languages: SQL, PL/SQL

Other tools: MS Office, MS Visio, MS Project, Publisher; Adobe Acrobat, Sub Version

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Senior Tableau Developer/Admin

Responsibilities:

• Gathered end user requirements from business and Finance to develop Executive dashboards constituting of Financial Forecast, Pre sales, Risk and underwriting Business.
• Developed corporate financial dashboards using the enterprise business intelligence for evaluating the Growth, distribution and Profitability for the executives.
• Developed Information Technology Metrics dashboards to evaluate the efficiency of the Technology partners for the segment leads and improve productivity and delivery schedules.
• Created Dashboard mockups or Proto Types for Business partners so as to give them a beforehand experience of how final product would look like.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provide Business Intelligence support using Tableau for implementing effective Business dashboards & visualizations of data.
• Develop manage and maintain data dictionary or metadata.
• Design Metadata Layer for Tableau reports and Tableau metadata management with maintaining consistency in server data source.
• Helped customizeTableauServer with Company Logo and Company Pop-Ups.
• 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.
• Generate KPI for customer satisfaction survey results and disease management.
• Created Data Connections, published on Tableau Server for usage with operational/Monitoring Dashboards.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, and User Defined Functions to implement the business logic.
• Took regular back-ups of the Production Metadata in SQL Server Database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.
• Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance.
• Created extensive custom joins for blending data from several different data sources.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse withETL Development team.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Upgraded Workbooks and Dashboards from Tableau 8 to Tableau 9.

Environment: Tableau Desktop 9.0/8.1, Tableau Server 7.0/8.0/9.0, MYSQL, Oracle 10g, Excel, TSQL, Windows 7, SQL Server 2008, SQL BI Suite (SSIS, SSRS) /DBA, Toad, MS Office.

Confidential

Tableau Analyst / Admin

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created Tableau extract files for improving the performance.
• Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for CHOP Enterprise wide Tableau application consisting of multiple key functional business domains.
• Participated in building and visualizing dashboards using Tableau Desktop.
• Used Tableau visualization software to generate Tableau combination dashboards.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

Environment: TableauDesktop 7.0/8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel, Oracle11g, PL/SQL, TOAD, Windows XP and windows 7

Confidential

Business Intelligence Developer

Responsibilities:

• Served as technical member for Reporting services in Business Intelligence Team.
• Work extensively on SSRS reporting and SSIS 2008.
• Acquire requirements for reports and develop or convert the reports in SSRS 2008.
• Validation of data for the reports and debug any errors.
• Performance tuning of the stored procedures and functions.
• Taking back up of existing databases during data conversion and implementation of new reports
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Preparing Dashboards using calculations, parameters in Tableau.
• Creating calculated fields, groups, sets and hierarchies etc.
• Creating data blending in case of merging two different datasets.
• Understanding of relational database structures, theories, principles, and practices.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on drill through reports by creating HTML references.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.

Environment: Tableau Desktop 6.02,7.0, ETL, M S Excel, MS Visio, Microsoft Office Suite.

Confidential

Data ware house Intern

RESPONSIBILITIES:

• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Extensively worked on stored procedures, triggers, cursors, functions, views, indexes, synonyms.
• Technical documentation of the Data warehouse architecture of the BI project which can be can be understood and/or used by members of the development team.
• Define Meta data standards for the data warehouse.
• Design SSIS packages to load data from Fox pro to SQL2008/2005 databases.
• Collect requirements from user regarding the measures necessary for the cube in Analysis services.
• Analyze client needs; develop SSRS reports in SQL2008 tailored to specific departments in the organization.
• De-bug issues in already existing reports.
• Lead offshore SSRS team for report requirements.
• Developed mappings with Transformations and Mapplets confirming to the business rules.
• Worked on Stored Procedures, Functions and Database Constraints.

Environment: T-SQL, MS SQL Server 2008/2005, SSAS, SSRS, SSIS, XML, Windows2000/2003/NT/XP, Microsoft .NET framework 3.5, MS-Excel.