PROFESSIONAL SUMMARY:

• I am a seasoned IT leader with hands on experience in the full software development life cycle on large projects and a proven track record of being a results oriented and creative problem solver. I focus identifying the critical problem definition, goals and objectives to deliver value added business change.
• Extensive experience and success with PMBOK practices through Initiation, Planning, Execution, Control, and Closing out projects
• Multiple successful projects charted with Migration of Legacy data systems to modern source systems
• Experience overseeing the core department and technical project budgets for a large team of onshore and offshore resources
• Multiple engagements establishing and working through AS-IS and TO-BE transitions paths
• Implementation success in large scale projects designing and deploying based on strong data governance, central master data management, metadata, broad sets of data interfaces and managing these with a Service Oriented Architecture SOA
• Broad and deep hands-on experience designing large scale data management solutions using Oracle in a Linux based environment and implementing Extraction, Transformation and Load ETL best practices
• Hands-on experience in Enterprise Data Warehouse design, Data Architecture, Data Modeling, Data Marts, Logical and Physical Data Models, Extraction Transformation Load ETL processing
• Project management for PEGA application delivery and production support for Front Office and Back Office Business Process Management BPM modernization
• Effective explaining Technical Concepts to audiences at executive management and technical levels
• Successful track record coaching and mentoring project team leaders and developers
• Creative at staff augmentation focusing on budget and schedule containment
• Demonstrated successful partnerships with software vendors and large consulting firms

PROFESSIONAL EXPERIENCE

Confidential

Manager, Information Technology

• Managed the delivery and improvement of advanced technology solutions utilizing internal resources proficient in Oracle, DB2, PEGA PRPC, Java, Web Services, and mainframe technology.
• Accountable for the delivery of multiple software projects from inception through post implementation including the project estimates, forecast / estimate to completion, variances, and status reporting.
• Promoted to lead the Benefit Solutions department consisting of 15 permanent employees include project leads and up to 40 onshore offshore resources.
• Delivered new functionality for managing the business process workflow of Client and Product data in the Integrated Customer Information System ICIS Master data repository.
• Delivered the performance improvement, stabilization and defect containment of the FLoW First Line of Work workflow PEGA application to enable roll-out. This application enables customers to manage and streamline their workload spanning Sales, Client setup, Benefits
• Delivered the addition of Oracle, PEGA PRPC, and DB2 service software components for new ASP/BPO business
• Delivered additional Medical Claims Benefit data analysis tools to increase re-use, enable mass updates of data, and eliminate redundant objects for benefit coding.
• Delivered the data model and ETL into systems test for the creation of user efficiency and business process efficiency statistics, to lay the foundation for predictive modeling and a focus on 'high performance' relative to the Sales through Client / Member go-live commitments
• Built two highly performing teams that exceeded SLAs for Customer Satisfaction including problem ticket resolution, batch process success, Quality defect reduction , and cost containment.
• Reduced operating cost of PEGA PRPC project leadership team by 66 while simultaneously building an internal project team that currently supports critical ASP / BPO business partner and process roll-out
• Established resourcing plans that created a unit labor cost run rate up to 30 below IT billable rates.
• Created a supportive team environment that was defined by collaboration and knowledge sharing
• Delivered 3 projects in the CIO Advisory forum that leverages leadership resource to sponsor and implement projects of positive change and growth for the IT organization

Application Developer Lead, Product / Confidential

• Requested by management to accept a technical project and resource leadership role
• Facilitated Use Case requirements analysis, design, development and implementation of software in a Service Oriented Architecture SOA for a major system transition of legacy mainframe applications to state of the art technologies
• Built a large scale data conversion from an Oracle 10 database with Customer Product Codes into the Integrated Customer Information System ICIS Oracle DB to establish a single source of truth for Benefit provisions
• Partnered with the business, Accenture consultants, and technical leadership to meet strategic goals
• Hands on work with Oracle PL/SQL, SQL, Linux, and software configuration management tools.
• Established resource plans and work breakdown structures for projects involving Oracle and DB2 database structure design, data service development and data migration
• Highmark lead for onshore and offshore development team producing SOAP an REST base Web Services.
• Continued as subject matter expert for applications developed and deployed by my team

Application Architect, Enterprise Data Warehouse, Confidential

• Led all aspects of new database table design and changes from inception through post implementation for the Enterprise Data Warehouse on the TERADATA and Oracle platforms
• Facilitated design and modeling sessions to drive solutions for new phases of the EDW including the Extraction, Transformation, and Load ETL processes
• Implemented repeatable, iterative processes for managing the database changes across 6 different environments and over 50 project related changes at a time, improving efficiency, quality, and flexibility in the development life cycle

Enterprise Data Warehouse EDW Consultant, Confidential

• Design, development, and implementation for Claims Billing System interfaces to the EDW
• Created and documented repeatable processes for managing changes to the Oracle and TERADATA databases
• Research and implement database security solutions for design challenge facing the ETL team

Confidential

Data Warehouse Architect

• Developed business intelligence solutions for the corporate DW using Oracle 9i technologies and COGNOS Multidimensional Online Analytical Procession MOLAP technologies
• Lead the evaluation of Oracle Warehouse Builder and recommendation for a cost benefit analysis on ETL tools
• Created and Maintained Oracle objects PL/SQL Packages, Materialized Views, Views, Indexes

Confidential

Supervisor - Business Intelligence BI Data Warehousing

• Defined the project vision and scope through collaboration with end users and systems analysts
• Provided work breakdown structures, key milestones and detailed plans for all Data Warehouse projects
• Established and maintained resource plans to balance resource assignments between projects
• Reviewed business requirements for source systems and defined strategies for data warehouse integration
• Supervised the production support of the ETL processes. Included hundreds of daily, weekly, and monthly jobs
• Supervised the OLAP help desk for the entire user community
• Sustained Service Levels for posting of Daily Sales at 100 availability before 8 a.m.
• Follow up on support issues and assigned responsibility to staff for resolution
• Set Goals for the team members and delivered performance reviews
• Performed all staff and administrative duties including interviewing and hiring recommendations
• Maintain intranet site to publish metadata about projects and new data available

Confidential

Consultant - Distributed Software Solutions

• Executed the proof of concept POC phase, including the installation and configuration of application, database, and system performance monitoring software
• Addressed RFP and RFI questions and delivered organized, well documented, packaged proposals.
• Provided customized software demonstrations and presented findings to senior management and technical personnel systems administrators, network engineers, and database administrators

Confidential

Consultant - Data Warehouse Architecture

• Gathered data requirements for over 10 application groups in Boston and Washington D.C
• Integrated data requirements for financial, HR, and security systems
• Created the project plan from requirements through implementation, using Microsoft Project
• Managed the meta-data repository to track requirements through multiple systems
• Defined the architecture and migration plan for data transformation to the Operational Data Store ODS

Confidential

Technical Lead - Data Architecture and Services

• Promoted to lead a team of software engineers building the new US Coast Guard Incident Management system
• Delivered presentations to admirals and captains for status and to determine project strategies
• Developed full life cycle Microsoft Project plans work breakdown structure and resource plans
• Commercial off the Shelf COTS deliverable was recognized as a standard by the US Dept of Transportation
• Developed and deployed the Executive Information System using SAS on UNIX
• Prepared a training plan and conducted customer training sessions during the prototype deployment
• Established standards and procedures used to produce the database development artifacts