OLEG BOCHKIS

323-***-**** ● acq5mp@r.postjobfree.com

SKILLS AND EXPERIENCE SUMMARY

Operating Systems & infrastructure

Installation, administration and configuration: MS Windows 2012/2008/2003 servers, VMware products, MS Hyper-V, Linux (Ubuntu, Red Hat, Debian, SUSE, Oracle Enterprise Linux), and Solaris

Expertise in deploying and managing LAMP (Linux, Apache, MySQL, PHP) MS SQL Server, MySQL and Oracle DBMS

Deployment, integration, configuration and administration of Data Bases, Data Warehouses and Data Marts using Oracle DBMS, MySQL, and MS SQL Server DBMS software

Management of databases using: MySQL Workbench, MS SQL Server Management Studio

Experience with SQL, PL-SQL, and Transact-SQL

Deployment and implementation of MS SQL Server Analysis Services, SSIS and MS SQL Server Reporting Services

Performed user requirement and data analysis, created various databases, Data Warehouses and GUIs, developed reports and implemented ETL for number of clients

Web Servers

IIS, Apache, WebSphere, Oracle iPlanet Web Server Networking and Telemetry

Installation and administration and configuration : CISCO Network Routers, Switches, VPN/Firewalls, Security Appliances (ASA, etc.), and Juniper devices for cloud services and on-premises

Installation, integration and trouble shooting of different wireless and wired meters, gateways, and sensors using different connectors and protocols (e.g. Modbus, BACnet, RF, Wi-Fi, SSH/SCP, and IIS)

Enterprise Security, Identity and Access Management

Installation and administration and configuration: MD Active Directory, AD LDS, SUN LDAP & Oracle OID LDAP

Extensive knowledge and experience in designing and implementing Microsoft AD, ADFS and Oracle Identity Management products including OIM, OAM, OVD, & OID in large Secure Enterprise Environments for cloud-based solutions and for on-premise solutions

Java

Experienced in designing and developing Java database applications using Oracle

(Sun) Java

Microsoft .NET

Has extensive knowledge and hands-on experience with MS VB 6.0 and VB.NET

Designed GUI for MS SQL server, MS Access and Oracle 9/10/11i based database applications

Middleware & Portals

Installation, administration and configuration: MS SharePoint 2013/2010, MS AD, and Oracle Middleware for cloud-based solutions and for on-premise solution PROFESSIONAL EXPERIENCE

PIE Systems International, Inc., Los Angeles, CA (2004–Present) Senior System Integration Manager

Sr. Systems & Integration Engineer/Administrator, MySQL Administrator, MS SQL administrator, Enterprise Identity management designer/administrator, and network administrator.

PROJECTS:

Chevron Corporation, California (2013–Present)

Sr. Systems Engineer

Was in charge of installation, configuring and administering of innovation lab private cloud solution, including: VMware products, Juniper, SharePoint 2013, SQL server databases, SSAS cubes, MS ADFS Federated Identity & Access Management product. Deployed Data Vault Data Warehouse. Configured SSAS integration with SharePoint in Tabular Mode. Installed and configured PowerPivot for SharePoint in Integrated Mode. Configured Excel Services on the SharePoint Server. Was responsible for planning, feasibility studies, procurement support, project management support, technical consulting, technical documentation, and user training.

PeopleKeys, Inc. (2014)

Sr. Systems Engineer

Migrated MySQL Database and LAMP applications from Rackspace cloud to Expedient VMware environment. Upgraded: MySQL, Apache, PHP. Configured multi-tier secure access to MySQL, fixed MySQL problems and stabilized MySQL databases. Created Linux based testing and development environment using Digital Ocean cloud hosting. Wrote user manual and use cases which were utilized by the client during UAT.

Oklahoma Gas & Electric and University of Oklahoma (2011-2013) Sr. Systems Integration Manager

Project goal was to implement and configure Smart Grid, Enterprise Energy Management System – smart micro-grid Cloud Service solution design based on iEnergyIQ SaaS, Microsoft stack, Cloud-based Federated Identity & Access management services, and Security technologies.

Was responsible for: data collection, planning and feasibility studies. Administered MySQL database for telemetry gateways and implemented connectors. Oversaw: networking, VPN, meters, gateways. Conducted sensors installation, and integration for smart grid Energy Management (electricity, steam, chilled water, natural gas). Used Operational Analytics and Operational monitoring for management and control of meters, devices, sensors (Meters Data Management -MDM/AMI) for a very large campus with 500 buildings, and a Portal. The implementation included integration with Utility smart grid with Honeywell Building Automation System and asset management system.

State of California Courts System (2009-2011)

Sr. Systems Integration Engineer

Project's goal was to modernize California Courts' Case Management System and Access & Identity Management system. Was responsible for oversight, review and validation of Deloitte integration technology and solutions. Conducted feasibility studies and implemented Enterprise Access and Identity Management. Installed and configured Federated Identity and Access Management pilot per US DOJ Requirements. Work included design and implementation of custom Child Forms, as well as adding custom identity attributes to various screens, displaying custom messages/banners on certain screens, hiding certain UI controls from a specific set of users. It also involved designing custom validations that were triggered when form data is submitted or a field value changes. Furthermore was responsible for the design of Custom Approval Process for Self Registration and Custom Approval Workflow using both Parallel and Serial Approval. Developed new and customized existing Oracle Identity Manager adapters using OIM Adapter Factory. Was responsible for customization of Oracle Access Manager AccessGates/WebGates, Authentication Plug-ins, Authorization Plug-ins. Provided project management support, technical consulting, quality assurance, and supported UAT. Wrote technical documentation and user manuals which were later used by the client.

State of California EDD (2009-2010)

Systems Integration Engineer/Implementation Manager Was in charge of deployment and implementation of Oracle-based (Oracle Identity Manager, Oracle Access Manager) automated Identity Management Solution. Work included design and implementation of custom Child Forms, as well as adding custom identity attributes to various screens, displaying custom messages/banners on certain screens, hiding certain UI controls from a specific set of users. It also involved designing custom validations that were triggered when form data is submitted or a field value changes. Furthermore was responsible for the design of Custom Approval Process for Self Registration and Custom Approval Workflow using both Parallel and Serial Approval. Developed new and customized existing Oracle Identity Manager adapters using OIM Adapter Factory.

Was responsible for customization of Oracle Access Manager AccessGates/WebGates, Authentication Plug-ins, Authorization Plug-ins. Was responsible for planning, feasibility studies, procurement support, project management support, technical consulting, and quality assurance. Wrote user manuals and use cases which were utilized by the client during UAT. Conducted end user training via WebEx.

State of California DMV (2007-2008)

Systems Integration Analyst/Technical Consultant for Tivoli IAM installation, configuration and integration. Was the lead for the installation and configuration of IBM Identity and Access Management Suite in VM-Ware based test and development environment. Was in charge of rolling out new IAM configurations. Performed analysis of the effects caused to the system's performance by various IAM configurations. Wrote user manual and use cases which were utilized by the client during UAT.

California ISO (2007)

System Integration Analyst for the project that involved implementation and integration of Oracle based Enterprise Identity Management design with Enterprise applications and databases.

Systems Integration work included Enterprise Identity Management integration with SUN LDAP, MS Active Directory, MS Exchange, Oracle Database, Enterprise Oracle Internet Directory, JBOSS, and Oracle Application Server & Virtual Directory. Work included design and implementation of custom Child Forms, as well as adding custom identity attributes to various screens, displaying custom messages/banners on certain screens, hiding certain UI controls from a specific set of users. It also involved designing custom validations that were triggered when form data is submitted or a field value changes. Furthermore was responsible for the design of Custom Approval Process for Self Registration and Custom Approval Workflow using both Parallel and Serial Approval. Developed new and customized existing Oracle Identity Manager adapters using OIM Adapter Factory.

Provided technical consulting and aided in quality assurance. Wrote user manual and use cases which were utilized by the client during UAT. American Express (2005-2006)

System Integration Analyst for hosted TRIRIGA facility management suite with multiple Applications using ETL tools, .NET framework and JBOSS. Was responsible for security administration, systems analysis, system requirements (Use Cases and data elements), design and implementation of ETL Data Migration, Interfaces with external databases, reporting based on MS SQL Reporting Services, Systems administration, MS SQL Server database administration, and Data Warehouse. Data Interfaces were created between MS Access, MS SQL Server, FoxPro DBF, MS Excel, and other data sources. Wrote user manual and use cases which were utilized by the client during UAT. American Express

Audit and IV&V of multiple applications for compliance with SOX (2004) Systems Integration Analyst in the team which performed assessments of 1,200 applications, including: information security controls/processes, MySQL and SQL server databases, application architecture, and identified remediation steps necessary to bring items into compliance with information security best practices. This included: providing recommendations, creating an advanced analytical and reporting system to perform risk assessment, and generating reports for top management.

The Procyon Group, South Cate, CA (2002-2003)

Systems and QA Analyst, Test Tools Software Developer Responsibilities included: creating systems requirements (Use cases, data model), creating test cases and test procedures for different parts of LIMS II application, and administering MySQL database.

Lenax Construction Services, Los Angeles, CA (1999-2002) Software Designer/Developer, Systems Analyst, Data Base Administrator Responsible for design and maintenance of databases (MySQL and Oracle) and applications used for estimation for various commercial constructions works: Price Database, Client Database, Report Manager, and Database for maintaining historical information on productivity and time control. Prepared use cases, forms, tables and test data. Participated in planning and selecting of the hardware and software to be used in office automation projects as a computer system support specialist.

LANGUAGE

Bilingual and biliterate in Russian

Contact this candidate