Ryan Dobos Email & Phone Number

East Amherst, Ny, Us

Buffalo, New York, United States

Buffalo/Niagara, New York Area

Buffalo/Niagara, New York Area

Buffalo/Niagara, New York Area

Manage a team responsible for completing all reporting within the department as well as the management of all Access databases and SQL servers within the department. Oversee the migration of all departmental reporting from various areas within the bank into a centralized team. Performed an in-depth analysis of the reporting and MIS work completed within the department and presented a recommendation to management to consolidate onto a centralized team.

Buffalo/Niagara, New York Area

Developed and Maintained SQL servers responsible for housing sales data for the department. Created and modified SQL procedures to transform raw data into intelligent reporting for the sales force and management. Developed department-wide reporting to align with strategic goals of the department. Worked with business partners to ensure reporting needs are met and existing process and data align with expectations. Chaired a departmental Reporting Committee designed to analyze reporting completed within the department, such as what reports could be decommissioned and which were needed.

540 Crosspoint Parkway, Getzville, Ny 14068

Evaluated Citi internal applications to determine prospective toxic entitlements (employee access to an application that allows the possibility to commit fraud).Worked with business partners to ensure that toxic entitlements were revoked or justified and entitlement reviews were completed when due. Developed/maintained databases utilized for generating business specific reports detailing potentially toxic access and upcoming or overdue entitlement reviews. Identified areas of manual report generation and used Microsoft Access and Excel to automate processes leading to increased efficiency of 5% on a weekly basis and a reduction in manual errors. Managed offshore consulting employees who were responsible for the generation of reports utilized by the businesses. Ensured reporting was completed in a timely and accurate manner.

Accounting and Billing Operations, Management Information Systems (MIS)Built/maintained databases to complete daily, weekly, and monthly reporting for the Accounting, Billing, and Global Payment Operations (GPO) departments. Worked with Microsoft Access databases and Excel spreadsheets to compile statistics for the various departments. Learned Microsoft Access Visual Basic for Applications (VBA), Excel VBA, and Structured Query Language (SQL). Utilized these programs to increase productivity and to automate manual processes used in various departments; received management recognition for submitted and implemented process improvements. Assisted with the migration of multiple billing platforms onto a standardized, global billing system. Provided system data and completed testing to ensure the integrity of data during the migration. Completed an Operations Analyst Management Training Program involving specialized classes and the presentation of a process improvement project to senior management.

Coordinate and assisted research investigating the accuracy of eyewitness identification with varying pre-identification conditions. Read research articles, set-up experiments on the computer (and administer the experiment to subjects), create computer programs to run the research at other schools (using structured query language, SQL), gather and interpret research results. Presented our research at a science fair at Canisius College.

Coordinated and completed the migration of remote access platforms and controls within the organization. Worked with Excel spreadsheets to cross reference names with corresponding information on each sheet. Utilized the V-lookup function to accomplish this task. Learned the remote access procedures and supported a soft token migration project, where employees with blackberries would receive a token accessible via their blackberry. Assigned users specific token serial numbers and then helped them set-up this token. Worked on a document migration; reviewed documents ensuring they were up to date and in the proper format. Resolved data issues and moved these updated documents into an alternative site for document storage available to each department.; Work on updating documentation within the password recovery software of the corporation.

Investigate unionized employees who were in violation of institutional policies. Investigate complaints, either from management or customers, about the unionized employees of Roswell; cases range from simple issues, such as unauthorized breaks or not showing up for work, to performance or conduct issues. Review the information sent by the department, review timesheet information, request statements from employees, talk with supervisors and managers about issues that arise, and draft notification/penalty letters. Reviewed grievance hearing briefs for each major grievance since the inception of the Employee and Labor Relations office and sorted/recorded the information contained.

Assisted Special Agents and Support Staff within the Immigration and Customs Enforcement Department of DHS. Shadowed agents and assisted them in case related activity. Entered and transported sensitive data between offices/agents, assisted agents in the creation of brochures and guidelines for the internship, assisted in setting up firearm training and took part in firearm training and participated in software computer training.

Master Of Business Administration (Mba)

Bachelor Of Arts, Psychology