Aayush Kumar

Software Engineer

Patna, Bihar, India6 yrs 8 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Proven history of delivering automation and data management.
  • Expertise in building ETL pipelines and performance dashboards.
  • Recipient of two Spot Awards for outstanding contributions.
Stackforce AI infers this person is a Data Engineer with strong expertise in Legal Compliance and Data Analytics.

Contact

Skills

Core Skills

Data AnalysisSql Server Integration Services (ssis)Data ReportingDashboardingEtl Transformation

Other Skills

3D Design3D ModelingAnalytical SkillsAutoCADBusiness AnalysisBusiness ValidationsCATIACOMSOLCSWA DesignerCloud ServicesDashboards CreationData Flow ManagementData Retention RulesData ValidationData Warehouse Management

About

Aayush is Graduate and is aimed to learn and solve problems with innovative ideas. Experienced in Techno-Functional roles and responsibilities. Proven history of delivering automation and data management. He managed database applications to provide support with data driven reports and compliance with legal holds on data. He built ETL pipelines for Data Warehouse refresh in batches. Built performance and MIS dashboards. Data ingestions using azure data factory and databricks. Resurce management on azure. Data Transformations using SSIS and Python. Took responsibility of regression testing of databases, Business Validation, Application performance enhancement and new custom objects building. Developed reports in Bold Reports. Experienced as strategy and decision advisor with data driven reporting. Created funnel and waterfall model dashboards on live data for business monitoring and performance reporting. He catered GDPR and Data research fir compliance.

Experience

6 yrs 8 mos
Total Experience
2 yrs 2 mos
Average Tenure
4 yrs 1 mo
Current Experience

Deloitte

2 roles

Software Engineer II

May 2025Present · 1 yr 1 mo

SQLMicrosoft SQL ServerSQL Server Integration Services (SSIS)Technical ReportsFinancial ReportingQlik Sense+7

Software Engineer I - Data Analytics and Engineering | Legal and Compliance

May 2022May 2025 · 3 yrs

  • Worked for Reporting and Dashboarding Team for Legal and compliance business.
  • Supporting the business of over $ 1 billion in revenue.
  • Built data reports to support leadership decisions, analyze business and formulate future vision.
  • Product analytics. Created custom reports. Data validation and flow management. Testing data pipeline.
  • Processed json data from web api to sql database. Analyzed and Validated database applications.
  • Handled GDPR and Data Research.
  • Creation and maintenance of database applications. Data Retention rules creation and validation of legal holds of data, data purge procedure handling. Migrated SSRS reports logic to BOLD reports.
  • Involved in business validation and testing of new feature, performed backward compatibility for the web application.
  • Formulated regression testing modules for testing new retention rules for legal holds of data.
  • Managed job schedules for reporting.
  • Qliksense Dashboard Development including KPI , Set Analysis, Pivots & Charts and section access controls.
  • Managed Consents for independent reporting.
  • Recipient of two Spot Awards.
  • Understanding the business need and Quality Assurance for new feature releases. User acceptance Testing and Business Validations.
  • volunterred in AI guild as an advisor.
  • Worked on query optimization for procedures.
Data ReportingDashboardingProduct AnalyticsData ValidationData Flow ManagementTesting Data Pipeline+6

One97 communications limited

Business Analyst | Lending

Feb 2022Apr 2022 · 2 mos · Noida, Uttar Pradesh, India

  • Worked on lending data analysis. Performed data analysis on customer data for Behaviour tracking, model building, and dashboards creation. Built MIS reports, Analyzed patterns and prepared insights for business managers which helped in overall growth and policy formation. Built models on Waterfall and funnel analysis.
Data AnalysisModel BuildingDashboards CreationMIS Reports

Cognizant

2 roles

PA - Data Engineer | Retail

Jul 2021Feb 2022 · 7 mos

  • Responsible for managing data warehouse for retail client. Performed ETL transformation for bussiness reports that helps in taking data driven informed decisions. Manage Cloud services. Built and loaded PowerBI reports for store level performance for a retail convenient store giant. Maintained Audit and EJ data for Legal reference. Integrate business rules and performance ctiterias.
ETL TransformationData Warehouse ManagementCloud ServicesPowerBI Reports

PAT - Data Engineer

Jul 2020Jun 2021 · 11 mos

  • Responsible for managing data warehouse for retail client. Performed ETL transformation for bussiness reports that helps in taking data driven informed decisions. Manage Cloud services and Databricks Batches
ETL TransformationData Warehouse ManagementCloud Services

Indian oil corp limited

Mechanical Maintenance Trainee

Jun 2019Jun 2019 · 0 mo

Rail wheel plant , bela

Industrial Training on casting of Rail wheels.

Dec 2018Dec 2018 · 0 mo · Bihar

  • Understanding the various processes involved in casting of wheel.
  • Audited the Plant for safety precautions.
  • Performed Brinell hardness Test on Finished wheel.

Team odyssey

Mechanical Lead

Aug 2018Jun 2020 · 1 yr 10 mos

Hindustan coca-cola beverages pvt ltd

Intern

Jun 2018Jun 2018 · 0 mo · Patna

  • Trained in VCRS and plant operations. Management and monitoring of Chilling plant. Efficiency monitoring of automated machines.

Chicane racing india

Technical Team Member

Nov 2017Dec 2018 · 1 yr 1 mo · India

  • Designed cooling system, swingarm and sprockets for 250 cc motorbike.
  • Fabricated Bike with other team Members.

Alankar auto sales and service private limited

Inplant trainee

Jun 2017Jun 2017 · 0 mo · Patna, Bihar, India

Education

SRM IST Chennai

Bachelor of Technology — Mechanical Engineering

Jan 2016Jan 2020

Dr.D Ram DAV Public School

Senior Secondary Certification — Science

Jan 2013Jan 2015

Stackforce found 100+ more professionals with Data Analysis & Sql Server Integration Services (ssis)

Explore similar profiles based on matching skills and experience