SUMMARY:

• Senior IT professional with a history of successful large scale implementations across a variety of industries and technologies. Areas of concentration include Financial Services, Healthcare, Insurance, Manufacturing, Civil Engineering, Consumer Goods and Manufacturers.
• Investment Banking Architecture, Integration and Implementation for all systems integrated with Operations, Finance, Risk and Regulatory systems. Expert in onboarding acquisitions (setting up BIC, SWIFT, /Transaction Data, reconciliation, Risk and asset classification etc.)
• Wide array of market vertical and horizontal successful deployments with a common objective of requiring architecture that supports golden source MDM system integration, high performance and throughput, standard and custom reporting, predictive analytics to support Operations, Finance, Regulatory and competitive business advantage.
• Technology visionary and implementer across a wide variety of technologies including Oracle, Microsoft, Unix, core and application suites as well as complementary supporting technologies and methodologies

PROFESSIONAL EXPERIENCE:

Confidential

Independent Consultant / Data Architect

Responsibilities:

• Augmate assignment to provide Solution Architecture services for planning, direction of Enterprise Smartglasses over Amazon AWS cloud and Intel IOT router. Assist in capital planning efforts and overall business strategy. Virtual Reality has been most prevalent in gaming applications. Augmented Reality is focused on business applications that integrate with business applications through JAVA. Environments include Oracle, SQL Server and Big Data.
• Confidential assignment to provide FFEIC 031 and Y9C reporting utilizing OFSAA (8.0.4.1) and Lombard integration for deposits in an agile manner (Version1). Source systems were Murex and Deposit systems for this phase. Coded formula’s and SQL utilizing OFSAA lineage and linkage documents to ensure derived entities contained information stores reflective of business and technology requirements.
• Allied World assignment to upgrade to Oracle Cloud applications and integrate seamlessly with disparate systems. Utilized standard API’s, BI Publisher, Fusion, Azure and Mulesoft to architect, develop and deploy solutions. In addition to solutions, provided, support and guidance.
• Citi Corp assignment to provide comprehensive analysis, review and plan for Operations, Finance, Risk and Regulatory systems for entire global operations which are input to Basel, DFAST and CCAR reporting/ projections and overall reporting/exposure/forecasting.
• Commerzbank assignment to provide architectural/design/implementation/support services for global implementations of Oracle data warehouse and EBS 12.1.3. Target environment was an operational data store for all investment and trade, and financial system which will feed the Global Consolidated Ledger. Environment is a myriad of standard and non - standard technologies, including, but not limited to Oracle Reports, FSG, OBIEE, ESSbase cubes, and legacy home grown development. The project was focused on migrating the existing environment to a targeted to EBS 12.1.3 for all Front Office, Mid-office and back-office integration to be phased in over several years. Development methodology was a mixture of AIM, and homegrown with a primary focus on agile approach. The US organization was extremely small with less than 400 total employees.
• Deutsche Bank assignment to provide architectural/design/implementation/support services for a global implementations of Oracle data warehouses. Business Analysis and Data Analysis for the migration, conversion and reconciliation of Loan IQ feeds for Federal Reserve Call Reports (FR Y-9C) and Comprehensive Capital Analysis and Review (CCAR). Detailed project plan, Business Requirements Document (BRD), Functional Requirements Document, Technical Requirements Document. Source to target mapping of LIQ source to Micro Data Manual (MDRM) data elements. Environment was a backend Oracle with SAP EBS. Project was the development of an Oracle 11g data warehouse to support Fed regulatory reporting.
• RBS assignment to provide ABN AMRO migration, restructure of accounting rules engine for all front office trading system and architectural/design/implementation/support services for a global implementation of Oracle data warehouses and EBS 12.1.3.. RBS environment was 11.5.10 for US entity and proprietary for EMEA and APAC. Target environment was an operational data store for all investment and trade, and financial system which will feed the Global Consolidated Ledger. Reporting (target 12.1.3). Legacy environment was a myriad of standard and non-standard technologies, including, but not limited to Oracle Reports, FSG, OBIEE, ESSbase cubes, and legacy home grown development. The project was targeted to be fully live in 2015-6 and was being phased in over several years. Development methodology was a mixture of AIM, and homegrown with a primary focus on agile approach. The US organization included former Oracle employees, who were well aware of release 12 features and new approaches (OAF, Oracle Unified Method), and all staff were balancing existing production workload with future development work streams.

Confidential

Director of IT

Responsibilities:

• Provide IT development and support for all modules in the Oracle EBS suite. iProcurement, Web tapout, Order Entry, Inventory, approval hierarchy, FSG, ADI, HFM feeds, Oracle Reports, extracts/ imports, workflows, and operational support. Order Management. Multiple Tap outs Multiple Organization setups (hr approval hierarchies, workflows, bill to’s, ship to’s)Integration with 3rd party vendors to replenish our supply rooms at our facilities. Multiple approval hierarchies/workflows for dollar amount/controlled substance replenishments. Integration with external vendors with internal inventory which fed the Confidential t orders. This inventory was then used for Confidential ts and marked up and invoiced through the receivables. There was a 4 way match between the PO, Receipt note, Invoice and receivable line item.

Environment: was Oracle, SQL Server, Microsoft and custom BI/Tools. Upgraded Oracle EBS 11. .1.3 Financials, HRMS, Payroll, iProcurement, iexpense, Inventory, KBI, KBX, HFM Responsible for day to day support for modules including, but not limited to user support, bug fixes, configuration, load balancing of concurrent manager configuration, report writing, data extracts, system integration with non-EBS modules and opening/supporting escalating service requests. Wrote many SQL scripts and utilized both TOAD and SQL Navigator. Environment did not have a lot of forms customizations, so there was limited requirement for additional flexfields and CUSTOM.PLL enhancements to forms. Utilized AIM methodology.

Confidential

Senior Architect/Manager

Responsibilities:

• Provide IT leadership and strategic vision in a phased tactical implementation approach
• Provide design/solutions architectural for Marketing Mix Modeling data warehouse including Client Raw data feeds, Industry feeds, modeling and BI Client tool delivery in SQL Server, SPSS, Microsoft and custom BI/Tools.
• Correlate Web Order Entry to marketing spend.

Confidential

Development Manager

Responsibilities:

• Implemented Oracle Siebel 7 and Siebel 8 CRM with integration points in the ODS layer of Data Warehouse and fusion integration to PeopleSoft Financials/HFM IT leadership, creativity, mentoring and guidance and strategic/tactical vision
• Governance of MDM for ODS (Operational Data Store) fed from the system of record OLTP system into a 3rd normalized form of the data warehouse. Data is transformed in Informatica ETL to OLAP. DOI audits, feeds (WEB MD) and coordination/Integration of predictive clinical data mining with Medstat/internal data.
• Design, data and solutions architectural services for Healthcare DW/BI from Project Charter, physical and logical models and JAD’s. Implemented an Oracle 10G Informatica ETL solution with DB2 adaptors. Reporting Data Warehouse solution was a star schema. Kimball design reporting solution developed in ERWIN. Design also supported a 3rd normal form Operational MDM data store for system integration. Current deployment supports access to DW thru a variety of tools - Business Objects XIR2, Cognos 8.4 and SAS. Development of Meta data layer with data dictionary for Cognos Catalog and Business Objects Universe. Additional feeds to architecture are utilizing Ascential Datastage ETL. Portfolio management with retirement/steady state of applications and software as they were integrated with multiple versions and competing software as a result of numerous acquisitions and mergers. HCR and ICD-10 analysis and design. Developed Web metrics and client profiles.

Confidential

Independent Consultant

Responsibilities:

• Specialize in Business Intelligence, Data Warehouse, design, architectural and implementation services
• Owner providing solution and data architectural services
• Build, support and trained on projects with SQL Server and Oracle Data Warehouse
• Microsoft Web development technologies including VB and Java in the .NET framework
• Apache Tomcat, Unix System Admin and DBA installations and configurations
• Deployed BI/DW SAP Business Objects solutions for Health Plus, Segal, GHI, and HIP. with Ingenix/Medstat

Confidential

Director of IT

Responsibilities:

• Under my tenure Confidential became the first US company to deploy Oracle HRMS. Additionally, Oracle Projects was co-developed with Confidential, Failure Analysis and ABB.
• Oracle Applications 9.37 to Release 12 design, Projects, ERP, E-business suite, iProcurement, Order Entry, CRM, business intelligence, reporting and emerging technologies. Worked with Oracle Architects on numerous modules for Release 12 including OAF with early adaptations of fusion/ iProcurement, Order Entry modules with a 3 - way match (Order, Goods Receipt Notice,and Invoice) played a pivotal role as we had the contract for FEMA after Hurricanes Katrina and Rita.
• Vendor selection/negotiation choosing Intranet business intelligence, ETL and reporting systems. Strategic direction of Intranet 5 year plan.
• Built/directed team of 30+ employees and 24 consultants to develop, manage and operate initiatives
• Instituted a Software portfolio management system
• Acquired 50+ companies in my tenure - responsible for due diligence, IT analysis/config and integration
• NDA prototype Oracle OWB, Discoverer, Financials Intelligence, Multi-org, multi-currency and multi-legislation
• Opened proprietary ERP reporting systems through ETL, warehouse and SOA for integration with Portal technologies
• Identified business needs/developed tools which allowed marketing/sales departments to reduce staff 20% while increasing sales and new business initiatives
• Developed, negotiated, selected and implemented strategy to move approximately 20% of the company to new reporting systems, allowing business to meet strategic diversification objective of revenue streams without cost
• Integrated Oracle Projects with a pre-release of MOSS (Sharepoint 7) for MS cubes with high level Project Revenue Margin erosion identifying and teeing KPI’s from both Projects and Financial Net Income statement

Confidential

Senior Developer/Architect/Manager

Responsibilities:

• Oversaw entire Oracle Applications 11.3 environment (ERP, EBS, and CRM), Remedy Trouble Ticketing and provisioning systems, Concord Web metrics system reporting directly to the CIO. Managed all aspects of technology integration
• Sole point of contact responsible for patches, sql, reports, user requirements, problem resolution and vendor liaison
• Responsible for seamless integration/conversion of all acquired companies. Performed Unix SA, and DBA duties
• Installed, configured and implemented Oracle Applications 11i with E-Business, CRM, Procurement, Order Entry, Projects, HRMS and Financials
• Asked by Confidential to pursue an ASP solution for ORACLE Applications in the Globix hosted environment
• Built team to 3 dozen full time staff, 12+ vendor consultants, and approximately 12 graduates.
• Utilized numerous tools (Quest, Veritas, Extreme programming Techniques, Team Building) to maximize the rate and quantity of deliverables while at the same time maximizing quality
• Developed a SOA architecture which unified the Oracle modules, Remedy provisioning system and the Concord monitoring systems which utilized web services with LDAP database integration and Microsoft ADS. Upon hire in HR, building access cards, VLan assignment, disk storage, logons and associated workflow process were initiated
• Leveraged data marts driven from both the Oracle AP and remedy provisioning system which provided line item detail for Telco tariffs payments, resulting in a savings of over $1.4M per annum

Confidential

Senior Developer/Architect/Manager

Responsibilities:

• Responsible for all systems development staff and systems reporting to VP of Information Technology. Supported approximately 2000 users which grew to slightly over 10,000
• Developed Oracle applications with Developer 2000 and in-house developed custom applications that integrated with ORACLE environment.
• Leveraged Custom.Pll, flexfields for customizations and worked with Oracle to implement our customizations into base product.
• Tuned concurrent manager, database and developed summary rollups for operational efficiency
• Supported disparate reporting environment (ADI, FSG, Oracle reports, numerous legacy extracts).
• Seamless integration and conversion of all acquired companies
• Responsible for all software business initiatives
• Configured/implemented/supported Oracle Applications ERP, Projects(1st customer/architect), HRMS(1st US customer/architect) and Clarus E-Business integrated into Oracle PO, Order Entry, Purchasing, Inventory modules prior to E-Business suite availability
• Worked with the Oracle SME’s to in corporate designs into standard product releases
• Developed data marts for OLAP reporting justified by the incapability of the standard Oracle reports to process the high volumes of data
• Leveraged knowledge of Financial packages as well as inter-operability between all financial packages to develop solutions which facilitated the distribution and appropriate priority of the reporting/query systems
• Developed numerous in-house systems for marketing, sales and e-procurement which provided both hard and soft pipeline backlog and controlled costs
• Member of 1 of 3 companies to design, architect and deploy Oracle Applications including future features in phased releases including 12 in the Projects
• Deployed Oracle Applications 9.3.7 with the first Project Accounting Release and the first US HRMS release

Confidential

Senior Developer/Architect/Manager

Responsibilities:

• Managed the design and development of financial systems ported to ORACLE and SYBASE
• Developed interfaces to Financials which facilitated upload and downloads to the core product
• Evaluated all prospect, client, internal, and business partner requirements
• Developed multiple scenario implementation strategies based on current and projected costs and available software/resources
• Responsible for Cognos Impromptu and Powerplay integration with core Financial Product
• Worked as technical liaison providing development strategies for all sales accounts
• Managed technical support team for implementation, conversion of clients' current technologies to new environments
• Provided technical guidance on a wide variety of new operating systems, database and network scenarios
• Was a contributor to the new Windows NT environment along with 11 other Microsoft selected companies
• Worked with sales force and vendors on a day-to-day basis to prioritize and cultivate business opportunities
• Was a key resource in the generation of over $18M new revenue during 1993
• Developed application configuration to run on (Oracle, RDB, SYBASE, SQL Server, OS400
• Key resource in the Microsoft Advisory board of 12 companies having input into the development of Windows NT

Confidential

Product Manager

Responsibilities:

• Evaluated internal, business partner, client, and prospect requirements and prioritized for integration with the GEMMS development. Integrated GEMMS into ORACLE Financials, CODA Financials and a variety of 3rd party apps
• Lead technical service teams of both internal (35 staff) and external development staff and successfully “offshored” development for European market requirements before it was fashionable. Managed consultants and developers, directed Trade Shows and Demonstration Centers and achieved DEC CMPD, IBM CSP, and HP Premier solution provider status
• Set up Centers of Excellence (COE’s) worldwide and presented to industry watchdogs to garner favorable status to be rated in the magic quadrant - or equivalent status
• Worked with sales force and vendors to generate over $15M per annum
• Managed strategic business partner relationships which included offshore development and multi-vendor solutions, and cultivated business partner relationships with Level 1 & Level 3 process manufacturing industry vendors
• Responsible for functionality in GEMMS release and communication to internal staff, client base and prospects
• Senior Developer/Architect/Manager
• Managed staff of 24. Responsible for full project life cycle of Accounting/Process Manufacturing business systems
• Enhanced development of Cimpro (VB) while simultaneously developing the new relational database product GEMMS (Global Enterprise Manufacturing Management System). Interfaced with client/user community for all projects.

Confidential

Senior Developer/Architect/Manager

Responsibilities:

• Responsible for selection and implementation of financial packages for North American operation
• Managed 24 systems development staff. Responsible for the development of all business applications
• Formulated business requirements, prioritized and scheduled existing/future work plans
• Provided technical solutions for business, maintained communications with the user community
• Accomplished installation and implementation of a LAN based ORACLE development environment; conversion to Confidential Financials with AP, GL, Accounts Receivable, Payroll/Personnel, timecard systems
• Developed seamless interfaces between all systems and developed data warehouse utilizing Oracle Release 2.3c

Confidential

Systems Analyst

Responsibilities:

• Responsible for conversion and enhancement of over 400 COBOL programs (IBM System 3 to Wang VS 100)
• Applications delivered ahead of schedule. Included Order Entry/Billing, Inventory, Finance, Marketing and Sales
• Conversion to Wang fostered formed the basis for a new approach for supply pipeline and distribution on-line

Confidential

Programmer/Analyst

Responsibilities:

• Member of a small IS team supporting upper management, developed agent profiles, maintained/enhanced financial, marketing and sales applications, and designed/deployed IMS database update system