● First hired data engineer for growing startup; identified company-wide data needs; simultaneously addressed critical reporting issues and strategized long-term data management and governance ● Designed and created enterprise data warehouse to facilitate data-driven business decisions ● Owned reporting impacts of large-scale, fast turnaround database refactor, at various times serving as project manager, product owner, and lead engineer● Led the migration and automation of disparate reporting platforms to reduce errors and inefficiencies across multiple departments● Designed pipelines for multiple raw data streams; created daily ETL procedures using stored procedures ● Collaborated with multiple cross-functional teams (finance, product, operations, and design) for product and process improvement

● Create and maintain ETL procedures in MySQL and Vertica databases using SQL, Python, and shell scripting; support existing data pipelines by evaluating issues as they arise, developing solutions, and deploying fixes; work daily with complex sets of structured and unstructured data sources● Own the Imputed Income reporting process which provides more than 200 of our B-to-B clients with critical tax information; code changes to allow for complex, frequently changing business logic, automate custom reports, improve code base to allow for more flexibility● Primary Salesforce API contact for Data Warehouse team - work with business owners to gather requirements, consult on data modeling, and research downstream data flow implications● Designed and developed automated process to manage CCPA (California Consumer Privacy Act) regulations - identify, scrub and track removal of personal information ● Developed and improved Python skills on the job, and not afraid to learn new languages or tools. From one recent manager review: “She is ready to learn any skills that would allow her to contribute to the team and the company and her career.”● Strong communication skills and ability to collaborate with team members at different levels of the organization

• Proactively identify, investigate, and diagnose database and reporting data issues.• Understand the data output of complex data warehouse code and verify that the output meets the business requirements.• Contribute to testing efforts by working with development team members to identify and clearly understand business requirements and functional design. • Engage at the team level to ensure that release commitments are met in a fast-paced Agile environment.• Work with on-shore and off-shore developers and quality assurance engineers.● Verified that the data output of complex data warehouse code met particular business requirements - comprised ETL changes, data migrations, python jobs, mySQL stored procedures● Proactively identified, investigated, and diagnosed database and reporting data issues● Responsible for validation of Imputed Income reporting process - daily and monthly tax-critical data● Created and verified Tableau reports - met with business owners to identify requirements, wrote complex queries to produce customized reports ● Created comprehensive documentation for all Salesforce API data extracts and loads; began to take the lead on creating new Salesforce extract jobs

• Part business intelligence developer, part database engineer, and part data detective, I am responsible for the data integrity of and consistent reporting from a relational database representing $36MM in annual revenue.• Work closely with lead architect on data modeling and data warehouse design to provide basis for financial accounting and to support new products and e-commerce website features.• Co-authored an enterprise-wide credit line data model to allow for accurate tracking and repayment of licensee "Nite Credit." • Work closely with financial accounting team to ensure precise records and audit preparation.• Primary resource for regular data verification and QA – investigating and diagnosing complex and often subtle data interaction issues.• Effectively communicate business requirements to technical stakeholders and technical requirements to business owners with ease.• Responsible for maintaining consistency in complex and frequently evolving financial business logic. • Provide short-term solutions for data inconsistencies while proposing company-wide data collection and governance guidelines. • Gathered requirements for, designed, and implemented data warehouse schemas to support centralization of third party data; assisted with creation of ETL flows. • Create, QA, and enhance complex MySQL queries, stored procedures, and views for both centralized and ad hoc reporting requests.

• Work with business owners across the company to clarify, translate, and satisfy their data needs and assist in analysis -- close interactions with product, engineering, sales, finance, business development, and marketing departments.• Created and maintained home grown BI platform “Paint by Numbers” (learning JavaScript and HTML along the way) ultimately used by over 200 internal and external end users.• Responsible for accuracy and consistency in reporting - both ad hoc and centralized.• Resident MySQL querying “ninja.”• Manage, communicate, and oversee the ongoing implementation and evolution of “PBN” platform.• Primary liaison for reporting and data investigation requests.

• Serve as primary contact for complex big-data requests, ranging from university and government-mandated inquiries to faculty leadership requests for trends in historical course, grade, and enrollment information.• Regularly craft sophisticated SQL queries to respond to ad hoc data requests for faculty and higher administration.• Participate in and contribute to major MBA technology innovation projects including new instructor evaluation process, EC Course Planner, Exam tool, and upcoming university-wide change to file formats. Present at weekly iteration meetings; participate in testing and QA. • Manage and coordinate over 200 online course evaluations each term; distribute results to senior administrators. • Oversee hiring, supervision, and career development of Staff Assistant.• Improved tracking documentation for joint degree students to reduce redundancy and improve clarity; oversee database updates for withdrawing, returning, and continuing students.• Ensure accuracy of large amounts of confidential student data and complex educational records.

• Oversee tuition billing for over 1800 students biannually; responsible for tracking $110 million in annual income.• Create and submit weekly data files to central Harvard University offices (biographic and address information, tuition/fee updates) and subsequent maintenance of audit records. • Coordinate updates to official student email addresses as necessary. • Maintain and update complex student records. • Attend to daily and weekly tasks such as transmitting weekly biofiles, respond to student/faculty/staff questions via email and phone. • Developed and administered online poll to streamline incoming student name change process; this innovation improved customer service to students and saves potentially $1,200 annually in name badge reprinting costs.

➢ Produce weekly report summarizing critical development updates for executive team. o Took report from 30-person readership to audience of over 200 by improving quality and consistency of content, standardizing format, and converting to digital layout and distribution.➢ Manage rotating weekly schedule of 12 project presentations to executive team.➢ Coordinate communication among developers, quality assurance team, and technical leads to ensure accurate and timely project completion.➢ Serve as point of contact for multiple project teams; monitor daily project queues and resource allocations.

- Completed profitability analysis for recently released line of garments.- Analyzed online purchase data to identify trends in customer profile; isolated and established list of relevant customer purchase variables including repeat purchasing, gift buying, customer gender, seasonality.- Researched current trends in online marketing; identified key areas of opportunities; made actionable recommendations based on findings.- Consulted on efficient and effective use of social media.- Assisted operations team through busy holiday period.

- Managed and coordinated annual update and editing of the Graduate School of Arts and Sciences Handbook (involved tracking text updates, correcting and proofing manuscript, schedule control and management, constant communication with outside compositor)- Consulted on and initiated new electronic indexing software to improve process flow of handbook updates.- Administered and expedited applications for transfer/readmit applicants, leave of absence, study abroad. Reviewed all responses and acted as departmental liaison.- Consulted on updating website to enrich user interaction.

- Tracked and trafficked incoming/outgoing files and assignments for educational publishing developer's elementary school reading programs, while maintaining multiple schedules.- Participated in up-front project planning to help establish efficient processes.- Copyedited and proofread at all stages of development. Performed Internet research for fact-checking.- Edited and consulted on middle school and high school math lessons for content. Checked for accuracy of questions/answers as well as clarity of topics. Corrected lessons as needed.