Mark Rotundo Email & Phone Number

Oneida, New York, United States

• 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.

Oneonta, New York, United States

• 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.

Utica, New York, United States

• 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.

Buffalo, New York, United States

• 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.

Utica, New York, United States

• 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.

Utica, New York, United States

• 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.

Utica, New York, United States

• 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.