
Social Media and Business Intelligence Consultant, Community Builder
Cincinnati Area

Social Media and Business Intelligence Consultant, Community Builder
Cincinnati Area
I wear many hats.
BUSINESS INTELLIGENCE
* Diverse Business Intelligence (BI) experience in many industries, designing and developing Decision Support Systems (DSS).
* Server-side development, optimizing and creating new systems using SQL Server 2005 Management Studio, which is tied closely to a version of Microsoft Great Plains Dynamics customized for the PEO industry. Currently runs on SQL Server 2000, but organization is moving to SQL Server 2005 this summer.
* SQL Profiler traces have been highly valuable in uncovering underlying tables and troubleshooting processes. Investigated SQL Server Reporting Services, looking to help company implement it for reporting later this year.
* SOFTWARE: Access 2003, SQL Server 2005 Management Studio, SQL Server 2000, Visual Basic for Applications, Excel 2003, Outlook 2007, MySQL, Microsoft Great Plains Dynamics 9
SOCIAL MEDIA
* Enthusiastic early-adopter of blogging, podcasting and new media, as fan, producer, and activist, developing and contributing to the community.
* In 2007 I set up and managed online public relations (PR) for a local domestic violence community awareness walk, using social media tools such as MySpace, Twitter, and podcasting.
* In October 2007 I founded the New Media Cincinnati social media group to promote awareness of new media and social media in Greater Cincinnati, Northern Kentucky and Dayton, helping others connect. Members report that they've benefited professionally and financially through connections they've made.
* Looking for opportunities to further use social media marketing, public relations, and analytical skills I've developed elsewhere in and around the Greater Cincinnati area. I get the biggest satisfaction from work where I see I'm helping others and look forward to helping you where I can.
IMPORTANT: I periodically send out updates about what's going on in my personal and professional life. Connecting with me means you'll get a copy.
Power networker and connector; social media expertise, community builder, defining requirements, managing customer expectations, application development, business intelligence, analysis, decision support systems, online branding and public relations
(Online Media industry)
October 2007 — Present (1 year 10 months)
New Media Cincinnati is a social media group for people in the Greater Cincinnati, Northern Kentucky, and Dayton areas involved with or who have an interest in new media (podcasting, video podcasting, blogging, micro-blogging, social networking, etc.).
I founded this group to help connect others in this space and promote new media in the Greater Cincinnati, Northern Kentucky and Dayton areas. Every month I organize meetups and through digital outreach promote the events.
I have spoken and facilitated discussions on managing multiple online identities and why someone would want to attend a new media unconference like Podcamp. In 2009 I have led meetings where the group participated in an in-person social tagging exercise, 5-minute JOLT discussions, and new media roundtables.
In May 2009, we conducted our first New Media Cincinnati Unconference, in which attendees organized into clusters to discuss specific topics of interest to them.
(Religious Institutions industry)
May 2006 — Present (3 years 3 months)
Provide audio/visual support for worship services. Includes running 40-track mixing board, lighting system, tape deck and CD player, DVD player, MediaSHOUT, lighting mixer, and digital recording of sermons to be posted to church's website. This position demands the ability to work in an ever-changing, multi-tasking environment behind the scenes.
In 2009 I began posting live updates via Twitter of worship services and have approached the leadership about having a Deacon of Social Media. My efforts in this respect have been featured in MSNBC and in other media.
(Media Production industry)
January 2002 — Present (7 years 7 months)
Jazzmania Productions is the name of an umbrella group I'm using for all my personal new media blog and podcast properties, including
+ How I Got My Job (howigotmyjob.com)
+ Get That Job! (getthatjobonline.com)
+ Journey Inside My Mind (journeyinsidemymind.com)
+ QuotesBlog (quotesblog.blogspot.com)
(Privately Held; Human Resources industry)
January 2005 — June 2009 (4 years 6 months)
PaySource was a great company to work with and further develop my analytical skills. Here are some examples of my accomplishments there:
- Implemented server-side processing with SQL Server for custom reports previously developed in Access that improved performance by 95 percent.
- Developed custom applications to transform raw payroll data for thousands of employees into a format that can be uploaded into the payroll management system, saving hours of payroll processing time. One specific client's payroll went from taking over three hours to produce to only 30 minutes.
- Developed custom Business Intelligence (BI) tools and Decision Support Systems (DSS) to fulfill 401(k) reporting, open enrollment for benefits, worker's compensation reporting, and overall business process requirements.
- Developed custom Business Intelligence tool to better facilitate operations tracking for a courier company.
- Streamlined existing systems by moving from Access database engine to SQL Server, improving performance.
(Non-Profit; Professional Training & Coaching industry)
June 2009 — June 2009 (1 month)
At the Podcamp Ohio 2 social media unconference in Columbus, Ohio, I gave a talk entitled "Real people. Real job-hunting success stories." I shared 5 qualities of successful job seekers, based on what I have found from conducting interviews with them, using their own words.
(Events Services industry)
February 2009 — April 2009 (3 months)
In April 2009, I gave a talk entitled "The Emotional Side of the Job Search" to a group of about 50 job seekers. This interactive discussion covered the wide spectrum of emotions felt and techniques to stay positive.
In February 2009, I gave a presentation entitled "Real People. Real Job-hunting Success." to a group of about 150 job seekers. This inspiring presentation discusses "How I Got My Job," the ongoing job-hunting success stories audio series, which is found at http://howigotmyjob.com
In the presentation, I talk about how the project came to be, how people can access and use the website, some of the initial findings and common threads that have been discovered among successful job seekers. I also share some of the job-hunting success stories to inspire and encourage the group.
(Government Administration industry)
April 2009 — April 2009 (1 month)
I worked with Mike Boehmer to put together a Social Media Release using Pitch Engine to help publicize Hamilton County Job and Family Services (HCJFS)'s activities for National Foster Care Month in May 2009. This social media release was done in connection with the other media outreach activities HCJFS conducted.
(Events Services industry)
June 2008 — June 2008 (1 month)
Volunteered to assist Podcamp Ohio in digital outreach and delivered a 45-minute session on Managing Multiple Online Identities, discussing the challenges that the various social networks present along with some strategies and tools that help in managing one's presence on them.
If you attended PodCamp Ohio and my session, I'd love to hear your feedback!
(Non-Profit; 1-10 employees; Non-Profit Organization Management industry)
August 2007 — October 2007 (3 months)
- Organized and set up online presence for the One Voice Domestic Violence Community Awareness Walk, held in Cincinnati, Ohio
- Promoted the 2007 One Voice Walk through social media (blogs, podcasting, other social media networks), communicating the 'onevoicewalk' brand
- Recorded audio during the walk, which was held in September 2007
- Released audio to the internet during October, National Domestic Violence Awareness Walk
- Ongoing management of the social media presence, continuing to raise awareness
(Food & Beverages industry)
February 2004 — November 2004 (10 months)
(Privately Held; 51-200 employees; Food & Beverages industry)
August 2003 — January 2004 (6 months)
Fill drink orders that waiters and waitresses take from customers. Prepare dozens of standard mixed drinks accurately, quickly, and without waste, even during the busiest periods. Check identification of customers seated at the bar, to ensure they meet the minimum age requirement for the purchase of alcohol and tobacco products. Directly serve and interact with patrons. Friendly and helpful with customers.
(Self-Employed; Myself Only; Internet industry)
March 2003 — May 2003 (3 months)
- Designed web site for a construction company that enables customers to accurately understand the services it provides.
- Developed the corporate web site using HTML and JavaScript.
(Public Company; 10,001 or more employees; Information Technology and Services industry)
November 2002 — February 2003 (4 months)
- Rebuilt a Resource Planning tool used by vice presidents, financial analysts, and program managers that transforms raw project cost and resource data into easy-to-read reports, saving hours of computing time.
- Managed client expectations by building enhancements to the application, based on additional requirements from end users.
(Public Company; 1001-5000 employees; Information Technology and Services industry)
August 1998 — June 2002 (3 years 11 months)
- Defined requirements with end users and crafted technical design for an application that generates information for NAFTA certificates, which saves company millions of dollars annually.
- Managed a team of resources to document mission-critical end user applications to perform actual conversions from legacy systems. Conferred with business owners, end users, and management to verify that the new applications performed the same and/or better than the legacy applications.
- Supported complete software development life cycle proces to develop multi-tiered, Intranet-based Product Data Management System from a Software Quality Assurance perspective. Analyzed business requirements and functional specifications.
(Public Company; 10,001 or more employees; Information Technology and Services industry)
November 1997 — June 1998 (8 months)
- Teamed with MIS to enhance existing databases used to generate monthly sales reports for upper management.
- Developed a system that automatically gathers and compiles sales information from several time periods into a summary report, saving processing time and eliminating errors.
- Redesigned tools that compile sales and project information to generate reports that help guide upper level management in their decision-making.
(Public Company; 201-500 employees; Building Materials industry)
September 1994 — September 1997 (3 years 1 month)
B.S. , Civil Engineering , September 1988 — June 1994
Graduated with 3.0/4.0 GPA. Received Professional Practice Certificate.
helping solve problems, public speaking and presenting, connecting with othes, podcasting, music, promoting other people and ideas, reading, learning new technology
Time Magazine Person Of The Year, 2006 ☺