Alan Miles Email & Phone Number

Pleasanton, Ca, Us

Lake Oswego, Or, Us

As a member of the Professional Services Organization, I am responsible for managing third-party legacy data imports/exports and HRIS integrations and updates/changes to current customer solutions as a component of our implementation process. This role will engage with clients and internal NAVEX technical, implementation and consulting resources to ensure seamless migration/integration into our application(s).• Manages and performs customer data mappings, transformations and data loads.• Configures and implements data integration between customer and non-customer databases/applications.• Assists Business units with new Client integration and configuration.• Perform quality tests to confirm data integration success• Analyze, develop and maintain integration processes, procedures and requirements (i.e. HRIS, ETL, etc)• Create template or custom reports based on client needs• Provide technical assistance to customers implementing our solutions; participate in customer design and process reviews and assist customers with data mapping transformations• Write code samples, tutorials, content as needed• Scope work orders and/or work requests and provide professionally written Statement of Work language• Perform job responsibilities in a project focused, deadline-driven methodology, with time tracking and management of customer projects as needed and guided by our project principles• Conduct client meetings to ensure proper configuration of software to meet business needs• Customer satisfaction and client-facing skills are critical to this role

Portland, Or, Us

Supported and enhanced extensibility to the Banner ERP system in the HR, payroll, finance, grants, budget, and student module areas.• Performed extensive troubleshooting of systems to resolve programming, workflow and data integrity issues.• Designed and programmed solutions with shell and SQL scripts to automate processes and run reports.• Extensively used SQL to analyze complex data sets from multiple sources, perform data modeling, and create data manipulation language (DML) and data definition language (DDL).• Researched vendor knowledge-base and system-wide documentation for upgrades to resolve flaws, and ensured compliance with regulations.• Evaluated and assigned appropriate application-level security for the Banner ERP system in all modules.• Provided assistance and training to partners in the setup and use of products, services, and reports.Supported third-party interfaces to the Banner ERP system.• Loading and extracting data; student degree auditing (DARS/redLantern); fitness center; parking services; student non-credit; housing; health services; CashNet (payment processing); eVisions FormFusion.Thoroughly documented requirements, issues, and solutions through case management ticketing systems.• Consulted with SME (subject matter experts) to obtain business requirements, and validated testing results.• Communicated project statuses and remedies to partners and departmental management in online systems.

San Marcos, Ca, Us

Became the principal analyst fulfilling reporting requirements for the organization to state and federal agencies, as well as presenting to broader audiences.• Extensively used SQL to analyze complex data sets, perform data modeling, and data manipulation.• Created database objects in SQL and PL/SQL utilized in statistical analysis and report creation.• Ensured a high level of data integrity through constant auditing, and recommended process improvements.Accepted additional responsibilities as a member of the BI (Business Intelligence) team.• Performed ETL (extract, transform and load) and report development with SSRS/SSIS in the data warehouse.Proactively supported ERP systems, and was instrumental in implementing PeopleSoft ahead of schedule.• Performed fit-gap analysis between the ERP systems to maintain and enhance business functionality.• Critical member of a cross-functional project team to convert to and configure the PeopleSoft ERP system.• Reviewed vendor and system-wide documentation for upgrades to resolve flaws and improve business usage.• Coordinated installation of software updates, and led testing efforts including developing test cases.• Evaluated and assigned appropriate application-level security for the enterprise and third-party applications.• Delivered assistance and training to partners in the setup and use of products, services, and reports.Implemented, in a team setting, and supported third-party interfaces to our ERP systems including:• Loading and extracting data; Document imaging, EDI, and OCR (Hershey/Hyland); student degree auditing (DARS/redLantern); library patron; health services system; CashNet (payment processing); eVisions FormFusion.Thoroughly documented requirements, issues, and resolutions through case management ticketing systems, and other network and online resources.• Solicited partner data requirements by interviewing users, performed user acceptance testing, and applied data standards.