Business Data Analyst & Tableau Developer Resume
5.00/5 (Submit Your Rating)
New, YorK
SUMMARY:
- An analytical and problem - solving professional with massive knowledge and experience in Project Management processes and knowledges Areas, Analytics (Business & Data) and Data Science.
- Good experience on Advance Excel, SQL, BI tools like Tableau and Power BI for developing dynamic reports.
- Experience in working with Excel Functions, VLOOKUP’s, Pivot Tables and formulas.
- Experience and Knowledge in Project Analysis, Requirement Gathering such as Business Requirement documents(BRD) and developing Business Case.
- Excellent knowledge in designing and developing dashboards using Tableau by extracting the data from multiple sources (Flat files, Excel, Access).
- Excellent interpersonal skill and effective communication in verbal and written as well as listening.
- Able to Multi-task and handle changing priorities in a fast-paced team environment.
- A Team player and ability to work within time and budget.
TECHNICAL SKILLS:
Databases: SQL, MySQL, MS SQL Server
Advanced Excel: Pivot Tables, VLOOKUP, Data Validation & VBA
Data Visualization Tools: Tableau Desktop & Power BI
Programming: Python, C/C++, R
PROFESSIONAL EXPERIENCE:
Confidential,New York
Business Data Analyst & Tableau Developer
Responsibilities:
- Responsibilities include providing analytical support and expertise in data collection and dashboard reporting as well as developing rules for data standardization and cleanliness on Tableau Desktop and Publishing Dashboards on Tableau Server.
- Wrote complex queries using complex joins, grouping, aggregation and nested queries in TSQL and Manual Reporting.
- Create different types of charts for Tableau dashboard analysis.
- Increased revenue by 10% and reduced account receivable by 20% with the use of Tableau to support executive decision.
- Used Tableau and Excel Analysis to create KPI and scorecard to improve corporate profitability.
- Developing the high-end Visualization Tableau Dashboards using Tableau objects
- Gathered and model business needs into report specifications and technical requirements.
- Using Excel Pivot table to manipulate large amount of data to perform data analysis, operation reporting, ad hoc queries and analysis.
- Involved in creating ad hoc analysis and reports for Business Executives in a timely manner.
Confidential
Excel & SQL Developer
Responsibilities:
- Creating Excel Templates and Provide timely status reports and metric.
- Using Excel Pivot table to manipulate large amount of data to perform data analysis, operation reporting, ad hoc queries and analysis.
- Developed Excel Templates and created views with TSQL.
- Involved in creating ad hoc analysis and reports for Business Executives in a timely manner.
- Wrote complex queries using complex joins, grouping, aggregation and nested queries.
- Developed Excel Templates, provide timely status reports and metric and created views with SQL.