Data Architect Resume Profile
Dallas, TX
| Summary Of Skills | Soft Skills Self-motivated team player with excellent communication and problem solving skills. Strong leader with experience training junior developers and advising technical groups on ETL best practices. Comfortable leading meetings with functional users and gathering requirements. Experienced in generating specifications and documentation for data warehouse and ETL design. ETL Tools ETL development experience includes installing, configuring, tuning, and developing ETL jobs in tools such as Informatica, Infosphere/IBM Datastage, Informatica, Oracle Warehouse Builder, and Microsoft SQL Server SSIS/SSAS. Involved in all phases of data warehouse development lifecycle, from gathering requirements and model architecture to development, testing, implementation, and support. Developed incremental data loads using Change Data Capture development tools and methodologies. Experienced in dimensional modeling with tools such as Oracle Designer and ERwin. Oracle and SQL Skilled Data Architect with dimensional and relational database design experience. Highly advanced SQL query writing skills. Experience designing objects in Oracle 11g and SQL Server. Performed logical database administration and the creation and modification of objects including views, tables, stored procedures, sequences, triggers, indexes, and constraints in the warehouse. Experienced in PL/SQL and T-SQL functions, packages, and stored procedures. Perl and UNIX Shell Scripting Comfortable in a UNIX environment and experienced in writing shell scripts for BASH and Korn shells on Solaris, AIX, and Linux. I am an advanced Perl developer. |
| Work experience | Data Architect Confidential Data Warehouse Architect for the financial division of General Motors. Responsible for gathering requirements, designing dimensional and normal form relational data warehouse architecture. Wrote ETL specifications and technical requirements for Informatica ETL development. Interfaced with high level business users to design data marts for credit scoring, leasing, auto loans, commercial lending, and securitization of receivable assets. Performed troubleshooting of data loading problems in Oracle and Informatica. Designed data models in ERwin and implemented naming and table design standards. Designed and documented XML schemas to meet departmental standards. Created DDL for database objects such as tables, views, and indexes. Documented metadata and served as a subject area expert to our reporting community. I recently completed Data Vault 2.0 training which included Data Modeling for Data Vault, Agile Data Warehouse Development Methodologies, and Integrating Hadoop Big Data/NoSQL solutions into the Data Warehouse Architecture through the use of MapReduce and Hive. Business Intelligence Analyst Confidential Responsible for the architectural design, ETL design, development, and support of many multi-terabyte Oracle EPM data warehouses for multiple UT System Universities using IBM Infosphere Datastage. Designed star schema fact and dimension tables and implemented custom data marts to deliver a Peoplesoft data reporting solution for multiple remote campuses in the University of Texas System. Managed data lineage and metadata. Installed, configured, and tuned Infosphere and Datastage environments. Designed a job scheduling scheme, and implemented incremental load designs for the UT Arlington data load process which resulted in a 400 faster nightly data load. Performed code reviews and migrations. Established naming and development standards. Mentored and trained new developers. ETL Developer Confidential ETL Developer and Application Support Manager for various data warehouse projects for SUNY University at Buffalo. Developed data architecture and ETL maps using dimensional modeling, star schema, and best practices as defined in the Data Warehouse Toolkit series by Ralph Kimball. Supported and developed a secondary data warehouse in 3rd normal form. Performed architectural duties including blueprint design as well as the creation and administration of fact and dimension tables. Standardized column names and data types in a staging area that received data from many disparate transactional systems. Performed impact analysis of changes to the data warehouse and maps. Assisted in project management by creating Work Breakdown Structures and technical specifications for other developers on the ETL team. Data Analyst Confidential Data Analyst for a company specializing in the data warehousing and reporting of medical standard X12 EDI data for many large clients in the pharmaceutical industry. Performed numerous data maintenance activities including scrubbing, staging, and validating supply chain management data in large MySQL and Oracle data warehouses. Installed and configured JRun Java web servers for optimal performance. Interfaced with customers to develop blueprints mapping X12 data to warehouse tables. Wrote many custom reports and data extracts to meet the needs of clients. |
Privacy Policy
Resume Categories
- .NET Developers/Architects Resumes
- Java Developers/Architects Resumes
- Informatica Developers/Architects Resumes
- Business Analyst (BA) Resumes
- Quality Assurance (QA) Resumes
- Network and Systems Administrators Resumes
- Help Desk and Support specialists Resumes
- Oracle Developers Resumes
- SAP Resumes
- Web Developer Resumes
- Datawarehousing, ETL, Informatica Resumes
- Business Intelligence, Business Object Resumes
- MainFrame Resumes
- Network Admin Resumes
- Oracle Resumes
- ORACLE DBA Resumes
- Other Resumes
- Peoplesoft Resumes
- Project Manager Resumes
- Quality Assurance Resumes
- Recruiter Resumes
- SAS Resumes
- Sharepoint Resumes
- SQL Developers Resumes
- Technical Writers Resumes
- WebSphere Resumes
- Hot Resumes
