- Featured in:
-
High Quality
The best examples from thousands of real-world resumes
Expert Approved
Handpicked by resume experts based on rigorous standards
Diverse Examples
Tailored for various backgrounds and experience levels
Data Warehouse Architect Resume Samples
No results found
Candidate Info
years in workforce
years at this job
Bachelor of Science
Business
Team Lead\data Warehouse Architect
Pioneered successful cutting edge technologies, development processes and standards in an environment resistant to change.
- Streamlined the operational processes to be more efficient and cost effective (i.e. reduced the costs of tape backups by 90%).
- Regularly advised and consulted with other teams at the University and other Universities.
- Lead team of twelve people. Duties include hiring new employees, developing employees and evaluating the performance of employees.
- Designed dimensional models and developed ETL solutions (included data from Student, Finance, HR, Library and Research Systems).
- Core technologies include: Cognos (Framework, Cube, Report and Data Manager), Microsoft SQL Server (Database, SSIS and SSAS), and SharePoint.
Candidate Info
years in workforce
years at this job
Data Warehouse Architect
As Data warehouse Architect the various Data marts built and worked on enabled easy access to months of customer, product and financial data to the Credit Suisse business users. The Data Warehouse was more than 1 Terabyte in size and features powerful analytical tools, flexible reporting capabilities and leverages the corporation's authoritative sources of information. It accessed the log files generated from the web servers.
- One of the architects of Credit Suisse's enterprise wide customer profitability Data warehouse. Worked on this project from inception. Conceived, designed, developed and implemented the data warehouse solution from scratch.
- Managed the complete project with a team size of over 25 persons.
- Analyzed the existing systems and the business user requirements for tactical and strategic needs.
- Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data.
- Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation
- Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results.
Candidate Info
years in workforce
years at this job
Business Information Systems
Data Warehouse Architect
Designed the dimensional star schema for a large-scale warranty data warehouse and implemented the ETL process in SQL Server 2000's DTS technology; implemented (Kimball "type-2") dimensional history to provide audit trail of dimensional changes.
- Supported Business Objects Universe for data warehouse analytical reporting.
- Introduced design standards for ETL processes to enhance audit and support capability.
- Led design sessions with analytical users to streamline previous requirements process.
- Recommended process improvement for internal design methodology to facilitate Rapid Development.
- Evaluated SQL Server 2005 and formulated migration plan for ongoing data warehouse development.
Candidate Info
years in workforce
months at this job
English / Psychology
Linguistics
Warehouse And Systems Engineering For 6
Data Warehouse Architect Team Lead
Architect / Team Lead for a 7 person offshore Informatica ETL data team for EDW data integration.
- Mapped multiple ETL sets and coordinated all team development into sharable, non-redundant maps.
- Created Enterprise Data Warehouse architecture and standards, plus trained two architects in dimensional modeling and data quality; created shared Master Data sets and data models for Business Objects in an Oracle Financials ERP BCNF (inventory control) including Requisitions, PO, AP, and GL
- Mentored DA's on dimensional models, SCD's, MDM, standards - resolved multiple issues
- Worked with business users to analyze requirements, standards, presentations and documents
- Environment: Oracle 10g, ER/Studio, TOAD, Informatica 8.6, SQL Developer, Business Objects
Candidate Info
years in workforce
months at this job
Computer Systems
Computer Methodology
Data Warehouse Architect
DB2 UDB V8.2, MS SQL Server 2000, MS Window, ERwin Environment
- Designed and created a data warehouse model using ERwin for sales transaction analysis to identify profitable region, restaurant, location, product, promotion, and minimize expense.
- Supported production application, troubleshooted DB2 & MS SQL Server stored
- Created source, target, and process models to load data with DB2 Data warehouse Center
- Created Cognos reports
Candidate Info
years in workforce
months at this job
Computer Science
Technical Management
Project Management
Senior Data Warehouse Architect
Tuned and solved problems in Oracle 10g databases and many SQL statements for a data warehouse project.
- Supported Discoverant applications and automated conversion and migration operations with Korn shell scripts on Solaris 10.
- Designed, tested and benchmarked the production database system.
- Fully documented project database administration and designs for the system.
- Performed all DBA functions using Toad and SQLPlus for DSS type databases.
Candidate Info
years in workforce
years at this job
Business Administration
Project Leader, Data Warehouse Architect
Project leader - Led project, working with executives, management, and IT staff.
- Data Warehouse Architecture Consultant - Designed the Enterprise Data Warehouse and dimensional Data Marts.
- Established Data Management, Governance, and Metadata processes/standards.
- Established Data Administration function including Data Governance.
- Created a common objects and data reuse strategy.
- Mentored client data modeling staff, including teaching data modeling classes.
- Supply Chain - Analyzed, designed, and modeled mfg. supply chains.
- Database Consolidation- Consolidated 18 different DMBS platforms into 4.
Candidate Info
years in workforce
years at this job
Business And Financial Accounting
Data Warehouse Architect
Created a flexible data model design that was scalable and reusable, while at the same time emphasizing performance and the enterprise's business needs. Played an active role in the design of ETL process(s) to load data from source to staging, foundation and presentation layers of the DW.
- Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
- Translated business requirements into design and technical specifications for implementation.
- Collaborated with business analysts and offshore developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.
- Engaged in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various data load modules.
- Provided technical design overviews for the DW setup, and participated in technical reviews for IT related implementations.
- Delivered key support to multiple IT teams and business users, and created and maintained technical and application support documentation.
- Extracted data from IT systems created 20 years prior and without referential integrity, overcoming issues with extensive source data analysis as well as agreements on data extraction and usage rules with source system teams by having an interface control document in place.
Candidate Info
years in workforce
year at this job
Electronics Engineering
Data Warehouse Architect
Analyzed, identified and documented data mapping between source, stage and destination repositories.
- Designed reporting ODS, staging area and data marts for each Line of Business (total of 5) to deliver Enterprise Data Warehouse (EDW)
- Designed DTS packages between FileNet P8 system and SQL Server 2000 to provide data validation, scrubbing, aggregation and transformation. Coded data cleansing logic utilizing regular expressions.
- Created enterprise reporting solution utilizing SQL Reporting Services 2000, T-SQL and MDX.
- Implemented security, scheduling and maintenance plans for the DTS packages and reports.
- Stress tested designed framework under full processing load, provided documentation and knowledge transfer to a client's BI team.
- Technologies: SQL Server 2000, Analysis Services 2000, EDW Kimball Method, T-SQL, MDX, FileNet P8 Platform, SSRS 2000 (VS.NET 2003), Visual Basic 6.0, VBA, SSAS 2005, SSIS, SSRS, EDW Kimball Method, MDX, .NET Framework, UML/Visio, TFS, SQL Profiler/Performance Monitor.
Candidate Info
years in workforce
years at this job
Mathematics
Data Warehouse Architect
Responsible for a first-generation data warehouse (DW) from 1993 to 1999, including DW modeling, analysis, data quality, user support, ETL development, production support, and user reporting.
- Converted from Teradata to Informix, with re-write of all DW ETL processes
- Supported IQ Software report tool and created user semantic layer
- Headed the DW User Group and managed all user interactions and requirements
- Managed relationships with multiple business partners: Sales, Marketing, Accounting, Compliance, H/R, and Capital Markets (Fixed Income, Municipals, Equities, Research)
- Coordinated the orderly application retirement and transfer of functionality to EDW
- Designed, developed, and supported two applications: Syndicate Index for public offering trade analysis; and Money Market Preferred, a commission accounting application
- Architected the Sector Market Analysis & Report Tool (SMART) for transmitting, storing, and displaying bond offerings and for providing a pricing database for swap analysis
Candidate Info
years in workforce
years at this job
Master of Business Administration
Engineering
Executive Leadership
Data Warehouse Architect
- Led the development and implementation of data warehouse and business intelligence for clients - Health care (Health Care Recoveries), Investment Banking (JP Morgan and Chase & American Express Financial Advisors), Retail warehousing (Ascendant Solutions) utilizing Oracle, MS SQL Server, Hyperion, Data Stage, Informatica and Cognos.
- Replaced 400 existing reports with 90 new metric-unified warehouse reports for sales, marketing, Claims, Overpayments, and recovery revenue management.
- Improved month-end closing process by 70%, created multi-department task force to resolve issues with data management infrastructure, formulation of corporate metrics and standardized reporting.
- Helped the client (JP Morgan and Chase) implement Master data management (MDM) application, collaborated with Stake holders in finalizing master data definitions and helped company achieve "Single version of Truth", which resulted in cost savings of 25% over a 18 month period.
- Streamlined the vendor contracts, projects resource, infrastructure requirements, which resulted in cost savings of 15% over the life of the project (Health Care Recoveries).
- Delivered centralized data warehouse solution (Ascendant Solutions) and customer management systems, which resulted in cost savings of 15% over 3-year period.
Candidate Info
years in workforce
years at this job
History
Data Warehouse Architect
Engaged to re-architect Charmer's Enterprise Data Warehouse (EDW), a data warehouse the dealt with the depletions, pricing, and inventory of wine and spirits of a five billion dollar corporation across 17 states and 21 brick and mortar warehouses on a SQL 2005 platform.
- Produced conceptual, logical, and physical models from gathered requirements to re-architect and upsize a 600 GB compilation of databases into 1.5 TB enterprise class data warehouse, including SSIS packages and Decision Support Science (SSAS) servers.
- Identified and led the MDM effort to remap product SKUs across 21 warehouses resulting in a 23% decrease in SKUs and increased efficiency in product reporting.
- Transformed hundred's of DTS packages into SSIS packages to standardize and centralize feeds to the data warehouse and subsequently to the SASS servers reducing maintenance time by 40% and cutting data delivery time by over 50%
Candidate Info
years in workforce
year at this job
It Management
Project Management
Computer Science
Data Warehouse Architect
Designed, developed, implemented and supported Clinical Data Warehouse and data integration applications using Informatica, Cognos, Erwin, Oracle, Control M, and Trillium tools. Worked with various business organizations: Research, Pre-clinical, Early Development, Clinical Development and Medical Affairs, Pharmacovigilence, Drug Regulatory Affairs and Project Management to capture business requirements and build analytical solutions. Defined and built DW technical infrastructure.
- Evaluated various data integration tools through RFP process for analysis, comparison and selection.
- Reviewed and approved all applicable policies, standards, procedures, and monitored compliance for internal and regulatory guidelines for Data Warehouse systems.
- Developed Solution Analysis and Concept Document templates used for all Data integration projects.
- Built Financial FDAIND, Pre clinical, Clinical Trial metrics and safety signaling reports applications.
Candidate Info
years in workforce
year at this job
Leadership
Business Intelligence / Data Warehouse Architect
Delivered a data architecture for the data warehouse that included a comprehensive data model, configured tools for access to data, integration with all data sources included in the warehouse
- Delivered a system that provided checks and balances of the data to ensure data quality and security
- Delivered solutions to business partners and other stakeholders that allowed for data analytics that delivered timely and accurate data to support decision-making.
- Business Intelligence solution allowed data to be analyzed and reported to media in 20 man hours. This eliminated approximately 60 man hours from the process and provided a solution that will streamline the process and reduce the possibility of human error.
- Delivered data governance plan that allows agency to check for data accuracy, consistency, security, and grow to meet the future data needs.
Candidate Info
years in workforce
years at this job
Computer Engineering
Software Engineering For Embedded Computer Systems
Data Warehouse Architect Consultant
Served as a Principal for Data Warehousing project sci (Strategic Capital Information) from conceptual design to production implementation.
- Conducted business assessment, collected user requirements, analyzed operational data.
- Designed conceptual and technical architecture and marketed it with corporate sponsors and stakeholders.
- Defined strategies for back- and front-end construction, data security, metadata population and usage, Web usage, error handling, reconciliation, and reference data maintenance.
- Designed and developed logical and physical data models for Staging, Data Warehouse, and Data Marts.
- Built and implemented procedures for data load, validation, transformation, and data mart population.
- Designed and implemented multiple Web-based Brio reports with EIS screens, pivot tables, and charts.
- Mentored team members, educated business users.
- Used ERwin 4.0, Oracle 8.1.7, HP-UX 11, SQL, PL/SQL, Sql*Load, Sql*Plus, UNIX Korn shell scripts, FTP, XML, SQL Server 7, SQL Server 2000, Sybase 12, Oracle 11i - General Ledger, Brio Enterprise 6.5, Data Junction 7.5, Informatica PowerCenter 5.1.1, QueryMan, Toad Xpert, eXceed, NetOp, MS Project 2000, Visio Professional 5.0, MS Power Point, MS Publisher, MS Excel, MS Access 97.
Candidate Info
years in workforce
years at this job
Education
Master of Arts
Library Science
Senior Data Warehouse Architect
Created, designed and implemented [company name] health care marketing decision support system to provide web based client access to their information. Increased data availability to client and internal users by 90% - Client and Internal users are able to create their own reports, download data and manipulate data without IT assistance. External and Internal users doubled by the end of the second year.
- Created overall data warehouse strategy, processes and procedures, and basic methodology. Recommended technical architecture to management.
- Managed all data warehouse projects, defined resources, tasks, estimates, risks and tracked work in Microsoft Project Manager.
- Created 150 standard reports in Business Objects and Oracle SQL
Candidate Info
years in workforce
months at this job
Information Systems
Data Warehouse Architect
- Designed custom star schema data warehouse with 10 marts over two major subject areas including Leave Management and Claims. Helped return project to success after original design failure.
- Developed source to target data mappings and worked with ETL team to implement business rules.
- Developed detailed metadata and met enterprise design requirements including development of code sets and custom naming conventions.
- Served on project leadership team as the lead technical resource. Interfaced with other teams to make sure a consistent vision of the design was enforced across all teams.
- Data Warehouse designed to provide clients customers with direct access to their data. Largest current project for the fortune 500 company with over 70 consultants and staff involved in the project.
Candidate Info
years in workforce
years at this job
Electronics Engineering
Management
Data Warehouse Architect/project Manager
Worked closely with the DW team in designing the first DW for AMD which mandated capturing manufacturing processing lines granular data such as the electrical characteristics of wafers as they travel down the manufacturing processing lines in order to enhance future chip design.
- Researched, analyzed, wrote and led hardware consolidation project of multiple remote Far East sites. Reduced operation cost by over $235K annually.
- Managed Data Warehousing project which included risk assessment, roadmap planning, developing project time lines, budgeting, researching material, writing specifications, locating suppliers, team management, analyzing customer needs, and requirement gathering.
- Participated in custom software package commercialization effort for the semiconductor market segment. Researched and analyzed competitors' market segment.
- Participated in DW life cycle implementation phases from inception to delivery which included business need assessment, data source definition, data source analysis, physical design, technical architecture, data staging and loading, and end user acceptance testing.
- Met with system owners and devised procedures to solve complex problems considering current infrastructure environment.
- Deployed Global DW data mart for a global users community (i.e. Singapore, Germany, USA).
- Led Oracle 8i database upgrade project of seven engineering and manufacturing databases in a global business environment.
- Coordinated and documented Request For Information (RFI) and Proof Of Concept (POC) for BI and DW projects.
- Adhered to PMI Project Management Body Of Knowledge (PMBOK) methodology.
Candidate Info
years in workforce
months at this job
Chemistry
Senior Data Warehouse Architect
Three projects - one for a vice-president and two senior managers.
- Interviewed PetSmart senior managers, directors and vice-presidents concerning data issues. Grouped issues and gave impact on business.
- Created a plan for an Enterprise Data Strategy and initial tactical steps to achieve alignment with business objectives. The plan addressed the needs for a road map which contained data governance, master data management, standards, metadata strategy and more. Also determined gaps in processes and documentation.
- Drill down on STORES subject area to document Informatica data flows.
- Company re-organization, project ended early.
Candidate Info
years in workforce
years at this job
Engineering
Data Modeler/data Warehouse Architect/development-delivery Manager
Improved efficiencies by implementing a single data repository to enable better business decisions and risk analysis reducing time to analyze loan positions from 90 days to 3 hours.
- Managed teams and coordinated consolidation all U.S. company data to enable rating and regulatory agencies to aptly monitor the risk and exposure of lending institutions and the system in its entirety.
- Conducted planning, tracking, and reporting of application deliverables.
- Created resource specifications, hired personnel to develop applications, and allocated appropriate resources to meet deliverables.
- Mentored developers in performance and tuning of application and database; trained application end-users of data warehouse features and functionality.
- Created RFPs for vendor selection to host solution and determine solution partners for FC DWH.
- Translated both Business and Functional Requirements Documents into Technical Requirements Documents; engaged with stakeholders to review Functional Requirements Documents to determine scope and deliverables of application.
- Designed logical model and physical data models to ensure that all elements and functionality were accommodated; designed UIs for data access, and enabled modifications for risk analysis.
- Set up secure data delivery and storage of encrypted data in data warehouse; developed process for production support and disaster recovery.
- Updated senior management on quarterly progress and peers on weekly progress.
- Created presentations, data and process flows to enable senior management to understand application and deliverables as well as scripted for Business Intelligence tools to access data
Candidate Info
years in workforce
years at this job
High School Diploma
Data Warehouse Architect, Price Waterhouse
Sr. Programmer Analyst, Time Customer Services
- Saved firm tens of thousands of dollars earmarked for development by prototyping using MS Access.
- Supported Net Revenue Data Warehouse in a MVS COBOL and UNIX environment.
- Specialist in dynamically generated JCL for mainframe job-streams.
Candidate Info
years in workforce
years at this job
Project Management, Leadership
Senior Data Warehouse Architect
Proposed the new architecture that was selected by the team to support operational reporting, executive management, business data analysts and data scientists, i.e. the Data Mart Collective Architecture ("BI 2.0").
- Drafted the presentations for executive approval of BI 2.0, and presented the architecture to the Enterprise Systems Architect Council.
- Researched and drafted presentations of the functional components in BI 2.0
- Worked with the Enterprise IT Business Intelligence Leadership team to define the technical architecture for BI 2.0.
- Facilitated workshops and drafted presentations aiming toward a shared architecture with the Engineering Team.
- Proposed an approach to align the build-out of the BI architecture with strategic business objectives.
- Contributed to proposals for improving the BI design process and standards.
- Reviewed and graded Business Requirement Documents and High Level Architecture Designs for back-end systems to define/determine impact on business intelligence applications. Participated in an initiative to improve the High Level Solution Design template.
- Designed the Data and Solution Architecture for various projects
Candidate Info
years in workforce
years at this job
Liberal Arts
Chief Oracle Data Warehouse Architect & Director of Dw/bi Development
Provider of Internet media delivery software and services. The top one or two company every year, providing text messaging services to the largest telecom companies in the world (Sprint, Verizon, etc.)
- Collaborated with business and technology departments to define deliverables and develop solutions that were reusable across the organization.
- Established the vision for and led the design and development of the dimensional data warehouse and business intelligence system, pioneered the use of Metadata repositories to uncover patterns of system utilization allowing for the identification of opportunities for system improvements and the ability to mitigate system issues leading to over 30% reduction in costly customer service calls.
- Managed, mentored, trained, and guided junior application developers and DBAs, directed activities and reviewed code of offshore and onsite database application developers, and served as senior data warehousing and business intelligence technical advisor to upper management and executives.
- Designed and built a Microsoft Access tracking system that contributed to the reduction of costly SLA violation penalties by 50%.
- Hands on supervisor of Crystal Reports and Oracle Business Intelligence Executive Edition 10g (OBIEE) developers and systems. Designed reports and optimized queries, and built dashboards. Trained users, gather requirements, and presented business cases.
- Conceptualized and programmed a custom ETL process utilizing Oracle SQL & PL/SQL that extracted, transformed, and loaded more than over 1.5B transaction records per day, resulting in the storage of multi-terabytes of data.
- Enabled securing of multi-million contract with Telcel (Mexico's largest wireless carrier) by building process that ensured rendering of timely and actionable reporting on key business metrics.
Candidate Info
years in workforce
months at this job
Data Warehouse Architect /lead Developer
Goal of the project was to decommission existing consumer medicine's data warehouse and replace it with a more accurate, scalable, detailed, cost efficient data warehouse and reporting system. Expertise in the chosen tools associated with the data integration tool to be used in the Program with exposure to SAP
- Migrated codes from Informatica 5.1 to Informatica 6.2
- Managed entire code migration in PVCS version control from development to test and then to production environment, and created the necessary migration templates required
- Performed string testing, integration testing, data validation and UAT signoff.
Candidate Info
years in workforce
years at this job
Computer Science
Data Warehouse Architect
Successfully migrated a data warehouse application to Houston during the company merger with another oil and gas company. Was responsible for the acquiring of the production and test servers for Oracle, AutoSys and Essbase. Was responsible for the successful integration of the converted data and load processes.
- Performed logical and physical data modeling and design duties for business solutions. Deployed data objects and procedures, and load processes. Administered all scheduling jobs in AutoSys.
- Worked with the reporting team to simplify the reporting process against the data warehouse. This included analyzing requirements and developing structures and procedures to integrate and summarize heterogeneous financial and operations information.
- Designed and implemented a reusable load process for flat file sources that simplified adding new sources to the data warehouse nightly load. It included robust error handling and e-mail notification.
- Participated in the selection of standard toolset for the data warehouse team. This included ETL, data modeling, scheduling, and reporting and data analysis tools. Once the toolset was chosen, developed the standards and methodologies for use by the team.
- Assisting ETL developers design, code and deploy new ETL processes in Oracle Warehouse Builder for redesign effort.
- Developed financial reports using Brio with Oracle and Essbase sources.
Candidate Info
years in workforce
years at this job
Bachelor of Engineering
Technology Management
BI Team Lead / Data Warehouse Architect
Scaled and managed a team of four BI developers and designed data architecture/ETL for the enterprise data warehouse and master data management application.
- Defined the architecture and developed Teradata data ware house data models using ERWin and ETL for subject areas like inventory, shipments, promotions, retail sales, distribution and financial planning.
- BI lead for multiple efforts delivering KPI, strategic and operations reports for finance, supply chain and sales.
- Provided direction and set goals for a team of four offshore BI developers.
- Successfully delivered an executive dashboard to measure sales and Financial performance. Audiences include CEO and President of the company.
Candidate Info
years in workforce
year at this job
International Business Management
Finance
Data Warehouse Architect
Lead a fast growing team in all technical aspects of Business Intelligence (BI) from data warehouse ETL best practices to cube design to getting executive support for the team through proven benefits of BI.
- Architected, designed and implemented entire data warehouse for XanGo's top corporate initiative that year.
- Assisted systems team in architecting / implementing logical and physical design of Business Intelligence servers, including PPS, Proclarity, SSAS, SSRS, Sharepoint including failover setups for more reliable uptime.
- Designed and implemented data warehouse around Development, QA and Production environment with minimal or no human intervention moving code changes between these environment.
- Created various ETL processes, reconciliations and audits on legacy system in order to assure accuracy on key reports until migrated to new data warehouse.
- Designed new processes and data warehouse designs most likely not available in any Multi Level Marketing company enabling analysis and views into distributor trees accurately and efficiently.
Candidate Info
years in workforce
years at this job
Chemistry And Physics
Chemistry
Senior Data Warehouse Architect
For a radiation benefit management company, a new system was designed and developed to consolidate payer provided claims and member eligibility files with call center operational data.
- Utilizing the Kimball methodology, a logical and physical data model was designed, developed, and deployed to consolidate data from multiple source systems into a single consolidated source.
- SSIS packages were developed to extract, transform, and load claims payments, member eligibility, call center consults, and facility site survey data into primary data marts.
- SSIS packages were developed to construct secondary data marts that encapsulated business definitions dependent upon data from multiple business processes.
- A single SSAS cube was designed, developed, and deployed with measure groups for claims, member eligibility, radiation consults, and facility assessments.
- Report procedures against SSAS were constructed and ExcelWriter templates were developed to automate and replace existing manually generated, client-contracted reports.
Candidate Info
years in workforce
years at this job
Information Technology
Data Warehouse Architect - Data Modeler & Cognos Developer
Increased visibility of web sales that improved product sales through ecommerce strategy.
- Built and effectively maintained Cognos Business Intelligence environment; Cognos ReportNet, ETL Decision Stream, Sun One Java for Access Management and Cognos Transformer for multi-dimensional cubes.
- Architected ETL purchase order system for the Project Tracker and built data sets to track and manage sales of medical supplies and other products.
- Migrated Decision Stream to Data Manager for proof of concept in testing with existing ETL architecture.
- Built various Sybase data structures for maintaining current and historical data-sets among production and data warehouse.
- Modeled many types of dimension and fact tables using star schema designs; dozens of packages with multiple query subjects using dimensional relationships.
- Worked directly with leaders in building business and technical requirements for all ETL and dimensional modeled projects.
- Designed and built various detailed tabular and prompt reports ranging from customized packages of daily business sales, purchase order reports, rolling completed sales and returns which include mix of sales and returns.
- Implemented an enhanced method of collecting state and county tax adjustments in retail and web business that helped reduce audit risk.
- Implemented purchase order processes that to reflect current, historical and late shipments leading to reduction of late shipments for the entire organization and increased customer satisfaction.
Candidate Info
years in workforce
years at this job
Finance
Finance
Data Warehouse Architect
- Managed PMC's Data Warehouse (operational data store and data-marts) and OLTP systems (G/L, A/P, Purchasing, Time keeping, etc.).
- Independently developed an enterprise HIPAA-compliant warehouse reporting application which provided staff timely insights into their areas of business interest. These reports significantly improved organizational cash flow by ensuring that providers turned in their charges and insurance companies were billed.
- Implemented horizontal partitioning to improve warehouse data load speeds (reduced by 80%). Created an automated nightly load process since the reduced load times now permitted this.
- Served as a member of the Provider Compensation Committee. Interfaced directly with physicians regarding their productivity data while giving careful recognition to the sensitivity of compensation-related matters. These efforts, in conjunction with the warehouse reporting application, established the credibility and high value of the data warehouse.
- Successfully hardened the corporate SQL infrastructure to pass the Department of Defense's DITSCAP security audit.
Candidate Info
years in workforce
years at this job
Management
Management Information Systems
Senior Data Warehouse Architect
Assigned to the primary responsibility for supporting Lockheed/Martin in maintaining the Naval Standard Integrated Personnel System (NSIPS - the naval equivalent of HR and assignments/training systems) Analytics Data Warehouse data models using the ErWin 7.3 data modeling tool.
- Provided support to the Operations Support and DBA Requirements analysis Teams. Designed, modeled documented, and guided the logical and conceptual relationship of data and database changes for complex applications.
- Analyzed needs and requirements of existing and proposed systems and developed technical, structural and organizational specifications.
- Created standards and naming conventions to enhance capacity and systems performance.
Candidate Info
years in workforce
years at this job
Data Warehouse Architect
Worked as a Data Architect to design, develop as part of the Enterprise Data Warehouse initiative and build Data Marts using Seagate Factory Information Systems in the areas of SLIDER, WAFER, HGA, Head Stack Assembly, Media and Substrate.
- Conducted interviews with the data producers (Process Engineers) and the stakeholders for business requirements and gathering, data analysis, data profiling and data modeling.
- Actively performed business requirements Gathering, Gap Analysis, data analysis and data profiling.
- Data Modeling using Erwin, technical solution and architecture reviews and customer satisfaction.
- Provided ETL solutions, production support and fixes.
- Setup TIBCO data feeds/TDF Files, JAVA Normalizer program to provide data feeds from Seagate Information Bus to EDW.
Candidate Info
years in workforce
year at this job
Computer Science
Data Warehouse Architect/informatica Lead
Design, Architect, and Implemented Informatica installations (8.1.2), upgrades (8.1.2), and add-ons for all of the GE Infrastructure businesses including Rail, Transportation, and Aviation worldwide.
- Developed Design Standards, Architecture Standards, and Administration Standards for the several GE Informatica project teams.
- Reviewed the Data Model/Architecture for efficient ETL Architecture.
- Served as an interface to project teams relative to technical requirements, directions, and problem resolution.
- Tools included: Informatica 7.0.x, Erwin 4.x, & Custom EDW & Data Marts
Candidate Info
years in workforce
year at this job
Management
Master of Arts
Data Warehouse Architect / Agile Project Manager
Managed numerous projects from inception to completion, leading cross- functional teams from Actuary, Market Research, Finance, and IT.
- Converted Business Requirements from Senior Leadership into Technical and Reporting Requirements for IT Project Team.
- Created and maintained multiple project plans running in parallel.
- Performed Data Analysis/Data Profiling of application databases to identify and correct system data issues and implement process
- Utilized Master Data Management (MDM) tools to ensure Data Integrity and perform Data Cleansing when necessary.
- Designed Data Marts, Materialized Views, and Result Sets for BI reporting
- Assisted in SAP Business Objects universe design and report writing.
- Prepared test cases and deployment plans.
- Communicated and ensured the use of Best Practices in all project plan
Candidate Info
years in workforce
years at this job
Finance
Management Information System
As400 Programmer\data Warehouse Architect
Designed and deployed data warehouse via Sybase IQ with complicated data structures from multiple data sources(Sybase ASE, MS SQL Server, AS400 and MS Access) with different technologies(row based Vs column based) and migrated into single server with user friendly reporting tool for quick reports buildings and better decisions support for management
- Deployed data warehouse from end to end processes including user requirements gathering, writing technical spec, implementing data warehouse in modules, validating end results with user acceptances, developing tools, training users to make uses of new deployed modules
- Used PL/SQL via KornShell to facilitate writing scripts and automating a wide variety of tasks
- Monitored operations of the data warehouse and provided production support 24 x 7
- Created BI reports for different users including executives, Accounting, Sales/Marketing and CRC via SAP Business Objects and SSRS. Assisted users to develop reports with different tools
- Supported multiple business applications e.g. AdaptivePlanning, BizInsight, BizBroadcast, Sage MAS500, Sage Fixed Asset, and SalesForce
- Assisted in maintenance of AS400 billing system which was built in-house via IBM AS400
- Deployed external and intranet webpages via Joomla content management system(CMS)
Candidate Info
years in workforce
months at this job
Data Warehouse Architect
Environment: HP, NT, Oracle, Oracle Express Server 6.2, Oracle Express Web Agent, SAS.
- Architect for full-cycle design and deployment of the NDA data warehouse.
- Evaluated and selected hardware, DBMS, OLAP and ETL tools.
- Deployed meta-data repository for Designer2000 models and star schema meta-data.
- Deployed Oracle Express Web to provide OLAP capabilities on intranet.
Candidate Info
years in workforce
year at this job
Data Warehouse Architect
Manage, Design, Test & Implement full Data Warehouse capability, including ESD (Enterprise Staging Database), EDW (Enterprise Data Warehouse) and System Management Dashboard.
- Developed and populated repository for Meta-data
- Produced working proto-type DW in under 3 months
- Developed OLAP (Analysis Services) cubes and English Query capability.
- Environment: Win 2000 Pro, SQL Server 2000, Transact-SQL, DTS packages, VBScript, Query Analyzer, Performance Monitor, Views, Stored procedures, SQL Agent, Analysis Services, Star schema, Dimensional modeling, OLAP Cubes, English Query.
Candidate Info
years in workforce
months at this job
Data Warehouse Architect
Lead the development of the enterprise architecture for data warehouse.
- Modeled the first and second generation of data warehouse.
- Designed and developed ETL routines to load the initial rollout of the Data Warehouse.
- Integrated post-ETL quality assurance.
Candidate Info
years in workforce
years at this job
Marketing And Advertising
Finance
Alliancebernstein Data Warehouse Architect
Designed a commission application for private client financial analysts which included differentiation between payment tiers, new vs. old accounts, and assumed vs. actual revenue.
- Designed a Star Schema SQL Server database to support this new commission application, and integrated it with existing data from Access, Oracle, Excel, and other SQL Server databases. Utilized such tools as SSIS, SSAS, SSRS, and Cognos to develop an analytic framework and reporting package.
- Implemented a high availability mirroring solution for a mission critical instrument trading application utilizing SQL Server 2005.
- Utilized ETL tools to scrub and transform disparate databases.
Candidate Info
years in workforce
months at this job
Computer Science
Technology / Human Resource Development
Data Warehouse Architect and Developer
Designed and developed a Microsoft SQL Server 2008R2 Analysis Services database consisting of 3 fact groups and 12 dimensions to serve as a platform for adhoc reporting using Excel and Report Builder. The SSAS database is used to produce time sensitive Inventory, Sales and Profit reporting.
- Designed automated processes using Microsoft SQL Server 2008R2 Integration Services to extract data from Microsoft's RMS POS solution, hosted under SQL Server 2008 R2 with SQL Server 2008 and 2005 clients.
- Designed and developed SSIS ETL process to extract sales data to feed to major suppliers.
- Designed and developed SSIS ETL process to extract market data to sell to media research firms.
- Designed and developed multiple Microsoft SQL Server 2008R2 Reporting Services reports for internal and external auditors.
- Gathered requirements from end users in Accounting and Operations on reporting requirements.
- Designed and developed multiple Microsoft SQL Server 2008R2 Reporting Services reports for Accounting and Operations.
Candidate Info
years in workforce
years at this job
Marketing And Advertising
Finance
Data Warehouse Architect
Managed an internal team of two programmers and a major off shore resource in India.
- Designed a commission application for private client financial analysts which included differentiation between payment tiers, new vs. old accounts, and assumed vs. actual revenue.
- Designed a Star Schema SQL Server database to support this new commission application, and integrated it with existing data from Access, Oracle, Excel, and other SQL Server databases. Utilized such tools as SSIS, SSAS, SSRS, and Cognos to develop an analytic framework and reporting package.
- Implemented a high availability mirroring solution for a mission critical instrument trading application utilizing SQL Server 2005.
- Utilized ETL tools to scrub and transform disparate databases.
Candidate Info
years in workforce
months at this job
Business Administration
Data Warehouse Architect (consultant)
Technology: Oracle 11g, Informatica PowerCenter 8.6, 8.1 UNIX (Solaris)
- Primary architect for data warehouse
- Designed, developed and implemented the metadata strategy for the wholesale division, which included reporting, data capturing and defining business requirements
- Lead offshore team for developing ETL processes using Informatica, Oracle and UNIX shell scripts
- Design data structures for staging and analytical reporting using a star schema design
- Analyze various sets of data for determining relationships of undocumented data sets, using SQL and Toad.
- Design and implement consolidated sets of transactional data for streamlined reporting
- Meet with management and clients to present proof of concept models, status of current projects and implementation schedules.
Candidate Info
years in workforce
year at this job
Sr. Data Warehouse Architect
A giant in manufacturing and services industry over 40 countries. TED is a hybrid Data warehouse of [company name] division which holds day to day Sales and marketing, budgeting and related finance information.
- Analyzed and prepared SRS docs and Data Flow Diagrams.
- Designed the Application interfaces after gathering the info from end users.
- Designed Schema ER diagrams, Physical design in Designer data modeling tool.
- Extensive back end programming using stored procedures, functions, packages and triggers through Oracle PL/SQL.
- Performance testing and load testing on various test systems for data conversions.
- Scheduling batch jobs and monitoring through IBM Tivoli job scheduler.
Candidate Info
years in workforce
years at this job
Computer Science
DATA WAREHOUSE ARCHITECT (consultant)
Architect and design enterprise data warehouse solutions for downstream analysis and reporting.
- Created and implemented the Database Development Life Cycle to organize project deliverables and decrease time to market with improved quality.
- Mentor and train new team members on how to create high efficiency ETL processes to decrease negative impact on customer facing systems while increasing system performance.
- Currently creating the logical and physical data models to create the new Enterprise Data Warehouse utilizing a hybrid approach of the Inman and Kimball methodologies.
- Currently creating dashboards with Tableau that consume departmental data marts.
- Currently creating SSAS cubes to allow business users to quickly consume existing business metrics.
Candidate Info
years in workforce
months at this job
Administrative Systems Management
Management Professional
Moran Towing Data Warehouse Architect and Project Lead
Client was a marine transportation company that was developing a data warehouse from scratch for their Tug Boats, Barges and ATBs.
- Conducted SME and Stakeholder interviews to determine high level and detailed requirements, created Business Requirements Document and maintained high level project plan using MS Project.
- Performed data analysis of the various vendor source systems as needed to complete phase one (Financial data) and initiate phase two (Operational Data) data warehouse
- Designed table structures for staging, relational data warehouse and analysis services database using a combination of Oracle Toad ER Modeling software and Microsoft Visio software.
Candidate Info
years in workforce
months at this job
Mathematics
Mathematics
Computer Science
Sr. Data Warehouse Architect
Responsible for corporate data warehouse architecture and design, ETL development, production data migration. Legacy systems reverse-engineering and research. Data research, normalization and centralization.
- New technology evaluation and IT project proposals, recommendations for the new software purchases.
- Mentored staff.
- Consolidated, tuned the performance of the existing warehouse and tuned ETL.
Candidate Info
years in workforce
year at this job
Economics
Data Warehouse Architect
- Created a web-based Business Intelligence Data Warehouse for managing Nuclear Chemical and Biological Weapons protective equipment inventory for the United States Marine Corps.
- Designed Oracle 9i Warehouse star schema using ErWin.
- Created all extract/transform/load jobs from source SQL Server systems.
- Created presentation layer using Oracle Portal and Discoverer.
- Configured Oracle Application Server 9iAS to host secure portal.
Candidate Info
years in workforce
years at this job
Bachelor of Engineering
Administration / Finance
Sr. Financial Data Warehouse Architect
- Led the development for a financial data warehouse using Microsoft SQL 2000 and made it the primary source for month end closing and high-volume (millions) transaction operation service analysis
- Designed and built OLAP Accounts Receivable cubes using SQL Analysis Services; trained users from VP to customer services using Aging info from the cube for collection efforts; linking tables through ODBC data connections, building macros to streamline the information access process and resulted in significantly greater efficiency.
- Interpreted business requirements and translated them into data requirements for complex projects; Extensive work in creating and designing queries in both SQL and Access.
- Functioned as the SQL database administrator in finance for maintenance of user security accounts, table design, creation of table schema, views, etc.
- Developed sophisticated Excel pivot reporting model for cash development analysis and forecasting.
- Provided detailed and insightful analysis for financial and operational management including meetings with LA County Fire Department.
Candidate Info
years in workforce
years at this job
Computer Science (honors, Class 2:1)
Artificial Intelligence
Senior Database/data Warehouse Architect
- Gathered and analyzed user requirements for business reports. Designed and specified technical solutions. Supervised and reviewed technical implementations.
- Managed software builds, releases and quality assurance process in multiple QA environments.
- Collaborated with on-site and off-shore developers and personnel on multidisciplinary projects.
- Architected, designed and delivered a Data Warehouse based on star-schema with conformed dimensions and fact tables.
- Integrated data from heterogeneous data sources into SQL Server 2005 databases using SSIS.
- The data warehouse provides a Decision Support environment for information analysis and business reporting with great visibility to data in the following business areas: Online Customer Enrollment, Customer Cohorts, Meeting Member Enrollment, Meeting Attendance, Product Sales, Location Sales, Employee Pay, Online Tools Usage.
- Migrated, optimized and maintained a multi-countries Data Warehouse and reporting application implemented by third party. The application includes SQL Server database, SSIS, SSAS and SSRS components. The project provides savings in hundreds of thousands of dollars per month.
Candidate Info
years in workforce
months at this job
Mathematics, Statistics And Computer Science
Data Warehouse Architect
Data Warehouse and Business Intelligence System development in SQL Server 2008 R2, SSAS, SSIS, SSRS, PowerPivot for Excel 2010, PowerPivot for SharePoint 2010, Excel Services for SharePoint 2010 and PerformancePoint Services for SharePoint 2010 on Windows Server 2008 R2.
- Design Enterprise Business Intelligence Architecture.
- Document existing enterprise system architecture using Infobody Model and analyze problems for improvement.
- Document product manufacturing process using Infobody Model.
- Legacy ERP, CRM and Sales Distribution System maintenance.
Data Warehouse Architect Resume Success Stories
