Sarwest Kumar
Delhi NCR
Summary
Valuable experience in the IT field, showcasing a strong foundation in technology Data Analyst with Tableau BI Focus: Specializes as a Tableau BI Developer, demonstrating expertise in leveraging Tableau for data analysis and visualization.
Overview
7
7
years of professional experience
Work History
Senior BI Analyst
McKinsey & Company (APSI DATA Solution)
12.2022
- In tableau, identifying patterns and trends in data sets and create attractive dashboard for the users
- To Use Tableau BI and Power BI & python Data science skills code to improve and customized the dashboard features
- Tableau and Power BI Integration with python & some other source packages tool to enhance the dashboard program functionality
- Creating regression line between two and more variables to show the trends and forecasting
- ETL developers, in general, design, create, automate, and maintain sophisticated programs that extract, convert, and load data
- To do some dynamic functionality features like sheet swapping, graphic changer or switcher, dynamic dimension, dynamic measures
- Graphical representation through reference line, reference band, and average line to set the limit of the KPI’s
- Create multiple charts Like, Bar, Line, Trends Line, Bubble Charts, Histogram, pareto charts, Bullet charts, Map Design, Tabular format, donut charts, Pie Charts etc
- Create date field calculation using YTD Sales value vs LYTD and MTD VS LMTD Sales etc
- And target values according to the business requirement
- Use parameters and filter for user requirement purpose for user control access
- Create sets and group in the worksheet to use the dimension or facts as fully dynamic
- Creating Oracle database table and views tools to store data within the organization
- Use different kind joints in database to connect multiple tables as per project requirement
- Build Daily Sales and profit KPI’s based dashboards
- Publishing Workbooks and Data Sources to Tableau Development and QA sites
- Follow up Managers for any required approvals
- Obtain SVP/Chair/Dean Approvals to request access for dashboards
- Providing knowledge transfer and support to Interactors and Viewers
- Direct meeting with stakeholders to discuss some major scenario for business growth handle individually.
Tableau/Power BI- Data Analyst
Reliance Den Network Ltd
11.2021 - 12.2022
- In tableau, identifying patterns and trends in data sets and create attractive dashboard for the users
- To Use Tableau BI Data science skills code to improve and customized the dashboard features
- Tableau Integration with packages tool to enhance the dashboard program functionality
- Regression line between two and more variables to show the trends and forecasting
- Create statistical modelling and future data prediction by using time series and forecasting technique
- Developing, maintaining, and managing interactive Dashboard & reports, analytics, and other BI solutions
- Performing data analysis, data validation, and data mapping/design
- Use Oracle and SQL server database to import the date into tableau for dashboard purpose
- To setup connection between database and Tableau to create the project setup environment
- Connect live and extract data connection in tableau both for the dashboard environment
- Also, setup incremental data refresh and full data extract refresh as per report’s demand
- To do some dynamic functionality features like sheet swapping, graphic changer or switcher, dynamic dimension, dynamic measures
- Graph representation through reference line, reference band, and average line to set the limit of the KPI’s
- Create multiple charts Like, Bar, Line, Trends Line, Bubble Charts, Histogram, pareto charts, Bullet charts, Map Design, Tabular format, donut charts, Pie Charts etc
- Create an YTD Sales value vs LYTD and MTD VS LMTD Sales and target values according to the business requirement
- Create statistical modelling and future data prediction by using time series and forecasting technique
- Developing, maintaining, and managing interactive Dashboard & reports, analytics and other BI solutions
- Performing data analysis, data validation, and data mapping/design.
Tableau developer
Bata India limited
11.2020 - 11.2021
- In tableau, Identifying patterns and trends in data sets
- Developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions
- Performing and documenting data analysis, data validation, and data mapping/design
- Reviewing and improving existing systems and collaborating with teams to integrate new systems
- Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues
- Creating Oracle database tools to store data within the organization
- In Tableau Server, create and manage the site’s users and groups, create projects to organize Content on the site and assign permissions to allow users (groups) to access the content
- Promote and certify content and measure the use of analytics within their site
- Manage site settings, create projects for organizing content, and delegate responsibilities for administrative tasks
- Also promote and certify content and measure the use of analytics within their site.
Associate Consultant
Oodles Technologies
01.2020 - 04.2020
- Working alongside teams within the business or the management team to establish business needs
- Defining new data collection and analysis processes
- Creating visualizations for the data extracted with the help of Tableau Identifying patterns and meaningful insights from data by analyzing it
- Designing dashboards Managing Tableau Server Managing big data SQL queries for improving performances Examining glitches in business processes and resolving them Finding the key areas of automation to make the business processes smooth Developing reference documents or reports for the finalized project
Sr. Associate Consultant
Amiga Informatics’
07.2015 - 10.2019
- Develop, design and supporting interactive Tableau dashboard reports and templates Recommend dashboards per Tableau visualization features Deploy dashboard/reports to Tableau server environment Designing dashboards with the use of visualization tools like Tableau Using SQL for managing large volume of data, communicating with customers to analyze historical data and identify KPIs Making sure the team delivers reports as per the requirements Analyzing the data so as to identify trends and share insights Implementing Tableau mobile dashboards with the help of Tableau mobile application Creating Thematic Heat maps with the help of MapInfo Recognizing areas for automation Restricting data for particular users with the help of User filters Producing support documentation and keep existing documentation up to date Carrying out investigation of root cause analysis
Education
B.Tech -
UPTU University
01.2015
Intermediate -
01.2011
Matriculation -
01.2009
Skills
- Advanced Excel
- Python Programming
- ETL development
- SQL Programming
Data Analysis And Modeling
Identifying patterns and trends within datasets, enabling the creation of attractive dashboards for users. Proficiency extends to regression analysis, statistical modeling, and future data prediction using techniques such as time series forecasting.
Dashboard Development
Has hands-on experience in developing and customizing dashboards using Tableau and Power BI. Work involves enhancing dashboard functionality through code, integrating Tableau with other tools, and implementing dynamic features.
Domain Expertise
Analyzing the risk factor and trying to reduce the losses and maximize their capital, work on various methodology to determine the risk terminologies. demonstrate a strong grasp of database systems, including Oracle and SQL Server. Can create and manage database tables, implement data connections, and ensure data integrity for dashboard purposes.
Collaborative And Communication Skills
Actively engages with stakeholders, conducts meetings, and handling the team members, user roles and permissions. The ability to communicate effectively contributes to successful project management.
Troubleshooting And Optimization
Responsibilities include resolving issues, optimizing dashboard performance, and conducting performance tuning for the Tableau Server
Technical Skillset
Tableau BI, MS Power BI, Alteryx, Tableau Desktop, Tableau Server, Tableau Prep Builder, data visualization, data modeling, data cleansing, SQL Server, Data Science, Python, Risk Analysis and Management
Personal Information
Title: Senior BI Consultant
Timeline
Senior BI Analyst
McKinsey & Company (APSI DATA Solution)
12.2022
Tableau/Power BI- Data Analyst
Reliance Den Network Ltd
11.2021 - 12.2022
Tableau developer
Bata India limited
11.2020 - 11.2021
Associate Consultant
Oodles Technologies
01.2020 - 04.2020
Sr. Associate Consultant
Amiga Informatics’
07.2015 - 10.2019
B.Tech -
UPTU University