Aaron Walker Email & Phone Number

Virginia Beach, Virginia, Us

Morristown, New Jersery, Us

• Performed facilities maintenance and improvement on a 69 year old structure including electrical, plumbing, trim, paint, and appliance repair.• Implemented/Fabricated interior design requests from home co-owner based on ambiguous requirements and limited budget.• Designed/Built/Procured/Managed/Administered entertainment and educational devices and systems for multiple Gen Alpha youth participants.• Prepared nutritious meals adhering to sanitization standards using organic/free-range/local/non-GMO ingredients (when available) while accommodating subjective and objective dietary concerns and preferences.• Produced artisan grade lumber from a felled hickory tree using splitting wedges, sledge hammers, chainsaw mill, bandsaw, thickness planer, jointer, and elbow grease• Performed automotive and recreational vehicle maintenance and repair for household members and employees including brakes, ignition, starters, fuel delivery, body and structural work, electrical, cooling, oil changes, air delivery, and child safety seats according to NHSTA guidelines.• Operated and maintained a rehearsal room/recording studio with multitrack audio and 4k Video recording/livestream capabilities. Produced demo recording in-house and provided post production work for live recordings.

Glen Allen, Virginia, Us

Responsibilities:• Design and develop ETL solutions using data warehouse design best practices, SSIS and Python.• Analyze data requirements, complex source data, and the data model, and determine the best ETL methods for destinations including data staging, warehouse and other system integration projects.• Provide technical assistance in identifying, evaluating, and developing systems and procedures.• Manage automation of file processing as well as all ETL processes within a job workflow.• Ensure data quality throughout entire ETL process, including audits and feedback loops to sources of truth.Accomplishments:• Served as lead developer for systems integration with Novantas interest rate optimization platform. This involved standardizing, segmenting, and creating data feeds for thousands of product and rate schedule combinations across multiple business lines, often from AS400/ IBM DB2 sources to SQL Server.•Built APIs in Python to migrate and maintain our enterprise CRM of 100,000+ customers and accounts to Hubspot. Worked closely with our marketing department to ensure availability of all needed data for existing and future campaigns.•Migrated over 150 reporting data sources from our legacy SSIS packages stores scheduled under SQL Agent to Python/Pandas scheduled orchestrated under JAMS Scheduler. This included mandatory regulatory reports and our entire month-end general ledger reconciliation. The result was almost 90% less tickets for job and reporting failures/errors. During this project I also developed reusable automated testing capabilities for file base feeds.

Richmond, Virginia, Us

Responsibilities:● Develop and assess statistical models for credit and insurance score prediction.● Create and implement automated processes to replace manual analysis and duties.● Meet with business owners to identify business needs and create solutions that add value to the business.Key Accomplishments:● Implemented agile practices and source control into daily workflow.● Created web services for automated scoring of customers quoting on the website.● Established QA and documentation standards for the Data Science department.

Richmond, Virginia, Us

Responsibilities:● Developed database solutions for a rapidly expanding insurance price-comparison website.● Served as technical lead and subject matter expert for sales processing and revenue reporting.● Worked directly with stakeholders or business owners to balance their performance requirements with corporateneeds and technical solutions.● Aligned system design with business needs, including reviewing contracts, maintaining accounting and complianceknowledge, and building auditability throughout the system.● Identified risks and impacts of current and proposed systems and processes.● Designed analytical reports and dashboards for business users through SQL Server and Tableau.● Collaborated with Data and Analytics teams to maintain and improve ETL processes and Data Warehouse.● Performed DBA tasks such as security, performance monitoring, storage and index management, deployments,backups, migrations, and job scheduling.● Determined whether to refactor or build new systems and processes based on project complexity and goals.● Collaborated with internal and external teams, as well as resources in Europe and India.Key Accomplishments:● Designed and built application for contract management and revenue calculation for 50+ insurance carriers' complexand disparate pricing models.● Created automated file-processing framework for client sales reporting.● Assisted with large scale migration of database servers to a new data center with minimal downtime.● Achieved Certified ScrumMaster Certification and actively promoted Agile methodologies within the organization

Indianapolis, Indiana, Us

Indianapolis, Indiana, Us

Responsibilities• Provided leadership and administration of release management, environment management, and source control. • Orchestrated large quarterly and smaller monthly software releases. • Coordinated and administered code base for several multi-tiered database development and testing environments for several project teams. • Reviewed and approved daily builds to multiple testing environments (QA/SIT/Training/Performance). • Collected and maintained features and fixes and associated scripts for each release. Led communication and performed production deployments during scheduled release.Accomplishments• Assisted with migration of source code from Visual Source Safe to Team Foundation Server.

Indianapolis, Indiana, Us

Responsibilities:• Provided support for production database environment.• Troubleshot issues and developed solutions for production defects.Accomplishments:• Was offered full-time employment within 4 weeks of starting my internship.Technologies: • SQL Server 2005, Test Director, Visual Source Safe

New Braunfels, Us

•Managed scheduling for 14 service and delivery technicians for the entire state of Virginia for the Richmond Distribution Center and two remote offices. •Served as first point of contact for customers and technicians for all technical, billing, procedural, and customer service issues. •Analyzed and implemented procedures for work order completion, inventory management, and both new-hire and existing employee training•Ensured strict compliance with frequently changing company, Medicare, Medicaid, ACHC, and HIPPA guidelines and regulations•Ran all aspects of administration and management in the absence of the DC Manager•Raised our Distribution Center’s monthly Score Card from 58% to 92% over 6 months

Miami, Fl, Us

Assisted in the management of four dedicated freight accounts comprised of over 20 drivers Ensured equipment availability, timely delivery and client satisfaction while complying with all DOT requirementsCoordinated driver scheduling, dispatching and trip entry, including third party managementFacilitated and ensured accuracy of payroll, billing and client reporting

San Francisco, California, Us

Analyzed and reported on short salesMaintained database with short-sale justifications, requiring advanced use of Microsoft Excel and AccessStreamlined reporting processes to boost efficiencyDeveloped a tutorial for the department's work procedures to aid with new employee orientation

Us

Analyzed claims against state petroleum storage tank funds to determine financial eligibility of chargesDesigned queries in Oracle Discoverer/SQLCreated databases in MS Access Maintained superior customer serviceServed as primary liaison to the Virginia Resources Authority Accelerated Payment ProgramContributed to the Reconsideration Panel for appealed claims

Englewood, Co, Us

Bachelor'S Degree, Information Systems

Master'S Level Certificate, Analytics

Associate'S Degree, Business Administration

Engineering, Business

Computer Software Engineering