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.