VIKTOR ROMANOVICH
Katy, TX 77450
******.**********@*****.***
SUMMARY: Seasoned software engineer with a proven track record of project
successes in Microsoft .NET framework, Web based application
infrastructure and Client-Server environments, providing design,
development, implementation of innovative software solutions and
applications, and maintenance of existing systems throughout all
phases of the software development life cycle.
TECHNOLOGY SKILLS:
Operating Windows 7/8/Server 2008, UNIX
Systems:
Computer T-SQL, PL/SQL,VB.Net, Java, Java Script, Java Servlets, JSP, ASP,
Languages: XML, HTML, C,
Visual Basic, VB Script, AQL, Unix Shell Script
RDBMS: MS SQL Server2005/2008, MS Access 2007/2013, ORACLE
Development MS SQL Server Management Studio, SSIS, SSRS, SSAS, Query Analyzer,
Tools: MS Visual Studio, .NET Framework 4.0, MS SourceSafe, HP Application
Designer, HP Connect-It Scenario Builder, TOAD, Crystal Reports
Applications: HP Asset Manager 9.x, Connect-It 9.x, Microsoft SCCM, Tomcat, IIS,
Visio, HP Project Portfolio Management
Business Contract, SAM, and Portfolio Management areas of HP Asset Manager 9.X
Processes:, IT Stock Management, PC Staging, Web Product Catalog, Software
Introduction/Packaging, Software Export Compliance
Methodology: Software development lifecycle methodology and industry best
practices.
PROFECCIONAL EXPERIENCE:
SAIC/Wipro, Houston, TX - Marathon Oil/Marathon Petroleum accounts
2005 - February 2015
Software Application Engineer III
Major roles:
. Designed and developed system architecture for the Software
Delivery, Asset Deployment, Software Approval, Computer Software
Transfer, Replacement and Restore processes available globally.
Coordinated design of subsystems and integration of entire Asset
Management system.
Created and implemented Asset Manager solutions including
wizards, workflows, actions, SW counters, features, views, and
queries. Asset Manager Database administration of user
profiles, authorization codes, diagnostic and repair database.
Developed new and support existing Connect-It scenarios.
Designed SQL Server Web Reports. Supported Asset Management and
Core Data Load. Identify, analyze, and resolved applications
support deficiencies.
. Delivered a wide range of functional enhancements and
performance improvements for the custom applications that
require creation of the MS SQL database stored procedures,
triggers, indexes, jobs, queries, and security profiles.
Developed User defined Functions, created views and reports.
. Optimized the database, performed quality assurance and testing
of SQL server environment. Developed new processes to facilitate
import and normalization, including data file for
counterparties. Ensured best practices are applied, integrity of
data is maintained through security, documentation, and change
management.
. Performed Data Extraction, Transforming and Loading (ETL) and
most of the SQL Server Management Studio functionality using T-
SQL DDL/DML, Scripts and Batches.
. Worked with business stakeholders, application developers, and
production teams across functional units to identify business
needs and discuss solution options, recommended and implemented
changes.
PROJECT ACCOMPLISHMENTS:
. Planned, developed and implemented upgrade from Asset Manager
5.22 and Connect-IT 4.11 to Asset Manager 9.40 and Connect-It
9.50 including database schema migration. Set up and configured
web application server to enable HP Asset Manager Web Client.
. Designed, developed, implemented and maintained integrations
between Asset Manager and Active Directories, MS SCCM, VMware
Service Manager, Citrix XenMobile, HR database to fully automate
manual business processes.
. Developed Catalog Administration tools that perform computer
staging, transfer, replacement and restore for remote PCs via
web interface to reduce PC staging phase.
. Automated Asset Manager Employee data status changes to enhance
security of the IT Product Catalog.
. Developed components using WMI in VB.Net to integrate with SCCM
via a Web portal.
VOLT Services Group, Findley, OH - Marathon Oil Company account
2004 - 2005
Software Application Consultant
Technical Engineer for Software Delivery System and Software
Introduction Process with end-to-end responsibility of
infrastructure and software components.
Developed and supported AssetCenter Software Delivery Workflows,
Connect-It scenarios and
AssetCenter Reports. Provided Technical knowledge for
improvements and system optimization.
Ensured overall and high-level technical knowledge of all
components of the Software Delivery System
(i.e. MS SMS, HP Asset Center, HP Connect-It, HP Get-It, SMS
Gateway, Web IT Product Catalog)
Electronic Data Systems, Rochester, NY
1998 - 2004
Software Analyst
Major projects:
. Digital Workflow (DW)
Customized out of the box AssetCenter and ServiceCenter
applications Designed, developed, and implemented complex
customized Crystal Reports and stored procedures in Sybase
environment for multiple clients.
. Navy Marine Corps Intranet (NMCI) Asset Management
Designed, developed, and tested background and interface
programs based on AssetCenter API. Completed assignments that
involved C, Pro*C, and PL/SQL programming in second tier of
application support. Developed triggers and stored procedures
against Oracle 8i database to customize Peregrine AssetCenter
application to meet business requirements. Created C Shell Unix
scripts to automate C and Pro*C programs compilation and
scheduled batch jobs.
. E.Value Asset Center Management (ACM)
Designed, developed, tested, implemented, and supported
AssetCenter E.Value Web Interface that involved IIS, JRun
Application Server, Visibroker CORBA, LDAP Directory Services,
Java Servlets, JSP tools, and technologies, utilizing knowledge
and skills in Java, Java script Dynamic HTML, and SQL.
Administrated MS SQL server 7.0 database to support automatic
printer driver installation and mapping across all Xerox
accounts nationwide. Proved as a source of technical and
business function expertise. Assisted with personal development
through mentoring, leadership, role modeling and sharing
knowledge.
. Xerox Non-production (XNP)
Planned and supported the implementation of Electronic
Commerce technology solution for communicating business
transactions with external suppliers via Intranet. Tested
and certified Supplier Catalog Load. Created and
maintained Global Standard Reports in WebFOCUS environment.
Participated in Oracle Application testing. Gathered
requirements, developed, tested and certified Electronic
Data Interchange (EDI) Module in Oracle Application for
Electronic Commerce Inbound and Outbound transactions.
PROJECT ACCOMPLISHMENTS:
. Developed an interface program for UNIX that extracts
critical data from Oracle database for Billing Group,
allowing the delivery of customized reports on demand,
providing business analysis, and reducing operational
costs.
. Developed Visual Basic applications to fully automate
silent installation of the Oracle and AssetCenter client
applications. The implementation of the program provided
time efficient, effective, user friendly, and error free
installation for a user base of 1,000+.
. Designed, developed, and tested Web interface for
AssetCenter database utilizing skills in Java, Java
Servlets, HTML and ASP. This implementation permitted users
to access AssetCenter database and manage assets via Web
Interface without having AssetCenter client installed on
their computers. This project increased the number of
concurrent users and reduced license cost.
Telecom Consulting Group N.E. Corp.
Johnson & Johnson Research and Development Facility, Rochester,
NY 1997 - 1998
Desktop support
. Provided network design for TCP/IP, Domain Servers, firewalls,
gateways, routers, data
communications on Wide Area Network with over 1,200 users
multiple platform LAN.
. Managed installation, configuration and troubleshooting
Windows OS, MS Mail, Antivirus software.
EDUCATION:
AAS - Computer Technology
Monroe Community College, Rochester, NY
1996
BS - Mechanical Engineer
Kiev State College of Technology, Kiev, Ukraine
1986
CERTIFICATION:
Java programmer certificate
EDS Information Analyst Development (IAD) program 1999