BHAWANA KUMAR adbgbe@r.postjobfree.com 971-***-****
PROFESSIONAL SUMMARY:
•Extensive experience in Data warehousing and Business Intelligence technologies across various domain using Tableau Desktop, Tableau Server, Business Objects reporting suite.
•Experience in interacting with Business Users in analyzing the Business Process requirements and transforming them into documenting, designing, and rolling out the deliverables
•Strong Dashboard design experience and passionate practitioner of effective data visualization.
•Mastered the ability to design and deploy rich Graphic Visualizations Parameters using Tableau.
•Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
•Responsible for Client Delivery and Solution Design.
•Monitored, reviewed and suggested corrections for the reports developed by team.
•Expertise in data cleansing for analysis, perform data quality testing.
•Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
•Also, used various versions of Tableau Reader, Tableau Public, and Tableau Server along with Tableau Desktop.
•Produced attractive visuals/dashboards to convey the story inside the data.
•Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
•Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
•Have been working with various data sources
•Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
•Created Tableau Data Extracts for making visualizations perform better.
•Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server
•Mastered using Filters, sorts, groups and Sets, reference lines in different kinds of charts.
•In depth knowledge in Tableau advance analysis features like Actions, Calculations, Parameters and Trend lines.
•Designed and deployed reports with advanced features such as drill down, drill up and drop down menu options and parameters.
•Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and keen to learn.
•Capability to tell a story through dashboards using various sets of data.
•Strong analytical, logical, communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
•Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
•Involved in Gathering/ analysis, Design, Development, Testing and Production rollover
•Experienced in Retail data to project important KPIs and metrics for business
•Good knowledge and hands on experience in Metric Insights
TECHNICAL SKILLS:
Operating System
Windows 98 / 2000, Windows XP
BI/Visualization Tools
Tableau Desktop, Tableau Public, Tableau Reader, Tableau Server
Programming Languages
TABLEAU, SQL, PL/SQL
Databases
MS Access, Amazon Athena, Snowflake
Application Software
MS Excel, MS Word, MS Power Point, Microsoft Visual Studio, Jira, Confluence, Box, ServiceNow, Metric Insights
EDUCATION:
•Bachelors in Engineering – Rajiv Gandhi Technical University
PROFESSIONAL SKILLS:
Nike (Beaverton, Oregon) Oct’18 – till date
Data Viz Engineer
Nike, Inc. is an American multinational corporation that is engaged in the design, development, manufacturing, and worldwide marketing and sales of footwear, apparel, equipment, accessories, and services.
Responsibilities:
Responsible for delivering a wide range of solutions across all business functions that will turn data
into visual representations that makes it easier to make meaningful decisions.
Capable to facilitate and drive meetings toward results is critical in this role, as is your general written and verbal communication skills.
Partnering with business teams to anticipate needs; assesses requirements and identify new solutions.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Work with end users, business analyst and project team members to plan, design, develop,
implement and enhance business analytics capabilities using Tableau Business Intelligence tools.
Construct and maintain an appropriate, scalable, and easy-to-use infrastructure with Tableau for the development of actionable reports.
Perform peer review of Business Intelligence reports from other developers to ensure that all code
and reports conform to standard guidelines.
Migrate Business Intelligence artifact changes between development, test, training, and production
environments and maintain a proper development cycle.
Review current operational data structures and data flows and recommend optimizations and
opportunities for automation.
Perform Tableau type conversion functions when connected to relational data sources
Develop and enforce change management and versioning processes surrounding new releases of
dashboards and evaluate and recommend new tools and methodologies to assist with change and
version management.
Creating data blending in case of merging different sources
Created report schedules, data connections, projects, groups in Tableau server
Responsible for migrating the dashboards to Snowflake view
Responsible for security implementation on dashboards based on role level access of users and perform end to end validation
Participate in various team meetings to decide on priorities and important stories for sprint
Connecting to different database like Amazon Athena, Snowflake to fetch data
Preparing pre-upgrade checklist and performing post-upgrade validations
Testing new Tableau server versions to help perform smooth upgrade
Support existing dashboards like fixing bugs and modifications as requested by stakeholders
Building new dashboards after requirement gathering from stakeholders and work on iterations
Good knowledge and hands on experience in Metric Insights
Experience in Retail data to showcase important KPIs for business
Sentient Law Group (New York City, NY) Oct’16 – Oct’18
Programmer Analyst
Boutique Law Firm specializing in Corporate Law, Business Planning and Finance, Employment and Labor Law, Real-Estate Law and Transactions, Immigration and Complex Civil Litigation.
Responsibilities:
Architecting and building Analytics Rapid Deployment Solutions
Coordinate with application vendors as needed
Responsible for Client Delivery and Solution Design
Involved in creating dashboards by extracting data from different sources
Created dashboard using parameters, sets, groups and calculations
Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard
Provide system documentation and other administration tasks and duties as required
Creating calculated fields, mapping and hierarchies
Creating drill through reports in dashboard
Creating data blending in case of merging different sources
Creating a dual-axis bar chart with multiple measures
Extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server
Extensively used data blending in Tableau
Performed Tableau type conversion functions when connected to relational data sources
Created incremental refreshes for data sources on Tableau server
Created report schedules, data connections, projects, groups in Tableau server
Extensively used Tabcmd commands in creating backups and restoring backups of Tableau repository
Accenture Apr’16-Aug’16
Client: Telstra (Melbourne, Australia)
Telstra is Australia’s largest telecommunications and media company which builds and operates telecommunications networks and provides mobile, voice, internet access, pay television and other entertainment products and services.
We basically provided cloud services and data center services and support to the customers of Telstra globally.
Description: Providing insight on sales effectiveness via tableau visualizations for commercial section of Asia Pacific and Japan. Designing an end to end business solution for Asia Pacific and Japan region.
Responsibilities:
•Gathered the requirements and made list of reports client needs going forward
•Responsible for Client Delivery and Solution Design
•Involved in creating dashboards by extracting data from different sources
•Created dashboard using parameters, sets, groups and calculations in Tableau
•Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard
•Created calculated fields, mapping and hierarchies
•Created drill through reports in dashboard
•Involved in creating data blending in case of merging different sources
•Involved in creating a dual-axes bar chart with multiple measures
•Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server
•Working on generating various dashboards in Tableau Server using different data sources such as Oracle, Microsoft SQL Server
•Extensively used data blending in Tableau
•Created incremental refreshes for data sources on Tableau server
•Created report schedules, data connections, projects, groups in Tableau server
•Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
Environments: Tableau Server, Tableau Desktop, SQL
HCL Technologies
Client: EMC Corporation (Hopkinton, MA) Dec’13 – Apr’16
EMC Corporation (stylized as EMC ) is an American multinational corporation headquartered in Hopkinton, Massachusetts, United States. EMC offers data storage, information security, virtualization, analytics, cloud computing and other products and services that enable businesses to store, manage, protect, and analyze data. EMC's target markets include large companies and small- and medium-sized businesses across various vertical markets.
Project 1: Rebuilding Qlikview Visualizations on Tableau
Responsibilities:
•Development of Sales, Marketing, Finance, Operations and Infrastructure Reports in Tableau 8.2
•Metadata modeling. Development of Reports and Dashboards using Tableau 8.2
•Tableau 8.0 to implement advanced forecasting and analytics
•Coordinating with client COE team in data validation and understanding feasibility of Tableau in the business
•Validating data and used case scenarios
•Designed, programmed, deployed and tested the requested Reports.
•Analyzed long running queries and tuned the complex queries to optimize application and system performance.
•Integrating the web-based application with Tableau 8.0 server
•Load testing Tableau Server Testing Environment
•Google Analytics integration for fetching online sales reports and analytics
•Developed user test cases and validated test results during user acceptance testing
•Assisted in test planning and execution. Created test plan for User Acceptance Testing
•Documenting technical specifications
Environment: Tableau Desktop, Tableau Server, Windows Server 2008 R
Project 2: Web based Application integrated with Tableau acting as a one-stop portal for Sales and Marketing Reports for EMEA and NA regions.
Description: Development of a web based application which had different sections for sales and marketing visualizations. Reports developed in Tableau were integrated to this web application to act as a one stop for various reports in NA and EMEA regions.
Responsibilities:
•Tableau Workbook design
•Preparing Dashboards using calculations, parameters in Tableau
•End to end data modeling, dashboard designing and deploying data visualizations using Tableau.
•Tableau Server-side and row-level security
•Developing proof of concepts and architecting solutions with focus on security, high availability, trade-offs etc
•Used different Mark types and Mark properties in views to provide better insights into datasets
•Created various types of charts to provide better visualization.
•5 weeks of hyper-care sustain post production release.
•Used Tableau Desktop for blending databases and creating different interactive views and dashboards
•Using Tableau Desktop created interactive reporting dashboards by combining multiple views
•Published views and dashboards in Tableau Server for auditor review
•Documenting Technical and Functional specifications
Environment: Tableau Desktop, Tableau Server
Tech Mahindra
Client: D-Link Corporation (Fountain Valley, CA) Apr’13 – Dec’13
D-Link Corporation is a Taiwanese multinational networking equipment manufacturing corporation headquartered in Taipei, Taiwan. It was founded in March 1986 in Taipei as Datex Systems Inc. It began as a network adapter vendor and has gone on to become a designer, developer, and manufacturer of networking solutions for both the consumer and business markets.
Project: Development/Administration of Tableau reports.
Description: Maintaining the tableau platform as well as developing reports in Tableau.
Responsibilities:
•Requirement Analysis and data-extraction from heterogeneous data sources, development of Metadata modeling reports and dashboards using Tableau 8.3
•Integrating the web-based application with Tableau 8.3 server
•Created Tableau extract files for improving the performance
•Providing insights on the Dashboards
•Participation in Quarterly Business Reviews
•Development of Sales, Marketing, Finance, Operations and Infrastructure Reports in Propose workflows and data structures & Design mock-ups and templates.
•Evaluate customer needs effectively and evidence of using good judgment.
•Worked with a dynamic and demanding environment where expectations for performance and productivity are high.
•Integrating trusted authentication services to enable single sign-on using LDAP credentials.
•Load testing using Qlikview Scalability and Tableau Server Testing Environment.
•Used different Mark types and Mark properties in views to provide better insights into datasets.
•Created various types of charts to provide better visualization.
•5 weeks of hyper-care sustain post production release.
•Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
•Using Tableau Desktop created interactive reporting dashboards by combining multiple views.
•Published views and dashboards in Tableau Server for auditor review.
•Documenting Technical and Functional specifications.
Environment: Tableau Desktop, Tableau Server, SQL Server, MS Excel, Windows Server 2008 R2