Stephanie C. Email & Phone Number

Culver City, Ca, Us

Oakland, California, Us

Oakland, California, Us

Resume all responsibilities as BI AnalystOptimize and automate ETL pipeline, design and develop SQL datasets; refine and standardize frameworks in Airflow;Develop complex SQL queries in BigQuery environment;Collaborate with and support Marketing and Product Analytics to understand and translate their analytical requirements into technical design and reporting solutions;Recruit and manage interns; mentor and train new BI Analyst;Lead BI Analyst Projects: Looker Admin, Tax Product, Growth Technology, Email & Push Notifications (Migrate legacy email system to cloud service), Growth Marketing & Engagement (Email Attribution), Core Product Analytics (SDU Attribution, Multi-Channel Revenue Attribution), UK Product Launch (Marketing, Product, Experimentation)https://info.looker.com/customer-stories/credit-karma-looker-automating-internal-workflows

Oakland, California, Us

Develop and manage 3rd-party partner and marketing revenue data ETL framework, automation, and operational enhancements using PentahoOrchestrate and implement Partner Revenue Framework Migration from Vertica to Google BigQuery (ETL logic transformation changes and data validation)For all tracking projects, work closely with cross-functional teams (engineering, design, marketing, product) to define tracking specifications, perform data QA validation, develop and design complex SQL dataset query logic, integrate and model datasets and views (LookML), build visualizations and dashboards in LookerCoordinate and conduct multi-level Looker Training courses to over 500+ employees and incoming new employees (covering data exploration, visualizations, dashboards, pivot tables, table calculations, scheduling, data modeling, LookML)Lead BI Analyst Projects: Partner Data Framework Migration from Vertica to BigQuery (April 2016), CK Tax (Product Launch), Growth & Engagement (Logon Traffic Attribution, User Engagement, Web Push, Deep Linking, Karma Pro Tips, Email, Feature Usage, Meaningful Actions)

San Diego, California, Us

Part of the Data Warehouse team, gathered business requirements from project managers and translated into BI solutions (dashboards and visualizations)Worked closely with product managers to create and define data and business requirements for new products; collaborated with developers and QA to ensure accurate implementation; designed and documented mock-up reports and dashboards for new products; and implemented reports/dashboards in OBIEE environmentIdentified data gaps by analyzing and comparing transactional application data to analytical reporting database and data requirementsCreated, designed, and developed dashboards using OBIEE 10g/11g and Tableau Software: reports with drill-up and drill-down functionalities, data visualizations with graphs, charts, maps, etc.Worked closely with BI developers and data architect to map and load data from Staging to Operational Data Store (ODS) tables using Informatica PowerCenter tool; continuous updates to data mappings and documentations as structural changes are released; set up scheduled jobs for batch data loadsPrepared, distributed, and maintained release notes and comprehensive user guides; conducted multi-level training sessions to users and clients on new functionalityDesigned and built complex SQL queries to create ad-hoc reports and delivered weekly to stakeholders and product managers; modified custom report in Excel as professional deliverables; constructed and designed pivot table view reportsAnalyzed and troubleshoot data issues in existing reporting application; suggested development fixes or requirement changesLead BA on Projects: OBIEE 11G Upgrade, Driver Experience Analytics, Estimate Check Analytics, Autosource Specialty Analytics

San Diego, Ca, Us

Managed the lifecycle of Problem Reports by researching root cause of incidents, making temporary and creative solutions (workarounds), analyzing and documenting reported system defects, prevent recurring incidents, and develop final solutions for errors; in addition, replicated and analyzed issues in multiple environments and across release cycles to isolate and pin-point root causes and probable fixes to system defectsReported issues directly to the Service Delivery Manager and Support Desk Manager and acted as interim lead when necessaryConducted and led weekly calls with Government Services Administration (GSA) while providing weekly status update of problem reports, high impact issues, and maintenance release updatesParticipated in weekly status meetings with technical leads and managers, providing updates and feedback to internal and external issuesAssisted support technicians with questions on system issues and business logicCommunicated and collaborated closely with software developers, quality assurance testers, business analysts, and configuration management team to efficiently determine problem resolutionsParticipated in monthly maintenance releases to provide support validations, troubleshooting, and ensuring system functionality is stable post-release. Confirmed deployments were implemented and released to production as expectedWorked directly with BIRT (BI Reporting Tool) developers by gathering data requirements from GSA to develop SQL reporting logic

San Diego, Ca, Us

Developed and executed ad-hoc and recurring analysis reports in Oracle environmentResumed all responsibilities as a Level 1 support analyst while also mentoring new and existing support analystsApproved and Implemented SQL table DDL (update/insert/delete) statements in Oracle environmentResearched, validated, and documented problem/bug reports; work with software engineers on fix and QAVerified production implementations through QA validation

San Diego, Ca, Us

Technical Support for Assisted Acquisition Services Business System (AASBS) to General Services Agency (GSA) users and government clients and contractorsResearched, analyzed, and troubleshooted technical issues for various federal government applications and modules (FPDS, RBA, AASBS, GWAC, ITOMS) while providing in-depth answers to application questions or troubleshooting needs; resolved customer requests by providing creative solutionsAnswered overflow support calls; resolving users’ technical issues over the phone or documenting incident ticketsWorked independently, as well as in a team with other support analysts, software developers, and DBAsTested and verified software changes and releases into productionWrote SQL in Oracle environment; prepped production-level DML update statements for implementationSpecial Projects – GWAC Connections I Data Migration (02/2012 – 10/2012): Implemented mapping and loaded internal and external GSA data sources into internal target database tables using SQL Loader. Wrote SQL scripts to perform manual migration and validation checks of orders and fields into the Governmentwide Acquisition Contract Management Module (GWAC MM). Verified scripts and validations in testing environment to ensure accuracy before deploymentFPDS Weekly Status Sync (Federal Procurement Data System - Next Generation): Generated reports from internal and external systems. Used Microsoft Access to compare status discrepancies between internal and external systems. Ran internal system tool to refresh and update inconsistent statuses to match internal and external systems.

La Jolla, Ca, Us

Assisted in the COGA Study (Collaborative Studies on Genetics of Alcoholism) - (http://psychiatry.ucsd.edu/faculty/mschuckit.html)Mass data entry into Microsoft Access databases and perform data scoring using ADM (Assessment Data Manager) softwareWorked closely with research technicians to discuss subjects’ interview data and answers to questionnairesOrganized subjects’ data into portfolios and sent out mass mail to subjects regarding database informational updatesCOGA Project:http://www.niaaa.nih.gov/research/major-initiatives/collaborative-studies-genetics-alcoholism-coga-studyhttp://www.jsad.com/jsad/static/about.html

Bachelor Of Science (B.S.), Mathematics And Computer Science

Education record