Data Engineer

PROTECTED 関係者外秘

Praveen Sadasivam

**+ yrs. Experience on Data Warehousing and Business Intelligence Contact

Mobile : +1-310-***-****

***********@*****.***

Career Profile

A skilled, talented and dedicated IT professional with diverse experience in database, data warehousing and business intelligence. Looking for a challenging position to utilize my knowledge of implementing, designing, low cost solutions and operating stably in enterprise data integration. Summary of Qualifications

• Over 10+ years of total IT experience with strong knowledge in ETL/Database.

• 10 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center.

• Hands-on experience in Database modelling. (Star/Snow flake schemas).

• Good knowledge in SQL Scripts, UNIX Shell Scripting.

• Experience in HDFS, Hive, SQOOP, Hue, Oozie., PySpark.

• Expertise in scheduling jobs using Redwood scheduler.

• Strong Experience in SQL queries – Oracle SQL.

• Experience in Python scripting.

• Data scalability using MongoDB (NoSQL DBs).

• Agile methodology of execution of projects.

• Involved in Troubleshooting database problems, Performance tuning – session and mapping tuning, partitioning and SQL Tuning.

• Production Support lead for major warehouse applications (Tickets/Releases/DQ/SLA/On-call support/Implementations).

• Experience on Data Quality framework including Data profiling, creating Data dictionaries and Source to target documents.

• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, testing, documentation, training, implementation and post- implementation process.

Key Skills

Operating Systems - Windows, Linux OS.

Languages - SQL, UNIX Shell Scripts, Python

Hadoop - Sqoop, HDFS, Hive, Hue, Oozie, PySpark (Spark), MapReduce, Pig ETL Tools - Informatica 9.1

Database - Oracle11g, MongoDB, Teradata

Database modelling - Star/Snow Flake

Scheduler - Redwood v8, Crontab.

Others - WinSCP, Putty, JIRA, Bit Bucket, Rational CQ and Clear-case. Work Experience

Cognizant Technology Solutions

Senior Associate Jun 2007 to Till date

PROTECTED 関係者外秘

Work Eligibility

Current Visa H1B

Validity July 2018

GC process PD Dec 2014 (I 140 approved)

Certification Summary

Data Warehousing

Cognizant Corporation

Manufacturing and Logistics

Awards and Honors

Award Organization Account

Above and Beyond Award Cognizant Technology Solutions Toyota Motor Sales, USA, Inc., 2014

BI Platform certification Cognizant Technology Solutions Toyota Motor Sales, USA, Inc., 2015

Education

2003 to 2007 Bachelor of Electronics and Communication Engineering Anna University, India

Personal Details

Date of Birth

Communication

Address

October 29, 1985

3476 Garnet street Apt 144

Torrance CA - 90503

Projects

ROLES AND RESPONSIBILITIES

• Responsible for creation of custom ingestion (SQOOP) scripts to ingest data into the lake as part of convergence process.

• To transform and aggregate data from raw layer and store it in integrate layer using Pyspark SQL.

• Setting up of Hive tables with partitions and handling baseload and incremental refresh process.

• As a key member of the Toyota Integrated platform initiative, responsible to consolidate various sources that save millions of dollars/efforts for Toyota in performing analytics from the one stop platform (Saved 5 million dollars per year due to centralized data availability)

• Part of team member responsible to ingest data for Parts and Sales Analytics dashboard for National executives to assess vehicle parts and accessory sales across US dealerships and its performance. 1. PROJECT NAME Data convergence to Big data Platform CLIENT TOYOTA MOTOR SALES

DURATION SEP 2016 – TILL DATE

ROLE SR. ETL DEVELOPER (BIG DATA)

2. PROJECT NAME VDW – Vehicle, Sales, Inventory, Global Pipeline, Application migrations.

PROTECTED 関係者外秘

ROLES AND RESPONSIBILITIES

• Key team member in supporting daily operations and involved in setting up Enterprise warehouse for Sales, Inventory, Finance and Order information for business decisions and analytics purpose.

• Worked as a part of Vehicle Data warehouse responsible for Requirement Analysis, Data Quality Analysis, Gap Analysis, Functional/Technical Specifications, ETL Design Documents, ETL Development, Testing and Support Activities.

• Tuned the jobs to meet SLA timelines which saved close to 100 hours per month in application availability. (1200 hours per year).

• Involved in Database modelling deriving Star/Snow-flake schemas out of design process.

• Provided Value-adds to the customers in setting up automated data extract process to share with Federal government (saved millions of dollars due to late fine), Automated report monitoring system etc. ROLES AND RESPONSIBILITIES

• Analysis of ETL code and fixing defects.

• Understanding of requirements and convert into Technical specifications.

• Development of ETL jobs to convert data from SQL Server to Teradata.

• Production team member to support job completion, SLA compliance and tuning of jobs. ROLES AND RESPONSIBILITIES

• Team member to set up Enterprise Cost/Performance DW involving in development of ETL jobs.

• Implementation of the ETL codes to Production.

• Warranty support to the jobs deployed in Production.

• High and Low level design documents creation.

CLIENT TOYOTA MOTOR SALES

DURATION JAN 2010 – AUG 2016

ROLE SENIOR ETL DEVELOPER, PROJECT LEAD

3. PROJECT NAME Global Data warehouse

CLIENT 3M

DURATION SEP 2008 – DEC 2009

ROLE ETL DEVELOPER

4. PROJECT NAME Cost and Performance DW

CLIENT FLORIDA POWER AND LIGHTS

DURATION AUG 2007 – AUG 2008

ROLE ETL DEVELOPER AND PRODUCTION SUPPORT

PROTECTED 関係者外秘

Contact this candidate