Vishwas Gupta
Ghaziabad
Summary
A results-driven professional with more than 8 years of experience in PL/SQL, SQL, Oracle forms and reports, and Unix Shell scripting, currently working at Tata Consultancy Services (TCS). Previously with Nucleus Software Exports Limited, I have extensive experience in writing complex SQL queries, developing stored procedures, packages, triggers, views, and optimizing SQL queries to meet business needs.
Overview
9
9
years of professional experience
Work History
IT Analyst
Tata Consultancy Services
Noida
07.2022 - Current
- Working for the client Petco, an American retailer, to maintain the Oracle PIM application, which is used for maintaining retail attributes of SKUs.
- Created APIs. In Oracle PL/SQL, in the form of packages and procedures, to get data from another application and process it to enrich the PIM. And working from gathering requirements until post go-live maintenance.
- Monitored system performance, identified bottlenecks and optimized the same.
- Expanded or modified system to serve new purposes or improve workflow.
- Development support during deployment, post-go-live support, and bug fixes.
- Providing support for daily DB issues and providing data based on requirements using complex queries.
- Working closely with other team members to check data validity in the PIM application.
Sr. Software Engineer
Nucleus Software Export Ltd.
Noida
08.2016 - 07.2022
- Worked for clients like Duniya Finance, Bajaj Finance Ltd., Bank of Florida, and Agri Bank.
- Developed an ATM system for Agri Bank.
- Enhanced fixed deposit module of Bajaj Finance to book retail and individual FDs, which included the creation of multiple packages, stored procedures, triggers, and views.
- Developed creative forms and business reports using the Oracle Forms and Reports tool.
- Create multiple stored procedures to read and write CSV files using SQL Loader.
- Provided support during deployment, post-go-live support, and bug fixes. Prepared project deliverables, like release notes, deployment documents, and BR documents.
- Working closely with the BAs and the business to identify and analyze software requirements to ensure information is acquired for the detailed design of the reporting solution.
- Involved in the analysis and design of all the change requests that were raised during the UAT phase.
Education
Master of Computer Applications -
Teerthanker Mahaveer University
Moradabad06-2015
Bachelor of Computer Applications -
Teerthanker Mahaveer University
Moradabad06-2012
Intermediate -
UP Board
Amroha06-2009
High School Diploma -
UP. Board
Amroha06-2007
Skills
- Oracle PL/SQL
- Oracle SQL
- SQL Loader
- Performance monitoring
- Oracle Forms and Reports
- Bug tracking
Timeline
IT Analyst
Tata Consultancy Services
07.2022 - Current
Sr. Software Engineer
Nucleus Software Export Ltd.
08.2016 - 07.2022
Master of Computer Applications -
Teerthanker Mahaveer University
Bachelor of Computer Applications -
Teerthanker Mahaveer University
Intermediate -
UP Board
High School Diploma -
UP. Board
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
KUMARJIT DUTTAKUMARJIT DUTTA
Business Development Executive at Beno Support TechnologiesBusiness Development Executive at Beno Support Technologies