 Responsible for working with all levels throughout the organization in order to gather and document the organizational needs. Manage current opportunity intake tool and process Built compelling, interactive dashboards in Tableau that answer key business questions. Audited the datasets and data analyzed as required ensuring their continuity, accuracy and consistency. Created meeting with the business users to understand more on requirement both. Prepared data in tableau prep. Understands business needs and translates them into business and functional requirements. Works alongside IT support to translate functional requirements into technical designs when required Reviewed, assessed and promoted adoption and standardization of Tableau support solutions. Generated insights out of voluminous and complex datasets and built story lines. Develops and maintains detailed documentation of the team assets to ensure effective development, maintenance and support Designed excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business. Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. Establish and manage timelines, project priorities and handle multiple/concurrent projects. Communicates project updates to key stakeholders in a timely manner Develop and drive meeting cadence with customer groups based on demand, value, etc. to provide status, knowledge shares, project pitches, etc. Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler.

Interact with Business users and Gather Requirement according to Brd requirement for visualization Come up with problem statements based on initial client meeting and follow-up discovery sessions. Publish interactive and visually appealing Dashboard. Setup meeting with Business users and stake Holders to understand how or what they want on the dashboard. Peer review dashboard of developers. Guide colleagues and junior consultants in terms of prescribing suitable solutions with an understanding in limitations of toolsets and available data. SQL query writing. Create cross database Join or blending or any other type of join as per business Requirements. Write Dynamic Store Procedure to move data from Staging to Application. Use SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries. Schedule data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately. Test dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data. Use action filters and and Tableau interactive tools. Track and monitor project through Jira Manage Developers progress on project basses Setup meeting with Business users and stake Holders to understand how or what they want on the dashboard. Create cross database Join or blending or any other type of join as per business Requirements.

• Arrange Jira Dashboard and run weekly standup Meeting• Arrange Request /Ticket as per importance• Peer Review Dashboard and Test Tableau Dashboard Functionality on BRD specification• Enhance Tableau Dashboard as per Stake Holders /Business users Requirements• Create New Tableau Dashboard as per Business requirement• Interact with Business users /Stake Holders for BRD and Gathering of Requirements• Query writing• Model Data for visualization purposes• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.• Data Blending from different Data sources• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements• Optimized existing stored procedures and various T-SQL queries• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler• Added more audits and alerts in SSIS Packages in case of package failure• Big Data experience Data Manipulation

• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements• Optimized existing Stored Procedures and various T-SQL queries• Wrote Dynamic Store Procedure to move data from Staging to Application• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction• Improved Performance by creating Clustered and Non-Clustered Indexes and by Optimizing the T-SQL statements using SQL profiler• Added more audits and alerts in SSIS Packages in case of package failure• Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data in to the tables from Text files• Managed index, statistics and optimize queries by using execution plan for tuning the database• Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc. to clean data• Developed Master Child package using variables and Execute package task in SSIS• Scheduled jobs to call the packages and Stored Procedures as per business requirement• Deployed, tested and scheduled SSIS packages using SQL Agent• Deployed and scheduled Reports using SSRS to generate all reports including current status

Cashboards publishing dashboards, report scheduling using Tableau Server, demoing dashboards, and creating user manual• Meet frequently with Business Users to gather requirements and/or user stories, document requirements• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.• Created Custom Hierarchies to meet the Business requirement in Tableau.• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.• Created Web reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.• Created sheet selector to accommodate multiple chart types like Bullet charts and Stack bars etc. in a single dashboard by using parameters.• Displayed multiple measures like Dual Axis and Blended Axis for consolidated data contents.• Worked on understanding of relational database structures, theories, principles and practices.• Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.• Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries.• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.