SUMMARY

• Around 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Over 3+ years of working experience with Tableau Software as a dashboard developer.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle),Teradata, Mainframes, MS Access and client/server applications.
• Extensive experience creating canned and ad-hoc reports in Tableau Desktop.
• Involved in creating dashboards and reports in Tableau 8.2. Created report schedules on Tableau server
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked extensively with the major functionality of BO like breaks, alters, filters, sorts, query Prompt and Drill filters.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mark Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Improved Reports performance in tableau using extracts and context filters.
• Deploying and scheduling Reports to generate all daily, weekly, monthly and quarterly Reports including current status.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• 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.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.
• Hard Worker, Smart learner, Team player and can motivate team to accomplish deliverables.

TECHNICAL SKILLS

BI Tools: Tableau8.0/8.1/8.2

Relational Database: MS SQL Server, Oracle, Teradata, MS Access.

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio

Languages: SQL, PL/SQL, HTML, XML

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7

PROFESSIONAL EXPERIENCE

Confidential, WI

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, and delivery.
• Worked closely with expert level professionals to create reports/dashboards using tableau desktop.
• UsingTableauDesktop created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues withinTableau Server and Reports
• Created trend lines, analyzed the residuals and forecasted the sales of the products.
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in regional analysis of products and brands across the segment using mapping.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.

Environment: Tableau 8.1/8.2, Teradata, Teradata SQL Assistant, Teradata Administrator, Business Objects, SQL, PL/SQL, MS Project.

Confidential, MI

Tableau Developer

Responsibilities:

• Involved in Installation and configuration of Tableau Software. Have also configured distributed installation of Worker Servers for production environment.
• Created Users, groups and Domains from Active directory and created different License level for each User on Tableau Servers.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.
• Analyzed the performance of different products across various locations.
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by products and by segments, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Good Experience in publishing reports and dashboards to Tableau server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different formats.
• Involved in analysis of Key Performance Indicators (KPI's).

Environment: Tableau 8.0/8.1, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel.

Confidential, St Louis MO

Tableau Developer

Responsibilities:

• Gathering business requirements from various users of different Departments.
• 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.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.

Environment: Tableau Desktop 7.0, Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007,MS Access, Windows 2007 server, Teradata, Microsoft office 2007.

Confidential, Northbrook, IL

SQL Server Developer

Responsibilities:

• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Transferred flat files from different sources to the Staging Area by using SSIS and executed BCP from a package to import all files to pre-staging database.
• Worked on different kinds ofTransformationsinSSISas per the client requirements.
• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key to streamline the process of replication.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
• Understanding the OLAP processing for changing and maintaining the Data Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on the business requirements to change the behavior of the cube by using MDX scripting.
• Worked with database designing physical and logical database design.
• Coordinated with back-end programmers in optimized stored procedures, implemented referential integrity by using triggers, worked on performance tuning.

Environment: SQL Server 2005, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, SSAS.

Confidential

SQL consultant

Responsibilities:

• Involved in logical modeling and physical modeling of the database.
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Implemented the business logic and processing of the payment by developing stored procedures and scripts.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Environment: MS SQL Server 2000, T-SQL, Visual Basic 6.0 and windows NT.

Environment: SQL Server 7.0/2000, T-SQL, VB 6.0, Windows NT/2000 server.