Lucy Swain

Experience

• 

  UMass Boston

  Sept 2012 - Apr 2013

  Lucy was working with Instructional Design Support Team. She was migrating the courses from Blackboard Vista (Learning management system ) to Blackboard Learn 9.1.She was working with professors and faculty members to create there courses in the new LMS system. Lucy took labs of undergrad students and was teaching them Microsoft Excel and Access 2012.

  • Graduate Assistant in IT Department

    Nov 2012 - Apr 2013

  • Graduate Assistant

    Sept 2012 - Oct 2012
• 

  Masco Contractor Services

  May 2013 - Sept 2013

  EBusiness Intern, Masco Contractor Services

  o Created tables, stored procedures, views and functions in MS SQL Server 2012.o Created SSIS packages. Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.o Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.o Performed ETL operations for Business Intelligence reporting solutions.

• 

  UMass Boston

  Sept 2013 - Jan 2014

  IT Graduate Assistant

  Lucy works with Instructional Design Support Team. She is now migrating the courses from Blackboard Vista (Learning management system ) to Blackboard Learn 9.1.She works with professors and faculty members to create there courses in the new LMS.

• 

  Premier Research

  Jan 2014 - May 2014

  Data Visualization Analyst

  o Administers Oracle Clinical Discoverer and Integrated Review users within user groups.o Administers foreign panels and custom SQL on the database for use by users.o Administers reports on the database to share, grant, and revoke access for multiple users to access.o Creates, enhances, decommissions reports and the SQL code used for creating reportso Provides general support in use of the application.o Performs additional duties and assignments as requested.

• 

  Pearson VUE

  May 2014 - Jul 2016

  Database Analyst

  o Do list pulls using T-SQL query in SQL server database and create accurate reports and metrics for the organization.o Perform SQL queries and inserts on MS Access database as needed.o Upload reports to PNA collaborative workspaces for campaign execution.o Create/modify report subscriptions for daily, weekly, and monthly reports.o Perform data integrity reviews for duplicate records, incorrect imports.o Generate reports using SSRS by writing stored procedures, functions.o Perform ad-hoc analysis using Tableau. Show less

• 

  Randstad Technologies US

  Oct 2016 - Jan 2017

  Database Administrator Admin III/Data Analyst

  o Created customized reports and dashboard using Tableau Desktop for Bavencio Launch.o Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.o Created restricted data set for particular users using Row level security and User filters.o Created Net Sales and Demand Proxy National Snapshot Dashboards for all brands.o Created Attainment reports (finance sales & quota data) for KAM/ABD users to view TRx against Quota for the current quarter using Consolidated HCP data source of different brands.o Worked on creating Call reports using Call activity data source. Developed different visualizations such as Call change using different comparison period, Call chart and Call table for each month as well as Calls per business days per territories for each month.o Built and published customized interactive reports and dashboards, report scheduling using Tableau server. Show less

• 

  EMD Serono, Inc.

  Feb 2017 - now

  o Develop, define, and summarize monthly and quarterly KPI metrics for stakeholders, which provide key insights about the business performance. These KPIs focus on Patient metric, Adherence, Retention, Inventory metric, Specialty pharmacy metric and other key variables.o Develop predictive models to predict most likely prescribers to prescribe EMD Serono’s top line drugs using Python.o Created tableau extracts to merge standalone data in different data systems – database Oracle and in Datawarehouse AWS and successfully able to implement new and innovative mapping analytics for the Patient and Prescription metric datasets.o Closely collaborated with key Market Access team members to understand the needs, gathered requirements and developed comprehensive analysis by formulating the analytical problem, researching and cleaning the data and then summarizing the key insights/ findings/ trends in a compelling visual representation.o Continuously collaborate with different team members to better understand the data and in turn establishing close relationship with key stakeholders to understand their day-to-day growing needs based on how the business is performing and how the KPI needs are evolving.o Work closely with different multisource data sets and actively use Tableau Prep to prepare comprehensive data and provide ad-hoc analysis to support daily activities and provide insights for decision making process. o Formed different Tableau extracts, Custom SQL and AWS Redshift views for report creation needs based on business rules and for different data analytics activities.o Incorporate different Tableau best practices to optimize and maintain different reports and extracts.o Integrated different SQL best practices to optimize the SQL query for different Redshift extracts. Show less o Collaborated with IT and developed new KPI Tableau reports to monitor Medical call efficiency using Veeva CRM data. Reviewed and validated the flow of Medical Physician call data in different systems from Veeva (CRM) through Redshift (AWS) and finally in Tableau reports for data integrity and efficiency.o Used SQL queries and excel pivots to test the efficacy of data received from different sources to merge and create global datasets.o Created an automated process for the incentive compensation program. Followed by designing and devising structural and controlled reports for monitoring IC and easy payouts.o Created ad-hoc reports to support the users for different POA meeting queries.o Worked closely with payer data SME for payer analysis and integrated a pull through campaign report for Market access department. o Developed different Tableau extracts, Custom SQL and Redshift extracts for report creation needs.o Closely worked with the BE Field Planning and Operations team to automate the bonus payout statements and developed reports for Oncology and N&I teams.o Continually developing/ enhancing Tableau extracts as per requirements.o Provided TM1 dimension and cube creation and analysis support for Actual, Budgeting, Forecasting and Long-Range Planning Processes for Sales, Opex, P&L, Headcount, and Cross charge KPI measures.o Developed and maintained revenue & P&L forecast files. The Files included sales, expenses, actual and forecasted units, all the rebates and chargebacks and other financial measures.o Extracted US and Canada data from Tableau (earlier Cognos/OneSource) and SAP; and delivered it in a unified North America regional format.o Prepared detailed automated TM1 reports to significantly reduce the amount of manual work for the US and Canada commercial teams.o Built procedures and supporting systems for validation of data prior to release of data within the Company. Show less

  • Manager, Data Analysis & Reporting

    Mar 2023 - now

  • Senior Analyst & Report Author

    Jan 2021 - Mar 2023

  • Systems & Report Writing Analyst

    Feb 2017 - Dec 2020