Janet Gershen-Siegel

Social Media Specialist with extensive cross-industry experience including law, financial services, publishing, voice recognition, and insurance. Experienced blogger, tweeter, and social networker, with an online presence since 1997. Admitted to the New York Bar; Notary Public, Massachusetts.

TECHNICAL SKILLS

Certification Training:

• Passed Oracle SQL Certification exam (1Z0-007).
• Completed Oracle DBA certification training for Oracle Certified Professional (OCP).
• Completed Business Analyst Fundamentals Certification Track.

Programs and Languages: Hyperion, Brio, Stratum, SQL, Oracle 9i, Excel, Access, Project and Visio.

EXPERIENCE

FIDELITY INVESTMENTS/VERITUDE, Boston, MA 2011 - 2012

Reporting Analyst/Consultant

• Ran database reports for FILI (Fidelity Investments Life Insurance) Division, including providing analysis of trends.
• Troubleshot reports, using Hyperion 11.

Neuron Robotics LLC, Boston, MA 2010 - present
Director of Social Media and Public Relations: Social Media expert and practitioner for startup robotics company.

• Plan, conduct and produce company pre-adventure presentation for TEDxBoston, July 27, 2010
• Maintain, curate, edit and update company blog
• Manage and update company Twitter account
• Attend functions on behalf of company
• Responsible for marketing decisions and social media strategy
• Implement good content strategy practices
• Improve company onsite and offsite SEO
• Create offline marketing strategies
• Gather metrics using Google Analytics, Compete.com and Yahoo Site Explorer and present findings to Board of Directors
• Manage and grow online community from scratch

The Examiner, Boston, MA 2010 - present
Freelance Writer: Extreme Weight Loss Examiner writer for The Examiner.

• Wrote articles as Boston Extreme Weight Loss Examiner
• Researched health and nutrition topics.
• Interviewed featured dieter for resolutions series.

Able2Know, Boston, MA 2002 - present
Project Manager/Volunteer: Co-founder and moderator of a Question and Answer Internet community of over 100,000 users.

• Moderate and manage site, including development and implementation of Disciplinary Policy.
• Select and supervise a staff of 30 remotely located volunteers.
• Manage Help Desk and triage support tickets to technical personnel.
• Keep all site statistics on membership growth and finances; report results and trends to the site owner.
• Wrote Terms of Service Membership Agreement, Privacy Policy, and Forum Descriptions.

Home Energy Remedies, Douglas, MA August 2010 - December 2010
Freelance Social Media Marketing Practitioner: Social Media expert and practitioner for home energy audit company.

• Maintain, curate, edit and update company blog
• Manage and update company Twitter account
• Responsible for marketing decisions and social media strategy
• Implement good content strategy practices
• Improve and maintain company onsite and offsite SEO
• Gather metrics using Google Analytics, Compete.com and Yahoo Site Explorer and present findings to owner

HACHETTE BOOK GROUP,Boston, MA 2008 - 2009

Reporting Analyst

• Database reporting - Sales Performance reporting using a Stratum interface on an Oracle database. Created and managed all user report subscriptions (13 daily, 3 weekly, 14 monthly).
• User security - managed and coordinated user security for the Stratum system. Created and updated User Lists, Security Profiles, User Groups, and View Groups) for 250 users on the Sales Reporting side and 250 users on the Point of Sale side (this was a mix of over 300 users) to manage user access.
• QA Liaison - managed QA workflow by distributing work and tracking key metrics to address website performance issues.
• ETL - performed all data loading of Point of Sale data for 19 retail and wholesale data sources, covering all of 2007 through and including all of 2009. Prepared all user communications regarding all data delays and issues. Managed daily load process, working closely with data verifiers in order to assure that accurate data was being loaded every time. Backed out data as needed using SQL scripting.

KEANE INC., Charlestown, MA 2006 - 2008

Data Analyst/Consultant

• Won the Keane K-Pin award after only six months of service.
• Developed and ran queries against a financial services registration and licensing relational database for Fidelity Investments.
• Prepared, tested, and distributed (in Excel) 20 ad hoc queries/month, using Brio 6.0 and Hyperion 8.3.
• Conducted training sessions, both informal (in person) and formal (on SameTime), in the use of spreadsheet reports and Access databases. Trained successors.
• Prepared 50 regular queries each month: fully organized and documented all aspects of data reporting.

COMPUTER EXPRESS, Burlington, MA 2004 - 2006

Voice Recognition Engineer/Consultant

• Served as subject matter expert for creation of public safety voice recognition product at Dictaphone Corporation; researched and documented legal and law enforcement terminology; performed recognition testing of product, using Perl, including preparing wrapper scripts and batch files. Performed requirements gathering and analysis for public safety voice recognition product.

FIDELITY INVESTMENTS, Boston, MA 2000 - 2001

Senior Quality Assurance Engineer/Consultant

• Gathered requirements for and tested Fidelity Members website
• Wrote test plans on transferring web-based data to company databases.
• Served as technical liaison between internal client and developer.
• Compared CRM database entries utilizing Brio Query 6.0 and Brio Query 6.1.
• Created Access databases for more accurate and efficient data comparisons.
• Performed manual user acceptance and boundary testing, and comparative analysis of website data.
• Wrote mapping logic and tested data as migrated from an Informix to an Oracle database platform.

LIBERTY MUTUAL INSURANCE GROUP, Boston, MA 1995 - 2000

Business Analyst 1998 - 2000

• Developed and ran queries against a litigation billing relational database
• Prepared reports on data results.
• Learned BrioQuery 5.5 and BrioQuery 6.0 with self-study methods.
• Created reports on rate increase requests, analyzed data and made detailed recommendations to senior management (Vice President level).
• Analyzed and evaluated business systems and user needs to parallel overall business strategies.
• Distributed reports using Brio On Demand Server.
• Tested new database structure/tables; wrote database improvement scopes.
• Wrote detailed documentation and descriptions of user needs, and detailed program functions.

Litigation Auditor and Bill Reviewer 1995 - 1998

• Presented legal audit findings on site to outside counsel law firms
• Collected reimbursements
• Supervised accountants
• Developed high-level invoice review process, including tables, graphs, and templates, using Excel.
• Training 30 bill reviewers in desk auditing procedures.

NEW YORK UNIVERSITY, New York, NY 1990 - 1994

Adjunct Professor:

• Taught the law of torts to paralegals on a graduate level.

Various positions in insurance carriers and law firms NY and RI 1986 - 1994

• Conducted trials and depositions
• Prepared motions and legal memoranda as in-house counsel to AIG, and as outside counsel to AETNA.
• Trained attorneys in use of mainframe computerized billing system.

EDUCATION

Juris Doctorate, WIDENER LAW SCHOOL, Wilmington, DE, 1986

B. A. Philosophy, BOSTON UNIVERSITY, Boston, MA, 1983