SUMMARY

• Experience in integrating front and backend Technologies to create modern and secure interactive visualizations.
• Experience in implementation of Data Warehouse, BI solutions and expertise in data modeling (star/snowflake ), Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• Expertise in working with Business SME is to translate business requirements and KPIs into BI/Analytics models, views, Reports, dashboards, and query objects.
• Implemented Tableau best practices in deployment and migration of reports
• Expert in design/development using 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.
• Extensively involved in Reverse - Engineering and Business Rules Extraction Expert in project planning, Strategic planning, systems analysis, troubleshooting, quality control, scheduling and planning and tracking results.
• Experience in configuring reports from different data sources using data blending.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security, performance tuned Reports using extracts and context filters.
• Experience in working as both Senior BI Administrator and Developer in different Domains (Hospitality, Financial, HealthCare) using one or several of the following: Tableau, OBIEE, SAP BO.
• Expertise in Developing OBIEE 11g/12C Interactive Dashboards with drill-down & drill-across capabilities
• Extensive experience in working with various EDWs like Teradata, Oracle and exposure to working with Cloud Databases like, Azure SQL Data Warehouse, Google Big Query and Exposure to Hive, Hyperion Essbase
• Versatile, innovative and motivated self-starter with strong, hands-on technical management experience, adept at juggling multiple tasks in a high-pressured environme nt and strong communication skills

TECHNICAL SKILLS

Business Intelligence: Tableau Desktop (Certified) 2019.1/2018.1/10.3/9.3/9.0/8.3 , Tableau Server, OBIEE 12c/11g/10g, SAP BO Admin/Developer, Power BI.

ETL/ELT: Informatica Power Centre 9.x/8.x/7.x, DAC, ODI, Bteq, CAWA, Azure Data Factory.

Databases: NoSQL, Big Query, Oracle 10g/11g, TERADATA, SQL Server.

Languages: SQL, PL/SQL, C, C++, json, python, Hive, PowerShell.

Methodologies: Rally, Data Modeling, Star Schema, FACT & Dimension Table, Erwin

Application Server: Oracle WebLogic Application server 9.x/10.x/12.x

Operating Systems: Red hat Linux 7.x, 6.x, 5.x, 4.x, IBM AIX 5.x, 6.x, 7.x, Windows 95/98/2000/XP/Server 2008 R2/2012 R2/2016 and MacOS X

Cloud Technologies: Microsoft Azure

CI/CD Tools: Azure DevOps

Version Control: Git, GitHub, Azure Git, Subversion.

PROFESSIONAL EXPERIENCE

Confidential

Sr Tableau Consultant

Responsibilities:

• Worked with Business Owners and Business Analysts for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Converted business requirements into design, develop, and delivered interactive data visualizations using Tableau Desktop and Tableau Server and also design, develop and delivered reports using other Business Intelligence tools.
• Configuring Workday Compensation including Compensation Elements, Eligibility Rules, Grades, Compensation packages, and Compensation Plans.
• Serve as point of contact for HR Representatives and Managers for Workday related issues.
• Developed data analytics and dashboards to satisfy requirements.
• Created custom reports & multiple calculated fields.
• Good exposure to Workday Configurable security
• Created User Stories, Epics and Themes using Rally followed by Agile Methodologies.
• Using Oracle HCM cloud/WORKDAY as a data source and created Dashboards.
• Embedded Tableau Dashboards in report app.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created KPI Dashboards for Operational Dashboards, Diversity, Span of Control, Recruiting offer prep and Succession.
• Developing Tableau data visualization using Donut charts, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, Gantt charts and various other charts based on the business desired.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Performed ETL activities for new and existing dashboards and reports.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Maintained assigned areas of the current Human Resources dashboard/Report library and performs necessary dashboard and reporting activities.
• Maintains Security permission structure in Tableau Server and other Business intelligence tools (e.g. Alteryx and OBIEE).
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.

Confidential

Sr Tableau Consultant

Responsibilities:

• Responsible for designs, Configure, create Reports/Dashboards, Visualizations in Tableau from legacy reporting tools like OBIEE and SAP BO.
• Meeting with Business Users/End Users to Discuss requirements and gain feedback on the developed Reports/Dashboards.
• Developed Highly customized Tableau Dashboards and KPI score cards for Executive Managements (CFO, VP) using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Worked directly with stake holders to enable self-service Reporting and analytics in on data source from wide variety of system like Teradata, HIVE, Primary using Tableau Desktop.
• Created BI 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.
• Proficient in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals), Drill through reports, and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
• Analyzed booking and reservations flow from GRS systems to Big Data databases like Hive and created Tableau mockup Visualizations.
• Performance tuning of reports and resolving issues within Tableau Server Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.
• Designed and Optimized Connections Live, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Created data sets in Tableau Desktop from SAP BO UDT tool by using Data connectors for Global sales Team.
• Act as single point of contact for Confidential Business to provide support in resolving any issues with Business Intelligence applications spanning across Tableau, Oracle Business Intelligence, SAP Business Objects, Confidential Reporting Java Applications.
• While playing the role of an Administrator, ensure code artifacts are in-sync between lower and Production Environments, also responsible for ensuring that various development teams follow Confidential coding standards while working on their projects.
• Ensure high availability of business-critical reporting systems by Identifying issues, performance bottlenecks, and optimizing the Business Intelligence Dashboards and Reports by working with Development Teams and Database Administrator.
• Work on the User Stories/tasks assigned as per Rally Board and create and KT relevant documentation to migrate to Prod for RFCs, worked on Prod issues (as per created Incidents on Service Now).

Confidential

Sr OBIEE Consultant, Developer/Administrator

Responsibilities:

• Performed Installation and Configuration of OBIA/OBIEE Server for High availability including additional OBI components ranging from Dev to Production Environment.
• Integrated OBI Apps 7.9.x with Seibel CRM so that users can navigate between the applications using SSO.
• Designed and developed OBIEE 10g/11g Metadata repository (.rpd) that consisted of Physical layer, business model and Mapping layer (Aggregates, Dimensions and time Series functions) and presentation Layer.
• Worked closely with ETL team in regard to schema and data model design,
• Created and monitored DAC execution plans in DAC, Worked on DAC subject Areas like Financials - General Ledger, Financials - Payables, Financials - Receivables etc.
• BI Apps/OBIEE implementation of Financial Analytics Subject Areas: Financials - AP Balance, Financials - AP Overview, Financials - AP Transactions, Financials - AR Balance, Financials - AR Overview, Financials - AR Transactions.
• Customized existing dimensional hierarchies for drill down, aggregate navigation, level-based measures and time series functions based on the requirements.
• Developed and customized many Reports using different Views (Pivot Table, Chart, and Column Selector), Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts.
• Implemented security by creating users & web groups, setting up LDAP, creating session variables and initialization blocks and associating catalog objects and Web modules with the created groups.
• Upgraded the client environment from OBIEE 11.1.1.5 to OBIEE 11.1.1.6 and higher.
• Worked extensively on OBIEE 11g components like Oracle Enterprise Manager (EM), Oracle Web logic server administration console and application (presentation services).
• Managed Migrations across all the Environments (migration of RPD and Webcat including BI Publisher Reports from DEV to Higher Environments), including fail overs.
• Performance tuning of reports which having considerably longer durations of returning results for both newly developed as well as those in production as part of Production support.
• Created RTF templates in Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.
• Supported Production Release activities, Provided 24x7 Production Support (often outside business hours)