Work History

Contents

- Objective
- Summary of the Advantages Offered
- Experience
- Examples of Work
- Education
- Additional Languages
- Work Status

Objective

Database or report development, business or data analysis, project management or research related position.

Summary of the Advantages Offered

I use my experience from all the database application development fields to build effective bridges between the users needs and the development capabilities, and devise solutions so that the outcome adheres to the budget and schedule, has good quality and usability and increases user productivity.

As an analyst, developer and project manager, I am very good at workflow, information flow and business process identification and analysis, documentation and relevant application and solution development. I approach project implementation from the users needs, goals and milestone structure perspective, identifying the objectives and scope, cost-effective development steps, resource needs and other relevant variables.

Experience

09/11-10/11  Analyst / Developer, self-funded project. Updated MS Access based SalesGetter CRM sales planning and management application prototype that I had developed in the past. The prototype contains sales process management and planning tools that enable to assess performance related aspects, to determine the accounts that each salesperson has been working on, the results that were generated and aspects that can be improved. Production environment application can be built using any relational database software.

01/09-08/11   Analyst / Developer / Project Manager, self-funded project. Developed a creative thinking skills management method, CreativityModel Method, and made it available as an open source project through Creative Commons license.

• Developed a scalable and programmable creative thinking skills management method that addresses goal oriented business creativity and self-expressive artistic creativity usage, so that both types of creative thinking skills can be combined as necessary. Further, intelligently behaving application functionality can be created with less resources than artificial intelligence engineering and expert systems require.
• Documented creative thinking processes from creativity usage perspective. Used an approach that is similar to documenting subject matters and information flow (workflow) in IT business analysis cases for complex applications. For project specific rules used US patent application filing guidelines.
• Developed a website that functions as creativity management industry resource site and helps to put CreativityModel Method into context through comparisons.
• Developed specifications for custom built blogging software user facing
  front-end functionality and content management system.

08/08-12/08  MS Access/Excel Developer / Business Analyst, Brown Brothers Harriman partnership based, privately-held global financial services firm. Worked as a contractor through Sapphire Technologies.

• Interviewed users, based on user needs analysis put together application functionality specifications, verified planned project scope, development steps, timetable and functionality with user group representatives.
• Developed Data Processing Application for Brown Brothers Harriman Billing Department. The Application imports data from Excel and CSV files, processes data for billing purposes, identifies the exceptions, separates the exceptions from the rest of the data for different type of data processing, and allows the users to export the billing-related data into another database (that was built in the mid 1990s using Smalltalk).
• Developed Issue Tracking Application for Brown Brothers Harriman Billing Department. The Application helps to manage sub-custodian banks payment discrepancy solving issues.
• Developed Trade Repairs Data Processing Application for Brown Brothers Harriman Billing Department. The Application keeps track of all the trade repairs billing data and generates on demand relevant Excel workbooks, using automation. Users of Excel 2000 have the ability to put hundreds of thousands, or if needed, millions of records of data into Excel workbooks, regardless of Excel's worksheet limitations.

04/08-07/08  MS Access/Excel Developer / Business Analyst / Project Manager, Covidien, (formerly Tyco Healthcare), large healthcare device and supply company. Worked as a contractor through Kelly Engineering Services.

• Interviewed users, identified project scope, development steps and timetable, put together application functionality specifications, verified planned functionality with the application user representatives.
• Developed Duplicate Auditing Database Application for Covidien Human Resources Department. The application imports data from Excel and another database, helps to compare the data sets, to identify duplicate and matching entries, and to decide which rows of data should be deleted. Results can be put into Excel.
• Developed Benefits Auditing Database Application for Covidien Human Resources Department. The Application imports different type of data from Excel workbooks, helps to compare the data and to identify fields that contain discrepancies. Results can be put into Excel.

08/07-03/08  Founder / Analyst / Developer, Project Developer, Inc., custom database application development company.

• Developed company website, branding, logo, symbol, design, site architecture, a proprietary search engine and wrote website content.
• Developed SalesGetter CRM sales planning and management CRM application prototype that can be customized for individual companies needs.

09/04-07/07  IT Project Manager, InfoTrends, Inc., leading international market research and strategic consulting firm for the digital imaging and document solutions industries.

• Interviewed users, identified project scope, resource needs, development steps and timetable, put together application functionality specifications and prototypes, verified with user representatives.
• Researched sales CRM options, interviewed company's sales personnel and consultants / market analysts, analyzed organizational information flow from CRM development perspective, did cost/benefit analysis.
• Handled application programming tasks, automation (data transfers between Access, Excel, Word, SQL Server, CSV), application architecture, navigation structure, user interface design, quality control, wrote User Guides. Used VBA, DAO, ADO, T-SQL, Data Transformation Services, Crystal Reports, SharePoint.
• Developed solutions and worked with complex Excel based forecasting tools that contain large numbers of linked Excel workbooks and worksheets. The tools are used for forecasting different aspects of digital imaging and document solutions industries. Used pivot tables, variety of Excel formulas, reporting, VBA.
• Developed Events Management Application that decreased application usage-related labor needs and increased user convenience and accuracy. Application users can plan and manage any number of different events year after year with minimized need for data entry.
• Developed Research Application that cleanses inputted lists of data and uses list marketing principles.
• Occasionally provided miscellaneous network administration and help desk support.

02/02-08/04  MS Access/Excel Developer / Business Analyst / Project Manager, independent contractor. Primary customer was Fleet Bank (now part of Bank of America) Branch Training Departments.

• Interviewed users, analyzed and documented the requirements and specifications, handled database development, programming, user interface design, quality control, training.
• Developed a scheduling application, training results storage and analysis application, and a training calendar creating application. Developed MS Excel reports and complex reporting functionality, scheduling tools, training calendar.

07/96-02/02 International business and sales (sports apparel, gift items), then sales in the US (Toyota vehicles, furniture), then research assistance, IT and Web development support, database development. Increasingly focused on database development and business analysis, used primarily MS Excel and Access.

Examples of Work

Below are examples of my work as a business analyst and database application, report and report center developer. All this information is on this website, so, you can explore it safely.

• The Previous Work Experience section contains quite a bit of descriptive information on applications, functionality and user interfaces that I have put together as database application architecture and navigation structure developer, table structure and other objects developer and programmer, and user interface designer and usability engineer.
• Additionally, below are examples of my work as a business analyst.
• The first two business analysis examples represent small-to-medium size applications with relatively complex functionality.
• The third, fourth and fifth example, the custom developed blogging website front end user-facing functionality specifications, and the back end content management system specifications, and the sales CRM application prototype, took a lot of business analysis work to put together. These are all big and complex projects by any company's standards.
• The sixth example is an unusual project that also helped to develop further my business analysis and documentation skills. There are probably very few technical business analysts who have worked on a comparable project.
• Putting together documentation that both the application user group representatives can understand and the developers can use is not easy. Big projects with very large number of interrelated details get exponentially difficult to document. I am one of the people who can actually do this type of work well. So, this is one of the skill sets that I offer to my employer.
• Additional comment: I have worked in a "waterfall" manner and also in an agile manner. I would say that having sufficiently comprehensive specifications and other forms of documentation can be very helpful for most IT projects. However, the documentation and the project management process should be kept flexible enough, so that modifications can be made as needed.
• 1) UsersRequirementsStatement_2004_01.pdf is from working with a group of people at Fleet Bank in 2004. I took about 1 month of work and meetings with both regular users and executives to put together this rather complex trainer, room and equipment scheduling application specifications.
• 2) PD_Search_Functionality_Description.pdf is a set of specifications for custom built search functionality development. The developers were overseas. Working with the developers this way is more difficult than is working with developers with whom you can personally interact. I have worked with both onshore and offshore developers and that makes my background more valuable to my employer.
• 3) 2010_CMM_V01_Blogging_Site_Development_V29.pdf describes custom developed blogging website functionality front end specifications and requirements.
• 4) 2010_CMM_V01_Blogging_Site_Dev_CMS_V54.pdf describes custom developed blogging website content management system specifications and requirements.
• 5) Putting together SalesGetter CRM sales CRM application prototype, descriptions and user interface mockups required extensive business analysis.
• 6) While several of the above examples represent big projects, in my own opinion, the biggest and most complex project that I have worked on so far is CreativityModel Method development. Starting from scratch, without any precedent to go by, I was able to put together a scalable and programmable creative thinking skills management method that addresses goal oriented business creativity and self-expressive artistic creativity usage, so that both types of creative thinking skills can be combined as necessary.
• CreativityModel Method can also be used for building intelligently behaving computer application functionality, so that the results can be created with less resources than artificial intelligence engineering and expert systems require.

Education

09/90-05/96 B.A. in economics with psychology, philosophy and business management as 3 minors - Rhode Island College, Providence, RI. Graduated magna cum laude with both College and General Education Honors.

Additional Languages

Estonian - fluent, full knowledge; Finnish - conversational; Russian - conversational (limited knowledge).

Work Status

US citizen since 1996 and as such can work for any employer.