Michael Alonzo Email & Phone Number

White Plains, Ny, Us

White Plains, Ny, Us

Minneapolis, Minnesota, United States

Optimize business processes to ensure effective delivery of services to airport tenants and stakeholdersDeliver efficient tools and workflows for use by operational teamsFocus on continuous improvement of core servicesServe as key conduit between business teams and IT teams

St Paul, Minnesota, United States

Design custom SQL queries and collaborate with end-users to conceptualize, design, and test new SQL reports. Conduct ad-hoc analyses to provide actionable insights.Serve as the a business analyst for NextGen business reporting processes.Lead cross-functional teams in gathering detailed business requirements to align system capabilities with business needs.Collaborate closely with various departments to implement reporting improvements.

Las Vegas, Nevada, United States

Aviation StatisticsUse a consultative process to work with end-users to determine what reports are needed. I then work with our Information Systems department to establish access to the correct databases. Once I have access to data, I connect to the database to extract the data. The data is then transformed using Power Pivot in Excel/Power BI. The data is then loaded into the data model. I create formulas to analyze performance over time. I then create the visual presentation to… Show more Aviation StatisticsUse a consultative process to work with end-users to determine what reports are needed. I then work with our Information Systems department to establish access to the correct databases. Once I have access to data, I connect to the database to extract the data. The data is then transformed using Power Pivot in Excel/Power BI. The data is then loaded into the data model. I create formulas to analyze performance over time. I then create the visual presentation to communicate my findings. I also include documentation explain some of the features in the report as well as notes on how to update the reports.Oversee collection of operating activity reports from airlines for statistical reporting and complex, highly technical statistical analysis. Submit reports in compliance with federal requirements for FAA reports and TSA grants.Reports are published at https://www.mccarran.com/Business/Statistics Show less

Mccarran International Airport

Accounts Receivable AccountantIn my current position, I lead a small team responsible for billing, tracking and collecting over $540 million in operating revenue. This role allows for extensive interaction with internal customers to determine the proper course of action needed to ensure timely collection of amounts due and compliance with the terms and conditions set forth in over 1,100 active tenant contracts. It also requires interaction with employees of airlines and airport tenants.… Show more Accounts Receivable AccountantIn my current position, I lead a small team responsible for billing, tracking and collecting over $540 million in operating revenue. This role allows for extensive interaction with internal customers to determine the proper course of action needed to ensure timely collection of amounts due and compliance with the terms and conditions set forth in over 1,100 active tenant contracts. It also requires interaction with employees of airlines and airport tenants. This position requires the use of Power BI, PROPworks, Discoverer, SAP, Crystal Reports and Microsoft Excel and Microsoft Word.Aviation StatisticsOversee collection of operating activity reports from airlines for statistical reporting and complex, highly technical statistical analysisReports are published at https://www.mccarran.com/Business/Statistics Submit reports in compliance with federal requirements for FAA reports and TSA grants Show less

Mccarran International Airport

Aviation Contract SpecialistIn this role, I drafted, reviewed and enforced aviation support operating permits issued to appoximately 38 aviation support companies providing services to the Airlines operating at McCarran. The position provided further knowledge and experience in establishing and cultivating relationships with airport tenants, airport staff and airline personnel. Knowledge of PROPworks, Discoverer and Microsoft Office were very useful in this role.

Mccarran International Airport

Passenger Facility Charges/General Ledger AccountantUpon completion of the Airport Management Intern Program, I obtained a career position as a Management Analyst in the Finance Division. In this role, I established a process to monitor receipt of approximately $80 million in PFC payments as well as airline and airport compliance with the Federal Aviation Administration’s Passenger Facility Charge (PFC) program. This required knowledge of PFC regulations (14 CFR Part 158) in order to… Show more Passenger Facility Charges/General Ledger AccountantUpon completion of the Airport Management Intern Program, I obtained a career position as a Management Analyst in the Finance Division. In this role, I established a process to monitor receipt of approximately $80 million in PFC payments as well as airline and airport compliance with the Federal Aviation Administration’s Passenger Facility Charge (PFC) program. This required knowledge of PFC regulations (14 CFR Part 158) in order to determine the payments and reports due to the airport from the airlines. The role provided experience interacting with the airline community to obtain PFC reports, to provide Airport PFC reports to the airlines and to inform airlines of McCarran’s PFC applications. I also submitted PFC reports to the FAA.In addition to administration of McCarran’s PFC program, I also served as the department’s General Ledger Accountant. In this role, I was responsible for preparing journal entries, reconciling the department’s deposit and credit card accounts, and expense allocations and variance analyses. I also reconciled the deposit and credit card accounts for the General Aviation airports.These duties required knowledge of PROPworks, Discoverer, SAP, Crystal Reports and Microsoft Office. Show less

Mccarran International Airport

Airport Management InternThe two-year program provided a broad overview of the function of each unit of the Department of Aviation as well as the role of each unit within the larger organization. The internship also provided familiarity with the rules and regulations that apply to airport operations and awareness of the Airport’s relationships with its tenants and the community. Functional areas included: 1) Employee Services and Risk Management2) Public Affairs and… Show more Airport Management InternThe two-year program provided a broad overview of the function of each unit of the Department of Aviation as well as the role of each unit within the larger organization. The internship also provided familiarity with the rules and regulations that apply to airport operations and awareness of the Airport’s relationships with its tenants and the community. Functional areas included: 1) Employee Services and Risk Management2) Public Affairs and Marketing3) Security4) Terminal Operations5) Facilities6) General Aviation7) Information Systems8) Landside Operations9) Planning and Construction10) Airside Operations11) FinanceWhile serving as an Airport Management Intern, I also served as an on-call media liaison. This role required exercise of independent judgment when dealing with local and national media inquiries regarding incidents at the airport. Show less

Master Of Science (Ms), Accounting And Information Management

Postgraduate Certificate, Data Science And Business Analytics

Bachelor Of Science (Bs), Public Administration