? Experience in Design,Analysis and Development of Relational Database. ? Solid Experience in PL -SQL/ T-SQL. ? Experience in Writing Queries,creating Tables,views,Procedures, Triggers and User defined functions. ? Involved in the ETL phase of the project. ? Creating packages at SQL Server Integration Service platform. ? Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Send Email Task and Data Flow Task. ? Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns Conditional Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse. ? Scheduling the packages using SQL SERVER AGENT. ? Experience in Creating Logging,Checkpoints and Deploying the packages. ? Created data source, data source views using SSAS. ? Developed OLAP Cubes, Dimensions, and added Measure groups. ? Experience in creating KPI’S , calculated members, Named set for the SSAS . ? As per requirements developed the reports in the form of Matrix, Table Using SQL Server 2008 Reporting Services. ? Experience in writing MDX queries in SSAS. ? Developed parameterized reports including multi-parameters, Sub reports and Cascading parameters. ? Generated the Reports Weekly and Monthly basis as per the Client Requirement. ? Experience in creating Drill Down ,Drill Through and Cascading parameters in SSRS. ? Experience in POWER PIVOT and POWER VIEW. ? Deploying the reports to the Report Server,Enabling Subscriptions. ? Experience in Data Analysis, Data visualizations using Tableau Analytics 8.3. ? Experience in creating wonderful visualizations to help clients to take better decisions. ? Created adhoc reports as per the users/client