This wiki could serve a lot of folks including:

• People who want to remotely or locally run a web internship without too much formaility.
• Programmers looking for extra hands who can move your Drupal projects faster in exchange for some coordination and mentorship.
• Programmers on the management track looking to get experience with managing / outsourcing.
• Filipinos abroad looking for a general way to donate their expertise in computer science towards helping students in the Philippines

"You say you want a revolution? Well, you know, we all want to change the world." - The Beatles

Abstract:

The Cognitive Metaphors Filipino Web Internship program started in 2006 with one student. In 2009, I took on 5 students to continue to build out web communities that I am passionate about using the Drupal content management system. My overall motivation is to leverage my talents and eventually create opportunities for my family back home in the town of Plaridel, Bulacan, Philippines. My grandfather, Emilio Garcia, once served as Mayor of Plaridel during the Japanese occupation in WWII, 1945.

The following is a cookbook that I hope others will follow to promote interest in Computer Science in the Philippines. Please feel free to adapt these ideas to the communities that you are most passionate about. Young people need many more opportunities to apply significant hours of supervised practice if they are to become proficient in this craft. Malcom Gladwell's Outliers claims you need 10,000 hours of practice to be really good in any endeavor you wish to master.

--Anthony

Here's a lists of communities that are a part of me. I'm either actively involved in them now or grew up in them.

Conshohocken Catholic School - www.conshohockencatholic.org

Knights of Columbus - www.kofcconshohockencouncil1603.org

Conshohocken Little League - assistant coach

Montgomery County Special Olympics - Bowling coach - I grew up in bowling leagues and am happy to share my skills in this worthwhile program from Sept - Nov each year.

Joy And Care Giving Foundation and St. Anthony's Development Center - this is my mom's foundation and the school she built on land left to her sisters and her. The school serves underpriveleged children with a pre-school and soon to be 1st, 2nd, and adult vocational education.

The Philippine-American Civic and Cultural Community of Staten Island (

PACCCSI) - Grew up bowling on Saturday nights, Christmas parties, family parties.

Plaridel, Bulacan, Philippines - My grandfather was the mayor of this town during WWII around  the time of the Japanese occupation.

Rutgers / Comp Sci Department / English Department

Penn State Great Valley / Information Science Department

Saint Joseph's High School

Our Lady of Fatima Elementary School

Saint Joseph's Rosebank Elementary School

Drupal

Pentaho

I'll write more later. The idea is that to some extent, I am or plan to use the social networking skills I am building up .

I've just finished a great 3 day session at Drupalcon D.C. 2009. On a sad note, in the last hour of the conference I lost a gold cross pen that I bought on my first date with my wife. It had my name on it so my outside hope is that someone will look up "Anthony Garcia Drupalcon" and find my profile and contact me. Either way, I'll going to take the sentimental energy I had stored up in that pen and turn it into a lot of Drupal energy.

At the conference, I learned alot of new techniques to do cool things with data and Drupal and visualization, Integrate Drupal with Facebook,  my special interest in Education/Church sites, the business side of Drupal and more. I've met the Drupal luminaries. I especially was star struck by the Lullabot folks. Now, it's time to go back home to apply it. I thought I'd write up an action plan on practical ways I could apply what I've learned in short, medium, and long term ways. I'll put together a list below of things specific to what I am working on rather than made up stuff.

Anthony C. Garcia
Email: acgarcia21@yahoo.com
Home Office: (610) 397-0976

Summary

Over fifteen years of experience with the full software development life cycle spanning data modeling, data warehouse development, systems architecture, application development and business analysis. Lead responsibilities with implementing three multi-terabyte data warehouses for a world leading bank (financial industry), a regional transmission organization (energy industry), and a premier e-commerce outsourcing firm (retail industry). Responsibilities also included developing and conducting comprehensive software test plans. Also provided technical sales support, consulting, and seminars for a data warehouse software company. Experience spans several industries including Internet E-Commerce, Energy Market, Credit Card, Defense Logistics, and Medical Informatics.

Experience

01/2008-Present 3Touchpoints, Conshohocken, PA

Chief Operating Officer (07/2009 - Present)

• Provide infrastructure (office space, record keeping, and back end analytics reporting) needed to operate a web analytics company.
• Assist in forming service offerings including the incorporation of Six Sigma techniques.
• Assist in the web analytics based sales opportunities.
• Evangelize and accumulate subject matter expertise in the practical application of web analytics.

01/2008-Present NRG Energy, Princeton, NJ

Project Manager (09/2009 - Present)

• Work with my manager to develop a IT CORE development standards, project demand management, and to grow relationships and trust for our technical solutions.
• Provide project management, business systems analysis, and planning for the next generation of the risk management policy enforcement and market monitoring platform.
• Work with developers on the next iterations of our existing commercial operations and risk applications with an eye towards business transparency and self service.

Senior Business Systems Analyst (01/2008 - 08/2009)

• Support Finance, Risk, and Commercial Operations through data extraction architectures that take data from various energy markets, mix the data with internal transaction data, to build insight needed to run a complex business and compete on analytics.
• Built a series of coal logistics applications for tracking contract versus actual profit and loss and projecting inventory.

05/2006-Present Independent Consultant

• 3TouchPoints - Currently serving in the role of Chief Operating Officer in this start-up web analytics firm,
• AvenueARazorFish/Microsoft - Process automation of a internet search engine marketing keyword reporting process using Microsoft SSIS.
• NRG Energy - Business analysis and process automation of a coal trades settlements process using Microsoft SSIS, Fuelworx, Zainet, and EDX.
• Informant-Tech - Analytics solution for an innovative school safety applications using Pentaho.
• PJM Interconnection - Process analysis of existing systems in preparation for SOA based rearchitecture.
• Endasol - Built a prototype of an analytics solution from the energy market
• Home Decor Products - Data warehouse software training, process automation (price updates, product page creation), and third party product feed integration (ebay/shop.com) for this online seller of home products.
• Various Web Community Sites - With the help of my intern team, I am putting together several community based web sites using Drupal.

08/02-04/2006 GSICommerce, King of Prussia, PA
Manager, Enterprise Analytics

• Managed/mentored three data warehouse engineers in the daily operations of the GSI enterprise analytics portal.
• Participated in all phases of fulfilling reporting requirements for a partner launch.
• Mentored analysts to work within the SCRUM environment (an agile development methodology).
• Mentored analysts in estimation and creation of small projects.
• Assisted in the execution of a plan to migrate reporting from Oracle 8i to Oracle 10g.

Decision Support Systems Architect

• Developed process diagrams for partner reconciliation systems for gift certificates and gift card activity for finance.
• Provided finance with decision support systems used for Sarbanes Oxley (SOX) auditing of gift certificates and gift cards.
• Developed service level agreement compliance systems.
• Developed product margin reporting systems that merchandisers use to decide which products can be sold online for a profit.
• Developed inventory management reporting systems that business managers use to manage inventory levels for hot selling items.
• Provided full life cycle support for data warehouse ETL and Reporting platform which serves over 50 Fortune 500 company partners, executives, and business analysts.
• Participated in sprints (short term project requirements) and daily SCRUM meetings (quick cross functional collaboration) to execute small analytics projects needed for partner launches.

Data Analyst

• Performed data analysis activities which led to the data extraction, transformation, and load and report creation of a standard set of reports for GSI’s web retail partners and internal analysts.

08/00-07/2002 Sagent, Mountain View, CA Senior Regional Technical Manager

• Provided pre-sales engineering support to Sagent sales managers including corporate technical demonstrations as well as data warehousing expertise and adhoc product demonstrations as specified by prospective customers. Used SQL Server 2000 as the staging area for all custom demos.
• Scoped and implemented proof of concept projects demonstrating Sagent's ability to solve complex analytical problems for prospective customers. Developed process models.
• Provided post-sales engineering support and training to Sagent customers within the Eastern U.S. region.
• Built data extraction (ETL) and worked with data models and reports from a number of subject areas including: Sales, Marketing, Retail, Portfolio Analysis, Inventory Management, Energy Market, Pharmaceutical, and Clickstream Analysis

11/95- 08/2000 Walklett Group, Malvern, PA Principal Information Systems Consultant

• Internally, worked on proposals, a corporate web site, technical interview screens for C/Java, and assisted in marketing. 05/98-08/2000
• Lead a technical team to implement data acquisition for a data warehouse of telemetry and other enterprise data for a company that manages the electric grid in Pennsylvania, New Jersey, and Maryland.
• Used PERL to normalize mainframe data and the Sagent Solution to implement and automate data population for the data warehouse and several data marts.
• Took on multiple challenges including vendor technical support communications, standardizing procedures, training team members, and generally coming up with creative solutions to the customer’s problems. The resulting warehouse is targeted to be over a terabyte in size.
• Participated in data modeling meetings for constructing an operational data store to hold data from transactional systems and a datamart for reporting/scoring on federal energy reliability compliance.
• Maintained an elaborate Oracle PL/SQL procedure for extracting data from a volatile, real-time electric grid telemetry database.

05/98–07/98

• Designed operating procedures for population of a medical supplies sales/distribution data mart implementation. Provided instruction to customers in using Oracle Discoverer

11/95-04/98 Was part of the core team that constructed a sophisticated application that distilled 12 terabytes of credit card data to prepare several terabytes for loading into a data warehouse.

• Designed, Implemented, and Automated elements of an extraction, transformation, and loading architecture for a three-terabyte data warehouse for Citicorp.
• Used code generation of C++ through a CASE tool to implement data loading programs for DB2 UDB EEE.
• Used PERL to normalize data formats.
• Used Torrent Orchestrate to parallelize data loading jobs for this large credit card analytics data warehousing system on a 116-processor IBM SP2.
• Took part in both the pilot project and the full development cycle of the deliverable data warehouse including several months of initial data loading of the final implementation.

08/95-11/95 Independent Consultant

• Data conversion assignment using Informix for Infomed.
• Data conversion assignment using Oracle PL/SQL and Unix Shell for CSC/US DoD.

1/95 - 8/95 InfoMed, Princeton, NJ Database Programmer/Analyst

• Developed an optometry medical records system using Informix and PowerBuilder.
• Worked with customers for data conversion into our medical records products.
• Created course curriculum for MS Windows and Information Engineering.
• Evaluated data base products for possible use in InfoMed pilot projects.

7/93 - 12/94 General Research Corporation, Marlton, NJ Database Analyst

• Developed data import programs in C/UNIX/SQL and Oracle SQL*LOADER / SQL*PLUS / PL/SQL to map data into our client’s enterprise data model
• Provided faster SQL applications through Oracle 7 performance tuning.
• Developed a transaction monitoring tool in Ada for gauging the performance of a workflow and logistics system.
• Wrote step by step test scenario procedures for application demonstrations.
• Demonstrated GRC’s software design to consultants from a related DoD project.
• Organized and documented the stored procedure development process and data conversion procedures.

10/92 - 6/93 College Internships - Immedia, Martinsville, NJ & Merrill Lynch, Princeton, NJ

• Constructed and installed a legal litigation support system consisting of a text/image database using Zyindex and Calera OCR.
• Provided hardware support and documented the imaging system process.
• Provided SQL report writing, data base administration, documentation, hardware, and client training/support for the Strategic Performance Analysis Network (SPAN) which ranks Merrill financial consultant sales.
• Used Corel Draw and Word for documentation, SYBASE SQL Server tools and QMF for transaction monitoring and stored procedure analysis.

Education

• 1999 M.S., Pennsylvania State University, Great Valley, PA (Information Science).
• 1993 B.A., Rutgers College, Rutgers University, New Brunswick, NJ (Computer Science).
• 1993 B.A., Rutgers College, Rutgers University, New Brunswick, NJ (English).
• 2009 NRG Future IT Management Program
• 2009 Executive coaching - Debra Foreman - Pinstripecoaching.Com
• 2009 Six Sigma Greenbelt in IT Certificate - Villanova University
• 2009 Drupalcon D.C. 2009
• 2008 Introduction to Energy Trading and Hedging, Energy Management Institute
• 2008 How To Supervise, Coach, Confront and Help Your People Reach New Heights, John Formica Enterprises LLC
• 2007 Philadelphia PHP Meetup 2006 Philly On Rails Users Group (www.phillyonrails.org)
• 2004 Edward Tufte's Presenting Data and Information, Philadelphia, PA
• 2002 Philadelphia Java Users Group (www.phillyjug.com)
• 2000 Executive Presentation Skills - Communispond, New York, NY
• 1999 Microsoft SQL Server 7.0 Database Administration, Malvern, PA
• 1998 Cognos Training: Impromptu and Powerplay, Blue Bell, PA.
• 1995 Small Business Administration Certificate Courses - Mercer County College.
• 1995 Programming in 4GL - Powerbuilder Course - Mercer County College.
• 1994 Introduction to C++ - CorporateU.
• 1994 Client/Server Boot Camp - Data Base Server Systems.
• 1993 ML University Week – Classes on future trends, global markets and time management

Technology

• Methodology: Agile Development With Scrum
• Data Base Management Systems: Oracle 10g, DB2 Parallel Edition, Informix, Ingres, Interbase, MS SQL Server 2005, MS Access 2000, MySQL, Sybase. Data Base /
• Data Warehouse Tools: Cognos Impromptu and Powerplay,Crystal Reports, Powerbuilder 4.0, Oracle Discoverer, PL/SQL, SQL*PLUS, SQL*LOADER, SQL*FORMS, Informix Stored Procedures, ERWIN, Omniture, Pentaho Open Source BI, Powersoft Power Designer, Sagent Solution, CA DecisionBase.
• Languages: ASP, C, C++, HTML, Java (inc. Servlets), PERL, PHP, Ruby on Rails, SQL, UNIX Sed/Awk/Ksh,VBScript, XML/XSL.
• Software: Apache/Tomcat, Corda Pop Charts, Citrix Portal, Corel Draw, Endeca, Epiphany, IBM C-Set++,Borland JBuilder, MS Office, MS Project, MS Visio, MS Front Page,MS Visual Studio, MS IIS, NetBeans, Omniture, Adobe Go Live, Ascential Orchestrate, WebEx, Xitami Web Server, ProVision Business Process Modeling, Camtasia for Screencasts, netIQ Aegis.
• Content Management: Microsoft Sharepoint, Drupal, Kwizcom Wikiplus.
• Operating Platforms: Unix (AIX, Solaris, LINUX, MAC OS X), Windows XP/2003.

Awards

• Lockheed Martin Pride Award
• Walklett Group Technical Excellence
• GSI Commerce TEAM Impact Award
• NRG Energy STRIVE Award

Certifications

Small Business Administration Certification – Mercer County College

Community Service

• 2010 - Present Conshohocken Environmental Advisory Council
• 2006 - 2009 Assistant softball coach - Conshohocken Little League
• 2006 - Present Knights of Columbus
• 2006 - Present Bowling coach - Montgomery County Special Olympics
• 2006 - Present Web development in support of www.joyandcaregivingfoundation.org and www.foreigntraineddentists.org

References

Available upon request.