Leo Rozenblat
Newton MA ***** 617-***-**** *********.***@*****.***
SUMMARY: Database and System Architect/Technical Team Lead of a global development team with 18+ years of experience, excellent analytical, problem-solving and communication skills, and expert level in following areas:
Database design and implementation, data conversions/migrations
Design, development, rollout and production support of business-critical applications
Architecture design and system integration
Technical documentation and training presentations
Customer support
PROGRAMMING SKILLS:
Platforms: Windows, UNIX
Databases: Oracle, SQL Server, Informix, DB2
Languages: Perl, SQL, ColdFusion, JavaScript, Oracle PL/SQL, Informix SPL, C, Java, HTML, XML, UNIX Shell Scripts, Awk, Visual Basic
EXPERIENCE:
2003 - 2016 Computer Science Corporation Waltham, MA
Database and System Architect/Tech Team Lead
Led a global development team to manage a number of business-critical CSC systems through all phases of the Development and Production cycle:
Designed, developed and rolled out an in-house Billing Application to replace third party vendor packages, thus reducing technology run-rate costs of the Billing process by $5,000,000 per year
Designed and developed a robust Asset Management application to enable cost saves and improve performance of internal as well as clients’ hardware and software assets in CSC and customer owned datacenters
Worked with Business Process Owners to document, design and deliver a Sales Database for a customer portal to enable self-access to various reports and screens, such as Order and Contract Maintenance, Service Maintenance, Configuration Workbook and Contact Management
Coordinated, developed and executed large data projects (CSC datacenters migrations and similar) across the globe and international delivery teams to prepare and upload customer, ordering, billing, service and system data using special scripts and tools
Designed, developed, tested and implemented variety of tools, scripts, reports to exclude manual steps and completely automate workflow
Led, supervised and rolled out a number of projects aimed at improving Data Quality and Application Performance. Performed database cleanups and data control
Improved workflow and implemented system triggers and controls to eliminate redundancies and manual steps to improve key operational processes
Worked closely with managers, business analysts and process owners from different functional areas to develop detailed business requirements for various projects
Documented run books, system user guides and functional schemas for all application processes, performed numerous demos and user trainings.
2000 - 2003 Genuity, Inc. Woburn, MA
Senior Software Developer/Technical Project Lead
Led database design and migration of a legacy character-based database interface to a new 3-tiered (ColdFusion/Javascript/DHTML) dynamic intranet interface
Guided a team of developers to design, develop and implement a next generation of a system DB engine
Responsible for architecture, design, development and monthly installations of updates and enhancements of numerous modules of a Customer Provisioning System
Acted as a key developer for the consolidation of line of business service information into a uniform system and data model.
Designed, developed and implemented a generic interface between Customer Provisioning System and other systems (quoting, billing, order summary, datamart)
Responsible for design and development of a system connector to a Vitria Databus Interface
1997 - 2000 BBN Planet (GTE Internetworking) Cambridge, MA
Programmer
Designed, developed and implemented tables/indexes/triggers/stored procedures with usage of Informix, C library packages, Perl scripts and reports, Informix-4GL forms for the Customer Provisioning System
Led a team to migrate service data of four lines of business to a standard product model; created and implemented migration scripts for these data migrations
Developed and enhanced a dynamic data validation system, dynamic user permission system and an audit trail system
Functioned as a key member of a tools support group providing 24/7 on-call customer support
OTHER RELEVANT EXPERIENCE:
Russian Society of Appraisers (RSA) Yekaterinburg, Russia
Software Engineer
Designed, developed and implemented a system for appraising real estate properties using Access and Visual Basic
Created data entry forms, designed and developed weekly reports for RSA
Prepared technical documentation for the application and provided on-call support
.
Sverdlovsk Automation Technology Yekaterinburg, Russia
Lead Engineer/Manager
Managed a team of engineers and technologists in design, development and implementation of electronic equipment and developed equipment testing
Designed and developed specific language programs for electronic testing during production phase
Provided technical guidance and training to staff, and documented all stages of product development
EDUCATION:
Ural Polytechnic Institute Yekaterinburg, Russia Master of Science in Electric Engineering
Ural Academy of Economics Yekaterinburg, Russia
Master of Business Administration
New Horizons Computer Learning Center Waltham, MA
MS SQL Server – Data Warehouse Architecture (20463), SSRS and Data Models (20466), BI Solutions (20467)