Resume

Melissa DeMelo

Tampa Bay area            www.Linkedin.com/in/mydemelo

Translating between the technical and non-technical world. Presenting data simply and irresistibly. 
Discovering data trends that lead to strategic transformation.

Expertise
  • Creating adhoc and auto reports and designing dashboards 
  • SQL Server, SSRS/Report Builder, PowerBI, PowerPivot, Excel, Google Analytics, Tableau, CRM, SharePoint, Access, Crystal Reports, PowerPoint, Word, HTML, Photoshop, Google Docs, DonorDirect
  • Business Intelligence 
  • ETL and analyzing data
  • User support
  • Managing projects
  • Knowledge transfer
  • Problem solving 
  • Communicating between technical and non-technical users 
  • Software testing, training, and support 
  • Technical writing 
  • Social Media writing, strategy, and campaign measuring
  • Remote work

Experience

Application Administrator | InfiLaw | July 2017-present

  • First line of Support for staff/users in CampusNexus Student (CampusVue), ACES2, D2L, and Oracle CRM
  • Quickly handle and route support tickets, troubleshoot issues, and manage identities in Active Directory
  • Skilled in working remotely with diverse types of people from various cities in different time zones
  • Liaison with third party vendor and user support during application/software upgrades
  • Create user reports and facilitate data requests/updates using SQL / Crystal Reports / Excel / PowerQuery
  • Contribute to knowledge sharing—Writing, updating, and organizing documentation in JIRA/Confluence
  •  Analyze and revise business process best practices. Gather user requirements leading to specified outcomes

Data Analyst | In Touch Ministries | Feb. 2010-May 2017

  • Create queries, auto-reports, dashboards, visuals, charts, maps, surveys, and SQL Views and Stored Procedures — to analyze sales, donations, web data, call reporting, and constituent data. 
  • Design and update PowerPivot and PowerBI dashboards to analyze and distribute information to users. 
  • Crafted a 360-degree Call Volume report using PowerPivot and Pivot Tables which shows all aspects of weekly calls by channel per toll-free number, along with top sales data and geographical charts. 
  • Assist customer care department with staffing needs by mapping out high call volume times. 
  • Create SSRS/Report Builder reports for multiple users using various data sets and parameters. 
  • Our team implemented a data warehouse to simplify reporting for PowerBI. 
  • Generate Word Clouds for visualizing monthly web search terms. 
  • Monitor and troubleshoot SSIS jobs and SSRS reports. 
  • Quickly respond to support tickets and data requests. 
  • Kept historical data to facilitate Forecasting so we could determine data patterns. 
  • Used goals (KPIs) to define strength of projects. 
  • Manage intranet design and content for 250-member staff. 
  • Create and write procedures. 
  • Train users. Test software. 
  • Manage projects, including information gathering.

Research and Strategy Analyst | In Touch Foundation | July 2003-Feb. 2010

  • Supported 15-person field rep team, dividing the work via territory and scope. 
  • Created reports and maps. 
  • Trained new users. 
  • Handled migration to Microsoft Dynamics CRM. 
  • Researched foundations and constituents for donation opportunities.

Writer/Researcher | Leading the Way | October 2001-July 2003

  • Wrote grant proposals, researched foundations and donors. 
  • Handled constituent information.

Research and Project Manager | In Touch Ministries | November 1989-October 2001

  • Admin responsibilities, event planner, research. 
  • Handled constituent information.

Education

  • Campbellsville University | BA | English/Journalism | Journalism Award | Editor of campus newspaper 3 years
  • New Horizons | Business Intelligence Classes

Engagement

  • ESL Instructor -- create lesson plans and teach English and American culture to International adults (current)
  • Austell, GA City Planning and Zoning Committee Member
  • Assist startups and small non-profits with organization, scope, donor development, and database administration

Popular posts from this blog

CSI: Church

September 30th was a big day in our household, for it was the Sunday that we ended a six-year relationship at the church where we are members. We have found that even though you feel like God is leading you to take a stand--it doesn't make it any easier. Leaving (since we were the oddballs, so to speak) has been one of the most difficult things we've ever done as a couple. I would put it right after the whole immigration fiasco, and the dual deaths we experienced in 2002 and then again in 2005. This post has been a long time brewing. I have so much to say. With each Sunday that we visit and investigate a new church, and with each interesting person we meet, I kind of feel like I'm a part of a TV show and this mystery is unravelling with each step we take. I thought we were going to be placed into a dry and weary desert and I was gearing up to experience a dehydrated spiritual life. But I am very happy to report that it seems that God had other plans. Healing... We took the ...
Read more

The DeMelo Garden

Image
Interesting! I picked these Nasturtium flower seeds out at Home Depot because (1) they were very pretty, (2) I liked the Empress of India name for the red ones, and (3) they were “buy one get one free” for Earth Day. I’d never even heard of them before. I bought a jewel mix and the Empress of India variety and when I looked them up, I found out they are also edible. They are like water cress (which is another thing I think I will plant). I have planted the Nasturtiums in the front yard along the path to the front door. I can hardly wait to see how they look when they bloom! http://www.sallybernstein.com/food/columns/gilbert/nasturtiums.htm http://www.gardenguides.com/plants/info/flowers/annuals/nasturtium.asp This is the Empress of India variety. What bold red! I also planted 2 purple balloon Flowers on either side of the walkway. Our garden consists of 9 green pepper plants (yeah, I know it’s a lot but I love green peppers!), 3 cherry tomato plants (these are so addictive; great in s...
Read more

My Top Web Links

News www.drudgereport.com (must-have news; my most-visited site) www.worldnetdaily.com (my 2nd most visited site) www.foxnews.com www.weather.com http://www.ajc.com/ (Atlanta's hometown newspaper) http://www.cknj.com/ (my hometown newspaper) http://newsdirectory.com/ (find any newspaper, by region) Personalities www.clarkhoward.com www.boortz.com www.hannity.com www.anncoulter.com www.michellemaulkin.com Reference www.refdesk.com (starting point for finding just about any fact) www.google.com (the best, search within results, toolbar is a must!) www.almanac.com (the Old Farmer's Almanac, in a new way-online) www.amazon.com http://www.snopes.com/ (check here before you send that possible urban legend email) http://www.atlantagasprices.com/ http://www.flylady.net/ (getting your house, and your life, in order) Computer Helps www.komando.com http://www.asap-utilities.com/ (a must-have for running Excel reports!) www.dummies.com http://office.microsoft.com/en-us/templat...
Read more