Top BI Developer Skills

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

The six most common skills found on BI Developer resumes in 2020. Read below to see the full list.

1. SQL

high Demand
Here's how SQL is used in BI Developer jobs:
  • Developed Reports Using SQL Server Reporting Services on statistical data during migration of data and integrated them with Visual Basic applications.
  • Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
  • Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
  • Worked on analyzing reports currently generated via SQL server reporting services.
  • Involved in SQL Server Clustering and Database Mirroring implementation.
  • Implemented Data parallelism and pipeline parallelism in SQL server.
  • Configured SQL Mail agent for sending automated alerts/email.
  • Played an active role in the development of a SQL Server maintenance plan, scheduling jobs, alerts, and troubleshooting.
  • Involved in creating Tables, Stored procedures, Views, Functions, Triggers, and user profiles in SQL server.
  • Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel spreadsheet to SQL Server 2008.
  • Implemented the Indexing making the Transaction in SQL 2005 faster nearly three times as compared to the SQL Server 2000.
  • Merged Data from Heterogeneous Data stores (Oracle, Access and Excel) to SQL Server 2005 using SSIS packages.
  • Scheduled and maintained every mid-night and weekly load data by creating corresponding job task by SQL Server Agent in SSMS.
  • Created Stored Procedures for complex business process, SQL Agent jobs, and designed tables by following RDBMS rules.
  • Used Union, Intersections, custom joins for creating queries in report studio and created reports using custom SQL.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
  • Worked on several queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Experienced in Managing Data Model and Improving Performance using the Master Data Services for SQL and Add-in in Excel.
  • Involved in Writing Stored procedures, views, trigger and creating Indexes on tables using MS SQL Server 2014.
  • Created various SQL server objects like stored procedures, functions and views as per the logic to be implemented.

Show More

2. Data Warehouse

high Demand
Here's how Data Warehouse is used in BI Developer jobs:
  • Provided documentation about data warehouse structures and updated functional specification and technical design documents for cubes, reports and SSIS Packages.
  • Developed, maintained and monitored all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
  • Communicated statuses with data warehouse and business intelligence teams and assisted in resolving data-related problems.
  • Integrated new systems with existing data warehouse structure and refined system performance and functionality.
  • Involved in estimation, design and architectural discussion with architecture team for data warehouse.
  • Involved actively in critical data analysis, data modeling and data warehouse design.
  • Participated in data quality analysis and integrity between source systems and data warehouse.
  • Developed documentation, where necessary, to support data warehouse development initiatives.
  • Translate functional requirements into technical specifications for design of Data Marts/Data warehouses.
  • Worked on data warehouse Analysis services and developed different reports for analysis.
  • Designed physical and logical modeling of databases for data warehouse applications.
  • Coordinated integration of Epic data with organization s back-end data warehouse.
  • Created logical and physical data warehouse design for business purposes.
  • Perform data verification on Data Warehouse using sample reports.
  • Analyzed customer s requirements for Data Warehouse implementation.
  • Developed SSIS packages for Data Warehouse applications.
  • Developed Lot History Data Warehouse reports.
  • Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
  • Used DAC to configure and monitor the sessions and also ran weekly loads to update the data within the data warehouse.
  • Designed and developed ETL (SSIS) processes & implemented Logging strategies when loading data into data warehouses and data marts.

Show More

3. Database

high Demand
Here's how Database is used in BI Developer jobs:
  • Develop documentation that sufficiently describes technical deliverable as required for internal controls and maintaining documentation of the database for future reference.
  • Designed and built OBIEE data level security based on external database model to deliver an intelligent authentication mechanism with Row-Level security.
  • Perform database administration tasks in support of development testing and deployment tasks, troubleshooting, and physical database configuration.
  • Experienced in the procedure of normalization of Database in order to eliminate redundant data and to improve Database performance.
  • Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.
  • Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency.
  • Deploy, upgrade and configure new database and Coordinate database migrations with developers and other stakeholders.
  • Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
  • Performed in performance monitoring and trouble-shooting issue in SQL Server database and validating transactions.
  • Participated with business analysts in order together requirements for design and implementation of database.
  • Worked on Database Compression for different databases to save space across different environments.
  • Prepared a Conceptual, Logical and Physical database modeling designs for new applications.
  • Involved in requirements gathering and providing high-level design solutions in designing database architecture.
  • Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Scripted several database maintenance tasks reducing manual processes and related overheads.
  • Participated in re-design and development of back-end SQL Server database applications.
  • Company hosts a very large database system and other operational databases.
  • Designed and developed logical and physical database models with ER-win.

Show More

4. Dashboards

high Demand
Here's how Dashboards is used in BI Developer jobs:
  • Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI's and visually accentuate critical business controls.
  • Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
  • Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy to read, interactive documents.
  • Developed Tableau visualizations and dashboards using Tableau Desktop which involved data blending from multiple data sources and advanced calculations.
  • Gathered business requirements from users to develop and deploy required reporting for various Culinary POS reporting and dashboards.
  • Involved in managing appropriate security privileges on subject areas and dashboards according to business and User requirements.
  • Collaborated with business users in creating and modifying worksheets and data visualization dashboards using Tableau Desktop.
  • Identify delivery mechanism - all managerial and operational reports that are delivered through BI Dashboards.
  • Created user level security for Intelligence dashboards based on Business Requirement and Business Objects.
  • Created Dashboards with multiple attribute element selectors, metric selectors and metric condition selectors.
  • Consulted with and trained analysts to effectively access data and optimize Tableau dashboards.
  • Generated canned Reports/Dashboards for Business users by using SQL Server Reporting Services.
  • Configured repository and session variables to get dynamic reports and dashboards.
  • Design several prototypes/POC dashboards for Scientific & Technical Information Center.
  • Design and develop interactive dashboards and reports for business stakeholders.
  • Developed security matrix for dashboards/Answers users based on Individual.
  • Developed Dashboards and Scorecard using Dashboard manager.
  • Generated and updated Tableau scorecards and dashboards.
  • Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
  • Created advanced dashboards to save HTML versions of more than 100 dashboards and run daily jobs for refresh of these versions.

Show More

5. Ssis

high Demand
Here's how Ssis is used in BI Developer jobs:
  • Deployed SSIS Packages into production and used package configuration to export various package properties to make package environment independent.
  • Migrated data from production and development databases to centralized SQL Server databases using SSIS to overcome transformation constraints.
  • Involved in Documentation, testing and implementing solutions using applicable SSIS technologies.
  • Created SSIS packages for new projects utilizing Business Intelligence Development Studio.
  • Created SSIS Package configurations for executing in different environments.
  • Involved in Data Migration of Packages from DTS to SSIS by using advanced features in SSIS (Aggregate, Sort).
  • Developed SSIS Packages to load the client's data from Flat files, Excel, SQL Database Sources to SQL Database.
  • Deployed the SSIS packages to SSISDB Catalog and automated the execution of those by scheduling them through SQL server agent jobs.
  • Migrate all old DTS packages to SSIS packages to take advantages of all new features that present in SQL Server 2012.
  • Organized Error and Event handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers in SSIS.
  • Defined various Extracting, Transforming and Loading (ETL) tasks using SSIS packages with appropriate control & data flow elements.
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio (SSDT).
  • Created break points in order to view the status of data, variables and over all status of SSIS package.
  • Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task.
  • Performed ETL using SSIS by extracting data from OLTP data sources such as Excel, Access, and Text files.
  • Created and maintained XML, parent package variable and SQL table package configurations for migrating towards different environments in SSIS.
  • Created Yearly Partition and processing Cube based on adjustments using SSIS package as well as deployed cubes in various environments.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Conditional Split, Derived column in SSIS.
  • Created SSIS packages including setting up the database, the server, and the environment to run ETL processes.
  • Created packages in SSIS using different tasks, Execute SQL task, Data conversion Task, Script Task etc.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Ssrs

high Demand
Here's how Ssrs is used in BI Developer jobs:
  • Designed and developed reporting system using SSRS to analyze performance and availability metrics of in-house/outsourced support groups.
  • Developed external document control system in SSRS for complex document analysis and storage tracking.
  • Supported and involved in maintenance of SSRS report modifications and enhancements.
  • Designed user interactive reports that implements interactive sorting using SSRS.
  • Developed various operational Drill-though and Drill-down reports using SSRS.
  • Generated Sub-Reports, Drill down reports, Tabular Report and list reports using SSRS and published as PDF, Excel formats.
  • Generated different types of reports like List, Table and others and depending upon requirements and deployed them by using SSRS.
  • Designed, created and published matrix, scoreboard and dashboard reports by SSRS from data cube and Tableau onto web servers.
  • Generated reports using SSRS that could be used to send information to diverse group of users, clients, and managers.
  • Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Designed, installed and created SSRS reports that reside on application for the users to regularly check the performance.
  • Designed and implemented in house SSRS reporting portal and scheduled automated reports via email using SSIS and T-SQL jobs.
  • Created user reports in SSRS Report Builder 2.0 Making use of sub reports and procedures in SQL 2008 environment.
  • Designed the usage summary, performance, AUDIT/LOG, Job Status and detailed reports for IT users in SSRS.
  • Created several dashboard reports with drill down and drill through capabilities which were integrated into application development using SSRS.
  • Delivered SSRS reports to multiple clients in different format such as PDF, excel, and XML utilizing subscriptions.
  • Formatted the reports using Global Variables and Expressions in SSRS and deployed the generated reports onto the Reporting server.
  • Modified the facts, used calculations and query designer in order to modify queries and developed reports using SSRS.
  • Created stored procedure for SSRS reports, modifying/fixing stored procedure to generate reports on a daily or monthly basis.
  • Performed installation and configuration of Reporting Services, and assigned permissions to different lever of users in SSRS.

Show More

7. ETL

high Demand
Here's how ETL is used in BI Developer jobs:
  • Reviewed Business Requirements Document, System Technical Specification Document, ER Diagram, Design Document Deliverable and ETL Design Specification document.
  • Prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
  • Participated in to Design ETL architecture and processes insurance and policies related record from different locations.
  • Developed and modified complex stored procedures in supporting ETL processes in data warehousing environment.
  • Designed efficient and optimized ETL Strategy by identifying, analyzing sources and destinations.
  • Gathered, analyzed and documented requirements for generation of reports and ETL development.
  • Prepared detailed design documentation including ETL data mapping documents and report specifications.
  • Designed data dictionaries and data mapping documents for ETL implementation.
  • Support existing ETL applications in a complex database environment.
  • Developed transformation logic and designed various ETL packages.
  • Monitored ETL jobs and BO report schedules for successful completion on a daily basis, resolved any defects or user-encountered issues.
  • Designed processes for Extract, Transform and Load (ETL) of data from legacy system to SQL Server using SSIS.
  • Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
  • Created many ETL jobs to load the tables using various simple and complex transformations to facilitate the incremental and full loads.
  • Prepared mapping document for ETL and user manuals for end users in order to educate them about execution of BI reports.
  • Designed, Developed and Deployed ETL packages using several transformations such as Derived column, Sort, Merge and Conditional Split.
  • Involved in Designing, Developing and Testing of the ETL strategy to populate the data from various source systems feeds.
  • Created packages in ETL to load ODS tables, package configured and automate to run through the SQL SERVER Agent.
  • Created ETL processes to load External Feeds from excel file, flat files and web service to SQL server database.
  • Redesign extract-transform-load (ETL) process to land data, stage data and load data into dimensions and fact tables.

Show More

8. Business Requirements

high Demand
Here's how Business Requirements is used in BI Developer jobs:
  • Provided application effort estimation by predicting the realistic amount of effort to develop the application based on the Business Requirements Document.
  • Gathered information for business requirements that was implemented into useful database information that is subsequently utilized in applications development.
  • Collaborated with the client's Windows administrators, database administrators, and a line-of-business manager for business requirements.
  • Gathered information for business requirements that was implemented into useful database information, and enhanced user interface features.
  • Gathered business requirements and developed Interfaces for retrieving data from various databases for importing and processing POS transactions.
  • Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology.
  • Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
  • Gathered various business requirements from users and translated them as technical specifications and design documents for development.
  • Worked with data architects to translate business requirements into technical specifications and logical & physical data models.
  • Participated in Requirement gathering sessions (JRD) to understand the business requirements and prepare documentations.
  • Prepared Business Requirements Document and then converted the business requirements into Functional Specifications and Technical Specifications.
  • Tested applications to ensure valid implementation in accordance with the business requirements and documented test results.
  • Conducted research and analysis of business requirements to define systems solutions that increase efficiency and effectiveness.
  • Interacted with business representatives for gathering business requirements and to analyze the business and functional specifications.
  • Validated the data to support the business requirements which is accurately reflected in an implemented solution.
  • Involved in gathering requirements, analyze the existing business requirements and interacted with business users.
  • Translated Business requirements into their Technical counterparts to ensure that proper programming documentation is maintained.
  • Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
  • Gathered, analyzed and categorized business requirements from various users by survives and interviews.
  • Worked closely with client resources and business analysts to analyze and understand business requirements.

Show More

9. Windows XP

high Demand
Here's how Windows XP is used in BI Developer jobs:
  • Installed MS SQL Server 2000 and Configured MS SQL Server 2000 requirements on Windows XP Professional Edition server.
  • Installed SQL server 2008 on windows XP server, applied service packs and security fixes.
  • Delivered training on Operating System Concepts for Windows XP and Windows 7.
  • Worked on workbook Permissions, Ownerships and User filters.Environment: Tableau 8.0, SQL Server, JavaScript, Windows XP.
  • Mentored team members to optimizing SQL queries Environment: VC++, MFC, Sybase 11.1, PL/SQL, Windows XP

Show More

10. T-Sql

high Demand
Here's how T-Sql is used in BI Developer jobs:
  • Developed various Stored Procedures and Functions using T-SQL per business requirement.
  • Optimized the performance of queries with modifications in T-SQL queries, Normalized Tables, established Joins and created Indexes whenever necessary.
  • Created complex Triggers, Functions, Indexes, Tables, Views, SQL Joins and T-SQL code to implement business rules.
  • Team Foundation Server, Performance Point Server, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.
  • Involved in designing and development of tables, views, user defined functions and complex stored procedures using T-SQL and CTE.
  • Assisted application developers to manipulate data by writing complex T-SQL commands including: Joins, Views, Triggers and Stored Procedures.
  • Worked with T-SQL, DCL, DDL, DML Scripts and created relationships between tables using Primary Keys & Foreign Keys.
  • Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors using 2012 SSMS Versions.
  • Extracted data from SQL Server 2014/2012/2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
  • Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers.
  • Optimized the performance of queries with modifications in T-SQL queries, eliminated redundant data, and created indexes whenever necessary.
  • Automated the complete load process by creating file watcher using T-SQL task which monitors a specific location for new files.
  • Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures.
  • Developed Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and statements for applications using T-SQL.
  • Map SQL statements and Transact-SQL stored procedures from old data sources to new data sources (Legacy to EDW).
  • Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL.
  • Worked on Complex T-SQL Queries using Inner joins, Stored Procedures with multiple parameters, Functions, and Views.
  • Developed SQL, T-SQL scripts to integrate data from various sources like Text, CSV files, Access Databases.
  • Experience in using T-SQL in SQL Server Management Studio for creating stored procedures, indexes, cursors and function.
  • Involved in troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code.

Show More

11. Complex Queries

high Demand
Here's how Complex Queries is used in BI Developer jobs:
  • Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
  • Developed complex queries to generate various database objects like Stored Procedure, User Defined Functions, Triggers, Views, Index.
  • Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012.
  • Created Joins, Sub-Queries, Views and User Defined Functions for complex queries involving multiple tables and developed User Defined Functions.
  • Utilized SQL Server SSRS 2008 to create complex queries and stored procedures needed to do custom reports for Probation department.
  • Created stored procedures and complex queries to satisfy the business logic, testing standards, and reporting needs.
  • Involved in writing complex queries to generate reports as per client request as a part of production support.
  • Developed complex queries in T-SQL, Stored Procedures, and Views and optimized for best execution plan.
  • Analyzed and tuned complex queries/stored procedures in SQL Server 2008 for faster execution and developed database structures.
  • Tested the data with complex queries, joins, stored procedures, views and sub queries.
  • Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.
  • Write complex Queries using joins, User Define Functions (UDF), Common Table Expression.
  • Used Store Procedure as Data provider to retrieve data from scheduled tables and complex queries.
  • Created multiple complex queries for data profiling and auditing purposes utilized in the ETL process.
  • Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
  • Designed and implemented stored procedures, indexes, complex queries for analysis and extraction.
  • Developed complex queries to fetch data from various tables from various remote databases.
  • Used joins and sub-queries for complex queries involving multiple tables from different databases.
  • Developed Power Pivot Dashboards by writing Complex queries as per the requirement.
  • Developed complex queries and database objects like stored procedures and indexed views.

Show More

12. Ssas

high Demand
Here's how Ssas is used in BI Developer jobs:
  • Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
  • Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS).
  • Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
  • Designed and developed SSAS Cube with multiple Fact, dimension, hierarchies, calculated members, action, partitions and aggregations.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MSOLAP/ Analysis Server (SSAS).
  • Created dimension and fact tables and developed the ETL's to load dimension and fact tables from Stage for SSAS cube.
  • Designed, Built Cubes, Hierarchies, and different perspectives using SSAS; export them to Excel for data analysis.
  • Developed dimensional Cubes and fact tables with star and snowflakes schema by using SQL Server Analysis Services (SSAS).
  • Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
  • Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
  • Involved in editing the cube by adding and removing dimensions tables using SQL server analysis services (SSAS).
  • Generated variety of practical and complicated business reports from SSAS with using MDX to evaluate cost/benefits and cost value.
  • Developed Data Source Views, Dimensions, Measures and cubes in SSAS to cater to business user's analysis.
  • Created relationships between measure groups and dimensions in a cube using MS SQL Server Analysis Services (SSAS).
  • Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
  • Create the SSAS Multidimensional cube using star schema and creating various calculations used in the report using MDX.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on server to achieve the efficiency of SSAS.
  • Created report Model using T-SQL queries on SSAS Cubes as well as changing default configuration on existing Cubes.
  • Worked with SSAS storage and partitions, and Aggregations, calculation of queries, Data Mining Models.
  • Created OLAP cubes using SSAS to analyze the status of sales, calculation of queries with MDX.

Show More

13. Drill Down

high Demand
Here's how Drill Down is used in BI Developer jobs:
  • Developed complicated business reports using Cross-tabs, Drill Downs, Sub reports and customized conditional formatting.
  • Used open-doc functionality to invoke contextual/drill down reports from dashboards.
  • Worked on creating SSRS drill down reports for revenue, click data conversions from various web advertisers, publishers and markets.
  • Developed different kind of reports such a matrix and Tabular reports with drill down and drill trough using SSRS, Tableau.
  • Designed and deployed direct and indirect customers reports for targeted segmentation of people and across different regions with Drill Down approach.
  • Worked as a Lead Designer and developer matrix and tabular reports with drill down and drill through report using SSRS 2012.
  • Created different level of report including Tabular, Matrix, and Drill Down reports to support the Management of the company.
  • Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
  • Generated Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2008/2005.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Generated various reports like Matrix reports, Tabular reports, and Chart reports, link Reports, Drill down reports.
  • Designed and developed visualizations with functionality like Drill Down, Slice & Dice, Drop down and parameters using Tableau.
  • Designed and developed various Interactive Dashboards and reports with drill down reports, guided navigation, filters, and prompts.
  • Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Charts.
  • Created Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models, and Drill Down Reports.
  • Generated different types of Reports like Tabular, Matrix, and several drill down and drill through reports using SSRS.
  • Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
  • Drill Down, Drill Through, Sub Reports, Charts, Tabular, Matrix and Linked reports from Database Objects.
  • Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
  • Provided reports which users can drill down or up by various criteria like by Year/Month, Area, Product.

Show More

14. Olap

high Demand
Here's how Olap is used in BI Developer jobs:
  • Created Multidimensional Models (OLAP) and Multi-Dimensional reports using PowerPlay.
  • Involved in multidimensional analysis of business data using OLAP.
  • Generated reports utilizing relational databases and OLAP cubes.
  • Developed OLAP Cubes from RDBMS in SSAS 2008 to include historical market target performances and to be prepared for tracking purposes.
  • Created data sources to connect to OLAP databases and Data Source View (DSV) to extend relational tables and views.
  • Designed, developed, created and tested Power Pivot reports based on OLAP cubes and offline cube files for business analysts.
  • Worked on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
  • Created named calculation in the data source view and calculated members in cube based on OLAP reporting needs utilizing SSAS.
  • Extracted and reviewed Data from Heterogeneous Sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2008.
  • Created SQL server Analysis Projects and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
  • Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP system.
  • Involved in analyzing the OLAP Cubes to pull the data in order to build the different types of reports.
  • Involved in Analyzing, Designing and testing of OLAP cubes with SQL Server Analysis Services (SSAS) 2012.
  • Created automated backup of OLAP cubes as well as normal backup using SQL server management studio and SSIS package.
  • Generated queries/reports and other activities like OLAP through the SAS OLAP Cube Studio, Forecasting and Analysis as requested.
  • Used ADO.NET extensively, for Database Interactions to get Employee Review, Remittance and Service Manual Data from OLAP.
  • Develop and implement several Reports, ETL Processes and OLAP cubes and all are thoroughly tested and debugged.
  • Designed and developed OLAP cubes and worked on storage and partitions, and aggregations, calculation of queries.
  • Developed reports on SSRS on SQL Server (2008/2012/2014) with excellent understanding of SSAS, OLAP cube.

Show More

15. Column

average Demand
Here's how Column is used in BI Developer jobs:
  • Optimized query performance with indexes, table partitions, unnecessary column removal, and redundant/inconsistent data elimination.
  • Optimized query performance by removing unnecessary columns, eliminate redundant and inconsistent data.
  • Used Derived Column transformation to perform various calculations.
  • Created level based measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
  • Worked on various Transformations such as OLEDB Command, Conditional Split, Derived Columns, and Merge Joins during Data Migration.
  • Worked extensively on Physical Layer, Business Layer and Presentation Layer (.RPD) to get new column as per BU.
  • Implemented Individual Axes in Tableau Desktop for measuring sales and profit by dragging measures to the Rows and Columns shelves.
  • Used join, left join, right join, filters, transform columns, grouping data and order by column.
  • Sit with the ETL team and discuss with them the columns needed for building up the packages in Framework Manager.
  • Used Column Filter prompts and various views such as Pivots Table, Charts, Narrative Views and View Selector.
  • Build the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
  • Create the scorecard reports using the Metric Studio and Implemented dynamic measures, dynamic column selection in Report Studio.
  • Worked on developing cubes with Derived column, Aggregation, KPI for decision-making, Prospective, measures and hierarchy.
  • Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
  • Designed standards for database table, Column, Procedures, Views and created mapping document for new Data Mart.
  • Have created Time Dimension Hierarchy to build the report and logical columns by using the Time Series function AGO.
  • Applied row level and column level Security at designer level to secure data based on the user profiles.
  • Used derived column transformation to handle package variables and derived values to load data in the Fact table.
  • Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
  • Created Joins on Business Components to appropriately map the related fields to the proper columns of joined tables.

Show More

16. Tableau Server

average Demand
Here's how Tableau Server is used in BI Developer jobs:
  • Involved in generating tableau reports by developing dashboards and published on tableau server and performed Query Optimization to enhance report performance.
  • Published workbooks and extract data sources to Tableau Server, implemented row-level security and scheduled automatic extract refresh.
  • Supported operations and performed Tableau server maintenance, Security Administration, License Management and Performance Monitoring.
  • Configured high availability and fault tolerance of Tableau server by implementing backup primary and worker nodes.
  • Provided best practices for development, administration process and documentation for tableau server platform.
  • Consulted on Tableau server performance enhancements.
  • Served as Tableau admin for the Tableau servers across the organization and participated in the upgrade of Tableau servers.
  • Worked with Tableau server configuration utility to manage SSO, caching, SMTP, high availability and fault tolerance.
  • Created extracts and published data sources on tableau Server for the users from various databases in Green Plum.
  • Experience in the maintenance and Scheduling of Tableau Data Extracts using Tableau Server and the Tableau Command Utility.
  • Created Data Connections, published on Tableau Server for usage with Operational Dashboards and story points.
  • Applied tableau security and published report to Tableau Server based on Sector Level & Market Level.
  • Created data quality operational reports using Tableau desktop tools and published to the EBI tableau server.
  • Published dashboards onto Tableau Server that allowed end users to understand the data on the fly.
  • Experience in working with Tableau server to publish data sources, creating users and Tableau installation.
  • Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
  • Consulted on Tableau server performance enhancements; upgrades from version 8.1 to 9.3 and server.
  • Administered user, user groups, and scheduled instances for reports in Tableau Server.
  • Published Tableau Views and Dashboards to Tableau Server, Tableau reader and Tableau Public.
  • Enabled trusted authentication to set up relationship between web server and tableau server.

Show More

17. Schema

average Demand
Here's how Schema is used in BI Developer jobs:
  • Participated in design of Staging Databases and Data Warehouse/Data mart database using Star Schema/Snowflakes schema in data modeling.
  • Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
  • Worked on designing and executing Application objects and Schema objects using MicroStrategy Desktop.
  • Designed, implemented and maintained Database Schema, Entity relationship diagrams.
  • Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
  • Designed mappings between sources and operational staging targets utilizing star schema.
  • Designed star schema Dimensional Modeling using Relational Data Sources in Cognos8.
  • Created Framework Manager based Star-Schema models for additional reporting projects.
  • Modeled data using star schema and dimensional modeling.
  • Created the design specs for loading the Treasury transaction data from OLTP to STG Schema, STG schema to DWH Schema.
  • Involved in star schema creation in the metadata layer and the corresponding reports built on top of this using OBIEE 10g.
  • Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
  • Analyzed the business requirement and designed the database systematically created a complete schema including store procedure, views, and triggers.
  • Used TFS Server and Visual Studio 2008- Schema Comparisons and Database Comparisons -synchronized all the DEV, SIT and PROD Environment.
  • Design SQL server/Oracle database schema, develop and update stored procedures, functions, triggers, and other database objects.
  • Analyzed the Data and came up with Logical Star schema model with the help of Data Modelers and Business Analysts.
  • Designed Cube as per requirements by setting direct & referenced relationships between Dimension & Fact Tables, resembling Star Schema.
  • Interacted with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
  • Worked on primary keys, foreign keys, indexes and drew the diagrams of star schema or snow flake schema.
  • Created Star Schema Layers, Business Layers, and Data Source - IQD layers in Report net Framework Manager Model.

Show More

18. XML

average Demand
Here's how XML is used in BI Developer jobs:
  • Incorporated package configurations such as XML files and environment variables to improve compatibility.
  • Installed ReportNet Migration Tool and migrated Impromptu catalogs using impcat2xml command.
  • Configured SSIS packages utilizing environment variables, XML files, and SQL Server tables to make them platform independent and dynamic.
  • Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
  • Developed reports, forms, and dashboard using LogiXML, HTML, CSS, JavaScript, and SQL Server 2008 database.
  • Worked with Application designer, Database Configuration application, MEA, Integration objects, Interfaces, XML imports and exports.
  • Created package configurations like XML, SQL Server Configurations and also logging using text, XML and Windows event log.
  • Administered the configuration of NQSCONFIG.INI and INSTANCECONFIG.XML Also worked with configuring CREDENTIALSTORE.XML while setting up the Single sign - on.
  • Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, On-Task FailedEvent Types.
  • Designed SSIS packages dynamically that could run on various Environments by creating XML and SQL Server Configuration Files.
  • Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
  • Add XML configuration files to each package to deal with different servers like Development, Testing and Production.
  • Extracted data from different sources like Oracle, flat files, XML and SQL Server loaded into DWH.
  • Extracted data from XML and HTML files using Python code and imported it into SQL Server tables.
  • Utilized multiple sources and destinations, including Excel, Flat File, XML, and OLEDB connections.
  • Developed SSIS Packages to extract and transform data from XML data files, and SQL Server 2014.
  • Involved in developing and modifying VB and XML reports for exporting the reports to web application.
  • Used XML, SQL Server and Environment Variable Package configurations to manage the package connection Strings.
  • Deployed SSIS packages and Scheduled Jobs and Extracted data from XML and flat files using SSIS.
  • Configure SSIS Package for run time Parameters and Configuration file using XML configuration and environment variables.

Show More

19. Ad-Hoc

average Demand
Here's how Ad-Hoc is used in BI Developer jobs:
  • Generated Information Maps using Information Map Studio and created Ad-Hoc reports on need basis using SAS Web Report Studio.
  • Created List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis.
  • Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
  • Generated report models from cubes as well as relational data warehouse to create Ad-Hoc Reports and chart reports.
  • Created Ad-Hoc reports using MS Access, Microsoft Excel and Report Builder and Crystal Reports.
  • Created Ad-Hoc reports using Report Builder and Worked on Stored Procedures and Database Triggers.
  • Train power users to use Query Studio for Ad-Hoc reporting.
  • Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
  • Designed/Implemented the Ad-Hoc Reports using Excel and power pivots.
  • Participate Ad-Hoc, and scheduled High End meetings.
  • Created Ad-Hoc reports using Report Builder.
  • Used Query Studio for Ad-Hoc Reporting.
  • Help users develop Ad-Hoc reports.
  • Developed ad-hoc reports as per business requirements and generated various reports like tabular reports, summary reports.
  • Improved user functionality by developing an independent module for generating ad-hoc reports based on user input.
  • Provide Ad-Hoc reporting for Surgeons, Physicians and Clinical Researchers using Microstrategy Developer 9.4.
  • Provided training/support to the business/Prospective users to create ad-hoc reports using Universe.
  • Created a reporting environment for both ad-hoc reporting and standardized reporting.
  • Designed ad-hoc reports using Report Model and configured using Report Manager.
  • Provide canned and ad-hoc reporting capability depending on the requirement.

Show More

20. Sub Reports

average Demand
Here's how Sub Reports is used in BI Developer jobs:
  • Worked Extensively in Crystal SDK, JRC component and familiar with integrating complex report containing Parameters and sub reports with Java.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports based on Relational Databases.
  • Developed Complex BI reports using Sub reports, pulling the data from stored procedures and packages, writing complex commands.
  • Design and developed reports leveraging SSRS reporting tool like cascading reports, sub reports, graphs, charts, etc.
  • Designed Reports, Sub Reports, drill though reports using various features like Charts, graphs, filters etc.
  • Created reports from OLAP, sub reports, bar charts, matrix, tabular reports and applied the indicators.
  • Developed several tabular reports, matrix reports, and lists, sub reports for different applications and data subsets.
  • Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS.
  • Developed complex crystal reports with using multiple sub reports and using sub reports linking to satisfy user's needs.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports using SSRS.
  • Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
  • Used various types of report layout options like charts, images, sub reports, hyperlinks etc.
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
  • Developed different kind of reports like Sub Reports, charts, Matrix Reports, Linked Reports.
  • Designed and developed Static and dynamic Charts and Sub Reports, Business Reports using SSRS.
  • Worked on reports that contained up to 10 sub-reports (including drill-down sub reports).
  • Developed several reports that exploited the use of Sub reports, report grouping, PRD.
  • Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
  • Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.

Show More

21. Cognos

average Demand
Here's how Cognos is used in BI Developer jobs:
  • Upgrade the report and packages version of COGNOS from 8.4 to 10 and Participate in the regression testing and unit testing.
  • Developed a Standard Template for data warehousing requirement specification collection of requirements for development under Cognos environment.
  • Designed Metadata Model using Framework Manager and published package in to the Cognos connection.
  • Developed projects and packages in Framework Manager and published packages to Cognos Connection.
  • Designed and Developed into technical Cognos Reports and Cubes and Implemented Security.
  • Involved with scheduling and distributing reports through Schedule Management in Cognos Connection.
  • Implemented security to Cognos 10 environment using windows authenticated Active Directory.
  • Communicated intensively with Cognos consultants to establish cordial/effective working relationship.
  • Create new and modify existing Cognos reports for operational reporting.
  • Published Packages to Cognos Connection and implemented Package Level Security.
  • Documented deployment procedure documents and maintained Cognos packages documents.
  • Developed and maintained Cognos Reports and Framework Manager Models.
  • Designed reports over relational and dimensional models in Cognos.
  • Implemented security into Cognos Transformer Models using Macros.
  • Developed Multidimensional Power Cubes with Cognos Power Play.
  • Published report documentations on the Cognos connection.
  • Designed Reports and security using Cognos Administrator.
  • Performed Report automation using Cognos.
  • Upgraded Framework Manager Models, Transformer Cubes and Reports from Cognos Version 8.4 to 10.1.1 and from version 10.1.1 to 10.2.1.
  • Involved in identifying and designing the process improvements to streamline the current planning process and optimize impact of the Cognos solution.

Show More

22. Fuzzy Lookup

average Demand
Here's how Fuzzy Lookup is used in BI Developer jobs:
  • Used Fuzzy Lookup transformation to perform data cleaning tasks such as standardizing data, correcting data, and providing missing values.
  • Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
  • Applied Transformations includes Merge, Merge Join, Fuzzy Lookup, Fuzzy Grouping, etc.
  • Created packages to cleanse data with fuzzy lookups/groupings, derived columns, and condition splits.
  • Developed ETL packages using SSIS and performed data quality using Fuzzy lookups.
  • Performed data cleansing and quality using Fuzzy lookups.
  • Used lookup tables and fuzzy lookup tables to make error tolerant matching logic and provider reconciliation report for business acceptance review.
  • Filtered incorrect data from legacy systems with transformations (such as lookups, fuzzy lookups, and conditional split).
  • Performed Data Cleansing using several Transformations like Derived Column, Data Conversion, Lookup, and Fuzzy Lookup etc.
  • Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Lookups, Aggregations, and Multicasting.
  • Implemented data profiling, data cleansing utilizing data profiling task, lookup and fuzzy lookup tasks.
  • Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
  • Applied different conditions, lookup, data cleansing using FUZZY lookups, data conversion,Based on requirement.
  • Involved in data transformation like lookup, fuzzy lookup, multicast, merge, join, derived column.
  • pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate).

Show More

23. Sharepoint

average Demand
Here's how Sharepoint is used in BI Developer jobs:
  • Experience in Integrating Reporting Services with Microsoft Office SharePoint Services for central delivery and management of business insight.
  • Deployed the generated reports in SharePoint and created interactive reports using PerformancePoint services from cube.
  • Created visually compelling and actionable interactive reports and dashboards in SharePoint.
  • Design and Develop custom SharePoint 2010/2013 applications using SharePoint Designer.
  • Administered and maintained corporate reporting portal hosted in SharePoint 2013.
  • Developed automated Data Driven subscriptions by using SharePoint.
  • Deployed and uploaded the power view, power BI reports to SharePoint Server for the end users to look at them.
  • Generated reports using SSRS and Excel Power pivots with expanded data capacity, advanced calculations and deployed them on SharePoint Server.
  • Deployed reports to the report server in native mode and SharePoint server; implemented report delivery via subscriptions in SSRS.
  • Create scorecards and dashboards to empower reports from OLTP, OLAP and reporting tables using SharePoint Insight and Excel sheet.
  • Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
  • Use of SharePoint 2010 and TFS for version controlling, storing and report the same by creating Tasks in TFS.
  • Migrated and Deployed SSRS Reports (2005 to 2013) to SharePoint and provided Security and Subscription to various Users.
  • Created web parts on SharePoint site using SharePoint Server 2010 and displayed the SSRS charts as a web part.
  • Integrated reports and dashboards within SharePoint from various reporting tools by using SQL Server Reporting Services (SSRS).
  • Deployed Dashboards to SharePoint, assigned authentication of the items, and granted access to selected groups of users.
  • Deployed and maintained reports in SharePoint 2010 and played critical role in providing the support to the business users.
  • Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
  • Expose to Microsoft SharePoint 2010, Visual Studio 2010, Microsoft InfoPath 2010 and Microsoft SharePoint Designer 2010.
  • Leaded the offshore team in development and documented series of process flows and maintained them in the SharePoint.

Show More

24. MDX

average Demand
Here's how MDX is used in BI Developer jobs:
  • Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
  • Designed MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
  • Experience in creating calculated measures, partitions and worked with different dimension hierarchies in MDX for developed reports through Reporting Services.
  • Worked on designing Partitions, Aggregations and created calculated Measures using MDX, KPI's, Roles, Perspectives and Security.
  • Created cube objects like KPI's and Calculated members using MDX and hidden some cube data by creating Perspectives on Cube.
  • Used SQL Server Analysis Services to create cubes for multidimensional features and involved in designing CUBE and wrote MDX queries.
  • Created MDX queries to retrieve data from cubes and also to display (SSRS) SQL Server reporting services.
  • Used functions in MDX like Array, Hierarchy, Level, Logical, Member, Numeric, Set etc.
  • Created SSRS and PowerBI reports sourcing from SSAS's Multidimensional OLAP and Tabular model cubes with MDX and DAX.
  • Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
  • Developed and delivered complex MDX queries to build XML reports on Internet Information Services website for the company.
  • Worked on implementation of Row level security for different users in cubes using MDX expression using SQL SSAS.
  • Updated and tested current OLAP data cubes including Servicing cube, Loan Payment cube using SSAS and MDX.
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2012/2008 (SSAS).
  • Use MDX and DAX to perform the aggregations, Calculating Averages, Calculating Accumulating Total and Navigating Hierarchies.
  • Designed and developed OLAP cubes using SSAS according to design specification and written calculated measures in MDX.
  • Loaded historical features like Client, Client_Hierarchy_Level and Client_Hierarchy_Value by writing Store Procedures and MDX queries.
  • Supported Ops Capital System including: MDX calculations, Cube changes, ETL changes and more.
  • Documented the Stored Procedures, User Defined Functions and MDX queries for future references and maintenance.
  • Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.

Show More

25. Fact Tables

average Demand
Here's how Fact Tables is used in BI Developer jobs:
  • Worked with Data Warehouse team to maintain and correct dimensional or fact tables that have impact on report accuracy and availability.
  • Worked on transforming the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
  • Developed dimensions and fact tables based upon the requirements and based on these facts and dimensions for designing SSAS cubes.
  • Created Multiple Measure Groups on different Fact tables and maintained Dimension usage between multiple measure groups to get appropriate results.
  • Involved in generating partition schemes and functions for fact tables to load billions of data from SQL server 2005..
  • Improved performance of many user reports by creating aggregated fact tables, join indexes, and collecting stats.
  • Created Full load and Incremental Loading packages for Dimension tables and Fact tables, including SCD1 and SCD2.
  • Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
  • Identified fact tables and dimension tables, and created data marts for various subject areas as required.
  • Worked with data modelers to design bridge tables between fact tables and revenue code dimension tables.
  • Make sure all the Dimensions are well built before pushing the data into the Fact tables.
  • Model and ETL additional dimensions, large fact tables using SQL Server 2012 and SSIS packages.
  • Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
  • Developed SSIS package to load data into dimensions and fact tables using slowly changing dimension.
  • Modified SSAS Tabular models with dimensions and fact tables from data sources.
  • Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
  • Implemented CDC (Change Data Capture) in loading the Fact tables.
  • Load different types of dimension and fact tables into data warehouse.
  • Design various Dimensions and Fact tables, Building the Analysis cubes.
  • Analyzed the requirements and selected the appropriate fact tables/created fact tables.

Show More

26. KPI

average Demand
Here's how KPI is used in BI Developer jobs:
  • Conducted Customer requirement workshop sessions to discover KPI's and actively involved in requirement analysis for reports analysis.
  • Worked extensively on LO-Cockpit Extraction, standard extraction, generic extraction and also monitoring/debugging of BI Extractors.
  • Prepared effective KPI reports for various departments and different executives.
  • Implemented perspectives and KPI using calculated measures based on requirements.
  • Developed various reports including matrix report, parameter report, and dashboard with charts, Drill-Trough/Drill-Down function, and KPI/Indicators.
  • Created Cube, Aggregates, Partitions, Dimensions, Measure Groups, KPI, and Calculated Members using SQL 2008.
  • Extract, Transformation and load data from ECC into BW using Enhancement, LO Cockpit, Custom and Standard Extractors.
  • Worked extensively on Standard Data-sources with LO Customizing Cockpit for extracting Sales, Delivery, Billing, Purchase and Customer.
  • Designed & developed Fact tables to identify and store Metrics and Key Performance Indicators (KPI) for FCAP project.
  • Created Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures(KPI).
  • Developed reports / KPI's for Supply Chain mechanism, including supply demand GAP and self-life stock monitoring reports.
  • Created RYLA Dashboard and deployed KPI reports on the Dashboard for Management to analyze the performances of different departments.
  • Generated KPI as business requirement that helped the decision maker to find the possible projects to be invested.
  • Created cubes, dimensions and KPI using SSAS (MAX, Tabular)/Power Pivot representing data aggregation.
  • Enhanced the performance of the cubes by creating perspectives, KPI's, Translations and Calculated members.
  • Implemented KPI's, actions, created calculated members for doing intermediate operations on Cubes in SSAS.
  • Created KPI'S and Oracle Score Cards to measure the performance and progress of the business strategy.
  • Created hierarchies in dimensional modeling and defined the appropriate measure groups, KPI's and deployed cubes.
  • Configured Data sources in R/3 by using LO Cockpit (LBWE), Initialized the setup tables.
  • Identified the Metrics and sub metrics, Key performance indicators (KPI's) for Dashboard development.

Show More

27. Oltp

average Demand
Here's how Oltp is used in BI Developer jobs:
  • Worked on Designing and developing normalized OLTP database with referential integrity and constraints.
  • Created ETL (SSIS) process to transfer data from OLTP Files to data warehouse, scheduled and monitored jobs.
  • Designed ER diagrams and mapped the data into database objects and involved in normalization of the database in OLTP.
  • Remodeled OLTP tables, stored procedures, user-defines functions, and views as per changes in business process.
  • Created tables for data ware housing applications and populated the tables from the OLTP database using SSIS packages.
  • Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
  • Created SSIS packages to extract the data from OLTP databases and load it into the target system.
  • Designed and developed ETL strategy to load data from OLTP system to load data on periodic basis.
  • Designed and maintained SSIS packages to migrate data between OLTP servers and the data mart.
  • Involved in data verification and validation of reports against the data warehouse and OLTP database.
  • Extracted the data from various sources like relational and flat file sources of OLTP systems.
  • Created business model and designed a dummy fact model for the OLTP data model.
  • Produced 3NF data models for OLTP designs using data modeling -best practices- modeling skills.
  • Designed SSIS packages and schedule them in jobs to load OLTP data every day.
  • Schedule the packages to keep extracting the data from OLTP at specific time intervals.
  • Design and Implement high availability OLTP strategies, under RAID-10 for better performances.
  • Produced several reports on Data Mart and OLTP Database using Reporting Services.
  • Analyzed the existing MTBC OLTP application and database.
  • Performed CDC and Change tracking on OLTP systems.
  • Created data models for OLTP systems.

Show More

28. C #

average Demand
Here's how C # is used in BI Developer jobs:
  • Created SSIS packages using Conditional Split, Data Conversion, and Fuzzy Logic and C #.
  • Used C #scripts to auto generate sequential value using script transformation in Data flow task.
  • Developed ASP.NET Web Forms, Classes, and Business Logic using C # as code behind language.
  • Used C # and VB in SSIS to design customized tasks.

Show More

29. Source Data

average Demand
Here's how Source Data is used in BI Developer jobs:
  • Prepared resource data for further statistical hypothesis tests and financial mathematical model simulation.
  • Updated technical documentation to map source database to target database.
  • Developed slowly changing dimension SCD-Type2 in SSIS to update old data in dimension tables when the new source data is loaded.
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
  • Analyzed source data, reviewed SQL store procedures, and SSRS report scripts to capture a complete source to target mapping.
  • Performed ETL operations to do data transfer and validation of criminal data needed as source data to feed reporting needs.
  • Design the data flow from end to end, right from capturing the source data till the creation of reports.
  • Created mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
  • Developed ABAP start routines, end routines, and field Level Routines to manipulate and transform source data.
  • Extract, Transform and Load source data into respective target tables to build the required data tables.
  • Designed and developed ETL processes to extract source data from ERP system and load into data mart.
  • Improved the accuracy of the source data by implementing data validation on the source Data for reporting.
  • Developed SSIS packages to transfer data from Source databases like Oracle, Mainframe to SQL Server databases.
  • Worked on source data to identify granularity of data marts, associated Dimensions and Facts, etc.
  • Analyzed the source data, cleansed, standardized source data and provided cleansed data to ETL.
  • Created various Stored Procedures to validate source data and update/insert the records into destination tables.
  • Worked with Business users to understand the Business practices, Source Data and reporting requirements.
  • Factorized market source data into risk factors within Data Warehouse for BARRA model based analysis.
  • Implemented packages to translate the source data to target data and loaded in conversion DB.
  • Analyzed the source data coming from Oracle, SQL server, and flat files.

Show More

30. DTS

low Demand
Here's how DTS is used in BI Developer jobs:
  • Converted stored procedures and DTS packages to run in SQL Server 2005 using T-SQL for SQL Server development of replacement procedures.
  • Worked on all activities related to the development, implementation, administration and support of ETL processes using SSIS and DTS.
  • Created DTS packages and scheduled data migration from old system to new system and verified making different reports on new system.
  • Experience in utilizing ETL tools; SSIS (SQL Server Integration Services) and DTS (Data Transformation Services).
  • Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources.
  • Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
  • Performed detail analysis on server in terms of databases, DTS packages, drivers, files and applications.
  • Convert 100 of DTS package into SSIS and convert C# application into SSIS package to load/transform data.
  • Experienced in ETL using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
  • Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
  • Migrated around 100 DTS packages from SQL 2000 to SSIS 2008 R2 using migration wizard and also manually.
  • Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
  • Experience in evaluating existing DTS packages on SQL Server 2000, upgrading and transforming into SSIS packages.
  • Managed the ETL processes between various environments through scripts utilizing linked servers, DTS packages and SSIS.
  • Used DTS, SSIS, and stored procedures to schedule, update, and validate the data.
  • Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing and deployment.
  • Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
  • Involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.
  • Worked on Data Transformation Services (DTS), SSIS 2005/2008, Bulk Insert/ BCP utility.
  • Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.

Show More

31. Pl/Sql

low Demand
Here's how Pl/Sql is used in BI Developer jobs:
  • Performed analysis of existing Java and PL/SQL logic to facilitate new development.
  • Developed Manufacturing and financial reports using Crystal and PL/SQL.
  • Programmed PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus and other editors.
  • Master Data Management for Merchandise and Assortment Planning using SQL server and Oracle including T-SQL, PL/SQL and stored procedures.
  • Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
  • Developed SQL based solutions for SQL Server and Oracle by creating T-SQL and PL/SQL solutions dealing with hierarchical extracts.
  • Designed and created summary tables and developed PL/SQL Stored Procedures to collect summary data in support of reporting system.
  • Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL stored procedures.
  • Reviewed data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
  • Worked on PL/SQL queries and converted them to T-SQL queries to use as an input for SSIS Packages.
  • Involved in implementation of various data load processes using Oracle PL/SQL and various reconciliation reports, search reports.
  • Created Oracle PL/SQL Stored Procedures, Functions, for use by Framework Manager Packages and Report Studio reports.
  • Develop and support queries and stored procedures using PL/SQL for development, unit testing, and analysis.
  • Design and Develop the reports using info-view in Business Objects XI R2 and Oracle PL/SQL And OBIEE.
  • Developed PL/SQL jobs including Packages and Procedures to load data from data sources to data ware house.
  • Developed complex PL/SQL code for extraction of data from FACETS and transform and load into SMART data-mart.
  • Developed /modified Oracle PL/SQL stored procedures, functions, triggers based on technical and functional specification documents.
  • Developed PL/SQL stored procedures for database updates and to create the necessary Indexes in the target tables.
  • Validate the OBIEE application to ensure that the reports match the data with the PL/SQL procedures.
  • Used PL/SQL procedures for the back end ETL process to load data into target oracle tables.

Show More

32. Report Studio Reports

low Demand
Here's how Report Studio Reports is used in BI Developer jobs:
  • Created Technical design document for Report studio reports based on Functional specifications.
  • Implemented external triggering for report studio reports.
  • Created Power play Transformer Models and Power Cubes and implemented Drill through to Report Studio reports and Impromptu reports.
  • Create cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.
  • Adjusted Report Studio reports prior to PROD adding additional measures, conditional formatting, and advanced calculations.
  • Created various report studio reports using calculations, filters, prompts conditional formatting and drill through.
  • Developed the Report Studio reports using the Dynamic Cube as a data source.
  • Performed Unit testing and System Regression Testing for Report Studio reports.
  • Created Calculations, Filters and Prompts in Report Studio reports.
  • Designed complex Report studio reports.
  • Experience in writing HTML/Java Script in Cognos report studio reports as per the requirements.
  • Created report studio reports based on the TM1 cube 2.

Show More

33. Text

low Demand
Here's how Text is used in BI Developer jobs:
  • Generated context filters and used performance actions while handling huge volume of data for applications and region specific visualizations.
  • Designed SSIS ETL packages to load data from different sources Text files, Excel to staging and staging to Data warehouse.
  • Created events (OnError, OnTaskFailed and the OnPostExecute) to track data loading and store the information in text files.
  • Created For each loop to iterate through a number of suppliers having multiple text files to be loaded to the warehouse.
  • Developed extremely complex dashboards using Tableau table calculations, quick filters, context filters, hierarchies, parameters and action filters.
  • Migrated data from Legacy system (Text files, Excel docs and Access files) to SQL Server Databases using SSIS.
  • Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
  • Worked on SSIS 2008/2012 for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
  • Utilized SAP FI, LO as data sources; loaded master data attributes and texts created transfer and update rules.
  • Tested the Universe on various parameters such as Database Connectivity, loops and Contexts, object mapping, aggregate awareness.
  • Used the row count transformation to keep track of the rows processed and write the data to a text file.
  • Developed dynamic dashboards composed of widgets, panels, panel selectors, metric and attribute selectors, and dynamic texts.
  • Resolved several issues with regards to the contexts, predefined conditions, same prompts handling multiple data sources etc.
  • Designed and Developed Universes using tables, views, materialized views and building contexts and aliases to resolve loops.
  • Defined alias and contexts to resolve loops and also tested them to ensure that the correct results were retrieved.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x / 8.x) reports.
  • Worked extensively with the major functionality of BO like Ranks, Alerts, Input Control, Calculation context etc.
  • Transferred data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Worked on Text, excel files as sources and also archiving them along with pulling remote server files.
  • Loaded Master data (attributes, texts, hierarchies) from flat files to Master Data Info Providers.

Show More

34. Data Analysis

low Demand
Here's how Data Analysis is used in BI Developer jobs:
  • Worked with business users in gathering requirements, source data analysis, development, Testing and preparing technical documentation.
  • Performed business requirement gathering through interactions with business users, analyze requirements and source systems and perform data analysis.
  • Developed advanced dashboards which were used by Executives and top level business users for data analysis and data forecasting.
  • Worked on intensive data analysis tasks using advanced excel and various reporting tools in suggesting various process improvements.
  • Reviewed report requirements and participated in Data Analysis to ensure accuracy and integrity of data.
  • Created Data Mapping Documents to develop ETL packages and translate business requirements into data analysis.
  • Implemented Power BI PowerPivot for data analysis by developing various aggregation and calculations.
  • Conducted data analysis and interpreted business performance trends by using different models.
  • Involved in requirement gathering and data analysis for reporting from business users.
  • Pulled information from Warehouse and presented for forecasting and data analysis.
  • Participated proactively in the development and management of data analysis systems.
  • Performed extensive data analysis, data modeling and database design.
  • Perform data analysis and profiling across different source systems.
  • Designed SSIS packages to Migrate Data from Multiple Data sources for Data Analysis, Deployment and Dynamic configuration of SSIS packages.
  • Provided proactive data analysis of all MR machine issues before the customer report the issue to reduce the MR machine downtime.
  • Modify the existing code for better performance and performed data analysis to resolve the data anomalies in the existing system.
  • Used various data analysis techniques to validate business rules and identify low quality missing data in the Insurance data mart.
  • Support project teams in the areas of metric definitions, data analysis and visualization critical to data driven project management.
  • Created complex formulas using Data Analysis Expression (DAX) and Key Performance index (KPI) in Power Pivot.
  • Supported Great Plains GP 10 and CRM and user's community with Reporting, data Research and Data Analysis.

Show More

35. Unix

low Demand
Here's how Unix is used in BI Developer jobs:
  • Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
  • Automated report generation in the UNIX System for the efficiency during Production and in the Production Environment.
  • Used monitoring tools in UNIX and the database as part of the tuning process.
  • Have worked on creating UNIX shell scripts and scheduling them using Control M scheduler.
  • Assist and administer the deployment process of UNIX, OBIEE and repository codes.
  • Worked on Unix Shell scripts to handle batch jobs running through Job Scheduler.
  • Designed the File Handling from the client BioGen by using UNIX Scripts.
  • Developed UNIX shell scripts as part of the ETL process for scheduling.
  • Worked on creating and scheduling Oracle based applications using Unix Shell scripts.
  • Created technical document for coding standards and procedures and writing Unix Script.
  • Involved in development and maintenance of UNIX (HP) shell scripts.
  • Designed database & UNIX Scripts needed to meet the system requirements.
  • Developed Unix Scripts to call the Data Stage jobs and Sequencers.
  • Designed & implemented d many UNIX Shell Scripting programs.
  • Create SAS programs to transfer data on UNIX environment.
  • Scheduled jobs using PMCMD command and UNIX shell scripting.
  • Created UNIX scripts to execute cubes on servers.
  • Installed and Configured DAC 10.1.3.4.1 on UNIX server.
  • Created and modified Unix Shell Scripts.
  • Worked on Unix shell scripts.

Show More

36. DB2

low Demand
Here's how DB2 is used in BI Developer jobs:
  • Created and Implemented SSIS Packages for importing and exporting data to other data storage like Postgre-SQL, FoxPro, and DB2.
  • Extracted and migrated data from different data sources including DB2, flat files, Excel spread sheets by creating ETL packages.
  • Developed packages and procedures to get data from DB2, X12 and FCR and load into SQL Server DB.
  • Designed SSIS packages to load the data from DB2/SQL Server 2000/2005 to Staging and Staging to pipe delimited files.
  • Developed shell scripts to call DB2 stored procedures for transformations on the source DB2 tables and generating flat files.
  • Developed stored procedures and user defined functions using PL/SQL and T-SQL in MSSQL, DB2 and Oracle environments.
  • Gathered user requirements, analyzed and designed software solution based on the requirements in SQL and DB2 environments.
  • Transfer of data from DB2, flat files and SQL Server into a SQL Server data store.
  • Created various scheduled jobs to handle the data migration from DB2 to SQL Server 2008 R2 periodically.
  • Used Framework Manager to create dimensional/relational data model using multiple data sources using SAP and DB2 databases.
  • Migrated data from IBM-DB2 to SQL Server 2012/2008 with SQL Server Integrated Services (SSIS).
  • Single point of contact for client for all reporting & SQL, DB2 database questions/concerns.
  • Compared the data between DB2 and DW as part of existing Prod DW reports maintenance.
  • Experience with Snapshot Replication from DB2 to SQL Server 2005 database.
  • Created an ODS for reporting from base tables in DB2 database.
  • Involved in installing and migrating DB2 database to SQL Server 2008.
  • Migrated data from DB2 to SQL Server using third party application.
  • Extracted XML files from the DB2 database containing the policy data.
  • Extracted data from several DB2 and SQL Server 2000/2005 warehouses.
  • Experienced in writing queries on DB2 servers.

Show More

37. Informatica

low Demand
Here's how Informatica is used in BI Developer jobs:
  • Performed administration of Informatica repository.
  • Improved Performance by incorporating Informatica's development standards, mapping tuning techniques and session tuning.
  • Validated mappings using Informatica debugger and obtained troubleshooting information about data and error conditions.
  • Developed, Tested and Migrated the Informatica objects to Production environment.
  • Developed mapping and sessions using Informatica power center for data loading.
  • Worked extensively on Informatica debuggers for unit testing and data validation.
  • Worked on Informatica Data Quality to resolve customers address related issues.
  • Experience in Installation and Configuration of Informatica Client and Repository.
  • Promoted Informatica mappings from Development to Test to Production environment.
  • Developed Informatica code for various interfaces for the implementation.
  • Design and implement incremental load process in Informatica Mappings.
  • Work extensively on various Informatica transformations including Transaction Control.
  • Followed Team Based Development for Informatica ETL Development.
  • Developed highly tuned Informatica mappings using partitioning technology.
  • Analyzed and improved performance in Informatica.
  • Created Informatica mappings for data transformation.
  • Created and Monitored Informatica sessions.
  • Developed and tuned all the Affiliations received from data sources using Oracle and Informatica and tested with high volume of data.
  • Experience in Installation and Configuration of OBIA (including Informatica, DAC and OBIEE) Out of the Box Reports.
  • Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.

Show More

38. Toad

low Demand
Here's how Toad is used in BI Developer jobs:
  • Performed indexing & performance tuning to improve the application statistics and response time of the database using Toad.
  • Perform data manipulation, extraction and job scheduling using Oracle Toad Software and SQL Developer.
  • Worked on Toad 10.6 for writing, updating and modifying the SQL Queries.
  • Used TOAD extensively for Unit Testing and Analyzing the data.
  • Developed SQL in TOAD and exported results to Access Database.
  • Used TOAD for the ODS data validation and comparison.
  • Tested reports for uniqueness of data using Toad.
  • Imported Excel data into Oracle tables using TOAD.
  • Created tables and Inserted/Updated Values using TOAD.
  • Performed BI Content Administration tasks including scheduling and content management Developed SQL in TOAD and exported results to Access Database.
  • Created Variables, hierarchies and custom prompts based on these hierarchies.Environment: Windows, Pentaho, Toad

Show More

39. Management Studio

low Demand
Here's how Management Studio is used in BI Developer jobs:
  • Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008/2005 tools like SQL Server Management Studio.
  • Created ETL packages (SSIS packages) using Microsoft Visual Studio 2015 and Microsoft SQL Server Management Studio 2014.
  • Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio
  • Worked with SQL Server Management Studio to manage storage and execution of deployed packages.
  • Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
  • Scheduled the ETL Package (Daily) Using SQL Server 2012 Management Studio.
  • Scheduled the ETL Job Using SQL Server 2005 Management Studio.

Show More

40. R2

low Demand
Here's how R2 is used in BI Developer jobs:
  • Worked comprehensively on complex dynamic SSRS 2008/2008R2 tabular and matrix reports and embedded these reports into different applications.
  • Migrated Desktop Intelligence reports to Web Intelligence using Report Conversion Tool XI R2 and published the converted reports to the CMS.
  • Upgraded MS SQL Server 2008 R2 database to MS SQL Server 2012, by using Detach/Attach, Back up & Recovery.
  • Enhanced and built different reports using SSRS 2008R2 by discounts, service items, cloud node, usage, invoice etc.
  • Involved in upgrading and maintaining MS SQL Server 2008R2 and migration of databases from SQL Server 2008 to SQL Server 2014.
  • Involved in migrating SAP Business Objects R2 CRDW legacy reports to BI 4.0 using the Upgrade Management Tool (UMT).
  • Transformed data from MS SQL Server 2008R2 to MS SQL Server 2012 using OLE DB connection by creating various SSIS packages.
  • Performed Extract, Transformation and Load process to transfer data from HP Serves Manager to data ware house using SSIS 2008R2.
  • Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008R2 and participated in Disaster Recovery Drill processes.
  • Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008R2/2012.
  • Develop Oracle and SQL server 2008 R2 stored procedures, data mappings for data importing, exporting and parsing etc.
  • Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008 R2.
  • Designed and developed Cubes, Calculation, and Cube Partition using SQL Server Analysis Service (SSAS) 2008R2.
  • Created a replica of Production Servers to create SNAT Servers by configuring IIS web Applications in Windows Server 2008R2/2003.
  • Recommended OS configuration for installing Win Server 2012 R2, Tableau Server, and MS SQL Server 2012 R2.
  • Designed and developed various SSIS packages to import data from Excel and Flat files to SQL Server 2012/2008 R2.
  • Worked with the Global Investment department assisting with the upgrade from Business Objects BOXIR2 to Business Objects 4.0.
  • Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008 R2.
  • Train and mentor other staff in SQL Server 2008 R2, business rules, and data mart.
  • Configured SQL Server2014 and SSRS using IIS and troubleshooting performance issues and fine-tuning queries and stored procedures.

Show More

41. TFS

low Demand
Here's how TFS is used in BI Developer jobs:
  • Used TFS to keeping track of the history, merging code between the different versions of the software, check-in/check-out options.
  • Worked in Agile/Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
  • Used Team Foundation Server (TFS) and successfully tested all tasks in staging and stored all versions of data.
  • Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
  • Developed and refined a system to coordinate time and labor reporting between Oracle, and TFS into Project Server.
  • Implemented TFS (Team Foundation Server) for code check-in and check-out and management of different code versions.
  • Worked on Team Foundation Server (TFS) to synchronize the data with different-2 sources as well.
  • Code check in and checked out on a daily basis using Team Foundation Server(TFS).
  • Utilize Visual Studio/ TFS (Team Foundation Server) to manage user requests and source code control.
  • Worked on Team Foundation Server (TFS) to maintain track of report and also all documentation.
  • Used Team Foundation Server (TFS) to create Build tickets for testing and deployment.
  • Integrate TFS work items with SQL Server database and create SSRS reports from TFS DW.
  • Experience in using revision control software of SVN and TFS for Agile sprint planning Methodology.
  • Used Team Foundation Server (TFS) for version control, source control and reporting.
  • Utilized TFS for code check-in and check-out and manage different versions of complicated codes.
  • Experience in working with version control tools like Team Foundation Server-TFS 2010 and 2013.
  • Used Team Foundation Server (TFS) for all the source code maintenance needs.
  • Utilized Team Foundation Server (TFS) for the version control and project co-ordination.
  • Used the TFS 2005 to upload reports for collaboration purposes and version control.
  • Used TFS (Team Foundation Server) for project management and source control.

Show More

42. Complex Reports

low Demand
Here's how Complex Reports is used in BI Developer jobs:
  • Involved in utilizing QlikView solutions to develop complex reports and executive dashboard.
  • Developed complex reports using drill-through options and Master-detail relationships in Report Studio.
  • Developed the complex reports using Query Calculation and Layout Calculation.
  • Designed and implemented several complex reports and administration modules.
  • Developed complex reports using report studio.
  • Connected to different various data sources like Oracle, SAP, and flat files to create and schedule different complex reports.
  • Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Created List, cross tab and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio.
  • Developed complex reports in report studio in PDF and EXCEL format to meet the specifications given in the business requirements.
  • Work extensively on creating Application Objects like Metrics and Compound metrics, Filters, and Custom Groups for complex reports.
  • Created complex reports using multiple data providers like Oracle, SQL and Excel to extract data and also to Validate.
  • Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
  • Developed and Deployed Complex Reports, used multiple data providers and created master/detail, cross tab, and charts.
  • Created complex reports on excel using macros and other advance excel functions (COUNTIFS, SUMIFS etc.).
  • Developed multiple Complex reports like Master-detail relationship, drill through, burst options and Cascading prompts using Report studio.
  • Developed many complex reports as list, cross tab, drill through and master-detail chart using Report Studio.
  • Developed Complex Reports having many filters, calculations, unions, Conditional blocks, variables using Report Studio.
  • Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc.
  • Created complex reports like detail level sales transaction reports, monthly aging, and YTD revenue reports.
  • Constructed complex reports that involved multiple data providers, graphical data such as pie charts, graphs.

Show More

43. Teradata

low Demand
Here's how Teradata is used in BI Developer jobs:
  • Experience in retrieving data from different data sources like TERADATA and SQL SERVER for creating of complex SSRS reports.
  • Used InfoSpoke to export data to TeraData.
  • Created Information Links for many databases for populating data into Visualization from underlying databases such as Teradata and Oracle etc.
  • Participated SCRUM sessions to develop Extended Logical Models and Physical Models for Teradata.
  • Involved in monitoring performance and tuning different teradata applications.
  • Developed and tuned reports developed over Teradata.
  • Designed Universes on Teradata DB platform as per the technical requirements and applied the necessary object level, row level security.
  • Report development work involved the creation of reports from SAP (BI 7.3) and non-SAP (Teradata) data sources.
  • Implemented stored procedures that help in driving the complex UNIX & Teradata process by dynamically populating a table with required dates.
  • Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
  • Pulled data into MS SQL Server Database from different DBMS databases like Oracle and Teradata with ETL packages.
  • Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
  • Developed SQL Server Stored Procedures for data migration and transformation from Teradata extracts to SQL Server objects.
  • Created SSIS packages to extract data from text files, Teradata, oracle to OLAP cubes.
  • Used free form SQL in Teradata to sort out data sets with more than 1000 records.
  • Performed data extraction and manipulation from various databases (Oracle and Teradata) for claims data.
  • Created different stage tables in Teradata to be loaded from EDW (SQL server).
  • Developed Windows Batch scripts to extract Sales data from NCR Teradata Database to Flat Files.
  • Analyzed various data sources for the projects including Teradata, Oracle and SQL Server.
  • Utilized Teradata query tools and/or write SQL queries to extract data from relational databases.

Show More

44. Wizard

low Demand
Here's how Wizard is used in BI Developer jobs:
  • Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
  • Worked with Deploying the SSIS packages using SQL Server package deployment wizard to deploy the packages on the production server.
  • Maintained and enhanced existing Universes for the Quality Assurance department and promoted them to the production environment using Import Wizard.
  • Optimized Cubes using the aggregation wizard and usage based optimization to make the queries more efficient, easier and faster.
  • Assisted the client Wizard of the Coast in developing their BI system to control and manage their gaming business.
  • Upgraded SSIS packages for an entire Application from 2005 to 2008 using Project wizard and successfully deployed packages.
  • Experience in using SSIS tools like Import and Export wizard, package installation and SSIS package designer.
  • Migrated universes and all related documents from BO 6.5.1 to XI R2 file system using migration wizard.
  • Created reports using Report Model Project, Report Server Project, and Report Server Project Wizard.
  • Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index Tuning Wizard.
  • Experienced in publishing Business Objects reports using Import Wizard, LCM, and Publishing Wizard.
  • Used Date Wizard to create Time Dimension in Transformer for creating Cubes and PowerPlay Reports.
  • Implemented Time Comparison and calculation measures in the business model using Time series Wizard.
  • Used Index tuning wizard to redesign and created index to increase the query performance.
  • Experience in SSIS package (Microsoft SQL server 2012) using import/export wizard.
  • Optimized Indexes for better performance using Execution Plans and Database Engine Tuning wizards.
  • Deployed the crystal reports and business views to production using import wizard.
  • Used export and import wizard to load reference tables in the database.
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Optimized Indexes on columns by analyzing them by using Index tuning wizard.

Show More

45. User Acceptance

low Demand
Here's how User Acceptance is used in BI Developer jobs:
  • Tracked and resolved defects encountered during component, assembly, and integration and user acceptance test execution.
  • Design test plans and facilitate user acceptance testing including issue resolution.
  • Tested all the solutions I created and prepared the test cases, test results and observed most User Acceptance Tests.
  • Performed user acceptance testing as new content is being added to HR Data Warehouse and hub common format files.
  • Performed testing with all values and scenarios in the developed reports for user acceptance and production deployment.
  • Executed test plans for unit testing, integration testing, user acceptance testing, documentation and tracking.
  • Supported the testing team and business through System Integration testing and User Acceptance Testing of reports.
  • Experienced in Integration Testing and User acceptance testing for several extracts and Data loads to EDW.
  • Test applications in all phases of development to ensure proper functionality and end- user acceptance.
  • Defect resolution during Unit Test, Assembly Test, Product Test and User Acceptance Test phases
  • Participated in integration, performance, and user acceptance testing for BI solutions.
  • Provided support during QA testing, integration testing and user acceptance testing.
  • Performed Regression and User Acceptance testing to check the data accuracy.
  • Involved in documenting user acceptance test plan and test cases.
  • Developed, managed, and coordinated all user acceptance testing.
  • Participated in system and user acceptance testing tasks as assigned.
  • Performed user acceptance testing on new and modified reports.
  • Performed Unit Testing and User Acceptance Testing.
  • Participated in supporting the User Acceptance Testing.
  • Conducted the User acceptance testing.

Show More

46. Business Logic

low Demand
Here's how Business Logic is used in BI Developer jobs:
  • Participated in developing logical design of database incorporating business logic and user requirement and building entity relationship(ER) diagrams.
  • Designed and developed a custom web-based CRM primarily using stored procedures and triggers for data manipulation and business logic.
  • Convert complex business logic into Stored Procedures and Functions to achieve functionality required by business analysts.
  • Developed Reports, Visualizations, calculated metrics and filters for various procurement business logic.
  • Developed SQL Server Procedures and Functions to accommodate complicate business logic.
  • Converted complex business logic into SQL stored procedures and user-defined functions.
  • Developed Stored Procedures to calculate metric values implementing business logic.
  • Configured expressions and implemented business logic using set analysis.
  • Created Stored Procedures for implementing certain business logic.
  • Developed Stored Procedures to implement the business logic.
  • Designed the ETL process which included access, manipulation, analysis, interpretation, and presentation of data per business logic.
  • Interacted with partners to understand and propose solution, written robust business logic to determine In-Role, New-Role promotions for HQ/DC/Stores.
  • Involved in the development of the Business logic layer using C# and Data access layer using C# and ADO.NET.
  • Created complex User Defined Functions to be implemented in many Stored Procedures where the same business logic is required multiple times.
  • Implement the business logic and developing codes for the Transformation of the data and store them in different subject areas.
  • Created the TI processes and rules as per the business logic to load the bought trades on the daily basis.
  • Understand and frame the business logic provided by the customer into meaningful low-level entities and building relationships between them.
  • Developed multiple Stored Procedure to support business logic for extracting data from source as well as Data Validation.
  • Supported SSRS Report writer with data issues and clarifying business logic on extracting data for report.
  • Worked with translation team and business to understand the source and target business logic for mapping.

Show More

47. QA

low Demand
Here's how QA is used in BI Developer jobs:
  • Performed environment migrations between the Development, QA and Production environments.
  • Coordinated Quality Assurance(QA) testing team for system wide testing and regression testing developing test cases for all scenarios.
  • Created SQL Server Reports using SSRS 2012 and exported them to Excel format for managers and QA team for easy validation.
  • Bubble chart to represent data, fetched Using Business Objects Universe connected through QAAWS and using Google Maps API for Dashboard.
  • Transport all the objects from DEV to QA for testing and then QA to Production with the collaboration of Basis team.
  • Developed many case solutions for YAGO, QAGO, MAGO measures for comparing the various case types' service requests.
  • Assisted QA Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas.
  • Use Promotion Management Tool to move reports from DEV to QA and from QA to Prod environments by creating jobs.
  • Created a Java application for automatic report migration from DEV to QA, QA to PROD based on approvals.
  • Worked closely on multiple projects with multiple cross functional team: Development team, business team and QA team.
  • Served as a QA test resource, conducting extensive black-box, functional and use case testing for reporting team.
  • Fix issues, and Test data loading in QA environment with EAM (Enterprise Application Maintenance) team.
  • Prepare Analysis Report, develop module, prepare Test Case and test with QA team for new initiatives.
  • Maintained the Full and Incremental loads through DAC on different environments like Development, QA and Production environment.
  • Worked with QA team on the reports and documented all test procedures and worked closely with End users.
  • Migrate projects from development to QA/Production environments; Uses best practices and naming conventions through SSIS development.
  • Created Deployment utility(.bat) to deploy SSIS packages over Production, QA and Local System.
  • Involved in transporting the BW objects from development system to QA for unit testing and integration testing.
  • Constructed an intuitive and dynamic reporting suite around the quality measurements of HEDIS, STAR, QARR.
  • Worked closely with QA to validate and tests reports and business process prior to migration to production.

Show More

48. UAT

low Demand
Here's how UAT is used in BI Developer jobs:
  • Worked with operational\BI technical Framework\architecture\skeleton\pattern, tools evaluation techniques.
  • Performed necessary investigation, analysis and evaluation of various systems for feasible reporting for the business.
  • Evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.
  • Participated in evaluation and selection of Query and Analysis tools, identified performance measurement processes.
  • Provided production support for existing Status Reporting system using Actuate prior to conversion to MicroStrategy.
  • Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
  • Participate in evaluating and analyzing utilities and tools offered by BI applications/tools vendors.
  • Deploy reports and projects/frameworks models from development to UAT and production environments.
  • Converted data fields from antiquated databases structure to new database environment.
  • Gather and evaluate reporting requirements to support business reporting needs.
  • Evaluated and improved existing processes and designed technical documentation.
  • Audit reporting system implementation on UAT and Production Environments.
  • Evaluated performance test results and developed technical architecture.
  • Evaluated business processes and defined products.
  • Used various features of Actuate like Data Filters, Single Input Filter, Memory Data Sorter, and Page Level Security.
  • Used 2LIS_03_BF (delta stock balances and movements) and 2LIS_03_UM (revaluations) and 2LIS_03_BX (initial stock balances).
  • Created High level and Detailed design of Actuate Reports and the queries to extract data from the new oracle database.
  • Lead the team in internal BI environment upgrades and testing by keeping Production, UAT and Development environments in sync.
  • Involved in migration of OBIEE repository, web catalog from Development environment to testing and then to UAT and Production.
  • Perform unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Show More

49. CSV

low Demand
Here's how CSV is used in BI Developer jobs:
  • Designed SSIS packages to transfer data from various heterogeneous sources such as SQL Server, Excel, CSV, etc.
  • Created data processing jobs in SSIS to collect data from various sources such as FTP, Excel and CSV files.
  • Created staging environment in SQL 2008 for the data migration from different heterogeneous sources (CSV, Excel).
  • Export and import data from Flat file, CSV file, Excel to/from SQL Server database using SSIS.
  • Provided CSV and Excel files to managers for particular records they wanted to look at in different meetings.
  • Designed SSIS packages to load data from CSV and excel files to the Staging Area in SQL server.
  • Set up MicroStrategy and Windows Performance Counters and logged them to text or CSV for performance tracking.
  • Designed SSIS packages to extract data from different data sources like SQL, Cubes and CSV/text files.
  • Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
  • Used ETL for data cleansing and loading from flat files such as CSV, Microsoft Excel.
  • Created CSV and excel files for data analyst for the particular records they want.
  • Dump them to CSV files that can be imported into the new system.
  • Exported data from SQL server 2008 tables to CSV files using SSIS packages.
  • Produced reports in various formats like PDF, CSV, HTML and languages.
  • Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
  • Involved in exporting the reports in different formats like excel, puff, csv text files and publishing the reports.
  • Created an ETL Solution that reads Product, Vendor and Order data from .CSV files into a SQL Server Database.
  • Transacted with various formats of data; flat files, CSV, XLS; to create and maintain large datasets.
  • Extracted data from Oracle, .CSV, Excel and Text files and loaded into destination tables.
  • Create specific reports to ensure reports can be exported in .CSV format for financial end-users.

Show More

50. Html

low Demand
Here's how Html is used in BI Developer jobs:
  • Modified JavaScript in WebFocus-created user-interface HTML pages to enable attribute filtering.
  • Implemented HTML emails into Velocity campaign management software.
  • Create a variety of outputs (customer ready PDF documents, HTML output for optimum online viewing, Excel spreadsheet).
  • Designed and implemented reports with different layouts using SSRS 2005 and exported them into Excel, PDF and HTML.
  • Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
  • Implemented functionality of linking attribute elements to various reports/folders in the project by using SQL, HTML concepts.
  • Experienced in handling Web based Intranet/Internet application using ASP, HTML, and VB Script in IIS.
  • Generated output reports in RTF, PDF, HTML and Excel format using SAS/ODS Statement.
  • Used Joins, Filters for various reports formats like Documents, HTML, Excel etc.
  • Used HTML and JavaScript to improve the look and feel of the reports.
  • Created optional filters/prompts in report studio using Java Script and HTML.
  • Customized Reports using HTML, JAVASCRIPT and SDK.
  • Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
  • Use of SAS ODS Graphics Editor 9.41 for Output in various Formats(HTML, etc).
  • Exported reports into various Formats like PDF, HTML, Excel and Word for the Users.
  • Designed user parameterized input screens using WebFocus HTML Composer.
  • Used Razor Views to enable fast coding workflow and quickly integrate server code into HTML markup with minimum of keystrokes.
  • Designed and developed N-tier Windows application using Web forms in CSS, HTML, VB Script and ASP.Net.
  • Developed views using Master Pages, Partial Views, custom HTML helper and jQuery with Razor view engine.
  • Used Java scripts to embed inside report as HTML items to achieve different functionality in Cognos reports.

Show More

20 Most Common Skill for a BI Developer

SQL13.6%
Data Warehouse10.8%
Database7.1%
Dashboards6.7%
Ssis6.5%
Ssrs6.5%
ETL6%
Business Requirements5.9%

Typical Skill-Sets Required For A BI Developer

RankSkillPercentage of ResumesPercentage
1
1
SQL
SQL
9.9%
9.9%
2
2
Data Warehouse
Data Warehouse
7.8%
7.8%
3
3
Database
Database
5.2%
5.2%
4
4
Dashboards
Dashboards
4.9%
4.9%
5
5
Ssis
Ssis
4.7%
4.7%
6
6
Ssrs
Ssrs
4.7%
4.7%
7
7
ETL
ETL
4.4%
4.4%
8
8
Business Requirements
Business Requirements
4.3%
4.3%
9
9
Windows XP
Windows XP
3.9%
3.9%
10
10
T-Sql
T-Sql
2.9%
2.9%
11
11
Complex Queries
Complex Queries
2.8%
2.8%
12
12
Ssas
Ssas
2.7%
2.7%
13
13
Drill Down
Drill Down
2.5%
2.5%
14
14
Olap
Olap
2%
2%
15
15
Column
Column
1.9%
1.9%
16
16
Tableau Server
Tableau Server
1.8%
1.8%
17
17
Schema
Schema
1.7%
1.7%
18
18
XML
XML
1.6%
1.6%
19
19
Ad-Hoc
Ad-Hoc
1.5%
1.5%
20
20
Sub Reports
Sub Reports
1.4%
1.4%
21
21
Cognos
Cognos
1.4%
1.4%
22
22
Fuzzy Lookup
Fuzzy Lookup
1.3%
1.3%
23
23
Sharepoint
Sharepoint
1.2%
1.2%
24
24
MDX
MDX
1.2%
1.2%
25
25
Fact Tables
Fact Tables
1.2%
1.2%
26
26
KPI
KPI
1.2%
1.2%
27
27
Oltp
Oltp
1.1%
1.1%
28
28
C #
C #
1%
1%
29
29
Source Data
Source Data
1%
1%
30
30
DTS
DTS
1%
1%
31
31
Pl/Sql
Pl/Sql
1%
1%
32
32
Report Studio Reports
Report Studio Reports
0.9%
0.9%
33
33
Text
Text
0.9%
0.9%
34
34
Data Analysis
Data Analysis
0.9%
0.9%
35
35
Unix
Unix
0.9%
0.9%
36
36
DB2
DB2
0.9%
0.9%
37
37
Informatica
Informatica
0.9%
0.9%
38
38
Toad
Toad
0.9%
0.9%
39
39
Management Studio
Management Studio
0.8%
0.8%
40
40
R2
R2
0.8%
0.8%
41
41
TFS
TFS
0.8%
0.8%
42
42
Complex Reports
Complex Reports
0.8%
0.8%
43
43
Teradata
Teradata
0.7%
0.7%
44
44
Wizard
Wizard
0.7%
0.7%
45
45
User Acceptance
User Acceptance
0.7%
0.7%
46
46
Business Logic
Business Logic
0.7%
0.7%
47
47
QA
QA
0.7%
0.7%
48
48
UAT
UAT
0.6%
0.6%
49
49
CSV
CSV
0.6%
0.6%
50
50
Html
Html
0.6%
0.6%

22,016 BI Developer Jobs

Where do you want to work?