Vidy Shettu

Vidy Shettu

Big Data Expert
Ireland

About Me

Big Data Expert with over 10 years of experience. Employers: Eagle Alpha, Facebook, J.P. Morgan, Accenture. Education: B.Eng(Computer science), MSc.

Experience

Senior Data Engineer

Eagle Alpha
Mar 2017 - Present · 9 years 4 months

▪️ Big Data Ecosystem: Hadoop, HDFS Map Reduce, Hive, Presto, Spark, Airflow, Snowflake.

▪️ Backend: Python, UNIX.

▪️ AWS: Serverless, Lambda development and deployment, Glue, Athena, Redshift, RDS, EMR, EC2, IAM, S3.

▪️ Data warehouse: Built EDW and Data Marts, OLAP, ETL, data architecture (modelling, dimensions and Normalisation), data pipelines, columnar databases.

▪️ Databases: Oracle, MS SQL Server, MySQL, PostgreSQL

▪️ Database languages: SQL, PL-SQL, T-SQL, NoSQL

▪️ BI Reporting: Tableau, SSRS, SSAS, Oracle Apex

Facebook (Contract through Singlepoint Solutions)
Jul 2017 - Mar 2018 · 8 months

Business Analyst

J.P. Morgan
May 2015 - Jul 2017 · 2 years 2 months

Design conceptual and logical data models to integrate data sources to build EU data mart.
Develop new metrics to analyze all areas of payment processing, from finance, sales to client services.
Develop reports as required, including exception logic and granular reports using SSRS / Tableau.
Build monthly and quarterly payments key performance indicators dashboard for clients and executives using T-SQL and SSRS.
Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.

Oracle analyst and project management

Dunnes Stores
Sep 2012 - May 2015 · 2 years 8 months

Manage, develop and deliver oracle-based projects, through complete life-cycle from requirement gathering, design, specification write-up, development, testing, implementation and roll-out support.
Develop and implement EDW, OLTP-OLAP ETL processes, report building, dashboard design and business intelligence solutions.
Perform SQL tuning with cost-based optimizer to increase the EDWs performance.
Develop housekeeping programs to improve EDW performance.

Supply Planner (temporary)

Procter & Gamble
Jun 2012 - Sep 2012 · 3 months

Interacted with supply chain partners to maximize supply chain customer service.
Day to day inventory management to minimise remnants and maximise customer service.

Analyst Programmer

Accenture PLC
Jun 2007 - Sep 2010 · 3 years 3 months

Lead & Managed WMS (Warehouse Management System) team.
Provided 24 * 7 support for oracle applications, worked on major issue root causes and solution analysis.
Analysed and resolved incidents raised by the client with regard to the above applications.
Identified gaps in the supply chain in order to perform enhancements and automations on the chain.

Business Analyst

J.P. Morgan
May 2015 - Jul 2017 · 2 years 2 months

Design conceptual and logical data models to integrate data sources to build EU data mart.
Develop new metrics to analyze all areas of payment processing, from finance, sales to client services. Develop reports as required, including exception logic and granular reports using SSRS / Tableau.
Build monthly and quarterly payments key performance indicators dashboard for clients and executives using T-SQL and SSRS.
Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.

Oracle analyst and project management

Dunnes Stores
Sep 2012 - May 2015 · 2 years 8 months

Manage, develop and deliver oracle-based projects, through complete life-cycle from requirement gathering, design, specification write-up, development, testing, implementation and roll-out support.
Develop and implement EDW, OLTP-OLAP ETL processes, report building, dashboard design and business intelligence solutions.
Perform SQL tuning with cost-based optimizer to increase the EDWs improve EDW performance. Develop housekeeping programs to improve performance.

Senior Data Engineer

Eagle Alpha
Mar 2018

Responsible for architecting data platform and finding solutions for alternative data with help of big data and AWS.
Manage ETL, data warehouses and data lakes for multiple products.
Build relationship with product managers and product analysts to understand data needs, deliver working solutions and analytics in an Agile and Iterative manner.
Review project objectives and determine best technology for implementation.
Implement best practice standards for development, build and deployment automation.
Process semi-structured / unstructured data.

Head of workplace culture (volunteer)

Eagle Alpha
Mar 2018

Manage working groups like Social, GoGreen, Gaming and Charity.
Continuous improvement on work culture, efficient meetings, teamwork.
Helped teams to adapt to new working culture during COVID19 pandemic.

Senior BI Developer

Eagle Alpha
Mar 2018

Architect, build and launch new data models that provide intuitive analytics to customers.
Design, build and launch efficient & reliable data pipelines to move data to large Data Warehouses.
Responsible for ETL, data landing and Data quality of critical systems.
Develop Tableau dashboards for data visualization, used by executives.
Perform automations wherever possible.

Skills

Big Data Cloud Computing Cloud Services Data Management Python Structured Query Language (SQL) Hadoop HDFS Map Reduce Hive Presto Spark Airflow Snowflake Lambda development Glue Athena Redshift RDS EMR EC2 IAM S3 Oracle MS SQL Server MySQL PostgreSQL PL-SQL T-SQL NoSQL UNIX Tableau SSRS SSAS MapReduce AWS Lambda AWS Glue Amazon Athena Amazon Redshift Amazon RDS Amazon EMR Amazon EC2 AWS IAM Amazon S3 Data warehousing EDW Data marts OLAP ETL Data architecture Data modelling Dimensional modeling Normalization Data pipelines Columnar databases Microsoft SQL Server PL/SQL Agile
Report this Profile?