SUMMARY:

• 8+ Years of overall expert level experience in Data Visualization and Business Intelligence.
• Analysis, Development, Testing and Implementation of dashboards, scorecards, analytical reporting using Tableau.
• I have extensive knowledge of Designing, Administration, Analysis, Order Management, Customer loyalty analytics, including needs assessment, business process flows, Analytics repository management, Administration and the development of custom modules for the Business Intelligence Data Warehouse using Tableau, Oracle Business Intelligence Enterprise Edition and Informatica.
• Strengths Include: Teamwork, Multi - tasking, and Delivering high quality results; organized, goal- oriented and sociable.
• Proficient in Data Visualization development using Tableau to create complex and innovative dashboards.
• Experience in Data Modeling, Data Mapping, ETL Development, Metadata Management and Reporting Solutions.
• Experience in extracting and combining Data from different Data sources, different Databases and Data warehouses.
• Extensive experience in Tableau Desktop workbook, reports and dashboard design and Tableau Administration/Server, troubleshooting, user / group setup, permissions and security roles.
• Designed and deployed dashboards, reports with drill down, drill through and Drop down menu option.
• Worked with Calculations, Parameters, Background images, Maps, Forecasted reportsandAdvance Analysis Actions, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Strong understanding of Business Processes with good experience in development of various types of reports like Crosstabs, Lists and various Charts.
• Extensively Used Data Blending to Join Multiple Data Sources and Rendering the data to Tableau for Visualization.
• Experience in writing complex Formulas, Reports, Summary Reports.
• Conceptual knowledge of Tableau architecture including VizQL Server, Application Server Data Engine and Data server.
• Excellent data skills, including the ability to analyze, visualize, and present data in a clear and brief manner.
• Enthusiastic team player, with excellent interpersonal and communication skills and capable to work in a team as well as individually.
• Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
• Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.
• Performed data analysis and data profiling using SQL on various sources systems including SQL Server 2008.
• Extensive knowledge and experience in producingtables, reports, graphs and listings using various procedures and handling large databases to perform data manipulations.
• Experience in Defining, Designing, Integrating and Re-engineering the Enterprise Data Warehouse and Data Marts in different environments with multiple Terabytes of size and various levels of complexity.
• Good understanding of Project Management Methodologies and SDLC.
• Experience in data warehouse development practices and processes.
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modelling.
• Experience in ETL design (from staging to presentation layer) using Informatica.
• Experienced in building Data Marts, Data Structures, Data Warehouses, data archives, and data analysis.
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Experience in UNIX shell scripts to write scripts to call ETL Jobs.

TECHNICAL SKILLS:

Data Visualization/BI Tools: Tableau 9.x/ 10ETL Tools:Informatica Power Center 9.x/10

Databases: Oracle 10g/11g/12c, MS SQL Server

Programming Languages: SQL, PL/SQL

Big Data Ecosystem: HDFS, Map Reduce, Sqoop, Pig and Hive along with UDFs

Software Tools: MS Office Suite (PowerPoint, Excel, MS Visio, MS Project, SharePoint)

Functional Skills: Financial, Sales & Marketing, Health Care, Event Survey

PROFESSIONAL EXPERIENCE:

Confidential, Palo Alto, CA

Tableau Developer

• Interacted with the customers and business analyst to assess the requirements and needs, performed impact analysis and documented.
• Involved in reviewing business requirements and analyzing data from different sources such as Excel, CSV, Oracle SQL and SQL Server.
• Good knowledge on Data Mining and conducted File processing (Converted Text Sources into database after completing spell check), Text Parsing (Handled multiword terms, equivalent terms and entities) and Applying List (Created and applied lists like start list, stop list and synonym list).
• Good Knowledge on Tableau installation and configuration with Single Server System.
• Created dashboards, reports, analytics and advanced graphical virtualizations by using various reporting objects like Facts, Attributes, Hierarchies, Filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Extensively Used Data Blending to Join Multiple Data Sources.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Experience increating calculated fields, combined field, Bins, Sets, Geo-coding and Hierarchies using Tableau Desktop. Involved in creating a dual-axis bar chart with multiple measures.
• Created Forecasted Reports for the Upcoming Year to Observe Trends in Tableau.
• Created many Dashboards and KPI reports using relevant Marks or Highlight functionalities.
• Experience in performance tuning in tableau to improve report response time.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule and checking the tasks daily on the server.
• Monitored VizQL server, Application Server and Data Server activity to track performance and system stability.
• Prepared and documented theMeta data to make sure users understand.
• Worked with users to address issues/question and assist them to understand the Tableau reports.

Environment: Python, R, Tableau Desktop 9.x, Tableau Server 8.x/9.x, MS Excel, MS SQL Server 2012 R2, Tableau Data Extract (TDE)

Confidential, Milpitas, CA

Tableau Developer

• As a Tableau Report Developer, primary role is to understand data and put it into a way that Tableau likes; understanding what the needs are and basically reverse engineering.
• Building the Data Mining Database - Collected data from different data source, eliminated irrelevant and unneeded data, interpreted the missing value using k-nearest.
• Using systematic sampling, prepared data for modeling by selecting variables and selecting rows.
• Understanding the problem being asked so that Tableau can be configured to visualize an answer.
• Developed the database structure and also contributed extensively in writing queries that perform DDL and DML.
• Brainstorm ideas on what to include in Views/Dashboards from the data source and document on the fly business requirements.
• Examined reports and pitched ideas for creating new Reports/Dashboards for better analysis of data.
• Created document for visualization best practices and report and dashboard design.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with Calculations, Parameters, and Date functions.
• Performed ETL and was involved in the entire warehouse development cycle.
• Experience with creation of Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau server logons andsecurity checks as Tableau Administrator.
• Participated in stakeholder and project review meetings on weekly basis.
• Monitored and worked with the developers to find the root cause of the data related issues.
• Designed and documentedthe test cases for ensuring quality of data and performed thorough validation.

Environment: Tableau 9.x,SQL Server, Microsoft Excel, Microsoft Access, Windows

Confidential

BI Developer

• Experience in installation and Configuration of OBIEE
• Experience in creating and managing repository by OBIEE Repository tool (Oracle Administration tool)
• Develop requirements from the customer perspective: categories of reports, report layouts, scheduling, customization, etc.
• Provided necessary inputs in Star Schema Design.
• Developed the database structure and contributed extensively in writing queries that perform DDL and DML.
• Imported the Physical tables and Keys into Repository and Developed Business Model and Mapping layer,Implemented logical column measures and calculations.
• Extensively involved in developing dashboards by OBIEE Answer.
• Created Time series measures for QTQ, YTY, WTW, YTD, QTD analysis.
• Involved in Analysis, Design, development and customization of Dashboards.
• Configured Prebuilt Oracle Business Intelligence Application.
• Extensively involved in modifying Prebuilt (Oracle BI Analytics Applications) Dashboards and Metadata Repository
• Created Dimensional hierarchies and Level based Measures along withrank measuresin BI Administration Table.
• Experience in using advanced analytics to create valuable Key Performance Indicator (KPI) reports for customers.
• Provide access to various internal and external users with different roles, privileges and access rights to search, pivot and drill down and visualize data.
• Involved in writing complex SQL query to calculate complex result.

Environment: OBIEE 11g on Red Hat Linux, OBI Answers, Oracle Reports, Oracle SQL

Confidential

BI/ SQL Developer

• Wrote complex SQL queries for validating the data against different kinds of reports.
• Worked with Excel Pivot tables.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform data manipulations.
• Experience in rebuilding and transferring new database.
• Created Database Maintenance Plans for the performance of SQL Server, which covers Database Integrity.
• Performed Database Search and Query Strategy design, Implementation, Testing and Optimization.
• Performed Stored Procedures development and testing, as well as Database Report design and implementation.
• Export data in Excelto SQL Server 2008 via DTS.
• Run daily, weekly and monthly reports for management consumption.
• Wrote optimized T-SQL stored procedure to improve performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Identified, Tested and Resolved database performance issues (monitoring and tuning) to ensure data optimization.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Environment: SQL Server, Oracle 10g, MS Excel, CSV, UNIX Shell Scripting