• 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

• 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

• 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

• 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

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• Compiled, analyzed, and evaluated data on inventory and allocations using Cognos and JDEdwards• Liaised with other teams in order to consolidate information to be used in allocating products

• 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