Katherine Alexander-Ramirez

As a Microsoft Excel Data Analyst, I work with data in all its forms - structured and unstructured data.

I work on extracting valuable insights from data using Microsoft Excel.

Here are some typical tasks I can handle:

• Work closely with stakeholders to understand their needs and define the data requirements for the analysis.

• I gather relevant data from sources like databases, market research, spreadsheets, accounting reports, data collection tables, MS Word documents, PDF files, and all other sources available to work on the project. 
•  Do the data entry necessary in spreadsheets to create workbooks and files. 

• Proceed to clean, transform, and organize the data to make it suitable for analysis.
• Removing inconsistencies, duplicates, and errors from datasets is a critical task.
• Perform tasks like data normalization, aggregation, and filtering.
• Use Excel functions and tools to clean and validate data.

• Apply statistical techniques, pivot tables, and charts in Excel to analyze data.
• Derive meaningful insights from data using Excel’s formulas and functions like macros.

• Design tables, schemas, and relationships.
• Create a Data Model that allows the integration of data from multiple tables, effectively building a relational data source inside an Excel workbook.

• Create visualizations, such as graphs, charts, and dashboards, to communicate insights effectively.
• Present findings to stakeholders clearly and concisely.
• Provide a written summary of my data analysis, along with visualization reports that can be utilized in market research, investigations, business analysis, concluding, or to find insights that can help solve business problems. 

Worked on projects involving market research and financial analysis.

Plaza College, Jackson Heights, New York

Accounting and Information Systems