SUMMARY:

• 8 years of experience in Data Visualization, Business Intelligence, Data Warehouse development, Testing and delivery using Tableau, QlikView/Qlik Sense, OBIEE, Business Objects and Informatica.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Data Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong understand in Dimensional Modeling (Star and Snow Flake Schema), Identifying Facts and Dimensions, Physical and logical data modeling using Erwin.
• Highly skilled in Development & Implementation of dashboards, KPI, scorecards, Business Objects Universe build, analytical reporting and Meta data modeling.
• Worked with Calculations, Parameters, Background images, Maps, Forecasted reports and Advance Analysis Actions, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Enthusiastic team player, with excellent communication and interpersonal skills. Can take up individual responsibilities and detailed in the analysis and process optimization.
• Expertise in complete SDLC which involves Requirement Gathering, Proof of concept, Gap analysis, Converting functional to technical Spec, Design, Development, Testing and Implementation.
• 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.
• Participated in SCRUM meetings and JAD sessions worked on designing the functional requirements document.
• Experience serving industrial segments like Finance, Healthcare, Sales and Marketing domains

TECHNICAL SKILLS:

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

ETL Tools: Informatica 9.x, SSIS, SAS and ODI 11g

Business Intelligence: Tableau 10.x/9.x, BO, OBIEE 11g/10g, QlikView, Qlik Sense

Data Modeling: Erwin

Web Technology: J2EE, Servlets, HTML, PHP

Operating Systems: Windows (All platforms), Unix/Linux

Domain Expert: Financial, Healthcare, Sales Ops, Marketing and Non - Profit

Language: R, Java, SCALA

Big Data Technologies: Hadoop, YARN, SPARK, Hive, Pig, HBASE, Zookeeper

PROFESSIONAL EXPERIENCE:

Confidential, Palo Alto, CA

Sr. Tableau Developer

Responsibilities:

• 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 Merging, data Matching, Data Cleaning, Data Blending to Join Multiple Data Sources.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Experience in creating 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 the Meta 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, SSIS, T-SQL, Tableau Data Extract (TDE), OBIEE 11g/12c

Confidential, Milpitas, CA

Tableau/BI Developer

Responsibilities:

• Primary role is to understand data and design & develop the reports and dashboards in Tableau.
• Understanding the problem being asked so that Tableau can be configured to build an analysis.
• Build, test, and deploy controlled releases of new Tableau Dashboards.
• Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
• Examined mockup reports and building the 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.
• 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 documented the test cases for ensuring quality of data and performed thorough validation.
• Interacted with the client and worked onsite to resolve issues and expedite various process in the project.
• Identified cross-functional impacts of systems and process changes.

Environment: Tableau Desktop 10.x/9.x, Online Tableau Server, MS Excel, Oracle 12c/11g, Win Server 2012 R2, OBIEE 11g & Informatica 9.x

Confidential, Palo Alto, CA

Data Consultant/ BI Developer

Responsibilities:

• Interact with the customers and business analyst to assess the needs and requirements, performed impact analysis, described and documented.
• Translate business requirements and business questions into report requirements and visualization dashboards.
• Involved in reviewing business requirements and analyzing data sources for design, development, testing, and production rollover of reporting and analysis project within Tableau Desktop.
• 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.
• Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Analyzed, troubleshoot and / or tune product performance or deployment issues when required.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks as Tableau Administrator.
• Did performance turning in tableau to improve report response time.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Created many Dashboards and KPI reports using relevant Marks or Highlight functionalities.
• Responsible for creating calculated fields, combine 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.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule and checking the tasks daily on the server.
• Prepared metadata and documentation of data sources to make sure power users understand metadata.
• Responsible for Training 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.
• BO Universe design, Web Intelligence, Dashboards/reports
• Migration from BO dashboards/reports to Tableau Dashboards/reports

Environment: Tableau 8.0/7.0, BO, Oracle 12c, Microsoft Excel, ODI 11g, SAS, Health Buddy System (HBS) & Windows.

Confidential, CA

BI Developer

Responsibilities:

• Coordinate with ETL & Reporting team to implement all procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
• Collaborate with Metadata Manager and perform tests and provide update to all activities within schedule and provide support to all large data volumes and assist in data processing.
• Collaborate with all developers and business users to gather required data and execute all ETL/BI programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
• Analyze and interpret all complex data on all target systems, Analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements.
• Provide analysis, design leadership consulting services to BI core product line clients.
• Identify new reporting techniques, data collection sources and constraints of developing business.
• Contribute to BI technical design sessions and data modeling efforts and Assist EBIS team to deliver assigned projects on time.
• Maintain all technical and system specifications documents for all ETL processes, reporting system and business intelligence solutions and perform unit tests on all processes and prepare required programs and scripts.
• Develop all data warehouse models and prepare reports for all Metadata integration into systems and draft all ETL/BI scripts and prepare required reports for all end users.
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL/BI applications.
• Develop and perform tests on all ETL codes for system data and analyze all data and design mapping techniques for all data models in systems.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.

Environment: ETL tool used is SSIS 2008 r2 installed on Windows Server 2008 r2, Oracle EBS built on Oracle 11g. Reporting tools used are Tableau8.0. All Development, QA, Production environments are built on Windows Server 2008 r2.