Highly organized and result-oriented professional with experience in Data Reporting and Analysis
Proficient in MS Office suite, MS Access, Google Suite
Proficient in all Microsoft applications, Word, and PowerPoint, with advanced Excel skills (Pivot Tables, VLOOKUP, Macros)
Experience assisting Business Analysts in gathering requirements for development purposes
Experience with Tableau Dashboard Visualization
Tableau Developer
Experience in Data Analysis and manipulation of complex data set for business need
Knowledge of SQL to generate queries in Database for exporting purpose
Strong project management skills with good working knowledge and understanding of business and operational processes
Ability to interact and work with internal & external stakeholders/vendors/clients at all levels.
Self-aware, reflective, and able to learn from mistakes, with an ability to learn quickly while on the job
Overview
6
6
years of professional experience
Work History
Data Analyst (Excel, Power Bi, Tableau)
Kubota Manufacturing Equipments
09.2023 - Current
Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems
Work with business teams in various areas of field sales to develop reports or address data needs to provide reporting solutions
Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically, data residing in data warehouses
Synthesize and translate Business data needs into creative visualizations in Tableau
Extract, Upload and Manipulate data on Enterprise Business Intelligence Software
Write SQL query, sub-queries and perform table joins and complex data merges
Manipulate Tables on Excel and Import to SQL using Enterprise Business Intelligence
Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
Identify and translate business needs and requirements into customized design and implementation of intuitive information dashboards, reports, and visualizations that are optimized for performance and use best practices
Manipulate data on Salesforce for Visualization purpose
Create complex reports on Adobe Analytics
Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
Interpret data, analyze results using statistical techniques and provide ongoing reports
Data Reporting Analyst
AES Clean Technology
02.2021 - 09.2023
Company Overview: Cleanroom and Contamination Control Industry
Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
Data migration and Data validation/Testing through MS Access and MS Excel
Wrote VBA codes for automated transferring of data between spreadsheets and workbooks
Wrote VBA codes for exporting queries from Access Database to Excel
Importing of data to Access and SQL Server from flat files and Excel spread sheets
Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
Maintained Access database for the purpose of extracting reports
Developed interactive Microsoft Excel dashboards for presentations purpose
Worked with the Business users to understand what reports were critical, non-critical and not needed
Cleanroom and Contamination Control Industry
JR Data & Business Analyst
Carter's Distribution Center
01.2019 - 02.2021
Created an MS Access database to collect data systems to provide lists, status reports and management overview reports
Created BI reports in pivot charts, graph, and other visualization format to Analyze trends
Created Dynamic Charts/Graphs in MS Excel and MS Access using VBA
Maintained system databases, e.g
Rent rolls and tenant files, in MS Office
Imported data from pre-existing text files and excel spreadsheets
Generated the necessary BI reports and information to litigate tax appeals for properties Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
Data migration and Data validation/Testing through MS Access and MS Excel