SUMMARY:

• Over 8.5 years of experience in Software Design, Database Design, Development, Testing, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensively worked on Tableau 7.x/8.x/9.x/10.x (Desktop, Server, Reader, Mobile, and Public), SAP Business Objects3.x/4.x and XCelsius Dashboards.
• Involved in requirements gathering/analysis, Design, Development, Testing and SIT of reporting and Analysis Projects.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau Dashboards.
• Extensive Tableau experience in Enterprise environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience on building dashboards using Tableau.
• Extensive experience in Tableau Administration Tool for Installation, Configuration, Patching, upgrading Tableau software.
• Extensive experience in Tableau Administration Tool for Creating Sites, adding users, Groups, Projects and managing data security by using TABCMD command through command mode and GUI mode and data connections, scheduling tasks.
• Deploying and scheduling Reports to generate all daily, weekly, monthly and quarterly Reports including current status. Established Best Practices for Enterprise Tableau Environment and application and development processes.
• Extensive experience in taking server backup and Site backup.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex requirement, User-defined Functions, Views.
• Proficient in designing Data Model using Erwin Star and Snowflake Schemas.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Donut Chart, Map Charts, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization, Spot Lighting and Multi Conditional Score Card other making use of actions, other different filters and Parameters according to the end user requirement.
• 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.
• Experience in creating varies dashboards like Master Detail Dashboards, Multi Master Details Dashboards, Hiding Dashboards; Sheet selected Dashboards, Index Dashboards, Toggle or popping Dashboards.
• Extensive experience in Alteryx to improve Tableau performance.
• Implemented Row Level Security and providing options.
• Conducted Gap Analysis, created Use Cases, work-flows, screen-shots and PowerPoint presentations for the Web Applications.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Experience in writing complex SQL scripts/queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Proficient in working on SQL in Oracle 8i/9i/10g/11, SQL Server(MS Sequel Server) 2005/2008, DB2,Teradata 13 databases, Vertica, Hive, AWS and SAP HANA,BW/BI.
• Extensive knowledge of all phases of the Agile Scrum Frame work & Waterfall methodologies.
• Deployed the reports and Scheduled Reports for the use of end users.
• Good knowledge on Qlikview.

TECHNICAL SKILLS:

Reporting Tools: Tableau 7/8,8.1,8.3, 9.0, 10.1,10.2,10.3Tableau Desktop and Tableau Server(Tableau Administrator), Business Objects XI 3.1/XI R2/6.5, UDT,IDT, BI Launch pad, Desktop Intelligence, Web Rich Client, Web Intelligence, Import Wizard, Xcelsius, Dashboard Designer, CMC, Qlikview 12, SSRS

ETL: MSBI,Informatica9/8/7.1

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2008/2012, Teradata12, Netezza

Languages: SQL and PL/SQL

Tools: TOAD and SQL Developer, HPSM, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Princeton, NJ

Sr. BI Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Created detailed Functional Specifications Documents, including data samples, use cases, key project assumptions, report samples, data flows and data models
• Leveraged Tableau built in graphical capabilities to create Bar-charts, Tree-maps, Geo-maps, and Area-charts.
• Used Tableau to create visual interactive dashboards, workbooks and stories for better decision making.
• Created Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI).
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Used Sets, Bins, Parameters, Aggregate Functions, Filters, Action in Tableau. Used Tableau Desktop to analyze and obtain insights into large data sets.
• Publishing the Worksheets, Dashboards and Stories on Tableau server to share it with multiple BU's.
• Created visually compelling, actionable interactive worksheets and dashboards for the clients to analyze various KPIs.
• Prepared migration and resource utilization plan and matrices to migrate Reports build in SSRS to Tableau.
• Build several proofs of concepts dashboards in Tableau to lay framework of analytics.
• Developed Tableau reports including highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps.
• Review the reports developed by peers and guide them whenever required and basically point of contact for reporting module.
• Conducting Performance tuning, applying user and row level securities.

Environment: Tableau 10.3, SSRS, SSIS, SQL Server, SQL Developer, Jira.

Confidential, IL

Tableau Analyst

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Designed and published customized interactive dashboards.
• Used filters, parameters, sets, groups, BIN etc.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual-Axis, Box-Plots, Bullet-Graphs, Tree-maps, Bubble-Charts, Pie-Chart, Gantt-Chart, Histograms, Waterfall charts, Funnel charts etc to assist business users in solving complex problems.
• Good experience in administration, configuration, and maintenance upgrade setting up Tableau Server.
• Extensively created very interactive dashboards like Drill Dashboards, Master detailed Dashboards; Multi Master detailed Dashboards, Hiding Dashboard, Sheet Selector Dashboards, and Index Dashboards.
• Found efficient ways to maintain the accuracy of the core information content that is being communicated, while at the same time presenting graphs and tables visually, and aesthetically.
• Extensive experience in taking server backup and Site backup by using TABADMIN
• Created interactive dashboards by combining views in Tableau Desktop that was presented to Business Users, Engagement Managers, and End Users.
• Utilized Tableau visual analytics and best practices like performance improvement, Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and of complex dashboards/reports.
• Developed Cross Tab, Chart, Line, and Drill down through worksheets in Tableau.
• Created Complicated Calculation Based LOD (Level of detail) feature.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Worked extensively with Advance analysis, Sets to create detail level summary worksheets and dashboards using KPI's.
• Implemented Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, hierarchies.
• Generated dashboards using dual axis and blended axis for comparison.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.

Environment: Tableau 10.0, 10.2, Oracle, Jira, Service Now, MS Share point

Confidential, Cincinnati, OH

Tableau Lead

Responsibilities:

• Worked on full life-cycle projects from gathering Requirements to publishing it to Production.
• Involved in creating D ashboards, Storyboards and Visualization in Tableau. Created Report schedules on Tableau server.
• Created out of the box Dashboards which includes extensive use of Actions and filters
• Created Parameters, Actions etc. for detail visualization to meet end user needs.
• Created Executive level KPI dashboards with interactive visualizations
• Extensively worked with Best practices in tableau for best performances of the dashboards when it comes to huge data set like creating extracts, Data blending uploading the data source to server for better performances.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Trained Business users for usage of dashboards and tableau tool for their basic needs.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree-maps, Bubble-Charts, Pie-Chart, Gantt-Chart, Histograms, Waterfall charts, Donut-graph etc to assist business users in solving complex problems.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Huge Experience in with SQL Server and Vertical Databases.
• Good Experience in Data Modeling and Data analytics.
• Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Extensively used Date based calculations for the entire project. Specially YOY and MOM Calculations.
• Huge Experience in converting sales force and BO reports in to rich Tableau Dashboards.
• Experience in creating dashboards using Tableau.
• Worked on Developing Website (Portal) for Board Members which include embedding tableau dashboards in the website which takes tableau to a whole new level.
• Provided effective Tableau Solutions for creating dashboards for various devices like Desktop, Laptop, I pad, Mini I Pad, Mobile phones (I phone, Samsung galaxy).

Environment: Tableau 9.0,Oracle, HPSM, Control-M,SAP HANA, Jira, MS Share point, Windows 2008/Windows 7

Confidential, Dallas

BI Tableau Consultant

Responsibilities:

• Met with the Business Users, Analyst and project owners to gather the requirements and document the reporting development work to meet business objectives. Understanding functional requirement specifications and create detail level documentation
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Created Dashboards with combination of charts, graphs, filters and more to help Users to analyze and understand the data and by navigating through the reports for detail analysis.
• With help of tableau server and a supported browser and controlled users interactions and combine functionality.
• Coded single control that filters a group of marks, selects some of those marks, and presents their data for download.
• Created Parameters, Actions etc. for detail visualization to meet end user needs.
• Created Executive level KPI dashboards with interactive visualizations
• Resolved loops by creating contexts for each fact table and also by adding aliases.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Mentored business users to create reports/dashboards using tableau desktop.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.
• Good experience in administration, configuration, and maintenance upgrade setting up Tableau Server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt Chart, Histograms, Water Fall charts, funnel charts etc to assist business users in solving complex problems.
• Huge Experience in OLAP, OLTP.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Conducted Training sessions for Tableau users and created the documents for end-user support.
• Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.

Environment: Tableau 7/8, Oracle, Teradata, MS Share point, Windows 2008/Windows 7.

Confidential, Dallas, Texas

Tableau Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Develop canned / Ad-Hoc reports and complex dashboards in Tableau
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards with forecast and reference lines.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Generated Tableau dashboards with combination charts for clear understanding.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards using dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.

Environment: Tableau 7.0, Windows 2008, SQL server 2008/2012, SSRS, SSIS, SSAS.

Confidential, Cincinnati, OH

SAP Business Objects Developer

Responsibilities:

• Worked closely with Business Analyst, Business Users and Managers for gathering, analyzing, documenting Business Requirements, Functional Requirements and technical Specifications for Business Objects universes and reports
• Prepared the (BRS) Business requirement specifications and functional requirement documents (FRD)
• Worked on planning, designing, developing, distributing and maintaining Universes with relational databases (IBM DB2) as the data sources
• Used BO Universe Designer for semantic layer, Business Objects Info View, Web I for reporting
• Designed the universes on top of IBM DB2 databases from scratch and exported them to the repository
• Designed, developed and maintained universes for supporting ad-hoc and canned reports
• Defined cardinalities, created joins, performed check integrity, resolved loops by creating aliases and contexts to remove the cyclic dependencies
• Created cascading List of Values (LOVs) for better understanding of prompts by the end users
• Created complex reports using cascading prompts to restrict data fetch and ease data load
• Created filter objects, formatted objects and measures within the universe for faster report generation
• Created different types of reports, like Tabular, Master/Detail, cross Tab using multiple queries
• Used filters, conditions, Prompts, Drill Down, Functions, etc.,
• Extensively used breaks for white spaces and sections for better navigation
• Created Web I Reports using Drill down functionality creating custom hierarchies
• Created detail and summary reports to fold/Unfold sections corresponding to breaks in current blocks
• Extensively used Web Intelligence Info view for querying, reporting and analysis tasks
• Created reports like Quarterly reports, Demographic reports and Metric exception Reports
• Created complex Web I reports by linking objects from different data providers and using Merge Dimension Option
• Created Web I Reports using Drill down functionality within different hierarchies
• Worked extensively with the Performance Management tool involving the creation of dashboards
• Gained experience in loading data into Oracle from an existing data source, modeling the data in Information Design Tool to facilitate data analysis and using Business Intelligence Tool
• Worked on POC (Proof of Concept) system which lead to clear understanding of requirements, assess design decisions early in process and reduces overall risk of projects failure.
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes
• Migrated the universes from DEV to Acceptance and PROD Environments
• Trained the users on the Ad Hoc reporting and on navigating the Business Objects tool
• Gained knowledge about Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.

Environment: Business Objects Enterprise XI 3.1& SAP BO 4.0, Designer, Web I, Info View, BI Launch Pad, Dashboards Designer, Import Wizard, Information Design Tool, Business Objects Data Services XI 3.1, IBM DB2 V8, Windows XP/2003

Confidential

SAP Business objects/Xcelsius Dashboard Developer

Responsibilities:

• Performed system study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Demonstrated various samples of reports before sign off -obtaining from the users.
• Created Desk I reports with conditions and prompts.
• Created web I reports with report level prompts and critical functions.
• Conducted meetings with management and user community to understand the business requirements and convert them into technical specifications.
• Created different types of reports, such as, Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, Formulas, calculations.
• Tested the universes periodically by running Check Integrity Tool.
• Created several Classes, Objects, Conditions, and Measure objects.
• Used Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down).
• Extensively used linked and unlinked Sub Reports.
• Created Static and Dynamic Parameters in the Reports.
• Created Dashboards using Xcelsius and Live Office
• Extensively involved in writing SQL Queries and testing the data
• Created reports like Reports by Period, Demographic reports and Comparative Reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Trained the user community in making use of universe to create and publish reports.

Environment: SAP Business objects R3, Xcelsius, TOAD, Oracle 9i, SQL and Windows 2003.

Confidential

BO Developer/Data warehouse Developer

Responsibilities:

• Understand the technical requirements, developed simple reports to satisfy the user requirements
• Worked on Desk and Web reports in BO 3.1
• Worked on Universe Designer and designed simple Universe by defining Joins, resolving loops and cardinalities
• Resolved Loops in Universe by creating Aliases, Contexts.
• Export the universe into the repository. Initiated migrating universe and reports between environments.
• Created several Classes, Dimension Objects, Measure objects and Conditions.
• Created Web reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas, etc. Developed hierarchies to support drill down reports.
• Features such as breaks, alerter and hide blocks are used in developing reports.
• Exported Business Objects reports to Web Intelligence to be published on the Intranet and created thin client reports through Info View.
• Developed universes and Desk reports from the Oracle 9i database.
• Written queries to retrieve data from Oracle database for multi-dimensional analysis using slice & Dice and Drill up/down functionality.
• Generated various standard reports and queries based on the existing classes/objects.
• Responsible for Creating Complex and Multi-Dimensional reports using Master/Detail, Cross Tab, Slice and Dice and Sub Queries.
• Developed On - Demand Sub Reports, Parameter Reports and Drilldown Sub Reports.
• Created numerous Alerts that are executed based upon certain conditions.

Environment: Business Objects 3.1, Desktop Intelligence, Web Intelligence, Xcelsius Dashboard, Oracle 9i, SQL TOAD, Windows NT/2005