SUMMARY:

• An accomplished IT professional with experience in the design and implementation of various systems, databases and applications, utilities, monitors, appliances, and databases in private and public sectors.
• I have global work / travel experience in North America, Europe and Confidential with corporate management (C - level) presentation and communication skills with a diverse knowledge of languages, hierarchical & relational database products. Over 25 years of experience in Oracle, DB2, Sybase, SQL Server, Unix / Linux / MS platforms, .NET, C/C++, Java and OO design, web development and related methodologies, utilities and SDK’s
• Project Management; enterprise architecture and governance; solution architecture; database design and data modeling; technical leadership; data integration and migration; infrastructure / application / database architecture; application design and development; pre-sales and post-sales engineering and design support systems and business analysis; technical support; QA; technical and business process documentation; training.
• Aerospace, Banking, Credit, Energy, Financials, Healthcare, Insurance, Investment, LIM, Manufacturing, Pharmaceuticals, Public Sector, Retail, Supply Chain, Scientific Applications, Software Development, Technology Vendors, Utilities.
• Facilitating data requirements; Data analysis and data modeling for OLTP/OLAP Data warehouses, data marts, data warehouses, and MDDB / clustered databases; development and implementation of standards / procedures (governance) for data design and enterprise data management; custom development, and Oracle application implementation.
• Design methodologies including waterfall, gated SDLC, RUP, Agile, ETL, MDM, CRM, TOGAF and DODAF frameworks.
• Data Center & DR facility consolidation; virtualized application / environment conversions; full life-cycle project development and planning; requirements gathering and definition; interfacing with and coordinating efforts between various business and technical teams; systems and database optimization; systems conversion & integration; technical support; analysis, design, implementation, and maintenance of solutions; triage, troubleshooting supporting and end-to-end analysis of environments and systems; design development; management and delivery of applications and databases.
• Data Center migrations for multiple clients with hands-on setup and configuration experience with routers, proxy / reverse proxy servers, load balancers, domain controllers, network switches

PROFESSIONAL / CONSULTING HISTORY:

Confidential, Chicago, IL

Enterprise Architect

Responsibilities:

• Core Staff Enterprise Architect supporting RMS (Revenue Management Services) in designing, coding and implementing statistical, analytical, and demand forecasting components. These were major components of a new Revenue Management suite ( Confidential ) that is being implemented by UAL to improve revenues and bookings
• Performed SQL query-based analytics in multiple SQL Server, Oracle and Teradata databases.
• Developed Orchestrate OPD scripts
• Created documentation, topologies, process flows and relationship diagrams for the end-to-end environment and built a consolidated Sharepoint reference library of relevant documentation.

Environment: Infosphere / Datastage Orchestrate, MS Project, Visio, MS Office, PowerPoint, Sharepoint, Oracle 11i / 12g, Oracle SQL, PL/SQL, APS, SQLServer 2008, Teradata, Linux / Unix SA, C, C++

Confidential, Indianapolis, IN

Enterprise Architect / Data Modeler

Responsibilities:

• IDMP SME in building a consolidated EDW (enterprise data warehouse) with multiple data marts to service12 business verticals.
• Completed an integrated domain analysis across multiple data domains, cross-application element mapping to database tables elements maintained centrally in an Information Hub, remediation of conflicting / variances between application data sources; development of end-to-end process flows; element type-definition standardization; normalization of Hub database schemae; re-design of application data sourcing to redirect sources to the central data Hub.
• Modeled new Oracle database schema tables, indices, stored procedures and triggers to maintain a synchronized Hub repository.
• Generated critical UML artifacts to describe processes and topologies for several data domains including product, sponsor, clinical trial sites and site personnel.

Environment: Informatica Power Center 9.6.1, ERWIN, MS Project, Visio, MS Office, PowerPoint, Sharepoint, Oracle 11i / 12g, Oracle SQL, PL/SQL

Confidential

Lead Enterprise Architect

Responsibilities:

• Supported the transition from locally managed to Confidential virtualized production and DR environments per an outsourced management contract for all physical environments, infrastructure, applications and data.
• Created BRDs, TRDs, TSDs, NRFs, PWOs, runbooks, build sheets, server specification documents, and other technical support build and configuration documentation for all projects. Created SOWs, PWOs, RFPs / RFQs, and IQOQs for Confidential .
• Supported and directed 9 PMs, 3 BAs, 4 DBAs, 3 RDMs and other technical personnel across multiple migration projects.
• Created a migration roadmap and coordinated infrastructure and database movement plan to modify applications and environment configurations to set technology directions in the new environments.
• Migration engineer moving physical and virtual servers from Astellas’ US and German data centers to Confidential DCs in Boulder and Raleigh. Coordinated multiple server lift-and-shift efforts in the US and Europe in preparing TSD, build sheets, teamed NIC network switching configurations and port assignments.
• Worked with onshore and offshore teams to define and configure VLANs, IP address schema, network switches / port channels, physical and virtual servers, SAN / NAS storage farms, load balancers, firewall servers / rules, PAC files and other infrastructure elements.
• Performance engineer using Wily Introscope, TOPAS, TOPS, RMON, PerfMon to assess application and server performance.
• Installation of Service Now modules Asset Management, Service Support Management, CMDB, Client Management, Workload Management
• Defined metadata elements for configuration of new systems and applications in Remedy CMDB for change management, configuration of new and existing systems, tracking infrastructure assets / servers, storage and other equipment.
• Created architectural / UML diagrams, topology, runbooks and other artifacts and documentation covering the end-to-end infrastructure, application and database architecture. Technical design of project architecture artifacts to perform triage of issues and problems.
• Worked with business and technical teams to define and compile requirements and design solutions for OOS, SaaS, PaaS, and mobile applications. Worked with OBIEE and SSAS for data mining and big data analytics to support internal customer analytics initiatives.

Environment: Windows Server 2005 / 2010. 2012 , RHEL Linux, VMWare, Remedy CMDB, MS Project, Visio, MS Office, PowerPoint, Sharepoint, ILO, AD (Active Directory) LDAP / SSO, Oracle 11i / 12g, DataPower / DataPower Gateway 7.5, EMC, V7000, SQLServer RDBMS, Oracle SQL, MS ACCESS, PL/SQL, Confidential Broker / MQ, XM, TOGAF, CISCO, Wily Introscope, ServiceNow

Confidential, Chicago, IL

Architect / Performance Engineering / Infrastructure

Responsibilities:

• Developed technical requirements for various user group applications.
• Cataloged and documented end-to-end applications and hardware infrastructure and application architecture.
• Developed an environmental reference to facilitate triage of issues and problems.
• Developed migration plan for relocation of a data center for a BMO affiliate (M&I Bank) including: building the application catalogue, documenting CRON, Ab Initio, and shell script jobs, preparing support documentation as needed
• Defined database configuration elements for new systems and applications in Remedy CMDB for change management, configured new and existing systems, tracked infrastructure assets / servers, storage and other equipment.
• Engaged with performance engineering group to improve use of SPLUNK and Wily Introscope for analyzing infrastructure performance. Developed multiple SPLUNK queries, dashboards and mash-up portal status indicators for better alerting and notification to key personnel.

Environment: SPLUNK, Wily Introscope, Dynatrace, ESX VMWare, Websphere AS (WAS), Remedy CMDB, MS Project, Visio, MS Office, PowerPoint, Sharepoint, AIX, RHEL, HTML, LDAP / SSO, Oracle 11i / 12g, SQLServer RDBMS, Oracle SQL, MS ACCESS, PL/SQL, Java J2EE, Confidential Broker / MQ, WAS, XML, TOGAF

Confidential, Charlotte, NC

Architect / Performance Engineering

Responsibilities:

• Cataloged and documented end-to-end architecture for applications, infrastructure and databases.
• Deployed and used performance monitoring tools (SPLUNK, Dynatrace, Wily Introscope, HP Performance Center, MinT). Developed multiple queries and embedded scripts to perform various PE analyses. Developed SPLUNK and Wily scripts to drill-down issues and dashboards to identify / display color-coded load and latency metrics for application sectors and specific application areas. Benchmarked components to anticipate areas of risk, failure, mutual impact and potential performance impacts to the enterprise.
• Triaged production issues using custom PE tools / dashboards enabling PE team to quickly examine issues, identify and reverse-engineer problems. Measure impact of software changes / enhancements, upgrades to middleware and ancillary software, JVM and VM efficiency and other environmental factors. Provide support during bi-weekly release exercises.
• Deployed TIBCO LogLogic for robust collection of transaction logs for analysis using SPLUNK and Wiley Introscope.
• Deployed and supported Confidential web accelerator to improve user web access and user routing.
• Worked with build teams to define and configure VLANs, IP address schema, network switches / port channels, physical and virtual servers, SAN / NAS storage farms, load balancers, firewall servers / rules, PAC files and other infrastructure elements.
• Defined metadata elements for configuration of new systems and applications in Remedy CMDB for change management, configuration of new and existing systems, tracking infrastructure assets / servers, storage and other equipment.
• Designed and wrote SQL, Python, SPLUNK and PERL scripts to provide query capabilities for application and database engineering groups.
• Worked with business and technical teams to compile requirements and design solutions for OOS, SaaS, PaaS, and mobile applications. Worked with OBIEE and SSAS for data mining and big data analytics to support internal customer analytics initiatives.
• Architect to examine usage of SDN for new infrastructure deployment and management of devices. As the TIAA technology stack was being redesigned for better efficiency, we based our model on the OpenFlow framework examined and executed POC’s for Cisco XNC, Brocade and Juniper

Environment: Confidential Luna / Aqua / Terra / Kona / Aura, SPLUNK, Wily Introscope, Tableau, Dynatrace, TIBCO LogLogic, Mercury, Gomez, MinT, ESX VMWare, Weblogic, Websphere AS (WAS), Remedy CMDB, MS Project, Visio, MS Office, PowerPoint, Sharepoint, AIX, z/Linux, HTML, LDAP / SSO, Oracle 11i / 12g, SQLServer RDBMS, Oracle SQL, MS ACCESS, PL/SQL, Java J2EE, Confidential Broker / MQ, WAS, XML, SQL Server, Cognos, CISCO, BARRACUDA, DataPower / DataPower Gateway 7.1, PERL, PYTHON

Confidential, Chicago, IL

Enterprise Architect / Compliance / Governance / Analyst

Responsibilities:

• Formulated architecture governance policies and monitoring systems for enterprise-wide initiatives including: CAB approvals and reviews, change reviews, architectural governance and compliance standards, technical QA, artifact control, business / application / data / technical requirements.
• Data architect and modeler for the migration of several critical instances from Oracle 11i to 12g including planning, governance, data mapping, data / metadata modeling and restructuring for a star schema model.
• Performed database vitality and functionality assessments, DBA maintenance functions, performance tuning and optimization for multiple Oracle ODS and data warehouse instances.
• Mentored staff on SQL and PL/SQL coding, database management concepts for database components (Stored Procedures, triggers, packages, constraints, etc.) to GFT BSA staff.
• Implemented business analytics tools for data mining and predictive pattern analytics for consumer behavior and transaction patterning for various financial packages.
• Designed and wrote SQL-PL/SQL, Python, SPLUNK and PERL scripts to provide query capabilities for application and database engineering groups. Developed SQL queries using Oracle, DB2/UDB and Sybase reflecting system, database and SQL best practices and optimization techniques. Completed migration of Sybase instances to an Oracle EDW consolidating over 300 databases into 5 Oracle MDM Snowflake instances with multiple data marts.
• Performed application, data modeling, data warehouse design and database analysis for GFT Risk Management (LRI) Group
• Created optimized SQL and Oracle-based applications in QA and Development environments.
• Technical advisor for the LRI team on hardware, software and database issues / problems, database design and optimization, systems analysis, process model and requirements design.

Environment: MS Project, Enterprise Architect, PowerPoint, Sharepoint, Documentum, ClearCase, AIX, z/Linux, HTML, LDAP / SSO, Oracle 11i / 12g, SQLServer RDBMS, MEGA, TOAD for DBA, Oracle SQL, MS ACCESS, PL/SQL, Java J2EE, Confidential Broker / MQ, WAS, XML, SQL Server, SSAS, Cognos, OBIEE, TOGAF, PERL, PYTHON

Confidential, Bloomington, IL

Enterprise Architect

Responsibilities:

• Integration Architect for a corporate initiative (Integrated Customer Platform - ICP) that reinvented the State Farm technology stack.
• As a member of the ARB (Architect Review Board), reviewed, designed and approved / tracked all project design, development, implementation specifications and plans for all new applications including claims and adjudication processing, policy and CRM management, AR, AP, limits and terms, disbursements, and others. Formulated enterprise architecture governance policies and monitoring systems for enterprise-wide initiatives including CAB approvals and reviews, change reviews, architectural governance and compliance standards, technical QA, artifact control, business / application / data / technical requirements.

Environment: MS Project, Enterprise Architect, PowerPoint, Sharepoint, ClearCase, Sun OS, z/Linux, HTML, SAML 2.0, Oracle / DB-2 / SQLServer RDBMS, SalesForce CRM, MEGA, Lotus Notes, TOAD

Confidential, Chicago, IL

Enterprise Architect

Responsibilities:

• Architected a migration / implementation plan to migrate mainframe systems / Inter-Claim, claims, EPA and BlueSquared applications (servicing 38 BCBS plans) from 5 in-house Solaris environments ( Confidential through Confidential ) to an outsourced hosting vendor, converting to z/Linux virtualized mainframe environments. Design / developing applications and systems inventory, middleware dependency roadmap, project plan, applications matrix summary, cost comparison model and other documentation to support the migration.
• Architected a SAML solution for SSO authentication for 38 BCBS plans to govern adoption of an IdP to SP Service Delivery Support system. Design Out-of-Plan provider portals to provide focused access to healthcare / payer data, PSR, member eligibility, special subject areas, and patient sourced systems.
• Performed MDDB data modeling for a SQLServer support RDBMS instance servicing the secured SAML assertions / logons.
• Performed database vitality and functionality assessments, DBA maintenance functions, performance tuning and optimization for multiple Oracle ODS and data warehouse instances.
• Data architect and data modeling, governance, data mapping, data / metadata modeling and remapping data to a star-schema model. Interfaced with various business and technical teams to compile requirements and design solutions for a mobile application proof of pilot.

Environment: MS Project, Enterprise Architect, PowerPoint, Sharepoint, ClearCase, Sun OS, z/Linux, HTML, SAML 2.0, Oracle / DB-2 / SQLServer RDBMS

Confidential, Jacksonville, FL

Operational Readiness Engineer

Responsibilities:

• Performed requirements gathering (BRD / TRD / TSD), infrastructure design and requirements artifacts. Presented design options to management
• Provided technical direction and architectural oversight to the development, database, infrastructure management and other technology support teams to assure that applications were sufficiently healthy to deploy.
• Engaged with installation teams with implementations of hardware and software build-outs.
• Operational Readiness Engineer for eCommerce group. Drafted operational platform infrastructure and capacity requirements to migrate / integrate multiple applications into new virtualized or hybrid cloud environments for delivery of bank related products.
• Conceptual, logical and physical design and implementation of a RDW (Reporting Data Warehouse) for business, operations and performance reports delivery. Used Informatica & Oracle Golden Gate to capture data from an MDM data warehouse and setup Capture,Trail files and Delivery modules for transfer to the reporting database.
• Worked with business and technical teams to compile requirements and design solutions for OOS, SaaS, PaaS, and mobile applications. Worked with OBIEE, TIBCO Spotfire, Cognos and SSAS for data mining and big data analytics to support internal customer analytics initiatives.
• Designed and wrote SQL, Python and PERL scripts to provide query / scripting capabilities for application and database engineering groups.
• Worked with onshore and offshore teams to define and configure VLANs, IP address schema, physical and virtual servers, SAN / NAS storage farms, load balancers, firewall servers / rules, PAC files and other infrastructure elements.
• Routinely triaged production issues using PE tools to identify and reverse-engineer problems. Enabled PE team to quickly examine issues and path loads using PE dashboards customized for specific technical teams. Used various performance monitoring tools (SPLUNK, Dynatrace, Wily Introscope, HP Performance Center, MinT, etc.) to identify production performance problems, measure impact of software changes / enhancements, assess upgrades to middleware and ancillary software, JVM and VM efficiency and track configuration changes.
• Developed SPLUNK and Wily scripts to dashboard and drill-down issues and to quickly identify performance problems. Alerts color-coded load and latency metrics by application / server groups and specific application areas (front-end and back-end).
• Defined elements for configuration of new systems and applications in Remedy CMDB for change management, configuration of new and existing systems, tracking infrastructure assets / servers, storage and other equipment.
• Used Tivoli TADDM to make infrastructure-wide assessment of the overall systems health and to collect historical data (over 30 day increments) to determine server process growth, processing efficiency, measure server utilization.

Environment: MS Project, HP-UX, Linux (Red Hat & SUSE), Windows .NET, OBIEE, SSAS, Compaq, Confidential AIX i /p /x-series, C++, PYTHON, Info-Basic, DataPower / DataPower Gateway 7, WMS Basic, PERL, WinCVS, BOXI (Business Objects), Informix, DB/2, Oracle 9i /10g/11g/12g RDBMS, DBArtisan, Erwin, TOAD, NETAPP ENC EMC storage monitoring and optimization, Remedy CMDB, VMWare, Websphere, Confidential Broker / MQ, TADDM, TDMF, Rsync, PlateSpin, Apache, Tomcat, ITIL, Wintel, Visual C++, SSL, C, COBOL, Documentum, Sharepoint, TIBCO Spotfire, COGNOS, OBIEE, ManageNow, Portal, Crystal Reports, ETL and data warehousing tools including Infosphere CDC, Golden Gate, Informatica Power Center, DB2/UDB, Oracle financials (AP / AR / GL / IC), ERWIN, Oracle Case, SPLUNK, Wily Introscope, Dynatrace, HP Performance Center, TOGAF, CISCO

Confidential, Charlottesville, VA

Senior Software Engineer

Responsibilities:

• Designed and developed intelligence software for deployment into active theaters-of-operation.

Environment: MS Project, Enterprise Architect, PowerPoint, Sharepoint, Documentum, ClearCase, AIX, z/Linux, HTML, LDAP / SSO, Oracle 11i / 12g, SQLServer RDBMS, MEGA, TOAD for DBA, Oracle SQL, MS ACCESS, PL/SQL, Java J2EE, Confidential Broker / MQ, WAS, XML, SQL Server, SSAS, Cognos, OBIEE, DODAF, CISCO Systems

Confidential, Chicago, IL

Enterprise Architect

Responsibilities:

• Technical advisor (for the treasury architect team) on hardware, software and database issues / problems, database design and optimization, systems analysis, process model and requirements design.
• Designed new applications for financials management verticals and managed architectural elements for full SDLC development efforts
• Designed and wrote SQL, Python and PERL scripts to provide query capabilities for application and database engineering groups.
• Implementation architect for OpenFlow framework for managing and configuring infrastructure

Environment: MS Project, Enterprise Architect, PowerPoint, Sharepoint, AIX, z/Linux, HTML, LDAP / SSO, Oracle 11i / 12g, SQLServer RDBMS, MEGA, Python, PERL, TOAD, Oracle SQL, MS ACCESS, PL/SQL, XML, SQL Server

Confidential

Senior IT Architect, Charlotte, NC

Responsibilities:

• Chief engineer for Treasury Channel to provide technical direction and architectural oversight supporting development, database, infrastructure management and other technology support teams at a corporate level.
• Infrastructure design; coordinate application and infrastructure design / upgrade face-to-face sessions. Formulate business (BRD) / technical (TRD) requirements, Work Order and detailed technical designs with various bank SME’s, DBA’s, developers and management; created solutions and specifications for bank applications related to CPO, CPW, CP Portal, eCommerce, and BA Direct.
• Participated in design and deployment of code and infrastructural changes in monthly release exercises. My role entailed examining applications and hardware infrastructure to be modified or implemented for analysis with respect to optimization, environmental impact, configuration for optimal performance, and enhancement of user experience. eCommerce commercial applications and traditional back-end process design and architecture were applied in routine architecture activities.
• Designed a reporting data warehouse (RDW) for business, operations and performance reports delivery using Oracle Golden Gate to capture various data from an MDM data warehouse and setup Trail files for transfer to the reporting database. Setup the Capture, Trail files and Delivery modules for real-time replenishment of the target reporting database
• Lead triage / trouble-shooting events to resolve issues affecting banking applications and operational infrastructure. Assess and developed remediation actions once causes were identified.
• Developed strategies for multi-data center deployment of applications and active-passive / active-active fail-over strategies for disaster recovery and migration for critical application environments.
• Worked on deployment of various tools and appliances to improve overall user experience and enhance throughput / performance including Confidential, TADDM, Wily and other agent and non-agent based alternatives.
• Used performance monitoring tools (SPLUNK, Dynatrace, Wily Introscope, HP Performance Center, MinT, etc.) to evaluate performance problems, measure success after modifications / application releases. Developed multiple SPLUNK and Wily scripts to dashboard and drill-down issues. Routinely triaged production issues using PE tools to identify and reverse-engineer problems. Enabled PE team to quickly examine issues and path loads using PE dashboards customized and color-coded for specific technical teams.
• Performed applications installation, deployment, configuration and maintenance including OBIEE, Oracle Financials (GL / AP / AR), Banking related applications, Confidential WAA, TADDM, Wily Introscope, SPLUNK and others.
• Designed and wrote SQL, Python, and SPLUNK scripts to provide query capabilities for application and database engineering groups.
• Worked with onshore and offshore teams to define and configure VLANs, IP address schema, physical and virtual servers, SAN / NAS storage farms, load balancers, firewall servers / rules, PAC files and other infrastructure elements.
• Worked with business and technical teams to compile requirements and design solutions for OOS, SaaS, PaaS, and mobile applications. Worked with OBIEE and SSAS for data mining and big data analytics to support internal customer analytics initiatives.
• Authored special topics white papers to provide definition for best practices.
• Technical Project Manager / Senior Architect for an Enterprise project ( Confidential ) to migrate the primary AMEX data center from Phoenix, AZ. to Greensboro, NC by 2015. Responsibilities included identification of all file systems, applications, databases, middleware, ETL (Golden Gate and Infosphere Datastage / Quality Stage / CDC), BI, and other ancillary software.
• Modeled 12 DB/2 and Oracle 11i / 12g database instances to support CRM and other native applications.
• Oversight of EMC and NETAPP SAN devices, re-tasking them to better distribute and manage storage usage. Performed routine OCI surveys on tenant and application usage for capacity planning.
• Managed: 1) extensive review / examination of servers for risk mitigation, upgrades, middleware and application co-dependencies; 2) recertification of applications for virtualized / standardized / upgraded environments in the new data center; 3) a POC to examine consolidation of dedicated servers and apps into virtualized / vCloud environments, application grouping for migration, evaluation of end-to-end requirements for staging a physical migration to a new data center, and server migration from Confidential i-Series Red Hat Linux to p-Series and x-Series mainframes with SUSE Linux.
• Senior Architect to migrate AMEX Incident Management / CRM processes from Manage Now to ServiceNow. It was a full life cycle project (SDLC) involving data mapping, ETL, creating a Data Warehouse with partitioned data stores as an intermediate repository for ManageNow data, installation and configuration of Service Now (Asset Management, Service Support Management, CMDB, Client Management, Workload Management), migrating the database, full IAT and UAT testing, and parallel execution of both processes during the production conversion. Several of the ServiceNow modules required customization for features present in ManageNow but absent from ServiceNow base functionality. Modules included Asset Management,
• Senior Architect for an AMEX POC project to demonstrate the feasibility and cost-effectiveness of migration AMEX servers into vCloud environments.
• Integrated data into an Enterprise Data Warehouse. Developed data requirements, data flow diagrams, data models, source-to-target data mapping, and ETL specification. Produce conceptual, logical and physical data models and generate Oracle and Teradata DDL using ER/Studio Data Architect.
• Used Tivoli TADDM to make infrastructure-wide assessment of overall systems health and collect historical data over 30 day increments (to determine server process growth, processing activity, measure server utilization and determine assimilate data that would qualify for enhancements).
• Used performance monitoring tools (SPLUNK, Dynatrace, Wily Introscope, HP Performance Center, MinT, etc.) to evaluate production performance problems.
• Performed a comparative evaluation of COGNOS and TIBCO Spotfire for evaluating business and predictive analytics for market and consumer activity analysis.
• Triage of production issues using PE tools to identify and reverse-engineer problems.
• Implemented Oracle Golden Gate to replenish reporting data warehouse for business, operations and performance reports delivery. Setup the Capture, Trail files and Delivery modules for real-time replenishment of the target reporting database
• Engaged in applications installation, deployment, configuration and maintenance including OBIEE, Oracle Financials (GL / AP / AR), Insurance and banking applications, TADDM, Wily Introscope, SPLUNK and others.
• Architect for the conversion of multiple older legacy analytics systems written in BISON and PYTHON.
• Created and formalized SOWs, PWOs, RFPs / RFQs and IQOQs for internally bidding on client projects for Confidential
• Technical Manager and Senior Technical Architect for conversion of legacy platforms and applications to a new virtualized and cloud based architecture designed to support web applications in a new data center.
• Lead team to perform the migration of all applications and databases to the DR site for AP, AR, Claims, Payments, Adjudications, Treatments and Plans.
• Performed applications installation, deployment, configuration and maintenance including OBIEE, Oracle Financials (GL / AP / AR), Insurance and banking applications, TADDM, Wily Introscope, SPLUNK and others.
• Assembled / lead a SWAT team to physically build-out 238 servers in a new Boulder DR facility. On-site activities included: initial server / appliance placement; router cabling; Unix / Linux OS installation; firmware installation; applications, database and ancillary / middleware software installation; and synchronization of databases with the primary DC in Hartford.
• Worked with state and federal regulatory agencies to define and create emergency procedures and DR best practices.
• Technical Manager, Senior Technical Architect, and Migration engineer / developer for Reuters UK to migrate streaming Market Analytics Tools Suite (Stock Ticker Line Handler and Market Rules applications) from VAX VMS / Pascal / VAX Basic to Windows Server / C++ and Java J2EE / Oracle 10g technologies. Objective: to leverage RDP connectivity provided in the new .NET environment and previously unavailable in the legacy VMS environment. The new architecture had to be a global, multi-currency investment accounting solution supporting transaction volumes of over 150,000 messages / second from over 30 different exchanges worldwide. It incorporated multiple upgrades and enhancements to complement services and features delivery to subscription clients. The VMS / VMS-Basic libraries conversion also included rewriting a number of interpreted programs originally developed in PYTHON and Natural languages to C# function calls to eliminate interpreted coding for analytics and market analysis in the new replacement systems.
• Designed a replacement of their Market Analytics Tools Suite. Redesigned the eCommerce front-end (presentation of market analytics to subscribers using a web-based front-end portal) as well as back-end processes where analytics and real-time forecasting data is prepared.
• Managing architect and single point-of-contact to re-design and developed / test all converted / migrated stock trading-based applications for the new environment.
• Converted Thompson Reuters PORTIA Client and Regulatory Reporting, Performance Measurement and Investment Accounting / Reporting software to a .NET framework. PORTIA supports a broad range of asset types from around the world and provides the multi-currency functionality required by diverse investment managers. It complies with all industry standards including those from Financial Accounting Standards Board (FASB), International Financial Reporting Standards (IFRS), Generally Accepted Accounting Principles (GAAP) and Statutory Accounting standards.
• Developed BI protocols for Reuters incorporating Cognos BI tools, Websphere ILOG BRMS (Visualization, ODM, OAD, Logic Net Plus). BOXI. Implemented OBIEE and SSAS predictive analytics packages for evaluation of customer investment patterns.
• Analyzed business data requirements for product integration, sales forecasting, inventory, assortment planning, order management, and merchandise planning.
• Developed logical and physical data models for the implementation of an Investor Online Data Analytics and Metrics solution.
• Designed and wrote SQL and PERL scripts to provide query capabilities for application and database engineering groups.
• Technical manager and Lead Architect for Confidential (Enterprise Computing Model), a project to globally consolidate and convert Confidential enterprise-wide internal servers and applications to more efficient virtualized and cloud environments to reduce TCO and improve user experience. Activities included: full migration plan design through implementation; client-facing coordination to identify deliverables, use cases, requirements and expectations; gap analyses; application certification and remediation; database optimization; virtualization and infrastructure management; VM build-out and configuration; meeting with all Confidential business and application development groups to manage, plan and coordinate migration of their systems. Oversight of EMC and NETAPP SAN storage retasking to better distribute and manage storage usage. Performed routine OCI surveys on tenant and application usage for capacity planning.
• Successfully completed over 17 “waves” for migrating various internal business groups / applications and CIO sponsored projects including: Tivoli, iRAM (Rational), TADDM, SDG, WAS Suite including Websphere ILOG BRMS (Visualization, ODM, OAD, Logic Net Plus) and other mainline Confidential software development operations.
• Project Leader and migration engineer to install Unix / Linux (Red Hat and SUSE) / HP-UX OS, Solaris, Vintella, Weblogic, Confidential Broker / MQ, Q-Logic, middleware, and various applications and Oracle / SQLServer database software on over 2200 Solaris, HP and Windows servers to setup a DR / BCV facility for a major insurance firm. Architecting the infrastructure, network, database migrations and application migrations were included in scope of responsibility.
• Evaluated various client application and environment performance and application fault issues in advance of architecting / remediating / solution engineering for various Confidential global clientele to support migration efforts from platforms, legacy software and systems.
• As a DMS Manager, established and maintained several document repositories (encompassing Sharepoint, Discovery and RAM) for internal documents and assets relating to projects, applications, performance metrics, and numerous other media categories.
• Test Lead Manager for the development of an end-to-end test plan for a new SCE+ methodology to automate migration of clientele servers to Cloud environments (VSO-SCE).
• Technical PM, Architect and Lead Migration / Development Engineer for the Confidential Enterprise Computing Model) project to migrate all Confidential internal systems and applications to virtualized, clustered server, and more energy efficient hosting environments.
• Drafted database migration plans for universal migration of Sybase to DB@ and SQL Server including system, database and SQL best practices and optimization techniques
• Performed functional system design and technical design document reviews.
• Reviewed data modeling artifacts for quality and completion.
• Co-organizer of The Shadow Forums - An Insider’s Guide to AMS C&M to provide monthly forums covering special topics and technical overviews to the entire AMS C&M community of practitioners.
• Participated in the Confidential Mentor program extensively.
• Support pre-sales efforts in the design and review of systems and applications including risk analysis and management, identification of business rules and use cases,
• SPOC for architectural issues and information to the Confidential community of GBS consultants.
• For Northern Natural GAS (NNG), architected a multi phase BI solution / migration from SQL Server to Business Objects XI to implement a standard BI methodology across NNG and parent company Berkshire-Hathaway.
• Developed various applications using C, C++, Visual C++, VBx, PERL, Unix shell scripts
• AMS C&M organizer and lead for project Blue Reach (later becoming Expertise Locator) which was a volunteer program to provide technical assistance on-demand to internal Confidential colleagues by a volunteer group of SMEs.
• Defined metadata elements for configuration of new systems and applications in Remedy CMDB for change management, configuration of new and existing systems, tracking infrastructure assets / servers, storage and other equipment.
• Architected and lead a POC for a new Confidential CMDB tool (DARWIN) for change management and tracking / deployment of new server configuration parameters for automated configuration management and asset tracking. DARWIN is an SDN / NFV based system for configuration and deployment of network configurations and managing changes using various Confidential API’s to respond to network changes with other API’s such as OpenFlow, Valet and Chef (also encompassed in the Confidential DARWIN management framework.
• Used Tivoli TADDM to make infrastructure-wide assessment of the overall health of all systems and to collect historical data over 30 day increments to determine server process growth, processing activity, measure server utilization and determine assimilate data that would qualify for enhancements.
• Created SOW, PWO, RFP / RFQ for internally bidding on client projects for Confidential as well as preparation of architectural and technical support and topology documents in my role.

Environment: MS Project, HP Open VMS, HP-UX, Linux (Red Hat & SUSE), Windows .NET, Cognos, OBIEE, Solaris, Compaq, Confidential AIX p-series, C++, PYTHON, Info-Basic, WMS Basic, PERL, Visual Studio, JSP / JSF, Pascal, UDP, WinCVS, BOXI (Business Objects), Informix, DB/2, Oracle 9i /10g/11g RDBMS, Sybase and Sybase ASE, DBArtisan, Erwin, TOAD, Confidential InfoSphere Information Server / DataStage / Quality Stage / Information Analyzer, NETAPP ENC EMC storage monitoring and optimization,VMWare, Websphere, Confidential Broker / MQ, TADDM, TDMF, HP Open View CMDB, Remedy CMDB, DARWIN CMDB, Rsync, PlateSpin, Apache, Tomcat, CORBA, ITIL, Wintel, Visual C++, SSL, C, COBOL, Documentum, Sharepoint, Cognos, SSAS, OBIEE, ManageNow,Various Portal, Crystal Reports, various ETL and data warehousing tools including Infosphere CDC, Datastage, Qualitystage, Golden Gate, Informatica Power Center, DB2, DB2/UDB, Oracle financials (AP / AR / GL / IC), ERWIN, Oracle Case, SPLUNK, Wily Introscope, Dynatrace, HP Performance Center, DODAF, TOGAF

Confidential, Libertyville, IL

Global Solutions Applications Architect

Responsibilities:

• One of four worldwide architects to oversee all corporate applications’ design and function.
• Supervised a team of functional designers and solution engineers.
• Analysis and rework of deployment landscapes, design templates, SDLC architectures, customization requirements.
• Developed and maintain global applications architecture complying with A&E Governance standards.
• Revise and redefine architecture for best practice and optimal solution for the business.
• Presentation of models, business requirements, solutions and architectural elements to customers and Confidential management.
• Supported multiple Confidential Cellular device applications for their mobile devices in their eCommerce sector.
• Evaluated BI tools for cellular retailing division and established BI protocols for market evaluations and targeting customer market demographics.
• SPOC for level 3 applications related matters
• Strategic and tactical planner making critical decisions regarding adoption, deployment and documentation of critical processes and applications.
• Engaged with application teams in the installation, deployment, configuration and maintenance of multiple applications including OBIEE, Java Apps, Oracle Financials (GL / AP / AR), eCommerce related applications, and others.
• Defined metadata elements for configuration of new systems and applications in Remedy CMDB for change management, configuration of new and existing systems, tracking infrastructure assets / servers, storage and other equipment.
• Developed ETL utilities and applications for migrating and transferring large data volumes for application deployment and daily data exchanges using C, PERL, Unix shell scripts, Confidential Infosphere / Datastage / Qualitystage, Informatica

Environment: MS Project, Sun Solaris UNIX, AIX Unix, Oracle (9i /10g / 11i / 12) RDBMS, Oracle Financials (AP / AR / GL), Oracle Developer 6i,Oracle OAS, J2EE, PL/SQL, SQLPlus,, Manugistics Collaborate, I2 Demand Planner, E2Open, Informatica, Confidential Datastage / CDC / Qualitystage, Data warehousing, Erwin Case Tools, Rational Clear Case /Quest Confidential, C/C++, TOAD, FTP, DB Artisan, Expert, various project tracking and modeling tools, Cognos, CMMI / ITIL, HP Open View CMDB, Apache, Tomcat, JAVA, Struts, Visual C++, PERL, .NET, ETL Tools, WAS, Websphere Confidential Broker / MQ, ILOG BRMS (Visualization, ODM, OAD, Logic Net Plus), DODAF

Confidential, Clearwater, Florida

Project Manager and Senior Design Analyst /DBA

Responsibilities:

• Technical Project Manager and senior designer of an FAA / EASA airworthiness compliance system to track and identify compliance with PMA, DDA, TSO, DSA, TC, STC BASA, EAN and BIS operational constraints.
• Developed Application and Database designs and detailed application specifications for BRMS, Confidential, MRP, DMP and Supply Chain applications as necessary to complete and implement the system.
• Developed applications (coding, testing and QA / testing) and lead several other developers in application development (full SDLC) for CRM, service, sales, supply chain, federal (FAA) compliance reporting and other initiatives.
• Performed functional system design and technical design document reviews.
• Designed and reviewed data modeling artifacts for quality and completion for an FAA compliance reporting system.
• Built and maintained database object DDL and SQL code for ODS, Data Warehouse, and Data Mart databases
• Management and oversight of the development and implementation team.
• Designed and implemented conversion plans for database and applications to integrate the new Germantown subsidiary into baseline systems.
• Evaluated methods to optimize database, schema, SQL and PL/SQL across applications and multiple package steams.
• Redesigned, coded and implemented (full-SDLC) extensive modifications to a Manugistics MRP, Inventory and Replenishment system including Unix shell scripts, SQL, application interfaces and database schema/model designs.

Environment: MS Project, Sun Solaris UNIX, AIX Unix, Red Hat Linux, Oracle (9i / 10g / 11i / 12g) RDBMS, Oracle Forms, Oracle Case, Oracle Financials (GL / AR / AP / IC), Manugistics, PL/SQL, SQL-Plus, Data warehousing, PVCS Confidential, C/C++, .NET, XML, HTML, Struts, Oracle Forms / Reports, WAS, Weblogic, Websphere ILOG BRMS (Visualization, ODM, OAD, Logic Net Plus), Tomcat, VBX, Oracle Developer 6i, ERWIN, Crystal Reports / PRO, SQL Server, Windchill, DODAF

Confidential, Washington, DC

Project Manager / Database Architect / Business Analyst

Responsibilities:

• Project manager for implementation of a web-enabled accounts reconciliation application to facilitate rapid closure of financial transactions for quarterly and annual accounting periods.
• Architected solutions for migrating applications and databases to new environments and infrastructures.
• Database architect to reengineer 284 databases across multiple business units and develop normalized schema models for VLDB and MDDB / MDM repositories. Consolidated multiple data warehouses into single Oracle DW’s with multiple stores.
• Served on the Database Review Board which reviewed proposed database physical / logical models and validated / approved them for correctness and best practices.
• Drafted database optimization standards for universal adoption using Oracle, DB2/UDB and Sybase including system, database and SQL best practices and optimization techniques. Completed migration of Sybase instances to an Oracle EDW consolidating over 300 databases into 5 Oracle MDM Snowflake instances with multiple data marts.
• Integrated internal and external data sources, including Airport Services and third-party Industry market data, into an Analytical Data Warehouse. Developed data models, source-to-target data mapping, and ETL specification.
• Produced conceptual, logical and physical data models, metadata, and Oracle DDL using ER/Studio Data Architect.
• As a DML (Manager) in charge of Common Initiatives, successfully brought several technology projects through full life-cycle development to completion.
• Developed ER/Studio administration standards and processes for ER/Studio data model and repository management, and the publishing of metadata through the ER/Studio Portal.
• Designed C, C++, Java, PERL and SAS applications and managed development / implementation teams through installation.

Environment: Sun Solaris UNIX, AIX Unix, / SUSE / Red Hat Linux, Oracle 9i / 10g / 11g RDBMS, Sybase, DB2 RDBMS, PL/SQL, SQL-Plus, Informatica, HP Open View CMDB, Ascential Information Server / DataStage / Quality Stage, MS Project, Cognos BI, Data warehousing, Erwin Case Tools, Rational ClearCase and ClearQuest Confidential, Websphere / MQ, C/C++, TOAD, FTP, DB Artisan, Java, SAS, Business Objects, Confidential COBOL, MicroFocus COBOL, various ETL, DODAF