Experience

TransSIGHT

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Engineer

  • Sep 2021 - Present

  Working on Redshift, Postgres and oracle database. Creating Flask API’s and DAGs using python for applications and pipelines for reporting purpose. Creating Dashboard’s using Tableau and PowerBI. Involved in multiple projects as an independent resource handling end to end. Getting training on creating pipeline using Azure data factory. Guiding team members on proceeding with project flow and clarifying the project scope/ information and helping with coding as and when needed. Working on Redshift, Postgres and oracle database. Creating Flask API’s and DAGs using python for applications and pipelines for reporting purpose. Creating Dashboard’s using Tableau and PowerBI. Involved in multiple projects as an independent resource handling end to end. Getting training on creating pipeline using Azure data factory. Guiding team members on proceeding with project flow and clarifying the project scope/ information and helping with coding as and when needed.



Kantar

• Armenia
• Hospitality
• 1 - 100 Employee

• Analyst - Data Architect/MSSQL/ETL/BI/RoR

  • May 2016 - Sep 2021

  Data profiling - Analysing the source data, identifying the relationship between different source data and understanding the granularity of data . Data modeling - by data profiling , defining the database schema, table structure and data type. Database architect - Creating database based on star schema or snowflake schema and maintaining the master table as single source for multiple projects. Worked in automating the ETL without any manual intervention using Pentaho data integration and reduced the manual effort Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues. Written complex stored procedures in SQL Server. Created Data harmonisation application using RoR active admin as a front end and MSSQL as the back end with BI tool Pentaho Data Integration and been as full stack developer. Playing IAM roles in AWS Involved in Visualisation using BI tools like Sisense and tableau. Creating dashboard with the charts as per project requirement. Creating an admin tool using .NetCore (C#,HTML,CSS,Javascript and MSSQL server). Worked with Excel Functions. Show less