January 22, 2004 at 5:03 pm
Michael Lukach Romm
Senior Database Architect and Administrator
10840 Hillbrae Court -- San Diego, CA 92121 -- (619) 871-9042 – MROMM@san.rr.com
OBJECTIVE
Design and development of Data Warehousing, Analysis, and Transaction Processing systems.
EXPERIENCE SUMMARY
· Expert in relational database design, tuning and administration with emphasis on MS SQL Server.
· Expert in data warehousing subject area including multidimensional design, ETL, cube building, data reporting, analysis and exploration with emphasis on MS Analysis Services and supplemental tools.
· Emphasis on Business Intelligence tools including Microsoft (Analysis Services, Reporting Server), Cognos (PowerPlay, ReportNet, DecisionStream), ProClarity, etc.
· Extensive experience with the Very Large Databases (VLDB up to 900 GB).
· Expert in data migrations and conversions in heterogeneous systems.
· Expert in transaction processing systems, troubleshooting SQL Server databases, monitoring connections and locks, eliminating deadlocks, tuning performance.
· Data processing, client/server, Internet and Intranet applications development in the Microsoft environments (IIS, COM+, SQL Server, .NET, C#, Visual Basic, ASP, SQL Server CE, eVB).
· Project leadership and supervision of small groups of programmers and database administrators. Responsibility for the software development branch of IT department and for a corporate DBA team.
TECHNOLOGIES
MS SQL Server (4.21, 6, 6.5, 7, 2000, CE, Yukon Beta 1), Oracle, Sybase, Access, AllFusion (ERwin) Designer and Validator, PowerDesigner
MS Analysis Services, MS Business Intelligence Workbench, MS Reporting Server, Cognos, ProClarity
.NET (C#, ASP.NET, ADO.NET), Visual Basic, ASP, VBScript, JavaScript, eVB, embedded SQL, C, C++, Visual InterDev, Perl, HTML, UNIX Shell, FORTRAN
Operating Systems
Windows (all versions), DOS, UNIX, OS/2 (version 2.0)
OLTP, DSS (OLAP), DTS, bcp, OLEDB, ODBC, IIS, MTS/COM+, COM, DCOM, ADO, RDO, DAO, ActiveX, SourceSafe, Crystal Reports with CRPE (v.4 through 7), Homer
PRESENTATIONS AND PUBLIC SPEAKING
· Customer Call Tracking System, Client/Server Application Development, at the Visual Basic User Group of San Diego, 1997.
· Pivot Reporting in SQL, at the San Diego SQL Server User Group, 1997.
· Error Handling in the SQL Server Stored Procedures, at the San Diego SQL Server User Group, 1998.
· Gain Proficiency with Relational Databases , 15 hours course taught at Stellcom, 2000.
· Data Integrity in RDBMS , at Database Interest Group in San Diego, February 2001.
· Relational Database Design with Erwin , at ASP SIG in San Diego, March 2001; at SAIC for Computer Associates, September 2001.
· SQL Language Components and Implementation in Various RDBMS, at Database Interest Group in San Diego, April 2001.
· Introduction to Data Warehousing Part I and Part II, at Database Interest Group in San Diego, October 2001 and January 2002; at San Diego SQL Server Users Group in January 2004.
Database Interest Group (DIG) in San Diego
· I founded and led the Database Interest Group in San Diego from January 2001 through January 2002.
EDUCATION
· MS Computer Science and Applied Mathematics from University of Moscow, Russia, 1992.
· Sphinx SQL Server Workshop for DBA and Developers, Los Angeles, CA, Microsoft, 1998.
· Implementing a Database on Microsoft SQL Server 7.0, Microsoft Official Curriculum, 1999.
· Mastering Web Application Development, Microsoft Official Curriculum, 1999.
· Implementing Microsoft Site Server 3.0, Microsoft Official Curriculum, 1999.
· Building E-Commerce Solutions, Microsoft Official Curriculum, 1999.
· Dale Carnegie Course, 2001.
· Yukon SQL Server Pre-Release Conference, Seattle, WA, Microsoft, 2003.
· MCP in Implementing a Database on Microsoft SQL Server 7.0, 2000.
· MCP in Developing Distributed Applications with Visual Basic 6, 2000.
PROJECTS
EDmin.com (09/2002 – 11/2003) San Diego, CA
Title: Senior DBA
Projects:
- New Mexico School Assessment – OLAP with MS Analysis Services.
- File Import System (FIS) – ETL tool with MS SQL Server.
- Virtual EDucation (VED) DB Redesign, Data Merge and Upgrade for new release – OLTP and reports with MS SQL Server.
- Performance Tuning, locking troubleshooting on the production environments – MS SQL Server.
Responsibilities: Led all the database-related development activities in the company; established the database coding standards and training on the database-related issues for developers. Focused on customer satisfaction, eliminated "bad data" emergency situations, automate all data processing. Built, mentored and supervised the DBA group, setup a professional working environment. Established and supported a stable database production environment. Discovered, designed, developed and successfully demonstrated a statewide data warehouse with OLAP reporting based on data originally stored in OLTP databases. Designed and supervised a development of the ETL process to feed reporting databases and the warehouse from the external data sources (files and databases). Kept up to speed with technology advance, recommended data reporting, analysis and mining tools. Researched the features and integration with the SQL Server Yukon Beta 1.
Software used: MS SQL Server 2000 with DTS, stored procedures, jobs, Performance Monitor, SQL Profiler, MS Analysis Services, Erwin (AllFusion) Designer and Validator, SQL Server Yukon Beta 1.
Database Consulting (08/2001 – 9/2002) San Diego, CA
Title: Senior Database Consultant
Projects:
- Product Inventory Warehouse – DSS with MS SQL Server.
- Mortgage Data Repository and Distribution System – DSS with MS SQL Server.
Responsibilities: Architecting and leading the development of corporate data warehouses (over 900 gigabytes) and departmental data marts. Data scrubbing, cleaning, validating standardizing, pushing to data marts, and reporting. Educating other database developers on the data warehousing concepts and techniques. Writing DTS packages, jobs and stored procedures, doing code reviews and performance tuning. Working on the enhancements and maintenance requests for the production applications.
Software used: MS SQL Server 2000 with DTS, stored procedures, Performance Monitor, SQL Profiler, etc.
Stellcom Technologies Inc. (07/1998 – 09/2001) San Diego, CA
Title: Systems Architect
Projects:
- Duke Pacific Payroll Application – OLTP with MS SQL Server, VB, ASP, COM+.
- Blades Inventory Tracking System – OLTP with MS SQL Server, VB, ASP, COM+.
- HP Corrective Action Request Intranet System – OLTP with MS SQL Server, VB, ASP, COM+.
- Pacific Life Competition Database and Intranet Application – DSS with MS SQL Server.
- StableOnline database and Web site – OLTP with MS SQL Server, VB, ASP, COM+.
- Restoration Hub Intranet System – OLTP with Oracle, VB, COM+.
- GPSCo Win CE-based application written in eVB and SQL Server CE with RDA and merge replication.
- Smaller projects involving database design, review, tuning, data access and business tiers development.
Responsibilities: OLTP and DSS systems design and development, database administration, writing reports against SQL Server and Oracle database systems and integrating with the Visual Basic project, COM and DCOM objects development for MTS and COM+ in VB, ASP development, user interface design, research of emerging wireless technologies, writing demo application, doing code and design reviews, mentoring of junior programmers, project technical leadership.
Software used: Microsoft development environment for Windows including SQL Server 2000, 7.0 and 6.5, Oracle 8, Visual Basic 6.0, Seagate Crystal Reports 6.0 and 7.0, ERwin, ERwin Examiner, SourceSafe, MTS, COM+, IIS, VB 6, ASP. Microsoft development environment for Windows CE including SQL Server CE, Windows CE Platform SDK, embedded Visual Basic, ActiveSync, Remote Display Control.
Biosite Diagnostics, Inc. (11/1996 – 07/1998) San Diego, CA
Title: Senior Programmer/Analyst.
Projects:
- Customer Maintenance and Conversion Wizard – OLTP with DSS elements, MS SQL Server, VB, MTS.
- Customer Call Tracking System - OLTP with MS SQL Server, VB, MTS, Crystal Reports.
- Contract Tracking System - OLTP with DSS elements with MS SQL Server, VB, MTS, Crystal Reports.
- Corporate Data Warehouse – DSS with MS SQL Server.
- Sales Reporting – DSS with MS SQL Server, VB, MTS, Crystal Reports.
Responsibilities: Project management, design, development and implementation, team leadership, database administration, client/server and Intranet multi-tier development, defining standards, writing specifications.
Software used: Microsoft development environment including SQL Server 6.5 and 7.0 Beta 2, Visual Basic 5.0, Visual InterDev 1, Active Server Pages, VBScript, Seagate Crystal Reports 6.0, PowerDesigner, Apex TrueDBGrid, VBAssist.
Independent Consulting (4/1996 – 11/1996) San Diego, CA
Title: Consultant.
Projects:
- Analysis Database System for an ambulance conglomerate – DSS with MS SQL Server.
- Billing applications for an ambulance conglomerate – OLTP with SYBASE SQL Server, UNIX Shell.
- Digital Alignment System written in C++ for a manual adjustment of Sony high-quality monitors;
- Data processing applications for a financial company in Perl and SYBASE SQLServer;
- WebSQL screens for a demo on the 1996 International SYBASE User Group Conference.
Responsibilities:
- Project requirements analysis, data mapping, data dictionary creation, data flow design, database design (tables, indexes, rules, defaults, triggers, stored procedures, etc.), user interface design, tools evaluation, software cost evaluation, hardware requirements evaluation, contacts with the customer on-site.
- Debugging stored procedures, creating user interface, technical documentation, doing code reviews.
- Coding small financial data processing applications according to the customer requirements.
- Designing, coding and debugging Web pages to search through the database.
Software used: Windows NT, Microsoft SQLServer 6.0, Visual Basic 4.0, UNIX, SYBASE System 10 and 4.9, APT 4GL, VI Editor, Perl, WebSQL, HTML.
Integrated Health Systems (2/1994 – 3/1996) La Jolla, CA
Title: Senior Programmer/Analyst.
Projects:
- Radiology Information System with billing, orders, appointment scheduling, report routing, maintenance, HL/7 interface to AS/400 – OLTP with DSS elements with SQL Server, VB, Crystal Reports.
Responsibilities:
- Database design, performance tuning for LAN and WAN, GUI design and coding, reports routing design and implementation, software tools evaluation, testing, on-site installation and customer support.
Software used: Windows NT and 3.11 (including both APIs), Microsoft SQLServer 6.0 and 4.2, Visual Basic 3.0, Access 2.0, Crystal Reports (including Print Engine calls), Delrina Win Fax Pro using DDE interface, OLE, custom controls (TrueGrid, VSElastic, MicroHelp tools, etc.)
General Atomics/Emark Division (3/1993 -- 2/1994) San Diego, CA
Title: Software Engineer.
Projects:
- Gasoline Distribution Control System used by major oil companies. System consists of distributed IBM PS/2 workstations with both centralized and distributed database capabilities.
Responsibilities: Screens and screen functions, SQL library, and reports module design and implementation.
Software used: OS/2 2.1 Presentation Manager, DB2/2, Microsoft C, and embedded SQL.
Institute of Computer Aided Ferrous Metallurgy. Moscow, Russia (9/1989 -- 10/1992)
Title: Software Engineer.
Projects:
- Developed a non-linear math solution for automating a steel plating process. Implemented solution in a microprocessor based control system for electronic calipers and other electronic measuring devices.
- Created interactive programs for analyzing data and initiating electrical control signals.
Responsibilities: All the aspects of the project including requirements definition, algorithms evaluation, software evaluation, programs design and implementation, testing.
Software used: MS DOS, Turbo C.
Institute of Mechanics of Russian Academy of Science. Moscow, Russia (3/1991 -- 9/1992)
Title: Programmer/Mathematician.
Projects:
- Developed and implemented finite elements' analysis system. Solution provided two alternative approaches including the elaborated block methods of factorization and conjugate gradients.
Responsibilities: Algorithms design, evaluation, and coding, program debugging and testing.
Software used: UNIX, FORTRAN-77.
PERSONAL
Legal: citizen of the USA.
Hobbies: chess, reading, camping and sports.
References: Available upon request.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply