AYUSH ANSHUMAN

Experience

• 

  Anlight Consulting Services Private Limited

  Jun 2016 - Aug 2018

  IT Technical Consultant

  ● Responsible for requirement gathering from the client and analyse the gap.● Responsible for Technical as well as Functional configuration of HR setup, Employee Induction, Leave management, Time management, Recruitment, Performance Management, Grievance, Security Definition (DLS)Travel,Training, Reimbursement and Payroll● Involve in Customization or Changes in existing functionalities after approval solution document.● Created Leave Entitlement and Posting Rules, Time management Attendance Rule, and Payroll Rules.● Created Customised Dcube Reports and DW data integration.● Responsible for Solution document, Test case document and deployment in production server after successful testing in testing server.● Configured/ Customized functionalities on User Attributes, Approval, Confirmation and prepared solution document.● Responsible of Data upload● After Live Support. Show less

• 

  PeopleStrong

  Aug 2018 - Sept 2019

  Product Analyst

  ● Creating complex queries and analyzing performance using MS SQL 2012. ● Create DDL for tables, indexes, views, function, and trigger.● Create indexes on some columns of tables to increases the application's performance.● Know how to use dynamic SQL effectively for both DDL and DML● Uses ref Subqueries for fetching data from database.● Written SQL queries for DML operation using function, join, Sub query.● Automating the jobs using trigger.● Involve in research and analysis to understand business functional requirement.● Run trace to find out system workflow and bugs.● Analysis client requirement reports using SSRS and Crystal reporting tool.● Analysis using Pivot Table, Pie charts.● Knowledge of Excel Formulas, Pivot table, V loopup, H loopup, Charts, Data Validation, Document Protection, Data Formatting. Show less

• 

  IndiaLends

  Oct 2019 - Mar 2020

  Senior Software Developer

  ● Design Database according to the Line of business.● Creating stored procedures according to the requirement.● Create a database report.● Responsible for database backup and recovery.● Data Warehouse maintenance.

• 

  NTT DATA Services

  Mar 2020 - Jan 2022

  Senior SQL Developer

  ● Design Database tables according to the LOB● Handling API data and store into table with logic● Database reports● Creating Stored procedure according to the requirement● Team Handling

• 

  Admiral Group Plc

  Jan 2022 - Jul 2024

  Database Engineer cloud

  As a data engineer working with Azure Synapse, SQL Server, SSIS, ADF, Databricks, Apache Airflow, Data Lake, and SnowflakeData Integration and ETL Processes● Designing, developing, and maintaining Extract, Transform, Load processes using tools like SSIS , ADF and Apache Airflow.● Ensuring efficient data movement and transformation across different data sources and destinations.Data Modeling and Warehousing● Designing and implementing data models and data warehouses using Azure Synapse Analytics, SQL Server, delta lake, Snowflake and other relevant technologies.● Optimizing data structures for performance and scalability.Data Processing and Analysis● Leveraging Databricks for data processing, analysis, and machine learning tasks.● Implementing data pipelines for batch and real-time data processing.Database Management and Optimization● Managing SQL Server databases, including schema design, indexing strategies, and performance tuning.● Writing and optimizing T-SQL queries, pyspark code for data retrieval, manipulation, and reporting.Data Governance and Security● Implementing data governance policies and ensuring compliance with regulations (e.g., GDPR, HIPAA) and industry standards.● Securing data assets through access controls, encryption, and monitoring.Monitoring and Maintenance● Monitoring data pipelines, databases, and analytical processes for performance issues and errors.● Performing regular maintenance tasks such as backups, updates, and patches.Collaboration and Documentation● Collaborating with cross-functional teams including data scientists, analysts, and stakeholders to understand data requirements.● Documenting data pipelines, processes, and system configurations for knowledge sharing and future reference.Report Development and Visualization● Creating and maintaining reports and dashboards using tools like Power BI, Tableau, or custom solutions.● Ensuring reports are accurate, visually appealing, and meet business requirements. Show less

• 

  Srijan- A Material+ Company

  Jul 2024 - now

  Lead Data Engineer