SUMMARY

• 10+ years of experience in IT industry as BI Developer with Tableau and Business Objects with strong background in Databases and Data warehousing concepts.
• Expertise in Tableau 10.2/10.1/9.3/9.2/9.1/8.0, Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud
• Worked on different Tableau versions (Tableau10.2/10.1/ 9.3/9.2/9.1/8.0/7.0)
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices
• Experience in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Working with the team on creating ETL packages related to Data warehouse andAzure DWH maintenance.
• Worked onAzurecloud database servers and ADLS for ETL use.
• Hands on experience with designing and developing Solutions onAzurewith transformation of Data into Intelligent action.
• Also has noledge on External and Internal tables along withAzurerun books for job scheduling.
• Setup and configuration of Tableau server 10.1/9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Experience in importing, transforming and analyzing data and creating visualizations and reports using R andPython.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Worked on creating interactive, real - time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Setup trusted autanticationinTableau serverand pass requests fromWeb server
• Worked heavily usingTabadmin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Currently working on Proof of Concepts (POC) presentation and review with project and IT lead along with developingTableauDashboards.
• Adjust views/dashboards after initialPOCpresentation.
• Generatedassetreports and data analysis formanagementreview.
• Providedassetdata error reports to staff to investigate and perform corrections withinasset managementdatabase.
• Designed and setup user securityfor the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrationsfrom one environment to another.
• Setup of Distributed Server environmentsfor optimum load balancing.
• Used efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Createdautomated scripts for tableau workbook refreshwhen not using live connections
• Experience withTableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Interpretingdata, analyzing results using statistical techniques and providing ongoing reports.
• Experience in detailed document and report preparation, complex internal and externaldataanalysisresponsibilities.
• Experienced in managing schedules and scheduling workbooks and activities on Tableau Server
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
• Data blending, data preparation usingAlteryxand SQL for tableau consumption, publishing data sources to Tableau server.
• AlteryxData blending with multiple data sources, Tableau data objects using SQL queries. Dashboards using interactive parameters, filters, sets, charts and table calculations.
• ConductingPOCfortableauserver setup for non-existingtableauapplications.
• Analyzing web traffic and creating google analytic dashboards to visualize the web traffic interactively.
• Setup of SSO between Tableau portal and Oracle.
• FollowedAWSbest practices to convert data types from oracle toredshift.
• Involved in runningHadoopjobs for processing millions of records of text data.
• Installed and setup cluster environment for Tableau server and used Jmeter for load balancing and load analysis
• Using the command line tools and configuration utility on the primary server pushed the updates to the workers.
• Used Kerberos for user autantication thru Active directory (Win AD).
• Performance tuning for the Tableau Visualizations and Tableau server for more TEMPthan 250 concurrent users.
• Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.
• Assigning various extract schedules and using blending techniques to optimize the performance of Tableau.
• Capable of creating reports, designing Universes, Full Client/ Webi reports, Crystal reports etc.
• Documenting reports requirement and details obtained from business users in order to design, develop and maintain Business Objects, Web Intelligence and Crystal reports.
• Excellent communication and interpersonal skill, decision making skills, presentation skills along with management and ability to interact with end-users, managers and technical personnel.
• Experience on new Business Objects 4.1 client tools like Dashboard Design, BI Launch Pad, and Crystal Reports Enterprise etc.
• Used Analysis OLAP to create reports on top of HANA views.
• Worked on Lumira to connect to the HANA views for visualization of KPI data.
• Worked on Lumira datasets on the CMC to connect Lumira to the HANA views.
• Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications.
• Experienced in writing queries, stored procedures and functions using SQL.
• Identifying Business Data and requirement and modifying it to logical data models.
• Knowledge in creating Crystal Reports using crystal reports formulas, Grouping, Parameters, selection criteria to handle the customer’s requests from Tables, Views and command objects.
• Quick Learner with excellent analytical and problem solving skills with positive attitude towards new challenges

TECHNICAL SKILLS

Tableau: 10.2/10.2/9.3/9.2/9.1/8.0, Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader, SSRS, SSAS, Microstrategy, Qlickview.

SAP: BI, BW, SAP BOBJ 4.0/3.1

Operating Systems: Windows, UNIX and LINUX.

Databases: Oracle 9i/ 8i/7.3, MS SQL Server, T-SQL, SAP HANA, Access, DB2, Teradata, Redshift, Netezza, Mongo.

Methodologies: Kimball, Agile, Iterative and Waterfall.

Data Modeling Tools: Power Designer, R studio, MS Visio.

Document Management: TFS, Documentum, Visual Source Safe, Share point, Ultra edit.

Programming Languages: C, C++, Visual Basic, SQL, Python, Oracle PL/SQL, UNIX shell scripting, Java, Pyspark, JSP, HTML.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI/Tableau Consultant

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Setup and configuration of Tableau server 10.2/9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Hands-on and extensive working experience on Business Intelligence IT solutionETLprocesses.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Integrated theTableauReports in theJavaapplications usingTableauAPI.
• Used JavaScript API to integrate Tableau workbooks and dashboards with web applications.
• Handled user licenses for projects.
• Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion
• Importing tables using Warehouse catalog and Creating Logical Tables
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables, views, procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Created dashboards for analyzing POS data usingTableau10.2 on top ofSAPHANA.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Setup trusted autanticationinTableau serverand pass requests fromWeb server.
• Worked heavily usingTabadmin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Designed and setup user securityfor the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrationsfrom one environment to another.
• Setup of Distributed Server environmentsfor optimum load balancing.
• Got involved in the discussions to convertSAPBW queries toHANAViews and developtableau dashboards using them.
• Involved in production support for the implementedFinancialAnalytics application.
• Lead for theFinancialAnalytics and the custom Gift Card Module Implementation.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections and settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 10.2/9.3 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Developed, designed dynamic and browser compatible user interfaces using JSP,HTML and JavaScript.
• Scripted inPythonto generate reports, provide data to other teams, update data in the Elastic Search database, and interact with third-party services' APIs.
• UsedPythonto predict how the markets will behave in the future and visualized it inTableau.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.
• Managed the migration of fixed income data mart from oracle to Teradata.
• Plan and implement the overall analytics and business intelligence strategy.
• Provided support to consultants, Technical Support engineers in creating and troubleshooting Micro strategy SDK customizations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
• Worked on CMC to create the User-groups and worked on the security rights
• Worked on life-cycle manager for business objects Xi R3.1. Promotion Management for 4.1
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports.

Confidential, BOSTON, MA

Tableau Consultant

Responsibilities:

• Designed, developed and tested variousTableauvisualizations for dashboard and ad-hoc reporting solutions.
• Worked closely with data architects to improve data's performance by reducing the number of calculated fields and thus optimizing performance.
• Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
• Managing timely and accurate delivery of information to various cross-functional teams.
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across it and various data sources.
• Designed interactive dashboards with drill down capability, roll back capability, customizations by using both live and in-memory data connections.
• Monitored user activity and maintained security profiles.
• Published workbooks and dashboard to different environments me.e. testing and production and used Tab CMD for dashboard migrations.
• Worked on evaluation and analysis of Hadoop cluster and different big data analytic tools including Hive, Hbase database and Sqoop.
• ConnectedTableaudirectly to Horton works Data Platform through Hive interface so that business users can quickly find insight with Hadoop deployment.
• Exported the analyzed data to the relational databases using Sqoop for visualization and to generate reports for the BI team.
• Used filters, parameters, sets, groups, hierarchies (Customer and default), calculated fields and table calculations to create interactive, user friendly and creative dashboards.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
• Worked extensively with background imaging, custom geo-coding to plot KPIs on the dashboard.
• Updated various documents like design document, business requirement document and technical specifications document.
• Setup and configuring ofTableauserver in various environments by using Tab CMD and Admin tools.
• Upgraded server from 9.2 to 9.3.
• Used Tab CMD tools to authorize different users and assigning user permissions me.e. assigning row and column level security at application, folder and user level.
• Worked with various team including Business Analysts, ETL, Data Warehousing, and testing for smooth flow/transition of development life cycle.
• Importing tables using Warehouse catalog and Creating Logical Tables and views.
• Involved as a technical expert providing input to application design regarding performance tuning and administration requirements.
• Worked on Agile methodology, and involved in scrum meetings to give inputs as technical expert to application design for performance tuning and admin requirements.
• Created and tested various stored procedures, views, and triggers during data preparation stages. And suggested best practices for process improvements.
• Provided Just-In-Time training for various end users on usingTableauand exploring various functionalities of the dashboard.
• Monitoring schedules and extracts and debugging issues with data extracts if any.
• Excellent SQL skills for daily testing of data using various SQL queries.
• Designed and setup user security for the entire landscape to facilitate Windows AD login.
• Setup of Distributed Server environments for optimum load balancing.

Tableau Developer

Responsibilities:

• Upgraded tableau 7.0 to tableau 8.0. And gathered requirements, analyzed from raw data.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Providedfixedincomefinancial solutions to financial advisors.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
• Created mockup dashboards and presented to the higher-level end users to has them a look and feel of the dashboards.
• Develop and maintain reporting and analytical tools, including Business Objects.
• Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental.
• Lead BI work stream projects in the implementation and use of new BI software tools and systems.
• Got involved in designing the Data model for the Data warehouse and for different Data marts.
• Performed End to end testing using SQL Queries in Oracle.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-uses.
• Work experience in advanced Xcelsius concepts like, wat if analysis, dynamic visibility, narratives, interactive charts, hierarchies and experience in connecting Xcelsius/ QaaWS, live office.
• Work with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations

Confidential, Washington, DC

SAP BI Consultant

Responsibilities:

• Assisted business analysts with requirements gathering and in design and development of ETL processes.
• Attendant in work stream planning process including inception, technical design, development, test and delivery of BI solutions.
• Check internal and external customer’s need and abilities in order to provide appropriate solutions.
• Deployed patches and updates from SAP as required
• Design the dashboard application with multiple dashboards as required as per the security requirements.
• Developed Life Cycle (SDLC) efforts required in order to deliver on EIM-related projects and deliverables and used these estimates to assign completion date and milestones for EIM-related deliverables, tasks, etc.
• Developed the web-intelligence reports, provided a supporting role in building the universes
• Ensured solutions meet the expectations of end users and train users
• Interface with senior management, IT managers, business users and the development team
• Made sure proper clean-up and general maintenance of application boxes is scheduled and carried out
• Maintain the health of the SAP Business Objects system and Scheduler
• Manage analyses of functional business processes and requirement and participates in the development of business cases.
• Perform analysis for a wide range of requests using data in different formats and form various platforms.

Confidential, NJ

SAP BI/BO Consultant

Responsibilities:

• Used Report level joins and unions in some of the reports, created prompts and calculations in RS and FM model.
• Validated the schema and found the errors present in the ETL and also took part in giving the recommendations to fix the problem.
• Modified existing Universes to meet user reporting requirements.
• Interacted with Business Objects technical team to solve the bugs involved in Business Objects.
• Met with the Business Analyst, Users and Businessleads to understand their needs. Modified universes and created reports for them accordingly.
• Experience with Data Extraction and transforming data from using Data Integrator.
• Provided technical leadership for Business Intelligence (BI) roadmap and the direction of application projects from data capture through application design & implementation.
• Implemented the best practices for Business Objects Environment.
• Defined Business Views and Business components with data connections