Candidates About

 

Victor Vincent Tischuk       

 

             

SUMMARY OF QUALIFICATIONS

 

Project Management

20 years of experience in project methodologies including Oracle Agile PLM,  PDM,  RAD,  JAD, SDLC, XP.  Managed small and large teams of five to 10 FTE and 150+ contractors. Experienced with MS Project and Primavera.

 

Business Analysis

Finance & Financial Management, Mortgage, Securities, Mutual Funds, Retail, Manufacturing, Supply Chain.

 

Business Intelligence/OLAP Experience

Cognos 8 & 10, Business Objects, Microstrategy, SSAS, Essbase, OBIEE, Oracle Express, Discoverer & Financial Analyzer

 

System Administration Experience

AIX, Solaris, HP-UX, NT/2000, VAX/VMS, AS/400, OS/390 MVS

 

Database DBA, Apps DBA & Developer Experience

20 yrs Oracle, 8 yrs Oracle Apps, 5 yrs DB2, 10 yrs SqlServer, 5 yrs Access,

3yr Model 204, 6 yr Teradata

 

ETL Tools

Oracle Warehouse Builder, Oracle Data Integrator, Informatica, SSIS, Pervasive, Biztalk, Talend

 

Technical Writing

Ziff-Davis (Element K) Courseware - writer/editor for the Oracle DBA & Developer

EDI Manuals/User Guides/Workflow for Mellon Financial

Black Box Catalog User Guides & Product Descriptions

20 yrs of writing Technical Documentation for Applications Development

Content & Web Site Development for Oracle, Ford, MetalSite, and Calgon

 

Development Tools

Oracle Developer Forms & Reports, Oracle Designer, JDeveloper, Visual Age for Java, Crystal Reports, ERWIN, ER/Studio, TOAD, BTEQ, SQL*LOADER, SQL Navigator, SQL Query Analyzer, BIDS, Visual Studio, Eclipse, Enterprise Manager, Fastload, MultiLoad, Synon

 

Programming Experience

SQL (20yrs), PL/SQL (15), HTML (10), Javascript (4), Java (2), XML (5)

COBOL - 10+ yrs w/ Financial, EDI, Manufacturing & Supply Chain Applications

Visual Basic - 6 yrs Manufacturing, Publishing, Engineering & Laboratory Applications

FORTRAN - 4 yrs Manufacturing & Scientific Applications

C - 4 yrs Scientific Applications & Device Drivers

Focus - 2 yrs Human Resources & Sales Applications

Clipper, Dbase, FoxPro, Assembler - Miscellaneous LAN Applications

 

 

Datawarehouse Experience

 

Sallie Mae – Data Architect, Designer & Developer

Created a Credit Reporting Datawarehouse using SQL Server 2000 & Analysis Services.

 

SBC - Designer & Developer  Largest Single Instance Teradata Datawarehouse,

Responsible for Financial Systems Integration.of SBC and Subsidiary Companies.

 

Verizon Wireless - Data Architect, Designer & Developer

Created Multi-terabyte Oracle Datawarehouse for Retail, Marketing & Financial Applications Reporting, partial ODS and ETL with remote Teradata & DB2 Datawarehouses

AIX, Solaris, NT, DB2, Teradata, Cognos

 

Raytheon Data Architect, Designer & Developer for  8 Kraft/FDA Datawarehouses.

Oracle Designer & Developer, Business Objects, Crystal Reports

 

AT&T – Data Architect, Designer & Developer

Development of AP, AR, GL & OE DataMarts from the CFO Datawarehouse. Oracle, Hyperion, Crystal Info.

 

ERP Experience

Oracle Applications, Great Plains, Microsoft Dynamics Nav & custom developed applications

 

Network Design & Implementation Experience

Local & Wide Area Networks using Ethernet, Token Ring, VTAM, SNA, SMDS, ATM, TCP/IP, Cisco & Nortel routers, switches, hubs, OpenView, Netview, Sniffer.

 

Systems Programmer Experience

10+ yrs OS/390, MVS, VTAM, CICS, RACF, ACF2, CA PRODUCTS, BMC, COMPUWARE, JCL, TSO, TCP/IP, ASSEMBLER, SAS, SMP/E

 

EDI Experience

Developer/Installer Sterling, Harbinger/Peregrine, Trading Partners

 

 

 

EMPLOYMENT HISTORY

 

 

Volt Technical Svc / RDX                   Nov  2015-Present

Contract   SQL Server / Oracle / MySql /  DB2/  Mongo  DBA/Analyst    

 

Created  Database and Application Alerts in Powershell, Bash, Perl, Vbscript, JMX, WLST,

SQL, PL/SQL.

 

Collaborated with Customer Integration to define customer requirements for custom alerts and resolve issues.

 

Created Development Sandboxes for Oracle E-Business Suite, MySql, Postgres, Sql Server (w/ Alwayson & Replication), MongoDB.

 

Setup Solarwinds Monitoring for all databases:

 

·         Installed Oracle Databases 11.2 & 12.2

·         Installed Sql Server Database Versions 8, 12, 14

·         Installed DB2 Version 10.5

·         Installed MySql Versions 4.1-5.7

·         Installed Mongo DB 3.2

·         Installed DB2 – 10.5

·         Installed Oracle E-Business Suite  12.2.2

·         Installed Oracle E-Business Suite  12.2.4  including Fusion Middleware.

 

Environment: VMWare, Virtualbox, Windows Server 2012, Linux, AIX, HPUX, AWS, Azure, Apache, Weblogic.

 

 

 

IBM/Citibank                      Feb  2015- Nov 2015

Business Analytics Application Architect (contract / remote)  

 

·           Lead Business Analytics projects with client and development teams.

·           Developed  relationships between the customer and development teams to collaborate in the development of analytics solutions.

·           Developed Detailed Design Documents from the contract and client interviews..

·           Generated correlations and  hypothesis based on data output, Outcome assessment, Statistics, data analysis.

·           Created data flow analysis and mapping, data visualizations, presentation packaging, reviewed report design and user testing with clients.

·           Design and lead the team in the execution of the Analytics Engine solution & integration of data sources, excellent communication skills working closely with client to design analytic solutions and contractual reports.

·           Created analytics solutions to address pain points and created dashboards with the development team.

·           Designated Resource for Business Analytics Scrum projects.

·           Agile/Scrum resource for Softlayer Cloud infrastructure and software installation, development and testing.

·            Tools: Cognos, Crystal, DataStage, DB2, SPSS,  SQL, Tableau, Watson Analytics & Softlayer.

 

 

NASA GSFC, MD                Feb  2015-Jun 2015

Contract SQL Server DBA/Analyst GSFC  (remote part time)  

 

·         Analyzed Servers and Databases. and presented project plans to NASA.

·         Developed and implemented Maintenance Plans for test and production servers.

·         Created scripts in T-SQL & Powershell.

 

 

 

University of Pittsburgh Dental School Pittsburgh, PA                  Aug  2014-Oct 2014

Contract to Audit and Upgrade School IT Systems  

 

·         Audit Security/Access  for HIPAA compliance.

·         Analyze, recommend and implement improvements for Disaster Recovery.

·         Performance Tuning of Oracle RAC databases , RMAN backups,  Crystal Reports and applications.

·         Upgrade software and resolve  system,  network, cluster, database and application problems.

·         PL/SQL, T-SQL and Unix and Powershell Script programming.

 

 

 

Motorola                Pittsburgh, PA                                                      Aug  2013-July 2014

BI Analyst/ Data Architect

 

·         Product Development for Big Data (RFID) Business Intelligence.

·         Performed a comparative analysis of competing products and made recommendations for the TBD Motorola product.

·         Developed Specifications and Requirements for Master Data, Metadata, Business Analytics,  ETL and Interfaces.

·         Designed and implemented Server and Mobile (Windows CE) Schemas.

·         Created packages for Change Data Capture updates of downstream databases.

·         Created packages for ETL and Reports.

·         Installed Virtual Machines  for Hortonworks, Cloudera and Oracle Big Data for Proof-of-Concept.

·         Converted the RDBMS production schema into Hadoop for each VM and interfaced the existing Front End.

·         Code development in Hive,  Pig, Sqoop, Hbase, T-SQL, PL/SQL, C#.

·         ETL development between SQL Server & Hadoop with Talend Data Studio.

·         Agile PLM development environment with MS Project, Team Foundation Server & Red Gate change control.

 

 

 

Aetna      Pittsburgh, PA                                                                      Sept 2012-Aug 2013

Business Analyst/ Oracle Developer 

 

·         Analysis and Documentation of Pharmacy Systems and Interfaces.

·         Implementation of Schema Changes for Development.

·         Report Development for Accountable Care Organizations.

·         ETL of data from Aetna and CVS Caremark.

·         Unix Development for ETL and Reports.

·         Performance Tuning of Oracle and Linux scripts and packages.

·         Environment: Oracle 10.2, Oracle 11.2, Linux

 

Prequel Solutions Pittsburgh, PA                                                       July 2011-July 2012

Business Analyst/ Oracle Developer/ DBA 

 

·         Analysis and Documentation of Tax Accounting Systems.

·         Analysis and Development of a Taxpayer Information System.

·         Analysis and Development of a Tax Refund System.

·         Data modeling and design of the new system.

·         MDM of Municipal Tax and Payroll Data.

·         Metadata management of data to comply with state tax laws.

·         Data Governance, Data Analysis & Data Cleansing of Taxpayer Data.

·         Installed Oracle 10.2 & 11.2, Oracle SOA, OBIA & OBIEE.

·         Installed Clean_Address & Mellisa Data and interfaced to Oracle Spatial.

·         Developed scripts and stored procedures.

·         Geocoding if Municipal and School Tax Districts with Oracle Spatial.

·         Taxpayer address standardization and verification.

·         Oracle PL/SQL, Forms and Reports and BI Publisher Development.

·         Interface development & testing (AR, Payables, GL).

·         Troubleshooting & Performance Tuning.

 

 

Verizon  Wireless Orangeburg, NY                                                                 Dec 2010-July 2011

Cognos Business Intelligence Analyst/Developer Oracle Data Integrator/ETL Developer

Contract to migrate Legacy data using ODI/OWB and to develop new Cognos applications.

 

·         ETL of Big Data with Oracle Data Integrator (ODI) accessing data in Oracle Financials 11.5.10, OBIA, Peoplesoft 9.1, SSAS, Impromptu, Cognos cubes, Spreadsheets, Text files.

·         Used Oracle Warehouse Builder (OWB) to created daily extracts/imports of EBS and Peoplesoft data into the Reporting Data Warehouse.

·         Enterprise Content Management (ECM) using Oracle Data Integrator for data transfers between Peoplesoft and third party Instructional vendors software and EMC Documentum.

·         Cognos 8.4.1 Business Intelligence Development in an Oracle, Teradata and Peoplesoft 9 environment for Financial, Services, Human Resources. & Executive Reporting.

·         Data Modeling with ERWIN & Framework Manager.

·         Cube Development with Transformer & SSAS.

·         Report Development in Cognos 8.4.1 (production) and Cognos 10 (Development), Business Objects, Excel

·         Master Data Management/Metadata Management of new data sources.

 

 

 Iglobal Group Nyc, NY                                                                                          May-Nov 2010

Cognos Business Analyst, Database Administrator and Developer

 

Project to develop a Middleware ERP/EDI Product.

 

·         Installed and maintained multiple Oracle, SQL Server, Cognos, Apache, Jboss systems.

·         Installed and configured Cognos 8.4.1 Business Intelligence.

·         Created Models from multiple data sources in Cognos Framework Manager.

·         Created Dashboards and Reports using Report Studio, Analysis Studio and Event Studio.

·         Assisted Java Developers in skinning Cognos for customers using Cognos SDK and  Mashup Services.

·         Programming with SQL, PL/SQL, SSIS and T-Sql.

·         Interfaced with data from Sterling Gentran EDI.

·         Data Governance and Data Cleansing of customer data.

·         Business and Data Analyst.  Wrote requirements to customize the product based on                           customer requests.

·         Data Modeling of ERP Schemas for Customers EDI and Middleware systems.

·         Custom EDI, XML and XQUERY development.

·         Maintained Laboratory Servers.

·         Oracle, Sqlserver and Network Performance Tuning & Troubleshooting.

 

Wendys/Arbys Group Columbus, OH                                              03/10 - 04/10

Consultant – Business Analysis

 

Project to convert Cobol/DB2 programs to Oracle.

 

·         Identified & Analyzed Cobol/DB2 programs for conversion to Oracle.

·         Created Informatica ETL Design Documents.

·         Created Oracle & DB2 Queries.

·         Created Visio Diagrams for the existing Cobol processes and the new ETL processes.

 

 

Safeguard, Cleveland, OH                                                 03/07 - 12/09

Senior Consultant – Business / Data Analysis

 

Project to replace a legacy Big Data (multi-terabyte) CRM system with a new SOA.

 

·         Identified & Analyzed Data Sources for ETL processes including Legacy Systems and          Microsoft Dynamics Navision.

·         Data Profiling and Quality Analysis of Source Data.

·         Created automated Data Quality processes for feedback to source systems and users.

·         Data Governance and Data Cleansing of mortgage data.

·         Planning for Master Data Management.

·         Created ETL Design Documents, ETL Maps & Processes

·         Installed & used Pervasive Business Integrator.

·         Installed SQL Server 2005 & Navision Financials on Windows.

·         Tuning & Troubleshooting of Oracle/ASP/Nhibernate/Navision/SQL Server Performance.

·         Installed Oracle 10.2 on Windows & Solaris.

·         Created External Tables & PLSQL Stored Procedures.

·         Oracle 10.2 Performance Tuning & Troubleshooting.

·         Created reports with Oracle Reports Builder and Cognos 8.3 (Framework Manager,               Analysis Studio, Report Studio, Query Studio, PowerPlay Studio).

·         Installed Oracle 11G and Oracle Warehouse Builder.

·         Used Oracle Warehouse Builder, Pervasive & ODI to migrate ETL processes to 11G.

 

Environment:

Oracle 10/11g, Informatica Power Center 8.1.6, Pervasive, OWB, UNIX Shell Scripts, SQL, PL/SQL, SQL*PLUS,  MS SQL Server 2005, T-SQL, TOAD, ERWIN

 

 

IBM Global Services, (remote)                                                       04/07-07/07

Business and Database Analyst

 

Remote Support for IBM SCON

 

·         Documentation and Analysis of Client Databases (Oracle, Sql Server, Essbase, DB2, Informix, Sybase) to plan for server consolidation.

·         Conducted in-person and remote client interviews.

·         Enhanced ASP/SQL Server consolidation tools.

·         Installed SQL Server 2005 on Windows.

·         Developed T-SQL scripts for IBM SCON toolset.

·         Tested IBM SQL Server consolidation tools.

·         Tested IBM consolidation tools.

 

Environment:

Oracle, Sql Server, Essbase, DB2, Sybase, T-SQL, ASP.NET

 

 

Otto Bock Healthcare, Minneapolis, MN                                                       02/07-03/07

Infrastructure and Database Analyst

 

SQL Server Cluster Installation and Migration

 

Otto Bock needed to implement a disaster recovery solution and simultaneously upgrade it's databases and interfaces to SAP and Access.

Role & Contribution:

 

·         Analyzed existing IT infrastructure and databases.

·         Submitted recommendations to client.

·         Installed Windows Server 2003 Cluster.

·         Installed Sql Server 2005 Cluster, SAC, Reporting Services.

·         Migrated databases from Sql Server 2000 to Sql Server 2005.

·         Added/Modified SAP Interfaces and Business Objects Reports.

·         Modified VB & Access front ends to use the new cluster.

·         QA & Testing of the Applications and Cluster.