Welcome to the “Peoplesoft and SQR” web log. My name is Steven Alexander. I worked on Peoplesoft HCM from November 1997 to October 2011 in various installations running with Oracle DBMS on UNIX file servers and Microsoft Windows client PCs.
I started this blog in January 2009 with the name “Peoplesoft SQR.” For the first year, it was about the SQR programming language and how best to use it. I wrote about techniques and algorithms, commands, and how to thrive within the Peopletools environment.
Adding a conjunction to the blog title reflected a wider range of topics. In 2010, I continued to write about the SQR programming language. I also wrote about Peopletools and using SQL (that’s an L, not an R) with the data in the Peoplesoft HCM modules (Human Resources, Base Benefits, Payroll, and Time & Labor).
I changed employers in April 2010. My new employer was a consulting firm where we earned our living by selling our intellectual property. I stopped this blog in deference to my new role.
I started my own business in November 2011, outside the world of Information Technology. My wife and I created and operated Pee Wee Bees, an indoor playground and birthday party place. We provided a comfortable environment and an enormous toy collection to children between 6 months and 7 years old. It was a very exciting and enjoyable five-year adventure.
I was my own Information Technology department. I created our website, our Facebook page, and our Google business page. I created our customer database in the Microsoft SQL Server database that came with our Denali Accounting package. I wrote a variety of Business Intelligence reports, but without SQR or other BI tools, I implemented them with views. Since I didn’t have access to a Peoplesoft environment, I could not supply PeopleSoft-relevant code samples for this blog.
We closed Pee Wee Bees at the end of our lease in February 2017. It was disappointing, but the concept was unprofitable and didn’t show a potential for growth. I started the Master’s of Science – Data Analytics program at University of Texas at San Antonio (August 2017 – August 2018), which will be the basis of my next career.