$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Engineer
Ashish Talreja
,
Harrow, United Kingdom
Experience
Other titles
Skills
I'm offering
I am brilliant in transformation any type of raw data into Graphs.
I am okay to work on any tool.
I am okay to work on any tool.
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Available
My experience
2013 - 2020
job
Application Development Senior Analyst
Accenture Solution Pvt Ltd.
Project - Sainsbury's Argos (Agile and Waterfall)
Project Domain - Products/Ecommerce/Retail
Responsibilities Handled:
• Full-fledged experience on all stages of project phases like requirement gathering, analysis, designing, development, support, performance tuning, error handling, documentation and deployment till project Go-live in production. Managed deployments and error handling by coordinating with cross-functional the teams.
• Implemented more than 100 automated ideas using Unix scripting, Splunk and Informatica.
• Completed more than 250 Jira tickets and Resolved 40-50 Major Incidents.
• Implemented 10+ applications using Informatica and SSIS.
• Created 5 dashboards using Qlikview, PowerBI, and Splunk.
• Worked as an acting team lead and managed team of 7 members.
• Have a combination of development and support experience.
Application Development Senior Analyst 03/2020 to SYSDATE
Revionics
Project - Metro (Agile)
Project Domain - Retail
Responsibilities Handled:
• Working as Data Implementation Engineer and on Pricing Recommendation SAAS solution.
• Infrastructure is on GCP so have development experience on various services such as Bigquery, Composer, Storage, Dashboard etc.
• Created complex Mappings to transform data as per requirement from customers.
• Worked on different interfaces of data like Product, Sales, Category, Store, Price families, PLG etc.
• Worked on some of batch scripts as well to automate the data transfer.
MSBI (SSIS, SSAS, SSRS)
• Created multiple complex SSIS packages using data and control flow tasks like merge join, lookup, SCD2, aggregator, sequence, etc.
• Also, modified a few existing SSIS packages for the changes in the downstream systems.
• Written plenty of complex stored procedures and functions using TSQL.
• Automated procedures through SQL Agent Jobs.
• Used flat files, SQL server and XML as Source and Target destinations.
• Created time series calendar and KPI's, in SSAS.
• Created multiple SSAS cubes using different aggregations like sum, count etc.
• Prepared data extracts in SQL server to get used in SSRS.
• Created SSRS reports using matrix, tabular, gauge, bar, etc. and deployed the same on web server.
PowerBI
• Created Power BI dashboard for the client to check the data on the products which got returned due to breakage or bad quality. Also, created charts/metrics to depict which suppliers are constantly sending bad quality products based on QBL score (Quality Breakage Level).
• Used data from flat files and Oracle database as Source Pipelines for PowerBI.
• Created data model in power BI for the customer return dashboard and Configured data gateways and scheduled PBI reports to refresh.
• Worked on visualization PowerBI charts like Line, Bar, Gauge, Column, Area, Map charts, Straight Table and Matrix.
• Developed various visual reports, rolling calendar, dashboards and scorecards using PBI desktop.
• Created Executive summary, product and supplier deep drive dashboards.
• Extensive knowledge in various reporting objects like DAX Measures, Facts, Attributes, Hierarchies, filters, Calculated fields, Groups, Parameters, etc.
Informatica
• Development, test and deployment of Informatica workflows and Unix scripts and making it go-live till production. Managing deployments by coordinating with cross-functional teams. Additionally, supported admin activities like creating Integration and repository services, managing users and roles, etc.
• Created and customized many workflows for the different applications and interfaces like order, product, stock, sales, forecasting, competitors, data lake, etc.
• Extensively used transformations like router, aggregator, normalizer, joiner, expression, lookup, update strategy, sequence generator and stored procedure.
• Created conceptual and physical model in oracle for one of the complex project applications.
• Extracted data from mainframe using PowerExchange 9.1 with the help of SQL queries and loaded in oracle database using Informatica partitioning for creating reports.
• Deployed fixes by changing the logic in existing live workflows and reports as per requests by Clients.
• Worked on Oracle, DB2, flat files and mainframe in Informatica as source and target pipelines.
• Undertook performance tuning to reduce the run time of the ETL fact job from 10 hours to 2 hours a day.
• Experience in writing complex SQL queries and procedures.
QlikView:
• Designed, implemented, and supported QlikView dashboards for displaying the sales of the company which shows multiple measures like revenue, visits, conversion, attachment, competitor price index.
• Created dashboard with various views like summary, key drivers, health check and detail view having different levels of granularity. The dashboard also had day, week and period comparisons of data.
• Interacted with end-users to collect requirements and acquire the necessary domain knowledge to support the dashboards of Qlikview application.
Splunk/Unix:
• Created Unix scripts to FTP files from one server to another for loading data into mainframe using PowerExchange 9.1
• Developed an alarming system using Splunk, Unix and SQL using Informatica metadata to alert team about the data issues to troubleshoot data inconsistency issues.
• Created Splunk dashboard for different teams for active monitoring on 12 various applications.
• Built real-time dashboard in Splunk specifically for Clients to display trends in sales of various channels after exporting data from Oracle using Unix scripting.
• Saved 150+ of manual hours by automating tasks using Informatica workflows and Unix scripting.
• Created dashboards for the Accenture leadership to check all the services throughout the project.
Project Domain - Products/Ecommerce/Retail
Responsibilities Handled:
• Full-fledged experience on all stages of project phases like requirement gathering, analysis, designing, development, support, performance tuning, error handling, documentation and deployment till project Go-live in production. Managed deployments and error handling by coordinating with cross-functional the teams.
• Implemented more than 100 automated ideas using Unix scripting, Splunk and Informatica.
• Completed more than 250 Jira tickets and Resolved 40-50 Major Incidents.
• Implemented 10+ applications using Informatica and SSIS.
• Created 5 dashboards using Qlikview, PowerBI, and Splunk.
• Worked as an acting team lead and managed team of 7 members.
• Have a combination of development and support experience.
Application Development Senior Analyst 03/2020 to SYSDATE
Revionics
Project - Metro (Agile)
Project Domain - Retail
Responsibilities Handled:
• Working as Data Implementation Engineer and on Pricing Recommendation SAAS solution.
• Infrastructure is on GCP so have development experience on various services such as Bigquery, Composer, Storage, Dashboard etc.
• Created complex Mappings to transform data as per requirement from customers.
• Worked on different interfaces of data like Product, Sales, Category, Store, Price families, PLG etc.
• Worked on some of batch scripts as well to automate the data transfer.
MSBI (SSIS, SSAS, SSRS)
• Created multiple complex SSIS packages using data and control flow tasks like merge join, lookup, SCD2, aggregator, sequence, etc.
• Also, modified a few existing SSIS packages for the changes in the downstream systems.
• Written plenty of complex stored procedures and functions using TSQL.
• Automated procedures through SQL Agent Jobs.
• Used flat files, SQL server and XML as Source and Target destinations.
• Created time series calendar and KPI's, in SSAS.
• Created multiple SSAS cubes using different aggregations like sum, count etc.
• Prepared data extracts in SQL server to get used in SSRS.
• Created SSRS reports using matrix, tabular, gauge, bar, etc. and deployed the same on web server.
PowerBI
• Created Power BI dashboard for the client to check the data on the products which got returned due to breakage or bad quality. Also, created charts/metrics to depict which suppliers are constantly sending bad quality products based on QBL score (Quality Breakage Level).
• Used data from flat files and Oracle database as Source Pipelines for PowerBI.
• Created data model in power BI for the customer return dashboard and Configured data gateways and scheduled PBI reports to refresh.
• Worked on visualization PowerBI charts like Line, Bar, Gauge, Column, Area, Map charts, Straight Table and Matrix.
• Developed various visual reports, rolling calendar, dashboards and scorecards using PBI desktop.
• Created Executive summary, product and supplier deep drive dashboards.
• Extensive knowledge in various reporting objects like DAX Measures, Facts, Attributes, Hierarchies, filters, Calculated fields, Groups, Parameters, etc.
Informatica
• Development, test and deployment of Informatica workflows and Unix scripts and making it go-live till production. Managing deployments by coordinating with cross-functional teams. Additionally, supported admin activities like creating Integration and repository services, managing users and roles, etc.
• Created and customized many workflows for the different applications and interfaces like order, product, stock, sales, forecasting, competitors, data lake, etc.
• Extensively used transformations like router, aggregator, normalizer, joiner, expression, lookup, update strategy, sequence generator and stored procedure.
• Created conceptual and physical model in oracle for one of the complex project applications.
• Extracted data from mainframe using PowerExchange 9.1 with the help of SQL queries and loaded in oracle database using Informatica partitioning for creating reports.
• Deployed fixes by changing the logic in existing live workflows and reports as per requests by Clients.
• Worked on Oracle, DB2, flat files and mainframe in Informatica as source and target pipelines.
• Undertook performance tuning to reduce the run time of the ETL fact job from 10 hours to 2 hours a day.
• Experience in writing complex SQL queries and procedures.
QlikView:
• Designed, implemented, and supported QlikView dashboards for displaying the sales of the company which shows multiple measures like revenue, visits, conversion, attachment, competitor price index.
• Created dashboard with various views like summary, key drivers, health check and detail view having different levels of granularity. The dashboard also had day, week and period comparisons of data.
• Interacted with end-users to collect requirements and acquire the necessary domain knowledge to support the dashboards of Qlikview application.
Splunk/Unix:
• Created Unix scripts to FTP files from one server to another for loading data into mainframe using PowerExchange 9.1
• Developed an alarming system using Splunk, Unix and SQL using Informatica metadata to alert team about the data issues to troubleshoot data inconsistency issues.
• Created Splunk dashboard for different teams for active monitoring on 12 various applications.
• Built real-time dashboard in Splunk specifically for Clients to display trends in sales of various channels after exporting data from Oracle using Unix scripting.
• Saved 150+ of manual hours by automating tasks using Informatica workflows and Unix scripting.
• Created dashboards for the Accenture leadership to check all the services throughout the project.
Development, Router, Mainframe, SSRS, It, Implementation, Support, Infrastructure, Analyst, SSAS, Monitoring, KPI, Health, Ssis, Storage, Visualization, Detail, Web, Power, BEE, Server, Logic, Production, Tuning, Go, Agent, Unix, Writing, Ecommerce, Retail, Jira, Oracle, SQL Server, Forecasting, XML, Power BI, Deployment, Agile, Scripting, Sql, ETL, Saas, Database, Leadership, SoMe, DB2, Stored procedures, Integration, Oracle database, Sales, Test
My education
University of Mumbai
BSc, Computer Engineering
BSc, Computer Engineering
Ashish's reviews
Ashish has not received any reviews on Worksome.
Contact Ashish Talreja
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Ashish directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark