Mark Ruppel Email & Phone Number

Glen Allen, Va, Us

Detroit, Michigan, Us

Brought in data from over 800 external sources available in a central easily queryable platform using Oracle GoldenGate, SQL, Sqoop, and Hadoop • Made enhancements to a widely used inhouse data processing tool to increase capability and performance using Java using Hadoop MapReduce scanned by Sonar to prevent security vulnerabilities• Developed the backend for a customer facing utility using Java, Springboot/Spring MVC, Spring JDBC/JPA, Spring Cloud, Hibernate, RabbitMQ, and Pivotal Cloud Foundry which allows users to select data to manipulate• Developed a microservice to get new table definitions from RDBMS databases using Springboot, • Created a near real time rollup process through the use of shell scripting and Hive table partitioning to make querying of 4 trillion records of vehicle data possible using Hadoop and MapReduce• Developed process to extract SAP HANA data to Hadoop using Sqoop and shell scripting scheduled through Autosys• Reduced manual effort by 50% through automation of processes using shell scripting and Java• Worked closely with stakeholders to ensure data quality by gathering requirements and continual status updates

Detroit, Michigan, Us

Designed custom ETL solutions based on business requirements using IBM DataStage, JAQL, Hive, Teradata, and shell scripting • Worked with teams in Europe, Asia, and South America to bring data into a central enterprise data warehouse • Developed custom validation tools using shell scripting and HQL to verify data integrity • Worked cross team to develop streamlined processes to increase rate of deployment • Created ETL processes that were used for financial reporting for vehicle profitability by VIN • Acted as mentor to new college hires by providing insight and personal experiences