SUMMARY:

• A pioneering IT professional, Program/Project Manager and Architect with a broad set of Business and Technical Interafcing/Analysis, Project Management, Audit, Business Intelligence, and Enterprise Wide Data Warehouse skills, technology experiences, and “Big 4” consulting experience
• Worked effectively with project teams, stakeholders/sponsors, business/functional leaders, and senior management
• Worked with business SME’s and technology leaders in setting priorities and developing short and long term roadmaps to align with corporate initiatives
• Planned and managed large scale (multi - million dollar) projects based upon many flavors of IT project management methodologies - Waterfall, Agile, Sprint, Iterative as a Program/Project Manager with PMO organizations - 15 years
• Developed project plans, budgets, risk & mitigation plan which aligned with PMBOK functions, steps, and guidance
• Provided BA and PM mentor guidance
• Architected Enterprise-wide data warehouses (Global Systems) for multiple industries and domains such as Claims/Eligibility/Provider/Plan, Supply-chain, Enterprise Assets and ERP, HR, Sales & Marketing, Workflow, Visa, and Bank, Property & Casualty (Loss, Risk, Market Potential, Fraud), and Insurance Commission
• Managed Business Intelligence system development and roll-outs across multiple environments - DEV, UAT, PROD
• Managed Enterprise releases, coordinated and conducted Release command Center meetings
• Organized and conducted testing for re-plat formed server environments for integration and Disaster recovery tests
• Established relationships with business managers and technology managers for the purpose of advancing team and project goals
• Manage multiple vendor and managed services engagements for development and support capabilities involving on-shore and off-shore models
• Assisted with business stakeholders in setting priorities and developing short and long term roadmaps to align with corporate initiatives
• Project management for Healthcare claims, benefits, provider, and payer domain and HIPPA compliancy
• Managed multiple projects, developers, business analysts, data modelers, database administrators, network administrators, and web developers for BI, Data Integration, and EDW projects along with green field Data Warehouse
• Data Architecture and Data Modeling for Data Integration, EDW, BI, and MDM solutions - 20 years
• Managed project involving User experience design and User interface design (UX/UI) - 10 years
• Cobol mainframe project management and application development
• Managing projects implementing enhancements for a ServiceNow application to route trouble/incident tickets to various project, development, and testing groups for tracking and resolution

TECHNICAL SKILLS:

Technology: Unix, DB2, UDBEEE, Oracle, IMS, VSAM, SQL Server 2008/2010, SSIS, CICS, Informatica 6.2, 7.2, 8.2, Oracle Warehouse Builder (OWB), Oracle OBIEE, Business Objects 5.0, 6.1, and XI, ERWIN 7.3,Case tools, TCP/ISPF, FTP, Toad, SQL, PL/SQL, Cobol II, Assembler, HTML, Unix ScriptingSharePoint, Cognos, Qlikview, Web Servers, Database Servers, and IBM Mainframe

Other Tools: Project Workbench, and Confidential Excel, PowerPoint, Visio, Project Manager, Word, Access

PROFESSIONAL EXPERIENCE:

Confidential

Project and Program Manager

Responsibilities:

• Project/Program Management within the centralized PMO - directing both onshore and offshore resources - infrastructure and software development and releases for EDW, BI, and Data Integration with Cognos and Qlikview - Global Risk Aggregation (Insurance), Property & Casualty Risk, and Regulatory Reporting
• Managing Dev/SIT/QA/UAT/Production deployments and coordinating resources - onshore and offshore
• Managing server configurations and commissioning, budgeting, and decommissioning
• Migration of ETL, Reporting, and Web apps from POC servers to standardized IBM and windows servers
• Managing user provisioning for all environments
• Managing and coordinating ETL Developers, BI Developers, and DBA - technical staff functionality
• Managed (UX/UI) design for Qlikview web apps

Confidential

Project & Release Manager

Responsibilities:

• Program Release Manager within the PMO - directing both onshore and offshore resources (40+) - software development and releases for BI and Data Integration projects for Informatica and Business Objects - Regulatory Reporting
• Managing Dev/QA/UAT deployment to final Production and coordinating onshore and offshore resources
• Project Management using Agile Methodology used during development, testing, and implementation of strategic and supportive code
• Reporting to Executives on development and release from DEV/UAT to Production for financial feeds in the Global Warehouse for consumption by internal Confidential personnel and external partners. Enhancement and maintenance of 4 major data warehouse systems covering over 500 million in asset transactions per week.
• Setting up Sharepoint Application Registry for UAT projects

Confidential

Senior Project Manager

Responsibilities:

• Project/Program Management within the PMO - directing both onshore and offshore resources (40+) - $3M project
• Reporting to PMO and Executive on Customer data migration effort from a legacy EDW system (DB2) to a
• Integration Customer Data Warehouse (ICDW) - Financial and Regulatory Reporting
• Project Manager - directing both onshore and offshore resources (40+) - infrastructure and software development and releases for BI projects/Data Integration with Cognos
• Managed (UX/UI) design for web apps
• Project Management using Agile Methodology and Waterfall Methodology used during development, testing, and implementation of strategic and supportive code

Confidential

DWBI & PM - Associate IT Director

Responsibilities:

• IT Director for 5 clients averaging 35-60 consultants per client and $5M projects each
• Project/Program Management within multiple client PMOs - directing both onshore and offshore resources (40+) - infrastructure and software development and releases for BI, Data Integration, and EDW systems - Informatica/Data Stage/Cognos/Business Objects
• BI Assessments and Metadata Strategy Roadmaps - Datawarehouse (ODS/EDW/DM) Informatica and SQL Server 2008 for MDM solutions
• Assessment of entire DW infrastructure and capabilities for identifying increased performance and scalability
• Creating Reporting Data Store (star schema) vendor feed infrastructure that allowed for metadata tables resulting in consolidation of vendor data and reducing redundant build-out of vendor packages
• Managed (UX/UI) design for web apps
• Project Management using Agile Methodology and Waterfall Methodology used during development, testing, and implementation of strategic and supportive code in ETL and components of Microstrategy

Confidential

Technical Program Manager (FTE)

Responsibilities:

• Creation and deployment of Premier Field Engineering (PFE), SR Wellness, MS Voice for executive reporting and cubes - Global Consumer Relations Management system using Confidential Dynamics CRM 2011, SSIS, and SSRS
• Project/Program Management - directing both onshore and offshore resources (40+) - software development and releases for BI projects/Data Integration with SSRS
• Managed (UX/UI) design for Confidential web apps
• Development of new staging and data mart for PFE reporting under a MDM solution base
• Included data modeling, coordination of off-shore developers, status reporting to Portfolio Management (CSS)
• Release management for quick fix enhancements (QFE), monthly customer requests (CR), daily and weekly service requests (SR)
• Project Management using Agile Methodology and Waterfall Methodology used during development, testing, and implementation of strategic and supportive code
• Creation of the Data Warehouse Architecture on a SQL Server platform

Confidential

Technical Program Manager

Responsibilities:

• ETL Architecture and Governance - Payroll and Benef Confidential - Global Consumer systems
• Data Governance, ETL migration procedures, UAT testing and Production deployment
• Executive Strategy Analytic Management Systems and Subsystems - Project and Program Management (EDW and Cube Analytics) - entire US Navy
• Labor - Direct and Vendor (OLTP to EDW) - Naval Logistic and Ships
• Labor Availability - Billet, Ship transfer, Position Transfer, and Grade Promotion
• Change management for EDW and analytic cube per bi-monthly roll-outs to production
• Work with data architects, database administrators, networking administrators, and data transmission administrators on upgrades (VOIP, Oracle, SQL Server, LDAP, and web portal)
• Project acceptance and closure validation with Confidential executives and US Navy commanders

Confidential

Technical Consultant Manager (FTE)

Responsibilities:

• Technology Architect: Hardware Infrastructure, Web and ETL applications, Dashboards, and Data Warehouse RDBMS, Decision Management and Support systems and MDM systems
• Data lifecycle management architecture and design for backup/recovery, disaster recovery, storage planning, and data retention policy
• Project Management within multiple client PMO using Agile Methodology and Waterfall Methodology - SDLC
• Project/Program Management - software development and releases for BI, Data Integration, and EDW with Informatica (ETL), Cognos and Business Objects
• Managing Cobol developers

Confidential

Technical ETL & Data Architect

Responsibilities:

• Client: Farm Bureau - Insurance, Re-insurance and Sales Analysis - Consumer systems (reporting and web portal)
• Technology Architect: Hardware Infrastructure, Web and ETL applications, Dashboards, and Data Warehouse RDBMS, Decision Management and Support systems
• Environment: IBM P595 (2) 32-bit servers AIX 5L Version 5.3 with four logical partitions per server, Red hat Linux operating system. ETL applications were Informatica 7.2 with Powercenter, Power Connect, and Power Exchange. Data modeling tool was Erwin.
• Strong ETL experience with data extraction, transformation, and load into target data stores
• Heavy systems integration testing across multiple corporate business units
• Data integration via ETL - combining data from disparate sources and platforms, plus heavy systems integration (UNIX, SQL server, external vendor feeds) also managing Cobol developers
• Data lifecycle management architecture and design for backup/recovery, disaster recovery, storage planning, and data retention policy
• Project Management using Agile Methodology and Waterfall Methodology - SDLC

Confidential

Technical Program Manager & Data Warehouse Administrator

Responsibilities:

• Global Application Program - Truck Sales and Marketing, Inventory, Plant Logistics, Truck Delivery Logistics, Workflow (ERP) for truck manufacturing, and General Ledger/Accounting - Business Analysis and IT development activities
• Technology Architect: Hardware Infrastructure, Web and ETL applications, Dashboards, and Data Warehouse RDBMS, Decision Management and Support systems
• Developed ETL build schedules that incorporated sales information, truck scheduling, vehicle tracking, and parts inventory demand and supply levels. For over 4 years, also responsible for directing the activities of the DBAs for the mainframe, data warehouse, and SQL Server environments. This included all migration and performance monitoring of ETL applications.
• Worked as a Data Warehouse Administrator and was responsible for all scheduled rollouts of new applications across multiple platforms.
• DB2 UDB - determine partitioning, and indexing. Monitoring query and parallel processing performance. Identifying bottlenecks in ETL processing
• Strong ETL experience with data extraction, transformation, and load into target data stores - Informatica
• Design and implementation of data warehouse structures, workflows (conceptual, high-level, and detail), and all operations of the data warehouse data management system - data warehouse administrator
• Data lifecycle management architecture and design for backup/recovery, disaster recovery, storage planning, and data retention policy
• Design, implementation, and operation of Informatica 7.2 and DB2 UDB data management system