SUMMARY

• Over 8+ years of IT experience including both the functional and technical sides of Data warehouse engagements and Experience with Business Intelligence Tools like Tableau Server, Tableau Desktop and Cognos 8BI, Cognos Report net (Framework Manager, Report studio, Analysis studio, Query Studio)
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• 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 Tableau’s Advanced Capabilities.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Involved inTroubleshooting, Performance tuning of reportsand resolving issues withinTableau ServerandTableau desktop report
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• Proficient in Building compelling, interactive dashboards inTableauthat answer key business questions
• Highly proficient in using Confidential - SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Professional in communicating Dashboards perTableauvisualization features
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Designed and developed many complex reports based on the requirements using complex calculations like Row-level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines using TABLEAU 8.0.
• Expertise in creating various Cognos Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Expertise in Report Development - Administration for Tableau and Cognos BI.
• Proven ability to deliver and ensure success in high-pressure/high-risk situations.
• Provided 24x7 production supports for applications based on Cognos products.
• Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.
• Involved in Tableau Desktop 7.0 to 8.0/Server Upgrades/Patch upgrades and also involved in maintaining Tableau Server Activities.
• Expertise in developing and coordinating automation tasks that enable the rapid and repeated delivery of custom reports. Also, created many Executive level and customer facing dashboards using Tableau 8.0.

TECHNICAL SKILLS

BI Reporting Tools: Tableau Desktop 7.0/8.0/8.1, Public, Tableau Server, Cognos

Java & J2EE Technologies: Core Java

Databases: Oracle 9i/10g/11g, MySQL, MS Access SQL Server

Operating Systems: Windows 95/98/2000/XP/Vista/7

Environment: Windows XP/2000/2003/NT 4.0/Vista and MS-Dos.

PROFESSIONAL EXPERIENCE

Confidential, Orangeburg, NY

Sr. ETL/ BI Developer (Cognos & Tableau)

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Good Knowledge on Tableau installation and configuration with Single Server System
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementationproject, designing and developing visualizations.
• Created batch scripts for tableau Server backup atomization on weekly basis and save the backups in particular folder.
• Brainstorm ideas onwhattoinclude in views/dashboards from the data sourceand document on the fly business requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau.
• Involved in creating many complex Adhoc and Dynamic reports with calculated fields, filters, parameters, hierarchies, sets and groups.
• Created much visualization like filled maps, geo maps based on dimensions and measures which gives the End user more visibility to make decisions based on the region.
• Created many Dashboards and KPI reports using relevant Marks or Highlight functionalities.
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Developed Leadership reports, dashboards, drill downs, charts, scorecards, master detail reports, crosstab with non-numeric facts, conditional block, conditional format and alternating row colors for both wireline and wireless business units.
• Reduced the performance of Cognos burst reports (VP/DIR/AD) from 10+ hours to 40 minutes (90 AD’s).
• Performance tuned the summary report built off of other team cognos package from 2 hours to 17 mins; 4 hours+ report to 20 minutes; forever running yearly report to 45 minutes.
• Identified & solved the performance issues on the reports developed by other team members and framework issues that impacted report errors and performance and guided them.
• Involved in upgrading the ETL processes/code as per the upgraded PeopleSoft ELM 92 version & custom built PeopleSoft application (ITAT), verified the cognos framework changes are in sync and updated all the relevant cognos reports as per the new “query item” name changes.
• Involved in creating a dual-axis bar chart with multiple measures.
• Implemented data blending to blend related data from different data sources.
• Responsible for Training endclient users onTableauDesktop by providing step-by-step guidancefrom basics to advanced functions ofTableauincludingworking with calculations,parameters, and date functions.

Environment: Tableau V 8 (Desktop, Server, Reader), Oracle, cognos 10.1/10.2, Oracle 11g, SQL Server, PL/SQL, TOAD

Confidential, SUNNYVALE, CA

Tableau Admin/Developer

Responsibilities:

• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement
• Created Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created complex Executive dashboards using Tableau Desktop that was published for the business stake holders for analysis and customization using filters and actions.
• Created dashboard using parameters, sets, groups and complex calculations.
• Implemented various data connections from data source toTableauServer for report and dashboard development
• Monitored VizQL server, Application Server and data server activity to track performance and system stability
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Developed many reports with multiple data connections and performed data blending and created different visualizations like Bar Charts, Gantt Bar Charts, tree maps, bubble charts using complex joins.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal reports,
• Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Involved in creating guided navigation links for Interactive dashboards in Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Provided 24/7 production support for Tableau users.
• Involved in testing dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Reader, Tableau Server, Tabcmd, Oracle, MS Office 2007/2010, SQL Server 2008, Windows 7, Enterprise Manager, SQL Server Management Studio, Microsoft Excel.

Confidential, Bellevue, WA

DWH & Tableau BI Developer

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Installed, configured, and deployedTableauServeracross all environments.
• Maintained Tableau data extract refreshes using Scheduling and Tasks.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Designed and developed many complex reports based on the requirements using complex calculations like Row-level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Set upTableauDesktop, Data Analysis and publishing reports.
• Created dashboards in IPad mode where the C level executives can use the proposed solutions
• Wrote custom Confidential -SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created standardized reports and documents, along with enhancing and maintaining the existing Dashboards.
• Generated daily, weekly and monthly reports using Cognos.
• Developed Parameter based reports, Drill-down reports, Matrix reports, Charts and Tabular reports using Cognos and enabled ad-hoc reporting with report builder.
• Executedand tested requiredqueries and reportsbefore publishing.

Environment: Tableau 6.0/7.0,Cognos 8.4, SQL Server 2008, Confidential -SQL, Windows 7, Enterprise Manager, SQL Server Management Studio, Microsoft Excel.

Confidential, Sunnyvale CA

Sr. ETL / BI (Cognos) Developer

Responsibilities:

• Created reports using prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Developed multiple Complex reports like Master-detail relationship, drill through, burst options and Cascading prompts using Report studio.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created Active reports using data deck, tab data button bar, Iterator and sliders.
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Test/validate system tables/files in System Test, UAT and Production environment.

Environment: Cognos BI (Framework manager, Report Studio, Query Studio), Active Reports, Cognos Business Insight Advanced, Oracle 10g, TOAD.

Confidential, Phoenix, AZ

SQL Server / BI Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Filtered bad data from legacy system using complex Confidential -SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification Confidential early stages before calling them.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Generated reports using Cross-Tab, Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Tested the reports and fixed bugs in the stored procedures.
• Established backup and recovery of MS SQL server by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services, Confidential -SQL, Visual Studio 2005/2008, MS Office 2003/2007, SQL Profiler, Windows server 2003.