We provide IT Staff Augmentation Services!

Obiee/tableau Consultant/tech Lead Resume

5.00/5 (Submit Your Rating)

Phoenix, AZ

SUMMARY

  • Result oriented professional with eight years of experience in design, analysis, development, implementation and support of various Business Intelligence applications (Tableau, OBIEE 10/11g, 12c, Qlikview).
  • Excellent communication skills; strong competence in utilizing technology to convey varied information types; excellent problem - solving skills with the ability to provide creative solutions; ability to excel under pressure in deadline-driven situations; highly adaptable to rapidly changing business environment.
  • Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project usingTableau 9/10, OBIEE10/11.
  • Hands-on experience in SDLC processes and methodologies in Business Intelligence domain, Agile(Scrum) and Waterfall development environments.
  • Extensive business analyst experience:
  • Worked with end users on requirement gathering, and feasibility analysis
  • Worked with test team to define test cases
  • Ensured that everything went to production as expected
  • Solid understanding of Data warehousing and Dimensional Modeling.
  • Good at writing SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, User-defined Functions.
  • Created solution driven views/reports by developing different chart types such as Heat maps, Scatter plots, Geographic maps, Pie charts, Bullet graphs, and Histograms in Tableau desktop.
  • Highly capable of working on advanced analysis- actions, Calculation fields, Table calculations, Trend lines, Bins, Dual axes, Forecasting, and Hierarchies.
  • Created reports by using Filters, Sets, Parameters, Groups and data bins as per requirements.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
  • Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
  • Hands-on experience in Tableau public and Tableau server. Created and published Tableau dashboards/reports into Tableau server.
  • Created key performance indicators using table calculations and manipulating strings, arithmetic calculations, aggregation options and logical functions.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Monitored and maintained incremental refreshes for data sources on Tableau Server.
  • Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Worked with Individual Axes, Blended Axes, and Dual Axes.
  • Created Subscriptions for dashboards through Tableau Server to receive daily email according to user requirement.
  • Worked on both system administrators and site administrators with the correct permissions to add users from the Users page.
  • Basic understanding of data mining - clustering segment using R and Tableau
  • Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) ofan OBIEE Metadata Repository(.rpd) using Oracle BI Administration Tool.
  • Experienced indesigning customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.

TECHNICAL SKILLS

Languages: C, C++, PL/SQL, R, Python

Reporting Tools: OBIEE, Tableau, Hyperion Interactive Reporting, Financial Reporting Studio, Excel Spreadsheet Add-in, QlikView

Databases: Oracle 11/10/9, MS-Access, SQL Server.

Programming languages: C, C++, SSIS SQL 2005

Operating Systems: Windows, UNIX.

Other: Alteryx

PROFESSIONAL EXPERIENCE

OBIEE/Tableau Consultant/Tech Lead

Confidential, Phoenix, AZ

Responsibilities:

  • Worked with business users to gather information, defined subject areas for analytical data requirements
  • Performed gap analysis and feasibility study for the given requirement.
  • Worked with ETL resources in building the staging area by explaining the file formats needed to load metadata, data, and security.
  • Created multiple analytical dashboards in Tableau to maintain and analyze employee information throughout the global.
  • Created multiple ad-hoc dashboards to understand the customer spending habits and how they responded to different offers (credit cards).
  • Created dashboards according to user specifications and prepared stories to provide an understandable vision in OBIEE and Tableau.
  • Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
  • Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server 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 on Tableau Server for weekly and monthly increments based on a business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-Coding.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Monitored and maintained incremental refreshes for data sources on Tableau server
  • Customized the OBIEE Repository (physical, BMM, and presentation layers).
  • Created connection pools, imported physical tables and defined joins in the Physical layer of the repository
  • Created dimension hierarchies, aggregates, and keys in the BMM layer.
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
  • Worked on repository and session variables.
  • Created materialized views and aggregates to improve performance.
  • Setup Usage tracking option to monitor frequently run reports to provide caching for the reports and perform database optimization by analyzing query performance.
  • Customized reporting with OBIEE Answers and integrated them into the Dashboards.
  • Generated Reports and Dashboards by using Report features like Pivot tables, charts, and view selector.
  • Created Dashboards with global prompts, column selectors, navigation, and automatic drill-down
  • Created user level security for intelligence dashboards based on Business Requirements.
  • Created Dashboards with Dashboard prompts, Charts, Pivot tables.
  • Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.

Environment: Oracle Essbase 11,OBIEE 11.1.1.7, OBIEE 11.1.1.5, OBIEE 12c, Informatica, Tableau

OBIEE/Tableau Consultant

Confidential, Irving, TX

Responsibilities:

  • Involved in requirement gathering meetings and translated all the business requirements into technical requirements.
  • Worked with ETL resources in building the staging area by explaining the file formats needed to load metadata, data, and security.
  • Conducted data investigations and assisted the business partners with complex data analysis and ad-hoc queries
  • Extracted data from various sources and performed data blending.
  • Created multiple operational, analytical, and tactical dashboard to track and analyze inventory level/movement, and vehicle utilization.
  • Created ad-hoc dashboard to understand the customer behavior, how they respond to different offers in different regions.
  • Generated the test plan specifying an overview of the testing approach, testing strategy, roles, responsibilities.
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
  • Customized the Geo maps to use custom shapes and converted latitude/longitude sets to City/state using Reverse Geocoding utility.
  • Wrote Custom SQL to fulfill User Requirements and used Parameters in custom SQL for the Dynamic prompts as requested by the end users.
  • Participated in Preparing Detailed technical documents from the functional specifications.
  • Published Reports, workbooks & data source to the server and exporting the reports in different Formats.
  • Designed, documented and tested logical and physical data models optimized for operational and analytical reporting
  • Performed the changes to the physical layer, Business Model, and Mapping Layer and Presentation Layer in an OBIEE Repository for all new objects that needed to be added.
  • Conducted thorough Unit Testing, System Integration Testing, UAT, and Production Support Co-ordination effectively
  • Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.
  • Source data from Essbase to build reports.

Environment: Oracle Essbase 11,OBIEE 10/11g, ODI, QlikView, Tableau

OBIEE Developer

Confidential, Houston, TX

Responsibilities:

  • Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
  • Analyze, Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer
  • Worked on oracle 11g database, used 11g's usage tracking to keep updated of all the ongoing processes.
  • Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
  • Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
  • Trouble shooting the issues related to repository models and report development.
  • Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
  • Administered the Cache parameters and implementing the cache feature for improving the BI Server performance
  • Create users and groups and assigning the security privileges.

Environment: OBIEE 10.1.3.4, Oracle 10g, SQL, Informatica

We'd love your feedback!