We provide IT Staff Augmentation Services!

Sqlserver Bi Developer Resume

Birmingham, AL

SUMMARY:

  • 7+ years of experience in Analyzing, Designing, Development, Implementation, Maintenance and Documentation of Database and Client Server applications.
  • Extensive experience in Designing Relational database model and Implementation as per business needs.
  • In - depth knowledge of T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
  • Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers using tools like SQL profiler, and database tuning Advisor (DTA).
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Very strong T-SQL skill in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers in SQL Server 2008.
  • Experience in Change Data Capture (CDC), Change Tracking (CT) in SQL server 2008.
  • Efficient in building recursive queries using CTEs (Common Table Expressions).
  • Expert in Query Tuning, including Updating Statistics, Re-building and Re-organizing Indexes.
  • Thorough knowledge of addressing Performance Issues and Involved in Index tuning, Data profiling and other database related activities.
  • Experience in writing, testing (unit testing) and debugging stored procedures, triggers and troubleshooting database issues.
  • Hands on experience in performance tuning, query optimization, and database optimization.
  • Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks.
  • Experience in Monitoring, Job scheduling, Trouble shooting, Backup, Recovery and System upgrading.
  • Very Strong in Implementation of Microsoft Business Intelligence (BI) platforms including Performance Point Server 2007 (PPS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Microsoft Office SharePoint Server 8 (MOSS) in SQL Server 2005.
  • Proficiency in using different Transformation tools like DTS packages, BCP and Bulk Insert as well as SQL Server Integration Services (SSIS).
  • VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
  • Expertise in Extraction, Transformation, Loading data from Oracle, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Designed high level ETL architecture for data transfer from the OLTP to OLAP Using SSIS.
  • Experience in developing, configuring and deployingSSIS packages and providing security.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Experience working with Active Directory issues such as: logon failures, account lockouts, and authentication problems.
  • Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
  • Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
  • Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
  • Expertise in SQL Server Analysis Services (SSAS) CUBE design, Development and Deploying.
  • Optimized large cubes by creating partitions, usage based optimization, and using proper storage modes like MOLAP, HOLAP and ROLAP.
  • Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts and OLAP cubes.

TECHNICAL SKILLS:

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Server Profiler, Data Base Engine Tuning Advisor, Data Transformation Services, Visual Studio.

Data warehousing & Business Intelligence Tools: SQL Server 2008/2005/2000 , SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SSMS, DTS Packages, MDX Queries, ETL, Performance Point Server, OLAP, OLTP, Visual Studio.

Database Design Tools & Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT&Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inman Methodologies, MSX, MS Access, MS Project, ProClarity.Others: MS Office, MS Outlook (Microsoft Office Suite), Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, TFS.

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

SQLServer BI Developer

Responsibilities:

  • Created Stored Procedures, Functions, complex T-SQL queries using UPSERTS, JOINS, Sub Queries, CTEs, Temp Tables etc.
  • Optimized and tuned SQL Queries using CTEs, Temporary tables and created clustered, non - clustered, covering indexes etc. by checking the query execution plans
  • Created 2008 R2 SSIS Packages to extract data from various sources including Sql Server, Flat files, CSV files, excel files, share point lists, Sybase DB2, XML etc. into data warehouses and data marts following business requirements and client standards.
  • Used various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all, conversion and etc.
  • Converted DTS 2000 to SSIS 2008 R2 package using dts Xchange and converted 2008 R2 to 2012 DTSX packages.
  • Created and /or updated C# .NET code using SSIS script task in SSIS 2008 and 2012 DTSX packages.
  • Created SSRS 2008 reports including drill through, drill down, parameterized, cascaded parameterized reports along with global report parameters based on the business requirements and client’s standards and deployed them to Report servers.
  • Created and maintained SSRS data driven subscriptions.
  • Used BMC’s Control-M scheduler to monitor all the SSIS jobs by replacing all the MS SQL Agent jobs with Control-M jobs.
  • Converted all the 2008 R2 to 2012 SSIS packages and used SQL Server table configuration settings for each SSIS package and scheduled them in control-M.
  • Followed proper SDLC methods while deploying SSIS packages to Production environment via Development/Test, Model and production Environments of both Control-M scheduler and SQL Server instances by creating Change Requests and database requests using Service Now share point site.
  • Handled an offshore team of 4 while monitoring and fixing any SSIS job failures monitored via Control-M and BI Xpress, and followed necessary escalation procedures while doing so.
  • Made sure that the SSIS Jobs in Control-M are completed as per dependences, schedule and criticality.
  • Involved in creating cubes for the Enterprise Data Warehouse (EDW).
  • Created Multidimensional Cubes in Facts and Dimension Tables using SSAS.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS) 2008 R2 and 2012, MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS) 2008 and 2012, Microsoft Visual source Safe, BMC Control-M scheduler, C# .NET

Confidential, IL

SQLServer BI Developer

Responsibilities:

  • Created tables, views, stored procedure as per design needs.
  • Optimized queries tuned and monitored server performance.
  • Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
  • Developed, monitored and deployed SSIS packages.
  • Performing query plans and making sure each and every query is using appropriate useful Indexes
  • Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc.
  • Responsible for creating the reports basing on the requirements using SSRS 2008.
  • Identified the database tables for defining the queries for the reports.
  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
  • Defined the report layout in SSRS.
  • Wrote the queries for the drill down reports, parameterized reports.
  • Identified and added the report parameters.
  • Formatted the reports using the Global variables and expressions.
  • Deployed the generated reports on to the server.
  • Involved in creating cubes for the Enterprise Data Warehouse (EDW).
  • Created Multidimensional Cubes in Facts and Dimension Tables using SSAS.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential, Dallas, TX

SQLServer BI Developer

Responsibilities:

  • To build SSIS Packages to pull the data from Teradata and Netezza Databases.
  • To build reports using SSRS such as Drill Down and Drill Through reports
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS)
  • Developed KPI reports using SSRS that points to SSAS cubes.
  • Wrote very complex Stored Procedures using cursors and temp tables for Reporting purposes.
  • Fine-tuned various SQL server jobs in the Production environment.
  • Developed Incremental data logic to load data into the SQL Server using SSIS from Teradata and Netezza
  • Designed SSIS templates for the purpose of Incremental data load using table partitionsand System tables
  • Performance tuning, and optimization of procedures and queries.
  • Principle responsibility is to implement support, maintain, monitor and tune high available and clustered database systems.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchiesand adding the Aggregations to the Cube.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
  • Scheduled .dtsx packages execution to load data into Fact Tables using SQL Server Agent
  • Wrote MDX queries and expressions for use in Front End BI Applications
  • Optimized cubes for better query performance
  • Aggregated cube with 40% performance for better performance
  • Processed cube to perform incremental updates
  • Wrote MDX expressions to create name sets and calculated members
  • Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS).
  • Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
  • Implemented computational sensitive queries Stored Procedures.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005/2008 as SSIS Packages.
  • Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
  • Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
  • Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
  • Written DDL / DML Triggers as per company policy.
  • Actively involved in Normalization (3NF) & De-normalization of database.
  • Rebuilding indexes on various tables.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition, Microsoft Visual Basic 8.0 and 9.0, T-SQL, OLAP, VB.NET, Netezza, Teradata, and Microsoft Windows 2003 Advanced Server, BIDS.

Confidential, Chantilly, VA

SSIS/SSRS Developer

Responsibilities:

  • Understanding the report design Requirements and Constraints.
  • Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Design and implementation of Security Model, Policies and Procedures.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Creating and Modifying 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.
  • Deployed the created SSIS packagesusing different transformations 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.
  • VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Drill-down, Parameterized and Sub-Reports using RDL.
  • Promoted RDLs to Reporting Service Server (SSRS).
  • Designed and developed Datamart using SSAS.
  • Build Cubes on Enterprise Date Warehouse (EDW).

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe

Confidential, Minneapolis, MN

SQL Server Developer

Responsibilities:

  • Performed the creation, manipulation and supporting the SQL Server databases.
  • Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
  • Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS)
  • According to the business requirements made the documentation of the performed tasks.
  • Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
  • Managing the security of the servers, creating the new logins and users, changing the roles of the users
  • Experience in Database Backup, Recovery and Disaster Recovery Procedures.
  • Determined the MS SQLServer2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Tested the Installation of SQL Server and implemented different security modes.
  • Experienced on Database creation, database tuning, and performance planning, backup planning and database administration.
  • Involved in Creating Database Objects like Tables, Stored Procedures and Views.
  • Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer)
  • Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
  • Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager
  • Created and administered multiple development, training and production databases
  • Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
  • Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check
  • Responsible for creating standards and operating procedures to maintain all databases
  • Worked with development teams in the design of physical databases and in modification
  • Reduced systems downtime risk through automatic offsite backup and recovery over network
  • Responsible for database security of the operational and developmental application system databases
  • Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks
  • Programmed complex data structures in C and CPP.

Environment: MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Access 2000 &Windows NT platform, Reporting Services, DTS, Business Objects 4.0/6.5, Windows Active Directory.

Hire Now