•Design, build and maintain core data models using LookML, dbt, SQL and python. •Utilize dbt (data build tool) to refine data models and enhance transformations, fortifying our analytics pipelines for sustained growth and efficiency.•Improve BI performance through Looker PDT’s, Redshift query optimization, caching policies, incremental tables and orchestration of data pipeline.•Interface with internal teams to translate business requirements into the appropriate LookML structures: views, dashboards, models, dimensions and measures.•Develop and monitor data security infrastructure for Looker instance: field-level and row-level access controls using access grants, access filters and user attributes.•Systems monitoring and improvement for health of Looker instance using content validator, data tests, and custom system dashboards.•Onboard new data sources through custom API integrations using Python.•Lead new initiatives and experiments related to data warehouse performance, pipeline architecture, scheduling and dependency management.•Regular data audits to ensure high-quality, modular and performant SQL.•Implement and maintain Git procedures, test and version control for data development instancePrimary.Health is the engine behind your COVID-19 testing and vaccination programs. Our web-based platform provides government agencies, schools, healthcare facilities, and community based organizations the ability to quickly register participants, schedule appointments, arrange for easy onsite check-in and check-out, and exchange data between labs and state databases, easing the reporting process.

I'm honored and humbled to have helped over 10 students graduate from CareerFoundry data analytics program and find a job in their new career! My role as a Data Analytics Mentor includes:•Providing motivational feedback and advice to students both in writing and via video calls on creating an industry-ready portfolio of project work in line with current standards and best practices.•Crafting individualized video reviews of student work, highlighting creative successes and areas for improvement to showcase in-demand skills and design processes.•Applying extensive industry experience to guide students on potential career paths within their field of study.CareerFoundry offers online learners the chance to kick-start or advance their tech careers and supports students in finding a job that matches their professional goals. Mentors use their industry experience to work alongside a world-class tech curriculum to provide hands-on practice, real-world advice, and one-on-one mentoring to both students and tutors (junior mentors).

Data Science author and Towards Data Science contributor on topics such as Python, Pandas, Web Scraping, Automation, GeoLocation, Mapping (Folium, Leflet.js).

Core member of Data Driven Decisions team helping to bring transformational change to how data is consumed, analyzed and processed.•Generate insights/monitoring of key product launches through automated dashboards.•Implement machine learning models to better understand customers and make predictions around purchasing behavior. •Data architecting and implementation of data flows to create environment for robust data access.•Web scraping automation to aggregate data and inform key decision makers.

ESL consultant advising top executives using a personally developed curriculum of fluency training, ESL instruction, and coaching. Data Analysis using Pandas: digital marketing analytics, client acquisition, churn reporting, pricing optimization.Increased customer acquisition rate over 500% using web scraping and deep market analysis of competition.Created teaching curriculum from scratch resulting in highly satisfied clients and success in reaching goals:https://www.tusclasesparticulares.com/profesores/patrick-noonan.htm

After a decade in the tech sector, I decided to take a sabbatical to gain fresh insights and pursue my dream of living in Europe. During my time abroad, I worked as an English teacher in Spanish public schools, a truly enriching experience. This journey not only taught me about myself and the world but also allowed me to explore Europe while immersing myself in a new language and embracing the unknown with ease.

•Analyze data with Pandas.•Develop Business Logic in Python.•Product/Project management for key product releases/initiatives.•Automate everything.TrueAccord turns losses into opportunities. The company creates a personalized recovery campaign for your customers, improving recovery while learning about their reasons for default. As a result, you lower your losses while improving your customer life time value and reducing churn.

•Manage data querying, manipulation, automation and analysis across myriad data sources for input into Financial Model.•Produce/design metrics, write queries, create dashboards and automated reporting/insights for distribution to Exec. Team.•Forecast business data including usage patterns and sales pipeline using a variety of tools such as R, Excel.•Ad Hoc Analysis to produce insights on key business initiatives, proposals, strategies and forecasts.•Design/Maintain/Code scripts to produce essential business data tables for cross-departmental use and insight.•Work with cross-functional business groups/datasets including ad operations, yield/monetization, sales, eng. and finance.

•Develop/Maintain automated reporting systems (GoodData Dashboards, Excel templates) for entire sales/sales ops team.•Query internal Hive Database to aggregate, distill and analyze metrics/trends across several departments in Org.•Identify manual processes within Sales/Sales Ops teams and develop systematic, scalable and automatic solutions to needs.•Manage data integrity across systems in organization: Salesforce, Operative, DFP, Ad-Juster, Hive Data.•Ad-Hoc analysis for members of Sales/Sales Ops teams by pulling/distilling large datasets from disparate sources.

•Technical implementation of complex advertising campaigns across multiple platforms including Web, Mobile and Devices.•Communicate with Sales/Sales Planning/Product Management/Project Management/Design teams to execute highly customized/targeted web campaigns.•Product/technical relationship manager with 3rd Party Delivery Aggregator (Ad-Juster).•Worked on cross-departmental team to manage and implement Operative's Dashboard integration into Ad Operations workflow and product taxonomy.Collaborate with Engineering team to test/vet new advertising products and report site/advertising bugs.•Design and maintain automated reporting Excel templates for project management team using custom VBA program.•Go-to technical manager on assigned ad campaigns; answer spec/creative/technical questions, test creative, provide proof-of-implementation.

•Manage, execute and optimize highly targeted online advertising campaigns on CPM and CPC basis.•Responsible for client services/customer satisfaction for all Ad Ops issues after point of sale.•Strategically implement Ad Ops trafficking best practices for Healthline-specific page archetypes.•Upload, traffic and QA Ad Campaign creative using DFP (Dart for Publishers).•Collaborate and strategize with SEM (Search Engine Marketing) team to ensure full ad campaign delivery while ensuring profitable margins.•Pull custom reports using DFP's Query Tool.•Analyze and aggregate complex data reports using advanced Excel techniques (Pivot Tables, •VLookups, Nested Formulas, Logical Formulas, etc.)•Optimize Ad Campaign delivery based on CTR (click thru rate), eCPV (Effective Cost per Visitor), CPUV (Cost Per Unique Visitor), etc.•Organize and assimilate all relevant data into a billing document by pulling reports through DFP, DFA (DART For Advertisers), ATLAS and Pointroll.