C. Sean Stowers

Key Energy Services

System Analyst/Programmer

Master Data Management Hub is a Ruby on Rails system designed as a repository for hierarchy, employees, and assets. The Hub serves as the system of reference for all of the company’s non-transactional data.

• Designed and developed the Informatica ETL process from a Hyperion extract for hierarchical data.
• Created portions of the RESTful API.
• Developed Ruby validation script to ensure accurate hierarchical information.
• Designed and developed front-end for managing district-district manager association.

This project’s goals were to authenticate users from a variety of sources into several of the company’s systems. We used the Central Authentication Service (CAS) as the front-end for the authentication, and it aggregated Active Directory users and OpenLDAP users. This project streamlined application development by reducing the time to create the authentication and authorization system for each application. Another benefit is allowing all employees to utilize certain company resources. Before this project, only employees who had Active Directory accounts could be authenticated.

• Customized and deployed OpenLDAP server.
• Developed Ruby OpenLDAP load script.
• Customized and implemented CAS application.
• Designed and developed CAS gem (library) for all of our Ruby on Rails applications.
• Implemented company’s side of single sign-on for ADP Federation using a customized SimpleSAMLPHP implementation.

Alfresco is a centralized document management solution Key is implementing to replace several other, non-integrated document management systems.

• Interviewed business and technical users and provided that information to the consultants.
• Developed Java library used by SOA team for uploading documents, creating folders, updating meta-data, and other functions as needed.
• Developing a Ruby gem for use in Rails application to handle similar functions as library for SOA team.
• Designed and implemented custom meta-data.
• Administered system.

• Administered MySQL databases, Subversion repository, internal portal, chat server, and wiki server.
• Designed and developed the proof of concept front-end UI for a simplified AFE approval process using Rails.
• Customized team servers once built by the infrastructure team.
• Developed ancillary services for stock price and news for internal portal using Ruby scripts.
• Consulted on a variety of Ruby on Rails projects.
• Developed equipment forms using framework based on Java Struts.

Dawson Geophyiscal Services

Accounting Intern

• Designed and developed web-based incident reporting system using ASP.NET MVC 2, C#, and SQL Server.
• Developed macros to combine and summarize multiple spreadsheets.

• Prepared monthly lease journal entries and reconciliations.
• Prepared lease obligation schedule for quarterly and yearly financial statements.
• Prepared variance analyses for auditors.
• Prepared memo regarding company’s investments.
• Researched various accounting topics such as capital leases (and the upcoming lease changes), acquisition accounting, and financial statement presentation.
• Performed Sarbanes-Oxley testing and review.
• Helped prepare franchise tax accrual entries.

American Century Investments

Fund Accounting IT Intern

Migrated Fund Accounting databases from Access 97 to Access 2002. Added functionality to several databases and coordinated rollout of Access 2002.

Developed Access databases that saved over 30 manhours per month and $20,000 per year. Designed several new Access databases to automate portions of Fund Accounting’s end of month procedures. Created a new business process to track efficiency and effectiveness of banks and brokers.