Post Job Free
Sign in

Data Analyst Etl Developer

Location:
Dallas, TX
Salary:
90000
Posted:
May 24, 2023

Contact this candidate

Resume:

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



Contact this candidate