Project Design Sql Server Management .Net Business
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