I am looking for a contract or a full-time position as a Business Intelligence Architect/Senior Developer.

·    MCP (Microsoft Certified Professional), Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

·    MCP (Microsoft Certified Professional), Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

·    Certified Brainbench Master C Programmer.

·    Certified Brainbench C++ Programmer.

·    Certified Brainbench SQL Server 7.0 DBA.

·    Crystal Reports Development

·    Over 14 years in IT.

·    Accomplished lead developer, project director, and architect.

·    Held key roles on various scale Business Intelligence projects. Gathered requirements; directed design, development, and deployment; coordinated ongoing support.

·    Strong Data Warehouse modeling skills.

·    Strong ETL development skills.

·    Strong skills in database development and administration.

·    Experience with various Business Intelligence platforms, including Microsoft and Business Objects.

Feb 2009 – present              Upbit Technologies LLC                               Seattle, WA

Owner

·    Started 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.

·    Oracle, Unix Shell scripting, Crystal Reports, Business Objects Data Integrator.

Nov 2008 – Feb 2009         Raining Virtue Solutions                            Bellevue, WA

BI Architect

·    Option analysis, prototyping and implementing a Web analytics solution for PEMCO Insurance Company.

·    WebTrends Web Analytics, WebTrends SmartSource Data Collector, HTML, JavaScript.

Nov 2006 – Nov 2008        Brainbox Consulting                              Bainbridge, WA

BI Architect and Lead Developer

·    Delivered Business Intelligence solutions for small and large businesses, including scorecards, dashboards, ETL and custom integration, and business reporting.

·    Roles included architect, lead developer, data modeler, and report developer.

·    Built new Business Intelligence systems and re-designed existing ones.

·    Established communication with business users (including executive managers) to scope requirements and evaluate results.

·    Successfully leveraged various technologies including Microsoft SQL Server BI tools, Business Objects Data Integrator, Oracle DBMS.

·    SQL Server 2000, SQL Server 2005, SSIS, SSAS, SSRS, Business Objects Data Integrator, Oracle 10g.

Project Descriptions (most recent first):

Perfect Market
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.

Iron Mountain
Lead developer on ETL and Enterprise Data Warehouse re-design project. Responsible for data warehouse modeling, ETL design and development, and performance tuning.
Tools: Business Objects Data Integrator, SQL Server 2000.

Ryzex
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 development.
Tools: SQL Server SSIS, SSRS, SSAS.

Premera
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. 

Microsoft
Responsible for ETL development of OEM analysis project.
Tools: SQL Server SSIS.

Expedia
Developed and fine-tuned several BI projects related to hotels.com customer feedback analysis.
Tools: SQL Server DTS, SSIS.

Sep 2005 – Nov 2006         Iron Mountain (consultant)                        Renton, WA

Database Developer, Software Developer

·    Iron 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.

·    Business Intelligence used SQL Server 2000 for backend, DTS- and SQL job-based ETL infrastructure, Crystal Reports XI and Business Objects Web Intelligence.

·    Since BI 3.0 went live in December 2005, the number of its users has increased to over 700.

Apr 2001 – Sep 2005          Analysts International                       Grand Rapids , MI

Project Director, Database Administrator, Software Developer

·    AtSchool Student Information System (web-based student information system for charter, private and public schools and their school districts. SQL Server 2000, .NET, C#, JavaScript): combined roles of the main SQL Server 2000 database 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.

·    AcademyLink (web-based student information system National Heritage Academies used before switching to AtSchool. SQL Server 7.0, ASP, JavaScript, HTML): various 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 teachers.

·    News Tracking Application and Web-based Bulletin for Construction News Service of Michigan (www.cnsofmich.com, SQL Server 7, Visual Basic 6.0, JavaScript, HTML): database design, database migration, SQL Server installation and maintenance, user interface design, coding.

·    Meridian Automotive, Ionia, MI (SQL Server 7.0): SQL Server administration tasks, performance tuning, SQL Server upgrade.

May 2000 - Apr 2001         Northern Cross Partnerships             Grand Rapids, MI

Technical Specialist

·    Designed and coded search forms, developed technology and designed faxing subsystem for Promotional Media Management, Grand Rapids, MI. (Visual FoxPro 6.0, Visual ProMatrix)

·    Created an ASP application to update information on www.plasma-tec.com. (ASP, HTML)

·    Designed and coded a web-application for Grand Rapids Broadway Theatre Guild (www.bwaygr.org, SQL Server 7.0, ASP, HTML)

·    Designed and coded Intranet Time Tracking and Forecasting Application. This includes development and coding of Internet role-based security subsystem. (ASP, JavaScript, HTML, SQL Server 7.0)

·    Coded JavaScript part of www.northernx.com, a company’s web site.

·    Assisted 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

Developer of 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.

·    Designed and managed Client-Bank system.

·    Designed and coded Depository (stock) system.

·    Developed Currency Exchange Office system.

·    Designed and coded report generating subsystem for a variety of tasks.

·    Designed and coded applications for transfer software and databases for the new plan of business accounting and for denomination (for Russian banks, 1998).

·    Designed and coded Intermediate application for interface between Mebius bank automation system and Tellers Cash-Dispenser (Multi Denomination Dispense Mechanism).

Oct 1995 - Sep 1996           Belarusbank                                              Minsk, Belarus

Application Developer

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, Belarus

Programmer (part-time)

Checks 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, Belarus

Programmer (part-time)

X.25 Network Accounting System (Alcatel TP6000, X.25 routers, MS Access 2.0): designed the structure of the accounting system. Designed and coded main forms.

Sep 1992 - June 1997    Byelorussian State University of Informatics and Radioelectronics                                           Minsk, Belarus

·    B.S., Computer Science.

·    First-Class Graduate Diploma.

·    Completed Crystal Reports XI Intermediate and Advanced training classes.

Music, reading.