Andrew Gutierrez Email & Phone Number

Newport Beach, Ca, Us

Los Angeles, Ca, Us

Databricks Platform Administrator / Advanced Analytics and Data Science Development Consultant• Enabled data engineering and advanced analytic teams to develop and deploy applications through an evolved CICD pipeline. This included hands on development workshops and playbooks created to facilitate framework adoption which explains the required components and steps in application development• Streamlined access management patterns across server tenants for AWS, ADLS and AD services for end user consumption at the local and production level• Created pattern for Databricks model adoption and integration into existing production level applications • Automated DevOps activities like agent version management, workspace scaling and network traffic management Marketing, Sales and Services Engineer • Curated production level processes that consolidate email campaign metrics and engagement activity. We are able to accurately identify bot activity and subsequently remove fictitious engagement as well as incrementally track existing profile activity from the previous four years. This feeds into our engagement model as a facet that is used to calculate an overall engagement profile across all our channels for content delivery• Evolved separate and critical web domain processes into products that had combined development backlogs. By consolidating backlogs and requirements we can easily assess impacts and development plans across all web domain components for instance - ingestion, ETL, reporting and model serving• Completed end to end taxonomy solution to consolidate our content across domains including web, print, email and event contexts. By centralizing our content model, we can accurately curate content catalogs that would be a foundational component for engagement tracking and profile generation. This required upstream integration of a trackingIDs across various platforms and teams

Los Angeles, Ca, Us

Databricks Platform Administrator / Development Consultant• Onboarding business units, workspace administration, active directory integration, training facilitation• CI/CD support and maintenance, dev ops streamlining, pipeline creation and repo management - NexusIQ, Veracode Integration• Networking Coordinator - Firewall, certification and traffic managementEnterprise Feedback Management Program• Technological lead and solution architect - Audience targeting, feedback harvesting, response modeling, sentiment analysis, ETL and reporting integration• Secondary phase included growth from 1 survey to 20+ targeted surveys and feedback interactors

Los Angeles, Ca, Us

• Implemented and managed technology solutions to profile, monitor, and manage data quality in data significant applications in addition to automating the acquisition & provisioning of metadata from these applications. • Gained in-depth understanding of CG's data landscape through exposure to data significant systems and data flows spanning Investment Management and Marketing, Sales & Service, and supporting capabilities. Applied the knowledge in root cause analysis of data quality issues in IIS products (IDH, LASR, etc.) and their sources using Data Quality & Metadata tools.• Leveraged emerging technologies to advance data quality & metadata management objectives, e.g., use of machine learning in advanced data profiling & exception detection, auto-classification; publication of metadata and data quality insights through APIs. • Built active relationships with business leaders who are owners and stewards of enterprise data, developed understanding of business priorities enabled by data, and leveraged these relationships in mobilizing action on quality issues.• Facilitated the adoption of enabling technologies to achieve higher maturity in data governance.• Articulated data quality issues, performed business and IT impact assessment, and developed solution alternatives to facilitate Data Governance & ARB decisions. • Accelerated projects and improved solution quality through early assessment of data quality issues that impacted business outcomes. • Leveraged transformation project contexts to address systemic data quality issues.• Engaged architects, application team data SMEs, and data governance business analysts in impact assessment, prioritization, and facilitated solution decisions.• Facilitated enterprise initiatives and regulatory compliance directives with solutions that leverage metadata, e.g., privacy regulations.• Promoted visibility of systemic data quality issues among data engineers across CG and related solutions/workarounds.

San Francisco, Ca, Us

• Created visualizations and dashboards using Qlik Sense to analyze client, consultant and practice area comparisons in relation hours and revenue. • Planned, executed and managed Amazon Web Service resources and environments for SAP services and ETL projects.• Performed SAP Data Services and SAP Information Platform installations/standups using Amazon Web Services.• Supported Data Service error handling in development, quality assurance and production environments.• Provided pre-sales support of reporting, planning, and analyzation technologies including SAP Lumira and Business Objects Cloud. Created demo scripts that illustrate data anomaly identification and the ability to make data driven decisions based off of these findings. •Comprehensive training in:o SAP Business Objects (Data Services, Information Steward, Webi, Lumira, Explorer, Design Studio, Cloud): -Developed applications on various platforms to consume data from multiple sources. Analyzed data to create situations highlighting the functionality and capabilities of said technologies. -Gathered requirements to understand business pain points, utilized data discovery tools to leverage visualizations and dashboards in identifying key issues and trends, and implemented cross-functional drill-down capabilities.o SAP Netweaver Business Warehouse: -Familiarized with system architecture, leveraging BI Business Content, extracting and loading external data through layers into InfoCubes and MultiProviders, and creation of Business Explorer queries to build reports.o SAP HANA: -Gained an overview of the fundamentals of data provisioning, modeling, and building applications using HANA extended application services. -Used Zeppelin to define Vora tables from data stored in HANA and HDFS to then load and created visualizations in Lumira.

Bachelor Of Science (B.S.), Business Information Systems

Associate'S Degree, Business Administration And Management