SUMMARY:

• Over 8+ years of experience in Tableau, OBIEE, ETL, Informatica and ODI as a developer.
• Extensive experience working with Tableau Software as a dashboard developer and Business Analyst.
• Experience in creating dashboards with relational and multi - dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
• Experience in creating aggregates, hierarchies, sorting and grouping.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters and implementing Individual Axis, Axis Blending, Dynamic axis and Dual axis in Tableau.
• Experience in creating various views and interactive dashboards in Tableau.
• Extensive knowledge in various reporting objects like Facts, Dimensions, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Strong understanding of Data warehouse concepts and ETL.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Expert in validating data in report with the source of the data by back tracking process.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other s according to the end user requirement.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience handling Customer requests and work with them in Iterative process and fulfill their needs.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Expertise in Production Support related activities.
• Involved in creating dashboards and reports in Tableau 10.x/2018. x.x. Created report schedules on Tableau server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Extensive experience interacting with Department Managers and different levels of users and developers.
• Experience in MS PowerPoint presentations for end users and in MS Access and MS Excel.
• Ability to communicate business and technical issues to both business users and technical users.
• Excellent communication skills, strong teambuilding and conflict management skills.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters) using Presentation services.
• Good at analyzing, requirement gathering, documenting and editing Business/User Requirements. Also worked in distinct Business units, Process units, Review processes etc.
• Knowledge of OBIEE, Informatica and ODI tools.
• A Self-starter with a positive attitude, willingness to learn new concepts and to accept challenges, as well a very good team player
• Knowledge on ETL process, Debugging and validating data in data warehouse.
• Ability to convert complex business requirements into easy understanding reports.
• Experience in sales and e-commerce analytics.
• Worked on various complex channel mix calculations. Experience in doing analysis on data. Finding different causes based on the reports and analysis.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x, 8.x/7.x/6.x, ODI 11.X

Reporting Tools: Tableau 2018.X/10.X/9.x/8.x/7.x, OBIEE 11.1.1.x, 10.1.3.x

Database: SQL Server 2012/2008/2005 , Oracle 11g/10g/9i/8i, Teradata

Programming Languages: SQL, PL/SQL

Office Applications: Microsoft Office 2007/2003/2000/97 (Word, Excel, PowerPoint)

Operating Systems: LINUX, Windows XP/2003/2000/NT/98

PROFESSIONAL EXPEREINCE:

Sr. Business Intelligence /Tableau developer Engineer

Confidential, IRVING, TX

Responsibilities:

• Participated in Business Requirement Documents review, Functional Requirements Documents Data Model Reviews to understand the requirements as per the business requirements.
• Interacted with the client to understand high level business requirements as a Business Analyst.
• Played key role in Performing Analysis, Design and development of multiple Tableau dashboards and deployed in multiple environment (Dev/Stage/Production).
• Worked on concepts like joins and cross database joins.
• Worked on different kinds of reports as per business requirement.
• Developed many Reports / Dashboards with different Analytics Views, Pivot table, Chart, Column Sector, Tabular with local and global filters) using Presentation services.
• Mastered the ability to design and deploy rich Graphic visualizations with Parameterized and calculated fields using Tableau.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive Experience of Tableau Server Concepts like creating users, sites and projects.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Worked on various MOM and YOY calculations. Also, various cannel mix percentage calculations.
• Excellent Knowledge on Tableau Server Process and architecture and Tableau Deployment model.
• Worked on creating visualizations using custom hierarchies, groups and merged data from multiple sources using the cross-database join technique within the tableau workbook.
• Worked on Creating calculations and parameters to change data dynamically.
• Used appropriate Formatting Headers, Worksheets with different Visualization Color Coding for displaying the Complex Data in Dashboards to View easily.
• Documenting all the changes and maintaining them in SharePoint sites which help in future enhancements.
• Worked extensively Performing Unit testing, integrating Testing providing test cases for the QA team.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the Tableau Server.
• Involved in Support activities postproduction.
• Worked on developing various sales and e-commerce reports and calculations. Converted complex pivot views to easy understanding Tableau report.
• Good Team player always got appreciation from client for understanding and giving proper Business Insights to the executives. Explained use of report and data of the views by using feature like Tool tip.
• Used LOD expressions to do MOM and YOY calculations in Tableau.
• Knowledge on E-commerce and sales platform reports and data.
• Worked on huge datasets and tuned the queries to improve the performance of reports.
• Developed various funnel and various visualizations to show case KPIs and data flow over years on various platforms of Confidential
• Involved in documentation for future .

Senior Business Intelligennce consultant

Confidential

Responsibilities:

• Developed and delivered reports, dashboards and visualizations in Tableau as per the client’s requirements.
• Involved in publish, maintain and schedule activities of the reports/dashboards in Tableau server
• Interacted with business users on daily basis to gather requirements and demo the dashboards and presentations.
• Complete visualizations for assigned activities and publish them to Tableau server.
• Assisted users with questions and issues using Tableau.
• Involved in Collecting data on various process measurements and formatted into graphs using Tableau.
• Worked with Heterogeneous Databases and used the Cross-Database Join function available in Tableau.
• Working with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Worked extensively with advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics, and log axes, groups, hierarchies, sets to create detailed level summary reports, and dashboards using Tableau Desktop.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• 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 group discussions as well as communicating with stakeholders and business groups.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Experience in creating joins, sets, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, parameters and Level of detail expressions (LOD).
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Responsible for using different Mark types and Mark properties in views to provide better insights into large data sets.
• Responsible for creating Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Involved in Support activities postproduction.
• Involved in documentation for future .

Staff BI consultant

Confidential

Responsibilities:

• Develop many Reports and Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Analytics.
• Define Repository and Session variables using initialization blocks to control user access.
• Set connection pool properties to move database dimension tables into the physical layer to model into the RPD.
• Implemented hierarchy to address a one to many relationships in the BMM layer.
• Used agents/iBots for scheduled reports to be delivered to users based on a set of conditions that automatically generates a report when the trigger conditions are met •
• Deployed RPDs into analytics and tested them by creating simple reports.
• Trained users and testers on OBIEE functionality.
• Extensive experience in using OBIEE log files to diagnose issues.
• Managed security by creating users and groups and assigning users to their respective groups.
• Expertise in working in BI Admin Console, Enterprise Manager, and OBI Analytics.
• Managed performance by use of cache management to improve query response time.
• Used catalog manager to move catalog objects from one environment to another using archive and unarchive.
• Worked in all three layers of the admin tool (Physical, BMM, and Presentation layer)
• Imported tables from the data warehouse into the physical layer
• Created alias tables for re-use of the database tables
• Created star and snowflake schemas in the physical layer.
• Created hierarchies in the BMM layer to allow drill-down capabilities in reports.
• Enabled log levels in Admin tool to allow developers to see query logging and help diagnose report issues
• Deployed the RPD into analytics via the Enterprise Manager.

Associate BI consultant

Confidential

Responsibilities:

• Work with users in gathering the requirements, Fit Gap Analysis. Design, architect, document and implement technical solution using OBIEE and Informatica.
• Extensively worked on Performance improvement for reports and Dashboards
• Developed complex mappings in Informatica using different transformations Source Qualifier, Filter, Expression, Update Strategy, Router, Lookup - Connected & Unconnected, Sequence Generator, etc
• Creating the repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer) which includes working closely with the ETL team and implement primary key and foreign key relationship among physical facts and dimensions.
• Created session, repository and presentation variables and implemented data level and object level security.
• Created dimension hierarchies to drill down to the most detailed level of data as per business requirements.
• Set connection pool properties to move database dimension tables into the physical layer to model into the RPD.
• Involved in Designing and customization of Oracle BI Answers Reports and Dashboards.
• Used catalog manager to move catalog objects from one environment to another using archive and unarchive.
• Expertise in working in BI Admin Console, Enterprise Manager, and OBI Analytics.
• Efficiently interacted with users. Worked as primary point of contact for BI application for users across the Globe

Associate consultant

Confidential

Responsibilities:

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Implemented Business logic by creating dimension hierarchies, level-based measures and aggregates in BMM, presentation catalogs and folders in presentation layer.
• Created EBS query to validate OBIA reports.
• Performed Authentication and Authorization (Created new groups and added users to the group, implemented object and row level security).
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse (SIL mappings).
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Control user access to various parts of OBIEE platform, granting permission and granting rights and privileges. Creating users, roles and groups.
• Involved in Designing and customization of Oracle BI Answers Reports and Dashboards.
• Involved in Support activities post production.

Associate BI consultant

Confidential

Responsibilities:

• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer of an Metadata Repository (.rpd) using Oracle BI Administration Tool. Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services and Validated according to client expectation. Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse. Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications. Involved in migrating Repository and Web Catalog files from Development to Test and Production environment. Involved in taking backups of Repository and Web Catalog files. Developed Workflows using task, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor. Debugged the Informatica sessions by utilizing the logs of the sessions. 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 group discussions as well as communicating with business groups and end users.