SUMMARY

• Over 7 years of experience in Data Visualization, Analytics, Data Management, Integration, Implementation and Maintenance of Business Intelligence Platforms with strong background in Database and Data Warehousing concepts.
• Around 4 years of extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau.
• Expert in evaluating data models to designTableausolutions and fine tuning dashboards and worksheets in large BI using tableau.
• Extensive Experience in various Tableau Desktop reporting features like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculations, Calculated fields, Sets, Groups, Parameters, Forecasting, blending and Trend Lines.
• Have been working with various data sources such as Oracle, SQL Server, Hadoop, ODBC and flat file sources.
• Experience in designing and development of various dashboards, reports utilizing Tableau Visualizations likebar graphs,scatter plots,pie - charts,geographic visualizationand other making use ofactions,otherlocal and global filtersaccording to the end user requirement.
• End to end experience in designing and deploying data visualizations using Tableau.
• Combined Reports & views into interactive dashboards in Tableau desktop and presented to Program Managers, Business users and End Users.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• In-depth knowledge in building/maintaining Repository, Universes and creating AdHoc reports.
• Created Parameters to achieve desired functionality and create risk metric analysis by coordinating with users.
• Ability to use custom SQL for complex data pulls.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Comfortable in working with Composite Data Types.
• Experience in developing and implementing tableau changes such as upgrades and migration.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
• Strong and practical knowledge of business intelligence concepts including Extract Transform and Load (ETL).
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, MS BI

Databases: Oracle (9i/10g/11g), MS Access, MySQL, Teradata

Query Tools: TOAD, SQL Developer, SQL*PLUS

Languages: SQL, PL/SQL, Core Java, Java Script, HTML, C

Applications: Eclipse, NetBeans, Oracle SQL Developer

Operating Systems: Windows XP/7/8, Unix

PROFESSIONAL EXPERIENCE

Confidential, Waukegan, IL

Sr. 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.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• 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 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.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• 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.
• 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.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• 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 8.0/9.1, Tableau server / Administrator, Tableau drive, SQL developer, SQL 2012, Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, Hadoop, MS Access, MS Excel, Windows 2007 server, Microsoft office 2007

Confidential, Lake Oswego, OR

Sr. Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Defined best practices for Tableau report development and extensive use of data blending feature.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.

Environment: Tableau Desktop 7 & 8.0, Tableau Server, Business Objects, SQL Server 2008/2012SQL, PL/SQL, Crystal Reports, Web Intelligence, Info view, MS Project.

Confidential, Rosemont, IL

Tableau Developer/Analyst

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, UNIX, Toad, MS Office, Visual Studio 2010.

Confidential, Fort Washington, PA

PL/SQL Developer

Responsibilities:

• Wrote PL/SQL procedures, packages, triggers in Oracle 10g as required. Involved in creation of databases, moved databases by recreating control files, export/import, and complete backups. Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Design Logical and Physical data, define relationships, and implement business rules as constraints for normalization / demoralization of entities.
• Developed custom forms using standard AOL components like template forms and libraries. Used descriptive flex fields extensively to capture additional information in standard as well as customized forms.
• Wrote SQL*Loader scripts to migrate the data from the text files, Spreadsheet etc. and populated the intermediate tables.
• Developed and implemented concurrent process to load item details from external sources into inventory item tables and also created forms to view interface errors with details and correct the data in the interface table.
• Performance tuned the PL/SQL stored procedures in Oracle 10g.
• Used Qwest tools (Toad 8.0, SQL Navigator) for database monitoring and tuning.
• Designed and developed forms and reports for easy data updating that increased data entry efficiency over the existing system.

Environment: Oracle 10g, Reports 9i, UNIX Shell Scripts, PL/SQL, Toad, PL/SQL Developer, SQL Optimizer, Putty.

Confidential 

PL/SQL developer

Responsibilities:

• Responsible for the designing advance SQL queries, procedure, cursor, triggers, batch files. -PL-SQL (Triggers & Procedures) written for updating the data into the database to update the reporting purpose tables.
• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.
• Design Logical and Physical data, define relationships, and implement business rules as constraints for normalization / demoralization of entities.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Developed and implemented concurrent process to load item details from external sources into inventory item tables and also created forms to view interface errors with details and correct the data in the interface table.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: Oracle 9i, TOAD, SQL Navigator, Forms, Reports, Windows XP.