ALEXEI V. AKIMOV
10 Tangreen Crt. #2505
North York, Ontario M2M 4B9
Tel: 416-590-8939 (home), 416-650-5122 ext.2251 (work)
alakimov@hotmail.com alakimov@rogers.com
OBJECTIVE: A position of SQL Server DBA, DB Designer/Modeler/DB Architect
HIGHLIGHTS OF QUALIFICATIONS
Ten years as a professional DBA/DB Design/Developer.
Strong data analysis, logical and physical data modeling skills.
Organized, punctual, methodical.
Team player. Excellent communication skills.
COMPUTER SKILLS:
Databases: SQL Server 2000, 7.0, 6.5, Sybase ASE 12.0, Oracle 8i, MS ACCESS 7.0/2000.
Languages and technologies: Transact SQL, PL/SQL, VB 6/0/5.0, PB 7.3, VB.NET, ASP: VB Script (server), Java Script (client), HTML, XML, XSLT, CSS, VBA, C, MODULA-2, COBOL, PL-1.
Operating Systems: WIN2000, WIN NT 4.0, WIN 9x., RSX-11, RT-11, TSX-Plus.
Microsoft Certified Database Administrator (MCDBA) – 2002-2003, Microsoft Certified Solutions Developer (MCSD) (VB+SQL development), MCP: 70-027 , 70-229, 70-028, 70-175, 70-176 , 70-100, 70-215. Oracle Certified Developer (OCP 1Z0-001) – 2002, OCP 1Z0-101 PL/SQL Development – 2002.
RELATED EXPERIENCE:
Dec. 2004 – Now MARKETREND Inc. SQL Server Architect/DBA/DB Design/Modeler.
Position: Contract. DB Design, DB Modeling, ETL Developer. Environment: SQL Server 2000 Enterprise Edition, 2-Nodes, Clustered – DBA for both Production and Development environments. Planned, designed and implemented DB aggregation for about 35 DBs from multiple production 7.0 Servers to a single SQL Server 2000 server (including ETL, Jobs, Security). All upgrade actions were completely automated (i.e. implemented as one job). Debugged multiple production problems with clients as Com-Plus Services located on App. Server and Web-servers.
Development: DB design, Logical and Physical Modeling for new development (designed integrated Do Not Contact functionality for several CRM applications), using Sybase Power Designer v.10/11. Developed Instead-Of triggers for the views, added multiple archive/history tables, updated by after-triggers, implemented clean-up for obsolete and duplicate data, reindexed tables for speed and high data availability (avoiding table “hot-spots” for heavy usage multi-user concurrency issues).
Developed a proprietary package that detects, monitors and programmatically analyzes persistent live-locks (detection/kill of the head of the locking chain), traces server workload, response time and notifies DBA. ETL: Developed DTS packages for CRM data load from third parties (customers address third party validation and load for US/CA residents).
Oct. 2004 – Dec. 2004 "AMERICAN EXPRESS, Canadian Solutions Centre" Position: Contractor (through NCP)
SQL Server DBA, Back-end Upgrade/Consolidation, Application conversion and Reengineering project (SQL Server 6.5/7.0/2000, WinNT 4.0/Win2000/Win2003). Conversion project includes large number of Databases, most DBs are Web-related high-availability 24/7, with sizes from 1Mb to 30 Gb.
Coordination, audit, planning and implementation of DB Schema changes, patches and fixes for Development teams. Creation of DB capacity, backup and truncation plans. Multiple Data Feeds based on CRON scheduler, Win2000/2003 scheduled jobs (ISQL using DBCC), scheduled DTS packages, FTP and Mainframe Data Feeds.
Oct. 2003 – July 31, 2004 "TRAVELEX Inc." Position: Contractor (through CNC Global),
DB Design, ETL, TSQL, VB and PB Development, DTS Packages development, ETL Data loads, Documentation.
Used technology: MS SQL Server 2000, DTS, ADO, Visual Basic, PB, XML, XSLT, MS Visio.
Responsibilities on the project:
DB Schema Design, Data Modeling, OO Design, Coding, Debugging, Unit and System/UAT Testing, QA, Testing scripts and Installation Documentation, production Installation of Operational Data Stores, Data Mart/Data Warehouse for OFAC Anti-Money Laundering (AML) Compliance System.
ETL (Extraction, Transformation, Loading) Project includes design and development of a Data Stage DB with a series of scheduled DTS Packages (invoked through DTSRUN with parameters, driven by configuration files). DTS Packages are run through batch mode (as jobs with DTSRUN) with scheduled overnight execution. By design data load and data changes are wrapped into a single transaction context. ETL includes population with update of dimensions for the Data Warehouse/DSS system. Created DB schema and Object Model jointly with the Director of IT Development of the company (due to urgent nature of the project).
SQL Development involved writing Stored Procs, Views, UDF functions, TSQL and Sybase Installation scripts in a multi – database and distributed SQL Server/Sybase environment (using Linked Servers, dynamically assignable DTS connections and ODBC DSNs, reassignable inside DTS packages). Solution includes custom coded e-mailing, Logging and Error Reporting (DTSPackageLog and custom-written e-mailing model) functionality inside DTS Packages. Written detailed Installation and User Guides. Developed scenarios for UAT Testing. Developed auditing and logging functionality against archived data.
VB, PB, COM+ Server development. Designed and implemented custom written VB wrapper DLL, making API Calls for the Prime Associates DB Server. Rewrote the functionality with modifications in PB 7.0 for other projects (against Sybase back end). Expert skills with DLL development (stateless programming) for distributed COM+ Servers with built-in redundancy, dynamic distribution of load and high availability and scalability (for more then a hundred of concurrent clients on the intranet).
XML, XSLT, expert skills with MS XML DOM3 Object Model programming (used in DLL in COM+ components and in DTS VB Script) , wrote multiple XSLT Transformations and DOM documents programmatic creation (XML-XML and XML- Object Model Applications data), client - COM+ server data XML data exchange. Expert skills in XML/XSLT data filtering, transformation, templates, variables, output formatting.
Business Analyst: Collection of Functional Requirements, Interviews with Stakeholders, prepared and reported for JAD Sessions (User Workshops), consulted AML Officers, developed Use Cases, Prototypes, Document Reviews, proposed an architectural approach and formulated the detailed architecture.
Financial: Project implements mandatory Anti Money Laundering Compliance Check and automatic Freeze/Release functionality for financial institutions according to OFAC/FINTRAC requirements (see: http://www.travelexca.com/AML.asp ) for Large Transactions, Drafts, Travelers Checks, Wires, FX Currency Exchange and Gift Cards. The Data Warehouse aggregates current data feed from multiple Corporate Data Sources and various Financial Instruments types both for individuals and companies.
The functionality implements data population, aggregation and automated AML checking for the eligible data against SDN/Blocked Persons lists and other information, provided by the Prime Associates Database (see also: http://www.primeassociates.com/prime/lists.asp#OFAC )
March 2003 – Aug. 2003 "INCUBED LTD" (contractor through Asset Computer Personnel).
Position: MS SQL Server DBA, DB Design/Analyst, TSQL Developer, DTS, ETL Data loads.
Client: “Equitable Life Of Canada”. Project: IN3BMS – comprehensive Insurance Benefit Management and Group Administration package (includes Health, AD&D, Dental, Reinsurance).
Used technology: MS SQL Server 2000, DTS, ADO.
Responsibilities on this project:
SQL Server 2000 Enterprise Edition Database Administrator/DB Analyst: Backup and Restore in Multi-Server, Multi-DB environment. Preparation of weekly and monthly Roll-out Scripts for a large Database (1000+ tables) -for QA, Training and Production Servers. Scheduled Backups, DTS scripts, Replications.
Responsible on the project for look-up tables, DropBoxes, CodeTables, NcodeTables. Compared Schemas and Metadata (using Power Designer) and prepared Schema and Data Comparison/Synchronization scripts. Implemented scheduled and centralized multiple Server/multiple DB backup job with periodic truncation of Trans. Log and programmatically determined time of backup initialization, backup periodicity, driven by DB changes, DB Size and Quotas of max. disk usage (based on custom coded USP inside Master DB).
DB Design/SQL Development: designed and developed UDFs, USPs, Views. Defined potential constraints, determined data redundancies, violating the constraints, indexed and reindexed tables for speed. Written a number of “After” triggers against tables for logging data changes. Developed DTS Packages for client data population from Access and Excel files with data validation, versions/revisions (based on data time segments, with architecture designed for full Audit Trail capability) and data cleaning.
Developed “Instead-Of” Triggers against Views, implementing Cascading deletes, business-logic driven Inserts and Updates for “One to Multiple” relationships against several underlying tables. Debugged ADO/VB6/COM-Plus data retrieval problems in Distributed Server Architecture environment – based on Recordsets from USPs with paginated output. Tools: Sybase Power Designer v 9, Red-Gate SQL Compare v.2. Other technologies on the project: C++, Data interchange in XML format, Cognos reports, MS BisTalk, MS VSS (for SQL Code), Census (Variance Tracking System on IIS server).
July 1998 – Dec. 2002 "CGI GROUP INC." Position: Consultant, full-time, permanent.
Client: “Air Canada”. Project: Pilot Qualification Record Management System (PQRM): May 2002 - Dec. 2002.
Position: Oracle DB Design/ETL.
Used technology: IIS 5, ASP, VB Script, Java Script (Server), JScript and Adobe Java-Script Client, XML, CSS, HTML, Interdev, Adobe Forms (E-Documents), export from PDF to FDF format.
Back-end: Oracle 8i (under HP-UX) and Access (was used for initial development stage). Data retrieval: ADO through DSN ODBC.
Responsibilities on this project:
Data Base Analysis, DB and Architecture Design, Development of Packages, Stored Procedures, Views, UDF Functions (PL/SQL), data population scripts. Designed and implemented Access and Authorization Security model (based on user credentials in the existing intranet application). Development of ASP pages, ADO Data Retrieval and Business Logic layer. WEB Server (IIS5.0 on Win2000) -Administration, configuration, security settings. Debugging of Jscript inside Adobe forms, testing, functional specifications, documentation. Tools: SQL Plus, PL_Developer, TOAD, ErWin.
Client: “Colliers International” Project: “Colliers On-Line Real Estate System” (CORE)
July 1998- April 2002
The project installed in more than 10 countries, with multi-language support. Project is a large Real Estate general purpose information system package with extensive data mining capabilities and flexible, reconfigurable interface. It is integrated on a server side with a financial application, calculating remuneration for Real-Estate Brokers, and on the Client Side integrated with ACT3.0/4.0, Lotus Notes R5, Crystal Reports run-time engine and MS Word/Excel template-driven reports.
Responsibilities on this project: 1998-1999: DB Design/DB Analyst/DBA/VB development, 2000 - 2002 SQL Server DB Administrator/ DB Analyst. Original DB schema was proposed by Microsoft Consulting (in 1995), substantially modified, CORE back-end became de-facto standard in the Real Estate and used in a number of other projects by the companies, affiliated with Colliers Int.
MS SQL Server Enterprise Edition 2000/7.0 DB Administration, consulting, application package roll-out, maintenance, analyzing /addressing tickets (logs) for a large Real-Estate SQL Server 7.0/2000 project (130 tables, 160 views, 800 stored procedures) under Win NT 4.0/Win2000 (server), Win95/Win98/WinME/WinNT Workstation/ Win2000/ Citrix-MetaFrame (client).
SQL Server 7.0/2000 DB Backup/ Restore from production for Development, QA, Datastaging, Reports and User Training Servers, restoring of particular Server/DB configurations/DB Schema and Data for reproduction of user-reported bugs/tickets, DTS data transformation packages/data feeds, scheduled maintenance batch jobs.
SQL Development (SQL Server 6.5/7.0/2000):
DB Design, DB Analyst, Transact SQL Development, Stored Procedures (wrote more than 100 Production SPs), Views, DBCC DB Repair/Maintenance, SQL Scripts-tables creation, indexing, maintenance, redefining table structure, constraints, fine-tuning for speed, robustness, multi-user concurrency. Development of User Activity Log (Auditing and Archiving) subsystems. Developed DB schema comparison/maintenance applications (based upon SQL-DMO library). Debugged Ad Hoc SQL query engine.
Designed reporting/DSS system based on replication/ETL of a set of modified tables using DTS. Expert knowledge of index fine-tuning, query optimization, schema redesign for scalability and speed. Vast experience with ADO/RDO/DAO. Detailed knowledge of data retrieval classes in VB.Net/ADO.Net.
Migration from MS SQL Server 6.5 to 7.0 (1999) from 7.0 to 2000 (2000). Responsible for all aspects and successfully implemented migration: rewriting views, SPs, triggers, reports and report views, application embedded SQL and application produced ad-hoc queries.
ETL, Data transformation: Extensive Data population skills, SQL Server Data Population (with MS Access/Excel as data source). Importing/Exporting data by sequences of DTS packages (from SQL Server and Access DBs and Excel files). Developed SQL Server Data-Population tool from xls files, based on Excel ActiveX Server instantiation and reusability of COM objects, implementing application business logic. Participated in design of a Real Estate Data Portal (DB schemas, data transformation, XML->XML data interchange, driven by XSLT templates with data being exported from SQL Server through ADO Recordsets).
Extensive Data Validation, Scrubbing, Conversion, Transformation and Data-Mining skills: country specific phones, currencies, number and address formats - TSQL batches, written instrumental SPs, VB5/6 programs, Excel VBA and macros, DTS, BCP, Bulk Copy, XML/XSLT. Developed a number of schema comparison, data analysis, data scrubbing and cleaning VB applications, TSQL Scripts, SPs for population of DSS/Reporting and Data Mart Systems, designed a number of data-mining Crystal Reports. Implemented load-balancing custom solution for Reporting (with propagation of data changes to other DB). Hands-on experience with Snapshot and Transactional types of replications.
Data Warehousing, Data Mining and Transformation – written logging and archiving SPs, Views, Reports, assembly of Statistical data from various production DBs for analysis (DSS, Data Marts). Extensive hands-on skills of partial data denormalization for DSS/Reporting and Archiving. Experience with setting and population of Fact and Dimension tables for OLAP (Analysis Services). Experience with Excel and Crystal Pivot reports.
VB 6.0 new development and maintenance (project contains 8 ActiveX execs, 30 ActiveX DLLs, 15 ActiveX controls, including 5 written specially for the project, and is based upon objects/collections, GUI interface based on multi-tabbed forms and Flex Grids). Tickets, logs, legacy code debugging, rewriting existing code for speed, removing memory leaks, ADO/RDO/DAO. Releasing builds, roll-out of client side with InstallShield Express 2.0/3.0. QA Testing; Performance Analysis, consulting Customers/Production DBMAs, resolving production problems. Rewrote part of data access retrieval layer from RDO to ADO.
Developed New Functionality (in VB 6.0): Usage Trace/Auditing System, ad hoc SQL Queries Engine DLL, Contact lists handling with batch e-mail (Event management), URLs and Document Reference and Retrieval functionality. Implemented memorizing and retrieval of Crystal Reports as binary blobs in DB, developed several Data Validation Tools (VB and SQL).
Debugged Functionality: Implemented and debugged mass Image loading (from Jpg, gif, bmp, tiff, wmf files into byte blobs, corresponding to JPG format, using third party and MS controls), image proportional auto resizing/cropping functionality, enhanced functionality for Template driven image Excel and Word reports. Debugged transparent integration of the product with Lotus Notes R5 E-Mail Client with address book handling and batch e-mailing processor with attachments autozipping (using ADFactory ActiveX control). Debugged data interchange (flat files transfer) with LoopNet and MLS (Real-Estate Data portals). Implemented application auditing functionality. This system memorizes/traces/reports all user/user group actions against each particular entity/group of entities.
Debugged integration of Act 3,4 on client side with DB backend with download/upload functionality. Debugged and reimplemented large volume of VB code due to integration with International Editions of MS Office and non-English client side regional locale settings. Developed reformatting DLLs for consistent (user defined masks driven) formatting of GUI forms and Reports (number, date, currency formatting) – reconfigurable on-the-fly with localized application “Look and Feel”.
Performance Analysis, restructured and rewrote large volume of SQL and VB code for speed (in SQL using Profiler, in VB – set of routines for measuring time intervals) – by identifying redundant data retrieval scenarios. Expert knowledge of dirty flag handling at form/grid/class/DLL level, reusability of encapsulated data and dynamic/lazy load object/collections retrieval techniques in multiple DLL environment.
ASP Development – server side VB Script, 3-tier architecture based on ActiveX DLLs (server side COM objects, written in VB, encapsulate application business logic), data retrieval implemented using ADO, IIS 4.0, SQL Server 7.0 (separate servers), development in Visual Interdev, client side: Java script (data validation, data formatting, controls initial population). Functionality of Multiple Images on ASP page (clickable thumb and full sized -with auto resizing) (dynamically updated set of temp files in JPEG format, filtered against each user/entity) Implemented Search and Property/Listing update system for Real-Estate brokers.
Developed Report subsystem for Seagate Web Crystal reports 8 (based on IIS Server side WCS service and RDC ActiveX control) with JPEG image files passed from applications. Participated in writing and debugging of ActiveX client-side control, written in Java (JDK 1.4)
Debugged a number of Citrix Metaframe Server specific problems (Registry settings, DLL registration, temp files location, drive mapping, printing, device mapping, DSN ODBC mapping).
Testing, QA. Performed as part of a team: Unit, Functional, System Integration, Performance Testing, Business Rules and W2K Testing. Wrote a number of Testing Scripts and Business Rules Test Scenarios - with client Business Analysts. I was responsible for Multi - User Concurrency Testing (with versioning of DB data based on Time Stamps).
Documentation: Developed functional requirements, detailed design and programming specifications for the project, presented and defended specifications to the client Project Managers, DB Administrators and Business Analysts. Written numerous installation Guides and Instructions. Developed GUI prototypes, presented detailed test plans, developed testing scenarios, set-up and supervised team of 3 in a multi-user and multi-process data concurrency testing (based on timestamp columns).
Roll-out of the complete Project was done every 4-6 months and was accompanied with Code Freeze for at least 3 weeks. I was responsible for both server and client roll-out (for 2 yrs with InstallShield Express), tracking Logs/Tickets using MS Anomaly Tracking System Database, reproduced, verified and addressed bugs, including those reported from QA, User Acceptance and Production. Edited a number of User Manuals and Help Files (written by client Business Analysts).
Crystal Reports 5.0, 6.0, 8.0, 8.5 – developed and debugged more than 150 Real Estate reports, report views, several MS Word 2000 and Excel 2000 reports (implemented image processing system for Crystal reports with BMP and JPEG blobs, autopacking/unpacking subsystem for Crystal reports, report generators, driven by Image and Attributes Templates in Excel and Word). Crystal reports based on Cubes, Rollups, multiple levels of aggregations. Provided roll-out (Install Shield) of the application package with Crystal 8.5 set of DLLs, with JPEG and BMP blob images in report exporting to PDF, RTF, HTML 4.0, RPT formats, using CRPE32.DLL.
Provided Teaching/Training and presentations for users, testers, production DBAs, client business analysts, project managers, provided full cycle of application support, writing/editing User Manuals, help documentation (Robohelp).
ActiveX controls used. Grids: FarPoint Spread, Video Soft Spread, MS Spread, ActiveDelievery, JpgImage control (by Softuarium), ImgEdit OCX (by Wang) several Date/Time and Calendar controls. OCXs for international Phone/Fax, written for the project and Shuffle control.
Utilities and tools used. MS VSS (Source Safe) v.5.0, MS Visual Studio 6 Database Project, VB 5/6: MS Visual Modeler 2.0, MZTools v.2/3, SQL DB design and maintenance: DBArtisan v5.4, ER Studio (Embarcadero), SQL Compare (Red-Gate), ERWin 4.0, QA/Testing: MS ATS (Anomaly Tracking System), Client installation on: Citrix MetaFrame 1.8 on Terminal Server, client side install: InstallShield Express v.2/3, reports: Crystal Reports 4.5, 6.0, 8.0, 8.5.
Distribution of my job: 50%-SQL, 30%-VB, 20%-Crystal reports. 40%-new development, 40%-QA, DB Design, DB Administration, maintenance, roll-out, user reported bugs, 20% - writing help files/program documentation, requirements, teaching users, consulting clients/DBAs.
Samples of SQL, VB and ASP code will be attached for technical interview. Lists of references attached on request.
1997-1998 Telesat Canada. Contract.
SQL Server 6.5, MS Access 7.0, WIN NT, SQL, VBA - data base schema design and implementation of Toronto Teleport Equipment Database, which covers equipment for uplinking (beaming to Anik E satellites) and monitoring quality of the most part of All-Canada Television Channels (CBC,CTV, Life, Discovery, Showcase, TMN, TVO, StarChoice and others) and a number of digital services for major customers (Ford, Chrysler Canadian dealerships, CIBC, Royal Bank, Revenue Canada, Delta Hotels, DirecPC). The Database covers the following: equipment inventory, repairs and maintenance history, client data, maintenance ticket (logs) database.
Installation of the Intranet Web-server, updating of web-page in corporate Intranet setting: web-bots, indexed file text search via web-server and other subsystems (IIS 3.0, PWS, Front Page Editor, Front Page Explorer). Installation of MS Outlook 97 mail exchange package in Intranet and programming of forms (templates) (VB Script in Outlook). References available.
LEAD PROGRAMMING ENGINEER
1987-1997 Scientific Research Institute of Radio and Electronics - Russia
Development of Accounting and Material Management Systems in VB 3.0, MS Access 2.0 (1993-1997).
Programmed in VB 3.0, MS Access 2.0 + proprietary database: installation, QBE, SQL, reports, teaching users. Implemented database for the Administration of the Institute: client accounts, development projects for tracking renting/leasing of office premises. Internal Database schema design, testing, data entry, presenting to client. Subsystem in VB3.0: tracking of projects and account deadlines. As Project Manager, supervised implementation of a similar system on IBM 370/155:DB2, QMF, SQL.
Programmed for PDP-11 computers in C, development of software tools, training and supervising groups of computer programmers for particular projects. Installed TSX-Plus (VAX-VMS look alike), RSX11 4.1, RT-11.
Lead programmer - hands-on programming and supervised development team of 4 programmers - projects in C, Modula-2, MacroAssembler - Real-Time Systems for reading data from sensors, diverse hardware - responsible for functionality of the result, testing and presenting to customers. Letter of recommendation and references available.
PROGRAMMER/ANALYST
1982 - 1987 Head Navy Research Institute (Ministry of Defense); Russian name: Military Unit 70170, Leningrad.
Programming in Cobol and PL-1 on IBM 370/155 - calibration, testing and metrological support for batches of newly developed non-standartised meters and sensors. IBM370, paper tape data input. Certified specialist in Electric and Radio Measurements.
Education:
St. Petersburg Technical University Russia; Master of Science in Physical Electronics, major: Physics, Mathematics.
Seneca College courses: advanced C, advanced C++ (total 4 courses), SQL In Depth, Microfocus Cobol.
MCSD+MCDBA: (List of MCPs) 70-027 “Implementing a Database Design on Microsoft SQL Server”-1999, 70-028 “SQL Server 7.0 Administration” - 2000, 70-229 “Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition”-2002, 70-175 “VB6 Distributed Development” 2001, 70-176 “VB6 Desktop Applications Development” - 2001, 70-100 “Solutions Architectures” - 2001, 70-215 Windows 2000 Server Administration - 2002, Oracle Certified Developer (OCP 1Z0-001), 2002 , OCP 1Z0-101 PL/SQL Development – 2002.
Hobbies: classical music, I like to read in different languages: (Russian, English, French, Polish)