Aileen Lopez Email & Phone Number

Virtual

• Perform data preparation activities, such as collecting, cleaning, and organizing to conduct and present analytical studies for Market Research, Digital, Customer Experience, Claims, LATAM, and Mobile clients providing.
• Lead on analytical projects submitted by internal and external clients by conducting requirements meetings
• Design and develop dynamic reports, dashboards, and self-service tools using Power BI (DAX) and Excel to drive business decisions
• Work with Power BI (DAX, Power Query), Excel (Power Pivot), Microsoft SQL Server and Google Analytics to extract large datasets
• Develop KPI reporting to include NPS, CSAT, OSAT, and Web Utilization among others for multiple lines of business
• Build and maintain Power BI dashboards which utilize Google Analytics data to track visitor flow, including web claims started, submitted, completed, utilization and self-service rates

Coral Gables, Florida, United States

• Created and administered an online survey to 3500 students and utilized data results to implement multiple programs and workshops
• Develop and analyze satisfaction surveys to over 1000 contacts to determine customer needs
• Provide monthly outcome summaries and recommendations to management based on research findings
• Manage qualitative and quantitative projects using survey software and present findings and recommendations to management for business planning and improvement
• Administer surveys and analyze summary reports to develop marketing strategies for programming efforts
• Conducted graduate student advising appointments on a weekly basis to discuss resumes, major options, salary and offer negotiation, internships and employment opportunities

• Compiled monthly and ad-hoc reports on usage of the management system and recruiting activities
• Conducted research to identify trends in the market to maintain an effective employer relations program
• Prepared and evaluated monthly and year-end statistical summaries of recruiting activities
• Assisted in the redesign of marketing collateral distributed to all constituents
• Developed innovative strategies designed to increase employment opportunities for students
• Identified and built relationships with regional, state and national Fortune 500 companies for sourcing of students/alumni through outreach

• Researched and analyzed current market conditions to establish appropriate sales price
• Created marketing materials for each property to drive sales and increase product awareness
• Coordinated sales and promotions, prepared presentations for prospective sellers and collaborated with prospective buyers and sellers on million-dollar properties
• Identified prospects and developed relationships with customers by discussing their needs and outlining a plan of action to successfully sell each property
• Prepared confidential documents such as representation contracts, purchase agreements, closing statements and lease agreements
• Acted as an intermediary in contract negotiations between buyers and sellers

Master Of Science:, Research, Measurement & Evaluation

Bachelor Of Business Administration:, Management & Organization