PROFESSIONAL SUMMARY

• 8+ years of experience in design, development, implementation, and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse.
• Extensive experience using Tableau Server, Tableau Desktop and Tableau Public.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Involved in publishing of various kinds of interactive data visualizations, dashboards and work books from Tableau Desktop to Tableau Servers.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Experience in creating, filters, quick filters, data source filters, global filters, context filters and user filters.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
• Experience in writing and debugging Stored Procedures, Views and triggers using T-SQL Script.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in Extracting, Transforming and Loading (ETL) data from various sources (Excel, Flat file, DBs) to MS SQL server by using DTS and SQL Server Integration Services (SSIS).
• Experience in enhancing and deploying SSIS packages from development server to production server.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Good Experience in managing various SSIS Package Configurations in the form of XML Files, SQL server, Environment variables
• Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources
• Proficient in designing techniques like Snowflake and Star schema, fact and dimension tables, logical and physical modeling.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Proven abilities in creating complex reports by linking data from multiple data sources, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.
• Provided 24x7 supports for production servers.

TECHNICAL SKILLS

BI Reporting Tools: Tableau Desktop/Server 7.x/8.x/9.x, Cognos, SSIS/SSRS, Informatica, Erwin

Databases: Oracle 9i/10g/11g/12c, MySQL, MS Access SQL Server

Application Servers: Web logic, Web Sphere, Tomcat

Operating Systems: Unix, Linux, HP-UX, AIX, Solaris

Office tools: Windows XP/2000/2003/NT 4.0/Vista and MS-Dos.

Programing Language: C#,HTML,SQL,PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer & Administrator

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 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 customize Tableau Server 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.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and data security checks.
• Used User row level security for data in the Dashboard.
• 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 with ETL 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/8, Tableau Server 9/8, Tabcmd, MS SQL Server 2014, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Erwin r8, C#.

Confidential, Houston, TX

Tableau Developer &Administrator

Responsibilities:

• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Held responsibility for integration points and the order in which these must be executed.
• Involved in integration of Tableau JavaScript API Filters in web application
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Mentored less experienced Tableau reporting specialists.
• Performed administrative and support activities across a multi environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
• Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
• Reviewed, assessed and promoted adoption and standardization of Tableau support solutions.
• Generated insights out of voluminous and complex datasets and built story lines.
• Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from MS SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Install and maintain Stratus FT series fault Tolerant systems running Windows Server 2003 2008 and 2012 Operating Systems.
• Migration from Exchange Server 5.5 to Exchange Server 2003.
• Installation and Configuration of Exchange Front-end Backend architecture.
• Schedule the Overnight task through Power shell Scripting.
• Active Directory users, groups, and computers including delegate authority and applying permissions to various member servers' nomenclature.
• Provided 1st and 2nd level 24x7 after-hours supports to application and infrastructure teams via hot pager assignment every five weeks.

Environment: Tableau Desktop 8, Tableau Server 8, Tabcmd, MS SQL Server 2012, MS SQL Server Integration Services, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, SharePoint, C#.

Confidential, Detroit, MI

Tableau Developer & Administrator

Responsibilities:

• Worked closely with the Client at Client’s place and with almost closer deadlines to meet, came up with dashboard that got great recognition as it surpassed Client’s expectation which has been possible only through a great rapport that we build up during the interactions. Responding appropriately to the Clients queries and issues raised by them.
• Created new Schedule's and checking the task's daily on the server.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• 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.
• Defined best practices for Tableau report development and effectively used data blending feature intableau.
• Created users, groups, projects, Data connections, and settings as a tableau administrator.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
• Published Workbooks and Dashboards to the Tableau server.
• Migrated Workbooks and Dashboards from Tableau 6 to Tableau 7.
• Created extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved from requirements gathering till the Delivery.
• Attend stand up of 15 min on every day send a proxy to the other
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated the Tableau reports to other portals.
• Provided reporting solutions for OLTP and OLAP systems.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 7.0/6.0, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/XP, UNIX.

Confidential, Richmond, VA

Tableau Admin and Developer

Responsibilities:

• Developed Tableau dashboards according to user specifications.
• Extensively used Data Blending techniques in dashboard development.
• Supported different user groups and business domains.
• Good knowledge of tableau server, administrative functions, installation, configuration, back up of servers and load balancing techniques.
• Defined architecture for Tableau - establish Dev/QA/Prod environments
• Responsible for security configuration including user/ group setup, permissions, security roles, configuration of trusted ticket authentication
• Setup new projects, security groups, roles and administer users for all supported platforms
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitoring of Tableau Servers for its high availability to users.
• Worked on Tableau Server upgrades for new versions.
• Providing Tableau Demo’s to new on boarding users.
• Developed worksheets and data visualization dashboards with graphs and filters.
• Created report schedules on Tableau server.
• Develop monthly reports and dashboards.
• Created calculated fields as per business requirement.
• Defined best practices for Tableau report development.
• Used Tab-admin and Tab-cmd commands in creating and restoring backups of Tableau repository.
• Involved in Production support for Tableau.

Environment: Tableau Server V 7.0/8.0/8.1/8.2 , Tableau Desktop, Oracle, Netezza, Teradata, Excel, Windows 2008 R2.

Confidential, Boston, MA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel.

Confidential, West Des Moines, IA

BI Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Generated reports using Cross-Tab, Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Tested the reports and fixed bugs in the stored procedures.
• Established backup and recovery of MS SQL server by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Created/ Maintained clustered/ non-clustered Indexes for fast and efficient reporting process.

Environment: MS SQL Server 2005, SQL Server Reporting Services, T-SQL, Visual Studio 2005, MS Office 2003/2007, SQL Profiler, Windows server 2003.