Clara Lam Email & Phone Number

Pittsburgh, Pennsylvania, United States

New York City Metropolitan Area

I held both a project manager and database design role. I have previous experience at this company and thus, worked with the IT manager to supervise software engineer interns while devising a project plan to migrate the company's Microsoft Access database to a MySQL database.• Coordinated with IT manager to supervise software engineer interns, ensuring daily stand-ups were organized and productive• Devised project roadmap, established team communications, implemented Trello board to… Show more I held both a project manager and database design role. I have previous experience at this company and thus, worked with the IT manager to supervise software engineer interns while devising a project plan to migrate the company's Microsoft Access database to a MySQL database.• Coordinated with IT manager to supervise software engineer interns, ensuring daily stand-ups were organized and productive• Devised project roadmap, established team communications, implemented Trello board to facilitate project progression• Migrated a Microsoft Access database with 276 tables and hundreds of columns into a MySQL database with 14 tables, creating an entity-relationship diagram (ERD) for product-related reference tables and defining relationships• Developed SQL procedures, scripts, and queries to analyze and prepare database for migration, including creating dump files• Decompounded Amazon Product Type templates to match fields relevant to Dahlia’s product types, ensuring an easy procedure for Amazon product datafeed uploads and considering multi-platform restrictions, such as Shopify’s requirements Show less

Pittsburgh, Pennsylvania, United States

I worked as a UI/UX design intern at Confirmed to improve the usability of their application as they prepared to refactor their front-end. I had a lot of autonomy with design choices, allowing me creative freedom while taking ownership and responsibility for my work.• Designed Confirmed’s internal product pages by combining 2 related products into a single page to support expanding features; restructured settings pages to help users easily navigate and customize account experience•… Show more I worked as a UI/UX design intern at Confirmed to improve the usability of their application as they prepared to refactor their front-end. I had a lot of autonomy with design choices, allowing me creative freedom while taking ownership and responsibility for my work.• Designed Confirmed’s internal product pages by combining 2 related products into a single page to support expanding features; restructured settings pages to help users easily navigate and customize account experience• Developed new brand guidelines (logo, colors, typography, design elements) to facilitate a consistent design process• Redesigned scheduling page for external users, resulting in a cross-platform experience that increased usability and flexibility• Designed and coded a campaign of 10 drip emails to inform new users of app features and increase app engagement• Advised development and leadership teams that had no prior design experience on best design practices for user experience• Conducted user research and heuristic analysis to identify pain points and opportunities for intuitive and user-friendly design Show less

Pittsburgh, Pennsylvania, United States

I learned a lot about human-computer interaction research, participatory design, and accessibility standards and was able to apply what I learned to the native application our research team is working on.• Led implementation of accessibility guidelines for Peerdea, starting from research and outlining guidelines, to delegating and programming accessibility best practices in preparation for Peerdea's larger-scale deployment• Designed and developed Peerdea's landing page (peerdea.app)… Show more I learned a lot about human-computer interaction research, participatory design, and accessibility standards and was able to apply what I learned to the native application our research team is working on.• Led implementation of accessibility guidelines for Peerdea, starting from research and outlining guidelines, to delegating and programming accessibility best practices in preparation for Peerdea's larger-scale deployment• Designed and developed Peerdea's landing page (peerdea.app) to inform users about the app• Formulated and executed a user recruitment plan and screener survey for Peerdea, including outreach to Facebook groups and entrepreneurial makerspaces, establishing and maintaining relationships with potential users• Implemented post prioritization using React, ensuring that older posts with low engagement are displayed to users first, taking into account factors such as post type, likes and comments, and time elapsed since posting• Enhanced user interface and experience of Peerdea, currently deployed to 29 small business owners in Pittsburgh for over 2 years, under the mentorship of Ph.D. candidate, Yasmine Kotturi (advised by Dr. Chinmay Kulkarni)• Analyzed qualitative user data (interviews, surveys) as well as quantitative data (app log data) to devise improvement plans Show less

New York, New York, United States

• Directed 5 departments (Academic, Marketing, Career Development, Administration, IT) consisting of 150 TA Leaders, TAs, and students by planning, allocating, and executing tasks via created project management files under NYRA staff’s lead• Developed TA evaluation criteria to promote and award high-performing TAs while identifying low-performing TAs to provide feedback and ensure TAs perform responsibilities timely and efficiently• Arranged 2020 graduation agenda, coordinated officials… Show more • Directed 5 departments (Academic, Marketing, Career Development, Administration, IT) consisting of 150 TA Leaders, TAs, and students by planning, allocating, and executing tasks via created project management files under NYRA staff’s lead• Developed TA evaluation criteria to promote and award high-performing TAs while identifying low-performing TAs to provide feedback and ensure TAs perform responsibilities timely and efficiently• Arranged 2020 graduation agenda, coordinated officials and speakers, and moderated and emceed three-hour graduation where 9 elected officials attended, including 3 NYS Senators and 1 NYC Borough President• Trained TAs proper documentation, file management, and Excel skills and developed procedures and manuals for camp and department operations, increasing team effectiveness and reducing repetitive tasks Show less

New York, New York, United States

New York, New York, United States

• Generated monthly sales report for 7000+ SKUs under Parent SKUs, SubCat and CAT (category) reports, which are used for production projection modeling• Analyzed SKU ups and downs based on WOW, MOM, and YOY through sales report and evaluated reasons for sales changes, such as inventory in-stock level, paid promotions, and competition• Examined Amazon customer search terms through generated reports for about 100 ad groups to pinpoint effective keywords to decrease advertising costs and… Show more • Generated monthly sales report for 7000+ SKUs under Parent SKUs, SubCat and CAT (category) reports, which are used for production projection modeling• Analyzed SKU ups and downs based on WOW, MOM, and YOY through sales report and evaluated reasons for sales changes, such as inventory in-stock level, paid promotions, and competition• Examined Amazon customer search terms through generated reports for about 100 ad groups to pinpoint effective keywords to decrease advertising costs and boost sales• Conducted Google and Amazon keyword research and devised a categorization system to finalize top 50 keywords out of thousands for each product category; wrote training manual on research methodology and categorization system• Collaborated to design skeleton of Customer Relationship Management (CRM) database, connecting scattered consumer information between 2 platforms, centralizing data, and making information retrieval 5 times faster Show less

New York, New York, United States

• Collected and studied market data to identify potential new marketing opportunities based on fashion trends, market needs, company’s development demands, customer feedback and competitors• Planned monthly social media content based on a marketing plan and key performance indicators such as increased number of followers, engagement rates, and conversion rates to adjust plans accordingly• Created Pinterest, Instagram, and Amazon Posts content with SEO-optimized descriptions, hashtags… Show more • Collected and studied market data to identify potential new marketing opportunities based on fashion trends, market needs, company’s development demands, customer feedback and competitors• Planned monthly social media content based on a marketing plan and key performance indicators such as increased number of followers, engagement rates, and conversion rates to adjust plans accordingly• Created Pinterest, Instagram, and Amazon Posts content with SEO-optimized descriptions, hashtags, and eye-catching graphics to reach target audience, resulting in posts reaching thousands of users• Assessed key performance indicators of posted content to Instagram and Pinterest and adjusted posts Show less

Bachelor Of Science - Bs, Information Systems

Activities and Societies: Asian Students Association (Co-President 2023, Treasurer 2022, Webmaster 2022 & 2023, Advocacy Chair 2021) |.

Education record

Activities and Societies: Indicator (Art Editor) | Environmental Club (Advisory Council) | Oratorio Choir (Alto Section Leader) | Girls.