• Served as a senior member of the DOTS team for a leading organization of intelligence decision support and advisory services to domestic and international financial institutions• Provided critical on-boarding services to domestic and global clients to ensure seamless ingestion, processing, and validation of raw datasets• Developed new implementations within the cloud environment and supported AWS migration efforts• Performed data validation and data quality checks to produce high data quality for ETL tasks• Responsible for managing 200+ Globalscape accounts - establish connectivity, create accounts, and facilitate file transfers via HTTPS/SFTP• Diagnosed and resolved connectivity issues (coordinate with relevant ITS teams for additional support as needed)• Enhanced in-house technology to optimize processes for loading, validating, and generating reports for incoming data• Produced various file formats for normalized datasets and securely transmit data to respective clients

• Ingested ~3TB of data on a monthly basis from credit bureaus into structured MS SQL Server databases • Developed advanced automation processes using Pentaho Data Integration (PDI) for existing manual procedures• Reduced data loading efforts by nearly 50% • Interacted directly with banks and other financial institutions to resolve critical issues in data quality• Conducted coding and process review sessions with newly on-boarded employees• Produced user-friendly documentation describing processes containing highly technical information

• Received and ingested datasets from numerous clients utilizing Microsoft SQL Server Management Studio• Monitored daily/month-end reporting to ensure all datasets received were loaded successfully• Assisted with maintaining server & database space allocation within SSMS• Owned several end-to-end ETL processes, which occasionally required manual intervention/troubleshooting

• Responded to incoming calls from students, faculty, and staff regarding ITS challenges and developed effective resolutions• Referred callers to other ITS departments for handling after obtaining precise technical information from users• Addressed all inquiries about E-mail, Blackboard, or Pace Portal which included username, password, or functionality concerns