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 TrackerSoftware 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

Confidential, Cedar Rapids, IA

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

Confidential, Cedar Rapids, IA

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.

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

Tableau Developer/ Admin

Confidential, Jacksonville, FL

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

Confidential, Lake Mary, FL

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

Confidential, Branford, CT

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