Richard Langseth

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

PROFESSIONAL SUMMARY

Data transformations, data architect, database designer, data analyst, project manager. Can serve as DBA. Experience with SQL Server for over 10 years including some SQL Server 2005.

My now ending assignment is 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 and the web site layout. For data modeling, I have experience with Casewise Corporate Modeler, ERwin, PowerDesigner, ER/Studio, and the Visio database and process modules. My experience includes dimensional data support systems (DSS), data architecture, data modeling, business analysis, programming, and project management. Report writing packages include Crystal, VB, Access and Excel VBA, Cognos PowerPlay and MicroStrategy Web tools. Some SAS.

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. Work with Star Schema and other Kimball structures to support Cognos and MicroStrategy environments, both of which have fact, dimension and measure formats.

OLAP: MicroStrategy 7, Excel & Access 2000 OLE DB, Seagate Info, Crystal Reports 8, Cognos 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. Applications include Demos StaffSmart (banking), ONYX, SalesLogix and other sales force automation tools.

DBA: 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.

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

Object Access to SQL: DTS - Data Transformation Services including VB extensions, ADO - ActiveX Tools, BCP 2000 and other data extracting, transformation and loading tools.

Database and WEB programming support: Visual Interdev 6 asp, VB 6 and dot net, VBA including Access 2000 and Excel, ADO, Delphi, Dreamweaver and UltraDev, Cold Fusion, some Visual Studio.net, some mainframe download experiences. Some SAS. I am currently working with SQL 2005 Analysis Service, Integration Service, and Report Service.
PROFESSIONAL EXPERIENCE

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.

· Validated reports being developed in SAS against corporate accounting systems running in a mainframe environment. Built special reports in Microsoft Access to balance against SAS data sets.

· Documented the consolidation of data processes from the disparate loan systems into the central data warehouse. This included the analysis of the inbound data consolidation programs written in various languages, the study of the actual rows and columns of data being mapped into the central GL Ledger-based hierarchy, and new data feeds being developed by other vendors.

· Developed methodologies to validate the data being consolidated into the central warehouse including SQL queries. The overall database was of moderate size, in the several million-row category

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.

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 Database 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

EDUCATION

Bachelor of Science, University of Connecticut

rel sql 03/21/06