Agarwal A.
Tableau Reporting, MS SQL, Oracle PL/SQL, SSIS and Business intelligence professional with 6+ years intensive experience and having a good hand on Experience for data mining, data warehousing, data Integration, data Analysis and data reporting
India | Asia/Kolkata ()
Part-time:10-30 hrs/week
ABOUT ME
Technology Analyst and Certified Tableau Developer with 6+ years of Business Intelligence Experience in spanning across various Database Platforms for Data Integration, Data Warehousing, Data Visualization with exposure to financial and banking domain primarily with Mortgage Technology and Enterprise Data Management. Working with the client to understand requirements closely and managing the team of 25 people by working as a Team Lead to meet the client expectations. Experience in Oracle 11g and MS SQL 2008 r2 Server database PL/SQL and SQL, experienced in Creating database design and doing database modeling. worked in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and modeling Transactional Databases and Data Warehouse. working experience in PL/SQL Packages, Stored Procedures. Experienced in tuning long running SQL queries for better performance tune them by analyzing Query Execution plan, statistics, Indexes, joins and Query hints. Hands on experience in using SSIS 2008 r2 to create workflows for ETL and executing Stored procedures in the DB and also to perform ETL. Design and deploy rich Graphic visualizations with Drill Down menu option, Parameterized reports and actionable interactive reports and dashboards using Tableau. knowledge in various reporting objects, Level of Detail (LOD) calculations, Forecasting and storytelling in various versions of Tableau 7.x/8.x/9.x/10.x . Proficient in blending data from different sources and developing reports from the same on Tableau. Extracting data from different sources connecting them and used the same to create dashboards. Improved Reports performance in tableau using extracts and optimizing them. Experience in interacting with various business stakeholders and able to gather the business specifications and translate into data visualizations for effective decision making. Experience in using R integration in Tableau for Sentiment Analysis. End to end experience in designing and deploying data visualizations using Tableau. Extensively experienced in analyzing business requirements and specifications, development and execution of Test Plans, Test Scripts and Test Cases and extensively used Quality center for defect tracking and linking them with test cases.