Daniel Dion Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, Us

*Led design and development of new reporting solution for Fund Accounting business unit using DB2 Operational Data Store, Oracle Exadata Mart, Datastage ETL, Oracle PL/SQL Data Services, Crystal Reports, Internal Report Generation Engine and Front end. *Created High Level Technical Design document for all aspects of FA IDS Program including traceability matrix back to business requirements. *Created mappings for Data Services and reports for all designated reporting requirements including evolving to account for new requirements as they were provided.*Evaluated Operational Data Store and provided suggestions that effectively reduced footprint by over 6TB, eliminated data redundancy, and greatly improved data load times and model consistency.*Created Governance model to evaluate necessary columns and consistently apply to model(s) and reporting.*Created numerous logical business rules to effectively remedy source system errors across all entities where addressing at source was not deemed feasible. *Created better quality control mechanisms by improving available exception reporting, provided input into data quality initiatives and performed detailed data analysis of model characteristics and populated values to document defects. *Provided quality control on data loads, data services core reporting and client specific reporting by performing system, user acceptance and post-production install testing (in conjunction with Testing Center of Excellence).*Actively participated in all meetings revolving around IDS Program Governance and Project Management including roll-out strategies, release strategies, prioritization, cost and effort analysis, resourcing decisions, training, marketing, etc.*Demonstrated project results to external beta clients, internal management groups, internal operational staff, training, etc. to facilitate successful project roll-out.

Chicago, Illinois, Us

*Product Manager for Report Center the companies core reporting service for Corporate and Institutional clients.*Product Manager for several related reporting applications and services including Inbox, Secure E-mail, Report Scheduler, File Upload, and Report Generation Services.

Chicago, Illinois, Us

*Managed the development effort of the portal for wealth management clients - Wealth Passport. *Managed a team of up to 35 developers in varying capacities building the applications that Wealth Passport supports. This included streams of work with 3 different offshore providers. *Played an instrumental role in designing the data model and data load capabilities including the data mapping from all source systems (including external data aggregation). *Served as a system analyst and architect in building out the customizable reporting, document management, calendar, alerts, account, consolidation, net worth summary and partnership reporting capabilities.

Chicago, Illinois, Us

*Served as senior applications consultant role for Global Investor Passport development project. *Created the systems requirements, performed development tasks, and supported development for the Account Brief, Security Exposure, Easy Answers, Easy Event, Portfolio Review and Top Equities applications. *Played an important role in the development of the architecture of Global Investor Passport batch processing which produces data for all the core reporting portal applications.

Chicago, Illinois, Us

*Custom report writer wherein he developed custom financial reports for over 50 different large corporate and wealth management clients. *Primary business analyst on the Ford Foundation GLI conversion and coordinated all initial development of Department of Labor regulatory reporting and Fund Peek Through Reporting.

Chicago, Illinois, Us

*Became a founding member of the user acceptance testing group. *Served as the testing coordinator of the domestic trust system conversion, which was a critical bankwide initiative that moved clients from IMS based PAR/NCS reporting to DB2 based Management Reporting. *Also coordinated the testing of the Alerts project and was a key participant in the global trust system taxable conversion.

Chicago, Illinois, Us

*Started career at Northern Trust in CTARO as a Reporting Analyst. *Prepared and audited financial statements for large corporate clients including several Fortune 500 corps. *Promoted to a teamleader role where I managed the daily work of 10 reporting analysts servicing over 25 large corporate clients.

Masters, Information Systems

Bachelor Of Science, Finance