Todd Mclain Email & Phone Number

Pearland, TX, US

Paris La Défense, Île-de-France, FR

Paris, La Défense, FR

• Manager in IT team supporting energy trading and related risk management areas. This includes our ETRM system Aligne, various exchange interfaces (ICE/CME/Nodal), eConfirm reporting, nightly price feeds, overnight.
• Provided project management duties for various projects: Aligne upgrades, a Gas Scheduling system implementation, a data center migration, domain migrations, etc., building project plans, developing and maintaining.
• Lead monthly team meetings with the business, providing status on current projects underway, and working with them to set priorities for all future work. I introduced some Agile elements to this process, and our.
• Serve as technical lead in the setup, maintenance, and architectural decisions for our ETRM software Aligne, and the virtual servers it runs on, currently hosted on Nutanix hardware.
• Act as key liaison collaborating with infrastructure / dba groups on network and database issues, upgrades, technology migrations, environment changes and refreshes, etc.
• Handle external auditor requests and checks each year, as well as ensuring the team meets IT Compliance demands.

Software developer specializing in custom software, web development and application integration, primarily using.NET and other Microsoft technologies.

• Developed an integration process in SSIS that helped flow affiliate deals to ICE eConfirm as part of the company’s Dodd-Frank compliance effort
• Supported the Credit team, primarily their custom ASP.NET web application and SSRS reports

• Developed and supported an ASP.NET web site so association group owner can manage most all aspects of operations anywhere. Includes an action item list, a search feature for locating members, ability to.
• Streamlined and extended an existing e-mail messaging system to allow members to send millions of emails a month much more reliably using an ASP.NET solution written in C# and VB.NET. Added new console page to track.
• Supported company's public facing web sites and the virtual and physical servers that run them. Included all aspects of IIS and SQL Server administration, data replication and created a disaster recovery approach.

Houston, Texas, US

• Worked primarily on Trakker, software that supports their core business – growing fee income for financial institutions. It is desktop software, sometimes distributed, with a configurable backend database - Jet or SQL.
• Ported all code from the original version of Trakker written in Visual Basic 6 to Microsoft VB.Net and C#. Included completing and testing all screens, and helping to develop new architecture for the business and.
• Created an interface solution that allowed any number of Trakker workstations to communicate with a Symitar Episys host. It utilized.NET Remoting and a custom Windows service written in C#. Installed at dozens of.
• Developed comprehensive data migration tool from the original version of Trakker to the most recent.NET version using ADOX and SQL. Included thousands of lines of code, plus custom stored procedures and views.
• Dramatically sped up import process of checking accounts by applying transactions and streamlining code, improving speed roughly 95%. For some customers this meant running a process in three minutes instead of an hour.

Created a comprehensive patient application and SQL Server database for a cosmetic surgeon's office. Tracked inquiries, sales progress, and all aspects of surgical and spa services provided. Included a medical record export that allowed all information to be exported. An interactive UI allowed the doctor to mark up exactly where on the face filler work.

Helped a national medical organization create and deliver to its doctors a Best Practices database that was ultimately used throughout the country. Allowed users to track every detail of a hair restoration surgery. Statistical reports allowed doctors to see how their approaches where similar or different from others throughout the organization.

Helped the company with a divestiture of oil and gas assets by providing relevant information to potential investors. Automated the reporting of financial information to Excel with a custom solution developed in Access, using dozens of queries and VBA.

Irving, Texas, US

Key developer on three different projects - 1) Counterparty - a repository of customer/supplier data, 2) Rocket - integration of Trading and Scheduling, and 3) Retail Power – a LodeStar implementation.* Developed Counterparty’s outgoing and incoming interfaces. The publisher allows the application to communicate data changes via Tibco messaging to several.

London, England, GB

* Sole developer on the Shell/Texaco Alliance Y2K Command Center web application that was used throughout the nation during the Y2K rollover period. The application supported both SQL Server and Oracle, in case one I had a Y2K problem.* Created other applications and web applications for searching, reporting, and updating various Y2K-related databases.

* Developed and maintained three independent web search engines using ASP, JavaScript, and SQL Server, so car dealers could better market their inventory. Added admin functionality for customers, which allowed the editing of photos and sales promotions online.

London, England, GB

* Performed various database development and VBA programming duties for the A & D department in a $1.9 billion divestiture of assets. By meeting its numerous information requirements, the group saved millions of dollars.* Created an Access front-end to periodically download and summarize data from an Oracle database to exactly match the financial results.

Newark, New Jersey, US

Designed several applications that effectively tracked the receipt of several thousand medical documents, the subsequent audit of over two thousand claims, check-in/check-out tracking of medical document files, and a comprehensive on-line questionnaire used by auditors to detect overpayments in reviewed claims.

Miami Lakes, FL, US

Credit Analyst creating professional reports for loan review. Began working extensively with databases at this time. Created a spreadsheet based Credit Analysis tool to exactly match results produced by a commercial solution.

Mba

Bba, Finance