Johan R. Email & Phone Number

Menlo Park, CA, US

Nanterre, Ile-de-France, FR

• Led trade reconciliation team globally, successfully delivered migration initiatives of multiple legacy database applications running SQL server 2005, 2008 servers to SG Cloud platform/ MS SQL instances, the project.
• Partnered with non-technical operational teams to implement several data workflows for multiple tier-1 clients and internal stakeholders. The processes enable transparent trade data to identify data issues/client.
• Proven track record to understand business processes fluently, architect scalable solutions analyzing impact across multiple in-house application. Successfully delivered synthetic average pricing reconciliation for.
• Designed and developed data pipeline for non-production legacy platform using SSIS script components to implement table synchronization, the process currently copies over 700 tables with option to configure cumulative.

Nanterre, Ile-de-France, FR

• Developed dashboard for foreign exchange monitoring metrics, leveraging SSIS, SQL functions and views to calculate per minute exchange rate fluctuation, calculation of Nth percentile value based on historic data for.
• Optimized matching algorithm analyzing SQL execution path and trade scenarios, refactored existing SQL code, leverage on binary checksum and addition of computed column to allow for one to one join cardinality for.
• Proficient with ad-hoc queries and custom SQL reports, generated scalable reports to identify performance metrics for individual executing brokers and generate meaningful allocation metrics for client facing team.

Pembroke, MA, US

• Responsible for tax-non filers campaigns in MRS tax compliance unit. This involves use of statistical analysis to identify insights of complex data sets and create accurate list of non-filers.
• Participate in meetings with directors and decision makers' from tax compliance unit and refund fraud management to create data driven strategic approaches to increase tax compliance.
• Actively involved in process optimization of refund fraud reports. This includes analyzing large data set to identify refund fraud patterns, document process changes, implementing code changes, forecast dollar amount.
• Support cross-functional teams in day-to-day execution of inter related processes. This includes monitoring up-time and performance of database and multiple web servers, collaborating with different teams to identify.

Pembroke, MA, US

• Checked raw data file received from several IRS and state sources, responsible for data integrity following extraction, loaded more than 20 million records in 2015 alone, analyzed data in Oracle 11g, projected.
• Developed ETL with Embarcadero DT/Studio, optimized JavaScript and SQL queries in transformation task, improved runtime up to 33% for multiple jobs, established automated process to migrate large data extracts from.
• Entertained client’s AD-HOC SQL request including several complex aggregate queries, created principal reports, recognized and appreciated by the client for accurate result and quick turnaround times.
• Designed and wrote Oracle stored procedures and functions to aid tax calculation process, documented code changes for easy manipulation for future configuration changes.
• Responsible for code migration from DEVL, TEST to PROD server and maintain consistency across the regions.
• Performed database administrative duties, created and updated roles, managed user accounts and security, maintained up-time of servers backing the database, monitored process logs, identified and troubleshoot critical.

• Communicated with project management personnel, gathered specifications, document application and business rule requirement.
• Constructed dynamic web interfaces using PHP, JavaScript along with HTML, CSS, and MySQL database.
• Acquired extensive hands-on experience with advanced SQL, data modelling and database design concepts.

Bachelor Of Science (B.S.), Computer Science

Professional Training, Data Modeling/Warehousing And Database Administration