аЯрЁБс;ўџ ]ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџўџџџ\  !"ўџџџ$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[ўџџџўџџџ^ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџџџџџўџџџџџџџџџџџџџџџўџџџџџџџџџџџџџџџўџџџџџџџџџџџџџџџўџџџўџџџўџџџўџџџ ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџ џџџџ РFMicrosoft Word-Dokument MSWordDocWord.Document.8є9Вqўџр…ŸђљOhЋ‘+'Гй0ф X`pˆ˜ Ј Д Р Ь ищ§SUMMARY IBM EmployeeNormalJo-Ann2@FУ#@Дћ Ф@В_Шa`Ы@В_Шa`ЫТ [dёџdDefault$a$1$*$7$A$/B*OJQJCJmH sH PJnH^JaJ_HtHP‚ P Heading 1@& & F & FЄЄOJQJCJaJZ‚ Z Heading 2@& & F & FЄxЄOJQJCJ5^JaJ\N‚ N Heading 3@& & F & FЄxЄCJ5aJ\tt Heading 49@& & F & F$a$1$ Ца p@  р$CJmHsH5aJ\dd Heading 59@& & F & F$a$1$ Ца p@  р$5\nn Heading 64@& & F & F$a$$d%d&d'd$OJQJCJ$5aJ$\BA@ђџЁBAbsatz-Standardschriftart.ўђџё. WW8Num2z0 OJQJ^J.ўђџ. WW8Num3z0 OJQJ^J*ўђџ* WW8Num4z0OJQJ*ўђџ!* WW8Num5z0OJQJ.ўђџ1. WW8Num6z0 OJQJ^J.ўђџA. WW8Num7z0 OJQJ^J.ўђџQ. WW8Num8z0 OJQJ^J*ўђџa* WW8Num9z0OJQJ,ўђџq, WW8Num10z0OJQJ,ўђџ, WW8Num11z0OJQJ,ўђџ‘, WW8Num12z0OJQJ,ўђџЁ, WW8Num13z0OJQJ0ўђџБ0 WW8Num14z0 OJQJ^J,ўђџС, WW8Num15z0OJQJ0ўђџб0 WW8Num16z0 OJQJ^J0ўђџс0 WW8Num17z0 OJQJ^J0ўђџё0 WW8Num18z0 OJQJ^J0ўђџ0 WW8Num19z0 OJQJ^J0ўђџ0 WW8Num19z1 OJQJ^JBўђџ!BAbsatz-StandardschriftartHўђџ1HWW-Absatz-StandardschriftartJўђџAJWW-Absatz-Standardschriftart1LўђџQLWW-Absatz-Standardschriftart11NўђџaNWW-Absatz-Standardschriftart111PўђџqP WW-Absatz-Standardschriftart1111RўђџR!WW-Absatz-Standardschriftart11111Tўђџ‘T"WW-Absatz-Standardschriftart111111VўђџЁV#WW-Absatz-Standardschriftart1111111.ўђџБ. WW8Num1z0 OJQJ^J.ўђџС. WW8Num1z1 OJQJ^J.ўђџб. WW8Num1z3 OJQJ^J.ўђџс. WW8Num2z1 OJQJ^J.ўђџё. WW8Num2z2 OJQJ^J.ўђџ. WW8Num3z1 OJQJ^J.ўђџ. WW8Num3z2 OJQJ^J*ўђџ!* WW8Num4z1OJQJ*ўђџ1* WW8Num4z2OJQJ*ўђџA* WW8Num5z1OJQJ*ўђџQ* WW8Num5z2OJQJ.ўђџa. WW8Num6z1 OJQJ^J.ўђџq. WW8Num6z3 OJQJ^J.ўђџ. WW8Num7z1 OJQJ^J.ўђџ‘. WW8Num7z2 OJQJ^J.ўђџЁ. WW8Num8z1 OJQJ^J.ўђџБ. WW8Num8z2 OJQJ^J*ўђџС* WW8Num9z1OJQJ*ўђџб* WW8Num9z2OJQJ,ўђџс, WW8Num10z1OJQJ,ўђџё, WW8Num10z2OJQJ,ўђџ, WW8Num11z1OJQJ,ўђџ, WW8Num11z2OJQJ,ўђџ!, WW8Num12z1OJQJ,ўђџ1, WW8Num12z2OJQJ,ўђџA, WW8Num13z2OJQJ,ўђџQ, WW8Num13z3OJQJ0ўђџa0 WW8Num14z1 OJQJ^J0ўђџq0 WW8Num14z2 OJQJ^J,ўђџ, WW8Num15z1OJQJ,ўђџ‘, WW8Num15z2OJQJ0ўђџЁ0 WW8Num16z1 OJQJ^J0ўђџБ0 WW8Num16z2 OJQJ^J0ўђџС0 WW8Num17z1 OJQJ^J0ўђџб0 WW8Num17z2 OJQJ^J0ўђџс0 WW8Num18z1 OJQJ^J0ўђџё0 WW8Num18z2 OJQJ^J0ўђџ0 WW8Num19z2 OJQJ^J0ўђџ0 WW8Num20z0 OJQJ^J0ўђџ!0 WW8Num20z1 OJQJ^J0ўђџ10 WW8Num20z3 OJQJ^J,ўђџA, WW8Num21z0OJQJ,ўђџQ, WW8Num21z1OJQJ,ўђџa, WW8Num21z2OJQJ0ўђџq0 WW8Num22z0 OJQJ^J0ўђџ0 WW8Num22z1 OJQJ^J0ўђџ‘0 WW8Num22z2 OJQJ^J0ўђџЁ0 WW8Num23z0 OJQJ^J0ўђџБ0 WW8Num23z1 OJQJ^J0ўђџС0 WW8Num23z2 OJQJ^J,ўђџб, WW8Num24z0OJQJ,ўђџс, WW8Num24z1OJQJ,ўђџё, WW8Num24z2OJQJ0ўђџ0 WW8Num25z0 OJQJ^J0ўђџ0 WW8Num25z1 OJQJ^J0ўђџ!0 WW8Num25z2 OJQJ^J,ўђџ1, WW8Num26z0OJQJ,ўђџA, WW8Num26z1OJQJ,ўђџQ, WW8Num26z2OJQJ,ўђџa, WW8Num27z0OJQJ,ўђџq, WW8Num27z1OJQJ,ўђџ, WW8Num27z3OJQJ,ўђџ‘, WW8Num28z0OJQJ,ўђџЁ, WW8Num28z2OJQJ,ўђџБ, WW8Num28z3OJQJ,ўђџС, WW8Num29z0OJQJ,ўђџб, WW8Num29z1OJQJ,ўђџс, WW8Num29z2OJQJ0ўђџё0 WW8Num30z0 OJQJ^J0ўђџ0 WW8Num30z1 OJQJ^J0ўђџ0 WW8Num30z2 OJQJ^J0ўђџ!0 WW8Num31z0 OJQJ^J0ўђџ10 WW8Num31z1 OJQJ^J0ўђџA0 WW8Num31z2 OJQJ^J,ўђџQ, WW8Num32z0OJQJ,ўђџa, WW8Num32z1OJQJ,ўђџq, WW8Num32z2OJQJ0ўђџ0 WW8Num33z0 OJQJ^J0ўђџ‘0 WW8Num33z1 OJQJ^J0ўђџЁ0 WW8Num33z2 OJQJ^J0ўђџБ0 WW8Num34z0 OJQJ^J0ўђџС0 WW8Num34z1 OJQJ^J0ўђџб0 WW8Num34z2 OJQJ^J,ўђџс, WW8Num35z0OJQJ,ўђџё, WW8Num35z1OJQJ,ўђџ, WW8Num35z2OJQJ0ўђџ0 WW8Num36z0 OJQJ^J0ўђџ!0 WW8Num36z1 OJQJ^J0ўђџ10 WW8Num36z2 OJQJ^J8ўђџA8 WW8Num37z0OJQJCJ^JaJ,ўђџQ, WW8Num38z0OJQJ,ўђџa, WW8Num38z1OJQJ,ўђџq, WW8Num38z2OJQJ,ўђџ, WW8Num39z0OJQJ,ўђџ‘, WW8Num39z1OJQJ,ўђџЁ, WW8Num39z2OJQJ0ўђџБ0 WW8Num40z0 OJQJ^J0ўђџС0 WW8Num40z1 OJQJ^J0ўђџб0 WW8Num40z2 OJQJ^J,ўђџс, WW8Num41z0OJQJ,ўђџё, WW8Num41z1OJQJ,ўђџ , WW8Num41z2OJQJ,ўђџ , WW8Num42z0OJQJ,ўђџ! , WW8Num42z1OJQJ,ўђџ1 , WW8Num42z2OJQJ0ўђџA 0 WW8Num43z0 OJQJ^J0ўђџQ 0 WW8Num43z1 OJQJ^J0ўђџa 0 WW8Num43z2 OJQJ^J,ўђџq , WW8Num44z0OJQJ,ўђџ , WW8Num44z1OJQJ,ўђџ‘ , WW8Num44z2OJQJ0ўђџЁ 0 WW8Num45z0 OJQJ^J0ўђџБ 0 WW8Num45z1 OJQJ^J0ўђџС 0 WW8Num45z3 OJQJ^J,ўђџб , WW8Num46z0OJQJ,ўђџс , WW8Num46z1OJQJ,ўђџё , WW8Num46z2OJQJ,ўђџ , WW8Num47z0OJQJ0ўђџ 0 WW8Num47z1 OJQJ^J,ўђџ! , WW8Num47z2OJQJ<ўђџ1 <Default Paragraph Font6U2 A 6 Internet Link B*phџ>*FV2 Q FVisited Internet Link B* ph€€>*.ўђџa .BulletsOJQJPJ^JFў‚ FHeading ЇЄ№Єx$OJQJCJPJ ^J aJZB‚ Z Text body%Ј$a$1$ Ца p@  рOJQJCJaJ / ’ ListЉ^J @ўЂ @Caption ЊЄxЄx $CJ6^J aJ]&ўВ &IndexЋ $^J <>в <TitleЌ$a$ЄЄ№OJQJCJ0aJ08Jq ‚ 8Subtitle­$a$CJ6aJ]2ўт 2 Body SingleЎCJaJ@ўђ @Bullet 1Џ Цh^„h]„`„˜ўCJaJ@ў @Bullet 2А Цh^„h]„`„˜ўCJaJJў JFirst Line IndentБ^„]„`„аCJaJFў" F Number ListВ Цh^„h]„`„˜ўCJaJ8ў2 8 Table Text Г ЦCJaJTўB TOutline (Indented)Д Цh^„h]„`„˜ўCJaJ\ўR \Outline (Not Indented)Е Цh^„h]„`„˜ўCJaJbCb bText body indent(Ж Ца p@  р^„ ]„`„CJaJ4ўr 4 Default TextЗCJaJ,‚ ,Header И ЦрР!, ’ ,Footer Й ЦрР!pўЂ pBody Text Indent 21К$a$1$ Ца p@  р^„а]„`„CJaJBўВ B Plain TextЛ1$7$OJQJCJ^JaJnўТ nH4-Body Text-Bullet!М & F$a$1$7$^„h]„`„˜ўOJQJCJ^JaJ(ўв (Bullet Н & F Fўт F Body Text 2О$a$OJQJCJ5aJ\Šўђ ŠBody Text Indent 3CП1$ Ца p@  р^„h]„`„$d%d&d'dOJQJCJaJPў P defaulttextР1$7$ЄЄOJ QJ CJPJ ^J aJ^ў ^ Body Text 3С1$ Ца p@  рOJQJCJ5aJ\Ж'pџџџџ V.ЬVjW,-.N2V.r6†@ђKЪRjWlW/01234567џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ џџџџџџџџџ џџџџџџџџџ џџџџџџџџџ џџџџџџџџџ џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ^„А`„PўЦџ^„@`„Р§Цџ^„а`„0§Цџ^„``„ ќЦџ^„№`„ќЦџ^„€`„€ћЦџ^„`„№њЦџ^„ `„`њЦџ^„0`„аљЦ ^„а`„˜ўЦаOJQJ^JЗ№ ^„а`„˜ўЦаOJQJ^JЗ№^„а`„˜ўЦаOJQJЗ№^„а`„˜ўЦаOJQJЗ№ ^„а`„˜ўЦаOJQJ^JЗ№ ^„а`„˜ўЦаOJQJ^JЗ№ ^„а`„˜ўЦаOJQJ^JЗ№^„а`„˜ўЦаOJQJЇ№^„а`„˜ўЦаOJ QJ o^„а`„˜ўЦаOJQJЗ№^„а`„˜ўЦаOJQJЗ№^„а`„˜ўЦаOJQJЗ№ ^„h`„˜ўЦhOJQJ^JЗ№^„а`„˜ўЦаOJQJЗ№ ^„а`„˜ўЦаOJQJ^JЗ№ ^„а`„˜ўЦаOJQJ^JЗ№ ^„а`„˜ўЦаOJQJ^JЗ№ ^„а`„˜ўЦаOJQJ^Jё№ ^„8`„˜ўЦ8OJQJ^Jц% ^„ `„˜ўЦ OJQJ^JЊ% ^„`„˜ўЦOJQJ^Jё№ ^„p`„˜ўЦpOJQJ^Jц% ^„и `„˜ўЦи OJQJ^JЊ% ^„@ `„˜ўЦ@ OJQJ^Jё№ ^„Ј `„˜ўЦЈ OJQJ^Jц% ^„`„˜ўЦOJQJ^JЊ% џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџWW8Num2WW8Num3WW8Num4WW8Num5WW8Num6WW8Num7WW8Num8WW8Num9WW8Num10WW8Num11WW8Num12WW8Num13WW8Num14WW8Num15WW8Num16WW8Num17WW8Num18WW8Num19џ@Ж'Ж'PGTimes New Roman5Symbol3&ArialG€ MS Mincho-џ3џ fgY CG TimesTimes New Roman?&Arial Black;Wingdings?4Courier New_€ OpenSymbolArial Unicode MSI&Arial Unicode MS5Mangal5MangalI&€Arial Unicode MS?5Courier New?Wingdings 2Bаhg№щ†g№щ†ъХƒfсm'[ƒ[сm'[['№0№лп0€џџSUMMARY IBM EmployeeJo-AnnьЅM П0lWCaolan80 :pЊ' џџ,џџ/ џџˆf(f(f(z(8В(Ю(LЅ5є‚5™9bћ;\5)Ц2€F4<„5 йRichard Langseth 170 Budlong Farm Road f& Warwick, RI 02886 f& (401) 738-4347 or (860) 415-0500 (cell) richard@langseth.com PROFESSIONAL SUMMARY ICD-9 to ICD-10 federal health coding working group, conversions and crosswalks. Project management of health claims processing - HIPAA  HEDIS  TPA setups, provider networking. Managed federal online claims submission projects. X.12 HIPAA EDI trading partner datasets, conversions to HIPAA 837 standards. Clinical and pharmaceutical research studies tying physician components to lab and pharmacy data sets. Reports to pharmaceutical companies and chain drug stores. Data warehouse setups, transaction systems modeling, very large databases. Data modeler and architect, Erwin and PowerDesigner. Managed care PMPM models and calculations for HMO filings. Physician office automation and transmissions. ETL loads and replication log extracts including massively parallel data loads. IBM DataStage Changed Data Capture (CDC) Data dictionaries and corporate data conformance. EIS reporting tools  MicroStrategy, Cognos, Crystal, Microsoft analysis tools. Agile and traditional project management techniques. Offshore team building experiences. TOOL SETS: Project Management  Microsoft Project, CA SuperProject (Federal). Data Architecture and Business Analysis: PowerDesigner, ER Studio, and ERwin data modeling. Entity Relationship diagrams. Real time data capture. OLAP: Microsoft, MicroStrategy, Excel & Access, Crystal Reports, Cognos. 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. OLTP: Mainframe and in memory, object-based equity trading systems. Networked transaction systems including health claims processing and pharmacy integrations. SQL: as a language Microsoft T-SQL, Oracle PL/SQL triggers, stored procedures. Oracle data warehouse petition architecture experience. Experience with Oracle TimesTen in memory database setups. Teradata setups at MicroStrategy. DB2. CONSULTING EXPERIENCES: IBM InfoSphere Changed Data Capture and Data Stage  Capgemini - 02/11  07/11 Lead data architect and data modeler. Transformations of Guidewire Policy Center data on SQL Server to IBM mainframe via InfoSphere. 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. 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). Senior Data Analyst - Verispan - 04/06 - 11/06 My basic responsibility was the data modeling and mapping of pharmacy scripts and medical (CPT procedure) data collected from switches and pharmacy chains into X-12 and XML formats for data exchange with pharmaceutical companies. Included ICD-9 / CPT crosswalk planning to ICD-10. NCD and LOINC integration setups. This included normative calculations to determine relevance of data coming in from very large pharmacy and medical provider feeds. I also studied the X-12-based adjudication of medical savings accounts and the autoadjudication of claims through point of sale networks bypassing the traditional Per-Se NDC and Caremark PCS switches. 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, data modeler and query writer and C# ADO dataset-bound forms in C# for administrative pages and data conversions. ICD-9 and CPT coding conversion planning to ICD-10. NDC and LOINC integration. Included extensive data transformations of claims, enrollment, and provider data into a SQL Server 2005 database and data feeds to DB2-based mainframe setups. 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. Delta Dental of Rhode Island 05/04-08/04 Data modeling of self-administration system using ERWin, SQL Server administration. Textron Financial 11/03-05/04 Completed data map of eight feeds from commercial loan and lease transaction systems into SAS data sets associated with the data warehouse. Teknor Apex Company 06/03 10/03 Microsoft Data Transformation Service - AS/400 feeds to the SQL Server data base. Neighborhood Health Plan of Massachusetts 10/02-03/03 Finalized their HIPAA EDI X12n 837 Companion Guides and reject (997) planning including data feeds from Oracle and mainframe data. Extensive ICD-9 / CPT code crosswalks as required by data switches to line up with HIPAA 837 requirements. Conversions of in hospital claim submitted by paper into claims processing system. 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. 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. 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. 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 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 feeding mainframe database ( DB2-based). 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. 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 practice management bridges to capitation plans. Worked extensive with medical billing companies to automate billing submissions to claims processing system. 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. PAREXEL International 1996 - 2000 Project managed Cleveland Clinic cardiac intervention data project. Project managed and built AIDS adverse event collection and analysis system. Polaroid Worldwide Supply Chain 1996 - 1998 Cognos application. HMO Blue 1992 - 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 worked on at New England Medical Center 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. Mashantucket Pequot Tribe  Pharmacy Network and HMO 1986  1991 Project Managed federal Department of Health and Human Services projects for several tribes moving forward with managed care initiatives. Built an Indian Country data network tying tribes together for common reporting of health data and supply ordering. Early adoption of ARPAnet (Internet) FTP for file exchange. 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 and Pharmacy Benefit Management (PBM) firms in the nation. (The PBM is the Pequot Pharmaceutical Network - PRxN). EDUCATION Bachelor of Science, University of Connecticut, School of Insurance rel 10/14/2011 ICD ќў( * Ь і  ’ ж l и NЌЎN ІZ\rœјF&LV˜bd”–4Ш8V24Ќ˜!š!"†%''И'Ў)N*Œ+Ž+Ъ+-T.V.єєщщщщщщщщщщщщщщщщщлллЭлщлщлщлщлщєССЗЎСЗЎєЇЎЎЎЎžžЎЎЎ™žЎЎ™OJQJmH sH OJQJ ^JOJQJCJaJOJQJCJ5aJOJQJCJ5aJ]OJQJCJ5PJaJ\OJQJCJ5PJaJ\OJQJCJPJaJOJQJCJ5aJ\OJQJZ>О>†@ˆ@Д@м@ЎBАBШBіBLDюD№D8EZEЂFЮG>H@HŽHzJ|JІJаJєKXL€L‚LРLкNоOрO P0Q2QЖQЪRВS*TŒVVЄVЬVїюттюютююїююттгююютююЯтюЯЯююЯюЯтююЯтЪююЯтююЪЪтююЯтЯюЯЪЪюУУтУУУОтГCJ65aJ]\CJaJ CJOJQJOJQJ5\CJ65aJ]\OJQJCJ5aJ\OJQJCJaJOJQJmH sH OJQJFЬV,WTWVWjWјѓюmHsHCJaJCJ5aJ\"ќў( * Ь і  ’ ж l и NЌЎNїђтЦСЏЏЏ ЏЏЏЏЏ‘Џ1$ Ц p@  р1$ Ц p@  р & F 1$ Ц p@  р$a$1$ Ца p@  р$d%d&d'd1$ Ца p@  рО$a$ & F$a$N ІZ\rјLbd”–4ШV2эээээомзззззЯПППКЈК1$ Ца p@  р$ & F1$ Ца p@  р^„а]„`„˜ў & F 1$ Ц p@  р & F 1$ Ц p@  р24Ќ˜!š!"†%''И'Ў)N*Œ+Ž+Ъ+-T.V.њтаСПааЗЗаааЈЃаа”1$ Цаp@  р & F1$ Цаp@  р & F$a$С1$ Цаp@  р & F1$ Цаp@  р & F1$ Ца p@  рЄЄ$a$V.Д.\/^/Ќ/Ц0Ш01М1О102В4r6њшйЦЏ Ц›™њ„„ & F$a$1$ Цаp@  р & F 1$ Цаp@  р & F$a$1$ Ца p@  р$a$1$ Ца p@  р1$ Цаp@  р & F1$ Цаp@  р & F r6v6к6ј7D9F9’9L;N;’;Є<І<,=X>Z>О>†@чЯЪЪШРЛГ ›  –Ž –^„h]„`„ & F & F $a$1$ Ца p@  р^„а]„`„ & F^„]„`„ & F $a$1$ Цаp@  р^„]„`„˜ў$a$1$ Цаp@  р^„]„`„˜ў†@ˆ@м@ЎBАBіBLDюD№DZEЂFЮG>H@HŽHzJ|JаJXKђK§ѕ№юлжбллЬЬЧПлЬНЛВЉЏ & F ЦhЏ & F ЦhЎ^„h]„`„Ў & F & F & FЎ & F$a$1$ Ца p@  р & F ^„а]„`„˜ўђKєKXL€L‚LРLкNоOрO P0Q2QЖQЪRєсЬКИГГЋІ”…xsН & F 1$ Ц p@  р1$ Ц p@  р & F1$ Ц p@  р & F^„˜ў]„`„Ў & F$a$1$ Ц p@  р & F$a$1$ Ц p@  р$a$1$ Ца p@  р Џ Цh^„]„`„ ЪRВS*TŒVVЄV,WTWVWXWZW\W^W`WbWdWfWhWjWњњњѕйЩЖГБЏ­ЋЉЇЅЃЁŸЗ1$$a$1$ Ца p@  р1$ Ца p@  р1$ Ца p@  р$d%d&d'dН & FН & FjWlWы$a$1$ Ца p@  р8Аа/ Ар=!А "А А #аАа$2P1h0p3P(20ўџеЭеœ.“—+,љЎDеЭеœ.“—+,љЎ\щ§щ§Root Entryџџџџџџџџ РF€CompObjџџџџjOle џџџџџџџџ1TableџџџџџџџџџџџџW<SummaryInformation(џџџџWordDocumentџџџџџџџџџџџџ#:pDocumentSummaryInformation8џџџџџџџџџџџџtџџџџџџџџџџџџўџџџ