Ashutosh

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, 05^h June’2019 to till date.

Project Details

Project #1    : ELC

Company      : SkillNet Solutions

Client           : Estee Lauder Companies   

Team Size     : 8

Duration       : 10^th 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, 24^th April’2018 to 10^th May 2019.