Data Warehouse Analyst Resume Samples

A Data Warehouse Analyst undertakes the most crucial job of collecting, analyzing, mining, and helping the business leverage the information stored in data warehouses. A well-drafted Data Warehouse Analyst Resume mentions the following core duties – researching and recommending technology solutions relating to data storage, reporting, importing, and other business concerns; and defining the user interfaces for managing the interactions between data marts and data warehouses.

Below are the most sought-after skills and qualifications needed for the job role – excellent research, analysis, and problem-solving skills, extensive knowledge of relational database theory; experience with data modeling and architecture, strong verbal and written communication skills, and strong listening skills for communicating to technical and non-technical team members. A bachelor’s degree in computer science or a related field is necessary.

 

Data Warehouse Analyst Resume example

Data Warehouse Analyst Resume

Objective : Responsible for Working and coordinating with other team members from the Data Warehouse team and also with the Data Exchange team to make sure we meet client deliverable deadlines.

Skills : Database Management, Project Management, BI Reporting, Analytics, Data Standards, Excel, Powerpivot, SQL, Text Analysis, Google Apps, Bitcoin.

Description :

    1. Designed and developed store procedures, tables, views and functions; implemented best practices to maintain optimal performance.
    2. Analyzed and integrated data from various legacy systems.
    3. Developed complex reports using SSRS.
    4. Integrated and replicated data to build data marts and data models.
    5. Involved in creating nightly batch process using Informatica to transfer data from legacy system to SQL Server data warehouse.
    6. Worked on various business reports using Microsoft business intelligent reporting.
    7. Used different functionality of SSRS like sub reporting, drill trough reporting, links, interactive sorting, etc.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
MS In Computing


Data Warehouse Analyst Resume

Headline : Currently under contract with a global media company specializing in on demand video streaming to African audiences. I provide BI reports that drive business decisions.

Skills : Consulting, Nursing, Sales, Teaching, Teaching, Clinical Analyst, Lean Six Sigma, Change Management.

Description :

    1. Gathered, analyzed business requirements and converted them into technical specifications.
    2. Developed Oracle Warehouse Builder (OWB) maps and process flows to load multiple Dimensions and Facts.
    3. Created external table objects based on the FSD to read incoming eligibility and claims data from various clients.
    4. Developed ODI components like interfaces, packages and load plans from scratch.
    5. Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into the data warehouse tables.
    6. Developed PL/SQL packages to load data into various marts, dimensions and facts tables.
    7. Coordinated with clients and vendors to setup and test SFTP connections between their servers and HealthFitness.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
BS


Data Warehouse Analyst Resume

Objective : Talented and skilled IT Professional with around 5.5+ years of IT experience in working on multiple projects based on data warehousing portfolio as an ETL developer Using Netezza/Oracle and Datastage and Business Object Data Services Ability to understand business problems and apply technology to formulate workable solution.

Skills : COBOL, Unica, Cognos, Project Management, Database Architect, Focus, DB2, Data Stage.

Description :

    1. Developed and evaluated data design.
    2. Reviewed and validated data loaded into the data warehouse for accuracy.
    3. Reviewed documentation, peer code and conducted code walkthroughs Responsible for gathering requirements and designing data warehouse Documented and tested all queries used to pull data for reporting purposes.
    4. Interacted effectively with user community to produce analysis results and analytics requirements.
    5. Ensured data integrity and timely output of daily, weekly, and monthly scheduled jobs.
    6. Performed data replication, extraction, loading, cleansing, and data modeling for data warehouses.
    7. Worked on performance tuning on Netezza by using effective bright light optimization techniques to avoid overhead on source, target and intermediate components.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Computer Application

Data Warehouse Analyst Resume

Headline : More than 9+ years of experience in Business/Data Analysis, Design, and Development of complex software systems. Extensively worked on Oracle 9i, 10g, and 11g using SQL/PLSQL. Experienced in gathering business requirement, analyzing and translating it into technical specifications. Experienced in identifying and implementing Business Intelligence strategies.

Skills : Data Analysis, Software Development, Oracle PLSQL/SQL.

Description :

    1. Always focused on Data Analysis and Data Profile.
    2. Extensively used SQL and Excel to identify, analyze and interpret trends or patterns in complex data sets.
    3. Designed and implemented software solutions to meet complex business requirements.
    4. Independently and concurrently worked on Multiple Projects.
    5. Worked closely with Project Team for gathering requirements.
    6. Interacted with business users and business analysts to translate business requirements into technical specifications.
    7. Involved in defining the source to target data mappings, business rules, and data definitions.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
MS In Computer Science

Data Warehouse Analyst Resume

Objective : Responsible for Designing various Access Layers and Data Marts (Physical as well as virtual) by extracting data from the centralized warehouse for complex reporting and analysis, and also Tunning batch queries, views, and reports to run with minimal resource utilization.

Skills : SQL Server, Communication SKills, Accounting Skills.

Description :

    1. Identified and sought personal and professional growth opportunities and proactively contribute to the success of the team and company.
    2. Courageously adapted, celebrated the achievements of others, and take pride in doing quality work.
    3. Developed and leveraged self-awareness and self-management to establish and maintain genuine relationships with colleagues, leadership, and external stakeholders.
    4. Proactively learned about and consciously leverage your unique and powerful Strengths in a manner that supports cohesion and company-wide success.
    5. Acted as liaison with Trading Partners to establish secure data exchange method and troubleshoot issues with file ingestion or validation.
    6. Analyzed EDI X12 and flat file formats containing healthcare data to assure necessary data points are included, data is in an acceptable format, and perform preliminary mapping to assure files can be ingested without issue into the Data Warehouse.
    7. Crafted and distributed analytics of the tracking against established KPIs utilizing Power BI.
              Years of Experience
              Experience
              2-5 Years
              Experience Level
              Level
              Executive
              Education
              Education
              M.S. In Database Systems

              Data Warehouse Analyst Resume

              Objective : Responsible for Performing pre-and post-data load QC to assure data completeness and appropriateness, and also Assisting ETL Specialist regarding any data pipeline issues.

              Skills : Managing Skills, Data Warehouse, Multitasking.

              Description :

                1. Summited ICMA Reporting initiative has been developed to improve, automate, and introduce more controls around reporting.
                2. Decentralized Accounting unit (DAU) s will be using the tools to conduct their validation and to produce analytics on the portfolio.
                3. Created Detailed Design documents to implement ETL strategy to load ICMA Datamart.
                4. Extracted data from CDW feeds for different instrument types.
                5. Designed DataStage jobs to validate and to produce analytics on the portfolio adhering to EUC needs.
                6. Implemented insert/update strategy using repetitive logic.
                7. Various Lookup build hash files and Load ready files are created in the process Created Batch jobs to load various static dimensions, dimensions, and facts Implemented Roll-forward mechanism for generating Adhoc Reports.
              Years of Experience
              Experience
              2-5 Years
              Experience Level
              Level
              Executive
              Education
              Education
              M.S. In Database Systems

              Data Warehouse Analyst Resume

              Summary : Over 8+ years of total IT experience in the Planning, Analysis, Design, Implementation, and Maintenance in different domains of Financial, Manufacturing, Pharmaceutical, Health, and Retail Oriented companies, 7+ years of Data Warehousing experience in designing and implementing Data Warehouse applications using Informatica Power Center.

              Skills : Training Skills, MS Office, Team Work.

              Description :

                1. Responsible for designing mappings, sessions, workflows, Mapplets, re-usable transformations, Shortcuts, Performance Tuning, and Error Handling.
                2. Worked closely with the data modeler and with the business intelligence team for data loads into the staging area, ODS, WH, and data marts.
                3. Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
                4. Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
                5. Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
                6. Implemented Informatica Power Exchange CDC Option to capture the changes for up-to-the-minute data and increasing business agility.
                7. Developed divisional sales performance analysis datamart Developed exception analysis process.
              Years of Experience
              Experience
              7-10 Years
              Experience Level
              Level
              Management
              Education
              Education
              Bachelors In Computer Science

              Data Warehouse Analyst Resume

              Headline : With 8+ years of Data Warehouse Analyst professional experience in Data Modeling, designing, and Data analysis with Conceptual, Logical, and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP) systems. Extensive experience in designing robust data models using Erwin, Sybase Power Designer, and VISIO.

              Skills : Designing Skills, Multitasking, Developing Skills.

              Description :

                1. Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
                2. Involved in extensive DATA validation using SQL queries and back-end testing.
                3. Used SQL for Querying the database in the UNIX environment.
                4. Developed separate test cases for the ETL process (Inbound & Outbound) and reporting.
                5. Involved with Design and Development team to implement the requirements.
                6. Developed and Performed execution of Test Scripts manually to verify the expected results.
                7. Designed and developed ETL process using Informatica ETL tool for dimension and fact file creation.
              Years of Experience
              Experience
              5-7 Years
              Experience Level
              Level
              Junior
              Education
              Education
              GED

              Data Warehouse Analyst Resume

              Objective : Expertise in designing logical data models and physical structures associated with transactional, data warehouse, and dimensional databases with conformed dimensions. Proven proficiency in translating complex business processes into defined data transformations integrating multiple data sources. Data design documented using ERwin primarily for Oracle.

              Skills : Developing Skills, Testing Skills, Test  Casing Skills.

              Description :

                1. Impacted analysis of existing applications.
                2. Created Source to target mapping document.
                3. Prepared of High level, Low-level design documents.
                4. Developed data cleansing jobs.
                5. Developed UNIX wrapper scripts, Shell scripts for validating the data.
                6. Developed sample test data according to Test cases.
                7. Developed Unit Test cases, System Testing documents with respective Test cases/Scenarios with expected results.
              Years of Experience
              Experience
              2-5 Years
              Experience Level
              Level
              Executive
              Education
              Education
              GED

              Data Warehouse Analyst Resume

              Headline : A results-oriented professional with over ten years of healthcare software development experience including product, program, and project management in addition to over ten years of clinical experience. Well-versed in the software development lifecycle, optimizing cross-functional teams, enterprise solutions, content development, and requirements management with a passion for designing and delivering products that customers love.

              Skills : Developing Skills, Planning Skills, Communication Skills.

              Description :

                1. Maintained the Teradata database environment over 10 terabytes of data.
                2. Designed and developed 3M's Account Receivable Reporting System on Teradata Platform.
                3. Worked on backup and recovery strategies on mainframe environment using ARCMAIN.
                4. Supported business users in their reports and query performance.
                5. Developed various DBA tools and macros within Teradata to gather various matrices for data warehouse growth analysis, capacity planning and warehouse usage cost analysis.
                6. Developed ELT (Extract, Load, Transformation) processes using Teradata utilities such as MultiLoad, FastLoad, FastExport and BTEQ.
                7. Identified load strategies, physical design and backup/restore strategies.
              Years of Experience
              Experience
              5-7 Years
              Experience Level
              Level
              Executive
              Education
              Education
              Master Of Computer Applications