Zachary Litawa Email & Phone Number

Berkeley

• Document, build, and maintain new/existing data pipelines and data architecture• Supervise and manage Salesforce client data-related communications and projects• Develop and optimize SQL Server database environment via script and stored procedure generation• Build and maintain new/existing data pipelines and administrate data in SQL Server development/production database environmentsKey Accomplishments: • Expanded company’s market coverage into Canada and domestically by 116 % through development of 150+ data load sub-systems via T-SQL and ETL • Completed 690 client data engineering requests from May – Oct. 2017 and reduced average completion time for data customer requests from 4-6 business days to 1-2 business days • Migrated and saved client accounts during 2018 company merger, saving thousands of dollars in recurring monthly revenue

Berkeley, Ca

• Communicate with clients and real estate associations over writing regarding issues with data pipelines• Compile and document company’s data architecture systems for internal development and training • Daily monitor & maintain 500+ dynamically-updating active data pipelines of 10 million active/sold real estate listings comprising 80%+ of all on-market US/Canada properties • Develop and optimize SQL Server stored procedures• Data mine and analyze large data sets for reports and content generation• Utilize ETL functions to transform and store data in database• Supervise data engineering requests, maintenance tasks and additional projects

Berkeley, Ca

● Diagnosed and serviced computer systems for software and hardware system issues● Restored systems compromised by virus/malware infestation and/or system failure● Instructed customers on usage of computers pertaining to networks and computer systems

Davis, California

● Managed all day-to-day operations of a small business, including opening/closing the store, point-of-sales system, inventory, and buyback program● Managed online business marketplace account● Serviced printer and office hardware and calculated profit margin● Organized and streamlined book buyback program

Davis, California

● Assisted in maintaining care ministry for 1,000+ member church; provided lay caregiving for people through in-person visitations and emails; maintained care-receiver confidentiality● Completed 50 hour training program in lay pastoral counseling and crisis care (Stephen Ministries series)

Davis, California, United States

Copy-edited numerous manuscripts and essays for college students from a variety of disciplines/classes ranging from creative writing stories to engineering/science essays. Copy-edited essays of all collegiate levels.

University Of California, Davis

● With no prior existing group or members, recruited and mobilized peers into healthy, goal-oriented groups in a college fellowship of 200 students● Weekly created and prepared successful curriculum for team training and development● Spearheaded new initiative for bi-weekly cross-cultural lunch campaign to foster dialogue between students of different views on campus

Davis, California