• Involved inrequirement gathering/analysis, Design, Development, and Testing of various Reporting and Analysis Projects.• Connected to different data sources such as Teradata, Amazon Redshift, SQL Server, Excel to gather the required data.• Written SQL queries to validate the data displayed on the dashboards.• Created various complex workbooks by connecting to multiple data sources using data blending.• Created Text tables, side-by-side bars, Scatter Plots, Tree maps, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps per deliverable specifications.• Created Excel files using various formulas and used it in dashboards when a dedicated table was not available in DW for that specific information, as it is easy to update for frequent changing data.• Consistently attended meetings with different teams inside the organization to acquire functional business requirements to build SQL queries that would be used in dashboards, to satisfy the teams' needs.• Refactored existing batch jobs and migrated existing legacy extracts from Informatica to Python based micro services and deployed in AWS with minimal downtime.• Created AWS Security Groups for deploying and configuring AWS EC2 instances.• Worked with team of developers on Python applications for RISK management.• Developed Python/Django application for Google Analytics aggregation and reporting.• Worked with multiple teams such as ETL/BI, Strategy and Business Development, Ad Operations, and Sales and Marketing inside the organization to create Tableau workbooks per their needs.• Converted existing Business Objects reports into Tableau dashboards and embed views to SharePoint.• Created dashboards using various filters, groups, bins, sets, hierarchies, reference lines, trend lines, forecast, parameters, level of detail (LOD) calculations, and other complex calculated fields.

Working on the existing dashboards maintainence and creating new reports based on the client requirement by using tableau desktop.

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.• Created views in Tableau Desktop in Agile environment, that were published to internal team for review and further data analysis and customization using filters and actions.• Created dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop.• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.• Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.• Gathered Business Requirements, interacted with Strategic Development Team, Business analyst to analyse business needs and developed technical specifications.• Installed, Configured and setup Tableau environment in the organization.• Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.• Developed Templates for AWS infrastructure as a code using Terraform to build staging and production environments.• Created AWS Lambda architecture to monitor AWS S3 Buckets and triggers for processing source data.• Used Tableau API such as Python and Web Data Connector and Performed Predictive Analysis.• Generated Python Django Forms to record data of online users.• Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting.• Creating reports and infrastructure to show migration activities by monthly release, business functions and IT projects.• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.• Worked on converting map shape files to tableau readable CSV format using R software• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool.