- Featured in:
-
More BI Developer Resumes
Use these BI Developer samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Statistics Resume Samples
BI Developer Resume Samples
No results found
6-10 years of experience
Created custom complex data analytics in Tableau to identify trends within quality data and find new sources of revenue within customer data
- Trained over 100 end users across 10 departments on how to use created Tableau workbooks and interact with Tableau Server
- Managed a project moving monthly balanced scorecard and KPI metrics into Tableau, saving team 40 hours/month in workload
- Developed and manage 8 unique Tableau workbooks consisting of 30 dashboards and over 100 worksheets that are used by management and employees across multiple departments
- Currently managing the development of 5 new Tableau projects
- Consults Tableau developers weekly on best practices and problem solving
- Developed and released 8 databases within Quality and Central Business Functions that have been utilized by 100 employees
- Administered LEAN projects saving ~$200K in risk avoidance and ~$100K in productivity savings
0-5 years of experience
- Implemented Qlikview Publisher into existing Qlikview server environment. Developed PDF
- Contract developer responsible for dashboard development and support for dozens of dashboards delivered to 12 of Sopheon’s external fortune 500 clients.
- Project development for large Fortune 50 client has led to a 50% reduction in load script time
- Mentor and 3rd level support for team of new developers as they come up to speed on
0-5 years of experience
Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
- Successful and rapid conversion of Legacy BO XI 3.1 Reports to BI 4.1 SP3
- Design and Developed Multisource universes using IDT
- Enhanced report performances by tuning the derived tables and join structures
- Provided technical guidance and solutions to peer technical teams
- Lead and supervised offshore delivery
- Liaised with SAP Technical support for Product Defects and Bugs
- Created Dashboards for tracking live data which are highly optimized for faster runtime
0-5 years of experience
Worked on the data migration project, where all the functionality was moving to a new platform ‘Genesis’ from the older platform ‘Pegasis’.
- Created databases and schema objects including tables, indexes, stored procedures and functions as a part of the data migration initiative
- Built SSIS packages and scheduled jobs to migrate data from disparate sources into SQL server and vice versa
- Performed root cause analysis on failures. Resolve performance tuning related issues and queries
0-5 years of experience
Developing demos with complex capabilities and functionalities for the sales team to utilized as their presentation.
- Successfully developed front end web base dashboard with trending data, animated pipeline charts, and demographic charts with drill downs functions that displays a breakdown of Regional/States sales, utilizing data aggregation from SQL statements.
- Built ad hoc reports such as an analysis grid with the capability to drill down at a hierarchical level and functions as print and download.
- Wrote SQL queries to aggregate data such as profit margin, cost per sales, revenue per Sales.
- Development includes SQL, HTML, CSS.
0-5 years of experience
Developed and supported enterprise BI solutions, data visualization tools and data warehouse for company’s mortgage business.
- Utilized T-SQL to pull loan data from various databases and created various dashboards, scorecards and reports to support loan business decision making.
- Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS and Tableau.
- Created Stored Procedures, user-defined functions, views for handling business logic and functionality such as Email Alerts, Data Extracts build-in Excel.
- Built daily, weekly, monthly graphs and charts of loan data using R and Stored Procedures.
- Updated and tested current OLAP data cubes including Servicing cube, Loan Payment cube using SSAS and MDX.
- Involved in designing, developing and testing of the ETL strategy to populate the data from various source systems using SSIS.
0-5 years of experience
Taxpro application involves M-Type Development to develop complete custom application. In this tax pro applications, when all the M calculations are completed, reports are provided to business to review the configuration and calculations.
- Creation of analytic reports based on the design.
- Design and customization of Siebel answers, reports and dashboards.
- Using Siebel analytics administration tool to develop and enhance metadata to build business model and established relationships.
- Using advanced PL/SQL concepts to implement complex ETL logic.
- Performed pre and post implementation testing of dashboard, answers and validating repository
- Identified slow running reports and coordinated discussions between Siebel experts and development team for tracking down issues with slow running reports.
- Involved in bug fixing of RPD and ETL.
0-5 years of experience
[company name] provides website features and other Amazon products and services to clients all over the world. Our mission in Transaction Risk Management Services (TRMS) is to make Amazon.com the safest place to transact online. TRMS designs and builds the software systems, risk models and operational processes that minimize risk and maximize trust in Amazon.com. Our group are responsible for analyzing terabytes of data to identify specific instances of risk or broader risk trends and will implement algorithms to flag high risk transactions. Beside, we are also responsible for building a robust set of operational and business metrics and will utilize metrics to determine improvement opportunities.
- Created SSIS packages with which data from different resources were loaded daily in order to create and maintain a centralized data warehouse. Made the package dynamic so it fit the environment.
- Designed and implemented a snowflake -schema Data Warehouse in SQL Server based on the existing data warehouse & SCS auto operational database.
- Developed schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables.
- Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
- Managed and developed existing and new ETL processes for SQL Server reports. Refreshed staging tables with ETL. Scaled SSIS to make it work more reliable.
- Scheduled and monitored all maintenance activities of SQL Server 2000/2005 to meet business requirements activities including database consistency check, data backup & restore strategy, index defragmentation.
- Ran month end processes. Troubleshot issues in jobs, reports, SSIS packages and so on. Trained the business users to create Ad hoc reports of their own.
- Wrote enterprise reports and stored procedures upon requests. Designed report models to meet business requirements and allowed users to perform fast queries.
0-5 years of experience
Create databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
- Used SSIS to create ETL package to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
- Used ETL tools to implement the Slowly Changing Dimensional maintain Historical Data in Data warehouse.
- Designed Cubes with Star/Snowflake Schema using SQL Server Analysis Services 2012 (SSAS).
- Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, char and matrix report).
0-5 years of experience
Wrote, modified & deployed SSRS reports
- Created and modified SQL Stored Procedures.
- Performed business analysis and wrote sql scripts to analyze data and parse to Excel
- Creating Excel macros and VBA code to massage data in Excel as well as link to SPs in SQL
- Modified SSIS packages to facilitate loading and parsing of files in Music Royalties database
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
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
0-5 years of experience
- 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.
0-5 years of experience
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
0-5 years of experience
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.
0-5 years of experience
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.
0-5 years of experience
Initiated and led the development effort of relational database for chemical compound inventory
- Created database tables with various constraints including primary key, foreign key, etc.
- Loaded data from flat data files into SQL Server 2008 database tables using bcp, bulk insert, and table export/import, SSIS package
- Extracted data from SQL Server 2008 database tables into flat data files and Excel sheet.
- Power user of SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL.
- Generated variety of business reports using SQL queries, SSRS.
- Using hands-on experience, training sessions and materials to increase understanding of database design principles.
0-5 years of experience
- Developed and implemented SSRS reports with multi-parameter, chart, sub-reports, and interactive capability.
- Wrote and modified complex sql queries using table join, sub query and common table expression (CTE).
- Optimized queries using SQL profiler, execution plan and database engine tuning advisor.
- Maintained existing SSIS packages and SSRS reports.
- Designed ETL packages to migrate data from different data sources such as Oracle, flat files, and XML files into SQL server.
- Developed and modified complex stored procedures in supporting ETL processes in data warehousing environment.
- Used various SSIS tasks such as Condition Split, Derived Column, etc. to scrub, clean and validate data during staging before loading data into the data warehouse.
- Created and configured data source, data source view, cubes, dimensions, measures, partitions and KPI using SQL server Analysis Services (SSAS).
0-5 years of experience
Develop and support SSIS import scripts for ETL activities and Cube support.
- Communicated project status to all levels of organization and client through written, verbal communications
- Implemented BI Reporting Solution and supporting ETL process.
- Developed report tracking process for promoting of reports requested by department managers and senior management.
- Set-Up Development, test and production Cubes for use with Performance Point and Share Point report distribution.
- Retrofitted SSRS 2005 to new data driven 2008 process.
- Converted Crystal Reports to use SSRS processes.
0-5 years of experience
Developed SAP BI 7.0 (BW) InfoCubes, MultiProviders, and Process Chains
- Developed additional SAP BEX queries against the Multiproviders
- Created Web Intelligence 4.0 reports for portal use
- Created SAP Netweaver IViews and pages to display Web Intelligence and Crystal reports
- Played a role in the independent creation of MicroStrategy desktop reports for managers
- Oversaw Cognos report design for end users
0-5 years of experience
Designed, implemented, and supported Business Intelligence systems for Fleet Management Group.
- Design of dimensional modeling built from requirements to support data warehousing informational needs for Sales and Marketing Department.
- Develop multidimensional data marts and cube for financial analysis and reporting.
- Designing and develop reports, dashboards and other analytical delivery methods using Microsoft SQL Reporting Services 2008 R2.
- Data extraction and data manipulation using Microsoft SQL Integration Services.
- Create and optimizes objects in the database, e.g. Tables, Views, Store Procedures, Functions, etc.
- Coordinated unit and system testing with business users to ensure report and environment functionality.
0-5 years of experience
- Created data warehouse objects, such as dimension tables, views and stored
- Developed SSIS packages for the data migration and created SSRS reports.
- Implemented role-based access control model to secure the reporting system.
- Created database objects for the address quality project; developed a dynamic SSIS
- Wrote T-SQL queries and stored procedures for ad hoc reports for various applications.
0-5 years of experience
Used the Execute DTS 2008 package task to execute DTS packages.
- Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
- Designed a new schema for the Data Mart databases.
- Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
- Created MDX queries to extract data from the Data Mart.
0-5 years of experience
Imported data from various formats into a standard format using stored procedures and functions
- Produced files that are used in Direct Mailing projects
- Strategic planning and implementation of a manual process into an automated processing using SSIS
- Developed QC plans and reports for the Direct Mailing projects
- Database Developer
- DBA for multiple SQL 2005 & 2008 servers
- Assisted in Developing and Designing a Database Warehouse for one our marketing clients
Rate This Article
[BI Developer]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
