Benwill Lopez Navarro Email & Phone Number

Puerto Rico

Carolina, Puerto Rico

Main Responsibilities: Proactively identifies, gathers, and analyzes relevant data and complex trends within data environments for fraudulent behaviors and patterns- Deep experience analyzing large datasets with a variety of tools (SQL, Python, Excel, others)- Provide detection of relevant information to improve rules development used for prevention of fraud, piracy and cybercrime with minimal supervision.- Identify possible new rules sets (offline/inline) to proactively combat fraud.- Analyze and review newly proposed rules data for potential impact.- Develops and provides effective recommendations and guidance to Protection Services team members.- Look at the data trends and recommend solutions for creating increased revenue and reducing losses- Transforming data into actionable insights and articulating insights to a broad audience: Risk Management, business management, Analysts, Developers and Program Managers.- Gathers requirements from business users to create new or improved rules for fraud prevention.- Presents findings to peers at a relevant place in the analysis; cross-checks work with peers to ensureprocesses are followed and data are accurately understood- Experience with Synapse Analytics environment including working with Notebooks, Pipelines and Queries.- Experience in development of Power BI Reports and Models.- Work on data engineering pipelines, transformations and maintenance.- Work with complex data systems and databases, as well as experience querying and seeking data from multiple sources.- Experience fraud or piracy investigations.

Hato Rey Central, San Juan, Puerto Rico

Main Responsibilities: - SAP Crystal Reports: Developed and Scheduledcomplex reports using multiple big-datauniverses related to claims, Demographics,Providers, Medicare, Medicaid & CHIP for AD-HOCrequests.- Use of DBeaver UDBMT to develop SQL queries toobtain vast amounts of data directly from theprod. tables.- Hands-on experience with Synapse Analyticsenvironment including working with Notebooksusing core functions of PySpark(sc.) & .pandas,Pipelines and Queries development.- Requirements Gathering and Data ConsumptionModeling for the PRMMIS ecosystem collaboratingwith both internal and external stakeholders.- Developed and maintained essential reports anddashboards for various departments includingfederal agencies like CMS and the Commonwealthof Puerto Rico using PowerBI and Tableau.- Managed and supervised daily data operationsinvolving direct data entry of over 200caseworkers while standardizing reportingtemplates and validating data for strategicdecision-making across seven main regionaloffices.- Led a team of 15 tasked with handlingrecertifications, appeals, and benefit forms,ensuring compliance with PRDOH guidelines- Designed and Standardized the PRMP STEVE PuertoRico Demographic Registry Mortality File fordata reconciliation and validation with the useof R Scripts.

San Juan

Main Responsibilities:- Introduced INprende to Business Intelligencetools such as Microsoft PowerBI and Tableauleading the entire acquisition andimplementation phases allowing INprende tofurther reach company intelligence objectives.- Extensive use of Excel formulas such as:XLOOKUP, MATCH, IF, NESTED FUNCTIONS, COUNTIFS,ETC. depending on the scenario.- Developed and created routine reports anddashboards extracting information from variousdata sources to show patterns and/or trends inthem that allow executives to create processimprovement mechanisms.- Use of SQL core functions to query andPython.pandas to manipulate large datasets.- Developing Python.pandas scripts to perform andautomate data ingestions, transformation andload to database from files and completedreports with the use of BigData_sets.

San Juan, Pr, Puerto Rico

Main Responsibilities:- DataBase administration and complex dataquery's development for data research regardingall type of businesses all around Puerto Rico;Data Transformation with python core functionsand libs as .pandas- Coordinated Microsoft 365 productimplementation.- Designed and established AirDNA (AirBNB) dataextraction, transformation and loaded intoDatawarehouse with azure synapse pipelines.- Upgraded excel visualizations applying bestpractices with the use of PowerBI and Tableaualigned with dept. necessity- Performed EDA procurement audits to maintainfinancial organization on Micro and smallpurchases and RFPs (Request For Proposal)

China

This opportunity was my first step-in into data in a professional environment with around 14 years sparking a love for technology & data that has been growing non-stop and serving as fundamental guidance.Some responsibilities included Data translation in excel spreadsheets, English to Spanish, Documented tasks and procedures completed and kept on SharePoint Reporting and basic solutions for errors in the data being worked on