Pedro A Avalos

Business Intelligence, Data Science and Analytics @ Conagra Brands

About

I am a creative technology leader with a strong business knowldege background. Thrive at identifying and driving new technologies in support of business objectives. Adept at serving as the primary point-of-contact and “thought partner” for the rest of the organization to support problem identification, generate ideas, and identify potential technology solutions. I leverage my experience as a developer to drive analytical solutions and reduce human touch time to a minimum using massive data sets/applications. Skill & Tools: - Environment: Databricks, AWS (Amazon Web Services), Tableau Desktop 2018.1.5, 10.4, 9.2, SAP Business Objects, Alteryx, QlikView v11, Tibco Spotfire, SAS, IBM Cognos v10.2 (Report Studio, Query Studio, Analysis Studio, Event Studio), Agile methodology - Development: SQL, Python - Interface: Aqua Data Studio v 7, Oracle SQL Developer, TOAD

Country

United States

City

Greater Chicago Area

Industry

Financial Services

Skill

Attention to Detail, Big Data Analytics, Data Integration, Python (Programming Language), Data Analytics, Extract, Transform, Load (ETL), Azure Data Factory, Data Engineering, Azure Data Lake, Consumer Goods, Revenue Recognition, Financial Reporting, Financial Analysis, Sarbanes-Oxley Act, Forecasting, Process Improvement, Access, Analysis, Budgets, Business Analysis

Experience

Business Intelligence, Data Science and Analytics

Conagra Brands

2022-6 - 2024-11 · 2 yrs 6 mos

Chicago, Illinois, United States

Business Intelligence, Distribution and Sales Reporting

Nuveen, a TIAA company

2020-2 - 2022-6 · 2 yrs 5 mos

Chicago, IL

Data Management and Business Intelligence

Goldman Sachs

2017-1 - 2019-6 · 2 yrs 6 mos

Chicago

•Oversaw and executed direct marketing campaigns, end-to-end, including creating campaigns, segment audience lists, and analyzed/measured performance and identify optimization opportunities which resulted in an additional $43mm in deposits at year-end. •Created Executive Tableau dashboard for CEO and CTO that identified KPI's across all divisions (US Deposits, US Lending, UK Deposits, Goldman Sachs). Dashboard replaced 7 FTE's originally needed to generate this weekly report and automated the report. Provided executives the ability to do on-demand analysis, and the dashboard receives five times the average number of views per week. •Directed the design and development of firm-wide Tableau dashboards, workbooks and complex parameters-based calculations that tracked Goldman Sachs bank KPIs. •Managed assigned Developed Tableau dashboard that tracked outflow of dollars from US Deposits platform, which included monthly cannibalization figures from OSA’s (online savings accounts) to CD's. •Provided training on SQL best practices to maximize query performance and reduce processing time. •Directed projects from end-to-end, oversaw and tracked timelines, risks, and deliverables using Agile.

Associate - Data Analytics and Insights

Goldman Sachs

2016-4 - 2017-1 · 10 mos

Chicago

•Collaborated with stakeholders to identify important business data analytics, determine where information is stored, and develop methods to retrieve and report on data, using business intelligence applications. •Defined business intelligence project requirements by establishing project milestones, phases, and elements. Monitored project progress by tracking activity, resolving problems, publishing progress reports, and recommending actions.