Bi Developer Resume Examples - Page 2

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

BI Developers, or Business Intelligence Developers, aggregate data from multiple sources and design enterprise-level solutions for large, multidimensional databases. Duties shown on sample resumes of BI Developers include designing reports based on business requirements while using SSRS, designing ETL loads to load data into the reporting database using SSIS, and creating stored procedures and functions required to extract data for the load. In addition to five years or more experience in MS SQL Server and MS SQL analysis services, candidates should also be able to show a familiarity with MDX and expertise in T-SQL Programming and debugging on their resumes.

Find out what is the best resume for you in our Ultimate Resume Format Guide.

11

BI Developer

Report Writer

  • Responsible for leading development of project and worked in collabration with team and business users
  • Built SSIS package to extract the data from Oracle database and SFTP to remote server.
  • Experience in creating SSIS packages using different type's task, with Error Handling, Log particular event by doing logging and worked on package configuration.
  • Applied various data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split and Derived column.
  • Experience in deploying the SSIS packages to stage and production environments and creating SQL server agent jobs for scheduling
  • Developed and scheduled reports in Cognos 10.1 Report Studio.
Candidate Info
13
years in
workforce
2
years
at this job
12

SQL Server BI Developer

Designed and developed ER diagrams (Physical and Logical using ERwin data modeler) and mapping the data into database objects.

  • Created stored procedures, views, triggers and constrains to implement the database consistency and integrity.
  • Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
  • Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
  • Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.
  • Defined measure groups and further tuned dimensions attributes for a cube, created and deployed cubes to an instance of analysis services on the development server.
Candidate Info
2
years in
workforce
1
year
at this job
BS
Electronic Information Engineering
MS
Computer Engineering
13

BI Developer

Developed EHS Compliance Reports including: designing and writing technical specification also developing T-SQL stored procedures, ETL and SSRS reports, UAT and deployment.

  • Developed Energy Conservation System including: design, data model, ETL creation, Star Schema design, Cube Creation, Dimensional Hierarchies design, writing MDX calculations, writing SSRS and Performance Points reports and dashboards.
  • Supported Ops Capital System including: MDX calculations, Cube changes, ETL changes and more.
  • Utilized SQL Server 2008-R2, T-SQL, SSAS, SSRS, SSIS, Share Point, Performance Point, TFS, SVN, ER Studio, Agile, MDX
Candidate Info
24
years in
workforce
4
years
at this job
MS
Computer Science
14

Sr. BI Developer / Consultant

Generated Drill down, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration.

  • Transformed data from different data sources like Flat files and SQL databases to SQL Server 2012 using OLEDB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.
  • Worked on Microsoft Team Foundation Server (TFS) 2010.
  • Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
  • Implement the performance tuning of T-SQL queries by using SQL server profiler.
Candidate Info
33
years in
workforce
1
year
at this job
BA
Computer Applications
MA
Information Technology & Management
MA
Information Technology & Management
15

BI Developer

Created user reports in SSRS Report Builder 2.0 Making use of sub reports and procedures in SQL 2008 environment. Using one data source for multiple tablixs.

  • Monitor production cube and report processing detecting errors. Research data inconsistencies cases submitted by users.
  • Set up meetings and training sessions for follow employees as needed in the use of the Report Builder 2.0. Demonstrated uses of Report Builder 3.0 in TFS 2008
  • Creation and modification of dimension for cubes (multi-use dimensions) SSAS in BIDs. Testing and reviewing cubes in Excel using the pivot table option.
  • Running and trouble shooting SSIS packages in BIDs.
  • Performed analysis to gather information for a requirement document.
  • Development environment using Scrum method.
Candidate Info
23
years in
workforce
7
months
at this job
C
Certificate
BS
Bachelor of Science
16

BI Developer/analyst

Designed and maintained weekly and monthly statistics, reports and queries from raw data gathered through Oracle, SQL Server and MS Access database systems using Visual Basic, SQL and PL/SQL

  • Created Oracle Views, Tables and Queries
  • Created data model for RDBMS project
  • Presented weekly and monthly data analysis and statistics using MS Excel and MS Power Point
  • Designed and created multiple star schema databases
  • Data migration from Oracle to MS Access
  • Gathered requirements and created solutions for various RDBMS projects
Candidate Info
5
years in
workforce
4
months
at this job
AS
Associate of Science
17

BI Developer

  • Managed a team of five developers, provided guidance, performed yearly reviews, etc.
  • Developed/maintained the Business Objects universes for an Oracle 11g data warehouse populated from Oracle ERP/EBS system.
  • Used multiple contexts for Sales, Invoice, BOM and Purchase Order data.
  • Implemented row-level security for sensitive data at the universe level.
  • Trained users in Webi and Crystal report development, migrated universes through DEV, QA and PROD environments, and handled support calls.
  • Upgraded the environment from XIR3 to 4.0.
  • Developed Crystal and Webi, SSRS, SSAS reports and SQL Server database 2008/2012 administrator.
  • Started and maintained the metadata descriptions to help users understand the data.
Candidate Info
20
years in
workforce
3
years
at this job
BBA
Management Information Systems
18

Database/bi Developer

Designed and maintained ETL processes with MS SQL Server Integration Services 2012 (SSIS) using advanced data transformation and SSIS task scripting

  • Built Reports with MS SQL Server Reporting Services 2012 (SSRS) implementing tabular, matrix (crosstabs), bar and line charts, spark charts, and multi-tiered drilldowns as well as advanced formatting such as data driven color coding, visibility, and both fixed and movable headers.
  • Developed complex T-SQL queries and stored procedures for the purposes of moving and maintaining data and to run reports based on MS SQL Server 2012
  • Designed and developed advanced table partitioning and partition swapping systems for rapid maintenance of very large tables and to improve query performance on same
  • Modeled data in support of ETL processing and reporting systems
Candidate Info
15
years in
workforce
9
months
at this job
Computer Science
Geology
19

BI Developer

Identified the slow running query in database using SQL Profiler to capture the events and then do the analysis.

  • Solved T-SQL query performance issues by checking the execution plan and then rewriting the query or adding missing indexes.
  • Created SSIS/ETL packages for moving data from OLTP (Lab and Pharmacy) database to operational database (ODS) for reporting.
  • Created data mapping between source and target using different tools like data profiler, ERWIN and Excel sheet.
  • Created database tables with various data types, constrains (primary key, foreign key, unique, check, default, etc.) and indexes (clustered index and non-clustered index) in Oracle database.
  • Loaded data from flat data files into SQL Server 2008 database tables using bulk insert, and table import wizard methods.
  • Extracted data from SQL Server database tables and Oracle database tables into flat data files and Excel sheet.
  • Maintained and managed SSRS reports, configured standard and data driven subscription.
  • Created a variety of table report (matrix, drill-through, parameter, etc.) and dashboard using SSRS and Excel/Pivot Chart.
  • Designed and developed SSRS reports and deployed to report server.
  • Created data dictionary for database tables.
Candidate Info
6
years in
workforce
2
years
at this job
PhD
Analytical Chemistry
Chemistry
20

BI Developer

ETIPS -Electronic Timesheet and Invoice Processing System is a web based system to reduce the cost of processing timesheets and invoices by presenting clients with a single, 100% accurate consolidated weekly invoice. The system also provides clients with a wealth management information and delivers a previously unattainable level of transparency, visibility, control and compliance. This enables our clients to manage, control, forecast spend and manage non-permanent staffing requirements more effectively.

  • Created SSIS packages to extract data from multi formatted flat files, excel, xml files into UL database and DB2 billing systems.
  • Worked on the reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
  • Created parameterized reports, cross-tab reports, drill down reports and summary reports using SSRS.
  • Created report snapshots to improve the performance of SSRS.
  • Created T-SQL functions, cursors, views, indexes, stored procedures and triggers.
Candidate Info
4
years in
workforce
11
months
at this job

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!