SUMMARY

• Over 8 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.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Solid understand of SQL and have worked with various data source types like Oracle, Neteeza, SQL server.
• 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, Mar 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 in OBIEE 10g configuring repository, create/manage Dashboards, Reports/Answers using industry best practices.
• Subject Matter Expert in Oracle Business Intelligence and Data warehousing.
• Worked extensively in analysis and development of data warehouse applications using OBIEE 10g.
• Extensive experience working with Answers (Chart, Pivot, Radar, Pie, Scatter), Dashboards (Prompts, Reports, Embedded Contents, Images, guided navigation links etc.), BI Publisher, Delivers and iBots.
• 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

Specialties: Data Visualization, Business Intelligence (BI), Software Management and Data Collection.

BI Tools: Tableau 7.0,Tableau 8.0/8.1,OBIEE 10g/11g, ESSBASE 9.x

Relational Databases: Oracle 10g/11g, TERADATA, SQL Server 2005/2008, VERTICA

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, Crystal Reports

Languages: SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Sr. Tableau Consultant

Responsibilities:

• Develop various data connections from data source to Tableau Server for report and dashboard development
• Developed Dashboards using Hadoop as a data source.
• 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.
• 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.
• Ensured projects were completed on time and within budget.
• Utilize Tabadmin and Tabcmd commands to create backups and restore backups of Tableau repository.
• 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: Tableau 8.1, Tableau Server, SQL server, SSIS, Windows 7 and Hadoop Horton works.

Confidential, El Segundo, CA

Sr. 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.
• Utilize Tabadmin and Tabcmd commands to create backups and restore backups of Tableau repository.
• 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, TERADATA and JavaScript.

Confidential, Tampa, FL

Tableau Consultant

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Oracle, Vertica for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop those were published to internal team for review and further data analysisand customization using filters and actions.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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 onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Upgraded Workbooks and Dashboards from Tableau 7 to Tableau 8
• 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 groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: Tableau 7/8.0, Tableau 7 Desktop, Tableau server, Oracle, Vertica, Informatica 8.x, TOAD, Windows 2003/ XP, UNIX.

Confidential, PA

Tableau Developer

Responsibilities:

• Currently working on Proof of Concepts (POC) presentation and review with project and IT lead along with developingTableauDashboards.
• Recommended OS configuration for installing Win Server 2012 R2,TableauServer, andMSSQL Server 2012 R2.
• Adjust views/dashboards after initial POC presentation to Business Users.
• Brainstorm ideas onwhattoinclude in views/dashboards from the data sourceand document on the fly business requirements.
• Create views and dashboards on end client'ssales data. Producepowerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by Business Users.
• Cleanse and normalize data in MS Excelby combining from variousdatasources.
• PerformTableauServer admin duties; add users/groups from Active Directory; and schedule instances inTableauServer including weekly data dump.
• Train endclient users onTableauDesktop by providing step-by-step guidancefrom basics to advanced functions ofTableauincludingworking with calculations,parameters, and date functions.

Environment: TableauDesktop 7,TableauServer,Oracle10g, SQL ServerR2, MS Excel

Confidential, NYC

Tableau Developer

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.
• Implemented new features in Tableau 6 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 6.0, Tableau 6 Desktop, Tableau server, Oracle 9i, Informatica 7.x, TOAD, Windows XP.

Confidential, OH

OBIEE Sr.Developer

Responsibilities:

• 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 and snowflake Schemas.
• Worked with ETL Team using SSIS.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Performance Tuning of reports is done by identifying the indexes required on the backend tables and also from the data available in the Cache
• 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 & the Siebel Application level.
• Experience in customization of OBIEE front end user interface like creating new skins, Portal Banners and logo.
• Experience in configuring scheduler and delivers to alert to the users.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Used Guided analytics to display Sales below Threshold reports for different regions
• Performed OBIEE Administration - including creation of Users and cache management
• Created hierarchies based on the territory level for territorial level sales and contact reports
• Used constrained filters, column filter prompts and various views such as Pivot tables
• Developed interactive Dashboards using OBIEE Answers
• Experience in migrating the repository and web catalog from development to production environment.
• Experience in configuring slowly changing dimensions to generate the reports between a specified date ranges.
• Experience in configuring security using LDAP server.
• Have developed requests/custom reports using Siebel Answers based on payments, currency and liquidity in order to analyze and understand the liquidity store uncollectible and adjustments.
• Developed and executed Unit & Integration test cases scripts.

Environment: Oracle Business Intelligence 10.1.3.4.1 , Oracle BI Publisher 10.1.X, SSIS, Microsoft Windows XP Pro, SqlServer 2005, Windows Server 2003.

Confidential, FL

Responsibilities:

• 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 and snowflake Schemas.
• Enabled Usage Tracking Table and Dashboards.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Performance Tuning of reports is done by identifying the indexes required on the backend tables and also from the data available in the Cache
• 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 & the Siebel Application level.
• Experience in customization of OBIEE front end user interface like creating new skins, Portal Banners and logo.
• Experience in configuring scheduler and delivers to alert to the users.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Used Guided analytics to display Sales below Threshold reports for different regions
• Performed OBIEE Administration - including creation of Users and cache management
• Created hierarchies based on the territory level for territorial level sales and contact reports
• Used constrained filters, column filter prompts and various views such as Pivot tables
• Developed interactive Dashboards using OBIEE Answers
• Experience in migrating the repository and web catalog from development to production environment.
• Experience in configuring slowly changing dimensions to generate the reports between a specified date ranges.
• Experience in configuring security using LDAP server.
• Have developed requests/custom reports using Siebel Answers based on payments, currency and liquidity in order to analyze and understand the liquidity store uncollectible and adjustments.
• Developed and executed Unit & Integration test cases scripts.

Environment: Oracle Business Intelligence 10.1.3.4.1 , Oracle Warehouse Builder 11gR, Microsoft Windows XP Pro, Oracle 10g, Windows Server 2003, Oracle BI Publisher 10.1.X

Confidential, FL

OBIEE Developer

Responsibilities:

• 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 and snowflake Schemas.
• Converted SSRS report to OBIEE.
• Configured Business Intelligence Delivers.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Performance Tuning of reports is done by identifying the indexes required on the backend tables and also from the data available in the Cache.
• 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 & the Siebel Application level.
• Used Guided analytics to display Sales below Threshold reports for different regions.
• Performed OBIEE Administration - including creation of Users and cache management.
• Created hierarchies based on the territory level for territorial level sales and contact reports.
• Used constrained filters, column filter prompts and various views such as Pivot tables.
• Developed interactive Dashboards using OBIEE Answers.
• Scheduled reports and delivered the same to the end-users through Delivers.
• Have developed requests/custom reports using Siebel Answers based on payments, currency and liquidity in order to analyze and understand the liquidity store uncollectible and adjustments.
• Developed and executed Unit & Integration test cases scripts.

Environment: Oracle Business Intelligence 10.1.3.4.1 , ODI, ESSBASE, Microsoft Windows XP Pro, Oracle 10g, UNIX, SSRS, SSIS, SSAS

Confidential

Siebel Analytics Developer

Responsibilities:

• 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.
• Enabled Usage Tracking Table and Dashboards.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and ToDate functions.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Siebel Application level.

Environment: Siebel Analytics 7.7.4, Informatica 6.2, oracle 8i, UNIX, Windows NT platform, ER-win 4.0.