Sirisha Nigidala

E-mail: ad1t7k@r.postjobfree.com Phone: +1-713-***-****

LinkedIn: linkedin.com/in/sirisha-n-56720a134

Summary:

Over 9 years of experience in IT with Business Intelligence tools development, support and admin activities with expertise in end-to-end Data Analytics pipeline.

Extensive knowledge in Tableau Desktop, Tableau Server, Power BI, SQL scripting, analytical model building using R & Python and experience in using statistical methods for data analysis.

Gather requirements from client and build reports using different data sources and design dashboards with the use of Business Intelligence tools like Tableau and Power BI.

Good at Tableau Server Architecture and has expertise applying business rules, data validation, installation, configuration and administration of the Tableau server.

Plan for the migration, considering factors like data security, scalability, and cost and migrated Tableau Server from On-Prem to AWS Cloud Platform.

Experience in understanding and implementing various phases of SDLC, including requirements gathering, design, development, testing, deployment, and maintenance.

Conducted presentations and knowledge transfer sessions on Tableau Desktop and Tableau Server.

Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Implemented machine learning models in R and Python programming. Implement robust Tableau security measures to ensure data access control and privacy.

Strong foundation in RDBMS, having worked extensively with various relational database systems.

Designed and optimized relational database schemas for complex applications, ensuring efficient data storage and retrieval.

Proficient in writing complex SQL queries, including joins, subqueries, and aggregations, to extract meaningful insights from large datasets.

Successfully implemented data integrity constraints, such as foreign keys and unique constraints, to maintain data accuracy and consistency.

Played a key role in database performance tuning initiatives, improving query response times and overall system efficiency.

Proficiency in writing complex SQL queries for data retrieval, manipulation, and reporting.

Communicating with customers to analyze historical data and identify KPIs. Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 10 desktop/Server.

Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.

Disaster Recovery setup, including Backup Primary setup and configuration.

Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.

Restricting data for users with the help of User filters and creating reference lines based on parameters or measure value.

Education:

Bachelors – Information & Technology (Sphoorthy Engineering College (JNTU), Hyderabad – India (2008-2012)

Masters of Business Administration – HR & Marketing (TKRIMS (Osmania University), Hyderabad – India (2012-2014)

Achievements:

Received SPOT AWARD in Jan 2022 from Deloitte.

Received PAT ON BACK Award and many appreciations from clients.

Received e-Card’s from client for building a dashboard on short notice.

Certifications:

Tableau Desktop Specialist https://www.credly.com/badges/2d1e861c-1d26-4795-a0af-2f34812d30d0/linked_in?t=s4zt8z

Python for Data Science https://www.credly.com/badges/f5d2dfe0-a39c-4c82-9e63-15e4b868bcb8/linked_in?t=s4zt4v

Skill Matrix:

Reporting Tools: Tableau Desktop (10.5 to latest version), Tableau Server, Power Bi, Microsoft Power Query, PowerPivot, Alteryx

Programming Languages: MySQL, R programing, Power shell, Python, T-SQL

Database: MSSQL, PL/SQL, SQL Server Management Studio (SSMS), Microsoft SQL Server 2008/2008 (R2)/2012/2014/2016, Redshift, Oracle, and NoSQL database, Cloudera Impala and/or Hive

Software Methodology: Agile – SCRUM

Operating System: Windows, Linux

Incident Management: Service Now, RITM’s, INC’s

Professional Experience:

Deloitte – Texas, USA

Sr. Tableau Developer April 2020 – Till date

Responsibilities:

Proficient in Tableau for creating interactive HR data reports and dashboards, enabling data-driven decision-making and analysis.

Experience with Agile methodologies, participating in ceremonies and executing user stories within cross-functional teams.

Expertise in ETL methods for data validation, ensuring high data quality and reliability for HR data.

Strong commitment to data accuracy, completeness, and transformation to meet business requirements.

Collaboration skills honed through Agile ceremonies, communication with stakeholders, and teamwork.

Understanding of data governance principles and data normalization for efficient organization.

Database modeling for HR requirements, translating business needs into effective solutions.

In-depth knowledge of database concepts and Tableau architecture for advanced reporting.

Proficient in creating HR data visualization, report, and dashboard creation in Tableau Desktop 2022.2.

Creation of PowerShell alerts script for Tableau processes failures.

Data visualization expertise with a variety of chart types in Tableau.

Experience in data blending, user and group administration, and Tableau Server tasks.

Effective management of day-to-day reporting activities within scope, budget, and schedule constraints.

Analyzed large HR data volumes to develop complex reports and insights for clients.

Preparation of unit test cases and test plans for HR reports and designed templates and filters for grid and graph mode reports.

Creation of technical dashboard documents using Tableau Desktop based on business requirements.

Building and publishing Tableau reports with complex calculations, filters, and parameters.

Improved Tableau report performance through extracts and filters.

Published and scheduled dashboards in Tableau Server, ensuring up-to-date data and created custom SQL queries to pull data into Tableau Desktop.

Assisted users in publishing and collaborating on HR reports via web browsers and embedding Tableau views.

Experience in creating Tableau to Hadoop dashboards using Cloudera Impala and/or Hive.

Familiarity with Business Objects universes and Webi reports and created interactive customized HR dashboards and stories.

Built, published, and scheduled interactive HR reports and dashboards using Tableau Server and managed report schedules and daily server tasks.

Executed and tested HR queries and reports before publishing and gathered and analyzed HR requirements, interacting with customers to ensure data accuracy and completeness.

Validated HR data for each report and conducted thorough report reviews.

Environment: Tableau Desktop 2022.2.3, Tableau Server 2022.2.3, SharePoint, SQL, Cloudera Impala and/or Hive

Sailotech Private Limited – Hyderabad, India

Tableau Developer November 2016 – March 2020

Description: This project involves call center data, dashboards represent the behaviour of customers for particular periods. Understanding all the actions of customers for every channel and segment. Represents the growth level of change for different regions using filled maps.

Responsibilities:

Requirements gather from client and build reports using different data sources. Worked on Reports from requirement gathering to Report Development and involved in migrating it to production.

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, Reference lines, bands, Distribution, Trend Lines.

Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards.

Connected to MS SQL Server 2012 directly to pull data into Tableau and created extracts.

Developed database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Created parameters to show MoM, QoQ and YoY change of score in a single selection.

Build a hover functionality for table chart values to show the score for previous six months for selected period that presented in a line graph.

Used different charts line bar, table charts, maps and represented the values with different shapes like arrows and boxes with different colors as per user requirement.

Involved in scheduling and publishing dashboards to tableau server.

Modify the format and structures according to the end-user requirements and created sets and parameters to improve the performance.

Use maps extensively to check various KPI’s at different geographical locations and developed technical specification document.

Extensive experience in handling performance-based issues while handling huge volumes of data.

Evaluated Data Management and Data access processes for gaps, and inefficiencies and provided recommendations for improvement.

Proficient in data quality analysis of Tableau dashboards. Expertise includes all levels of Quality Assurance and Testing from the development stage, software requirements definition, and documentation to User Acceptance Testing.

Technologies: Tableau Desktop 2019.1, SQL and Tableau server

Covalense Global – Banglore, India

Junior Programmer Analyst June 2014 – October 2016

Description: In this project, built dashboards to represent the transactions of customers in different modes, detailed summary of transactions done by mobile user enrollments and user activities.

Responsibilities:

Building Interactivity in dashboards using actions and filters to look at the selected data and to have proper flow.

Worked with Aggregate functions and Mapping Functions.

Designed the donut, dual axis, blended axis, tree map, bar graphs and customized visualizations.

Designing the worksheets and configuring the dashboards with dashboards objects.

Apply filters at the data extract level to reduce the data set size and improving the report performance.

Functional testing of dashboards, fixing bugs, helping the client with the feasibility of product and working on different workarounds to achieve expected functionality. Develop (create new and update existing), publish, schedule reports and dashboards.

Experience in designing, implementing, and executing test cases.

Assist business users with using published reports/dashboard and performing ad hoc data analysis.

Work collaboratively with team members including project managers, solution architects and business analysts.

Responsible for end-to-end development of new Power BI reports and maintaining and updating existing reports.

Experienced in writing advanced SQL queries for the creation of views/tables, functions, and stored procedures.

Skilled for query performance tuning and writing ad-hoc queries.

Engage with end users to gather requirements, understand them, and turn them into engaging visuals in Power BI.

Collaborate with database engineers and application engineers when there are changes or issues related to data sets feeding the Power BI reports.

Experienced implementing and managing row level security.

Technologies: R programing and PowerBi, PowerQuery

Contact this candidate