As a Robotic Process Automation (RPA) Developer, I develop software robots that automate business processes. My goal is to rid the workplace of monotonous tasks giving the human workforce greater fulfillment and job satisfaction.I am always interested in hearing from colleagues so feel free to contact me if you would like to connect.
-
Rpa DeveloperAlirriumSavannah, Ga, Us -
Manager - Digital SolutionsBaker Tilly Nov 2024 - PresentGlobal, Gb -
Rpa DeveloperAlirrium Jun 2020 - Nov 2024Reston, Va, Us•Developed unattended automations replacing an expensive middleware for a large federal client that is expected to save the organization more than 1 million dollars per year•Supported business and technical teams during RPA projects meant to mitigate/resolve risks and issues that may impact project schedule, cost, scope, and quality•Delivered a high fidelity attended automation prototype to a large federal client that is expected to save its 2,500 end users more than 10,000 hours annually•Staged and deployed unattended automations into test and production environments•Designed all UiPath automations using best practices including but not limited to the use of the Robotic Enterprise Framework, use of a dispatcher and a performer, no hardcoded values, secure use of credentials, use of background activities when possible, use of flexible selectors, sufficient logging, and proper error handling to account for both application and business exceptions•Extensively used XML in SOAP for data transfer across different systems and XSLT for transformations•Used UiPath Orchestrator for deployment, monitoring, and management of UiPath Robot automation activity•Experienced in creating Process Definition Documents (PDDs), Solution Design Documents (SDDs), Development Specification Documents (DSDs), process maps, and process diagrams•Used database connections and SOAP/REST APIs to automate data transfer between applications•Gained experience automating business processes in Epic Hyperspace•Built solutions utilizing RPA best practices and maintain technical responsibility for project delivery•Worked with UiPath Orchestrator and has an excellent understanding of modern folders, queues, triggers, assets, and Orchestrator logs•Developed automation components that parse and validate very large and complex PDF and XML files•Proficient in all phases of SDLC such as Analysis, Design, Development, Integration, Implementation, and Maintenance -
Battalion Maintenance OfficerArmy National Guard Apr 2019 - Aug 2021Arlington, Virginia, Us•Was responsible for the maintenance of over 8,000 pieces of equipment•Assisted the Battalion Commander on all matters maintenance•Was responsible for the equipment combat readiness of the unit•Assisted in the automation of equipment readiness reporting•Became proficient in GCSS-Army, an SAP Enterprise Resource Planning (ERP) system, which tracks supplies, spare parts, and organizational equipment -
Company Executive OfficerArmy National Guard Feb 2018 - Apr 2019Arlington, Virginia, Us•Actively managed transportation, distribution, maintenance, supply, and field feeding operations•Developed operational concepts and strategic planning to maximize efficiency and productivity within the unit•Prepared monthly reports and briefings on current operations and recommended actions to the Commander•Actively managed soldier readiness, soldier evaluations, and disciplinary actions•Ensured unit supply needs were addressed for maintaining operational readiness•Was responsible for establishing, implementing and monitoring company standard operation procedures•Acted as the Company Commander during 2 Inactive Duty Training weekends; responsible for over 100 soldiers•Led 3 convoys during Hurricane Michael relief missions•Received the Humanitarian Service Medal for participation in Hurricane Irma relief efforts•Received The Georgia Commendation Medal for exceptionally meritorious achievement while providing Defense Support of Civil Authorities during Hurricane Michael•Received The Army Achievement Medal while serving as the Executive Officer of the 1214th Forward Support Company -
Distribution Platoon LeaderArmy National Guard Aug 2016 - Feb 2018Arlington, Virginia, Us•Coordinated and managed the distribution of food, fuel, and ammunition for the entire battalion•Was responsible for forecasting bulk fuel requirements for all supported units•Ensured that accurate and complete accounting, reporting functioning, and all relevant records are maintained•Oversaw the distribution of over 9,500 gallons of fuel during FY2017 annual training•Managed the distribution of over 64,000 rounds of small arms ammunition and over 700 rounds of high explosive projectiles during FY2017 annual training•Planned logistical support for national disaster and wartime requirements•Managed the handling and accountability of sensitive and hazardous cargo•Was responsible for the health and well-being of 40 soldiers•Received the Army Achievement Medal for meritorious service during FY2017 annual training•Graduated from the Quartermaster Basic Officer Leadership Course at the Army Logistics University in August 2017•Initiated and directed the forecasting, requisition, transportation, storage, and distribution of consumable materials•Led 10 convoys during Hurricane Irma relief missions•Received the Georgia State Active Duty Ribbon for state activation during Hurricane Irma -
Officer CandidateArmy National Guard Oct 2014 - Aug 2016Arlington, Virginia, Us•Attended the Georgia Army National Guard Officer Candidate School and commissioned as a 2nd Lieutenant in the U.S. Army•Obtained a security clearance from the Department of Defense•Applied and studied military practices, accepted theory, and research•Learned how to lead and work with others in a high-stress environment•Qualified in leadership, leadership theory and application, law, moral reasoning for leaders, and basic psychology•Participated in numerous leadership development exercises•Received instruction and training on drill and ceremony, troop leading procedures, map reading, land navigation, warrior tasks, warrior battle drills, and physical fitness during phase one of the program•Received instruction and training on military leadership, military justice, military law, military history, military intelligence, supply operations, tactics, call for fire, and Army operations during phase two of the program•Received instruction and training on tactics, troop leading procedures, squad lanes, platoon lanes, and field leadership during phase three of the program -
SpecialistArmy National Guard Aug 2014 - Oct 2014Arlington, Virginia, Us•Completed a rigorous 10-week basic training course in Fort Jackson, South Carolina that emphasized the seven Army values: loyalty, duty, respect, selfless service, honor, integrity, and personal courage•Maintained 100% accountability of 53 personnel and over $250,000 worth of equipment during time in leadership•Participated in field training with close-knit groups and intense team-building exercises -
Financial Systems Analyst/Uipath Rpa DeveloperAdecco Dec 2017 - Jun 2020Zurich, Ch•Developed business process automations using UiPath’s RPA software that save the company more than 225 hours a month•Created end to end automation solutions for other business units which involved feasibility study, designing architecture, development, testing, and deployment of automation•Used RPA, Java, Jython, TIBCO, batch scripts, and Hyperion FDMEE to integrate PeopleSoft Human Capital Management 9.2, PeopleSoft Financials 8.4, and Oracle Financials E-Business Suite 11i with Oracle Cloud•Developed over 30 back office and front office robots using UiPath Studio that are now deployed across five different business units•Has extensive hands-on experience with VB.NET and UiPath’s Excel, CSV, Email, Collection, DataTable, Debug, String, Application, Clipboard, File, PowerShell, Browser, Find, Keyboard, Element, Attribute, Event, Image, OCR, Text, Window, Mouse, Screen Scraping, Error Handling, Checkpoint, Flowchart, Invoke, and Control activities•Writes complex queries, functions, views, indexes, and joins in Microsoft SQL Server and Oracle SQL to optimize reporting and to troubleshoot system issues as they arise•Acted as the system administrator for the RPA development server and the RPA production server in the early stages of RPA adoption within the company•Automated web-based, Java-based, and desktop-based processes using several different automation tools•Used UiPath’s screen scraping method to extract data using appropriate output methods such as native, full text, and OCR•Managed master data across three different systems: Oracle E-Business Suite, Oracle PeopleSoft, and Oracle Hyperion•Improved the workflow of requested additions, deletions, and changes to master data to provide the team and other business units with complete and accurate information•Automated numerous routine reports using SQL and Microsoft Power Query•Managed master data mappings using Oracle Hyperion Financial Data Quality Management, Enterprise Edition -
Accountant/Financial AnalystEon Products, Inc. Jan 2015 - Nov 2017•Managed financial departments with responsibility for budgets, forecasting, payroll, and accounts payable and receivable•Provided financial support and analysis to operations and marketing areas for strategic business decisions and cost savings initiatives•Collected, cleaned, and analyzed structured data used for major business decisions•Used advanced Excel functions to generate comprehensive monthly reports calculating labor cost, company sales, regional sales, product sales, employee commissions, and Georgia sales tax•Ensured all Payment Card Industry Data Security Standards (PCI DSS) were met•Implemented more efficient data collection procedures•Received, recorded, and deposited cash and checks as well as reconciled records of bank transactions•Managed inventory count procedures including control, daily counts, and annual counts•Assisted in the fixed capital planning process for both future fixed capital spending and the evaluation of past fixed capital projects resulting in an accurate monthly forecast•Led initiatives for business process improvement in accounting, sales, rental, shipping, and production departments•Performed software upgrades and support for information systems including but not limited to Sage 50 Accounting, Vtiger CRM, FedEx Ship Manager, UPS Worldship, ShipGear, Maintenance Pro, FedEx Desktop Customer Tools, and Microsoft Outlook•Created a prototype relational database using Oracle SQL Developer and Oracle Database 12c•Used SQL queries to automate the calculation of regional sales, product sales, monthly labor cost, and employee commissions•Performed a rental equipment utilization analysis showing what pieces of rental equipment produced the most revenue for the company; analysis results were presented to the owner and used to make equipment purchasing decisions•Helped create a robust data governance policy that ensured all master data met company standards•Increased the company's average accounts receivable turnover ratio
-
Account ManagerSellerlabs May 2014 - Dec 2014Athens, Georgia, Us•Helped increase company sales by 20% each month through professional service and salesmanship•Served as the first point of contact for all customers•Promoted the benefits of company products and generated high customer interest•Resolved customer concerns through investigating problems and developing effective solutions•Built strong relationships with customers through superior interpersonal skills and professionalism•Kept track of deadlines and ensured all client requests were completed promptly -
Business/Marketing AnalystSellerlabs Jan 2014 - May 2014Athens, Georgia, Us•Helped the company launch a new product line on Amazon by providing market research and data analysis•Compiled and analyzed data for future company projects using Microsoft Excel•Created and edited 10 videos explaining how to use company products such as Scope and Feedback Genius•Published 14 blog posts that supplemented the educational videos on company products•Dedicated 40 hours to editing technical videos on the process of establishing an E-commerce business•Increased public awareness of the company by launching the company’s first marketing campaign•Identified new revenue stream sources by recognizing the potential opportunities for new product lines
John Kastenbauer Iv Skills
John Kastenbauer Iv Education Details
-
University Of Florida - Warrington College Of BusinessBusiness Administration -
Georgia State UniversityComputer Information Systems -
Army Logistics UniversityLogistics -
The University Of GeorgiaFinance -
Valdosta State UniversityCore Curriculum
Frequently Asked Questions about John Kastenbauer Iv
What company does John Kastenbauer Iv work for?
John Kastenbauer Iv works for Alirrium
What is John Kastenbauer Iv's role at the current company?
John Kastenbauer Iv's current role is RPA Developer.
What schools did John Kastenbauer Iv attend?
John Kastenbauer Iv attended University Of Florida - Warrington College Of Business, Georgia State University, Army Logistics University, The University Of Georgia, Valdosta State University.
What skills is John Kastenbauer Iv known for?
John Kastenbauer Iv has skills like Leadership, Peoplesoft Financials, Information Technology, Powerpoint, Information Security, Oracle E Business Suite, Economics, Corporate Finance, Uipath Orchestrator, Uipath Studiox, Uipath Studio, Financial Modeling.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial