Created and maintained 1500+ data pipeline ETL/ELT jobs to support data integration needs for ExpertVoice. Collected, cleansed, prepared and loaded data from a variety of sources into the Redshift data warehouse and MySQL transactional databases.• Served as the Tech Lead and Mentor for members of the Data Engineering and BI Analyst teams. Filled in as the Manager of Business Intelligence, twice. Performed employee performance reviews and interviewing/hiring.• Debugged and fixed complex job failures due to upstream/ downstream changes.• Designed / developed BI environments to support Tableau reporting.• Maintained and optimized Redshift cluster. Created and supported dev environments for other Engineers/Analysts.• Designed and created tables in data warehouse for proper storage and reporting with Tableau. Developed and tuned database queries for optimal performance.• Ensured data quality and accuracy with both internal and external stakeholders.• Lead the efforts to gather analytics collector events for the ExpertVoice Advocacy Platform. This involved collecting, structuring, sanitizing, and loading ~7 million events/day into Redshift.TECHNOLOGIES:• SQL Pro: PostgreSQL, MySQL, HiveQL, T-SQL, PL/SQL• AWS Tech: Redshift, S3, Spectrum, Glue, EMR, EC2, Aurora RDS, Athena• Tech used/familiar with: Linux/ Ubuntu, MageAI, Pentaho Data Integration (PDI), shell scripts, Bash, Cron, HDFS, Hive, Tez, Java, JavaScript, Python, Docker, JSON, Tableau, Git, Jira, Postman, APIs, cURL

Responsible for the integrity, availability, recovery, performance, and security of L-3's databases (Oracle & SQL Server). Approx. 50 Oracle servers, 160 SQL Server, with approx. 2200 databases. Includes backup and recovery, restores, monitoring, performance tuning, tracing, security/user access, installs/upgrades, stored procedures, SSIS packages, queries, SQL, PL/SQL, T-SQL, DDL/DML, Oracle SQL Developer, Oracle Enterprise Manager, SQL Server Management Studio and Red Gate Software.

Developed and maintained enterprise HRIS systems within MVC frameworks using the following technologies: Microsoft SQL 2000, 2005, and 2008, 2008R2, T-SQL, Oracle 10g,11g, Oracle SQL Developer, PL/SQL, ASP, VB, VBScript, Java, (X)HTML, CSS, Ajax, DOM, JQuery, JSON, JavaScript, PHP, XML.