William Entriken, portfolio

Portfolio by topic

software design

leadership

engineering

finance

statistical analysis

Technologies used: IBM Cognos Planning, Oracle 10i, Excel
Team size: 1 project lead, 1 designer, 3 developers, 10 testers, 80 users
Implementation: Designed a company-wide budgeting and forecasting system, selected and managed contractors and remained accountable to users for a working system. The largest challenge was switching to a unified system from Excel, which allowed custom calculations for revenue recognition, expense calendarization, and taxes. This required detailed requirements gathering from international users and participation from many users in reviewing the design.
Notable metrics: 80 "systems" replaced with the new product, 24+ server hours needed for each model change (parallelized with 3 servers), $1 billion in revenue budgeted using this system
Relevant links: Positive project review on LinkedIn (FOLLOW UP WITH AMAR)

Technologies used: IBM Cognos Report Studio, SAP Crystal Reports, Oracle 10i, Excel
Team size: 1 project lead/designer, 3 developers, 10 users
Implementation: Managed migration and consolidation of management reporting systems. Worked in data warehouse with Oracle to transform and connect separate systems, lead requirements process and user acceptance testing to ensure product is delivered as expected.
Notable metrics: 24 new reports created from disparate business requirements, XXX development hours logged to the project, live data consolidation from 3 separate systems
Relevant links: Positive project review on LinkedIn (FOLLOW UP TOM)

Technologies used: Excel, Zoomerang
Team size: 1 lead analyst/editor, 30 content contributors developers
Implementation: Lead analysis of operational best practices including surveys, interviews and psychological profiles of hundreds of top employees. Create comprehensive report with widespread distribution and presentation at global conferences.
Notable metrics: 400 survey participants, 300 independently-owned offices involved
Relevant links: N/A

Technologies used: SONET, OC-192, CISCO 15000 ONS Platform, EXFO Test Equipment
Team size: 3 engineers, 3 vendors
Implementation: Designed, selected vendors for and built 10 GBit/s optical communication network. The end product was network laboratory for running Ethernet and SONET services over Discovery products integrated with CISCO networks. Efforts included selecting components, validating the lab design and assembling the products when they arrived from wire splicing to programming. Challenges included limited parts availability and vendors without integration experience. This was handled by reading CISCO network design documentation and using the CISCO administrator forums.
Notable metrics: 10 Gbps network (transfer a full DVD in 30 seconds over hundreds of kilometers), total system retail value over $400k
Relevant links: Discovery Semiconductor's 10G system
CISCO ONS products

Technologies used: PHP, MySQL, Excel
Team size: 1 business lead/developer
Implementation: Collected historical rail on-time performance data for SEPTA's system of rail service over a period of 3 years. Performed statistical analysis of rail performance and created proposed schedule modifications for trains which have been consistently late. Results presented to XXXXXX with several modifications accepted. Working with another analyst who is using rail data to predict realtime metrics based on weather and other local factors.
Notable metrics: 1,000s of Philadelphians are riding trains each day with the affected schedule changes and are shaving 1-5 minutes off their transit time
Relevant links: Positive project review on LinkedIn (FOLLOW UP WITH MIKE)
Live demonstration (ask for password)
Maneesha Sane research on rail schedules (FOLLOW UP WITH MANEESHA)

Technologies used: Web browser, telephone
Team size: 1 business lead/analyst
Implementation: Led collaboration with the FBI, FINRA, SEC, and investment banks to identify and resolve security holes allowing unauthorized access to retail investors’ accounts. Less sensitive security exploits I have worked with are documented in the links below.
Notable metrics: Over one million investors were vulnerable to other people making fraudulent transactions on their behalf... and they'll never know
Relevant links: Security case study: Hole in SMS spam websites allows charges to arbitrary mobile numbers
LinkedIn privacy case study: Stealing private data from your address book
TD Ameritrade privacy case study: Selling your position information to a third party

Technologies used: VMEbus, ADA, C, DOS Batch, Perl
Team size: 12 engineers, 1 engineering apprentice
Implementation: Wrote and performed engineering test cases on ship networking and sensor systems. Used test case results to fix embedded software. Challenges included learning ADA, a specialized cousin of C for high-availability systems. To aid in this, I created a code documentation tool for ADA to track functions and code paths and aid in auditability.
Notable metrics: Over a million lines of code per ship. Each ship in the fleet has its own custom code base
Relevant links: NAVSEA Philadelphia

Technologies used: PHP, MySQL, Apache, Bash
Team size: 1 lead developer, 5 crazy patch writers, 2 consultants
Implementation: This is mature project since 2001 allowing people to run their own photo websites. The project goal is allow people to have control over their photos and run a gallery they can integrate with the rest of their website. Challenges include competition from free online services like flickr and the top open source project Gallery.
Notable metrics: Over ten years of steady releases
Relevant links: Camera Life project homepage

Project: 19 Questions, an online guessing game
Description: Related to my math and machine-learning interests, this projects demonstrates using bayesian math to solve practical problems (other than email classification!)
Relevant links: 19 Questions homepage
Research on the entropy function that makes this all possible

Research interest: Analysis of chess
Description: I am interested in parallel, exhaustive-search problems, this is one effort in that direction
Relevant links: John Tromp's Haskell program launched from our collaboration

Other: iPhone programming, economic analysis, finance
Description: I am currently teaching iOS classes and learning iPhone app development. Look out for updates as that project progresses.
Relevant links: Other projects on Google Code
Analysis of everything, my blog