Johan Klein Email & Phone Number

Cincinnati, Oh, Us

Cincinnati, Oh, Us

United States

Bogota, D.C., Capital District, Colombia

I led a data migration project with a total cost of $2.8 million, ensuring seamless integration and data integrity across all platforms. This effort resulted in improved data accessibility, operational efficiency and alignment with the digital transformation strategy.I implemented automated data processing and query workflows using SQL and SAS, resulting in a 30% reduction in processing times for datasets up to 8 million records with 200 columns. This initiative also improved data accuracy by 15%, enhancing service delivery to stakeholders and operational efficiency.Some of the responsibilities included:-Extracting and manipulating large datasets, incorporating customer payment history, account information, and transactional data.-Collaborating with other departments such as risk management, finance, and IT to identify opportunities for process improvement and efficiency through data analysis.-Developing predictive models and statistical analysis to forecast trends, assess credit risk, and detect fraudulent activity.-Creating comprehensive reports and dashboards to communicate findings to management.

Bogotá, Distrito Capital, Colombia

I analyzed patient data and COVID vaccination trends at Nueva EPS, contributing to increased vaccination coverage among target demographics. Created data dashboards using government-sourced and collected data, enhancing resource allocation effectiveness.Some of the responsibilities included:-Analyzing large datasets related to healthcare claims, member demographics, and utilization patterns.-Creating and maintaining reports to monitor the performance of different insurance plans, providers, and healthcare services.-Developing SQL queries and Excel connections to automate data analysis and reporting process.-Automating repetitive tasks to streamline workflows.

Bogotá D.C., Colombia

I developed a comprehensive report analyzing the credit profiles of our bank's clients, juxtaposing them with data sourced from credit bureaus. This enabled us to gain valuable insights into our competitive standing, facilitating informed strategic decisions based on accurate market positioning and client creditworthiness assessments.Some of the responsibilities included:-Analyzing financial statements from the corporate and investment banking department to evaluate financial health and performance.-Creating presentations in PowerPoint to communicate transaction strategies, and financial analyses to senior management. -Utilizing Excel charts and graphs to visually represent key financial metrics and analysis.

I implemented robust control limits to enhance transaction quality, standardizing error margins and preventing fraud and anomalies. Resulted in proactive monitoring and identification of up to 103 unusual transactions daily, effectively pinpointing errors in record creation, discrepancies in disbursed amounts, and incorrect interest rates, thereby safeguarding financial integrity.

Bogotá D.C., Colombia

I enhanced financial integrity and efficiency by automating reconciliation processes, integrating bank transactions with sales reporting. Implemented robust controls that reduced errors in balance reconciliation, ensuring accurate clearing of asset and revenue accounts. This initiative safeguarded against cash shortages and transactional errors at cashier-operated points of sale and online platforms.Some of the responsibilities included:-Evaluating the effectiveness of internal controls related to cash handling, bank reconciliation, and financial reporting processes. -Monitoring compliance with regulatory requirements, industry standards, and company policies.-Using Excel to document control procedures, perform testing, and assess control deficiencies.

Bogotá D.C., Colombia

Providing basic customer service assistance, such as answering inquiries about account balances, transaction history, and banking services.

Bachelor Of Engineering - Be, Industrial Engineering

Associate'S Degree, International Business/Trade/Commerce