Andrea Simmons Email & Phone Number

Kingston, Rhode Island

New London/Norwich, Connecticut Area

Member of senior leadership for an Advancement program that includes more than 40 professionals securing more than $30 million in new gifts and commitments annually. Oversees and manages all Advancement reporting and data analysis needs as well as high level, specialized reporting and dashboards for the Vice President of Advancement, Office of the President, Board of Trustees, Alumni Association Board and Parent’s Council. Strategically collaborates with all Advancement program areas in effort to evaluate, guide and propose effective solutions to improve business intelligence decision making, enhance data quality and eliminate offline reporting, manual data entry and outdated methods and practices.Serves as a technical liaison to for all major Advancement database and software implementations, upgrades and conversions and advocates for IT programming resources that are necessary to support the strategic initiatives in Advancement. Proactively and effectively manages the Advancement Services team of five professionals by creating a successful and positive team atmosphere based on integrity, respect and professionalism.

New London/Norwich, Connecticut Area

Developed and delivered polished and professional high level complex reports and metrics to the Vice President and Assistant Vice President of College Advancement. Created hundreds of standardized push reports and business intelligence dashboards that empowered end users to dynamically retrieve data for further analysis. Served as a functional and technical for Banner and Web FOCUS upgrades.Collaborated and delivered quarterly metrics to reconcile gift and pledge data as part of the annual audit of Intuitional finances with Finance and Accounting offices.

Responsible for assisting with planning, developing, implementing, and evaluating casino events and promotions. Executed targeted mailings through developing strategic and intricate programming queries using a robust customer database software system, SAS Enterprise Guide. Assisted with design, implementation and maintenance of database using various software applications. Managed daily responsibilities, provided training and oversaw special projects within the marketing department

Developed complex SQL queries to extract information out of the casino’s transactional database, Teradata, for reporting and analysis.Analyzed the performance trends of marketing efforts with regression analysis techniques and forecasted direct mail response rates and customer behavior trends. Provided analytical reporting and analysis derived from both standardized and ad hoc reporting, including insightful conclusions and recommendations to improve future budgeting.Contributed as a team member in proactively developing methods for capturing & reporting critical direct mail response information.

Calculated weights and centers of gravity for modeled parts of submarines and air craft carriers.Analyzed and retrieved data for product modeling and applied for use in an itemized quarterly weight report.Interacted with engineers and designers to discuss potential weight impacts throughout phases of design.

Bachelor Of Science, Mathematics

Research, Statistics And Quantitative Measurement

Graduate coursework