Pankaj Sharma

Sr. Tableau Developer

Professional Summary:

Over 7+ years of experience in designing, developing and implementation of Business Intelligence using Tableau 7.x/8.x/9.x, OBIEE 10g & 11g.

4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 7x,8x, 9x.

3+ years of expertise in OBIEE 10g and 11g versions handling RPD & Dashboards/reports development including data/object level security implementation.

Hands-on experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau8.0 to 9.0).

Reports development using various reporting tools like Tableau and OBIEE.

Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.

Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.

Participated in Tableau 9.0, 10.0 Beta Program both Desktop and Server editions.

Experience in Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's.

Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica UNIX, DB2, Oracle and SQL Server technologies.

Experienced in OBIEE 10g which include building and configuring repository, creating and managing oracle Dashboards, oracle Answers, oracle Delivers and oracle iBots (ETL Informatica, Reporting-Siebel Analytics, Scheduling-DAC).

Experienced in Data Warehousing Methodologies.

Experienced in OBIEE solution architecting (OBIEE 11g & OBIEE10g) and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server.

Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing metadata layers including Physical, BMM, and Presentation layer.

Experienced in working with Oracle Fusion & Web Logic.

Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.

Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements.

Experienced in Oracle EBS R12 Financial.

Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.

Expert ability to trouble shoots and prioritizes issues.

Excellent interpersonal and communication skills for efficient client interaction.

Technical Skills:

Operating Systems:

Windows 2000/XP/Vista/7, UNIX, Linux

Methodologies:

Rational Unified Process (RUP), Waterfall, Agile/Scrum-KANBAN

Business Tools:

Requisite Pro, UML, MS Visio, Mock Flow, Mockingbird, JIRA, Empower, nbA (New Business accelerator), Rapid (Automated underwriting tool), Bug Tracker,

Software Packages:

MS Office Suites, MS Project, MS SharePoint 2007/2010, MS Visual Studio, Adobe Photoshop, Rally, ServiceNow

Testing Tools:

Rational Clear Quest, Mercury Test Director, Quality Centre, QTP, Load Runner, Xml Pad

Database:

Oracle, SQL Server 2005/2008/2000, MY SQL, Oracle SQL Developer (2005, 2011)

Professional Experience:

Sr.Tableau Developer/Admin

Transamerica, Cedar Rapids IA September 2015 – Till date

Responsibilities:

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Experience in migrating client's reports from excel (static) based solution to an interactive service.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI's.

Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.

Installed Tableau Server 8.0/9.x in Dev, QA, UAT and Prod environments.

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.

Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.

Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test.

Access dashboards from any browser or tablet.

Experience in MS SQL Server Configuration, Performance Tuning of stored procedures.

Created incremental refreshes for data sources on Tableau server.

Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.

Coordinated database middleware issues with DBA's, system performance with System Architects.

Involved in license management SLA's with Tableau support.

Having experience in SME (Subject Matter Expert) in all BI tools.

Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.

Defined and created procedures to install Tableau desktop in silent mode.

Defined best practices for Tableau report development.

Worked on scheduling the extracts and setting up the permissions.

Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau Desktop 8.0/9.3, Tableau server / Administrator, tabcmd,SQL developer, SQL 2012, Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Sr. Tableau Developer/Admin

Transamerica, Cedar Rapids IA, June 2015 – September 2015

Responsibilities:

Responsible for design and development of interactive business operational reports, scorecards, KPI dashboards, and automated reports used for measuring productivity and performance.

Involved in implementing data blending feature to get data from SQL Server and MS Excel.

Created sheets, stories and dashboards using Stack bars, Bar graphs, Scattered Plots, Geographical maps, Heat maps, Bullet charts, Gantt charts.

Implemented custom SQL to support business requirements.

Preparing Dashboards using calculations, parameters in Tableau.

Creating calculated fields, groups, sets and hierarchies etc.

Creating data blending in case of merging two different datasets.

Built complex formulas in Tableau for various business calculations.

Created and assisted users in tableau dashboard development and assessment of need of tableauserver (in the process of implementation).

Transitioned reports from currently used set ups like SAP BO, and Flat Files to Tableau.

Administered and provided analysis on financial data for R&D department and Cost Analysis

Defined and created procedures to install Tableau desktop in silent mode.

Defined Group level security standards for Tableau and educated application teams on pre-defined access levels and their purpose.

Working with Mobile App Development and Testing Group to analyze data and application gaps

Defined best practices for Tableau report development.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Environments used: Tableau Desktop 8.2, 8.1, Tableau Administrator, SharePoint, Oracle10g, Flat Files, Microsoft Excel.

Tableau Developer/Admin

Auditmacs, Jacksonville, FL October 2014 – June 2015

Responsibilities:

Creation of database objects like tables, views, materialized views, procedures and packages using oracletools like Toad, PL/SQL Developer and SQL* plus.

Partitioned the fact tables and materializedviews to enhance the performance.

Extensively used bulk collection in PL/SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducingcontext switching.

Designed Technicaldesigndocument based on the businessrequirements.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Defined best practices for Tableau report development.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Developed and Prepared Unit Test documents.

Developed several stored procedures to handle large amount of data manipulation.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the errormessages in the application.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Upgraded the existing database from Oracle 9i to Oracle 11g.

Involved in Logical & Physical Database Layout Design.

Created queries to minimize transactions table data size and copy into historical tables.

Modified exiting UNIX Shell Scripts to schedule daily jobs.

Improved the performance of the application by rewriting the SQL queries.

Involved application deployment process and co-ordinate with DBA Team.

Environment: Oracle 9i/11g, Tableau Server 7.1, Tableau Desktop 7.1, PL/SQL, TOAD, Sun Solaris, HP- Quality Center.

Business Analyst

Convergys, Lake Mary FL June 2011 – October 2014

Responsibilities:

Served as a liaison between internal clients and functional departments; help clients achieve their objectives by serving as a resource in the interpretation, application and compliance with internal and external laws, regulations, policies, procedures, standards and practices.

Develop and build internal and external partnerships to improve communication, coordination, collaboration and effective working relationships within own department, across the Company and outside the Company.

Utilize Microsoft SharePoint concepts, practices and procedures within an enterprise environment.

Researched, analyzed, synchronized, maintained, modified, interpreted, validated and prepared ‘AS IS’ to ‘TO BE’ data and documentations for the development team.

Followed up and delivered all enhancement functionality assigned within a Sprint.

Created User Stories for the scrum development team to build a shippable product increment every sprint

Expert in agile methodology.

Produced, edited and distributed a variety of business documents such as reports, proposals, technical manuals, policies, system and process documentation, etc.

Created, presented and/or facilitated meetings, webinars, conference calls, training programs, education sessions, certifications, etc. for a variety of internal and external audiences. Represented assigned function at external symposia, conferences, meetings, etc.

Experience in On-site/Offshore Model

Business Analyst

Bank of America, Branford, CT Apr 2009- June 2011

Responsibilities:

Gathered the business requirements from Global Compliance Risk team by interacting on a day to day basis and got an understanding of different compliance categories, risk assessment units, regional regulations etc.

Designed Business Process Diagrams, Business Requirements document, Project Charter and other artifacts required at the initial phase of the project using RUP

Delivered detailed Use Cases and business rules traceability matrix covering all the proposed functionalities of the new tool which helped bring a sound product deliver in production

Contact this candidate