Fernando Medeiros Email & Phone Number

Paris, France, FR

Boston, Massachusetts, US

• Multi-task effectively in creating and managing multiple projects related to data aggregation, analysis and visualization providing key effectiveness insights in marketing, operations, and reporting
• Identify and apply data mining and analytic methodologies to identify or forecast trends assisting in targeting and constructing segmentations of the addressable market to survey for career exploration research purposes
• Manage the organization-wide data warehouse infrastructure for processing performance and concurrency to support responsive dashboard
• Build end-to-end BI and analytics solutions by ingesting internal and external data, including web scraped data, into the Snowflake database and developing Tableau dashboards supporting insight development and.
• Develop and maintain ELT pipelines using SQL to perform data manipulation and transformations on data from the staging layer through ODS and into reporting warehouse
• Automate secure data transfer processes to and from external partner organization using Python saving the organization significant manual processing time and revenue through labor savings

Boston, Massachusetts, US

• Utilized effective oral and written interpersonal communication in coordinating with all department and stakeholders on multiple subjects engendering a positive and welcoming environment for all
• Exercised solid judgement and attention-to-detail to advise and consult the organization on data strategy, data management, reporting and analytics across the entire organization to deliver timely and precise.
• Used excellent leadership skills to lead data team in delivering value on multiple projects including return on investment of campaigns and dashboard development
• Conducted regression analysis using internal data blended with public data to predict/quantify impact of campaigns on post-secondary schools’ cohort default rate initiating the decision for organization-wide.
• Prepare and cleanse phone call notes through use of a word cloud in Power BI identifying phrases (n-grams), to assist with caller discussions and improve talking points in student-loan counseling

Boston, Massachusetts, US

• Supported the business in developing data flows supporting project requirements to guide relevant departments in the appropriate and effective use of the data to respond with timely and targeted modifications in.
• Led and engineered the consolidation of the manually-executed marketing campaign selection process distributed amongst four campaign analysts into a single automated process managed by a sole analyst increasing.
• Converted post rehabilitation campaigns from manual, file-driven processes to BPMS platform through process automation to allow for more timely campaign execution and readily accessible reporting
• Performed cost assessment of campaign activities and associated outcome value assisting the business in forming better financial decisions resulting in a reduction of less effective and costly print collateral from.
• Applied econometric modeling to quantify the optimal monthly communication quota and implementing the optimum contact rate resulting in maximizing the call center resources
• Performed complex data analysis in support of ad-hoc and standing requests and providing actionable and insightful information to improve data processes and campaign strategy

Boston, Massachusetts, US

• Developed clear, well-structured analytical plans and analyzed large data sets with 250M+ records to assist the business in shaping the data infrastructure moving forward resulting in highly efficient and accurate data.
• Utilized excellent oral and written interpersonal communication skills to translate and elucidate identified data gaps impacting fulfillment of functional requirements for the business to proactively resolve issues and.
• Ensured timely data-loading to maintain accuracy of sensitive business-critical information used within the data department safeguarding integrity and security of important information
• Developed comprehensive data sets of standardized records that are used by the analyst team to conduct campaign assessments timelier and with improved accuracy
• Investigated data integrity issues and recommended appropriate solutions, including database enhancements, process workarounds, data correctness, and campaign resource management, to improve process performance.
• Used SAS and Task Scheduler to set up automated alerts proactively identifying data and process issues early to apply resolutions promptly and avoiding downtime or gaps in critical infrastructure

Boston, Massachusetts, US

• Leveraged expertise in database programming principles and best practices to create efficient and reusable SQL code to facilitate uniform segmentation logic and data definitions for standardizing campaign selection.
• Utilized Data Analysis skills to develop regression models identifying macroeconomic indicators for student loan borrower default
• Designed and instituted, utilizing A/B split testing methods, controlled experiment standards and procedures for the marketing team that ensures valid test results for data-driven decision making of marketing.
• Developed and designed extract-and-transform data procedures for recurring analyses and summaries of findings toward improve borrower selection and segmentation to increase campaign effectiveness
• Prepared comprehensive and concise documentation that includes problem definitions, proposed solutions, detailed requirements, outstanding issues, and recommended implementation approach to standardize procedures and.
• Maintained oversight of campaign data files to ensure accuracy and on-schedule delivery of student-loan borrower communications

Data Science Certificate, Data Science

Master'S Degree, Applied Economics

Bachelor'S Degree, Management Science For Finance, Economics