For the Federal Reserve Bank of Chicago, provided SharePoint support to Chicago region. Worked closely with internal bank customers to design, create, and implement new forms and business process workflows (using InfoPath, Nintex, SharePoint). Made extensive use of state machines to provide maximum flexibility to reviewers and approvers to be able to return documents and forms any number of times for further review and modification. Developed new or refined existing PowerShell scripts to populate SharePoint lists for use in workflows. Participated in Office365 and SharePoint Online strategy, planning, governance, migration. Helped to organize Office365 Adoption Champions Team.
For The Roundtable Group (formerly TREWS), Qualified Litigation Consultant. Expert witness in a legal dispute between two distributors. Plaintiff’s claim hinged on evidence stored in Microsoft Access database. Filed expert opinion report in the form of an affidavit.
For city government, performed complete redesign of city permitting system in order to overcome design deficiencies and scripting errors, which enabled processing of more permits with fewer resources. Designed, created, and maintained a number of systems written in MS Access/VBA.
For large home improvement company, performed technology audit, recommended changes to provide consistency and align with business model, strategy, and goals. Implemented VOIP system. Introduced best practices for Help Desk, QA/QC. Planned improvements to network. Managed and select new vendors. Developed and implement plan for new ERP system and conversion of existing system to Sql Server back end.
With a business partner, managed C# development team in the design, development, and testing for Parts to Pull, a shrink-wrapped software product for auto salvage yards to track puller and dismantler jobs through completion, pay commissions, measure productivity. Platform: C#, SQL Server, InstallShield.
For Fortune 500 food corporation, participated on VB.NET development team on rapid-turnaround assignment to enhance mission-critical Pipeline Visibility Tracking program which runs on the company’s intranet; tracks the development of all new products.
Automated production of annual Department of Insurance report for large insurance company
For estate bond firm, managed design and programming of estate bond database management system. Platform: C#, SQL Server, SQL Server Reporting Services.
Value-Added Reseller of TM1™ Perspectives OnLine Analytical Processing (OLAP) Database Engine (Add-On to Excel) for two years.
For an insurance agency (car insurance and financing),
worked with leadership on business process improvements, including operations, information systems, web site, financial systems, strategic alliances, vendor relations, personnel, marketing and advertising, legal. Reviewed and analyzed profitability of products; recommend new lines of business. Collaborated with CTO to develop software solutions; identify specific needs and maintain/enhance software as needed to improve productivity and profits. Participated in recruitment activities; interview, hire, and negotiate salaries and terms of employment. Established and maintained strong working relationships with key stakeholders.
Designed and managed the development of EMS, complete agency management/premium finance/accounting policy management system, which imports/exports data from/to a third-party rating and quoting system. Platform: MS Access/SQL Server.
Designed and programmed a set of management reports which provide performance and profitability metrics on brokers, lead source, and insurance companies.
Spearheaded turnaround of organization, collaborating with executive management to increase productivity levels, reducing operating and administrative costs and increasing sales.
Managed the design and programming of their website, which provides real-time rating and quoting, exports results to agency management system.
For large home improvement company, performed technology audit, recommended changes to provide consistency and align with business model, strategy, and goals. Implemented VOIP system. Introduced best practices for Help Desk, QA/QC. Planned improvements to network. Managed and selected new vendors. Developed and implemented plan for new ERP system and conversion of existing system to Sql Server back end.
Redesigned customer service system for major telecommunications company, which eliminated use of expensive service, saving approximately $250K annually.
For Silicon Valley startup, designed and implemented website, SEO and affiliate marketing strategy.
Managed the redesign of a supermarket coupon database management system .
Automated report/reimbursement workflow for major bank.