Mike Regan Email & Phone Number

Southborough, Ma, Us

Zug, Ch

Boston, Ma, Us

Boston, Ma, Us

Boston, Ma, Us

Boston, Ma, Us

• Developed multiple extract, transformation, and load processes using Oracle, IBM DB2, Sybase, and flat files as sources and targets for Informatica mappings.• Managed off-shore development workload and reviewed code and deliverables for a team of Informatica and Oracle developers.• Acted as the liaison between business users and technical resources, translating business requirements and needs into technical specifications.• Modified and enhanced existing data load processes for an internal mutual fund data warehouse, improving data reliability and reducing vendor costs.• Coded and tested numerous ad-hoc SQL queries to address business data needs.• Analyzed and prioritized bug reports and business enhancement requests.• Planned and designed database, dashboards, and reports as components of an application to analyze the effectiveness of operational processing employees.• Contributed to the overall architecture and project management for a multi-year series of projects aimed at transforming operational systems and processes.

Boston, Ma, Us

• Designed and developed extensions to vendor application to add transaction functionality using industry standard SWIFT format and Ascential Datastage. • Managed and conducted SWIFT cash management testing with internal business partners, external customers, and banks.• Coordinated major application and database software upgrade for distributed transaction system with UNIX, Oracle, Sybase, and Windows 2000 software components.• Managed application performance testing for web-based transaction and reporting system.• Provided on call and off hours support to ensure application functionality and availability.• Analyzed and recoded Oracle stored procedures and indexes to reduce response time and improve user experience.• Conducted prototype testing of Business Objects Web Intelligence reporting as potential new functionality for an existing application.• Designed, developed, and supported batch data processing applications using BMC Control-M and UNIX shell scripts.• Earned prestigious World Class Award for personal performance and exemplary project delivery.

Boston, Ma, Us

• Led team of experienced Java, Informatica, and Oracle developers in planning, design, and construction of a database application with online query functionality.• Designed and developed Oracle stored procedure application for data extraction, including functionality to load only changed data to target database.• Modeled Oracle database and created stored procedure application for processing online insurance variable fund transactions and group value aggregation.• Investigated and modified database and report code to improve the performance of an online reporting application. • Modified and supported several batch applications with 24x7 uptime requirements.• Constructed and promoted Informatica data exception system as corporate best practice, resulting in wide reuse of code and cost savings to subsequent development projects.• Prototyped and implemented Trillium data cleansing software to improve data reliability.• Trained and mentored developers and analysts on application functionality, support tasks, and reporting.

Boston, Ma, Us

• Gathered business requirements, designed system specifications, and managed numerous projects under system development life cycle (SDLC) guidelines for project management.

Mba

Mba

Bs, Finance And Information Technology