We provide IT Staff Augmentation Services!

Sql Bi Engineer Resume

East Rutherford, NJ

SUMMARY:

  • Over 7+ years of experience in analysis, design, implementation & administration of business intelligence solutions with Microsoft SQL server 2012/2008/2005 in development, testing & production environment of complete software development life cycle (SDLC)
  • Experience in coding, testing, deployment, support and maintenance of business applications using MS - SQL Server 2005/2008/R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
  • Expertise in T-SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key
  • Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables
  • Expertise in T-SQL (DDL, DML) documentation, coding, programming, query optimization, performance tuning and implementation of Business Intelligence solutions using SQL Server
  • Experience in creating various types of reports like Tabular report, Matrix report, Drill-Down/Drill through report, Cascaded parameterized, Chart reports, Sub reports, Ad-Hoc Reports, Cross Tab Reports and Distributed Reports in multiple formats using SSRS
  • Experience in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning
  • Excellent command over design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation like Lookup, Fuzzy Lookup, Script Component, Derived Column, Conditional Split, Union All, Merge Join, Multicast, OLE DB
  • Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)
  • Experience in design and scheduling integration packages using SSIS
  • Working Knowledge in Database Administration activities - Installation, Configuration, User Management, Backup and Recovery
  • Excellent communication and strong analytical skills. Ability to work independently or part of a team to accomplish critical business objectives

KEYWORDS:

SDLC (Development Cycle)

SSMS (Management Studio)

DDL/DML

Triggers / Functions

Views

Stored Procedures

Constraints/Joins

UDF

Normalization

Indexes

SSRS (Reporting Services)

Drill Down

Drill Through

Chart/Pie

Cascading

Parameterized

Cross Tab

Tabular

SSIS (Integration Services)

Lookup

Derived Column

Conditional Split

Union All

Merge Join

SSAS (Analytical Services)

Cubes

MDX

Relationships

Dashboard

ROLAP

HOLAP

NETEZZA

DDL/DML

Views

Stored Procedures

TECHNICAL SKILLS:

SQL Server 2012/2008/2005 , Integration Services (SSIS), Reporting Services (SSRS), Analytical Services (SSAS), SQL Profiler, Server Management Studio, Business Intelligence Development Studio (BIDS), OLAP, T-SQL, Data Transformation Services (DTS), SQL Server Import/Export Data, BCP, NETEZZA, MS Access, Microsoft Word, Excel, PowerPoint, Visio, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, East Rutherford, NJ

SQL BI Engineer

Responsibilities:

  • Worked with various teams and User groups in designing and developing the Reporting warehouse
  • Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings
  • Developed Complex Packages to load data into Staging table of Netezza from the source
  • Created XMLPackage Configurations for extracting the data from the source dynamically
  • Designed Data flows, Workflows and jobs to load data from source to target
  • Involved in automatingSSIS Packages usingSQL Server AgentJobs
  • Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables
  • Monitored the job and troubleshoot the problems
  • Involved in writing heavystored procedures and views in Netezza
  • An interface process was developed to push the staged data through a mapping application and ultimately the data with the new mapped values was fed to the client's Micro Strategy/Cognos table
  • Moved data from different databases to end database and maintained batch log files
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Scheduled tasks to run every day to update changes in the base tables

Technologies: SQL Server Agent, Netezza, DB2, SSIS Packages, Excel, CSV,HTML,SSMS

Confidential, Daytona Beach, FL

SQL Server BI Developer

Responsibilities:

  • Developed and maintained SQL Stored Procedures, functions, and triggers for updating customer usage information in the database
  • Merge tables and created views to support reporting requests using SQL Server
  • Used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
  • Tuned SQL queries performance using SQL Profiler, Index Tuning Wizard and Stored Procedure Debugger
  • Troubleshoot data and functionality issues related to reports, and SSIS packages
  • Used several transformations in Data Flow including Derived-Column, Script, Lookup, Data Conversion, and Conditional-Split to categorize data for other departments
  • Created complex SSIS packages using proper control and data flow elements with error handling
  • Designed Data flows, Workflows and jobs to load data from source to target
  • Performed Documentation for all kinds of reports and SSIS packages
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS)
  • Design daily table reports, matrix reports, sub-reports based on business needs using SSRS
  • 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 Reports using SSRS. Identified the data source and defined them to build the data source views
  • Created reports in SSRS with properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Designed and created report templates, bar graphs, and pie charts based on financial data for analyzing performance counters using SSRS
  • Created reports using features like drill down, drill through, parameterized reports. Developed yearly, quarterly, monthly sales reports and scheduled the reports to run on daily and weekly basis in report manager and also email them to project manager to review in Excel sheet

Technologies: SQL Server, T-SQL, SSRS, SSAS, SSIS Packages, ETL, ODBC, Excel, Data Integrator, OLAP, OLTP

Confidential, De Leon Springs, FL

SQL Server BI Developer

Responsibilities:

  • Translated business requirements into data analysis, data source for BI reports and applications
  • Created Error and Performance reports on SSIS Packages and alerts for successful or unsuccessful completion of scheduled jobs using SQL Server Agent Job Task in Event Handlers
  • Accomplished various SSIS tasks like Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse
  • Created new database object like Stored Procedures, Functions, Triggers, Indexes and Views using SQL Server in development and production environment
  • Used Performance Monitor/Profiler to resolve Dead Locks, tuned stored procedures and used Microsoft Visual Source Safe as version control tool
  • Designed new SSIS packages to extract data from Excel files or Flat files, transformed it based on business needs and loaded data to OLAP servers for further analysis
  • Created complex SSIS packages using proper control and data flow elements with error handling
  • Designed Data flows, Workflows and jobs to load data from source to target
  • Used various ETL tools like SSIS for data flow from source files like Excel, Tables and Views to other databases or files with proper mapping
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design (SSRS)
  • Designed, developed and deployed reports including Tabular Reports, Matrix Reports, Parameterized, Drill-down, Ad hoc and Sub-reports using Report Designer and Report Builder and generated these reports using variables, expressions and functions
  • Created Reports using SSRS. Identified the data source and defined them to build the data source views
  • Moved data from different databases to end database and maintained batch log files
  • Created reports in SSRS with properties like chart controls, filters, Interactive Sorting, SQL parameters etc
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Analyzed OLAP cubes with SSAS based on multidimensional database with star schema

Technologies: SQL Server, T-SQL, SSRS, SSAS, SSIS Packages, ETL, ODBC, Excel, OLAP, OLTP

Confidential, Lincroft, NJ

SQL Server BI Developer

Responsibilities:

  • Gathered requirements from the business users, created technical specification documents
  • Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules
  • Designed and implemented Stored Procedures and Triggers for automating tasks
  • Managed all indexing, debugging, optimization and performance tuning using T-SQL
  • Wrote T-SQL queries, Store Procedures and used them to build packages
  • Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse
  • Created configuration packages in SSIS to move the package from development server to production server
  • Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS
  • Installed MS SQL Server and Management tools using MS SQL Server Setup Program
  • Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on MS SQL Server
  • Ran and tested required queries and reports before publishing
  • Published the reports and scheduled the reports in different formats (Email, Public folder)
  • Scheduled the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.
  • Created a number of complex formulas to find the capacity levels of different servers.
  • Scheduled tasks to run every day to update changes in the base tables

Technologies: MS SQL Server, SSRS, SSIS, SSMS, T-SQL, Oracle, Access and Excel

Confidential

SQL Server Report Developer

Responsibilities:

  • Gathered requirements from the business users, created technical specification documents
  • Wrote T-SQL queries, Store Procedures and used them to build packages
  • Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse
  • Installed MS SQL Server 2012 and Management tools using MS SQL Server Setup Program
  • Ran and tested required queries and reports before publishing
  • Using report builder developed report models and distributed reports in multiple formats using SQL server reporting services (SSRS) in Business Intelligence Development Studio (BIDS)
  • Used stored procedures and function directly in SSRS to generate reports on the fly
  • Published the reports and scheduled the reports in different formats (Email, Public folder)
  • Scheduled the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format
  • Created a number of complex formulas to find the capacity levels of different servers
  • Scheduled tasks to run every day to update changes in the base tables

Technologies: MS SQL Server, SSRS, SSMS, T-SQL, Oracle, Access and Excel

Confidential

SQL Server Developer

Responsibilities:

  • Understanding the requirement and technical direction of the programming from BAs and Architectures
  • Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules
  • Designed and implemented Stored Procedures and Triggers for automating tasks
  • Managed all indexing, debugging, optimization and performance tuning using T-SQL
  • Created and used complex stored procedures and views to store data of the clients and optimized stored procedure to improve its performance
  • Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval
  • Created UDFs, triggers to store data in appropriate tables and when data arrived, created indexes on least updated table to improve query performance
  • Conducted optimization of queries and enhanced the performance of the database using SQL profiler
  • Generated reports on account information, health insurance claims, annual reports of the company using ad-hoc reporting to be used by the company heads

Technologies: Windows, SQL Server Enterprise Edition, Oracle, T-SQL

Hire Now