Praneetha Maruvu
***************@*****.*** +1-720-***-****
PROFILE
Around 5 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 SQL, ETL, Python, Excel, and Tableau
Develop data pipelines using ETL tool Matillion & Reporting using Excel and Tableau
Experience working with data and statistical analysis using Excel pivot tables, data cleaning, formulas
Familiar with Excel 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.
Work on multiple databases such as MySQL, SQL Server, PostgreSQL and experience with PL/SQL
Knowledge on cloud-based data warehouse Snowflake and AWS services
Requirements gathering, analysis, design, development of OLTP and OLAP systems
Worked on dimensional data modeling using Star & Snowflake schemas
Developed reports, KPls and dashboards using Tableau Desktop and Tableau Server
Designed data model using Snowflake tasks, stages, streams
Perform ad-hoc analysis to determine opportunities for meaningful Enterprise-wide KPIs
Build data lake and develop ETL pipelines using AWS Services - EC2, S3, Lambda, Glue
Analyze information from large structured and unstructured (XML, JSON) datasets
Well-versed in enabling data profiling, data quality, SQL and ETL optimizations, performance tuning
Skilled at writing complex queries and presenting the findings to business users
Worked on Automations, debugging, and troubleshooting BI applications
Provide production support for Business Intelligence applications
Involved in unit and integration testing of the 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 the 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
Strong communication and presentation skills
TECHNICAL SKILLS
Databases
Snowflake, MySQL, Oracle, SQL server 2012, PostgreSQL
ETL Tools
Matillion, Informatica 8.1.1/10.2, Pentaho 7.1, Datastage v8.5/9.1
Reporting Tools
Qlikview 11, Tableau 10.x/2018.2, Power BI, Cognos 11.0.6, Splunk 6.6.3
Data Analysis Tools
Python, MATLAB, SAS, Excel
Other Technologies
Amazon Web Services, Unix, JavaScript, Java, Jira, Github, REST APIs, Postman
PROFESSIONAL EXPERIENCE
Lausn Technologies May 2017 - Feb 2022
Data Analyst
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
Worked on Excel to create ad-hoc reporting on customer, marketing, sales data to business users
Build ETL and API pipelines to load the dimensional data using Python and Matillion tools
Worked on creating views, tables and functions to load data objects to Snowflake database
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, etc.
Worked with various business stakeholders, architects, developers and data engineers to understand the requirements and transform into data solutions
Formulate the optimized SQL queries 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 Snowflake 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 Matillion
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 May 2017
Jawaharlal Nehru Technological University, India