ROGER GAULKE
Infosys
Visalia,CA
5
years of professional experience
Data Analyst with experience managing 12 databases, building SQL scripts, and supporting full-stack Java work for development teams and management. Turns database output into actionable insight, resolves data issues to protect integrity, and improves older applications through backend and frontend updates. Bridges analysis and engineering to keep reporting reliable and business decisions grounded in current data.
Work History
Data Analyst
4 Years 6 Months- Managed 12 databases across Verizon functions, maintaining data accuracy and integrity in PostgreSQL and SQL.
- Directed 9 systems by troubleshooting code issues and using SQL scripts to streamline data handling.
- Built hundreds of SQL scripts to extract actionable insights for development teams and management.
- Diagnosed and resolved database issues quickly to maintain reliable data access for downstream users.
- Used SQL databases within full-stack Java projects to support dynamic application development.
- Transformed an outdated Verizon application into a Spring Boot backend with a JavaScript frontend, adding significant database enhancements.
- Automated recurring analysis and validation workflows in Excel and Python to improve reporting consistency.
Retail Salesman
3 Months- Assisted customers with product selection by answering questions and explaining basic features clearly.
- Maintained organized merchandise displays to improve store appearance and product visibility.
- Supported fitting room and sales floor operations by responding quickly to customer needs.
- Recommended products based on customer needs, helping guide informed purchasing decisions.
Software Engineer
3 Months- Built full-stack websites using Java, Angular, Spring Boot, SQL, and Jenkins for functional application delivery.
- Maintained PostgreSQL databases and validated data integrity to support accurate analysis and dependable application behavior.
- Created Python and Excel reporting workflows to streamline data analysis and improve repeatability across routine updates.
Education
Bachelor of Science - Computer Science
Associate of Science - Criminal Justice
Skills
SQL
Python
Excel
PostgreSQL
JavaScript
Java
Data analysis
KPI reporting
Dashboard development
Data validation
Report automation
ETL development
Data warehousing
Dimensional modeling
Query optimization
Data pipeline troubleshooting
Tableau
Power BI
A/B testing
Timeline
Retail Salesman
Sportsman's Warehouse
09.2022 - 12.2022Read More
Data Analyst
Infosys
04.2022 - CurrentRead More
Software Engineer
Revature
01.2022 - 04.2022Read More
Moorpark College
Associate of Science from Criminal Justice
Read More
Cal State University Channel Islands
Bachelor of Science from Computer Science
Read More
Links
linkedin : (25) Roger Gaulke | LinkedIn
Github : rogerjarad