- Having 5 years of experience in Microsoft Business Intelligence Tools (SSIS) and Sql server.
- Experience with SQL Server and T-SQL in constructing Tables, user functions, views, Indexes, joins, sub queries and Stored Procedures.
- Managed performance and tuning of SQL queries and fixed the slow running queries in production.
- Experience in extracting data from heterogeneous data sources, transforming and loading (ETL) process using SQL Server Integration Services (SSIS).
- Created solutions, projects and packages and managing them.
- Involved in various tasks such as Control Flow (Execute Sql task, For each loop Containers, Data Flow task, File System etc) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc..
- Worked with logging and error handling in various projects.
- Involved in performance tuning at different levels (Package, Source, Destination and Transformation).
- Created UNIT test cases and prepared Unit test results.
- Managed clients and collected requirements from client & converted them to functional requirements.
- Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
- Designing and developing reports using SSRS tool.
Created the Drill down, Drill through, Dashboard and sub reports using SSRS as per the requirements
Role : Database Developer and SSIS Developer
Technologies : SQL Server 2008R2, SSIS , SSRS.
CDW (Computer Discount Warehouse) is a leading multi-brand technology solutions provider to business, government, education and healthcare organizations in the United States.
· Analysing and Understanding the business requirements
· Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
· Written user defined functions and stored procedures. Debugging and tuning the procedures.
· Populating the Data from different source systems into DW using SSIS.
· Created Unit test cases and Implemented unit test results.
· Involved bringing the data from various sources to tables.
· Involved in creating the Drill down and Drill through using SSRS as per the requirements.
· Involved in Designing and development of Trend and performance analysis reports using Bar chart, Line Chart using SSRS.