Praneetha Maruvu

adyttn@r.postjobfree.com +1-720-***-****

PROFILE

Around 6 years of experience building business intelligence applications using Excel, Databases, ETL, Reporting, Data warehousing, Data analysis, Data modeling, Data integrations and Production support. Love learning new things and willing to expand my knowledge on Cloud Computing & Data Mining.

SUMMARY

Clean, organize, analyze and visualize data using BI technologies such as SQL, ETL and Reporting

Develop data pipelines using ETL tool Matillion & Reporting using Excel and Tableau

Successfully managed large-scale warehouses in Snowflake, ensuring smooth operations and optimal performance

Proficient in utilizing Oracle Development Tools (ODT) for application development, database management, and performance tuning

Successfully optimized database performance by fine-tuning SQL queries, indexing strategies, and database configurations using ODT

Expert in query optimization and performance tuning techniques, resulting in significant improvements in query response time and overall system efficiency

Developed reports, KPls and dashboards using Tableau Desktop and Tableau Server

Perform ad-hoc analysis to determine opportunities for meaningful Enterprise-wide KPIs

Work on multiple databases such as MySQL, SQL Server, PostgreSQL and experience with PL/SQL

Knowledge on cloud-based data warehouses Snowflake and AWS Redshift

Requirements gathering, analysis, design, development of OLTP and OLAP systems

Worked on dimensional data modeling using Star and Snowflake schemas

Build data lake and develop ETL pipelines using AWS Services – Redshift, EC2, S3, Lambda, Glue

Analyze information from large structured and unstructured such as XML, JSON datasets

Well-versed in enabling data profiling, data quality, SQL and ETL optimizations, performance tuning

Experience working with data and statistical analysis using Excel pivot tables, data cleaning, formulas

Familiar with Excel macros and DAX functions such as vlookup, sumifs, averageifs, date, match etc.

Build pipelines using Python scripts using libraries such as pandas, API requests, numpy, scipy etc.

Skilled at writing complex queries and presenting the findings to business users

Worked on automations, debugging, and troubleshooting and production support for BI applications

Involved in unit and integration testing of Tableau reports and data warehouse applications

Experience working in Agile methodologies & domains such as Ecomm, Retail etc.

Knowledge on data design principles and software development life cycle (SDLC) phases

Schedule Tableau workbooks and ETL jobs using Crontab, Task schedular and Matillion

Document data mappings, functional specifications, activity flows and data flow diagrams

Experience working on large scale data and SQL implementations

TECHNICAL SKILLS

Databases

Snowflake, Redshift, MySQL, Oracle, SQL server 2012, PostgreSQL

Reporting Tools

Tableau 2021.4, Qlikview 11, Power BI, Cognos 11.0.6, Splunk 6.6.3

ETL Tools

Matillion, Informatica 8.1.1/10.2, Pentaho 7.1, Datastage v8.5/9.1

Data Analysis Tools

Python, MATLAB, SAS, Excel, Alteryx

Other Technologies

Amazon Web Services, Unix, JavaScript, Java, Jira, Github, REST APIs, Postman

PROFESSIONAL EXPERIENCE

Tableau Developer/Data analyst (Client: United Airlines) Dec 2022 – June 2023

Designing, developing and publishing visually rich and intuitively interactive Tableau workbooks

Develop highly interactive data visualization reports and dashboards in Tableau using data blending, extracts, calculations, filters, actions, parameters, context filters, sets, groups, aggregate measures, etc.

Develop a dimensional data model based on application requirements and create reports in Tableau using charts such as dual-axis, bar graphs, scatter plots, pie-charts, heat maps, bubble charts, treemaps, box plots

Proficient in designing interactive dashboards in Tableau by extensively using functionalities such as LOD’s, Custom Table Calculations, Clustering, Set Actions, Parameter Actions

Created Dashboards by creating Filter Actions and URL actions using Field and Filter Values

Experienced in Tableau working with different data sources likes SQL server, Snowflake, Amazon Redshift

Combine, shape, and clean data for analysis using Tableau Prep builder

Taking Care of Tableau server tasks: Publishing reports, changing data sources, Scheduling reports as per user requirements, and monitoring server activities.

Experienced in Implementing Row level data security in Tableau dashboards

Translate business requirements into action by devising dashboards using Tableau

Worked on Alteryx to access multiple sources and structures of data and ETL processes

Data Reporting Analyst (Client: Nordstorm) May 2017 – Feb 2022

Worked on a migration project from on-prem database to cloud data warehouse

Performed data analysis comparing SQL Server and cloud database to identify the database objects that needs to be migrated for reporting

Collaborated with cross-functional teams to design and implement data models, ETL pipelines, and data integration processes within the Snowflake environment

Assisted in the implementation and configuration of Snowflake warehouses, ensuring optimal performance and scalability for data processing and analytics.

Worked on creating views, tables and functions to load data objects to Snowflake database

Worked on Tableau to create ad-hoc reporting on customer, marketing, sales data to business users

Worked with various business stakeholders, architects, developers and data engineers to understand the requirements and transform into data solutions

Worked In data models, stored procedures, triggers, and views using Oracle PL/SQL in conjunction with ODT

Formulate the optimized SQL queries to model the data that handles complex business scenarios

Implemented data quality checks to ensure correct data is being sent to downstream systems

Experienced working in Agile team space and delivering the projects with strict timelines

Analyzed data from different sources such as flat files and databases like SQL Server and MySQL

Develop data solutions for Enterprise Data Warehouse using ETL and ELT methodologies

Worked with business stakeholders to understand their business needs and define metrics

Worked on SQL optimizations and automation of manual processes to build a data warehouse

Define metrics and build Tableau dashboards to business users from Marketing, E-commerce, Retail

Develop a Data Quality framework to resolve data discrepancy issues

Designed and modelled a data warehouse with staging, storage and business layers

Parsed data sources of various formats XML, JSON, CSV using SQL and ETL

Work on source to target mappings, standardize business rules, data dictionary and metric calculations

Supports business management projects by documenting risks, issues, and action items.

EDUCATION

Bachelor of Technology in Electronics Engineering, Jawaharlal Nehru Technological University, India May 2017

Contact this candidate