Vigilant to data revolution, seeking a role for providing quality solutions for data analysis and information data control functions in a renowned data analytics enterprise for professional sustainability in emerging data engineering &ETL/BI field. I am a computer technology researcher and Data Engineer (ETL/BI).
Working with ETL/BI tech stack.
✪ Migrated user events from Excell to Mysql & Quickbook/SalesForce to Snowflake.
✪ Implement the whole ETL pipeline using Talend Open Studio & Talend Cloud Integration for data integration tools.
✪ Use Talend Cloud for ETL job publish & schedule.
✪ Developed & Maintain Data Warehouse dimensions and fact tables through complex SQL queries & Complex complete ETL cycle.
✪ Build new fact and dimension tables as the business is growing day by day.
✪ Using MySQL/SnowFlake as database/Datawarehouse, worked with complex queries, view, materialized view, query updates etc.
✪ Develop complex SQL scripts to build reports on the Semantic (Business) layer.
✪ Build stunning dashboards using Tableau Desktop & Tableau Online which help marketing and growth Client to make decisions.
✪ Use Tableau Server to publishing & schedule the dashboard automatically.
A detail-Oriented ETL/BI Developer with Professional Experience and with full of technical skills.
Project: YLOPO (Data Integration Service) Implement RETS base source which is using Data extraction, Data Cleansing And data mapping for required fields which display on client Property Site like ‘Realtor.com’. Enhancing Data mapping and data transformation for retail real_time data
Project: Chemcopharmacy.com A pharmacy based in Ireland having a Data warehouse of twenty stores with separate Databases for each store. As a BI Analyst, I am using analytics to drive strategic business decisions. Wrote Optimized SQL Queries for quick analysis. Made Trigger, Views, Store Procedure and SQL Jobs for tasks automation Made Pentaho Jobs for Data Integration to push data from different sources to SQL tables within the warehouse(Dimensions, Fact Tables)
Making and provide support of Buisness Intelligence base reporting ,dashboards,KPI\'s on Tableau
Reporting on (Tableau,MS Power BI) ,Databases (PostgreSQL,Microsoft SQL Server), ETL (Pentaho), Data Monitoring(POSitive Retail))
Yahoo Clicksco Affiliate Marketing BI & ETL Services
Data analysis and reporting using an in-house analytics tool, Loss Manager and as well as MS Excel, MS Power BI.Tableau. Dashboard Design/KPI Design/multi-layer dashboards
Reporting on (Excel,Tableau,MS Power BI) ,Databases (PostgreSQL,Oracle SQL developer), ETL (Pentaho), Data Monitoring(Loss-Manager(In-house tool))