SUMMARY:

• 5 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms SQL Server and Tableau.
• Extensive experience with different phases of SDLC (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• Experience in working with Tableau Desktop, Tableau Server, Tableau Online, and Tableau Reader in various versions of Tableau 2018.1, 10.5/10.4/10.0/9.2/9.0/8.2/8.0 as a developer and administrator.
• Extensive experience with the design and development of Tableau visualization solutions.
• Extensive experience in using Tableau (Desktop/ Server), SQL Server, Oracle, Teradata, Informatica Power Center, Oracle 11g, and DB2.
• Experience in reviewing business requirements and analyzing data sources from Excel, Oracle, Hadoop, SAS, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Worked with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Experience in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report.
• Responsible for developing interactive data visualizations.
• Involved in upgrading Tableau platforms in clustered environment and performing upgrades.
• Expertise in designing and development of various dashboards used 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.
• Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/ analysis, design, development, testing and production rollover.
• Excellent experience in designing Dashboards, BI Answers, and Analytics using Tableau.
• Good experience in generating Sub-Reports, Drilldown reports, Drill through reports, and Parameterized reports using Tableau.

TECHNICAL SKILLS:

Data: Tableau Desktop/ Server 9.3/9.2/9.1/9.0/8.0/ Tableau reader/Public visualizations/Reporting tools

Data Warehousing Tools: OBIEE 10g, Hyperion Essbase, BI publisher, Informatica Power Center 8.1.1/7.1.2/7.1.1/7.1.5 , DataStge 7.5

Programming/Scripting: SQL, TSQL, PL/SQL

Databases: Microsoft SQL Server 2012/2008/2005 , IBM DB2, Teradata, Postgres sql, MS Access 2003, Oracle 11g/10g/9i/8i.

Methodologies: Waterfall, SCRUM and Agile.

Operating Systems: Windows, UNIX, Sun Solaris, Linux and MS-Dos.

Web Tools: HTML, XML, JAVA SCRIPT, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, Cordova, CA

Tableau Developer

Responsibilities:

• Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Built functionalities by writing condition to in corporate with various metrics and hands on experience in Level of Detail Expressions (LOD’s) such as Daily profit KPI, Percent of total, yearly trending analysis and root cause behavior.
• Writing complex SQL queries on Teradata handling source data challenges and adapting to the dynamic nature of the project.
• Developed various reports using SQL for Inventory Management and Innovations team in accordance with Business Strategies.
• Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
• Involved in reviewing business requirements and analyzing data sources from Excel/MySQL.
• Designed and deployed interactive reports with Drill Downs, drop down menu option, Parameters and Linked reports using Tableau
• Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, and parameters.
• Scheduled data refresh on Tableau Server for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Develop parameter-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
• Migrated all dashboards from Tableau 9.3 to 10.3 and 10.5 to 2018.1
• Used SQL tools like Squirrel and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.

Confidential, Fremont, CA

BI Analyst/ Tableau Developer

Responsibilities:

• Involved in reviewing business Server for design, development, within Tableau Desktop. requirements and analyzing data sources form CSV/Oracle/SQL testing, and production rollover of reporting and analysis projects

• Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map by color that was broken into Counties and Zip codes allowing business user to understand and help the state officials to focus on the Low KPI areas.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Worked with administration team to configure and installation of tableau server and proof of concepts.
• Connected to SQL server and SAS as data sources.
• Used data blending concepts to blend data from different data sources (CSV and MySQL and CSV and Oracle and between data bases).
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• 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.
• Applied Cascading Prompts and Multi Level Prompts on dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Exhibited internal sales trends using Tableau for better understanding of profitability of different client segments. This replaced time consuming Excel/ SAS based data analysis.
• 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.
• Created Test Scenarios to validate Tableau dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Confidential, Cincinnati, OH

Tableau Developer

Responsibilities:

• Responsible to Create Dashboards for compliance reports, treasury reports, Daily P&L reports for Client and internal management using Tableau Desktop and Server.
• Involved in migration reports from various reporting tools like Spot fire, QlikView, and OBIEE to Tableau.
• Involved in migration reports from Oracle BI Publisher to Tableau. And involved in Data extraction and transformation to Oracle BI to Tableau.
• Implemented Installation of Tableau Desktop 9.0/8.3 and Tableau Server.
• Used Trend Lines, Lines and Annotations to describe the data. Created Data extracts for better performance and accessing data offline.
• Had good knowledge and experience in Data Modeling. Used parameters and input control to give users control over certain values.
• Worked extensively on setting up groups, roles and user permissions in Tableau Server.
• As a Site Level Admin created Project folders & assigned permissions for respective Active Directory groups.
• Managed the application’s users, groups, and integration with Active Directory.
• Experience in taking backups and restoration of Tableau repository.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created complex calculation using Table Calculation, Date, Aggregate functions in Tableau.
• Providing support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Assisting QA team in creating Test Cases, Test Scenarios and working closely with QA team in managing all the reported defects.
• Working closely with the Business teams in organizing for UAT Sessions and assisting business teams to write use cases throughout UAT Phase.
• Assist managers in meeting client expectation by monitoring timely delivery of daily, weekly and monthly deliverables.
• Involved in integration of Tableau JavaScript API Filters in web application.
• Basic understanding of financial instruments, accounting concepts, Hedge Fund Industry.
• Prepared financial statements for all funds on the monthly, quarterly, and yearly basis.
• Publishing Reports, workbooks & data source to the server and export the reports in different Formats.
• Effective oral and written communication. Ability to engage meetings/calls with clients/counter parts in other groups.

Confidential

Tableau Developer

Responsibilities:

• Extensive experience 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 colors that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth by developing reports to show in detail.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Bullet graphs were created to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Generated report by blending data from multiple databases into one report by selecting primary keys 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.
• 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.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Confidential

Tableau Developer

Responsibilities:

• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created and managed project templates use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved with respect to the evaluation criterion.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers.
• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case.
• Used SQL queries for organizing and extracting data from Teradata databases to suffice adhoc data requests for Business Users.
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Accumulated system requirements for analytical reports across different subject areas like Finance, Marketing, Merchandising users to convert MicroStrategy reports to Tableau reports.
• Designed standardized data marts with aggregated tables and views to suffice data sourcing requirements for Tableau reporting solutions.
• Configured the Data mapping between Oracle and SQL Server to Teradata.
• Designed and Developed single reports instead of multiple reports as in Tableau by implementing row level security and user filters to cater multiple users with different access levels to the data.
• Conducted meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies with Tableau power users.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests).
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).