We provide IT Staff Augmentation Services!

Sql Bi Developer Resume Profile

Summary:

  • Over 7 Years of experience SQL Server BI Developer in Production, Development and Test Environment. Excellent experience in SQL Server Programming T-SQL , Integration services SSIS , Analysis Services, Notification Services and Reporting services SSRS in SQL 2005/2008 R2/2012.
  • Experience in Data Warehouse Development environment using Microsoft SSIS, SSAS and SSRS.
  • Expert in Creating Views, Complex Triggers, effective Functions and appropriate stored procedures to facilitate efficient data manipulation and data consistency.
  • Experience in writing SQL Loader scripts for Extract, Transformation and Loading of Data.
  • Experience in data Extraction, Transformation and Loading ETL processes. Worked extensively on data extraction, cleansing and data integration, and loading from different data sources using SSIS.
  • Very good experience in designing, development and deployment of SSIS packages.
  • Designed SSIS Packages to Extract, Transform and Load data into Database, Archive data file from different legacy systems using SSMS on SQL Server 2005/2008/2012 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
  • Experience in MS SQL Reporting Services SSRS . Generated tabular, matrix, drilldown, Drill through, summary Reports, sub reports, detailed reports, Parameterized and linked reports using SSRS.
  • Developed several ad-hoc reports for one time purpose according to the customer requirement.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Developed Cubes using SQL Analysis Services SSAS .
  • Familiarity in designing reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
  • Very good exposure to Data Modeling including Dimensional Data Modeling, Star Join Schema/Snowflake Modeling, FACT Dimensions tables, Physical Logical Data Modeling, Visio.
  • Experienced in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
  • Excellent Communication, Analytical skills and Interpersonal skills. Exceptional ability to learn new concepts.

Technical Skills:

MS SQL Server 2005/2008/2012, MS SQL Integration Services 2005/2008/2012, MS SQL Reporting Services 2005/2008/2012, MS SQL Server Analysis Services 2005/2008, C , Seagate, Crystal Reports, Ado.Net, Java, Oracle, C, C , C , ASP.Net, Oracle, Java, Visual Basic, HTML, Unix, Windows

Confidential

SQL Server BI Developer

Responsibilites:

  • Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
  • Enterprise reports using SQL Server Reporting Services SSRS and Excel pivot tables which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamic reports and other features of Reporting services. Built Drill Down, Drill through, linked and sub reports using SSRS
  • Created Stored Procedures, User Defined Functions for databases using T-SQL.
  • Developed complex T-SQL code for the application conversions.
  • Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
  • Worked with SSIS to import, export and transform the data between the linked servers.
  • Used the Report Manager to Create folder structures,modify data sources,Controlling access to Report Services resources.
  • Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services SSRS
  • Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
  • Developed Various Reports like Charts, Matrix, Tabular, and Cross Tab using SSRS.
  • Developed reports involved in Passing parameters and cascading parameters using SSRS
  • Built and Deployed reports on the server using SSRS Report Manager.
  • Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services.
  • Used Oracle, SQL, PL/SQL, T-SQL in test environment.

Environment: SQL Server, Management Studio, Integration Services, Reporting Services, SSRS, OLAP, PL/SQL, Oracle, Data Modeling, Analysis Services, T-SQL, Windows, ETL, SQL Server Agent, Data ware Housing.

Confidential

SQL BI Developer

Responsibilites:

  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results by using T-SQL.
  • Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
  • Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures.
  • Generated database monitering and data validation reports in SQL Server Reporting Service SSRS .
  • Designed and developed reports using SQL Server Reporting Services
  • Developed Stored Procedures and Views used to supply the Data to the Reports.
  • Developed different types of Tabular Reports, Matrix Reports Cross Tab or Pivot Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SSRS
  • Used Oracle, SQL, T-SQL and PL/SQL in test environment.
  • Configured, built, deployed different reports in PDF, Excel, TFI formats according to the business requirement using SQL Server 2012 Reporting Services.
  • Developed reports where the data extracted from SSAS cubes in SSRS.
  • Designing Cubes, Star Schema and Data models for Data Warehousing Applications
  • Built different types of chart reports using SSRS for the business requirement like Designed and deployed reports with Drill Down, Drill Through, Drop down menu options, Sub-reports in SSRS using BIDS.
  • Report parameters included single valued parameters, empid, mgrid that also consisted of different parameter types like hidden, internal, default queried and non queried parameters .
  • Created complex stored procedures to use as the datasets for the Report Design, to generate Ad hoc reports using SSRS
  • Developed Complex SSRS Reports involving Sub Reports Matrix/Tabular Reports, Charts and Graphs, Bar charts, Column charts and Pie charts

Environment: SQL Server, Management Studio, SQL, PL/SQL, Oracle 9i, ETL, Integration Services, Reporting Services, Analysis Services, SSRS, Data ware Housing, ETL, T-SQL, Windows

Confidential

SQL Server BI Developer

Responsibilites:

  • Generated database SQL scripts and deployed databases including installation and configuration.
  • Design and Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse.
  • Worked with SSIS to import, export and transform the data between the linked servers.
  • Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2008 R2.
  • Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures using T-SQL.
  • Worked on Stored Procedures and Database Triggers and business analytical functions.
  • Wrote various T-SQL stored procedures and Triggers to carry out various tasks
  • Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
  • Designed and implemented application using VB.Net, ASP.Net.
  • Troubleshooted, monitored, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
  • Used Microsoft Source Safe for version control and configuration management.

Environment: SQL Server, BIDS, SSMS, Windows, SQL Server Management Studio, T-SQL, SSIS

Confidential

SQL Server BI Developer

Responsibilites:

  • Analyze client requirements and translate them into technical requirements.
  • Created Stored Procedures, T-SQL, Triggers, Views and Functions for the database Application.
  • Created various Tabular, Cross-tab, Matrix and Ad-hoc reports using SSRS.
  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
  • Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
  • Developed data access queries/programs using SQL Query to run in production on a regular basis.
  • Created report snapshots to improve the performance of SSRS.
  • Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
  • Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like Access, Excel.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa
  • Defined the report layout and identified Datasets for the report generation. Built drill down reports, and also parameterized reports using SSRS.
  • Extensively used Report Builder and Report Manager in SSRS.

Environment: Windows NT, Windows 2003, SQL Server 2005/2000, ETL Tools, DTS, SSIS, SSRS, T-SQL, SQL Profiler, Visual Source Safe, MS SQL Reporting Services.

Confidential

SQL Developer

Responsibilities:

  • Actively participated in gathering of User Requirement and System Specification.
  • Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
  • Used MS access in test environment.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
  • Carried out a Developer's role on MS SQL Server 2000, MS Access Databases Stored Procedures and Views.
  • Involved in developing the SQL code for the application
  • Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
  • Created and automated regular Jobs such as Daily/Weekly Report Generations.
  • Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.
  • Managed and resolved design issues during development
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with database vendor license agreement

Controlling and monitoring user access to the database

Monitoring and optimizing the performance of the database

Environment: T-SQL, SQL Server 2000, MS ACCESS, SSMS, Oracle

Hire Now