We provide IT Staff Augmentation Services!

Sql /msbi Developer Resume

Houston, TX

SUMMARY

  • Over 6 years of experience with database development and business intelligence applications as a BI developer.
  • Strong Communication & Management skills with excellent role - playing capabilities.
  • Experience with strong skills in MS SQL Server2012/2008R2/2008/2005 including Microsoft Business intelligence tools like SSIS and SSRS.
  • Experience in writing and executing complex queries in Database such as Stored procedures, Functions, Triggers, Cursors, Joins, PL-SQL, T-SQL.
  • Thoroughly involved in the various phases of SDLC including waterfall and agile models.
  • Worked on optimizing different databases by integrating SQL Server DBAs, architects, and application developers.
  • Worked on business requirements, designing & implementation of ETL strategies.
  • Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
  • Good experience in using performance monitor/SQL profiler for handling Performance Tuning of long running queries and dead lock issues.
  • Involved in unit testing, performance, and system testing.
  • Excellent ability to solve adhoc requests with ease in the project and execution, troubleshooting and fixing errors as required.
  • Developed ETL packages using SSIS with various transformation tasks.
  • Experience in using Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
  • Good experience in designing and scheduling complex SSIS Packages for data migration from various sources like SQL Server, Oracle Database, Excel, and Flat file.
  • Experience with SSIS performance tuning using counters, error handling, event handling.
  • Worked extensively on SSRS reporting tools using various reports such as Charts, Drill Down, Drill-Through Filters, Reports, Multi-valued parameters, Sub-Reports, SSRS tabular, matrix reports.
  • Experience in Performance Tuning in SSIS packages using Block and Unblock Transformations.
  • Extensively used SSIS transformations such asMerge, Derived column, Data conversion, Aggregate, Conditional split, Multicast, Union All, Sort, Fuzzy lookups, and Lookups.
  • Worked on designing SSRS reports based on the project requirement.
  • Working experience on mainframe file uploads and downloads.
  • Experience on troubleshoot of various packages during execution.
  • Troubleshoot of issues related to package configurations and connection managers.
  • Worked on various connection managers, control flow tasks and data flow tasks.
  • Involved in database backup and restorations in SQL Server.
  • Configured Package security by providing password protected

TECHNICAL SKILLS

Relational databases: SQL Server 2016/2 R2/2008/2005, Oracle11g/12c.

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

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, ODBC, SQL OLEDB, DBCC, ADO.NET, Business Intelligence Studio, SSRS Reports.

Reporting Tool: SQL Server Reporting Service (SSRS)

Languages: T-SQL, PL/ SQL, C, VB.Net, CSS, JavaScript.

Web Technologies: HTML, XML.

Operating systems: Windows98/NT/2000/XP, Windows Server 2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL /MSBI Developer

Responsibilities:

  • Upgraded SQL Server 2014 to SQL Server 2016 and migrated data from old systems to new systems.
  • Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
  • Involved in developing database objects such as procedures, triggers, constraints, indexes, and views using SQL Server 2016.
  • Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
  • Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Created various complex reports and manage those using SQL Server Reporting Services (SSRS ).
  • Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
  • Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
  • Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.

Environment: SQL Server 2016/2014/2012 , SSRS, SSIS, SSAS, BCP, DTS, SQL Mail, SQL Server Management Studio, T-SQL, XML, MS Excel, and MS Access, DTS, visual studio 2005/2008/ 2012 , TFS 2008/2010

Confidential, Boston, MA

SQL /MSBI Developer

Responsibilities:

  • Actively participated in interaction with users, team lead, and DBA’s and technical manager to fully understand the requirements of the system.
  • Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).
  • Using all kinds ofSQLServer Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
  • Writing Complex T-SQLQueries, Sub queries, Co-related sub queries and DynamicSQLqueries.
  • Created logins, users and configuring permissions and assigning roles to users.
  • Created indexes on selective columns to speed up queries and analyses inSQLServer Management Studio.
  • UsedSQLServer 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services.
  • Created new SSIS package to extract date from legacy toSQLServer Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Generated reports using SSRS and Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Responsible for creating the reports based on the requirements using SSRS 2008.

Environment: MSSQL Server 2005/2008, SSIS, SSRS, BIDS, Visual studio 2008, MS Visio 2007 and XML.

Confidential

SQL BI Developer/SSIS Developer

Responsibilities:

  • Involved in the development of SSIS Packages & SSRS reports using BIDS
  • Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for different applications.
  • Developed Stored Procedures, Functions, Triggers, Tables, Views, SQL joins and statements for applications using T-SQL.
  • Used CTEs for recursive functionality to bring the organization structures.
  • Built table valued functions, scalar valued functions to suffice the needs for business rules and for the implementation in stored procedures.
  • Created new jobs or using the existing jobs, reviewing the results to determine success/failure, documents success/failure, troubleshoots failures, provides up-to-date communication, and maintains documentation.
  • Designed dimension modeling for data warehouse. Developed data warehouse to generate OLAP cubes and identified measures and dimensions according to different requirements.
  • Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS, Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Created user defined functions in SSRS using VB script.
  • Worked on row and column grouping, filtering, and sorting the data in the repots using SSRS.

Environment: MS SQL Server 2005/2008, MS Reporting Services 2005/2008, SQL Server Integration Services 2005, T-SQL, Windows Server 2003, Windows XP Professional, MS Excel 2003, Team Foundation Server.

Confidential

SQL/SSIS Developer

Responsibilities:

  • Worked extensively on the major enhancements to the dotnet existing code.
  • Design and execution of SQL queries, stored procedures, functions, and indexes.
  • Worked on Database tables, views, joins for analyzing the data.
  • Prepared the technical documentation for the new business requirements for the upcoming portal enhancement.
  • Delivered the project required targets weekly on time and given extensive trainings to the new joiners in the project.
  • Involved in Design, Development, and maintenance of new Installs and Existing SSIS Packages, including creating technical specifications for new SSIS requirements.
  • Analyzed the requirements and framed the business logic for the ETL process.
  • Developed T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments.
  • Implemented complex business requirement in backend using efficient stored procedures and flexible functions and facilitated easy implementation to the front end of the application.
  • Loading source files into raw tables for data mining and data ware housing tasks.
  • Used Merge function to check against old records and load only new records.

Environment: SQL Server 2008/2005, SSIS, SSRS, T-SQL, VB Script.Net, MS-Excel, Visual Studio.

Hire Now