Feb 2009 – present Upbit Technologies
LLC Seattle, WA
a new BI consulting company.
· Worked with
Brainbox Consulting on an ETL upgrade project for Iron Mountain. Migrating
data warehouse and staging databases to Oracle was the primary objectives of
the project. Performed additional option analysis on performance tuning
options, developed data migration process, migrated Crystal reports.
Participated in strategic architectural decisions, evaluated various
BI-related products including Oracle Data Integrator.
Unix Shell scripting, Crystal Reports, Business Objects Data Integrator.
Nov 2008 – Feb 2009 Raining Virtue Solutions Bellevue,
analysis, prototyping and implementing a Web analytics solution for PEMCO
Nov 2006 – Nov 2008 Brainbox Consulting Bainbridge,
BI Architect and Lead Developer
Business Intelligence solutions for small and large businesses, including
scorecards, dashboards, ETL and custom integration, and business reporting.
included architect, lead developer, data modeler, and report developer.
new Business Intelligence systems and re-designed existing ones.
communication with business users (including executive managers) to scope
requirements and evaluate results.
leveraged various technologies including Microsoft SQL Server BI tools, Business
Objects Data Integrator, Oracle DBMS.
Server 2000, SQL Server 2005, SSIS, SSAS, SSRS, Business Objects Data
Integrator, Oracle 10g.
Project Descriptions (most recent first):
Architect on a new Business Intelligence solution for search engine
marketing. Established development guidelines, performed data modeling,
designed ETL and directed ETL development, optimized performance to large
data volume processing.
Tools: Business Objects Data Integrator, Oracle 10g.
Lead developer on ETL and Enterprise Data Warehouse re-design project.
Responsible for data warehouse modeling, ETL design and development, and
Tools: Business Objects Data Integrator, SQL Server 2000.
Played a key role in establishing a new Business Intelligence platform from requirements
gathering, data warehouse modeling, and design sessions to ongoing support. Responsible
for data modeling, design and development of data collection (ETL), and SSAS
Tools: SQL Server SSIS, SSRS, SSAS.
ETL design and development for a scorecards solution project for claim
processing time analysis. Performed data collection interviews with Premera
IT departments. Developed performance and trending reports.
Tools: SQL Server SSIS, SSRS.
Responsible for ETL development of OEM analysis project.
Tools: SQL Server SSIS.
Developed and fine-tuned several BI projects related to hotels.com customer
Tools: SQL Server DTS, SSIS.
Sep 2005 – Nov 2006 Iron Mountain
(consultant) Renton, WA
Database Developer, Software Developer
Mountain Business Intelligence project: being hired as a database developer, I
was responsible for performance optimization and design changes in BI data
mart, ETL tasks design and development, code review, and some QA. Later, my
responsibilities increased to include back and front ends of BI Crystal and
Web Intelligence reports.
· Iron Mountain BI 3.0 integrated business data from various sources and provided tools to
analyze collected information by running predefined or ad-hoc reports.
Intelligence used SQL Server 2000 for backend, DTS- and SQL job-based ETL
infrastructure, Crystal Reports XI and Business Objects Web Intelligence.
BI 3.0 went live in December 2005, the number of its users has increased to over
Apr 2001 – Sep 2005 Analysts International Grand Rapids , MI
Project Director, Database Administrator, Software
Student Information System (web-based student information system for charter,
private and public schools and their school districts. SQL Server 2000, .NET,
administrator for the product, a lead database developer and a key project
director for all the database-related tasks. Participated in a full 3-year
cycle of product development, including requirements gathering, prototyping,
design, implementation, testing, delivery and ongoing maintenance of the system.
Installations of AtSchool are used at National Heritage Academies (www.heritageacademies.com, with
51 charter schools and over 60,000 students this is the largest installation
of the system), Newaygo Middle and High Public Schools, Saint Joseph Catholic School, Aabizikaawin School.
(web-based student information system National Heritage Academies used before
database and coding tasks related to optimizing performance of a number of
modules including teachers’ grade books, progress reporting for parents,
transcripts, report cards. Designed and developed attendance module for
Tracking Application and Web-based Bulletin for Construction News Service of
Michigan (www.cnsofmich.com, SQL
migration, SQL Server installation and maintenance, user interface design,
Automotive, Ionia, MI (SQL Server 7.0): SQL Server administration tasks,
performance tuning, SQL Server upgrade.
May 2000 - Apr 2001 Northern Cross Partnerships Grand
and coded search forms, developed technology and designed faxing subsystem
for Promotional Media Management, Grand Rapids, MI. (Visual FoxPro 6.0,
an ASP application to update information on www.plasma-tec.com. (ASP, HTML)
and coded a web-application for Grand Rapids Broadway Theatre Guild
(www.bwaygr.org, SQL Server 7.0, ASP, HTML)
and coded Intranet Time Tracking and Forecasting Application. This includes
HTML, SQL Server 7.0)
in system analysis and design for both internal IT and consulting projects.
Sep 1996 - May 2000 MEBIUS Co. Minsk, Belarus
Senior Application Designer and Developer
different business tasks in bank technologies for over 200 banks in Russia and Belarus. Technologies used: Borland C++ 3.1, MEBIUS C++ Object Library, Btrieve 6.0,
RDBMS Oracle 7.
and managed Client-Bank system.
and coded Depository (stock) system.
Currency Exchange Office system.
and coded report generating subsystem for a variety of tasks.
and coded applications for transfer software and databases for the new plan
of business accounting and for denomination (for Russian banks, 1998).
and coded Intermediate application for interface between Mebius bank
automation system and Tellers Cash-Dispenser (Multi Denomination Dispense
Oct 1995 - Sep 1996 Belarusbank Minsk,
A key developer
of bank's head office information management system "FORWARD"
(Windows 95, Novell 3.11, RDBMS Oracle, Oracle Developer 2000, Oracle Reports
Designer, PL/SQL, Borland C++ 3.1): the system performed information processing
from over 200 bank branches, allowing and delimiting suitable access for
involved departments, automates generation of accounting information.
Designed a library for automatic forms generation. Designed and coded reports
printing system using Oracle Developer 2000. Designed and implemented reports
using Oracle Reports Designer.
July 1994 - Oct 1995 Savings Bank Minsk,
management information system "IMUSCHESTVO" for bank branches (UNIX
System V (DRS6000), UNIX Terminal, Novell 3.11, Microfocus COBOL, Borland C++
3.1): developed various forms and reports.
May 1995 - Oct 1995 Interbanks Settlement Center Minsk,
Accounting System (Alcatel TP6000, X.25 routers, MS Access 2.0): designed the
structure of the accounting system. Designed and coded main forms.