Los Angeles Metropolitan Area
Experienced Data professional with a demonstrated history of working in the entertainment/media industry. Strong business professional skilled in Metadata, Data Visualization, Data Integration, and Documentation.
• Lead weekly vendor meetings with DADC and Technicolor/Vantiva reviewing Master Data, Carton Count discrepancies, and various SKU issues • Oversaw two analysts/reports and managed to save 4 hours a week of their workload through the use of macros and Alteryx automation processes. • Utilized Power Automate to facilitate Alteryx processes that identified and decoded system error messages • Designed, built, written custom report pages, set up automatically triggered notifications, scheduled report deliveries • Oversaw PRISM enhancements, and submitted 33 Jira user stories serving as the liaison between the business and IT. Major updates include main screen UI reorganization, configuration debugging, and default resetting. • Standardization and governance of all master data, including owning process flows and standard definitions for governance across a variety of cross-functional systems and processes
Cross border life science technology licensing and OEM acceleration platform. Currently fighting to deliver mission-critical goods for essential businesses and front-line workers within North America. BioBX accelerates cutting-edge medical device and supply companies and help manufacturers accelerate congested supply chain and distribution of PPE, disinfectants, and critical medical supplies for hospitals, government, education, and Fortune 500 companies.
• Apply Python to collect data from the FCC License View’s API to identify geolocation of internal and competitor signal towers then merge data with Nielsen’s DMAs and US Census Data to determine audience reach. • Map, mine, clean 180+ Wide Orbit tables using MSSS to create weekly Financial reports. • Prospect data pipeline tools, integrate multiple sources including Netsuite, Salesforce, ServiceNow and a variety of flat file formats including TXT, XML, and CSV, by using ODBC, Rivery, and SnowSQL to data warehouse, Snowflake, so that different departments can quickly and efficiently store and consume data at scale. • Ensure that data pipelines are highly reliable through data quality assurance and validating all data imported into Snowflake and maintain data quality and accuracy across our records by creating systems to monitor our data for anomalies and inconsistencies. • Connect with the Finance and BI team to aggregate, analyze, extract, normalize, and label relevant data working with to run daily analytics, metrics. • Design, develop, and maintain daily business reports and dashboards using R, Alteryx, Tableau, and other data visualization tools to detect data outliers, anomalies. • Build automated tools and frameworks to report on internal and external databases across programming, marketing, sales, and finance. • Create and manage a backlog of items by documenting business requirements and translating into technical specifications for solution implementation. • Collect Salesforce and ServiceNow logging information, external data, and user generated data. • Developed Boomi workflows to push data from Netsuite and LITO’s Mobrain APIs and various sources to Snowflake.
• Database management of 600K+ titles and 200K+ content versions by building, maintaining, and completing required fields and values. Key liaison with internal and external business units, and lead in researching, compiling, and updating metadata in SPE’s master data and rights management system, GPMS, that feed 100+ systems • Aggregate metadata operations and manage large data sets to streamline critical path servicing needs • Utilize corporate reporting tools such as Business Objects to pull, analyze, and identify trends and opportunities of ad-hoc data; Data manipulation with extensive use of spreadsheet applications • Enforce key business rules and deploy system enhancements for content metadata that has driven ~$50M in digital revenue per year • Develop training materials and quick reference guides; Create data compliance reports to ensure data integrity. Create documentation for use cases, best practices, new standardized operation procedures (SOPs), functionality; Prepare executive summaries for management review