Requests
17
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Atlantic Union BankBusiness Intelligence Developer
Aug. 2019 - Nov. 2022Richmond, Virginia AreaResponsibilities:
• 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.
Compare.comData Scientist
May. 2018 - May. 2019Richmond, Virginia AreaResponsibilities:
● 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.
Compare.comDatabase Developer
Mar. 2015 - May. 2018Richmond, Virginia AreaResponsibilities:
● 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 corporate
needs and technical solutions.
● Aligned system design with business needs, including reviewing contracts, maintaining accounting and compliance
knowledge, 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' complex
and 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
Anthem, Inc.Release Manager/Configuration Engineer
Apr. 2013 - Jan. 2014RichmondResponsibilities
• 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.
Anthem, Inc.Database Developer
Aug. 2011 - Mar. 2015Richmond, VAResponsibilities
• Developed database solutions for an enterprise healthcare management application. • Wrote stored procedures, DDL/DML, SSIS packages, functions, triggers, and indexes according to technical requirements and design documents. • Served as a subject matter expert in a number of areas and assisted with technical design and requirement collection in those areas. • Analyzed and troubleshot production issues and developed fixes. • Assisted with SQL Server administration and security for over 40 servers. • Served as database technical lead on performance testing and monitored performance. Accomplishments
• Designed, developed, and implemented performance testing framework for monitoring and reporting performance issues with database and application.
• Created an ETL solution for automated call processing working with outside vendors. My solution now serves as the foundation for several other new business processes. Technologies: SQL Server 2005/2008/2008R2, SSIS, Team Foundation Server, Visual Source Safe, SharePoint Skills: SDLC, project management, database design and development, troubleshooting, time management
Anthem, Inc.Database Development Intern
Jul. 2011 - Aug. 2011Richmond, Virginia AreaResponsibilities:
• 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
The Scooter StoreField Support Specialist
Mar. 2010 - Mar. 2011•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
Ryder Integrated LogisticsLogistics Coordinator
Jan. 2006 - Jan. 2010Assisted 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 requirements
Coordinated driver scheduling, dispatching and trip entry, including third party management
Facilitated and ensured accuracy of payroll, billing and client reporting
Wachovia Securities, LLCReports Analyst
Jan. 2005 - Jan. 2006Analyzed and reported on short sales
Maintained database with short-sale justifications, requiring advanced use of Microsoft Excel and Access
Streamlined reporting processes to boost efficiency
Developed a tutorial for the department's work procedures to aid with new employee orientation
SedgwickEnvironmental Claims Examiner
Aug. 2002 - Oct. 2005Analyzed claims against state petroleum storage tank funds to determine financial eligibility of charges
Designed queries in Oracle Discoverer/SQL
Created databases in MS Access Maintained superior customer service
Served as primary liaison to the Virginia Resources Authority Accelerated Payment Program
Contributed to the Reconsideration Panel for appealed claims
EchoStar CorporationTechnical Support Representative
Mar. 2002 - Jul. 2002
Intch is a Professional Networking App for the Future of WorkSee more people like Aaron on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
18
Senior Software Engineer @ EarnIn
41415 people
16
Startup Product and Operations Strategist @ SmartLogic Strategy LLC
16
Independent Consultant @ N/A
15
Systems Engineer @ Capco Computing