SUMMARY

• More than 18 years of extensive business experience in implementing Data Warehousing solutions (12 years onsite in USA and 6 years in UAE) using Tableau & Cognos.
• Sound technical knowledge of relational databases, dimensional data modeling, structured query language (SQL), data warehouse and reporting techniques. Strong hands - on experience using SQL with a relational DBMS such as Oracle, DB2, SQL Server.
• Solid knowledge of Visualization tools like Tableau, Qlik Sense and other reporting tools like Cognos, Business Objects.
• Solid knowledge in Finance domain being a CPA from India.
• Solid knowledge of Project Management and handling project within Budget and Time.
• Translating architectural strategy and business requirements into implemented software.
• Sound knowledge of product life cycle phases like requirement specification, software designing and development, testing and maintenance.
• Excellent communication skills with great leadership qualities and detail oriented.
• Designed and automated manual reports to reduce and eliminate tedious and outdated report processes.
• Sound knowledge of MS Office package.
• Profound ability to analyze and formulate results.
• Provided accurate and timely reports and analysis for influencing business decisions and the achievement of strategic goals.
• Performed Cost Benefit Analysis and recommendations.
• Performance tuning of Views, Dashboards, reports / cubes.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Tableau Lead Developer

Responsibilities:

• Converting excel based legacy system to Tableau Dashboards.
• Developed more than 100 dashboards in 3 years.
• Scheduling meeting with stakeholders to get their requirements and create wireframe reports for initial approval.
• Created data sources using Oracle, Box, SmartSheet.
• Create Business requirement document for off-shore team to develop dashboard and monitor the progress and update stakeholders.
• Interacting with ETL team for data requirement and getting all tables populated and refreshed as per reporting requirements.
• Created various dashboards which includes dual axis, stacked bar, donut, heat map, geo coding etc.
• Created all types of complex calculated columns like Table Calc, LOD, Nested LOD Customized tool tips, Parameters, sheet swapping etc.
• Applied Action Filter to filter data from dashboard to another dashboard.
• Used multiple data sources and applied data blending.
• Scheduled data refresh on Server.
• Applied data level and dashboard level security. Applied data source filter when doing data blending so that user can see only relevant values in filter drop down.
• Tested data against database and rectified all defects.
• Shared our dashboards with vendors with proper data security and published dashboard on Tableau Online as well as on premise server.
• Refreshed Tableau Online data sources using Tableau Bridge.
• Conducted multiple training sessions with more than 300 users to train them about features of each dashboard and how to drill down, down load data etc.
• Recorded all training sessions and put recordings on Company’s intranet for users to refer in future.
• Created user training documents.

Environment: Tableau 2021.1, Oracle

Confidential, Dedham, MA

Tableau Architect

Responsibilities:

• Analyzing reports already built in MS Excel and creating design documents to develop dashboards in Tableau.
• Sending Wireframe reports to Stakeholders and getting approved after making necessary changes.
• Writing Custom SQL to create data sources in Tableau.
• Used Table Calculations, LOD Expressions.
• Created various visuals like 2D Pie Chart, Donut Chart, Funnel Chart, Water Fall,
• Applied Action Filter to filter data from dashboard to another dashboard.
• Created Dashboards using multiple data sources, applied data blending and passed filters from one data source to another data source.
• For larger extracts, created empty extract on the desktop to save time and then refreshed extract on the server to have full data.
• Scheduled data refresh on Server.
• Applied data level and dashboard level security. Applied data source filter when doing data blending so that user can see only relevant values in filter drop down.
• Tested data against database and rectified all defects.

Environment: Tableau 10.5.2, SQL Server 2016

Confidential, Northbrook, IL

Tableau Developer / Architect

Responsibilities:

• Meetings with business users to gather business requirement.
• Created wire-frame of reports and get them signed-off
• Created data sources using custom sql,
• Created summary tables using custom sql to improve performance of the dashboard.
• Used SQL Developer to run SQL queries and validate the data.
• Created dashboards that included drill-through, filters passing from one view to another view or all views, Heat/Geo, Pie/Bar charts, Circle views, Line/Area charts, Scatter plots and Bullet graphs, Dual Axes Charts, Donut Chart to compare various measures etc.
• In Tableau, applied cascading filters so that user will always see relevant data.
• Applied all types of filter i.e. Quick Filter, Context Filter, Data Source Filter, created hierarchies, created parameters.
• Created calculated columns, Table Calculation, LOD Expressions,
• Tested dashboards data against source system and rectified the defects.
• Published dashboards on Tableau Servers and scheduled Tableau data extracts refresh.
• Applied security in Dashboards (data level and dashboard level). Applied data source filter when doing data blending so that user can see only relevant values in filter drop down.
• Provided maintenance of the Dashboards.
• Created navigation tabs on the left of the dashboard to move from one dashboard to another dashboard (within same workbook) instead of navigating using tabs on the top.
• Customized Tool Tips for users.

Environment: Tableau 10.3.3, Oracle

Confidential, Saint Louis, MO

Senior Tableau Architect

Responsibilities:

• Meetings with stakeholders to get business requirement and document them.
• Created mock-up of reports and get then approved from stakeholders before start of development work.
• Had meetings with DBA to understand tables structure and then developed SQL scripts after joining required tables, written ‘Case’ statements to pivot the data, ‘Union All’ to add rows based on different aggregation levels, filters etc and populating staging table for reporting requirement.
• Based on staging table, created reporting table to be used in Tableau as Data source after applying logics as per reporting requirements.
• Created calculated columns at SQL level.
• Used SSMS to run SQL queries and validate the data.
• Created various dashboards involving Pie Chart, Funnel Chart, Bar Chart using Dual Axis, Heat Map, Cross Tab Report,
• In Tableau, applied cascading filters so that user will always see relevant data.
• Applied Quick Filter, Data source filters and Global Filter,
• Created Hierarchies so that user can drill down data.
• Created folders in Tableau Work Book to arrange related fields in one folder.
• Created Dashboards using multiple data sources, applied Data Blending, test dashboards data against source system and rectified the defects.
• Published dashboards on tableau Dev Server and QA Server and after getting UAT Testing, moved to production server.
• Scheduled Tableau Data Extracts refresh on the server so that user can see current data.
• Applied security in Dashboards (data level and dashboard level).
• Created Stores Procedures to refresh Staging Tables and Reporting Tables on daily basis.
• Provided post implementation production support.

Environment: Tableau 9.3, SQL Server 2014

Confidential, Lincolnshire, IL

Tableau Developer

Responsibilities:

• Converting business requirement documents to technical specifications to develop views and dash boards.
• Designed layout of the views and dashboard and got it approved by the stakeholders.
• Created data dictionary for development of views and dashboards.
• Developed Views and Dash boards using multiple data sources and applied data blending.
• Developed Tableau Data Extracts file (.tde) file and saved Tableau Data Source file (.tds) and .tdsx file.
• Saved workbooks as .twbx file and published on Tableau server and scheduled data extract refreshes.
• Developed dashboards using multiple data sources and applied data blending.
• Applied conditional formatting to highlight data.
• Applied context filter, quick filters and data source filters.
• Scheduled data extracts.
• Applied user filters (security) to limit the access of the views and dashboards to the intended users only.
• Performance tuning of the views and dashboards.
• Worked with ETL team for defining data-mart.

Environment: Tableau 9.3, SQL Server 2012, LDAP

Confidential

Tableau Reporting Lead

Responsibilities:

• Worked closely with business power users to create Reports/Dashboards using Tableau Desktop.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
• Developed reports using custom SQL queries and created .tdsx, .tde and .tds files.
• Used Excel and CSV files to generate Tableau data sources for the data not in the Data Warehouse.
• Used Data Blending in case of different data sources.
• Created aggregates, hierarchies, calculated measures.
• Applied Conditional Filters, Quick filters, context filters and data source filters.
• Applied conditional formatting to highlight data comparing to previous period/previous year.
• Used Trend Lines and Reference Lines.
• Developed various dashboards and used sets and groups.
• Developed various operations, production, sales, purchase, costing and finance reports for critical business decisions.
• Make use of filters and making then local and global according to requirements.
• Involved in creating interactive dashboard and applied actions (filter action, highlight action and URL action) to dashboard.
• Worked on Quick Table Calculations, LOD Expressions usingTableauDesktop.
• Tableau Desktop and Tableau Server has been used to create Data Extracts & Scheduling the Data Extract Refreshes.
• Developed different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Created Prompts, customized Calculations, Conditions and Filters for various analytical reports and dashboards.
• Worked with the Data modeler/ETL team members on the data mart requirements.
• Worked with Data modeler on creation of summary tables for few critical reports.
• Worked with the end users on UAT and resolved data issues.
• Leading a team of 3 developers
• Worked extensively with DBA’s on creation of functional indexes/table partitioning.
• Rolled out Best practice Semantic layer guidelines and report building templates.
• Conducted SQL Plan of the reports indicating performance Gaps.
• Interacted with business users for their reporting requirements, proposed and finalized layout of the reports and business approval
• Translated business requirements into technical specifications.
• In-depth knowledge on Tableau Desktop and Tableau Server.
• Used Parameters and input controls to give users control over certain values.
• Used Trend Lines, Reference Lines and statistical techniques to describe the data.
• Generated Dashboards with Quick Filters, Parameters and sets to handle views more efficiently.
• Create basic calculations including string manipulation, arithmetic calculations, custom aggregations and ratios, date, logic statements and Quick Table Calculations.
• Performance Tuning of the dashboards:
• Analyzed performance recording reports
• Instead of live connection, used data extracts
• Pushed the logic to the database layer
• Pushed all required dashboard calculations in the data source
• Joined tables at the data source level instead of using data blending
• Provided links within dashboard for ‘detailed views’, to reduce the overall load time of the dashboards
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Tableau administration activities: Installation, backups, security administration, managing extracts and publishing contents

Environment: Tableau 9.2, Oracle 11g

Confidential, Mentor, Ohio

Sr. Reporting Analyst

Responsibilities:

• Working with end users to determine reporting needs and create BRD’s (Business requirement documents).
• Created technical specifications and documentation for the reports/cubes to be developed.
• Architected Framework Manager Model/Reports to meet reporting requirements.
• To develop Cognos 8.4 Report Studio reports.
• To develop Transformer Model for creation of Cubes.
• Applying filters, prompts, conditional formatting, report scheduling, creating calculation etc.
• To develop IQDs to be used in development of cubes.
• Performance tuning of the reports and cubes.
• Implemented row level security in cubes.
• To enhance the existing reports and applying filters prompts etc.
• To enhance the existing cubes and applying Alternate drill path, filters, dimension, measures etc.
• Working with ETL team for defining data-mart.
• Production support.

Environment: Cognos 8.4, Oracle 10g, Cognos 7.3

Confidential, Houston, Texas

Reporting Lead

Responsibilities:

• Interact with business unit users for requirement gathering and development process.
• Created technical specifications and documentation
• Developed Cognos data models and reports from relational and multi-dimensional data sources
• Used Cognos 8.4 Report Studio to develop standard and complex reports.
• Applied prompts, filters and calculations.
• Applied conditional formatting.
• Developed list, chart and cross-tab, drill-through and master-detail reports.
• Applied join to join the query within Report Studio.
• Developed and scheduled Event Studio Alerts.
• Performance tuning of the reports and prompt page.
• Worked with ETL team for defining data mart.
• Production support.

Environment: Cognos 8.4 Oracle 10g, SQL Server 2005

Confidential, IL

Cognos Administrator

Responsibilities:

• To install and maintain Cognos 8.2 in multiple servers environment.
• To trouble shoot the day-to-day issues.
• Identified long running reports utilizing Cognos audit package.
• Worked with UNIX & DBA teams to capture database SQL and UNIX process id times.
• Worked with IBM Cognos on heath check of Cognos Environment; Server configuration and number of BIBUS processes.
• Installed another instance of dispatcher to share the workload of scheduled reports.
• Worked with Data modeler on creation of summary tables for few critical reports
• Worked extensively with DBA on creation of functional indexes/table partitioning.
• Implemented weekly start of Cognos server utilizing UNIX script.
• Vendor management i.e. logging the case with Cognos to fix the issues.
• Production support.

Environment: Cognos 8.2, Oracle 10g

Confidential, Charlotte

Cognos Administrator /On-Site lead

Responsibilities:

• Worked with Business Analyst/Functional Consultants and Business Users to gather requirements and fine tune requirements.
• To give technical molding to business requirements by writing Technical Specifications.
• To interact with the ETL/UNIX/DBA/Source team on the requirement for the data model as part of development, testing and implementation process.
• Responsible for critical designing/coding/template designing of the same.
• To coordinate with Offshore Developers in report/cube development.
• To interact with UAT team on any raised issues and to draft test Scripts and test deliverables for UAT.
• Maintenance of Access Manager using Access Manager Batch Maintenance and People soft App Engine.
• Administration activities of migrating/Publishing Reports/Cubes in different environments, using Deployment Manager/Migration Utility/ Unix Scripts.
• Customizing Upfront Portal as per specific client
• Created Data Dictionary of the FM model for developers.
• Developed advanced reports using Report Studio and Adhoc reports using Query Studio.
• Scheduled various reports using Schedule Management used in Cognos Connection and Cubes using UNIX script and Control M(A third Party scheduling tool)
• Implemented row level security in cubes.
• Performance Tuning of Reports/Cubes.
• Created iqds in Framework manager/created Transformer Model in 7.3 and build the cube on the server.
• To support multi-client Production and data issues.

Environment: Cognos 7.3, ReportNet 1.1, Cognos 8, DB2, Oracle 9i, LDAP.

Confidential, Poway, CA

Cognos Analyst

Responsibilities:

• To identify source data for the Transformer Models.
• To identify source data for Data Warehouse.
• To modify the IQDs and apply necessary security filters.
• To modify the Transformer Models.

Environment: Cognos 7.3, Oracle 11i, LDAP.

Confidential, Thousand Oaks, CA

Cognos Analyst

Responsibilities:

• Developed the Framework Manager Metadata Model using multiple data sources.
• Interacted with business users to gather their requirements and making technical specifications for developers.
• Designed the reporting formats.
• Developed the various types of sales & marketing reports such as list report, graphical report, cross tab reports, drill-through reports, complex reports using ReportNet 1.1.
• Applied Prompts, Filters, Conditional Formatting and Calculations in the reports.
• Interacted with DBA/ETL team to define data mart for reporting needs.
• Set the security through Access Manager in Framework Manager Model and Reports.
• Customized reports using Java in Reportnet reports
• Performance tuning of the reports by conducting SQL Plan.
• Test the reports against database after writing SQL in Oracle 9i.
• Deployment of the reports to production.
• Getting user feedback.

Environment: ReportNet 1.1, Cognos Connection, Report Studio, Query Studio, Framework Manager, LDAP and Oracle 9i.

Confidential, Minneapolis

Cognos Lead

Responsibilities:

• Install and configure Cognos ReportNet 1.1 in multiple server environments.
• Work with Business Analyst/Functional Consultants and Business Users to gather requirements and fine tune requirements.
• To give technical mould to business requirements by writing Technical Specifications.
• Architected Framework Manager Model with two tier architecture. Published /Implemented Package security and Object security for both Query Studio and Report Studio Packages.
• Created Data Dictionary of the FM model for developers.
• Analyzed the Joins and eliminated Looping.
• Created various types of reports such as list reports, cross tab reports, charts report, drill through reports, master detail reports, cascading prompt reports etc. using Cognos ReportNet 1.1.
• Created financial reports such as Profitability Analysis, Monthly report, production, sales & dispatch report, inventory report, assets turnover, inventory turnover, Profit Margin Graph.
• Applied security using Access Manager.
• Applied Security in Framework Manager for Adhoc Query users.
• Administration activities of migrating/Publishing Reports/Cubes in different environments, using Deployment Manager/Migration Utility/ Unix Scripts
• Created documentation for staff training.
• Trained users on Query Studio for Ad-hoc reporting.
• Interacted with DBA and ETL team in building the data warehouse.
• QA of reports.

Environment: Cognos ReportNet 1.1 MR2, Report Studio, Query Studio, Framework Manager, LDAP, SQL Server 2000.