Peter Berntsen, Mba Email & Phone Number

Shelton, Ct, Us

Greenwich, Ct, Us

▪ Oversee day-to-day deliverables and performance of 6-person team, reporting into VP of Analytics▪ Review and prioritize incoming requests from internal and external clients, allocating the best suited personnel and other resources as needed▪ Ideate, generate, and QA new SQL scripts, Tableau dashboards, auto-refreshable datasets, bulk mailings, etc. for all reporting suites▪ Ensure availability and accuracy of data through creation of efficient ETL processes▪ Create, lead, and act upon brainstorming committees across departments to optimize client-facing reporting for relevance and aesthetics▪ Attend client-facing meetings with Client Management team to provide answers to technical questions▪ Manage all incoming requests for reporting enhancements, communicating and prioritizing each according to relevant stakeholders▪ Lead projects for team of 8+ international third-party developers, providing instructions, guidance, feedback, and direct contribution in data warehousing, reporting, and production environment architecture / user interface enhancements▪ Design intricate LLM prompts to fully automate adaptation of hundreds of production environment SQL scripts for functional use in data warehouse environment, including consolidation of code, notation, and appropriate use of variables in place of hardcoded strings▪ Integrate web search results into custom ad-hoc reporting needs using Google Cloud API-enabled Python process

Stamford, Connecticut, Us

▪ Write SQL queries around knowledge of current business rules to identify billing errors with large financial opportunity▪ Lead project meetings to discuss unusual business rule violations within each data system and facilitate collaboration between multiple departments on solutions▪ Bear ownership of monthly processes to provide senior management with regular revenue flash reports, summarizing monthly revenue by geography, billing system, General Ledger IDs, product, etc.▪ Create, automate, and maintain weekly reports for quantifying previously defined business rule errors in all billing systems, tracking progress of any resolutions implemented▪ Perform data mining and account-level analysis by request to validate business rules, find new errors, answer questions, and provide insights▪ Identify and communicate no less than $15M in unrealized revenue opportunities per year ▪ Provide weekly booklets summarizing and comparing actual revenue streams vs. cash flow forecasting based on multiple databases, monitoring data daily for variances and discrepancies▪ Monitor trouble call, work order, and PPV activity for insights and trends▪ Maintain ownership of dozens of simultaneous projects, processes, and ad-hoc requests, autonomously identifying priority level and critical path for each

Norwalk, Ct, Us

▪ Design universally compliant Excel templates for event recapping, invoice tracking, etc., using conditional formatting, advanced data validation, and selective worksheet protection▪ Optimize bulk communication with variable field mail merges linked to company datasets▪ Create dynamic surveys in Qualtrics, Survey Monkey, etc., and extract data into customized client reports▪ Develop reports to identify missing, duplicated, or dysfunctional data▪ Track performance of third-party vendors through data analysis and provide insights/feedback▪ Communicate across departments to identify and fulfill automation needs▪ Integrate multiple databases for cross-functional analysis and applications▪ Create client-facing reports, visuals, metrics, slides, dashboards, and other materials▪ Originate data-handling best practices and share via presentation among coworkers across all departments▪ Successfully designed database ERD in 3rd normal form to link data from all programs▪ Forecast ROI for all marketing campaigns using pertinent KPI and financial figures

Arlington, Virginia, Us

▪ Lead and train a team of military police officers for foreign and domestic operations▪ Deployed to provide active-duty administrative support of Operation Enduring Freedom (2012-2013)▪ Served in security detail for First Lady Michelle Obama during Westpoint football event (2012)▪ Activated as emergency Humvee driver during natural disasters including Hurricane Katrina (2011) and Storm Nemo (2013)

Norwalk, Ct, Us

▪ Maintain integrity of 2,000,000+ account database, identifying and resolving discrepancies in real time▪ Collaborate with dozens of utility companies to resolve abstract dataflow complications ▪ Generate flow charts to map rules of function and define order of operations for automatable processes ▪ Conceptualize and implement account transferring procedures from internal database to third party agency’s▪ Optimize work procedures to increase daily account adjustments to 400% of team average▪ Design VBA modules, mail merges, and other tools to reduce manual workload of department

Westport, Connecticut, Us

▪ Create weekly POS reports using Nielsen data and other sources▪ Pool client and competitor sales information into company database for forecasting▪ Established cost-minimization standards, reducing sales team shipping expenses by 40%▪ Converted Excel database to Microsoft Dynamics and identified programming needs for new system

▪ Process donation pledges, payments, and receipts▪ Create and maintain customer databases in QuickBooks and salesforce▪ Manage tax returns, employee payroll, trade name registration, revenue forecasting, etc.▪ Organize and send newsletters and other direct mailing to customer base

Master'S Degree, Mba, Data And Technology Management

Bachelor'S Degree, Economics

Liberal Arts And Sciences, Math & Science Concentration