We provide IT Staff Augmentation Services!

Sr. Msbi Developer (ssis) Resume

Redmond, WA

PROFESSIONAL SUMMARY:

  • Around 9 years of extensive experience in Database Design, Development and Implementation of Client - Server Applications & Database systems using MSBI 2012/2008/2005 in different environments.
  • Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using different transformations.
  • Expertise in using different transformations provided by SSIS such as script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2012/2008/2005 ).
  • Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Experience in deploying created reports in various sources like Web browser, XML and PDF
  • Experience in creating several reports such as drill down reports, parameterized reports, and linked reports, sub reports, Matrix Reports and Charts using SSRS.
  • Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
  • Experience in report writing according to the business requirement in SSRS.
  • Expertise in Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS).
  • Generated reports using Global Variables, Expressions and Functions using SSRS 2012/2008
  • Experience in creating reports in SSRS and Crystal reports.
  • Created stored procedure for generating reports using SQL Server Reporting Services (SSRS)
  • Strong knowledge in Strand Snow-flake schemas and OLAP modeling which involved in creating data source views with added measures, dimensions in SSAS
  • Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
  • Worked on creation and deployment of cubes on SSAS for data with pre-calculated aggregations and also in summarized fashion which can be modeled into a report accordingly.
  • Expertise in installing and configuring SQL Server 2005/2008/2012 on Windows Environment and managing the database using Confidential SQL Server Management Studio.
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Experienced in using T-SQL in SQL Server 2012, 2008 and 2005 platform
  • Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.
  • In-depth knowledge of Transact-SQL (DDL, DML, DCL) and design and normalization of the database tables.
  • Test & Deploy code across various SDLC Environments like TEST,UA/UT/Production
  • Experienced in using Data Modeling Tools like Erwin, MS access and Confidential Visio.
  • Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
  • Involved in optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, SQL Server Configuration Manager, Database Engine Tuning, Dynamic Management Views and Functions

RDBMS: MS SQL Server 2005/2008/2012, MS Access

Productivity Applications: MS Word, MS Excel, MS Access, MS Project

ETL: SQL Server Integration services

Programming Languages: C, C++, C#, .NET, SQL, TSQL, PL/SQL

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate, Windows 8

DBA Tools: Import/Export, SQL Loader, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, Service Broker

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. MSBI Developer (SSIS)

Responsibilities:.

  • Writing code for database Access, Modifications, and Constructions including schemas, SSIS and stored procedures
  • Responsible for developing, maintaining and supporting EIM applications and supporting .NET developers
  • Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
  • Gathers and analyzes requirements and Programs all or selected components of SQL applications.
  • Documents components and applications.
  • Researches, Evaluates and Recommends new tools and applications for use in assigned responsibilities
  • Independently writes and reviews design specifications, code, and unit tests
  • Troubleshoots and resolves medium to high complexity application defects and Solves a range of problems
  • Analyzes possible solutions using standard procedures
  • Receives a moderate level of guidance and direction
  • Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
  • Made the SSIS packages dynamic by passing the input from configuration files.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures
  • Suggested best practices in migrating DTS to SSIS
  • Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
  • Wrote Stored Procedures / Transact-SQL scripts as per the business need.
  • Worked Auditing and Notifications while loading process in SSIS

Confidential, NC

Sr. MSBI Developer (SSIS)

Responsibilities:.

  • Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
  • Prepared the complete data mapping for all the migrated jobs using SSIS
  • Involved in the DTS to SSIS Migration Project
  • Created the Proof of Concept for the Migration Project
  • Design SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
  • Performed ETL Auditing to maintain Loads report
  • Used complex transactions and Validations to make sure the data is correctly loaded into the warehouse
  • Used Configuration files to deploy and install a package from one environment to another.
  • Used log providers to log error into the table and send the reports to the concerned department.
  • Applied Security in Packages to safe guard sensitive data, and used log providers to log events.
  • Made the SSIS packages dynamic by passing the input from configuration files.
  • Involved in Performance tuning of ETL transformations, data validations and stored procedures
  • Suggested best practices in migrating DTS to SSIS
  • Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
  • Wrote Stored Procedures / Transact-SQL scripts as per the business need.
  • Involved in monitoring database maintenance plans for checking database integrity, data optimization,
  • Rebuilding indexes and updating statistics.
  • Created and modified complex TSQL batches / stored procedures.
  • Involved in creating new Stored Procedures and Optimizing existing queries and Stored Procedures.
  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS- 2012 in Business Intelligence Development Studio (BIDS)
  • Involved in development, enhancement, testing and performance tuning of the application.

Confidential - IL

Sr. MSBI Developer (SSIS/SSRS)

Responsibilities:

  • Worked with Business Analysts and Users for gathering requirements and implemented logical Design into Physical Design.
  • Involved in the all the stages of Software Development Life Cycle (SDLC).
  • Installed SQL Server 2008/2012 on development and production servers setting up databases, users, roles and permissions.
  • Integrated Database Maintenance jobs to perform Full, Differential and transaction log Backups and scheduled them with SQL Server agent job scheduler.
  • Upgraded all SQL Server 2008 to SQL Server 2012 without any service interruption.
  • Involved in the normalization and de-normalization of the databases.
  • Created and Modified tables, Views, Indexes, User Defined Functions, Stored Procedures in SQL Server 2012/2008.
  • Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2012/2008.
  • Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor
  • Used sever Transformations in the SSIS packages for the data transformation from the OLTP to OLAP.
  • Explicitly used Execute SQL Task, Script task, Derived Columns, Condition split, aggregate, lookup, Merge join etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
  • Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
  • Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in the packages.
  • Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
  • Designed and created distributed reports in multiple formats such as Excel, PDF, XML and CVS using SQL Server 2005 Reporting Services (SSRS).
  • Developed drilldown and drill through reports from multi-dimensional objects like star schema and snowflake schema using SSRS and performance point server.
  • Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
  • Created jobs and scheduled jobs using SQL Server Agent.
  • Deployed code into the production environment. Provided 24/7 production support for the production database.

Confidential, Redmond, WA

Sr. MSBI Developer (SSIS/SSAS/SSRS)

Responsibilities:

  • Involved in gathering requirements, performing source system analysis and development of ETL jobs to populate data from the transactional data source to the target Data warehouse.
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
  • Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
  • Experience in SSIS package design, development and deployment..
  • Expertise in using different transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.
  • Configure SSIS Package for run time Parameters and Configuration file.
  • Developed some scripts and used in ETL Process that works as transformation
  • Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
  • Created packages in SSIS with error handling.
  • Scheduled tasks to run every day to update changes in the base tables
  • Writing complex stored procedures to meet the business requirements.
  • Created new database objects like Stored Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment on SQL Server 2008.
  • Created matrix and tabular reports with drilldown, drill through and dropdown menu option using SSRS.
  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
  • Designed and developed various types of reports using SSRS
  • Created parameterized reports, Drill down and Drill through reports using SSRS
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
  • Generated reports using Global Variables, Expressions and Functions using SSRS 2008
  • Excellent ability in writing specification and gathering from the user to developed crystal report as per the client and maintained documentation of the reports .
  • Created custom formulas to display RGB colors in crystal reports.
  • Experience in developing ASP.Net web application with Crystal reports using C#.
  • Worked on Data modeling, creating star and snowflake schemas in SSAS.
  • Experience in working with data warehouses and Confidential OLAP Analytics Services.
  • Created automatically drill down report from summary data which is managed by the OLAP server to data warehouse relational database.
  • 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
  • Created complex Stored Procedures, 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
  • Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions
  • Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
  • Actively involved in Normalization (3NF) & De-normalization of database.
  • Rebuilding indexes on various tables.

Confidential, West Chester, PA

Sr. MSBI Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Analysis of the client requirements.
  • Created and maintained databases, tables, constraints, views, indexes
  • Creating SSIS packages for Extraction, Transformation and Loading operations.
  • Writing T-SQL queries, Views, Stored Procedures and User Defined Functions.
  • Troubleshooting performance issues, fine-tuning queries and stored procedures.
  • Written SSIS packages in 2005 and did conversion DTS packages from
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
  • Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
  • Created packages in SSIS with error handling.
  • Designed reports using SQL Server Reporting Services (SSRS).
  • Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005
  • Generated reports using Global Variables, Expressions and Functions using SSRS 2008
  • Experience in creating reports in SSRS and Crystal reports.
  • Worked with Reporting Services Report Servers in SharePoint Integrated Mode.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.
  • Involved in De-Normalization of existing tables for faster query retrieval.
  • Created complex Stored Procedures, 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
  • Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions.
  • Actively involved in Normalization (3NF) & De-normalization of database.

Confidential

Sr. MSBI Developer (SSIS/SSRS)

Responsibilities:

  • Installed SQL Server 2005 on development and production servers setting up databases, users, roles and permissions.
  • Upgraded all SQL Server 2000 to SQL Server 2005 without any service interruption.
  • Involved in the all the stages of Software Development Life Cycle (SDLC).
  • Involved in the normalization and de-normalization of the databases.
  • Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2005.
  • Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2005.
  • Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
  • Created SSIS packages to transfer data from different data sources load it to data warehouse.
  • Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
  • Migrated DTS packages to SSIS packages using package migration wizard.
  • Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
  • Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
  • Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
  • Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
  • Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
  • Wrote MDX queries according to the business requirements.
  • Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2005 Reporting Services (SSRS).
  • Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
  • Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
  • Created jobs and scheduled jobs using SQL Server Agent.
  • Deployed code into the production environment. Provided 24/7 production support for the production database.

Confidential

Sr. SQL Developer (SSIS/SSRS)

Responsibilities:

  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions for various Batch and reporting purposes
  • Helped the front end application developers with their queries.
  • Creating SSIS packages for Extraction, Transformation and Loading operations.
  • Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems like Oracle, Flat files, Excel into databases for Dashboard Reporting on a daily basis
  • Experience in SSIS package design, development and deployment..
  • Expertise in using different transformations provided by SSIS such as script component, LookUP, Data Conversion many more to transform the data before loading into the destination.
  • Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
  • Populated Data Warehouse using SSIS Packages and implemented Kimball methodology. Implemented Type I, II, III changes in Slowing Changing Dimension (SCD) Tables.
  • Involved in usage of various SSIS components like For loop, Foreachloop, Fuzzy Lookup, Variables, Error Handling etc
  • Created Several Dash Boards using Performance Point Server
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
  • Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
  • Involved in De-Normalization of existing tables for faster query retrieval.
  • Created complex Stored Procedures, cursors, tables, views and other SQL joins and statements for applications by using T-SQL

Confidential

Responsibilities:

  • Gathered reporting requirements from every department.
  • Designed and developed a database to house data from various data sources for all reporting needs.
  • Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
  • Created and scheduled SQL jobs to run SSIS packages on a daily basis.
  • Developed Query for generating drill down reports in SSRS 2005.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Created parameterized, drill-down and drill-through reports.
  • Created subscription to reports.
  • Deployed reports to Reporting Services.
  • Involved in De-Normalization of existing tables for faster query retrieval.
  • Created complex Stored Procedures, cursors, tables, views and other SQL joins and statements for applications by using T-SQL
  • Created complex T-Sql Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Identified the Data Source and defined them to build the Data Source Views.
  • Installed and maintained MS SQL Server 2005.
  • Participated in weekly IT status update meetings.
  • Maintained very good relationship with client by communicating progress of the project

Hire Now