SUMMARY

Experienced in the finance/banking industry. Manage the design, development, implementation and maintenance of a diverse number of systems Annuities, Order/Trade Entry, Trust Accounting, Credit Card, Securities Movement Systems, Global Custody, Risk Management, Brokerage Account, Portfoli Management, and 401K Retirement systems. Worked on both front-end .NET framework based processes and back-end mainframe. DBA work on both DB2 and MS SQL Server. Strong SDLC experience. Strong Vendor interface as well as offshore development. Experience managing migration/conversion projects. One of the implemented project was nominated and selected as a semifinalist for the 2007 Morgan Stanley North American Awards for Leadership and Excellence out of 155 nominees across the company.

PROFESSIONAL EXPERIENCE

Confidential

Project Lead

• Project Manager in the Corporate Systems area, leading a team of five onshore and one offshore resources. Responsible for distributed systems as well as for a mainframe based application.
• Manage all phases of application lifecycle for a distributed, MS SQL DB application Ariba/SmartSpend. The SmartSpend system is a complete spend management system that provides the Bank the ability t requisition goods or services, manage corporate cards, submit expense reports, invoicing, and analyze spend metrics.
• Responsible for a Web General Ledger application, this is a front end entry system t enter GL transactions. These batches are entered, approved, then submitted for processing by the FCS main GL system.
• Manage, enhancements and maintenance of Mainframe based Financial applications General Ledger, Accounts Payable and MIS. Cobol, CICS, DB2
• Manage the SQL Server backup/restore, DR, logging, and SSIS development support.

Confidential

VP Project Lead

• Mutual Fund Applications: Order Entry, Dividends, Trust Accounting, ACATS, Account and Asset Master Maintenance. Manage all phases of application lifecycle including requirements analysis, application design, construction, quality control testing, deployment and integration, troubleshooting, maintenance, and change management. COBOL, DB2, CICS. Lead 7 offshore resources and tw onsite PA.
• Successfully implemented an NFS conversion project, work focus on Master Account, Dividend Reinvestment Options and Tax Lots. Used COGNOS as reporting tool.
• Management, Analysis, Development and implementation of a Tax application migration from Paradox platform t MS SQL server platform using .NET C , Visual Studi as well as DBA work on MS SQL Server.
• Manage the SQL Server query tuning, backup/restore, logging, and development support.
• Manage regular DB maintenance including index optimization, consistency checks, and data file and transaction log size monitoring using built-in tools, custom written T-SQL scripts, SQL Agent Jobs, and Database Mail. Used SSMS,SSIS and SSRS.

Confidential

Project Manager

Manage all phases of application lifecycle for a Mutual Funds Application: including requirements analysis, application design, construction, quality control testing, deployment and integration, troubleshooting, maintenance, and change management. Deployed applications and developed scripts using XML and .NET framework. Lead 11 offshore resources and seven onsite PA. Mainframe COBOL,DB2,CICS and Distributed Environments.

Confidential

Project Manager - Consultant

Manage all phases of application lifecycle for an Aut Loan Application, including: requirements analysis, application design, construction, quality control testing, deployment and integration, troubleshooting, maintenance, and change management. Lead 7 offshore resources and one onsite PA.

Confidential

VP Project Manager

• Hands on IT Project manager in the Insurance and Annuities trading area. Managed 4 in-house and 8 offshore developers. Strong SDLC experience.
• Manage all phases of application lifecycle including requirements analysis, application design, construction, quality control testing, deployment and integration, troubleshooting, maintenance, and change management.
• Manage project plan, resource allocation, compliance and stakeholder expectations. Provide accurate status reporting and information regarding the ongoing work, risks and initiatives.
• Communicate with clients on all levels t accurately assess customer process needs and recommend efficient solutions. Recognized ability t support users and serve as liaison with system development groups.
• Proven ability t translate complex business requirements int functional specifications for developers. Business analysis and quality assurance expertise based on an in-depth understanding of application functionality.
• Successfully coordinate the work of geographically dispersed teams, including employees and vendors
• Designed, developed, implemented and supported a new annuities performance system. Developed all feeds from DTCC for more than 40 carriers: positions, revenue and Financial Activity Reporting FAR transactions.
• Led Design and development of compliance audit and liquidity reports for exchanges, subpays and new orders. Used DB2 triggers as part of system design for faster development, Stored Procedures and XML.
• Led initiative t enhance the Global Wealth Management Group GWMG Performance Reporting Application by enabling performance reporting for deferred and immediate annuity contracts.
• Contrived end-to-end process flow defined business rules underlying process flow overall project strategy and standard operating procedures SOP .
• Designed tools t reconcile changes in principal t corresponding financial transaction s and related deductions such as fees and taxes.
• Managed a CICS Web Transaction Server effort with COBOL and XML in a multi-layer platform.
• Engaged, developed, motivated, and managed a matrix project team of 80 individuals from 10 MS organizations and 10 insurance companies.
• Drove multi-year, full life-cycle program, t successful completion on schedule -- drop-dead schedule, despite ongoing org., project priority, personnel, technical, and procedural hurdles.

Confidential

Associate Director/Project Manager

• Project Manager in the Resource Management Account RMA area, leading a team of 5-8 developers.
• Demonstrated ability t manage multiple tasks, set priorities, achieve results, meet customer expectations and perform well under pressure
• Proactive problem solver with attentions t details, implementing solutions with careful consideration of the bottom line, long-range goals, feasibility and ease of use.
• Designed, development and maintenance of various efforts such as Credit card, Debit card processing, Credit card lost/stolen, credit card rewards and check processing.
• Led conversion of debit card processor from MasterCard t American Express in all SDLC phases.
• Interfaced and developed relationships with vendors such: FDR, Maritz and Clarke for Credit card, rewards and Check processing.
• Involved in the fine-tuning of DB2 Triggers and SQL predicates. Also, redesigned and converted VSAM systems t a DB2 platform.
• Played a key role in every CAI release with CRDB front end WEB driven system. This was a company Web enterprise system.
• Led in the reconciliation of non financial data between internal systems RMA, CAI, bookkeeping.

ILARION G. LARA Page Two

PROFESSIONAL EXPERIENCE

Confidential

Assistant Vice President/DBA/Team Leader /Associate

• Team member in projects such as Portfoli Management, Trust Accounting, Tax Lots, Profit/Loss Reporting, Interest Accrual Booking , Repurchase Agreements and Corporate Actions.
• Duties als include support for Db Trader's System Wide Tables. Involved in DB2 performance and tuning of SQL predicates and served as a technical support for team members. Als provided support t NewC France in all non-trade processing enhancements.
• Maintained and enhanced a Risk Management System, Coordinate UAT efforts between different platforms and provided 24/7 production support.
• Completed successful development effort of a 401k system, DCAPS Phase I. Set up daily batch production network, created data extracts for system interface and production support. Als assisted in production support, debugging and analysis.
• Served as DBA, extensive use of Platinum and Insight. Produced image copies, loads for disaster recovery jobs and created table, views, index DDLs for DB2 v4. Als developed index lists t support application programmers.

Confidential

Team Leader/Senior Programmer Analyst

• Team Leader responsible for the support of a Accounts Receivable ASI financial system, Interfaces with a Desktop client/server architecture system and overall production support.
• Developed programming, testing, turnover standards and institute program walkthrough policies.
• Performed analysis, coding and testing of DB2, CICS, COBOL II programs on a server environment. Worked on conversion of MVS COBOL programs t UNIX COBOL. Created Shell Scripts and tested programs using Microfocus in an UNIX RS6000 environment.

Confidential

Lead Programmer/Analyst

• Duties include analysis, development and enhancement of a Dividend Interest and Redemption system. Used of HPS case tool, C, COBOL II, DB2 and CICS.
• Heavy programming in development phase of project. Client/Server environment using HPS, worked on both client and server ends.
• Assumed hands on Team leader responsibilities through the development and test phase 3 staff . Als involved in staffing, set development standards and system performance tuning.

Confidential

Manager/Project Leader

• Technical Manager supporting Money Transfer System. Responsible for the maintenance of a CICS on-line system, troubleshooting, debugging and system tuning.
• Responsible for intra-day contingency plans of on-line and batch systems.
• Tested and successfully implemented ENET contingency package and DRS forward recovery software.
• Led the analysis, design, and development of a Blocked Accounts project. At that time, the Blocked Accounts project was key in the funds area of the banking industry.
• Used ANSI C, MicroFocus COBOL/CICS in an OS/2 workstation environment and Renaissance for software re-engineering.
• Led system conversion from OS/COBOL t VS COBOL II using CCCA.

ILARION G. LARA Page Three

PROFESSIONAL EXPERIENCE

Confidential

Team Leader - Assistant Vice President

• Experienced in the maintenance of fiduciary application programs, such as Cash Dividends, Stock dividends, Fees, and Daily Pricing
• Project leader responsible for the maintenance of a Global Custody system Dyatron . Analysis and design of system enhancements and supervision of a team of three P/A's. Als involved in the analysis and design of a DB2 Statement Reporting System, data element analysis and normalization.
• DBA duties, DB2 logical and physical, restores, backups, tuning, performance SQL review for access.
• Private Bank: Team leader responsibilities in the development of securities movement applications Commercial Paper and Mortgage Backed Securities. Duties als involved Implementation of VISTA SMS package, pending trades modules and development of a DTC interface,
• Design and developed an Estimated Tax System t comply with regulatory reporting
• Maintenance and enhancement of AIMS, a Trust Accounting Package, pending trades, corporate actions, fees, statements, performance measurement and pricing. Personally responsible for the analysis, design, programming, and maintenance of on-line and batch applications. Extensive use of CICS, VSAM and IMS databases.
• Used IMS/DB, CICS, Structure Cobol, COBOL II, Intertest facilities, created FOCMAST, FOCEXEC's Focus for quick data base reports, developed CLIST's t facilitate programming tasks.
• Developed functional specifications of interfaces between ULTRUS, a Trust Accounting system VAX and various IBM systems. Wrote prototype programs in MUMPS within a VAX VMS/DCL environment.

COMPUTER EXPERIENCE

HARDWARE:

IBM/3090, 3033, MVS/ESA, RS6000 AIX , VM/CMS, TSO, VMS/DCL.

SOFTWARE:

.NET C , Visual Studio, MS SQL Server, CICS, DB2, SQL, IMS, Platinum, COBOL II, UNIX, MS Visual Studio,. Web Server, JavaScript, Java, SYBASE, HTML, Forms, MQ series, VSAM, OS/JCL, COGNOS, Fileaid, Focus, Microsoft Project, Stored Procedures/Triggers.