AddThis Social Bookmark Button
Guido Piedra ( Available )
Tigard, Oregon - 97223 USA
Expertise :IT Integration/Interface Microsoft Biztalk, Developer, Support Specialist
Status :Citizen
Job Type :
All - W2
Position :Management Occupations, Computer and Mathematical, Education, Training, and Library

Resume
 
Summary





Seasoned IT Specialist with experience in a variety of roles ranging from software development and system/database administration to account and business management. Involved in every aspect of project implementation from analysis and requirements gathering to technical architecture and management. Experience in documentation, project lifecycle methodologies and development of training courseware. Recently involved in web-based, multi-tier application development, with a focus on e-commerce and content management solutions. Involved with application audits and Sarbanes Oxley remediation efforts.
Experienced with : Finance, Billing, HR, Marketing, Sales, Manufacturing, Supply Chain, Global Logistics, Warehouse Management, Production Control, Customer Relationship Management, Medical, Optical Lab Management, Network Management, Service Center Administration, Internet and IT Consulting.
TECHNICALL SKILLSET : experience in a wide variety of platforms, Windows, Unix and IBM.
languages/apps : Net, BizTalk, Visual Studio, Visual Basic, Visual Source Safe, Access Vba, Visual Web, Powerbuilder, Sybase Sql, Mysql, T-Sql, Pl/Sql, Sql/Plus, Toad
Stored Procedures, C, C#, Java, J Builder, Jre Applets, Unix Shell Scripting, Fedex/ Ups Tagged Transaction Api, Interdev, Loftware, Easy Label Create
Ms Crystal Reports, Crystal Query, Oracle Reports, Developer 2000, Infomaker, Enterprise Manager, Query Analyzer, Web Forms, Frontpage, Flash Technology, Html, Xml, Asp. Net, Accuate, Filenet, Content Management, Optimal Trace, Test Director, Crm, Active Directory, Remedy, MQ Visual Edit
database/server : Oracle, Sql Server, Access, Netscape Enterprise Server, Pervasive Sql, Hyperion Essbase, Hyperion Xla, Cubes, Metadata, Data Warehousing, office/suites : word, excel, powerpoint, project manager, lotus notes, corel products, photoshop, adobe pdf, messenger, sametime, service center, remedy, clarify/vision, efrontoffice, concur expense, teloquent system, placeware, testdirector, qms quality management system, brio, contact., trim
interface BizTalk - Microsoft adapter for SAP, wcf, mqseries, sap bapi/rfc, cisco, vpn, citrix, terminal server, pcanywhere, live meeting, netmeeting, meeting place, msn instant messenger, ds view, remote assist, wrq reflections, x-windows, castanet, etransceiver, marimba, cti telephony interface, ip telephony, veritas netbackup and backupexec, odbc, oda, ado, olap, http, bapi, ftp, dns, dhcp, tcp/ip, nis, nfs, smtp, ldap, soap, api/
os/hardware : windows nt/server, windows xp, 2000, me, 95 - 98, 3.1, ms-dos, unix solaris, hp-ux, aix, sco, novell, macos 89 and x, novell palm os, pocket pc, macintosh, hp
ibm mainframes : cobol, eztrieve, db2, ims, tso, endevor, infocus, sar express, rpgiii, os/hardware : mvs, vse, vs1, as400 ibm, amdahl, xerox
bilingual proficient in spanish utilized my spanish capabilities for translating legal/technical documents. customized screens to display spanish labels and have created cross-reference tables for use in developing software.


Employment

April, 2007 -  Present
IS Development and Support Specialist

NW Natural Gas

involved in migrating BizTalk projects from 2006 to 2009
BizTalk developer/administrator and single point of contact for deployments of new projects and upgrade of existing projects.
Point BizTalk person in all network/interface/integration meetings supporting all company platforms SAP/CIS-AS400/Oracle/SQL Server using adapters for Web Services, SAP RFC/BAPI, MQSeries, FTP, File
Coordinates scheduled outages to the BizTalk environments.
Monitor BizTalk environments for errors and warnings and engage
Developed the plan to migrate 2004 projects to 2006 environments.
Installed BizTalk Server 2006 R2 Upgrade, SAP Adapters and WCF Components.
Developed BizTalk solutions, implementation, setup and point person in BizTalk Server administration.

Developed SAP Enterprise integration and many other Legacy systems and a CGI-PragmaCAD Dispatch system. Experience with XML Schemas and XSLT maps.
All development was done via Visual Studio using Microsoft BizTalk tools which uses .Net technologies.
Object Oriented code design utilizing both VB.net and C# technologies and SAP BAPI/RFC technologies.
Worked with both Sql Server and Oracle databases.
stored procedures using SQL Server 2005 Management Studio in conjunction with the BizTalk interface tool.
Administered the BizTalk Console application which required configuring Web Service Ports and queues, utilizing the following adapters : WCF, SOAP, SAP, MQSeries.
Developed multiple WCF Web Services for BizTalk and maintained/supported the IIS configurations.
Created documentation for NT Admins to support configurations of BizTalk servers and production applications.
Develop well documented processes and procedures for upkeep of production environment.
Used Source Control to track code changes.
Build MSI packages to push Software from Test-toQA-Production
Played a key role in QA environment Prepping and Testing.
Worked closely with NT Admins and DBA s to develop/maintain application and server environments.
Used Access with Oracle/SQL server databases for both reporting and extraction of data
Used Remedy to track Changes and to support production issues.
Being a utility company I got familiar with many of our core systems like : CIS, GIS, WMIS Construction Management and Risk and Land Systems, Advantix dispatch, Locates system, FieldSmart application


April, 2005 -  March, 2007
Senior Technical Service Analyst

ADP Services

Responsible for over 300 clients using our Web Customer Relation Management system. Extensive experience with the front office business processes, sales, marketing and service.
Managed the software vendors in the delivery of software patches and releases.
Developed and programmed complex software solutions at an R and D level.

Designed documentation, training and FQA groups to ensure field product readiness.
Responsible for development, critical client problem management, defect isolation and resolution. Quality Management System, Clarify/Vision eFRONTOFFICE
Troubleshoot and diagnose and resolve extremely difficult and complex problems to resolution for our CRM system. Enterprise Manager Tools, Query Analyzer, Profiler, SQL, Vb.net, ASP
Retrieval/update processes customer's information to/from the database. Crystal Reports/SQL
Knowledgeable of Taks management, Alerts, telephony processes that take you from contact to contract, purchase and post-sales. CRM
Knowledgeable of IP Telephony hardware and software products, IP phones, media processing devices, voice over IP VoIP gateways and multimedia applications.
Worked in QA/Project Testing, Optimal Trace.
Managed/Configured Group policies for Desktop/Software Active Directory


April, 2004 -  March, 2005
Consultant

Senior System Eng/Technical Analyst Onsite at PacifiCorp

Support/Implementation Financial Data Consolidation System Pervasive SQL/MS Excel
Support/Implementation Hyperion Financial Reporting Hyperion Enterprise/MS Excel
Support/Implementation Employee Online Expense Manager System Oracle/SQL Plus/MS Access
Support/Implementation Employee Performance Appraisal System Softscape/WebApp
Developed or Implementation FDSI Interface FTP/Encryption Software
Developed/Implementation SAP FTP/Interface
Support/ImplementationBAPI SAP Business Application programming interface
Support/Implementation FLT Franchise Tax Licensing and ELI Energy Loan Information
IMS COBOL/EZTRIEVE/ENDEVOR/TSO/JCL
Supported/Managed/Configured Group policies for Desktop/Software Active Directory
Develop/Maintain Technical documentation Word/VISIO


May, 2001 -  March, 2004
Senior System Eng/Developer/Account Manager

., Menlo Logistics

Responsible for critical client problem management, defect isolation and resolution with over 50 clients world wide and specific focus on our GM account in Mexico.
Extensive knowledge/training of Warehouse Management system to provide global logistics solutions.
Develop/Deploy/Admin of Cyclone Solo Server, used for Nortel Networks Interface NT Server
Develop/Maintained Software using formal software development and support methodologies.
Develop/Deploy SIMS/Gemini API/COM Interface Visual Basic/PowerBuilder/SOAP/XML
Develop/Deploy SIMS/UPS Interface Visual Basic/PowerBuilder/SOAP/XML
Develop/Deploy SIMS/FEDEX Interface Visual Basic/PowerBuilder/SOAP/XML
Develop/Maintain SQL Stored Procedures SQL Server/PL/SQL/Oracle/Enterprise Manager/Query Analyzer
Develop/Maintain WEB Application Warehouse Management System FrontPage/ASP/Crystal Query/ Crystal Reports/SQL Server/ Visual Source Safe
Supported/Managed/Configured Group policies for Desktop/Software Active Directory
Design/Develop bar code labels Loftware Software and Easy Label Create
Used Service Center for Job Tracking
Used Active Directory with Win NT Securities performing Win NT System Administration


September, 2000 -  April, 2001
Consultant

Senior System Eng/Developer Onsite at Nike

Supported and Trained Sales personnel in both Apparel and Footwear
Support and Implementation of Sales Planning System VB or MS Access
Deployment/Installations of Squawk Application Sales Query Application Install Shield or VB
Maintain both front end VB and back end Oracle of Squawk application. SQL/UNIX
Designed and Developed Supply Chain Web Application VB/Java
Designed and Developed Sales History application VB/ MS Access


September, 1999 -  August, 2000

Customer Services Specialist/Developer Vision Star

Represented Vision Star on all industry meetings regarding E-Commerce, EDI, Hardware Interface, ANSI Standard and provided technical support during trade shows OLA, VISION EXPO
Responsible for development, critical client problem management, defect isolation and resolution.
Support and Implementation of Optical Lab Management Software RxCalc Application. UNIFY
Support and Implementation of Vision Star Lab Management Software Application PowerBuilder

Created and maintained schedule for in-house employee training Oracle or PowerBuilder
Designed and developed company web site : www.VisionStarLLC.com. Visual Studio/Ms FrontPage
Developed utilities for converting and analyzing lens data Excel, Visual Basic, Visual Studio
Maintenance for numerous databases Oracle or SQL/UNIX Scripts or WRQ Reflections
Provide QA for new releases


November, 1995 -  September, 1999
Technical Services Analyst

Signet Armorlite , Inc

Visited Customer Sites Domestic/International to gather requirements, implementations, provide process training and support and other professional services.
1st contact in providing support for all computer related issues software and hardware to both our customers and software vendors
Responsible for all computer/software maintenance for the technical service department.

Consulted for and supported other IT departments as necessary 1st contact in providing technical support for all lens/optical lab issues
Designed and Developed application for eyeglass lens comparison Visual Basic, Ms Access
Designed and Developed Rx Calculation Application Visual Basic, Visual Studio
Designed and Developed company web site : www.SignetArmorlite.com. Visual Studio or FrontPage
Created numerous technical documents using Word, Excel and PowerPoint presentations providing technical specifications and processing tips for all our lens products MS Office
Proficient in INTERNET, EMAIL, AS/400 NETSOFT, Some RPG
Provide technical support during trade shows OLA, COLA, Vision Expo

Provide experience input to CIS department with issues related to LAN, EMAIL and INTERNET
Help out the CIS group with hardware/software troubleshooting issues


December, 1994 -  September, 1995
Services Consultant

Professional IT Peregrine Systems

Supported over 100 clients worldwide with their Service Center Application which included Financial, Order Management and Asset Tracking Management.

Specializing in implementation services, gathering requirements, installation and customization, systems integration and training in Network Management, Service Center administration and network interfaces, for both Domestic and International accounts
Provided software maintenance and customization on a consulting basis
Extensive knowledge in electronic data interchange, application development, hardware configurations, system integration and client/server applications across many platforms
Extensive knowledge of financial applications like : MRP, IM, OCM, PM
Proficient in UNIX, SQL, TCPIP, SNA, NOVEL, NT, CICS, C, RAD., Paradox, Access, Lotus Notes, Project Manager
Provided technical support for sales team
Provided professional services for companies Nationwide/Worldwide like : Pacific Bell, Pillsbury, Proctor and Gamble, Phillip Morris, IRS, Dahran Saudi Arabia.


March, 1984 -  December, 1994
Prog . Analyst

System . Coordinator/DB Adm . or Xerox Computer Svcs ., Inc




Education

BS Business and Management Pepperdine University Malibu , CA

AS Computer Science El Camino College Torrance , CA
BIZTALK Server Developing Business Processes , SAP Overview , SAP Web Server , SAP ABAP , Visual studio .net , vb.net , ado .net , vb script , visual web dev , interdev
Access vba , Winforms , web forms , advanced data - driven web sites
Powerbuilder , java , c++ , c , c scripts
Oracle reports , oracle dba , sql mapping ingres/oracle , rdbms administration
Sql server , foxpro , sybase

Administrating unix , nt server administration , ms exchange server
Client server installations , network management , tcp/ip , open sna networks
Pos systems , inventory management , change management , order management
Axces , ipas , ftp , ir/expert , report writer , ag/rad 4gl , excer debugger
Ide , clr , msil , jit



Miscellaneous

During the 10 year tenure, was immersed in many areas of the data processing business
Provided technical support and maintenance for all financial applications 1st contact of support for the Billing, Email and Sales Analysis Systems for over 800 clients.
1st contact of support in all computer related issues for the Finance, Marketing, Sales and Human Resources departments
Designed and developed a customer information database 3GL XEROX language ICP
Designed and Developed an employee information database MS ACCESS/VBA
Extensive knowledge of all financial applications like : PR, AP, GL, MRP, IM, OCM, PM, Sales Analysis, Fixed Assets and others
Data Center Systems coordinator running both MVS and VM environments
Operations in Multi-CPU environments.
Coordinator in Technical Support Plans for implementation and Procedural changes of both Hardware and Software updates/installs.
Proficient in a variety of IBM software : OS/DOS/MVS/JES, JCL, NOVELL, SNA, VTAM and other IBM Utilities Large data center utilizing IBM/AMDAHL systems and peripherals
DBA : Database Management and System Performance Management System tuning 1st contact during all system outages or application aborts - Trained and supervised employees
Volunteer for SMART children reading program
Volunteer soccer/basketball/football coach.
Mike Nicolleti Xerox - Manager
Eric Mirarchi Menlo Logistics Supervisor
David Cuevas Pacificorp Lead
Robin Cassidy Vision Star CEO/Manager
Steve Drake Signet Armorlite Director of Technical Services
Dreux Pangelin Menlo
Alfred Yeap Nike
Rich Turner Neighbor - Oregon Department of Fish and Wildlife
1 of 5