Business Intelligence Developer Resume
Omaha, NE
SUMMARY
- 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.
TECHNICAL 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
PROFESSIONAL EXPERIENCE
Confidential, Omaha, NE
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, Omaha, Nebraska
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, Omaha, Nebraska
Business Intelligence Developer
Responsibilities:
- 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, Cincinnati, OH
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, Austin, TX
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.