Shivamallika Penubadi

Phone: 925-***-**** • Email: ad3ynl@r.postjobfree.com

SUMMARY

* ***** ** ********** ** business intelligence and data visualization design, development, management and implementation.

Extensive Tableau, Power BI experience in enterprise environment, worked with various versions of tableau as a developer both on Tableau Desktop, Tableau Prep and Published on Server and Power BI Desktop.

Experience in creating year over year and quarter over quarter, YTD, QTD, MTD, ROY dashboards in no time.

Experience in creating customized reports using various chart types like Text table, Bar Charts, Tree Maps, Waterfall, Pie Charts, Heat Maps, Line Charts and Combination Charts using Tableau.

Designed and Developed complex Parameters based calculations, Aggregate functions, Filters to visualize the KPI’s in most efficient and appealing way.

Developed dashboards utilizing advanced Tableau functions and features.

Experience in advanced Tableau features including calculated fields, LOD, Parameters, table calculations, joins, data blending, dashboard actions.

Experience in configuring reports from different data sources using data blending.

Have developed Repots, Scorecards using Power BI Desktop.

Experience with Tableau Prep’s connects and unions to integrate different data sources into a single data source.

Experience in writing SQL complex queries, stored procedures, triggers, functions, views, index, relational data models and involved in maintaining data integrity in various tables using SQL joins and writing sub queries.

I am passionate about studying how to improve performance, and I am seeking to leverage data analytical skills to improve corporate performance as a data analyst.

Experience with Excel functions like VLOOKUP’S and Pivot tables.

Good hands-on experience in writing complex SQL queries, performance tuning or reports.

Expertise in all aspects of Software Development Lifecycle (SDLC) from requirement analysis, design, development coding, testing, Implementing and maintenance including Agile and Waterfall methodology.

Good Business Analytical skills.

Result oriented, self-starter looking for a challenge, ability to rapidly learn and apply new technologies and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Linux, Unix, Windows XP/2007/2010, Mac OS

Dashboard Tools: Tableau Desktop 2021.x -2018.x, Tableau Public, Tableau Prep, Tableau Server.

Languages: MSSQL, T-SQL, Python, C

Databases: ORACLE, SQL Server, MS Access

Methodologies: Agile, Scrum, Waterfall

Reporting Tools: Tableau, Power BI

Application Packages: MS Office, Microsoft SharePoint Service, Excel, Outlook

EDUCATION:

Master of Business Administration in Human Resource and Finance from Osmania University –Hyderabad, India – 2006

Bachelor's in computer science from Bhavan’s Degree Collage – India – 2004

WORK EXPERIENCE

United Health Group (Optum). Nov 2022 – Feb 2024

Tableau Developer

Gathered business requirements, interacted with strategic development team, business analyst to analyze business needs and develop technical specifications.

Designed, built and maintained beautiful and functional visualizations (reports and dashboards).

Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.

Trouble shoot and solve Ad-Hoc requests by solving problems in previously developed dashboards.

Perform data validation on various Tableau dashboards and solve data discrepancies.

Works closely with the data service team to resolve data reporting issues or enhancements to the currently published data sets.

Published dashboards, created scheduled tasks, alerts and subscriptions on Tableau Server.

Participated in daily standup with clients on with daily design and development efforts.

Ensuring that scheduled reports run in a timely manner and user requests are answered.

Good working knowledge of databases, RDBMS concepts, SQL Server, Oracle.

Implemented row level security for tableau dashboards and used various advanced table calculations for the dashboard.

Fannie Mae, Washington DC, (Remote from CA). May2022- Sept2022

Tableau Developer

Developed dashboards to track key performance indicators (KPI’s), identified trends, and monitored company initiatives on business operation results and line of business weekly, monthly, and quarterly.

Built predictive patterns and trends, related to investigation and root cause determination of business operations, operational functions, workflow, processes, and other business-related issues.

Involved in business meeting to gather requirements for building reports.

Worked with the backed database team to create the fact tables needed for the creation of the dashboard.

Have working knowledge of Tableau Prep to facilitate quick data cleaning, reshaping and preparing for data analysis.

Transforming business questions into fact-based analysis that delivers clear insights and actionable recommendation.

Developed various dashboards prototype for the future uses and conversion of current excel reports into tableau.

Developed various tableau dashboards prototypes as templates for onboarding future use cases and migrated excel reports into tableau dashboard.

Created complex dashboards using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.

Ensuring data management impacts are appropriately assessed, documented and implemented through successful change management; providing data-driven decision support for better outcomes

Performed Data Validation by coordinating with Database teams.

Verizon Wireless, Walnut Creek, CA March 2013 – March 2015

Tableau Developer

Created visually impactful dashboards in excel and tableau for data reporting by using pivot tables.

Extracted interpreted and analyzed data to identify key metrics and transformed raw data into meaningful actionable information.

Used analysis and visualization tools such as SQL, Excel and tableau to analyze data and draw accurate and reliable conclusions to provide insights to upper managements.

Optimized SQL scripts to improve the efficiency on the database and was involved in the performance tuning for tableau Dashboards.

Benetech, Palo Alto, CA Feb 2011 – April 2012

Tableau Developer

Optimized data collection procedures and generated reports on a weekly, monthly and quarterly basis.

Used Microsoft Excel to Create pivot tables and pivot reporting.

Created, validated and sent daily, weekly, monthly reports to clients.

Prepared reports that interpreted customer behavior, market opportunities and conditions, marketing trends, results and investment levels.

Mining data from various sources and organizing the mining data into easily readable information.

Interpreting data sets and testing for reoccurring patterns to recognize trends and make calculated predictions.

Contact this candidate