Danielle Copeland Email & Phone Number

New York, NY, US

• Analyzed $10M+ weekly advertising spend to assist leadership in better prioritizing spend across states by developing and maintaining pipelines and workflows that transformed data from various sources
• Sped up weekly analysis by 10x by ingesting and transforming data from external files in Google Cloud Storage using dbt and python
• Created dynamic dbt models to allow for quicker analysis and troubleshooting of data by developing macros that remodeled and standardized tables and reduced duplicate code
• Drove allocation of $250M+ of digital and mail marketing spend to highly targeted voters based on demographics and geographies
• Increased the number of voters reached by recommending programs and stations to place ads for various demographics and geographies based on tv viewership data
• Directed placement of digital out–of-home advertising to reach more voters by creating dynamic models that populated city specific spreadsheets

New York, NY, US

• Built a pivot table that tracked contractors’ time and cost to allocate developers’ work to more profitable projects
• Ensured domain knowledge and mapping remained consistent during system upgrade to guarantee accuracy
• Conducted quarterly data quality checks to certify reliability and completeness on reports that impact 1600+ users
• Created new and modified existing reports and analytics for users on the Cognos platform to increase satisfactiON
• Connected with user community to deliver weekly platform training and address questions/issues

New York, NY, US

• Developed a Kibana dashboard for visual analysis of performance using ElasticSearch for real time analysis
• Tested changes to the domain specific language and integration of APIs into MSCI Beon analytical system
• Managed weekly scrum events, blockers, JIRA backlog, and analyzed burnout charts to increase team productivity
• Maintained automatic testing framework through investigating and diagnosing code issues to validate data quality

Milton Keynes, Buckinghamshire, GB

• Documented the inputs and data validations for XML APIs to map the internal and external field requirements
• Consulted with 10 stakeholders to define and document business needs to verify product upgrade success
• Investigated 100+ system issues raised by users in order to pinpoint the root cause for the development team

Minato-ku, Tokyo, JP

• Sales Forecast and Inventory Operations
• Created and edited spreadsheets from databases and verified accuracy and completeness of reports
• Compiled monthly purchase reconciliations and maintained yearly reconciliations
• Managed spreadsheets using advanced spreadsheet skills: pivot tables, vlookup, VBA
• Designed a large macro that reduced the time needed to run monthly analysesSales Operations
• Assisted sales teams with operational tasks, such as submitted manual orders and follows ups with vendor

• Researched and analyzed different stocks and mutual funds to be added into existing client portfolios
• Conducted due diligence for new clients and risk tolerances for their financial and personal circumstances
• Collected portfolio data for client meetings to discuss current performance and provide advice

• Oversaw employee work and data on a variety of special projects with approaching deadlines
• Participated and generated ideas in regular meetings with the Director and Deputy Director
• Acted as a liaison and improved communication between different groups working on projects

• Researched, extracted, and compiled basic information and data for research projects conducted
• Assisted in the evaluation and analyzation of data sets through computerized statistical programs
• Conducted a small research project analyzing the admission and completion of certain minors

• Initiated a way to reduce the errors in financial reports
• Collected and organized data in order to analyze decades of financial data
• Led a team whose main goal was to come up with ways to make the department more efficient

• Categorized and indexed garnishments and deductions orders and releases
• Distributed new orders and releases to keep information updated
• Duplicated and prepared documentation for clients and marshals
• Organized files into social security order, allowing workers to find financial papers that pertain to a certain client more easily

Master Of Arts (Ma), Economics

Data Analytics

Bachelor Of Arts (Ba), Economics