Susan Lottes Email & Phone Number

Cedar Falls, Iowa, United States

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.

Cedar Rapids, Iowa, United States

* 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.

Cedar Rapids, Iowa, United States

* 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.

Cedar Rapids, Iowa, United States

Generated daily publication of a set of client-specific reports detailing Customer Service/Telemarketing production statistics. Created Excel templates with macros for new reports and configured internal tools for querying data sources. Key contributor to the development of a configurable, automated data import and presentation model for our department’s usage of Microsoft Excel which led to a natural transition of roles upon my promotion to Reports Developer.

Cedar Rapids, Iowa, United States

Cedar Rapids, Iowa, United States

Cedar Rapids, Iowa, United States

Peoria, Illinois, United States

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.

Urbana, Illinois, United States

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.

Oak Brook, Illinois, United States

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.