999 Main Street
Any Town, NY 99999
999-999-9999
email@gmail.com

Brett Perry

Data Warehouse, ETL Architect and Software Developer.

Summary of Qualifications:

Over 10 years of software development experience, mostly focused on data. Have a Bachelor’s of Science in Computer Science. Have designed and implemented data warehouses using custom coding as well as with ETL tools. Experience developing front end applications, BI reporting and database administration. Have worked with Oracle and other databases.

Informatics:

• Two years of Informatics Experience.
• Experience with Power center Designer, Work flow Manager, Repository Manager, and Admin Console, Data Analyzer, and Meta data Manager.
• Informatics installs upgrades, administration, and maintenance. Oracle repository creation and maintenance.
• Correct issues and bugs through.
• Creation of Informatics database source and target connections, folder management, and deployment of objects to and from development, QA, and production repositories.
• Scheduling of work flows and after hour support.

Data Warehousing And Architecture:

• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Developed address data hygiene system that utilized post office standards; used to integrate households.
• Data cleansing, data quality tracking and process balancing checkpoints.
• Create flexible data model design that is scalable, reusable, while emphasizing performance and business needs.
• Utilized in-house wiki to document data model, business rules, projects, and other information;
• Included dynamic documentation coming from the database.

Database:

• Proficient in designing and maintaining databases.
• Oracle: Sizing, Modeling, Bitmap Indexes, Materialized Views
• Other databases: SQL Server, Informix, Access, FoxPro.
• Optimized SQL skills. Proficient in data profiling and analysis.
• Have assumed DBA duties for Oracle and Informix databases.

Development languages And tools:

• Java (Servlets, JSP, command line), Tomcat and Apache web servers, SQL, HTML, JavaScript, C#, Unix Scripts, Cron, Oracle SQL Loader.
• BI: Cognos, Oracle Express, Microsoft Analysis Service SSAS, Hyperion Brio, Sea gate Holos.

Professional Experience

2002-present ABC Inc., Any Town, NY
Data Warehouse Solution Architect

• Member of the data warehouse architecture team that is responsible to create the Business Intelligence reference architecture and implement the next generation enterprise data warehouse. Created standards and design patterns on data movement, data access, data integration, and other areas in the data warehouse.
• Enable the reference architecture and design solutions for several specific data warehouse issues: enterprise key assignment process, data migration and integration, complete ETL audit and catalog process, multi-source (including legacy systems) data acquisition, data archival strategy, and data analysis for business specific applications.
• Member of a design team that implemented a canonical data format for the enterprise party and location entities.
• Re-engineer some of the current ETL processes to streamline the data acquisition and integration process using Informatics Power Center, PERL and UNIX scripts, and DB2 stored procedures ELT technique.
• Work with business partners to define analysis requirements. Guide them through the BI delivery process and layout the business and application architecture road map. Produce some ‘quick win’ prototypes in Cognos and Business Objects.

1998-2001 XYZ Corp., Any Town, NY
Data Architecture

• Designed and managed a High Availability database infrastructure providing scalability and reliability with multi-site replication architecture and DR strategy to comply with firm-wide critical application.
• Utilized Power Designer to create logical and physical data structures based on a Metadata driven architecture. The data is sourced from external vendors and is supplemented with information from internal settlement and trading systems
• Introduced Informatics for building end of day extracts for asset classes to help meet SLAs for downstream users.

1995-1998 BCD Inc., Any Town, NY
Business Inelegance Engineer

• Designed and implemented a multi tier data warehouse And Data Mart using SQL Server 2008.
• Data model design and implementation.
• ETL from multiple source systems using SSIS and CDC, (Change Data Capture).
• ETL to Data Mart Dimension and Fact tables using CDC, SSIS and SSAS.
• Team leader for the source to Reporting Data mart process.

Education

Bachelors of Science in Computer Science
New York University, NY – GPA of 3.0

Click to download the Data Warehouse Resume Sample One in PDF.

Related Resumes

• CRA Resume Sample One
• CRA Resume Sample Two
• CRA Resume Sample Three
• DBA Resume Sample One
• DBA Resume Sample Two
• DBA Resume Sample Three
• Data Modeler Resume Sample One
• Data Modeler Resume Sample Two
• Data Modeler Resume Sample Three
• Data Warehouse Resume Sample One
• Data Warehouse Resume Sample Two
• Data Warehouse Resume Sample Three
• Data Warehousing Resume Sample One
• Data Warehousing Resume Sample Two
• Data Warehousing Resume Sample Three
• Database Architect Resume Sample One
• Database Architect Resume Sample Two
• Database Architect Resume Sample Three
• Information Architect Resume Sample One
• Information Architect Resume Sample Two
• Information Architect Resume Sample Three
• IT Auditor Resume Sample One
• IT Auditor Resume Sample Two
• IT Auditor Resume Sample Three
• IT Manager Resume Sample One
• IT Manager Resume Sample Two
• IT Manager Resume Sample Three
• IT Project Manager Resume Sample One
• IT Project Manager Resume Sample Two
• IT Project Manager Resume Sample Three
• IT Specialist Resume Sample One
• IT Specialist Resume Sample Two
• IT Specialist Resume Sample Three
• Network Administrator Resume Sample One
• Network Administrator Resume Sample Two
• Network Administrator Resume Sample Three
• Network Specialist Resume Sample One
• Network Specialist Resume Sample Two
• Network Specialist Resume Sample Three
• Program Manager Resume Sample One
• Program Manager Resume Sample Two
• Program Manager Resume Sample Three
• SQL Resume Sample One
• SQL Resume Sample Two
• SQL Resume Sample Three
• System Analyst Resume Sample One
• System Analyst Resume Sample Two
• System Analyst Resume Sample Three