Business Intelligence (BI) Resume

PROFESSIONAL SUMMARY:

Around 7+ years of experience in analyzing, designing and developing Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2008/2005/2000, SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2008/2005/2000 .
Excellent noledge in creating Databases, Tables, Stored Procedure, Views, User defined data types, Cursors and Indexes using T - SQL.
Extensive noledge in tuning T-SQL (DDL and DML) queries to improve teh database performance and availability.
Deployed database objects from development/testing environment to production environment wif ETL/Data Warehousing
Experience in Query Optimization and performance tuning of stored procedures, functions etc.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility and SSIS services.
Experience in creating SSIS packages to automate teh Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
Created many complex SSIS packages wif transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Conditional Split etc.
Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports using SSRS.
Ability to work wif team wif SQL Profiler and Query Analyzer to identify performance issues.
Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up teh SQL Server Performance.
Knowledge in query optimization & performance tuning using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
Expert in planning and scheduling backups and restoring databases.
Good noledge in Normalizing and De-normalizing teh tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
Expert in planning and scheduling backups and restoring databases.
Good understanding of ACID properties, RDBMS and Normalization /De-normalization.
Knowledge in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.

TECHNICAL SKILLS:

RDBMS/DBMS: : MS - SQL Server 2008/2005/2000, MS Access, MS Excel. Teradata

Programming Languages: : T-SQL, PL/SQL, C, C++, HTML, XML, Java

ETL Tools: : SQL Server Integration Services (SSIS), Data Transformation

Reporting Tools: Services (DTS), Data Warehousing, Informatica, Data Stage.

SQL Server Tools: : SQL Server Reporting Services (SSRS), Crystal Reports, Cognos SQL Server Management Studio (SSMS), Business Intelligence

Operating Systems: : Windows 98/2000/2003/ XP/NT/Vista

Data modeling Tools: Development Studio (BIDS), Query Analyzer.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship