Visual Studio
Akash Shrivastav
PLSQL Developer
Mumbai,MH
Summary
Results-driven IT Analyst with expertise in SQL/PLSQL and performance optimization, honed at Tata Consultancy Services. Proven track record in enhancing application efficiency through advanced data manipulation and robust error handling. Strong collaborator in Agile environments, adept at aligning technology solutions with business objectives while ensuring high-quality outcomes.
Rational PLSQL Developer with 6 years of experience enhancing operations for organizations through information systems solutions. Proven track record of transforming specific business goals related to growth and efficiency improvements into new system designs. Knowledgeable innovator known for recommending new technologies to enhance existing systems and introduce new systems.
Overview
6
6
years of professional experience
Work History
IT Analyst
Tata Consultancy Services
03.2022 - Current
- Working on an ETL based application which extracts data from SAP, CSV files and other database and perform complex transformations using stored procedures to produce the desired output.
- Creating architecture for database and helping with proficient SQL queries for front end applications.
- Proficient with stored procedures, functions, package, triggers, transactions , views and materialized view.
- Performance tuning of ETL jobs( tunning of views and materialized view refresh) using indexing and hints. Up to mark familiarity with Explain Plan features and AWR report analysis to check for performance.
PLSQL Developer
Infosys Ltd
08.2019 - 03.2022
- Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
- Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
- Built databases and table structures for web applications.
- Collaborated effectively within an Agile development environment to rapidly respond to changing priorities while maintaining high-quality results.
- Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
- Maintained database documentation for accurate record-keeping and easy reference for colleagues.
- Worked closely with business analysts to translate requirements into functional specifications, ensuring alignment between technology solutions and business needs.
SAP BI Consultant
Infosys Ltd.
08.2019 - 03.2020
- Developed strong working relationships with vendors and suppliers, ensuring a reliable supply chain for critical resources.
- Supported organizational objectives by aligning SAP BI strategies with overall business goals and priorities.
Education
Bachelor of Technology - Information Technology
St. Thomas College of Engineering And Technology
Kolkata, India 04.2001 -
Intermediate Certificate - Science Education
Guru Gobind Singh Public School
Bokaro Steel City, India 04.2001 -
Metriculate - General Studies
Guru Gobind Singh Public School
Bokaro Steel City, India 04.2001 -
Skills
IT troubleshooting
Software
PLSQL Developer
Oracle Developer
Anypoint Studio
Eclipse IDE
SAP BI GUI
Interests
API development
Backend automation
Timeline
IT Analyst
Tata Consultancy Services
03.2022 - Current
PLSQL Developer
Infosys Ltd
08.2019 - 03.2022
SAP BI Consultant
Infosys Ltd.
08.2019 - 03.2020
Bachelor of Technology - Information Technology
St. Thomas College of Engineering And Technology
04.2001 -
Intermediate Certificate - Science Education
Guru Gobind Singh Public School
04.2001 -
Metriculate - General Studies
Guru Gobind Singh Public School
04.2001 -
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
JEYA SEKAR DHASNEVIS VINOTH JEYA SEKAR DHASNEVIS VINOTH null
Production Manager at FREELANCEProduction Manager at FREELANCE