Megan Walker Email & Phone Number

United States

Dayton, Ohio, United States

Part of a team supporting the Strategy & Innovation group at AFLMC/HIQD responsible for migrating data from legacy systems, storing it in a custom-built database, then gathering and applying business rules to the data so it can be ingested by an Oracle ERP application. • Load data received from legacy systems in various formats into project database.• Translate and document Subject Matter Expert's requirements into text-based business rules.• Convert business rules into SQL code and apply it to the data in the correct sequence.• Present results of business rules application to SMEs in meaningful format in order to validate and evolve the data and business rules into an acceptable data package.• Prepare the data to be ingested by the Oracle ERP application following the constraints imposed by the Target system.• Throughout the process use reporting tools to change the appearance of the query results as needed in order to be presentable to several audiences for validation.

Moraine, Ohio

Responsible for gathering requirements, researching, analyzing, designing, and developing data related solutions for tracking, reporting, updating, and delivering data per client specifications.• Research, analyze, design and develop database reporting, tracking, process automation and related database solutions in alignment with client requirements, project specifications and timelines.• Apply appraisal industry/systems knowledge and database knowledge to identify and troubleshoot data issues and needs of basic to moderate complexity for internal staff and external clients.• Extract data from various systems and transfer to the Computer Assisted Mass Appraisal (CAMA) system.• Identify data anomalies and discrepancies. Evaluate to determine viable solutions in alignment with client needs.• Perform basic data mapping, data conversion and load data to both client and internal systems.• Create and run reports to address specific client needs and to ensure data load accuracy.• Write technical specification, scripts and reports involving defining parameters, developing stored procedures, creating database views and other data solutions using technologies such as SQL Server and PowerShell• Create training materials as needed. Present software related training on capabilities and functionality to internal staff and clients

Cincinnati, Ohio

• Design, implement and support data flow solutions using industry standards (HL7, SQL) and proprietary tools• Implement new data integration requests and customizations into existing client environments• Test integration functionality executed in customer environments• Document and diagram integrated systems• Provide technical support for integration reported incidents, including system outages• Provide root-cause analysis for reported incidents• Provide accurate detail and direction to customers and vendors

West Chester, Ohio

Provide overall administrative support to the Integrated Cosite Equipment department Product Line Manager, Business Development Engineers and Managers by creating documented, repeatable, accurate reports, processes and documents. Responsible for a variety of business operations which assist the organization to attain cost-effective production with increased efficiency, quality, and satisfied customer service. Provide administrative support to entire department including: assistance with travel arrangements, submission of expense reports, meeting organization and coordination, order office supplies and other needed equipment, and assist with new hire on-boarding process.Selected Accomplishments: • Worked closely with the Product Line Manager, Business Development Engineers and other department managers by providing daily operational support.• Generate and publish critical data reporting components for department metrics• Update departmental Visual Management Board on a regular basis • Updated, Developed and implemented customizable reporting for departmental operations• Assisted with implementing operational changes in policies and procedures.• Responsible for uploading contractual data submissions to various client portals.• Generate and update opportunities in CRM software.• Coordinate marketing efforts such as trade show attendance and registration as well as catalog updates

Provide overall administrative support to the Operations Department VP, Directors and Managers by creating documented, repeatable, accurate reports, processes and schedules. Major involvement in several business operations and assisted the organization to attain cost-effective production with increased efficiency, quality, and satisfied customer service.Selected Accomplishments: • Worked closely with the C level and executive management teams by providing daily operational support.• Responsible for all critical data reporting components for Operations Department metrics• Maintained all companywide job costing and labor reports • Developed and implemented customizable reporting for daily companywide operations• Assisted with implementing operational changes in policies and procedures.• Maintained and distributed weekly resource schedule for over 20 field technicians• Made schedule changes based on staff availability and expected work load.• Reallocated resources to support client contract rollouts • Developed all operational data components for analysis projects for existing and potential prospects• Responsible for all field staff daily time management components including time and attendance administration.

Professional Services Administrator & Web Services, 2005 to 2010 Provide key administrative support to North Americas Area Vice President: maintain calendar, assist with travel arrangements, submit expense reports and organize needed correspondence. Assist team members with meeting organization, travel arrangements, intern payroll processing and office supplies ordering. Assisted in ATM Lab management including: allocation of hardware, system backup and restoration, minor system repairs, hardware upgrades and lab organizationSelected Accomplishments:• Assist in testing of Software Support portal prior to release to Customer. • Provide feedback on future requirements and improvements.• Maintained product line customer portal providing all regular updates including documentation, software patches and security updates. • Provide frontline support to internal and external end users of the customer portal. • Documented and distributed departmental workspace allocation information.• Assisted in planning and documenting transition requirements during workspace reconstruction project.• Functioned as liaison between department and ITS groups by providing sole point of contact for software and hardware orders, PC setup requests, assignments and recovery. • Improved overall departmental efficiency by optimizing the Inventory Allocation report, streamlining the order filing system and implementing an additional tracking system.• Helped to increase system availability by tracking hardware inventory and allocating systems which met minimum required specifications.• Implemented interim hardware service call tracking system • Assisted and trained users with installation and setup of MKS/defect tracking system. • Assisted with department staff daily time management components including time and attendance administration.• Ensured quality control by maintaining and creating projects in software defect and time tracking systems.