Solutions Architect Resume Profile
PROFESSIONAL PROFILE
BUSINESS/PROJECT MANAGEMENT PROFILE
| TECHNICAL PROFILE
|
Industries
Commercial Construction Roadside Assistance Retail Tile and Supply Police Music Distributor Education Healthcare Railroad Car Leasing Pharmaceutical Non-profits/charities Fast Food Employee Benefits Travel Insurance Metropolitan Newspaper Computer Software Fantasy Football IT consulting
SYSTEMS IMPLEMENTED
Mobile Apps Construction Support , Portals Downloadable Music Reporting, University Content Management, Healthcare Management, Food Content Management Road Side Assistance Dispatch, call center, claims, service provider, billing Validated Drug Packaging Clinical Government Web Site Informational Web sites Entertainment Websites Rail Car Management Fund Raising Accounting OLTP applications Contracts Pricing Customer Business Review Employee Benefits Invoicing Educational Training Time Tracking Employee Support Library Direct Marketing Insurance Applications Enterprise Meta Data Management e-commerce Fantasy Football Site
TECHNOLOGIES
- Databases/Data Providers: Oracle 11g-7X Including Spatial, Locator , JDBC, Oracle ODP.NET, MS Access,
- ODBC, DB2
- Middleware: Oracle Application Server 10g/11g thru WebLogic Server , LDAP - Oracle Internet Directory OID , Oracle Portal thru 10.1.4 , Zend App Server, IIS, Nginx
- Languages/Frameworks: SQL, PLSQL, SQL, JavaScript Greybox, jcarousel , HTML, XML, CSS Blueprint, Bootstrap , JSP, Oracle ADF entire stack , PHP, Symfony 2, Web Services, Analytic Functions, Oracle MapViewer, Java, Less recent J2EE, ASP classic , VBScript, COBOL, CICS, TELON, MVS/JCL, PASCAL , Node.js, Express, Sencha Touch
- Development Tools: JDeveloper, Oracle Forms thru 11g , Reports thru 11g , Application Express APEX , Discoverer, Designer, SQL PLUS, SQL Developer, SQL Loader, Datapump, TOAD, SQL Navigator, SQL Impact, Cognos ReportNet, Cognos Framework Manager, Visual Source Safe - VSS, MS Project, MS office, Erwin, Visio, Graphics Tools, Sencha Architect, Ripple
- Platforms: Various flavors of Linux, Unix, and Windows, node.js, Amazon EC2, Amazon EBS
- Web Apps/Hosting Google Apps/Mail/Maps, Vyew, WebEx
PROFESSIONAL CONSULTING EXPERIENCE
Confidential
Solutions Architect
Solutions architect for implementing mobile apps for client.
o Created mobile web app that displayed project lists, details, and maps.
Technical Summary Sencha Architect, Sencha touch, node.js, express node.js , Oracle 11g, Amazon web services, Linux, Oracle VM Virtual Box, Google maps, Nginx, Ripple, JavaScript, HTML, CSS.
Confidential
Technical Project Manager/Solutions Architect/Lead Developer
- Large custom application millions of members for motor club processes billing/finance, call center, customer service, claims, dispatch, service providers, invoicing/letters, reporting, retail and wholesale .
- o Created project plans, managed multiple deliverables, priorities, projects, and developers off/on shore staff of 12 . Architect for technical solutions using Oracle technology stack to improve business processes and reduce costs. Liaison between business and IT for translating business requirements to technical implementations. Major projects included: Billing engine currency, taxes , Real time payment authorization, dispatch geo-location. Re-architecting/managning software infrastructure. Company merger involved in all aspects of merging functionality/data between systems including strategic planning and architecture for application migrations. Implemented PCI compliance initiative into existing application. Implemented testing automation.
- Technical Summary Oracle App Server weblogic 11g, PL/SQL, Analytic Functions, Oracle Locator, Oracle Spatial, Oracle MapViewer, JavaScript, Web services, JDeveloper, Forms 11g, Reports 11g, Oracle ADF, Oracle Designer, Unix, Microsoft Project, WebMeeting, Visio, XML, Java, JavaScript, TOAD, SQL Developer, ETL.
Confidential
Consultant/Web Development
Provide IT strategy/direction and technical recommendations to company based on business initiatives. Managed and implemented companies web site.
Technical Summary HTML, JavaScript greybox, jcarousel , CSS Blueprint , PHP, Google Apps, Google Maps, Web Hosting, Vyew.
Confidential
Lead Developer/Architect
- Custom central purchasing and accounts payable application:
- o Defined strategy, created project plan, and migrated existing Oracle application from client server to the Oracle Application Server/web. Implemented reporting infrastructure. Designed new legacy-to-Oracle ETL load process using external tables and SQL merge operations to improve error reporting and handling, metrics analysis, and eliminate data integrity issues.
- Technical Summary Forms 10g, Reports 10g, SQL Loader, Oracle Application Server 10g, PL/SQL, SQL Developer, External Tables, SQL Analytics, Oracle Portal 10.1.4, Unix, Windows 2003 Server.
Confidential
Lead Developer
- Integrated portal with Oracle Apex to allow data entry using APEX HTML DB . Implemented streaming video within portal. Implemented address mapping and searching within portal.
- Technical Summary Oracle Portal 10.1.4, Oracle Application Server 10g, PL/SQL, HTML, JavaScript, SQL Developer, Portal API's, Portlets, Oracle APEX 2.2, Google Maps API.
Confidential
Lead Developer/Project Manager
- Provided project plans, managed project deliverables, coordinated personnel, gathered requirements, designed, and implemented a secure portal web site that allowed external clients to access/search/download secure files. Site also provided internal users with analytics for site use. Design included creation of API load process to populate site and load metadata for files.
- Technical Summary Oracle Portal 10.1.4, OID Portal/OID security, portal API's PDK , DB Provider components, reports, charts , Oracle Application Server 10g, PL/SQL, Discoverer, UNIX, JSP, Windows XP, HTML, JavaScript, SQL Developer, Visio, DB Providers, Portal API's, Portlets, Portal Security, Single Sign On, Transport sets, Templates, Nav pages, Styles, CSS, SQL analytics.
Confidential
Project Manager/Lead Developer
- Provided project plans, managed project deliverables, coordinated and managed personnel, gathered requirements, designed, and implemented a portal web site that allowed students to search university content.
- Technical Summary Oracle Portal 10.1.2, OID, Oracle Application Server 10g, PL/SQL, UNIX, Windows XP, HTML, JavaScript, SQL Developer, Visio, PLSQL, DB Providers, Portal API's, Portlets, Portal Security, Single Sign On, Transport sets, Templates, Nav pages, Styles, CSS.
Confidential
Lead Developer/Project Manager
- Provided guidelines, technical recommendations, and implemented initial user interface for a portal site that allowed entering and accessing healthcare information.
- Technical Summary Oracle Portal 10.1.2 portal/OID security, portal API's PDK , 10.1.4 features, various DB Provider components , Oracle Application Server 10g, PL/SQL, UNIX, Windows XP, HTML, JavaScript, SQL Developer, Visio, PLSQL, DB Providers, Portal API's, Portlets, Portal security, Transport sets, Templates, Nav pages, Styles, CSS.
Confidential
Architect/Lead Developer
- Provided strategic information, planning, and direction for migrating existing client server forms and reports application to the web platform, including: interacting with Oracle Financials, determining Oracle portal's functions, and converting forms and reports. Enhanced internal change control process, enhanced invoice processing application.
- Technical Summary - Oracle Application Server Release 2 , Oracle Forms and Reports 10g, Oracle Portal, PL/SQL stored procedures, packages, database triggers , UNIX, Windows XP, HTML, TOAD, SQL PLUS, Visio.
Confidential
Architect/Project Manager
- Intranet application for managing packaging dates for drugs - a validated system for product safety in the clinical systems area.
- o Planned, coordinated, designed, developed, tested, and implemented reporting, ad hoc query, and auditing
- o Decided technical direction, created project plans, created specifications, created data model. Implemented framework for error handling, messaging, logging, data access, security, user interface, screen flow.
- o Improved change control processes by working with compliance managers.
- o Created metadata model and packages using Cognos framework manager. Created clinical reports.
- o Created Oracle Forms and Reports to enhance Oracle Clinical. Automated Oracle Clinical menu creation.
- Technical Summary - Oracle 9.X-10g, PL/SQL, Windows 2003, HTML, TOAD, SQL PLUS, JavaScript, VBScript, ASP, Visual Studio Interdev, IIS, Visual Source Safe, Oracle forms/reports, NUnit, Zanebug, NDoc, XML, Oracle Clinical, Cognos ReportNet, Cognos Framework Manager, ODP.NET, Oracle .NET development tools, Test Driven Development, Oracle Application Server 10g 9.04 , Oracle Portal.
Confidential
Architect/Lead Developer
- Created food content management portal that was to be used by 25,000 scientists worldwide. Determined scope of work, project plan, and implementation schedule. Implemented taxonomy. Portal technical highlights: Defining/developing portal security, templates, navigation pages, custom searches, style, UltraSearch, OID, custom portlets using PDK, various DB Provider components forms, reports, dynamic pages, calendar, URL, etc.
- Technical Summary - Oracle 9.X, Oracle9i Application Server IAS Release 2 - 9.04 , Portal, PL/SQL stored procedures, packages, database triggers , Windows NT, Linux, HTML, MS FrontPage, SnagIt, TOAD, SQL PLUS, JavaScript.
Confidential
Architect/Lead Developer
- Re-engineered car tracking business processes, resulting in a half million dollar savings. Architect for development and web infrastructure, including areas such as error handling, messaging, logging, object libraries, PLSQL libraries, templates, dynamic SQL, PLSQL collections, security and reporting. Emphasis placed on business and technical analysis skills due to users' unfamiliarity with developing applications. Project/resource planning.
- Technical Summary - Oracle 8.X, 9.X, Oracle9i Application Server IAS , Oracle Forms/Reports, Designer 6i, Oracle Portal, PL/SQL stored procedures, packages, database triggers , UNIX on Solaris, Windows NT/2000, HTML, MS FrontPage 2000, SnagIt, TOAD, SQL PLUS, SQL Navigator, Visio, SQL Loader.
Confidential
Architect/Project Manager
- Created project plans, architected, designed, developed, and implemented a custom intranet application that handled all aspects of raising funds for the organization.
- o Worked with client to identify requirements, scope, technical architecture, and resources.
- o Decided technical direction, created specifications, designed/modeled database, coded, tested, managed developers.
- o Created complete framework for implementing oracle forms and reports over the web using Oracle9iAS, including tech areas such as error handling, messaging, logging, object libraries, PLSQL libraries, templates, dynamic SQL, PLSQL tables, property classes/visual attributes, security and reporting. Framework provided a consistent interface that was easy to code and maintain. Large system with hundreds of tables, over a hundred forms, and a hundred reports. Evaluated Oracle Portal for client.
- Technical Summary - Oracle 8.X, Oracle9i Application Server IAS , Internet Development Suite Forms and Reports Developer , Developer 6i, Designer 6i, Portal, PLSQL stored procedures, packages, database triggers , HP-UNIX, Microsoft Project 2000, Office, Windows NT/2000, HTML, MS FrontPage 2000, PVCS, Visio, SnagIt, TOAD, SQL PLUS.
Confidential
Project Manager
- Created project plan for implementation of client's education training web site. Worked with client to identify requirements, scope, costs, resources, technologies, and timeline for implementing initial site. Acted as a liaison between the technical resources and client.
- Technical Summary - Microsoft Project, Word, Excel.
Confidential
Oracle Designer Admin/Lead Developer/ Confidential
- Designed and developed a centralized metadata intranet portal application for all company's databases DB2, Oracle, Access, etc. . Designed/developed web portal used by business analysts for querying enterprise repository.
- Technical Summary - Oracle 8, SQL, PL/SQL, Oracle Developer 2000 Forms, Reports , Oracle Designer 2000, DB2, Oracle WebDB, Enterprise Manager, UNIX, SQL PLUS, Erwin, HTML, Active Server Pages ASP , IIS, MS FrontPage, SQL PLUS.
Confidential
Project Manager
- Contracts and pricing department. Managed business and technical personnel. Managed and coordinated enhancements across multiple business areas and systems including mainframe and client/server. Created and successfully implemented deadline driven-project plans. Business analysis skills were also critical to decipher user process flows to create more stream-lined business processes using technology.
- o Customer business review application that helped bring in 12 million dollars in 4 days.
- o Led project to create average selling price analysis application for company product comparison using Oracle tools and Cognos tools. Application interfaced with data warehouse.
- Technical Summary - MS Project, Oracle 7 on Dec Vax, Oracle Forms/Reports, Windows 95/NT, Word, Excel, Access, Cognos PowerPlay, Impromptu, SQL PLUS.
Confidential
Project Manager/Lead Developer
- Created project plans, managed technical personnel, architect for development environment/applications, designed databases, coded/tested, led requirements gathering, gave demos and trained users.
- o Time Tracking Application.
- o Enterprise custom ad-hoc Oracle reporting architecture
- o Employee Support Library application allowed 1100 employees to store, query, and retrieve documents from a corporate on-line library. Notebook users could work connected or disconnected.
- o Invoice Management System - redesigned from a mainframe application to a client/server application.
- o Employee Benefits Application. Implemented complex financial reports.
- Technology Summary - Oracle 7, Oracle Forms/Reports, SQL, PLSQL, Oracle Textserver, SQL Loader, SQL PLUS, Windows 95/ 3.1, Microsoft project, Wise, HP-UNIX, HP OPENMAIL, UNIX on Solaris, SQL Loader.
Confidential
Software Company
Programmer/Analyst
- A direct marketing system, major accounting system GL , accounts payable invoice tracking system, insurance application entry program.
- Technical Summary - Oracle, SQL, PL/SQL COBOL, DB2, CICS, APS, QMF, SPUFI, TELON, COBOL, Oracle Forms/Reports.
.
