Varun Krishna Makineni

● Interact and gather requirements from clients, product owners, stakeholders, and business users, and analyze, and determine the feasibility.

● Connect to various data sources, implement necessary relations/joins/unions/blends, and write custom SQL queries wherever required.

● Data mining, data cleaning, and preparing complex data sets for analytics and visualizations.

● Create data visualizations such as text tables, geographical maps, pie charts, bar charts, line graphs, word clouds, histograms, tree maps, donut charts etc.

● Design and develop ad-hoc tableau reports, dashboards and stories containing filters, groups, parameters, sets, actions, and hierarchies based on requirements.

● Create calculated fields and LOD expressions, Year-to-date (YTD), Month-to-date (MTD) and other calculations.

● Format reports and align various dashboard objects such as containers, text, images, blank, download etc. as per client requirements.

● Incorporate row-level security and user filters to achieve data confidentiality.

● Handle unknown geographical locations on maps using custom geocoding and include trend lines and reference lines on visualizations when required.

● Carry out testing of dashboards and schedule, refresh monitor extracts/hyper on server.

● Publish workbooks and data sources across various environments such as Dev, QA and Production and provide support to teams for migration.

● Identify hidden patterns, trends, and meaningful insights from raw scattered data and communicate to clients to enhance productivity, quality, and business decision-making capability.

● Perform technical reviews and implement performance tuning and optimization techniques to enhance the performance of reports.

● Developed a Proof of Concept (POC) by connecting Tableau to the AWS Redshift and created various charts showing different metrics.

● Identify key areas for automation and implement them.

● Connect to tables, views, and stored procedures, and create dynamic reports, and dashboards using visuals like text tables, bar graphs, word cloud, histograms, tree map etc.

● Make reports more interactive with the use of filters, hierarchies, parameters, actions etc., and use LOD expressions and other calculations wherever needed.

● Handle unknown geographical locations on maps using custom geocoding.

● Carry out deployment of dashboards, stories, and migration activities from the development environment to test and production.

● Embedded row-level security and user filters to achieve data confidentiality in reports.

● Make reports accessible to clients by Publishing on the server, refreshing, scheduling and giving necessary permissions.

● Implement enhancements to the existing reports and assist with user testing when applicable.

● Research and implement the latest features and visuals in tableau workbooks.

● Follow the best practices and integrate the developed reports into the existing environment.

● Prepare necessary documentation for future reference, find key areas of automation, and implement them.

● Work with business stakeholders, application developers, production teams and cross-functional units to identify the business needs.

● Design, develop, and maintain databases and database objects, such as tables, views, stored procedures, functions, triggers, and indexes using DML, and DDL commands.

● Extensively used joins and sub-queries to simplify complex queries involving multiple tables.

● Implemented and maintained database security measures, including user access and permissions ensuring data confidentiality and compliance with industry regulations.

● Performed unit tests on all code and packages.

● Monitored database performance and troubleshoot issues, reducing system downtime by 10% and improving overall system reliability by 5%.

● Collaborated with cross-functional teams to develop and maintain reporting solutions, providing actionable insights to stakeholders, and driving data-driven decision making.

● Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

● Involved in the complete Software Development Life Cycle (SDLC).

● Documented and maintained database system specifications, diagrams, and connectivity charts.