SUMMARY

• Senior Project Manager, Technical Lead and Data Architect with over eighteen years of experience in information system design, software development and systems integration. Candidate is a hands-on contributor who possesses exceptionally strong technical as well as business skills in the disciplines of business analysis, group facilitation, software analysis, design and development. Candidate can assist clients in the technical and management tasks required for multi-tiered Web based application development efforts. Candidate has assisted in the establishment of multi-regional Internet company presence supporting infrastructure build-out. Experienced data architect skilled in data model design conceptual, logical and physical in both OLTP and OLAP environments. Candidate has designed data warehouses utilizing schemas for financial, product sales and human resource application.
• Expertise as a DBA primarily in a development context, however, familiar with enterprise production support tools, processes and procedures. Familiar with Computer Systems Validation including IQ, OQ and PQ development and execution. Experienced in supporting ERP financial applications from Oracle to include Accounts Payable, Accounts Receivable, General Ledger and HR.
• Candidate is experienced in the design of data warehouse environments utilizing both Kimball bottom up and Inmon top-down data warehouse design methodologies. Candidate has designed and developed ETL production processes utilizing PL/SQL and Unix scripting to encompass end-to-end loading, maintenance and reporting of a data warehouse and data mart content in a lights-out environment.
• Candidate is an experienced Data Modeler/ Architect capable of designing Logical Databases and Data Warehouses, utilizing Star Schema and 3rd Normal form modeling techniques creating Conceptual Data Models, Logical and Physical Data Models with target RDBM's in both Oracle and SQL Server. Utilized native database capabilities to create physical databases from logical models that take advantage of the latest advanced operational features such as data partitioning and advanced indexing.
• Candidate has assisted in the development of Corporate Web Sites with dynamic content utilizing Oracle's WebServer 2.0 with the PL/SQL data cartridge.
• Familiar with XML Schema Design and Development of DTD's based on W3C standards as well as RDF schema development.
• Sitecore Website Management Studio, Certified SiteCore developer Level 1.

TECHNICAL SUMMARY

• Software: Oracle Products
• Oracle 9,10 and 11G servers with replication and partitioning options and OEM management utilities, diagnostics, tuning, ASM, XML functions and development of XML streams for use in mid-tier applications.
• PL/SQL Development complex development of packages, procedures and functions, Oracle Forms 6i
• Microsoft Products SQL Server Version 2011, Visual Studio 2005-8, C
• ETL IBM's Datastage, Informatica V5
• Modeling Tools: Sybase PowerDesigner V15 and 16.1, ERWin, Toad Modeler, ErStudio and SQL Developer Modeler
• BI Tools: Sagent, Business Objects, OBIEE and Tableau Other DB Tools Toad, SQL Navigator, SQL Developer, SQL Server Management Studio
• Languages: C , PL/SQL, SQL, COBOL, Basic
• NOS/OS's: Unix and Variants AIX, Solaris 5.7, HP 11.x , NT 4.0 Server, Netware 5,6.X with moderate admin
• Networks: TCP/IP administration, Netware IPX/SPX, SQL Net config V2.X, Oracle Names
• Enterprise Mgmt: Oracle Enterprise Manager, BMC Patrol
• Project Management: Agile Project Management Methodology, SDLC Waterfall PM Methodology

CAPABILITIES

• Technical project management
• Data Warehouse design, development and integration into enterprise systems
• Requirements gathering, definition and documentation
• System and process analysis, definition and documentation
• System architecture and design hardware, software, network
• Web and SOA based processing architectures, distributed, and cooperative processing environments
• Skilled in the analysis and design of Corporate Taxonomy data to support web site data commonality and Web Site navigation functionality.
• Database installation and configuration
• Database administration and design
• Database modeling and design Conceptual, Logical, Physical, Master Data Management MDM
• Data Warehouse analysis and design utilizing Kimball and Inmon methodologies
• Database replication design and implementation
• Performance tuning at the system, network, and database levels
• Database auditing review of current configuration and administrative procedures
• Data Analysis and Conversion
• Networking and communications
• Strategic technology planning
• Business Process Analysis
• Product evaluation, implementation, and integration
• Systems integration including access to legacy systems
• Migration planning and implementation database and application
• Development of system test plans
• Full lifecycle application development
• Business strategy/requirements analysis

EXPERIENCE

Confidential

• Architect for organic MDM project focused on customer management. Designed Client Management System schema for Insurance Services organization to consolidate disparate customer data sources into a single hierarchical Client Management System structure.
• Executed initial phase to define current and future states for handling of Client Management schema and extension of schema to accommodate future requirements. Presented and proposed second phase to implement and load newly designed Client Management schema. Designed and built with team of three loading framework utilizing incumbent Informatica processes as well as PL/SQL. Designed matching algorithms to associate clients from different sources and establish client hierarchies for multi-franchise and multi-line clients.
• Advised ADP on integration of new schema into existing systems and business processes.

Confidential

• Acting as interim replacement for internal staff architect advised on the architecture and development of a business analytics data warehouse based on star schemas utilizing SQL Server and Oracle OBIEE Business Analytics tool versions 10 and 11G.
• Developed new subject area star schema model to accommodate national animal health product sales and market share data across participating manufacturers. Modeled, built and loaded initial data sets to SQL Server for evaluation by internal analytics groups utilizing Tableau BI layer.
• Acted as Data Integration lead for SAP ERP implementation project. Analyzed impact of phased implementation on existing systems globally and worked on high-level strategy for replacing existing Oracle EBS feeds to consuming systems with similar feeds from SAP ECC.
• Created high-level data architecture diagrams as roadmaps for the different states of the project which involved the replacement of analytics platforms, CRM Siebel transition to SDFC and continuation of operations of Order to Cash feeds to proprietary internal direct client rebate calculation system.

Confidential

• Worked on developing changes to existing applications as well as modeling efforts on new application development. Utilized Sybase PowerDesigner 15 and 16 with CMR repository to manage Enterprise team modeling efforts.
• Reviewed Enterprise data model for re-use amongst current and future application development efforts.

Confidential

• Worked on Enterprise Data Modeling project as lead data modeler subject areas covering the legal court system, court rules and structure, attorney and law firm models.
• Attorney, Law Firm and Contact models including global addressing structures were modeled to be used as MDM data structures throughout the organization.
• Utilized Sybase PowerDesigner 15.2 modeling software and shared repository product to develop conceptual, logical and physical data models for assigned subject areas.
• Work with team to develop data modeling standards and team process workflows for model development.

Confidential

• Worked as Project Manager in Enterprise Infrastructure Services group, managed infrastructure delivery projects in GxP environment global in scope distributed amongst Swiss, India and U.S. data centers.
• Managed schedules, status, issues and resolution to ensure satisfaction with delivery commitments.
• Developed presentations for project steering committees to communicate project options, key issues and delivery performance to date.
• Working as Process Lead developed Active Visio process maps with links to Web content describing processes for execution of SR's Service Requests for internal and external clients and partners of the Enterprise Infrastructure Services group.
• Linked process maps into Internal Wiki for global publication to Novartis personnel
• Managed resources both locally and globally to affect service delivery on project deployments.
• Acted as liaison between 3rd party vendors IBM, Verizon Business and British Telecom to ensure timely delivery and adherence to agreed upon SLAs.
• Participated in project architecture reviews to assess options for upgrades for both infrastructure hardware and software components.
• Worked with off-shore resources in India providing technical assistance, reviewing and managing the development of coding, tuning and analysis efforts
• Handled application incidents determining Root Cause and developing remediation responses and solutions
• Responsible for reporting on Key Performance Indicators KPI's to management in regards to incidents processed, time required to resolve, resources utilized in process
• Developed internal group process maps with links to key internal reference material to act as a guide to affect service delivery within the group and amongst group partners.
• Managed internal projects to upgrade and enhance systems globally including network, server, SAN and database component configuration and deployment
• Developed internal process diagrams describing service delivery models for the Enterprise Infrastructure Services EIS group within Novartis.
• Acted as Application Service Manager ASM for internal Configuration Management Database CMDB application. Updated data model and architecture diagrams in Visio and data attributes in Oracle to current state. Managed releases through development QA Production environments.
• Developed Wiki based group portal for dissemination of group information and reference material regarding architecture service delivery and links to key group initiative collateral.

Confidential

• Developed data model and data architecture to support commercial multi-site content management system.
• Developed processes and code to support content retrieval and migration from Oracle data stores to SQL Server 2005 based data model and operational control structures to support on-line ordering, provisioning and control of content management system to be operated by external legal clients.
• Performed business analysis to determine requirements for supporting the operational components of the system, product feature and function mapping to product offering.
• Prepared requirement and technical documents to support the end to end data flows required by the website content management system
• Performed data analysis to determine XML content and source table mapping for building websites
• Developed XML Schemas to provide data content from Oracle to Sitecore Engine to generate WebSite content.
• Wrote PL/SQL procedures and utilized XML functions to generate XML data content to populate dynamic website.
• Became certified as a level 1 developer in the use of Sitecore product.
• Conduct project under Agile Project Management Methodology

Confidential

Technical Project Manager, Oracle Database Architect

• Managed three different software implementation projects Business Intelligence product implementation, In-Licensing management software and JD Edwards upgrade project.
• Established Oracle test, development and production environments for an electronic document management system. Utilized IBM P570 platform running AIX operating system and Oracle 10G-R2.
• Assisted in the development and execution of CSV validation tests for a GXP environment. Authored work procedures for operations shutdown, startup, backup recovery utilizing RMAN.
• Developed proposed architecture for DR utilizing Oracle Dataguard from Basking Ridge, NY to Bagshot UK data centers
• Performed project management and financial analysis of options for BI tools selection to be used in analysis of pharmaceutical trial data. Managed vendor negotiations for BI tool procurement and implementation into production environments utilizing internally as well as externally hosted architectures.
• Scanned market offerings for IT asset and change management software and managed project to implement both internally at Aspreva.
• Managed implementation of In-Licensing software for Aspreva' business development group.
• Confidential

Data Warehouse Designer and ETL Developer

• Designed Data Mart for sales force performance reporting system utilizing Erwin data modeler
• Designed and built ETL load routines utilizing Oracle 10g and PL/SQL to load performance data from SAP/R3 HR and True Comp sales compensation system
• Built data sources for Cognos BI cubes and reporting tools

Confidential

Data Warehouse Designer and ETL Developer

• Built via reverse engineering financial transaction data warehouse and enhanced data model to support new requirements of internal stakeholders and vendor, FACTSET Incorporated.
• Utilized Oracle 10G and PL/SQL to generate full and incremental load and update framework for data warehouse.
• Utilized Korn Shell scripting for process control, status and error reporting of warehousing load cycles.
• Managed vendor relationship and acted as liaison to internal stakeholders
• Utilized XSQL functionality to extract Siebel Order data to XML streams and transfer to internal clients.

Confidential

Technical Lead Project Manager

• Technical Project Manager on project to Integrate SciQuest's Higher Markets procurement system with University's legacy ERP SCT's FRS Financial Records System.
• Managed team of six IT developers
• Responsible for Technical Design of data integration layer and overall project management tasks.
• Responsible for determining architecture to facilitate data integration layer between SciQuest SQHM and SCT FRS
• Responsible for managing development efforts of MSU IT resources and SciQuest project management and technical resources
• Project components include Open VMS ISAM legacy environment, Webmethods middleware and SciQuest Higher Markets a.k.a SelectSite procurement system.
• Data Integration layer utilizing Ascential Datastage and Connx RMS file system management products.
• Communications layer utilizing Webmethods Integration Server and XML messaging.

Confidential

Data Warehouse Designer/Developer

• Designed Data Warehouse to store Historical information on Global Attorney and Law Firm spanning a 10 year timeframe.
• Developed all initial load ETL utilizing PL/SQL and 3GL routines to load extract from quarterly CD Publications spanning 10 year period.
• Designed and developed over 20 procedures and 3GL processes for cleansing, loading and maintaining data warehouse contents.
• Cleansed data to support full UTF8 character set extensions within Oracle to ensure quality Web publication capabilities.
• Designed on-going process and infrastructure to support on-going synchronization of Data Warehouse with current publication processes.
• Worked with Data Administration to tune warehouse for optimal performance.

Confidential

Data Interface Architect

• Designed Data Interface Framework to process client legacy data loads into CHIMES ERP products RPM Resource Project Management and CVM Vendor Management.
• Utilized Erwin to model, maintain and generate required data structures
• Utilized Oracle PL/SQL to develop packages and procedures to support a dynamic and data driven ETL application.
• Data Interface designed to support
• automated run control,
• Interface dependency ordering and hierarchy
• Data driven validation and processing rules
• Load progress tracking and impact
• Dynamic staging area definition and processing
• Designed multiple interfaces integrated into above framework to process client data loads into application tables

Confidential

Remediation Infrastructure and Applications Architect

• Established testing lab for 3rd party vendor Part 11 remediation solutions utilizing Windows 2000 Server Active Directory, DNS, DHCP, Netware 6.0, NT 4.0 in a Virtual machine environment based on VMWare virtual machine software.
• Established database services environments supporting Oracle 8i, 9i, SQL Server 7 and 2000 RDBMS environments for use by 3rd party remediation product solution vendors.
• Layered Oracle Enterprise Management Server functionality into existing database production environment to support performance monitoring and high availability.
• Participated in assessment of Oracle 9i RAC Real Application Clustering for future deployment into new system development projects.
• Assessed and tested remediation solutions from the following vendors:
• Velquest SmartShell for file-based and lab instrument requirements
• NuGenesis File/Print Archive solution.
• Wimmer Dacs for Excel spreadsheet remediation
• Compliance Builder for Process Control/Oracle SQL/File based applications
• Biomedion BM Windream document management system
• OFNI Systems remediation toolkit for MS-Access applications
• Cimcon E-Infotree Access module for MS Access applications
• Intellution IFIX HMI 3.0, 7.0
• Performed GxP assessments on legacy computer systems in quality, IT and Labs environments
• Performed Part 11 gap analysis assessments for various legacy systems
• Evaluated vendor Part 11 software solutions for the following types of systems file-based COTS applications Excel, MS Access, SQL Server, Oracle, IBM Mainframe and HP3000
• Made recommendations for remediation of systems based on aforementioned architectures
• Created AS-Built specifications and remediation plans for legacy systems
• Developed RTM's for existing systems in need of validation
• Developed procedures for system operation to create validation initiatives IQ/OQ/PQ for GXP systems and software.