John Ruff Email & Phone Number

Middle River, Md, Us

Atlanta, Ga, Us

Atlanta, Ga, Us

Design, Build, and Enhance sustainable reporting solutionsInterpret stakeholder needs and translate into actionable work requirementsCreate and maintain design documentation for data solutions

London, Gb

 Developing portfolio health reporting by aggregating multiple data sources to produce key health statuses and create a 5–10-year portfolio roadmap. Automating the allocation of the company’s Azure Billing invoice to create a historical view of cloud cost trends and influences. Creating ServiceNow I.T. Service Management Reporting targeted to business application users. Producing interactive organizational reporting to visualize team structure, size, supported applications, and key performance indicators. Leading and mentoring a small team of business intelligence developers, while managing communication and requirement gathering with business stakeholders.

Chicago, Il, Us

 Led discussions across the organization to design a SOX Control solution that fit the needs of all business units. Led trainings for ServiceNow Reporting, Release & Change Management. Contributed to the business unit’s transition from multiple legacy ticketing systems to the ServiceNow platform.

Chicago, Il, Us

 Managed product and hardware upgrade projects ensuring Compliance with NERC CIP Standards Coordinated bi-weekly release and monthly system patching processes. Facilitated the implementation of new NERC CIP initiatives such as CIPv6 and CIPv7. Engaged in annual Compliance Activities including Disaster Recovery Drills, Asset Inventory, and Documentation Updates.

Chicago, Il, Us

 Oversaw monthly code deployments across interdependent technology areas. Ensured IT Controls and Best Practices are followed prior to production deployment. Developed Release Management process and compliance adherence reporting.

San Jose, Ca, Us

 Developed and executed fair lending analysis using credit application and U.S. Census data. Generated monthly key risk indicators that identified risks to meeting regulatory obligations. Analyzed the success rate of all collection programs through repayment analysis. Automated exception reporting through Microsoft Excel to identify operational and procedural errors in need of remediation. Increased department productivity through automation, using ACL Analytics and advanced knowledge of Excel.

Marcq-En-Baroeul, Nord, Fr

• Tracked and analyzed portfolio metrics and evaluated the portfolio for overall default risk through FICO refresh analysis and late pay monitoring• Assisted Senior Management with the facilitation of portfolio sales by maintaining portfolio data• Evaluated at-risk and delinquent borrowers to determine the proper loss mitigation strategy • Developed loan modification strategies for borrowers to accommodate their diminished financial capacity and minimize potential loss• Managed hard collection process by coordinating repossessions with repossession agents, brokers, and legal counsel • Collected post-repossession deficiency balances through direct negotiation with borrowers or coordination with legal counsel• Developed tools and reports to effectively and efficiently manage the floor plan lending collection and reporting process