Chip's Resume: Difference between revisions

Revision as of 17:33, 2 August 2012

Data Warehouse Architect

e-mail: chip@chiplynch.com

I am a data warehouse architect with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence and data migration projects. I have led teams of people through every phase of Data Warehouse creation, and I can 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 Capabilities and Maturities Model (CMM) development lifecycle standards, where I've learned processes for running organized, repeatable and successful data warehousing projects. I have personally designed data models, built ETL and reporting architecture, and administered databases and application servers.

DOD Clearance: Top-Secret

Experience:

Wright Patterson Air Force Base Dayton, OH,

Data Warehouse Contractor (2003-Present)
US Air Force, GLSC Project, December 2010 – Present

Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of GLSC owned and managed systems

US Air Force, ECSS Project, August 2008 - December 2010

Technical lead for several of the Data Management Organization’s initiatives, including Master Data Maintenance, Metrics and Monitoring, Business Rule Consolidation, Data Acquisition and Archival, and other data quality focused products
Team lead for a Business Intelligence study, which focused on architecting methods to bridge data from hundreds of legacy systems and existing reporting with the new policies, procedures, and data introduced by the ERP. The design stretches from high level governance and policy issues to technical BI architecture and enterprise warehouse design
Performed in depth data analysis as team lead for a Master Data pilot, resulting in methodologies for ongoing analysis, quality monitoring, and specific recommendations on trouble areas for data migration to the Oracle ERP

US Air Force, Data Warehouse, June 2003 – August 2008

Performed as the technical team lead for a development team, which integrated over 50 maintenance, supply, logistics, and asset systems into the data warehouse including D043, D200A, D035A, D035K, and G100
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, and ongoing maintenance
Supported and designed the development of various versions of Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, and Teradata in a closely integrated environment

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 Postal's 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 DBA work, Informatica and Cognos design, development, and performance tuning. Also administered large 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

Double Bachelor's of Science in Mathematics and Computer Science

Technical Experience Extensive/Up-To-Date Knowledge of

Data Warehousing best practices
SEI/CMM project lifecycle management standards
Informatica PowerCenter (w/PowerConnect for SAP/DB2)
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
Desktop Publishing

Working Knowledge of

Microstrategy, Brio, Holos, Crystal Reports
SAP R/3: ABAP and HR InfoTypes
Microsoft SQL Server
Apple Macintosh OS, OpenVMS
Sun, Hewlett-Packard, IBM, and Digital Hardware`
DCL, Pascal, C, C++
PGP, Numerical Cryptographic Theory, System Security
Numerous other software packages, feel free to ask

@@ Line 1: / Line 1: @@
-== internet marketing consultant ==
+Data Warehouse Architect
-A subscriber list marketing marketing consultant works together with providers to develop in addition to employ marketing and advertising practices. A lot of these techniques are usually focused on the actual heart of your organization and what exactly products and services they offer. Any advisor facilitates create a specific marketing program, identify this internet marketing message, <span class="plainlinks">[http://www.allaccentpillows.com/ <span style="color:black;font-weight:normal; text-decoration:none!important; background:none!important; text-decoration:none;/*CITATION*/">internet marketing consultant</span>]</span> plus identify the perfect marketing and advertising incorporate to get the sales message available. They will and then keep to the strategy through, together with function to execute along with employ a marketing strategy. They can keep track of results, modify as important and ensure which the businesses provides the best results using their company marketing endeavors.
+e-mail:  chip@chiplynch.com
-An advertising and marketing advisor shall be expert as well as educated in buyer conduct plus promoting approach. This can include having the option to recognize adidas and puma audience as well as posture their product or service offering in ways that may attention clients to make these people are interested to buy.
+I am a data warehouse architect with expertise in the design, implementation, and maintenance of enterprise-scale business intelligence and data migration projects.  I have led teams of people through every phase of Data Warehouse creation, and I can 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 Capabilities and Maturities Model (CMM) development lifecycle standards, where I've learned processes for running organized, repeatable and successful data warehousing projects.  I have personally designed data models, built ETL and reporting architecture, and administered databases and application servers.
+DOD Clearance:  Top-Secret
-A great internet marketing advisor will be able to but not only assume creatively nevertheless analytically. They ought to be able to not merely be inventive, nevertheless in order to achieve is a result of that will imagination. Marketing consultants normally concentrate on distinct areas around marketing and advertising just like:
+Experience:<br>
-Internet promotion
+Wright Patterson Air Force Base	Dayton, OH,
-Copy writing
+Data Warehouse Contractor (2003-Present)<br>
+<i>US Air Force, GLSC Project, December 2010 – Present</i>
+* Performed systems and network analysis, visualizations, and requirements planning for an IT assessment and Roadmap of GLSC owned and managed systems
+<i>US Air Force, ECSS Project, August 2008 - December 2010</i>
+* Technical lead for several of the Data Management Organization’s initiatives, including Master Data Maintenance, Metrics and Monitoring, Business Rule Consolidation, Data Acquisition and Archival, and other data quality focused products
+* Team lead for a Business Intelligence study, which focused on architecting methods to bridge data from hundreds of legacy systems and existing reporting with the new policies, procedures, and data introduced by the ERP. The design stretches from high level governance and policy issues to technical BI architecture and enterprise warehouse design
+* Performed in depth data analysis as team lead for a Master Data pilot, resulting in methodologies for ongoing analysis, quality monitoring, and specific recommendations on trouble areas for data migration to the Oracle ERP
+<i>US Air Force, Data Warehouse, June 2003 – August 2008</i>
+* Performed as the technical team lead for a development team, which integrated over 50 maintenance, supply, logistics, and asset systems into the data warehouse including D043, D200A, D035A, D035K, and G100
+* 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, and ongoing maintenance
+* Supported and designed the development of various versions of Oracle, WebSphere MQ, Business Objects, Cognos, Informatica, and Teradata in a closely integrated environment
-Strong Email
-Promotion experts regularly go his or her enterprises as well as get the job done for yourself or simply in your marketing team. They may be qualified during promotion, business, marketing communications together with therapy.
+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 Postal's 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)
-Secrets to any high-impact marketing and advertising plan is to help optimize your own limited spending budget. The one-time airwaves advert overwhelm, smooth catalog, or perhaps flash-enabled internet site will begin to deteriorate the cost together with derail your promoting plans. Apply low-budget promoting to have your current meaning seem to your visitors fairly often, and watch sales sales increase.
+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 DBA work, Informatica and Cognos design, development, and performance tuning.  Also administered large 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.
-There are plenty of main reasons why a good low-budget marketing and advertising plan's extremely important to get small enterprise in the present marketing full society:
+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)
-High-priced offer exposure will not actually change in order to greater revenue. Only check with Excellent Dish marketer Pet.org, whose sock puppet industrial would be a attack along with individuals, but remaining the business down and out. Every last advertising and marketing bill used up must build a very good go back around sales and profits.
+Dahlgren Naval Base, Dahlgren, VA (as needed, 1999-2000)
-The goal customers really need to notice an individual's marketing and advertising announcements at least Several situations that will have an impact on a good buying decision. Using marketing and advertising & gross sales tactics outdoors your finances, would not enable you to perform repeatedly your current sales message typically enough to make a positive change.
+Wright Patterson Air Force Base, Dayton, OH (Summer, 1998)
-Promoting effects is usually drastically better by using various marketing and advertising programmes. Prospects will more than likely come to be buyers when they: read about your small business in the newspapers, attend a course, gather a catalog, in addition to visit your online business site. The actual even further you'll be able to "stretch ones advertising and marketing dollars" to arrive at your current market you work in during a number of programs, the higher the effects of the internet marketing meaning.
+Oakland County, Michigan (Sept. 2001-Feb. 2002)
-Low-Budget High-Impact Promoting Approach Solutions
+Other Work Experience:<br>
-Obtain a Piggyback: Hitching a cruise within the advertising and marketing of another provider will save your small business some time to capital. When personal pc reseller company, Pc Return, wanted solutions to accomplish amount conscious individuals with a cheap, the organization put into practice Wal-Mart availabilities. Wal-Mart`s significant spending budget advertising and marketing department will meticulously select the brand new keep openings in accordance with demographics as well as other high priced study. Online Trade opened outlets near Wal-Mart conserving real-estate choice expenses together with piggy support about Wal-Mart`s marketing plan.
+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!
-Find the proper Concentrate on: A significant section of the promotion plan's great for people proper buyer. For a low-budget high-impact marketing plan to deliver the results, discover customers who will be very easy to discover together with cost effective to arrive at.
+Education
+Xavier University
+Cincinnati, Ohio
+* Double Bachelor's of Science in Mathematics and Computer Science
-Forget about the store bought and opt for smaller niches. For example, area, huge certain breed dog followers can be reached by way of organizations, special exhibits, as well as aimed journals. Hitting every dog owner shall be unproductive thanks to minimal visibility along with increased costs of marketing with huge books.
+Technical Experience
+Extensive/Up-To-Date Knowledge of
+* Data Warehousing best practices
+* SEI/CMM project lifecycle management standards
+* Informatica PowerCenter (w/PowerConnect for SAP/DB2)
+* 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
+* Desktop Publishing
+Working Knowledge of
+* Microstrategy, Brio, Holos, Crystal Reports
-Get yourself Reports Acceptable: A good mention of your business in the suitable media channels may also help deliver a person's promotion sales message inside of a low price approach. My plumbing company provides overcome light beer self-promotion. If a son's or daughter's red-colored lorry had been stolen, "Pete The actual Plumber" turned up in their Super-Hero displayed lorry to have a completely new chariot for the child. Rrt had been a good deed; contributing to plenty of media talk.
+* SAP R/3: ABAP and HR InfoTypes
+* Microsoft SQL Server
+* Apple Macintosh OS, OpenVMS
+* Sun, Hewlett-Packard, IBM, and Digital Hardware`
-Variety some pot Venture: Synovial endeavors are far too strong designed for independent business to disregard. Developing an connections which has a selection of small corporations or a sizeable enterprise can provide your marketing and advertising program the final "bang for any dollar." A joint opportunity is going to reduce rates, helping you to enter new markets and build completely new supply choices.
+* DCL, Pascal, C, C++
+* PGP, Numerical Cryptographic Theory, System Security
+* Numerous other software packages, feel free to ask
-Capitalize on Referrals: Probably the most cost-effective means of reaching potential customers is actually by recommendations from content consumers. The completely satisfied prospect revealing to other people concerning your enterprise is more effective as compared to every fancy advertisement campaign. Spend an afternoon to receive purchaser contacts weekly.
-These are merely some of lots of methods and techniques used by online business to develop a high-impact promoting look forward to some sort of low-budget. Marketing and advertising being successful emanates from inventiveness; certainly not from obtaining the greatest funds

Chip's Resume: Difference between revisions

Revision as of 17:33, 2 August 2012

Navigation menu

Search