- Featured in:
-
More Data Warehouse Architect Resumes
Use these Data Warehouse Architect samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Inventory Management Resume Samples
Data Warehouse Architect Resume Samples
No results found
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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
0-5 years of experience
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
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
6-10 years of experience
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
0-5 years of experience
- 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.
0-5 years of experience
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%
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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
0-5 years of experience
- 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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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
0-5 years of experience
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.
6-10 years of experience
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
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
- 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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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
0-5 years of experience
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
6-10 years of experience
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)
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
- 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.
0-5 years of experience
- 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.
6-10 years of experience
- 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.
0-5 years of experience
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.
Inventory Management Cover Letter Examples
Rate This Article
[Data Warehouse Architect]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
