SYNOPSIS:

• Seasoned Practice Level Portfolio Management Professional
• Information Technology Expert providing Project Management, design, development, and maintenance of applications fielded across multiple presentation platforms, including, mainframe, client-server, and internet and intranet
• Senior Business Manager having managed and supported a wide range of enterprise-wide strategic analysis including e-Commerce, Electronic Data Interchange EDI , X12 and XBRL transaction processing, Data Warehousing/Decision Support Systems
• Project Management Professional PMP Structured Analysis and programming techniques JAD and RAD analysis approaches Business Process Re-Engineering Customer Relationship Management CRM and Rational Unified Process RUP
• Industry experience includes Government, Health Insurance/Information, Banking, Mortgage Securities, and Telecommunications. Information specialties include: Financial Transaction Management and Property and Casualty Insurance Processing
• Specific Health Insurance/Information experience includes: Claims Processing/Management, Health Care Regulatory and Compliance Reporting HIPAA, Medicare Modernization Act, Medicare Part D, and local, state and federal regulations , EPIC/Health Connect for Kaiser Permanente Exam Room Computing, Telederm, Radiology, Medical Imaging, Pharmacy , Electronic Medical Records Patient Centered Medical Home PCMH Programs HR Management, Inventory Tracking, Call Center Management, and Case/Work-Flow Management
• Excellent oral and written communication skills accustomed to managing executive customer relationships, and increasing company presence and value.

TECHNICAL SUMMARY:

• Data Warehouse DW and Operational Data Store ODS Development: ETL architecture, DW standards, best practice methodologies, Source-to-Target analysis and mapping, data acquisition, data integration, ETL design, peer reviews, development, testing, service level agreements, production support, and processes to send data from DW to external organizations by SFTP.
• Data Warehouse Technical Management: Waterfall, Agile, Hybrid, methodologies, SDLC templates, Scrum and Sprint Cycle management, Earned Value: ROI, budget, communication planning, functional and technical requirements, issue tracking, risk mitigation, training plans, test plans, and 360 feedback assessments.
• Enterprise Data Management: master data management, data architecture, data modeling, data profiling, metadata definition, ontology, master data management, data encryption, data quality, data security, data archiving, object naming standards, and database administration for Oracle, SQL Server, Sybase, DB2.
• Enterprise O M Administration: acquisition, configuration, administration, security, virtualization, performance, and capacity planning, for Informatica and Microsoft Enterprise servers, UNIX ' IBM mainframes, software and hardware upgrades, anti-virus, SAN, asset management, vendor relationships, benchmarking, contract language and negotiations, co-location, ITIL service, change and problem management processes.
• Executive and Decision Support Services: Dashboard / reporting design, development, testing, security, user training, distribution, and maintenance. Design and develop Cloud software-as-a-service SaaS business intelligence analytics web based applications.

EXPERIENCE:

Confidential

Program/Project Manager

Modernize the existing FEPOC Provider Database and associated transactions allowing Blue Cross/Blue Shield Plans to improve efficiency and accuracy in the processing of all medical insurance claims, Establish consistent enterprise-wide standards for managing provider data associated with EDI Medical Claims Processing, OBRA90, OBRA93, Debarred Provider Management and Plan Provider Networks.

Key Accomplishments:

• Re-Platformed the COBOL/VSAM Provider and Debarred Database and all associated processing to a JAVA/Webservices/DB2 environment for all Blue Cross/Blue Shield BCBS Plans nationally.
• Replaced the COBOL/NDM batch processing with XML/SFTP for all BCBS Plans.
• Implemented enterprise wide standards for managing provider data, establishing an open architecture to support Patient Centered Medical Home PCMH Program initiatives for the Plans.

Environment: SQL, MS 2010 Suite, DB2,DB2,J2EE, Windows 7, Internet Explorer 9, Active Directory and OES security components, COBOL/VSAM, HP Application Lifecycle Management ALM JasperSoft ETL SharePoint. Remedy.

Confidential

Program/Project Manager

Data and Shared Services Manager responsible for Core and Initiative projects for the Corporate Data Warehouse CDW , Single Family Credit Data Mart SFCDM , F C Regulatory Reporting and Enterprise Business Intelligence Support.

Key Accomplishments:

• Delivery of L3 Core Support Platform Management framework for CDW, SFCDM, F C Regulatory Reporting and Enterprise Business Intelligence Support.
• Improved Resource Utilization across all four data platforms, improving capacity for core initiatives, while reducing core incidents.
• Implemented enterprise-wide process flows for the management of all core activities for these platforms, engaging both business and IT staff, improving customer service and continuity of information service delivery.

Environment: SQL, Solaris, Linux, MS 2010 Suite, DB2, Oracle 10, DB2,J2EE, Windows 7, internet Explorer 9, Active Directory and OES security components, HP Quality Center, Clearcase, DOORS, , SharePoint. Remedy.

Confidential

Program/Project Manager

Manage the Financial Data warehouse design, development, and integration of legacy Excelon and Constellation wholesale energy securities trading systems. Establish common enterprise accounting and financial data processing and reporting for daily, weekly and monthly management of energy generation supply and demand securities trading.

Key Accomplishments:

• Converted existing exchange and bilateral trades from Zainet to SecDb
• Deployed Megawatt-hour MWH balancing, Daily Profit Statement DPS /General Ledger GL reconciliation, and monthly Accounting Close of wholesale securities trading
• Established one set of Commercial Trading, Pricing Tools and Enhanced Valuation for wholesale trading
• Improved trade balancing and reconciliation reporting from weekly/month to daily
• Introduced Data Governance, Metadata Management, and Data Warehouse Operation and Maintenance Standards for the Enterprise.
• Scrum Sprint Cycle development and testing of Finance and Accounting Data Warehouse systems
• Consistent on time and on budget delivery for the baseline Finance and Accounting Data Warehouse

Environment: PL/SQL, MS 2010 Suite, MS SQL Server BI, SSIS, SSAS, Oracle 10, .NET, Windows 7, HP Quality Center. TFS, CVS, SharePoint

Confidential

Program/Project Manager

Provided senior management services in the design and development of enterprise application delivery executive management communication and risk management and coordination of program activities of business and technical FTEs and consulting resources

Key Accomplishments:

• Delivery of enterprise the Legacy Remediation Application Stability LRAS migration requirements, design, development and testing of Cash Manager, Electronic Default Reporting EDR , and Loss Mitigation Work Station LMWS for Offerings and Single Family Operations SFO
• Establishment and management of the legacy migration team composed of SFO business resources, business analysts and UAT test analysts, and technical staff assigned to Technology Services to successfully deliver the 4.3M LRAS migration from Gupta/SQL to J2EE
• Consistent on time and on budget delivery of the LRAS project in a very dynamic business environment with a significant amount of Federal Housing Finance Authority FHFA mandated work requiring the monitoring and management of competing enterprise application delivery schedules, and availability of Business and Technical Subject Matter Experts

Environment: SQL, Solaris, Linux, MS 2010 Suite, DB2, Oracle 10, DB2,J2EE, Windows 7, internet Explorer 9, Active Directory and OES security components, HP Quality Center, Clearcase, DOORS, , SharePoint

Confidential

Program/Project Manager

Provided senior management services in the development of infrastructure and Executive Information Systems designed to better coordinate Capital Markets and Property and Casualty Insurance information processing. North America BIM Health Insurance Practice Lead

Key Accomplishments:

• Delivered Enterprise Data Architecture EDA initiatives using SDLC, TOGAF, and PMO methodologies for Fannie Mae.
• Established and implemented a canonical data model bridging Liberty Mutual legacy data to the Guidewire ClaimCenter. Took legacy claims data platforms from Liberty Mutual's acquisitions Safeco, Wasau, Ohio Casualty amongst others , and staged them for importation into the Guidewire ClaimCenter, standardizing Liberty Mutual's claims processing using the Guidewire platform.
• Developed the Master Data Management strategy for EDA initiatives, integrating with Data Integration, Business Intelligence, Data Modeling, Data Quality, Data Governance, Security, and Meta Data Management workstreams for Farmers and CNA insurance customers
• Established Data Governance and Stewardship practices to support Enterprise Data Architectures' for OneBeacon Property and Casualty
• Enabled Predictive Analytics and Modeling to increase profitability and reduce costs and or/fraud for a variety of Property and Casualty insurance customers
• Design, development and implementation of KPI and SLA's frameworks and metrics for Enterprise and Departmental use for Capital Market and Property Casualty clients.

Environment: Guidewire ClaimCenter,, Oracle 10 OES, and OIM, Informaticata Suite Data Center, Data Governance, MDM, PowerCenter,Data Explorer MS 2010 Suite, SAS, Cognos, Microstrategy

Confidential

Program/Project Manager

Confidential served as Project Manager supporting the Kaiser Permanente Information Technology organization. He provided senior management services in the development of infrastructure and Executive Information Systems for Claims Administration for Kaiser Middle Atlantic States MAS .

Key Accomplishments:

• Developed Reporting Metrics and Monitoring capabilities for all 835 and 837 X12 claims processing between Perot Systems Diamond, MAS Health Connect MAS Encounter Processing and KMATE, Membership and Provider Data Administration.
• Architected Full Encounter Platform to support end-to-end claims process modeling and process improvement.
• Delivered a 1.9M revenue cycle initiative, matrixed between multiple Claims Administration Business SME's, 12 KPIT development staff and integration personnel.

Environment: KMATE,Epic KP HealthConnect ,MACESS, Ingenix HIMS ,Diamand,,RCA,MCL,KPEG, BETS,: Cache Mumps , Oracle, DB2, Informatica ETL Hyperion Essbase

Confidential

Program/Project Manager

Mr. Masoero served as Senior Task Order Manager/Technical Manager providing PMO and Service Level Agreement SLA and Operating Level Agreement OLA tracking and reporting services for Lockheed Martin's Enterprise Information Management and IT Tools ITAS Task Orders for the Federal Deposit Insurance Corporation FDIC .

Key Accomplishments:

• Developed Catalog of SLA's and OLA's to support upgrade of PMC Remedy 7.5 Service Level Management Module
• Developed Incident Tracking process aligned with FDIC ITIL Framework Guidelines.
• Established Incident Thresholds for problems reported by Remedy Help Desk Tickets, directing the problems to the Application Portfolio Manager for expedited resolution by the agile programming teams.
• Utilized Business Process Re-Engineering and Management best practices to consolidate and streamline redundant processes working with Six Sigma extreme and scrum programming teams
• Principal point of contact between the Lockheed Program Manager and the Team Leads 4 and Task Order Senior Staff 30 with a contract value over 15M Task Order Oversight Manager .

Environment: Windows, SharePoint, ClearConnect, HP Quality Center, UNIX, Oracle, MS Suite, ETL, ERWIN, Six Sigma, ITIL

Confidential

Program/Project Manager

Task Order Manager/Technical Manager for the Release Management Task Order at the Federal Deposit Insurance Corporation.

Key Accomplishments:

• Management and administration of the FDIC Release Management Task Order with a contract value of 12.7M, 18 Senior Staff
• Instituted strong cost and personnel controls delivering within monthly accrual amounts established jointly with the TOOM for all months during the evaluation period.
• Established Process Assessment Model to evaluate the existing Release Management Processes to best align these processes with Release Management Best Practices. Currently on schedule and within budget.
• Technical Release Evaluations were complete on average in 3.52 days using metrics developed from 7/1/2007 12/31/2007, representing 79 releases for the 6 month reporting period.
• Replaced Manual Implementation Task List Reporting with Remedy Task Order Process.

Environment: Windows, SharePoint, ClearConnect, HP Quality Center, UNIX, Oracle, MS Suite, ETL, ERWIN, Six Sigma, ITIL

Confidential

Program/Project Manager

Task Order Manager to integrate business process modeling with data modeling, with the intent of improving governance and decision making with respect to data.

Key Accomplishments:

• Developed a data modeling method for the use by Fannie Mae's Data Stewards. This method defined the concepts, example artifacts and best practices for the Data Stewards and served as an integration point for other Fannie Mae business and IT personnel as well.
• Defined guidance and best practices for Fannie Mae's Data Stewards rolled up to include the Fannie Mae's Enterprise Data Stewardship Group consisting of the Data Stewardship Council, the Domain Data Stewards, and the Enterprise Data Steering Committee. Interaction with the Enterprise Data Stewardship Group was a regular requirement for completing the work the Lines of Business Single Family, HCD, Capital Markets, BA D, and Finance were consulted to confirm the utility of the methodology
• The Fannie Mae Unified Business Architecture, Lean Six Sigma, and work done to date on the Fannie Mae Corporate Data Dictionary and Enterprise Metadata Repository were leveraged extensively as part of this effort.

Environment Applications: DB2, Oracle, Business Objects, SAS, Cognos, Embarcadero, ERwin, Oracle Financials, Ab Initio, Crystal Reports

Confidential

Program/Project Manager

Program/Project Manager for Corporate Trust Services. Collateral Risk Management and Investment Reporting CRM/IR Data Warehouse

Key Accomplishments:

• Established business information and functional processing surround all aspects of mortgage and asset backed securities, including all servicer and loan accounting processes, master servicing, and bond administration associated with mortgage and asset securities management.
• Implementation of the CRM/IR subject areas and the roll-out of an enterprise information reporting capability using Business Objects XI over 18 months with a budget of 10.9M and a staff of 15 FTEs and 5-10 consultants further aligned with Corporate PMO Governance given Tier 1 mission critical status.

Environment Applications: DB2, Oracle, Business Objects, SAS, Cognos, Oracle Financials, Ab Initio, Data Stage, Crystal Reports, Microstrategy

Confidential

Data Warehouse Program/Project Manager

Lead Project/Program Manager, assigned to the Mid-Atlantic States MAS Region Information Management IM department.

Key Accomplishments:

• Delivered Data Warehouse/Data Mart/Operational project and staff management for all investment and operations projects that are assigned to the MAS IM staff of 10 with an annual budget of 2.6 million.
• Established and managed the Business Infrastructure Health Plan Employer Information Data Set HEDIS , Maryland Health Care Commission MHCC , Risk Assignment Tracking System RATS , and Decision Support System DSS , FTE and MGMT Essbase Cubes Health Plan Operations Hospital In-patient Tracking System HITS , Other Party Liability OPL Claims and Inpatient Essbase Cubes Johns Hopkins Call Center Surveillance JHCC Triple Tier Point of Service/Flexible Choice 3TPOS Care Delivery Care Management Institute CMI Reporting, Clinical Quality Care Scorecard, Chronic Disease Registry Reporting KPIT MAS Core MSM to CACHE Conversion, Monthly Data Warehouse Loads, Daily Operational Data Store Loads, Clinical Operational Data Store CODS load, Computer Associates Advantage Repository for Distributed Systems CAARDS Metadata Conversion.
• Implemented Medicare Part D as part of the Medicare Modernization Act established a data mining effort to optimize Medicare encounter submissions for the Kaiser National Program office estimated to recover 2 - 6 million in eligible Medicare claim encounters per region that are not being received from Medicare.

Environment: Applications : KMATE,Epic KP HealthConnect ,MACESS, Ingenix HIMS ,Diamand,,RCA,MCL,KPEG, BETS,: Cache Mumps , Oracle, DB2, Informatica ETL Hyperion Essbase

Confidential

Senior Business Manager

Senior Business Manager for Destiny Health, LLP, a health insurance provider based in Bethesda, MD.

Key Accomplishments:

• Delivered Strategic Analysis and Enterprise Project Management for HIPAA EDI Processing Automatic Health Claims Adjudication, Enterprise Data Warehouse and Data Mining, and all Vendor Management.
• Developed and implemented Automated Claims Processing, EDI enabled XML forms processing, and Operational Data Store development to expand the health insurance e-business portal Destinyhealth.com.
• Completed RAD/JAD sessions with Business Unit Executives, and coordinating with the IT department to successfully deliver EDI forms processing, and established an Operation Data Store Warehouse.

Confidential

Senior Principal Consultant

Senior Business Manager for the e-commerce division of First Union Bank District of Columbia Office of the CTO DIGEX, Inc., and Blue Cross/Blue Shield of Maryland

Key Accomplishments:

• Delivered First Union Electronic Statements production for the e-Commerce division, providing a scalable, electronic statement capability for all of the FUNB internet products for the FUNB enterprise utilizing Mobius, WebSphere, and Vignette
• Implemented Enhanced Fraud Detection, focusing on the e-Channel electronic fraud detection for On-Line Banking, consumer ACH processing and Wire transfers.
• Established vendor evaluation criteria, and business logic to mitigate the potential for electronic fraud in a DB2, MQSeries environment.
• Project Manager for a Data Warehousing/Decision Support System for the District of Columbia's Office of the Chief Technology Officer managing the operation of a team of 12 data warehousing specialists, providing delivery of Logical Design, DSS/DW Design and Construction, Technical Implementation, Enterprise Architecture, and Quality assurance and Testing activities for this enterprise intranet data warehouse using Cognos, Prism and Oracle 8.
• Led the Program Management Office at DIGEX coordinating the Y2K assessment, testing, and remediation, activities for the Web Farm internet service components including servers, firewalls, and network enterprise software, Internet Backbone components including routers, hubs, and telecommunication switches.
• Provided corporate Year 2000 strategic planning, client corporate communications management and support, and corporate Year 2000 strategic planning, client corporate communications management and support, and served as liaison between the Project Office and BCBSMD Year 2000 Steering Committee and Business Managers.

Confidential

Senior Consultant

• Directed development and maintenance of the corporate data warehouse/data mart model, dedicated to the management of the data warehouse and data marts in a DB2 environment.
• Instrumental in assisting the client's evolution from using a data warehouse to the use of mufti-dimensional data marts.
• Developed the technical architecture for the NIH Data Warehouse using Prism Data Warehousing tool suite, Bachman Groundwork's and Terrain Tool Suite.

Confidential

Senior Systems Analyst

Mr. Masoero was assigned as a Senior Systems Analyst to the U.S. General Service Administration, U.S. Department of Labor, U.S. Department of Energy, and the General Accounting Agency.

Confidential

Senior Analyst

Mr. Masoero served as a Senior Analyst for database development and management of political campaign contributions and direct fundraiser activities.

Confidential

Director of Computer Operations

Mr. Masoero was responsible for database management for a congressional election campaign.