SUMMARY:

• A Tableau Developer with 9+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms in Retail, Manufacturing, Banking/ Finance, Health Care, Delivery Services and Pharmaceutical industries.
• Proficient in Tableau 10.x/9.x/8.x/7.x/6.x (Desktop, Server, Online), Business Objects Webi, Crystal reports, Dashboard designer/Xcelsius, SSRS, Power BI, SAP BOBJ Cloud Analytics and Informatica Power Center.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• In depth understanding of the As - Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Expertise in using Tableau Filter, URL and Highlight actions to switch between sheets and navigate to external or internal websites
• Expert in visualizing the data, reporting and analyzing, creating the dashboards and reports in an intelligible pictorial representing like bars, geographic maps, bubbles, pies, lines etc.
• Proficient in creating Tableau scorecards, dashboards using advance Tableau functions like Calculated fields, Sets, bins, Groups, Parameters, Actions, Level of Detail (LOD), Adhoc Calculations, etc.
• Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
• Extensive experience in creating users, groups, sites, row level security and monitoring server activities in Tableau Server.
• Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,
• Expertise in analysis, design and implementation of data warehousing applications using Teradata,, Informatica UNIX, DB2, Oracle, SQL Server and MySQL technologies.
• Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Expert in Trouble shooting, Performance tuning the reports and resolving the issues within the server and dashboards.
• Excellent communication skills, Team lead and player and interpersonal skills.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
• Experience working with offshore team.

TECHNICAL SKILLS:

Tableau Desktop/Server/On: Line 10.x/9.x/8.x, Power BI, Dashboard Designer, SQL, Google Analytics, Google Sheets, Server Reporting Services (SSRS).

ETL Tools: Informatica Power Center 9.x, SQL Server Integration Services (SSIS), Tableau Prep.

Languages: SQL, Custom SQL, Stored Procedure, ANSI 89/92, PL/SQL, HTML, Python

Data Modeling: Star Schema/Snowflake Schema model, Fact & Dimensions tables, SCD Type 1/2/3, OLAP, OLTP, Conformed Dimensions

Databases: Oracle 10g/11g/12C, MS SQL Server 2008/2012/2014, Teradata, MS Access, Salesforce, MySQL, DB2, PostgreSQL, Hive.

Operating Systems: Windows XP/Vista/7/8/10, MAC OS X, Linux, Unix

Microsoft Tools: MS Excel, MS Word, MS Project, MS PowerPoint

Industries: Banking/Financial, Investment, Healthcare, Retail, Manufacturing, Pharmaceutical and Delivery Services.

Document Management: JIRA, Share Point, Version One

PROFESSIONAL EXPERIENCE:

Confidential, Greenwich, Connecticut

Lead Tableau Developer

Responsibilities:

• Involved in the solution scoping of the project.
• Organized workshop sessions to gather business requirements (blue printing) from the business users.
• Built Strategic, Analytical and operational dashboards using Tableau.
• Built interactive dashboards using extracts from Google Analytics and Big Query.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.
• Implemented row level security for the Tableau dashboards and used various advanced table calculations for the dashboards.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and Teradata.
• Created stored procedures, user defined functions, views, tables and T-SQL scripting for complex business logic.
• Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending
• Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.
• Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements
• Implemented visualizations and views including combo charts, stacked bar charts, Pareto charts, donut charts, geographic maps, sparklines, crosstabs etc.
• Defined visualization pixels and created dashboards using vertical/horizontal containers and collected dashboards in Tableau Story Tableau dashboards embedding into Salesforce for the continuous data experience for the users,
• Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforce to show the relevant data for that selected object.
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.
• Developed tableau dashboard landing page for the embedding into Salesforce to provide integrated views and navigation inside Salesforce for the users.
• Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data.
• Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.

Environment: Tableau Desktop/Server 10.x/9.X, MS Office Suite, Google Analytics, Adobe Analytics, Sales Force, SQL Server 2014, Salesforce, Teradata, SQL Assistant, SharePoint, JIRA, MS Excel.

Confidential, Houston TX

Lead BI Consultant

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, and scorecards and developed the same using Tableau desktop
• Mentored business power users to create reports/dashboards using Tableau desktop.
• Design, build and maintain logical model for Tableau reporting application.
• Design, build and maintain all Tableau schema objects (attributes, facts, hierarchies).
• Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Tableau server and desktop upgrade from 9.3 to 10.3.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Make use of filters and making them local and global accordingly.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, iPhones, and other smart mobile phones.
• Exhibited internal sales trends using Tableau for better understanding of profitability of different client segments. This replaced time consuming Excel/ SAS based data analysis.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users could generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Created several base formulas (mathematical expressions) using existing facts in Tableau that can be re-used to build any number of metrics.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Used Tableau QA Testing server to migrate Tableau objects from development environment to the Test environment.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 8.x (Desktop/Server), Teradata, Oracle, SQL Server, Informatica, Teradata SQL Assistant, SharePoint, PL/SQL, Oracle 11g, UNIX, Documentum, Microsoft office Suite

Confidential, Minnetonka, MN

BI / Tableau Developer/Analyst

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Involved in the complete Life cycle of the Project and in the data analysis process
• Gather the various requirement matrices from the business analysts.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Created technical designs for the various reporting requirements.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed different BI Dashboards for the Company Executives, through an efficient use of Tableau Report Services.
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Helped end users with integration of their front-end application with tableau server by establishing trusted authentication.
• Created rich dashboards using tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Maintained Test Log and wrote Test Evaluation, Summary Reports.
• Setup and Deployed tableau server to publish dashboard to a central location for portal integration
• Implemented row level security and windows AD authentication for Tableau reports
• Worked with the tableau community to extensive test the tableau 8 beta version

Environment: Tableau 8.x (Desktop/Server), Teradata, Oracle, SQL Server, Power Designer, MS Visio, JIRA Microsoft Office Suite (Word, Excel, Power Point, Visio).

Confidential, Houston TX

Data Analyst Lead

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developed and maintained high level overview of the project and design flows using MS Visio.
• Created dashboard using parameters, sets, groups and calculations.
• Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• 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.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Created incremental refreshes for data sources on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau online.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Migrated reports from Business Objects to Tableau 8.
• Worked on Framework Manager Models Relational DMR for Standard Reporting and Adhoc Analysis
• Validated the Data Loads in the Cube using Analysis Studio
• Developed numerous multi tab multi page dashboard reports based on the existing remedy database incident management system with drill through functionality to the detail reports.

Environment: Tableau Desktop/Server 6.x, Business Objects, SQL Server 2008, SQL Server Management Studio, Oracle11g, DB2, Clear Case, Excel, Linux.

Confidential - Pocatello, ID

Data Technician/Oracle DBA

Responsibilities Include:

• Creation of roles, privileges, profiles policies for group of users and assigns roles to proper end users.
• Perform daily routine dba tasks. Managing tablespace, data files, reading alert performance tuning using reports with 3rd party software.
• Controlling and monitoring user access to the database.
• Creation and management of multiple instances for testing and development.
• Take care and troubleshoot, if any problem occurs in computer labs, making sure all the computers are in running condition and all of the hosts have live connection to DB.
• Tuned the oracle memory structure (Buffer cache, library cache, Shared spool, sort area).
• Implementation of Database Monitoring scripts to monitor the Space usage of various tablespaces, Memory tuning, I/O and network traffic.
• Have performed Oracle RAC & ASM Admin/Installation.
• Created, upgraded, and cloned Oracle databases for Development and testing environments.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Implemented RAC and Physical Standby databases for High availability and disaster recovery.
• Performance monitoring using explain Plan, STATS PACK, AWR, ADDM, and Oracle Enterprise Manager.
• Implemented Oracle database backup & recovery solutions using RMAN as well as conventional backup methods.
• Retrofitted HR and Payroll based on new requirements and customizations.
• Worked on Data Mover Scripts (DMS Scripts) on HR and Benefits tables to validate in different environments
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Identify gaps in business processes not met by delivered solutions in PeopleSoft HCM 8.8 system.

Confidential

Oracle Database Administrator/OBIEE developer

Responsibilities Include:

• Performed Database Performance Tuning and Monitoring of Databases.
• Designed and implemented Security Policies.
• Configuring the Auditing of database at DB or OS level, to monitor illegal use of database.
• Utilized Oracle Export and Import utilities to perform logical database backup and recovery, to move Oracle data from one machine, database or schemas to another and to detect database corruption
• Controlling and monitoring user access to the database.
• Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
• Created schemas with partitioned external tables for a production environment, using SQL Plus.
• Using Hints in Select Statements for Best Execution Plans. (After gathering statistics through Explain Plan, Analyzing the Table, Indexes).
• Configured the database for maximization of disk space utilization and memory utilization and minimizing the disk I/O to make the application faster.
• Administered Oracle 9i and Infrastructure support using Oracle OEM.
• Performed requirement analysis, capacity planning for databases and system infrastructure.
• Populated Oracle tables with data from external and non- oracle files using SQL*Loader utility.
• Used Stored Procedures for performing complex business logic involving database access and for validating information.
• Support the database with logical backup as well as cold and hot backups.
• Design variety of Triggers for object create, alter, drop, server errors, startup/shutdown and for logon/logoff.
• Built Databases and refreshed them by executing the scripts.
• Developed shell scripts for day to day database administration activities.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Written SQL Loader Scripts for data extraction and transformation.