SUMMARY:

• 10 years of experience in Business Intelligence with a focus on Developing Reporting Applications for all kinds of Enterprise Reporting solutions using Tableau Software products, Alteryx, Bigdata Hadoop (Hive Impala, Amazon Redshift, AWS, Cassandra) and SAP Business Objects.
• 5 years as a Tableau Developer/SME.
• 5 years in SAP Business Objects and Crystal Reports.
• Experience in working in Agile and Scrum methodologies for all kinds of Reports and visualization developments.
• Excellent in managing teams, coordinating with senior management and working closely with business leaders in soliciting business reporting requirements in various domains like Health Care, Banking/Finance, Logistics, Consumer goods/products.
• Strong Exposure to Enterprise Data Warehousing (EDW), Strong understanding of Data Modeling and very good at Complex Data Analysis, Facts & Dimensions and ETL processes.
• 5 years of Tableau experience with extensive knowledge as a Tableau Developer and Server Administrator with strong understanding of Tableau Architecture, providing the best practices for deployment and maintenance of Enterprise class dashboards on Tableau Server and Cloud.
• Extensively involved in design and development of Tableau visualization solutions using operational Design/Layouts, dashboards on various flavors of RDBMS like Oracle, Teradata, MS SQL Server and Big data (Cloudera, Impala), Datameer and Alteryx.
• Very good at implementing Tableau visualizations and dashboard design with best practices to facilitate in - depth analytics and decision making among business users.
• Worked on implementing POCs using Hadoop with Alteryx for Integration, Analysis and Visualization.
• Worked with users to build data extracts (data source files) to support Adhoc reporting needs and publish those to Tableau server.
• Worked on Action filters, LODs, table calculations, Analytical functions, hierarchies, dual-axis charts, filters (extract, data source, and context), and parameters.
• Excellent in data blending, data joining and cross data joins techniques.
• In-depth knowledge of Installation, configuration and setup of Tableau server, multi-threading of server processes, managing licenses, users & groups, server monitoring, Tableau command line utilities, migrations, schedules and extract refreshes.
• Worked closely with Windows Admins and BI data teams to evaluate the Hardware and Software requirements to implement Tableau Software at Enterprise level.
• Good understanding of Tableau online, Tableau server and other Tableau products.
• Extensive experience in complex Data Analysis of large data sources, studying relationships among data tables to understand the data flow of various Businesses - Key for Report writing.
• Very good at building custom SQL queries comprising of Aggregations, Hierarchies, and excellent in performance tuning.
• Played many key roles in various stages- Reports developing, Testing, resolving Production/data issues, Data modeling and complex Data analysis.
• Extensively involved in conducting knowledge transfer sessions and training users on accessing Tableau software/tools.
• Active team player and Individual with excellent communication, Interpersonal skills, self motivated, fast learner and good listener.
• Solid experience in various versions- BO 4.x, BOXI 3.x/R2/6.x and all BO components- Web Intelligence (WEBI), Universe Designer, BI Launch Pad, Xcelsius, Desktop Intelligence, Promotion Manager, Publishing Wizard.
• Excellent in BO reporting solutions using various flavors of RDBMS and SAP OLAP (BI/BW) databases.
• Extensively worked on Design and Developing Semantic Layer (BO Universes) with various functionalities like Aggregate navigation, row level and table level Securities, cascading LOV's.
• Huge experience in creating Web Intelligence (WebI) reports for adhoc reporting and publishing them to BusinessObjects Enterprise, migrating/upgrading the reports from BO 3.1 to BO 4.0
• Expertise in designing Complex Crystal Reports including Cross-tab, Conditional, Drill-down/summary, Top/Bottom N, multiple Subreports, Conditional formatting, Summaries and Complex formulae.
• Good at creating Dynamic Cascading prompts, Business Views, List of Values (LOV’s).
• Extensively worked in end-user requirements, business data requirements- studied, analyzed them.

TECHNICAL SKILLS:

Tableau Software: Tableau Server, Tableau Desktop versions 10.x/9.x/8.x/7.x, Tableau Reader and various tableau files like .twb, .twbx, .tde, .tds

Other Business Intelligence tools: BusinessObjects XI 4.1/4.0, 3.x/XI R2/6.x, CMC, CCM, Crystal Reports for Enterprise 4.0, 2008/XI R2, Universe Designer, Web Intelligence, BI LaunchPad (InfoView), Information Design Tool (IDT), Universe Designer, Business Analytics, Live Office, SAP BO Explorer, Design Studio, Analysis for Office/OLAP, Informatica, Dimensional data modelling (Star and Snow flake schemas)

Databases & tools: SAP BI 7.x, Teradata, Oracle 10g/8i, SQL Server 2008/2005/2000 , Netezza, DB2, MS Access, SQL*Plus, SQL* Loader, Oracle Developer, SQL Developer, Erwin, HP Quality Center.

Programming & Scripting: SQL, PL/SQL, C, C++, Java Script (basic), MS Office Suite.

Operating Systems: Unix (Linux), Windows XP/2003/2000/NT/2003 Server

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Tableau Lead Developer/Admin

Responsibilities:

• Lead Tableau developer and key member of Tableau COE team at Confidential .
• Worked with multiple Business units and Executive stakeholders in reviewing business requirements for design, development, testing and production rollover of Tableau reporting solutions using Tableau Desktop and Tableau Server.
• Developed and managed daily, weekly and monthly Tableau dashboards with functionalities like drill down, parameters, sets, action filters, dual axis charts and table calculations that provide real-time snapshots with improved granularity of core operational business metrics.
• Did few POCs on Tableau with Bigdata Hadoop Impala database, Hortonworks Hive to generate few critical visualizations and published to Tableau Cloud
• Connected to Tableau PostgreSQL to create Usage statistics reports.
• Implemented Level of Details (LODs), cross table joins and storytelling.
• Developed few performance dashboards with complex requirements involving conditional formatting, Java API, real-time maps, allowing global users to visualize and analyze their key metrics/KPIs, MTD, QTD and YTD calculations
• Heavily used action filters in summary-detail dashboards to facilitate the navigation between dashboards.
• Mentored business users to effectively make use of Tableau Desktop by providing the best practices related to data profiling, data blending, Tableau extracts and other Tableau files (.twb, .twbx, .tds, .tde etc)
• Set up extract refreshes, schedules and dashboards subscriptions for few dashboards based on requirements.
• Involved in initial setup of Tableau Server environment, worked with windows engineers for hardware scaling of 2-node and 3-node cluster environment.
• Performed admin activities like daily server monitoring, resolving tickets, weekly backups, version upgrades and managing security.
• Worked closely with Tableau Elite support to deal with any unknown technical issues in report development.

Environment: Tableau Desktop and Server (9.x, 10.x), Oracle, Teradata, SQL Server 2012, Management Studio, Toad, Windows OS.

Confidential, Fort Worth, TX

Tableau Lead

Responsibilities:

• Analyze and understand the existing Reporting system, legacy Excel dashboards and critical backend objects to setup the base tables and views exclusively for Tableau visualizations.
• Involve in requirement gathering and interface directly with stake holders and business teams in coordinating the reporting needs.
• Implemented pilots, POC’s and given demos to Dept. heads and executives to explain the capabilities and functionality of Tableau tool.
• Lead and drive the Reporting team to develop 4 major Tableau visualizations, around 15 tabs in each dashboard, which accommodates various KPIs and metrics related to Inventory, Demand, Sales and Manufacturing departments.
• Developed dashboards with data being fed from multiple sources like JD Edwards and many other front end legacy systems.
• Dashboards included various components and functionalities involving dual axis, combo graphs/charts, complex conditional formatting, trend lines, parameters, filters (extract, context and quick filters) using Tableau desktop.
• Worked heavily on table calculations and Tableau window functions for KPI’s involving in % variances, YTD, QTD and MTD values.
• Work with ETL team to setup aggregate tables, data mappings and critical backend objects/views
• Setup Tableau Schedules and assign dashboards to schedules based on users/group security.
• Conduct training sessions to explain the abilities and capabilities of Tableau tool and introduce all the new features to the team.
• Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting.

Environment: Tableau Desktop and Server 9.0/8.x, SQL Server 2012, Management Studio, JD Edwards Windows OS.

Confidential, Richardson, TX

Tableau Developer/SME

Responsibilities:

• Involved in coordination with Confidential senior management along with other DB and BI Architects in setting up the Tableau platform to accommodate business reporting needs.
• In charge for all kinds of Reporting solutions using Tableau and SAP Business Objects, Crystal Reports.
• Involved in conversion of many legacy reports to Tableau visualizations which involved extensive data blending, filter actions, parameters and embedded hyperlinks.
• Developed visualizations for summary and detailed data with respect to monthly breakups involving Sets, Groups on multiple KPIs (targets, deliverables etc)
• Excellent in optimizing dashboards, performed Data validation and testing of visualizations with backend data prior to deployment.
• Responsible for the complete hardware setup of Tableau servers, Admin Portal, security checks, scheduled refreshes and License Management for over 2000 users.
• Deployed Tableau Server in clustered environment comprising of a Primary and two worker servers.
• Involved in overall coordination regarding Installation, configuration and setup of Tableau environment at the client location.
• Performed daily maintenance activities, performance tuning, dashboard deployments and extensively used Tabadmin commands in creating and restoring backups.
• As a Lead developer, involved in heavy interaction with business users in the process of discussing the overall Reporting requirements.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Conducted user training sessions and provided 24/7 production support for Tableau users.

Environment: Tableau Desktop/Server 8.1, Oracle 10g, SAP Business Objects 4.1, Crystal Reports, SQL Server 2008, Windows.

Confidential, Oklahoma City, OK

Tableau Lead/BI consultant

Responsibilities:

• Involved in heavy interaction with business users in the process of discussing the overall Reporting requirements.
• Analyze user requirements and translated them into front end Tableau visualizations and reporting solutions.
• Developed workbooks (with over 12 worksheets) with various parameters, calculated fields, hierarchies, drill-down abilities and deployed them on server.
• Used functionalities like groups, sets, Actions (hyperlinks), context filters wherever required.
• Managed and maintained Tableau Server, Desktop, users and user groups.
• Responsible for Tableau Infrastructure including Server Security, Troubleshooting and overall system maintenance.
• Scheduling and maintaining the workbooks to synchronize dynamically with run time data.
• One of the main modules of the project is to convert/migrate many legacy and BEx reports into BO 4.1 tools which included Analysis for Office, WebI Adhoc and Design Studio
• Interacted closely with Functional team and Confidential Business users to discuss the optimum strategies for reports delivery using various advanced SAP tools.
• Worked a lot on IDT to create BICS connections on top of BEx queries, which would act as the sources for most of the WebI and Analysis reports.
• Involved in building 2 P&L dashboards using Xcelsius and Live Office connectivity.
• Involved in developing Pilots for SAP BO Explorer, Design Studio and Analysis tools and given presentations to explain the abilities and capabilities of these powerful tools on BW and HANA backend.
• Responsible for Onsite-Offshore coordination and status tracking of the deliverables.

Environment: Tableau 8.0/8.1, BusinessObjects 4.1, SAP BI 7.3/7.1, SQL Server, BI LaunchPad, IDT, Dashboard Designer, Query Designer, Crystal Reports for Enterprise 4.0, Promotion Manager, Web Intelligence, Design Studio, Analysis for OLAP/Office

Confidential, Plano, TX

Tableau Administrator/SAP BI Consultant

Responsibilities:

• Involved in high level discussions with business users, BI technical team to understand the requirements needed to setup Tableau Server Infrastructure at client location.
• Responsible for the successful implementation of Tableau 8.0, software installation, configuration, security setup, users and user groups, permissions and server logons.
• Worked on Tableau Demo sessions, presentations, Pilot releases of Dashboards and workbooks.
• Involved in migration of few legacy reports to Tableau workbooks with improved functionalities in terms of input parameters, Dynamic data synchronization at run time.
• Conducted Presentations and Knowledge Transfer sessions on Tableau Desktop tools.
• Designed and developed a Universe with huge chunks of Sales data of various brands to support 25 Web Intelligence reports including hyperlinks, multiple tabs and aggregation at various levels
• Created mockup reports with sample data as per the users reporting needs.
• Developed universes (.unx) to support almost 20 WebI reports with multiple data providers
• Created BICS connections in IDT and publish them to repository to support most of the WebI reports with BI 7.3 as the backend
• Developed complex Crystal and WebI reports using BICS connections on top of Bex queries.
• Involved in creating new Bex queries and modifying the existing if necessary.
• Coordinate with the report users on periodic basis about the scheduled reports for data validation
• Used Promotion Manager (Import Wizard earlier) to migrate the reports from Dev box to Quality.
• Involved in production support of many existing WebI scheduled reports
• Trained users in accessing and executing the reports

Environment: Tableau 8.0, BusinessObjects 4.0, SAP BI 7.3/7.1, Teradata, BI LaunchPad (InfoView), IDT, Crystal Reports for Enterprise 4.0, Promotion Manager, Web Intelligence, Windows

Confidential, La Palma, CA

Tableau/BO Developer

Responsibilities:

• Responsible for Tableau Server Configuration, Administration, Maintenance of entire Tableau Services.
• Designed and developed Tableau Visualizations based on their existing legacy reporting applications
• Involved in development of interactive Dashboards with Dynamic visibility, enhanced Calculations, Maps to improve insight for better Analysis.
• Reports involved Data from wide variety of data sources and further extended through data blending from external sources.
• Extensive training and Knowledge Transfer sessions on Tableau Desktop tools which involved Executing and Scheduling the Workbooks.
• Lead an offshore team of 4, assign tasks on bi-weekly basis and review their work regularly.
• Designed and developed Tableau Workbooks and Dashboards with various Data source connectivity.
• Involved in migration of Universes and Reports to BI 4.0 from BO XI 3.1 (R3)
• Developed new Universes using Information design tool (IDT) and created new reports in BI 4.0
• Designed and Developed 2 major universes with over 40 tables by defining necessary Joins, Cardinalities and apply Contexts/Alias to maintain the overall integrity of the Universes
• Created derived tables wherever necessary and used Aggregate navigation for aggregate level calculations like Yearly, Quarterly, Monthly figures
• Extensively involved in fine tuning of SQL queries to validate the backend data with reports data
• Created and maintained BO Universes from BW queries and InfoCubes.
• Generated Hyperlinks in WebI reports and sub reports in crystal reports.
• Involved in End User Training, Coordinated the migration strategy to move the developed objects across the landscape.

Environment: Tableau 7.0, BusinessObjects 4.0, BOXI R3.1, Teradata 12, BI LaunchPad (InfoView), Universe Designer, IDT, Web Intelligence, Xcelsius 2008 SP3, Live Office, Crystal Reports for Enterprise 4.0, Crystal Reports 2008, Unix and Windows

Confidential, Denver, CO

SAP BO/Dashboard Designer

Responsibilities:

• Created WebI on top of universes with Bex queries. Bex is the main source for majority of the BO universes.
• Created complex WebI which involved multiple data providers, multiple levels of hierarchy of various dimension objects.
• Designed around 30 Crystal Reports with complex formulae, parameters, sub-reports involved.
• Involved in very recent migration from BOXI 3.1 to BO 4.0 - Supported in issues related to Universes and reports during migration.
• Modified existing reports and designed new parameterized reports based on the mockups.
• Involved in performance tuning of Reports and Universes by making necessary changes to Bex queries whenever needed.
• Created predefined conditions, prompts at Universe level to improve the efficiency of reports.
• Extensively used merged dimensions in WebI reports to extract data from more than one universe.
• Validate the report data with respect to SAP data and perform unit testing on all the reports built.
• Assisted in developing Xcelsius dashboards to display the high level data of various departments of Confidential . Modified few already existing Crystal reports as per requirement changes.
• Involved in training the end users on accessing/handling web portal InfoView to execute the reports based on selection parameters
• Maintain regular interaction with BW developers for better understanding of Business

Environment: Oracle 10g, SAP BODI/BODS 4.0, BO 4.0, BO XI R3.1, SAP BI 7.1, Launch Pad (InfoView), Universe Designer, Web Intelligence, Xcelsius 2008 SP3, Live Office, Crystal Reports.

Confidential, PA

SAP BO Consultant

Responsibilities:

• Designed and Developed 2 universes by defining necessary Joins, Cardinalities and apply Contexts/Alias to maintain the overall integrity of the Universes
• Created Classes and universe Objects as per the Business standards - defined additional measure objects wherever require.
• Designed a universe from BEX query (source data) in the process of creating few WebI reports
• Developed 4 interactive Xcelsius Dashboards with multiple selector components and Bar/Pie charts for MTD, QTD and YTD data comparison
• Used Live Office to import necessary WebI and Crystal reports which were the source of data for Xcelsius Dashboards
• Created many WebI reports of high complexity which involved multiple data providers, Report level and Block level drill filters, Alerts for conditional output
• Converted few existing WebI reports to Crystal reports to overcome the limitations of output data rows in WebI.
• Trained end users in running parameterized reports and accessing InfoView.

Environment: Tableau 6.0, Business Objects XI R3.1, Oracle, SAP BI 7.0, Universe Designer, Web Intelligence, Xcelsius, Live Office, Crystal Reports 2008, SQL Assistant, Informatica ETL, Windows

Confidential, Chicago, IL

BO/Crystal Reports Developer

Responsibilities:

• Interacted with Business Team in gathering their business requirements to prepare high- level User/System manual.
• Involved in conversion of high-level specifications to detailed documentation for building Universe with all necessary data elements, mockup templates and design specifications.
• Assisted project lead in managing a BO reporting team in course of Report designing.
• Designed universes for standard canned, ad hoc reports based on reporting requirements.
• Assisted in developing 2 Xcelsius dashboards with various visualizations and components.
• Built dashboards with drilldown capabilities, Dynamic Visibility and various visualizations using menu components, Gauges, Sliders.
• Involved in troubleshooting, optimizing, and fine-tuning the SQL queries and debugging for efficiency.