Aimee W. Email & Phone Number

New York, Ny, Us

▪ Drove medium-complexity projects across multiple global agencies by managing project scope and schedule changes and minimizing project risks to hand over deliverables under budget and timeline through PM software(Workfront).▪ Liaised with internal agency and SBU teams to identify partnership needs and solutions that improve programmatic business outcomes.▪ Used statistical and analytical techniques to examine data sets and identify trends, patterns, and insights. ▪ Extracted data from Flat files, Excel, transformed as per the logic, and loaded into the data warehouse. ▪ Cleaned and blended multiple data sources to allow for different views on application data in a single dashboard.▪ Analyzed and visualized performance data with Excel and Tableau to build weekly interactive dashboards for all global deals and agency evangelization elements, analyzed advertising trends and addressability, and checked against various endeavors.▪ Tracked and managed projects simultaneously by coordinating with the product and legal team and making appropriate adjustments such as balancing resources, changing timetables, and skipping some redundant steps to fulfill stakeholders’ additional requirements and achieve high stakeholder satisfaction.▪ Collaborated reports on Excel and PPT to conduct trend analysis and research on partners, identified target markets to help optimize KPIs, and introduced new projects to consolidate and facilitate partnership upgrades.▪ Generated pacing reports to the financial department and marketplace regularly under tight deadlines identified.

Boston, Ma, Us

▪Managed social media updates and maintained brand consistency while engaging with industry topics on behalf of the brand.▪ Generated regular client reports encompassing significant metrics, goals tracking, revenue, and potential program initiatives.▪ Utilized various charts to visualize sales performance metrics across categories, geometrics, and customer segments.▪ Implemented KPI measurement tools based on historical data, enabling continuous monitoring of marketing campaigns.▪Facilitated the creation of cohesive, creative images associated with the social media posts▪Scheduled social media posts in the social media scheduling system/software, ensuring proper tags and tracking are in place for reporting.▪Used social media Spinklr to scheduling system/software to schedule posts, retweets, updates, etc▪Monitored and administered web analytics dashboards, reports, and key reporting tools and pointed out key areas of importance by client goals.▪Communicated with team and management on project development, timelines, and results.

Boston, Ma, Us

▪ Analyzed website data such as bounce rate and other key performance indicators by using Google Analytics.▪ Developed business process models of Waterfall to document existing and future business processes.▪ Worked in using collections in Python for manipulating and looping through different user-defined objects.▪ Designed, developed, and implemented Power BI Dashboards, Scorecards, and KPI Reports.▪ Extracted data from Flat files, Excel, Transformed as per the logic, and loaded into Data warehouse. ▪ Developed and executed complex SQL queries to pull data from data sources like SQL server databases.▪ Cleaned and blended multiple data sources to allow for different views on application data in a single dashboard.▪ Used MS Office extensively (Word, Excel) for analysis, presentation, and documentation throughout the project.▪ Generated Agile methodology to ensure the data analysis process corresponded to business needs and delivered results accurately.▪ Imported, transformed, and cleaned data from various sources with Power BI, like MySQL databases, websites, and data from clients, and composed user stories to deliver insights to our stakeholders.▪ Leveraged window function, aggregate, distinct, and condition function in SQL to find the business insights.▪ Developed the interactive dashboard to visualize the purchase trends and conversion rate by considering customers’ detailed personal information, purchase data, and total amount.

▪ Designed and maintained email campaigns, newsletters on email and social media channels.▪ Built an interactive dashboard with Tableau to track marketing status timely and communicate with stakeholders.▪ Utilized multiple charts to visualize the sales performance metrics over different categories, geometrics, and customers’ segmentation.▪ Calculated the KPIs with built-in tools based on historical data to monitor the marketing campaigns continuously.▪ Built a project roadmap, set up milestones, and organized weekly prioritization meetings to report progress to the leadership.▪ Identify opportunities to create workflow and reporting efficiencies through technology and work with key stakeholders to implement changes and enhancements.

➤ Marketing Implementation: ▪Participated in the project and acted as an organizer to help a medical treatment consulting company improve its website layout and provide a number of new marketing initiatives. ▪From the background picture to the introduction, carefully checked the matching situation to avoid the appearance of outdated information, which may bring troubles and bad experiences to customers. Tailored keywords to the audience.

▪ Created a marketing promotion plan for calling volunteer projects to expand publicity and public participation.▪ Contributed to the implementation of marketing strategies: target audience, competitor Analysis, SWOT Analysis.▪ Designed and implemented ongoing email campaigns for Calling Volunteers to increase the survey sample pool.▪ Managed and delivered ongoing marketing campaigns and newsletters on email and social media channels.▪ Organized and attended marketing activities and coordinated several parties to raise brand awareness.

Us

➤ Product Operations: ▪ Trained in the main business of China Unicom as well as the composition of the products’ costs and associated revenues; utilized a product-profit and loss-testing model to predict potential revenue of China Unicom’s telecommunication suite of products. ▪ Assisted in allocating marketing resources according to specific product and consumer groups to guarantee the product’s profitability during its life cycle; helped carry out customized marketing plans of five universities based on comprehensive research and analysis.