PROFESSIONAL SUMMARY:

• Overall 4 Years of IT experience including both the functional and technical sides of Data warehouse engagements, and Business Intelligence Tools like Tableau Server/Desktop, Cognos, SSIS/SSRS, Erwinand ETL tools like Informatica.
• Extensive working knowledge on operating systems like UNIX, Linux, HP - UX, AIX and windows.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboardsin various versions ofTableau 9.x/8.x/7.x.
• 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.x/9.x.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Creating Static Reports using MDXqueries and creating MDXBase Report Definition.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Involved in Tableau Desktop 7.0 to 8.0/Server Upgrades/Patch upgrades and involved in maintaining Tableau Server Activities.
• Proficient in Building compelling, interactive dashboards inTableauthat answer key business questions.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Utilized MDXscripts for querying the data from OLAP cubes (SSAS), and built reports on top of cubes.
• Effectively used data blending feature inAlteryxto combine the data from different sources like SAP Lynx, Vision etc. into a single report.
• Professional in communicating Dashboards perTableauvisualization features.
• Involved inTroubleshooting, Performance tuning of reportsand resolving issues withinTableau ServerandTableau desktop report.
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• 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.
• Sound knowledge of Data Warehouses and ETL/OLAP processes.
• Oversee Tableau/Alteryxon-boarding process, deliver, consultation and support services.
• Experience in Query optimization/Performance tuning using Explain Plan command.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Proven abilities in creating complex reports by linking data from multiple data sources, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Proven ability to deliver and ensure success in high-pressure/high-risk situations.
• 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.
• Provided24x7 support for production servers.

TECHNICAL SKILLS:

BI Reporting Tools: Tableau Desktop/Server 7.x/8.x/9.x, Cognos, SSIS/SSRS, Informatica, Erwin

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

Application Servers: Web logic, Web Sphere, Tomcat

Operating Systems: Unix, Linux, HP-UX, AIX, Solaris

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

Programing Language: C#,HTML,SQL,PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Tableau Developer/ Data Analyst

Responsibilities:

• Developed logical data models and physical database design and generated database schemas using Erwin.
• Coordinated with DBA to create best-fit Physical Data Model from the Logical Data Model using Erwin.
• Generated DDL (Data Definition Language) scripts using Erwin and supported the DBA in Physical Implementation of data Models.
• Reverse Engineered the existing Stored Procedures and wrote Mapping Documents for them.
• 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.
• Created dashboard-using parameters, sets, groups and complex calculations.
• Written MDXqueries to create new measure with rebuilding cubes.
• Used MDXqueries to create the filters and parameters according to the requirement
• Very good experience in integrating R, Alteryx and SAS with tableauand build the reports.
• Good Knowledge on Tableau installation and configuration with Single Server System1
• 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.
• Created calculated measures and dimension members using multidimensional expression (MDX),mathematical formulas, and user-defined functions.
• 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 many visualizations like filled maps, geo maps based on dimensions and measures, which give 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.
• Involved in creating a dual-axis bar chart with multiple measures.
• Implemented data blending to blend related data from different data sources.
• Responsible for endclient users onTableauDesktop by providing systematic guidancefrom basics to advanced functions ofTableauincludingworking with calculations,parameters, and date functions.
• Performed data analysis and data profiling using SQL queries on various sources systems including Oracle, SQL Server and DB2.
• Modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Defined ETL framework, which includes load pattern for staging and ODS layer using ETL tool, file archival process, data purging process, batch execution process.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and session.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.

Environment: Tableau V 9.0 (Desktop, Server, Reader),Alteryx,Ervin, Oracle, DB2, SQL Server, PL/SQL, TOAD

Confidential

Tableau 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 stakeholders for analysis and customization using filters and actions.
• 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, 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

BI Developer/Tableau 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 T-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, T-SQL, Windows 7, Enterprise Manager, SQL Server Management Studio, Microsoft Excel.