Sandra Lapp Email & Phone Number

Allentown, Pennsylvania Area

Emmaus, Pa

• Work with in-house team and consultants to create a Google BigQuery Data Warehouse, containing web analytics and sales data, with data connected at user id, content and product level.• Analyze data sources, provide requirements to consulting team, and validate data. Communicate data issues to 3rd party vendors and ETL developer.• Develop complex SQL to pull data for reporting and analysis from BigQuery database.• Create data visualizations to answer business questions and provide actionable insights using Tableau.• Designed and implemented affiliate commerce dashboards and reports to identify articles and channels driving the most revenue, along with worst performing articles, giving website producers the data needed to better target content, resulting in a 60% increase in earnings. • Created ETL process and Tableau workbooks to visualize customer survey data, and provide visibility to satisfaction by product and product category.Technologies: BigQuery, Oracle, Tableau

Emmaus, Pennsylvania

• Implemented Tableau (Desktop and Online) using an Amazon Redshift database to provide visibility to upsell business along with book and magazine sales.• Designed and created Tableau data sources to hide data complexity and enable self-service use for business users.Technologies: Tableau, Amazon Redshift

Emmaus, Pa

• Supported Oracle E-Business Suite as technical lead; developed system interfaces to 3rd party systems and internal systems; developed application sub-systems to fill in gaps where needed, including designing back-end database and front-end applications.• Designed, coded, tested, and implemented applications for e-commerce startup to work with Oracle EBS and other 3rd party applications (warehouse, web store, etc.).• As the Oracle BI Discoverer Administrator, set up business areas, created folders using custom SQL, managed user privileges and data security.• As the sole Oracle BI Discoverer Developer, created all company reports for Oracle EBS modules GL, AP, INV, WIP, BOM, AR, PO, and PA.• Created Crystal Reports for book editorial and book production business; implemented rePORTAL for Crystal Report viewing and distribution.• Created Oracle EBS Alerts to ensure data quality and notify users of data issues.Technologies: Oracle database, Oracle R12 E-Business Suite, Oracle Alerts, Oracle PL/SQL, Oracle BI Discoverer, MS Access, PHPRunner, Crystal Reports, Crystal Reports Server, rePORTAL

Emmaus, Pa

• Developed Photography Department client/server application; lead project, designed application, designed and built database, developed help system, trained users.Technologies: MS SQL Server, MS Visual Basic, Doc-to-Help

• Developed client/server application to manage in-house ad agency business.• Worked with team of developers to create purchasing system for in-house print business.• Maintained mainframe magazine subscription fulfillment system.Technologies: MS SQL Server, PowerBuilder, Assembler, COBOL

Electrical Engineering

Certificate, Computer Programming