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 insights and recommendations ● 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● Analyze consumer behavior data (including surveys) to generate process/performance metrics and answer key questions● Work cross-functionally with key partners including client services, digital, customer experience, business integration, data science, and data services to strategize over projects requirements and delivery standards● Build and maintain relationships with business stakeholders in a fast-paced environment● Co-chair of the Global Data Analytics Internship Committee● Work with proprietary data from Assurant, a global leader in risk management products

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• Assisted in screening resumes, interviewing candidates and providing feedback in the hiring process of staff members• Developed and sustained relationships with companies which enabled and facilitated effective hiring practices• Participated in multiple networking events monthly to promote the University of Miami

● 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● Assisted in the planning and coordination of 10 expos with an average of 150 vendors and 1100 attendees● Co-planned and coordinated over 50 career fairs and networking events with an average of 200 attendees● Maintained daily contact with an average of 40 recruiters and students● Editor of the monthly e-newsletter distributed to over 11,000 recipients

● 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 ● Conferred with escrow companies, lenders, home inspectors, and pest control operators to ensure that terms and conditions of agreements were met before closing

Master Of Science:, Research, Measurement & Evaluation

Bachelor Of Business Administration:, Management & Organization