Mark Donnelly
Ballston Spa,NY
Summary
Accomplished and educated in the fields of IT and Finance. With a robust background at IBM, I excel in unifying disparate data structures and leading transformative IT projects. My expertise in data warehousing and adeptness in managing development cycles have driven significant improvements in data accuracy and processing times, showcasing my ability to blend technical acumen with strategic leadership.
Overview
31
31
years of professional experience
1
1
Certification
Work History
Enterprise Performance IW Data Architect
IBM
12.2019 - Current
- Unified disparate data structures and operating environments during initialization of newly-created, company-wide cloud-based Enterprise Performance Management Information Warehouse (IW).
- Led efforts that continually added new data content to the IW.
- Developed and delivered business information reporting solutions.
- Designed data models for complex analysis needs and better understanding/documentation of requirements.
- Gathered, defined and refined business requirements, led project design and oversaw implementation.
- Collaborated with worldwide teams of system architects, design analysts and others to understand business and division requirements.
- Ensured data accuracy through data testing and validation along with performance testing.
Services Finance Transformation Manager
IBM
01.2014 - 12.2019
- Managed a diverse team of business analysts in gathering and documenting business requirements, development and testing under guided by Agile methods.
- Provide support to the team including career development, coaching and assessments.
- Led a complex "follow-the-sun" IW transformation leading to more timely information for data stakeholders.
- Advised on projects that assessed products/offerings for profitability and subsequent decisions to support them.
- Analyzed processes for improvements leading to improved data accuracy and processing times.
- Designed solutions to automate previously manual processes including the reporting of currency impacts and under-performing Contracts.
Consulting US Federal Senior IT Architect/Manager
IBM
06.2009 - 01.2013
- Advised on and provided for the Architecture needs of the Federal Systems Support Team suite of financial applications including accounting, billing, labor recording and business intelligence tooling.
- Led tasks of ASCA (Application Systems Control and Auditability) certification of 7 FSST tools which remedied an internally imposed risk gap.
- Managed the preparation and responses to external and SOX compliance of applications and reporting.
- Led Disaster Recovery planning and walk-thru execution of processes.
Services Transformation Senior Architect
IBM
10.1999 - 06.2009
- Led I/T Architecture in Business metrics area with emphasis on Information Warehousing.
- Designed process to derive contract "Signings" and revenue "Backlog" information from static contract and project data given managers an automated way to see sales production and headlights to future revenue.
- Created the data architecture for Utilization metrics which captured the available hours of practitioners and compared it to their various categories of labor resulting in a more complete view of productivity for managerial decisions.
Business Analyst
IBM
06.1997 - 10.1999
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Documented and translated requirements to a team of developers implementing projects that would improve system efficiency and reliability.
- Mentored MBA hires and acted as a campus recruiter at college job fairs.
Graduate Assistantship
State University Of New York At Buffalo
09.1996 - 12.1996
- Provided guidance and training for Executive MBA students related to quantitative decision-making techniques, linear programming and simulations.
IM Expense Analyst Co-Op
Xerox Corporation
06.1996 - 08.1996
- Leveraged relational databases to create expense analyses for the identification of areas of inefficiencies and errors.
Treasurer and Vice President
Citizens Savings Bank (now M&T)
12.1993 - 03.1995
- Managed bank's fixed income portfolio and directed the budget and strategic planning functions.
- Helped correct inadequate Asset-Liability Management and investment policies resulting in an Office of Thrift Supervision upgrade of the bank's Liquidity/Interest Rate Risk and CAMELS rating from "unsatisfactory" to "outstanding".
- Introduced reverse repurchase agreements resulting in interest expense savings.
- Developed mortgage-backed security "what-if" shock simulations to better understand the future impact of potential market interest rate fluctuations on the balance sheet.
Education
MBA - MIS And Finance
State University If New York At Buffalo
Amherst, NY1997
Bachelor of Science - Business Administration
Le Moyne College
Syracuse, NY1984
Skills
- Data warehousing expertise
- Enterprise information architecture
- Requirements gathering and documentation
- Managing Development Cycles
- Data Modeling (ERwin, Visio, Infosphere, Sybase PD)
- SQL
- E-T-L
- Financial Techniques
Affiliations
- Who's Who of American Grad Students
- Beta Gamma Sigma
Certification
IBM Architecture Profession
Timeline
Enterprise Performance IW Data Architect
IBM
12.2019 - Current
Services Finance Transformation Manager
IBM
01.2014 - 12.2019
Consulting US Federal Senior IT Architect/Manager
IBM
06.2009 - 01.2013
Services Transformation Senior Architect
IBM
10.1999 - 06.2009
Business Analyst
IBM
06.1997 - 10.1999
Graduate Assistantship
State University Of New York At Buffalo
09.1996 - 12.1996
IM Expense Analyst Co-Op
Xerox Corporation
06.1996 - 08.1996
Treasurer and Vice President
Citizens Savings Bank (now M&T)
12.1993 - 03.1995
IBM Architecture Profession
MBA - MIS And Finance
State University If New York At Buffalo
Bachelor of Science - Business Administration
Le Moyne College
Similar Profiles
TOMMY HSUTOMMY HSU
Application Consultant at IBMApplication Consultant at IBM
Salem AsratSalem Asrat
Hardware Developer at IBMHardware Developer at IBM
Ardra Njattuvetty PrakasanArdra Njattuvetty Prakasan
Mainframe Application Developer at IBMMainframe Application Developer at IBM