Ian Mcdaniel Email & Phone Number

Application Development Senior group manager -Data Services Platform, Strategy, Capabilities, Compliance and Tooling lead Head

Apps Development Project Manager/Vice President, Citi, Warren, NJ, May 2007 to PresentProject Manager within the Data Distribution Infrastructure division which facilitated and distributed data throughout the Institutional Clients Group. Ab Initio was used to process and distribute both real-time and batch data. A Data Access Layer built in Java was used for the request/response service which was provided to clients. • Responsibilities included managing the common message model design and mappings, data modeling, Ab Initio design, development, and implementation, and the integration with the Tibco Enterprise Service Bus, Oracle Operational Data Store and BEA Web Logic Teams.• Managed the DDI Global Stock Record Initiative, which provides a reusable data service of External Depository, Trade, Settlement, and Reference data to clients. This program resulted in visibility to Citibank’s external depository positions at DTC and Euroclear, improved data quality, legacy system retirement, and headcount reduction.• Managed the successful deployment of the Mortgage Products data service which provides real time asset indicative reference data for clients and eliminates point to point interfaces. • Managed the establishment of Data Access Layer framework created using Java which facilitated faster access, caching and distribution of Standing Settlement Instructions (SSIs) which are mandatory for timely trade settlement.

Ab Initio Subject Matter Expert for the Global Corporate Operation Technology and Equities departments responsible for overseeing and reviewing the Ab Initio ETL design, development and testing.• Lead Ab Initio designer and developer for various Citi projects within Risk Technology, Equities Technology, Compliance Technology, and Finance Technology. By assisting these technology groups, performance of newly developed processes was improved significantly by as much at 500% and development time was reduced by 50%.• Integrated Ab Initio with Tibco RV & Business Works, Staffware and Citi Bullet Framework.• Created custom re-useable Ab Initio components such as SCP-to, publishing/subscribing to Tibco RV using Java APIs and connecting to a Custom Java Application. This allowed for faster development time by developers who integrated these components.• Setup and deployed new Ab Initio Servers to create an Ab Initio clustered environment which helped improved performance of current processes and reduced CPU utilization.• Maintained and supported the Ab Initio Shared Technology Environment by coordinating upgrades, project on boarding and creating generic EME tagging and checkout scripts for users.

• Development cell leader which successfully delivered assigned AT&T Project Kaleidoscope components on time and under budget. It consisted of Transforming data from AT&T legacy systems into the Siebel ODS using Ab Initio This project encompassed the design, build, testing, and deployment phases of the SDLC. • Responsible for training, mentoring and managing a team of 6 Ab Initio developers onshore and offshore.• Serve as subject matter for Ab Initio related inquiries.• Review and Performance tune Ab Initio data transformation routines for various interfaces.

• Designed and developed the generic managers and common components used by the development team which reduced development time.• Assigned Development cell which consisted of two analysts who completed their assigned work ahead of schedule and under budget.• Developed most difficult process of the Customer Connect application which was the Project Create module.• Quickly promoted to Consultant for Exceptional Work and ability to assist all team members.• Constructed the schedule for the development and system test phases of Customer Connect.