Sql Bi Developer/ssis/ssrs Resume
St Louis, MO
SUMMARY
- Having 8+ years of IT experience with expertise in analyzing the requirements, application development, Testing, Production support and a major focus on Business Intelligence.
- Expertise in software analysis, design, and development of applications including providing Business Intelligence solutions using SQL Server Business Intelligence Development Studio with tools like SQL Server integration services SSIS, SQL Server Reporting services SSRS, SQL Server Analysis SSAS .
- Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP systems (SSIS, SSRS, SSAS) using SQL Server 2005/2008/2008 R2/2012.
- Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities as well as a proactive team member.
- Excellent Transact - SQL programming skill in writing SQL Server Stored Procedures, Triggers, User-defined Functions & Views.
- Expertise in managing Alerts, Operators and Jobs through SQL Server Agent.
- Expertise in ETL DTS Packages & SSIS Packages for integrating data from sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Conditional Split, Data Conversion, Bulk Insert, merge and union all.
- Experience in database activities like Data Modeling, Data Staging, Data cleansing, Data scrubbing.
- Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
- Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
- Defined Break points and Check points in SSIS Packages.
- Expertise in managing Alerts, Operators and Jobs through SQL Server Agent.
- Developed reports on Drilldown, Drill Through, Parameterized, Cascaded Parameterized reports in SSRS 2012.
- Experienceingenerating scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
- Experience in using global variables & expressions for the reports.
- Expert in creating cubes and dimensions using SSAS.
- Involved in creating the Star Schema, MDX cubes and dimensions.
- Expertise in creating Aggregations, partitions in cubes using SSAS.
- Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance.
- Ability to learn and adapt quickly to the emerging new technologies.
- Exceptionally well organized, strong work and a willingness to work hard to achieve confidence and objective.
TECHNICAL SKILLS
Programming Languages: T-SQL, SQL, VB 6, C#.Net.
Database Application Software: MS SQL server 2005/2008/2008 R2/2012/2014 Oracle 8i, 9i/10g, MS Access 97/2000
ETL Tools: SQL Server Integration Services (SSIS)
GUI: DTS Import/Export, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services
Application Software: Microsoft Office, Visual Studio.
Modeling Tool: Database Designer, Visio
Operating Systems: Windows Vista/XP/NT/2000.
PROFESSIONAL EXPERIENCE
Confidential, St. Louis, MO
SQL BI Developer/SSIS/SSRS
Responsibilities:
- Created complex Stored Procedures, triggers, tables, views and other SQL joins for applications.
- Involved in gathering requirements, business rules and deliver them in time.
- Involved in complex Views and other T-SQL code and SQL joins for applications.
- Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
- Worked on Performance Tuning to reduce the runtime and increase performance & efficiency.
- Involved in SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
- Worked with different types of dataflow transformations like Derived Column, Data Conversion, Lookup and Conditional Split, Multicast etc.
- Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc using SQL Server 2014.
- Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
- Used Change data capture (CDC) to load initial and incremental loads in data.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
- Configured Server for sending automatic mails to the respective people when a DTS/ETL process failure or success.
- Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
- VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
- Automated several legacy tasks using a combination of SQL Server and .NET (VB).
- Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
- Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
- Extensively worked on reporting using Excel Power Pivot, developed multiple pivot charts and tables while improvising the old reports.
- Designed ETL package, with ETL Import/Export wizard for transferring data.
- Designed the reports layout for creating tabular and matrix reports.
- Implemented change data capture to log the inserts, updates and process the data to different servers.
- Designed and developed various Service Management Reports, utilizing Dynamic and Cascading.
Environment: SQL Server 2008/2008R2/2012/2014, T-SQL, MS-Excel, MS SQL Reporting Services, Visual Studio 2012.
Confidential, St. Louis, MO
SQL BI Developer/SSRS/SSIS
Responsibilities:
- Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
- Used DDL and DML for writing triggers, stored procedures, and data manipulation for automating tasks.
- Defined Check constraints, Business Rules, Indexes, and Views.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Tuned and Optimized SQL Queries using Execution Plan and Profiler.
- Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS/ETL).
- Worked on Integration testing for data extraction and loading to destination paths.
- Design and development of SSIS packages (Design and development of Extraction, Transformation and Cleanse Packages to migrate legacy data into SQL Server.
- Created DTS/ETL packages to schedule the jobs for batch processing.
- Used SQL Profiler and Query Analyzer to optimize DTS/ETL package queries and stored procedures.
- Involved in securing the dimensions and Cubes. Created perspectives and Partitions (for various years of data).
- Worked on preparing testing scripts to verify the development execution results and involved in tuning the SQL queries when testing the performance.
- Involved in resolving various issues during testing the package queries, also worked on huge data and validating them using back end testing.
- Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
- Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
- Maintaining complex SSIS packages which play a major role in data transformation and data migration.
- Created SQL Jobs and automated schedules to run the jobs along with error handling and user notification capacity.
- Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
- Developed and Supported reports built with Microsoft Reporting Services (SSRS) on SQL.
Environment: MS SQL Server 2012, SSRS, SSIS, DTS/ETL/SSIS, Visual Studio.
Confidential, Tampa, Florida
SQL Server Developer
Responsibilities:
- Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
- Responsible for stored procedures optimization, performance tuning and index tuning.
- Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
- Extract Transform Load (ETL) development using SQL Server, SQL 2008 Integration Services (SSIS).
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
- Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
- Experience in moving the data from heterogeneous data sources like oracle, xml etc to SQL using SSIS.
- Enhancing and deploying the SSIS Packages from development server to production Server.
- Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
- Created reports with different features like drill through capabilities, usage of Tablix, use of pie charts and bar charts use of filtering conditions.
- Created Triggers to enforce data and referential integrity.
- Defined Check constraints, Business Rules, Indexes, and Views.
- Strong knowledge of dimensional data modeling using star and/or snowflake schemas.
- Played a major role in production support of SSAS (cube refresh), SSIS jobs.
- Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Environment: SQL Server 2008/2008 R2 T-SQL, MS-Excel, MS Reporting Services, DTS, SSIS.
Confidential, Brecksville, OH
SQL Server Developer
Responsibilities:
- Created schema modification scripts to implement the logical design into SQL Server 2005.
- Planned and implemented various SQL, T-SQL statements, stored procedures and triggers according to the requirements of the project.
- Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
- Extensively used joins and sub queries for complex queries involving multiple tables from different databases.
- Successfully managed Extraction, Transformation and Loading (ETL) process by pulling data from various data sources using BCP in staging database from MS Access, Excel.
- Configured replication servers for transactional replication for production and mirror server for high availability.
- Developed parameterized, drill down, drill through and sub reports to meet the business requirements.
- Developed client applications, report models and reports using SSRS and BI studio by pulling data from the cubes and relational tables using ADO .Net.
- Deployed SSIS packages and Reports to Production Servers.
- Creating report model on SSAS cubes as well as changing default configuration on existing cubes.
- Developed KPIs in accordance to the business requirement.
- Involved in designing calculated measures using Multi-Dimensional Expression (MDX).
Environment: MS SQL Server 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access2007, Office2007, Windows Server 2003.
Confidential
SQL Server Developer
Responsibilities:
- Gathered Requirements from the end user and checking the structure of the schema.
- Developed, modified, and optimized complex queries to retrieval and modification.
- Generated database SQL scripts and deployed databases including installation and configuration
- Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL
- Worked closely with application development team helping them in performance tuning and optimization of queries.
- Designed and implemented stored procedures and triggers for automating tasks.
- Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
- Created SSIS packages and transferred them to the appropriate destinations.
- Involved in defining Referenced Relationships with the measure groups and fact tables.
- Generated reports using the SSRS 2008 and formatted reports.
- Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
- Created the data source views for security reasons.
- Created SQL server Analysis Projects using MS SQL Server 2008.
- Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
Environment: MS SQL Server 2008, MS Analysis Services 2008, MS Access, Import & export data.
Confidential
Junior SQL server Developer
Responsibilities:
- Installing and Configuring of SQL Server on windows OS.
- Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user input.
- Participated in the creating tables, indexes, constraints, triggers, procedures, views, user defined data types and user defined functions.
- Extensively used joins and sub queries to simplify complex queries involving multiple tables.
- Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
- Designing and building data load procedures, using MS SQL Server.
- Monitored the performance of Database Server & Tuning for Better Performance.
- Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Environment: SQL Server 2005, Enterprise Manager, MS-Excel, SQL Profiler, ETL, DTS, T-SQL.
