SUMMARY:

20+ - year track record for managing high-level data, software and technical development projects in competitive markets.Highly skilled and experienced data warehouse architect and software engineer with proven success leading high-level projects through all phases of development. Adept at leading and managing data conversion teams to ensure top-tier accuracy, quality and performance. Proven enterprise data warehouse design (dimensional/normalized model) and architecture skills on high-profile projects aligned with key business goals.

AREAS OF EXPERTISE:

• Data Warehouse Management, RDBMS, Object Oriented, Web Programming meta-data management, Oracle, Netezza appliance solutions, Big Data, Commercial Off-The-Shelf (COTS) software for Extraction Transformation and Loading (ETL) of data
• Team Leadership, Project Management, Strategic Planning & Analysis, Problem-Solving

TECHNICAL PROFICIENCIES:

Technical Expertise: Data Warehouse, ETL, BI, DSS, Oracle, Netezza, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Data Warehouse Architect

Responsibilities:

• Performed high-level data analytics and financial economics projects while defining best practices and implementing standardized process improvements.
• Gathered data requirements, developed template documents, data dictionary, dimensional data model and operation’s manual documents to streamline processes across all levels.
• Successfully developed and launched the Home Mortgage Disclosure Act (HMDA) while leveraging shell scripting, nzload, nzsql and stored procedures.
• Expertly utilized agile and hybrid development methodologies to define process flows.
• Lead design review sessions with technical and SME teams to enhance best practices.

Confidential, Herndon, VA

Data Warehouse Architect

Responsibilities:

• Served as expert advisor for all data architecture best practices, including the development of Enterprise Data Warehouse(EDW) POC as part of an Enterprise Data Integration (EDI).
• Managed all aspects of the EDI, including technical infrastructure, data, ETL, BI & metadata to deliver optimal results aligned with business and technology goals.
• Successfully trained and supported teams for all environments DEV,SIT,UAT,PERF,PROD to ensure streamlined processes and transitions.
• Designed and launched an ETL framework flexible, scalable and adaptable to boost enterprise growth.
• Automated load processes using shell scripts, autosys, database and ESB messaging.

Confidential, Silver Spring, MD

Tech Lead/Data Warehouse Architect

Responsibilities:

• Worked closely with Project Managers and leadership to manage key technical resources and achieve all project milestones wtihin strict time and quality standards.
• Served as expert contact to mentor and lead technical teams with all design and development methods and best practices.
• Demonstrated exemplary technical agility and leadership while leveraging resources, including Netezza, Informatica 9x, Unix/Linux, Autosys, Oracle 12c, Mainframe, Aginity,Toad.

Confidential, Bethesda, MD

Data Warehouse Architect

Responsibilities:

• Supported Sales Revenue Warehouse architecture, reports and sql performance tuning to enhance efficiency and technical agility aligned with business goals.
• Resolved key technical issues and implemented enhancements for ETL scripts using nzsql & shell scripting.
• Utlizied Netezza, Informatica 8, Cognos, Unix, Windows and Toad to achieve all project goals.

Confidential, Little Rock, AR

Data Warehouse Architect

Responsibilities:

• Supported SPP data warehouse development and ETL architect while providing expert recommendations on Netezza administration, configuration and best practices using Informatica and shell scripting.
• Designed metadata repository and library of functions to share across subject areas.
• Served as key contact to support teams in Netezza and Informatica processes.
• Collaborated with the Business Intelligence architect to assist in metadata, data availability and testing.
• Contributed key dimensional data modeling and database objects from logical model and Confidential scripts.

Confidential, Columbus, OH

Data Warehouse Architect/Modeler

Responsibilities:

• Served as data warehouse architect and expert advisor for a data foundation initiation for Confidential and data warehouse.
• Supported all aspects of development, testing, production and backup/recovery to deliver optimal results.
• Assisted ETL team with data load performance and all technical issues.
• Leveraged Netezza, Oracle 10g, Informatica 8, Unix, Windows and WinSQL to achieve project goals.
• Provided key recommendations for ETL/Data Warehouse architect solutions.
• Supported data modeling for Confidential and data warehouse, including data distribution keys and statistics to enhance performance.

Confidential, Charlotte, NC

Data Warehouse/ETL Architect

Responsibilities:

• Key contributor to the Customer Value Creation migration project to Netezza from Oracle RAC, including development and launch of databases for UAT, QA, DEV and production environments.
• Performed performance tuning, system monitoring and maintenance, security processes and utilities scripts to enhance operations.
• Provided high-level production support to on-shore and off-shore teams to boost performance across all levels.
• Collaborated with ETL developers on technical solutions, developmental strategies and recommendations for Netezza and ETL architect innovations.
• Developed and launched the Proof of Concept for the Campaign Management data mart.