Over 6 years of experience in analyzing, designing and developing various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2012 Reporting Services (SSRS) , Analysis Services(SSAS) and SQL Server Integration (SSIS)
• Ability to pick up and deliver new technology very quickly along with effective analytical, problem solving and debugging skills
• Creating Tables, Joins, Sub Query, Stored Procedures, Functions, Views and Indexes.
• Expertise in SSRS (Designing various reports like tabular , matrix , drilldown, Parameterized, Linked reports, Sub reports and drill through)
• Providing reports to client according to their requirement using oracle SQL queries using joins, sub queries, inline views to retrieve data from database.
• Extensive experience in using T-SQL (DML, DDL) in SQL Server 2012 platforms.
• Expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration.
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.
• Proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, multicast, Union All, Bulk Insert, Merge Join, Merge and SCD to load data into SQL Server destination.