Smart Consulting, LLC.
Devon, PA
Business Consultant, Business Consultant Senior
- Designed and created relational database structure for three large projects.
- Created DTS Packages using MS SQL Enterprise Manager to synchronize production and development environments for a major distributor.
- Administered SharePoint to coordinate shared documents and applications for a twenty-person team for a major insurance company.
- Created scripts to upload documents to SharePoint portal via its exposed Web Services.
- Developed tool for use in cross ledger reconciliation using Excel VBA for a major insurance company. The tool provided functions to assist in reconciling schedules consisting of up to two thousand lines. These functions included the ability to automatically capture matching amounts across ledgers, data integrity validation, hiding of reconciled sums, smart subtotals, and system generated hyperlinks for matching amounts.
- Developed Access tool to generate schedules via exported Cognos data and previous period data for a major insurance company.
- Wrote and designed training, requirements, and design documents for many applications.
- Developed Metastorm BPM workflow application for major food processor.