JOEL ARIAS CORDOVA

TEL: 281-***-**** • E-MAIL: ad44qg@r.postjobfree.com

• 2112 Foxworthy av. San Jose, CA 95124

• https://www.linkedin.com/in/joel-arias-cordova-39849628/mailto:ad44qg@r.postjobfree.com

mailto:ad44qg@r.postjobfree.com mailto:ad44qg@r.postjobfree.com

SUMMARY

Highly motivated Senior QA Engineer and Data Analyst with 10 of experience ensuring software quality and driving data-driven insights. Leverages expertise in UI, API, web services, jobs data, and ETL testing (manual and automated with Python and Java) to proactively identify and prevent defects. Proven ability in SQL tuning, optimization, and data modeling (SQL Server, MySQL, MariaDB) to unlock valuable data insights. Skilled in creating compelling reports (Microsoft Power BI, SSRS) and data integration (SSIS). Experience with NoSQL databases further expands data analysis capabilities.

EDUCATION

B.S. in Computer Engineering. Instituto Tecnológico Autónomo de México.

CERTIFICATIONS

Oracle Certified Associate, Java SE 8 Programmer.

Microsoft SQL Server: Reporting Services (SSRS).

Microsoft SQL Server: Integration Services - ETL (SSIS)

EXPERIENCE

04/01/2013 – 02/10/2023 Oportun, Inc. Menlo Park, CA

Senior Software Engineer in Test

■I architected and implemented automation testing tools, streamlining testing processes and reducing test execution time by 95%. The used technologies are Docker, Python, Jenkins, AWS, Selenium, Pytest, Sauce Lab, and Bitbucket.

■I exercised my testing expertise across diverse technologies, conducting rigorous manual and automated testing for UI, API/SOAP, data, ETL, jobs, and software foundation changes in applications.

■I architected and implemented robust SQL solutions, including DDL/DML queries and stored procedures, streamline testing activities, support job automation testing, reducing errors, and boosting productivity.

■I designed and executed comprehensive test cases to validate the functionality of MongoDB and Solr databases, ensuring optimal data management and retrieval.

■I authored bash scripts to automate data processing, file management, and compress files, reducing manual effort and saving time.

■As lead tester for Servicing modules (Payments, Notification, Loan Accountant, Collections) and Jenkins-Jobs and Foundation modules, I spearheaded meticulous testing efforts, resulting in zero severe and critical bugs encountered during that period.

■I actively verified the accuracy and reliability of the Financial Engine, Loan Generation, and Data modules through comprehensive testing, ensuring seamless financial transactions and data integrity.

■I Crafted a suite of testing tools using Java (Spring Boot), MongoDB, Selenium, Cucumber and TestNG to streamline quality assurance processes, boost test coverage, and accelerate development cycles. Testing and data processing time were reduced un 98%.

■Executed comprehensive performance testing using JMeter and Groovy to pinpoint bottlenecks, optimize system performance, and ensure seamless user experiences under heavy load.

■Championed production support for the Loan Application System, ensuring its seamless operation by expeditiously troubleshooting, identifying, triaging, and resolving database errors in the live environment. Bug fixing time was reduced by 50%.

03/03/2008 – 03/03/2013 Klass Time, Ltd Sugar Land, TX

Application Business Analyst (sql server developer)

■My contributions to the Business Analysis Area increased 25% of sales in the PMAs on which we implemented the detailed sales analyst reports.

■Delivered impactful insights and data-driven solutions by skillfully leveraging SQL Server tools, including Reporting Services, Integration Services (VBScript), Analysis Services, GIS, OLAP, SSMS, Power BI, and DDL/DML.

■Provided critical technical support to Sales, Logistics, Product Development, Administration, and Finance, ensuring smooth operation of systems and applications, leading to 25% increase in operational efficiency.

■Extracted actionable insights from the internal ERP (Microsoft Navision - now known as Microsoft Dynamics 365) through comprehensive data analysis, driving informed decision-making and process improvements.

■Designed and implemented comprehensive reports for compensations, customer sales analysis, brand health, and customer inventory management, empowering stakeholders with critical data insights to optimize decision-making and drive business growth.

■Developed accurate and comprehensive annual sales budgets, utilizing historical data analysis and market trends to forecast revenue with 95% accuracy, enabling informed resource allocation and strategic planning.

■Leveraged my expertise in data analysis and quality control methodologies to design and implement effective data accuracy and quality checks.

■Accelerated query performance by up to 25% through meticulous SQL tuning and optimization, ensuring seamless data access and enhancing user experience.

■Created robust and scalable SQL data models to ensure data integrity, enhance data analysis capabilities, and support strategic business decisions.

■Identified and resolved data discrepancies and quality issues between sales and client inventories, ensuring reliability and trustworthiness for decision support.

■I also developed web scrapping wit SSIS for provide Freight information to Sales Manager.

11/01/2005 – 02/28/2008 Urban Science de Mexico Mexico City

Data Analyst (Shared Data Associate)

■Partnered with stakeholders from diverse departments and clients from automotive industry to streamline data exchange processes, reducing time to access critical data by 60% and accelerating workflows and increasing Urban Science Sales in 30%.

■Spearheaded the geocoding of Sales, After Sales and Lead Management data for the automotive industry, enabling spatial analysis and driving targeted marketing campaigns.

■Orchestrated the development of a comprehensive Sales Point Analysis Report, empowering sales teams with actionable insights to optimize resource allocation and maximize dealership performance, leading to an early knowledge of automotive market.

■Streamlined data validation processes by automating repetitive tasks, boosting efficiency, and saving resources.

■Leveraged my expertise in data analysis and quality control methodologies to design and implement effective data accuracy and quality checks.

■Identified and resolved performance bottlenecks through in-depth query analysis and optimization, reducing query execution time by 99% and boosting overall system responsiveness.

SKILLS

Spanish Fluent

SQL (DDL/DML), SQL server (Reporting Services, Analysis Services, SSIS and SSMS), MySQL, MariaDB, MS Access, Oracle Java 8 Certified,, Spring Boot, MongoDB, Solr, Linux, API Testing, Web Services, Jenkins, Jira, Bitbucket, Confluence, Test link, Python, Pytest, postman, JMeter, Selenium, AWS, parquet files, Typescript, JavaScript, Visual Basic, Angular JS, Docker, Sauce Lab, and Service Now.

Contact this candidate