Alex Orozco Email & Phone Number

Englewood, Co, Us

Denver, Colorado, United States

o Developed and managed comprehensive ad streaming analytics, integrating dozens of API and email feeds from ad servers (FreeWheel, Publica) and SSP providers into Google BigQuery using ETL scripts. Established multi-frequency reporting as well as decision triggering alerts on data and revenue trend anomalies. o Replicated and enhanced third-party Ad & Revenue reporting Enterprise Application within Google Cloud Platform, including historical data and logic migration, improving business logic and cross-functional reporting capabilities while reducing operational costs. o Managed Double Verify Unified Financial Ad Reporting Enterprise platform, ensuring data quality, enhancing feeds, and identifying ad serving opportunities through custom dashboard creation.o Established secure data exchanges with Credit Union companies using AWS S3 buckets and AWS GLUE jobs for customer segmentation and targeted advertising. o Collaborated with FreeWheel to enhance machine learning algorithms and improve anomaly detection in advertising trends. Established troubleshooting processes internally to triage and react to such alerts.o Monitored, optimized, and maintained multiple supply and demand partner data feeds, applying transformation rules to provide actionable insights for operations and financial teams.o Led cross-functional data projects from conception to delivery, utilizing Agile methodologies. Managed internal employees and external contractors through all project phases, including requirement gathering, complex data processing, and reporting initiatives. Effectively used JIRA Epics and Kanban boards to guide teams and achieve data-driven objectives.

Denver, Colorado, United States

- Designed, implemented, and maintained ETL solutions for Comcast data across multiple platforms (e.g., Steel Cloud, CCP, Databricks, AWS, Snowflake), addressing server and Cloud Prisma vulnerabilities within SLA.- Integrated cybersecurity data from Crowdstrike and Symantec into Databricks via APIs and database connections, producing security compliance reports across Comcast.- Managed cross-platform connectivity and security, overseeing firewalls within AWS VPC and Comcast TSF, and supporting developers’ environment requirements.- Led pricing, performance, and security analyses across Google Cloud, CCP, AWS, and Databricks; ensured data quality during audits by verifying source-to-destination data accuracy.- Administered TeamMate Audit software for 170 users, handling upgrades, data migrations, connectivity, and vulnerability management.- Optimized ETL platforms and orchestration tools, training teams on UC4, XGears, and data lake environments; established ongoing support with data tool teams.- Conducted quarterly cybersecurity audits using Crowdstrike, Uptycs, Eracent, and Symantec CCS, with detailed vulnerability reporting.- Directed Comcast-wide asset management integration, consolidating server data in ServiceNow, IOP, ITRC, and Eracent, creating dashboards to address discrepancies.Instructed and mentored in the FullStack DevOps program, advising on suitable Comcast data platforms for participant projects.- Completed the Data Science Academy, developing predictive models using Python and Scikit-Learn, including Decision Trees and Random Forests, to forecast customer service downgrades and SLA-exceeding vulnerabilities.

80112

o Improved Voice traffic reporting accuracy by 20%. Created interactive dashboards monitoring and trending source data, implemented notification logic on unexpected data fluctuations by moving averages. o Developed ad-hoc queries via MsSQL, PLSQL, MySQL, and Big Data query tools such as HIVE, Vertica SQL, PrestoDB, and Datameer, identifying and testing trends. o Worked with Carrier finance teams to prepare billing disputes amounting to 100K yearly, creating ongoing customized reporting for monitoring carriers in question.o Tested proprietary Big Data platforms performance on Hadoop clusters through Datameer configuration settings.o Created and interpreted multiple regression model results through Minitab & Excel to determine which CDR behaviors (i.e, SIP errors, Long PDD) contribute to low answer call completion rates by carrier. o Elicited, defined, and proposed reporting requirements. Identified optimal data sources, created and maintained actionable Tableau, Datameer, and Excel reports. o Analyzed and documented system rules on data collection, mediation and loading for video systems. Created and maintained logical and architectural system diagramso Through Python scripting, replaced third party vendor software and saved $150K. Scripts tested web-service availability and notified if services unresponsive. o Led and project managed MSSQL Database migrations of over 40 TBs of data and nearly 100 DBs analyzing stored procedures, server specs, reporting dependencies, determined priorities, created project plans, modified scripts, communicated project plan, delegated activitieso Maintained over 50 Windows & Linux Virtual Machines analyzing hostmon metrics, DB processes and Security vulnerabilities. Used Symantec Qualys scannero Utilized SOAPUI to verify and document application behavior via XML transactions.o Improved database design and query performance by interpreting execution plan, utilizing partitions, or creating indexes on large and joined tables.

Greenwood Village, Colorado

IMS Network Architecture Analysise911 Routing, Maintenance & SupportSoftware Requirement Analysis & CommunicationNetwork SIP Error Code AuditCall Processing Cost AuditDS1-DS3 Trunking Cost AuditCode Administration AuditPremise Wiring AuditDS1, DS3, OC48, Transport Cost SavingsCisco BTS VoIP SwitchesCedar Point Safari VoIP SwitchesSONUS VoIP SwitchesDS1, DS3 Testing

Implement & Audit E911 Routing TranslationsImplement, Adjust, and React to 911 network alertsCisco BTS VoIP SwitchesCedar Point Safari VoIP SwitchesSONUS VoIP Switches

Broomfield, Colorado

Monitored & supported capacity for SIP Traffic

Lone Tree, Colorado

DS0, DS1 Testing5E supportSONUS supportPBX support

Thorton, Colorado

5E, DMS, SONUS supportRouting TranslationsSwitch MaintenancePBX support

Greenwood Village, Colorado

Monitor and Troubleshot Premise and Network HealthLocal Number Portability/NPAC

Master Of Science In Leadership, Organizational Leadership, 3.8

The Master of Science in Leadership at GCU cultivates candidates' leadership styles, introduces advanced leadership models.

Network Architect, Computer And Information Sciences And Support Services

Network Architecture

Bachelor Of Business Administration (B.B.A.), Business Administration And Management, General

Business Management

Marketing, Business, Management, Marketing, And Related Support Services

Marketing, Statistics

Marketing, Marketing

Marketing

Education record

SQL