We provide IT Staff Augmentation Services!

Business Intelligence Developer Resume

Omaha, NE

Summary of Experience:

  • 7+ years of experience as a BI Developer of MS SQL Server suite of products like SSRS and SSIS of MS SQL Server 2008 R 2/2008/2005.
  • Hands on experience in Data Analysis using SQL (2008, SSRS, SSIS), PL/SQL in Client/Server and Web applications.
  • Experience with Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS).
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, SQL Joins, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
  • Expert in designing reports, generating on-demand and scheduled reports for Business Analysis or Management decisions using SQL Server Reporting Services (SSRS).
  • Created, designed and deployed Tabular, Matrix, Chart, Drill-down, Drill through and Ad-Hoc reports on report server
  • Good knowledge of logical and physical data models.
  • Experience in Data Analysis including analysis of root cause for Incident and Problem Management.
  • Experience in Reporting including System reporting through data transmission, validation and release, and manual reporting in MS Excel and MS Access database.
  • Functional expertise in Crystal Reports and Microsoft Visio.
  • Have a thorough knowledge of software development life cycle (SDLC).
  • Have a good understanding of the system flows, the architecture of the systems, how to design new systems and ensure that new systems can be supported long term.
  • Proficient in Microsoft Office applications Word, Power Point, Advanced Excel (including Pivot Tables) and Access skills, MS Project.
  • Experienced in environments requiring direct customer interaction during design specification, development, and product implementation phases. Great learning skills to adapt the rapid changing technologies and implementing the same at work.
  • Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.

Summary of Skills:

Databases

SQL Server 2008/2005/2000/7.0 , Oracle 9i/8.x, DB2 MS Access

Languages

SQL, T-SQL, PL/SQL.,C#, C, C++, VB 6.0,Perl,CSS, HTML, XML, MHTML

Reporting Tools

SQL Server Reporting Service (SSRS), Actuate BIRT, Maximo, Crystal Reports XI/10/9

ETL Tools

SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software

MS Office- 2007/2003/2000 , Adobe Professional, Team Foundation Server, SharePoint2012

Operating Systems

Windows / 98/2000/2003/ XP/Vista, Unix.

Database Tools

SQL Query Analyzer, ERWIN, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS), Source gear Vault

Methodologies

Logical and Physical Database Design, UML, Database Design and Normalization

Experience:

Confidential

Role: Business Intelligence Developer

Responsibilities:

  • Gathered requirements to understand the specifications of the client’s needs.
  • Created various database objects such as tables, indexes and views based on the requirement.
  • Wrote complex stored procedures, queries, triggers and implemented constraints on tables.
  • Designed new SSIS packages and deployed them.
  • Used various SSIS tasks such as Conditional Split, Derived Column, and Data validation checks during staging, and before loading the data into Data warehouse.
  • Used ETL to implement slowly changing transformation to maintain historical data in Data warehouse.
  • Used SQL Agent Jobs for scheduling SSIS package, SSRS reports and alerts.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Developed, deployed and monitored SSIS Packages.
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
  • Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
  • Configured and maintained Report Manager and Report Server for SSIS.
  • Developed reports using SSRS and published as PDF, Excel, and CSV formats.
  • Generated Drill down, Drill through, Ad-hoc, Matrix Reports, and parameterized reports using SSRS.

Environment: MS SQL Server 2008 R2, SSIS, SSRS,SQL Server Management Studio, SQL Server Business Intelligence studio, SQL Profiler, VB 6, MS Excel 2010, Windows Server 2008/2005

Confidential

Role: Business Intelligence Developer

Responsibilities:

  • Gathered requirements to understand the specifications of the project.
  • Involved in identifying various data sources, design and develop data models (logical/physical) based on the requirements.
  • Worked extensively in writing and debugging stored procedures, triggers, Inner Joins, Outer Joins, views and User-defined functions.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server Databases and Flat Files.
  • Used different Transformations in SSIS as per design specifications.
  • Applied various data transformations like Aggregate, Sort, Conditional Split, Derived column in SSIS.
  • Implemented Event Handler and Error Handling in SSIS packages.
  • Created SQL Agent Jobs for scheduling SSIS package, SSRS reports and alerts.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: MS SQL Server 2008 R2, SSIS, SSRS, SQL Server Business Intelligence studio, SQL Profiler, MS Excel 2007, Windows Server 2008/2005.

Confidential

Role: Business Intelligence Developer

  • Work with different levels of management in performing research, based on the objectives of the required analysis report.
  • Developed database for required analysis report using MS Excel, MS Access, MySQL Programs.
  • Perform data compiling, mining and analysis required to evaluate the accuracy of the given data using different software.
  • Used Query, SQL and ERWin to validate the accuracy of data.
  • Gather required information from the business owners and prepare analysis reports based on their requirements.
  • Analyze and develop analysis reports for the business process development using Crystal Reports.
  • Follow processes and procedures to modify analysis reports and make proper evaluations.
  • Manually review and validate data to ensure the quality, validity and accuracy of the data’s.
  • Maintain the research database, update and upgrade on a timely manner to ensure the safe storage of data.
  • Created daily, weekly, monthly and yearly reports on the transactional data.
  • Created various temporary tables to analyze and fact finding of the data.
  • Created MS-Excel Charts and Pivot tables on the resultant data set.
  • Consulting with clients (Business analysts) to meet reporting needs for their specification.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Created customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: MSSQL Server 2008, SSRS, Crystal Reports 8 ,VB 8, ERWin, MS Excel, MS Access, Windows Server 2008/2005.

Confidential

Role: Business Intelligence Developer

Responsibilities:

  • Gathered requirements and reviewed peer code and documentation.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Resolved performance related issues to Blocking, Deadlocks and long running queries.
  • Created and Modified T-SQL Stored Procedures, Triggers for validating the integrity.
  • Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Deployed and scheduled report subscription using SSRS to generate daily, weekly, monthly and quarterly reports including current status.
  • Created report models and configured the report builder for building Ad-hoc reports.

Environment: MSSQL Server 2008/2005, SSIS, SSRS, SQL Server Management Studio, SQL Server Business Intelligence studio, SQL Profiler, Windows Server 2008/2005.

Confidential

Role: Business Intelligence Developer

Responsibilities:

  • Experience in SQL joins, sub queries.
  • Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
  • Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages.
  • Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
  • As per requirements developed the reports in the form of Matrix, Table using SSRS.
  • Developed parameterized reports including multi-parameters, Sub reports, and Navigation reports.
  • Developed Cubes using SQL Analysis Services (SSAS).
  • Extending OLAP Cubes, Dimensions and data source views.
  • Involved in creation of named calculation the MDX queries.
  • Involved in writing T-SQL stored procedures, Functions, and complex joins.
  • Providing support and fixing issues related to Data on Reports, Dashboards etc.

Environment: MSSQL Server 2005, SSIS, SSRS, SSAS, MDX, SQL Server Management Studio, SQL Server Business Intelligence studio, Windows XP/Windows Server 2003

Hire Now