Mark Rotundo
Rome,NY
Summary
Prudent Business Intelligence Analyst with 24 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
26
26
years of professional experience
Work History
Senior Business Intelligence Analyst
Community Bank System, Inc.
01.2011 - Current
- Responsible for designing and developing queries and scripts utilizing SSMS
- Maintain, develop, and enhance the existing data warehouse reports
- Develop vendor and client exports that meet specifications
- Perform quality checks on reports and exports to ensure exceptional quality
- Provide business users the data required for metrics and analysis.
Systems Analyst
Wilber National Bank
01.2010 - 01.2011
- Responsible for designing and developing T - SQL queries and scripts utilizing SSMS
- Implement, support and troubleshoot bank databases as assigned
- (Primarily Microsoft SQL Server) Implement, maintain and support Windows-based applications, including, but not limited to, new installations, updates and patches, interface creation and implementation, basic and advanced troubleshooting, vendor contracts, etc
- Represent IT in multifunctional projects and teams as required
- Maintain and support applications as assigned, including security administration, updates/testing as required, interface maintenance and other tasks as needed
- Provide escalated End-User support for IT related problems as required
- Responsible for developing, documenting and updating operational procedures.
Database Analyst
Human Technologies Corporation
01.2008 - 01.2010
- Responsible for designing and developing T - SQL queries and scripts utilizing SSMS
- Provide support for Finance, Manufacturing, Payroll, Mental Health Clinic and Sales
- Responsible for creating and maintaining Microsoft SQL Server financial reporting code
- Create and maintain Microsoft Access Databases
- Create and maintain Crystal Reports
- Lead Analyst for United States Forest Service Uniform Program
- Lead Analyst for Army Corps of Engineers Uniform Program.
Systems Analyst – Project Management
M and T Bank
01.2007 - 01.2008
- Maintain technical support for mainframe and distributed applications including Finance, Project Management Office, Compliance/Risk, Central Operations and Research with both internal and offshore staff
- Project Manager for special projects.
Assistant Vice President – Asset Quality
Partners Trust Bank
01.2005 - 01.2007
- Provide support for Finance, Credit Administration, Loan Operations, Deposit Operations and Compliance/Risk
- Create and maintain over 20 Microsoft Access databases that produced more than 1,000 custom reports annually
- Lead the Quarterly Allowance Meeting (Participants: Senior Executive Vice President and Chief Operating Officer
- Executive Vice President and Chief Credit Officer)
- Produce and defend the supporting documentation for the Quarterly Allowance Meeting
- Lead the Monthly Credit Quality Meeting
- Produce reports to help maintain the Commercial Loan portfolio
- Generate various Board Reports
- Review and provide analysis of audits, both internal and external
- Produce monthly regulatory reports for the Office of Thrift Supervision.
Data Warehouse Administrator / Analyst
Partners Trust Bank
01.2004 - 01.2005
- Responsible for data warehouse report development
- Create and maintain Microsoft Access Databases
- Produce monthly regulatory reports for the Office of Thrift Supervision
- Provide support for Finance, Credit Administration, Loan Operations, Deposit Operations and Compliance/Risk
- Review and provide analysis of audits, both internal and external
- Responsible for developing, documenting and updating operational procedures.
Systems Analyst
Affiliated Computer Services
01.1998 - 01.2004
- Provide Management reports
- Create and maintain Microsoft Access Databases
- Provide support for various departments
- Provide technical training to staff
- Review and provide analysis of audits, both internal and external
- Responsible for developing, documenting and updating operational procedures.
Education
A.A.S. Communications -
Herkimer County Community College
Herkimer, NY01.1989
Skills
- Possess technical proficiency with Microsoft SQL Server, Microsoft Access, Excel, Word
- Custom Reporting
- Trend Analysis
- Data Operations
References
Steve Petronella, Database Administrator, Mohawk Regional Information Center, (315) 527-2653 Joshua Rodgers, Finance Team Leader, Community Bank, (315) 420-1375 Mark Shimer, Tax Accountant Supervisor, Community Bank, (315) 345-9603
Timeline
Senior Business Intelligence Analyst
Community Bank System, Inc.
01.2011 - Current
Systems Analyst
Wilber National Bank
01.2010 - 01.2011
Database Analyst
Human Technologies Corporation
01.2008 - 01.2010
Systems Analyst – Project Management
M and T Bank
01.2007 - 01.2008
Assistant Vice President – Asset Quality
Partners Trust Bank
01.2005 - 01.2007
Data Warehouse Administrator / Analyst
Partners Trust Bank
01.2004 - 01.2005
Systems Analyst
Affiliated Computer Services
01.1998 - 01.2004
A.A.S. Communications -
Herkimer County Community College
Similar Profiles
Julie RoeskeJulie Roeske
Bank Customer Service Representative at Community Bank System Inc.Bank Customer Service Representative at Community Bank System Inc.
Mary MartinelliMary Martinelli
Senior Systems Analyst at Community Bank System Inc.Senior Systems Analyst at Community Bank System Inc.
Monica HarrisMonica Harris
Substance Use Treatment Director at Integrea Community Mental Health SystemSubstance Use Treatment Director at Integrea Community Mental Health System
Susan PawlikowskiSusan Pawlikowski
Assistant Mgr. at Rite AidAssistant Mgr. at Rite Aid
MacKenzie HiltsMacKenzie Hilts
Graphic Designer at A&P Master ImagesGraphic Designer at A&P Master Images