ChipWiki - User contributions [en]

File:Egg Nog Bourbon Pie Crust.jpg

2016-05-05T17:40:10Z

Admin: Admin uploaded a new version of File:Egg Nog Bourbon Pie Crust.jpg

A version of the Bourbon Pie Crust recipe made using Egg Nog.

Chip's Resume

2015-10-14T18:20:39Z

Admin: Fixed million/billion typo

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Farm Credit Mid America Louisville, KY
Data Warehouse Architect (Jan 2015 - Present)
*Led a very small team to build a new data warehouse from scratch, designing policy, procedures, and establishing a VP-Level governing steering committee
*Designed a star schema database with multidimensional cube support to house data from our $21 Billion Loan/Lease business
*Enabled initial end user capability in only a few months; continuing to improve and roll out BI capabilities and expand data warehouse footprint

Passport Health Plan Louisville, KY
Data Warehouse Architect (October 2012 - Aug 2014)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University, Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science
University of Louisville, Louisville, KY
* Currently pursuing PhD of Computer Science in Data Mining

Extensive Experience With
* Informatica PowerCenter
* Tableau, Cognos, and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* python (mostly around SciPy, NumPy, and SQL integration)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware
* MelissaData Geocoding and Fuzzy Matching SSIS Packages

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Medical Coding including ICD-9, ICD-10, CPT, DRG, BETOS, HCPCS, and others
* Department of Defense Architecture Framework (DoDAF)
* Top 1% ranking in Kaggle and top 5% finisher in their $3Million Heritage Health Prize Data Mining Competition
* Completed Coursera's May 2013 Data Mining class "with Distinction"
* Maintain websites for http://heartsforkenya.com/, and http://daytonartists.org/

Chip's Resume

2015-10-12T16:57:19Z

Admin: Added U of L and expanded Farm Credit information

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Farm Credit Mid America Louisville, KY
Data Warehouse Architect (Jan 2015 - Present)
*Led a very small team to build a new data warehouse from scratch, designing policy, procedures, and establishing a VP-Level governing steering committee
*Designed a star schema database with multidimensional cube support to house data from our $20Million+ Loan/Lease business
*Enabled initial end user capability in only a few months; continuing to improve and roll out BI capabilities and expand data warehouse footprint

Passport Health Plan Louisville, KY
Data Warehouse Architect (October 2012 - Aug 2014)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University, Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science
University of Louisville, Louisville, KY
* Currently pursuing PhD of Computer Science in Data Mining

Extensive Experience With
* Informatica PowerCenter
* Tableau, Cognos, and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* python (mostly around SciPy, NumPy, and SQL integration)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware
* MelissaData Geocoding and Fuzzy Matching SSIS Packages

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Medical Coding including ICD-9, ICD-10, CPT, DRG, BETOS, HCPCS, and others
* Department of Defense Architecture Framework (DoDAF)
* Top 1% ranking in Kaggle and top 5% finisher in their $3Million Heritage Health Prize Data Mining Competition
* Completed Coursera's May 2013 Data Mining class "with Distinction"
* Maintain websites for http://heartsforkenya.com/, and http://daytonartists.org/

Chicken Fried Bacon

2015-05-21T03:52:11Z

Admin: Initial Post

Alright, this isn't my recipe exactly, it's a very simple combination of a few recipes found online... but it's so freakin' tasty I just had to include it:

Basically, prepare a bowl of two raw mixed eggs, a bowl of 1-cup flower with a few teaspoons of spices that I had around -- paprika, oregano, ground mustard, nutmeg, pepper, and whatever else the cabinet had -- and a skillet with an inch of vegetable oil at about 375 degrees. Coat the bacon in egg (lightly, I kinda wiped them off so it wasn't drippy), cover it in flour, and fry for about 3-1/2 minutes (I did one for four, but it was a bit burnt). I ran them in batches of four slices each. Shake off the excess oil and let them cool and dry on a wire rack for a minute or two. Then eat. That will pretty much cover a 12-pack of bacon. Someone recommended baking them for a few minutes after that, but I didn't do that -- they were epic right out of the fryer.

Recipes

2015-05-21T03:50:37Z

Admin: /* List of Recipes on ChipWiki */

[[Category:Recipe]]

==List of Recipes on ChipWiki==
* [[Guinness Bread Recipe]]
* [[Bourbon Pie Crust]]
* [[Derbie Pie Recipe]]
* [[Joe's Thunder Over Louisville Salsa Recipe]]
* [[Joe's Breakfast Bars Recipe]]
* [[Vegetarian Burrito Goop]]
* [[Chicken Fried Bacon]]

Windows Desktop Software

2015-05-12T02:35:34Z

Admin:

== Que? ==

This is a page to list software I use that I often forget to install, or forget that I hated.

=== Software to Always Use ===
==== Productivity ====
* 7-Zip
* AVG
* Microsoft Office (if we have a license) or Libre Office
* GIMP
* Dropbox
* Google Chrome
* Malwarebytes
* Notepad++
* Rstudio / RProject / Revolution R
* VLC
==== Games ====
* Good Old Games installer
* Steam
* Origin

=== Software to Maybe Use ===
==== Multimedia ====
* Avidemux
* Blender
* Autodesk 123D Catch
* Fotosizer
* GitHub (The official software isn't that great but there's not much better for Windows)
* MuseScore (Sheet music editing?!)
* Shotcut (did I try this?)
* Sketchup

==== Coding ====
* Microsoft Code
* Eclipse
* Java SDK -- there should really be a better alternative
* Anaconda / Spyder (Python)

==== Other Stuff ====
* yWriter
* OpenVPN / PrivateTunnel
* Skype
* Tarrasch Chess GUI
* Tixati (or uTorrent)

=== Software that Sucked ===
* Geekbench
* FICO Xpress (data mining / simulation)

Windows Desktop Software

2015-05-12T01:38:10Z

Admin:

== Que? ==

This is a page to list software I use that I often forget to install, or forget that I hated.

=== Software to Always Use ===
==== Productivity ====
* 7-Zip
* AVG
* Microsoft Office (if we have a license) or Libre Office
* GIMP
* Dropbox
* Google Chrome
* Malwarebytes
* Notepad++
* Rstudio / RProject / Revolution R
==== Games ====
* Good Old Games installer
* Steam
* Origin

=== Software to Maybe Use ===
==== Multimedia ====
* Avidemux
* Blender
* Autodesk 123D Catch
* Fotosizer
* GitHub (The official software isn't that great but there's not much better for Windows)
* MuseScore (Sheet music editing?!)
* Shotcut (did I try this?)
* Sketchup

==== Coding ====
* Microsoft Code
* Eclipse
* Java SDK -- there should really be a better alternative
* Anaconda / Spyder (Python)

==== Other Stuff ====
* yWriter
* OpenVPN / PrivateTunnel
* Skype
* Tarrasch Chess GUI
* Tixati (or uTorrent)

=== Software that Sucked ===
* Geekbench
* FICO Xpress (data mining / simulation)

Windows Desktop Software

2015-05-12T01:33:32Z

Admin:

== Que? ==

This is a page to list software I use that I often forget to install, or forget that I hated.

=== Software to Always Use ===
==== Productivity ====
* 7-Zip
* AVG
* Microsoft Office (if we have a license) or Libre Office
* GIMP
* Dropbox
* Google Chrome
* Malwarebytes
* Notepad++
* Rstudio / RProject / Revolution R
==== Games ====
* Good Old Games installer
* Steam
* Origin

=== Software to Maybe Use ===
==== Multimedia ====
* Avidemux
* Blender
* Autodesk 123D Catch
* Fotosizer
* GitHub (The official software isn't that great but there's not much better for Windows)
* MuseScore (Sheet music editing?!)
* Shotcut (did I try this?)

==== Coding ====
* Microsoft Code
* Eclipse
* Java SDK -- there should really be a better alternative
* Anaconda / Spyder (Python)

==== Other Stuff ====
* yWriter
* OpenVPN / PrivateTunnel

=== Software that Sucked ===
* Geekbench

Windows Desktop Software

2015-05-12T01:28:04Z

Admin: Adding to the lists...

Windows Desktop Software

2015-05-12T01:24:18Z

Admin: Created page with "== Que? == This is a page to list software I use that I often forget to install, or forget that I hated. === Software to Always Use === * 7-Zip * AVG * Microsoft Office (if ..."

== Que? ==

This is a page to list software I use that I often forget to install, or forget that I hated.

=== Software to Always Use ===
* 7-Zip
* AVG
* Microsoft Office (if we have a license) or Libre Office

=== Software to Maybe Use ===
==== Multimedia ====
* Avidemux
* Blender
* Autodesk 123D Catch
==== Coding ====
* Microsoft Code
* Eclipse

=== Software that Sucked ===

Main Page

2015-05-12T01:05:39Z

Admin: /* Technical Tidbits */

<big>'''ChipWiki is fully operational!'''</big>

Or at least I hope so. Not sure what I'm going to do about it, of course. Here's some useful stuff that shipped with the front page... when I figure out how to change the navigation and toolbox sidebars, I'll probably move this stuff there. Of course, then I'll have to come up with some real content for the main page. Sheesh.

== Links about Chip ==

[[Chip's Resume]] (Not that I need a job, but you know, just in case)

[[ChipLynch.com|About ChipLynch.com]]

[[Good Ideas|Some ideas running around in my head]]

[[To Do List|Chip's To Do List]]

[[Video Games|A Place for Chip to talk about Video Games]]

[[Wood Projects|Things Chip has Made in his budding Wood Shop]]

[[Recipes|Chip's Recipes]]

[http://www.facebook.com/chip.lynch Chip's Facebook Page]

[http://www.linkedin.com/pub/chip-lynch/2/9a/b45 Chip's LinkedIn Page]

== Technical Tidbits ==

[[Oracle Tidbits]]

[[Teradata Tidbits]]

[[Informatica Standards]]

[[Microsoft Tidbits]]

[[Linux Tidbits]]

[[Windows Desktop Software]]

== MediaWiki Links ==

Consult the [http://meta.wikipedia.org/wiki/MediaWiki_User%27s_Guide User's Guide] for information on using the wiki software.

== Getting started ==

* [http://www.mediawiki.org/wiki/Help:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Help:FAQ MediaWiki FAQ]
* [http://mail.wikipedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Chip's Resume

2015-01-23T14:34:28Z

Admin: Added FCMA

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Farm Credit Mid America Louisville, KY
Data Warehouse Architect (Jan 2015 - Present)

Passport Health Plan Louisville, KY
Data Warehouse Architect (October 2012 - Aug 2014)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University
Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science

Extensive Experience With
* Informatica PowerCenter
* Tableau, Cognos, and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* python (mostly around SciPy, NumPy, and SQL integration)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware
* MelissaData Geocoding and Fuzzy Matching SSIS Packages

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Medical Coding including ICD-9, ICD-10, CPT, DRG, BETOS, HCPCS, and others
* Department of Defense Architecture Framework (DoDAF)
* Top 1% ranking in Kaggle and top 5% finisher in their $3Million Heritage Health Prize Data Mining Competition
* Completed Coursera's May 2013 Data Mining class "with Distinction"
* Maintain websites for http://heartsforkenya.com/, and http://daytonartists.org/

To Do List

2015-01-19T21:31:50Z

Admin: /* Things to Do */

=Chip's Official To-Do List=
==Things to Do==

Retire

Get in shape

Run the Kentucky Derby Mini Marathon! [Complete! April 2009, 3 hours, 35 minutes!] (and 2010, 2011, 2012... 2013?)

Be a Space Tourist (orbital flight, or the stretch goal: Moon Landing) [Mars?]

Buy a Fixer-Upper house (and fixer-it-up) (then sell it or torch it or rent it)

Eventually successfully complete a NanoWrimo or, better, just write a book (e-books?) Complete 2014 NanoWrimo

Watch a shuttle launch [Fail!]

Buy someone a car [Complete! Ask [[Ang]]!]

Buy Ferf a yacht [Complete! Ask [[Ferf]].]

Recruit butter minions (ummm... Ang, why is this here?)

Swim in a pool filled with macaroni and Cheese (We're counting jello wrestling as a success here... 2010)

==Things to Learn==

Learn some more instruments

Learn to Ride the Unicycle

Learn to Juggle 5 balls

==Songs to Learn to Play==

Home Sweet Home (Motley Crue)

They Can't Take That Away from Me (Frank Sinatra)

Joy to the World (Three Dog Night)

Something to Believe In (Poison)

==Things to Make, Buy, Borrow, or Steal==

Grand Piano (Complete! And it's PURTY)

Dishes (Complete! Finally!)

Murhpy Bed (Complete -- YAY! Now I have to get rid of it.)

A House (as in, pay-it-off) UPDATE: I'm paying for THREE houses now!!! Trying to sell one, living in one, one rented, none paid off.

MAME Cabinet

Sailboat

A Fishtank

A comprehensive wood shop, so's I can make lots of other stuffs:

*A Canoe or Kayak (or both!)

*A decent telescope

*Wooden replacement covers for the 4-color pens

*Wooden bicycle

*Flexible/bendable/softish wood furniture

*Chess boards and pieces (make this)

*Boxes and drawers and built-in cabinets

*Bows (as in archery)

*Musical instruments (violin, guitar, ...)

==Software to Write==

Photomosaic Software so [[Ferf]] can use it!

Some video game (at least one of the little addictive ones)

Data Visualization Software (see [http://chipmonkeyscorner.blogspot.com/ ChipMonkey's Coding Corner])

Android Retirement Calculator

Android Fuel Mileage and Car Maintenance Tracker

Bourbon Pie Crust

2014-11-29T20:21:26Z

Admin: Added Image

[[Category:Recipe]]
[[File:Egg Nog Bourbon Pie Crust.jpg|thumbnail]]
Everyone always talks about a good pie crust... there are a million recipes out there, so here's one more! What makes this one special is that we use some good old fashioned Kentucky Bourbon to make it, because what could be better?

I don't really bake much, so I had to scour the internet like anyone else to find a few good recipes and hints and I put them together. For the most part, though, there were some tips that I've put into this recipe that are, IMHO, the most important:
* Use real butter, not shortening or other substitutes (I haven't tried real lard or animal fat, so I can't speak to that -- yet)
* Cut the butter up into "pea" size blocks before first mixing them in
* Keep ingredients cold -- as cold as possible while still being pliable enough to cut up using a dough blender
* Use a liquor (I prefer bourbon, natch) instead of water when mixing the dough

The first one about using real butter is the most often decried, I'd say -- many people like shortening or lard, they say it makes things flakier, but I find that the amount you squish the butter up and the temperature you use while mixing are more important, and I just never liked the taste of the shortening recipes. Using a liquor seems like a good, albeit more rare, recommendation. Many people like vodka because of the lack of flavor, but I prefer bourbon for precisely the opposite reason.

While I've pulled from a lot of conversations and sites for information, these two articles are the ones I think explain things the best:
* [http://query.nytimes.com/gst/fullpage.html?res=9B01E6DC173EF936A25752C1A9609C8B63&sec=&spon=&pagewanted=1 Heaven in a Pie Pan (New York Times)]
* [http://smittenkitchen.com/2007/11/pie-crust-101/ Pie Crust 101 (Smitten Kitchen)]

They're going to have prettier pictures than I will here, if nothing else, so that's nice.

In any case, here we go... ingredients to make a "full" (top and bottom) 9-inch pie crust:

2-1/2 cups flour (all-purpose flour is fine)
2 tablespoons sugar
2 sticks of salted butter OR 2 sticks of unsalted butter and a teaspoon or so of salt
1/2 cup of bourbon

On butter: Most recipes call for a teaspoon or two of salt and unsalted butter. That's fine... I mistakenly used salted butter once and actually liked the results. The result seemed saltier than if just adding salt separately (although I may have done both), but in the very sweet rhubarb pie I used it in the mixture seemed tastier.

Bourbon should be kept in the freezer prior to using. If the flavor is too powerful, a half-bourbon/half-water mixture is probably OK, but I will call you girlie names.

Ok:

Taste the bourbon, and if you need to add some water to it and throw it back in the freezer.

Mix the flour, sugar, and (if you used it) salt into a bowl and stuff it in the freezer to keep the bourbon company. I actually use the lining of a crock pot, which holds the cold better and keeps things cold longer so you don't have to keep stuffing the whole concoction back into the freezer while you work. Taste the bourbon to make sure it's getting cold.

Cut the butter up into little cubes. Everyone always says "pea-sized," it seems, but peas are round and it's not worth the effort to shave down the corners. If you're using a normal stick of butter, cutting it in half lengthwise, then half again will give you four long thin strips of butter. These are about the right width, just cut the length down so you have a lot of little cubes and that should be about the right size. Toss these into the freezer for a few minutes too. Have a bourbon while you wait.

Yank everything out. Slowly mix the very solid butter cubes into the flour mixture while mashing at it with a dough blender. A handheld one, of course, I probably should have mentioned that I don't have a KitchenAid or anything so I do this by hand, but it's really not that bad. You want to avoid over blending anyway. Keep this up until the butter starts to melt, just the teensiest little bit, then shove it back in the freezer for about 2 minutes to teach it a lesson.

Have some bourbon, but not the bourbon that's in the freezer for the recipe, we still need that cold.

Yank the mess back out and start kneading it with one hand while slowly pouring the still very cold bourbon in the concoction with the other hand. This should only take a minute or two, and very likely not all of your bourbon... the butter should have already done some work holding the flour together, but it needs help. Moreover, you don't want to squish the butter too small which will happen if you work it too long... there should still be obvious chunks of it in there, well coated in flour. The key, here, is to get the whole mess to stick together when it's rolled out, but not the slightest bit more damp than that. While in the bowl, your hand shouldn't be sticky at all; the moment it is you've gone to far. Still, you don't want things too dry. Mostly this just takes practice. Pictures aren't as helpful as you'd like, plus I don't have any to show you anyway (although there are a lot on the links I pushed out above). Dry and lumpy but holding its shape is the goal.

Split the dough into two pieces, one slightly larger than the other (the bottom of the pie has to ride up the sides of the pan; the top is flatter and smaller). They don't need to be rolled out, just separate and maybe pressed into patties to ensure they're holding up properly. The edges should crack noticeably, but the center should be nice and squishied together.

Throw this in the freezer for a half hour or so... most people recommend longer, but I have no idea why. Drink what's left of the bourbon.

Once you pull it out, all you have to do is roll the dough into the requisite circles. I try to avoid rolling on a floured surface because it seems to mess with the outside texture of the crust. Rolling between two plastic wrap or freezer wrap sheets is a good compromise. Roll the larger portion out until it will fill the pie pan. Feel free to rip off parts from one side and squish them in place on another side if you're lopsided, it will all bake out in the end, just try to keep the thickness consistent.

Stuff with your favorite pie filling (homemade, of course).

Roll the top part out the same way and lay it on top and cut pretty patterns in it if you like.

If you want to do a checkerboard layout, still roll the lump out into a circle, when you cut it into pieces you'll find they fit nicely together. Someone somewhere had a hint about checkerboards but I can't find the link so I'll just explain it: lay down all the vertical strips where you want them (about 1" in width and 1" apart is a good look). If you cut them out of a circle like a good instruction-follower, select one strip for the middle (the longest) and every-other strip towards the smaller ones. Pinch down one end of all the vertical strips.
The remaining strips are the horizontals... pull back every-other vertical strip off of the pie (attached only where you pinched) and lay down the smallest horizontal over the remaining vertical strips. Then switch the vertical strips and lay down the next horizontal one, and repeat until everything is down. There should be a youtube video of this somewhere... basically you create the checkerboard weave by alternating which verticals are on top and on bottom and just laying down the horizontal strips.

Anyway.

Cooking times may vary more for the filling than for the crust, but I tend to prefer a short (15 minute) period of 450 degree heat followed by 45 minutes of 350 degrees. Sometimes that works better reversed, actually, but I have no idea why. Some people recommend brushing butter on top of the pie at some point to add to the golden color, but I tend not to bother. If you're watching the pie to see if it's done, the crust should pretty much come out of the oven crispy the way you want it on top. Some touches of darkening are nice, but too many will taste burnt and will get overly crunchy. It's touchy -- make lots of pies to get it right.

Take the pie out, let it cool. Eat, with bourbon.

File:Egg Nog Bourbon Pie Crust.jpg

2014-11-29T19:28:29Z

Admin: A version of the Bourbon Pie Crust recipe made using Egg Nog.

A version of the Bourbon Pie Crust recipe made using Egg Nog.

Recipes

2014-11-26T17:38:39Z

Admin:

Recipes

2014-11-26T17:38:19Z

Admin:

[[Category:Recipe]]

==List of Recipes on ChipWiki==
* [[Guinness Bread Recipe]]
* [[Derbie Pie Recipe]]
* [[Joe's Thunder Over Louisville Salsa Recipe]]
* [[Joe's Breakfast Bars Recipe]]
* [[Bourbon Pie Crust]]
* [[Vegetarian Burrito Goop]]

Bourbon Pie Crust

2014-11-26T17:35:49Z

Admin:

[[Category:Recipe]]
Everyone always talks about a good pie crust... there are a million recipes out there, so here's one more! What makes this one special is that we use some good old fashioned Kentucky Bourbon to make it, because what could be better?

I don't really bake much, so I had to scour the internet like anyone else to find a few good recipes and hints and I put them together. For the most part, though, there were some tips that I've put into this recipe that are, IMHO, the most important:
* Use real butter, not shortening or other substitutes (I haven't tried real lard or animal fat, so I can't speak to that -- yet)
* Cut the butter up into "pea" size blocks before first mixing them in
* Keep ingredients cold -- as cold as possible while still being pliable enough to cut up using a dough blender
* Use a liquor (I prefer bourbon, natch) instead of water when mixing the dough

The first one about using real butter is the most often decried, I'd say -- many people like shortening or lard, they say it makes things flakier, but I find that the amount you squish the butter up and the temperature you use while mixing are more important, and I just never liked the taste of the shortening recipes. Using a liquor seems like a good, albeit more rare, recommendation. Many people like vodka because of the lack of flavor, but I prefer bourbon for precisely the opposite reason.

While I've pulled from a lot of conversations and sites for information, these two articles are the ones I think explain things the best:
* [http://query.nytimes.com/gst/fullpage.html?res=9B01E6DC173EF936A25752C1A9609C8B63&sec=&spon=&pagewanted=1 Heaven in a Pie Pan (New York Times)]
* [http://smittenkitchen.com/2007/11/pie-crust-101/ Pie Crust 101 (Smitten Kitchen)]

They're going to have prettier pictures than I will here, if nothing else, so that's nice.

In any case, here we go... ingredients to make a "full" (top and bottom) 9-inch pie crust:

2-1/2 cups flour (all-purpose flour is fine)
2 tablespoons sugar
2 sticks of salted butter OR 2 sticks of unsalted butter and a teaspoon or so of salt
1/2 cup of bourbon

On butter: Most recipes call for a teaspoon or two of salt and unsalted butter. That's fine... I mistakenly used salted butter once and actually liked the results. The result seemed saltier than if just adding salt separately (although I may have done both), but in the very sweet rhubarb pie I used it in the mixture seemed tastier.

Bourbon should be kept in the freezer prior to using. If the flavor is too powerful, a half-bourbon/half-water mixture is probably OK, but I will call you girlie names.

Ok:

Taste the bourbon, and if you need to add some water to it and throw it back in the freezer.

Mix the flour, sugar, and (if you used it) salt into a bowl and stuff it in the freezer to keep the bourbon company. I actually use the lining of a crock pot, which holds the cold better and keeps things cold longer so you don't have to keep stuffing the whole concoction back into the freezer while you work. Taste the bourbon to make sure it's getting cold.

Cut the butter up into little cubes. Everyone always says "pea-sized," it seems, but peas are round and it's not worth the effort to shave down the corners. If you're using a normal stick of butter, cutting it in half lengthwise, then half again will give you four long thin strips of butter. These are about the right width, just cut the length down so you have a lot of little cubes and that should be about the right size. Toss these into the freezer for a few minutes too. Have a bourbon while you wait.

Yank everything out. Slowly mix the very solid butter cubes into the flour mixture while mashing at it with a dough blender. A handheld one, of course, I probably should have mentioned that I don't have a KitchenAid or anything so I do this by hand, but it's really not that bad. You want to avoid over blending anyway. Keep this up until the butter starts to melt, just the teensiest little bit, then shove it back in the freezer for about 2 minutes to teach it a lesson.

Have some bourbon, but not the bourbon that's in the freezer for the recipe, we still need that cold.

Yank the mess back out and start kneading it with one hand while slowly pouring the still very cold bourbon in the concoction with the other hand. This should only take a minute or two, and very likely not all of your bourbon... the butter should have already done some work holding the flour together, but it needs help. Moreover, you don't want to squish the butter too small which will happen if you work it too long... there should still be obvious chunks of it in there, well coated in flour. The key, here, is to get the whole mess to stick together when it's rolled out, but not the slightest bit more damp than that. While in the bowl, your hand shouldn't be sticky at all; the moment it is you've gone to far. Still, you don't want things too dry. Mostly this just takes practice. Pictures aren't as helpful as you'd like, plus I don't have any to show you anyway (although there are a lot on the links I pushed out above). Dry and lumpy but holding its shape is the goal.

Split the dough into two pieces, one slightly larger than the other (the bottom of the pie has to ride up the sides of the pan; the top is flatter and smaller). They don't need to be rolled out, just separate and maybe pressed into patties to ensure they're holding up properly. The edges should crack noticeably, but the center should be nice and squishied together.

Throw this in the freezer for a half hour or so... most people recommend longer, but I have no idea why. Drink what's left of the bourbon.

Once you pull it out, all you have to do is roll the dough into the requisite circles. I try to avoid rolling on a floured surface because it seems to mess with the outside texture of the crust. Rolling between two plastic wrap or freezer wrap sheets is a good compromise. Roll the larger portion out until it will fill the pie pan. Feel free to rip off parts from one side and squish them in place on another side if you're lopsided, it will all bake out in the end, just try to keep the thickness consistent.

Stuff with your favorite pie filling (homemade, of course).

Roll the top part out the same way and lay it on top and cut pretty patterns in it if you like.

If you want to do a checkerboard layout, still roll the lump out into a circle, when you cut it into pieces you'll find they fit nicely together. Someone somewhere had a hint about checkerboards but I can't find the link so I'll just explain it: lay down all the vertical strips where you want them (about 1" in width and 1" apart is a good look). If you cut them out of a circle like a good instruction-follower, select one strip for the middle (the longest) and every-other strip towards the smaller ones. Pinch down one end of all the vertical strips.
The remaining strips are the horizontals... pull back every-other vertical strip off of the pie (attached only where you pinched) and lay down the smallest horizontal over the remaining vertical strips. Then switch the vertical strips and lay down the next horizontal one, and repeat until everything is down. There should be a youtube video of this somewhere... basically you create the checkerboard weave by alternating which verticals are on top and on bottom and just laying down the horizontal strips.

Anyway.

Cooking times may vary more for the filling than for the crust, but I tend to prefer a short (15 minute) period of 450 degree heat followed by 45 minutes of 350 degrees. Sometimes that works better reversed, actually, but I have no idea why. Some people recommend brushing butter on top of the pie at some point to add to the golden color, but I tend not to bother. If you're watching the pie to see if it's done, the crust should pretty much come out of the oven crispy the way you want it on top. Some touches of darkening are nice, but too many will taste burnt and will get overly crunchy. It's touchy -- make lots of pies to get it right.

Take the pie out, let it cool. Eat, with bourbon.

Pie Crust

2014-11-26T17:34:46Z

Admin: moved Pie Crust to Bourbon Pie Crust

#REDIRECT [[Bourbon Pie Crust]]

Bourbon Pie Crust

2014-11-26T17:34:46Z

Admin: moved Pie Crust to Bourbon Pie Crust

[[Category:Recipe]]
Everyone always talks about a good pie crust... there are a million recipes out there, so here's one more!

I don't really bake much, so I had to scour the internet like anyone else to find a few good recipes and hints and I put them together. For the most part, though, there were some tips that I've put into this recipe that are, IMHO, the most important:
* Use real butter, not shortening or other substitutes (I haven't tried real lard or animal fat, so I can't speak to that -- yet)
* Cut the butter up into "pea" size blocks before first mixing them in
* Keep ingredients cold -- as cold as possible while still being pliable enough to cut up using a dough blender
* Use a liquor (I prefer bourbon, natch) instead of water when mixing the dough

The first one about using real butter is the most often decried, I'd say -- many people like shortening or lard, they say it makes things flakier, but I find that the amount you squish the butter up and the temperature you use while mixing are more important, and I just never liked the taste of the shortening recipes. Using a liquor seems like a good, albeit more rare, recommendation. Many people like vodka because of the lack of flavor, but I prefer bourbon for precisely the opposite reason.

While I've pulled from a lot of conversations and sites for information, these two articles are the ones I think explain things the best:
* [http://query.nytimes.com/gst/fullpage.html?res=9B01E6DC173EF936A25752C1A9609C8B63&sec=&spon=&pagewanted=1 Heaven in a Pie Pan (New York Times)]
* [http://smittenkitchen.com/2007/11/pie-crust-101/ Pie Crust 101 (Smitten Kitchen)]

They're going to have prettier pictures than I will here, if nothing else, so that's nice.

In any case, here we go... ingredients to make a "full" (top and bottom) 9-inch pie crust:

2-1/2 cups flour (all-purpose flour is fine)
2 tablespoons sugar
2 sticks of salted butter OR 2 sticks of unsalted butter and a teaspoon or so of salt
1/2 cup of bourbon

On butter: Most recipes call for a teaspoon or two of salt and unsalted butter. That's fine... I mistakenly used salted butter once and actually liked the results. The result seemed saltier than if just adding salt separately (although I may have done both), but in the very sweet rhubarb pie I used it in the mixture seemed tastier.

Bourbon should be kept in the freezer prior to using. If the flavor is too powerful, a half-bourbon/half-water mixture is probably OK, but I will call you girlie names.

Ok:

Taste the bourbon, and if you need to add some water to it and throw it back in the freezer.

Mix the flour, sugar, and (if you used it) salt into a bowl and stuff it in the freezer to keep the bourbon company. I actually use the lining of a crock pot, which holds the cold better and keeps things cold longer so you don't have to keep stuffing the whole concoction back into the freezer while you work. Taste the bourbon to make sure it's getting cold.

Cut the butter up into little cubes. Everyone always says "pea-sized," it seems, but peas are round and it's not worth the effort to shave down the corners. If you're using a normal stick of butter, cutting it in half lengthwise, then half again will give you four long thin strips of butter. These are about the right width, just cut the length down so you have a lot of little cubes and that should be about the right size. Toss these into the freezer for a few minutes too. Have a bourbon while you wait.

Yank everything out. Slowly mix the very solid butter cubes into the flour mixture while mashing at it with a dough blender. A handheld one, of course, I probably should have mentioned that I don't have a KitchenAid or anything so I do this by hand, but it's really not that bad. You want to avoid over blending anyway. Keep this up until the butter starts to melt, just the teensiest little bit, then shove it back in the freezer for about 2 minutes to teach it a lesson.

Have some bourbon, but not the bourbon that's in the freezer for the recipe, we still need that cold.

Yank the mess back out and start kneading it with one hand while slowly pouring the still very cold bourbon in the concoction with the other hand. This should only take a minute or two, and very likely not all of your bourbon... the butter should have already done some work holding the flour together, but it needs help. Moreover, you don't want to squish the butter too small which will happen if you work it too long... there should still be obvious chunks of it in there, well coated in flour. The key, here, is to get the whole mess to stick together when it's rolled out, but not the slightest bit more damp than that. While in the bowl, your hand shouldn't be sticky at all; the moment it is you've gone to far. Still, you don't want things too dry. Mostly this just takes practice. Pictures aren't as helpful as you'd like, plus I don't have any to show you anyway (although there are a lot on the links I pushed out above). Dry and lumpy but holding its shape is the goal.

Split the dough into two pieces, one slightly larger than the other (the bottom of the pie has to ride up the sides of the pan; the top is flatter and smaller). They don't need to be rolled out, just separate and maybe pressed into patties to ensure they're holding up properly. The edges should crack noticeably, but the center should be nice and squishied together.

Throw this in the freezer for a half hour or so... most people recommend longer, but I have no idea why. Drink what's left of the bourbon.

Once you pull it out, all you have to do is roll the dough into the requisite circles. I try to avoid rolling on a floured surface because it seems to mess with the outside texture of the crust. Rolling between two plastic wrap or freezer wrap sheets is a good compromise. Roll the larger portion out until it will fill the pie pan. Feel free to rip off parts from one side and squish them in place on another side if you're lopsided, it will all bake out in the end, just try to keep the thickness consistent.

Stuff with your favorite pie filling (homemade, of course).

Roll the top part out the same way and lay it on top and cut pretty patterns in it if you like.

If you want to do a checkerboard layout, still roll the lump out into a circle, when you cut it into pieces you'll find they fit nicely together. Someone somewhere had a hint about checkerboards but I can't find the link so I'll just explain it: lay down all the vertical strips where you want them (about 1" in width and 1" apart is a good look). If you cut them out of a circle like a good instruction-follower, select one strip for the middle (the longest) and every-other strip towards the smaller ones. Pinch down one end of all the vertical strips.
The remaining strips are the horizontals... pull back every-other vertical strip off of the pie (attached only where you pinched) and lay down the smallest horizontal over the remaining vertical strips. Then switch the vertical strips and lay down the next horizontal one, and repeat until everything is down. There should be a youtube video of this somewhere... basically you create the checkerboard weave by alternating which verticals are on top and on bottom and just laying down the horizontal strips.

Anyway.

Cooking times may vary more for the filling than for the crust, but I tend to prefer a short (15 minute) period of 450 degree heat followed by 45 minutes of 350 degrees. Sometimes that works better reversed, actually, but I have no idea why. Some people recommend brushing butter on top of the pie at some point to add to the golden color, but I tend not to bother. If you're watching the pie to see if it's done, the crust should pretty much come out of the oven crispy the way you want it on top. Some touches of darkening are nice, but too many will taste burnt and will get overly crunchy. It's touchy -- make lots of pies to get it right.

Take the pie out, let it cool. Eat, with bourbon.

Wood Projects

2014-11-22T00:07:16Z

Admin: /* Things Chip has made in his little workshop: */

=Things Chip has made in his little workshop:=
(possibly chronologically ordered)

*Heart Inlaid Box -- 2007, Pine, RedHeart - Gift for Angela

*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Michael Koch
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Brian Helfrich
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Joe

*Chess Board 2008, Spalted Maple and RedHeart, PolyCrylic finish

*Bowl -- 2008, 6" diameter, PurpleHeart, Flaxseed Oil Finish with much help from Ang - Birthday Present for Karen Koch

*Rolling Pin 2008, Birch, Turned Green, Pentacryl dried, for Angela

*Pen -- August, 2008, Red Palm [nb: This wood is awesome!], Renaissance Wax Finish, Birthday Present for Joe
*Pen -- August, 2008, ZebraWood, Renaissance Wax Finish, Present for Pete Bell upon having his first kiddo
*Pen -- August, 2008, Acrylic, didn't really go that well
*Pen -- August, 2008, Laminated RedHeart and Spalted Maple, Renaissance Wax finish, Gift for Jen at BeaverVu Bowling since hers didn't work
*Pen -- September, 2008, Coconut Red Palm, Hut Wax finish, Gift for Stephanie Tubbs' Birthday

*Bowl -- October, 2008, 6" diameter, Yellow Heart, unfinished, with help from Ang
*Bowl -- October, 2008, 6" diameter, Black and White Synthetic wood, Spray Lacquer finish

*Trinket -- Tiny captured ring chalice shape

*Pen -- July, 2009, Patterned laminate wood, Cloth Applied Lacquer Finish
*Candle Holder -- July, 2009, Brazilian Rosewood, holds 4" and 3" candles, Gift for Cathy Thompson
*Pen -- July, 2009, Cocobolo, hard Two Part Wax Finish, Birthday Present for Jack Koch

*Rolling Pin -- May, 2011, Ash (from back yard), Pentacryl, for Me
*Bowl -- May, 2011, Osage Orange, Two Part Wax Finish

*Bench for Angela -- July 2013, Pine 2x4s cut and screwed all purty like
*Eric's Media Center Stand (made with Eric) -- June 2013, Birch plywood with steel threaded rods for legs and nice nuts, washers, and bolts
*Finished (previous) Chess Board -- July 2013, with cedar edges and maple curved feet - Christmas 2013 Gift for Dad

*Trash Can Holder for Ang, Cedar and Pine -- September 2014
*Box for [http://jchutchins.net/ Chris Hutchins] for his Golem Arcana collection -- Cedar from CedarUSA, October 2014
*Mustache trinket costume props for Halloween 2014
*Hedgehog Gift Card Holders for Diane, Karen, Dawn, and Danette (Angela's Family's November Birthdays) -- Cedar November 2014
*Bowl for Danielle -- Cedar, Mesquite, and Maple; my first glued up bowl -- November 2014
*Cocktail Muddler -- November 2014, 6" long of coconut palm, gift for Angela because she asked for it.
*Several snowmen with hats -- Late 2014, various sizes and shapes mostly maple as Christmas gifts
*Thomas the Train bed -- November 2014 for Ferf's son Isaac (commissioned) Plywood and pine mostly

=Things Other People have made:=

*Angela: Wooden Bowl (2008, Cherry, Woodcraft Class) -- Birthday present for her mom
*Angela: Wooden Bowl (2008, Paduak, Flaxseed Oil finish)
*Angela: Pen (2008, Cedar, Wax Finish)
*Angela: Pen (2008, PurpleHeart)
*Kory: Pen (2008, Cocobolo, Wax Finish)
*Eric: Chess Set, 2008-2009, Basswood Scroll Sawed

*Joe has made lots of stuff, but I can't really enumerate them, and he makes a lot of cool wood stuff outside the shop. Joe can add stuff here if he wants though!

=Things Chip should make but hasn't yet:=

*Spinning Tops
*Kendama
*Spheres
*Kayaks and Canoes
*Wooden Bicycles
*Ring Holders
*Baby Rattles
*Juggling Clubs or Torches
*Rolling Pins
*Wine Bottle Toppers
*Christmas Ornaments (see http://www.nancy-arn.com/wood_turning_projects.htm)
*Gavel
*Coasters

Wood Projects

2014-11-22T00:06:58Z

Admin: /* Things Chip has made in his little workshop: */

=Things Chip has made in his little workshop:=
(possibly chronologically ordered)

*Heart Inlaid Box -- 2007, Pine, RedHeart - Gift for Angela

*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Michael Koch
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Brian Helfrich
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Joe

*Chess Board 2008, Spalted Maple and RedHeart, PolyCrylic finish

*Bowl -- 2008, 6" diameter, PurpleHeart, Flaxseed Oil Finish with much help from Ang - Birthday Present for Karen Koch

*Rolling Pin 2008, Birch, Turned Green, Pentacryl dried, for Angela

*Pen -- August, 2008, Red Palm [nb: This wood is awesome!], Renaissance Wax Finish, Birthday Present for Joe
*Pen -- August, 2008, ZebraWood, Renaissance Wax Finish, Present for Pete Bell upon having his first kiddo
*Pen -- August, 2008, Acrylic, didn't really go that well
*Pen -- August, 2008, Laminated RedHeart and Spalted Maple, Renaissance Wax finish, Gift for Jen at BeaverVu Bowling since hers didn't work
*Pen -- September, 2008, Coconut Red Palm, Hut Wax finish, Gift for Stephanie Tubbs' Birthday

*Bowl -- October, 2008, 6" diameter, Yellow Heart, unfinished, with help from Ang
*Bowl -- October, 2008, 6" diameter, Black and White Synthetic wood, Spray Lacquer finish

*Trinket -- Tiny captured ring chalice shape

*Pen -- July, 2009, Patterned laminate wood, Cloth Applied Lacquer Finish
*Candle Holder -- July, 2009, Brazilian Rosewood, holds 4" and 3" candles, Gift for Cathy Thompson
*Pen -- July, 2009, Cocobolo, hard Two Part Wax Finish, Birthday Present for Jack Koch

*Rolling Pin -- May, 2011, Ash (from back yard), Pentacryl, for Me
*Bowl -- May, 2011, Osage Orange, Two Part Wax Finish

*Bench for Angela -- July 2013, Pine 2x4s cut and screwed all purty like
*Eric's Media Center Stand (made with Eric) -- June 2013, Birch plywood with steel threaded rods for legs and nice nuts, washers, and bolts
*Finished (previous) Chess Board -- July 2013, with cedar edges and maple curved feet - Christmas 2013 Gift for Dad

*Trash Can Holder for Ang, Cedar and Pine -- September 2014

*Box for [http://jchutchins.net/ Chris Hutchins] for his Golem Arcana collection -- Cedar from CedarUSA, October 2014

*Mustache trinket costume props for Halloween 2014

*Hedgehog Gift Card Holders for Diane, Karen, Dawn, and Danette (Angela's Family's November Birthdays) -- Cedar November 2014
*Bowl for Danielle -- Cedar, Mesquite, and Maple; my first glued up bowl -- November 2014
*Cocktail Muddler -- November 2014, 6" long of coconut palm, gift for Angela because she asked for it.
*Several snowmen with hats -- Late 2014, various sizes and shapes mostly maple as Christmas gifts
*Cedar Golem Arcana Box for Chris Hutchins (commissioned) Cedar, 2x1x1 feet with lid and removable shelf
*Thomas the Train bed -- November 2014 for Ferf's son Isaac (commissioned) Plywood and pine mostly

=Things Other People have made:=

*Angela: Wooden Bowl (2008, Cherry, Woodcraft Class) -- Birthday present for her mom
*Angela: Wooden Bowl (2008, Paduak, Flaxseed Oil finish)
*Angela: Pen (2008, Cedar, Wax Finish)
*Angela: Pen (2008, PurpleHeart)
*Kory: Pen (2008, Cocobolo, Wax Finish)
*Eric: Chess Set, 2008-2009, Basswood Scroll Sawed

*Joe has made lots of stuff, but I can't really enumerate them, and he makes a lot of cool wood stuff outside the shop. Joe can add stuff here if he wants though!

=Things Chip should make but hasn't yet:=

*Spinning Tops
*Kendama
*Spheres
*Kayaks and Canoes
*Wooden Bicycles
*Ring Holders
*Baby Rattles
*Juggling Clubs or Torches
*Rolling Pins
*Wine Bottle Toppers
*Christmas Ornaments (see http://www.nancy-arn.com/wood_turning_projects.htm)
*Gavel
*Coasters

Wood Projects

2014-11-08T17:55:10Z

Admin: /* Things Chip has made in his little workshop: */

=Things Chip has made in his little workshop:=
(possibly chronologically ordered)

*Heart Inlaid Box -- 2007, Pine, RedHeart - Gift for Angela

*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Michael Koch
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Brian Helfrich
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Joe

*Chess Board 2008, Spalted Maple and RedHeart, PolyCrylic finish

*Bowl -- 2008, 6" diameter, PurpleHeart, Flaxseed Oil Finish with much help from Ang - Birthday Present for Karen Koch

*Rolling Pin 2008, Birch, Turned Green, Pentacryl dried, for Angela

*Pen -- August, 2008, Red Palm [nb: This wood is awesome!], Renaissance Wax Finish, Birthday Present for Joe
*Pen -- August, 2008, ZebraWood, Renaissance Wax Finish, Present for Pete Bell upon having his first kiddo
*Pen -- August, 2008, Acrylic, didn't really go that well
*Pen -- August, 2008, Laminated RedHeart and Spalted Maple, Renaissance Wax finish, Gift for Jen at BeaverVu Bowling since hers didn't work
*Pen -- September, 2008, Coconut Red Palm, Hut Wax finish, Gift for Stephanie Tubbs' Birthday

*Bowl -- October, 2008, 6" diameter, Yellow Heart, unfinished, with help from Ang
*Bowl -- October, 2008, 6" diameter, Black and White Synthetic wood, Spray Lacquer finish

*Trinket -- Tiny captured ring chalice shape

*Pen -- July, 2009, Patterned laminate wood, Cloth Applied Lacquer Finish
*Candle Holder -- July, 2009, Brazilian Rosewood, holds 4" and 3" candles, Gift for Cathy Thompson
*Pen -- July, 2009, Cocobolo, hard Two Part Wax Finish, Birthday Present for Jack Koch

*Rolling Pin -- May, 2011, Ash (from back yard), Pentacryl, for Me
*Bowl -- May, 2011, Osage Orange, Two Part Wax Finish

*Bench for Angela -- July 2013, Pine 2x4s cut and screwed all purty like
*Eric's Media Center Stand (made with Eric) -- June 2013, Birch plywood with steel threaded rods for legs and nice nuts, washers, and bolts
*Finished (previous) Chess Board -- July 2013, with cedar edges and maple curved feet - Christmas 2013 Gift for Dad

*Trash Can Holder for Ang, Cedar and Pine -- September 2014

*Box for [http://jchutchins.net/ Chris Hutchins] for his Golem Arcana collection -- Cedar from CedarUSA, October 2014

*Mustache trinket costume props for Halloween 2014

*Hedgehog Gift Card Holders for Diane, Karen, Dawn, and Danette (Angela's Family's November Birthdays) -- Cedar November 2014
*Bowl for Danielle -- Cedar, Mesquite, and Maple; my first glued up bowl -- November 2014

=Things Other People have made:=

*Angela: Wooden Bowl (2008, Cherry, Woodcraft Class) -- Birthday present for her mom
*Angela: Wooden Bowl (2008, Paduak, Flaxseed Oil finish)
*Angela: Pen (2008, Cedar, Wax Finish)
*Angela: Pen (2008, PurpleHeart)
*Kory: Pen (2008, Cocobolo, Wax Finish)
*Eric: Chess Set, 2008-2009, Basswood Scroll Sawed

*Joe has made lots of stuff, but I can't really enumerate them, and he makes a lot of cool wood stuff outside the shop. Joe can add stuff here if he wants though!

=Things Chip should make but hasn't yet:=

*Spinning Tops
*Kendama
*Spheres
*Kayaks and Canoes
*Wooden Bicycles
*Ring Holders
*Baby Rattles
*Juggling Clubs or Torches
*Rolling Pins
*Wine Bottle Toppers
*Christmas Ornaments (see http://www.nancy-arn.com/wood_turning_projects.htm)
*Gavel
*Coasters

Wood Projects

2014-11-08T17:50:56Z

Admin: /* Things Other People have made: */

=Things Chip has made in his little workshop:=
(possibly chronologically ordered)

*Heart Inlaid Box -- 2007, Pine, RedHeart - Gift for Angela

*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Michael Koch
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Brian Helfrich
*Baseball Bat 2008 -- Ash, Unfinished - Birthday Present for Joe

*Chess Board 2008, Spalted Maple and RedHeart, PolyCrylic finish

*Bowl -- 2008, 6" diameter, PurpleHeart, Flaxseed Oil Finish with much help from Ang - Birthday Present for Karen Koch

*Rolling Pin 2008, Birch, Turned Green, Pentacryl dried, for Angela

*Pen -- August, 2008, Red Palm [nb: This wood is awesome!], Renaissance Wax Finish, Birthday Present for Joe
*Pen -- August, 2008, ZebraWood, Renaissance Wax Finish, Present for Pete Bell upon having his first kiddo
*Pen -- August, 2008, Acrylic, didn't really go that well
*Pen -- August, 2008, Laminated RedHeart and Spalted Maple, Renaissance Wax finish, Gift for Jen at BeaverVu Bowling since hers didn't work
*Pen -- September, 2008, Coconut Red Palm, Hut Wax finish, Gift for Stephanie Tubbs' Birthday

*Bowl -- October, 2008, 6" diameter, Yellow Heart, unfinished, with help from Ang
*Bowl -- October, 2008, 6" diameter, Black and White Synthetic wood, Spray Lacquer finish

*Trinket -- Tiny captured ring chalice shape

*Pen -- July, 2009, Patterned laminate wood, Cloth Applied Lacquer Finish
*Candle Holder -- July, 2009, Brazilian Rosewood, holds 4" and 3" candles, Gift for Cathy Thompson
*Pen -- July, 2009, Cocobolo, hard Two Part Wax Finish, Birthday Present for Jack Koch

*Rolling Pin -- May, 2011, Ash (from back yard), Pentacryl, for Me
*Bowl -- May, 2011, Osage Orange, Two Part Wax Finish

*Bench for Angela -- July 2013, Pine 2x4s cut and screwed all purty like
*Eric's Media Center Stand (made with Eric) -- June 2013, Birch plywood with steel threaded rods for legs and nice nuts, washers, and bolts
*Finished (previous) Chess Board -- July 2013, with cedar edges and maple curved feet - Christmas 2013 Gift for Dad

*Trash Can Holder for Ang, Cedar and Pine -- September 2014

=Things Other People have made:=

*Angela: Wooden Bowl (2008, Cherry, Woodcraft Class) -- Birthday present for her mom
*Angela: Wooden Bowl (2008, Paduak, Flaxseed Oil finish)
*Angela: Pen (2008, Cedar, Wax Finish)
*Angela: Pen (2008, PurpleHeart)
*Kory: Pen (2008, Cocobolo, Wax Finish)
*Eric: Chess Set, 2008-2009, Basswood Scroll Sawed

*Joe has made lots of stuff, but I can't really enumerate them, and he makes a lot of cool wood stuff outside the shop. Joe can add stuff here if he wants though!

=Things Chip should make but hasn't yet:=

*Spinning Tops
*Kendama
*Spheres
*Kayaks and Canoes
*Wooden Bicycles
*Ring Holders
*Baby Rattles
*Juggling Clubs or Torches
*Rolling Pins
*Wine Bottle Toppers
*Christmas Ornaments (see http://www.nancy-arn.com/wood_turning_projects.htm)
*Gavel
*Coasters

Chip's Resume

2013-11-21T15:52:45Z

Admin: added website work

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Passport Health Plan Louisville, KY
Data Warehouse Architect (October 2012 - Present)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University
Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science

Extensive Experience With
* Informatica PowerCenter
* Tableau, Cognos, and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* python (mostly around SciPy, NumPy, and SQL integration)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware
* MelissaData Geocoding and Fuzzy Matching SSIS Packages

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Medical Coding including ICD-9, ICD-10, CPT, DRG, BETOS, HCPCS, and others
* Department of Defense Architecture Framework (DoDAF)
* Top 1% ranking in Kaggle and top 5% finisher in their $3Million Heritage Health Prize Data Mining Competition
* Completed Coursera's May 2013 Data Mining class "with Distinction"
* Maintain websites for http://heartsforkenya.com/, and http://daytonartists.org/

Chip's Resume

2013-09-25T19:08:05Z

Admin: Added Tableau

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Passport Health Plan Louisville, KY
Data Warehouse Architect (October 2012 - Present)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University
Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science

Extensive Experience With
* Informatica PowerCenter
* Tableau, Cognos, and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Department of Defense Architecture Framework (DoDAF)
* Top 1% ranking in Kaggle and top 5% finisher in their $3Million Heritage Health Prize Data Mining Competition
* Completed Coursera's May 2013 Data Mining class "with Distinction"

Chip's Resume

2013-09-25T19:06:21Z

Admin:

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Passport Health Plan Louisville, KY
Data Warehouse Architect (October 2012 - Present)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University
Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science

Extensive Experience With
* Informatica PowerCenter
* Cognos and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Department of Defense Architecture Framework (DoDAF)
* Top 1% ranking in Kaggle and top 5% finisher in their $3Million Heritage Health Prize Data Mining Competition
* Completed Coursera's May 2013 Data Mining class "with Distinction"

Microsoft Tidbits

2013-09-24T20:07:58Z

Admin: added "or"

==SQL Server Tidbits==
===Running Queries===
<pre>
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext;

select row_count,* from sys.dm_exec_requests r join sys.dm_os_tasks t on r.session_id = t.session_id where r.session_id = 70 order by task_state;
select sum(context_switches_count) from sys.dm_exec_requests r join sys.dm_os_tasks t on r.session_id = t.session_id where r.session_id = 70;
</pre>
===List Tables in a schema===
<pre>SELECT NAME FROM SYS.all_objects WHERE schema_id IN (SELECT SCHEMA_ID FROM SYS.schemas WHERE NAME = 'ICD10');

select [name]
from dbo.sysobjects
where OBJECTPROPERTY(id, N'IsUserTable') = 1 -- restrict to normal user tables
</pre>
===Determine space used by an object===
<pre>EXEC sp_spaceused N'Facts.F_MEMBER_ENROLLMENT';</pre>
===Awesome undocumented procedure to loop through tables (one exists for databases too)===
<pre>exec sp_MSforeachtable 'EXEC sp_spaceused [?]';</pre>
===Size of individual indexes===
<pre>exec sp_MSIndexSpace N'Dimensions.D_CLAIM_LINE_ITEM_T1';</pre>
===Rename or Move Objects===
<pre>exec sp_rename 'Dimensions.D_PROVIDER_T1.TAXONOMY_CODE','PRIMARY_TAXONOMY_CODE', N'COLUMN'
exec tempdb..sp_rename '#MY_TEMP_TABLE.COLUMN_OLD','COLUMN_NEW', N'COLUMN'

-- Move (rename) a table into a different schema (with generation):

alter schema HEDIS_2014 transfer dbo.AAB;

select 'alter schema HEDIS_2014 transfer dbo.' + name + ';'
from sys.all_objects
where schema_id = 1 and type = 'U'</pre>
===Rebuild Indexes===
<pre>ALTER INDEX ALL ON Dimensions.D_CLAIM_LINE_ITEM_T1
REBUILD WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON);</pre>
===Rebuild statistics===
<pre>UPDATE STATISTICS Dimensions.D_CLAIM_T1;

IF NOT EXISTS (SELECT * FROM sys.stats WHERE object_id = OBJECT_ID(N'[Facts].[F_CLAIM_LINE_ITEM]') AND name = N'_stat_DCT1_DMT2_DMT1')
CREATE STATISTICS [_stat_DCT1_DMT2_DMT1] ON [Facts].[F_CLAIM_LINE_ITEM]([CLAIM_T1_SKEY], [MEMBER_T2_SKEY], [MEMBER_T1_SKEY])</pre>
===Cute query to FLOOR (round to midnight the morning beginning) a date in Transact SQL===
<pre>SELECT DATEADD(day,0,FLOOR(CONVERT(float, getDate())));</pre>
or
<pre>SELECT CAST(GETDATE() AS DATE) -- Also works</pre>

===List partitioned thingies===
<pre>select distinct
p.[object_id],
TbName = OBJECT_NAME(p.[object_id]),
index_name = i.[name],
index_type_desc = i.type_desc,
partition_scheme = ps.[name],
data_space_id = ps.data_space_id,
function_name = pf.[name],
function_id = ps.function_id
from sys.partitions p
inner join sys.indexes i
on p.[object_id] = i.[object_id]
and p.index_id = i.index_id
inner join sys.data_spaces ds
on i.data_space_id = ds.data_space_id
inner join sys.partition_schemes ps
on ds.data_space_id = ps.data_space_id
inner JOIN sys.partition_functions pf
on ps.function_id = pf.function_id
order by object_id, index_name</pre>

==Reasons Microsoft Vista Sucks==
<UL><LI>"search in files" is gone. Yes, people THINK it's there, but it's not. I can't get the search to find a simple string in an .aspx file (which I have ridiculously associated with Notepad, just in case Vista is only looking for files it knows how to read). I've changed a boatload of settings, and read some other pages that seem to indicate that people got this working, but following their instruction does nothing. Is it the file type? WTF?</LI>
<LI>Really there are a lot of these, but given how lazy I've been updating the rest of the site you probably won't see them here unless they REALLY bother me... like whatever I have listed so far</LI>
</UL>

==Reasons Microsoft Access (2007) Sucks==

If you have a query that constantly asks you for a prompt for no reason, it could be that you've accidentally sorted by a column that you later renamed or removed. Access 2007 doesn't quite pick up on the change, so you have to do the following:
<UL>
<LI>Open the Query in Design View (or SQL View)</LI>
<LI>Open the Properties Sheet (which by default is open and docked on the right -- if not, right click somewhere and highlight "Properties")</LI>
<LI>See if there's anything in the "Order By" Property that shouldn't be there</LI>
<LI>Delete it</LI>
</UL>
Of course, it could be something else. ANY name change to a dependant query or table could cause grief -- they matriculate properly about half the time, judging from the last 12 hours. Changing the "Total" type of a field in a query for example will rename a field MaxOfxxxx without asking, and in some cases without propagating to other queries that reference the field. It's enough to drive one mad!

==Tips and Tricks for Windows XP Professional==
*NB: This used to be available at: http://www.microsoft.com/technet/prodtechnol/winxppro/tips/default.mspx but it's apparently gone, so I copied it here.

===Working with Files===
<ul>
<li>To rename several files at once, select all of them in any folder view, or in the Windows Explorer, rename the FIRST one in the list, and the rest will follow.
</li><li>To turn off filenames, hold down the Shift key when you click to open a folder in Windows Explorer or when you switch into thumbnail view. This will turn of the file names, giving more space for the thumbnails. Doing it again turns them back on.
</li><li>Try grouping your files. In the top menu bar select View – Arrange icons by… - Type, and then View – Arrange icons by… - Show in groups.
</li><li>You can change the size and quality of the shell's thumbnails. Start regedit, expand HKEY_CURRENT_USER (only for you) or HKEY_LOCAL_MACHINE (for all the users in this computer) and in Software – Microsoft – Windows – CurrentVersion – Explorer, add or modify the following entries:
</li><li>ThumbnailSize – Double Word, decimal value between 32 and 256
</li><li>ThumbnailQuality – Double Word, decimal value between 50 and 100
</li>
</ul>

===Internet Explorer===
<ul>
<li>You can use the Search Companion in Internet Explorer to perform many Internet related actions. Try:
</li><li>go msft
</li><li>Go yp cheesecake factory
</li></ul>

===Interface===
<ul>
<li>
Get rid of balloon tips: Start regedit, expand HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced
Set EnableBalloonTips=0x00000000
</li><li>
Disable the Search companion to go back to the traditional search view: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Explorer – CabinetState, set the value of Use Search Asst to "no"
</li><li>
Turn off the low disk space notification: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Policies - Explorer, and set the value of NoLowDiskSpaceChecks to DWORD = 1. (This modification requires a logoff or reboot to work)
</li><li>
You can force your taskbar to group windows. Any application that has any number you decide of windows open will automatically cluster, regardless of how full your taskbar is. To set this: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Explorer - Advanced, and create a REG_DWORD with the name TaskbarGroupSize and the value you want to reach before the windows are clustered together on the taskbar. (This modification requires a logoff to work).
Top of pageTop of page
</li></ul>

===Keyboard===
<ul>
<li>windowskey + Break opens the Control Panel System applet.
</li><li>windowskey + Tab moves through the taskbar buttons
</li><li>windowskey + D shows the Desktop
</li><li>windowskey + L shows the Welcome screen, or locks the machine if Fast User Switching is disabled.
</li>
</ul>

Microsoft Tidbits

2013-09-24T20:07:29Z

Admin: Added Partition query

==SQL Server Tidbits==
===Running Queries===
<pre>
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext;

select row_count,* from sys.dm_exec_requests r join sys.dm_os_tasks t on r.session_id = t.session_id where r.session_id = 70 order by task_state;
select sum(context_switches_count) from sys.dm_exec_requests r join sys.dm_os_tasks t on r.session_id = t.session_id where r.session_id = 70;
</pre>
===List Tables in a schema===
<pre>SELECT NAME FROM SYS.all_objects WHERE schema_id IN (SELECT SCHEMA_ID FROM SYS.schemas WHERE NAME = 'ICD10');

select [name]
from dbo.sysobjects
where OBJECTPROPERTY(id, N'IsUserTable') = 1 -- restrict to normal user tables
</pre>
===Determine space used by an object===
<pre>EXEC sp_spaceused N'Facts.F_MEMBER_ENROLLMENT';</pre>
===Awesome undocumented procedure to loop through tables (one exists for databases too)===
<pre>exec sp_MSforeachtable 'EXEC sp_spaceused [?]';</pre>
===Size of individual indexes===
<pre>exec sp_MSIndexSpace N'Dimensions.D_CLAIM_LINE_ITEM_T1';</pre>
===Rename or Move Objects===
<pre>exec sp_rename 'Dimensions.D_PROVIDER_T1.TAXONOMY_CODE','PRIMARY_TAXONOMY_CODE', N'COLUMN'
exec tempdb..sp_rename '#MY_TEMP_TABLE.COLUMN_OLD','COLUMN_NEW', N'COLUMN'

-- Move (rename) a table into a different schema (with generation):

alter schema HEDIS_2014 transfer dbo.AAB;

select 'alter schema HEDIS_2014 transfer dbo.' + name + ';'
from sys.all_objects
where schema_id = 1 and type = 'U'</pre>
===Rebuild Indexes===
<pre>ALTER INDEX ALL ON Dimensions.D_CLAIM_LINE_ITEM_T1
REBUILD WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON);</pre>
===Rebuild statistics===
<pre>UPDATE STATISTICS Dimensions.D_CLAIM_T1;

IF NOT EXISTS (SELECT * FROM sys.stats WHERE object_id = OBJECT_ID(N'[Facts].[F_CLAIM_LINE_ITEM]') AND name = N'_stat_DCT1_DMT2_DMT1')
CREATE STATISTICS [_stat_DCT1_DMT2_DMT1] ON [Facts].[F_CLAIM_LINE_ITEM]([CLAIM_T1_SKEY], [MEMBER_T2_SKEY], [MEMBER_T1_SKEY])</pre>
===Cute query to FLOOR (round to midnight the morning beginning) a date in Transact SQL===
<pre>SELECT DATEADD(day,0,FLOOR(CONVERT(float, getDate())));</pre>
<pre>SELECT CAST(GETDATE() AS DATE) -- Also works</pre>

===List partitioned thingies===
<pre>select distinct
p.[object_id],
TbName = OBJECT_NAME(p.[object_id]),
index_name = i.[name],
index_type_desc = i.type_desc,
partition_scheme = ps.[name],
data_space_id = ps.data_space_id,
function_name = pf.[name],
function_id = ps.function_id
from sys.partitions p
inner join sys.indexes i
on p.[object_id] = i.[object_id]
and p.index_id = i.index_id
inner join sys.data_spaces ds
on i.data_space_id = ds.data_space_id
inner join sys.partition_schemes ps
on ds.data_space_id = ps.data_space_id
inner JOIN sys.partition_functions pf
on ps.function_id = pf.function_id
order by object_id, index_name</pre>

==Reasons Microsoft Vista Sucks==
<UL><LI>"search in files" is gone. Yes, people THINK it's there, but it's not. I can't get the search to find a simple string in an .aspx file (which I have ridiculously associated with Notepad, just in case Vista is only looking for files it knows how to read). I've changed a boatload of settings, and read some other pages that seem to indicate that people got this working, but following their instruction does nothing. Is it the file type? WTF?</LI>
<LI>Really there are a lot of these, but given how lazy I've been updating the rest of the site you probably won't see them here unless they REALLY bother me... like whatever I have listed so far</LI>
</UL>

==Reasons Microsoft Access (2007) Sucks==

If you have a query that constantly asks you for a prompt for no reason, it could be that you've accidentally sorted by a column that you later renamed or removed. Access 2007 doesn't quite pick up on the change, so you have to do the following:
<UL>
<LI>Open the Query in Design View (or SQL View)</LI>
<LI>Open the Properties Sheet (which by default is open and docked on the right -- if not, right click somewhere and highlight "Properties")</LI>
<LI>See if there's anything in the "Order By" Property that shouldn't be there</LI>
<LI>Delete it</LI>
</UL>
Of course, it could be something else. ANY name change to a dependant query or table could cause grief -- they matriculate properly about half the time, judging from the last 12 hours. Changing the "Total" type of a field in a query for example will rename a field MaxOfxxxx without asking, and in some cases without propagating to other queries that reference the field. It's enough to drive one mad!

==Tips and Tricks for Windows XP Professional==
*NB: This used to be available at: http://www.microsoft.com/technet/prodtechnol/winxppro/tips/default.mspx but it's apparently gone, so I copied it here.

===Working with Files===
<ul>
<li>To rename several files at once, select all of them in any folder view, or in the Windows Explorer, rename the FIRST one in the list, and the rest will follow.
</li><li>To turn off filenames, hold down the Shift key when you click to open a folder in Windows Explorer or when you switch into thumbnail view. This will turn of the file names, giving more space for the thumbnails. Doing it again turns them back on.
</li><li>Try grouping your files. In the top menu bar select View – Arrange icons by… - Type, and then View – Arrange icons by… - Show in groups.
</li><li>You can change the size and quality of the shell's thumbnails. Start regedit, expand HKEY_CURRENT_USER (only for you) or HKEY_LOCAL_MACHINE (for all the users in this computer) and in Software – Microsoft – Windows – CurrentVersion – Explorer, add or modify the following entries:
</li><li>ThumbnailSize – Double Word, decimal value between 32 and 256
</li><li>ThumbnailQuality – Double Word, decimal value between 50 and 100
</li>
</ul>

===Internet Explorer===
<ul>
<li>You can use the Search Companion in Internet Explorer to perform many Internet related actions. Try:
</li><li>go msft
</li><li>Go yp cheesecake factory
</li></ul>

===Interface===
<ul>
<li>
Get rid of balloon tips: Start regedit, expand HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced
Set EnableBalloonTips=0x00000000
</li><li>
Disable the Search companion to go back to the traditional search view: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Explorer – CabinetState, set the value of Use Search Asst to "no"
</li><li>
Turn off the low disk space notification: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Policies - Explorer, and set the value of NoLowDiskSpaceChecks to DWORD = 1. (This modification requires a logoff or reboot to work)
</li><li>
You can force your taskbar to group windows. Any application that has any number you decide of windows open will automatically cluster, regardless of how full your taskbar is. To set this: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Explorer - Advanced, and create a REG_DWORD with the name TaskbarGroupSize and the value you want to reach before the windows are clustered together on the taskbar. (This modification requires a logoff to work).
Top of pageTop of page
</li></ul>

===Keyboard===
<ul>
<li>windowskey + Break opens the Control Panel System applet.
</li><li>windowskey + Tab moves through the taskbar buttons
</li><li>windowskey + D shows the Desktop
</li><li>windowskey + L shows the Welcome screen, or locks the machine if Fast User Switching is disabled.
</li>
</ul>

Microsoft Tidbits

2013-09-24T19:19:27Z

Admin: Added SQL Server Section

==SQL Server Tidbits==
===Running Queries===
<pre>
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext;

select row_count,* from sys.dm_exec_requests r join sys.dm_os_tasks t on r.session_id = t.session_id where r.session_id = 70 order by task_state;
select sum(context_switches_count) from sys.dm_exec_requests r join sys.dm_os_tasks t on r.session_id = t.session_id where r.session_id = 70;
</pre>
===List Tables in a schema===
<pre>SELECT NAME FROM SYS.all_objects WHERE schema_id IN (SELECT SCHEMA_ID FROM SYS.schemas WHERE NAME = 'ICD10');

select [name]
from dbo.sysobjects
where OBJECTPROPERTY(id, N'IsUserTable') = 1 -- restrict to normal user tables
</pre>
===Determine space used by an object===
<pre>EXEC sp_spaceused N'Facts.F_MEMBER_ENROLLMENT';</pre>
===Awesome undocumented procedure to loop through tables (one exists for databases too)===
<pre>exec sp_MSforeachtable 'EXEC sp_spaceused [?]';</pre>
===Size of individual indexes===
<pre>exec sp_MSIndexSpace N'Dimensions.D_CLAIM_LINE_ITEM_T1';</pre>
===Rename or Move Objects===
<pre>exec sp_rename 'Dimensions.D_PROVIDER_T1.TAXONOMY_CODE','PRIMARY_TAXONOMY_CODE', N'COLUMN'
exec tempdb..sp_rename '#MY_TEMP_TABLE.COLUMN_OLD','COLUMN_NEW', N'COLUMN'

-- Move (rename) a table into a different schema (with generation):

alter schema HEDIS_2014 transfer dbo.AAB;

select 'alter schema HEDIS_2014 transfer dbo.' + name + ';'
from sys.all_objects
where schema_id = 1 and type = 'U'</pre>
===Rebuild Indexes===
<pre>ALTER INDEX ALL ON Dimensions.D_CLAIM_LINE_ITEM_T1
REBUILD WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON);</pre>
===Rebuild statistics===
<pre>UPDATE STATISTICS Dimensions.D_CLAIM_T1;

IF NOT EXISTS (SELECT * FROM sys.stats WHERE object_id = OBJECT_ID(N'[Facts].[F_CLAIM_LINE_ITEM]') AND name = N'_stat_DCT1_DMT2_DMT1')
CREATE STATISTICS [_stat_DCT1_DMT2_DMT1] ON [Facts].[F_CLAIM_LINE_ITEM]([CLAIM_T1_SKEY], [MEMBER_T2_SKEY], [MEMBER_T1_SKEY])</pre>
===Cute query to FLOOR (round to midnight the morning beginning) a date in Transact SQL===
<pre>SELECT DATEADD(day,0,FLOOR(CONVERT(float, getDate())));</pre>
<pre>SELECT CAST(GETDATE() AS DATE) -- Also works</pre>

==Reasons Microsoft Vista Sucks==
<UL><LI>"search in files" is gone. Yes, people THINK it's there, but it's not. I can't get the search to find a simple string in an .aspx file (which I have ridiculously associated with Notepad, just in case Vista is only looking for files it knows how to read). I've changed a boatload of settings, and read some other pages that seem to indicate that people got this working, but following their instruction does nothing. Is it the file type? WTF?</LI>
<LI>Really there are a lot of these, but given how lazy I've been updating the rest of the site you probably won't see them here unless they REALLY bother me... like whatever I have listed so far</LI>
</UL>

==Reasons Microsoft Access (2007) Sucks==

If you have a query that constantly asks you for a prompt for no reason, it could be that you've accidentally sorted by a column that you later renamed or removed. Access 2007 doesn't quite pick up on the change, so you have to do the following:
<UL>
<LI>Open the Query in Design View (or SQL View)</LI>
<LI>Open the Properties Sheet (which by default is open and docked on the right -- if not, right click somewhere and highlight "Properties")</LI>
<LI>See if there's anything in the "Order By" Property that shouldn't be there</LI>
<LI>Delete it</LI>
</UL>
Of course, it could be something else. ANY name change to a dependant query or table could cause grief -- they matriculate properly about half the time, judging from the last 12 hours. Changing the "Total" type of a field in a query for example will rename a field MaxOfxxxx without asking, and in some cases without propagating to other queries that reference the field. It's enough to drive one mad!

==Tips and Tricks for Windows XP Professional==
*NB: This used to be available at: http://www.microsoft.com/technet/prodtechnol/winxppro/tips/default.mspx but it's apparently gone, so I copied it here.

===Working with Files===
<ul>
<li>To rename several files at once, select all of them in any folder view, or in the Windows Explorer, rename the FIRST one in the list, and the rest will follow.
</li><li>To turn off filenames, hold down the Shift key when you click to open a folder in Windows Explorer or when you switch into thumbnail view. This will turn of the file names, giving more space for the thumbnails. Doing it again turns them back on.
</li><li>Try grouping your files. In the top menu bar select View – Arrange icons by… - Type, and then View – Arrange icons by… - Show in groups.
</li><li>You can change the size and quality of the shell's thumbnails. Start regedit, expand HKEY_CURRENT_USER (only for you) or HKEY_LOCAL_MACHINE (for all the users in this computer) and in Software – Microsoft – Windows – CurrentVersion – Explorer, add or modify the following entries:
</li><li>ThumbnailSize – Double Word, decimal value between 32 and 256
</li><li>ThumbnailQuality – Double Word, decimal value between 50 and 100
</li>
</ul>

===Internet Explorer===
<ul>
<li>You can use the Search Companion in Internet Explorer to perform many Internet related actions. Try:
</li><li>go msft
</li><li>Go yp cheesecake factory
</li></ul>

===Interface===
<ul>
<li>
Get rid of balloon tips: Start regedit, expand HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced
Set EnableBalloonTips=0x00000000
</li><li>
Disable the Search companion to go back to the traditional search view: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Explorer – CabinetState, set the value of Use Search Asst to "no"
</li><li>
Turn off the low disk space notification: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Policies - Explorer, and set the value of NoLowDiskSpaceChecks to DWORD = 1. (This modification requires a logoff or reboot to work)
</li><li>
You can force your taskbar to group windows. Any application that has any number you decide of windows open will automatically cluster, regardless of how full your taskbar is. To set this: Start regedit, expand HKEY_CURRENT_USER and in Software – Microsoft – Windows – CurrentVersion – Explorer - Advanced, and create a REG_DWORD with the name TaskbarGroupSize and the value you want to reach before the windows are clustered together on the taskbar. (This modification requires a logoff to work).
Top of pageTop of page
</li></ul>

===Keyboard===
<ul>
<li>windowskey + Break opens the Control Panel System applet.
</li><li>windowskey + Tab moves through the taskbar buttons
</li><li>windowskey + D shows the Desktop
</li><li>windowskey + L shows the Welcome screen, or locks the machine if Fast User Switching is disabled.
</li>
</ul>

Chip's Resume

2013-08-29T14:32:29Z

Admin: Added Kaggle and Coursera

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Passport Health Plan Louisville, KY
Data Consultant (October 2012 - Present)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University
Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science

Extensive Experience With
* Informatica PowerCenter
* Cognos and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Department of Defense Architecture Framework (DoDAF)
* Top 1% ranking in Kaggle and top 5% finisher in their $3Million Heritage Health Prize Data Mining Competition
* Completed Coursera's May 2013 Data Mining class "with Distinction"

Chip's Resume

2013-08-29T14:02:38Z

Admin: Reordered and updated recent work

Data Architect, Data Hobbyist, and Data Scientist

e-mail: chip@chiplynch.com

I am a data scientist, architect, and artist with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence, data mining, data quality, and data migration projects. I have led teams of people through every phase of Enterprise Data Management, and I bring experience from high profile, large-scale clients such as NASA, the City and County of San Francisco, the US Air Force, and the US Postal Service. I have experience with the program management and development lifecycle standards required to run organized, repeatable, and successful data warehousing projects. I have personally designed data models, coded extract-transform-load (ETL) processes, built reporting architectures, and administered databases and application servers. I have matriculated into planning, architecting, and managing teams performing these tasks on increasingly large and complex systems.

Clearance: DoD Top-Secret

Experience: 

Passport Health Plan Louisville, KY
Data Consultant (October 2012 - Present)
*Established a new data warehouse from the ground up for a Medicare health care management company of ~250 people
*Built training materials, project plan, data models, design patterns, coding standards, physical architecture and infrastructure and all relevant documentation for a completely new data warehouse from scratch
*Quickly implemented Data Quality and Data Dictionary systems through designs pioneered through my previous projects
*Integrated sources from COTS health care, call center, IT management, and other systems into an integrated data warehouse following a Kimball-compliant star schema design
*Implemented the design in Microsoft SQL Server with SSIS/SSAS/SSRS components and a Tableau based dashboard

Wright Patterson Air Force Base Dayton, OH
Data Architect and ERP Contractor with Deloitte (2003-Present) 
* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of AF Global Logistics Supply Chain (GLSC) owned and managed systems
* Team manager for a staff of 24 people, in a leadership role on a team of 40+ members of a Data Quality initiative as part of a 150+ person ERP team.
* Provided data management, quality, governance, and oversight to for hundreds of logistics and financial systems with the new policies, procedures, and data requirements introduced by the USAF’s Oracle ERP installation – one of the largest Oracle implementations in the world, managing a $36 billion inventory and related supply chain.
* Responsible for the Data Management Organization’s Master Data Management component, including the technical management of various lists of values, building of a data dictionary, and integration with the enterprise data modeling efforts.
* Created an IT strategy and roadmap for the Air Force’s Global Logistics Support Center focusing on Data Management, Systems, Maintenance and Governance.
* Led a team to create a Business Intelligence strategy for the Air Force ERP system. The design stretches from high level governance and policy issues to technical Business Intelligence architecture and enterprise warehouse design.
* Performed as the technical team lead for a development team which integrated over 50 source systems and data marts into a large data warehouse. Ultimately we were responsible for integrating maintenance, supply, logistics data, and systems tracking specific assets into the Air Force Enterprise Data Warehouse.
* Built standards and repeatable CMMI processes for every aspect of Data Warehouse management, including modeling and loading new source data, data mart processing, report specification and building, ongoing maintenance, and pretty much everything in between.
* Technical demands included Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, SharePoint, MediaWiki, and Teradata support, design, and development in a closely integrated environment.

Cincinnati Financial Corp. Cincinnati, OH
Data Warehouse Consultant with Deloitte (Jan-Feb 2010)
* Provided third party evaluation of a nascent EDW implementation plan. Helped drive Enterprise Service Bus (ESB) adoption and identified solutions to project implementation roadblocks.

FirstEnergy Corp. Akron, OH,
Data Migration Contractor (2002-2003)
* Supplied technical expertise and programming support for a large scale SAP R/3 migration using Informatica, Oracle, and SAP/ABAP tools.
* Worked closely with both a functional and technical team to design, develop, test, and deploy a migration mechanism for Human Resources data.

US Postal Service Raleigh, NC,
Data Warehouse Contractor (2002)
* Provide Informatica and data warehousing expertise for the USPS very large data warehouse initiative.
* Primary responsibility was on increasing performance on very large data loads to the warehouse. For example I reduced the running time for some loads from 80+ hours down to 4 hours.

Clients with KPMG Consulting Washington, DC,
Senior Consultant (1998- 2002)

City and County of San Francisco (2000- 2001)
* Designed and implemented a terabyte scale data warehouse for the City.
* Responsible daily for Oracle tuning and database administration (DBA) work, Informatica and Cognos design, development, and performance tuning. Also administered large Windows NT and HP-UX servers.
* Marketed the warehouse to senior department heads, eventually creating departmental data marts and a distributed Oracle environment.
* Developed end user training, documentation, and robust testing/validation procedures.

National Aeronautics and Space Administration (NASA) (1999-2000)
* I was part of a team that designed and developed an enterprise-wide data warehouse (EDW) for NASA. I was the main technical resource on the project, and my duties included researching, specifying, purchasing and administering $1.5 million of Sun hardware running the Solaris operating system.
* I was involved in the entire lifecycle of this EDW. I met with scores of functional people from across the country to develop logical and physical data models. I led a small team in the Informatica development for data transformation and cleansing from disparate source systems to the Oracle EDW. We worked with the Holos OLAP package and Crystal Reports and Brio ad-hoc query tools to deliver a web-based reporting solution to the client's specifications.

Performance Executive (various clients)
* Performance Executive was a packaged data warehouse that we marketed to clients of our proprietary accounting systems. I was one of several technical resources on the project throughout my tenure at KPMG, and I was involved with every aspect of the product's creation, testing, and marketing. Primarily the product was back-ended in Oracle 7,8, or 8i, and Microsoft SQL Server, with an Informatica engine for data cleansing and transformation. The front-end tool of choice was Cognos Impromptu and PowerPlay, although some clients used Business Objects, Brio, Microstrategy and Crystal reports.

US Senate, Washington, DC (Fall, 1999)

City of Ottawa, Canada (as needed 2000)

Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)

Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)

Oakland County, Michigan (Sept. 2001-Feb. 2002)

Other Work Experience: 

Xavier University Cincinnati, Ohio
WebMaster/Programmer/Analyst (Fall 1993 - March 1998)

Farwell and Hendricks Cincinnati, Ohio
Senior Thesis Project
Worked on thesis project with Farwell and Hendricks to develop a Windows 95 program to collect and analyze data for electronic devices. The program collected 5,000-10,000 samples/second from hardware placed on an earthquake simulator, displayed graphs, and analyzed results to determine instabilities in electric current. Neat stuff!

Education
Xavier University
Cincinnati, Ohio
* Bachelor of Science in Mathematics and Computer Science

Extensive Experience With
* Informatica PowerCenter
* Cognos and Business Objects Business Intelligence Products
* MySQL, Oracle and Teradata Database Products and SQL
* ErWin Data Modeling Tool
* Windows Server, Linux and Unix (Various) Operating Systems
* Apache, PHP, HTML, TCP/IP, Other Internet Technologies

Working Knowledge of
* R (The R Project for Statistical Computing)
* Microstrategy, Brio, Holos, Crystal Reports
* Apple Macintosh OS, OpenVMS
* SQL Server, Microsoft IIS
* SAP R/3: ABAP and HR InfoTypes
* DCL, Pascal, C, C++, Visual Basic, Visual C++, SQL
* PGP, Numerical Cryptographic Theory, System Security
* Numerous other software packages, feel free to ask
* Sun, Hewlett-Packard, and IBM Hardware

Other Relevant Experience
* Oracle Unified Methodology Level 3 Certification
* SEI/CMMI project lifecycle management standards
* DAMA DMBOK and ITIL Practices
* Department of Defense Architecture Framework (DoDAF)

Category:Recipe

2012-07-25T18:34:52Z

Admin: Created page with "Semantic MediaWiki Master Page for "Recipe" So... you know... all of these are recipe related. :-) See: Recipes"

Semantic MediaWiki Master Page for "Recipe"

So... you know... all of these are recipe related. :-)

See: [[Recipes]]

Bourbon Pie Crust

2012-07-25T18:33:45Z

Admin: Added Category:recipe

Joe's Breakfast Bars Recipe

2012-07-25T18:33:30Z

Admin: Added category:recipe

[[Category:Recipe]]
Hi guys. I've finally ironed out the details to this recipe. It freakin rocks! Try it! <nowiki>:)</nowiki>

==Joe's Breakfast bar recipe==

2 cups oats
1c flour
1c dried blueberries or cranberries
1c semisweet chocolate chips (or dark)
1/2c almond peices
1/4c milled flaxseed
1 tbs cinnamon
Dash o salt
1/3c brown suggar
1/4c honey
1/2c veg or olive or flax oil
1c orange juice

Add and mix. Let stand and soak in till its all one gooey ball. Spread into greased 9x9 pan.

Bake at 375 for 30min.

Cut while hot. Let stand. Refrigerate and you have breakfast all week!

Joe's Thunder Over Louisville Salsa Recipe

2012-07-25T18:33:14Z

Admin: Added category:recipe

[[Category:Recipe]]
==Joe's Salsa Recipe==

4 ripe tomatoes
1 sweet onion
1 can corn drained
1 can black beans washed and drained
4 cloves garlic
Fresh chopped cilantro half a bunch
1 green bell pepper
(Also a red or yellow if desired for color)
1 stalk celery
1 finely diced Habanero and/or banana pepper (more or less to taste. Neither for mild)

Chop and mix all above ingredients, then add:

Ground pepper
Salt to taste
Splash of vinegar
1 squeezed lime
(Shot of silver tequila if desired)

Best if let settle for a few hours or so in the fridge, posibly overnight.

Derbie Pie Recipe

2012-07-25T18:33:01Z

Admin: Added category:recipe

[[Category:Recipe]]
==From The Louisville Times article by Sarah Fritschner staff writer, May 3, 1978==

The original “Derby Pie,” which is in a class by itself, was so obviously so when first formulated by Walter and Leaudra Kern, they copywrited the recipe. This needn’t be a hindrance, however, as the other pies that resemble it are so delicious that few people will ever know they aren’t eating the original. A recipe for an imposter follows:

'''HORSE-RACE PIE'''
4 Whole eggs
¾ cup white sugar
¼ cup brown sugar
1 teaspoon vanilla
2 tablespoons bourbon
1 cup white corn syrup
1 stick melted butter
1 tablespoon flour
1 cup chopped pecans
1 cup chocolate chips
1 unbaked 10-inch pie shell

Beat the eggs. Add to them the sugars, vanilla, bourbon, corn syrup, butter and flour. Mix well. Distribute nuts and chips in the bottom of the pie shell. Pour the filling on top. Bake at 350 degrees for 45 minutes.

The Kerns, along with son George, formulated the recipe while they managed the Melrose Inn in Prospect in the 50s ….

Guinness Bread Recipe

2012-07-25T18:32:42Z

Admin: Added category: recipe

[[Category:Recipe]]
Ok, I need to put more recipes on here. So, here's one.

I got a bottle of beer-bread-mix for Christmas, poured some Guinness in and, lo! Tasty bread. So, here's something that tastes completely unlike that.

4 Cups Flour (I use 2 Cups Wheat, 1-1/2 Cups All Purpose, and 1/2 Cup of whatever else is lying around)
2 Tablespoons Baking Powder
1 Teaspoon Salt
2 Tablespoons Sugar
2 Tablespoons Olive Oil
12 Ounces Guinness (Get the 14 ounce can so you can sip on it a bit)
2 Eggs

Mix stuff. Bake at 375 for 50-60 minutes in a 9x5 stoneware.

Dip in Olive Oil.

Eat.

Vegetarian Burrito Goop

2012-07-25T18:30:51Z

Admin: New Recipe for

[[Category:Recipe]]
In an attempt to make some vegetarian burgers in early 2012, I destroyed a lot of Amaranth and Quinoa (both great foods), and accidentally came up with the following, which can absolutely, positively not be made into patties. But it makes an EXCELLENT burrito filling and it's really simple:

1 Can Black Beans
1 Can Yellow Corn
1 Can Chickpeas (Garbanzo Beans)
1 Cup Quinoa
1 Packet Taco Seasoning

Cook the Quinoa according to instructions, typically boil 1 cup of water, add 1 cup Quinoa, cook 10 minutes and let sit.

While cooking, drain the cans of Black Beans, Yellow Corn, and Chickpeas and mix in a mixing bowl. Pulverize for several minutes with a pestle, targeting the chickpeas mainly, as they squish into the lovely goop that binds everything else together. Corn does not mush well, black beans are somewhere in between, but you'll hit enough of them aiming for the chickpeas. Do this for a couple of minutes, then add the packet of Taco seasoning and smash for a couple minutes more. Don't forget to stir the Quinoa a little in the mean time.

Once the Quinoa is cooked (it should not need to be drained, but you don't want extra moisture so sometimes draining or a pass through cheesecloth, or letting it sit and steam for a while is good), pour it into the mixing bowl with everything else. Mix with a wooden spoon, trying to fluff volume into the mix so the Quinoa mixes in with the goopy bits.

Eat.

Recipes

2012-07-25T18:21:12Z

Admin: /* List of Recipes on ChipWiki */

Main Page

2012-07-25T18:17:05Z

Admin: /* Technical Tidbits */

<big>'''ChipWiki is fully operational!'''</big>

Or at least I hope so. Not sure what I'm going to do about it, of course. Here's some useful stuff that shipped with the front page... when I figure out how to change the navigation and toolbox sidebars, I'll probably move this stuff there. Of course, then I'll have to come up with some real content for the main page. Sheesh.

== Links about Chip ==

[http://www.dummies.com/how-to/computers-software/ms-office/powerpoint.html Powerpoint for Dummies] This is what I do for a living now - I'm very proud!

[[Chip's Resume]] (Not that I need a job, but you know, just in case)

[[ChipLynch.com|About ChipLynch.com]]

[[Good Ideas|Some ideas running around in my head]]

[[To Do List|Chip's To Do List]]

[[Video Games|A Place for Chip to talk about Video Games]]

[[Wood Projects|Things Chip has Made in his budding Wood Shop]]

[[Recipes|Chip's Recipes]]

== Technical Tidbits ==

[[Oracle Tidbits]]

[[Teradata Tidbits]]

[[Informatica Standards]]

[[Linux Tidbits]]

== MediaWiki Links ==

Consult the [http://meta.wikipedia.org/wiki/MediaWiki_User%27s_Guide User's Guide] for information on using the wiki software.

== Getting started ==

* [http://www.mediawiki.org/wiki/Help:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Help:FAQ MediaWiki FAQ]
* [http://mail.wikipedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Annual Events to Attend

2012-07-16T03:38:36Z

Admin: Added Burning Man

* [http://www.defcon.org/ DefCon ]
* [http://www.machinegunshoot.com/ Knob Creek Machine Gun Shoot ] - April, October Annually
* [http://www.gencon.com/2009/indy/default.aspx GenCon ]
* [http://www.alefest.com/dayton.htm Ale-Fest Dayton ]
* [http://www.burningman.com/ Burning Man ]

Main Page

2012-01-27T02:07:04Z

Admin: Added Recipes link

<big>'''ChipWiki is fully operational!'''</big>

Or at least I hope so. Not sure what I'm going to do about it, of course. Here's some useful stuff that shipped with the front page... when I figure out how to change the navigation and toolbox sidebars, I'll probably move this stuff there. Of course, then I'll have to come up with some real content for the main page. Sheesh.

== Links about Chip ==

[http://www.dummies.com/how-to/computers-software/ms-office/powerpoint.html Powerpoint for Dummies] This is what I do for a living now - I'm very proud!

[[Chip's Resume]] (Not that I need a job, but you know, just in case)

[[ChipLynch.com|About ChipLynch.com]]

[[Good Ideas|Some ideas running around in my head]]

[[To Do List|Chip's To Do List]]

[[Video Games|A Place for Chip to talk about Video Games]]

[[Wood Projects|Things Chip has Made in his budding Wood Shop]]

[[Recipes|Chip's Recipes]]

== Technical Tidbits ==

[[Oracle Tidbits]]

[[Teradata Tidbits]]

[[Informatica Standards]]

== MediaWiki Links ==

Consult the [http://meta.wikipedia.org/wiki/MediaWiki_User%27s_Guide User's Guide] for information on using the wiki software.

== Getting started ==

* [http://www.mediawiki.org/wiki/Help:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Help:FAQ MediaWiki FAQ]
* [http://mail.wikipedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Main Page

2011-11-29T18:14:38Z

Admin: Removed Facebook Link

<big>'''ChipWiki is fully operational!'''</big>

Or at least I hope so. Not sure what I'm going to do about it, of course. Here's some useful stuff that shipped with the front page... when I figure out how to change the navigation and toolbox sidebars, I'll probably move this stuff there. Of course, then I'll have to come up with some real content for the main page. Sheesh.

== Links about Chip ==

[http://www.dummies.com/how-to/computers-software/ms-office/powerpoint.html Powerpoint for Dummies] This is what I do for a living now - I'm very proud!

[[Chip's Resume]] (Not that I need a job, but you know, just in case)

[[ChipLynch.com|About ChipLynch.com]]

[[Good Ideas|Some ideas running around in my head]]

[[To Do List|Chip's To Do List]]

[[Video Games|A Place for Chip to talk about Video Games]]

[[Wood Projects|Things Chip has Made in his budding Wood Shop]]

== Technical Tidbits ==

[[Oracle Tidbits]]

[[Teradata Tidbits]]

[[Informatica Standards]]

== MediaWiki Links ==

Consult the [http://meta.wikipedia.org/wiki/MediaWiki_User%27s_Guide User's Guide] for information on using the wiki software.

== Getting started ==

* [http://www.mediawiki.org/wiki/Help:Configuration_settings Configuration settings list]
* [http://www.mediawiki.org/wiki/Help:FAQ MediaWiki FAQ]
* [http://mail.wikipedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]

Wood Projects

2011-05-11T01:31:45Z

Admin: /* Things Chip has made in his little workshop: */

Wood Projects

2009-08-02T16:16:34Z

Admin:

Oracle Tidbits

2008-04-21T18:19:32Z

Admin: ORA-00942: table or view does not exist

=Useful things I always forget about Oracle=
==If Archive Logs Fill Up==
After you've made some space, or to direct archiving to an emptier place, remind Oracle where to right the archive files. When it locks up, it resets something in memory that needs to be reset.

<ul>
<li>SQLPLUS /NOLOG</li>
<li>Connect internal</li>
<li>alter system set log_archive_dest_1="LOCATION=F:\ORACLE\EDWD" SCOPE=MEMORY;</li>
</ul>
==Retrieving DDL from Oracle 9i==
Use this:
<blockquote>SELECT DBMS_METADATA.GET_DDL(object_type, object_name, owner)</blockquote>
as in:
<blockquote>SELECT DBMS_METADATA.GET_DDL('TABLE', MY_TABLE, CHIP);</blockquote>
==Setting Up a Clean Output for long Spools from SQL*Plus==
<ul>
<li>SET HEAD OFF</li>
<li>SET FEED OFF</li>
<li>SET PAGESIZE 0</li>
<li>SET LINESIZE 200 (or whatever)</li>
<li>SET LONG 90000</li>
</ul>

==ORA-00942: Stored Procedures Do Not Respect ROLE based Rights==
If you get "ORA-00942: Table or view does not exist" during a stored procedure compilation, and you're otherwise sure that you have the right table/view/synonym names of course, then it may be that the RIGHTS to the object are granted through a role, which the stored procedure does not respect. Try GRANTing the rights directly to the Procedure's owner, rather via a Role, and see if that doesn't help.

Oracle Tidbits

2008-04-21T16:15:00Z

Admin: /* Setting Up a Clean Output for long Spools from SQL*Plus */

Oracle Tidbits

2008-04-21T16:11:16Z

Admin: Clean Output SQLPlus Settings

Informatica Standards

2008-04-09T20:34:35Z

Admin: Fixed Naked <LI> element

=Informatica Standards and Thoughts=
==Good Standards==
<UL>
<LI>Always set the error threshold to 1</LI>
<LI>Always check "fail parent if this task fails"</LI>
<LI>Always check "Run if previous completed" on command tasks</LI>
<LI>Try to avoid overriding reuseable Tasks and Sessions... if you get a "Revert" button while making a change, make sure the change should only apply to THIS instance, rather than every instance, and consider making the change in another place.</LI>
<LI>Scripts should always write to <stdout>; only the highest level call should redirect to a log file with "> <log> 2>&1" style</LI>
<LI>Use Admin Tables: ADMIN_FEED_TO_TABLE, etc. (needed for checking MLoad errors, etc.)</LI>
<LI>Set Error Threshold to 1 in MLoad configuration. This does NOT mean you can avoid a separate check for MLoad errors; UV errors are not properly reported back to Informatica, but ET errors will at least fail the load</LI>
<LI>Ensure workflow and session logs are directed to the appropriate directory, as the default is not precise enough</LI>
</UL>

==Discussion Items==
<UL>
<LI>Where should shell script redirects to log files be? In the Informatica command task that calls them? Should the script handle its own log file? If a BTEQ script is called from a shell script, should the shell script handle the BTEQ log but something else handle the shell script log? Or should the BTEQ just pass through stdout and stderr to the script, which is then redirected by Informatica?
</LI>
<LI>There's some issue with the XML Parser that it doesn't always generate rows if some of the nested elements are missing. There's a "Force Row" check box in the source XML editor which alleviates this problem. I'll have a picture up around here about it sometime.</LI>
</UL>