SUMMARY

• Around 10 years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Data Warehousing, and OLAP environments using BI tools Tableau and Cognos.
• Extensive experience in Tableau Desktop, Tableau Server, and Tableau reader in various versions of Tableau (10.x/9.x/8.x/7.x), Cloud based data source Redshift and visual query language - VizQL.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks, visualization and dashboards for executive decision making.
• Created solution driven dashboards using different chart types like Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Worked on Tableau Server and Tableau Administration in creating users, Setting Security for Users and Licenses, Permissions, Groups and Projects, Scheduling Tasks.
• Mastered the ability to design and deploy rich Graphic Visualizations with Drill Down and Drop down menu option, Parameterized Dashboards from multiple data sources by blending data using Tableau.
• Harnessing best ways in designing stunning Tableau Visualizations using tableau software, publishing and presenting dashboards on web and desktop platforms. Provided extensive End User Training and Support on Tableau.
• Administered user, user groups and scheduled instances for reports in Tableau. Trouble shooting skills, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups in Tableau Server.
• Expertise in getting the data from different data source such as flat files, Excel, Access Database, Microsoft SQL server, MySQL, T-SQL, Oracle, Amazon Redshift.
• Experienced in various Cognos components such as Cognos BI (Report Studio, Analysis Studio, Query Studio, Transformer and Cognos Connection).
• Worked on Agile methodology, and involved in scrum meetings to give inputs as technical expert to application design for performance tuning and admin requirements.
• Strong Communication skills, Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILLS

Reporting Tools: Tableau 10.4 (Tableau Desktop, Tableau Server, Tableau Online), Tableau Server Administration,Cognos Analytics 11.0.9 and Cognos 10.2.2 (FrameworkManager, ReportStudio, AnalysisStudio, WorkspaceAdvanced, QueryStudio, EventStudio, CognosConnection),Cognos Series 7.4/7.1 (Power Play, Transformer, PowerPlay Enterprise Server, Impromptu Administrator, IWR, Access Manager, Report Administration, Server Administration, Upfront, Visualizer).

Data Tools: SQL Workbench, PLSQL developer, TOAD, SQL* Plus, SQL* Loader, SQL Server Management Studio.

Databases: Redshift, Oracle, MS SQL Server.

Languages: SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Tableau Developer

Responsibilities:

• Oversee the performance of design to develop technical solutions from Analysis documents.
• 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.
• Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Tableau Logs - Reviewing the Server logs for any errors or security issues that are unexpected.
• Performance Logs - Reviewing the performance metrics to determine if the baseline exceeded or for the slow points during the day that need to be reviewed.
• Tested reports and uploaded Tableau dashboards on to server and provided production support for Tableau users.
• Created Heat maps, Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server, MS Excel, and MS SQL Server to create various Tableau Dashboards and Reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report. Used Tableau advanced functions like LOD Level Of Detail, Lookup and Sets.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks and did performance tuning on various Tableau Reports, Dashboards.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets based on AWS Redshift Cloud data source.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand, needed information.
• Reviewed transactional database schemas (OLTP) and utilized Tableau software to build Reports and Dashboards.
• Involved in sprint planning sessions and sizing the user stories in AGILE SCRUM environment

Environment: Tableau Desktop 10.2.6, Tableau Online, Tableau Server, Tableau Administration, Jira, SQL Workbench, AWS Redshift, SQL Workbench, MS SQL Server 2012 and Windows Server 2012.

Confidential, CA

Tableau Developer

Responsibilities:

• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Analyze complex data from various data repositories and become familiar with user base locations.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed Tableau Dashboards for visualization of data, presentation, and analysis.
• Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth.
• Involved in creating interactive, parametrized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements and did performance tuning on various Tableau reports.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports and dashboards.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Used parameters and input controls to give users control over certain values.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle & MS Excel.
• Created Data extracts for better performance of dashboards and accessing data offline.
• Integrated dashboards with live Connection in Microsoft PowerPoint using LiveWeb add on.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Worked in Agile environment to carry out the Development activities and maintained the documentation in JIRA.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Created reports using Custom SQL for complex report views.
• Executed and tested required queries and Tableau reports before publishing.

Environment: Tableau (Desktop/Server) 9.x/8.x, Oracle 11i, JIRA, SQL Workbench, AWS Redshift, MS SQL Server, MS Visio, Microsoft Office Suite ( Word, Excel, PowerPoint).

Confidential, CA

Tableau Consultant

Responsibilities:

• 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.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Dash board actions and Table calculations.
• Involved in migrating client's reports from excel (static) based solution to an interactive service.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from Tableau 8.0 to 8.1
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created incremental refreshes for data sources on Tableau server.
• Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tab commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau Desktop 8.x, Tableau server / Administrator, Tableau drive, SQL developer, SQL 2012, Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.and Windows Server 2008.

Confidential, CA

Senior Cognos BI Consultant

Responsibilities:

• The Data Warehouse was focused on building dimensional model using Ralph Kimball's methodology.
• Modified PowerCubes as per the user requirement by adding new Dimensions, Levels, Measures and Calculated Measures etc., Published Cubes and Reports to Upfront through PowerPlay Enterprise Server administration.
• Done Unit testing of the reports by checking the report output to the SQL output and prepare Unit Test Document.
• Building an integrated Business Metadata model using Cognos Framework Manager and accommodate data layer and business layer for future growth.
• Extensively used prompts, filters, cascading conditional variables, multiple queries for data extraction in reports.
• Used Access Manager Administration to implement Authentication, Security to various Cognos applications.
• Gathered, analyzed and documented user requirements for reporting. Working with Agile Methodology.
• Developed Meta data models using Framework Manager, creating Packages and published these Packages on to Cognos Connection for creating ad-hoc reports using Query Studio and professional reports using Report Studio.
• Created Database Layer, Intermediate layer and Presentation Layer defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Created Packages with various security settings and published them onto Cognos Connection.
• Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager.
• Created reports using Conditional formatting, Conditional blocks, Conditional variables, Advanced Conditional styles and Conditional Layout features in Report Studio.
• Developed Active Reports using Cognos 10.2. Developed Power Play cubes in Transformer 10.2.
• Deployed reports and packages from Development to UAT and then to Production.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level. Customized Reports using HTML and JavaScript.
• Decreased the Cube build time drastically and increased runtime performance.
• Involved in Upgradation of models and reports from Cognos 8.4 to Cognos 10.1.1. and Cognos 10.2
• Involved in testing, validation of report data against the database to measure performance using Toad & SQL Developer.
• Scheduled and Busted Reports to user requirements in Cognos connection and distributed them through email.

Environment: Cognos 10.2/8.4/8.3 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Office Connection),Java script, XML, HTML, Transformer 8.4, Oracle 10g, SQL server 2005, MS Project, MS Visio, and Windows 2008.

Confidential, MA

Cognos BI Consultant

Responsibilities:

• Analyzed the Business functional requirements and documented the technical specifications.
• Created Packages with various security settings and published them onto Cognos Connection.
• Created Framework Manager Packages defining the cardinalities and namespaces.
• Implemented Cognos 8 distributed environments, Developed Dimensional Models for Cognos 8 Analysis Studios, Migrated Power Play cubes to Cognos 8 Framework Manager.
• Created DMR models in framework manager in order to create multidimensional reports in analysis studio and drill down and drill up reports in report studio.
• Defined security over packages, package level access and object level access to allow users to create calculations over the query items. Created Roles and Groups and assigned permissions to users in Cognos Name space for security.
• Reviewed the existing Impromptu environment and made the necessary changes to them so that the migration to Cognos 8 would be successful.
• Integrated various conditional prompts, cascading prompts, conditional variables in the report. Developed Prompt pages and Conditional Variables.
• Created multipage reports with master-detail relationships, Query Prompts, Calculations, Conditions & Filters.
• Used conditional formatting to discard the unwanted columns in the report.
• Created Public Folders, Private Folders, My pages and custom views in Cognos Connection.
• Securing Cognos Connection and setup security by assigning users to groups and roles defined in Cognos Namespace.
• Implementing the plan to migrate from Cognos 8.2 to Cognos 8.4.

Environment: Cognos 8.4, Cognos 8.2, Cognos EP series 7.1, Framework Manager, Report studio, Query Studio, Analysis Studio, SQL and MDX, Power Play Transformer Version 7.1/8.1, DB2 and Windows Server 2003.