FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

BI Architect

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 BI Architect Skills

Below we've compiled a list of the most important skills for a BI Architect. We ranked the top skills based on the percentage of BI Architect resumes they appeared on. For example, 9.9% of BI Architect resumes contained Data Warehouse as a skill. Let's find out what skills a BI Architect actually needs in order to be successful in the workplace.

These are the most important skills for a BI Architect:

1. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in BI Architect jobs:
  • Gathered user and functional requirements, developed data models, and implemented NineWest Data warehouse.
  • Gathered user and functional requirements, developed data models, designed and implemented custom developed data warehouse in SAP BW system.
  • Developed BW project plan and estimated cost to implement custom data warehouse for all primary and ceded insurance business reporting.
  • Designed and managed physical and logical data models of enterprise data warehouses, data marts and operational data stores.
  • Gathered requirements, developed data models, designed and implemented custom developed data warehouse on SAP BI 7.0 system.
  • Developed views from the Oracle Data warehouse to feed data to the Application.
  • Created aggregated tables in the data warehouse to improve performance of reporting applications.
  • Design & implement Business Intelligence platform & data warehouse.
  • Involved in data modeling of the Data warehouse.
  • Designed and implemented 4 layers of data warehouse to support operational, regulatory, analytical and strategical reporting.
  • Implement enterprise process improvement efforts in regards to data management, data warehouse, application production support and COTS products.
  • Analyzed the existing OLTP/Transaction system and identified the required database level objects and designed required Schemas in the data warehouse.
  • Mentored and lead multiple teams in BI Analytical Applications and data warehouse implementations at Ford Motor Company.
  • Developed BW project plan and estimated cost to implement custom data warehouse with GRC matrixes.
  • Work with data from: DB2, Oracle and Netezza data warehouse appliance.
  • Designed, analyzed, refactored data warehouse & mart, BI processes.
  • Project: Solutions Development Dashboard and Scorecard Deployment Created Data Warehouse and cubes using Microsoft Sql Server and Microsoft Analysis Services.
  • Experience to model and build an Enterprise Data Warehouse Leveraged industry best practices and methods in designing reporting applications.
  • Design of ETL Architecture, development of Informatica mappings/Workflows to load the data warehouse tables.
  • Provided ETL Solutions for Data warehouses using Informatica Power Center and Informatica Data Quality 3.

Show More

3 Data Warehouse Jobs

No jobs at selected location

2. Dashboards

demand arrow
high Demand
Here's how Dashboards is used in BI Architect jobs:
  • Implemented QlikView solution to provide in-memory business analysis and dashboards.
  • Background This project is about producing SAP BOBJ reports and dashboards out of SAP BI system for utilities & Energy domain.
  • Guided the development team on the type of data sets to create in order to feed into the dashboards.
  • Involved in the enhancement of the ETL design of the Sales dashboards for the Asia Pacific Region.
  • Created multiple reports including Data Visualization (Dashboards) and Active Reports for the Business Reporting Group.
  • Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data.
  • Modified existing reports and dashboards and fixed issues related to performance, data quality.
  • Maintained and delivered several weekly dashboards to FSA as part of the maintenance plan.
  • Integrate Microsoft SharePoint Web Parts with Business Objects to display dashboards on SharePoint.
  • Created test documents that help in validating reports and dashboards in QA.
  • Created and Maintained dashboards for Consumer Financial Protection Bureau (CFPB).
  • Designed dashboards using XCELSIUS and QAAWS and customized ERRB dashboard.
  • Created several pilot dashboards for user sampling.
  • Designed analytics and dashboards using Tableau.
  • Created and maintained several FS, Design documents and Code related to reports, universes and dashboards in Version Manager.
  • Documented standards and best practices documentation that will be followed for all future WEBi reports and dashboards.
  • Created new Xcelsius Dashboards for FSA using the congressional district and state data from Satori.
  • Developed interactive dashboards and reports in Oracle BI Answers highlighting the KPIs.
  • Created Dashboards using Workspace, Workspace Advanced and also portal pages as per the requirement.
  • Designed Dashboards and ad-hoc reports using Tableau for all Ad-hoc analytics projects Worked on reverse Engineering to design the complex reports.

Show More

4 Dashboards Jobs

No jobs at selected location

3. SQL

demand arrow
high Demand
Here's how SQL is used in BI Architect jobs:
  • Structured and maintained initial SQL Server infrastructure including disaster recovery and database mirroring.
  • Defined partitioning strategy, performed extensive tuning (explain plan, logical i/o, waits) and defined best SQL practices.
  • Worked within a group to create a fail-over strategy for Power Exchange Listeners and Oracle and SQL Server databases.
  • Used SSIS to load data from various sources into on SQL Server 2012 database and created packages.
  • Trouble-shoot and optimize SQL stored procedures, implement partitioning, high availability and cloud solutions.
  • Used Denali (SQL Server 2012) to populate the ODS and Data Warehouse.
  • Coded and implemented all backup and restore routines for Oracle and SQL Server.
  • Performed Development tasks with SAP HANA programming including SQL, SQL Script.
  • Develop SQL scripts and stored procedures to provide 4 way recon reports.
  • Analyzed IO performance at logical, physical and application SQL levels.
  • Worked with business users to create SQL scripts for data extracts.
  • Developed R forecast models using SQL Server 2016 R services.
  • Implemented and enforced SQL, universe and reporting standards.
  • Created SQL server agent job to regularly process cube.
  • Created SQL server dynamic configurations for SSIS packages.
  • Worked with data from: SQL Server.
  • Tuned SQL server environment on NT.
  • Installed and administered the Embarcadero ER/Studio model repository on SQL Server.
  • Performed BI Content Administration tasks including scheduling and content management Developed SQL in TOAD and exported results to Access Database.
  • Involved in SQL performance tuning using cost based optimizer and Oracle SQL Advisor recommendations.

Show More

12 SQL Jobs

No jobs at selected location

4. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in BI Architect jobs:
  • Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
  • Designed and validated the process flows for capturing business requirements from Discovery to Pre-Baseline Stages with C-Level Executive Leaderships of client.
  • Defined conceptual data model for marketing database based on business requirements.
  • Gathered business requirements for enterprise wide data warehouse project.
  • Established complex end-routine transformation logic to support business requirements.
  • Converted the business requirements into technical documents.
  • Gathered and analyzed the end-user business requirements.
  • Analyzed Business requirements from the analysts.
  • Involved in requirement gathering, Analyze and understand the business requirements for report and dashboard development.
  • Created Use Cases, User Stories or other required technical assets based on business requirements.
  • Partnered with business owners to capture, and prioritize BI specific business requirements.
  • Complete end to end Involvement from Business Requirements phase to Project Delivery phase.
  • Worked and Documented for Business requirements with the help of client requirements.
  • Created views in Tableau Desktop based on the business requirements.
  • Applied transformation rules based on the business requirements.
  • Gathered business requirements by interacting with the business users and defined subject areas for analytical data requirements.
  • Provide data modeling and detailed requirements analysis to meet business requirements.
  • Analyzed business requirements and defined best way to fulfill them.
  • Proof of Concept to validate feasibility of the new tool Oracle OBIEE 11g and Tibco Spotfire to meet the business requirements.
  • Created ad hoc reports in Query Studio Cognos 10.2.scheduled reports using autosys in eventstudio Translated the business requirements into technical documents.

Show More

5. ETL

demand arrow
high Demand
Here's how ETL is used in BI Architect jobs:
  • Translated requirements into designs for a solution that incorporates ETL components.
  • Created the Data & ETL Architecture Reference document and guided RAD sessions between reporting, modeling, mapping and ETL teams.
  • Analyzed the current ETL process for the current reporting system and documented my suggestion to the super users.
  • Involved with major aspects of QlikView development, including scripting, data modeling, data optimization, ETL.
  • Designed, developed ETL, and extracted BW Data to Non- SAP System using Open Hub service.
  • Monitored data quality, resolving problem data issues with SSIS ETL jobs and ensuring timely updates.
  • Standardized ETL Development by introducing best practices and creating Landscape document for each Environment.
  • Created and maintained ETL application to load sales data into SQL 2008 data mart.
  • Worked on the currency conversion both at the ETL and Reporting layers.
  • Analyzed and debugged the data issues with the SSIS ETL jobs.
  • Migrated ETL routines from 11g R1 to 11gR2 OWB environment.
  • Created HLD, ETL Specs and developed pilot.
  • Designed and implemented ETL process for BI Solution.
  • Assigned estimated complexity for Reporting/ RPD/ ETL/OBAW.
  • Improved, designed new ETL processes.
  • Approved Oracle as the repository, Informatica as the ETL tool, and Business Objects as the Portal and Reporting tool.
  • Interacted with various business teams and resolved the issues in production support for Cognos and SSIS ETL.
  • Performed source to target data mappings for the SSIS ETL and Cognos Reporting teams.
  • Created new ETLs using informatica to handle complex multiple hierarchy reporting requirement.
  • Star Schemas, capacity plan, Data Stage ETL, Business Objects Universes 4.0, Webi & Dashboard.

Show More

2 ETL Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Web Intelligence

demand arrow
high Demand
Here's how Web Intelligence is used in BI Architect jobs:
  • Delivered an end-to-end BW on HANA based data model including front end reports via Analysis for Office and Web Intelligence.
  • Documented the recommendation of administrating servers and contents in XI 3, universe development and web intelligence reporting.
  • Created custom hierarchies to aid in Drill-Through analysis of Web Intelligence documents and built cascading prompts.
  • Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
  • Generated reports using SAP BusinessObjects Web Intelligence 4.0 and provided end user training.
  • Designed and Developed BO reports for Budget Input Application using Web Intelligence.
  • Created and maintained Universes, Web intelligence and Rich Client reports.
  • Designed and created reports using Web Intelligence in Business objects.
  • Created complex Web Intelligence reports with multiple data providers.
  • Created and maintained Business Objects & web Intelligence reports.
  • Created complex dashboards and reports using SAP BI Dashboards, SAP Lumira, SAP Design Studio, Tableau and Web Intelligence.
  • Designed and developed fully self-servable universe for Willow Ambulatory module with a set of canned Web Intelligence reports.
  • Worked on distributing, maintaining, and optimizing BusinessObjects universes for Web Intelligence, Lumira and Explorer reporting.

Show More

7. Architecture

demand arrow
high Demand
Here's how Architecture is used in BI Architect jobs:
  • Provided technology directions for the database development and technical architectures.
  • Designed APO-BI interface architecture design and implementation for Demand Planning.
  • Worked on BPC application architecture, performance enhancement using optimization
  • Trained Cognizant Internal Project Folks for Hybrid architecture implementation.
  • Provided management with strategies for development and computing architecture.
  • Defined high-level future-state application architecture and infrastructure.
  • Defined future state data architecture.
  • Redesigned Architecture for self-service BI framework which involves setting a guideline for entities in Physical data model and Semantic layer design.
  • Lead a data architecture team in developing value added product and services for banking.
  • Functioned as Data Architecture lead on the consolidation of multiple Auto Warranty/Claims BI applications.
  • Developed the Knowledge System using the J2EE Architecture.
  • Created the future state technical architecture.
  • Trained advanced programming, architecture, software lifecycle, methodology.
  • Created flexible scalable architecture while emphasizing performance and business needs.
  • Documented the BI Strategy & Data Architecture that comprises of high-level for both the HANA instances ECC/Integrated BPC and Insurance Analyzer.
  • Trained users and demoed the Front End Business Integration BI Architecture, Business Intelligence Enterprise Platform and Infoview portals.
  • Support and manage a Load Balanced Cognos Architecture (6 Gateways, 9 Dispatchers and 5 Contents Store).
  • Delivered an Enterprise Architecture and a self-service BI framework which is a foundation for Digital data analytics.
  • Worked in both IT and Business Teams, and architectured the applications to suit the model.
  • Architected optimal & scalable BI architecture to support JPMC strategic initiatives.

Show More

17 Architecture Jobs

No jobs at selected location

8. Analytics

demand arrow
high Demand
Here's how Analytics is used in BI Architect jobs:
  • Mentored the development team to create Business Analytics reports using Microsoft Reporting Services.
  • Gather document requirements from end-users for new applications/Active reports/analytics.
  • Brand new data mart creation for Admission, enrollment and student retention analytics with in 4months time frame end to end.
  • Worked with senior architects and advisory software engineers to perform analytics on the Hedging system which is Grid enabled.
  • Created and scheduled Agents to deliver Analytics content for subscribed users and to seed the cache.
  • Created SQL extracts and interactive dashboards for Tableau 8.1 to make data available for visual analytics.
  • Worked with Product Owners to identify, analyze, and modules to activate Analytics Dashboards.
  • Develop ETL Automation and Enhanced Business Intelligence Analytics for all areas of the enterprise.
  • Author of small data framework for near real time web and mobile analytics.
  • Experienced in creating dashboard using Visual insight to do analytics on fly.
  • Create standards for ETL and BI Analytics.
  • Author of a Business Intelligence Javascript Framework for HTML5 Analytics, Dashboard and Reporting system with machine learning.
  • Lead BI teams of 2-10 onshore and offshore report developers delivering Cognos Analytics (11) reports.
  • Implemented Tableau COE at Enterprise level CEO and CIO Management Dashboards creation and maintenance through advanced analytics.
  • Correlated various PS3/PS4 Game Titles popularity, Player Analytics, eCommerce data and Pricing models.
  • Conducted unit, integration and system testing for all components in Pentaho Business Analytics.
  • Display Advertising Data Marts including Pricing and Yield Management DM and Financial Analytics DM.
  • Design Cognos Analytics Framework Manager models including DMR layers.
  • Train personnel on Webi reporting and analysis Project management and analytics.
  • Deployed geo analytics Spotfire solutions using company provided shape files.

Show More

8 Analytics Jobs

No jobs at selected location

9. Ssis

demand arrow
high Demand
Here's how Ssis is used in BI Architect jobs:
  • Assisted Business Analysts in the gathering of requirements specific to support complex technology initiatives.
  • Develop and implement data extraction procedures utilizing Microsoft SSIS and other various tools.
  • Assisted in troubleshooting software application issues.
  • Designed SSIS Packages to transfer data from various sources like Excel Files, SQL Server using Business Intelligence Development Studio.
  • Installed and configured several tools including but not limited to SQL Server 2005/2008, SSIS 2005/2008, SSRS 2005/2008
  • Developed ETL packages using SSIS 2008 for loading Dimensions, MDS Entities and Facts for the DWH.
  • Assisted in developing generic graphs for data cleansing, validation and transformation using Ab-Initio.
  • Assisted users in the professional system design concepts and business standards and conventions.
  • Designed, Developed and Deployed packages in SQL server environment using SSIS-2013.
  • Assist developers in design and implementations, ensuring best practices are followed.
  • Worked as lead and developer to assist with various business users.
  • Support, Maintain and develop SSIS Packages for ETL process.
  • Assist Developers in fixing performances and meet the deadlines.
  • Modified SSIS Packages in the source applications when necessary.
  • Develop ETL (SSIS) package and automate scheduling.
  • Assisted with troubleshooting performance issues with ODI loads.
  • Assisted in creating the functional requirements document.
  • Assist in building strategy roadmap and perform proof of concept to transform current BI landscape into HANA platform.
  • Involved in re-architecting the existing SSIS packages based on the new business rules.
  • Assisted in designing the data flow process between the tool set of PROVISION, ERWin and CONTIVO for the client.

Show More

4 Ssis Jobs

No jobs at selected location

10. Cognos

demand arrow
high Demand
Here's how Cognos is used in BI Architect jobs:
  • Developed advanced sales reports in Cognos 8 which required formatting according to very precise specifications.
  • Proposed solutions for Cognos report performance tuning.
  • Managed all Cognos Framework Manager modeling.
  • Performed user acceptance testing and end user training for Cognos Users and involved in Data validation and testing procedures.
  • Improved the performance of Cognos reports by changing the Framework Manager model and database object relationships.
  • Enhanced the database stored procedures and resolved issues with importing them into Cognos Framework Manager.
  • Used Cognos Impromptu to present the data mining analysis in a report format.
  • Worked on installation of Cognos 10 and validated the current report content.
  • Worked with IBM Cognos support as part of logging bugs and enhancements.
  • Implemented security in report level and Framework Manager of Cognos 10.2.
  • Worked on Cognos DQM model enhancements and changes to framework model.
  • Analyzed the model rules and calculations in Cognos Analysis Studio.
  • Worked as a Mentor for Cognos training for Business Users.
  • Provide Cognos user support and troubleshooting with the testing team.
  • Worked on the Enhancement of Cognos reports.
  • Modified system configuration files and customized Cognos 10 portal and added enterprise logos.
  • Implemented Cognos Security using CAM in Cognos environment.
  • Worked on IBM Cognos Lifecycle Manger 10.0.1 for validating report content and for the introduction of new environment.
  • Developed Cognos 10.2 Reports which included reports with multiple charts, crosstabs, and lists.
  • Worked with Cognos 4Thought and Cognos Scenario to create predictive models and analyze data.

Show More

2 Cognos Jobs

No jobs at selected location

11. SAP BW

demand arrow
high Demand
Here's how SAP BW is used in BI Architect jobs:
  • Created data models from different source systems and modeled the as a composite provider in SAP BW basing on SAP HANA.
  • Developed Forecasting Error and Replenishment Error reports in SAP BW which are used by business for calculating safety stock.
  • Designed Balance carry Forward solution within SAP BW to support P&L and balance sheet reporting.
  • Developed custom financial reporting in SAP BW to meet business requirements for analyzing business profit and loss.
  • Install and activate SAP BW Standard Content for SPM and other HR project requirements.
  • Implemented standard and best practices in integrating SAP BW and BPC.
  • Designed BO Universes connecting to SAP BW cubes and created reports.
  • Designed the migration of legacy reporting environment to SAP BW.
  • Design lead for the proposed model in SAP BW.
  • Developed universes that access SAP BW.
  • Worked on Upgrade from SAP BW 3.5 to SAP BI 7.0 and SEM 4.0 to SEM 6.0.
  • Analyzed the stand-alone BI systems (SAP BW, Oracle, and Legacy).
  • Provided following Procurement and FI Dash boards with SAP BW as backend and SAP BO & Design Studio as front end.
  • Developed SAP BW Backend Objects, Queries and Layouts to meet Business requirements for the community of BD users.
  • Create proof of concept demos for Business Objects Front End to SAP BW backend Integration.
  • SAP BW 7.3 and 7.4 on HANA, SAP Design Studio 1.5 1.
  • Install and activate SAP BW Standard Content for MII charts replacing with BEx quries.
  • Performed BI technical upgrade from 3.X to 7.X and migrate SAP BW 3.X content and reports into SAP BI 7.0.

Show More

1 SAP BW Jobs

No jobs at selected location

12. Informatica

demand arrow
high Demand
Here's how Informatica is used in BI Architect jobs:
  • Provided development best practices and technical support on the installation/configuration and development using Informatica.
  • Lead POC efforts for the following Informatica Products: PowerCenter Real-time web services, Release management and Metadata Manager.
  • Designed two Data Marts that included system architecture, logic data design, data mappings, and Informatica ETL.
  • Optimized the performance of the Informatica mappings by analyzing the session logs and understanding various bottlenecks (source/target/transformations).
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
  • Experience on working with running daily jobs on Informatica for data loading.
  • Extracted Data from various source systems using Informatica and stored procedures.
  • Implemented all the data quality rules in Informatica data quality.
  • Model the data load with Informatica lead.
  • Identified infrastructure needs for implementation of the new environment including the latest greatest Informatica Tool releases.
  • Created DAC Metadata Repository, configured the Oracle Business Analytics Warehouse Database, and registered Informatica Servers in the DAC Client.
  • Performed the role of SAP Business Objects SME and also supported Informatica Power Center efforts.
  • Developed the ODI/Informatica Mapping and Workflow.
  • Developed Etl Mappings Using Informatica.
  • Implemented integration of business segmentation between Informatica MDM and Salesforce for Sales Process using Informatica Web service (SOAP).
  • Developed UNIX shell scripts and Batch Informatica scripts to invoke Informatica workflow in batch jobs.
  • Installed and configured Informatica PowerCenter and Required Patches to setup the Informatica Server and Informatica Repository.
  • Developed Informatica Sessions & Workflows using Informatica workflow manager.
  • Designed and developed complex Informatica Mappings, Mapplets, Worklets and Workflows to support the Pathway ETL effort.

Show More

1 Informatica Jobs

No jobs at selected location

13. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in BI Architect jobs:
  • Design and development of both statistical and BI related reports using SSRS and Stored Procedures.
  • Used that calculated measures in SSRS reports by using source connection as cube in SSRS.
  • Generated reports in SSRS and then used the same data for the Tableau dashboards.
  • Designed and implemented reporting server to house and distribute SSRS reports.
  • Installed and configured SSRS 2008 and SSRS 2012 Reporting Services.
  • Implemented 'forms authentication' on SSRS using custom security extensions.
  • Created a Master SSRS report with more than 200+ sub-reports.
  • Developed integrity check reports with SSRS.
  • Designed the data driven SSRS template.
  • Design and development of SSRS Reports.
  • Create multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Design & Code SSRS reports.
  • Architected and deployed BI Solution for Windows OEM using Share-Point, SSRS and SQL Server 2013.
  • Designed and developed reports in SSRS Diagnose and fix issues reported in Development and Production environment.
  • Recreated legacy .net reports and SSRS reports in Business Objects and provided same functionality.
  • Created Adhoc reports to show the business using SSRS and Tableau.
  • Improved reporting SSRS (datasets/design)
  • Create SSRS reports for Roambi.
  • Created various reports (Sub reports, Drill Down, Drill Through, Charts etc ) using SSRS.
  • Design analytical reports/Dashboards using QlikView on Vertica and SSRS on SSAS cubes/ Data ware houses.

Show More

1 Ssrs Jobs

No jobs at selected location

14. Ssas

demand arrow
high Demand
Here's how Ssas is used in BI Architect jobs:
  • Developed various SSAS Tabular Models to facilitate data validation for Enterprise Data Warehouse development project.
  • Created new reports and updated existing reports (Online Reports, Customer Reports) that sourced information from the SSAS Cube.
  • Design, development and support of Dimensional data model using SSAS Cubes on top of MS SQL 2008 Data Warehouse.
  • Converted an executive level performance reporting system built in SAS to one built on SQL Server SSAS and SSRS.
  • Developed SharePoint solutions with SSRS reports and web parts for external clients based on data rendered by SSAS cubes.
  • Designed and developed a solution for financial reporting using SSAS and Excel to replace the current Hyperion based solution.
  • Use SSAS to validate the results of loading incremental data made up with SSIS packages.
  • Developed a custom SSAS DLL that generated Member Sets based on a keyword parameter.
  • Develop and architect SSAS cubes using tabular and multidimensional cubes for self-service BI.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Developed SSAS data mining models for predictive analysis for sales and marketing.
  • Created SQL Server Analysis cubes to support SSAS, SSRS reporting requirements.
  • Provided expertise in SSIS, SSAS design, configuration and customization.
  • Created Analysis tabular cube using SSAS.
  • Designed and developed multi dimensional Cube databases using SSAS.
  • Developed SSAS Tabular Models for the company s Prologis One Executive Dashboard.
  • Cube Development using SSAS 2012 (both multi-dimensional and tabular).
  • Deployed SSAS dimensions for BI reporting using Cognos and Crystal Reporting.
  • Developed several multi-dimensional OLAP cube in SSAS using the data warehouse schema Implemented parent-child & regular hierarchies for rolling up data.
  • Defined and designed project scope Create Dimensions and Fact tables Designed, built and deployed MOLAP cubes in SSAS.

Show More

1 Ssas Jobs

No jobs at selected location

15. Olap

demand arrow
average Demand
Here's how Olap is used in BI Architect jobs:
  • Involved in designing and developing subject areas in Repository (.RPD) catering to the OLAP reporting needs of OBI Project.
  • Structured the reporting requirements and consolidated the reporting needs against OLTP and OLAP (TM1 Cubes, MSAS) sources.
  • Designed and created the reports against relational and OLAP databases as per the user requirements using SSRS 2005.
  • Developed complex ragged hierarchies for sales and market into flat structures for reporting on OLAP.
  • Worked on Dashboard development using Design Studio with BW OLAP sources as the back-end.
  • Developed OLAP application including the SAS MDDB Viewer and Microsoft Office Web Components.
  • Created brand new OLAP cube for Online Reporting and Customer Reporting.
  • Designed multiple Cubes using IQD's using Transformer for OLAP.
  • Designed and created Universe based OLAP Queries in BW.
  • Designed and Implemented OLAP Cubes.
  • Designed and built data mart for SAS OLAP-based applications used in the delivery of market analytics service (predictive analysis).
  • Worked with both Relational Universe's and OLAP Universe's and designed several WEB-I reports on top of these Universe's.
  • Created OLAP Universe from SAP BI cube / Multi-provider / ODS data model in Universe Designer.
  • Configured DAC server host along with informatics servers and OLTP and OLAP physical sources.
  • Created Universes and Reports based on BEx quires and OLAP reports with BICS.
  • Worked on Business objects OLAP Reporting systems based on BEx Reports.
  • Design and implement Cubes in Multi-dimensional OLAP format in SSAS environment.
  • implemented OLAP cubes with different dimensions for decision support using UDM Complex Migration from MS Access database Applications into SQL database.
  • Upgraded Cognos 7 environment to Cognos 8 along with all key components such as Portal, reportnet, OLAP Cubes etc.
  • Verified and created the mdls for olap cubes, using packages and CSVs.

Show More

1 Olap Jobs

No jobs at selected location

16. ECC

demand arrow
average Demand
Here's how ECC is used in BI Architect jobs:
  • Extracted Data from Existing BI Info Providers and ECC Custom Data Sources using Generic extraction and also using Flat files.
  • Created an overall design and proposed architecture to stage the FI data from new GL in ECC to BW.
  • Used address cleansing packages for cleansing the Employee Address of DART across the globe and loading in to ECC.
  • Loaded the data from ECC to BI and used initialization with delta update and full update methods.
  • Gathered user and functional requirements to replicate the ECC content in HANA using data provisioning.
  • Extracted data from all modules with ECC systems and ABAP when needed.
  • Worked on data reconciliation, comparing ECC System with BI System.
  • Collected and transported both ECC and BI developments across the landscape.
  • Developed Crystal reports on SAP ECC to provide operational reports.
  • Configure STMS for the newly installed SAP ECC6.0 Landscape.
  • Extracted the data from ECC to BW using CCA.
  • Developed several Attribute, Analytic and Calculation views using ECC Sales, Billing, Delivery and Material Master Tables for COE.
  • Developed custom staging cubes to provide ECC and Subs Revenue data to EPM10 for consolidation, management and intercompany matching applications.
  • SAP ECC and BI Implementation Conducted the SAP BI Blueprinting sessions for Financial, HR and Global Delivery departments.
  • Designed and developed Asset Accounting flow from ecc and developed Asset Reports (BEx reports).
  • Created BEx queries for Key Performance Indicators, and reports to validate against ECC MC.9 reports.

Show More

17. BO

demand arrow
average Demand
Here's how BO is used in BI Architect jobs:
  • Performed requirements gathering and developed new Reports and Dashboards.
  • Re-designed revenue recognition reports to return the data in the dashboard from 1hour 15 minutes to less than 3 seconds.
  • Worked with the several business users and key stake holders to publish dashboard reports to new business units.
  • Improved the Summary dashboard query performance by 98% and engineered a creative solution to handle multiple hierarchies.
  • Collaborated with various parent company teams in integrating IFS's reports in the single client solution platform.
  • Improved the performance of the dashboard reports from 20 minutes to less than 3 seconds.
  • Worked with Executive Management to map the corporate metrics to the individual scorecards and Dashboards.
  • Designed the User Interface for Scorecards and Dashboards using Microsoft Scorecard Builder.
  • Developed single and multiple dash boards and score cards using Business Objects.
  • Published the scorecards and Dashboards in Microsoft SharePoint Portal.
  • Modeled using both Star Schema and Snowflake Schema.
  • Developed Dynamic dashboards and scheduled automated multi-media notifications and alerts.
  • Re-developed dashboard reports from BusinessObjects 3.3 to Microstrategy 9.
  • Managed a team of 5 members to implement BI solution using BO suites Partnered with SAP to implement and develop SuPM.
  • Build Dashboards using SAP BO Dashboards (formerly Xcelsius) and SAP Design Studio based on requirements of different reports.
  • Worked extensively on extracting data from iSeries and loading HCM objects in to ECC 6.0 using BODS via LSMW/ABAP.
  • Developed and tested Cognos Active Reports and Dashboard Reports.
  • Worked on Cognos Advanced and Workspace Advanced Business Insight to create Executive Dashboards and Active Reports.
  • SAP Design Studio Dashboards on BEx: Optimize back-end and developd complex interactive dashboards.
  • Project: OBIA Finance Analytics - Biogen Improved Cost Center Management Dashboard query performance by 94%.

Show More

18. Obiee

demand arrow
average Demand
Here's how Obiee is used in BI Architect jobs:
  • Row level and role based security design integrated with e-BS using LDAP, OBIEE variables, initialization blocks.
  • Worked on OBIEE publisher to publish the reports and dashboards to the users in different formats.
  • Configured Usage tracking, BI Scheduler, Proxy user and Cache Management in OBIEE.
  • Implemented OBIEE security from Security Infrastructure setup (WLS Console and EM) i.e.
  • Map viewer Integrated with OBIEE for Geographical based Reports and published into Dashboards.
  • Developed test cases, scenarios, scripts to validate functionality of OBIEE Solutions.
  • Automated numerous reports which were earlier done in MS Excel sheet in OBIEE.
  • Trained Developers and Business Users on OBIEE Answers/Dashboards and RPD Development.
  • Designed & Implemented Map viewer integration with OBIEE 12c.
  • Integrated Windows Active Directory authentication LDAP with OBIEE.
  • Developed Reports with different Analytics Views (Drill-Down, Pivot, View Selector and Tabular with Filters) using OBIEE Answers.
  • Installed, Configured and Developed OBIA Financial, Project & HR Analytics 11.1.1.9.x for Oracle with OBIEE 11G.
  • Involved in testing the DW Involved in creating physical layer, BMM layer and presentation layer in OBIEE11g.
  • Worked on NewBreed conversion project, converted 100+ NewBreed reports developed in Oracle OBIEE to Cognos.
  • Created Table, charts, narrative and other views in OBIEE Answers with drilldown capabilities.
  • Performed OBIEE report validations by comparing data against Siebel Applets and views.
  • Create Cognos, Tableau, and OBIEE dashboard & scorecard reports.
  • Design and development of Qlikview applications Migration of OBIEE dashboards/reports to the MS BI stack using tools like PowerPivot and SSRS.
  • Project Insights: OBIEE/Tableau Implementation BI Implementation at SSA is an OBIEE 12C Analytics implementation which includes leveraging Functionality EPM Analytics.
  • Key Projects: Platform Upgrade from Siebel Analytics 7.8.4 to OBIEE 10.1.3.4.1 Platform Upgrade from OBI 10.1.3.4.1to OBI 11g.

Show More

19. KPI

demand arrow
average Demand
Here's how KPI is used in BI Architect jobs:
  • Gathered capacity planning and end-user requirements for KPI development.
  • Designed and Developed dashboards, scorecards, charts, trends to show various KPI's to different kinds of users.
  • Designed and Developed Score Cards using KPI's identified by the business, making them available for analysis and reporting.
  • Involved with the functional team gathering KPI's and metrics for marketing subject area and completing the functional design.
  • Defined KPI's like Application availability, Security Vulnerability, Hardening and Patching by coordinating with CIO direct reports.
  • Conducted and gathered business requirements and metrics for major KPI system developed in Business Objects suite of products.
  • Led design and development of KPI dashboards for Claim, Member, PDE, and Executive Report Card.
  • Supervised design and development of 12 ETL projects using DataStage on KPI, Pharmacy Audit and FWA etc.
  • Worked extensively on LO Cockpit, BOM (Bill of Materials) and COPA extractions.
  • Designed and implemented ETL process to integrate multiple databases onto data warehouse for KPI reporting.
  • Designed and Developed data models for Logistics Cockpit Extractors e.g.
  • Interacted with business representatives for Need Analysis and to define KPIs for Business and derive functional specifications.
  • Led the design of the maturity model and a process driven framework to measure the various KPIs for future growth and sustainability
  • Worked with clients to develop processes to convert transactional data to dimensional and develop KPI's off the dimensional data.
  • Enhanced case fill logic for KPI calculation ordered vs delivered count without distrurbing the existing KPI logic.
  • Developed and facilitated Requirement sessions for partner incentive programs KPIs for Europe and USA.
  • Designed/developed Dashboards, KPIs, Reports, data modeling while managing 3 outsourced resources.
  • Create Dash Board and KPI using SAP Business Objects 4.0 and Lumira.
  • Project-based database development (SSDT), SSIS, DWH, SSAS Cubes and KPIs, MDX, SSRS, Maps.
  • Created KPI/Dimension matrix Created UAT scripts Created Unit test scripts and conducted UAT, recorded changes and tracked to closure.

Show More

20. Schema

demand arrow
average Demand
Here's how Schema is used in BI Architect jobs:
  • Developed Extract/Transform/Load jobs using STAR Schema and followed development standard into different projects.
  • Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
  • Involved in modeling activities which includes building Star Schema, etc as per business requirements with emphasis to performance.
  • Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
  • Worked with the ETL team to design the Star Schema and populate the Data warehouse.
  • Designed and implemented database schema for the use of internet base search engines.
  • Developed Logical and Physical Data Models and Star-Schema design using ERWIN.
  • Developed Schema objects, public objects and OLAP functionality.
  • Analyzed and implement database schema's utilizing E/R tools.
  • Designed and developed MicroStrategy Schema Objects like Attributes, Facts and Hierarchies using Microstrategy Desktop.
  • Created the conceptual and physical data model in CA Erwin Implemented Data Modeling Best Practices over the ConvaTec Data Schema.
  • Established the LDG Oracle database configuration, schemas, and Data Definition Language (DDL).
  • Created Schemas, table definitions, Attributes, Measures & Hierarchies in HANA.
  • Designed with SAP HANA Administration including managing schemas, data model objects.
  • Designed the datawarehouse using Star Schema.
  • Designed multiple schemas and table definitions.
  • Created dimensions model star schemas.
  • Designed Star schemas and dimensional models for Warehouse Management system and Labor management systems for UNFI's 12 national warehouses..
  • Modified existing transactional schema to allow creation of cubes from mirrored transactional databases.
  • Developed complex FM model with multi star schemas to support several functionalities.

Show More

2 Schema Jobs

No jobs at selected location

21. BEX

demand arrow
average Demand
Here's how BEX is used in BI Architect jobs:
  • Connected SAP Dashboard to SAP BEX queries utilizing BICS connection with triggers in dashboard
  • Created reports in BEX and WAD and publishing and testing in Portal.
  • Created report for Headcount, Payroll and Benefits BEX Reporting.
  • Developed flexible reports using flat files and navigational attributes in Bex analyzer to facilitate the analysis in a drill down mode.
  • Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx.
  • Adhered to SAP best practices to design BEx queries and WEB-I reports for performance optimization of Financial reports.
  • Created BICS connection using Information Designer Tool (IDT) to enable BEx Queries for BOBJ Reports.
  • Conducted training on BEx usage for Business Users and Web training and new features to power users.
  • Created & schedule Crystal reports and deployed them through BI Launch Pad with Bex as source.
  • Created and maintained Universes on BEx queries to address FI, SD and MM reporting requirements.
  • Published BEx reports on Enterprise portal 7.0 using Custom WEB templates.
  • Created Dynamic Dashboards using SAP BI data/ BEx Queries.
  • Worked on BEx reporting, Data modeling and Extraction.
  • Recreated Existing BEx reports using Web Intelligence Reports.
  • Build Web Intelligence Queries over BEx Queries.
  • Developed Budget variance, Internal Order, cost center, project system reports using BEx to support Rubics team needs.
  • Created OLAP Universes on SAP data (Infocubes / BEx queries) and Relational Universes on Non-SAP data
  • Created BEx queries, so that the performance is optimized at the BO Webi Reports and Dashboards.
  • Followed up by Implementing Multiprovider to integrate COPA and Sales Data for BEx and Tableau reporting.
  • Designed and developed 5 WEBi reports using BEx Queries as a dataSource.

Show More

22. BI

demand arrow
average Demand
Here's how BI is used in BI Architect jobs:
  • Designed and delivered data model and OBI solution that would dynamically add dimensions and measures with minimal effort on development.
  • Stabilized the product in 45 days by fixing key issues and reduced the # of reported incident by 90%.
  • Major implementation includes Visa Sales Analysis system, Visa Reporting and Billing application and Transaction research life cycle system.
  • Worked on creating aggregates and BI accelerators, applied compression and partitioning techniques to tune the query performance.
  • Enhanced Usage tracking to deliver key metrics for IT Directors and Systems team to monitor OBIEE effectively.
  • Provided best practices and setup MUD environment for 18 obi developers to work concurrently on different release.
  • Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports.
  • Documented the process of removal and upgrade of ODI and OBIEE from the application server.
  • Fine-tuned the existing data model by creating Bitmap indexes, Binary tree indexes and Partitions.
  • Established clear guidelines on developing, testing and deploying OBIEE components from Development to Production.
  • Worked on data conversion to combine the Old PCA Data with the New GL data.
  • Turned around OBIEE usage from less than handful to 275 active users every day.
  • Implemented new financial Metrics and designed new data mart for BI reporting
  • Defined and streamlined the OBIEE 11g automated testing methodology.
  • Trained business analysts and developers on OBIEE 11g nuances.
  • Stabilized the frequent ETL failures and Improved DAC load time from 19 hours to 7 hours in less than 4 weeks.
  • Created custom performance monitoring platform for OBI to track Weblogic metrics using WLST and Unix Shell scripts.
  • Deployed several prototypes on Exalytics environment to prove feasibility and benchmark performance for SLA's.
  • Build Webi's over Universes and BEx Reports.
  • Build BEx and Webi Queries.

Show More

28 BI Jobs

No jobs at selected location

23. Pl/Sql

demand arrow
average Demand
Here's how Pl/Sql is used in BI Architect jobs:
  • Recommended & debugged legacy PL/SQL packages, procedures, functions and views for systems & converted them in to ETL.
  • Developed PL/SQL packages and created Temp tables, which were used in ODI and to develop reports in BI.
  • Used PL/SQL cursor for loops in the stored procedures to perform complex row level calculations on the records.
  • Updated PL/SQL scripts to validate snap shot process of data in DWH.
  • Created PL/SQL stored procedures using cursors and complex SQL queries.
  • Created PL/SQL stored procedures, functions and triggers.
  • Worked extensively on PL/SQL and SQL languages.
  • Worked on Oracle R, Oracle APEX, Oracle BI Publisher, Java, BPEL and PL/SQL.
  • Coded in SAS, SQL (especially PL/SQL), and scripting languages.
  • Develop automated monitoring process within Composite using complex PL/SQL procedures and Autosys.
  • Worked with Bulk Collects, FORALL and PL/SQL Tables to improve the performance of multi-row queries by reducing the context switching.
  • Enhanced the open source PL/SQL test harness framework UTPLSQL created by Steven Feuerstein to adapt to the test harness engine.
  • Involved in the development of PL/SQL scripts for pre & post session processes to automate daily loads.
  • Developed automated dialer list script to give list of customer to be called in Perl, PL/SQL.
  • Used dynamic sql based stored procedures extensively to leverage powerful aspects of PL/SQL.
  • Used many pre-processing, post-processing, and validations scripts using Oracle PL/SQL.
  • Developed backend packages, procedures and PL/SQL to process high volume data.
  • Project: Automated Unit Test Engine Architected and implemented the Unit Testharness application to unit test PL/SQL stored procedures.

Show More

24. Master Data

demand arrow
average Demand
Here's how Master Data is used in BI Architect jobs:
  • Evaluated Metadata Management Solutions and built a case for Enterprise Metadata/Master data Management Solutions.
  • Implement Master data Tools (EDM and DQS), Security and Price Masters from external sources and Data governance solutions.
  • Designed and deployed data governance process for managing the master data, using IDQ for analyzing data quality/ data profiling.
  • Worked on Development, Data Load and Deployment of Data Model for Clients using SQL Master Data Services 2012.
  • Implement Data Governance for Master data using SAP Master Data Governance (MDG) for Customers and Supplier.
  • Set up master data and transaction data in BW & R/3 systems for unit & system testing.
  • Master Data Models provided single point of maintenance and consistency of design in all children models.
  • Created Information architecture strategy which included the use of a Master Data Management data hub.
  • Worked on creation o f Master Data Management (MDM) for retail products.
  • Helped them to create Master Data Management Warehouse & Data lake repository for reporting.
  • Developed Process Chains for various Master data pulls and data movements.
  • Developed Infproviders, Transformations and related master data for Consolidation.
  • Provided master data management and metadata repository using Rochade.
  • Assist in design and coordination of Master Data Management (MDM) approachs utilizing InfoSphere.
  • Support BPC frontend team to loading master data and transaction data from BW.
  • Enhanced master datasources in CMOD for Plant Maintenance Work Order header data.
  • Created Infoset for master data to enabling querying on data.
  • Web Dynpro model lets users maintain master data and plan on it on a easy to use interface.

Show More

25. Sharepoint

demand arrow
average Demand
Here's how Sharepoint is used in BI Architect jobs:
  • Implemented SharePoint portals to manage application development projects.
  • Created links to Business Objects reports using Open Doc Syntax in the process of integrating with SharePoint 2007 for better visibility.
  • Created dashboards, scorecards, reports, indicators of different templates and integrated them on to SharePoint server 2010.
  • Involved in standard reports and dashboard integration with SharePoint.
  • Managed and controlled MS SharePoint code promotion request.
  • Configured and deployed SSRS report in SharePoint environment.
  • Embedded Tableau views in to SharePoint.
  • Implemented branding on the SharePoint site.
  • Performed integration of SAP BO BI 4.0 with Esri Arc GIS and MS SharePoint.
  • Documented BW (backend and frontend) process flows into various folders on SharePoint utility drive.
  • Implemented ADFS SSO integration for client integrations with internal portals using Sharepoint.

Show More

26. CRM

demand arrow
average Demand
Here's how CRM is used in BI Architect jobs:
  • Analyzed existing Reports and have performed mapping to them with CRMOD Data Model for Reporting to be done within CRMOD.
  • Campaign Leads are generated in BI and via RFC calls creates/updates Opportunities and Activities in CRM system.
  • Extracted Costumer and service information from Costumer Information System (CIS) to support CRM team needs.
  • Supported one of the first Oracle CRM, a module of EBS, implementations ever.
  • Worked on redesigning the extractors from CRM to improve the load performance.
  • Involved in design and development of CRM Services Tickets Reports.
  • Implemented ICRM Technologies (Oracle, SUN, EMC).
  • Installed over 13000 CRM patches supported DB for CRM.
  • Managed the project, leading a team in India, Assigning Development Requests using Siebel pulse CRM tool.
  • Implement Conversion Solution of SAP CRM to Salesforce (SFDC) for Accounts, Contacts, Orders.
  • Configured Action link drill down between Oracle BI and Siebel CRM.
  • SAP BW 7.3, SAP BI 4.1, ECC 6.0, SAP CRM 7.0 Company: NTT DATA.

Show More

27. Ad-Hoc

demand arrow
average Demand
Here's how Ad-Hoc is used in BI Architect jobs:
  • Delivered Formatted Reporting, AD-HOC Reporting, Self-Service Reporting, OLAP Analyses and Executive, Dashboards using MicroStrategy OLAP tool.
  • Prepared Metadata model to support Ad-Hoc model for newly created Financial Tables in RDW and published the package.
  • Defined and built hierarchies within dimensions as a part of DMR modeling to support the Ad-Hoc requirements.
  • Design reporting framework or GTS to produce MIS, Ad-Hoc, and canned reports.
  • Experience in training end users to create Ad-Hoc reporting.
  • Created end user documents for Ad-Hoc Reporting.
  • Performed ad-hoc statistical data analyses and developed SAS utility macros for project automation.
  • Provided wide range of Ad-hoc analysis capability.
  • Allow Payer or Sold to views of the customer, permit users to build ad-hoc queries across different businesses or geographies.
  • Analyzed and improved performance of several ad-hoc reports (bug fixing) using Oracle SQL/PLSQL in SQL Developer.
  • Created various types of ad-hoc, master-detail, cross tab, bar chart and pie chart reports.
  • Designed a scalable solution for performing a calendar based Hedging of funds and Ad-Hoc hedging of funds.
  • Provided canned reports and Reporting Data Model using SSRS for Analysts to generate ad-hoc reports.
  • Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
  • Design OLAP/Ad-hoc reports for business users using SSRS.
  • Designed Ad-hoc reports using Query Studio.
  • Defined end to end BI Cognos framework to enable CITI clients for creating ad-hoc reports and schedule reports.
  • Created Ad-hoc reports using Query Studio and designed a plan to implement crystal reports to Cognos.
  • Design and build web based ad-hoc data analytics tool for multidimensional data cube.
  • Created Catalogs in Presentation layer used for both ad-hoc and Dashboard users..

Show More

28. Report Studio Reports

demand arrow
average Demand
Here's how Report Studio Reports is used in BI Architect jobs:
  • Developed dynamic Report Studio reports in Sales and Marketing, Incident Reporting, Pricing, Inventory Reconciliation, and Invoice Processing.

Show More

29. Teradata

demand arrow
average Demand
Here's how Teradata is used in BI Architect jobs:
  • Led framework design to enable parallel loading for multiple sources data to warehouse using teradata global temporary table.
  • Provided Teradata SQL connection naming convention, data layer design and ETL scripting logic support.
  • Design MOLAP/ROLAP cubes on Teradata Database using SSAS.
  • Analyzed informatica metadata repository and teradata query log for long running sessions/query and resource utilization.
  • Obtained efficiency by pulling data instead SAP pushing data into Teradata via Informatica.
  • Developed Teradata BTEQ script and Informatica mappings.
  • Developed autosys scripts in Unix to load data into target tables in Teradata on weekly and monthly basis.
  • Work with Teradata, AB-Initio ETL team for building views as part of performance tuning.
  • Lead architect for a new Enterprise Data Warehouse initiative based on Informatica and Teradata.
  • Used sql on Teradata for report design and development Worked on LCM in upgrading the Report Studio and Query Studio Reports.
  • Managed ETL Architect team for new developments involving Vertica, Hadoop and Teradata.
  • Reviewed ETL and reporting deliverables -Teradata BTEQ, Cognos model and OBIEE rpd.

Show More

1 Teradata Jobs

No jobs at selected location

30. Data Source

demand arrow
low Demand
Here's how Data Source is used in BI Architect jobs:
  • Analyzed enterprise data sources and design integration solutions and architecture.
  • Created generic data sources with ability of delta functionality.
  • Enhanced the business content data sources by appending structures, User Exits and customized delta built up for the data sources.
  • Experience in the enhancement of the master data and transaction data sources with Z-fields and are populated using User Exits.
  • Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager.
  • Worked with functional consultant for mapping the source data (ECC) to target data source in BW.
  • Worked as Side car for SAP BW CRM related data source and architect data mart migration by BODS.
  • Performed administrative tasks including migration, import, export, LDAP security and data source connections.
  • Experience in creating universes using information design tool 4.x and also connecting to multiple data sources.
  • Worked with state officials & leads to identify business processes, process flow & data sources.
  • Published Reports, workbooks & data source to server and exported the reports in different Formats.
  • Enhanced MM and SD data sources in ECC by generic extraction and replicated to BI.
  • Worked on Distributing, developing and maintaining Tableau Data Sources for Tableau dashboards.
  • Generated Export Data Sources to transform data from one InfoCube to other InfoCube.
  • Integrated SAP BW with Business Objects and extracted data from SAP Data sources.
  • Develop and maintained Marketing and Sales Reports using as data source transformer cubes.
  • Direct data source systems analysis and data mapping efforts.
  • Created models using multiple data sources in Framework Manager.
  • Experience with dimensional modeling and architecture experience implementing proper data structures for analytical reporting from different data sources.
  • Created ad-hoc reports to users in Tableau by connecting various data sources.

Show More

31. UAT

demand arrow
low Demand
Here's how UAT is used in BI Architect jobs:
  • Activated business content for Material Ledger prices and updated custom data model to reflect historic material valuation for blend components.
  • Developed custom data models to accommodate business requirements of material component breakdown, blend composition, and valuation.
  • Evaluate and recommend presentation alternatives, establish prototype guidelines, and determine query needs.
  • Led the evaluation and selection of a reporting tool and its subsequent installation, configuration and administration.
  • Evaluated capabilities of SAP HANA Live and SAP HANA / BI Adoption and recommended the solutions.
  • Developed and executed UAT methodology and scenarios to validate reports tie to existing systems of record.
  • Supported UAT, helped to fix production issue and coordinated between business stakeholders & teams.
  • Designed a seamless Migration Strategy from DEV to SIT to UAT to PROD.
  • Research and evaluate software and hardware to enhance the development environment and process.
  • Deployed Packages and Reports from DEV Environment to UAT and PROD Environments.
  • Involved in migration of catalog and security to UAT and PROD environment.
  • Supported UAT, reviewed deployment document and helped to fix production issues.
  • Evaluated and purchased database and BI software for the project.
  • Involved in evaluating AFS-specific data in the BI system.
  • Defined DEV, UAT and PRD Tableau BI environments.
  • Designed and Created the UAT script template.
  • Resolved issues resulting from User Acceptance Testing (UAT) Extensively worked with all the new features in IBM information Server.
  • Designed BO universes for Pfizer HCX, RX and VMOP projects Project evaluation, deliver technical solutions.
  • Performed UAT with business users and coordination with onsite/offshore team to fix the issues identified.
  • Evaluated and implemented ETL and reporting tool Pentaho.

Show More

32. HR

demand arrow
low Demand
Here's how HR is used in BI Architect jobs:
  • Delivered on consulting project activities, ranging from client identification through final invoicing for medium to long-term engagements.
  • Modified existing BI Universes to accommodate enterprise standard reporting capabilities through Web Intelligence.
  • Perform project assessment through engagement process.
  • Deployed dashboard in the third party Portal and enabled external drill through using Action Links in OBI Analysis.
  • Developed Dashboards and created Drill through reports from Dashboard to all summary reports and Summary to Detail reports.
  • Created multiple dimensions, Calculated Measures Alternate drill through and creating special categories in Transformer.
  • Created planning, forecast category and loaded the data through input schedules, flat files.
  • Participated in this role on three sequential projects extending Business Intelligence to various departments.
  • Monitor project progress through scrum meetings and coordinate with external teams.
  • Worked extensively on FI-CO, SCM, SD, HR, COPA.
  • Developed and deployed business critical reports through crystal reports and web Intelligence essential for month-end closing and city compliances.
  • Company Code Report is ran for specific group accounts across all company codes to identify differences across three systems.
  • Managed an offshore and offsite team to deliver HR corporate headcount, attrition and benefits dashboards.
  • Created Shared Containers to increase Object Code Reusability and to increase throughput of the system.
  • Designed and implemented information broadcasting to distribute BEx reports to end-users through E-mail.
  • Troubleshooted the issues with SSIS ETL and Cognos servers and environments through resolution.
  • Deployed Cognos Content from Test to QA to UAT through to Production.
  • Multithreaded the application to achieve robust performance for batch processing.
  • Involved in preparing the technical design documents and carrying out walkthrough meeting with the IT & Business managers.
  • Managed the timeline and deliverables through a hybrid agile and waterfall approach including multiple realization phases.

Show More

33. DB2

demand arrow
low Demand
Here's how DB2 is used in BI Architect jobs:
  • Integrated 3rd party product - SQDR and enabled 'real-time' data replication between DB2 and SQL server.
  • Developed new data feed for migrating from VMS DB2 system to PIA SAP system for data warehouse.
  • Read the data from a variety of sources including DB2, Teradata, and Flat Files.

Show More

34. QA

demand arrow
low Demand
Here's how QA is used in BI Architect jobs:
  • Performed architecture and configuration analyses of DEV and QA environments.
  • Synchronize different DB servers and Applications: Data Environments DEV, QA and PROD (Relational, Data Warehouse).
  • Worked extensively on Clear Cast, Clear Quest tools, and with QA team to resolve testing issues.
  • Worked closely with QA teams to make sure the Data flow and the measures are properly populated.
  • Worked very closely with the Basis teams, QA, Portals and ABAP teams during the project.
  • Work with QA Team in the QA Testing phase and Resolve issues/bugs raised during QA Phase.
  • Developed documentation of changes and procedures to move code changes from development to QA and production.
  • Created the testing manuals for QA team and templates for report and cube validations.
  • Worked with Quality Center for logging, tracking and fixing bugs in QA Testing.
  • Published framework models and reports from development to QA and then Production servers.
  • Maintain the repositories for different environments like DEV, QA and PROD.
  • Coordinated with QA, Operations and China offshore development team.
  • Supported QA team during integration and user acceptance testing.
  • Developed a BODS Landscape for DEV, QA.
  • Partnered cross-functionally with QA and Performance Test teams to improve application quality, reliability and performance for LLC Datamart.
  • Utilize Motio CI for version control and report deployment to DEV, QA, and PROD environments.
  • Worked on deployment process form Dev to QA and Prod.
  • Installed and configured Pentaho Business Analytics across DEV/QA and production environments.
  • Co-ordinated between Business Analysts, QA Team, DBA and Middleware team.
  • Upgraded reports from series 8.3 to series 10.1 Installed Cognos inn QA environment Experience in developing models using prompts and filters.

Show More

35. Data Analysis

demand arrow
low Demand
Here's how Data Analysis is used in BI Architect jobs:
  • Gathered business requirements, performed data analysis, created mapping documents and conducted code reviews.
  • Designed and validated the high-level proposed solution architecture with Data Analysis and Data Architecture.
  • Performed source data analysis to identify entities and attributes list for data warehouse.
  • Perform data analysis/data mapping to identify legacy custody data available in GDW.
  • Conducted in-depth data analysis to understand business information needs.
  • Apply BI and DW Best Practices in solution delivery and solution architect; apply Big Data analysis to improve Data Management.
  • Performed requirement gathering, Data Analysis using Data Profiling scripts, Data Quality (DQ) scripts, and unit testing.
  • Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
  • Provided insights on port-externals using Big Data Analysis to retain the subscribers using map reduce on structured and unstructured data.
  • Involved in developing Power BI Dashboards and KPI reports to make easy Data Analysis.
  • Reported the insights on data analysis on international roaming and its usage data.
  • Perform data analysis and come up with requirement gap assessment of data sets.
  • Performed Data Analysis in the working Subject areas for identifying Data discrepancies.
  • Risk data analysis, graphical presentation using SAS Graph and ODS layer.
  • Conducted data analysis using the PowerPlay Transformer cubes and DQM models.
  • Designed the Data Architecture and did Data Analysis.
  • Involved in Data Analysis of the existing system.
  • Designed and built OLAP multi-dimensional models for deeper data analysis and created reports and dashboards.
  • Integrated Google Bigquery into company data framework to enable extremely efficient data analysis of multi-terabyte data sets.
  • perform data analysis via SQLs, data cleansing and implement data quality procedures.

Show More

1 Data Analysis Jobs

No jobs at selected location

36. DB

demand arrow
low Demand
Here's how DB is used in BI Architect jobs:
  • Delivered a comprehensive training session that involved dashboard navigation and building Analysis for Microsoft Excel reports with extremely positive feedback.
  • Led 5-person development team in design of data warehouse model providing direction to DBA, ETL and reporting teams.
  • Worked closely with infrastructure groups like Windows Admin, DBA group and Network Admin Teams to ensure system stability.
  • Created DB links, Procedures, Indexes, Aggregate tables and Gathered statistics to tune performance of some reports.
  • Worked as lead data architect in developing EDW with estimated size of 400 TB on IBM UDB platform.
  • Analyzed and used various data sources like Oracle, DB2, MS- Access and flat files.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Utilized DB connect Interface to extract Legacy CAS data from Oracle database into BW system.
  • Introduce the feedback into the dashboard design and further develop the storyboard.
  • Provided architectural guidance support for DBA's and Developers.
  • Integrated J2EE environment with Database LDAP and RDBMS Systems.
  • Developed integration plan for the new installation of Cognos 7.3 with integration to SQL Server, ORACLE, DB2 UDB.
  • Worked extensive with RDBMS and parallel processing and ability to design DB schemas and interface with it using ODBC.
  • Assisted DBAs in data warehouse specific tuning, loading, archiving, indexing etc.
  • Maintain Databases utilizing DBA tools like DBartisian and Erwin ER.
  • Developed DB models for various product using Ralph Kimbal approach Used multiple data sources for building FM model.
  • Developed and Monitoring Netprophet ETL workflows using 4DB languages and NZSQL and schedules.
  • Work on data integration projects from ERP systems, SAP, DB2, Oracle, Teradata, Hadoop / Cloudera.
  • Architected and implemented Pentaho ETL solution to extract, transform and process the data from SQLite DB to Oracle.
  • Work with DBAs to ensure schemas in DB2 and Netezza are in sync.

Show More

2 DB Jobs

No jobs at selected location

37. Bobj

demand arrow
low Demand
Here's how Bobj is used in BI Architect jobs:
  • Inherited the SECURITY (Users, Roles and Authorizations) configured in the back-end BI/BW system into the BOBJ reporting layer.
  • Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP HANA Models.
  • Conducted demonstrations of BOBJ Design Studio in order for Hershey's to make informed technology decisions.
  • Designed & Developed the BOBJ 3.1 WEBI reporting on top of BW/BI systems for Management reporting.
  • Designed and developed efficient Universes, BOBJ reports and dashboards that minimize ongoing maintenance requirements.
  • Worked from ABAP coding to BW Development to BOBJ Development including complex security using User-Exit.
  • Created many complex Variables and Prompts in BOBJ according to the end user requirements.
  • Delivered a turn-key migration to BOBJ tools as an overall strategic reporting front-end.
  • Installed BOBJ SP2 and FP 2.5 on development, quality and production systems.
  • Installed and administer BOBJ XI 3.1 tools and integrated with SAP NetWeaver.
  • Used SAP Single Sign On (SSO) as log-on verification from BOBJ to BW.
  • Configure the security in BOBJ 4.0 based on the SAP BI roles.
  • Worked on BOBJ upgrade from SP2 to SP4 version.
  • Involved in managing team to take care of the daily deliverables of BW & BOBJ Implementation.
  • Design data models for BW analytical and BOBJ operational reporting tools.
  • Maintained BW and BOBJ OLAP applications for sales, finance, Vistex, SPM & HR.
  • Architected SAP design solution and recommended optimal choice of tools Created solutions integrating SAP BOBJ with Spotfire tools.
  • Architected BW backend and BOBJ reports covering financials, billing rates & regulations, utility operations, collections and capital projects.
  • Created several reports using Bobj tools on top of Bex queries using Crystal reports and Webi.

Show More

38. EDW

demand arrow
low Demand
Here's how EDW is used in BI Architect jobs:
  • Provided technical leadership and guidance for Data Warehousing and reporting solutions; enhanced the existing Data Warehousing environment into EDW.
  • Managed efforts to build out their MDM/EDW/BI and IT department as part of companies goals of acquiring VC funding.
  • Developed common framework in SSIS package to bring the data from PDW servers to EDW Metadata Reports database.
  • Developed best practices for data warehousing usage of Oracle EDW tools for both process and data modeling.
  • Worked with Data Modeler and ETL Architect to optimize the current EDW Structure to enable Reporting.
  • Designed the physical data models for EDW, and BI presentation layer.
  • Automated the daily EDW load using Tidal as a job scheduler.
  • Worked on the EDW logical and physical data model.
  • Performed extracts of data from the EDW Target tables.
  • Project MagnaCare-EDW: MagnaCare is self-insurance and healthcare provider covering NY & NJ states with its broad proprietary provider network.
  • Created the logical model for the EDW with approximately 60 entities and 850 attributes using ERwin.
  • Designed the ETL framework for both Covariance and Kaspick EDW.
  • Project: Covariance Data Warehouse/Kaspick EDW.

Show More

1 EDW Jobs

No jobs at selected location

39. Xcelsius

demand arrow
low Demand
Here's how Xcelsius is used in BI Architect jobs:
  • Performed BOBJ 4.0 to over 600 user for BusinessObjects WebIntelligence, Crystal Reports, Xcelsius and Advanced Analysis.
  • Developed Xcelsius dashboards based on business requirements using QAWS (Query as a Web services).
  • Used drill down functionality in Xcelsius to enable users to drill into more detail dashboards.
  • Created Xcelsius dash boards based on current fiscal year and previous fiscal period comparison.
  • Developed state of the art Xcelsius dashboards with Audit and server monitoring information.
  • Gathered requirement documents with BA's for Dashboard Creation in Xcelsius.
  • Designed Xcelsius dashboards using Live Office and QAAWS as data providers.
  • Created dashboards using Xcelsius using Query As A Web Service.
  • Created both static and dynamic dashboards using Crystal Xcelsius.
  • Created an enterprise dashboard for CERM users using Xcelsius.
  • Investigated POC of dashboards such as Excelsius.
  • Educated Users on WEBI and OLAP and Xcelsius(Dashboard).
  • Developed Chairman's Dashboard in Xcelsius using Live Office and QAAWS for monitoring underperforming banks.
  • Developed Xcelsius Dashboard for 4C Datamart using QAAWS which would analyze and monitor Asset Performance.
  • Experience in end user training on how to use BO tools like webi and Xcelsius.
  • Developed WEBI reports in Business Objects XI R3.1and Xcelsius Dashboards in Xcelsius 2008.
  • Conducted installation of Crytsal Report and BO Xcelsius 2008.
  • Developed Webi reporting and modifications to existing reports Designed Xcelsius dashboards for VMOP, HCX, VMOP project.

Show More

40. Unix

demand arrow
low Demand
Here's how Unix is used in BI Architect jobs:
  • Create Unix shell scripts, Perl scripts to schedule the mappings in batch process with ETL process dependency.
  • Designed and developed new programs and dashboards using the SAS BI suite on UNIX platform.
  • Upgrade and migrate Oracle databases on Windows, Unix and Linux environments.
  • Created process/standards for migrating metrics from UNIX reporting into COGNOS/Tableau.
  • Experience in UNIX / Linux platform, Windows platforms.
  • Created Unix script filess to automatically extract logistics transactions from DAASC archived data.
  • Used UNIX Shell scripts to run Datastage jobs using CA7 Scheduler.
  • Architected and Implemented distributed Business Objects Server topology across windows with .NET, Sun ONE UNIX and WebSphere Application servers.

Show More

41. Toad

demand arrow
low Demand
Here's how Toad is used in BI Architect jobs:
  • Installed and configured TOAD for Oracle and MS SQL Server.
  • Used Toad Data Modeler as the data modeling tool.

Show More

42. MDX

demand arrow
low Demand
Here's how MDX is used in BI Architect jobs:
  • Developed 550+ MDX calculated members for complex financial accounting calculations.
  • Created custom scheduled automated processes that consist of numerous SQL statements, stored procedures, MDX queries, and XML code.
  • Involved in MDX Cube and Tabular model development for Structured Metadata and data profile module.
  • Developed Analysis Services cube and defined over 200 statistical performance metrics using MDX.
  • Assisted in the development of complex MDX calculations.

Show More

43. R2

demand arrow
low Demand
Here's how R2 is used in BI Architect jobs:
  • Need to Migrate reports from BO V5.x to BO XI R2 and conversion of Desktop reports to Web Intelligence Reports.
  • Design a detailed new security approach for Pfizer BO XI R2 Security problems users were facing.
  • Installed XIR2 on windows clustered environment using IIS TOMCAT web application severs.
  • Migrated universes, reports, users from BO XIR2 to BOXIR3.
  • Created BOXI R2 WebI reports for Securities Data mart.
  • Planned and conducted upgrade from XIR2 to XI3.
  • Involved in Blue printing phase for the R2R (Report to Report project).
  • CUBE deployment SSAS/ MS SQL Server 2008R2 with tables with over 6 billion Rows.
  • Migrated BO XI R2 to BO XI R3.1 and then R4.
  • Drive the migration effort from BOXI R2 to R3.
  • Performed SQL Server programming of stored procedures Performed SQL Server T-SQL based test process, designed/tuned SQL Server 2008 R2 databases.
  • Installed, Configured and Developed OBIEE 12.2.1.1.x, Tableau 9 on Windows Server 2012 R2 & Redhat 7.x.
  • Created Crystal Reports using BOXI R2 for Securities Datamart and using SDM Universe as data Provider.
  • Upgraded/Migrated SSIS 2005 packages including sql agent jobs to SSIS 2008 on Windows 2008 R2 server.
  • Developed scalability and capacity planning strategy for upgrading to SQL Server 2008 R2.
  • Architected and installed BusinessObjects 6.5 and XIr2 environments.
  • Involved in Migration from BOXIR2 to BO XIR3; RPDs, reports and Dashboards using OBIEE.
  • Installed and configured Sql Server 2008R2 on Dev, Stage and Prod.
  • Created BOXI R2 Webi reports for SSO datamart.
  • Installed and configured Cognos BI 10.2.1, Cognos 8.4.1 and Cognos 8.4 on Microsoft Windows Server 2008 R2.

Show More

44. POC

demand arrow
low Demand
Here's how POC is used in BI Architect jobs:
  • Executed POC on IBM SPSS for statistical analysis, predictive modeling, decision management and data mining.
  • Worked on POC for SAP HANA with ETL replication method using SAP BO Data Services 4.0.
  • Designed several Active report POC's which included Food Categories, Beverage, Fuel from retail.
  • Implemented and completed a POC on 4 reporting Dynamic cubes.
  • Presented POC for SAP HANA implementation to the client successfully.
  • Delivered POC which then was developed into standard product.
  • Create Framework Models for POC testing for relational reporting.
  • Lead a team of 5 during its POC implementation.
  • Worked on SAP HANA POC/ Prototype BW migration.
  • Executed POC Big Data and Cloud deployment.
  • Involved in POC's for GE Global HR search projects.
  • Created POC in SAP BO design studio.
  • Created POC on Tableau for analytical purposes and demonstrated it to the entire team including product owner
  • Developed POCs by building reports and dashboards using Tableau 9 to demonstrate quick wins.
  • Have delivered POCs with new tool sets understanding the overall business requirements.
  • Modelled and developed MicroStrategy 9.3 dashboard POC.
  • Created POC on Power BI Dashboards to track KPI's for Sales.
  • Contribute to and present POCs, sales presentations, current and future state analysis, SOWs, and project timeline planning.

Show More

45. Technical Specifications

demand arrow
low Demand
Here's how Technical Specifications is used in BI Architect jobs:
  • Developed technical specifications, data identification and also recommendations on the preferred solution for development and deploy efficient BI solutions.
  • Analyzed requirements and technical specifications by partnering with business analysts to develop reports that conform to the enterprise standards.
  • Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications.
  • Provide functional & technical specifications/recommendation/build pertaining to the SAP BI IP application.
  • Analyze the requirements, develop technical specifications and identify the reports.
  • Translated user requirements into detail technical specifications and data mappings.
  • Converted the business requirements into technical specifications for ETL process.
  • Gathered reporting requirements and translated them into technical specifications document.
  • Create technical specifications and rationalize report portfolios.
  • Worked on designing the Web-I technical specifications documents for all the reports and maintained the project related documentation on the portal.
  • Created technical specifications and mapping documents for data warehouse schema and ETL processes.
  • Assisted in the creation of system design and technical specifications for software.

Show More

46. T-Sql

demand arrow
low Demand
Here's how T-Sql is used in BI Architect jobs:
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Created T-SQL scripts like Store Procedures, CTE, Functions, Indexes and other database objects.
  • Build a business rule engine using T-SQL and SSIS to enhance and ensure data quality.
  • Trained and mentored Process Engineers on T-SQL.
  • Implement performance tuning on T-SQL / ETL.
  • Develop SQL queries using T-SQL.
  • Developed ETL workflows using T-SQL and SSIS to move Client data into the AWS hosted AMO Portal database.
  • Implemented Performance improvements in T-sql scripts and handled data efficiently.
  • Designed and developed T-SQL queries to create SSRS datasets.
  • Designed and developed reports in SSRS Technical Summary: SQL Server 2014, SSAS, SSIS, SSRS, T-SQL

Show More

47. DSO

demand arrow
low Demand
Here's how DSO is used in BI Architect jobs:
  • Developed and successfully implemented extracting write optimized DSO and tripled throughput.
  • Worked with HANA optimized DSO's in BW 7.3 for best possible performance and to save memory.
  • Extracted data in various Data Targets depending on the user requirements like DSO, InfoCube.
  • Implemented BW Data Archive solution to Archive ODS/DSO objects onto File system.
  • Worked on Analysis Process Designer to extract data from Daily Inventory cubes and make it available in a DSO for lookups.
  • Worked on Purchase Orders, Purchasing Requisitions, Account Assignment, and Services and extracted the data to DSOs and Cubes.
  • Developed Info Objects, Info cubes, DSO, Multi Providers & Process chains as per design and the documents.
  • Coded end routines to filter and load delta records into write-optimized DSOs, on a package by package basis.
  • Designed ADSOs, Open ODS views, Composite providers and have extensively leveraged the new BW 7.5 features.
  • Developed custom Locking process to open and close data slice at runtime using DSO data.
  • Developed custom Info Cubes, DSO's and Multi Provider's to meet requirements.
  • Managed the optimization of DSOs and InfoCubes in BW using HANA functionality.
  • Used write-optimized DSOs as Data Stores.
  • Involved implementation of Optimization Methodology and "recipe" incorporating Pruning/ Logical and Physical Partitioning of DSO/Cubes.
  • Place: Richardson, TX Description: The project incuded the development of the ETL/BI Architecture and reports Along with automation.
  • Generated various reports on top of SAP data sources such as Infocubes, DSO and Multiprovider etc.
  • Implemented DSOs, Infocubes, and Multiproviders to support SD, MM, and FI reporting requirements.
  • Involved in creation of infoobjects, DSO's, Cubes, Multi providers, Infosets and transformations.
  • Developed dataflow (Write optimised DSO layer, Standard DSO, Cube and Multiprovider) for analytical summarized reporting.
  • SAP BW on HANA: Developed aDSOs and Composite Providers to convert existing Infocubes/DSOs and Multiproviders/Infosets/Virtual Providers.

Show More

48. Oltp

demand arrow
low Demand
Here's how Oltp is used in BI Architect jobs:
  • Fostered strong relationships with data architecture, database administration and data consumers including designs for both OLTP and Data Warehouse/BI structures.
  • Performed customization and configuration work on OLTP databases, tables, stored procedures, SSIS packages and other objects.
  • Created SSIS packages to extract data from OLTP to EDW systems and scheduled Jobs to call the packages.
  • Support production system for OLTP and post deployment SSIS packages/ SSRS Reports on the server.
  • Developed LLC Summary application Universe which feeds on OLTP Apex application.
  • Lead Logical & Physical Design of OLTP & OLAP Databases.
  • Implemented DSS and OLTP systems with Oracle based technologies.
  • Performed Analysis and design of an OLTP Systems.
  • Implemented DSS and OLTP databases.
  • Project: Onecert Created a custom OLTP system which was used for Access Recertification within Barclays.

Show More

49. SAP R/3

demand arrow
low Demand
Here's how SAP R/3 is used in BI Architect jobs:
  • Established connection between Business Warehouse, SAP R/3 systems and Non-SAP systems like BECON, ICESTROM and other data sources.
  • Analyzed and activated relevant Business Contents and set SAP R/3, Flat Files and BW as source systems.
  • Perform Data Integrity Check to verify the data in SAP R/3 and SAP BW.
  • Worked on LO extractors for extracting sap R/3 data into BI.
  • Configured the Data services to connect to the SAP R/3, BI, and CRM.
  • SAP R/3 Enterprise 4.7C/ECC6.0,SAP BI 7.1
  • Uploaded master data and transactional data from Flat Files and SAP R/3 to BW system.

Show More

50. IDT

demand arrow
low Demand
Here's how IDT is used in BI Architect jobs:
  • Used IDT to modify / change the connection parameters and subsequently test the database connections etc.
  • Created universes using Information Design Tool (IDT) and Universe Design Tool (UDT).
  • Created universe's in IDT for all these new reports by using Design Studio.
  • Developed WEBI Reports/ Dashboards / Universes (using IDT) in BO 4.0 Environment.
  • Developed Universe using Information Design Tool (IDT) in BO BI 4.1.
  • Used IDT to manage and maintain BICS connection.
  • Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.

Show More

BI Architect Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A BI Architect

Data Warehouse

13.8%

Dashboards

10.2%

SQL

8.8%

Business Requirements

7.8%

ETL

7.3%

Web Intelligence

6.2%

Architecture

5.8%

Analytics

4.3%

Ssis

4.1%

Cognos

3.8%

SAP BW

3.7%

Informatica

3.2%

Ssrs

3.2%

Ssas

3.0%

Olap

3.0%

ECC

2.5%

BO

2.5%

Obiee

2.5%

KPI

2.2%

Schema

2.2%
Show More

Typical Skill-Sets Required For A BI Architect

Rank Skill
1 Data Warehouse 9.9%
2 Dashboards 7.3%
3 SQL 6.3%
4 Business Requirements 5.6%
5 ETL 5.2%
6 Web Intelligence 4.5%
7 Architecture 4.1%
8 Analytics 3.1%
9 Ssis 2.9%
10 Cognos 2.7%
11 SAP BW 2.7%
12 Informatica 2.3%
13 Ssrs 2.3%
14 Ssas 2.2%
15 Olap 2.1%
16 ECC 1.8%
17 BO 1.8%
18 Obiee 1.8%
19 KPI 1.6%
20 Schema 1.5%
21 BEX 1.5%
22 BI 1.4%
23 Pl/Sql 1.3%
24 Master Data 1.3%
25 Sharepoint 1.2%
26 CRM 1.1%
27 Ad-Hoc 1.1%
28 Report Studio Reports 1.0%
29 Teradata 1.0%
30 Data Source 1.0%
31 UAT 1.0%
32 HR 1.0%
33 DB2 0.9%
34 QA 0.9%
35 Data Analysis 0.9%
36 DB 0.9%
37 Bobj 0.9%
38 EDW 0.9%
39 Xcelsius 0.9%
40 Unix 0.8%
41 Toad 0.8%
42 MDX 0.8%
43 R2 0.8%
44 POC 0.8%
45 Technical Specifications 0.7%
46 T-Sql 0.7%
47 DSO 0.7%
48 Oltp 0.7%
49 SAP R/3 0.7%
50 IDT 0.6%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

16,863 BI Architect Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.