Mark Stratton Email & Phone Number

Greater Philadelphia Area

• Responsible for designing models to project future hardware requirements for a complex set of interrelated applications implemented over multiple operating environments. Developed a simulation tool to create monthly.
• Spearheaded the launch of a capacity database to collect and merge capacity estimates by application, application footprint data, data center raw capacity for compute, storage, and network usage along with VM.
• Developed over 30 dashboards and reports to provide daily monitoring of overall capacity utilization within the environment, key application implementation status as well as operational monitoring tools.

Raritan, NJ

• Provided project management tools using MS Access and VBA to replace a set of SharePoint based spreadsheets for several related infrastructure projects. The restructured approach provided controls to ensure data.
• Acted as project manager for several projects aimed at encouraging business units to retire or virtualize older servers. This involved developing standardized communications used by the project team with all the.

Ft. Washington PA

• Developed extensive data mapping and profiling tools to track data relationships, cross reference data transformations and reconcile data flows through data hand-offs across multiple databases and systems used for.
• Developed automated testing facilities to compare data extractions in multiple formats against each other and integrated these facilities with quality control procedures. This enabled the project team to deliver an.

• Developed and implemented techniques for portfolio construction and evaluation including efficient frontier analysis, non linear portfolio optimization, risk management and portfolio analytics.
• Designed a system to completely construct all required individual and composite performance reports for a group of over 400 managed accounts directly from a month-end data feed provided by the broker.

Ft Washington, PA

• Conducted stakeholder interviews, performed system and data analysis and implemented the new system including substantial VBA development.
• Restructured the system to provide multi-user functionality, simplify the data update functions across related tables and developed forecasting and scenario modeling.
• Responsible for re-engineering and expanding MS Access 2007 based database system to track ingredient and packaging specifications and supplier relationships for the firm's products.

Chicago

• Designed and implemented a fund administration system with extensive reporting capabilities using Microsoft Access as a front end to SQL Server.
• Responsible for all database development and data administration for a small start-up firm providing fund administration services to public and private commodity and hedge funds.
• Oversaw the data migration of all customer demographic and financial data from third party administrators into an in-house system.

Princeton, NJ

• Directed back office operations for both single and multi advisor hedge funds including preparation of customer statements and all tax filings
• Oversaw all IT operations with final reponsibility for budgeting, architectural and hardware selection. Designed and directed the implementation of in-house software and database systems used to provide back office.
• Spearheaded a project to automate daily account reconciliation, which included mapping data structures for transaction activity and account balances from the firm's in house portfolio management system to daily.
• Established a consulting relationship with a Futures Commission Merchant (FCM) to automate their daily checkout and balancing procedures including mapping of all transaction and account balance data between Beacon's.
• Oversaw the launch of a public commodity fund including preparation of the prospectus; development of distribution strategy; led sales effort to enroll broker-dealers in selling syndicate; provided oversight for audits.
• Negotiated with state regulators to secure “Blue Sky” fund registrations.