Aaron Solar Email & Phone Number

Annapolis, Md, Us

Annapolis Junction, Maryland, Us

• Senior Systems Engineer / Subject Matter Expert specializing in delivering capabilities that empower data-driven decision-making by customers and government leadership• Solutions architect for agency business and management systems• Primary corporate timesheet & expense report approver• Designed & developed suite of CRM and automation tools supporting the Cybersecurity Directorate’s DIB partners• Gathered requirements, use cases, and analyzed sample data for multiple raw signal flows & mapped into corporate warehouses• Chaired multiple cross-IC working groups supporting ontology development, common data models, and metadata management • Partnered with stakeholders to understand and decompose requirements into short- and long-term deliverables, establishes cost, schedule and dependencies when architecting data presentation solutions• Analyzed legacy systems and provides guidance on new capabilities to efficiently arrive at customer requirements, interfacing directly with government leaders and development teams• Leveraged corporate tools such as JIRA & ServiceNow (action ticket tracking), Confluence (collaboration), Cognos BI (data dashboards and smart intelligence reporting), Windows 10 VM dev environments• Lead comprehensive test execution: manual user acceptance, peer, regression & unit testing• Investigated fault errors and performance failures by troubleshooting root cause ranging from UI/UX interface through middleware data grain through source system native data corruption• Enabled agency leadership with data-driven reporting, through development of Cognos BI reports, user interface dashboards for civilian and military customers, and supporting back office orgs• Designed metadata to transform SSOR into data warehouse cubes. Analyzed, updated, and streamlined ETL processes from SSOR (using PeopleTools and Oracle SQL Developer) into data warehouses, developing new ETL views to reduce data islands• Enabled 508 compliance across product offerings

Rockville, Md, Us

• Systems Architect specializing in data management, empowering customers with streamlined infrastructures that enable on-demand data ingest and reporting• Manage inter-dependencies of each customer to integrate with existing capabilities and dependencies, such as 3rd party data feeds & legacy infrastructures • Designed and built custom solutions to convert legacy, locally hosted data to cloud-hosted and virtually accessible for ~25+ different companies• Integrated 3 massive SQL Server data sets into 1 unified data set, standardizing data tagging, key structure, and database server constraints in a live, production environment• Designed/developed custom data feeds using IBM Cognos to automate data transfer via SFTP from SQL Server/Oracle databases, averaging 10k-50k lines of data • In addition to technical expertise and implementation, empowers clients in the use of developed system capabilities through:o Technical Writing: authoring leave-behind instructions & procedures for users at all skill levels, allowing for continuity during times of turnover or general referenceo Training: developed and led intensive training programs for end users, ensuring full immersion in new system capabilities – ranging from 1-hour to multi-day sessions (local and remote)o Support: Tiers 1, 2, and 3-level support as needs evolve• Performed patch management & hot fix deployment for customer on premise software• Designed/developed custom business intelligence reporting/dashboarding for ~50 government contractors

Maintain accurate & auditable financial statements in a non-profit environment. Responsible for cash management of the 5,000 member chapter supporting the Armed Forces.Served as VP of Technology May, 2009 through May, 2013: Designed, developed, deployed, and maintained Joomla content management system for chapter website which included a custom event management system used for chapter events as well as conferences such as NAIPE & NAMAS. All operating in a high foreign threat environment with zero downtime.

- Siedle USA (2006-2014): Administer domain controllers/file/Exchange servers, & web design / development - TSG Solutions: Implemented Deltek ERP system, operational consulting, & web design/development- OASIS Inc (2007): Implemented Deltek ERP system, operational consulting, & web design/development- C-Care LLC (2003-2004): Designed custom sales order/WIP entry system, job costing system for production lines; Ross Systems ERP support- Jonathan Product LLC (2005): Designed & deployed COTS inventory management system- Girl Scouts of New Hampshire (2003): Designed & built custom inventory/commission tracking system- Crystal Systems, Inc. (2002-2004): Developed & implemented custom sales, production, inventory, shipping, and QC database. Designed and built automated inventory adjustment system to maintain inventory levels, provided help desk services, domain administration, financial system administration.- Pilot Construction, Inc. (2002): Build out LAN, UPS Backup, File servers, & multi-client ERP system- iSource PC, Inc. (2001-2002): Build out LAN, multi-client inventory system, bar code tracking systems- Greenpages, Inc. (2000-2001): Data/process analysis with largest Filemaker database, locate/correct vendor API issues- Suflex. Inc. / Macallen, Inc. (1998-2000): ERP/MRP System Administrator, inventory/BOM script development for Symix- Management consultant to a number of various New Hampshire maple sugar conglomerates

Ellicott City, Md, Us

• Research, design & deployment of data-intensive systems to enable company and client leadership • Implemented web-based project collaboration software solution, Deltek WelcomHome (EVM), empowering location distributed team members with a user-friendly, single-interface, cloud-based collaboration environment • Implemented Deltek Cobra for contract specific EVM (Earned Value Management) reporting & ADP HR Expert system to automate & improve HRMS data quality/EEO reporting• Developed policies and procedures for newly implemented information systems to ensure continuity• Converted legacy home-built talent management database into Taleo’s talent acquisition platform• Implemented Cognos Business Intelligence tool, integrating it with existing systems for real time reporting

Washington, Dc, Us

• Designed and deployed new corporate rack server system with VMWare Virtualization for critical network operations (MS Exchange, Deltek ERP systems, etc)• Deployed key components of IT infrastructure, focused on hardening the corporate network:o ManageEngine ServiceDesk for help desk ticketing supporting 600+ user multi-tier requestso ManageEngine Desktop Central patch management solution for Windows/Linux workstationso GFI Languard for automated network vulnerability assessments & remediation o McAfee anti-virus/anti-malware agents for enterprise wide (12+ locations) scanningo SpiceWorks Network Inventory solution for real time analysis on hardware & software installations • Developed policies & procedures for disaster recovery and continuity of operations planning• Implemented custom data bridge between Deltek ERP system and ADP for payroll journal entry automation.

• Implement/maintain Active Directory, Exchange, Blackberry Enterprise Server, Citrix Xen Server, FTP servers• Deployed Cisco VPN, Backup Exec. Implemented Deltek GCS Premier for DCAA/FAR/CAS compliance.• Provided successful disaster recovery support to sister entity after RAID failure and massive data loss• Designed & deployed X-Cart e-commerce solution to sister entity with pass through shipping & bar code support• Implemented Cognos Impromptu Business Intelligence improved & automated financial/operational reporting.