TECHNICAL SKILLS

• MS Outlook, Word, Excel, Access, PowerPoint, Visio, Project, InfoPath, SharePoint
• Programming languages: C, C++, SQL, PLSQL, T - SQL, R, Python, Perl
• Business intelligence, analytics, and data visualization skills: SPSS, ArcGIS, Toad, Oracle, SQL Server, MySQL, SSRS, SSIS, Tableau, Teradata
• Data analysis, data mining, database development, ETL
• Business intelligence (BI) architecture, data modeling, analytics, data reporting, performance metric dashboarding
• Project management
• Training and meeting design and facilitation
• Research and report writing
• Strategic planning and organizational analysis of public, private, and non-profit organizations

PROFESSIONAL EXPERIENCE:

Independent Start - up Consultant, Adjunct Professor

Confidential, Cambridge, MA

Responsibilities:

• Advised start-ups businesses in online financial services, algorithmic trading investment strategies, platform strategy and adjunct professor:
• Advised Confidential ., an algorithmic trading investment strategies lean startup, on identifying alternative investment strategies based on machine learning and econophysics approaches. Recruited team comprised of computational finance, mathematical finance, and machine learning experts. Managed development of new algorithms and performance measurement of investment strategies.
• Advised Momzey, a local business social network platform, on business model and platform strategy, business plan, and go-to-market strategies. Recruited team members and contributed to marketing materials and operational plan.
• Adjunct professor at Cambridge College. Taught introduction to information systems to adults in MBA program. Developed hands-on data analytics course using Tableau, SQL, and introduction to business intelligence and data science algorithms for graduate students for Fall 2017.

Analytics Consultant

Confidential, Cumberland, RI

Responsibilities:

• Developed ETL and Tableau dashboards for digital analytics from Webtrends Infinity and Adobe Site Catalyst.
• Developed R scripts to automate API extraction of metrics data, transformation of data using in-memory objects such as data frames, and loading of data into Teradata via R.
• Scheduled scripts for ETL using R and SQL and scheduled refreshes of Tableau dashboards on a regular, daily schedule.
• Responsible for Mind the Store program management to report on stability and optimization metrics for all non-pharmacy, non-PBM businesses on CVS .com.
• Supported development of major marketing analytics/insights engine project to provide actionable information to marketing on proposed wind turbine development, including creating Tableau dashboards, SQL querying and joining tables, and ETL.
• Responded to ad hoc Tableau requests from key staff in marketing, finance, operations, and from outside of division and globally, including Europe and Latin America.
• Created interactive dashboards for real-time demand planning that improved transparency and timeliness of data, enabling better decision-making.
• Supported the Institutional Advisory Services (IAS) business with reporting and analytics on actions to outcomes, including events, bulk email, postcards, lead generation, and sales outcomes. Used Tableau, Excel, OBIEE dashboards, Teradata, Datameer as necessary. Prepared regular ad-hoc reports with key performance indicators (KPIs).

Senior Tableau Developer

Confidential, Chestnut Hill, MA

Responsibilities:

• Within the Tech Ops and Analytics team, developed Tableau dashboard data visualizations of performance metrics for the integrated marketing campaigns of select digital agency clients, and internal financial reporting.
• Responsible for Business Intelligence (BI) architecting, data modeling, and data reporting, including data quality and governance best practice.
• Developed ETL processes using SS Data Tools 2012/SSIS and T-SQL scripting and procedures for profiling, cleansing, and data analysis and mining locally on SQL Server 2012 and on the Azure cloud.
• Developed standard dashboards for media types such as display, TV, paid search/PPC on Google and Bing and other advertising on Facebook.

SQL Developer

Confidential, Boston, MA

Responsibilities:

• As part of the Data Management Team, reviewed the data quality of volume and linkage reports for provider data, including encounter, patient, diagnosis, billing, lab, and other healthcare data.
• Performed ad hoc data querying, data mining, and visualization of data trends as part of root cause analysis.
• Ensured that data in the
• CDR (common data repository) was ready for the factmart. Supported the development of new data quality metrics and data integration using SQL, Unix/bash scripting, and Tableau.

Analyst

Confidential, Boston, MA

Responsibilities:

• As part of the Data Standardization and Enhancement Team, supported the implementation of the master data management (MDM) process to facilitate the release of health data for the state.
• Worked with systems implementers to gather business requirements, design, develop, test, and operationalize MDM process.
• Supported release efforts via extraction of data, SQL querying, and QA of public and custom releases.

Confidential, Woburn, MA

Consultant

Responsibilities:

• Supported the data collection and analysis operations of a thermal imaging start-up. Steps involved XML extraction, GIS coding, file management, and SQL querying.
• Delivered recommendations for streamlining and automating the data management process from one that required multiple uploads and processing of data to one using MySQL on the cloud and automation in ArcGIS.

Senior Analyst

Confidential, Cambridge, MA

Responsibilities:

• Supported the U.S. Department of Transportation in operations and policy research.
• Developed a database and reporting process for the Federal Aviation Administration (FAA) Ambient Protocol task, as part of its collaborative Air Tour Management Plan (ATMP) effort with the National Park Service. Developed and populated tables, developed queries and procedures to enable remote access, and documented process.
• Analyzed a highway congestion pricing model as part of an economic team's review for the Federal Highway Administration. Flowcharted the model at a high level and at a detailed, step-by-step level after documenting the algorithm used. Identified assumptions, inputs, and dependencies between calculations for three different scenarios.
• Responded to data quality requests via the Federal Motor Carrier Safety Administration’s DART system, a web-based data request tracking system.
• Responding to DART requests consisted of clarifying business rules, querying data from multiple database sources, analyzing and charting data in Excel, developing reports, and validating data using a variety of software. Responding to DART requests also required assisting junior analysts as needed.
• Coordinated and managed the production cycle for quarterly online reporting of the NAFTA module, part of the Federal Motor Carrier Safety Administration’s Analysis and Information (A&I) website. Architected business intelligence (BI), designed and developed reports, defined business requirements, and delegated tasks to team of SQL/PLSQL programmers and web developers. Facilitated testing to production of module.
• Gathered business requirements, analyzed annual strategic performance measure data, wrote report, and delivered the report to the Federal Motor Carrier and Safety Administration (FMCSA). Project execution required learning PLSQL, testing, and implementing PLSQL programming and automation of the processes necessary for data analysis and reporting of the results. This was the first project in this work group to use PLSQL and an automation process for data analysis and reporting.
• Designed and facilitated focus group sessions for research on stakeholder needs regarding the use of an Internet-based tool to promote the adoption of intelligent transportation systems (ITS) standards for the Federal Highway Administration Joint Program Office.
• Conducted secondary and primary research and report writing for an organizational re-design of a CIO division within a public agency. Interviewed stakeholders and interviewed representatives of other agencies as part of best practices research.

Adjunct Professor

Confidential, Boston, MA

Responsibilities:

• Designed and taught strategic management, marketing, and organizational behavior to college management students. Taught using lecture, case analysis and discussion, and interactive in-class exercises. Evaluated students.
• Taught the capstone strategic management course and the organizational behavior course to an international group of management majors.
• Taught marketing to a diverse group of adult learners at Roxbury Community College

Consultant

Confidential, Boston, MA

Responsibilities:

• Designed and delivered strategy projects for leading hi tech and manufacturing companies. Coordinated research, conducted interviews, planned and participated in the facilitation of workshops, wrote reports, supported presentations to clients, and assisted with project management. Developed sales proposals and presentations for new clients. Developed rich scenarios, events, and other materials of industry evolution for client decision-making, planning, and organizational learning.
• Designed and presented new value propositions and business model alternatives for the specialty chemical and performance polymer business unit of a global, diversified corporation. The company is using this framework to develop growth strategies and to improve its marketing to customers.
• Conducted competitive analysis and identified emerging business models and success factors for the delivery of software-as-a-service to support the initiatives of a major enterprise software and hardware vendor. The company used these findings to assess the viability of its current and future initiatives.
• Conducted secondary research and interviews, developed materials, and facilitated a two-day decision-making scenario planning session to enable a major telecommunications company to adapt its corporate strategy to reflect a transition into a new media company with distinct capabilities in commerce, content, and connectivity.
• Assisted the largest server business of a major IT vendor to reconceive its business strategy and refine its marketing for the next four years, based on the impact of e-business on customers’ business models.