4/11/2023 0 Comments Tableau filter actions server![]() ![]() Generating insights by analyzing actual department performance versus targeted department performance.Analyzing huge data from multiple sources such as SFDC, Oracle, and Cognos to formulate and develop insights to day to day basis.Other Tools: Microsoft office suite, Photoshop CS5.Įnvironment: MS SQL Server, MS Access, Oracle JD Edwards,, IBM Cognos SQL Tools: SQL Server Data Tools and Business Intelligence Development Studio. MSBI Tools: SQL Server Reporting-SSRS, Integration- SSIS Services. Worked with various cross functional teams and ability to handle multiple tasks concurrently.īI Reporting Tools: Tableau, Microsoft Power BI, Excel.Team player with good communication and interpersonal skills.Good Understanding of Technical trends, architectures and highly motivated to know more about the latest technology update.Expertise in Report Caching and Subscriptions including Standard and Data-Driven Subscriptions.Experience in optimizing the query by creating various Clustered, Non-clustered indexes.Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS).Expertise in creating complex SSRS reports against OLTP, OLAP databases.Experience in Database Normalization, Designing, Creating Indexes, Developed Queries & T-SQL Scripts in MS SQL.Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.Experience in Creating Tables, Views, Complex Stored Procedures, Triggers to facilitate efficient data manipulation, data integrity and other T-SQL (DDL, DML) statements for various applications.Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services ( SSIS), Analysis Services ( SSAS), and Reporting Services ( SSRS).Worked on pilot batch team for getting trained, testing and implementing Power BI.Multiple levels of Hierarchies are implemented such as Sales, Product, Partner, Customers and Service Hierarchy etc.Analyzed the database and provide detailed information on their operational and Forecast for future years.Extracted reports from various BI tools and connected as datasource.Connected different data sources to Tableau like Oracle JD Edwards,, IBM Cognos, SQL Server & Excel for live connection on various Dashboards.Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Working knowledge in gather external data to Tableau from different sources like Oracle JD Edwards,, IBM Cognos, SQL Server & Excel, for data visualization.Performed LOD Calculations on the worksheet for micro granular reporting.Designed and developed many complex reports based on the requirements using complex calculations like Row - level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines using Tableau 10.3 to 2018.1.Used Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.Worked extensively with Advance analysis like Actions, Calculations, Parameters, Background images, Maps, Trend Lines and Statistics. ![]() Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions.Over 6+ Years of IT experience which includes Design, Development, Integration, Implementation and Maintenance of Business Intelligence Platforms.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |