SUMMARY

• 7 years of experience in design, development, implementation, and administration of Business intelligencevarious 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 2017, 2016,2012, 2008, 2005 and 2000.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• Strong understanding of project life cycle and SDLC methodologies including RAD, Waterfall and Agile.
• 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.
• Created Tableau Dashboards to replicate existing broken reports and migrated reports from other reporting tools to Tableau and created models, reports in Excel using Pivot Tables.
• Expertise in optimizing the existingDashboards with a focus on usability, performance, flexibility, testability, and standardization.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T SQL.
• Experience in writing complex SQL queries to perform End-to-End Data validations and support Ad-hoc business requests.
• Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.
• Strong Analytical and Problem-Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.
• 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 generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Strong hands on expertise writing complex & robust SQL queries & working with large volumes of data sets.
• 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).
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.
• 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.
• Designing and executing strategies to satisfy data needs by implementing frameworks and governanceroadmaps to ensure data quality, flexibility, availability, integrity, stewardship and data alignment with organizations strategies and operations.
• 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/10.x/10.0.x/SSIS/SSRS Informatica, Erwin,T-SQL, NETEZZA.

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

Front End Tools: ERwin, ER Studio, Composite, Microsoft Project, Visible Analyst, and Lotus Notes.

Application Servers: Web logic, Web Sphere, Tomcat.

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

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

Programing Language: C#, HTML, SQL, R LANGUAGE, PL/SQL, UNIX Scripting, C++, XML.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Tableau Developer & Administrator

Responsibilities:

• Expertise in Tableau Desktop Worked with various dashboards and Story creation in Tableau.
• Involved in development activities such as requirements gathering, designing solutions, testing and deployment.
• Exported data from views with different formats in both Tableau Server and Tableau Desktop.
• Developed Tableau visualizations to support ad-hoc analyses and interacted with Business users in understanding their requirements.
• Mastered the ability to design, deploy rich graphic visualizations with drill down and drop up menu options.
• Created symbol maps to understand the geo-spatial distribution of projects with custom symbols made of represent the application category.
• Worked with multiple data sources & Created complex dynamic dashboards and stories.
• Proficient in building maps, creating hierarchies, sorting and grouping.
• Proficient in creating actions in worksheet level and dashboard level.
• Extensive experience on data blending.
• Published and presented dashboards on web and desktop platforms.
• Designed and implemented Business Process for reviewing, rating and implementation planning of these ideas.
• Experience in creating filters, quick filters, table calculations and parameters.
• Implemented individual axis, axis blending, and dual axis.
• Created advanced data views like Funnel chart and waterfall.
• Expertise in using reference lines, trend lines.
• Worked with Report Builder, and Power Pivot to build Ad-hoc Reports.
• Proficient in requirement gathering, documentation, creating POC (Proof of Concept).
• Capable of troubleshooting in different types of reports, SQL.
• Developed reports such as Dash Boards, Story Boards as per Clients requirements.
• Created Dashboards with Drill-Up and Drill-Down option in reports.
• Used Measure name and Measure Value fields to create visualizations with Multiple Measures and Dimensions.
• Combined data sources by joining multiple tables and using Data blending.
• Used complex and advanced calculations to achieve the desired requirement.
• Used Reference Lines to describe the data.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom.
• Interacted with Tableau Server to publish the data-views.

Environment: Tableau Desktop 10.3x, Tableau Server 10.3x, MS SQL Server 2017

Confidential, Rosemont, IL

Tableau Developer & Administrator

Responsibilities:

• Gathered end user requirements from business and Finance to develop Executive dashboards constituting of Financial Forecast, Pre-sales, and RiskUnderwriting Business.
• Involved in the complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Developed corporate financial dashboards using the enterprise business intelligence for evaluating the Growth, distribution and Profitability for the executives.
• Provide Business Intelligence support using Tableau for implementing effective Business dashboards & visualizations of data.
• Expertise in Performance Tuning TableauDashboards and Reports built on huge Data sources.
• 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.
• 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.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.
• Worked on SSRS extensively to create and design reports.
• Developed Information Technology Metrics dashboards to evaluate the efficiency of the Technology partners for the segment leads and improve productivity and delivery schedules.
• Worked on creation of workbooks and the appropriate permission sets for Tableau server logon’s and data security checks.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.
• Upgraded Workbooks and Dashboards from Tableau 8 to Tableau 9.

Environment: Tableau Desktop 10.x/9, Tableau Server 9.x/8.x/10.x, Tabcmd, MS SQL Server 2016, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Erwin r8, C#.

Confidential, Lincolnshire, IL

Tableau Developer / Admin

Responsibilities:

• Using Tableau Desktop created Interactive Reporting dashboards by combining multiple views.
• Performed the data quality checks by writing SQL queries and validated report counts.
• Analyzed various spend trends over time and researched the various data anomalies and the specific.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Establish technical framework around data cleansing, governanceand stewardship.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Created Heat Map showing current distributors by color that were broken into regions allowing business user to understand where we have most profitable vs. least.
• Involved in creating a dual axis bar chart with multiple measures.
• Wrote numerous SQL queries involving joins, unions and views for data extraction and data cleansing before analysis.
• Presented the visuals and assisted the management for taking the appropriate business measures.
• Took active part with the DBA's in creation of materialized views used for Tableau data extracts.
• Prepared Quarterly Analysis and examined whether the cost savings actually happened as per earlier analysis outcome.
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Perform quality assurance checks and update databases to ensure data integrity.

Environment: Tableau Desktop 8.0/9.1, Tableau server / Administrator, SQL developer, SQL 2012,Oracle 11g, DB2, MS SQL Server Integration Services,MS SQL Server Reporting Services, JavaScript API, Microsoft Excel, MS Access.

Confidential

Tableau / SQL Server Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Extensively usedcalculatedfields for different logics for Trend, Extended price calculations for the different cost types.
• Foundefficientways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Used SQL Queries at the custom SQL level to pull the data intableaudesktop.
• Developed database objects like tables, views, procedures, triggers, functions using TOAD /T-SQL to provide definition, structure and to maintain data efficiently.
• Validated the results inTableauby running SQL queries in Oracle SQL developer.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Strong Data modeling experience in using ER diagram, Dimensional data modeling, Working knowledge of T-SQL, SQL Packages, Triggers, and scripting languages.
• Performed performance tuning of the dashboard inTableaudesktop.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
• Perform production readiness audit of tableau applications developed by the users.
• Involved in the development of SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Environment: Tableau Desktop 7, Tableau Server 7, MS SQL Server 2008 R2, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2008, Erwin r7.

Confidential

Tableau / SQL Developer

Responsibilities:

• Created views in Tableau Desktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Converted charts into Crosstabs for further underlying data analysis in MSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Combined views and reports into interactive dashboards inTableauDesktop that presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developing complex T-SQLqueries, common table expressions (CTE), stored procedures and functions used for designing SSIS packages.
• 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 groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel.