Ashish Mehrotra
Noida
Summary
Dedicated and detail-oriented Senior Engineer with almost seven years of experience in database management, data analytics, and software development. Expertise in designing and optimizing databases, creating insightful dashboards, and transforming data into actionable insights. Proven ability to ensure quality, performance, reliability, and security across various applications. Innovative engineer with background in diverse engineering projects, including design optimization and process improvement. Strong analytical skills, adept at problem-solving and implementing efficient solutions to enhance productivity. Proven ability to lead teams towards achieving project goals within deadlines, significantly improving operational efficiency and reducing costs.
Overview
7
7
years of professional experience
Work History
Senior Engineer
Indus Valley Partners
04.2024 - Current
- Managed and optimized database systems, ensuring data integrity and performance.
- Created and implemented advanced SQL queries for data analytics and reporting.
- Developed interactive dashboards and reports using Power BI and SSRS to support business decision-making.
- Analyzed data trends and generated actionable insights for organizational strategy.
Engineer
Indus Valley Partners
08.2021 - 04.2024
- Designed and developed complex database programs, adhering to V3 standards.
- Led the development of Oracle SQL functions, procedures, triggers, and packages.
- Ensured optimal performance through thorough testing and tuning techniques.
- Contributed to database compliance and standardization efforts.
Associate Engineer
HCL Technologies
09.2018 - 08.2021
- Managed Layer 2 Ethernet provisioning, focusing on routing and switching technologies (VLAN, EIGRP, BGP).
- Applied SQL commands and Workbench to support database-related tasks and network solutions.
Education
B.Tech/B.E. - Computer Science
Invertis University
Bareilly01.2018
Class 12th -
Uttar Pradesh Board
Bareilly06-2014
Class 10th -
Uttar Pradesh Board
Bareilly06-2012
Skills
- Advanced data analysis techniques
- Predictive modeling
- Trend analysis
- Statistical methods
- Designing databases
- Implementing databases
- Highly available databases
- Secure databases
- Efficient databases
- Data warehousing solutions
- ETL processes
- Data integration
- Large-scale data transformations
- Integrating SSRS
- Optimizing report performance
- Power BI
- Optimizing SQL queries
- Indexing
- Query rewriting
- Execution plans
- Troubleshooting slow-running queries
- Database performance issues
- Database tuning
- Building client relationships
- Effective communication
- Delivering tailored solutions
Languages
- English (Fluent)
- Hindi (Fluent)
Tools Used
- SQL Server Management Studio 2016
- SQL Server Management Studio 2019
- MySQL 8.0.40
- Power BI
- VS Code
- Visual Studio 2019
Timeline
Senior Engineer
Indus Valley Partners
04.2024 - Current
Engineer
Indus Valley Partners
08.2021 - 04.2024
Associate Engineer
HCL Technologies
09.2018 - 08.2021
B.Tech/B.E. - Computer Science
Invertis University
Class 12th -
Uttar Pradesh Board
Class 10th -
Uttar Pradesh Board
Similar Profiles
Rakesh SinghRakesh Singh
Manager– Fund Accounting at Indus Valley Partners LtdManager– Fund Accounting at Indus Valley Partners Ltd
Mansi MaheshwariMansi Maheshwari
Product Analyst at Indus Valley PartnersProduct Analyst at Indus Valley Partners
Ayushi SharmaAyushi Sharma
Business Analyst at Indus Valley PartnersBusiness Analyst at Indus Valley Partners
Himanshu JainHimanshu Jain
Architect at CognizantArchitect at Cognizant
ANSHU GARGANSHU GARG
SDE-1 & AI-Engineer at IQ-LINE PVT. LTDSDE-1 & AI-Engineer at IQ-LINE PVT. LTD