SUMMARY

• Over 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 5.5 years of strong work experience in Tableau desktop/ server with different versions including 6.x to the newest version 9.x.
• Experience in Installation, Configuration and administrationof Tableau Server in server
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Good understanding of Data Modeling techniques employing Normalization and Data Warehouse concepts using Star schema and Snow flake schema modeling, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Extensive experience in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development Life Cycle (SDLC).
• Expertise in Business Objects Life Cycle Management (LCM), moving Universes, Reports, Users, Security using LCM jobs and LCM Version management
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.
• Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues.
• Good knowledge on Data Quality Assessment & Data Cleaner Tool, Data Model Creation, Data Warehouse (Design, Implementation & Support)
• Worked extensively with the major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Apt at writing Data Mapping Documents, Data Transformation Rules and Data Dictionary maintenance, Data Warehousing, Data Migration, and Interface Requirements Documents.
• Outstanding knowledge in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio).
• Provided 24/7 production support for Tableau users.
• Good knowledge on JavaScript API for Tableau and client side scripting for web applications.
• Excellent team player at all levels with ability to perform independently with exceptional communication, analytical, presentation and problem solving skills.

TECHNICAL SKILLS

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling

Data Warehousing ETL Tools: Informatica Power Center Version 8 and 7, Data Cleaner 2.2

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

Database Tools: TOAD, SQL Developer, SQL Plus

Reporting Tools: Tableau 9.0/8.3/8.2/8.1/8.0/7.0 , SAS, OBIEE 10.1.3x/11g, TibcoSpotifreMicro Strategy

Languages: PL/SQL, SQL, Unix shell scripting, Java, C

Web Tools: HTML, DHTML, XML, JAVA SCRIPT

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Others: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE

Confidential, Morrisville, NC

Sr Tableau Developer

Responsibilities:

• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Installed Tableau servers in Dev, QA, UAT and Prod environments. Created users, groups, site roles and permission sets for Tableau server logon.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Responsible for developing databases SQL queries for data analysis and data extracts.
• Responsible for analyzing, debugging and tuning database SQL queries for performance improvements.
• Foundefficientways to make tables and graphs which were visually easy and at the same time maintaining the accuracy of the core information content.
• Designed and developed Tableau visualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, iPhones, and other smart mobile phones.
• Advanced analytics using data blending, context filters, date filters, sorts and analytics and connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that 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.
• 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 at various geographic locations.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• As a Tableau Analyst, using Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also to slice and dice the data, for analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, indicators, and gauges.
• Performance improvement using JavaScript API for creating filters navigation between sheets.
• Converted existing Webi reports, Crystal Reports and Xcelsius intoTableauDashboardsand worked on third party data connectors like Toreo Data connectors to connect SAP BusinessObjects Universes to Tableau and build visualizations.
• Developed and executed the Test Cases (TC) for the requirements as part of the staging and User Acceptance Testing (UAT) environments in RALLY tool to ensure correct functionality is achieved.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Environnent: Tableau Software 8.0, Microsoft office, SQL Server, SharePoint, MS SQL, (Desktop/Agent, Object Manager, WEB, Enterprise Manager) Teradata, Oracle 10g (PL/SQL), Windows 2000 Professional, UNIX

Confidential, San Ramon, CA

Tableau Developer/ BI Analyst

Responsibilities:

• Responsible for designing and developing user interactive dashboards for the financial applications. Enable business users with self-service reporting capabilities and supporting users in building analytical reports using Tableau Desktop 8.x/9.x Financial Reporting and Oracle BI
• Identifying and gathering user requirements and business requirements from different groups, end users for developing reports.
• Designed and developed Tableau Dashboards for critical Projects, i.e. CEO Scorecard & OBIEE to Tableau Reports Conversion. Particularly CEO scorecard, for which the scope of Workbook included 10+ dashboards.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in converting OBIEE content into Tableau BI content.
• Exploring tableau 8.0 features for web editing and authoring, filters and server monitoring.
• Have extensively used Tableau functions like Data Blending, Custom SQL, Interactivity, and Chart types, Navigation, Images and Parameters in this process.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

Environment: Tableau (Desktop/ Server) Oracle SQL Developer, SQL Assistant, HPQC, Oracle 11g, java1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential, Charlotte, NC

Tableau Developer/Data Analyst

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Productionrollover of Reporting and Analysis projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Iidentify new metrics and enhance the existing KPI's.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analyticalreports and dashboards.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic anduser requirement.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial trackinganalysis by 30%.
• Designed new database on SQL server 2008R2.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert.

Environment: Tableau Desktop/Server 7.x, Oracle 11i, Taratata, Windows, Rally, MS Excel, Visio

Confidential, New York, NY

ETL Developer/Data analyst

Responsibilities:

• Creating the SQL queries based on source to target mappings for Target tables.
• Created various Mappings by using different kinds of transformations like Source Qualifier, Expression, Join, Lookup, Filter, Rank, Sequence Generator, Stored Procedure, Router, Normalize, Transformations.
• Worked on SQL for Source overwrite queries to improve performance.
• Used Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and InformaticaPowerCenter.
• Created common reusable objects for the ETL team and overlook coding standards.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Used ETL to extract files for the external vendors and coordinated that effort.
• Migrated mappings from Development to Testing and from Testing to Production.
• Performed Unit Testing and tuned for better performance.
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document.

Environment: Power Center 8.6.1, Flat files, MS Excel Files, MS Access, SSIS 2008, Oracle 9i/10g, Erwin 7.3, PowerDesigner, MS SQL Server 2005/2000, PL/SQL, IBM DB2 8.0, Teradata V2R5, Mainframes, Toad, Perl, Unix scripting, Windows NT, Autosys, Microsoft Project Plan.

Business Analyst / Reports Developer

Responsibilities:

• Assisted the project manager/ lead in defining the project plan, charter, scope and timelines.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interaction with the process owners & SME's and document analysis.
• Created Business Requirement Documents, System Requirements Specification, High-Level Design Document, and Functional Requirement (Technical) Documents according to the User requirements and uploaded the documents in Knowledge Link.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Developed prototype of new information processing application.
• Identified all use case components including basic, alternate and exception flows.
• Worked with the QA Team as a Tester during the test phase, maintained an Issue Track Log to make sure all the issues are addressed played a part in troubleshooting before the QA Analysis.

Environment: Sun Solaris, Windows NT, Oracle 9i, My SQL, JSP, Servlet, MS Office Suite. Micro Strategy, Desktop Report, OLAP Services, Architect