Fitness enthusiast, enjoy running, cycling, and strength training
Learning to play guitar and writing songs
Richard P. Smith
North Andover,MA
Summary
Capable BI Manger/Lead Developer with solid background in leading business intelligence initiatives. Proven track record of implementing data-driven strategies that enhance decision-making processes and drive business growth. Demonstrated expertise in data analysis and visualization, showcasing strong leadership and problem-solving abilities.
Overview
32
32
years of professional experience
Work History
Business Intelligence Manager/Lead Developer
Personify Health Formerly Virgin Pulse/ Welltok
09.2016 - 03.2025
- Managed and led a team of off-shore Business Intelligence (BI) up to three developers and two testers to create enterprise level reports for external and internal customers.
- Managed day to day activities and prioritized user stories and development tasks
- Mentored developers by providing constructive feedback, sharing technical knowledge, and fostering a collaborative work environment.
- Developed and managed relationships with external BI partners and vendors.
- Evaluated third-party BI tools, making recommendations for cost-effective solutions that aligned with company objectives.
- Implemented knowledge transfer sessions between internal team members.
- Fostered an inclusive work environment where team members felt comfortable sharing ideas and feedback, ultimately resulting in stronger collaboration and improved overall product quality.
- Led successful migration projects from legacy systems to modern BI platforms, minimizing downtime during transition periods.
- Architected, implemented, and maintained enterprise reporting solution for external customers using Cognos, Tableau, and MicroStrategy reporting tools
- Supported product owners in defining clear requirements for feature enhancements or new functionality requests through active participation during backlog grooming sessions.
- Led developer meetings to discuss project milestones, share updates on individual progress, address any obstacles faced, and encourage collaboration amongst team members.
- Worked closely with product management to map out user stories and identify gaps for future iterations
- Reporting and data subject matter expert for campaign management system (Activate)
- Developed and maintained complex Sql queries for extracting and testing data
- Analyzed data to identify root causes of problems and designed corrective actions.
- Worked with database developers to design reporting database objects
- Collaborated with cross-functional teams to identify key performance indicators and develop relevant metrics.
- Developed customized and standard reports, dashboards, and OLAP cubes to provide actionable insights for key stakeholders.
- Provided technical support for troubleshooting analytics and reporting issues.
- Improved report/dashboard performance by optimizing code, implementing caching strategies, and conducting regular profiling sessions.
Business Intelligence Developer/ Technical Project Lead/ Operations Lead
Thermo Fisher Scientific
01.2008 - 09.2016
- Developed, tested, and maintained OLAP data cubes using Cognos’s PowerPlay Transformer
- Developed, tested, and maintained reports using Cognos’s Report Studio and Analysis Studio
- Develop, test, and maintain data models using Cognos’s Framework manager
- Collaborated with cross-functional teams to gather requirements and create tailored BI reports for stakeholders.
- Secondary administrator for Cognos environment
- Technical BI support for corporate sales data mart
- Improved overall efficiency by automating manual reporting tasks through the development of dynamic BI tools.
- Develop, test, and maintain database tables, views, and stored procedures to support cubes and reports
- Wrote and optimized SQL statements to assist business intelligence practices.
- Lead daily operations of corporate sales data mart
- Moderate weekly meeting with technical teams and business users
Senior Programmer Analyst/Lead Cognos Developer
MedVentive Inc.
01.2005 - 01.2008
- Develop, test and maintain data cubes using Cognos's PowerPlay Transformer
- Develop, test and maintain reports using Cognos’s Report Studio and Analysis Studio
- Cognos8 environment administrator
- Assisted on Cognos8 environment installations
- Cognos technical lead for projects from development through implementation
Consultant
Concord Communications
01.2005 - 12.2005
- Develop, test and maintain data cubes using Cognos's PowerPlay Transformer
- Develop, test and maintain reports using Cognos's Impromptu
- Develop marketing presentations for director level management
- Project lead of all corporate marketing reporting projects
- Responsible for maintaining marketing’s events tracking access database
- Responsible for the accuracy of marketing lead management via SalesLogix
Consultant, The Timberland Company
Ciber Inc.
01.2004 - 12.2005
- Work with end users to define report and data cube requirements
- Technical lead for projects from development through implementation
- Develop, test and maintain data cubes using Cognos's PowerPlay Transformer
- Develop, test and maintain reports using Cognos's Impromptu
- Implement data cubes and Impromptu reports via Cognos's Upfront
- Train and consult team members and end users on best practices
- Adhere to Change Management standards
Senior Business Systems Analyst
Solucient L.L.C.
01.2000 - 12.2004
- Write technical specification documents for a physician profiling system (Peer-A-Med)
- Coordinate project scheduling with development team, implementation team, and production management
- Insure quality and accuracy of all software development to the Peer-A-Med product
- Cognos administrator for Cognos Software products (PowerPlay, Transformer, Impromptu, Impromptu Web Reports, Upfront, Cognos Query)
- Build and test data cubes using Cognos’s Power Play Transformer software
- Build and test database queries and reports using Cognos’s Impromptu and Cognos Query software
- Assist with on-site customer implementations and training
- Provide technical support internal and external customers
- Install web-based applications as part of overall production implementation
Account Manager
ELECTRONIC DATA SYSTEMS (EDS-Wireless Division)
01.1995 - 12.2000
- Promote company programs, policies, and values with customer and account team
- Provide coaching, development plans, direction, feedback, and escalation path for all team members
- Hold financial accountability for customer accounts including revenue, receivables, and work order management
Senior New Accounts Analyst
CELLULAR ONE
01.1993 - 12.1995
- Analyzed credit bureau reports on all new customers’ credit worthiness and activated new cellular phone accounts via CMIS
- Trained new employees in all aspects of department and the cellular business and acted as a liaison between customers and our inside sales force as well as outside dealerships
- Used troubleshooting skills to help customers having problems with their service or equipment
Education
Bachelor of Arts - Economics
University of Massachusetts
Amherst, MA05.1989
Skills
- Tableau Report Creation
- Tableau User Administration
- MicroStrategy Report Creation
- Cognos Analytics Product Suite including administration, data modeling, and report/ cube development
- Proficient in PL/SQL Queries
- Skilled in Cloud Data Management with Snowflake and Databricks
- Working knowledge of MYSQL, and PostgreSQL
- Experienced in Agile tools Jira and Rally
- Problem-solving abilities
- Attention to detail
- Multitasking
- Reliability
- Excellent communication
- Team collaboration
- Adaptability and flexibility
- Verbal and written communication
Interests
Timeline
Business Intelligence Manager/Lead Developer
Personify Health Formerly Virgin Pulse/ Welltok
09.2016 - 03.2025
Business Intelligence Developer/ Technical Project Lead/ Operations Lead
Thermo Fisher Scientific
01.2008 - 09.2016
Senior Programmer Analyst/Lead Cognos Developer
MedVentive Inc.
01.2005 - 01.2008
Consultant
Concord Communications
01.2005 - 12.2005
Consultant, The Timberland Company
Ciber Inc.
01.2004 - 12.2005
Senior Business Systems Analyst
Solucient L.L.C.
01.2000 - 12.2004
Account Manager
ELECTRONIC DATA SYSTEMS (EDS-Wireless Division)
01.1995 - 12.2000
Senior New Accounts Analyst
CELLULAR ONE
01.1993 - 12.1995
Bachelor of Arts - Economics
University of Massachusetts
Similar Profiles
Theron RothsteinTheron Rothstein
Associate General Counsel at Personify Health (formerly Virgin Pulse)Associate General Counsel at Personify Health (formerly Virgin Pulse)
Haley HolborowHaley Holborow
Implementation Manager at Personify Health (formerly Virgin Pulse)Implementation Manager at Personify Health (formerly Virgin Pulse)
Cassandra MahurinCassandra Mahurin
Senior Director, HRBP at Personify Health (formerly Virgin Pulse)Senior Director, HRBP at Personify Health (formerly Virgin Pulse)