Linda Castro Email & Phone Number

Lynnwood, Wa, Us

Everett, Washington, United States

Created scorecards to monitor and evaluate KPIs for each website and retail store which are automated to refresh and be emailed to stakeholders via Power BI on a daily basis.Created and implemented an RFM customer segmentation program run on a monthly basis.Developed a market basket analysis program and presented my findings to executive leadership.Designed and continuously improving a self-serve reporting portal enabling stakeholders to quickly access insights and answers. This solution has also dramatically decreased the ad-hoc tasks in my backlog.Identify, analyze, and interpret trends or patterns in complex data sets.Design reports through an agile iterative process.

Designed, evaluated, and monitored KPIs, highlighting performance against KPIs and identified developing trends that impacted franchise and title growthBuilt and analyzed live dashboards and reports by utilizing Power BIDeveloped and maintained SQL and KQL to pull, manipulate, cleanse, and transform data from various sourcesCreated, operated, and maintained algorithms and script-driven methodologies for generation analysis and reportsPerformed quality assurance on reports to ensure accuracy and consistency

Worked alongside Chief Finance Officer and Chief Executive Officer to determine appropriate KPI’sDeveloped new insights and analyses that informed strategic decisions to help the business perform to the best of its abilities for each of our clientsMonitored and provided reporting in key metrics across all our portfoliosUsing VBA, created an easy-to-use form with drop-down lists that transferred information to a spreadsheet which ran calculations and refreshed charts and pivot tables to record employee productivityCreated easy to read reports, tables, and chartsAudited employee records to make sure all information was up-to-date and employees had proper testing and documentation using CMS and RankMiner programsEducated peers with tips and tricks on using Excel and various MS Office toolsEstablished risk-based audit programsDetermined compliance with policies and proceduresVerbally communicated findings to senior management and clients. Drafted comprehensive and complete reports of audit areas

Specialized in Android and SDK testing for iOS devicesLogged and tracked bugs in a bug database (JIRA)Regressed and closed bugs upon completionManaged tasks and testing scope for testing projectsRan and created test cases against games and logged issuesWorked closely with producers throughout the product lifecycleAssisting other QA members on projects as needed

Seattle, Wa

Composed correspondence with creative solutions that are both easy to comprehend and to followResearched claims in order to discover any potential technical bugs in the game app and ensure that the customer receives proper compensation, when appropriateMaintained exemplary scores in customer satisfaction surveysImproved an Excel file that tests the compatibility of PC and Mac games; thus making it faster for fellow Representatives to perform Mac/PC conversions for our customersSupported newly hired Customer Support Representatives in their training - Have served as an "Ambassador" and "Mentor"

Seattle

Formatted, updated, reviewed, and analyzed a complex month-end report detailing revenue, revenue adjustments, individual and team metrics, MoM and YoY comparisons, image copyright monitor’s performance, and OCA (Outside Collections Agency) related revenueCreated PowerPoint presentations to share and explain data to different types of audiencesPulled data from IBM Cognos (BI and performance management software)Researched and reconciled the data before updating the information in the systemCalculated daily revenue, settled cases, and Specialist/OCA/Online payment system’s performance and sent out daily non-OCA revenue reportsQueried and compared data from IBM Cognos with data pulled from OracleQueried, packaged, and delivered cases to outside collections agenciesCreated and improved many queriesPerformed frequent reporting via Access and SQL ServerQueried, updated, and uploaded cases into our databaseServed on hiring boards in search of a Product Manager and multiple tempsReviewed and formatted reports in preparation of upload to database and closed non-pursuable casesContributed to discussions regarding the building of a new database interface and tested

Master Of Science - Ms, Data Analytics

Nanodegree, Data Analytics

This program is a pre-requisite for the MS Data Analytics program with Western Governors University. Through this program, I have become.

Data Analysis

Gained experience and knowledge in SQL and Excel. Excel - pivot tables; dashboards; charts; and cleanup, analysis, and visualization.

Certificate, Business Intelligence Analysis, 3.8

Bachelor'S Degree, Psychology And Film