SUMMARY

• Around 8 years of IT experience in Data Visualization/Database Design and ETL with extensive Data Warehousing knowledge across Pharma, Financial and Retail industries.
• Over 4+ years of extensive experience as Tableau Developer/BI Analyst in Design, Development, Testing and Documentation implementation of Cognos applications.
• Experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 10.X/9.x/8.x/7. x
• Extensive experience working with Cognos 10.x/8.x Business Intelligence Reporting Suite (Framework Manager, Event Studio, Report Studio, Query Studio, Transformer, Dynamic Cubes, Workspace, Workspace Advanced.
• Extensive experience as Tableau Admin in installation, Migration, configuration, Patching and upgrading of Tableau tool across all environments.
• Experience in Creation of Models, Project and Publishing Packages using Framework Manager and created IQD’s in Framework Manager to use in Cognos Transformer using externalized method also in Cognos Data Manager.
• Experience in creating the extracts in Tableau from various source files including flat files, excel sheets, Access files and different databases.
• Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in all Tableau Desktop versions.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• 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.
• Deliver advanced/ complex reporting solutions such as KPI Dashboards and Standardized Reporting (including the bursting of reports globally) using Cognos Active reports.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity. Creating users, groups, projects, site roles, publishing workbooks to tableau servers.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau.
• 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 with HTML or Asp.Net.
• Experienced in Installing, Configuring, Monitoring Hadoop cluster.
• Excellent understanding of Data modeling OLAP &OLTP on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).
• 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.
• Hands on experience in business process engineering and all phases of SDLC.
• Experience in writing complex SQL queries to perform End-to-End ETL validations.
• Quick learner, excellent communication skills and good performer both in team and independent job environments.

TECHNICAL SKILLS:

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/2005, Oracle 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.

Languages/ RDMS: 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, Washington, DC

Sr Tableau Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Process.
• 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.
• Upgraded Tableau Desktop and Server Environments to V9.2, V10.0 from 8.2.
• Managed the application’s, users, groups with active data directory.
• Focused on continuous improvement in the areas of fixed income trading, credit modeling and monitoring systems and research new investment ideas. present and execute in-depth Fixed Income guidance strategies and constructed fixed income portfolios that specifically met client investment objectives.
• 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 with the historical population patterns of Latin American countries
• 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 with the usage of quick filters for on demand needed information.
• Used Parameters to hide/show sheets based on the parameter drop down to display the needed KPI’s such as (# of Outputs achieved, # of days from Eligibility date, # of days from Effective date etc.)
• Worked on creation of sites, Projects, workbooks, user groups and assigning appropriate permission sets forTableauserver logons and security checks.
• Extensive knowledge in all types of aggregations like Sum, Average, Count, Count (distinct), Median, Minimum, Maximum, Percentile and Std.Deviation etc.
• Used the pages feature to show the evolution of projects disbursements over time.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Created compound calculations to shape the data and build filters, advanced reports using diversified charts and dashboards visualizations.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc.
• Working experience in writing Sqoop queries for transferring bulk data between Apache Hadoop and structured data stores
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Rewrote poorly performance stored procedure, functions, triggers, views and indexes.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.

Environment: Tableau 10.1/9.2/8.0 , Tableau Server, SQL Developer, Hadoop, Windows XP, Windows 7, MS-SQL 2008 R2, MS Excel.

Confidential, Princeton, NJ

Tableau Developer

Responsibilities:

• Expertise in the design and development of Tableau visualization solutions. Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created many dashboards for decision making purpose and made KPI’s (Key performance indicators) such as employee safety indicators and environmental indicators.
• Created dashboards to analyze Economic indicators such as sales, net earnings and advertising costs.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used good designing skills to make graphs and tables visually appealing with aesthetic approach, while at the same time retaining the accuracy of the core information content that is being communicated.
• Worked on drill through reports by creating HTML s.
• 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.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Good understanding of Hadoop Architecture and its ecosystem components such as HDFS, Map reduce, Pig, Hive, Oozie, Flume, Zoo keeper.
• Hadoop Cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting.
• Connect to Oracle directly using OCI, created the dimensions, hierarchies, and levels on Tableau desktop.
• Experience in development of MDX queries to extract and modify the data from Multi-Dimensional data sources (Cubes).
• Responsible for Developing a Dashboard and preparing ad-hoc Reporting. Professional interaction with a diverse group, including executives, managers.

Environment: Tableau Desktop 9.0/8.0 Tableauserver / Administrator, SQL developer, SQL 2008, Oracle 10g, Hadoop, Pig, Oozie Microsoft Excel 2007, Microsoft office 2007

Confidential, Confidential, MD

Tableau Developer

Responsibilities:

• Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Worked extensively in resolving the data issues post development and communicated with the source system teams to ensure the data consistency.
• Used Data Blending, groups, calculated fields and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Worked on the Location Analysis Dashboards using Tableau with complex drill down charts, pie charts, and stacked column charts etc.
• Created, Maintained & scheduled various reports in Power BIlike Tabular Reports.
• Involvement in the ETL high level design and development for processing fact and dimension tables for the effective use in Cognos Framework Manager.
• Developed and assisted the team in creating List Reports, charts, Drill-through reports and Master-Detail reports using Cognos Report Studio.
• Created Dashboards for the business needs using Drill Through, Cross Tab report, Charts, JavaScript (in the report studio)
• Designed and developed Tableau visualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Provide future forecast analysis and identify past trends for different investments and market segments.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementationproject, design and develop visualizations.
• Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Develop Scripts to load data into tableau and work with multiple data by data blending.
• Use of excel sheet, flat files, CSV files to generate Tableau reports.
• Generate context filters and use performance actions while handling huge volume of data.
• Create complex reports using multiple queries and sub queries.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Co- ordinated Tableau TWBX files till UAT/Production environments.
• Worked with end users in creating complex dashboards in an iterative process.
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Desktop 9.0/7.0/8.0, Tableau Server 7.x/8.x, Business Objects, Excel, SQL developer, SQL 2008, Windows.

Confidential, Houston, TX

Cognos /Tableau Report Developer

Responsibilities:

• Proactively communicated with the business users to understand the needs and develop requirement documentation.
• Involved in requirements gathering, analysis, and functional specification documents.
• Installation and configuration of Cognos 8 BI and worked with Cognos 8 BI Framework Manager for modeling, Report Studio.
• Analyzing and reviewed business requirements and Technical Specifications for Report development.
• Incorporated different reporting functionalities such as Master Detail, Cascading prompts, Drill down, Drill-Through and Conditional formatting into multiple reports.
• Involved in performance tuning of complex reports and analyzed Cognos SQL with native SQL.
• Created and modified dashboard reports for business managers.
• Developed Complex reports which services multiple business requirements in a single report.
• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines as per project requirement.
• Created the tooltip to display the information for CTQ values, number of surveys and moments.
• Created different views using Tableau Desktop which were published to the business stake holders for analysis and customization using filters and actions.
• Created various data connections from data source to Tableau Server for report and dashboard development.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Connected to the SAP BW data sources using the Tableau BW connector.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending, filters, actions, Hierarchies feature in Tableau.
• Good experience in creating Business Objects Universe.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.

Environment: Cognos BI Suite 8.4.1, Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Query Studio, Tableau Server 7.1/8.1.2, Oracle10g, PostgreSQL, Excel, SQL developer, Windows.

Confidential

SQL Developer

Responsibilities:

• Developed SQL queries to Insert, Update and Delete data in Database.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks).
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Setup and maintained Linked Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Generated various SSRS Reports based on requirements.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

Confidential

SQL Developer

Responsibilities:

• Involved in developing & modifying SQL and PL/SQL tables, packages, functions, procedures.
• Cursors, collections, PL/SQL tables, views, indexes and database triggers.
• Involved in product implementation for various financial organizations.
• Coded PL/SQL scripts to implement triggers and functions for various packages.
• Involved in data migration from Flat files (.csv, .txt) into respective Oracle Database tables using SQL*Loader Scripts.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Created DTS packages to transfer objects from development server to production.
• Used dynamic SQL statements for run time SQL Query processing.
• Developed reports using XML/BI publisher.
• Tested SQL code and PLSQL and wrote indexes for efficient execution.
• Setup testing for module and integration settings.
• Documented the work by creating various manuals for by future testers and users.
• Used TOAD for faster and efficient code and application development.
• Used External tables to query the data from oracle tables.
• Performed Unit testing on reports and queries.
• Worked on Production support, bug fixing and enhancements.
• Provided additional technical support, performed test setups and troubleshooting for applications.

Environment: PL/SQL, SQL*Loader, SQL 2008, UNIX, Oracle 8i, Toad, XML/BI Publisher, MS Excel.