Debjani Hill

Debjani Hill
------------
D------------
Young professional with Excel, SQL and VBA skills looking to start a career in data analysis.
Looking to leverage technical skills and training with large data sets to attain a role in which to
grow and add value.
Training and Experience
• Designing profit and loss reports to aggregate inputs necessary for calculating costs and
revenues via automated queries within spreadsheets
• Collecting and designing databases with inputs from web sources
• Calculating/reconciling financial transactions to ensure accurate settlement
• Analyzing and summarizing operational metrics across long time frames
• Scrubbing data to conform to existing database table formats
• Creating dynamic spreadsheets using advanced Excel formulas (VLOOKUP, OFFSET,
INDEX/MATCH) to pull user requested data within requested date ranges
• Combined datasets using SQL join clauses to create meaningful, organized spreadsheets
that logically display relevant operational metrics
• Leveraged SQL skills with knowledge of Visual Basic and Excel to create spreadsheets
that query large data sets and pull requested data into the spreadsheet for user analysis
Skills
• Basic SQL Querying
• SQL pivoting (PIVOT)
• Beginner level data scrubbing and
table editing
• Beginner VBA for macros
• Advanced Excel features (Advanced
SUMIFS, data validation, Pivot
Tables)
• Reconciling
• Spreadsheet Design
Education
5/2017
International Institute of Hotel Management
Bachelor’s Degree Hospitality Management