Reporting Analyst Resume NY - Hire IT People

SUMMARY:

Highly organized and result - oriented professional with a 2+ years’ experience in Data Analysis, Reporting and Business Administration
Proficient in MS Office suite, MS Access and Tableau.
Proficient in all Microsoft applications, Word and PowerPoint, with advanced Excel skills (Pivot Tables, VLOOKUP, Charts)
Experience assisting Business Analysts in gathering requirements for development purposes
Proven understanding of translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs.
Understanding of Microsoft Access Database
Experience in Complex Data Cleansing, Exploration, manipulation and Analysis for business needs
Understanding basic 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-awareness, reflective and able to learn from mistakes, with an ability to learn quickly while on the job

TECHNICAL SKILLS:

Languages: VBA(Basics), SQL(Basics), DAX(Excel)

Databases: MS-Access 2.0/97/2000/XP/ 2002/2003/2007

Operating Systems: WINDOWS NT 4.0, WINDOWS 98/95, WINDOWS XP, MS DOS

Tools: MS (Access, Excel, Tableau, Word PowerPoint)

Other skills: VLOOKUP, Pivot table, dashboards

EXPERIENCE:

Confidential, NY

Reporting Analyst

Responsibilities:

Created Dynamic Charts/Graphs in MS Excel and Access for biweekly/Monthly reporting purpose
Assisted Business Analysts in gathering requirements for Development purpose
Transferring of data between spreadsheets and work books for weekly presentations
Documented weekly meetings with internal and external Stakeholders
Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
Worked with the Business users to understand what reports were critical, non-critical and not needed.
Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas
Investigated and explored raw dataset for further Analysis
Environment: MS Access (VBA), MS Excel (VBA), PowerPoint, Outlook Kimco Realty Corp. New York, NYJunior Reporting Analyst (Intern)June ‘18-Sept ‘19
Developed reports in Excel and Access from datasets as per business needs
Data migration and Data validation/Testing through MS Access and MS 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.

Environment: MS Access (VBA), MS Excel (VBA), PowerPoint