Connor Mcgee Email & Phone Number

Austin, Tx, Us

Campbell, California, Us

Assisted Meta's Privacy team with execution of administrative tasks necessary to demonstrate compliance with 2020 FTC privacy settlement. Constructed Presto SQL queries integrated with Meta’s data pipeline. Integrated queries with dashboard tools to provide live counts of reported Privacy issues by status, subject domain, and type. Performed multiple quality control reviews of internally reporting Presto SQL queries to ensure extraneous results, false positives, and false negatives were excluded. Developed communications strategies for outreach activities among Privacy stakeholders.

Austin, Texas, Us

Sole data position in a medium-sized regional company chiefly operating under a subscription-based model. Performed advanced work to gather, analyze, and compile data needed to identify trends and patterns, and then make recommendations for business actions. Delivered PowerPoint presentation showing original analysis of customer lifetime value and value-impact analysis of the relatively new monthly payment plans. Rapidly learned and utilized API tools to extract email data from company's HR account. Created more efficient secondary databases of sales and new/dropped clients to better analyze key trends. Developed decision tree and accompanying data-flow analysis to demonstrate the complex interaction of our commission reports. Conducted statistical regression analysis of keywords used in marketing materials against advertisement views.

Dublin 2, Ie

Lead data analyst at a social media client’s analyst-driven worksite where Accenture staff reviewed terms-of-service (TOS) violations. Developed Tableau dashboards using client’s internal data pipeline and SQL interface to show up-to-date KPIs, timekeeping, and accuracy of TOS ticket reviewers. Delivered key data insights for site management's forecasted staffing needs supporting future expansion and position placement. Developed live trackers merging accrued hours and projected future hours against monthly sitewide targets; used tracker to inform management of estimated month-to-date totals. Reviewed data pulls for completeness and anomalous errors. Implemented automated tools to spot discrepancies between accrued hours and prior schedules to ensure team leads were fully reporting expected work hours and planned/unplanned absences.

Led independent project to research and write a non-fiction book on the causes and timeline of Uber's battles with taxi regulators from the company's inception through the following seven years. Developed research through dozens of public information requests, online document reviews, and reviews of public testimony and hearings. Personally interviewed over twenty witnesses, including Colorado Governor John Hickenlooper. Managed all aspects of the project under a rigorous deadline, including the hiring of a cover artist and an editor. Published 350-page book on October 2017 via Amazon.com.

Stavanger, Rogaland, No

Division Order Analyst (October 2016 - June 2017) Joined Finance & Accounting team responsible for title research of royalty and override-royalty mineral-interest conveyances between owners of Statoil-operated wells in the Bakken shale formation (primarily North Dakota). Researched title opinions and publicly available databases to calculate net operating interests for comparison to our SAP database. Reviewed ad-hoc inquiries and reconciled prior payments. Contributed to several cleanup projects to correct processing errors from years past. Oversaw the company’s working interests of non-operated wells within the Bakken. Effectively communicated documentation requirements with pending mineral interest owners. Division Order Processing Assistant (January 2014 - October 2016) Maintained a newly implemented database of vendor contact information and updating of vendor payment statuses for oil and gas wells in the Bakken formation of North Dakota and Montana. Oversaw returned checks, researched owners’ chains of title, missing payments, new addresses, and other special projects. Worked to minimize the ledger of suspended payments by researching owners in suspense for unknown address and locating the heirs of deceased owners to commence a transfer. Document Technician (June 2013 - December 2013) Successfully implemented a workaround procedure for the transfer of mineral-well documents between incompatible databases.

Denver, Co, Us

Contributed to an audit team chiefly assigned to the Denver International Airport (DIA) to determine if sub-agencies and programs had effectively achieved stated goals while maintaining strong internal controls and oversight. Audits included the oversight of DIA parking fees, DIA fleet maintenance, and a review of the City's use of funds from the American Recovery and Reinvestment Act. Effectively collected background information, performed data analyses, and interviewed agency personnel. Drafted work papers, concluded on findings, and wrote portions of audit reports in accordance with Government Auditing Standards.

Concord, New Hampshire, Us

Contributed to teams of legislatively assigned performance audits of state-level agencies and programs to determine whether management and operations efficiently and effectively achieved agency goals in compliance with state laws and administrative rules. Selected as team member in audits of New Hampshire's Liquor Commission, Bureau of Elderly and Adult Services, Oil Remediation and Compliance Bureau, Bureau of Behavioral Health, and the state's employee health plan. Effectively performed data analyses, interviews of agency employees and stakeholders, and literary research. Drafted work papers and wrote observations to inform management, stakeholders, and public of pertinent issues in accordance with Government Auditing Standards.

Performed extensive archival research and submitted a report on the circumstances, time line, and relevant parties behind an unsuccessful 1980 referendum for incorporation of Reston as a town of Virginia. Submitted a written report to the Board of Directors upon the assignment’s conclusion.

Austin, Tx, Us

Austin, Texas, Us

Masters (M.P.A.), Public Administraion

B.A., Government