Vinayagamurthy Harikrishnan

• Working closely with Product owner and Stakeholders for converting business requirement to technical design. Developing Solution Architecture in Azure, AWS cloud platforms related to Data Lake, Data Warehousing, Data Catalog, Data Pipelining, and BI Analytics.
• Modernized the traditional Volvo Datawarehouse to Enterprise Datawarehouse in Snowflake to integrate analytical data.
• Built the data lake service in Snowflake to adopt quicker onboarding of AWS S3 and Azure storage accounts.
• Implemented Alation Data catalog for Volvo cars in Azure cloud with proper security mechanism, logging, and monitoring capabilities
• Implemented common API management for Alation data catalog to handle API request from different product teams.
• Implemented Data pipeline in Azure Service for different use cases and support different product team to build their own data pipeline
• Built Data pipeline in AWS Cloud service to integrate different source applications and published data catalog in AWS Data Lake Formation.
• Central Data Quality Engine and Data Lake usage metrics reports in Power BI
• Best practice template for snowflake data consumption from different Azure and AWS data pipeline.
• Built Common raw data ingestion pipeline in Azure to support different product team can build pipeline faster.
• Helping Agile activities to product owner on Program Increment planning, Biweekly Sprint planning, Sprint Review, Sprint Retrospective and Backlog Refinement.

· Worked closely with Onsite team, Data Analysis, Solution Architects from project team in the exercise of uncovering technical requirements & risks from business case.

· Worked with a team environment for the design, development and implementing of data warehouse projects.

· Development of scripts for loading the data into the base tables in EDW using MultiLoad, FastLoad, BTEQ utilities of Teradata.

· Tuning and Optimizing Performance Data Warehouse application/processes in terms of indexing, partitioning, parallelism, and in choosing the right load strategy such as a TPT over Mload, Mload over TPump, etc.

· Writing scripts for data cleaning, data validation, data transformation for the data coming from different source systems.

· Involved in DBA activities to create the Tables, Materialize the views and collect statistics.

· Involved in Unit Testing and Guiding team for preparing test cases.

· Interacting with business analyst, LDM & PDM Creation and get Signoff from DBA, Design document creation and get signoff from Business team, Query tuning and Bug fixing, Code deliver, Production Migration & Support.

· Responsible for Daily, Weekly, Monthly Data publish and maintenance.

· Leading the offshore team and directly interacting with clients from requirement to till warranty support phase.

· Supporting to different business team requirement in on-demand basis which is delivering the active reporting and providing tactical solutions.

· Design document creation and get signoff from Business team, Performance tuning and Bug fixing, Code deliver, Production Migration & Support.

· Worked closely with Data Analysis, Solution Architects & Data Architects from project team in the exercise of uncovering technical requirements & risks from business case.

· Participating in a team environment for the design, development and implementing of data warehouse projects.

· Development of scripts for loading the data into the base tables in EDW using MultiLoad, FastLoad, BTEQ utilities of Teradata.

· Writing MultiLoad Scripts, Fastload and Bteq scripts for loading the data into stage tables and then process into EDW

· Constantly work with DBA’s on tuning and optimizing the performance of the processes in terms of indexing, partitioning, parallelism and in choosing the right load strategy.