Francesca Long Email & Phone Number

San Francisco, CA, US

San Francisco, CA

• ARA Fellowship for 2023. Participate in a program to develop professional ties and leadership skills along with promoting data-driven organizational goals. Preparing an A3 to include a specialty care data registry to.
• Serve as an Advanced Reporting Analyst (ARA) and conduct training sessions for other analysts on how to use Epic Reporting Workbench. Respond to analyst questions on how to use… Show more
• Serve as an Advanced Reporting Analyst (ARA) and conduct training sessions for other analysts on how to use Epic Reporting Workbench. Respond to analyst questions on how to use Reporting Workbench and Slicer Dicer on.
• Research and assemble datasets for providers who are working on quality improvement projects in their clinics. Write SQL queries to pull data and combine those with data pulled using the Epic reporting tools. Assist.
• Request new data for inclusion in SQL databases and Epic reporting tools to enable more complete and speedy access to information. Participate in the Analytics and Reporting Subcommittee where I help explain data.
• Compile datasets and reporting metrics for hospital internal quality and performance metrics (PIPS). Assist other teams prepare graphs and charts to include in their own reports. Coordinated with a team responding to.

San Francisco, CA

• Graduate of the web development immersive program at General Assembly's San Francisco campus where we built full stack web applications.Through the course, I built the following apps:What is this Vegetable.
• Technologies used include: JavaScript, Node.js, Express.js, Bootstrap, and MongoDB. The Perfect Gift (http://the-perfect-gift.herokuapp.com/) An app that allows users to compile gift ideas for any recipient for any.
• Technologies used include: Ruby on Rails, Bootstrap, PostgreSQL.Read It Again (https://readitagain.herokuapp.com/)An app that allows parents (or anyone) to create a page for their child and post videos of themselves.
• Technologies used include: Ruby on Rails, Bootstrap, PostgreSQL. Show less

San Francisco, CA

• Coordinated testing, implementation of 2 retail billing systems to ensure accuracy of pricing details, customer invoicing for >100,000 customers. Worked with customer service, IT, legal to ensure smooth transition to.
• Evaluated customer behavior to predict future usage, analyzed marketing results, investigated financial impacts of retail offers. In company transition to limited data plans, mapped… Show more
• Evaluated customer behavior to predict future usage, analyzed marketing results, investigated financial impacts of retail offers. In company transition to limited data plans, mapped customers to appropriate plans for.
• Prepared annual budget assumptions for retail revenues, wholesale usage, costs for mobile & long distance products. Minimized monthly variances to actual by improving models to keep variances <=5%.
• Investigated and identified wholesale billing errors saving the company over $500K in incorrect charges.
• Automated audit reporting for weekly retail invoices to ensure billing accuracy, trending & budget variance. Investigated any errors and resolved them preventing customer inquiries, billing complaints. Resolved an.

San Francisco, CA

• Facilitated pricing decisions regarding rate plans, additional feature services, and equipment. Coordinated implementation of new pricing plans and changes to existing plans with systems, legal and marketing departments.
• Served as liaison between Finance and Marketing departments to ensure smooth flow of information and success of joint decision making processes. Conducted regular meetings regarding industry trends, internal pricing.
• Served as liaison between Finance and Marketing departments to ensure smooth flow of information and success of joint decision making processes. Conducted regular meetings regarding industry trends, internal pricing.
• Assisted with wholesale contract negotiations and model impact of pricing changes. Analyzed impact of actual and proposed retail and wholesale pricing changes on revenue, customer utilization and budget assumptions by.
• Reconciled monthly vendor costs to budget and contract rates, investigated any variances and resolved billing disputes.
• Developed background data and model assumptions for annual budgeting process.

San Francisco, CA

• Analyzed effectiveness of grants being made by The Heinz Endowments for the purpose of furthering their long-term sustainability initiatives. Provided them with necessary information when considering whether to renew a.
• Modeled historic trends and possible future outcomes utilizing indicators chosen to reflect the overall progress towards multi-faceted sustainability for communities including: Pittsburgh, PA; Orlando, FL; New Orleans.
• Modeled historic trends and possible future outcomes utilizing indicators chosen to reflect the overall progress towards multi-faceted sustainability for communities including: Pittsburgh, PA; Orlando, FL; New Orleans.
• Assessed potential investment alignment with sustainability measures for Angels with Attitude, a venture capital firm.
• Appraised organizational strategy, marketing methodology and fundraising for The Earth Charter Initiative allowing them to more effectively tailor their approach.
• Revised and streamlined sustainability indicator spreadsheets for corporate, foundation, regional and international clients. Identified successful programs and highlighted items that needed further attention in order.

Washington, DC (Sept 2000 To Nov 2002) / Boston, MA (Mar 1999 To Sept 2000)

• Compiled and prepared monthly management reports for commercial clients coordinating with client service teams to obtain and verify data. Graphical presentation provided clients with informative snapshot of the.
• Streamlined daily and monthly processing of various reports for internal clients by writing macros, preparing Excel presentations, and established reporting procedures. Combined, this saved… Show more
• Streamlined daily and monthly processing of various reports for internal clients by writing macros, preparing Excel presentations, and established reporting procedures. Combined, this saved 30-35 hours per month staff.
• Maintained relationship with Corporate Actions department serving as team liaison and information specialist.
• Tested, troubleshot, and established management reporting requirements for new trade reporting system with the goal of reducing report production time by 25%.
• Compiled reasons for daily overdrafts and distributed report for bank partners allowing management to respond quickly.

Wheaton, MD

• Conducted loan disbursement interviews with clients receiving microloans.
• Reported monthly client credit scores to credit reporting agencies.
• Designed new informational brochure for prospective clients, donors, interested parties.
• Responded to informational inquiries regarding lending practices.

Boston, MA

• Ensured quality and timeliness of detailed database entailing: biographical details, contact information, campaign finance breakdowns, special interest group ratings and voting records for 13,000 elected officials and.
• Tracked and presented details for state and federal elections including polling details, ballot measures, state government contacts and political party details and contract information.
• Consulted on… Show more
• Consulted on presentation and performance of internal database and website (www.votesmart.org), troubleshot problems and performed daily computer system updates.
• Supervised 2 staff members, 3-5 full-time interns and up to 300 part-time interns on all data related matters, special projects, and dissemination of information over the hotline. Show less

Boston, MA

• Researched, developed and implemented state level database for legislators from every state including: biographical details, campaign finance breakdowns, and performance evaluations by special interest groups
• Managed collection and presentation of ballot measures, election information, voter registration details, state government and political party references for all states.
• Supervised interns on collection, entry and accuracy verification of data.

Master'S Degree, International Development - Gender And Economic Relations, Gpa 3.66 Out Of 4.0

Concentration: International Development – Gender & Economic Relations. Research Project: Microlending Commercialization and Women’s Lives

Web Development Immersive Program, Full Stack Web Development

General Assembly's Web Development Immersive is a full-time 12-week course which covers the full stack in JavaScript and Ruby, with the.

Bachelor'S Degree, Politics; Economics; International Studies, Gpa 3.35 Out Of 4.0

Activities and Societies: Honors: Dean’s List, Omicron Delta Epsilon Honor Society (Economics), Delta Phi Alpha Honor Society (German).

Junior Year Abroad, Politics, Economics, International Relations

All coursework completed in German.