Vikas Tripathi

About Vikas Tripathi

Total 15+ years of experience, 10 + Data Engineering, Business Intelligence, SQL DBA, and 5+ years of software development experience using industry standard methodologies and best practices. experience with Data Engineering across SQL, Azure, or other big data solutionsStrong in T-SQL, Big Data (Azure, Synapse, Delta Lake) and experience in creating and leveraging data visualization platforms in visualizing data using Power-BI and Advanced Excel to do the Analysis. Development strong in C#.Net, Python, expert in ETL and automation to formalize data in correct format, Strong in COSMOS DBWorked on the Azure synapse Analytics to move the data from one environment to another using the notebook and pipelines. Started to work on the Microsoft new technologies Fabric, to integrate the data into OneLake using PySpark notebook. Expertise in designing big data, data warehouse solutions, development, deployment, upgradation & scaling up solutions.Skilled at progressing from problem statement to well-documentation, planning to design, development and presenting insights. Continuously monitoring and improving the performance Expert in design, build, and maintain big data processing pipelines to serve analytics. Worked with different partners and stakeholders across the business.Experience in working on data that relies heavily on aggregation, transformation & insight driven focusing on business information.Effective result oriented with good in logical thinking, finding the best solution on any problem.Innovative and self-motivated quick and great desire to learn modern technologies and undertake challenging tasks. Always share the data with preparing insights on timely, accurate, and actionable. Passionate about business intelligence.Proficient with writing complex SQL queries, stored procedures, views, temporary tables, and other objects related to solving questions with data. Expert in advanced excel to generate the pivot, graphical representation of data.Develops and maintains reports, graphs, and visualizations, including a catalog of available reports, allowing users to easily find and understand information.

Experience

1. Data Engineer Lead

   Tech Mahindra

   Jul 2024 — Present · US

Education

• IISE Lucknow, UPTU

  MCA, Computer Science

  2001 — 2004

• IISE, Lucknow

  Master of Computer Applications (M.C.A.), Computer Science

  2001 — 2004

Skills

• Test Automation
• Web Services
• Ssrs
• Databases
• Data Warehousing
• Performance Tuning
• Sdlc
• C#
• .net
• Sql Dba and Dev
• Sql Server Reporting Services (Ssrs)
• Ssis
• Agile Methodologies
• Requirements Analysis
• Windows
• Test Planning
• Sql
• Asp.net
• Requirements Gathering
• Web Applications
• Xml
• High Availability
• Microsoft Sql Server
• Etl
• Pl/Sql
• Software Development Life Cycle (Sdlc)