BI Developer Resume Samples

Description :

1. Confidential is one of the most prestigious management consulting firms in the world.
2. The objective of the project was to develop a Data Integration and Analysis system to generate incentives for an international retail banking client based on the information from customer transactions.
3. Being a part of the reporting team our primary objective was to design and develop time and expense reports for the application using SSRS and present it in a clear and coherent manner to the senior management.
4. Played a key role in the design and developing the reports and in the performance tuning of the reports.
5. Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
6. Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
7. Created and administered all SQL Server databases, objects, logins, users, and permissions in each registered server.
8. Created SSIS Packages to integrate data from Text files and Excel files and File Transfer from one location to the other using FTP task.

Experience

0-2 Years

Level

Entry Level

Education

Diploma

Description :

1. Conducted Data Analysis and performed Data Modeling and Created the ER diagrams using Logical Schema.
2. Managed the BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools.
3. Designed, deployed, and maintained various SSRS Reports in SQL Server 2008.
4. Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
5. Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
6. Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
7. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
8. Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor Of Science

Description :

1. Collect, store, and retrieve business data for analysis and reporting Define the scope, use, and worked closely with Clients & Risk team to gather requirements for designing the data warehouse model.
2. Determine business and systems requirements and create reports Solve technical problems related to data and guide team members Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
3. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
4. Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Aggregate, Derived Column, and Data Conversion Transformations.
5. Created SQL Queries for maximum efficiency and performance.
6. Designed and implemented data warehouse architecture for corporate circulation data warehouse.
7. Purchasing, setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
8. Created Drill-down and Sub-Report using SSRS.

Experience

2-5 Years

Level

Executive

Education

Software Engineering

Description :

1. Gathered user requirements, analyzed and designed software solution based on the requirements.
2. Installed, configured, and deployed Tableau Server across all environments.
3. Maintained Tableau data extract refreshes using Scheduling and Tasks.
4. Administered user, user groups, and scheduled instances for reports in Tableau.
5. Collected data on various process measurements and formatted into graphs using Tableau software.
6. Designed and developed many complex reports based on the requirements using complex calculations like Row-level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines.
7. Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently Set up Tableau Desktop, Data Analysis and publishing reports.
8. Created dashboards in IPad mode where the C level executives can use the proposed solutions Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Experience

2-5 Years

Level

Executive

Education

Diploma

Description :

1. Responsible for creating the reports based on the requirements using SSRS 2008.
2. Created detailed reports for the customers by showing demographic information based on various parameters.
3. Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
4. Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
5. Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
6. Created custom data flow items for different SSIS packages using the VB.Net script.
7. Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
8. Worked on performance tuning of T-SQL queries and Stored Procedures.

Experience

5-7 Years

Level

Consultant

Education

Information Technology

Description :

1. This project was to maintain and optimize the database in the system, analyze and generate the report for operation.
2. Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
3. Extract Transform and Load (ETL) source data into respective target tables to build the required data marts Responsible to create T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
4. Involved in management and optimization of database using SQL Profiler, Index Tuning Wizard.
5. Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Server and used Analysis Services processing task to update the cube with current data.
6. Identified the dimensions, fact tables and designed the data warehouse using Star Schema.
7. Developed Multi-dimensional Objects (Cubes, Dimensions) using Dimensional modeling with dimension Hierarchies for several client side BI requirements.

Experience

2-5 Years

Level

Executive

Education

Diploma

Description :

1. Responsible for implementing, developing, maintaining, and troubleshooting integrations for internal and external products.
2. Designed and developed data integration and reporting solutions using SQL Server Integration Services, Reporting Services.
3. Performed code reviews, analyzed execution plans, and refactored inefficient code to create efficiencies and controls.
4. Improved code functionality for optimization, performance and accuracy.
5. Followed data standards, resolved data flow issues, completed unit testing and system documentation for ETL and reporting processes.
6. Collaborated with business owners to determine business requirements then transformed data flow processes into technical requirements documents.
7. Collaborated with testing groups to ensure efficient releases of projects and made sure database environments were sustainable.
8. Work incident and problem tickets to troubleshoot day-to-day technical issues and perform root cause analysis.

Experience

0-2 Years

Level

Entry Level

Education

Diploma

Description :

1. Involved in designing and optimizing various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQL Profiler.
2. Involved in analyzing business requirements that will facilitate the planning and the implementation phase of a data mart.
3. Actively involved in logical and physical design phase of creation of the Data Mart.
4. Created/Modified T-SQL batches, database scripts, indexes, stored procedures, views, tables, and triggers, table-valued and scalar functions in SQL Server.
5. Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
6. Used error handing techniques like Try Catch and error functions to create robust T-SQL code.
7. Designed and created Data Mapping Document (DMD) by analyzing various data sources and mapping it to the data mart schema.

Experience

2-5 Years

Level

Executive

Education

Computer Science

Description :

1. Responsible for installation and Configuration of SQL Server 2008 database and configuration of Report manager.
2. Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008 Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
3. Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
4. Developed, deployed, and monitored SSIS Packages.
5. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
6. Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
7. Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Experience

0-2 Years

Level

Entry Level

Education

Communication

Description :

1. Used SSIS Packages for Moving Oracle data sources to SQL Server.
2. Developed several mappings to load data from multiple sources to data warehouse.
3. Worked with SSIS package event handlers, property expressions Responsible to tune ETL procedures and schemas to optimize load and query Performance.
4. Experience in generating on-demand and scheduled reports for business analysis or management Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
5. Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
6. Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
7. Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
8. Involved in designing Parameterized Reports and also cascaded Parameterized Reports.

Experience

7-10 Years

Level

Consultant

Education

Communication Engineering

Description :

1. Involved in the Data warehouse design and development, analyzed several approaches for creating facts and dimensions and building the Data warehouse application.
2. Worked with Business Analysts to gather Customer requirements.
3. Involved in all phases of Software Development Life Cycle (SDLC): Requirements gathering and Analysis, Design, Implementation, Testing & Deployment.
4. Created and published packages in Cognos Framework Manager.
5. Developed and Implemented new BI reports using Cognos Report studio, Query Studio and Analysis Studio as per the business requirements.
6. Created several Cross tab Reports, List Reports, Chart Reports and also complex reports including Drill-Down and Drill-Through Reports in Cognos.
7. Developed Stored Procedures and Triggers in PL/SQL.
8. Designed, Developed and Deployed several SSRS reports in Business Intelligence Development Studio.

Experience

2-5 Years

Level

Junior

Education

Masters In Computer Science

Description :

1. Oversee the performance of Design to develop technical solutions from Analysis documents.
2. Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
3. Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
4. Deep experience with the design and development of Tableau visualization solutions.
5. Background in installing and upgrading of Tableau server and server performance tuning for optimization.
6. Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
7. Preparing Dashboards using calculations, parameters in Tableau.
8. Creating calculated fields, groups, sets and hierarchies etc.

Experience

5-7 Years

Level

Executive

Education

Computer Science