170 Budlong Farm Road ♦ Warwick, RI 02886 ♦ (401) 480-9001 or (860) 415-0500 (cell)
Goal: To assist clients in optimizing the integration of transaction systems with third normal form and dimensional data warehouses. I specialize in data architecture and conforming business facts and dimensions to the business intelligence layer. Includes the use of changed data capture techniques when appropriate.
Data Architect, SQL Server Developer/DBA and Senior Consultant 1986 - 2012
Native American Business Enterprises (Mashantucket Pequot Tribe) 11/11-01/12
Assisted in the development of a federal application for a new HL7 (XML) component development project integrating with tribe's PrxN Pharmacy Benefits Management (PBM) program. This was a follow on to previous work I did for the tribe. Studied impact of Affordable Care Act provisions on healthcare delivery systems.
Capgemini - IBM Changed Data Capture and Data Stage 02/11-07/11
Lead data architect and data modeler. Transformations of Guidewire Policy Center data on SQL Server to IBM mainframe via InfoSphere (DataStage). My main tasks were the building and maintaining of the PowerDesigner data models, direction for the execution of the proof of concept using SQL Server replication logs and the building of the DB2 receiving database as well as MicroStrategy datamarts. Responsible for maintaining SQL Server DDL for the transformation stages.
BASEL Transmissions – RBS Americas and Citizens Bank - 01/08 – 8/10
My primary function was to oversee the daily transmission of credit derivative positions and bank treasury instrument positions to the Royal Bank of Scotland’s central facility for the calculation of positions and other credit risk data. I also reviewed legacy credit risk database applications and prepared outside auditor reports and validations. Managed monthly reporting cycle for risk area.
Data Architect – Fidelity Investments - 01/07 - 12/07
I served as the data architect for a team developing an equity trading system for Fidelity. The mission was to build a data model for a Java/Data Cache based transaction system, employing an in-memory, high-speed data store (Oracle’s TimesTen). I used Power-Designer to convert a conceptual/logical model to a full machine-level physical model. Java programmers in Boston and India used the resulting data definition language (DDL) that I derived from the data model to generate the actual normalized transaction data being pushed out of the TimesTen data cache. It was received in a permanent Oracle database. I also mapped the set of reference data that was loaded into the cache to be used by the Java programmers to establish an object relational model of investment vehicle and other data needed for the trading process. A major objective was building a pathway for supporting derivatives as part of the automated trading platform.
Senior Data Analyst - Verispan - 04/06 - 11/06
responsibility was the data modeling and mapping of pharmacy scripts
and medical (physician) procedure data collected from switches and
pharmacy chains into
X-12 and XML formats for data exchange with pharmaceutical companies. The medical encounter data ties to the Verispan pharmacy script database to allow for longitudinal studies combining medical encounters with pharmacy scripts and fills. SAS analysis.
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. 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
Reviewed data models across Pfizer to determine if they meet the corporate standards. ERWin and ModelMart were used in this mostly Oracle activity. Corporate Modeler.
Delta Dental of Rhode Island 05/04 - 08/04
SQL Server DBA Tasks. T-SQL stored procedure programming.
Textron Financial 11/03 - 05/04
Completed data map of eight feeds from commercial loan and lease transaction systems including SQL Server and DB2 data plus the general ledger system feeding into SAS Data sets associated with the Textron Financial Data Warehouse Phase II.
Teknor Apex Company 06/03 - 10/03
Set up complex Microsoft Data Transformation Service- and FTP-based mainframe and AS/400 feeds to the SQL Server data warehouse for CRM.
Neighborhood Health Plan 10/02 - 03/03
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
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.
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.
Other Consulting 1991 - 2002
Clients included Demos Consulting (StaffSmart Banking Manpower Model) John Hancock Financial Services, GIGA Information Group, MicroStrategy and Strategy.com, Behavioral Healthcare Partners, Inc., PAREXEL, Blue Cross and Blue Shield of Massachusetts, Fleet Bank.
Mashantucket Pequot Tribal Nation – Pharmacy Benefit Manager 1986 – 1991 - 2012
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 and PBMs in the
nation. United Nations Environment Program consulting. 2012
(Current) Affordable Care Act consulting.
Bachelor of Science in Business Administration, University of Connecticut
rel 08/15/12 HTML
Return to langseth.com