SUMMARY:

• Over 5 years of Data warehousing experience with Business Intelligence Tools Tableau 8.2/8.1/8.0/7.0 , OLTP and OLAP Microsoft SQL Server, Microsoft Excel as Developer in various companies.
• Proficient in Tableau 6.x/7.x/8.x Desktop, Server, SAP Business Objects and SSRS.
• Extensive exposure to different phases of SDLC process starting from analysis through evolution in Banking, Retail and Telecom Domain.
• 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.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Participated in Tableau 9.0 Beta release both in Tableau Desktop and Tableau Server
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities
• Outstanding knowledge in Microsoft Office suite MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio.
• Experience setting up and managing Tableau Server with large volumes of data.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Fulfilling daily DBA activities like: setting up user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.) and Disk space management (Table space, rollback segment).
• Experienced in writing SQL queries, PL/SQL Collections and Exception Handling, understanding requirements and developing plans.

KEY SKILLS:

Visualization Tools: Tableau 8.2/8.1/8.0/7.0 , Tableau Server

Programming Languages: C, C++, SQL, MySQL, PL/SQL, Core Java, SAS, MATLAB

Web Programming: HTML CSS, JavaScript

Database: Oracle SQL Developer, Toad, Microsoft SQL Server 2005/2008, SSIS, SSRS, MS Access

Operating System: Windows 95/98/2000, Windows XP Professional, Windows NT, UNIX

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Requirements Management: Requisite Pro, Microsoft Office Word, PowerPoint Excel

PROFESSIONAL EXPERIENCE:

Confidential

Tableau developer, Columbus, OH

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Converted existing BO 5x reports into tableau dashboards
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed donut charts for analyzing sales planning data.
• Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Parameters and Actions
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Published and shared views on Tableau server.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Ability to work effectively in team environment and interact with all levels of management

Confidential

Tableau developer, Columbus, OH

Responsibilities:

• Created dashboards for analyzing POS data using Tableau 8.0 on top of SAP HANA.
• Developed dashboards for POS use cases to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting and cannibalization.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.
• Extensively worked on different types of filters.
• Created custom Function's Date range, Time functions, Logical functions in the reports.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.
• Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Consistently attended meetings with the client subject matter experts to understand functional business requirements.
• Provided user trainings on the key dashboards
• Provided detailed documentation on the Analytical deliverables
• Used Industry standard design templets for POS use case analysis.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience with creating Worksheets and Dashboard.
• Experience with Tableau for Data Acquisition and data visualizations.

Confidential

Tableau/sql developer

Responsibilities:

• Devised simple and complex SQL scripts to check and validate Data flow in various applications.
• Performed Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through use of ETL tools such as Informatica.
• Devised PL/SQL statements - Stored Procedures, Functions, Triggers, Views and packages. Made use of Indexing, Aggregation and Materialized views to optimize query performance.
• Created Tableau dashboards/reports for data visualization, Reporting and Analysis and presented it to Business.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Knowledge in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Involved in analysis, design, development, and testing of the application.
• Developed PL/SQL batch processing jobs using UNIX Shell scripting.
• Involved in writing PL/SQL, stored procedures/packages, triggers, constraints, cursors, views and indexes using TOAD.
• Used forms and Reports 6i that would meet the needs of users and that show the Monthly transactions.
• Proficiency in understanding clients’ needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications.
• Experienced in using Oracle Utility programs like SQL*Loader and External Tables.