We can organize an interview with Aldin or any of our 25,000 available candidates within 48 hours. How would you like to proceed?
Schedule Interview NowMy name is Jennifer L. and I have over 9 years of experience in the tech industry. I specialize in the following technologies: Technical Documentation, Microsoft Excel, UX Writing, User Experience, Google Sheets, etc.. I hold a degree in CIS, MBA. Some of the notable projects I’ve worked on include: Demo reel of Google Sheets projects, Team Sales Estimation Tool, Automated Quote System, Sales Metrics, Health Tracker, etc.. I am based in Oxford, United States. I've successfully completed 10 projects while developing at Softaims.
I possess comprehensive technical expertise across the entire solution lifecycle, from user interfaces and information management to system architecture and deployment pipelines. This end-to-end perspective allows me to build solutions that are harmonious and efficient across all functional layers.
I excel at managing technical health and ensuring that every component of the system adheres to the highest standards of performance and security. Working at Softaims, I ensure that integration is seamless and the overall architecture is sound and well-defined.
My commitment is to taking full ownership of project delivery, moving quickly and decisively to resolve issues and deliver high-quality features that meet or exceed the client's commercial objectives.
Main technologies
9 years
8 Years
1 Year
3 Years
Potentially possible
Salesforce
Productivity solutions based in Google Sheets (or Excel) using apps script based on web application principles without the web app complexity and cost
Client needed an estimation tool for the sales team to be able to access with current pricing to provide to their customers. Multiple sales team members would access the tool at the same time. I created an Excel sheet that contains the products and services, pricing structure, calculations, and outputs estimates. The video and screenshots shown are from the Google Sheets generic version that I created for demonstration purposes with all customer data and references removed. This type of tool can be built in either Excel or Google Sheets. Client required Excel.
Automate calculations for printing price quote requests and output PDF files
This is a recent project. The client has two divisions - one for sales and one for accounts. Based on their directions, I developed reports for both divisions using data they provided from their CRM. The tabs for Sales and Accounts work independently but both pull from the data tabs. Unneeded tabs can be hidden or removed completely for each manager to view. All data that is touched - so anything that requires manual updates or imports - is kept on separate tabs from reports including information that populates drop-down lists. In the first image you can see the sales rep report. Everything on the report updates based on the start month and sales rep name which is why those selectors are separated completely and above this section. The down lists in the separate section update only the STATS section. Second, you see the Historical Sales Report. The start month is modifiable like the previous report and the proposed rate can be changed. On the left side, which sales rep's data should show in each section can be changed by selecting the sales rep from the hidden dropdown menu. The names are actually a selection. Entire new sections can be added by copying and pasting because all formulas are set up to allow expansion of the report. Likewise, new columns can be added easily by copying to the right. This is consistent throughout each report. Jumping over to Accounts in the third image, you can see the report is similarly laid out. Here there is a sub-option to select and view details for sales of specific plans by property and agent. This was designed to keep the columns to a minimum. The last image shows another historical report where you can see that there is a date selection which determines which 18 months of data to review. In the lower section, you can choose to see data in each cell for any combination of Agents/Properties and Leads/Revenue.
With this health tracker for weight, you first determine your BMR with the chart provided. Calculations are done to convert weight in pounds to kg and then a BMR number which is your base of calories. You then decide how much of a deficit you want to try to achieve each day to meet your goal. If you fall off and need to start again, you can change the date and reset the sheet to a new start date for progress. Then the sheet has a food and exercise log that you update daily. I created a Food List tab where you add all of the foods you eat so that you can reselect them each time in the log. The exercise log has the same feature for your preferred exercises. With that information the Daily Tracker tab shows your results. I also added a Meal Calorie Planning tab which has all of the foods you have in your food list available to select for meals to pre-plan your week.
CIS in
MBA in