Laura Romanschi
Bothell,WA
Summary
Seasoned analytics professional with a focus on Business Intelligence and Data Warehousing. Domain knowledge across E-Commerce, IT, Computer Software, Retail, Healthcare, Education and Telecommunications. Objective: Be part of a dynamic team that is poised for growth and drives initiatives to increase the company revenue while building loyalty with customers.
Overview
11
11
years of professional experience
Work History
Business Intelligence Engineer II
AMAZON
07.2019 - Current
- Member of Pricing BI team, enable data driven business decision making within the realm of Retail Pricing org worldwide
- Primary lead for all analytics related to Internal Matching in Retail Pricing
- SME for Lost Featured Offer (LFO) primary metric to measure the success of Internal Matching and currently consumed by 100% of users (Product Managers, Vendor Managers, In-stock Managers, Brand Managers) across Amazon
- Experience handling confidential information and discretion with sensitive materials due to legal pricing responses
- Owner for deprecating cluster dedicated for QuickSight dashboards; Effort estimated to have saved 3TB size & 25K/yrly.
SR Business Intelligence Analyst
NORDSTROM
09.2017 - 07.2019
- Design, build, and maintain a suite of BI Tools and Tableau dashboards designed for insight to NCOM customer experience and particular product pages
- Drove the quarterly change requests process by establishing a successful partnership with NCOM Business teams to understand their analytics needs and look for opportunities to enhance our product offering; focus areas of automation, scalability, actionability
- Collaborate with other BI Analysts and Engineers to develop data/table structures in both on-prem and cloud-based data stores, optimizing for Tableau dashboards and other self-service needs.
BI/DW Consultant
SIRIUS Computer Solutions
01.2013 - 01.2017
- Deploy Test/Dev/Prod Tableau servers from AWS on EC2 instances, perform tuning and troubleshoot access having SSL certificate and proxy server in place, behind firewalls
- Optimize data sources, dashboards, access new data sources in highly secured environments
- Configure SAML single sign-on with Azure Active Directory, Okta and local authentication
- Responsible for Tableau Server maintenance processes and backup automatic jobs daily to S3
- POC for upgrading Tableau Server in Dev and Prod from version 8 all the way to 10.X
- Maintain Tableau Server with over 1,700 users, developing strategic dashboards
- Statistics dashboards on server usage and space usage for data sources - Netezza databases and tables
- Facilitate migration from on-prem server to OneCloud, switch to SAML configuration
- Develop data visualizations and custom reports utilizing Tableau and SAP Business Objects
- Respond to a wide variety of Commercial Real Estate (CRE) business analysis requests
- Support the ongoing development of the CRE data warehouse with use-case feedback
- Assist the accounting teams during the yearly audit with questions on the code logic behind some of the reports selected for auditing
- Work with clients across the CRE, Space Management, Lease Administration, and Retail teams to determine report and project requirements and create specifications as needed.
Project Manager / Business Analyst
MICROSOFT CORPORATION
- Member of Treasury Project Management team to design next generation intelligence reporting tool for MS Credit and Collections, enabling Credit Services to continue evolving as an organization (while sunset old tools)
- Track indicators for lifecycle management and generate SDLC documentation, tracking project’s progress status between offshore teams and local stakeholders
- Coordinate data import/export feeds to Treasury applications from SAP platform
- Drove the quarterly change request process by establishing a successful partnership with Treasury, Tax, and Finance IT groups
Data Developer/Analyst (Dean of Medicine)
UNIVERSITY OF WA MEDICINE
- Consolidate feedback on eLearning courses delivered on UW Medicine
- Perform quantitative /qualitative analysis of the data extracted from LMS and from quiz-building tools (Catalyst)
- Develop executive dashboards, aggregating and distributing statistics on training and eLearning completion for executive reviews, and providing visual aids in MS Excel
- Administer UW Medicine’s Procedure’s Consult account and generate usage reports
- Write SOPs for end-users regarding the access and use of various reports.
Computer Specialist
HARBORVIEW MEDICAL CENTER
- Collaborate with Sr. Report Analysts on various radiology projects including systems integration and generating reports
- Populate data dictionaries in GE Centricity RIS IC according to UW Medicine IT standards
- Perform over 2,000 record merges in GE Centricity RIS
- Assist with “go live” of new application, Patient Call Manager (over 500 users), including compiling, organizing, and updating data for existing and new users
- Test documentation of different system procedures for GE Centricity RIS IC and McKesson Surgery downtime resource map procedures
- Assist Network Engineer with project to bring all radiology computers into System Center Configuration Management.
Online Instructor
BELLEVUE COLLEGE CONTINUING EDUCATION
01.2016 - 01.2019
- Data Visualization using Tableau –Healthcare IT Certificate
Education
A.A. in Information Systems, Database Administration -
Bellevue College
Bellevue, WA09.2012
Bachelor of Science - Banking And Financial Support Services
UBB University
Cluj Napoca, Romania06.2000
Skills
- Business Intelligence
- Data Analysis and Visualization
- Digital Analytics
- Project Management
- Customer/User Service
- Functional & Business Requirements
- Project Planning
- Problem-solving aptitude
- Data review
- Root Cause Analysis
- Agile Methodology
- Documentation And Reporting
- Stakeholder Communications
- Analytical Skills
- Problem-Solving
- Written Communication
- Quality Assurance
Certifications Training
- Certified Scrum Master (CSM) (2019) – Scrum Alliance
- IBM Selling Watson Explorer Sales Professional v1 (2017) - IBM
- Tableau Server Qualified Associate (2016) – Tableau Software
- Tableau Desktop Associate Certificate (2015) - Tableau Software
- Data Visualization (2015) – UWA Professional and Continuing Education Program
Tools
Amazon QuickSight, Tableau, SAP Business Objects, SSRS, IBM Cognos Analytics, Watson Analytics, Crystal Reports, Power BI, QlikView, ArcGIS, ESRI Maps, SQL Server, MySQL, Oracle, Netezza, IBM DB2, Redshift, Teradata, Google Cloud, Datanet, SSIS, Luigi, DJS, EDX, Tableau Server Administration (AWS and Windows servers), IBM Framework Manager, IBM Watson, SAP Business Objects Administration, DataDocs, Confluence, Agile Scrum, GitLab, Python, Bumblebee
Timeline
Business Intelligence Engineer II
AMAZON
07.2019 - Current
SR Business Intelligence Analyst
NORDSTROM
09.2017 - 07.2019
Online Instructor
BELLEVUE COLLEGE CONTINUING EDUCATION
01.2016 - 01.2019
BI/DW Consultant
SIRIUS Computer Solutions
01.2013 - 01.2017
Project Manager / Business Analyst
MICROSOFT CORPORATION
Data Developer/Analyst (Dean of Medicine)
UNIVERSITY OF WA MEDICINE
Computer Specialist
HARBORVIEW MEDICAL CENTER
A.A. in Information Systems, Database Administration -
Bellevue College
Bachelor of Science - Banking And Financial Support Services
UBB University