SUMMARY

• Over 8+ years of experience in Business Intelligence using Tableau 8.0/ 7.0,OBIEE, SSAS, SSRS.
• 5 years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0, 8.1 and 8.2 as a developer and Administrator.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Experienced in Tableau working with different Enterprise Data sources likes SAP HANA, SSAS Cubes, Hadoop HDFS, Oracle Enterprise Servers and the Extracts (auto/incremental).
• Administration, Installation and configuration of a Core Licensed Tableau Server
• Hands - on experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau7.0 to 8.0).
• Extensively worked on tabcmd, tabadmin, creating users, sites and projects in tableau.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Hands-on experience on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Good experience in Cognos 10.2.1/Cognos 10.1 using Business Workspace, Business Workspace Advanced, Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Event Studio, Query Studio, Powerplay Transformer, Powerplay Studio, Cube Designer - Dymamic Cubes.
• Experienced in developing Active Reports and Dashboard Reports in Cognos 10.2.1 and Cognos 10.1.
• Experience in developing standards for Cognos Framework Manager Model and Reports.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good noledge on SQL Server Analysis Services (SSAS).
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong noledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica UNIX, DB2, Oracle and SQL Server technologies.

TECHNICAL SKILLS

OLAP Tools: Business Objects 4.1/4.0/ XI 3.1/ 6.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, CMC, CCM, LCM, Promotion Management Performance Management, Report Conversion tool, Import Wizard, Publishing Wizard, Upgrade Management Tool

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005, MS Access 2000

Data Modeling tools: Star Schema Modeling, Snow Flake Modeling

Programming Languages: C,C++, SQL,PL/SQL

Data Warehousing ETL tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2,SSIS

Visualization Tools: Tableau 8.1/8.0/7/0

Other Tools: SAP BW 7.0, BODS, Toad, Putty, Sub Version, Clear Case Explorer, SAS, OBIEE 10.1.3x/11g

PROFESSIONAL EXPERIENCE

Confidential, Oceanport, NJ

Sr Tableau Developer/Admin

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• TEMPEffectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0.
• Created multiple visualizations like Heat Maps, Bar Graphs, Bullet Graphs.
• Preparing Dashboards using calculations, parameters in Tableau.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Defined best practices for Tableau report development.
• Extensively used data blending, embed functionalities in Tableau.
• Migration of the reports from Cognos 10.1 to Cognos 10.2.1 environments.
• Worked directly with business customers to build reports, dashboards, ad-hoc reports and portals with Cognos 10.2 reporting tools like report studio, query studio and analysis studio
• Created Relational Metadata model using Cognos Framework Manager.
• Creating Public Folders, Private Folders, My pages and custom views in Cognos Connection.

Environment: Tableau 8.0, OBIEE 10.1.3.4.1, Oracle10g/9i, OBI11g, Cognos BI 10.2/10.1

Confidential, Plano, TX

Sr. Tableau Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau and Xcelsius.
• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• 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.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Creating reports using Webi (Web Intelligence) and Deski (Desktop Intelligence) using Business Objects XI R2 and R3.
• Develop Ad-hoc Business object reports according to user’s requests.

Environment: Tableau, Tableau server, CrystalReports, Xcelsius 2008, Web Intelligence 4.1/4.0/3.1, MS Excel, SQL Server, HANA DB.

Confidential, Illinois

BI/Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we has most users vs. least users.
• Worked closely with business power users to create reports/dashboards usingtableaudesktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled the performance issues TEMPeffectively.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Environment: MS SQL Server 2005, 2008 SQL BI Suite (SSIS, SSRS), MS Access 2003 & Windows Server 2003, Oracle, MS Visual Studio.

Confidential, Chicago, IL

SQL BI Developer

Responsibilities:

• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Interacted with development Teams and Managers to analyzed business needs and developed technical specifications.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Created database objects like Stored Procedures, Views, User defined functions and Indexes.
• Worked on Joins and sub-queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Performed source system analysis and development of ETL jobs to migrate data from the Source to the target data warehouse.
• Responsible for moving data from SQL Server 2005 to SQL Server 2008.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Developed SSIS Packages using look up values & implementing rules provided by Business in the mapping document.
• Used Configuration Files in SSIS to ease the process of moving the packages across servers.
• Maintained data integrity by performing validation checks.

Environment: MS SQL Server 2005, 2008 SQL BI Suite (SSIS, SSRS), MS Access 2003 & Windows Server 2003, Oracle, MS Visual Studio.

Confidential

SQL Developer

Responsibilities:

• Participated in development efforts to analyze client server applications using Visual Basic 6.0 as front-end tool and MS SQL Server Database.
• Actively involved in analyzing the old database system and creating an environment and performed mappings to SQL Server 2005.
• Designed ER diagrams and mapped the data into database objects.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XML).
• Involved in converting existing PL/SQL stored procedures, triggers, functions and script to T-SQL.
• Designed, Implemented, Maintained OLAP servers and processes to replicate production data to the server.
• Involved in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Performed data extraction from OLTP to OLAP for decision making using SSIS.
• Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Provided documentation on current database environment and as well on the structure that needs to be modified in the future for better performance of the system.
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
• Deploying SSRS Reports across multiple environments including Test, Production and supporting environments.
• Scheduled Reports based on a particular Day and sent them through Email in required format.
• Worked in the complete life cycle of the project, from the beginning me.e. Planning Stage to final me.e. giving the codes to production side.

Environment: MS SQL Server 2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Data Analyzer, Visual Studio 2005, Advanced Windows 2000 Server, Erwin 4.0, Business Objects 6.5/ XI, VB Script

Confidential

Jr. SQL Analyst

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created ad-hoc reports for the upper level management using Stored Procedures and MS SQL Server 2005 Reporting Services (SSRS) following the business requirements.
• Created reports by dragging data from cube and wrote mdx scripts.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, VBS.