Ashutosh

Sr. Software Engineer
placeholder
Location Noida
view-icon
Total Views24
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 10 Year
  • Cost
    Hourly Rate$10
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnAugust 12, 2022
Key Skills
Oracle PL/SQL SQLUnix Shell ScriptingSplunk
Summary

EXPERIENCE SUMMARY

 

  • Total 9 years (Including Onsite 6 Months) of IT experience in Scrum, Production Support and Development Projects.
  • Expertise in SPLUNK reporting (Dashboard, Alerts).

·        Expertise in PL/SQL (Oracle 9i/ 10g/ 11g/ 12c) programming like writing Packages, Store Procedures, Functions, Collection and Triggers in Oracle.

·        Expertise in writing, Batch Jobs in UNIX for data processing and Complex Sql Queries.

·        Expertise in Performance tuning (Oracle 9i/ 10g/ 11g/ 12c) using Hints, CBO, Explain Plan, SQL_TRACE, Table Compression and Partion on Table in Oracle.

·        Having more than 4 years working experience in scrum team.

·        Having knowledge of, Meastro tool for Batch Job Scheduling and Remedy tool for incidents.

·        Expertise in database de-normalization.

·        Expertise to use and create External Table instead of SQL LODER for data processing from one environment to another environment.

  • Provided technical production applications support and assistance to customers.

·        Having domain knowledge of Insurance, Manufacturing, Logistics, Retail and Pharmaceutical Companies.

·        3 year development experience on Oracle Forms (Forms 6i/10g/11g/12c). 

·        Currently associated with Vinculum solutions and client is DP world Dubai.

Excellent interpersonal & communication skills, better understanding of client’s expectation and strong problem solving abilities


WORK PROFILE

 

v Currently working for SkillNet Solutions, 05h June’2019 to till date.

 

Project Details

Project #1    : ELC

Company      : SkillNet Solutions

Client           : Estee Lauder Companies   

Team Size     : 8

Duration       : 10th June 2019 to till date

Role             : System Analyst

Tool Use       : PL/SQL Developer, Putty, WinSCP, JIRA

Environment  : UNIX.

Technology   : SQL, PL/SQL, SQL Loader, Java, Salesforce, SPLUNK

 


WORK PROFILE


 Currently working for SkillNet Solutions, 05h June’2019 to till date. 


Project Details

Project #1 : ELC

Company    : SkillNet Solutions 

Client      : Estee Lauder Companies

Team Size    : 8

Duration     : 10th June 2019 to till date

Role       : System Analyst

Tool Use     : PL/SQL Developer, Putty, WinSCP, JIRA 

Environment  : UNIX.

Technology   : SQL, PL/SQL, SQL Loader, Java, Salesforce, SPLUNK


Description:

ELC is the global leader in prestige beauty. It deals in cosmetic products. Through ELC project, they are enabling the retailing in multiple European countries. In this project, SAP sends the file to middleware and then middleware team send the data in XML format to us, we extract & load the XML files and then salesforce teams process it & vise versa. 


Roles and Responsibilities: 

• Debug and develop the new packages.

• Create or Modify database objects like Materialized View, Packages, Triggers and Views.

• Performance Tuning for large queries.

• Extract and load the XML files to tables

• Create interactive dashboard in SPLUNK using DB input and other files input.

• Solve the technical issues of colleagues.


 Worked for Vinculum Solutions, 24th April’2018 to 10th May 2019. 

Roles and Responsibilities:

  • Debug and develop the new packages.
  • Create or Modify database objects like Materialized View, Packages, Triggers and Views.
  • Performance Tuning for large queries.
  • Extract and load the XML files to tables
  • Create interactive dashboard in SPLUNK using DB input and other files input.
  • Solve the technical issues of colleagues.

 

v Worked for Vinculum Solutions, 24th April’2018 to 10th May 2019. 


Copyright : 2022 – OnBenchMark All Right Reserved.