Richard Langseth

170 Budlong Farm Road ♦ Warwick, RI 02886 ♦ (401) 738-4347 or (401) 480-9001 (cell)

PROFESSIONAL SUMMARY

Decision support systems resource, data architect, database designer, data analyst. Experience managing Dot Net, C#, SQL Server, Oracle and Cognos tools. I currently direct a managed care programming effort being performed in India for the physicians group of Tufts New England Medical Center. My overall experience includes data modeling, business analysis, cube building, and technical/project management. Report writing packages include Cognos Impromptu and Powerplay, Crystal, Access, Excel VBA, and MicroStrategy Web tools. Some SAS.

I have specialized in the use of Microsoft SQL Server as a data analytics tool including working for a consultant to Citizens Bank in the area of branch optimization. I previously consulted with Fleet Bank analyzing loan portfolio performance and OREO management issues, marketing projections and consumer satisfaction data. In the distant past, I worked with Hartford National Bank on EFTS strategies and cash management techniques.

TECHNICAL SKILLS

OLAP: Cognos and Powerplay, MicroStrategy, Excel & Access statistical analyses, SQL Server Analysis Services. Major database platforms include Oracle and SQL Server. OLAP examples include bank teller performance, retail data acquisition and analysis, supply side logistics data cubes, and insurance buyer behavior analysis models. Applications include Demos StaffSmart (banking), ONYX, SalesLogix and other sales force automation tools. Some SAS.

Object Access to SQL: DTS - Data Transformation Services, ADO - ActiveX Tools, BCP 2000 and other data extracting, transformation and loading tools to load IBM Mainframe data, AS-400, Oracle, and Microsoft Excel and Access data into SQL Server warehouses and cubes.

Database and WEB programming support: A touch of Microsoft asp and dot net aspx, Visual Basic COM objects, VBA including Access 2000 and Excel, ADO, Delphi, Dreamweaver and UltraDev, Cold Fusion, some Visual Studio.net, VB.net aspx, access to databases through UNIX and NT, some C for data conversions, some mainframe download experiences.

Data Architectureand Business Analysis: Corporate Modeler, ERwin, PowerDesigner, and Visio Database data modeling including X.12 electronic commerce data mapping, Kimball "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.

DBA: SQL Server 4.2, 7.0, 2000, and SQL 2005 DBA including tuning strategies and restoration plans, various ETL (Extract Transform Load) data loading tools bring disparate data bases together into SQL Server data stores, warehouses, and data marts. I have 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.

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

PROFESSIONAL EXPERIENCE

Technical Team Management, Data Architect, and Senior Consultant1986 - 2005

New England Medical Center - New England Quality Care Alliance01-05-Present
  • I am overseeing a off-shore project focusing on the development of federal HEDIS measures in a patient registry setting. I am the data architect, analyst, and team manager.
  • Dot Net/C# developers based in New Delhi.
  • My responsibilities include writing SQL scripts to measure physician compliance with federal quality guidelines.
  • Includes extensive data transformations of claims, enrollment, and provider data into a SQL Server 2005 beta data base.
  • 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.
Pfizer08/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.
Delta Dental of Rhode Island05/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 Database1986 – 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 Neighborhood Health Plan of New England)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 Providence Washington Insurance)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 Healthcare03-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. Some Cognos.
  • I coordinated offshore programming and data base design using ERwin and Visio Database tools.

Merrill Clark08-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 Services10-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 Group06-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. Cognos cubes for reporting.
  • 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 and Cognos cubes..

Northeast Utilities1996 - 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. Impromptu and PowerPlay used for reporting. This was an early Cognos implementation with a Cognos home office support team providing direction.
  • Converted databases from SQL Server 4.2 to 6.5. Developed stored procedures. Fed Cognos cubes from SAP manufacturing data.

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 olap 01/20/06