SUMMARY

• Enterprise and project level technologist and consultant with extensive architecture, analysis, design, development and customer service experience across multiple domains, platforms and industries.
• Known as a versatile team player with the ability to drive change and bring creative solutions to business challenges and new initiatives. Seeking a challenging telecommute opportunity.
• Innovation, automation, integration
• API and standards development
• Business analysis, solution design
• Troubleshooting / problem solving

AREAS OF EXPERTISE

• Requirement gathering & discovery
• Attention to detail, form & function
• XML & Web technologies & scripting
• Expert MS Office, Visio & VBA skills
• Data / workflow analysis & modeling
• Graphic design, layout and imaging
• SQL & client/server program languages
• Strong writing & presentation skills

TECHNICAL SKILLS

Operating Systems: AS/400 i5/OS, Windows Desktop, Win 2k - 2012 Server, Redhat Linux, AIX, Solaris, z/OS

DBMS/Server Software: Oracle 7.3-12c, Oracle 9iAS, MS SQL Server 7-2005, mySQL 3.x-4.1, Access 1.0-2010, Sybase SQL Server/System 10, DB2 UDB 9.1 (Viper) & DB2 iSeries v5, Oracle Interconnect 8i, webMethods B2B 3.5-8.2, Lotus Notes/Domino 4.6, 7.0, BEA Weblogic 4.1-6.1, Bluestone XML Server, Tomcat, Apache/IBM Webserver, IIS, DBS Smartstream HR, Universal Command, TIBCO Rendezvous/BW 5.9, Microsoft SharePoint Server 2007

Languages/Frameworks: SQL, PL/SQL, DDL, Java/J2EE, JSP, EJB, JDBC/ODBC, Struts, Tiles, Swing, Reflection API, SOAP, JMS, AJAX, HTML, HTML5, DHTML, XHTML, XML, cXML, XSLT, XPATH, XSD, DTDs, WSDL, OWL, Ant, GWT, C/C++, C#, CSS3, PHP5, ASP, VB, VBA, VBScript, VB/.NET, JavaScript, JQuery, JCL, .NET, LotusScript, ActionScript, Turbo Pascal, Turbo BASIC, Turbo Assembler, PowerBuilder, Python 3.5, Hadoop

Data/Development Tools: CA ERWin ER Data Modeler, Embarcadero ER/Studio, TOAD for Oracle, Oracle SQL Developer, Sybase PowerDesigner, Casewise Modeling Suite, Crystal Reports, BusinessObjects Reporting, Rational Data Architect, Rational Rose UML, XMLSpy, Altova Mission Kit, SQL Plus, Microsoft SharePoint Designer 2007, Eclipse, CVS, Subversion, Adobe Creative Suite, Dreamweaver, VisualAge, Visual Studio 2012, JDeveloper, JBuilder, Adobe Photoshop, Adobe Illustrator, JASC Paintshop Pro, Balsamic Mockup, GIMP, Apache Pig, Visio/MS Office 1.0-2013

Data Science/Analysis Tools: MapReduce, Spark, Anaconda, Funf, Bandicoot, Jupyter Notebook

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Information Architect

Responsibilities:

• Designed process & data model for Ebix Contact Manager to Salesforce migration for advisor/client CRM in PowerDesigner.
• Built graph queries & data model to extract & transform OrientDB authorization data into relational Salesforce platform.
• Lead NoSQL POC to prove out document database capabilities with XML & JSON data in MongoDB and Oracle XML DB 12c.

Confidential, Eden Prairie, MN

Solution Architect

Responsibilities:

• Collaborated with other domain architects within the product design team for the Cirrus project, designed to redefine the healthcare industry from claims processing to provider network and benefit plan flexibility, to member - for-life enrollment and tracking, and more. Responsible for both go-to-market tactical and ideal end-state strategic planning and design.
• Created high level designs for the Finance domain, including both functional design documents and Visio business and technical workflows for features including Claim Adjustments, Accounts Payable, Accounts Receivable, Transaction G/L Tagging & Statistical Correction Utility, Overpayment Recovery & Refund Utility and Check Void & Reissue.
• Built logical data models in Embarcadero ER/Studio and CA ERWin Data Modeler to support high level designs, as well as physical models for MySQL database. Administered ERWin Model Mart libraries, versioning & data model access. Served as the ERWin expert to all of Cirrus IT and developed training and presentations to evangelize and enforce standards.
• Designed & executed migration, modularization & training plan to move data models from ER Studio to enterprise ERWin platform. Devised & implemented a unique mechanism for representing multiple releases within a single model.
• Brainstormed functional business requirements and gathered others by conducting and participating in JAD sessions with business operations personnel, Payment Integrity team, end users, product owners and delivery teams.
• Provided oversight and direction to systems analysts and developers for successful delivery of database, engine and UI designs. Created features in Rally/CA Agile. Joined daily delivery team standups to align on agile roadmap & user stories.
• Led and supported CISL (Cirrus Integration Services Layer) and OFin (Oracle Finance payment processor) teams in defining paylog and payment feedback JSON interfaces and processing as well as downstream ledger reporting impact.

Confidential, Eden Prairie, MN

Data Analyst

Responsibilities:

• Performed data analysis, validation & manipulation in Oracle and Excel; SQL, PL/SQL, XML & VBA scripting, and Toad for Oracle automation for onboarding of corporate clients to monthly releases of eHP/Rally health management portal.

Confidential, Hopkins, MN

Senior IT Analyst

Responsibilities:

• Led software lifecycling, architectural consulting, process improvement & administration across TIBCO, webMethods & Java middleware technologies for A2A/SAP/JMS & B2B/EDI/AS2 integrations. Also provided L3 project and production support of these systems and backend data platforms to customers, developers and local/remote L2 rotation resources using Remedy.
• Planned and directed effort to take over project landscape middleware function from Tartan (SAP) team. Led over 25 middleware environment builds/major upgrades, all delivered on time. Served as Tartan/EAI Operations Liaison.
• Proactively took ownership of support & rewrite of orphaned but support-critical app used for end-to-end message tracking in SAP, TIBCO, webMethods & Boomi. Also redesigned its UI and security model and administered its 15 Oracle DBs.
• Designed, developed, administered Dev-Ops SharePoint site collection, creating numerous linked document libraries & metadata lists, custom forms, web parts, workflows & innovative navigation methods in SharePoint Designer & Javascript.

Confidential, Golden Valley, MN

Data & Integration Architect

Responsibilities:

• Established standards and best practices for all XML & SOA Data Architecture for the eHP V3 portal, including XSDs namespaces & versioning for canonical datatype & entity schemas, WSDL operation definitions & SOAP/REST messages.

Confidential, Minneapolis, MN

Data Architect and Senior DBA

Responsibilities:

• Created logical and physical data models for CRM, Loyalty Program and Inventory Scanning OLTP & OLAP databases supporting POS, Marketing & Customer Service. Collaborated in extensive business & system use-case discovery sessions.
• Supervised and led team of 5 SQL developers. Modeled, built and maintained database schemas, versioned build scripts, views, triggers, stored procedures, UDFs and indexes, in DB2 v5r4 AS/400 iSeries development and production machines.
• Developed/promoted data architecture and SQL DB standards plus data quality management and cleansing processes. Educated rPg, Java, .NET development teams, facilitating cultural shift in a legacy environment new to relational DBs.

Confidential, Minneapolis, MN

Senior Data Architect

Responsibilities:

• Acted as "boots on the ground" in U.S. brokerage division for Royal Bank of Canada's Enterprise Information Planning and Strategy Group, driving Data Management projects, SDLC and conformance with enterprise data standards.
• Partnered with Business Intelligence team to promote, facilitate data architecture, data modeling and metadata management best practices, data reuse, quality, security, stewardship & data warehouse utilization. Created data integration roadmaps.
• Led OOA/OOD JAD sessions to create conceptual & logical data models for projects in Visio & ERWin Data Modeler.
• Successfully drove adoption of Universal Command to replace FTP as the strategic file transfer standard, minimizing traffic & shortening batch cycles by building partnerships with over 20 IT departments & delivery teams.
• Designed and constructed ontological and conceptual information modeling tools in VB/.NET. Modeled key data management entities & relationships to facilitate data landscape mapping & offer impact analysis capability to support teams.

Confidential

Principal Consultant

Responsibilities:

• Provided project feasibility and impact study analysis, technology selection & sourcing, cost pricing/justification and IT system designs for private sector utilities infrastructure and land development projects ranging from USD $4M to $40M.
• Enhanced & maintained over a dozen e-Commerce sites & databases for international clients, performing PHP and MySQL script development, data modeling, database administration, and osCommerce module design, development & installation.
• Achieved 1000% performance improvement of online pipe manufacturing app by identifying & counteracting bugs in 3rd- party software that produced inaccurate sensor data & production reports, rewriting SQL queries & tuning database indexes.

Confidential

Sr. Technology Architect, Java & UI Architect

Responsibilities:

• Provided analysis & consulting for B2B/A2A integration of Oracle 9i/9iAS with online bill pay, Oracle 11 i ERP/HR, CRM, call center, port yard operations, POS, bar coding & workflow. Designed database audit trail requirements & methodologies.
• Conducted JAD sessions with users; documented MVC designs in UML. Led design phases & prototype development.
• Supervised team of Java programmers & analysts and developed SMEs to select & support best-of-breed tools for e.g. business rules engine, application server, Web services, SCM, and code build/test/integration/deployment & bug tracking.
• Created Web app UI framework, MVC superclasses, look-and-feel graphics, CSS/DHTML/Javascript/JSP libraries and templates & Struts tiles for re-engineered online reservation system & port operations of nation's largest shipping company.
• Designed multi-tier distributed technical architecture with optimizations to accommodate low bandwidth & offline scenarios, e.g. data caching, AJAX techniques & SOAP payload compression. Dictated UI data security & quality controls.

Confidential, Wappingers Falls, NY

E-Commerce Engineer

Responsibilities:

• Researched, productized and supported e-commerce payment gateways, merchant accounts, commerce servers & SSL certificates. Evaluated/recommended Web-hosting tools & new technologies for NOC support, logging, VPS mgmt., etc.
• Architected, provisioned, and provided customer support for Web application environments & infrastructure hosted on a wide variety of managed Web and application servers (especially WebLogic), database & OS platforms in a 40K sq. ft. data center.
• Designed, scripted, configured and lab-tested clustered server solutions with network devices including switches, content caching appliances, ASP server appliances & load balancers (hardware & software based), configured IP addresses & DNS.
• Defined this client-facing role for the company. Built key partner & vendor relationships e.g. at national conferences.

Confidential, Norwalk, ct

Director

Responsibilities:

• Managed & mentored a multicultural tri-state team of 22 Java Architects, Developers, BAs, DBAs & Tech Writers, developing an enterprise recruiting & vendor management Web app & exchange for Fortune 100 financial sector clients.
• Led OOA & JAD sessions with BAs, authored functional reqs, modeled workflows & use-cases. Coordinated build releases with Sales, Marketing, Bus. Dev, Product Mgmt, Prof. Svcs, QA, Config. Mgmt, Training & Infrastructure teams.
• Performed pre-sales consulting to Sales and Marketing depts., and client-site interviews to gather product development specifications, workflow needs and customization requirements. Prepared RFP responses and provided sales demo support.

Web/UI Architect

Confidential

Responsibilities:

• Collaborated with architects and BAs to determine enterprise data integration, market exchange, data quality control, data security, invoicing, accounting, HR & timecard system requirements, and produced conceptual data models.
• Created a thin client UI architecture & widget innovations enabling cross-browser look-and-feel emulation of the non- performant thick client customer signed off on, rescuing the multi-million-dollar contract Nitorum was founded upon.
• Designed and built a Java B2B messaging gateway with commerceXML workflow handler & innovations that positioned Nitorum as the first ever Ariba Certified supplier to use Ariba for procurement of professional services rather than goods.