Experience SOA Architect

CONFIDENTIAL

Environment: Oracle SOA Suite 11i, Canonical Data Modeling, BPEL 2.0, OSB 11g.

SOA Architect

• Led a team of SOA developers to convert all PL/SQL based inbound/outbound Maximo 2.5
• integration points to XML based Web Services utilizing Oracle SOA Suite 11g.
• Reverse engineered each Oracle Application 11i / Maximo 2.5 integration to extract existing
• business rules, data mapping and data flow functional specifications and constructed the overall
• service model for the Oracle Application R12 / Maximo 2.5 SOA integration system.
• Designed and developed the purchase requisition, item and journal entries data load integration
• processes utilizing BPEL 2.0, OSB 11g and Oracle XML Gateway 11g.

Environment: Oracle Applications 11i / R12, Maximo 2.5, Oracle Database Triggers,

• Oracle Stored Procedures, Oracle Open Interfaces, Oracle SOA Suite 11i,
• Canonical Data Modeling, Oracle XML Gateway 11g, BPEL 2.0, OSB 11g.

CONFIDENTIAL

• Developed a sftp proxy service to transfer payroll files from public key SSH authentication
• based servers to other servers for further processing and rewrote several BPEL processes to
• resolve major performance issue's caused by huge data processing needs during the payroll cycle.

Environment: Oracle OSB 11g Console, Weblogic 10g Admin Console, BPEL 2.0.

CONFIDENTIAL

• Analyzed the existing student financial aid processing system and proposed solutions for difficult to process financial aid student schedule scenario's.
• As part of a scrum team, wrote special algorithms and modified the existing system's to increase
• the financial aid automation processing rate from 20 to 80 following the agile methodology.

Environment: Oracle SOA Suite 10g, PeopleSoft CI, Oracle Stored Procedures, Oracle Packages.

CONFIDENTIAL

• Developed a web service based integration to connect Maximo / Oracle project modules utilizing
• the Oracle Integration Repository and Oracle Application Adapter.

Environment: Oracle SOA Suite 11i, BPEL 2.0, Oracle Applications R12, Maximo 6.0.

CONFIDENTIAL

• Upgraded fifteen BPEL processes from 10g to 11g and applied needed configurations to
• the Weblogic10g server.

Environment: Oracle SOA Suite 10g, Oracle SOA Suite 11g, Weblogic 10g Admin Console.

SOA Consultant

CONFIDENTIAL

• Architected the Data Hub data access service layer utilizing Oracle MD70 technical design documents.
• Participated in designing the data hub data model based on UBL 2.0 standard.
• Defined the strategy to convert existing Oracle SOA Suite 10g based web services to
• Oracle SOA Suite 11g composite applications.
• Built several composite applications to send orders via Email, Fax and Ftp to major global
• business partners.
• Constructed configuration plans to deploy web services and composite application to
• Development, Test, QA and Production.

Environment: Oracle SOA Suite 11g, Oracle eBusiness 11i, Oracle Fusion Middleware,

• Oracle 11g, Oracle MD70/50, JDeveloper 11g, Java, UML 2.0, UBL 2.0,
• SOAP, BPEL, XML, XSD, XSLT, XPATH, JNDI, AIA.

Service Oriented Architecture Consultant

CONFIDENTIAL

• As part of the GDLS enterprise architecture team, participated in defining the SOA roadmap that encompasses maturity assessment, scope and SOA future vision.
• Participated in defining the SOA Governance Model that ensures the development of services that are reusable and add value to the business.
• Architected the Service Model to interface the Travel Master, Info Span and Concur Expense
• Reporting System with Oracle eBusiness 11i Modules.
• Built the As Is business process model for the Work Order Approval Process adhering to the
• BPMN 2.0 specifications and developed the To Be Business Process utilizing BPEL 2.0.
• Designed and developed loosely coupled, self-contained and re-usable web services to load GL
• and project journal entries into Oracle General Ledger and Oracle Project Modules This work
• included the design of the Canonical Data Model for Journal Entries as part of the GE SOA
• pilot project.
• Environment: Sun Solaris, Oracle eBusiness 11i, Oracle 11g, Oracle Fusion Middleware,
• Oracle SOA Suite 10g, Oracle UDDI, Oracle WSM, JDeveloper 10g, Java,
• BPMN 2.0, UML 2.0, Canonical Data Modeling, SOAP, BPEL, ESB, XML,
• XSD, XSLT, XPATH, JNDI.

Enterprise Architect

CONFIDENTIAL

General Architecture

• As a member of Handleman's architecture steering committee, participated in selecting emerging technologies, defining technology roadmaps and defining enterprise wide architecture strategies based on Zachman Framework for Enterprise Architecture.

Worked closely with senior management to ensure that enterprise vision is adequately represented on projects, proposed cost saving EA projects and provided technical advice and project level estimates to management.

Jointly worked with the VP of Architecture to build an enterprise wide Time model for the

enterprise Scheduler.

Data Architecture

Led JAD sessions to analyze functional and non-functional RFID data requirements to design

• state-of-the-art, well-integrated, and cost-effective Relational and Dimensional models.
• Designed the logical and physical relational data model for a large scale RFID Operational Data Store to hold retailer on-hand inventory, item and sales staging data.
• Designed the logical and physical star schema for a large scale RFID Data Warehouse to hold fact
• and dimension data needed to satisfy Handleman's BI and reporting needs.

Application Architecture

• Led a team of architects, DBA's and developers to install, configure and develop service oriented architecture web services for the RFID enabled supply chain management system utilizing Oracle ESB/BPEL.
• Analyzed and built Data Flow Diagrams and Source/Target Data Mapping documents
• to satisfy the RFID ODS and Data Warehouse overall data integration needs.

Infrastructure Architecture

• Jointly worked with the senior infrastructure architect to build the As-Is and To-Be technology models for Handelman's Unix, Windows and Storage environments and developed an action plan to realize the conversion to the To-Be technology model As part of the server consolidation project this work reduced the annual running cost of HDL environment by 2 million dollars.
• Performed capacity management activities as it relates to analyzing the production As-Is storage LUN's layout and forecasting Handlemans 3 years To-Be production storage needs.
• Managed effective relationship with Hardware vendors and submitted RFP documents for HDL
• future server and storage needs.

Environment: IBM P5 series AIX 5.3, Oracle ERP 11i, Oracle SOA Suite10g, JDeveloper 10g,

• Zachman Framework , UML 2.0, Yourdon DFD, James Martin E-R modeling,
• Visio 6.0, BPEL , ESB, XML, XSD, XSLT,AIA.
• Senior Data Warehouse Consultant
• CONFIDENTIAL
• Senior Data Warehouse Consultant
• Senior Oracle ETL Consultant
• CONFIDENTIAL
• Data Warehouse ETL Lead
• CONFIDENTIAL
• Data Warehouse Developer/Analyst
• CONFIDENTIAL
• Research Assistant
• CONFIDENTIAL
• Sales Representative
• CONFIDENTIAL
• Database Designer Programmer

CONFIDENTIAL

• Professional Oracle SOA Suite 10g: Service Orchestration
• Training Oracle Education Center Troy, Michigan Oracle BPEL Process Manager: Service Orchestration Fusion Middleware Oracle Education Center Reston, Virginia Oracle Financials Functional Foundation: Release 11 Oracle Education Center San Francisco, California
• Datastage Essentials for Enterprise Edition : An ETL Tool
• at Ascential of IBM Chicago, IL

Technical

• Summary Packages : Oracle Applications 11i/R12, Oracle SOA Suite 10g/11g, JDeveloper 10g/11g,
• Eclipse 3.7, Oracle XML Gateway11g, DataStage 7.x EE, Ab Initio 2.0,
• Business Objects Data Integrator ETL, EDI, Visual Basic 3.0/4.0, Visio 2007, Oracle Designer 2000, Oracle Warehouse Builder, Business Objects.
• Languages : BPEL 2.0, OSB 11g, XML, XSD, XSLT, SQL, PL/SQL 2.x/8.0, ODBC,
• Perl 5.0, Korn Shell, UNIX C, Syncsort, Java, Borland C 3.0, HTML 2.0,
• VRML 1.0, Cobol, Pascal, Fortran.
• Modeling : Canonical Data Modeling, Zachman framework 2.0, UML 2.0, UBL 2.0,
• Yourdon, DFD, James Martin E-R modeling.
• Databases : Oracle 11g/10g/9i/8i/7.x, IBM DB2 UDB 7.0/8.3, Teradata, MS Access 2007.
• Database Tools : Oracle Forms 3.0/6i, Oracle Reports 6i,
• SQL Loader 7.x/8.0, SQL Plus 3.x/8.0, Oracle Discoverer,
• Oracle Procedure Builder, Oracle Data Query, Oracle SQL Net,
• SQL-Station 3.3, SQL Navigator.

Environments : IBM P5 AIX 5.3 HP-UNIX 10.x/11.x, Windows NT/2000/XP, Vax-Vms 5.5-2.

CONFIDENTIAL