Business Intelligence Developer Resume Samples

Description :

1. QlikView, DB2 server and SQL server integrated custom application is used for analyzing and predicting the seasonal trends on client products.
2. Working with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming the data for loading into the pre-designed data warehouses.
3. Execution of the daily data publishing procedures from start to finish using the IWAY data migrator 7 and creating new ETL procedures for data extraction and transformation.
4. Importing data from various sources (flat file, excel, raw file & various databases) and exporting to various destinations using SSIS (2008).
5. Using the ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
6. Creating databases and schema objects including tables, indexes, and applied constraints.
7. Connecting various applications to the database and writing functions, stored procedures and triggers.
8. Extensively using the SSIS transformations such as lookup, derived column, data conversion, working on all activities related to the development, implementation, administration and support.

Experience

7-10 Years

Level

Senior

Education

MS

Description :

1. Building and maintaining the self-service BI applications that will inter-operate with data warehouses and other BI solutions.
2. Working collaboratively within and across development and project teams in a fast-paced work environment, utilizing agile BI design.
3. Experience in working with packages for data extraction and generating reports for business users.
4. Ensuring the architectural goals are met on all development projects and participating in activities of development lifecycle including estimation, coding, unit testing, deployment, and maintenance.
5. Participating in the development lifecycle activities, including estimation, coding, unit testing, deployment, and maintenance.
6. Working with the principal developers to design, develop and deliver an entire application, i.e., interface, ETL, extract and BI application.
7. Ensuring accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution.
8. Working on major projects with vendors, data validation project mainly for CMS audit, broker bonus.
9. Interacting with users and deliver the results up to their requirements.
10. Extensively involved in resolving the daily issues in the daily doc production environment.
11. Creating member universe for the purpose of Ad hoc reporting against the data marts.
12. Helping users in understanding web and run reports against the universe.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Performing database backup and recovery in support of business continually using RMAN.
2. Skilled in creating multiple shell scripts on Linux/Unix environments to run database related jobs.
3. Involving in the maintenance of Oracle high availability environment including data guard technology and RAC.
4. Working on large database architecture which involved partitioning, materialized views and other data warehousing processes.
5. Daily performance tuning and troubleshooting assignments, including AWR reports, and checking alert logs.
6. Managing the database performance and capacity planning, providing plans for increases and/or decreases, ensuring improvements are successfully implemented and making tuning adjustments as necessary.
7. Regular tasks include Oracle software installation, upgrade and patching along with meta link notifications.
8. Worked with the bi team to design and develop an automated ETL solution to load the data warehouse and process the cube.
9. Designed, developed and maintained universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.

Experience

5-7 Years

Level

Executive

Education

Diploma

Description :

1. Extensively involved in requirements gathering, writing ETL specifications and preparing design documents.
2. Analyzing and detecting the data quality issues and recommending the corrective courses of action.
3. Development of mappings based on given requirements and business rules to load data from desired source tables to target tables.
4. Worked for development, enhancement & supporting Edw which is on Teradata.
5. Worked with business analyst & data modelers in understanding the BRD - business requirement document, mapping document, and data model.
6. Working with Toad and Oracle developer to prepare Oracle queries to validate the data in both source and target databases.
7. Interacting with the business SMEs on requirement gathering, understanding the business and functional requirements.
8. Collaborating with the end users to identify technical requirements for the development project based on their business requirements.
9. Developing Informatica mappings, reusable transformations and created PL/SQL stored procedures/packages for extracting data from source systems to staging and processing and loading to the data warehouse.
10. Involving in enhancements and maintenance activities of the enterprise data warehouse.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Gathered and translated business requirements into technical solutions as reports, tableau dashboards, and scorecards.
2. Developed ETL packages for cleansing, data integration, transformation and incremental loads incremental loads in the data warehouse using Microsoft SSIS/SSRS.
3. Developed tableau dashboards, scorecards to track Jira team performance, agile planning dashboards for better project management and delivery using tableau desktop, managing tableau extract, and access permissions.
4. Performed dimensional data modeling using Kimball methodology to invoke new data sources in the data warehouse.
5. Developed derived fields in Tableau dashboard to explain data variation and trends to the non-technical audience.
6. Designed heat maps, story timeline, trend reports to analyze the capacity and find the data patterns using tableau.
7. Generated dashboards with calculated fields, filters, groups, parameters to handle views more efficiently in Tableau.
8. Responsible for maintaining SSIs ETL, Dev, QA, production data warehouse and BI reporting environments.
9. Optimized tableau dashboards for minimal load time, eliminate performance bottlenecks using best practices.
10. Developed complex statistical and forecasting reports using several R functions in Tableau workbooks.
11. Worked with the technical and functional teams to identify and correct data anomalies using data quality reports.

Experience

2-5 Years

Level

Junior

Education

Diploma

Description :

1. Collaborating with the stakeholder, architect and business analyst to outline business requirements in the JRD meetings.
2. Creating t-SQL scripts, which generated tables, relationships, based on the finalized er-diagram.
3. Designing stored procedures, CTE, UDFS, triggers to implement the business logic.
4. Implementing the temporary tables, indexes, execution plan, resolve parameter sniffing problem to optimize queries.
5. Designing the data mart utilizing bottom-up approach with star schema modeling.
6. Identifying the source, destination, staging area per ETL strategy and performed data cleansing and data profiling.
7. Designing the ETL mapping document per business requirement with help of FRD document.
8. Identifying and maintaining the SCD and role-playing dimension during the designing of the data mart.
9. Created SSIS packages for data loading utilizing various task and transformations within the SSIS.
10. Performed troubleshooting of SSIS packages utilizing error logs, checkpoints, breakpoints, and data viewers.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

1. Worked closely with teams to gather, analyze, and document business cases, functional and technical requirements, and processed the flow diagrams for new projects, enhancements to existing solutions and production issues reported by the end users.
2. Participated in the end to end implementation planning including project management, issue management, communication and change management.
3. Interpreted the business needs and technical requirements into an integrated solution, providing direction for system enhancements and defect fixes.
4. Managed UAT with end users including coordination and user acceptance signoff.
5. Managed the relationships with multiple teams for new solution features and technical support.
6. Created, delivered, and presented the end-user training materials to users throughout the organization.
7. Developed complex reports and dashboards and supported the existing reports using SQL Server Reporting Services (SSRS) and Power BI based on the end-user requirements.

Experience

10+ Years

Level

Consultant

Education

MS

Description :

1. Migrated existing packages from 2008 to 2016 environment. Configured database engine for SSISDB, deployed packages to projects in integration services catalogs, upgraded package script code, XML, and configurations.
2. Created, monitored and troubleshot SQL server agent jobs, utilizing integration dashboard.
3. Designed process to upload/download files from secure FTP server/site to internal file directories and database tables.
4. Created packages to transform flat file data using data conversions and derived columns for problematic database inserts.
5. Configured ssis logging and error handling, writing log entries to a table.
6. Created and executed powershell scripts from SQL server agent jobs to upload/download files to/from SFTP sites.
7. Developed SSRS reports displaying customer jobs, orders, invoices, inventory, and shipping information.

Experience

10+ Years

Level

Consultant

Education

BS

Description :

1. Assisting the client, a utility company, in gathering requirement for reporting and working on the development of transformation of data from the client's relational database to the data warehouse.
2. Interacting with the procurement and operation/maintenance business representatives for gathering the business objects reports/ dashboards requirements and to define business and functional specifications.
3. Creating a detailed report technical designs that also included sample report layouts. Creating ETL mapping sheets that included information regarding the source and target tables and the source to target join conditions as well as transformation rules. Based on the information in the ETL mapping sheets, created detailed ETL technical designs. All produced report and ETL designs were signed-off by the client with minimal to no re-work.
4. Extracted data from flat files and from Oracle database over database links, applied business logic to load them in the central Oracle database.
5. Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Sybase.
6. Implementing slowly changing dimensions to maintain current information and history information in dimension tables.
7. Working on different data sources such as Oracle, SQL server, flat files etc.
8. Created complex mappings in OWB designer using aggregate, expression, filter, and sequence generator, update strategy, union, lookup, joiner and stored procedure transformations.
9. Created process flows in UC4 to schedule OWB jobs and also created dependencies between the jobs.

Experience

10+ Years

Level

Management

Education

BS

Description :

1. Planning, defining and designing the data based on business requirement and providing documentation using Docxpress.
2. Creating SSIS package to load data from flat files, CSV files, and SQL server 2008r2 to SQL server 2012 by using lookup, fuzzy lookup, derived columns, condition split, term extraction, aggregate, pivot transformation, and slowly changing dimension.
3. Using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data mart databases.
4. Modifying the existing SSIS packages to meet the changes specified by the users.
5. Scheduling the jobs for executing the stored SSIS packages, which were developed to update the database on daily basis using SQL server agent.
6. Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
7. Scheduled report and exported in pdf format and excel format as desired by users.
8. Fine-tuned SQL queries for maximum efficiency and performance using SQL profiler and database engine tuning advisor.
9. Building the dashboards and performing the Ad hoc analyses with SSRS, Tableau and Power BI.
10. Designing and implementing the stored procedures and triggers for automating tasks.
11. Working in setup logging environment to track the status of the events like error raise, task fail.

Experience

5-7 Years

Level

Executive

Education

BS