Ian Lopez

Experience

• 

  EXude, Inc.

  May 2012 - Aug 2015

  Paid Summer Intern

  Sumer Intern for CFO (May 2013 - September 2013)Intern for COO (May 2014 - September 2014)Intern for Risk Management Division (May 2015 - August 2015)• Data Analysis; Proficient in excel pivot tables• Analyzed financial data for quarterly reports• Worked on internal improvements such as efficiency and job satisfaction• Created pivot tables, analyzed market segments and sales opportunities• Participated in marketing projects for sales team• Presented data in terms of PowerPoint and excel graphs, helped employees to better and more effectively serve clients • Managed social media content Show less

• 

  United By Blue

  May 2013 - Jun 2013

  Intern

  • Collaborated with the HR Department to define and improve corporate culture• Improved hiring practices for interns and new hires

• 

  American University - Psycholgoy Research Lab

  Sept 2014 - Mar 2015

  Research Assistant

  • Tested lab rats for food versus drug dependence • In Press: Induction of Pavlovian Responses by Food, Morphine and Cocaine

• 

  Delta Tau Delta Fraternity

  Jan 2015 - May 2017

  Director of Philanthropy

  • Organized a Cornhole Tournament and Dodgeball Event to raise money for JDRF ($2500 raised)• Organized and participated in off-campus group events such as volunteering in a food bank and a dog shelter

• 

  Steppingstone Scholars, Inc.

  Jun 2015 - Aug 2015

  Student Volunteer, Data Analysis

  • Data analysis

• 

  2U

  Jan 2016 - May 2016

  Intern for Operations Management Department

  • Data analysis, compressing raw data into organized deliverable• Helping to manage day to day issues and activities

• 

  Blackboard

  Jun 2016 - Aug 2016

  Intern for VP of Corporate Strategy and Associate VP of Higher Education Policy

  • Created a module describing the organization’s strategy plan for new hires• Analyzed strategic partners and developed a system to rate their value• Researched relevant statistics on education attainment and accessibility in the United States and created a database outlining the research

• 

  The Council of Insurance Agents & Brokers

  Aug 2017 - Dec 2017

  Strategic Resources Intern

  • Market research and competitive analysis • Internal data analytics and client survey analysis

• 

  Mercer

  Jun 2018 - Aug 2018

  Workforce Analytics Analyst Summer Intern

  • Data builds and peer review• Client interviews followed with analysis and recommendations

• 

  Gartner

  Nov 2018 - Oct 2019

  Specialist - Quantitative Analytics & Data Reporting

  • Client management and recruitment/participation• Survey build and analysis• Data visualizations and results delivery

• 

  Fragomen

  Oct 2019 - Jun 2021

  Client Data Analysis Specialist II

  • Deliver and automate reports for internal stakeholders as well as clients• Manage and manipulate raw data using VBA and Pivot Tables to create accessible and actionable charts and reports• Create tools and processes to increase billing and overall revenue• Track capacity and workload to inform decision making around human capital• Work to promote a data driven culture throughout the organization

• 

  Ballard Spahr LLP

  Jun 2021 - now

  Manager - Technology & Innovation

  • Work with data architects to build efficient databases for use on front-end reporting→ Resulting in increased efficiency for new report builds and a standard process document• Develop and maintain dashboards showing trend analysis, key influencers, and smart narratives (Power BI)→ Resulting in clients having increased access to more in-depth views of data, allowing for targeted decision making• Enhance business intelligence capacity through company and industry profiles and legislative tracking and analysis→ Resulting in enhanced decision making by providing multiple data views with different variables and outcomes• Work across teams to create holistic and easy to use products for the end user, while promoting team dynamics• Manage third-party data/vendor relationships and negotiate favorable contracts and terms• Serve on LVN Innovation Committee - representing the team as well as setting up speakers and contributing content Show less