James Olas
Dallas, TX. 972-***-****
*********@*****.***
Skills: outsystems, SQL, Autosys, Java, Linux, Angular, JavaScript, Typescript, Spring Boot, HTML, CSS, AWS, Microservices, accounting, general ledger, accounts payable, accounts receivable, fixed assets, SAP, excel, pivot tables, vlookups
Experience:
Pepsi:
Finance Coordinator (8/21/24 – present) (temporary assignment)
Perform Accounts payable
Reconcile expenses in Concur
Pepsi:
Finance Analyst (6/5/2023 – 7/26/24)(temporary assignment)
Analyze distributor information
Correct errors in sales records
Respond to requests and inquiries from sales department
Improved management of information
Infosys:
Senior Associate (6/10/2021 – 2/8/2023)
Production support – analyzed problems with jobs failing and made updates to production databases
Analysis of incremental records for tables – analyzed 6 months of data to find count of incremental records for certain tables
Analyzed run times of certain jobs and made recommendations on alerts for max run time
Automated a shell script in Linux
Switched servers that jobs ran on and collected evidence
Monitored reports going to regulators
Analyzed jobs that failed due to out of memory – checked if other processes were running at the time of failure
Sybase was primarily used to work with databases
Navigated in Linux servers to find logs
Helped restore missing files for archival
Prepared quarterly reports for operations
Completed Infosys Java Spring Certification
Worked on Java microservices application
Revature:
Associate (1/21 – 6/21)
Learned Java, SQL, Angular, JavaScript, TypeScript
Worked on projects using back-end and front-end technologies
Used SpringToolSuite IDE for projects
Learned about Spring and used it for projects
SpringBoot was used later on to make coding more efficient
Worked with Jenkins to deploy projects to Amazon AWS
GitHub was used as a remote repository for projects
PostgreSQL was used to work with databases
Learned how to use Docker as a containerization software for projects
Learned about Microservices
Hibernate was used to query databases for Java API
Used Apache Tomcat server on AWS cloud Linux server for Java backend. Also used Apache Tomcat on local projects.
Created full Stack applications using Java, sql, angular
Legoland (temporary assignment)
Junior Accountant (2/10/20 – 3/16/20)
Journal entries
Accounts payable
Accounts receivable
County of San Diego (temporary assignment)
Account Clerk (12/23/19-1/31/20)
Accounts Receivable
Reconcile data
Catholic Diocese (temporary assignment)
Accounting Specialist (12/2/19 – 12/13/19)
Accounts Receivable
Great Plains
San Diego Gas & Electric (temporary assignment) (8/2017 – 6/2018)
Accountant II
Extracted CWIP data out of SAP
Manipulated data in Excel using pivot tables and Vlookups
Entered journal entries
Performed data analysis of fixed asset depreciation in Excel
Assisted with month end closing audit
Worked with fixed assets in PowerPlan
Analyzed monthly data in Excel
Revlon
Domestic Sales Coordinator (8/2014 – 8/2017)
Consolidated material master data for sales team from SAP
Used Excel vlookups and pivot tables
Created customers and ran data reports
Used business intelligence tool to run sales reports
Extracted data from SAP and BI and prepare data in Excel
Salesforce administrator – managed data, reduced duplicate data
Manage sales to Amazon.com
CND
Marketing Logistics and Data Specialist (3/2013 – 8/2014)
Produced sales reports for marketing managers
Remade and managed budget file
Managed marketing promotional items
Managed materials in company ERP system
CND
Accounts Receivable Clerk (8/2012 – 1/2013)
Assisted accounts receivable department and wrote procedures
Posted cash receipts
Researched and reconciled past due amounts and credits
enXco
Staff Accountant (3/2011 – 5/2012)
Performed all accounting duties for the corporate segment and successfully met closing deadlines with little or no supervision
Performed intercompany reconciliations between corporate and internal segments as well as foreign counterpart
Managed USD and foreign currency loans with parent company and foreign counterparts.
Analyzed estimate versus actual comparisons of quarterly financial data
Worked with consolidation department to report financial data to parent company
Entered journal entries including accruals, reversals, cash transfers, expenses, etc.
enXco
Jr. Staff Accountant (7/2010 – 2/2011)
Journal entries for O&M department
Accounts Payable
Education
Bachelor of Science in Finance – California State University San Marcos