SUMMARY

• Over 14+ Years of experience in Design, Development, Data Warehousing, documentation and implementation of the software in Six Sigma approach with Master of Information Technologies (M.I.T).
• Managed both offshore and onsite - offshore project delivery models for Service delivery, Implementations and enhancement projects with 100% Say do.
• Managed team with 6 members.
• Extensively worked on Tableau 2019.1/2018.2/10. x as Admin and Developer
• Having Strong analytic skills and ability to develop, and implement analytical data models and dashboard and reports using Tableau to enable customers to analyze data and make business decisions.
• Ability to work iteratively and converts business requirements quick prototypes with different Visualization options
• Solid understanding of Tableau presentation and data layer and implementation of Security with Tableau
• Experience in rolling out Tableau as Self-service solution for large number of users
• Ability to advise customer in governance of Tableau as self-service analytics tool
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Ability to analyze performance issues and recommend optimizations for best performance
• Extensively worked on Tableau2018/10.5, Business Objects tools 5.x/6.x/XI/R2/XI3.x/4.x Designer (UDT, IDT), Deski/Webi, Xcelsius, Crystal Reports, Import Wizard, Query as Web Service, Report Conversion Tool, Bex, CMC and Live Office.
• Good Experience of SAP Lumira and Design Studio.
• Extensive experience on Business Objects XI 3.1 Integration with SAP BI and SAP R/3.
• Proficient in all phases of the Software Development Lifecycle, including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Proficient in designing and building Universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts, checking Integrity of Universes.
• Extensive experience on Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail Formulae, Breaks, Alerts, Filters, Sorts, Query Prompts and Drill filters.
• Extensive experience in handling the Central Management Console(CMC) and Central Configuration Manager(CCM) to create and manage the users and groups, applications, security and rights to the users
• Strong Experience in Performance Tuning and Query Optimization, Optimizing universe through Linked universes, Aliases and Contexts.
• Expert in Crystal Reports, created complex reports including parameter based reports, graphical reports, sub-reports, formula based, well-formatted reports, analysis reports, drilling reports and LOV.
• Experience with BO Dashboard Manager/Xcelsius in creating score cards, static and dynamic dashboards using Live Office QaaWS, Query browser and BI services connectivity.
• Strong understanding of Data Warehouse concepts, OLAP, Star Schema, Multi Star Schema, Snowflake schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Fact & Dimensions tables, Physical & Logical Data Modeling & ER diagrams
• Experience in using the Promotion Management Tool, LCM BAIR /import wizard to move reports and universes from Dev to UAT and to Production environments.
• Extensively involved in Managing Servers, Repositories, Connections, and assigning reports to Users, Importing/Exporting users.
• Experience in deployment of Business Objects from various database sources like Oracle, MS SQL Server, MS Access, DB2 UDB, Teradata and Sybase.
• Design and development for Workflows and Job in BODS (Business Object ETL Tool) Confidential development environment for root cause analysis.
• Having working experience on Crystal Reports2008 and Xcelsius2008.
• Extensively worked on Informatica7.1.1/8.5 (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer).
• Six sigma Green Belt certified.
• Aptitude for analyzing, testing, identifying problems and creating solutions, excellent time management skills, good team player with excellent communication skills.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Tableau Lead Consultant

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions in Tableau including working with calculations, parameters, and date functions.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Created and modified Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Published the developed dashboard, reports on the Tableau Server for end user consumption.
• Created Test Cases and documented the Test Results and shared with project team.
• Involved in validating Tableau reports, Dashboard by writing SQL against databases.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Environment: Tableau 2019/2018/10. x, Python, Hadoop IBM Big Insights, Horton works distribution platform, Hive 1.6 Control-M, DataStage and UNIX Scripting.

Confidential, Milwaukee, WI

Tableau Lead Consultant

Responsibilities:

• Analyzing/Reviewing Functional document and designing Technical specifications for Tableau, BODS and BO.
• Done many analytic POCs for the clients to recommend best possible tools for different scenarios.
• Provided the support for developed reports as per given warranty.
• Direct report/Interaction with Client to understand their business impact during the job failed scenario.
• Creating Interface Detail Design document (i.e. RunBook, SOD, DataFlow Design, Functional Design, Workflow Design and important briefing document) for each interface based on the business requirement.
• Design and development for Workflows and Job in BODS (Business Object ETL Tool) Confidential development environment for root cause analysis.
• Creating test documents and performing the RCA in test (ODS) environment.
• Escalation and point of contact for Client for Migration activity.
• Understanding source systems and Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Finding Workarounds for the application front end that dynamically hides selected areas of the dashboard on Tableau depending upon user privileges.
• Helped client reporting teams migrate from traditional static Excel reporting to a more interactive and powerful Tableau dashboard solution.
• Analysed relational database model according to business requirements to create Tableau associative data model.
• Created dashboards utilizing Tableau functionality like sets, parameters, groups etc.,
• Extensively created dashboards with multiple worksheets, linear graphs, pie charts and crosstab.
• Research and troubleshoot technical problems and provided ongoing Tableau based application consultation to the development team.
• Worked on data validations and worked with peer for code review
• Provided demo of Tableau functionality for prospective Line of Business and actively involved in training end users on Tableau functionality.
• Extensively used data blending, embed functionalities in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server

Environment: Tableau9.x/ 10.x,SAP BI4.1 SP6, BODS, BFC7.5, SAP BI7.0, SAP GUI, SAP R/3, Teradata, SQL Server, Oracle, BW, Hadoop, HANA, IBM Tivoli TWS, IBM Zeke Scheduler, Service Now MS-Excel and Windows XP.

Confidential

Tableau Lead Consultant

Responsibilities:

• Working as Team Lead for 4 members Team.
• Sending the BO Daily Status to PM.
• Co-ordinating with onshore team to clarify the gaps for report development.
• Understanding and Analyses the Functional Specifications (FS) to deliver the report per given ETA.
• Working closely with ETL team to understanding the Database model and Tables.
• Responsible for fixing the issues in the universe created using Information Design Tool.
• Created Connections, Universes for Webi Reports Development.
• Created, Tested and implemented the review comments the Webi reports as per FS.
• Delivered the user required reports with given KPIs which helps the Business Analyst to do the better analysis.
• Maintained the Backup for Universes and Reports by creating LCMBIAR file and migrated to Testing Environment.
• Provided the support for developed reports as per given warranty.
• Analyzed relational database model according to business requirements to create Tableau associative data model.
• Created dashboards utilizing Tableau functionality like sets, parameters, groups etc.,
• Extensively created dashboards with multiple worksheets, linear graphs, pie charts and crosstab.
• Research and troubleshoot technical problems and provided ongoing Tableau based application consultation to the development team.
• Worked on data validations and worked with peer for code review
• Provided demo of Tableau functionality for prospective Line of Business and actively involved in training end users on Tableau functionality.
• Extensively used data blending, embed functionalities in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server

Environment: Tableau 8.x/9.x, Business Objects XI 4.0, Oracle, SQL Server, MS-Excel and Windows XP

Confidential, Dallas, TX

Sr Tableau Developer

Responsibilities:

• Understanding the Client Requirements.
• Prepared High Level Design Document for the Project.
• Prepared the Low Level Design Document for Tableau, Universe and Reports.
• Created the Unit Test Cases document.
• Created, tested the Tableau Dashboards, Universe and Reports with back end as SQLServer.
• Deployed the Universe and Reports using Import Wizard.
• Enhanced Existing Universe as per user requirements.
• Developed, tested and deployed the Web I Reports
• Published the developed dashboard, reports on the Tableau Server for end user consumption.
• Created Test Cases and documented the Test Results and shared with project team.
• Involved in validating Tableau reports, Dashboard by writing SQL against databases.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Created procedures to ensure the quality, usability and accuracy of reports.

Environment: Tableau 6.x/7.x,Business Objects XI3.1, MSBI (SSIS), SQLServer2005, TOAD9.5, Import Wizard, MS-Excel and Windows XP