About Us

Resume

Natalie Rynda

Recent notable projects

• Developed an MS Access/VBA application for a warehouse with a unique workflow. Among the challenges was a very high-pressure environment (deadlines for some tasks were in minutes when the truck was waiting), lack of process documentation (had to figure things out myself under constant rushing) and a complex import procedure. The app functioned on data from various imports, extensive import error catching process had to be developed (they would get a list of errors after every import and an easy interface to fix them). In the end, the app automated all their daily tasks.
• Developed an MS Access/VBA billing application for a financial advisement company. The app got most of its data from multiple imports, so an automated, user-friendly import process had to be developed which validated the data and provided information on import issues. It processed monthly reports and quarterly billing. Some data for each account was entered manually, so, many data cleanup procedures were developed to ensure that all accounts had all required fields filled in. If an account was still missing data at the time of sending out reports – the report wouldn’t go out and a notification popped up telling them what had to be filled in. It also stored historical data, gave them the ability to run report for previous periods and logged sending of the reports and bills.
• Developed an MS Access/VBA application for a gym. The app allowed to time a training session, stored various workout regimens, each with a set of exercises, and on each session the trainer can record the reps and weights for each exercise. It also had a complex scoring algorithm to rank how the clients compares to others in the gym.

Responsibilities

• Develop MS Access/VBA applications for various businesses.
• Develop MS Access/Excel/VBA automation procedures.
  

Notable projects and achievements (in all of these, I managed full cycle of development from requirements to testing)

• Designed, developed, and maintained 60 complex automated reports which could not be automated with our standard methods because of many layers of complexity (outside messy data, matching, complex Excel formatting, constant changes of criteria, etc.). I automated them using Oracle stored procedures, MS Excel VBA, and an MS Access/VBA front end. Automating these reports saves hundreds of hours of manual work per week and eliminates mistakes. My applications are still being used by the company.
• Saved company $7,000 a month by recreating and automating a set of reports which used to be supplied by a vendor. The challenge was to reverse engineer their logic.
• Designed and developed an MS Access/Oracle matching application which allows the user to easily match any outside data to company data using 4,000 field combinations. It provides the user with many configuration options and allows automated matching file uploads. It assigns a match strength % to each matched record and allows the user to set a threshold for the number of matches per record. This application saves tens of hours of manual work per project.
• Automated a set of complex client reports which used to take weeks of manual work by various departments. The challenge was that these reports required data from external websites, which was not available for download, only to lookup. That data then had to be manually matched to ours and the reports had to pass state-supplied, complex validation process.
• Developed an MS Access/Oracle application that scrapes the data from the websites, matches it against company data, creates reports, performs validation, and emails results. The reports now take 30 minutes to run and do not require any manual work.
• Designed and developed an MS Access/Oracle automation and project tracker application. This application allowed for easy automation of any report, automated my workflow, it also automatically wrote SQL code for each project based on criteria selections, allowed for centralized changes to report logic, report configuration and distribution lists and performed many other tasks. The use of this application enabled me to consistently meet very tight client deadlines, minimized mistakes and saved me thousands of hours of manual work.
• Designed and developed an MS Access/Oracle application for creating call campaigns. There were many challenges and complex output requirements. Each campaign used to take a few days of manual work. My application creates a campaign in 15 minutes and requires no manual work.
• Because of my automation skills, to quote our department's VP, "I was doing the work of 3-4 people". It took 6 months for me to transition my work before I left, and they still contact me with questions.

Responsibilities

• Developed complex ad hoc reports and applications based on specifications provided by requestors.
• Analyzed data, looked for hidden patterns, developed algorithms and predictive models.
• Worked with messy data from various sources (including databases, manual files, and external websites), cleaned it up and combined it accurately.
• Developed and rewrote applications and SQL code to optimize and/or adapt to new requirements.