Sql Server Back-End

Arunas Kleinas

Highly Skilled Microsoft Access Developer

********@*****-***.*** Phone: 508-***-****

A Highly skilled Microsoft Access Developer with over 20 years of experience in designing and developing complex Access databases. Extensive expertise in creating user-friendly front- end user interfaces, back-end databases, advanced queries, reports, and VBA modules. Proficient in integrating Microsoft Access with other Office applications, automating workflows, and ensuring data integrity. Strong problem-solving, critical thinking, and business analytics skills. Proven ability to work independently, or collaboratively, to deliver high-quality solutions within tight deadlines.

Technical Skills

• Expert-Level: Microsoft Access (Forms, Reports, Queries, VBA), Visual Basic, Automation, Data Integration

• Database Management: SQL Server (Tables, Views, Stored Procedures), PostgreSQL, Oracle, Data Migration

• Programming: VBA, VB.NET, JSON, XML, COBOL, JCL, API Integration

• Testing & Optimization: Database Quality Verification, Process Documentation, Performance Tuning

• Frameworks & Tools: Visual Studio, PeopleTools, SQR, DevExpress Professional Experience

Event-Man Tournament Software

Microsoft Access Developer March 1997 – Present

• Designed and developed a user-friendly Microsoft Access front-end/back-end application used by over 5,000 golf professionals worldwide to administer simple to complex golf events.

• Integrated Access databases with external applications such as Excel, SQL Server, web services, and APIs.

• Created over 600+ tables, 400+ queries, 200+ forms, 1,000+ reports, and 2,000+ VBA functions/subs.

• Developed automated workflows, including database backups, linked table updates, and workflow notifications.

• Optimized system performance through bottleneck identification and troubleshooting.

• Documented database processes and provided end-user training and support to ensure smooth operation.

• Integrated Microsoft Access with other Office applications, automating processes like data exports and email notifications.

• Created advanced SQL queries for ad hoc data analysis and reporting needs.

• Designed and coded Event-Net, a web application for event registration, tee times, and leaderboard display using Visual Studio and SQL Server. AmberSoft Incorporated

Independent PeopleSoft Consultant October 1992 – March 1997

• Customized PeopleSoft General Ledger applications using Oracle databases, PeopleTools, and PeopleCode.

• Tuned database performance and optimized workflows to meet client specifications.

• Managed projects for prominent clients, including Schwab, NBC, and Partners Healthcare.

Online Solutions

Senior Software Developer September 1990 – March 1992

• Converted and enhanced IBM Mainframe applications to run on fault-tolerant Tandem Computers.

• Created tools and installation processes to support seamless system deployment. Cullinet Software

Senior Software Developer April 1988 – September 1990

• Migrated IBM Mainframe systems to Cullinet IDMS database platforms, improving functionality and efficiency.

Education

• Bentley University

4+ Years of Study in Computer Information Systems Waltham, MA

Contact this candidate