Gayathri

Gayathri

Software Developer
India

About Me

Software developer with 5+ years of experience in IT sector specializing in Data Engineering, Data Warehouse & Business Intelligence (BI) platform with expertise in Data Analysis, Design and implementation of Database an…

Experience

ETL & BI Developer / Tech Lead

SK IT Shoulders Pvt Ltd, Chennai, India
Jul 2016 - Present · 10 years 3 months

<p>Evaluating functional requirements and mapping documents<br>
Extracting and analyzing the source data<br>
Creating data model, mappings and ETL workflows<br>
Creating custom database SQL programs for business logics<br>
Creating Business Intelligence (BI) dashboards and reports<br>
Writing and validating test cases and design documents<br>
Assisting team in ongoing development works<br>
Engaging clients in requirement gathering, development activities and reporting</p>

PowerBI Developer

ITS
Jul 2016 - Present · 10 years 4 months

Evaluating functional requirements & mapping documents
Extracting & analyzing the source data
Creating Data model, mappings & ETL workflows
Creating custom database SQL programs for business logics
Creating Business Intelligence (BI) dashboards & Reports
Writing & validating Test cases & design documents
Assisting team in ongoing development works
Engaging clients in requirement gathering, development activities and reporting

ETL and Power BI Developer

NATERA INC.
Jun 2021 - Jul 2023 · 2 years 1 month

<p>Designing and developing data integration jobs in Talend to retrieve data from source systems and load them into the enterprise data vault and data warehouse dimensions and facts tables<br>
Designing aggregated tables according to business requirements<br>
Using views and stored procedures to process the data effectively<br>
Working with the business team to assist user acceptance tests<br>
Configuring data integration jobs to run in different frequencies as needed<br>
Publishing Power BI reports in Power BI Service to share the reports<br>
Creating Power Automate tasks to send the Power BI report as a PDF to users via mail</p>

ETL and BI Developer

PLOS, INC.
Mar 2020 - May 2021 · 1 year 2 months

<p>Creating users and projects using Git Repository and Remote engines in Talend Management Console<br>
Assigning roles to users and permitting the level of access to each user<br>
Using ETL methodologies and best practices to create Talend ETL jobs<br>
Enhancing programming and naming standards to load the data from various sources<br>
Building DI jobs to retrieve the data from source systems and load into dimensions, time variant dimensions and facts<br>
Tuning SQL source queries to restrict unwanted data in ETL process<br>
Optimizing ETL jobs and using views and stored procedures effectively<br>
Creating jobs to take weekly, monthly and yearly snapshots for building reports<br>
Scheduling jobs in Talend cloud version for incremental load<br>
Creating Tableau dashboards and reports for business analytics</p>

Tableau BI Developer

Pure Storage
Sep 2019 - Nov 2020 · 1 year 2 months

<p>Building Tableau dashboards based on requirements from SQL Server<br>
Resolving performance issues for existing dashboards<br>
Creating aggregated queries to reduce extracting time from source<br>
Publishing and scheduling Tableau dashboards in Tableau Server<br>
Monitoring Tableau run status using Tableau administrator access<br>
Creating interactive Tableau workbooks using Tableau Desktop<br>
Publishing Tableau dashboards and scheduling them in Tableau Online</p>

Data Integration (Talend) and Business Intelligence (Tableau) Developer

BGI – Beijing Genomics Institute.
Nov 2017 - Jun 2020 · 2 years 7 months

<p>Preparing data mappings<br>
Acquiring and interpreting business requirements, creating technical artifacts, and determining the most efficient and appropriate solution design<br>
Extracting, transforming and loading data from different data sources<br>
Handling data using Talend Tool (Big Data)<br>
Developing and analyzing Hadoop cluster and different Big Data components including Pig, Hive, Spark, HBase, Kafka, Elastic Search, database and Sqoop<br>
Installing Hadoop, Map Reduce, Confidential, and developing multiple Map-Reduce jobs in Pig and Hive for data cleaning and pre-processing<br>
Performing performance tuning and optimization in product<br>
Preparing and performing incremental logic along with job audits and mail alerts for job status<br>
Creating rich dashboards using Tableau and applying actionable insights<br>
Generating dashboards with quick filters, parameters and sets to handle views more efficiently<br>
Developing Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD analysis</p>

ETL and Tableau BI Developer

DataStax, Inc.
Jul 2018 - Oct 2019 · 1 year 3 months

<p>Building DI jobs to retrieve data from source systems and design dimensions, time variant dimensions and facts<br>
Optimizing ETL jobs and using views and stored procedures effectively<br>
Designing aggregate tables according to business requirements<br>
Creating jobs to take weekly, monthly and yearly snapshots for building reports<br>
Coordinating with the team to fix issues and guiding the team to complete modifications and new business requirements<br>
Scheduling jobs in cloud version for incremental load<br>
Creating rich dashboards using Tableau and applying actionable insights<br>
Scheduling dashboards in Tableau Server for incremental refresh</p>

Power BI Developer

NATERA INC.
Nov 2021

<p>Studying, analyzing and understanding business requirements in context to business intelligence<br>
Understanding the Qlik Dashboard and creating a data model accordingly<br>
Analyzing previous and present data for better decision making<br>
Creating Power BI report and complex DAX queries efficiently<br>
Validating the data in visuals and implementing quality checks</p>

Skills

Java MySQL SQL Database Talend Power BI Tableau Data Engineering Data Warehousing Business Intelligence Data Analysis Database Design ETL Talend Data Fabric SQL DAX Power Automate Power BI Service Power BI Desktop Talend Management Console Talend Cloud Git Qlik Oracle Snowflake Salesforce MSSQL LIMS LabVantage Stored Procedures Views Hadoop Pig Hive Spark HBase Kafka Elasticsearch Sqoop MapReduce Data Modeling Data Integration Data Migration Dashboard Development Report Development Data Validation Quality Checks Requirement Gathering Test Case Writing Design Documentation User Acceptance Testing Performance Tuning Scheduling Incremental Load
Report this Profile?