We provide IT Staff Augmentation Services!

Sql Server Bi / Etl Developer Resume

Houston, TX

SUMMARY

  • Over 7 years of IT experience in Data Warehouse, RDBMS concepts as SQL Server database Developer and BI Developer.
  • Good at installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 and 2008 on Windows 2000/2003/2008 servers.
  • Strong experience in TSQL query, stored procedure programming.
  • Expert in creating Indexes, Views, complex Stored Procedures, and User defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
  • Hands on experience in data Extracting, Transforming, and Loading (ETL) from various sources to SQL Server such as raw file, XML file, Oracle, DB2, Excel sheets and Access database.
  • Excellent knowledge of using variables and expressions in packages.
  • In - depth knowledge of Transact-SQL (DDL, DML).
  • Good hands on experience with SQL Server 2008/2005/2000 , SSIS, SSRS, SSAS and T-SQL.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS).
  • Experience in working with larger volume of database.
  • Scheduled jobs and alerts using SQL Server Agent.
  • Experience in Performance Tuning and Query Optimization.
  • Monitored the database to identify and resolve the performance issues using SQL Server Profiler.
  • Implemented error handling and roll back process in ETL load.
  • Worked on ETL SSIS Development, Created packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.
  • Developed and deployed data transfer packages to the appropriate destinations using SSIS.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and process SSAS cubes to store data to OLAP databases.
  • Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008.
  • Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SQL Server Reporting Services (SSRS).
  • Experienced in SQL Server Analysis Services (SSAS) OLAP Cubes, Implemented Snow Flakes Schema and Star Schema and multidimensional databases.
  • Experience with all the phases of Software Development Life Cycle (SDLC) and Quality procedures while executing projects.
  • Experienced in creating schemas, maps, processes, Jars and Batch files using Pervasive Data Integrator.

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows Vista, Windows 2000/2003/2007

Programming Languages: C,T - SQL,PL SQL,VB.net

BI and ETL tools: Microsoft SQL SERVER 2008/2005/2000 Business Intelligent Development Studio (BIDS), Microsoft SQL SERVER 2005/2008 Integration Services Toolkit (SSIS), Microsoft SQL SERVER 2005/2008 Analysis Services (SSAS), Pervasive Data Integrator

Reporting Tools: Microsoft SQL SERVER 2005/2008 Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Crystal reports 10

Relational Databases: SQL SEVER 2008/2005/2000

Office and Other Tools: Microsoft WORD 2007/2010, Microsoft EXCEL 2007/2010, Microsoft POWER POINT 2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL Server BI / ETL Developer

Responsibilities:

  • Developed, modified, and optimized Stored Procedures, Tables, Views, and other statements to handle complex business rules.
  • Scheduled Daily, Weekly and Monthly jobs using SQL server agent to load the data into the tables as per their market requirements.
  • Developed the SQL Server Integration Services (SSIS) packages to load data from Oracle database to SQL database as well as created stored procedures used in SSIS to load/transform data to the database
  • Deployed Packages from Development to Production Server.
  • Used SQL server reporting services (SSRS) to create and customize various on-demand reports, ad-hoc reports and sub reports. Published the reports on the web server to be accessed by the case managers.
  • Developed KPI scorecards for managerial purpose.
  • Managing Reports using Security, standard and data driven subscriptions in Report Server using SSRS.
  • Populate reports into SharePoint portal site from SSRS.
  • Designed index, statistics, and optimized queries by using execution plan for performance tuning of the database.
  • Developed SQL Queries to fetch complex data from different tables using joins, database links and formatted the results into reports and kept logs.
  • Identified the Data Source and defined them to build the Data Source Views.
  • Loaded the data into excel files and developed excel pivots from the data loaded in that excel files.
  • Involved in testing, bug fixing and documentation for the project.

Confidential, Wilkes-Barre, PA

SQL Server BI / ETL Developer

Responsibilities:

  • Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
  • Responsible for Developing, Monitoring and Deploying SSIS packages.
  • Created SQL server configurations for SSIS packages and XML & Windows event logs.
  • Used various SQL Tasks and Dataflow Transformation in SSIS according to the requirements; scheduled the execution of SSIS packages by creating the job tasks.
  • Generated reports on Summary information, account information, client detail reports using adhoc reporting to be used by the clients and advisors.
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Created SSRS reports and deployed them to the Report Server.
  • Configured the report viewing security for various users at various levels using Report Manager.
  • Created Stored Procedures, triggers, UDF, views, tables and generated TSQL script for application
  • Created many complex Stored Procedure/Functions and used them in Reports directly to generate reports.
  • Scheduled, maintained, and supported the distribution and access to reports through SSRS.
  • Tested the reports and fixed bugs in Stored Procedures and Tables
  • Created Stored Procedures, Views and user defined functions to store the data of clients, advisors.
  • Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
  • Created letter files for the company use on a daily process.
  • Created schemas, maps, processes and jar files for internal purposes using Pervasive Data Integrator.

Environment: SQL Server 2008, SQL Server Management Studio(SSMS), Business Intelligence development Studio(BIDS), SSIS, SSAS, SSRS, Windows 2007, Pervasive Data integrator, Titanium.

Confidential, Broomfield, CO

SQL Server BI / ETL Developer

Responsibilities:

  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS.
  • Used Query Analyzer to optimize SQL Queries.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as created stored procedures used in SSIS to load/transform data to the database.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data
  • Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping.
  • Generated Reports from a wide range of data sources using SSRS.
  • Created many complex stored procedures / functions and used them in Reports directly to generate reports on the fly.

Environment: SQL Server 2008, SQL Server Management Studio(SSMS), Business Intelligence development Studio(BIDS), SSIS, SSAS, SSRS, Windows 2007.

Confidential, Beverly, MA

SQL/BI Developer

Responsibilities:

  • Involved in requirement gathering, analysis, design, development and deployment.
  • Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions, Triggers, and creating packages.
  • Worked extensively with debugging, defect tracking and troubleshooting issues.
  • Responsible for Import and export of data between the environments.
  • Developed various drill down, parameterized reports using SSRS 2008.
  • Deployed Packages from Development to Production Server.
  • Created materialized views, dimensions and stored outlines for optimal performance.
  • Worked on Side by Side migration of multiple SQL 2005 instances to SQL 2008.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
  • Created stored procedures for SQL Server Integration Services (SSIS) which are used in the report to customize the report data and to make data analysis efficient.
  • Transformed data from various data sources using OLEDB connection by creating various DTS packages.
  • Scheduled jobs and alerts using SQL Server Agent.
  • Monitored the database to identify and resolve the performance issues using SQL Server Profiler.

Environment: SQL Server 2008, SQL Server Management Studio(SSMS), Business Intelligence development Studio(BIDS), SSIS, SSAS, SSRS, Windows 2000/NT.

Confidential, Salt Lake City, UT

MS SQL Server BI / ETL Developer

Responsibilities:

  • Created stored procedures, views, indexes, Triggers and functions.
  • Created SSIS packages for transforming data.
  • Lead the development of automated SSIS packages to extract, transfer, load and convert data from existing data warehouse to reporting database server.
  • Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Developed and optimized SSIS Packages.
  • Converted, loaded and integrated data from Access, Excel, text/.csv files and internal database applications with data captured for security applications.
  • Developed multidimensional cubes using for business analysis using SSAS.
  • Successfully designed and implemented data mart, fact tables, dimension tables and defined attribute properties in cube using SSAS.
  • Extract data from multidimensional cube and designed parameterized reports using SQL Server Reporting Service.
  • Proficiently created drill down reports, linked reports, drill through reports and sub reports using SSRS.
  • Proficiently created and manage roles and security of reports and scheduled the Subscription of Reports using SSRS.
  • Worked and coordinated with developers in writing and tuning new stored procedures.
  • Worked on DTS packages to import the data from Oracle, Access and text files.
  • Set up backups for the newly created databases.
  • Scheduled transfer of backups and log files to different servers.
  • Provided a support for data issues and given appropriate solutions.
  • Created Reports using SSRS.
  • Created the documentation for SQL server and service packs installations.

Environment: MS SQL Server 2008, MS SQL Server Integration/Reporting Services 2008(SSIS/SSRS), Windows Server XP/NT/ 2003/2000, DTS, SSAS, Performance monitor, SQL Profiler

Confidential, SFO, CA

BI Developer

Responsibilities:

  • Created destinations for different types of loans from one standard database for loans using SSIS packages.
  • Extensively used SQL server reporting services to generate reports on a weekly basis for a particular loan type in given period.
  • Generated reports using SSRS as per business requirements.
  • Created report models for ad hoc reports when the end user wants to see the reports on fly.
  • Tested the reports and fixed bugs in Stored Procedures, Tables and Triggers.
  • Developed and edited many complex reports with SSRS.
  • Implemented conditional formatting in reports to get a list of customers who have improper payment history.
  • Scheduled and performed data transfers using SSIS including filtering appropriate to the data mart for data analysis
  • Created T-SQL queries, dynamic Stored Procedures that calculates the loan sanctioning details taking the customer details as input.
  • Implemented the calculations to aggregate physical measures using management studio.
  • Defined Referenced relationships with the measure groups and fact tables.
  • Calculated loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.
  • Migrated data from SQL server 2000 to SQL server 2005.
  • Established backup and recovery of SQL reporting services.

Environment: SQL Server 2005, T-SQL, SQL Server Management Studio(SSMS), Business Intelligence development Studio(BIDS), SSIS, SSAS, SSRS, Windows 2000/NT.

Confidential, Washington DC

SQL Developer

Responsibilities:

  • Used the SSIS to migrate Databases such as Oracle and Access database, flat files to centralized IT destination.
  • Responsible for Developing, Monitoring and Deploying SSIS packages.
  • Successfully created dynamic configuration packages in SSIS.
  • Used Event Handlers for Exception Handling in SSIS packages.
  • Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8 minutes.
  • Generated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.
  • Worked on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Created many complex Stored Procedure/Functions and used them in Reports directly to generate reports.
  • Scheduled, maintained, and supported the distribution and access to reports through SSRS.
  • Created Stored Procedures, Views and user defined functions to store the data of clients, advisors.
  • Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
  • Conducted performance tuning by using SQL Profiler and database engine tuning advisor. created the Data Source Views (DSV) in SSAS using underlying database views and identifying the relation between Fact and dimension tables

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Visual Studio 2005, MS Office, SQL Profiler, Windows 2000/2003.

Confidential

Database/BI Developer

Responsibilities:

  • Involved in Design of the database, created database objects, users, roles & managing database space.
  • Created a scheduling process which would extract data from the required tables into flat files and would purge the data
  • Into MS Access database which is used for various front end applications generating reports for business analysis & help in case study operations.
  • Implemented various data transfers into Excel Sheets using DTS packages for Sales & Marketing division.
  • Created Scripts, schemas.
  • Scheduled regular day-to-day backups & differential backups as per business requirements.
  • Closely worked with business analyst for capacity planning, storage & data archiving that would help in load balancing of the present OLTP database running on SQL Server 2000 on WinNT platform.
  • Developed stored procedures and triggers using T-SQL
  • Tuning MS SQL Server along with Operating System to obtain optimal performance.
  • Reverse Engineered the database (De-normalization) to get a new schema for report generation

Environment: MS SQL Server 2000, 2005, MS Server Integration services, DTS, MS Reporting Services, Visual Studio 6.0, SQL Profiler and Windows 2003.

Hire Now