SUMMARY:

• 10 + Years’ experience in designing, developing and deploying of Tableau and Business Intelligence Applications. Expertise working in Telecommunications and Networking industry, Auto, Financial, Banking and Healthcare.
• Experience in Data Visualization Tool Tableau Desktop and generated the reports using Tableau 2018.2, 2018.1, 10.5, 10.x, 9.x, 8.x Versions.
• Worked on Power BI Desktop to analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Experience in Excel BI tool kit add in Power query to extract and transform data and Power Pivot for the data modeling process.
• Experiences on Tableau tools include Tableau Desktop, Tableau Reader, Tableau Public, and Tableau Server.
• Analyzed Sales, Marketing, Customer Service and Customer Support business processes used by salesforce.com customers and recommended ways to improve their processes using salesforce.com.
• Created a POC for implementing cross joins and transformations using Tableau Prep tool
• Produced attractive visuals/dashboards to convey the story inside the data Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Experience in Big Data Database tools Hadoop Hive/Impala, HP Vertica, Amazon Redshift and Traditional DB tools Teradata, Oracle, Dbeaver and MS SQL Server Management Studio.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in using ETL Tool Alteryx for mapping huge amount of data.
• Experience in creating different visualizations using Bars, Lines, Pies, Geo Maps, Scatter plots, Bubbles, Bullets, Tree maps, Heat maps and Highlight tables.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades. Built complex formulas in Tableau for various business calculations.
• Deployed the reports and Scheduled Reports for the use of end users and customers.
• Expertise in Batch scripting and effectively used TSM commands and Tabadmin and Tabcmd utilities.
• Good understanding of SFDC implementations covering Sales Cloud, Service Cloud and App - exchange applications.
• Expertise in writing SQL Queries, SSIS, SSRS, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Worked on Big data sources like Hadoop Hive, Pivotal Greenplum and Amazon Redshift with Tableau as the front end and created several complex reports with optimal performance.
• Worked on SAP Business Objects to pull the data using queries based on the requirements from business managers.
• Good Knowledge in reviewing Test Procedures, extensively interacted with the QA Team in executing the Test Plans for UAT, providing Test Data, creating Test Cases, analyzing bugs, interacting with team members in fixing errors and also assisted in Post - Production support.
• Partnering with clients to gather all requirements to formulate business specifications and translate those into application functionality, understanding value proposition of the project.
• Excellent professional skills by working independently and as a team member to prepare and create test plans, test scripts and test cases for manual and automated testing.

TECHNICAL SKILLS:

Business Analysis Tools: Rational Rose, Rational Requisite Pro, MS Visio

BI Tools: Tableau Desktop and Tableau Server 2018.2, 2018.1, 10.5, 10.x, 9.x, 8.x, 7.x, Power BI Desktop, Power Pivot, Power View, Alteryx, SAP BO

Operating Systems: Windows XP/NT/2000/98/95, UNIX, Linux

Databases: MS SQL Server 2008/2005, Oracle 12g/11g, Hadoop Hive, Amazon Redshift, Teradata, Dbeaver,Sales cloud,Salesforce.

Office Tools: MS Access, MS Excel, MS Word, MS Power Point, MS Project, MS Outlook

Languages: SQL, mySQL, XML

Methodologies: Agile, Waterfall, Scrum.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Sr. BI Developer/Tableau

Responsibilities:

• Gathering and analyzing the business requirements based upon the requirements from business partners
• Extracted data from Excel files, Oracle, SQL Server populated into EDW and consumed by Tableau desktop.
• Effectively used data blending, quick filters, actions, hierarchies’ features in tableau.
• Created an integrated performance metrics dashboard that provides all the Train related information such as number of trains, Total trips by region, number of trips delayed data etc.
• Worked on a complex dashboard “Engineer scorecard” that provides all the employee related data in terms of high and low performers based upon their score which is given using the business logic.
• Created actions, filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau
• Created Complex data flows using ETL Tool Alteryx.
• Extensively used Microsoft Power BI Desktop for the data modeling process and create various visualizations.
• Extensive Experience in SalesForce CRM with end to end implementation experience.
• Worked on complex SQL queries in Oracle database for creating BI layer for Tableau reporting.
• Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Creating users, groups, projects, Data connections, settings as a tableau administrator. Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Identified and defined Key Performance Indicators (KPIs) in Power BI and Tableau.
• Designed and developed the backend modules using MS-Excel / VBA / MS-Word / WordBasic for document automation.
• Created dashboards in Tableau/Power BI by connecting/ extracting data from various sources like HANA, SQL Azure Cloud, SQL Server, Excel, Oracle, Salesforce Sales Cloud (SFDC) and Snowflake.
• Experience working across various SFDC implementations that are covering Sales cloud, Service Cloud and Apttus CPQ.
• Experience in SAP Business Objects to pull the data using queries and create a report based on the requirements from the business managers.
• Scheduled data refresh on Tableau for Daily and Weekly increments based on business change to ensure that the views and dashboards displaying the changed data accurately
• Experience in creating complex Stored Procedures, Functions, Indexes, Tables, Views and other SQL joins for applications.
• Scheduled one-on-one Meetings with Business Managers to understand current reconciliation process; Gathered requirements from key stakeholders, customers and subject matter experts to define the scope and requirements of Reports .

Environment: Tableau 2018.2,10.5,10.1,9.3,9.2, Power BI Desktop, SAP Business Objects, Alteryx, MS Office, Oracle,Sales cloud, CRM, SQL Server, SQL.

Confidential, Detroit, MI

BI Developer/Data Analyst

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Documented business reporting requirements (functional/non-functional) and translated them into solutions.
• Created visually compelling and actionable interactive reports and dashboards. Utilized table calculations, parameters, filters, charts, mark cards, sets, nested sorting, trend lines etc.
• Effectively Used Tableau Data Blending Feature to blend the data from multiple source systems.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extracted data from Flat files, Teradata, SQL Server and Hadoop Hive populated into EDW (Teradata) and consumed by Tableau desktop.
• Expert in ETL tool Alteryx for data mapping process.
• Analyzed the data using data modeling feature Power BI Excel add in Power Pivot and created pivot tables to display the data.
• Developed complex SQL Queries for Teradata database for creating BI layer on DW for tableau reporting.
• Worked on multiple complex tables through Custom SQL.
• Utilized Javascript API for integrating Tableau server with companies front end applications.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using tableau desktop and publish them to server.
• Created Filled maps, actions, parameters, Filter and calculated sets for preparing dashboards and worksheets using Tableau
• Expert in MS Excel functions for data analysis process.
• Strong team member with good communication and analytical skills.
• Experienced in tuning long running SQL queries for better performance.

Environment: Tableau 2018.2,10.5,10.1,9.3,9.2, Power BI Desktop, MSBI Power Pivot, Power View, MS Office, DBeaver, Teradata, SQL Server, SQL.

Confidential, Bothell, WA

BI Tableau Developer

Responsibilities:

• Gathering and analyzing Business requirements to integrate Customer Global Marketing database.
• Developed dashboards in Tableau desktop and published them on to Tableau server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created calculated fields to customize available data for reports.
• Effectively used data blending feature in Tableau.
• Good Experience in using Tableau URL’s, hyperlinks, and filters for developing complex dashboards.
• Used Power pivot for Data modeling to pull the data using Oracle database.
• Responsible for Business Intelligence Solution and reporting for enterprise and corporate business units
• Identified information and analytical needs of business users with regard to data analytics, Business Intelligence (BI).
• Created Data extract for Amazon Redshift data source and pulled the data through Tableau to create the Interactive Dashboards and Storyboards
• Developed Reports and performed Project Planning using Power Pivot, Power View and Tableau.
• Worked on the Data Modeling using Power Pivot to extract, transform and load the data from the Oracle Database.
• Worked on 6.0 Sigma using BI which indicates the highest quality of an application using DPMO and Unique Visits count of an application. 6.0 Sigma Indicates highest quality.
• Responsible for development of Pivot charts in different formats like Column, line, Bar, stacked and clustered based on the requirements from business managers using BI power pivot and power view.
• Experience in SAP Business Objects to pull the data using queries and create a report based on the requirements from the business managers.
• Utilized Confidential & Confidential Route-It software to maintain proper call volume balance between the calls.
• Always took initiatives to call for meetings when it was required and resolved most of the issues by understanding the root cause.
• Worked on Business Process Flows, Data modeling, Use Cases.

Environment: Tableau 10.0,9.3,9.2,9.1,9.0,8.2, MSBI Power Pivot, Power View, MS Office, SAP Business Objects, Amazon Redshift, SQL Server, SQL, mysql.

Confidential, Fremont, CA

BI Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Created Pivot charts and Pivot tables using MSBI Power Pivot tool.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Identified and worked with Parameters (e.g. cascading parameters) for parameterized reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Experience in the Date Modeling using Power Pivot to extract, transform and load the data from the Oracle Database.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other Confidential -SQL code and SQL joins for applications.
• Experience in pulling the data using MS Access and created reports based on requirements.
• Created various types of reports like Dashboard, Variance, Forecast and client active reports.
• Effectively used data blending, quick filters, actions, hierarchies’ features in tableau.
• Executed and tested required queries and reports before publishing.
• Converted Metric insight reports to tableau reports.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau 8.0, 8.1, 8.2, Tableau Server, MSBI Power Pivot, Power View, SQL Server, Confidential -SQL, MS Access, SSRS, Windows 2008 Server

Confidential, SFO, CA

BI Tableau Developer

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
• 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, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking Confidential Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 7, Tableau Desktop 7, MS SQL Server, Oracle 10g, Excel, TSQL, UNIX, SQL BI Suite (SSIS, SSRS), Oracle 11g, Toad, MS Office, Visual Studio 2010.

Confidential, Louisville, KY

BI Tableau /SQL Developer

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements
• Participated actively in designing the system database structure.
• Responsible for MS SQL Server 2012, SQL2008 R2, 2005 Installation, Configuration and Tuning.
• Performed performance tuning of stored procedures using SQL Server Profiler
• Involved in the development of custom stored procedures, functions.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
• Data center Migration where migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS and converted few of them to visualizations using Tableau
• Created complex calculations that go into the individual visuals using Tableau for getting Analytical insights of the data.
• Writing logic using the EDI Tool Kit to pull correct data fields, ability to interpret and implement requirements for EDI claims per carrier, testing with carriers, creating carrier specific edits, etc.
• Transmission of all EDI Claim Files - this includes ensuring files are processed and accepted, retrieving and reviewing all reports, maintaining logs, distributing reports appropriately
• Generated Reports using Data Source Views in Report Builder.
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Drill Down, Drill through, linked and sub reports using SSRS.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.

Environment: SQL Server 2005/2008/2012, Confidential -SQL, Tableau, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, SSAS.