Ashwin Basrur ac71nx@r.postjobfree.com 703-***-****/ 203-***-****

SUMMARY

Self-motivated DW/ETL Architect/Sr Data Engineer with over 15+ years of experience in fast-paced, delivery-focused Fortune 500 environments with 11+ years of experience working in USA

Experience in Information Technology on handling multiple engagements in various capacities as Data Warehouse architect, ETL Architect, Project Manager, Modeler, Sr Data Engineer and Developer.

Experience in Banking, Mortgage, Utility, Marketing, Finance and Entertainment Domains with dataset size more than 130+ tb

Worked on various multi-site projects teams spread across US, Europe, Australia & India handling complex onsite-offshore engagements involving large data volumes.

Strong experience on Project Management, Systems Integration, Data warehouse architecture, Database Design, ETL Design, ETL Optimization, Data Profiling, Data quality process design, Best practice implementation, ETL Development, Production support and team co-ordination.

Data modeling experience using Erwin tool involving Dimensional and Fact tables in Operational Data Store and Enterprise Data Warehouse.

Unix/Python Scripting experience & AWS Cloud

Working experience on Hadoop-Hive, HDFS, Greenplum 4.2, Vertica 8.1, Teradata 13.10, Oracle 9i, and SQL 2012/2016 Server.

Strong ETL experience using Informatica Power Center 7.x & 8.6, 9.1, 9.6.1, Datastage 8.1

Have experience of working on Business Objects 6.5, Tableau 10 and Web intelligence reports.

Experience on working on No SQL and other tools like Redis in memory DB, Kafka & Splunk

Training session on Spark

TECHNICAL PROFICIENCIES

Databases: Teradata 13.10, MPP-Greenplum 4.2, PostgresSQL, Vertica 8.1, Hive, Oracle 9i, SQL Server 2005/2012/2016, Redis

ETL & BI Tools: Informatica 7.x & 8.x,9.1, Datastage 8.1, IBM CDC tool 6.5, Balanced Optimizer, OBIEE 10.1.3.2,, Knowledge of SAS DI

Reporting Tools: Tableau & Business Objects

Programming Languages: UNIX Shell Scripting, Python

Front End Tools: ASP, VB, Cold Fusion, Javascripting

Cloud- AWS-Amazon Web Services

Other- Splunk, Kafka, GIT, Jenkins

PROFESSIONAL EXPERIENCE

Sept 2017 till date

Intuit, San Diego, CA

Sr Data engineer

Working as Senior Data Engineer for CTG-Consumer Tax Group Team primarily supporting the Turbo Tax related data

Data Integration from various source systems into DW-CTG & Mint

Work with Technical Analyst and Product Managers to understand the requirement and come up with Design documents.

Design, Development to create an ETL process to ingest the data into DW & improvements to existing one

DB design using erwin

Worked on creating ETL framework using Python & Unix scripting to ingest data from various source systems including Oracle, Splunk, Hadoop-HDFS

Worked on migration to AWS Cloud, read source data from AWS bucket and load to Vertica db.

Worked on ingesting data from Redis into Vertica

Worked on Apache NIFI tool to ingest data from various source systems like Oracle, Kafka messaging, Splunk into Vertica

Jenkins & GIT was used to do CI/CD

YP, Glendale, CA Sept 2016 till Sept 2017

Sr Big Data Consultant

Work as primary Sr Big data consultant for Marketing team

Worked on pulling Leads, Prospects data from various source data from Hadoop hive, hbase into Vertica

Design/Development of Marketing datamart using vertica, Unix and Python framework

Define and Improve tasks to ensure Data Quality.

Design of database

Find performance bottle necks and provide industry standard solution.

Standardize the process to the enterprise level.

Disney, Burbank, CA Apr 2015 till Aug 2016

DW Architect

Worked on Database design

Create ETL mapping document

Analysis and profiling of data

Database design and modelling

Working on Unix & Python scripting and ETL development

Sourced data from Hadoop system into Greenplum platform

Worked on Informatica jobs and loading data into Mongo db using powerexchange

Worked closely with Business users. Interacted with Project Managers, and members of the QA teams.

Converted existing BO reports to tableau dashboards

Lytx, San Diego, CA Apr 2014 till Apr 2015

DW Architect

Analysis of existing OLTP DB Source systems in SQL Server 2012

Create ERD Diagram-Logical and Physical OLAP model for EDW using Visio 2010

Database design and modelling

Create a source to target mapping document to create a EDW using Greenplum

Create Architectural Design Documents

Build EDW using postgresql/Unix/python scripting using Agile methodology

Worked on Sending data from hdfs(Hive db) to greenplum using sqoop

Worked on writing SSIS Stored procedure in SQL 2012

Worked on pulling data from Hive into Greenplum platform using python scripting

Development & Optimize the process, data partitioning

Disney, Burbank, CA Jan 2013 to Mar 2014

DW Architect

Analyze the existing HP Neoview Database and Informatica code to understand the existing process for data load into DW.

Provide a roadmap to migrate the existing database to a new MPP Database.

Providing best possible solution for the migration and getting it approved from Architectural Board.

Providing alternate solutions or approach to improve the existing process.

Providing Architectural Design to the development team on the enhancement projects.

Database design and modelling

Source data from HDFS file system into DW.

Created/modified set of Informatica mappings to do performance improvement on Greenplum DB

Development of Greenplum DB Functions/sql as part of the conversion from current HP Neoview DB to Greenplum.

Used python/Unix scripting

Worked on converting the existing UNIX scripts to handle the source file movement and data load into Greenplum DB.

Work with DBA’s to get the Database design approved and implemented.

Define and Improve tasks to ensure Data Quality.

Find performance bottlenecks and provide industry standard solution.

Improve the existing process towards more automated, reduce failure risks, improve data quality and increased resource utilization.

Southern California Edison, Irwindale, CA Dec 2010 to Dec 2012

ETL Architect

Analyze changes and design database changes.

Providing best possible solution and getting it approved from Architectural Board.

Providing alternate solutions or approach to improve the existing process.

Gather requirements and create HLD/LLD Documents & source to target mapping document

Providing Architectural Design to the development team.

Coordination with the Datastage ETL & Reporting Development team with Design/Development approach to create a Data Mart.

Worked on developing of Teradata stored procedures.

Worked on development of ETL components

Data Integration from source systems into Operational Data Store-ODS.

Apr 2004 till Dec 2010

Employer: Tata Consultancy Services

Clients:

Worked for Bank of America, GE Treasury, GE Commercial Finance & Freddie Mac in various role as Data Architect, Project Lead, Module Lead & developer

May 1999 to Apr 2004

Other Employer’s:

Worked for Jax Humanet, Tech Pacific Technology Ltd & Smartech Global Solutions between 1999 to 2004 as Software Engineer with technologies like ASP.net, VB, Cold Fusion.

EDUCATION

Bombay University, India

Bachelor of Electronics Engineering

TRAINING

Informatica 7.3.1 - Oct 2005

MCSD (Microsoft Certified Solution Developer) - Feb 2000

OEAP (Oracle Alliance Partner Certification) - Oct 2001

Contact this candidate