Data Warehouse Consultant Resume Samples

A Data Warehouse Consultant is tasked with the duty of transforming data into information via data modeling techniques. Some common roles and responsibilities listed on the Data Warehouse Consultant Resume include – collecting data, enhancing logical models; solving code issues; managing data models; training staff on data modeling; assisting system and data analysis team; providing training to all advance users; preparing all functional and technical specifications documents for developers; coordinating with the cross-functional team; and assisting subordinates in data evaluation.

Qualifications that can highlight a resume include – knowledge of business processes; the ability to use data modeling tools; attention to details; analytical thinking skills; familiarity with coding languages and data warehouse architecture techniques and broad technical knowledge. Aspiring candidates interested in this line of work should mention their resumes a degree in disciplines such as IT, Computer Science, or Software engineering.

 

Data Warehouse Consultant Resume example

Data Warehouse Consultant Resume

Summary : Over 15 years of professional work experience in the Information Management and Analytics space. Aparajita has diverse project experience spanning from strategy development, product implementation, operations management and identification of enhancement areas. Besides delivering successful BI projects and creating new lines of work, Aparajita is extremely adept in developing client relationships and managing the complex dynamics of clients, employees, vendors and other stakeholders in large-scale BI engagements.

Skills : Informatica, Oracle, Sql Server, Unix, Hyper.

Description :

    1. Included performing the role of Data Architect for the finance team, which includes understanding business requirements, developing the physical database, implementing the business logic using Informatica as the ETL tool, creating the ETL routines in Informatica as well as in PL / SQL, and developing Cognos reports to meet the user's reporting needs.
    2. Included performing the role of Business Analyst transforming business requirements to technical specs.
    3. Served as the single point of contact between business users and the development teams.
    4. Performed feasibility analysis of several new applications related to Order Management as well as General Ledger.
    5. Proactively involved in the Reporting module for the Oracle 11i implementation, which included Oracle Reporting.
    6. Included analysis and Understanding business requirements, OWB Installation & configuration in Windows and Unix environments, Identify fields.
    7. Involved in creating universes using Business Objects Designer Created Users and assigned permissions to them using Business Objects Supervisor .
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Master Of Business Administration


Data Warehouse Consultant III Resume

Objective : Over  eighteen (18) years of analysis, Design and software development experience. Performed quality assurance on the designs and development done by the technical teams Familiar with Kimball and Inman methodologies. Extensive experience in data warehouse principles, dimensional, snow flake and relational Actively participated in design and analysis sessions to ensure sound team decision-making Provided direction for entire consulting project or a project team and makes decisions on approaches and procedures.

Skills : Architecture, Database Management, Computer, Hadoop, Teradata, Analytics.

Description :

    1. Migrated existing data from DB2 to Teradata 15.0 Analyze the existing stored procedure in DB2 and translate to Teradata Stored Procedures and BTEQ scripts.
    2. Analyzed the existing Informatica code and develop functional requirement to get data to the new Teradata environment.
    3. Communicated the report changes and work closed with the reporting team.
    4. Involved in data profiling and data modeling for the new requirements.
    5. Responsible for design, development and implementation of Customer and Billing System Data warehouse.
    6. Customized Complex ELT processes and resolved related issues.
    7. Improved ELT architecture and SQL scripts for improved performance.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
MCA In Computer Application


Data Warehouse Consultant II Resume

Objective : Over 9 Years of Experience in ETL Design/Development, Data Modeling, Programming, Testing, Performance Tuning, Implementation, Troubleshooting, Support, Error Handling in the field of Data Warehousing, Application Development and gathering Business Requirements. Expertise in ETL process using Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor, PowerExchange, Informatica Server and Repository Manager.

Skills : : Project Management - 8 years; Lead/Management Experience - 10 years; Agile - 4 years; MS Project - 4 years; Business Intelligence - 10 years; Data Warehousing - 10 years; ETL - 10 years; Informatica - 8 years; OBIEE - 4 years; Oracle - 10 years; MDM - 4 years;.

Description :

    1. Worked closely with the Business Users and Leads in understanding both HCC and WHIRL systems and built the Conversion-Field Mapping documents to load data from HCC to WHIRL Data Mart.
    2. Created Informatica Mappings using Lookup Transformations to validate and cleanse the data prior to loading to staging area by matching with Corresponding WHIRL Reference Tables.
    3. Built Informatica Mappings to handle huge Volumes of data related to HSBC India and HSBC Indonesia customers and loaded the incremental changes to the Customer Data Mart.
    4. Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
    5. Defined maintains, develops and supports specific software applications that support Wellmark's business requirements.
    6. Analyzed, developed, tested, implemented, documented and maintained programs and systems that meet business requirements.
    7. Supported and adhered to Wellmark Software development lifecycle (SDLC), operational procedures and development and security standards by following required processes.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Engineering

Data Warehouse Consultant I Resume

Objective : Nearly 10 years of experience in IT in the areas of analysis, design, development in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Business Objects with Oracle, SQL Server, ParAccel, Teradata V2R5.1, DB2 databases and Netezza. Involved in complete software development life cycle (SDLC) of project with experience in domains like Healthcare, Insurance, Automobile, Banking, Manufacturing and Pharmaceutical.

Skills : ETL Developer, Informatica.

Description :

    1. Coordinated with the Business team to gather user/system requirements and convert them to Technical Specifications.
    2. Coordinated and perform lead duties with offshore team.
    3. Developed Business System Requirements (BSR), High Level Design documents (HLD), Low Level Design documents (LLD) for each Application.
    4. Created Logical and Physical data models in staging database using Erwin tool.
    5. Used Informatica Power Exchange to connect to IBM Mainframe systems (JCL, Cobol Files), JMS (Java Messaging Services) to access data in various formats such as VSAM, IMS and IDMS.
    6. Performed data cleansing to support data conversion activity from source to targets.
    7. Used Metadata Manager to browse and search metadata objects, trace data lineage, analyze metadata usage, and perform data profiling on the metadata in the Metadata Manager warehouse.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

sr. Data Warehouse Consultant Resume

Objective : Over 7+ years of extensive experience with Informatica Power Centerin all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 9.X/8.X/7.X, SQL, PL/SQL, Oracle and Unix. Expertise in using Oracle 10g/11g and had hands on experience in building advanced relational database objects which uses Oracle 10g/11g database.

Skills : Analyze data sources, Distinguish between requirements and wishes.

Description :

    1. Purposed of this project is the enhancement of the Envision to provide external and internal users with reliable, timely and accurate data that can be easily analyzed.
    2. Responsible for Extensively involved in gathering business requirements and translating them into technical requirements.
    3. Responsible loading the data into SAP using BAPI'S and IDOC'S.
    4. Involved in performance tuning at source, target, mapping and session level.
    5. Performed Unit testing, Integration Testing, and User Acceptance testing to identify the inaccuracies.
    6. Maintained warehouse metadata, naming standards and warehouse standards for future application development.
    7. Extracted data from various sources such as Flat Files from Mainframe system, VSAM, DB2 and SAP tables for Inbound and outbound mappings.
    8. Prepared effective documentation for future references.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Master In Computer Applications

Jr. Data Warehouse Consultant Resume

Objective : Enthsiatic learner and a team player. Always aims to procure specific skills and harness her potential to appropriate and gauge the absolute necessities required to be a more efficient individual. Khushali has 3+ years of experience in Information Technology Industry primarily on Business Intelligence, Data-warehouse projects involving all phases of Software Development Life Cycle - starting from the requirement gathering phase till the system testing phase.

Skills : SSIS, SSRS, SQL, Data Warehousing.

Description :

    1. Transformed the data as per the underlying business rules and Load them to the Data Mart.
    2. Prepared technical documentation.
    3. Prepared Unit Test Case for code.
    4. Design; develop codes to carry the ETL process, using SSIS 2012, fetching business driven data from AgWorks Legacy and Current source systems, transform the data per the business rules and load into the Enterprise Crop Insurance Data Mart.
    5. Implemented Incremental load, used Event Handlers to clean the data from different data sources Implemented Masking mechanism, where we generated a Unique Identifier Key for each destination table based on the source key.
    6. Performed administrative tasks like database files management, backup database, restore database, security management, data integration Ensured the .
    7. Performed administrative tasks like database files management, backup database, restore database, security management, data integration Ensured the .
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Master's In Computer Science

Assistant Data Warehouse Consultant I Resume

Objective : Total experience of 11 years in Core and IT field in Requirement analysis, Development, Testing, Implementation and Support of Data Warehousing, ETL, Client Server technologies. 10yrs of experience on Admin, design, development, testing and implementation of Data warehousing ETL tools using SAS Admin DW/BI & Informatica Powercenter.

Skills : MS Office, Oracle, SQL.

Description :

    1. Collaborated with the Business analysts and the DBA for requirements gathering for developing the mappings Developed complex mappings like Slowly Changing Dimensions and concepts like Pivoting Extraction, Transformation and loading of data from SQL Server sources and Flat Files into SAS database.
    2. Extensively used different transformations like SCD Type2 Loader, Lookup, Extract, SQL Join, Splitter, Append, Table Loader, User Written Code, Loop and Loopend.
    3. Worked with huge tables that consisted of above 150 columns and more than 100 million records per each table.
    4. Responsible for monitoring all the sessions that are scheduled, running completed and failed.
    5. Involved in debugging the Mappings that failed.
    6. Documented processing times for each module, developed test cases and used them to run through each process.
    7. Implemented and supported the Business Intelligence environment and User Interface.
    8. Used parameters and variables in mappings using the parameter file.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Associate Data Warehouse Consultant I Resume

Summary : Detail-oriented Data Analyst with expertise in data conversion across database platforms. Extensive experience in design, development and implementation of custom-built extract, transformation and load processes for data warehouses. Skilled in interpreting and analyzing data as well as preparing detailed technical documentation. Wide spread practice using several business intelligence reporting tools.

Skills : SAP Business Objects 6.5 And XI, Microsoft SQL Server 2008, 2010, 2014, SQL Programming, Relational Database Management Systems, Microsoft Office Suite, Tableau Desktop.

Description :

    1. Responsible for the development and maintenance of the data warehouse and enterprise reporting system for HMSHost Inc., an international retail, food and beverage operation formerly known as Host Marriott Services.
    2. Consulted with senior executives as well as support staff, on an on-going basis, to identify ever growing reporting requirements to derive business intelligence from daily operations.
    3. Developed, validated and documented business rules as a result of the information gathering process.
    4. Documented detailed descriptions of reporting requirements, ETL processes, and steps required to develop and maintain a decision support system.
    5. Prepared source to target mapping documentation, ER diagrams and data flow diagrams.
    6. Developed and modified ETL processes, incorporating RDBMS objects such as triggers, cursors and stored procedures into SQL Server DTS jobs, in response to new or enhanced reporting requirements.
    7. Responsible for understanding the data architecture of various source systems such as PeopleSoft HR and Financial modules.
    8. Developed both complex and ad-hoc queries and deliver via Business Objects reports, Analysis Services OLAP cubes and Excel pivot tables.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
B.B.A.

Data Warehouse Consultant/Manager Resume

Objective : Over 16 years of management consulting and information technology experience. His experience includes IT Strategy, Transformation, Planning and Delivery within data warehousing, business intelligence, Oracle OFSAA and reporting solutions. His experience includes data management process (data analysis, data cleansing, data validation, data conversion, and data quality and data governance), data warehouse strategy, roadmap and architectural design, data modeling (logical and physical), Testing and Extract Transform and Load (ETL) tools.

Skills : MS Office, SQL, General Systems.

Description :

    1. Designed & development of EDWRX and CP2.0 data warehouse in Oracle 9i.
    2. Designed & developed ETL mappings/Workflows in Informatica PowerCenter 7 Involved in automating PowerCenter mappings/Workflows for CP2.0 Extensively worked on fine-tuning Oracle database and performance tuning of SQL queries.
    3. Extensively used database partitions, stored procedures.
    4. Worked on operation support of EDWRX and CP2.0.
    5. Involved in data analysis and prepared optimization parameters for a campaign studies.
    6. Created and developed a series of mappings for handling different cases of input data in the same source table.
    7. Used parameters and variables in mappings.
    8. Used Workflow Manager to create session task and other tasks.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelor In Science

Data Warehouse Consultant Resume

Objective : More than 21 years of IT experience in Project management, design, development, data warehousing, ETL, performance tuning, data modeling, and database design for OLAP and OLTP systems. Developed strategy and framework to address advocacy, sponsorship, and assessment of the enterprise Architecture, along with the development standards and guidelines to be used in the program.

Skills : Project Management, 8 Years; Lead, Management Experience, 10 Years; Agile - 4 Years; MS Project ,4 Years; Business Intelligence - 10 Years; Data Warehousing - 10 Years; ETL - 10 Years; Informatica - 8 Years; OBIEE - 4 Years; Oracle - 10 Years; MDM - 4 Years;.

Description :

    1. Scheduled, Maintained and Executed Data Load.
    2. Developed Shell Scripts to bulk-copy data from the flat file to production and developed scripts to recreate the Table indexes, recompile and update the statistics of the Sybase objects.
    3. Generated and modified database schemas.
    4. Developed and enhanced procedures, reports and fixed production bugs.
    5. Responsible for Import, Export, Patch Install, Version Upgrade, Extraction, Data Loading, SQL and PL/SQL Script.
    6. Performed Index rebuild to improve the query performance.
    7. Responsible for the data integrity of the fact tables and dimension tables of the data warehouse star schema.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Master Of Engineering