SUMMARY

• Working as Senior BI Tableau/Cognos consultant wif 8+ years of IT experience in analysis, design, testing, development and implementation of client/server applications
• Experience in Health care, Insurance, Financial, Marketing, Operations and Sales Reporting
• Experience in working wif Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 10.X/9.x/8.x/7. X
• Extensive experience working wif Cognos 10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Event Studio, Report Studio, Query Studio, Transformer, Dynamic Cubes, Workspace, Workspace Advanced)
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Excellent knowledge on Data Warehousing implementations using Star schema and Snow flake schema and developing reporting solutions from OLTP
• Experience in creating the extracts in Tableau from various source files including flat files, excel sheets, Access files and different databases
• Experience in administering users, user groups, and scheduled instances for reports in Tableau
• Experience in creating solution driven dashboards by developing different chart types including Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Hands on experience in use of actions, filters, advanced navigation techniques, calculations and Level of Detail (LOD) expressions
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity and creating users, groups, projects, site roles, publishing workbooks to tableau servers.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues wifinTableau.
• Expertise in applying design patterns to develop BI solutions for delivery on web and mobile devices such as tablets and smartphones.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL ServerIntegration Services (SSIS).
• Expertise in web integration of Tableau Reports wif HTML or Asp.Net.
• Working knowledge on different data sources ranging from flat files, Oracle, MSQL Server.
• Proficient in writing complex queries using Oracle (PL/SQL).
• Experience in Tableau Administration for installations, Configuration, adding users, data connections, scheduling tasks, assign privileges etc.
• Experience in writing complex SQL queries to perform End - to-End ETL validations.
• Experience in Tableau Administration including managing Licenses, Site creation and Storage management, Subscription to views, Schedule Refresh tasks, Permissions to Users and User Groupsand creating Custom Admin Views for the quick analysis of User activity and Load times for Views
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups, Parameters in Tableau
• Proficient in providing Data level security, Object level security and Package level security
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager
• Excellent team player wif problem-solving and trouble-shooting capabilities and ability to adjust to people, circumstances, wif a Drive for results through self-motivation

TECHNICAL SKILLS

Data Visualization/Reporting Tools: Tableau Desktop 7/8.1/9/10, Tableau Public 8.x/9.x,10.x Tableau Reader 8.x/9.x,10.x Tableau Server 8.x/9.x/10.x

RDMS/DBMS: MS-SQL Server 2014/2012/2008 R2/2008/2005Oracle 8i/9i/10g, MS Access.

BI Tools: Cognos 11.x,10.x,9.x,8.x Cognos Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio. SSIS, SSRS, BIDS.

Modeling Tools: Cognos Cube Designer, Cognos Transformer & Cognos Framework Manger. MS Visio 2007/2010/2013

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005, Oracle 9i/10g, OLTP, OLAP, SQL Query Analyzer.

Programming Languages: T-SQL, PL/SQL, MDX, XML, ASP .NET, JAVA.

Web Technologies: HTML, XML, CSS

Operating Systems: Windows Server 2003/2008/XP and Unix/Linux.

PROFESSIONAL EXPERIENCE

Confidential, TX

Tableau Developer

Responsibilities:

• Understood the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Designed and deployed rich Graphic visualizations wif Drill Down and Drop down menu option and Parameters using Tableau
• Developed Tableau data visualizations using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations
• Built groups, hierarchies, sets to create detail level summary reports and dashboard using KPI's
• Worked on workbook Permissions, Ownerships and User filters
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Utilized Tableau server to publish and share the reports wif the business users
• Involved in administration tasks such as setting permissions, managing ownerships and providing access to the users and adding them to the specific group
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community
• Tested dashboards to ensure data was matching as per the business requirements and if their were any changes in underlying data
• Rewrote poorly performance stored procedure, functions, triggers, views and indexes
• Worked TEMPeffectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries

Environment: Tableau 10.2/9.0/8.0, Tableau Server, SQL Developer, Amazon Redshift, MS-SQL 2008 R2, MS Excel

Confidential, CA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle/ SQL Server for design, development, testing, and production rollover
• Created Tornado charts in Tableau to compare Validated and Draft classification of projects for the Project Monitoring Report data
• Used Tableau to compare the percentage of disbursements of active projects against the historical 10 year disbursements of projects
• Extensive experience in using all Level of Detail (LOD) expressions like Include, Fixed and Exclude, to create visualizations that are different than the view level or visualizations level of detail
• Used Tableau Data blending feature to combine data from EDW wif the historical population patterns of Latin American countries
• Worked on drill through reports by creating HTML references
• Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel
• 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 wif the usage of quick filters for on demand needed information
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing
• Created report schedules, data connections, projects, groups in Tableau server
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Performance tuning of reports and resolved issues wifin Tableau Server and Reports

Environment: Tableau Desktop 9.0/8.x,Tableau Server, MS Office Suite, Oracle, SQL Server, Micro strategy 9.x, MS Excel, HTML, CSS

Confidential, MO

Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and tan translate them to technical specifications
• Created different views in workbook to visually analyze data
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop
• Setup and Administrating the Tableau Cluster Infrastructure and Perform upgrades
• Used Data blending, Data densification and Data scaffolding features in Dashboards
• Improved performance in dashboards by implementing context filters on dashboards
• Wrote Power Shell scripts to automate the TDE file refresh on Tableau Servers
• Used Table Calculations, Parameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards
• Created Actions in Worksheets and Dashboards for interactivity in dashboard views
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc.,
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet
• Performed Tableau Server administration activities like Site and Project creations and adding users and providing permissions to workbooks
• Provide dynamic selections of measures and dimensions in visualization by creating parameters and calculated fields
• Implemented security in Tableau workbooks by creating filter in workbooks and also implemented security at Data Extraction level
• Used Tableau Admin views to identify the performance issues on the Tableau workbooks
• Created a TDE files to improve the performance of visualization calculation in Tableau Dashboards
• Schedule TDE Reloads on Server and Troubleshoot errors and failures
• Responsible for Deploying and Maintenance Tableau Dashboards on Server

Environment: Tableau 8.0, Tableau Server, Hadoop, Hive, SQL Server, Toad, SQL, PL/SQL, PowerShell, HTML5, CSS3, JavaScript and D3.js, SQL Server 2008 R2

Confidential

Cognos Developer

Responsibilities:

• Gatheird, analyzed and documented business requirements, clarified business rules and data design requirements, functional requirements and prepared specification documents
• Designed mapping of process flow and interacted wif analysts and core team members to select the proper system infrastructure
• Designed and reviewed the processing steps and created processes for new system
• Reviewed project specifications, flow charts, process diagrams and system documentation for application operations and methodology
• Created processes for new system and attended ad-hoc issues related to day to day activities throughout project implementation and testing phases
• Extracted data from an Oracle transactional system and loaded it into a SQL Server data warehouse
• Developed complex reports including multipage-reports, graphical reports, formulae base and well-formatted reports according to user requirements
• Created Aliases for resolving Loops and Checked the Cardinality and Integrity of the Project / Framework Model
• Created various prompts like value prompts, Number prompt, in report to restrict data fetch and ease data load
• Provided the security access management by creating users/groups and folders
• Upgraded from Cognos 8.4.1 to 10.x by creating a backup environment parallel and performed a full content store export in Cognos administration

Environment: Cognos 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Oracle 10g, SQL Server 2008, DB2 9.1 on Windows Server 2003/2008.

Confidential 

Cognos Developer

Responsibilities:

• Extensively interacted wif Business Users and gatheird information and requirements
• Ensured that all assigned task was customer focused, results oriented, performance driven, and in compliance wif all applicable internal and external requirements
• Created customized BI reports linking various databases, to meet the user requirements
• Implemented internal Cognos Security - Data Security using Security tables to secure sensitive data wifSecurity Filter, Macros, Session Parameters and Parameter Maps
• Experience in creating OLAP cubes using Transformer and Utilized TOAD to access and analyse data directlyfrom databases
• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modelling, Reporting Model and report development, performance tuning, and data delivery mechanisms
• Created different filters and calculations in Framework Manager that can be TEMPeffectively used while reporting
• Created Hierarchies from providing drill down options for the end-user
• Created standard and Ad-hoc reports using Cognos Query Studio (Simple List, Grouped List, Crosstab, and nested Crosstab) reports and represented data graphically by charts utilizing Query Studio
• Modelled and Reported against an Operational Data Source (OLTP) using Framework Manager
• Created complex Dashboards wif Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio
• Developed Report Templates for Standard and Ad-Hoc reporting to make the Reports look Consistent

Environment: Cognos 8.3(Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformers, Framework Manager), Oracle 9i, TOAD, SQL server, Windows server2003, Excel.