Ashwin Basrur

About Ashwin Basrur

Self-motivated 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. • 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 • Established long-term and value-added relationships with assigned business partners to educate and develop the analytic capability of business customers and the organisation. • Lead and mentor the data team ensuring strategic alignment and rapid executional excellence. Specialities: Cloud technologies (AWS and Azure) Enterprise Data Services Data Warehousing, Data profiling, Vertica/Greenplum/Redshift/Teradata/Oracle/SQL Server/Postgresql/Mysql Hadoop-Hive Sqoop Redis, Splunk, Kafka ETL Informatica Unix/Python IBM Information Server DataStage Project Management/RFP/SOW/Client Engagement

Experience

1. Staff Data Engineer

   XiFin, Inc.

   Feb 2022 — Present · San Diego, CA, US

   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 Cloud Migration Strategy• Implementing redshift ecosystem for the company• Developing solution strategy vision and roadmaps and developing short, medium and long-termfeatures to achieve the vision.• Responsible for Architecture end to end solutions for DW/BI, Data Integration cloud platform AWS, Azure especially in Data Engineering, Data Lake, Data Visualisation using Tableau• 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 create and manage pipeline of projects across the digital operations journey of customers• Responsible for Client liaison, maintaining strong relationship with IT and Business stakeholders Maintaining strong and healthy relationship with customer & stakeholders• 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• Design, Development and lead team of data engineers supporting both Tableau and ML/AI related deliverables• Responsible for deliverable for upcoming Azure Cloud Migration Project using ADF, BLOB Gen2 and Synapse.

Education

• University of Mumbai

  Bachelor of Engineering (B.E.), Computer Engineering