Susan Lottes

Experience

• 

  Professional Computer Resources

  Jun 1981 - Aug 1982

  Programmer/Analyst

  Coded and tested custom accounting software. Prepared technical guides for end users. Trained in RPG programming. Coded and tested simple-to-complex, batch and online modules for inventory control, GL, AR, order entry, billing, and sales analysis.

• 

  Compion Corporation

  Oct 1982 - Dec 1983

  Computer Scientist

  Developed ARPANET network protocol / network interface software. Designed, coded, and maintained complex system software and user interfaces in C and Assembly Language. Quickly gained proficiency in C language without formal training. Prepared functional design specification for new user interface email product. Coded and tested network interface module for LAN device driver.

• 

  University of Illinois College of Medicine at Peoria

  Jan 1984 - Mar 1985

  Programmer

  Developed student/alumni database using dBase II and dBase III. Prepared technical guides for end users. Trained faculty and staff in use of hardware and software.

• 

  Johnson Elementary School

  Oct 1995 - May 1999

  Teacher Associate
• 

  Norrell

  Jun 1999 - Sept 1999

  Accounting / Clerical Temp
• 

  Accountemps and OfficeTeam, Grand Rapids, MI

  Sept 1999 - Oct 2000

  Accounting / Clerical Temp
• 

  APAC Customer Service

  Sept 2000 - Feb 2006

  * Developed, tested, and implemented data storage and delivery solutions for internal and external reporting requirements, using both Excel and web-based reporting platforms.* Acquired BI / IS development, design, and reporting experience to include PL/SQL (in an Oracle environment), ASP for web page development, Visual Basic 6.0, and VBA (Visual Basic for Applications) used with Microsoft Excel and Microsoft Access.* Interpreted and analyzed business requirements as communicated by non-technical personnel, and designed user-friendly interfaces, technical documentation, and training procedures for a non-programmer user base. Show less

  • Reports Developer

    Jan 2002 - Feb 2006

  • Reports Analyst

    Sept 2000 - Jan 2002
• 

  Ruffalo Noel Levitz

  Feb 2006 - Aug 2022

  Data Analyst / Software Support Specialist

  * Served on Data Operations team for Fundraising Management division - $1 Billion+ funds raised in a year through RNL-designed campaigns for 1900+ Higher Education and other client institutions across the U.S., Canada, and around the world.* Configured campaigns, loaded and maintained data, in RNL’s proprietary Engage platform. The division’s Data Operations team enabled 6 million+ conversations held with donors, alumni, and students annually.* Set up automated recurring and blast emails in CRM platform and in (Selligent) Strongmail. Company-wide, 240 million emails sent to prospective students and donors annually.* Configured recurring reports in proprietary Reports Plus application, and provided ad hoc reports/data sets/analyses using Oracle SQL, SSMS, and Excel.* Cleansed and transformed client data for loading into Fundraising campaigns.* Improved performance of complex recurring data maintenance tasks by implementing automated steps with checkpoints. Estimated time savings of 67% per task. * Go-to team member for troubleshooting or technical solutions requiring advanced programming or analytical skills.* Performed QC checks to maintain standards in team’s collaboration with an outsource group assisting in data operations tasks. Show less

• 

  Veridian Credit Union

  Aug 2022 - now

  Business Intelligence Analyst II

  Responsible for managing Business Intelligence tools within the institution. Also responsible for the development, administration, and monitoring of automated reporting processes from Data Warehouse. Focus is on process development, data transformation, and complex reporting requirements.