Victor Vincent Tischuk

ac8b02@r.postjobfree.com

412-***-****

SUMMARY OF QUALIFICATIONS

Project Management

** ***** ** ********** ** 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

IBusiness Consulting/Pittsburgh, PA Oct 2018 – Present

Contract Data Manager

**I am available immediately. The 2019 grant money

that pays my salary has been frozen

Data Architect & Data Manager – UPMC/Pitt Department of Neurological Surgery

Database Design and Security

Dashboard Design and Development

ETL of Patient and Seizure Analysis data

GCP, GDPR and HIPAA Compliance

Estaff Consulting/Southpoint, PA/Range Resources Jun 2018 – Jul 2018

Contract Report Developer

SSRS/SSIS Development for Wellview, Siteview & Avocet data using SSRS, SSIS and Sql Server.

Requirements Analysis and Source/Target Investigation.

Upgrade of SSIS & SSRS Projects to Visual Studio 17

Determined the sources of missing/bad data and created/updated spreadsheets tracking missing data and project progress.

Modified SSRS reports to add missing data sources.

Robert Half Technologies/Seven Fields, PA/Beacon Health Options Nov 2017 – Mar 2018

Contract ETL Developer

ETL Development for Healthcare Finance and Claims data using SSIS, Oracle and Sql Server..

Requirements Analysis and Source/Target Investigation.

SSIS development of packages for data transfer between Oracle and Sql Server.

Sql Server administration, performance tuning and troubleshooting.

Visvero/EQT/Pittsburgh July 2017- Oct 2017

Contract Application Architect - Application Integration

Integration of Workfront, Powerplan, Quorum data sources into a BI Framework using Python, Sql Server, Informatica, and Rest APIs(Workfront).

Requirements Analysis and Source Investigation.

Data Modeling of Stage and Target Schemas.

Stage and Target Tables Creation.

Wrote Python scripts using REST APIs to download/flatten JSON objects to csv files (client required csv files).

Informatica Mapping of Source to Target using Powercenter and Informatica Cloud.

Testing.

Enviroment: DBSchema, Sql Server, Oracle, Informatica, Python, Pandas, Powershell

Insight Global/Comcast/Pittsburgh March 2017-June 2017

Contract BI/Operational Management Reporting

Automation and Conversion of Spreadsheet based analysis and reporting to Sql Server databases and Tableau.

Consolidation of multiple operational engineerng datasources in Access, MySql, Excel, Jquery Datatables, HTML, XML to a standard database environment.

Enviroment: Sql Server, Oracle, OBIEE, MySql, VMWare, VirtualBox, Seleniun, Powershell, XataFace, PHP, Sharepoint

Bridge Solutions Group /Belron/Toronto Jan 2017-Oct 2017

Contract(Remote) Oracle / IBM Sterling Warehouse Management System

Analysis, Troubleshooting, Resolution and Documentation of performance issues.

Testing of Recovery Scenarios with RAC & RMAN.

Volt Technical Svc / RDX Nov 2015-Nov 2016

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

Created Database and Application Scripts and Alerts in Powershell, Bash, Perl, Vbscript, Python, 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 and administered the following databases and Sandboxes:

Oracle Databases 11.2 & 12.2

Sql Server Database Versions 8, 12, 14

DB2 Version 10.5

MySql Versions 4.1-5.7

Mongo DB 3.2

DB2 – 10.5

Oracle E-Business Suite 12.2.2

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, customer conversion to IBM Cloud and testing.

Tools: Cognos, Crystal, DataStage, DB2, Python, SPSS, SQL, Tableau, Watson Analytics & Softlayer, IBM InfoSphere MDM, IBM Master Data Management on Cloud (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 of 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 create 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.

Environment:

SQL Server 2000/2005, SAP, Access

NHS – Southend Hospital, Essex, England 01/07-02/07

Sr. Developer Analyst

Project : Emergency Troubleshooting of Oracle Databases and McKesson Software

Description

Hospital software was failing continuously and impacting patient care.

Role & Contribution:

Emergency review of McKesson Software problems.

Submitted problem analysis and proposed solutions to vendor.

Upgraded to Oracle 10.2.

Reinstalled McKesson software.

Applied new procedures and parameters.

QA of implemented solution.

Environment:

Oracle 10G, McKession Software

Thompson Reuters Lipper Group., Denver, CO / St. Louis, MO 01/06-01/07

Business Analyst, Data Analyst, Database Administrator

Project to replace the Reuters Hindsight Fund Manager client and existing web services with a consolidated Mutual Fund and Investment SOA.

Business Analyst/Data Analyst - Reuters Lipper Group Denver CO

Reverse Engineered existing Mutual Funds Software to move to an SOA.

Identified & Analyzed Data Sources for ETL processes.

Data Profiling and Quality Analysis of Source Data.

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

Developed Requirements for Investment Analysis Databases & Applications.

Created Design Documents for the new SOA.

Developer/DBA - Reuters Lipper Group St. Louis MO

Installed Oracle 10.2, designed Financial & Investment Databases.

Wrote PL/SQL stored procedures.

Implemented Oracle Streams and Oracle Text structures & processes.

Troubleshooting and tuning of multi-tier .Net and Oracle development.

Environment:

Oracle 9.34/10G, ASP.NET,ERWIN,TOAD,STREAMS

Dataquest Corporation., Pittsburgh, PA 10/05-01/06

Business Intelligence Analyst - Healthcare Informatics

Project to use 2005 dollars to get a head start on 2006 scheduled Business Intelligence projects.

Functional & Technical Analysis and Documentation for Claims Processing projects.

Teradata ETL & Development with Queryman, BTEQ, FastExport, MultiLoad.

Database & Application Performance Tuning.

Data Quality Analysis of EDW & Source System Data.

Environment:

Teradata, Oracle, MS Project, ERWIN, Visio, Access.

Alltel Corporation., Twinsburg, OH 07/05-10/05

Oracle Developer & DBA

Project to replace Mainframe Marketing and Order Entry Systems with Web based software.

Functional & Technical Requirements Analysis for a Marketing & Order Entry Web/CICS Replacement Project.

Oracle 9i & 10G Database Design & Performance Tuning.

Oracle PL/SQL Programming. CICS, SQL Loader, Cobol.

Some Visual Studio .Net, ASP.NET & ODP.NET Programming.

Environment:

MVS, CICS, VTAM, ORACLE, ASP.NET

Excell Corporation., Portland, OR / San Diego, CA 07/05-10/05

Remote DB2 v8.2 DBA

Project to document a DB2 based application, upgrade and tune the database and application, and implement Disaster Recovery using HADR.

Database & Application Analysis & Review

Implemented Database modifications for LOB Logging & Log Shipping.

Disaster Recovery Planning & HADR implementation.

Environment:

MVS, CICS, VTAM, ORACLE, ASP.NET

Seimens Westinghouse Corporation, New Kensington, PA 06/05-07/05

Systems Analyst

Seimens requested a review of the implementation of new Java/Oracle applications. The applications were performing poorly and losing data.

Systems Analysis and review of Java/Oracle application implementation.

Data quality analysis and cleansing of ERP data.

Recommendations for tuning of the programs, network, and databases.

Recommendations for ETL with legacy databases.

Environment:

ORACLE, JAVA, ASP.NET

Sallie Mae, Arcade, NY 04/05-06/05

Datawarehouse Architect

Sallie-Mae required a subsidiary to implement a datawarehouse within a very short time frame. Sole resource for the design and implementation of the Data Warehouse.

Business Requirements Analysis for the Datawarehouse.

Datawarehouse design and implementation at a Sallie Mae subsidiary.

Installed SQL Server 2000 and Analysis Services on multiple Windows 2003 servers.

Designed and implemented Datawarehouse DDL.

Database Analysis, Design & Problem Resolution.

ETL of data from production Unix systems to the SQL Server.

Data Profiling and Quality Analysis of Source Data.

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

Created Stored Procedures, ActiveX programs, and DTS packages.

Implemented Replication, Backup & Recovery & Disaster Recovery.

Wrote Technical Documentation and programs to automate documentation.

Environment:

SQL Server, Unix, ASP.NET, DTS

Vocollect Inc, Penn Hills, PA 01/05-04/05

IVR Developer

Temporary developer position customizing IVR and WMS software.

Custom programming for IVR and WMS systems integration.

Reviewed Requirements Documents and customized Vocollect software products using VB6 and SQLServer 2000 T-SQL Stored Procedures.

Implemented Workflow changes using Vocollect Talkman/TaskBuilder software tools.

Environment:

SQL Server, VB6

NDS Inc, Fairbanks, AK 12/04-01/05

Oracle Functional & Technical Analyst

Emergency project to fix a failed Oracle Financials installation. The GL, AR, AP & GRANTS modules were non-functional. Also, PAYROLL was improperly installed. There were no paychecks, 1099's or vendor payments. The client was very unhappy.

Cleanup of an Oracle 11.5.9/9.2 Quickstart Installation

Analysis and resolution of startup problems primarily with Oracle Grants, AP, PA, and GL modules.

Reviewed requirements & parameters for installation and setup with users.

Implemented changes to eliminate incompatible parameters.

Cleaned up Interfaces and Workflow.

Ran Oracle Diagnostics, initiated TARS and applied patches.

Redesigned Oracle Discoverer reports.

Wrote custom SQL & PL/SQL to fix problems unresolved by TARS for Payroll and Accounts Payable.

Trained users in basic Oracle Financials functionality.

Environment:

Oracle Public Sector Financials 11.5.9, Oracle 9.2, Discoverer.

SBC Inc, St. Louis, MO 08/04-12/04

Business & Data Analyst

Project to create an integrated data warehouse consolidating data from all SBC Divisions and Subsidiaries. Deliverables were Analysis and Detailed Design Documents to be used to create the Financial and Financial Data Management areas of the data warehouse.

Requirements Definition, Design Specifications, and Project Coordination for ETL of Financial and Financial Management Data for SBC & subsidiaries.

Analysis of source systems data and metadata on Oracle, Teradata, DB2 databases and other sources including Oracle Financials 11.5.9.

Validation of Source Data, creation of Requirements Documentation, review and update of ERWIN Data Models and Metadata, development of Mapping Rules and Transformation Logic, creation of Detailed Design Documentation

Reviewed the SEI Capability Maturity Model and presented recommendations necessary to meet the CMM Level 2 Requirements

Used OLAP Tools including Microstrategy, Business Objects, Cognos, MS Analysis Services, Essbase and Oracle Financial Analyzers to generate data loads & reports for the DW Integrated and Reporting Layers.

Environment:

Teradata, Oracle, DB2, ERWIN, Informatica, Test Director, CMM Level 2

Computer Task Group, Pittsburgh, PA July 2004

Oracle DBA and C Developer

Project to upgrade in-house developed Steel Manufacturing Operations software to meet new customer requirements.

Modified the database schema for new tables and fields.

Modified PLC Level 2 and PLC Level 3 programs.

Created new C programs, stored procedures and triggers.

Environment:

Oracle, VMS, C

Website Consultant, Pittsburgh, PA May / June 2004

SQL Server DBA and ASP.Net Developer

Customization of several local small business websites.

Dreamweaver modifications to websites.

SQL Server 2000 DBA and ASP.Net Development

Conversion of Access and Excel applications into SQL Server and ASP.Net applications

Environment:

Dreamweaver, Visual Studio .Net, Sql Server 2000 and Windows 2000

Microsoft Corp, Bentonville, AR March / April 2004

SQL Server DBA, Developer & Biztalk Server 2004 Developer

Proof-of-Concept Project for Microsoft at a large retailer in Bentonville, Arkansas. The project goal was to demonstrate the use of Biztalk Server 2004 to replace the retailer's existing middleware and interfaces.

Technical Resource for integrating applications with BizTalk Server 2004, Teradata, DB2, Informix & SQLServer

Requirements analysis for Enterprise Application Integration with Biz Talk Server 2004

Analyzed Client Interfaces, SQL Queries, programs.

Created SQL Server 2000 Tables and Stored Procedures to load and hold parsed data from the Biztalk Orchestrations and created Stored Procedures to retrieve the requested data from multiple RDBMS and return the data to the Orchestration pipelines

Troubleshooting, testing, tuning of the new Biztalk Retail DSS Systems and interfaces.

Environment:

Teradata, Oracle, DB2, Informix, SQL Server, Biztalk Server 2004

Congressman Tim Murphy Pittsburgh, PA March 2004

Network Technician

Installation of network print servers and printers at U.S.Congressman Tim Murphy's Office coordinated with Lockheed-Martin and Wharton Consulting.

Wesbanco, Fairmont, WV February 2004

Business Analyst / Project Planner

Requirements Analysis and Project Planning to migrate Bank Customer Transaction Data from a legacy system using ETL tools, Banctec Software, NCR Unix and Windows Server.

National City Bank, Pittsburgh, PA 11/03 - 04/04

Network Engineering Technician (on call)

Project to replace branch office Mainframe terminals and applications with Lans, Routers, Workstations and Client Server Software.

Removed old hardware from bank branches, installed new personal computers, cabling, routers and servers

Switched offices from Token-Ring to Ethernet

Installed images on PCs, tested applications

Troubleshooting, user testing and problem resolution.

The Training Associates, Inc, Pittsburgh, PA 03/03 - 11/03

Instructor and Courseware Designer

Independent contract instructor.

Contract instructor at Gateway Computer Stores for a variety of small computer & home office subjects

Course Designer for Oracle Applications, ASP.Net, Visual Studio and .Net Framework courses

Universal Stainless Steel, Bridgeville, PA 11/02 - 02/03

Technical Support Programmer

Project to upgrade Financial Software and databases.

Integration and Support of Great Plains Financial Software with other COTS software and custom in-house development

Creation/Installation of SQL Server v7 databases, views, tables and stored procedures using Enterprise Manager & SQL Query Analyzer

Performance tuning of T-SQL queries, Access, FRx and Crystal Reports and Citrix XP Applications

Mellon Financial Services, Pittsburgh, PA 07/02 - 11/02

Technical Writer / Programmer

Documentation project for EDI, ACH & Wire Transfer. Also developed a Java application to automatically generate documentation from existing Oracle and Access databases.

Development of Financial Services documentation for EDI, ACH, Wire Transfer

Documented workflows for all functions in the EDI department and created user guides and procedures for each employee workflow.

Developed an EDI Documentation System to automatically capture information from the Mainframe and Unix EDI systems and provide GUI interfaces for manual data entry using Access, Java, Oracle and Crystal Reports with the Harbinger/Peregrine Trusted Link EDI and OS/390 RemEDI systems

Verizon Wireless, Dallas, TX 07/00 - 07/01

Project Leader / Teradata & Oracle Developer & DBA

Development of a Big Data Datawarehouse for the conversion and integration of multiple financial and manufacturing systems acquired through Verizon’s mergers and acquisitions including Oracle Financials and Convergys P2K.

Analysis and Requirements Definition for interfaces to the datawarehouse, including the Converges P2K Billing System, extracts to other datawarehouses and Operational and Management Reporting

Worked with Convergys and other vendors to identify and troubleshoot problems.

Data mapping & modeling of the existing and new systems.

Metadata management of source and target systems.

Database & Application design and tuning.

Extraction, transformation and loading (ETL) of data to & from several multi-terabyte DB2 and Teradata datawarehouses and Financial Systems using SQL*Loader, Informatica, DataJunction, DTS. FastLoad, MultiLoad.

Report design using Cognos Impromptu, Transformer & Powerplay, Crystal Reports, Business Objects, Oracle Financial Analyzer, Oracle Forms & Reports, Express, Discoverer. HTML, Javascript.

Oracle PL/SQL & Java stored procedures.

Project planning with MS-Project.

Upgrade of Oracle Financials from 10.7 to 11i and the integration of Oracle Financials and Manufacturing Supply Chain Modules with the Data Warehouse.

Functional requirements for Financials & Supply Chain upgrade including Workflow & API’s.

Environment:

Oracle, Teradata, DB2, Queryman, Toad, Korn Shell, Perl, Informatica, Java, JDeveloper, Oracle Designer 2000, Oracle Developer 2000, Connect Direct, Cognos, Business Objects, Express, Discoverer

Contact this candidate