SUMMARY:

• Over 7 years of experience in Data warehousing, Business Intelligence Reporting, Data Analysis and Software Designing platforms.
• Working knowledge as a Techno Functional Tableau Consultant and OBIEE consultant for multiple clients which includes gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts, BI Tools .
• Extensive knowledge in working withTableauDesktop andTableauServer (7.x/8.x).
• Expertise in developing the Reports, Dashboards, resolving Performance issues and implementing best practices using Tableau/OBIEE and other BI tools.
• Over 2 years’ experience in Installing Tableau and Develop, Configure and provide Administration Support services.
• Extensive experience in writing complex SQL queries and has worked with various data source types like Oracle, MS - SQL server, Salesforce, Excel, Google analytics.
• Proficient in Troubleshooting issues with existing reports, understanding of Data connections to Oracle, MS-SQL Server and other Databases for Data blending.
• Skilled in Tableau Desktop for creating Data visualizations, Reports, Analysis, Cross Maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Charts.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop and Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Experience in connecting SharePoint list Data, Salesforce Tables using native connectors in Tableau.
• Expertise in Implementation of Tableau/Oracle BI security at the Data level (Data security) and Object level (Roles and Permissions) security.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience in the development of Dashboards of the Key Performance Indicators for the top level management.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems utilizing RDBMS Methodologies
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Familiar with Customer databases Analysis and Support and involved in performing OBI administration activities across all OBI instances on Red Hat Linux platform.
• Expertise in Financial, Retail and Insurance domains with skills in Sales, Marketing, Operations, HR functional areas.
• Result oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

Languages: HTML, SQL, Python, Java script, Shell scripting

Reporting tools: Tableau 7.x/8.x, OBIEE 10.x/11.x,Micro strategy 9.x

ETL Tools: Informatica 9.x/8.x., Talend

Applications: Eclipse, Net Beans, Oracle SQL Developer.

Databases: Oracle 9i/10g/11g, MS SQL Server 2000/2005/2008, MS Access.

Operating Systems: Windows XP/7/8, Mac OS, Linux, UNIX

CRM: Salesforce.com

Packages / Tools: MS Office, Toad, Putty

PROFESSIONAL EXPERIENCE:

Confidential - Los Angeles, CA

Sr.Tableau Developer/Administrator

Environment: Windows XP, Tableau 8.x, Tableau Server, Talend, Oracle Database 12c/11g, SQL Developer, MS-SQL 2008 R2, MS-Access, Salesforce, Google Analytics, MS Excel and JavaScript.

Responsibilities:

• Responsible for gathering business requirements from various users of different Departments and stake holders.
• Responsible for Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Responsible for gathering requirements and understanding the source systems to implement EDW/MDM/BI.
• Responsible for Data Modelling, Data Analysis, Data Integration and Data Visualization.
• Responsible for Building MDM/EDW.
• Responsible for Building Sales, Marketing and Finance reports and dashboards.
• Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing to Business users in using Tableau.
• Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.
• Responsible for converting all excel reports in to Tableau reports and dashboards.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Experience in creating Dashboards by connecting to different data sources like Google Analytics, Salesforce and different data sources.
• Experience in working with Tableau server to create data sources, creating users and Tableau installation and providing to Business users in using Tableau.
• Experience with creating advanced reports in Salesforce.com.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterization using Tableau.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Responsible for providing Tableau to business users and halping them in self-service Analytics.

Confidential -Irving, TX

Tableau Developer/Administrator

Environment: Tableau 7.x/8.x,Oracle 11g, Informatica 9.1/8.x, OBIEE 11g/10.x, SQL, SQL*Plus, TOAD, Windows 2003/XP, UNIX

Responsibilities:

• Responsible for creating different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in tableau server from Tableau Desktop.
• Responsible to convert reporting data from old version to new version in Tableau and validating Data.
• 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.
• Responsible to migrate dashboards from OBIEE to Tableau.
• 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.
• Responsible for administration of Tableau server, maintenance and Tableau server backup activity.
• Consolidate multiple data silos dat exist on campus to one location. Scheduled data extracts on a daily basis.
• Worked with all levels of development from analysis through implementation and support.
• Created groups and users in Tableau server. Used commands in Tabcmd and Tabadmin utility tool.
• Migrated Workbooks and Tableau upgrades/migration works. Implemented new features in Tableau to the existing Workbooks and Dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements.
• Developed featured Dashboards for each of Metrics by embedding Reports.
• Responsible for providing Intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary for reports.
• Responsible for creating complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.

Confidential

Sr. OBIEE Developer

Environment: OBIEE 10.x, Oracle 10g/9i, TOAD, SQL Developer, Informatica Power center 8.x, Windows Server 2003, MS VISIO.

Responsibilities:

• Involved in Analysis and Design of the data warehouse.
• Involved in requirement gathering with business analysts and end users.
• Extensively used OBIEE Administration Tool for creating physical, business and presentation layers of repository.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers and troubleshoot performance and solving issues related to BI team.
• Responsible to monitoring and fixing bugs in production box. Understand the Architecture and Server Configurations (Database, OBIEE Source System).
• Supported and responsible for implementation, administration and configuration of OBIEE functionality.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developing Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies. Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards.
• Associated with Production support team in various performances related issues.
• 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.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.

Confidential

Database Analyst

Environment: Oracle Database 8i / 9i, SQL*Plus, iSQL*PLUS, Oracle 9i Data Guard, TOAD, Red Hat Linux AS 2.1, Win NT/XP, SQL*Loader.

Responsibilities:

• Responsible for installation, configuration and administration of Oracle 8i/9i Database.
• Responsible for Cloning and administration of Oracle database products in different environments.
• Responsible for Performance tuning and Optimization of SQL queries.
• Created Users, security, backup, recovery and tuning.
• Carrying out specific Benchmark SQL Queries, Query execution plans and locking issues.
• Writing SQL*Loader control scripts and stored procedures.
• Loading data into database using SQL*Loader utility for billing and processing the detail call records.
• Written Database Triggers, Stored Procedures using PL/SQL.
• Successfully created and debugged many PL/SQL procedures, functions and Packages for the application.
• Analyzing requirement of client, generating and designing reports.
• Creating Data Structures i.e. tables & views and applying the referential integrity.
• Designing Data conversion/Interface with the use of SQL*Loader, and Open Interface, and convert data.
• Managing Rollback Segments and Temporary segments.
• Maintained Local Reports Server and local Test beds of oracle 9i on RHEL 3.0.
• Ability to summarize millions of transactions within limited time.
• Ability to move large quantities of data in and out of Salesforce by using Apex Data Loader.
• Providing meaningful analysis based on available data.
• Responsible for Analyzing and trouble-shooting technical issues related to data.
• Responsible for preparing business case for new project or scope items.
• Performed data Analysis to Assess Scope items.
• Pulling data from various sources in Oracle, Access.