SUMMARY

• Having 6+ years of experience as an IT professional including 5+ years of experience in Data warehousing and Business Intelligence technologies using Tableau.
• Expertise in Tableau 10.x, 2018.x, 2019.x Business Objects 4.0, 4.1, and Business Intelligence 7.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Hands on experience on Tableau Desktop versions 7/8.2/10.x, Tableau Reader and Tableau Server.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Integrated custom visuals based on business requirement using power BI desktop
• 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.
• Expertise in building BI components like Info objects, data sources, Info cube, DSO, Transformations, Data Transfer Process DTP, Multi providers and Master data Info Objects, Transfer Structures, Transfer Rules and Update Rules.
• Converting all operational excel report into Power BI Reports.
• Developing compelling and interactive analysis reports and dashboards for Credit Card Marketing analytics using advanced DAX..
• Expertise in front-end Components like BEx Queries, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Worked on User exits for various variables.
• Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast paced environment.
• Communicate effectively with colleagues and business users.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop v 10.x, 2018.x, 2019.x Tableau Server 10.x, 2018.x, 2019.x,Power BI, Cognos, Crystal reports XI/2008, Business Objects XI 4.x, BO Universe Designer, BO Web intelligence.

Databases: MySQL, MS SQL Server, Hive, Hadoop, Impala.

ETL Tools: Informatica, SSIS

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes,OpenProj, JIRA

Programming Languages: SQL, PL/SQL, HTML, Java/J2EE, ASP.net

Document Management: Documentum, Sharepoint, Ultra Edit

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile)

Data Modeling: Power Designer, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr Data Analyst

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Provide guidance to IT Infrastructure and Application teams on Architecture’s Frameworks, Patterns, Best Practices, and Programming concepts.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards.
• Created different KPI using calculated key figures and parameters.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Maintain the integrity of development work and underlying data through the use of version control systems.
• Assess performance, reward results, motivate and foster matrix management.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• 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.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau Desktop 2018.x/2019.x, Cognos 6, MS SQL Server 2008 R2, SQL Server Management Studio, MS Excel, Tableau Data Extract (HYPER), MS Access, Tableau Server 2018.x/2019.x, SSIS.

Confidential, San Ramon, CA

Data Analyst/Tableau / Power BI Developer

Responsibilities:

• Created dashboards for analyzing POS data using Tableau 10.x.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Scheduled extract refresh for weekly and monthly reports.
• Worked on workbook Permissions, Ownerships and User filters.
• Design and develop of reporting data module for Credit Card Marketing Analytics.
• Developed Up-selling and Cross-selling reports using DAX functions.
• Creating Row level security with power bi and integration with power bi service portal.
• Developed profit analysis reports and dashboards by products and customers
• Worked on all types of transformations that are available in Power bi query editor.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Created reports using time intelligence calculations and functions.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Executed dashboard setups and data manipulation using DAX.

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, IL

Tableau Developer/Admin

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.
• Extensive experience in Tableau Desktop workbook design, reports and dashboard design and Tableau Administration/server includes technical support, troubleshooting, user / group setup, permissions, security roles and monitoring of system usage.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.

Environment: Teradata, Hadoop, Business Rules Engine, Google Query, MS Visio, and MS Excel, Tableau 10x version (Desktop and Server).