Apply office management, SaaS tools and write communications to collaborate with civil service leaders on affairs that will serve the best interest of Transit's employees and its riders.

Employed precision, writing, and Excel to execute the necessary duties to support North America’s largest public transportation agency in combating terrorism.Daily interpreted the Security Command Center's radio, telephone, alarm, and email communications to expeditiously compose detail-oriented, reports. Dispatched the reports to various personnel, which includes executives, through email correspondence.Composed a monthly written and visual analysis about the amount and type of incidents the Security Command Center receives from the Transportation Security Operations Center. Presented findings to senior management.Utilized the alarm system to monitor possible, suspicious activity, and contacted the Stations and Police departments if necessary to prevent or mitigate this activity.Maintained effective integrated access management (IAMS) for multiple NYCT facilities with the assistance of Lenel.Performed both New York State Mandated employee and Federal Emergency Management Agency training.Supported the NYPD by providing transit footage and verifying qualifying information pertaining to criminal cases.Testified in District Attorney criminal court hearings on matters pertaining to evidence or graphic material obtained.

Advanced skills in Microsoft Access and Excel to aid North America’s largest public housing authority in analyzing budgetary, headcount, and Section 8 data in order to ensure that the Housing Authority maintains adequate funding to improve the lives of its residents.Conducted a full-time salary analysis (FTSA) bi-weekly for employees funded by Section 8 (Leased Housing). Updated the employee headcount in the FTSA spreadsheet with the assistance of payroll, and corrected the status of PARs (Personnel Action Requests) using HR's pipeline. Revised the year-to-date funds available for the designated departments using Hyperion reports.Continually used payroll, Hyperion Budgeting's headcount reports, and the information in the FTSA to complete PARs. Entered the PARs into a Microsoft Access database for the Assistant Director's approval.Partnered with a Deputy Director to obtain and analyze information about NYCHA's staff augmentation. Contacted department directors for information about their temporary staff. Consolidated the results into a single spreadsheet.Assisted in editing the 2017 - 2021 Budget Book by employing Budget's Operating Plan Narrative, executive summaries, Public Housing Authority (PHA) Annual Plans, and other supporting financial information.Routinely performed budget revisions through the NYCAPs job portal. Notified the requester of the status of the transaction(s) through email correspondence once completed.Helped maintain the monthly Budget Metrics Report by updating the monthly headcount, expenses, revenue variances, PARs, and flash figures.Received training in Budget's Capital Division. Learned about the vital steps NYCHA makes in order for NYC's OMB to approve the capital projects requested by NYCHA annually.Applied the use of Microsoft Smart view to assign PCNs (unique employee numbers) to vacant job positions added to the annual headcount (FY 2017 to FY 2021) for the needed responsibility centers (work locations).

Used knowledge of Microsoft Excel and SAP, a leading enterprise software that manages business and customer relations, to assist the largest cargo handler in North America in analyzing invoice and contract data to ensure that company records are accurate.

Used strength in Microsoft Excel to assist the busiest commuter railroad in the US in analyzing data, automating payroll processes and consolidating budgets to manage labor and overtime hours during a paid summer internship.Converted crew boards into Excel Pivot Tables to manage overtime assigned to employees during unplanned events.Consolidated monthly overtime/availability budget forecast and actual hours worked reports for Maintenance of Equipment and Stations (Customer Service) departments into one Excel spreadsheet; validated results with both departments to ensure accuracy of data and ease of use.Conducted a bench-marking study to provide a detailed analysis of how LIRR attrition rates compare to unemployment rates for both New York state and New York City. Collaborated with safety department officials of Liberty City Transit Authority (LTA) of Long Island to obtain employee injury records and analyze trends.Assisted Office of Management and Budget (OMB) in assembling a fact book to provide accurate information concerning various LIRR departments and associated processes and procedures. Attended a 2-hour training course in Hyperion, a leading software in business intelligence and performance management.