Abigail Cruz Email & Phone Number

Toronto, Ontario, Canada

- Data cleaning. Prepared complex large datasets for analyses, by removing duplicated values and outliers, imputing values, and deriving variables in Python. - Data processing. Used Tableau and Python to code marketing metrics and KPIs used to streamline analyses.- Data storytelling. Created visualizations (graphs and maps) for interactive dashboards and presentations. - Data modeling. Contributed to the development of machine-learning and marketing models assessing the profitability of customers, donors, and advertising channels.

Montreal, Canada Area

- Data processing. Cleaned and corrected structured datasets used for the calculations of economic indicators and market segmentations. - Reporting. Developed a report, including the visualization and interpretation of graphs, to assess the market of students’ residences. - Data manipulation. Responded to ad-hoc requests for evaluating housing development proposals through data collection and filtering, and coding of variables.

Montreal, Canada Area

As a research assistant of The Research Program in Historical Demography: - I proposed a new methodology to standardize open-ended questions from administrative records and censuses by using Open-Refine.- Produced indicators to assess the accuracy and consistency of demographic data, including Whipple's Index and data profiling using STATA. - I merged two data sources (administrative records to censuses) without a common ID, by comparing quantitative data (family size, age) and qualitative data (name, occupation) declared in both sources by the person.

Mexico City Area, Mexico

- Produced weekly reports for the board members in which Iauthorized or denied licenses and permits requests to use the radiospectrum, thus preventing anti-competitive practices.- Collaborated in the resolution of the merger between ALCATEL andNokia, by calculating market shares and equity ownership in Excel,and interpreting results supporting the authorization of theoperation valuated in $16.6 billion.- Communicated with clients and internal colleagues to request datarelated to prices, market competitors, and shareholders enabling tocomplete economic analyses and reports under strict deadlines.

Master Of Science - Ms, Demography And Population Studies

Bachelor'S Degree, Economics