PROFESSIONAL SUMMARY:

• Around 6 years of professional experience in IT Industry, with expertise in developing the Business Intelligence and Data Warehouse applications.
• Worked on Data Warehouse assignments in various domains (Insurance, Retail, Media and Healthcare).
• Expertise in major SDLC phases and Agile Methodologieslike SCRUM, KANBAN for end to end BI Application development, Requirements Gathering, Design, Development, User Acceptance Testing, Production Deployment, Sprint based development and JIRA tracking.
• Extensive Experience in Tableau Desktop, Server, SAP Business Objects, Crystal Reports for creating Dashboards and Ad - hoc Reports.
• Well versed in Data Visualization development using Tableau to create complex and Innovative dashboards in various versions of Tableau products.
• Experience in Creating Tableau calculations, table calculations, LOD calculations, Data blending, actions Filters, time period functions, parameters based on Business requirements.
• Created and managed schedules of the Tableau Extract by setting the priority of the extracts in Tableau Server and scheduled the published dashboards from Tableau Server on weekly basis.
• Experience in Maintaining Tableau Admin activities included upgrades, configuration, license management and back up of servers. Responsible for scheduling, running and monitoring reports on daily, weekly and monthly basis.
• Created reporting objects like Facts, Attributes, Hierarchies, Filters, Prompts, Calculated Fields, Calculated Sets, Groups, and Parameters etc. in Tableau.
• Created LOD expressions, action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Worked on multiple Data sources for Creating Dashboards Using Tableau Extract and Live Connections. Also, involved in Performance Tuning on Dashboards.
• Experience in Business Intelligence/Business Objects (BI/BO) that includes Software Deployment, System Administration, BOE Security, Universe/Report/Dashboard Development, Documentation, Production Support and User Training.
• Resolved join path problems like Loops and Traps in the universes using Aliases, Contexts in Universe Designer.
• Created simple and complex reports involving Filters, Contexts, Hierarchies, Variables, list of values (LOVS),
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice,
• Drilling Methodology, Filters, Combined Queries, Ranking, Sections, Graphs and Breaks.
• Created Crystal reports involving sub-reports using Custom SQL and heterogeneous data sources.
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports using CMCadministration tool.
• Developed and reviewed SQL queries with use of joins clauses for Data validation and performed reverse engineering techniques to achieve Performance tuning.
• Provided maintenance and support for reporting applications, resolved production incidents and worked on continual service improvements.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 2019.1, 2018x, 10x, 9x,BOXI 3.1 (Universe Designer, Web Intelligence, Info view), BI 4.1 (IDT, BI Launch Pad,Dashboards), Crystal Reports Design Studio, Lumira.

Databases: Oracle 10/11g, Microsoft SQL Server, IBM Netezza, Teradata, SAP BW, My SQL, Amazon Aurora Db.

Programming Languages: SQL/PLSQL

Tools: MS Excel, MS Word, MS PowerPoint etc.

Platform: Windows Server

PROFESSIONAL EXPERIENCE:

Confidential - O’Fallon, MO

Tableau Developer

Responsibilities:

• Collaboration with end users, project stakeholders, and support partners to identify needs, goals, metric measurements, and business models to understand interfaces and enable end users to quickly identify key themes within the data.
• Develop, validate and execute algorithms, statistical models and applications that answer applied research and business questions.
• Developing and implementing analytical data models, dashboards and reports using Tableau and SAP business objects for users to analyze data and make business decisions.
• End-to-end implementation of Business Intelligence (BI) reports & dashboards.
• Use of structured query language (SQL) to query, analyze and integrate data.
• Documenting the dashboard needs, critical success factors of the business, related KPIs and measures in the dataset, and the designs.
• Extensively used LOD expressions, calculated fields, Table Calculations and Sets to visualize user’s critical requirements.
• Implemented Row level security for Dashboards by creating user filters in Tableau and published dashboards in live connection.
• Developed Forecasting dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly.
• Implemented Row level security for Dashboards by creating user filters in Tableau and published dashboards in live connection.
• 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.
• Experience in creating Tableau Repository, adding Users and Groups, assigning password security and assigning privileges in Tableau Server .
• Developed and reviewed SQL queries with the use of joins clauses for Data validation.

Environment: Tableau Desktop 2019.1, 2018x,Tableau server, BI 4.2, Information Design Tool, Crystal Reports 2016,Web Intelligence, Microsoft SQL Server, Microsoft SQL Server Management Studio 2014, Oracle 11g, Splunk, OMS, Jira.

Confidential, IN

TableauDeveloper

Responsibilities:

• Responsible for interacting with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Performed data analysis and various data models to validate the future state of trending for various business departments related to different line of Business.
• Understanding the customer segmentation and dimensions to support Sales and Marketing initiatives for the client.
• Developed interactive dashboards using quick filters, cascading filters, context filters, and parameters.
• Involved in creating Tableau Repository, adding Users and Groups, assigning password security and assigning privileges in Tableau Server .
• Created and managing schedules of the Tableau Extract setting the priority of the extracts etc.
• Designed and developed Business Objects reports for multiple business units using Facets Operations data Stores as data providers.
• Created multiple Universes based on various subject areas using aliases, contexts and implemented row level security.
• Created Crystal reports involving sub-reports, dynamic cascading prompts using Custom SQL and heterogeneous data sources.
• Played a crucial role in the migration of reporting environment from Amisys to Facets.
• Successfully migrated 40+ reports and resolved data, compatibility and connectivity issues.
• Tuned the performance of Custom SQL involving in-line and multiple sub-queries.
• Handled the security of the reporting system using Central Management Console and maintained enterprise users, groups and folders.
• Created Technical Design Documents, System Use Cases and Data Model Diagrams for reports and Universes.
• Provided maintenance and support for reporting applications, resolved production incidents and worked on continual service improvements.

Environment: Tableau Desktop 10x, Tableau Server, BI 4.1, Information Design Tool, Crystal Reports 2016, Microsoft SQL Server Management Studio 2014, Microsoft Team Foundation Server (TFS), Cisco Tidal Enterprise Scheduler, BMC Remedy.

Confidential, CA

BI Developer/Admin

Responsibilities:

• Closely worked with business users to gather requirements and transform them into reports and dashboards.
• Created Tableau Dashboards with interactive views, trends and drill downs, action filters, parameters and calculated sets from multiple data sources using Joins and Data Blending.
• Installed and tested the BI4.1 application on Sandbox.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Setting up the BO environment by installing the media in all Dev, Stage and Production environments and DR environments.
• Created DSN Connections on all servers including Audit and CMS databases.
• Setting up the Info sol and Configuring for New Environment.
• Migrated all Objects including Universes, Connections and Reports from Existing Environment to New environment using Promotion Management Tool.
• Created DSN Connections on all servers including Audit and CMS databases.
• Migrated all Security Content from old environment to new environment.
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Monitor schedule jobs proactively and re-run in case of failure.
• Created Audit reports on application wise required for audit purpose.

Environment: Tableau Desktop, Server, BI 4.0, 4.1, Windows Server, Oracle 11g, SQL Server, Netezza.

Confidential, Europe

Software Developer (Offshore)

Responsibilities:

• Gathering the requirements from the Business Users for building the Reports.
• Involved in developing of Universes using Business Objects Designer.
• Maintained Universes by defining joins, cardinalities between tables and by using contexts and alias tables to remove cyclic dependencies.
• Tested the Universes and resolved the problems that came with the Universe Design.
• Designed and Developed Web Reports using the features like Charts, Cross Tabs, Drill Down to analyze the data.
• Involved in optimizing the performance of web intelligence reports.
• Updated and maintained Universes based on changing user requirements and data source changes.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like merged dimensions.
• Organized data in reports by using filters, worked extensively on hierarchies for the client specific requirement.
• Organized data in reports by using filters, sorting, ranking and highlighted data with Alerter.
• Created the reports using BO functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab reports
• Created new restriction sets to implement Row level security.
• Created the Crystal reports using tables and tested the reports by cross checking and verifying data against the reports generated.
• Created WEBI reports using data from multiple data providers using merged dimensions functionality.

Environment: Business Objects XI 3.1, Universe Designer, Web Intelligence, Crystal Reports 2008 Oracle 9g, Windows 2003 Server.