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

SQL BI Developer

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

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

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

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

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

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

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

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

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

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

or

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

Email and password are mandatory

Already have an account? Log in

reset password

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

Back to Log In

Company Saved

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

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 SQL BI Developer Skills

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

These are the most important skills for a SQL BI Developer:

1. SQL

demand arrow
high Demand
Here's how SQL is used in SQL BI Developer jobs:
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
  • Developed, monitored, scheduled and executed SSIS package by using MS BIDS and SQL Server Agent.
  • Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow task etc.
  • Monitor connections, sessions, locks, deadlocks and performance of SQL server.
  • Installed, authored, and managed reports using SQL Server 2014 Reporting Services.
  • Used SQL Reporting Services and Report Builder Model to generate custom reports.
  • Planned job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
  • Designed a report on the monitoring of SQL Server Performance.
  • Installed couple of SQL Server 2005/2008 on cluster environment.
  • Migrated SQL servers 2000/2005 to SQL server 2008 edition.
  • Created SQL server dynamic configurations for SSIS packages.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
  • Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
  • Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
  • Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.
  • Involved in installation and configuration of SQL Server 2008 and SQL Server 2008 with latest service packs.
  • Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
  • Imported data using SSIS packages and using custom Sql server stored procedures.
  • Fine-tuned SQL queries to improve query performance and to reduce runtime.
  • Extracted data from various source systems like Teradata, Sql Server and flat files.

Show More

4 SQL Jobs

No jobs at selected location

2. Database

demand arrow
high Demand
Here's how Database is used in SQL BI Developer jobs:
  • Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Modified existing database to fit new business requirement by adding tables and relationship.
  • Provided assistance in the development of conceptual and logical database.
  • Generated reports from different Databases and OLAP data warehousing.
  • Involved in SQL security and planning; administrating and creating user accounts for proper access, SQL/Server system databases and tables.
  • Involved in the extraction of data from different sources like OLTP server, flat files, excel and legacy databases.
  • Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
  • Automated shrinking of logs and databases after a 95% critical space threshold has been reached.
  • Involved in migrating data from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
  • Generated Script files of the databases whenever changes are made to stored procedures or views.
  • Managed the migration of SQL Server 2012 databases to SQL Server 2014.
  • Involved in developing logical and physical model of database using Erwin.
  • Involved in installing and migrating legacy databases to SQL Server 2005/2008.
  • Worked on Stored Procedures and Database Triggers and TSQL queries.
  • Created Linked Server to retrieve data from other databases.
  • Upgraded SQL Server 2005 database to SQL Server 2008.
  • Developed stored procedures, functions and database triggers.
  • Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Show More

3. Ssis

demand arrow
high Demand
Here's how Ssis is used in SQL BI Developer jobs:
  • Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2005/2008.
  • Generated Custom ETL scripts using SSIS 2014 and develop and unit test SSIS load processes for performance check.
  • Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
  • Used various containers, tasks, transformations, connection managers, script task to develop SSIS packages.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
  • Created SSIS packages to download data from FTP sites and populating into different databases and tables.
  • Created SSIS Packages to move the data from severs and performed other data transformations.
  • Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
  • Used VB Script for validating client side data entry screens in SSIS Packages.
  • Develop ETL packages using SSIS to load fact and dimension tables for EDW.
  • Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
  • Assist data modelers in designing of dimensional model for Star schema.
  • Developed SSIS packages, stored procedures, functions, triggers.
  • Involved in Migration of different DTS packages to SSIS packages.
  • Experience in developing SSIS packages for administering SQL server.
  • Created SSIS packages to import data from MS Access, Excel to SQL 2008R2.
  • Created Tables, Macros in Teradata SQL Assistant 7.1 and generating the sample reports using Excel 2007.
  • Used various transformations in SSIS like Lookup, Fuzzy grouping and Row Count Transformations.

Show More

2 Ssis Jobs

No jobs at selected location

4. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in SQL BI Developer jobs:
  • Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
  • Involved in design and development of financial data warehouse for internal department.
  • Participate in development and creation of Data warehouses.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.
  • Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
  • Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
  • Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.
  • Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
  • Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
  • Used Primary Key and Foreign Key to design the data warehouse maintaining the data mapping.
  • Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
  • Consolidated the data from all the data marts to build Enterprise Data warehouse.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Design, develop and implement complete life cycle of data warehouses.
  • Developed SSIS ETL s for Staging and Data warehouse pulling from Sybase, Oracle, SQL Server and various flat files.
  • Worked with OLTP, OLAP, Data Warehouse application, star schema, dimensional modelling.
  • Worked on the cluster failover and server maintenance process of the Data warehouse applications.

Show More

1 Data Warehouse Jobs

No jobs at selected location

5. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in SQL BI Developer jobs:
  • Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports and report stored procedures.
  • Generated Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
  • Generated and consolidated monthly reports to drive forecast production plan with SQL report services (SSRS).
  • Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.
  • Configured out IIS, deployed and scheduled reports by using SSRS and Report server.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Installed, Configured, and administered SQL Server Reporting Services (SSRS).
  • Developed and wrote documents for stored procedures, SSIS packages and SSRS Reports.
  • Provided trend reports to product development to target problem areas using SSRS.
  • Configured report server and report manager for SSRS report deployment and management.
  • Used SSRS to schedule reports to be generated on predetermined time.
  • Created Report Snapshots to improve the performance of SSRS.
  • Deployed types of reports into web-portal by using SSRS.
  • Developed Reports using SSRS, Tableau.
  • Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
  • Based on the data warehousing, i created new reports by using SSRS.
  • Designed and implemented parameterized and cascading parameterized reports using SSRS.
  • Generated parameterized/Drilldown reports using SSRS.
  • Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.

Show More

1 Ssrs Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. T-Sql

demand arrow
high Demand
Here's how T-Sql is used in SQL BI Developer jobs:
  • Involved in writing T-SQL, stored procedures, views, triggers, used indexes, constraints & business rules wherever applicable.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Developed various T-SQL stored procedures, views, and adding/changing tables for data load and transformation, and data extraction.
  • Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL for SQL Server 2005.
  • Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and views to support efficient data storage and manipulation.
  • Optimized T-SQL scripts and stored procedures used to feed reports and implemented ETL logic for faster loading and processing.
  • Experience in Database Normalization, Designing, Creating Indexes, Developed Queries & T-SQL Scripts in MS SQL.
  • Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.
  • Created complex conceptual database designs in SQL Server 2005/2008 using various constraints procedures and queries in T-SQL.
  • Involved to work with T-SQL, stored procedure to increase the performance tuning in terabyte database environment.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
  • Developed complex stored procedures using T-SQL to generate reports using Crystal Reports 9.0.
  • Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
  • Designed and optimized indexes, views, stored procedures and functions using T-SQL.
  • Developed complex T-SQL code for the application.
  • Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views, CTE's and other T-SQL scripts.
  • Developed advanced correlated and un-correlated sub-queries in T-SQL to create complex reports and prepared the List Report for customers.
  • Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
  • Improved Performance by creating Clustered and NoN clustered Indexes and by Optimizing the T-SQL statements using SQL profiler.
  • Performed T-SQLtuning and optimizing queries and stored procedures, which take longer time in execution.

Show More

7. ETL

demand arrow
high Demand
Here's how ETL is used in SQL BI Developer jobs:
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Prepared and used test data & test cases to verify accuracy and completeness of ETL, report process.
  • Worked on creation of mapping documents and development of ETL strategy for Initial and incremental load.
  • Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
  • Worked in Compliance Information technology and Legal affairs team as a Senior SQL and ETL developer.
  • Design, develop & test the ETL processes according to industries best practices using SSIS.
  • Automated the ETL process by scheduling SSIS package execution by creating and scheduling jobs.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures.
  • Improved efficiency for clients by training new programmers in organizational ETL processes.
  • Added new functionality to the existing ETL/SSIS packages and validated the changes.
  • Debugged existing ETL processes and did performance tuning to fix bugs.
  • Developed master child package technique to manage big ETL projects efficiently.
  • Reduced the overall ETL time by SQL Query performance Tuning.
  • Worked on Data Migration and ETL operations using SSIS.
  • Worked on creating an ETL Framework.
  • Involved in Database modeling, ETL and creation of analytical processes, responsible for translating the Business requirements into technical specifications.
  • Develop data models, DB objects, meta data, ETL; KPI's, summary and detail reports.
  • Implemented entire ETL job plan through Informatica Scheduler.
  • Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process and create run books.

Show More

8. Ssas

demand arrow
high Demand
Here's how Ssas is used in SQL BI Developer jobs:
  • Provided Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
  • Migrated and recreated existing dimensions and cubes using Star Schema on SQL Server 2008 to achieve the efficiency of SSAS.
  • Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
  • Worked with SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models.
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005/2008/2012 (SSAS).
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Designed and created complex cubes for analyzing the profit of commercial and individual banking products in SSAS.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
  • Created star schema in SSAS and developed SSRS reports based on the cube.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
  • Designed Partitions in Cubes on time for improvement in performance using SSAS.
  • Involved in cube creation, and Browsing cube data using SSAS.
  • Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
  • Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
  • Involved in creating SSAS projects using SQL Server 2008R2.
  • Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
  • Used SSIS for ETL processes, SSRS & Tableau for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
  • Developed a multi-dimensional database, OLAP cube and Pivot Tables by using SSAS.
  • Experience in creating Multidimensional cubes using SSAS and designing DW schemas.

Show More

1 Ssas Jobs

No jobs at selected location

9. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in SQL BI Developer jobs:
  • Produced DI solutions meeting 100 percent of technical specifications and business requirements according to the established designs.
  • Collected business requirements from users and translated them as technical specifications and design documents for development.
  • Gathered and documented business requirements, Security requirements, Enterprise Data Sources and External Data Feeds.
  • Analyzed the business requirements and translated the functional specifications into technical specifications.
  • Developed Aggregations and calculated members for cube as per business requirements.
  • Evaluate and document business requirements and functional specifications for technical design.
  • Understand Business requirements and convert them into technical specifications.
  • Translate business requirements into software applications and models.
  • Created functional/technical specifications based on business requirements.
  • Worked closely with Business People for gathering business requirements for the reports, data load processes and for the Cubes development.
  • Performed ETL process using SSIS and involved in generation of reports as per the business requirements.
  • Developed Complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
  • Designed, created dimensions/tables and the requisite relationships to meet business requirements based on ER diagram.
  • Created Grouping, Sorting columns and writing expressions according to the business requirements.
  • Analyzed and designed business processes as per the business requirements with SSRS reports.
  • Implemented transactions at package level and task level to meet the business requirements.
  • Analyzed data flow and business requirements to create High Level Design document.
  • Generated reports using SSRS as per business requirements.
  • Involved to work with .NET, C#, VB6 environment within SSIS, SSRS to implement the business requirements.
  • Generated SQL Server Drill down, Drill through, Adhoc, Sub-Reports using SSRS to fit business requirements.

Show More

10. Drill Down

demand arrow
high Demand
Here's how Drill Down is used in SQL BI Developer jobs:
  • Generated various reports like Matrix reports, Tabular reports, and Chart reports, link Reports, Drill down reports.
  • Designed, developed, and deployed SSRS reports with functionality such as Drill Down, Drill through, and Parameters.
  • Developed Query for generating Drill Down and Drill through Reports, sub report in SSRS.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
  • Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
  • Created drill down and sub reports from SSAS cubes that can be browsed on web.
  • Created some reports (Drill down and drill through) for reporting data process.
  • Developed various types of Reports like Tabular Reports and Drill Down reports using SSRS.
  • Created and worked with drill down reports and identified the report parameters.
  • Created Tabular, drill down reports using SSRS 2010 for Sales department.
  • Developed Query for generating drill down reports in SSRS 2008.
  • Created queries for generating drill down reports in SSRS 2005.
  • Used SSRS for creating matrix and tabular, drill down, drill through, and parameterized reports based on requirements.
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
  • Created and formatted various reports such as drill down, drill through, sub reports and parameterized reports.
  • Created/Developed Drill down reports, Cross-Tab reports, Parametrized reports & Summary reports by Using SSRS.
  • Developed drill through, drill down, parameterized, cascaded and sub-reports using SSRS.
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Worked on the development and deployment of parametrized SSRS Reports with various functionalities such as Drill Down and Drill Through.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Show More

11. Windows XP

demand arrow
high Demand

12. Query Analyzer

demand arrow
high Demand
Here's how Query Analyzer is used in SQL BI Developer jobs:
  • Created/optimized stored procedures using input, output, table valued parameters and query analyzer.
  • Worked with Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server.
  • Worked on SQL Server 2008 Enterprise Manager and Query Analyzer to administer SQL Server.
  • Involved in performance tuning to optimize SQL queries using query analyzer.
  • Used Query Analyzer to optimize SQL Queries and shortened lengthy queries.
  • Used Query Analyzer to optimize SQL queries.
  • Worked extensively in Query analyzer and profiler for tuning queries using variables for characteristics and query costs.
  • Monitored the performance of SQL Server and Windows using SQL Server Profiler, Windows Performance monitor and SQL Server Query Analyzer.
  • Developed highly scalable report automation system utilizing SSIS, T/SQL, stored procedure, cursor, Enterprise Manager, Query Analyzer.
  • Involved in Performance Tuning and query Tuning and used several sql Tools like Query Analyzer, red gate etc.
  • Used SQL Profiler for creating traces by which a suggestion for the query is analyzed by SQL query analyzer.
  • Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
  • Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
  • Used SQL Profiler and Query Analyzer to optimize DTS/ETL package queries and stored procedures.
  • Performed tune to optimize SQL queries using SSQL profiler and query analyzer.
  • Analyzed SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
  • Used Query Analyzer / best practices to optimize SQL Queries Successfully migrated data from M.S Access 2007 i.e.

Show More

13. Olap

demand arrow
high Demand
Here's how Olap is used in SQL BI Developer jobs:
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Implemented OLAP Cubes for providing summarized and aggregate views of large sets of data using SSAS.
  • Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
  • Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
  • Created OLAP models based on Dimensions and Facts for efficient loads of data.
  • Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
  • Maintained existing and created new relational and OLAP data warehouses using ETL processes.
  • Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
  • Created OLAP Cubes from the integrated data and generated reports on those cubes.
  • Designed an OLAP with the help of ERWIN to visualize data structure.
  • Experience in Programming AMO OLAP advanced objects like KPI's and Perspectives.
  • Created OLAP cubes using SSAS and created reports from them.
  • Recognized the fact and dimension tables from the OLAP database.
  • Involved in Analyzing, building and testing of OLAP Cube.
  • Designed and built OLAP cubes to meet reporting needs.
  • Created Time Dimensions on OLAP Cubes using SSAS.
  • Created and Managed OLAP Cubes using SSAS.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005.
  • Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.

Show More

14. Schema

demand arrow
high Demand
Here's how Schema is used in SQL BI Developer jobs:
  • Analyzed functional specifications and designed dimensional data models using star schema for the data warehouse.
  • Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
  • Designed and developed cubes to create relational database using Star Schema with SQL Server Analysis Services.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Created Partitions, Calculated Members, Schema and File Groups for fact tables and cubes.
  • Developed physical data models and created DDL scripts to create database schema and database objects.
  • Created databases and schema objects including tables, indexes, views and applied constraints.
  • Created domain XML schema (XSD) for use in services, and messaging/integration/import.
  • Defined relationship between facts and dimensions with star schema and Snowflake Schema in SSAS.
  • Involved in designing star schema and snowflake schema using facts, dimensions and measures.
  • Identified the dimension, fact tables and designed the Data-Mart using Star schema.
  • Created and deployed Star Schema (data marts) for OLAP Cube generation.
  • Designed and developed Star and Snow Flake Schema as a data analyst.
  • Assisted in the design of star schema and snow flake schema.
  • Designed star / snowflake schema and hierarchies for best practices.
  • Created and Managed OLAP Cubes using SSAS Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Involved in Dimensional modeling by identifying the fact and dimension tables and design start/snow flake schemas for the SS Analysis services.
  • Experience in Logical modeling using the Dimensional Modelling techniques such as Star Schema and Snow Flake Schema.
  • Created data Schemas (Name Spaces), views and established various connections with Teradata and SSMS in Customized SQL tool.
  • Followed Ralph Kimball Approach and created multi-dimensional data warehousing including snowflake schema, data marts, fact tables and dimension tables.

Show More

15. Sub Reports

demand arrow
average Demand
Here's how Sub Reports is used in SQL BI Developer jobs:
  • Developed Complex BI reports using Sub reports, pulling the data from stored procedures and packages, writing complex commands.
  • Created Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
  • Generated company reports in tabular, matrix, chart and sub reports by implementing SQL Server Reporting Services.
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
  • Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
  • Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
  • Created several reports using SSRS like drill through reports, linked and sub reports.
  • Worked on SSRS Reports, Sub Reports, Data Drill-Down, and Data sorting/grouping.
  • Developed Reports with different styles using Table, Sub Reports and Matrix.
  • Created reports that call sub reports in SSRS.
  • Drill Down, Drill Through, Sub Reports, Charts.
  • Created Tabular reports, Cross Tab Reports, Matrix and Sub Reports and Parameterized reports using SSRS 2008 and 2012.
  • Created Standard Reports, Cross-tab Reports, Sub Reports and Drilldown Reports using Crystal Reports 2013 and Web Intelligence.
  • Developed Cascading, Parameterized and Sub reports using variables and expressions for the business users.
  • Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
  • Created tablix, charts and sub reports.
  • Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub Reports using Sql Server Reporting Services 2008.
  • Created datasets using stored procedures and reports using multi value parameters Created sub reports, bar charts and matrix reports.
  • Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

Show More

16. XML

demand arrow
average Demand
Here's how XML is used in SQL BI Developer jobs:
  • Created XML Package Configurations and configured event driven e-mail notification processes.
  • Experience in extracting the data from SQL Server and using XML and present it to the end user in XML format.
  • Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
  • Implemented SSIS packages to extract the data from XML to OLTP environment & Involved to do XML Configuration for SSIS packages.
  • Worked on XML parameters for inserting data into tables using for XML, OPEN XML.
  • Created package configuration in XML and used them to deploy packages into SQL server.
  • Created package configuration to pass the data through XML variable and parent package variable.
  • Involved in XML Development and XML File Parsing in SSIS and SSRS.
  • Created the package configurations using XML configuration file and Parent Package Variables.
  • Have worked with XML transformation and have good knowledge of XSLT.
  • Worked on loading XML files to database tables using SSIS package.
  • Created new XML tags in order to execute new business rules.
  • Resolve errors with XML, ASP.NET 3.0 import export applications.
  • Produced full technical documentation of all results via XML notation.
  • Experienced in working with XML document structures and hierarchical data.
  • Deployed the packages to production using XML package configuration.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.)
  • Used XML datatype extensively and performed XML DML operations on the given XML data.
  • Created XML configuration files (.dtsconfig files) to dynamically alter package properties.
  • Used XML nodes to spilt comma separated values.

Show More

17. DTS

demand arrow
average Demand
Here's how DTS is used in SQL BI Developer jobs:
  • Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, text files and Excel files.
  • Cleaned existing (SSIS/DTS) packages for loading into the claims, PPO existing source system databases.
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
  • Involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.
  • Provide DTS, ETL capability between Excel, access and MS SQL Service.
  • Created the SSIS /DTS packages and scheduled them using SQL Server agent.
  • Performed Documentation for all kinds of reports and DTS and SSIS packages.
  • Migrated DTS packages to SSIS packages and modified those packages.
  • Managed Up gradation of DTS packages to SSIS packages.
  • Created DTS packages for the data cleansing/transfer and transformation.
  • Migrated the data from SQL 2000 to 2008 & involved to work with migrate DTS packages to SSIS.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
  • Handled migrations from DTS to SSIS 2005 and 2005 to 2008.
  • Migrated DTSX packages from SQL Server 2008 to SQL Server 2012.
  • Designed and architected the mechanism using SSIS/DTS to data load from the legacy claim systems DB2 to SQL server mitigation databases.
  • Created DTS Packages using ActiveX Scripts to upload Data from Text files Responsible for design and Normalization of the database tables.
  • Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Used DTS to transfer files from Excel datasheets to SQL server database.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data.

Show More

18. MDX

demand arrow
average Demand
Here's how MDX is used in SQL BI Developer jobs:
  • Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
  • Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).
  • Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
  • Build MDX queries and data mining expression (DMX) queries for Analysis Services and Reporting Services.
  • Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
  • Created basic Time series MDX functions and MDX queries to support the business requirement.
  • Implemented the complex query techniques of Passing Multi-Valued Parameters and cascading parameters in MDX.
  • Worked on creating calculated measures that fits business logic, using MDX queries.
  • Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
  • Involved in writing MDX queries and performance optimization of the SSAS cubes.
  • Involved in building reports from Analysis Service Cube using MDX Query Designer.
  • Involved in writing MDX query/expressions to create name sets and calculated members.
  • Used MDX expression to create named sets and calculated member in SSAS.
  • Created reports by retrieving the data from cube using MDX reports.
  • Designed MDX queries to retrieve data from SSAS cubes.
  • Created reports from cubes by writing MDX queries.
  • Created Calculated Measures using MDX Querying.
  • Defined MDX Scripts for querying the data from MOLAP cubes (SSAS) and build reports on top of cubes.
  • Involved in writing MDX Scripts for the OLAP CUBES.
  • Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.

Show More

19. Oltp

demand arrow
average Demand
Here's how Oltp is used in SQL BI Developer jobs:
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
  • Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2008.
  • Used appropriate data conversion tasks to convert data between different data types while transforming data from OLTP to downstream database.
  • Created ETL process from the OLTP database to the Data Warehouse and loading Data Marts to support several reports.
  • Involved in developing for ODS in order increase the performance and reduce the network traffic on OLTP server.
  • Designed and developed SSIS package for loading data from OLTP to ODS and finally to Data Warehouse.
  • Involved in designing the ETL process to pull and populate data from OLTP sources to the database.
  • Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
  • Involved in writing complex SSIS Packages to Load Data into both OLTP and OLAP systems.
  • Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
  • Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Created roles and managed user permissions on the OLTP server.
  • Designed the data model and created an OLTP database.
  • Configured and maintained huge OLTP databases.
  • Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL Server Agent.
  • Implemented checksums as incremental load technique to fetch incremental data from OLTP systems to populate OLAP data structures.
  • Generated reports using SQL Server Reporting Services [ ] from OLTP and OLAP data sources.
  • Created Indexes and proper re-indexing for intensive OLTP system to ensure best performance.

Show More

20. Column

demand arrow
average Demand
Here's how Column is used in SQL BI Developer jobs:
  • Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data.
  • Used SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data.
  • Created views/indexed views consisting of computed columns to facilitate easy user interface.
  • Converted data types using Derived Column, Data Conversion Transformation.
  • Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Experience on column alignment while writing the T-SQL queries and performing some analysis for those written queries.
  • Created indexes on selective columns for the fast retrieval of data in SQL Server Management Studio.
  • Identified all data fields and database columns that needed to be expanded to meet HIPAA requirements.
  • Identify columns for Primary Keys in all the tables at the design time and create them.
  • Involved to work with very basic SQL Server encryption level setting on database & column level.
  • Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
  • Created many calculated columns and measures using DAX in Power BI based on report requirements.
  • Used Bar Charts and Column Charts extensively as Pictorial Representation was needed for several Reports.
  • Created the derived columns from the present columns for the given requirements.
  • Created SSIS Packages using Derived Columns, etc.
  • Applied various transformations like Data Conversion, Multicast, Conditional Split, Derived column in SSIS.
  • Used data transformations like aggregate, sort, Multicasting, Conditional Split, Derived Column etc.
  • Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions etc.
  • Developed packages using lookup, aggregator, Derived Column, Sort and Conditional Split transformations.
  • pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).

Show More

21. C # .NET

demand arrow
average Demand

22. Constraints

demand arrow
average Demand
Here's how Constraints is used in SQL BI Developer jobs:
  • Constructed several Normalized database tables with different constraints to maintain integrity.
  • Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
  • Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
  • Created databases and schema objects including tables, indexes and applied constraints, and written functions, stored procedures and triggers.
  • Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
  • Created and modified tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
  • Created Constraints, Written and executed T-SQL queries like Stored Procedures and Triggers using SQL Server Management Studio.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
  • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
  • Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
  • Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference.
  • Created Database, Tables, Triggers, Unique Constraints, Cluster Index, Stored Procedures.
  • Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Created Stored Procedures, Indexes, Constraints and User Defined Functions.
  • Create Views, Constraints and Triggers to implement business rules.
  • Created Indexes, Constraints and Rules on database objects.
  • Created check constraints to maintain data integrity.
  • Developed complex TSQL queries for stored procedures, CTEs, views, triggers, constraints, UDFs and derived tables.

Show More

23. Fuzzy Lookup

demand arrow
average Demand
Here's how Fuzzy Lookup is used in SQL BI Developer jobs:
  • Created prototypes DTSX packages to show the functionality of FUZZY LOOKUP and Merge Table tasks to the clients using SSIS.
  • Worked on different transformation like OLE DB Command, aggregate, sort, merge, merge join, fuzzy lookup etc.
  • Utilized multiple transformations such as merge, merge join, union, union all, fuzzy lookup and fuzzy grouping.
  • Worked extensively on bad data with configuring the error output, Conditional split, derived column, fuzzy lookup transformation.
  • Experience in using different transformations like fuzzy lookup, derived column transformations etc in SSIS packages.
  • Developed SSIS Packages using fuzzy lookup transformation, file system task, for each loop container.
  • Cleansed and loaded data by implementing data quality services, fuzzy lookup and SQL stored procedures.
  • Created packages for different procedures like Conditional split, data conversion Fuzzy lookup and Aggregate.
  • Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc.
  • Created packages to cleanse data with fuzzy lookups/groupings, derived columns, and condition splits.
  • Worked on data cleansing techniques using look ups, conditional split and fuzzy lookup.
  • Used multiple transformations including Fuzzy lookups and Fuzzy grouping in the data cleansing process.
  • Developed SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
  • Created SSIS packages to remove bad data utilizing derived column, lookups, fuzzy lookups, and conditional split.
  • Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Lookups, Aggregations, and Multicasting.
  • Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
  • Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
  • Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
  • Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy Lookups, Lookups.
  • Used various Transformations in SSIS Dataflow, Control Flow using Containers and Fuzzy Lookups etc.

Show More

24. Ad-Hoc

demand arrow
average Demand
Here's how Ad-Hoc is used in SQL BI Developer jobs:
  • Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
  • Designed ad-hoc reports using Report Model and configured using Report Manager.
  • Developed ad-hoc reports using Report Builder.
  • Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2012/2008.
  • Developed Power Pivot Reports in Excel by publishing them to SharePoint for providing ad-hoc reports according to client need.
  • Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Involved in managing Reporting Server and creating ad-hoc reports from OLTP and data warehouse.
  • Created, published standard and ad-hoc reports using report designer and report builder.
  • Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
  • Developed Ad-hoc reports and modified them by using SSRS and MS Report Builder.
  • Create various reports (ad-hoc, Tableau, drill-through, crystal).
  • Configured Report Model for developing ad-hoc reports by the end-users.
  • Produced ad-hoc queries and developed reports to support business needs.
  • Created Linked reports, Ad-hoc reports based on the requirement.
  • Developed Ad-hoc reports using Tableau Desktop, Excel.
  • Create and deliver daily ad-hoc report.
  • Created ad-hoc reports using power BI.
  • Create SSIS packages, SSRS and ad-hoc reports.
  • Created parameterized reports and ad-hoc reports using Report builder.

Show More

25. Wizard

demand arrow
average Demand
Here's how Wizard is used in SQL BI Developer jobs:
  • Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
  • Configured SSIS packages using Package configuration wizard to allow package run on different environments.
  • Transferred data between various flat file connections and SQL Server database using SSIS, BCP, and the Import Export wizard.
  • Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server.
  • Upgraded SSIS packages for an entire Application from 2005 to 2008 using Project wizard and successfully deployed packages.
  • Worked with SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
  • Performed data transfers between various servers using BCP, DTS and SSIS and Import/Export Wizard.
  • Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
  • Involved in using SSIS tools like Import and Export Wizard for developing the packages.
  • Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
  • Worked with import export wizard to Import and export Data to and from SSMS.
  • Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
  • Designed DTS package, with DTS Import/Export wizard for transferring data.
  • Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis Services 2005.
  • Involved in tuning SQL Server Databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
  • Used SQL Server Profiler and Database Tuning Wizard for Performance tuning and query optimization.
  • Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
  • Conducted and monitored database management by using SQL Profiler, Database Engine Tuning Advisor and Index Tuning Wizard.

Show More

26. Sharepoint

demand arrow
average Demand
Here's how Sharepoint is used in SQL BI Developer jobs:
  • Maintained oversight of version control of documents within the SharePoint repository.
  • Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Deployed SSRS reports to SharePoint Server 2010 and configured SQL Server 2008 R2 Reporting Services to SharePoint Integration mode.
  • Involved in configuring SQL Server 2012 Reporting Services integration with SharePoint Server 2010 farmed installation.
  • Build and maintain SSIS packages, which take data from SharePoint list and other sources.
  • Deployed SSRS reports to SharePoint Server for the end users to look at them.
  • Created variety of reports from SSAS cubes and deployed on to SharePoint 2010.
  • Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Created pivot tables in Excel Services/PowerPivot 2010 integrated with SharePoint 2010.
  • Deployed SSRS report to SharePoint and Report Server Web Service.
  • Involved in deployment of SSRS reports on the SharePoint Portal.
  • Installed & configured SQL Reporting services Add-in for SharePoint 2010.
  • Customized the look and feel of sites in SharePoint 2010.
  • Created the documentation and upload and published them in SharePoint.
  • Developed Dashboard reports and implement them to MS SharePoint.
  • Integrated reports from SSRS with SharePoint 2010.
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, and Multi Valued Parameters and deployed on SharePoint 2010.
  • Embedded Tableau views in to SharePoint Analyzed the source data and handled efficiently by modifying the data types.
  • Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.

Show More

27. Management Studio

demand arrow
average Demand
Here's how Management Studio is used in SQL BI Developer jobs:
  • Scheduled package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
  • Implemented the calculations to aggregate physical measures using management studio.
  • Created and monitored SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio.
  • Worked on SSRS to generate hierarchical reports and drill down reports and tested using Management Studio in SQL server 2005.
  • Organized Training sessions for existing SAS Enterprise guide users to how to use SQL Server Management Studio using Query Editor.
  • Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
  • Performed daily tasks including backup and restore from disaster recovery in SQL Server 2008/2008R2 using SQL Server Management Studio.
  • Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
  • Project Description: Use SQL Server Management Studio, SSIS, SSRS and SSAS on a daily basis.
  • Scheduled and Monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
  • Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
  • Scheduled the ETL Package (Monthly) Using SQL Server 2005 Management Studio.
  • Worked on SQL Server Management Studio for Database Creation, Operations and Maintenance.
  • Created automated backup of OLAP cubes as well utilizing SQL server management studio.
  • Deployed and scheduled packages using SQL Server Agent Job in Management Studio.
  • Modified data on Azure SQL database through SQL Server Management studio.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Used SQL Server Management Studio for developing database objects.
  • Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
  • Administered SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.

Show More

28. Text

demand arrow
average Demand
Here's how Text is used in SQL BI Developer jobs:
  • Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
  • Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
  • Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data.
  • Involved in creating packages for extracting and loading data from text file to SQL Server Database.
  • Created Contexts and Aliases to resolve Loops, chasm and fan traps in Universes.
  • Resolved loops, chasm and fan traps using contexts, aliases and integrity checks.
  • Worked on import & export of data from Text to SQL Server in SSIS.
  • Created SSIS packages to Export data from text file to SQL Server Database.
  • Created SSIS Packages to integrate data coming from Text files and Excel files.
  • Experience using TEXTPAD to compare and synchronize all database objects, ETL Packages.
  • Created multiple universes and resolved Loops by creating table aliases and contexts.
  • Defined Aliases and Contexts to resolve loops in the universes.
  • Used Text Files/ SQL Server Logging for all SSIS packages.
  • Used SSIS to transform data into SQL database via FTP from Text files, MS Excel as source.
  • Designed and developed the Universes as per the report requirements Created Contexts and Aliases to resolve Loops and traps in Universes.
  • Performed ETL/ Informatica using SSIS by extracting data from OLTP data sources such as Excel, Access, and Text files.
  • Used BCP utility to publish table output to text files..
  • Designed SSIS Packages to transfer data from various sources like Text Files, SQLServer, Excel and Access to SQLServer.

Show More

29. KPI

demand arrow
average Demand
Here's how KPI is used in SQL BI Developer jobs:
  • Create standard reports using SQL Server Reporting Services (SSRS) for day to day analysis of KPI's.
  • Developed a star Schema cube in SSAS to provide reporting abilities with Various KPI's derived from Production data.
  • Experience in constructing cubes dimensions, DSV's, fact tables, aggregations, KPI's, Perspectives etc.
  • Deployed cubes from fact and dimensions with Aggregations, KPI, Measures, hierarchies, and attributes.
  • Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
  • Customized KPI's through writing MDX to analyze company's performance and making appropriate business decisions.
  • Created cubes from relational data warehouses and created KPI's for the front end team.
  • Created cube objects like KPI's, Perspectives and Calculated Members for better analysis.
  • Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.
  • Involved in adding KPI's, Calculated Aggregates, Actions and Partitions.
  • Defined KPI's, Actions and Calculations in SSAS using MDX.
  • Create Charts and Matrix and KPI Indicators for various Business Unit.
  • Created KPI Objects in line with Requirement Docs in SSAS.
  • Worked on KPI's and actions.
  • Created KPIs and Aggregations in the Cube and deployed them on SSRS to create reports.
  • Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
  • Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
  • Created custom Power BI Dashboards supporting multiple business KPIs.
  • Design and develop drilldown, drill through, parameterized reports and charts using SSRS as well as KPI's and gauges.
  • Created, managed and utilized KPIs' properties to determine business performance.

Show More

30. TFS

demand arrow
low Demand
Here's how TFS is used in SQL BI Developer jobs:
  • Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
  • Maintained the Version, Labeled Versions and Backups of the source using Team Foundation server (TFS).
  • Worked on Team Foundation Server (TFS) to synchronize the data with different-2 sources as well.
  • Used TFS (Team Foundation Server) for all the source code maintenance among the whole team.
  • Worked on database project in TFS (Team Foundation Server) for version control and deployment.
  • Used Team Foundation Server (TFS) for version control, source control and reporting.
  • Used MS Team Foundation Server (TFS) 2010 to organize the process of project.
  • Used Team Foundation Server (TFS) to keep Database Objects under Source Control.
  • Consolidated all Team Projects into from TFS 2008 to TFS 2010 Project Collections.
  • Involved in using TFS to check in and check out SSRS reports.
  • Utilized TFS and SharePoint for deployment and source control and version control.
  • Implemented SQL scripts to TFS source control to track version history.
  • Used TFS to report bugs and to maintain product backlog items.
  • Managed development changes for the BI solution with TFS.
  • Experience with Team Foundation Server (TFS).
  • Used TFS for storing code and packages.
  • Worked with TFS - source control.
  • Worked on Team Foundation Server (TFS) to coordinate with the development team on the deliverables as Version Control.
  • Used Team Foundation Server (TFS) for central repository as a versioning control.
  • Even if the local system crashes down we can able to use the code from TFS.

Show More

31. Dashboards

demand arrow
low Demand
Here's how Dashboards is used in SQL BI Developer jobs:
  • Experience designing visual report solutions, including dashboards using SSRS and/or other data visualization/dashboard tools.
  • Designed and deployed reports and BI Dashboards utilizing PerformancePoint Services/Dashboard Designer.
  • Involved in building PerformancePoint Dashboards and PowerPivot Gallery in SharePoint 2010.
  • Created visualization dashboards for online reports helping clients identify opportunities.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
  • Designed dashboards, scorecards, API's against OLAP cubes in Power Pivot and Power View of SharePoint 2013.
  • Created visualization dashboards for more than a dozen online reports helping clients identify opportunities to sell more advertising.
  • Captured business requirements and translate them into design documents that lead to the delivery of reports and dashboards.
  • Created Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Developed Dashboards, Charts in order to view the pipeline metrics using SSRS and Power view.
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Used Performance Point Server to create reports, scorecards and dashboards.
  • Developed SSIS packages procedures to provide the data required for dashboards.
  • Created dashboards for Sales, Inventory, Performance and finance.
  • Published dashboards on an intranet site using SharePoint Server.
  • Developed dashboards using Excel Power Pivot.
  • Designed Dashboards with all kinds of charts (Bar/Line charts, Heat maps, Area charts).
  • Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Show More

32. Development Studio

demand arrow
low Demand
Here's how Development Studio is used in SQL BI Developer jobs:
  • Utilize Microsoft business Intelligence Development Studio to develop SSIS packages for data integration and migration.
  • Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server.
  • Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.
  • Used SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data.
  • Designed and developed packages using Business intelligence Development Studio (BIDS) and Visual studio 2010, and 2012.
  • Developed SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes.
  • Migrated data from transfer database objects and Created SSRS reports in Business Intelligence Development Studio (BIDS).
  • Created and modified the existing SSRS reports based on T-SQL using Business Intelligence Development studio (BIDS).
  • Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Reviewed & Tested packages, fixing bugs (if any) using SQL 2008R2/2012 Business Intelligence Development Studio.
  • Used 2012 Business Intelligence Development Studio (BIDS) to create, edit, and deploy packages.
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
  • Created cubes using SQL Server BI Development Studio with Star schema.
  • Involved in developing Cubes in Business Intelligence Development Studio using SSAS Experience in writing DMX queries and statements.
  • Created Shared Data Source, Shared Dataset and reports using SSRS Business Intelligence Development Studio.
  • Specialized In analyzing and creating MOLAP and ROLAP data marts.. Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Show More

33. R2

demand arrow
low Demand
Here's how R2 is used in SQL BI Developer jobs:
  • Used various report items like tables, sub report and charts to develop the reports in SSRS 2008R2.
  • Implemented complex conceptual database design and database architect into SQL Server 2005/2008R2 using various constraints and triggers.
  • Extracted data from different sources like Oracle and MySQL using SSIS and loaded data to SQLServer2012 databases.
  • Created package and configuration file with SQL 2008R2 to support SSIS package deployments into each environment.
  • Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2008R2/2012/2014/2016.
  • Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008R2 OLAP databases.
  • Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008R2.
  • Configured Oracle SQL 10g/11g/11gR2 database parameter files to adjust memory usage and file size.
  • Worked on up gradation of Database from SQL Server 2008R2 to 2012.
  • Involved in Database Migration from SQL Server 2008R2 to SQL Server 2008.
  • Managed the complete migration of SQL Server 2008R2 to SQL Server 2012.
  • Installed SQL Server 2008R2/2012/2014/2016 manually and by using HP Server Automation tool.
  • Installed and Configured SQL server 2008 R2/2012 on Development and production server.
  • Developed incremental loading using MERGE statement in SQL server 2008R2.
  • Created SQL Server Analysis Project using MS SSAS 2008r2.
  • Upgraded database servers from SQL Server 2005 to SQL Server 2008R2 and 2008 R2 to 2012.
  • Deployed 2008 R2 Reporting Services (SSRS) RDL files to Reports server.
  • Involved in migrating SQL Server 2005 to 2008 R2.
  • Created ad-hoc reports using SQL server 2008 R2 Reporting Services (SSRS).
  • Build SSIS packages for data migration; and merge / Transactional replication to new SQL 2008 R2 Entity data structures.

Show More

34. Asp.Net

demand arrow
low Demand
Here's how Asp.Net is used in SQL BI Developer jobs:
  • Designed shopping cart functionality using Asp.net Profile.
  • Developed Win Forms using VB.NET, Web Forms using ASP.NET, Code Behind using C# and Mail server using ASP.NET.
  • Created ASP.NET web forms and Class libraries containing code for business and data access logic using C#.NET.
  • Created web applications using ASP.NET platform that supports the integration of SSRS reports for display within web portals.
  • Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
  • Assisted in designing and creating website for the system using ASP.NET, HTML, and CSS.
  • Developed web pages for embedding deployed SSRS reports using ASP.NET.
  • Developed GUI front end using web forms in ASP.NET.
  • Integrated SSRS Reports with ASP.net Pages.
  • Worked with ASP.NET, ADO.NET, C#.NET and SQL Server for developing applications.
  • Analyze, develop and test new systems using MVC 3 with C#/ASP.NET.
  • Created ASP.NET page with C# to bind SSRS reports.
  • Assisted in development and documentation of several ASP.NET based applications.
  • Developed custom Web parts using ASP.Net, to get the input from employees and for managers to give their feedback.
  • Experience in creating ASP.Net User Controls and Components to reduce the complexity of user interface design.
  • Implemented the object oriented programming concepts in C#, Web Forms and ASP.Net.
  • Implemented Client and Server side validations using JavaScript and ASP.Net validation controls.
  • Developed many asp.net web applications using SQL Server and C#, to provide solutions for companywide needs.
  • Created various Web forms for user login, account summary, applications and history pages using ASP.Net.
  • Designed and implemented parameterized and cascading parameterized reports using SSRS Developed ASP.NET user controls.

Show More

35. Data Source

demand arrow
low Demand
Here's how Data Source is used in SQL BI Developer jobs:
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.)
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
  • Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
  • Experience in developing SSAS Cubes, Dimensions and data source views and Deploying & Processing SSAS objects.
  • Created dashboard using multiple data sources and Custom Hierarchies to meet the Business requirement in Tableau.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Designed data source views (DSV) and report models for business users using SSRS.
  • Created and executed SSIS packages to populate data from the various data sources.
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Identified the data source and defined them to build the data source views.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Created Linked Servers to connect OLE DB data sources and providers.
  • Created SSIS packages to transfer data across heterogeneous data sources.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Involved in Data Source, data transformation, data storage, retrieval, analytical and presentation layer of business intelligence solution.
  • Created data sources, connection strings and defined the datasets for generating the report.
  • Implemented reporting packages involved drilldown, graphs, sub reports, shared data sources, and parameterized reports.

Show More

36. CSV

demand arrow
low Demand
Here's how CSV is used in SQL BI Developer jobs:
  • Design and developed SSIS packages to extract data from different source files like Excel, Access file, CSV, etc.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Worked on Bulk Copy Program to import the data from various CSV files into the tables in local servers.
  • Export and import data from Flat file, CSV file, Excel to/from SQL Server Database using SSIS.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
  • Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Exported data from SQL server 2008 tables to CSV files using SSIS packages.
  • Developed SSIS packages to load the data in to the tables from Text files, Excel files and CSV file.
  • Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
  • Extracted data from SQL server, ORACLE, Excel, CSV files and FLAT files.
  • Used MS Excel, CSV files as data source and copied data to the target.
  • Published reports in PDF, Excel, CSV formats.
  • Implemented SSIS (ETL) to extract and transform data from Teradata, Oracle, Flat files/CSV and Excel Files.
  • Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports.
  • Worked with Excel files, Flat files, csv files with SSIS to Import and Export the data into SQLSERVER 2008R2.
  • Used SSIS package to load data from different platforms such as CSV,XML,Flat file, and Excel.
  • Developed SAS macros for Data cleaning, Data mining and reporting (MS Excel, *.csv) Performed UAT testing.
  • Export a data from SQL to Csv file using PowerShell export csv cmdlet as an alternative methodology for SSIS

Show More

37. Business Logic

demand arrow
low Demand
Here's how Business Logic is used in SQL BI Developer jobs:
  • Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
  • Converted complex business logic into SQL stored procedures and user-defined functions.
  • Maintained referential integrity and implemented complex business logic.
  • Developed the reports using SQL Server Reporting Services (SSRS) based on the business logic by implementing efficient stored procedures.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes.
  • Created Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
  • Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
  • Worked with T-SQL to create tables, stored procedures, triggers and user defined functions for complex business logic.
  • Developed Advance SSIS packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
  • Applied and developed business logic and data cleaning in staging server to maintain child and parent relationship.
  • Worked with Stored Procedures, User Defined Functions, Views, SQL Scripting for complex business logic.
  • Created Stored Procedure to implement business logic in loading the data and implementing constraints.
  • Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
  • Created Sub reports called from the main report to implement the business logic.
  • Involved in writing classes for business logic layer using C#.
  • Transformed the complex business logic and calculations into coding.
  • Used cast, convert, Round and Len function to implement the business logic.
  • Created T-SQL scripts using common table expression to apply business logics.
  • Generated and documented several complex stored procedures that perform ETL business logic and support front end .NET applications.

Show More

38. Complex Queries

demand arrow
low Demand
Here's how Complex Queries is used in SQL BI Developer jobs:
  • Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
  • Experience with distributed transactions building linked servers, complex queries, error handling using SAVEPOINT in OLTP transactions.
  • Created numerous simple to complex queries involving self joins, correlated sub queries for diverse business requirements.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • Analyzed complex queries and tune the same to optimize application and system performance.
  • Tested the data with complex queries, joins, sub-queries in temp tables.
  • Experience in using Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Developed complex queries, packages, reports required to represent data as required.
  • Simplified complex queries using temporary tables, table variables and stored procedures.
  • Tested the data with complex queries, joins and sub queries.
  • Create and Execute the Stored Procedures and Complex Queries for Reports.
  • Created multiple complex queries for the profiling and auditing purposes.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Designed various cubes using MDX complex queries in SSAS.
  • Created complex queries involving Sub-queries and Joins.
  • Used complex queries, Joins, Views.
  • Identified the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handled them by implementing better Query Execution plans.
  • Created multiple MDX query, views and complex queries against cubes to develop multi-functionality using SSRS.
  • Developed Complex Queries in T-SQL, Stored Procedures, and Views with best Execution plan.

Show More

1 Complex Queries Jobs

No jobs at selected location

39. Dimension Tables

demand arrow
low Demand
Here's how Dimension Tables is used in SQL BI Developer jobs:
  • Developed partition dimension tables and execute as parallel approach.
  • Created dimension tables, measures, hierarchies, levels, CUBES and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Designed, processed and deployed the Cubes from the different fact and dimension tables based on the business requirement using SSAS.
  • Created cubes using respective fact and dimension tables, performed processing and deployed the cubes to SQL server analysis services database.
  • Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
  • Used Slowly Changing Dimensions (SCD) in SSIS packages to move incremental data in dimension tables.
  • Implemented Type II slowly changing dimension to maintain current information and history information in dimension tables.
  • Involved in building a strategy for star schema, snowflake schema with fact and dimension tables.
  • Created derived columns on the final fact and dimension tables as per the business requirements.
  • Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
  • Defined Dimension Models based on existing fact & dimension tables in Relational Data Warehouse.
  • Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
  • Identified the fact and dimension tables from the SQL server based on the requirements.
  • Build efficient SSIS Packages for processing Fact and Dimension tables with complex transforms.
  • Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
  • Implemented SSAS cubes, facts and dimension tables to perform analysis.
  • Worked on Star and Snow-Flakes Schema for Fact and Dimension tables.
  • Created star schema, dimension tables and fact tables.
  • Identified fact and dimension tables in the Cube.
  • Created multiple dimension Tables and created hierarches and relationships for the attributes based on requirements.

Show More

40. Data Analysis

demand arrow
low Demand
Here's how Data Analysis is used in SQL BI Developer jobs:
  • Developed user defined financial reports to provide on demand financial data analysis using SSRS.
  • Perform data analysis and develop data mapping and functional solution design documents.
  • Performed data analysis to generate various trend reports.
  • Write MDX queries to quickly retrieve data from SSAS tabular cube for data analysis and build audits to check data discrepancy.
  • Created calculations using the Data Analysis expressions (DAX), worked with Partitions that helped in updating really large tables.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
  • Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.
  • Involved in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Designed & developed ETL procedures, data mappings involving data analysis, data validations and data migrations.
  • Worked on data analysis to understand data requirements and make sure data is secured for transactions.
  • Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
  • Designed Report Templates, Bar Graphs and Pie Charts in Crystal Reports for data analysis.
  • Used pivot and power pivot for various data analysis needs and data quality checks.
  • Used Excel Pivot tables to manipulate data in order to perform data analysis.
  • Developed SSAS Cubes to solve business problems and made data analysis easy.
  • Carried out detailed study of business, data analysis and configuring the materials management module to user specification.
  • Performed Data Analysis of the Weblog data and automated the process using store procedures and design new SSIS packages.
  • Developed data Analysis tools using C#.Net for implementing quality patterns.
  • Produce SQL needed indices for data analysis purposes.

Show More

1 Data Analysis Jobs

No jobs at selected location

41. Windows Execution Plan

demand arrow
low Demand

42. DB2

demand arrow
low Demand
Here's how DB2 is used in SQL BI Developer jobs:
  • Developed SQL scripts, ensured optimal performance of the queries to generate reports from various relational databases like Oracle, DB2.
  • Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
  • Worked with SSIS for transferring and reviewing data from heterogeneous sources like Flat file, Excel, CSV and DB2.
  • Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like DB2 to SQL Server.
  • Developed packages and procedures to get data from DB2, X12 and FCR and load into SQL Server DB.
  • Migrated data from heterogeneous sources like Excel, DB2, Oracle and Main Frame to SQL Server 2008 R2.
  • Installed and configured IBM DB2 ODBC drivers to connect and get source data from DB2 servers.
  • Created ETL packages using Heterogeneous data sources (DB2, ORACLE and Flat Files etc.)
  • Worked in creating DB2 queries to fetch data from DB2 sources using Quest Toad software.
  • Imported data from different sources like oracle, DB2 to SQL Server using SSIS.
  • Created the Data Migration strategy for migrating the data from the DB2 legacy database.
  • Source data was extracted from Flat files, SQL Server and DB2 Database.
  • Used queries ran in DB2 environment as source in SSIS packages.
  • Created SSIS packages to migrate data from DB2 to SQL Server.
  • Extract data from various sources like DB2, ORACLE and Flat files as part of ETL process using SSIS.
  • Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2008.
  • Integrated SQL Server, Oracle, DB2, and MySQL data.
  • Created various ETL Packages to load data from transactional system DB2 to staging (ODS) and staging to Enterprise Data-warehouse.
  • Handled Tableau admin activities granting access, managing extracts and Installations Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
  • Managed SQL Server security, Snapshot Replication from DB2, logins, roles and users.

Show More

43. Drill-Through

demand arrow
low Demand
Here's how Drill-Through is used in SQL BI Developer jobs:
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
  • Created cross-tab, drill-down, drill-through, linked reports and sub-reports with both SSRS and Tableau.
  • Created linked reports, sub reports as well as drill-through reports in support of management.
  • Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL.
  • Worked on creating multiple SSRS reports in Drill-through mode and Cross Tab Reports
  • Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
  • Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill-through Report Models and Drill-down Reports.
  • Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
  • Developed Parameterized, Drill-down, Drill-through, Sub Reports, Charts, Matrix reports, Linked reports in SSRS.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
  • Created Parameterized reports, Cross-Tab reports, Drill down, Drill-through reports using SSRS.
  • Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2008.
  • Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
  • Used SSRS to create Sub-reports, drill-down, drill-through and parameterized reports.
  • Designed and deployed Drill-Down, Drill-Through and Drop-Down features and Parameterized reports.
  • Created Tablix Reports, Matrix Reports, Parameterized Reports, Drill-through, Drill-down and Sub Reports using SQL Server Reporting Services.
  • Developed various operational Drill-through and Drill-down reports using SSRS Refactoring existing SP's, Views & Functions.
  • Developed ad-hoc, parameterized, drill-down, and drill-through reports with parameters in SSRS.

Show More

44. Ssms

demand arrow
low Demand
Here's how Ssms is used in SQL BI Developer jobs:
  • Created stored procedures, triggers, user-defined functions, views for handling business logic and functionality of various modules using SSMS.
  • Migrated 50+ DTS packages using DTS editor wizard into SSMS Legacy folder, validated and tested all packages on development server.
  • Created and manage SSISDB Catalog using SSMS to deploy SSIS projects and configured it with various environments as per business process.
  • Created SSISDB catalog with SQL 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
  • Used various plugins via SSMS to access data from Azure SQL server * Created Tables, Cluster/Non-Cluster Index and Constraints.
  • Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
  • Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
  • Created stored procedures, triggers, user-defined functions, views for handling business logic with SSMS.
  • Worked on setting up connection string and connecting SQL Azure databases from local installed SSMS.
  • Deployed SSIS packages to Integration ServicesCatalog in SSMS.
  • Created packages using SSIS, SSMS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
  • Used to run the jobs by Active Batch, which it is more advanced to run the jobs in SSMS.
  • Created SSIS packages to build STG, ODS and DMT databases in SQL SSMS 2012.
  • Created SSIS packages to load data to Staging and Datamart tables in SQL SSMS 2012.
  • Worked on SSRS to generate drill-down, drill-through, parameterized and ad-hoc reports.Environment: SSMS, SQL SERVER

Show More

45. Fact Tables

demand arrow
low Demand
Here's how Fact Tables is used in SQL BI Developer jobs:
  • Identified the dimension, fact tables and designed the data warehouse using star schema and created complex reports using IREPORTS tool.
  • Developed the data warehouse to design the business process data representation, dimensions and fact tables using SQL Analysis services.
  • Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
  • Created Measures from fact table and also Named Queries and Named Calculations for multiple dimension and fact tables in SSAS.
  • Developed T-SQL Scripts and SSIS packages for loading the Data Warehouse Dimension and Fact tables on a daily basis.
  • Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business.
  • Developed Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
  • Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
  • Developed SSIS package to load data into dimensions and fact tables using slowly changing dimension.
  • Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
  • Implemented data warehouse design principles and best practices for maintaining dimension and fact tables.
  • Involved in loading data into Dimensions and Fact tables on MS Azure platform.
  • Used the calculated members in the fact tables to improve efficiency.
  • Partitioned the data of larger fact tables to improve the performance.
  • Analyzed the requirements and selected the appropriate fact tables/created fact tables.
  • Defined Referenced relationships with the measure groups and fact tables.
  • Created dimensions and fact tables based on the business requirement.
  • Work in creating dimension/Fact tables using SCD1 and SCD2.
  • Used SSIS for building Dim and Fact tables.
  • Managed upgradation of DTS packages to SSIS packages and filling Dimension and Fact tables into Data Warehouse and Data Marts.

Show More

46. Different Types

demand arrow
low Demand
Here's how Different Types is used in SQL BI Developer jobs:
  • Implemented ETL automation for downloading, loading them in to SQL and uploading different types of files from and To FTP.
  • Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
  • Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
  • Connected to different types of sources to extract data and destinations to load the data using Connection manager.
  • Implemented different types of reports for sales & marketing team to increase the revenue of the website.
  • Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
  • Developed SSIS packages using different types of containers to optimize the performance of the packages.
  • Build different types of chart reports using SSRS like column chart and Pie charts.
  • Generated different types of SSRS reports using Visual Studio as per the requirements.
  • Utilized SSRS reporting services to generate different types of reports from the database.
  • Created different types of User-defined functions and Stored procedures using T-SQL.
  • Implemented different types of constraints on tables.
  • Generated different types of reports for project manager to analyze the data, such as drill-down, cascading parameterized reports etc.
  • Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
  • Created different types of reports like drill down reports, drill through reports, sub-reports, and parameterized reports.
  • Created SSIS Packages to load data from Oracle to SQL Server Created different types of User-defined functions.
  • Developed different types of ad-hoc reports using Report Model and Report Builder tools of SQLServer2008 R2Reporting Services.
  • Created data conversion package which converts columns to different types and adds columns to datasets.
  • Created different types of reports which involve more number of groupings and multi-value parameters.
  • Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.

Show More

47. DDL

demand arrow
low Demand
Here's how DDL is used in SQL BI Developer jobs:
  • Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
  • Develop Stored Procedures, User Defined Functions, Non-DDL Scripts and Views based on the functional requirements to support the application.
  • Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
  • Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
  • Developed database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Worked with web logic as a middle ware interface in order to interact with different applications.
  • Developed physical data models using ERWIN/ VISIO and created DDL scripts for database schema and objects.
  • Developed and optimized database structures, stored procedures, DDL trigger and user- defined functions.
  • Designed and implemented Stored Procedures and Triggers (DDL & DML) for automating tasks.
  • Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
  • Use DDL and DML for writing triggers, stored procedures and data manipulation.
  • Used various SSIS transformations for loading the data into the Middle Office tables.
  • Created User defined Functions, Stored Procedures and Triggers using DML and DDL.
  • Created DDL scripts to create database schema and database objects.
  • Imported data from COSMOS streams to SQL using SANGAM jobs and DDL method.
  • Worked on DDL and DML operations on MS SQL Server 2000.
  • Worked with T-SQL, DDL, DML and DCL.
  • Created DDL/DML triggers in SQL Server 2008/2005.
  • Designed Data Mapping documents, DDL scripts, and Data Dictionary and Meta data of the models and maintained them.

Show More

48. Visual Source Safe

demand arrow
low Demand
Here's how Visual Source Safe is used in SQL BI Developer jobs:
  • Used Visual Source Safe on regular basis for version controlling of SSIS packages as well as various T-SQL objects.
  • Used Visual Source Safe (VSS) to keep all the Database Objects under Source Control.
  • Reviewed all code prior to production and moved team from Visual Source Safe to Subversion.
  • Used Ms Visual Source Safe to handle version history of the files in database.
  • Modified the current stored procedures using Visual Source Safe to meet current design.
  • Experience on Version Control System like Microsoft Visual Source Safe and MKS.
  • Used Visual Source safe for repository and maintaining versions.
  • Experience with working in Microsoft Visual Source safe.
  • Used Visual Source Safe as Version Control Tool.
  • Implemented Version Control with Visual Source Safe.
  • Experience in migration of parts from Visual source safe (VSS) 2005 to Team foundation server (TFS) 2010.
  • Installed various software like MS SQL server 2008 R2, Aqua data, visual source safe.
  • Used Visual Source Safe (VSS) for version control.
  • Used Visual Source Safe to provide locking and sharing support for files to be shared among multi users.

Show More

49. Multiple Tables

demand arrow
low Demand
Here's how Multiple Tables is used in SQL BI Developer jobs:
  • Created Cursors, Stored procedures and Functions work together to calculate ratings & score based on different attributes from multiple tables.
  • Reviewed potential ETL Mapping tools for efficient mapping of dirty data and dispersed data across multiple tables and flat files.
  • Worked on writing the insert, update and delete quires joining multiple tables to make changes in the staging tables.
  • Experience in creating joins, correlated and non correlated sub-queries for complex business queries involving multiple tables in SQL 2008/2012.
  • Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Involved in creating stored procedures which load data from multiple tables to single table in data mart.
  • Created multiple temporary physical tables to get faster and efficient way data out of multiple tables.
  • Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
  • Worked on writing the queries, joining multiple tables to make changes in the tables.
  • Implemented script task for loading data into multiple tables from the single source file.
  • Implemented joins and sub-queries on complex queries with multiple tables from different databases.
  • Created triggers, stored procedures, complex joins and Sub-Queries involving multiple tables.
  • Implemented joins and sub-queries for complex queries involving multiple tables from multiple databases.
  • Extracted data from multiple tables with joins, sub-queries, set operators.
  • Used Joins, correlated and non-correlated sub-queries for queries involving multiple tables.
  • Created joins, sub queries for complex queries involving multiple tables, SP's for SSRS report and SSIS.
  • Created reports using SSRS from the cubes by connecting to SSAS Created joins and sub-queries for complex queries involving multiple tables.
  • Create joins and sub-queries for complex queries involving multiple tables Created User Defined Functions, Stored Procedures, and Triggers.
  • Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
  • Implemented multi-threading in SSIS using Parallel Loop Task in CozyRoc to load multiple tables and improve the process time.

Show More

50. User Acceptance

demand arrow
low Demand
Here's how User Acceptance is used in SQL BI Developer jobs:
  • Configured Snapshot replication for reporting, user acceptance test and development servers.
  • Assisted end users in user acceptance testing, by explain all the functionality of the data warehouse and its applications.
  • Support user acceptance testing by helping business user create testing cases and coordinate to run testing and evaluate testing results.
  • Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
  • Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.
  • Performed User acceptance testing (UAT) for assigned change requests, incidents and SSIS packages.
  • Performed Unit Testing and created test scenarios for User Acceptance Testing (UAT).
  • Developed user test cases and validated test results during user acceptance testing.
  • Performed Regression and User Acceptance testing to check the data accuracy.
  • Document User Training Manuals for the User Acceptance Testing.
  • Created test plan for User Acceptance Testing.
  • Performed Regression and user acceptance testing on Thoratec Connect portal and load the bugs in 'Rally' defect tracking system.
  • Make analysis and development plan accordingly Actively participated in User Acceptance Testing, and debugging of the system.
  • Participated in User Acceptance Testing for Reports and trained end users in ad hoc reporting.
  • Attended functional testing meetings, user acceptance sessions and worked on the feedbacks.
  • Perform Quality Checks for all deliverables Facilitate the System and User Acceptance testing for the developed components.

Show More

SQL BI Developer Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A SQL BI Developer

SQL

12.6%

Database

12.0%

Ssis

10.3%

Data Warehouse

9.6%

Ssrs

7.2%

T-Sql

5.6%

ETL

5.3%

Ssas

4.5%

Business Requirements

3.9%

Drill Down

3.7%

Windows XP

3.6%

Query Analyzer

3.2%

Olap

3.1%

Schema

2.5%

Sub Reports

2.4%

XML

2.3%

DTS

2.2%

MDX

2.2%

Oltp

2.1%

Column

1.9%
Show More

Typical Skill-Sets Required For A SQL BI Developer

Rank Skill
1 SQL 9.3%
2 Database 8.9%
3 Ssis 7.7%
4 Data Warehouse 7.1%
5 Ssrs 5.3%
6 T-Sql 4.2%
7 ETL 3.9%
8 Ssas 3.3%
9 Business Requirements 2.9%
10 Drill Down 2.7%
11 Windows XP 2.7%
12 Query Analyzer 2.4%
13 Olap 2.3%
14 Schema 1.8%
15 Sub Reports 1.8%
16 XML 1.7%
17 DTS 1.6%
18 MDX 1.6%
19 Oltp 1.6%
20 Column 1.4%
21 C # .NET 1.4%
22 Constraints 1.4%
23 Fuzzy Lookup 1.4%
24 Ad-Hoc 1.4%
25 Wizard 1.3%
26 Sharepoint 1.2%
27 Management Studio 1.2%
28 Text 1.1%
29 KPI 1.1%
30 TFS 1.1%
31 Dashboards 1.0%
32 Development Studio 1.0%
33 R2 0.9%
34 Asp.Net 0.8%
35 Data Source 0.8%
36 CSV 0.8%
37 Business Logic 0.8%
38 Complex Queries 0.7%
39 Dimension Tables 0.6%
40 Data Analysis 0.6%
41 Windows Execution Plan 0.6%
42 DB2 0.6%
43 Drill-Through 0.6%
44 Ssms 0.6%
45 Fact Tables 0.5%
46 Different Types 0.5%
47 DDL 0.5%
48 Visual Source Safe 0.5%
49 Multiple Tables 0.5%
50 User Acceptance 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

22,039 SQL BI Developer Jobs

Where do you want to work?

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