Fachlicher Schwerpunkt dieses Freiberuflers

Professional Trainer, Developer, Python, ETL, AWS Redshift, Snowflake, Data warehousing, Informatica powercenter, Pentaho and UNIX Shell scripting

verfügbar ab
05.10.2020
verfügbar zu
100 %
davon vor Ort
100 %
PLZ-Gebiet, Land

Einsatzort unbestimmt

Städte
Regensburg
50 km
Kontaktwunsch

Ich möchte bevorzugt für Projekte in diesen Einsatzorten kontaktiert werden.

Projekte

09/2017 - 06/2019

1 Jahr 10 Monate

Logitech engineering and design India private Ltd

Rolle
Technical Lead
Projektinhalte
  • Developed a data insight application to assist enterprise sales and marketing team in decision making.
  • Mentoring and leading a group of data engineers who resolve L3 data issues in Data warehousing application.
  • Involved in Platform migration of ETL application from On-premise to Cloud environment – AWS Redshift and Snowflake

11/2016 - 08/2017

10 Monate

Design efficient data models

Rolle
AWS Redshift Consultant
Projektinhalte
  • Freelance trainer on AWS Redshift development and best practices in data loading.
  • Design efficient data models – distribution and sort keys, analyze data skew and periodically tune the Redshift environment

08/2015 - 10/2016

1 Jahr 3 Monate

AstraZeneca India private Ltd

Rolle
Consultant
Projektinhalte
  • Profile and cleanse Veeva CRM data, defining data quality rules
  • Bulk load activity data from oracle database to AWS Redshift database using SnapLogic Redshift bulk load snap
  • Maintained Redshift database – User creations, fixing long running queries, perform vacuum, performance tuning – table design and query design

05/2013 - 07/2015

2 Jahre 3 Monate

Analyst Apps Prog

Kunde
Bank of America
Projektinhalte
  • Defined and developed data quality and data lineage framework for Bank’s Globalization of reporting initiative.
  • Extensively used Informatica PowerCenter, Informatica Data quality and Metadata manager
  • Part of design committee – evaluating Business use cases, involved in Proof of Concepts, Benchmark ETL tools.

11/2012 - 04/2013

6 Monate

NTT Data

Rolle
Team Lead
Projektinhalte
  • Leading a team of L3 / L2 support engineers and ensuring Staples data warehouse operations runs smoothly to cater the business intelligence team
  • Performance tune data load pipelines by identifying the bottle necks.

05/2012 - 10/2012

6 Monate

Data quality and administration

Rolle
Data warehousing Trainer
Projektinhalte
  • Provided training on Data warehousing concepts and ETL best practices.
  • Training session on Informatica PowerCenter, Informatica Data quality and administration

11/2010 - 04/2012

1 Jahr 6 Monate

Associate projects

Rolle
Cognizant Technology solutions
Projektinhalte
  • Involved in developing ETL solution for Dun and Bradstreet initiative Max CV – Maximizing customer values
  • Maintained and supported D&B ETL servers
  • Generated and projected weekly reports dashboard using Data analyzer to monitor the data volume flow in D&B applications

08/2008 - 09/2010

2 Jahre 2 Monate

WellPoint and developed

Rolle
Software Engineer
Kunde
UST Global
Projektinhalte
  • Worked with renowned client WellPoint and developed an Internet Provider Finder (IPF) application which collects provider details from different sources (mainframe and MS ACCESS) and integrates the provider information by applying the business logic and FTP the provider extracts to web application

Kompetenzen

Produkte / Standards / Erfahrungen

SUMMARY

  • More than 10 years of experience in developing and implementing data analytic solution across various domains – Healthcare, Banking and Retail.
  • Specialized in designing and delivering ETL solutions, Data management, platform migration and performance tuning.

Tools and Languages

  • Proficient in Advanced SQL, Shell scripting and Python
  • Familiar with PL/SQL, Java and R
  • ETL Tools: Informatica suite, SnapLogic and Pentaho
  • Area of interest: Data analytics using Artificial intelligence

Platforms
AWS, UNIX and Window


Datenbanken
AWS Redshift
Oracle Exadata
Snowflake

Ausbildungshistorie

2007  2007

BSA Crescent Engineering college, Anna University
Chennai, India

  • Master of Computer Applications – 72.5%

2004 - 2004

Poonga College of Arts and Science, University of Madras
Chennai, India

  • Bachelor of Computer Applications - 72%