Richard Langseth

170 Budlong Farm Road ♦ Warwick, RI 02886 ♦ (401) 738-4347 or (401) 480-9001 (cell) richard@langseth.com

• Data Architect, Data Modeler, SQL Server 2005 resource. OLAP expertise including Star Schemas. Metrics development on large partitioned Oracle data warehouse.

• I have strong Power Designer and Erwin experience with 10 years experience. SQL Server and Oracle data warehouse design experience, skilled with SQL languages.

• On the business side, I have just finished a study to determine impacts of low cost generic drugs using Verispan's data warehouse. It stores over 50% of all pharmacy claims.

• My most recent past assignment has been to facilitate the development of health quality measures using an off shore resource for programming and web site development. I developed user requirements, the conceptual and physical data models, the process models for data transformations and the web site layout.

• Prior to that, I served as a data architect and data content analyst at Pfizer building a path to trace newly discovered compounds from initial registration at the bench or robot through to post marketing surveillance.

TECHNICAL SKILLS

Data Architecture and Business Analysis: Corporate Modeler, ERwin, PowerDesigner, and Visio Database data modeling including X.12 837 and UB-92 HIPAA electronic commerce data mapping, "pen and pencil" analysis, Zachman Framework, and other business analysis tools. Skilled at architecture views including "swim lanes". Entity Relationship diagrams, System Dynamic and Functional Dynamic diagrams and other flowcharting techniques.

OLAP: MicroStrategy 7, Excel & Access 2000 OLE DB, Crystal Reports, Cognos Impromptu and Powerplay. Major database platforms include Oracle and SQL Server. OLAP examples include managed care, physician prescribing patterns, clinical trial adverse event analysis and insurance buyer behavior analysis model. Sales force automation tools. SAS data setups.

DTS: Data Transformation Services including SQL Server 2005 and SQL Server 2000 ActiveX Tools, Bulk Copy (BCP) and other data extracting, transformation and loading tools. Limited Oracle data loading. That is not my area of expertise.

SQL: as a language Microsoft T-SQL, Oracle PL/SQL triggers, stored procedures and SQL*Plus

Database and WEB programming support: As needed for transformations - VB 6 and dot net, VBA including Access 2000 and Excel, ADO, Delphi, Dreamweaver and UltraDev, rusty Cold Fusion, some Visual Studio.net, some mainframe download experiences. I am currently working with SQL 2005 Analysis Service, Integration Service, and Report Service.

DBA: Occasional SQL Server 2000 DBA including tuning strategies and restoration plans, various ETL (Extract Transform Load) data loading tools. Team building experience in large database clusters with multiple DBAs engaged in the integration of mainframes, UNIX systems and large-scale NT machines including RAID management. Now using SQL Server 2005.

PROFESSIONAL EXPERIENCE

Senior Data Analyst - Verispan - 2006

· My basic responsibility was to measure and monitor the capture of pharmacy and medical encounter data being stored at Verispan for use by pharmaceutical companies. This allows for longitudinal studies combining medical encounters with previous and subsequent pharmacy scripts and fills. A major interest was the switching of health savings accounts data through alternative channels such as MasterCard and Visa rather than the traditional Per-Se NDC and Caremark PCS switching channels.

· I also assisted in the fielding of specialty pharmacies, compounding pharmacies, and physician office dispensing tracked by "J Codes".

· I also studied the impact of low cost (Wal-Mart) generic drugs on the data warehouse.

Project Management, Data Architect, and Senior Consultant 1986 - 2006

New England Medical Center - New England Quality Care Alliance 01/05 - 04/06

· I project managed a SQL Server/dot net project to develop federal HEDIS measures and a patient registry. I served as the data architect, query writer and project manager.

· Includes extensive data transformations of claims, enrollment, and provider data into a SQL Server 2005 database.

· This is a web-based reporting system to help physicians meet their Harvard-Pilgrim, Tufts Health Plan, and Blue Cross quality objectives under Federal guidelines.

Pfizer 08/04-09/05

· I worked with the drug discovery area on chemistry- and biology-based enterprise entities that reach across the corporation. 21 CFR 11 compliance was sometimes required.

· I also reviewed data models across Pfizer to determine if they meet the corporate standards. ERWin and ModelMart were used in this mostly Oracle activity.

· Casewise Corporate Modeler used for conceptual data modeling and process modeling including case studies.

· This was mostly an Oracle environment. My mission included modifying Erwin models to recognize unique Oracle data structures and materialized views.

Delta Dental of Rhode Island 05/04-08/04

· SQL Server DBA Tasks.

· T-SQL stored procedure programming.

· Data Modeling of self-administration system in ERWin

· Report Subsystem debugging and performance tuning of SQL Server database.

Textron Financial 11/03-05/04

· Completed data map of eight feeds from commercial loan and lease transaction systems including SQL Server and UNIX based FTP data plus the general ledger system feeding into SAS Data sets associated with the Textron Financial Data Warehouse Phase II.

· Validated SAS Data feeds and tested embedded SQL queries within the SAS programming environment. Also worked with traditional SAS programs in a UNIX environment and with Korn-based scripts.

Teknor Apex Company 06/03 10/03

• SQL Server DBA – Maintained and tuned SQL Server databases in the ten million plus row size (multiple gigabyte range). My responsibilities included the design of backups and restores, the application of security patches, and monitoring the handling of viruses.
• Set up complex Microsoft Data Transformation Service- and FTP-based mainframe and AS/400 feeds to the SQL Server data warehouse for CRM, financial and production planning purposes. This was the crunch area for this client. Microsoft ETL tools were used for the processing of FTP and AS/400 data.
• Built EDI interfaces to pass X12-based EDI purchase order and fulfillment transactions from major buyers as well as custom interfaces to the SQL Server from distributors and major retail chains. Supported supply-side reporting systems.
• Automated the transformation of Impromptu reports into Cognos Power Play cubes.
• To a large extent, this was a team building and mentoring project. At first, I filled in for the departing DBA. Then I built a team around the EDI process as it unfolded. I mentored a junior person who then took over as the DBA. At that point, I had successfully completed the tasks to be done and I moved on to the next assignment.

Mashantucket Pequot Tribal Nation – Various Database 1986 – 2004

· Managed projects to develop healthcare systems and HMO-like business structures. Used CA SuperProject for project management tasks.

· Developed various databases and Web sites using SQL Server and Dreamweaver Ultradev as well as older tools dating back to the 1980s. Built an Indian Country data network tying tribes together for common reporting of health data and supply ordering.

· Used ERwin for data design. Business modeling with Visio.

· In the spring of 2003 (03/03 – 05/03), I worked on a special project to support a United Nations Environment Program project by building a data base and a web site.

· Developed an HMO filing for federal qualification. Built a third party claims processing capability. Help build a pharmacy network that now includes one of the largest mail-order pharmacies in the nation and a major PBM, the Pequot Pharmaceutical Network.

Keane, Inc. (For a Boston-based HMO) 10/02-03/03

· Finalized their HIPAA EDI X12n 837 Companion Guides and reject (997) planning including data feeds from Oracle and mainframe data.

· Designed SQL Server feeds to their data warehouse and EDI responses back to hospitals and physician groups as well as laboratories and pharmacies using such X12 data sets as the 276/277 sets, the 278 set, and the 835 set.

Unicom, Inc. (For a New England-based insurance company) 7/02 09/02

• As SQL Server DBA increased speed for stored procedures and worked with SQL variables to improve performance of their multi gigabyte database.
• Used Microsoft Data Transformation Service to build complex a premium/loss reserve metrics model in Cognos Impromptu/Power Play. Built reports from the Cognos cubes.
• Reverse engineering of existing databases performed using ERwin.

United Healthcare 03-02 06-02

• Served as project management system business analyst while building new ways to track projects, and measure project performance metrics. Platform was Oracle and Cognos. Visio used for business process and data modeling.
• I coordinated offshore programming and data base design using ERwin and Visio tools.

Merrill Clark 08-01 01-02

• Conversion to SQL Server of chemical and hazardous material laboratory inventory system written in VB 6 COM objects. Client was the FDA.

Demos Consulting (StaffSmart Banking Manpower Model) 05-01 08-01

• AS their DBA, I set up their Fleet Bank implementation of their StaffSmart Workforce Management model database to SQL Server as required by Fleet. At that point their Citizens Bank model continued to operate as an Access database.
• Converted their StaffSmart management programs to SQL Server using VB ADO links and stored procedures that were previously running under Access 2000.

John Hancock Financial Services 10-00 05-01

• Served as a project manager and DBA consultant to focus on their SalesLogix CRM implementation to solve database performance issues within the structure of their SQL Server 2000 database with the professional assistance of Microsoft.
• Used Visio database tool as primary business planning and presentation tool.
• Combined banking and broker/dealer channels in to a common large database.

GIGA Information Group 06-00 01-01

• Served as SQL Server DBA for this clustered computer site with an active paid subscriber Web interface. Ensured that the near-instantaneous backup feature was working and performed manual restores once the backup feature kicked in.
• Assisted in the conversion of the GIGA web site ONYX-based back end to SQL Server 7, and a new version of ONYX.
• Set up programs in Visual Basic to analyze questions being posted on the web site by business clients. Worked with GIGA analysts on SQL Server questions.
• Scheduled task completion logs; performed web traffic analysis.

Strategy.com 01-00 05-00

· Managed a project to research the offering of additional financial services for users of desktop and wireless devices for this MicroStrategy consumer marketing operation.

• Developed SQL Server and Teradata approaches to optimizing stock market database

Behavioral Healthcare Partners, Inc. 1998 - 2001

• Built their data warehouse on a SQL Server 7 platform and served as their DBA.
• Built their web site utilizing Visual Studio, Dreamweaver 4, and ColdFusion 4.
• Managed the practice management package and developed the managed care/triage system with feeds to other providers. Covered the HIPAA planning issue.

· Analyzed healthcare data utilizing MicroStrategy tools.

Northeast Utilities 1996 - 1997

• Built automatic feeds from OASIS to internal reporting systems. OASIS is the shared Open Access Same-Time Information System used by NorthEast Utilities, National Grid, and several other utility companies for bulk power reserving and purchasing.
• Programming was carried out using VBA under Excel. Data was received via FTP from a variety of sources.
• This was mainly a reporting system to support power futures calculations and power brokerage operations.
  

PAREXEL International 1996 - 2000

· As a SQL Server DBA, I built a shadow SQL server 7 database that extracted data form a large Lotus Notes application, stored it in SQL Server tables and passed the data on to a large international clinic as ASCII files to be fed into SAS data sets.

· Maintained NT-based Oracle databases from a hardware RAID and systems programming perspective assisting the Oracle DBA with configuration issues.

· Provided business analysis, database administration, and data management support including the building of SAS data sets. Data architecture and business process tools were Visio, PowerDesigner and Erwin. Some 21 CFR documentation.

Polaroid Worldwide Supply Chain 1996 - 1998

· Set up and maintained Windows NT server and SQL server database while serving as SQL Server Database Administrator. (This was my first Microsoft SQL Server DBA experience. Prior experience was in Ingress, Sybase and Oracle.)

• Converted databases from SQL Server 4.2 to 6.5. Developed stored procedures.
  

HMO Blue 1993 - 1996

· Developed SQL queries to be passed against various UNIX-based databases to study claims data and create HEDIS data sets. (These are the same data sets that I am working on now (2005) for physicians contracted with Blue Cross, Harvard-Pilgrim, and Tufts.

· Created physician profile reports and other performance measurements from data, quality measurement, and case management systems.

Fleet Bank 1991 – 1994

· Developed nonperforming loan migration models for commercial loans and supported the implementation of the same in all operating banks. This was a PC-based application.

· Assisted in the development of block sale portfolio data sets using the C language for data transformations. These data were used in due diligence operations.

· Built OREO inventory reports for commercial real estate in all banks from downloaded mainframe data.

· Analyzed and developed the commercial banking operations new business pipeline including the aggregation of spreadsheets from the operating banks.

· Filled various roles in consumer response-based quality measurement and marketing systems

Rhode Island Pharmacy Switch 1991 – 1993

· Developed data capture techniques and data warehouse for an early on line pharmacy switch and third party payer/PBM, ProMark. This portion of ProMark was sold to Medco in 1994. Our data was used to studied the effects of formularies on prescribing patterns and realign pharmaceutical sales reps marketing efforts.

(Note: There was considerable overlap of clients during this time.)

EDUCATION

Bachelor of Science, University of Connecticut

rel ba_html 10/20/06