Post Job Free

Resume

Sign in

Project Design Sql Server Management .Net Business

Location:
Hewitt, TX, 76643
Posted:
June 17, 2011

Contact this candidate

Resume:

Arbra L. Bailey

Opulent SD Consulting, LLC

SUMMARY Possess sixteen plus years of object oriented experience in the

design, development and implementation of business

applications in areas such as oil & gas, consumer products,

procurement, inventory management, logistics, manufacturing

and human resources. Maintains business analyst and IT

skills (including eCommerce Development and EAI

integration), along with 11+ years of experience in web

development and B2B integration.

EDUCATION B.S., Computer Science, Trinity University, May 1995.

PROFESSIONAL .NET

TRAINING Upgrading Your Skills from ASP .NET 1.1 to ASP .NET 2.0

What's New in MS VS 2005 for Existing Visual Studio .NET Developers

Updating Your Database Development Skills to Microsoft SQL Server

2005

BizTalk Server 2004

Programming with the Microsoft.NET Framework (Visual C# .NET)

Programming with XML in the Microsoft.NET Framework

Programming with Microsoft ADO.NET

Developing XML Web Services Using Microsoft ASP.NET

Object-Oriented

Object Oriented Analysis & Design (UML)

Internet

. Web Development with Active Server Pages (included

VBScript, JavaScript & Visual InterDev)

. Commerce One Fundamentals

. E-Marketplace Fundamentals

. Inside SharePoint Products and Technologies

Enterprise Resource Planning

SAP

BC010 R/3 System Architecture, BC030 SAP R/3 Data Dictionary, BC110

R/3 Correction & Transport System, BC170 Introduction to

ABAP/4, BC180 Data Interfaces, BC190 Interactive Reporting,

BC220 Introduction to Online Programming, HR050 Human

Resources Management (NA), CA705 Basics of the Report

Painter, CA710 Advanced Functions of the Report Writer

(NA), CA610 R/3 Computer Aided Test Tool, ABAP Query, HR305

Configuration of Master Data, HR350 HR Programming

PeopleSoft

PeopleTools I, PeopleTools II, PeopleCode, SQL/SQR

Other

Facilitation Training

MCS Information Technology Self Study (MITIS) & MITIS II, Price Waterhouse

LLP

RANGE OF C#, ADO.NET, XML, cXML, XSL, XPATH, MSMQ, WMI, ADO, COM+,

EXPERIENCE VBScript, JavaScript, HTML, Active Server Pages, Visual

Basic, SQL, SAP (3.0D, 3.0F, 4.0B), SAP's CATT (Computer

Aided Testing Tool), ABAP/4, C/C++, Visual Studio.NET,

Visual InterDev, Microsoft Visual Studio 6.0 & 2005 Team

System, Microsoft Visual C++ 4.0 & 5.0, Visual Source Safe

5.0 & 6.0.

BizTalk Server 2000, 2002, 2004 & 2006, Actional 3.1, Microsoft

Commerce Server 2000 & 2002, IIS, Cleo LexiCom 3.1, AS2,

LDAP, OLAP, MarketSite 3.2 & 4.1, SupplyOrder 3.0 & 3.1,

PeopleSoft HR Module, SQR, PowerBuilder 5.0, FoxPro, UNIX

Scripts, RUSH Gateway, FTP, COBOL, JCL, Pascal, FORTRAN.

Microsoft Operations Manager (MOM) 2000.

Microsoft Project, WordPerfect, Microsoft Word, Microsoft Outlook &

Exchange, Lotus Notes, Microsoft Publisher, Freelance

Graphics, PowerPoint, Microsoft Excel, MacDraw, MacWrite,

Lotus 123.

MS-DOS, Windows, Windows NT, Windows 2000/2003/XP, UNIX, OS/2.

LDAP, Microsoft SQL Server 7.0, 2000 & 2005, Oracle, Sybase,

Microsoft Access, DB2.

PROFESSIONAL Opulent SD Consulting, LLC: Senior Consultant, March 2009

to Present.

AND BUSINESS

EXPERIENCE [Client: CovalentWorks - Houston, TX]

Participated in the design, development and maintenance of an ongoing

project to construct B2B interfaces (primarily PO's,

Invoices and Acknowledgements) for the oil and gas industry.

The B2B interfaces were created using BizTalk Server 2002

and involved the integration of EDI, XML and XML Web

Services and flat files.

Responsibilities included:

Designing, coding, testing, implementing and maintaining B2B interfaces

using Visual Basic, COM+, Visual InterDev, ASP, VBScript, ADO, MSMQ, XML,

EDI, SQL Server 2000 and Visual Source Safe

Developing and managing a work plan for assigned tasks

Identifying, tracking and resolving data design, management and operational

issues

Managing data design and project tasks in conjunction with client

expectations

Providing status on accomplishments, plans and issues

[Client: City of Houston (COH) - Houston, TX]

Participated in the analysis and design of an EAI project to enhance

the existing HEC Emergency Alerting System which bridges

alerting data between HFDCAD, HFD Stations and their

corresponding units/MDT's. The design included a web-based

dashboard for operations to utilize during data error

reconciliation. The design incorporated BizTalk Server 2009,

SharePoint 2007 Server, MSCE 2007 Server, SQL Server 2005

and involved the integration of XML, XSLT, heterogeneous

Databases (Oracle 8i and SQL Server 2000) and Operating

Systems (UNIX and Windows 2003). The web-based dashboard

design involved using SharePoint 2007 Server, ASP.NET 2.0

and XML Web Services.

Responsibilities included:

Analysis and designing of the EAI platform enhancement

Creating the corresponding documentation for analysis and design

Opulent GC, Incorporated: Senior Consultant, October 2001 to March

2009.

[Client: Sogeti - Houston, TX]

Participated in the design, development and testing of an EAI project

to construct a configurable order approval process for a

Store Front application. The configurable approval process

consisted of a web-based front-end to allow Store Front

administrators the ability to customize the approval process

(i.e., parallel, single agent, single range, custodial and

alternate approval methods) utilized for order fulfillment.

The architecture also consisted of a reusable exception

handling framework (E-Business Instrumentation Framework) to

capture, handle and notify of any exceptions encountered

throughout the various application layers. The EAI platform

was created using BizTalk Server 2006 and involved the

integration of XML, Web Services, SQL Server 2005 utilizing

a Windows 2003 Server platform. The web-based front-end was

developed using ASP.NET 2.0 and XML Web Services.

Responsibilities included:

Designing, coding and testing of the EAI platform using BizTalk Server

2006, Orchestration, Business Rules Engine, C#, Web Services, Visual Studio

.NET 2005 Team System, ADO.NET, MSMQ, XML and SQL Server 2005

Designing, coding, testing and implementing EBI-F (E-Business

Instrumentation Framework) for exception handling using C#, ADO.NET, Web

Services, ADO.NET, XML, SQL Server 2005 and MSMQ

Managing a work plan for assigned tasks

Identifying, tracking and resolving EAI design and management issues

Managing EAI design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

Participated in an EAI project to construct an Invoice Management

application with a windows-based front-end.

Responsibilities included:

Designing, coding and testing of orchestration interfaces using BizTalk

Server 2006, Orchestration, C#, Web Services, Visual Studio .NET 2005 Team

System, ADO.NET, XML and SQL Server 2005

[Client: City of Houston (COH) - Houston, TX]

Participated in the design, development, testing and implementation

of an enhancement to the existing HEC EAI platform which

allowed the processing of disregards. The enhancement

included the development of a web-based dashboard for

operations to utilize during data error reconciliation. The

enhancement was incorporated into BizTalk Server 2004 and

involved the integration of XML, XSLT, heterogeneous

Databases (Oracle 8i and SQL Server 2000) and Operating

Systems (UNIX and Windows 2003). The web-based dashboard was

developed using ASP.NET 1.1 and XML Web Services.

Responsibilities included:

Designing, coding, testing and deployment of the EAI platform enhancement

using BizTalk Server 2004, Orchestration, Business Rules Engine, C#, Web

Services, Visual Studio .NET 2003, ADO.NET, MSMQ, XML, XSLT, SQL Server

2000 and Visual Source Safe

Creating web-based dashboard for utilization during data error

reconciliation of the EAI platform using C#, ADO.NET, Web Services,

ADO.NET, XML, SQL Server 2000 and Visual Source Safe

Developing and managing a work plan for assigned tasks

Identifying, tracking and resolving EAI design enhancement and management

issues

Managing EAI enhancement design and project tasks in conjunction with

client expectations

Providing weekly status on accomplishments, plans and issues

[Client: City of Houston (COH) - Houston, TX]

Participated in the design, development, testing, training and

implementation of an EAI project to construct an EAI

platform for enabling and managing the process of

integrating data between applications in the Houston

Emergency Center (HEC). The EAI platform allowed the

migration of patient care data from the COH's billing system

to the COH's Records Management System for utilization by

the HEC and Fire Department's Emergency Medical Services

staff. The EAI platform was created using BizTalk Server

2004 and involved the integration of XML, XSLT,

heterogeneous Databases (Oracle 8i and SQL Server 2000) and

Operating Systems (UNIX and Windows 2003).

Responsibilities included:

Designing, coding, testing, training and deployment of the EAI platform

using BizTalk Server 2004, Orchestration, Business Rules Engine, C#, Web

Services, Visual Studio .NET 2003, ADO.NET, MSMQ, XML, XSLT, SQL Server

2000 and Visual Source Safe

Creating EAI tools for monitoring EAI platform using MOM2000, C#, ADO.NET,

Web Services, ADO.NET, XML, SQL Server 2000 and Visual Source Safe

Developing and managing a work plan for assigned tasks

Identifying, tracking and resolving EAI design and management issues

Managing EAI design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

[Client: Lamons Gasket - Houston, TX]

Participated in the design and development of an enhancement project

for the industrial manufacturing industry to construct an

online Drawings Catalog accessible to the client's customers

based on a B-B/B-C eCommerce platform. The Drawings Catalog

was created using Microsoft Commerce Server 2000, along with

using BizTalk Server 2000 for the integration of XML

documents originating from the client's SYTELINE back-office

system.

Responsibilities included:

Designing, coding, testing and implementing application functionality using

COM+, Visual Basic, VBScript, JavaScript, ASP, Visual InterDev, ADO, SQL

Server 2000 and Visual Source Safe

Creating a new Commerce Server Profile for persisting and manipulating

Drawings

Developing and managing a work plan for assigned tasks

Identifying, tracking and resolving data design and management issues

Managing data design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

[Client: Equiva Services - Houston, TX]

Participated in the design, development and maintenance of projects

to construct EAI interfaces (primarily Credit Terms, Service

Requests, Invoices and Acknowledgements) for the oil and gas

industry. The EAI interfaces were created using BizTalk

Server 2000 & 2002 and involved the integration of EDI, XML,

SAP and flat files.

Responsibilities included:

Designing, coding, testing, implementing and maintaining EAI interfaces

using BizTalk Server 2000 & 2002, XLANG, Actional Adapter for SAP, Visual

Basic, COM+, Visual InterDev, ASP, VBScript, ADO, MSMQ, XML, EDI, SQL

Server 2000 and Visual Source Safe

Creating EAI tools for monitoring BizTalk interfaces and Suspended Queue

using C#, ADO.NET, Web Services, Visual Basic, COM+, WMI, ADO, XML, SQL

Server 2000 and Visual Source Safe

Developing and managing a work plan for assigned tasks

Identifying, tracking and resolving EAI design and management issues

Managing EAI design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

[Client: Gospel Expo - Houston, TX]

Participated in the design and development of an Application Service

Provider (ASP) project to construct a B-B/B-C Internet

application for the Christian community. The ASP was

created using Microsoft DNA as the application framework.

Responsibilities included:

Designing, coding, testing and implementing application functionality using

Visual Basic, COM, Visual InterDev, ASP, JavaScript, VBScript, ADO, XML,

SQL Server 2000 and Visual Source Safe

Creating a windows-based registration application for use at trade shows

using C#, ADO.NET, XML and SQL Server 2000

Creating stored procedures to maximize the performance of SQL statements

Developing Business Use Cases/Scenarios

Developing and managing a work plan for assigned tasks

Researching, evaluating and choosing Vendor package for e-commerce engine

Identifying, tracking and resolving data design and management issues

Managing data design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

[Client: CovalentWorks - Houston, TX]

Participated in the design and development of a project to construct

B2B interfaces (primarily PO's, Invoices and

Acknowledgements) for the oil and gas industry. The B2B

interfaces were created using BizTalk Server 2000 and

involved the integration of EDI, cXML and flat files.

Responsibilities included:

Designing, coding, testing and implementing B2B interfaces using Visual

Basic, COM+, Visual InterDev, ASP, VBScript, ADO, MSMQ, XML, EDI, SQL

Server 2000 and Visual Source Safe

Enhancing client's RoundTrip and PunchOut capabilities within their E-

Commerce application using MS Site Server, Visual Basic, MTS, COM, Visual

InterDev, ASP, VBScript, ADO, XML, Oracle 8i and Visual Source Safe

Developing and managing a work plan for assigned tasks

Identifying, tracking and resolving data design and management issues

Managing data design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

Pantellos: Applications Engineer, March 2001 to October 2001.

Participated in the daily operations of the Pantellos digital

marketplace (TradeSite). The marketplace caters to the

utilities and energy industry. In addition, TradeSite is a

member of the Global Trading Web sponsored by Commerce One.

Responsibilities included:

Troubleshooting marketplace issues and providing resolutions using XML

(xCBL), SQL Server 7.0, ADO, Visual InterDev, Visual Basic, LDAP, ASP,

MSMQ, MarketSite 3.2 & 4.1, BuySite 6.5, SupplyOrder 3.0 & 3.1

Becoming resident expert of document choreography through the marketplace

Developing tools (applications) to enhance capabilities of the Marketplace

Operations team using Visual Basic, Visual Source Safe, XML, XPATH, ASP,

ADO, COM+, SQL Server 7.0, UML

Configuring the marketplace to enable integrated suppliers and

interoperability with existing marketplaces

Assisted in the enhancement upgrades to the marketplace using MarketSite

4.1, SonicMQ (MOM), WebMethods (Middleware/EAI Tool), SQL Server 2000, XML,

DTS

Designed and prototyped an extended monitoring system to capture the flow

of transactions to/from members and the marketplace using UML, Visual

InterDev 6.0, ASP, JavaScript, VBScript

Prototyped the re-design of the marketplace using MS Commerce Server 2000

and BizTalk Server 2000

BSI: Senior Consultant, July 2000 to March 2001.

Participated in the design and development of an ASP project to

construct a generic B-B/B-C Internet application for the

industrial manufacturing industry. The ASP was created

using Microsoft DNA as the application framework. The site

was BSI's first ASP client based on Commerce Server 2000 and

BizTalk 2000.

Responsibilities included:

Team Lead for designing and developing the application interfaces and B-B

functionality

Customizing and enhancing product solution to provide a more robust

platform base for creating the e-commerce web site using Visual Basic, COM,

Visual InterDev, ASP, JavaScript, VBScript, ADO, SQL Server 2000 and Visual

Source Safe

Configuring BizTalk Server to receive and translate client files, from a

variety of formats, into an XML format to be used within the site

Creating XML schemas and developing code to parse the XML documents

Creating transactional MSMQ Queues to provide asynchronous batch processing

of interfaces

Creating several custom COM+ components (utilizing Visual Basic, COM/DCOM,

MTS, ADO and SQL Server 2000) to provide enhanced functionality to the web

site and BizTalk Server (e.g., Inventory Management and Contract Pricing

components)

Creating stored procedures and triggers to integrate the cross-referencing

of client IDs to Commerce Server generated IDs

Developing Business Use Cases/Scenarios

Developing Object Model for Internet application architecture and

development using UML notation

Developing and managing a work plan for assigned tasks

Researching, evaluating and recommending Vendor package for shipping

components

Identifying, tracking and resolving data design and management issues

Managing data design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

The ASP application architecture involved the integration of

Microsoft tools and technologies, including Commerce Server

2000, IIS, BizTalk Server 2000, SQL Server 2000, Visual

Basic 6.0, Windows 2000, MSMQ and XML. Experience also

included Windows 2000 Advanced Server, OLAP, Visual Studio

6.0, Visual InterDev 6.0, Visual Source Safe 6.0, Microsoft

Access 2000 and Microsoft Excel.

Opulent GC, Incorporated: Consultant, April 1999 to July 2000.

[Client: Halliburton - Houston, TX]

Participated in the implementation of a SAP packaged software project

to create an integrated Human Resources system. The system

was constructed with SAP 3.0F packaged software.

Responsibilities included:

Managing the conversions within the SAP Training and Events Modules

Identifying, tracking and resolving data design and management issues

Managing project tasks in conjunction with client expectations

Providing weekly status on accomplishments, plans and issues

Developing conversion execution training manual for new employees

Served as a member of the Conversion Execution Team, while performing

the conversions within the SAP PD (Personnel Development)

and PA (Personnel Administration) Modules. Experience

included SAP 3.0F (HR, Payroll, Benefits, Training and

Events Modules), ABAP/4, Oracle and Microsoft Excel.

Participated in an internal office project to research the

integration of C++ and PowerBuilder applications.

Responsibilities included:

Project lead for researching integration of technologies

Developed a front-end PowerBuilder GUI application which called

functions developed from a C++ DLL. Experience included PowerBuilder

5.0, Sybase, SQL and Visual C++ 4.0.

Participated in an internal office project to analyze, design and

develop a Church Management application.

Responsibilities included:

Project lead for all stages of the application's life cycle

Analyzed, designed and developed a prototype using PowerBuilder 5.0,

Sybase, and SQL.

Baker Hughes Inc.: Business Analyst, July 1998 to April 1999.

Participated in the analysis, design, construction, testing and

implementation phases of a worldwide SAP business re-

engineering project. The system was constructed with SAP

4.0B packaged software.

Responsibilities included:

Data Design and Management Lead for HR interfaces and conversions

consisting of 20+ team members

Analyzing business requirements to define functional/technical

specifications for interfaces, conversions and custom solutions

Identifying, tracking and resolving data design and management issues

Developing and managing a work plan for assigned tasks

Managing data design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

Experience included SAP 4.0B (HR, Payroll and Benefits

Modules), ABAP/4, Oracle, SQL, SAP's CATT and Microsoft

Project.

Price Waterhouse LLP: Consultant, June 1995 to July 1998.

[Client: Compaq - Houston, TX]

Participated in the analysis, design and construction stages of a SAP

packaged software development project to develop an

integrated manufacturing system. The system was constructed

with SAP 3.0F packaged software.

Responsibilities included:

Technical Team Lead for interfaces, conversions and custom solutions

Analyzing business requirements to define functional/technical

specifications for interfaces, conversions and custom solutions

Identifying, tracking and resolving data design and management issues

Managing a work plan for assigned tasks

Managing data design and project tasks in conjunction with client

expectations

Providing weekly status on accomplishments, plans and issues

In addition, duties included construction, unit testing and string

testing of a WM Custom Non-Conforming Utility. Experience

included SAP 3.0F (WM and PP&E modules), ABAP/4, Oracle and

SQL.

[Client: Compaq - Houston, TX]

Participated in the design, construction and implementation stages of

a custom software development project to develop a worldwide

asset (finished goods, factory capacity, and raw materials)

deployment system. The system combined SAP 3.0D packaged

software with custom software developed in Microsoft Visual

C++ 4.0 and 5.0.

Responsibilities included:

Joint Team Lead for analyzing, designing, constructing and implementing the

error handling for the core C++ application architecture

Analyzing business requirements to define functional/technical

specifications for application enhancements

Analyzing, designing, constructing, unit testing and implementing the core

C++ application architecture

Developing application training manual for new employees and overseeing the

facilitation of the material

Experience included Microsoft Visual C++ 4.0 and 5.0, Visual Source

Safe 5.0, Windows NT 4.0, executing applications via remote

command from Windows NT Workstation/Server, Ashwin 3.1,

Microsoft Access 7.0 and SAP 3.0D.

[Client: Texas Instruments - Plano, TX]

Participated in the analysis, design and construction stages of a

custom software development project to develop a client-

server based payroll system. The payroll system utilized

the PeopleSoft HR module.

Responsibilities included:

Analyzing functional specifications to define technical specifications for

interfaces

Analyzing, designing, constructing and unit testing the payroll system's

interfaces

Experience included UNIX scripts, RUSH Gateway, Oracle, SQR, SQL,

COBOL, JCL, PeopleSoft HR module and FTP.

REFERENCES Available upon request



Contact this candidate