Maintain, build, and validate product hierarchies for perishable food databases containing items from the fresh departments of major grocery stores nationwide. Customize to address the business needs of diverse database clients including retailers, producers, and other food industry organizations. Platform/tools: MS SQL Server, T-SQL, Management Studio, Access.Work together with account managers to determine true client needs, provide expertise on perishable products, and make recommendations for hierarchy design and problem resolution. Develop business rules and write corresponding code for moving items into desired hierarchy locations. Maintain primary ownership of update/refresh, issue resolution, and enhancement projects for assigned databases.Take on the daily challenge that perishables data presents. Analyze ambiguous and incomplete data to determine basic item type, detailed characteristics, hierarchy placement, dollars and volume accuracy, and impact when corrections are made. Field questions to help account managers and clients understand data, products, and hierarchies. Handle or coordinate fixes where necessary.Together with an extended team, perform ongoing data quality checks of high impact items, QC complex custom client reports, and work on special analysis projects.Collaborate on wider Perishables Team projects and thought leadership, new staff training, and ongoing learning presentations to share fresh department knowledge and business skills.

Part of a small team of database analysts working on large direct marketing database of major, multi-brand, retail/catalog company. Apply database updates, monitor and coordinate activity, perform maintenance, handle special projects. Platform/tools: UNIX, Oracle, SQL, Toad for Oracle, DataStage, VI Editor.Co-developer of custom mainframe relational database created to test a client’s proposed retail loyalty program. Client moved forward to launch a full-blown loyalty program. The effectiveness of the test project contributed to winning subsequent business from the client.Handled all facets of service delivery for complex UNIX/SAS process that split client names into segments for specific credit card offer types. Performed all of the following tasks and roles: processing, consulting, projects, and programming. Functioned as client partner and central point of contact between client, sales, and management.Lead database developer for build/launch of successful, extremely innovative b2b cooperative direct marketing database.

Lead database analyst for direct marketing client databases of various configurations (mainframe relational and non-relational), serving various business types (catalog, retail, publishing). Mentor/trainer/consultant for other database analysts who worked on these accounts.

Lead database analyst for direct marketing client databases of various configurations (mainframe relational and non-relational), serving various catalog and retail clients. Mentor/trainer/consultant for other database analysts who worked on these accounts.

Responsible for programming and/or documenting significant portions of rebuilds of direct marketing mainframe relational databases for two large catalog/retail companies.Successful completion of several, large Y2K projects on direct marketing databases. Achieved Y2K certified status on these databases, from both internal and external auditors. Lead database analyst for the domestic and international direct marketing databases of well-known trade show. Performed updates, maintenance, and special projects. Provided guidance for other database analyst working on the account.

Lead database analyst for large direct marketing database of well-known retailer. Platform/tools: mainframe/DB2/QMF/SQL. Responsible for special projects. Trained and supervised Database Specialist in routine update/maintenance of the database.

Performed updates, maintenance, and special projects for large direct marketing database of well-known retailer. Platform/tools: mainframe/DB2/QMF/SQL.

Administered circulation, public service desk, and bill and fine operations at the library.Hired, scheduled, trained, managed, evaluated, and supervised 40 – 45 part-time employees.Served on Northwestern University Library policy, procedure, advisory, and search committees.Generated annual budget for 50 to 55 part-time employees in the Circulation Department and all other departments within three branch libraries at Northwestern University. This involved extensive budget analysis, determining staffing requirements, obtaining executive approval of budget, and monitoring personnel expenses throughout the year to stay within budget.Developed and implemented creative staffing solutions to stay within this very complex budget.Created, implemented, evaluated, and revised procedures and systems to carry out operations of the Circulation Department.