SQL Server, SSIS Developer
Select Project to Invite
* A dynamic professional with 10+ Years of experience in Database Design, Development, Administration, ERP Planning, Implementation, Support of Client-Server environment using SQL Server/ Crystal Report. * 7+ Years’ Experience in Microsoft SQL Server Database Design, Development, Programming, Maintenance with Performance tuning, 4+ Years of Experience In Business Intelligence (SSRS/SSIS) * Microsoft Certified Professional (MCP) in Microsoft SQL Server Business Intelligence Development & Maintenance (MSBI) * Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Keys & Constraints, Normalization techniques on database Tables. * Expert in creating and using Stored Procedures, Views, User Defined Functions. * Experienced in Installing, Configuring, Handling Multiple Instances & Databases of Microsoft SQL Server. * Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers. * Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency. * Expertise in SSRS 2008 R2 and Crystal Reports (MIS) 8.5/9.0/11. * Extensively worked on all types of reports like Tablix, Matrix, Charts (Daily, weekly, Monthly, Quarterly, Yearly) and created different Drilldowns, Drillthrough, Subreports, Linked Reports, Cache & Snapshots Reports and scheduled via subscription. * Developed, deployed and monitored SSIS 2008R2 Packages * Used Control Flow Tasks like For Each Loop Container, Sequence container, Execute SQL Task and Data Flow Task in Designing packages. * Experience in Data Flow Transformations like Derived Column, Conditional Split, Data Conversion, Union All, Merge Join, and Lookup and so on.