Abhishek Ranjan

Associate Consultant

Bengaluru, Karnataka, India4 yrs 6 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Expert in PL/SQL programming and debugging.
  • Designed dashboards that increased user engagement by 20%.
  • Achieved 75% reduction in post-deployment defects.
Stackforce AI infers this person is a Data Analyst with strong expertise in BI and SQL technologies.

Contact

Skills

Core Skills

Data AnalysisData VisualizationBusiness Intelligence (bi)C#Asp.net

Other Skills

.NET Core.NET FrameworkAJAXASP.NET CoreActive Server Pages (ASP)Analyst RelationsAnalytical SkillsAngularApplication MonitoringApplication SupportApptioAzure DatabricksBusiness ProcessC (Programming Language)C# in .NET

About

B.e(Computer Science and Engineering) at Visvesvaraya Technological University

Experience

Infosys

5 roles

Technology Analyst

Promoted

Jul 2024Present · 1 yr 8 mos

  • With expertise in development, maintenance, and post-implementation support, I have extensive experience in PL/SQL programming, debugging PL/SQL code and UNIX scripts, and conducting root cause analysis to enhance Oracle PL/SQL packages, procedures, triggers, and functions. I have resolved 95%+ of technical issues proactively, reducing resolution time by 30%, and ensuring 100% data accuracy through in-depth SQL analysis. Skilled in modifying functions based on PRCRs, I also create complex SQL queries using CTEs and develop optimized DAX expressions for advanced calculations and data modeling in Power BI. My work includes designing interactive dashboards to track KPIs and security metrics, increasing user engagement by 20%, and enabling seamless data navigation through dynamic visuals. Proficient in Excel for advanced data analysis, I also manage Change, Problem, and Incident Management using ServiceNow and effectively estimate requirements for efficient planning and execution.
Data WarehousingOracle SQL DeveloperData VisualizationData AnalysisMicrosoft Excel MacrosData Modeling+9

Associate Consultant

Oct 2023Jun 2024 · 8 mos

  • Experienced in data analytics and reporting support using SAP Business Objects with an Oracle PL/SQL database, specializing in maintaining and modifying reports as per business needs. Proficient in executing DML operations, designing efficient stored procedures, functions, and PL/SQL packages to enhance data processing speed by 75% and improve system performance. Adept at conducting impact analysis with 360 Eye Suits, optimizing report performance, and enhancing existing universes based on user requirements. Skilled in identifying and resolving database errors, managing service requests and incident tickets through Cherwell and JIRA, and ensuring timely issue resolution with minimal downtime. Strong in business logic implementation, requirement analysis, and stakeholder communication. Highly proficient in Microsoft Excel for in-depth data analysis, leveraging advanced functions such as VLOOKUP, HLOOKUP, PivotTables, and custom formulas to organize, interpret, and present data effectively.
Microsoft Power BIData WarehousingBusiness ProcessApplication MonitoringBusiness Intelligence (BI)Master Data Management+15

Senior System Engineer

Oct 2022Sep 2023 · 11 mos

  • Experienced in Windows application development and support on AutoCAD (C#) with Oracle PL/SQL as the backend, including maintaining and modifying ETL packages. Skilled in planning deployments across DEV, SAT, and production environments, collaborating with development teams for enhancements and bug fixes, and providing support for new code changes as well as existing applications. Adept at handling user tickets, maintaining knowledge transfer documents, and delivering KT for newly added modules. Worked on GIS technology concepts within AutoCAD applications and actively participated in Agile practices such as daily stand-ups, sprint planning, and retrospectives. Committed to delivering clean, modular, and well-documented code, achieving a 75% reduction in post-deployment defects while ensuring scalability and ease of maintenance, along with comprehensive technical documentation for complete requirement traceability and regulatory compliance.
.NET CoreASP.NETData WarehousingEntity Framework (EF) CoreApplication MonitoringDatabases+25

System Engineer

Jun 2021Sep 2022 · 1 yr 3 mos

  • Experienced in Windows application development and support on AutoCAD (C#) with Oracle PL/SQL as the backend, including maintaining and modifying ETL packages. Skilled in planning deployments across DEV, SAT, and production environments, collaborating with development teams for enhancements and bug fixes, and providing support for new code changes as well as existing applications. Adept at handling user tickets, maintaining knowledge transfer documents, and delivering KT for newly added modules. Worked on GIS technology concepts within AutoCAD applications and actively participated in Agile practices such as daily stand-ups, sprint planning, and retrospectives. Committed to delivering clean, modular, and well-documented code, achieving a 75% reduction in post-deployment defects while ensuring scalability and ease of maintenance, along with comprehensive technical documentation for complete requirement traceability and regulatory compliance.
.NET CoreData WarehousingApplication MonitoringDatabasesActive Server Pages (ASP)C (Programming Language)+22

System Engineer Trainee

Mar 2021May 2021 · 2 mos

.NET CoreDatabasesC (Programming Language)Relational DatabasesSQL.NET Framework+5

Edubridge learning pvt. ltd.

Java Full-stack Developer

Oct 2019Feb 2020 · 4 mos · Bangalore Urban, Karnataka, India

  • Java
DatabasesRelational DatabasesSQLAnalytical SkillsProblem Solving

Provab technosoft pvt. ltd.

PHP Developer

Jul 2019Jul 2019 · 0 mo · Bengaluru, Karnataka, India

MySQLAJAXDatabasesPHPRelational DatabasesPhpMyAdmin+1

Education

Visvesvaraya Technological University

Bachelor of Engineering - BE — Computer Science and Engineering

Jan 2016Jan 2020

Stackforce found 100+ more professionals with Data Analysis & Data Visualization

Explore similar profiles based on matching skills and experience