Experience in writing SQL queries using Joins, Views, Triggers, User Defined Functions, Stored Procedures.
Experience in writing T-SQL queries involving command shell and Cursors, which are used to read/write data from/into Excel, CSV, and notepad.
Experience in developing extensive reports using Tables, Matrices, Charts, Graphs, URLs, Reports, Sub reports.
Good knowledge on Salesforce Administrations – Tabs, Objects and relations between objects, Profiles, Roles, Object/Field/Record Level Access, Sharing Settings, Page Layouts, Rules, Sales Process, Reports & Dashboards, Validators, Triggers, App Exchange.
Experience in creating SSAS Cubes, Cube Partitions, Cube Aggregations.
Experience in creating cube Partitions Dynamically using SSIS script components.
Improved performance by creating Proactive Caching Techniques in Cubes.
Experience in creating Paged SSRS Reports using bookmarks.
Good knowledge in MDX queries, and cube dimension attributes and had coded few basic MDX Queries.
Experience in creating configuration files in packages for better reusability.
Created Checkpoints and Breakpoints in Packages for easy troubleshooting.
Created SSIS packages with SharePoint, Excel, and Oracle DB as sources.
Experience in Running Cubes from SSIS Packages.
Created reports which reads data from various sources like Excel, Oracle DB, Cubes.
Experience in creating reports using Power Pivot, Report builder.
Experience in creating High Level dashboard and complex Drill Down, Drill through reports, Ad hoc reports. (Using SQL and SSRS).