Associate Director/DW Engineering Lead/BI Manager/Cloud ETL Architect/Tech Lead/Data

Modeler/Staff Data Engineer

Ashwin Basrur ad2xlf@r.postjobfree.com 203-***-****

Immigration Status: Green Card

SUMMARY

• Self-motivated Associate Director/DW/ETL Architect/BI Manager/Staff Data Engineer with over 18+ years of experience in fast-paced, delivery-focused Fortune 500 environments with 16+ years of experience working in USA

• Experience in Information Technology on handling multiple engagements in various capacities as managing Engineering Teams, Data Warehouse architect, ETL Architect, BI Manager, Modeler, Staff Data Engineer and Developer.

• Experience in Healthcare, 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 modelling experience using Erwin tool involving Dimensional and Fact tables in Operational Data Store and Enterprise Data Warehouse.

• Unix/Python Scripting experience & AWS (EC2, S3, Glue, Lambda, Redshift)/Azure Cloud (ADF, BLOB Gen2, Synapse)

• Working experience on Redshift, Hadoop-Hive, HDFS, Greenplum 4.2, Vertica 8.1, Teradata 13.10, Oracle 9i, and SQL 2012/2016 Server. Other tools-Apache Nifi, azkaban

• 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. Knowledge of Airflow

• Established long-term and value-added relationships with assigned business partners to educate and develop the analytic capability of business customers and the organization. Project Management/RFP/SOW/Client Engagement. Lead and mentor the data team ensuring strategic alignment and rapid executional excellence. PROFESSIONAL EXPERIENCE

Feb 2019 till date

Xifin, San Diego, CA

Associate Director/Staff Data Engineer-Lead Architect

• Expert in Cloud Data Warehouse (AWS, Azure, Redshift) designing, architecture and providing Cloud Data Warehouse solutions and helping customer in technical assessment, solution designing, building end to end solution, Cloud Migration Strategy & development

• Implement AWS cloud ecosystem for the company

• Responsible for deliverable for upcoming Azure Cloud Migration Project using ADF, BLOB Gen2 and Synapse.

• Design, Development and lead team of data engineers/BI Team supporting both Tableau and ML/AI related deliverables

• Assessing current state solutions, defining future state needs, identifying gaps and recommending new technology solutions. Responsible for strategically managing and creating program road maps, setting strategic and tactical directions for all projects, budgeting, relationship building with the Client leaders.

• Responsible to engage with Business and IT leaderships to fully estimate scope and plan and translate engagement objectives into defined scope and executable tasks with the Data Engineering Team members Skills: Data Engineering · Architecture · Cross-functional Team Leadership · Team Leadership · Amazon Web Services Microsoft Azure ·

Sept 2017 till Feb 2019

Intuit, San Diego, CA

Staff Data engineer

Worked 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 using Agile methodology 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

Skills: Data Engineering · Team Leadership · Vertica · Amazon Web Services (AWS) · Data Modeling · SQL DexYP, Glendale, CA Sept 2016 till Sept 2017

Sr Big Data Consultant

Skills: Team Leader, Data Engineering · Vertica

Disney, Burbank, CA Apr 2015 till Aug 2016

DW-ETL Architect Consultant

Skills: Data Engineering · Architecture · Greenplum · ETL · Data Modeling · Data Integration Lytx, San Diego, CA Apr 2014 till Apr 2015

Sr Greenplum Consultant

Skills: Data Engineering · Team Leadership · Greenplum · DW Architect. Python (Programming Language) Disney, Burbank, CA Jan 2013 to Mar 2014

DW-ETL Architect Consultant

Skills: Data Profiling · Architecture · Greenplum · ETL · Data Modeling · Data Integration Southern California Edison, Irwindale, CA Dec 2010 to Dec 2012 DW ETL Manager & Architect

Skills: Project Management · Architecture · Cross-functional Team Leadership · Team Leadership · Data Modeling · ETL ARCHITECT

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 Client Engagement, IT Lead, BI Manager, Create RFP and SOW, Data Architect, Project Lead, Module Lead 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

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