SUMMARY

• Tableau Desktop and Server Qualified Associate(Certification from Tableau)
• Over 7 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Solid understand of SQL and understand and have worked with various data source types like Oracle, Neteeza, SQL server, Excel, Actian Vectorwise etc.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mark Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Used OData URL of Sales force connector table to connect to the Tables.
• Experience in configuring reports from different data sources using data blending.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML
• Improved Reports performance in tableau using extracts and context filters
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 9, Tableau Server 9, OBIEE 11g/10.1.3.4

ETL Tools: Informatica 7.x/8.x (Power Center)

RDBMS: Oracle 9i/10g/11g, MS SQL Server 2008, Teradata

Languages: HTML, XML

Operating Systems: Windows 95/98/NT/2000/XP/7

FTP Tools: WinSCP 5.X, Filezilla 3.5.x, Putty

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Tableau Consultant

Responsibilities:

• Set up the Tableau environment from scratch.
• Gave training to all the new users and help improve the learning curve.
• Was part of the governance team and help build a governance model around the usage of Tableau
• Created Finance dashboards which included complex calculations like YTD, MTD, Forecast, Budget etc
• Conducted weekly forums for user groups to help me learn Tableau.
• Load Tested Tableau server to identify the best configuration for our environment.
• Set up Disaster recovery Environment and automated the sync process to keep the prod and DR in sync
• Created scripts which helped maintain Tableau server. Server backup, site backup and monitoring of the server were all part of the scripts.
• Performed Server upgrades. Testing, sandboxing were done before upgrading to a newer version of Tableau server and Tableau desktop.
• Converted reports build in another reporting service(MARS) to Tableau reports.
• Worked with the Salesforce team to embed Tableau reports in their Salesforce accounts.
• Created custom admin views by connecting to the Internal postgres database of Tableau server.
• Leveraged security in the database to apply data level security in Tableau

Environment: Windows XP, Tableau 9, Tableau Server 9,SQL Developer, MS-SQL 2012 R2, MS-Access, MS Excel and JavaScript, OLAP, OLTP, Oracle, Actian Vectorwise

Confidential, Austin, TX

Tableau Consultant

Responsibilities:

• Develop various data connections from data source to Tableau Server for report and dashboard development
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Utilize Tabadmin and Tabcmd commands to create backups and restore backups of Tableau repository.
• Utilized tableau command line tools of Tableau Server for automation and maintenance.
• Good knowledge and experience on Tableau licensing: guest, interactor, viewer, editor.
• Connected to OLAP and OLTP datasets to build visualizations.
• Tableau server maintenance, Tableau server backup activity.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Environment Support to User community, Service Request & Resolution.
• Expertise in failed over activities in production Environments.

Environment: Windows XP, Tableau 8.1/7.0, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and JavaScript, OLAP, OLTP

Confidential, Sunrise, FL

Tableau Consultant

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tabcmd and Tabadmin utility tool.
• Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 7/8.0, Tableau 7 Desktop, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Confidential, Boston, MA

BI Consultant

Responsibilities:

• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Used MUD environment during development of the project.
• Responsible for Creating the Physical Layer, Business Model and Mapping Layer and Presentation Layer in ANA Repository (.RPD) using Oracle BI Administration Tool.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Ago(), To Date based on the Requirements.
• Created Attributes and Metrics in the BMM layer.
• Created Aggregated Tables to improve the Performance of the Reports.
• Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to 11.1.1.6.0.
• Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.
• Used theCatalogmanager and maintained the web catalog to manage Dashboards and Answers.
• Test the reports and data in OBIEE against Micro strategy and validate them.
• Responsible for documenting the OBIEE framework and track the progress.

Environment: OBI 10/11g, Informatica Power center 7.1.2/8.1,Oracle 11g, Microsoft Windows Server 2003, MS VISIO.

Confidential, CA

Business Analyst

Responsibilities:

• Analyzed application needs by interviewing and brainstorming with stakeholders for customer requirements.
• Involved in Business Process Re-Engineering- Reviewed Existing systems against the customer requirements and determine opportunities for custom development.
• Fully documented requirements through prototyping, customer narratives, and use cases to be used by developers to build applications.
• Worked on Rational Rose to create use cases, class diagrams, sequence diagrams.
• Analyzed reporting needs of stakeholders through system analysis, customer interviews. Created Business Requirements Documents to be used by Data Analysts to create reports.
• Coordinated between the on-site coordinator and development team at Offshore to derive correct requirements for the product.
• Co-ordinated with the testing team to design, document and carry out User Acceptance Testing (UAT) and report bugs to the development team.
• Used tools like Quality Center, HP Quick Test Professional to conduct various tests and log/report defects.
• Provided application support for applications. Helped distinguish the issues to whether they were user-related, technology-related or feature related.
• Followed up and coordinated with carious stakeholders to track the application and make sure that all the features are working and to analyze if there are any improvements needed.

Confidential

BI Developer

Responsibilities:

• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Added Aggregate measures using Aggregate Persistence Wizard.
• Enabled Usage Tracking Table and Dashboards.
• Configured Business Intelligence Delivers
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sing on (SSO) functionality.
• Developed automation tool to seed and purge the cache in Admin tool.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level.
• Migrated the Repository from Development to Production using UDML Utilities.
• Involved in designing STAR schema and developed complex Mappings / Mapplets using various Transformation / Re-usable Transformations (Update Strategy, Filter, Router, Expression, Lookup, and Aggregator) for implementing Dealer Data Warehouse.
• Designed and developed Pre and Post session tasks and data extracted from Transaction System into Staging Area.
• Developed custom SDE and SIL mappings to extract and load the data into Warehouse.
• Experience in customizing out of the box reports to support the business requirements.
• Experience in configuring sources, targets, tasks and execution plans using DAC.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Involved in assigning and managing privileges and rights given to the appropriate users and groups using Oracle BI Presentation Services Administration.
• Involved in the creation of Presentation groups and users to provide access to the appropriate reports and dashboards.
• Involved in managing the users to access Interactive dashboards by using the security matrix.

Environment: Oracle Business Intelligence 10.1.3.2,Siebel Analytics 7.8.2/7.8.4 , Siebel 7.5.3.4, Informatica Power center 7.1.2/8.1, DAC 7.7,Oracle 10g.

Confidential

BI Developer

Responsibilities:

• Created custom functions, stored procedures and packages to retrieve the data from tables.
• Involved in creating synonyms to reduce the usage of base tables to securing the data.
• Extensively used cursors, cursor for loops to fetch the data from different tables.
• Involved in writing UNIX shell scripts.
• Developed and deployed the User Interfaces using Oracle Developer 6i Forms.
• Developed and deployed the reports using Developer 6i Reports.
• Performed optimization of SQL queries (Used Explain Plan, TK-prof and Hints to tune SQL Queries.)

Environment: Oracle 8i, PL/SQL, Sun Solaris 5.0, Forms 4.5i, Reports 5, TOAD, SQL * Loader