Sr. Ssis/ssrs/etl Developer Resume
Columbus, OH
SUMMARY
- Over 7 years of IT experience in Design, Development & Administration of Business Intelligence Solutions with Microsoft SQL Server 2012/2008R2/2008/2005 with various business domains like Financial, Sales & Communication, and Banking Sector.
- Good experience in Information Technology field as a SQL Server Developer with strong expertise in SQL Server Development, Designing Stored Procedures/Transact - SQL Coding.
- Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2012/2008R 2/2008/2005/2000.
- Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity
- Efficient in creating Sub-Queries and Joins for complex queries involving multiple tables.
- Worked with T-SQL, DDL, and DML Scripts and established relationships between tables using Primary Keys and Foreign Keys.
- Expertise in SQL Server Integration Services (SSIS) andSQL Server Reporting Services (SSRS) with good knowledge onSQL Server Analysis Services (SSAS), OLAP and OLTP.
- Excellent in High Level Design of ETL - DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Experience in creating and managing Error logging, Event Handlers, Package Configurations, creating Jobs, SQL Mail Agent, Alerts and Scheduling SSIS Packages.
- Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
- Well-versed in usage of SSIS Control Flow items(For Loop, ExecuteSQLtask, Script Task, Send Mail Task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
- Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.
- Experience in performance tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Experience in developing ETL architecture for building a Datawarehouse and Data Migration.
- Good understanding of Relational Database Management Systems (RDBMS), Normalization, Multi-Dimensional (Star) and Snowflake logical and physical data modeling using ERWIN and MSVISIO.
- Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SSRS based on client requirements and deploying on Report Server.
- Expert in creating Ad-Hoc reports, Linked reports, Snapshot reports, Cross-Tab, Conditional, Top N and Sub reports using SSRS.
- Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
- Excellent hands on experience in creating groups, hierarchies, measures, KPIs and in creating MDX cubes, dimensions using SSAS.
- Experienced in Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, ER diagrams and Data Flow Diagrams, Scripts and formulas, Refresh Strategy and Planning
- Expertise in creating Dashboard Reports to support end users using SSAS.
- Worked with end users/business analysts to understand business requirements, recommended technical solutions and documented functional requirements.
- Extensive Knowledge in MS SQL Server configuration manager, performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery.
TECHNICAL SKILLS
Languages: C, C#, HTML, SQL, T-SQL, PL/SQL, JAVA, ASP.Net
Databases: MS-SQL Server 2000/2005/2008/2008 R2/2012, Oracle 8i/9i/10g, TFS
IDE Tools: Eclipse, Visual Studio
BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports, SQL Server Analysis Services (SSAS)
Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer, SQL Loader, TOAD
Data Modeling: ERWIN, MS Visio
Operating Systems: Windows 98/2000/2003/ XP/VISTA/7/8, Linux
PROFESSIONAL EXPERIENCE
Confidential, Columbus, OH
Sr. SSIS/SSRS/ETL Developer
Responsibilities:
- Writing advanced T-SQL queries, analyzing existing stored procedures and recommending modifications for efficiency gains.
- UsedSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
- Used T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
- Created Table Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
- Testing Packages and fixing bugs using SQL 2012 Business Intelligence Development Studio.
- Identified Dimensions and Facts, used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
- Scheduling and executing SSIS Packages, using SQL Server Agent.
- Creating SSIS package to import data from SQL tables to different sheets in Excel.
- Optimizing the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes.
- Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.
- Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
- Bug fixes in SSIS, SSRS, stored procedures as necessary.
- Use DDL and DML for writing triggers, stored procedures, and data manipulation.
- Performance tuning of SQL queries & stored procedures using SQL Profiler and Index Tuning Wizard.
- Used C# and VB Scripts in ETL Packages where ever necessary.
- Worked in an agile scrum methodology.
- 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.
- Scheduling the jobs to run for ETL using SQL Server Agent.
- Worked on writing the T-SQL code for the historical data to pull according to the requirement.
- Played roles like production support of SSIS and SSRS jobs.
- Perform T-SQL tuning and optimizing queries for and SSIS packages.
- Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
- Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.
Environment: MS SQL Server 2008R2, MS SQL Server 2012, Micro Soft Visual Studio 2012, BIDS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft SharePoint Server, Team Foundation Server.
Confidential, Columbus, OH
Sr. SQL Server SSIS/SSRS Developer
Responsibilities:
- Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
- Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
- Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
- Developed Logical and physical data model using ERWIN and mapped the data into database objects.
- Used VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
- Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
- Created SQL scripts for tuning and scheduling.
- Bug Tracking and Reporting through TFS bug tracking tool.
- Performed data conversion from flat file into a normalized database structure.
- Created Triggers to enforce data and referential integrity.
- Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2010.
- Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients and managers.
- Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2012, 2008 R2 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Scheduled and maintained weekly loads of data by creating the corresponding job tasks in Visual Studio 2010.
- Backing up master & system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
- Supported Application Development team with any database issues, updates or new releases. Developed SSIS Templates which is used to develop SSIS Packages which can deployed into Dev, Test and Production Environments dynamically.
- Involved in extracting the data using SSIS from OLTP to OLAP, monitored and deployed SSIS packages.
- Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
- GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
- Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
Environment: SQL Server 2012/2008 R2, SSIS, SSRS, Visual studio 2010, MS Visio, ASP.Net, VB.Net, BIDS, SharePoint, TFS, ERWIN.
Confidential, Detroit, MI
SQL Server SSIS/SSRS Developer
Responsibilities:
- Created User Defined Functions, Stored Procedures, and Triggers.
- Performed data conversions from Flat files into a normalized database structure.
- Developed, modified and optimized complex stored procedures, triggers to handle complex business rules.
- Created SSIS Packages, dimensions and cubes with star schema using SQL Server Integration and Analysis Services (SSIS, SSAS).
- Generated reports using Global Variables, Expressions and Functions using MSSQLServer Reporting Services.
- Migrated reports from SQL Server 2008 to SQL Server 2008 R2 and configured new data with the existing data.
- Implemented the concepts of incremental loading and slowly changing dimensions.
- Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
- Configured Server for sending automatic mails to the respective people when a SSIS process fails or succeeds.
- Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
- Implemented the Error logs through Event handlers for the existing packages.
- Created Drilldown, Cascade and parameterized reports using SSRS.
- Created reports to retrieve data using Stored Procedures that accept parameters.
- Scheduled the monthly/weekly/daily reports to run automatically onto the DashboardResponsible for Monitoring and Tuning Report performance.
Environment: SQL Server 2008 R2, Netezza, Nexus, T-SQL, MS Excel, MS Access, SSIS, and SSRS, SharePoint.
Confidential
SQL Server Developer
Responsibilities:
- Created new tables, written stored procedures for Application Developers and some user defined functions.
- Performed data conversions from flat files into a normalized database structure.
- Defined Check constraints, Business Rules, Indexes, and Views.
- Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
- Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts using SSRS.
- Implemented Custom Error Handling (Record Level) by using the Script component to generate custom error messages and redirected the error rows to a staging error table.
- Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
- Migrating DTS package from SQL Server 2005 to SSIS in SQL Server 2008.
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
- Creation / Maintenance of Indexes for fast and efficient reporting process.
- Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
Environment: SQL Server 2005/2008, T-SQL, Report Manager, Report Viewer, SQL Server Integration Services 2008, Data Transformation Services, SSRS, BIDS.
Confidential
SQL Server Developer
Responsibilities:
- Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
- Created packages in SSIS with error handling.
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Designed cubes with star schema using SQL Server Analysis Services (SSAS).
- Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
- Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
- Web Form design and coding using Master Pages, Server controls, Cascading Style sheet, JavaScript, html in .net development.
- Wrote business logic code in C# code behind files to read data from database stored procedures.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Wrote store procedures to generate account statements.
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
Environment: SQL Server 2008/2005, SSIS, SSRS, Visual Studio, .NET
Confidential
Jr. SQL Server Developer
Responsibilities:
- Designing the system architecture.
- Created new tables, written stored procedures for Application Developers and some user defined functions.
- Created SQL scripts for tuning and scheduling.
- Performed data conversions from flat files into a normalized database structure.
- Created and managed users, roles and groups and handled database security.
- Created Triggers to enforce data and referential integrity.
- Defined Check constraints, Business Rules, Indexes, and Views.
- Involved in migration of SSRS from SQL 2000 to SQL 2005.
- Created custom and standard reports using Crystal Reports.
- Used SQL Server to create stored procedures, views and calling through the application.
Environment: JAVA, SQL Server 2005, Visual Studio 2005, Crystal Report