Classic VB, VBA, Access, Excel, and SQL Server Developer/Analyst

TECHNICAL SKILLS:

• Languages: All things related to classic Visual Basic (VB5, VB6, VBA for Access and Excel, COM, DCOM, OLE Automation, ADO (multi-user strategies – locking & concurrency), DAO, RDO, VBScript, Active X (both in process DLLs and out of process EXEs), Data Report Designer, Package and Deployment Wizard), SQL, T-SQL, Crystal Reports, Pivot Tables, IIS, ASP, HTML/DHTML, Visual SourceSafe, XML, XSLT, DOM, iGlue, Windows API, Sockets,Regular Expressions, InstallShield, WinRunner, Test Script Language, Version Control, White Box and Black Box QA,SDLC (full software development life cycle).
• Databases: SQL Server 6.5 through 2008 R2, Oracle,& Access, including database design, normalization (5 normal forms) and denormalization, primary keys, foreign keys, indexes, stored procedures, triggers and data macros, views, SQL (from inner and out joins to sophisticated recursive sub-queries), T-SQL (from control statements to cursors), DTS.
• Applications: MS Office (from 1990 to Present -- Access, Excel, PowerPoint, Outlook, Visio, Project, &SharePoint), Blackboard, DARS.
• Statistics/Research: SPSS, Hypothesis Testing, Regression, Multivariate.

PROFESSIONAL EXPERIENCE:

Confidential,

• (PT W2) Cincinnati, OH Aug 2007 - Present

Instructor/Researcher/Data Analyst
The University of Cincinnati (UC) is a research oriented university. During my Ph.D. program, I taught eight management courses (strategic management, organizational behavior, family business, and an independent study); and I engaged in significant governance (i.e., top management teams and boards) research, which resulted in one publication (Journal of Management Studies) and two conference presentations (SMS - Rome 2010 and AMR - Chicago 2009). As part of my research process, I engaged in extensive data collection, aggregation, and analysis.

• I analyzed and aggregated numerous flat file Excel workbooks from BoardEx, Compustat, Execucomp, and Audit Analytics, utilizing VBA, Macros, Pivot Tables, etc. I utilized Excel Reports to share important data with colleagues. I built Excel applications (i.e., data forms, sub forms, controls, etc.) that allowed research colleagues to more easily retrieve subsets of cross-sectional and longitudinal data for related governance projects.
• For larger Excel files (i.e., 100,000 + records per sheet, with multiple sheets per workbook), I utilized SQL Server DTS to import this data intoSQL Server 2008 R2. I used T-SQL (i.e., inner, outer, and other joins, sub, nested, and recursive queries, cursors, stored procedures, views, normalized and de-normalized data, control statements, cursors, and more) to clean, manipulate, and transform files into more meaningful data.
• I created an Excel application that checked fortune 500 and biopharmaceutical industrySEC documents(over a 20 year period), in MS Word format, for a variety of research criteria (i.e., names, ages, demographic data, board info, etc.), by utilizing OLE automation and regular expressions.
• I analyzed,cleaned, and aggregated data using various statistical techniques (i.e. OLS, negative binomial regression, and hypothesis testing) through SPSS.

Confidential,

• (Contract 1099) Cincinnati, OH Oct 2008 – Nov 2008

Software Developer/Analyst
Children’s Hospital focuses on pediatric health care, research, and education. I redesignedan Access database that hospital employees use to manage patients.

• I updated data access functionality, where appropriate, by transitioning data bound controls and forms to unbound controls and forms, so that the client would have more fine-tuned control of database select, insert, and update needs.
• I updated/added additional user forms (with appropriate sub forms and controls) for additional needed functionality.
• I provided reporting functionality to users.
• I retooled the backend (normalized for reduced redundancy and faster/more appropriate future changes).

Confidential,

• (FTE W2) Oxford, OH June 2005 – June 2006

DARS Associate
Miami University – DARS (which is now independent and known as RedLantern) department was a quasi-independent software development group, within Miami University, that focused on degree auditing, planning, and transfer advice. I supported the DARS software product.

• I trained new clients on DARS usage and implementation.
• I provided technical support for DARS customers.

Confidential,

• (PT W2) Dayton, OH March 2004 – June 2005

Research Assistant
Wright State University is a research oriented university. During my M.B.A., I helped my advising professor with research and grading.

Confidential,

• (Contract W2) San Francisco, CA Aug 2001 – Aug 2002

Software Developer/Analyst
Viking Technology (later subsumed by PEC Solutions, and then Nortel) specialized in the Federal Information Technology market, specifically designing custom, enterprise level, n-tier software for Fire, Police, and EMS departments in California. I developed/updated front end interfaces, middle tier Active-X objects (i.e., separate business logic and data access DLLs), and backend database needs (i.e., database design, stored procedures, etc.) utilizing Visual Basic 6 (VB6), ADO, COM and DCOM, SQL Server 7,Crystal Reports, and related technologies.

• I wrote/edited numerous middle tier business logic Active-X components (i.e., in process DLLs and out of process EXEs, depending on the need, using Visual Basic 6).
• I created/updated multiple middle tier data access Active-X components. New components were written utilizing ADO, while older components, that used DAO and/or RDO, were updated to ADO.
• I built a bar scanner interface for the Police application.
• I updated various SQL Server 7 databases -- tables, fields, primary keys, foreign keys, index changes, stored procedures and triggers (inner, outer, and other joins, sub, nested, and recursive queries, cursors, transactions, flow of control statements, etc.).
• I designed and maintained front end forms, controls, etc. that relied upon built in Visual Basic objects, Windows API, and 3rd party APIs.
• I enabled reporting needs using Crystal Reports.

• Confidential,
• (Contract W2) Sacramento, CA March 2001 – Aug 2001

Software Developer
RealtyPlusOnline (later acquired by First American Corporation) focused on internet real estate transactions in Sacramento, California. I built custom scripts, using VBScript.

• I wrote scripts that were included in HTML pages sent to web clients (i.e. Internet Explorer) to perform various tasks, generally related to the Document Object Model (DOM).
• I developed VBScript files that executed server side processing for ASP pages.

Confidential,

• (Contract W2) Sacramento, CA Jan 2001 – March 2001

Software Developer/Analyst
California Federal Bank (later purchased by Citigroup) specialized in savings and loans for California customers. I wrote an employee directory web application that allowed company personnel to retrieve pertinent employee information (i.e., email, phone, location, tenure, position, etc.).

• I designed a web application employee directory, using classic Active Server Pages (ASP) and HTML/DHTML.
• I tied into a SQL Server 6.5 database to retrieve and display appropriate information, utilizing SQL.

Confidential,

• (Contract W2) San Francisco, CA March 2000 – Dec 2000

Software Developer/Analyst
EBalance (which closed operations in Dec 2000) was formed to aggregate financial data for customers. Utilizing iGlue, VBScript, XML, XSLT, and the DOM, I wrote hundreds of scripts to scrape data from a variety of financial websites (checking and savings accounts, stock portfolios, IRAs, etc.) for storage in an Oracle database. EBalance then provided customers with a one stop location (i.e., website) where they could view all of their financial data.

• Confidential,
• (Contract W2) San Francisco, CA June 1999 – March 2000

Software Developer/Analyst
Providian Financial Corporation (later acquired by Washington Mutual) was one of the largest credit card companies in the US. Using Visual Basic 5, Access, and SQL Server 6.5 &7, I developed several applications that helped facilitate collection on delinquent credit card accounts.

• I wrote multiple in-house Access applications, where Access was used as both the front end and back end, to facilitate delinquent credit card account collections. I wrote the front end, which consisted of standard forms, sub forms, controls, reports, etc. I also wrote the back end, which was made up of normalized data, tables, primary keys, foreign keys, indexes, etc.
• I rewrote several Access database applications to Visual Basic 5, DAO, RDO, and SQL Server 6.5 &7.
• I provided reporting capabilities utilizing Crystal Reports.

Confidential,

• (FTE W2) Cincinnati, OH Aug 1998 – June 1999

Software Developer/Analyst
Charles H Mack and Associates specializes in care management service software.
Utilizing Visual Basic 5, DAO, RDO, SQL Server 6.5, InstallShield, Crystal Reports, and related technologies, I developed a software application for an external client (CPAN – Cincinnati Post Acute Network)that automated the process of transitioning acute care patients from hospitals to less acute care facilities.

• I engaged in extensive client meetings to gather user requirements.
• I developed the front end application, using Visual Basic 5.
• I created a SQL Server 6.5 database as the backend, including all tables, fields, indexes, primary and foreign keys, stored procedures, triggers, etc. Using DAO and RDO, I used a mixture of SQL statements on the client side to execute queries, updates, inserts, and deletes. In addition I also used stored procedures on the back end to execute important business logic and data access needs.
• I developed multiple reporting options, using Crystal Reports.
• I utilized InstallShield to build the application for client distribution needs.
• Confidential,
• (Contract W2) Cincinnati, OH Jan 1998 – Aug 1998

Quality Assurance Lead/Analyst
General Electric Aircraft Engines (GEAE) is a provider of military and jet engines and components as well as avionics, electric power, and mechanical systems for aircraft with an extensive global service network to support these products. I was tasked by the Material Management division to establish quality assurance processes.

• I developed a Visual SourceSafe (VSS) database that helped ensure appropriate version control for Material Management application rollouts, while simultaneously providing backups for source code.
• I tested software using WinRunner and TestScript Language. WinRunner is a GUI testing tool that allows users to record and playback UI interactions as test scripts. By using TestScript language, I was able run WinRunner scripts with an array of different input values to test whether code would breakdown under various conditions. I engaged in both black box and white box testing.

Confidential,

• (PT W2) Oxford, OH Aug 1997 – Dec 1997

Systems Analysis (i.e., Computer Science) Instructor
Miami University is a teaching oriented school. I taught two introductory systems analysis courses to undergraduate students that focused on Microsoft Office (Access, Excel, and PowerPoint). Class included introduction to VBA programming.

Confidential,

• (FTE W2) Saint Louis, MO June 1996 – June 1997

Operations Manager
American Multi-Cinema (AMC) is a movie theater chain. I was an operations manager tasked with co-managing a multi-million dollar operation with 100+ employees across two locations, profit and loss, employee scheduling, employee recruitment, retention, mentoring, loss prevention,inventory management, etc.

EDUCATION:

University of Cincinnati In Process
Ph.D. in Management

Wright State University 2005
M.B.A., Concentration in Information Systems
4.0 GPA

Miami University 1995
B.Sc. in Education
CERTIFICATIONS
Microsoft Certified Professional – Visual Basic 5 1999