Rodolfo Schlichtmann Email & Phone Number

Schaumburg, Illinois, United States

-Innovative solution provider for a 125-year-old community bank, with a large portfolio of Commercial and Consumer Loans.-Supported a diverse portfolio of Commercial and Consumer Loans.-Led research project to find third party middleware solution vendors. Conducted product comparisons and informed findings to management.-Provided recommendations for the.

Rosemont - IL

• Handled process improvement projects and analytics for a medium size Commercial Lending and Consumer Lending portfolios.
• Key asset in Business Intelligence Analytics for Loan Operations and many other interdepartmental projects.
• In charge of the creation and execution of many automatic and semi automatic analytic tasks. Designs and deploys solutions for middle management and end users. Batch processing of scripted tasks.
• Complex report and graph creation for upper management and end users.
• Continued support and development of other BI analysts.

Rosemont, IL

• Produces and analyzes tracking, KPI and performance reports by improving existing or writing new queries in T-SQL, Spotfire, AS400, Hyperion, or Excel.
• Applies mass exchange and mass maintenance creating and using complex RPA scripts.
• Participant in developing and testing new admin and customer facing products.
• In support role for other BI analysts.

Rosemont, IL

• Monitoring and disbursing escrowed taxes and insurance. Review AS400 and tax service reports to disburse taxes using automated mass tax disbursement process and manual per-item single tax payments.
• In charge of creating ad-hoc and scheduled reports using Oracle’s Hyperion IDE software for the Escrow and Loan Servicing areas.

Schaumburg, IL

• Credit Services Technical Associate
• Responsible for handling all kinds of escrow payments, to insurance companies and many offices of tax collectors/county treasurers across the U.S.
• In charge of Escrow and general Loan report creation, scheduling and maintenance using querying IDE software such as Cognos View point and FIS Business Intelligence.
• In charge of all participation and deficiency loans maintenance and payments to participating financial institutions.

Schaumburg, IL

-Processed remittances and prepared them for reading using high speed NCR 7780 machine.-Reconciled and balanced all customer transactions.-Prepared balancing sheets for lockbox supervisor.-Responsible for entering, correcting and balancing paper and electronic check transactions using a high speed check reader machine and dedicated balancing.

Hickory Hills, IL

Role:-Responsible for the managing the overall process of banking check transactions in the form of checks and other documents.-Tasked with as creation and maintenance of training and instruction manuals for item capture, correction and transaction balance.-In charge of General Ledger transaction approvals and other supervisory decisions.

Elk Grove Village, IL

Role:-Overseeing the large quantity processing of day to day check deposits from many financial institutions and proper sorting of internal documents for later processing.-Aiding and occasionally overseeing the distribution department in the production of Cash Letters and preparing the work to be sent to the Federal Reserve Bank.-Troubleshooting issues in.

Elk Grove, IL

Role:-In charge of high speed item entry using a IBM 3890 reader/sorter.-Handling very high volumes of items for many different financial institutions at once.-Handling printing duties using high speed continuous paper laser printers.-Assisting distribution department with the creation of cash letters and preparing work to be sent to the Federal Reserve.

Bachelor Of Science - Bs - Data Management And Analytics, Data Modeling/Warehousing And Database Administration

Spreadsheet Proficiency, Computer Information Systems

English Proficiency

Computer Technician, Computer Information Systems

High School, High School/Secondary Diplomas And Certificates