SUMMARY

• Around 8 years of IT experience in Data Visualization/Database Design and ETL wif 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 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.
• 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 teh extracts in Tableau from various source files including flat files, excel sheets, Access files and different databases.
• Hands - on wif 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 teh 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 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.
• 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:

• Gatheird Business Requirements, interacted wif teh Users, Project Manager and SMEs to get a better understanding of teh 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 teh Project Monitoring Report data.
• Upgraded Tableau Desktop and Server Environments to V9.2, V10.0 from 8.2.
• Managed teh application’s, users, groups wif active data directory.
• Focused on continuous improvement in teh 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 dat specifically met client investment objectives.
• Used Tableau to compare teh percentage of disbursements of active projects against teh historical 10 year disbursements of projects.Extensive experience in using all Level of Detail (LOD) expressions like Include, Fixed and Exclude to create visualizations dat are different TEMPthan teh view level or visualizations level of detail.
• Used Tableau Data blending feature to combine data from EDW wif teh 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 teh 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 teh data on teh fly wif teh usage of quick filters for on demand needed information.
• Used Parameters to hide/show sheets based on teh parameter drop down to display teh 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 teh pages feature to show teh evolution of projects disbursements over time.
• Participated in meetings, reviews, and user group discussions as well as communicating wif stakeholders and business groups.
• Created compound calculations to shape teh 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 teh business requirements and if their 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 teh 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 teh 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 teh data.
• Gatheird user requirements, analyzed and designed software solution based on teh requirements.
• Experience wif creation of users, groups, projects, workbooks and teh 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 wif aesthetic approach, while at teh same time retaining teh accuracy of teh core information content dat 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 teh same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between teh views on teh sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing teh 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 dat 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 teh dimensions, hierarchies, and levels on Tableau desktop.
• Experience in development of MDX queries to extract and modify teh data from Multi-Dimensional data sources (Cubes).
• Responsible for Developing a Dashboard and preparing ad-hoc Reporting. Professional interaction wif 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 wif business stakeholders to understand their decision-making parameters, analyzing teh available data to build Tableau Dashboards and managing teh delivery.
• Worked extensively in resolving teh data issues post development and communicated wif teh source system teams to ensure teh data consistency.
• Used Data Blending, groups, calculated fields and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Worked on teh Location Analysis Dashboards using Tableau wif complex drill down charts, pie charts, and stacked column charts etc.
• Created, Maintained & scheduled various reports in Power BIlike Tabular Reports.
• Involvement in teh ETL high level design and development for processing fact and dimension tables for teh effective use in Cognos Framework Manager.
• Developed and assisted teh team in creating List Reports, charts, Drill-through reports and Master-Detail reports using Cognos Report Studio.
• Created Dashboards for teh business needs using Drill Through, Cross Tab report, Charts, JavaScript (in teh 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 wif 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 wif 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 teh 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 wif teh business users to understand teh needs and develop requirement documentation.
• Involved in requirements gathering, analysis, and functional specification documents.
• Installation and configuration of Cognos 8 BI and worked wif 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 wif 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 wif Clients for feasibility study of teh project in Tableau and drawing up teh timelines as per project requirement.
• Created teh tooltip to display teh information for CTQ values, number of surveys and moments.
• Created different views using Tableau Desktop which were published to teh 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 teh SAP BW data sources using teh Tableau BW connector.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate teh 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 teh SQL Scripts for report development, Tableau reports, Dashboards and handled teh 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 wif 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 teh database, troubleshooting, memory management.
• Maintained databases wif 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 teh different reports for teh analysis from dat servers.
• Generated Ad-Hoc reports as per teh client requirements using Report Builder.
• Generated various SSRS Reports based on requirements.
• Extensively involved in teh SSAS storage and partitions, and aggregations, calculation of queries wif 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 teh 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 teh 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.