Wenjie (Megan) Song Email & Phone Number

Philadelphia, Pennsylvania, United States

• Manage Metrics and Standards program, building up policies and processes to enterprise metrics lifecycle.
• Lead data stewards, sponsors and users to manage data as assets
• Pioneer in building Data Catalog and Knowledge Library for enterprise and teams

• Conceptualize and lead the buildup of a standardized and automated data collection and ETL process for inpatient capacity management, saving at least 0.5 FTE of labor and improving data quality
• Present to stakeholders and leadership to get resources and buy-in from all levels of management and staff
• Standardize and document 30+ data elements and metric definitions in EPIC and Data warehouse by working with data stewards
• Build a KPI and self-service QlikSense dashboard to replace 16 existing dashboards to facilitate capacity and patient flow management, improving data trust, data literacy, data accessibility and operation efficiency
• Operate day-to-day function of capacity management portfolio, including prioritize projects and tasks, and coordinate a cross-functional team using Agile methodology

Greater Philadelphia Area

• Integrated 5 siloed projects into a program portfolio as the coordinating lead and enhanced communication, efficiency and data integrity
• Designed and executed data solution packages for projects, promoting a data-driven culture
• Identified opportunity with data insights and increased 1240+ patient visits at one specialty care center in 1.5 years, approximately $1.5 million in revenue, increasing utilization of reserved rooms by 7%
• Automated metrics calculation and reporting, saving a total of 1248 hours of manual process per year
• Built a simulation model with MedModel and expedited the ramp up without sacrificing the patient safety during COVID pandemic, increasing volume by 80%
• Led a cross-functional team of 10, including providers, nurses, operation leads, data analysts and data engineers, for the POC of a third-party vendor, which values $200,000/year

Philadelphia, Pennsylvania

• Led shareholders from 4 teams to create the very first Enterprise Data Mart at the hospital. This project boosted the integrity and accuracy of harm related data and saved teams 10+ hours per quarter for data issue.
• Maintained and improved the most frequently used Qlikview dashboard (daily footprint > 1000) to ensure accurate data outputs and support safety related decision making
• Identified labor-intensive processes during the data collection phase and optimized them with data and technical support
• Standardized REDCap tool change process with a R web app to improve data protection and version control

• hosted 70+ sessions in career planning, Industry knowledge sharing, resume edition and mock interview, and has successfully helped 20+ college and graduate students to get their dream jobs.

Waltham, MA

• Organized the response of national patients’ satisfaction survey across 10 years with Access and Excel (millions of records)
• Linked records with hospital ID by American Hospital Association for further analysis with SAS and R

Boston, MA

• BrainCo is a startup dedicated to make a difference with Brain-Machine Interface (BMI) technology. Their first product is a neurofeedback headband that is able to detect brainwave, calculate attention level and make.
• Led 16 interns for marketing research, social media, business development and data analysis, and maintained a high retention rate and achieved great performance
• Identified niche market by analyzing the market trajectory, survey and focus group responses, and shared insights with the development team, which becomes the direction of the product line
• Led an interdisciplinary team of 12 to prepare and attend Consumer Electronics Show, including booth and conference presentation and demonstration
• Predicted the population of people with ADHD in 2020 using time series model, compared the accessibility and market size between the ADHD market and the smart home market, and selected the ADHD market as the niche.
• Surveyed 206 respondents and a focus group of 10 potential customers, analyzed customer preferences with cluster analysis and decision tree, and shared insights with the whole team for better product development

Somerville, MA

• BrainCo is a startup dedicated to make a difference with Brain-Machine Interface (BMI) technology. Their first product is a neurofeedback headband that is able to detect brainwave, calculate attention level and make.
• Prepared for 2016 Consumer Electronics Show, scheduled events, designed displays, prepared handouts and invited the media. Its product was featured in 70+ media, as the only startup in the "8 Takeaways in 2016 CES" by.
• Interviewed CEO, the R&D engineers, potential customers, behavioral coaches and therapists to construct a product description, considered external factors and selected a niche market.
• Divided 16 interns into 5 groups: Marketing Research, Crowdsourcing, Business Development, Branding and PR, Operation. Held weekly meetings, made plans and supervised performances. All dedicated interns appraised the.

Somverville, MA

• Represented the company in campus career fairs at Harvard University, MIT, Boston University and WPI, attracted hundreds of students to apply for positions.
• Scheduled interviews and prepared paperwork for candidates and new employees.
• Negotiated price for payroll services with ADP and managed e-verify profiles for employees.
• Assisted CEO for time arrangement, scheduling and task reminder, and coordinated with other core team members.

Greater Boston Area

• Planned NaPlus-Harvard SEED co-branding campaign, pitched the idea and negotiated SEED to create a win-win situation
• Coordinated with SEED for periodic goals, motivated team members to guarantee timely content generation
• Created social media calendar and wrote messages for Weibo and Wechat’s official accounts to promote engagement

Greater Boston Area

• Coordinated efforts of a product manager, a technology support team in China and an outsourced App development team in the U.S. to build a mobile app and a website for global business in a tight schedule
• Managed a recruitment project, diagnosed hiring needs, invited tech consultants for interview and prepared paperwork

120 Boyston St. Boston, MA

• Picked up phone calls, recorded messages and made appointments for students
• Answered visa-related questions for international students
• Organized immigration files of international students alphabetically and archived files of graduates
• Assisted supervisors for event planning and execution

Greater Boston Area

• Assisted new international students to transition quickly and smoothly into a new living and academic environment
• Shared and updated campus news, housing information and other messages to new students to prep for their move
• Collected and integrated all available resources to solve new students’ living and academic problems
• Led campus tours as a knowledgeable guide by sharing what Emerson has to offer to potential students

Qingdao, Shandong, China

• Presented in project biddings for real estate opening events to C-level management team
• Achieved a success rate of 66%

Beijing City, China

• Managed social media accounts on Weibo, Renren and Kaixin. Planned and executed daily messages, digital events and communicated with followers to build brand awareness and brand affection
• Crafted routine press releases for media channels and user forums for new product launch to help drive sales
• Collected brand-related buzz and supervised brand equity for crisis management, and addressed issues as needed
• Built monthly and semi-monthly measurement reports for ASUS and coordinated with in-house staff to meet goals
• Trained 2 new employees to adapt to the environment; assigned, guided and supervised their work progress

Business Analytics, 3.92

Academic Projects: Optimizing the efficiency of the Emergency Room – Course: Optimization and Simulation • Used the queueing model and.

Master Of Arts (M.A.), Integrated Marketing Communication, Gpa 3.69

Activities and Societies: • Part time work at Office of International Student Affairs • Worked as iGrad Transition Leader to assist new.

Bachelor Of Medicine, Registered Nursing/Registered Nurse

Activities and Societies: • Student Union of College and the Department of Nursing • Monitor of Class • League Branch Secretary • Minister.