Responsible for the architecture and development of the data solutions in the areas of Data Warehousing, Master Data Management, Data Quality, Operational Data Store and Metadata Management.

• Managed team of DW professionals covering Architecture, Development, and Production Support• Performed Data Architect role through the modernization of several legacy applications and a major corporate divestiture. Designed a multi track DW Divestiture Strategy focused on infrastructure, data, and Business Intelligence reporting.• Developed a Data Strategy and Implementation Roadmap to integrate data from several transaction systems into an Operational Data Store (ODS) in support of Real Time access to customer data, significantly improving the customer care experience.• Performed Data Architect role on several reporting initiates including Sales Performance Reporting and Document Management Workflow Tracking. Maintained data model and supporting documentation in Erwin / ER Studio.• Introduced and enforced DW Data and Database Standards regulating entity/attribute naming conventions and metadata, data types, and domains, and ETL Standards intended to improve coding efficiency, integrity, understandability, and supportability.• Designed and implemented Data Security Governance Strategy intended to meet restrictive Government compliance requirements. Evaluated Data Masking technologies as a method to implement a secure on-shore/off-shore augmentation model.

Data Architecture Role supporting both Data Warehouse and Operational Systems Development• Legacy system modernization effort - redesigned database structures, performed legacy data quality assessment, documented data migration / transformation specifications, and provided oversight to ensure adherence to design specifications• Data Warehouse – performed current state assessment and delivered future state architecture recommendation. Lead Architect integrating Sales data into customer centric DW.• Developed Data and Database Standards document intended to regulate entity/attribute naming conventions and metadata, data types, and domains across RDBMS.• Developed a customized Data Strategy and Implementation Roadmap. Areas of focus included data governance, development best practices, data track implementation methodology process flows, supporting technologies, and implementation plan.

Served in several roles throughout tenure from DW Solutions Architect, ETL Developer, to Manager of DW & DB Applications.• Managed DW and DB Application Development teams, 4 and 6 employees respectively, with the goal of optimizing quality of the companies data asset.• Coordinated efforts between front and back-end application developers in order to implement source system operational procedures focused on data quality.• Actively participated in the redesign of legacy database structures, introducing normalization concepts and identifying opportunities for data integration. Coordinated efforts of DB application developers to phase in changes to legacy systems while minimizing impact to existing front-end and back-end processes.• Developed the business and technical specifications for a Campaign Management solution used by the Sales and Marketing organizations to track customer contact initiatives. Evaluated several implementation strategies including in-house, outsourced, and hybrid solutions. Developed and issued a Request for Proposal, evaluated proposal responses, coordinated software presentations, technical reviews, and proof of concept sessions for finalists, and issued a final product recommendation to stakeholders. • Worked closely with Director to define the enterprise direction for the Data Warehouse and guiding the team toward achieving defined goals.• Supported end user data and reporting requirements through a centralized customer-centric data warehouse.• Managed the selection and rollout of a BI Tool accessing the Data Warehouse.• In the role of ETL Developer / Team Lead, developed and maintained the Extract, Transformation, and Load (ETL) processes used to migrate data into the customer centric DW using Informatica PowerCenter.• Administered the Informatics Server (on UNIX) and metadata repository that includes development and maintenance of global and local repositories, folders, permissions / privileges, and metadata reporting.

• Supported the ETL process for a centralized corporate data warehouse and associated data marts. The data warehouse consists of a normalized atomic layer projected to store 700 GB of current and historical data (Oracle 8i RDBMS on UNIX). The atomic layer then sources the Sales and Marketing dimensional stars projected to store 300 GB of aggregated decision support information (Oracle 8i RDBMS on NT). • Developed an implementation methodology used to standardize development of Type I and Type II update strategies and slowly changing dimensions.• Developed and implemented business transformation and data migration processes for each layer of this multi-layered data architecture using Informatica PowerCenter and PowerMart. Responsible for ETL process automation, performance optimization, job scheduling and recovery.• Performed data validation at each level of the data warehouse using Oracle SQL Plus, Oracle Enterprise Manager (OEM), and Embarcadero DB Artisan.• Administered the server and repository components of Informatica PowerCenter which includes development and maintenance of global and local repositories, folders, permissions / privileges, and metadata reporting. • Performed a lead role for an ETL group consisting of 4 developers. Responsible for task assignment and knowledge transfer.

• Support end user data requirements on data warehouse initiatives. Identify business requirements, design supporting dimensional star schemas, identify and map source data, define transformation logic, and define aggregation requirements. Maintain data model with supporting documentation in Erwin V3.5.• Designed departmental data marts satisfying decision support needs including Investor Reporting, a web-based investment portfolio reporting application and Valuation Management Reporting, a property valuation tracking implementation. Managed the extraction, transformation, and load processes targeting Sybase and Oracle databases. • Managed the selection of an Extract, Transformation, and Load (ETL) tool to support both data warehouse and production data migration processes. • Supported the selection of enterprise standard Business Intelligence and Report Writing tools. Identified and documented tool requirements in support of business needs, developed a proof-of-concept scenario, conducted vendor software presentations and technical evaluations, and issued final product recommendations.• Involved in the development of corporate data and database standards intended to regulate naming conventions, data types, and domains across several database platforms including Sybase, Progress, and Oracle.• Managed the development of a PowerBuilder application used to enable previously unsupported reporting relationships.

Served in several roles including Human Resource Staff Analyst, DW BI Tool Administrator, Data Administrator / Modeler (both DW and OLTP implementations)Accomplishments - • Supported the development effort of several reengineering applications.• Developed a process flow for the Information Resource Management organization, which streamlined the departmental workflow and defined roles and responsibilities for Data Administrators and Database Administrators supporting OLTP initiatives. • Developed methods and procedures used in standards enforcement. Developed departmental procedures used to complement and support the existing systems development methodology.• Supported end user data requirements on several data warehouse initiatives.• Defined and maintained Data Warehouse procedures, guidelines and standards. Developed a process flow in support of the Data Warehouse infrastructure, which streamlined the workflow of decision support requests through all phases of the development lifecycle.• Managed the selection and rollout of Business Intelligence Tools accessing the Enterprise DW. This included developing and issuing a Request for Proposal, proposal evaluations, managing vendor presentations and technical reviews, administering reference checks, and issuing final product recommendations. Designed and conducted BI Tool demonstrations to prospective internal DW stakeholders.• Supported Human Resource organization through decision support analysis in the areas of compensation, attrition, performance, and workforce analysis using QMF/SQL, Easytrieve, SAS and COBOL. Designed, implemented and maintained Decision Support System (DSS) DB2 databases. Designed and conducted training courses for technical HR analysts.