Ian Lopez Email & Phone Number

Washington, Dc, Us

Philadelphia, Pennsylvania, United States

• 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

Washington D.C. Metro Area

• 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

Arlington, Virginia

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

Washington D.C. Metro Area

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

Washington D.C. Metro Area

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

American University

• 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

Washington D.C. Metro Area

• 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

Landover, Maryland

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

• Data analysis

Greater Philadelphia Area

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

Washington D.C. Metro Area

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

Greater Philadelphia Area

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

Master'S Degree, Analytics

Bachelor'S Degree, Major: Psychology; Minor: Economics, Information Technology

Activities and Societies: Delta Tau Delta - Philanthropy Chair Research Assistant in Psychology Lab