• Design and implement data storage solution• Implement on-demand PowerBI Dashboarding in place of daily emailed reports• Reduction of email reporting by 40%• Warehousing of 60M+ records per week for dashboarding usage• Create automated business processes and ETL Pipelines using Alteryx, SSIS and Python• Create and Maintain SQL Server Environments for historical research purposes• Compile data from 10+ track-side data sources and provide storage• Database maintenance and diagnostics for internal and externally owned data• Use of statistical modeling, track-side detectors and analytical tools to identify and monitor poor performing train components to provide input on internal and industry rules• Perform analysis on train components to determine viability and life expectancy• Research industry trends and apply knowledge to current data• Identify data quality problems, research and implement solutions

• Reduce server footprint by 90% while maintaining performant ETL processes• Create automated business processes and ETL Pipelines using Alteryx, SSIS and Python• Data Discovery and exploration initiatives to find relevant information assisting the Intermodal/Automotive Operations Division of Norfolk Southern• Compile data from 3 terminal applications to provide dwell tracking data at automotive terminals for Senior leadership consumption for daily decision making• Create and Maintain SQL Server Environments for historical data for Process & Analytics team in Intermodal Operations• Lead the Creation efforts for a Automotive Data Warehouse to streamline the decision making process and provide insightful analytics to business users• Lead cross-departmental projects to automate business process, reporting and data warehousing• Debug preexisting and errored ETL pipelines and backfill where necessary• Create automated pricing models for Market Research and Forecasting using translated business logic from stakeholders, existing datasets, and trend analysis to provide active insight on product pricing and reduction of processing time by 85%• Aggregate large datasets to be used by stakeholders to make informed business decisions often moving upwards of 80M records across platforms• Successfully aggregate and restate historical data for Intermodal left behinds involving the aggregation of 6 data sources and 10M records• Create ETL Pipelines to stage data to provide internal users with the ability of developing self-serving analytics tools in Tableau• Create complex applications to perform analysis for external consumption• Maintain 85+ current ETL Processes on 6 SSIS Servers and 40+ Alteryx workflows• Perform database migration and consolidation used by Norfolk Southern IMAU's Operations team• Experience with Teradata, SQL, Alteryx, Python, Spotfire, Tableau as analytical tools• Work with team members to determine best storage solution for data needs

Leverages technical expertise in data and analytical tools to design and implement process improvement solutions for Revenue Accounting. These solutions will be used by the organization to improve efficiencies and make better decisions.• Project Management for internal projects and tasks• Process improvements using technology and data• Automate reports to eliminate manual effort• Research, develop and help drive large-scale solutions to improve performance• Data mining using various data sources• Create routine and ad-hoc reports for business partners• Compile, analyze, and validate financial data• Design and develop interactive dashboards and data solutions utilizing Python, SQL, Tableau, and other tools• Knowledge of Revenue Accounting data processes, systems, and data• Serve as a liaison between internal stakeholders and IT• Revenue Accounting Systems support, maintenance, and development• Work with IT partners on projects to support existing systems, improve processes, and eliminate manual work• Use current knowledge of business and technology in order to process, design, and present data in ways to help functional areas make better business decisions• Develop and maintain day-to-day relationships with internal and external (vendor) partners• Translate non-technical requirements into technical business requirements and vice versa• Routine tasks and audits for internal and external business partners, IT, and auditors

Position Purpose: Responsible for contract and lease management processing, compliance, and reporting.Unique Responsibilities: Process improvement and automation for tasks and reporting.Principal Duties:• Performs initial evaluation of corporate contracts and leases to determine appropriate accounting treatment in accordance with GAAP and regulatory guidelines.• Establishes lease payment and amortization schedules in lease accounting software• Manages the lease payment and amortization process.• Participates in process analysis, design, testing, and improvement of lease accounting software.• Performs general ledger account reporting, analysis, and reconciliation.• Prepares financial schedules and reports relating to leased assets in accordance with GAAP.• Ensures the business process compliance with accounting policy and internal controls.• Develops and maintains strong relationships with internal business partners (i.e. operations teams, FP&A, and others).• Drives process improvements and automation to improve efficiencies within the group.

Review leases for 842 compliance and provide a sub ledger to automate your month end lease accounting needs• Lease Accounting Expert• Manage a portfolio of 900+ lease for 50+ public and private clients to ensure compliance with GAAP, IFRS or GASB• Lease accounting consulting and guidance for regulatory bodies and compliance• Create and Review month end Journal Entries for clients• Perform reconciliation of lease data provided from clients to data in LeaseQuery • Reconcile data to ensure accuracy• Creation of a tool to automate the reconciliation process for lease data• Lead Public and Private companies through the implementation into LeaseQuery’s software while answering questions pertaining to the new accounting standards• Proposed and implemented 8 new time saving process in Q3 of 2019• Hold process improvement meetings with staff and present to department director and COO• Oversee a small team 3 - 5 and manage deadlines for the implementation process

Process ImprovementAutomation of Internal check request, expense report and marketing project request submissions via VBA ProgrammingAccounts Payable Not for profit Book Keeping - Silverton FoundationBank ReconciliationsAutomated editing for data for imports of various reports into the accounting softwareAssist with setup process of new branches Apply for Business Licenses within multiple jurisdictions Manage Vendors

A/P process improvement A/P entry, approvals, and paymentsHosted meeting with managers to alter manager approval processes for invoices Research past invoices for unclaimed property audit Research and assisted with recovery of $2 million in past due receivables Participated in build-of-material audits for multiple facilities

As the assistant manager I monitored inventory, receiving, and assisted in managing the team with day to day activities.