Data Warehouse Architect Resume
Washington, DC
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.
EXPERTISE AREA:
- 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 SKILLS:
Technical Expertise:Data Warehouse, ETL, BI, DSS, Oracle, Netezza, Informatica
PROFESSIONAL EXPERIENCE:
Confidential, Washington, DC
Data Warehouse Architect
Responsibilities:
- 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:
- 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:
- 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:
- 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 DDL scripts.
Confidential, Columbus, OH
Data Warehouse Architect/Modeler
Responsibilities:
- Provided key recommendations for ETL/Data Warehouse architect solutions.
- Supported data modeling for ODS and data warehouse, including data distribution keys and statistics to enhance performance.
Confidential, Charlotte, NC
Data Warehouse/ETL Architect
Responsibilities:
- 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.