Developer Data
Resume:
Victor Vincent Tischuk
********@*****.***
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