Aditya Gupta
Associate Manager @ Accenture || Oracle Database Design & Development || Advanced PLSQL || Data Analytics || Performance Tuning || IT Service Management || IT Service Operations
- Role
- Packaged App Development Assoc Manager at Accenture
- Location
- Mumbai, MH, IN
- LinkedIn followers
- 500 followers
About Aditya Gupta
Experience Summary-Over 20 years of IT experience with:* Oracle Database Design & Development (8 year)– Oracle databases 23ai/19c/12c/10g /8.0/7.3, Oracle SQL, PLSQL, Advanced PLSQL, Materiazed Views, DB Scripts, Dynamic SQLs, Data Migration etc. Database Design: Conceptual, Logical and Physical Models, ER-Diagram; Interfaces for ETL/BI/DWH workloads. Performance Tuning: SQL Tuning, Execution Plan, AWR. Certifications: Oracle Database 19c Program with PLSQL, Oracle database 12c: SQL Fundamentals.* IT Service Management (8 year)– Application Support, Service Operations, Technical Support & Troubleshooting. ITIL Processes: Incident Management, Change Management, Problem management, Request Fulfilment, CMDB, Knowledge Management etc. Ticketing Tool: ServiceNow; Certification: ITIL Foundation.* Project Management (4 year)- Agile, Scrum Framework; PMO, Quality Manager, Team Lead; Scope Management, Cost Management, Time Management, Quality Management, Risk Management; Certification: PMP, Certified Scrum Master. Tools: MS Project, Whizible, TCS In-house applications.* Application Development (4 year)- Requirement Study, Design, Coding, Testing, Implementation & Go-Live; Post-implementation support, Application Enhancements, Maintenance & Bug-fixing etc. Technologies: Oracle Forms, Oracle Reports, PLSQL, Oracle SQL, UNIX/Linux DB servers, etc.* Cloud Computing- AWS: EC2, S3, RDS, ECS; OCI: DB instances, OCI Gen AI, 23ai: Vector Search, Certification: AWS Certified Cloud Practitioner, Oracle Database Cloud Services.* Data Analytics- Oracle 19c DWH, Power BI, OBIEE* Other Databases- MS SQL Server (1 year); PI Historian (2 year)* Overseas Client/Locations (3 year)- Canada, Hong Kong, South Africa, Sweden, China, and SingaporeIndustries worked with-* Oil & Gas Upstream (10+ year)- Tieto Energy Components, OSISoft PI, PARCView, PVR (CGI), SchematicPro, Aspen HYSYS, Ambience etc.* Banking & Financial Services (6 year)– TCS-BaNCS a Core-banking Application* Cargo Logistics (4 year)– Export/Import Terminal Management for International Cargo* Manufacturing (4 year)- AR, AP, GL, OE Modules; AVALON-ERP
Experience
Packaged App Development Assoc Manager
Jan 2023 — Present · Navi Mumbai, IN
at ACCENTURE 15. Client: Halliburton – Since Sep 2025Team Size: 50+Oracle Database Develper & Data AnalystRole & Responsibilities: Oracle Database 19c - DWH Server design and development. PLSQL, Advanced PLSQL, SQL. Working in Packages, Procedures, functions. Development, Testing, UAT and Prod release.14. Client: TC Energy, Calgary, Canada – from Apr 2025 to May 2025Worked on Construction and Monitoring Report (CMR-K2) Application for performance enhancement. SQL Server DB, T-SQL, Working in Stored Procedures and Views. Development and Testing.13. Client: Repsol, Madrid, Spain – from Dec 2024 to Feb 2025Energy Components App SupportGlobal application Support of Energy Components Applications Team Size: 20+Role & Responsibilities: Application Technical Support and Development for Energy Components, Extensive use of Oracle SQL & PLSQL.12. Client: Cenovus Energy Inc, Calgary, Canada – from Dec 2015 to Nov 2024 (9 year)at ACCENTURE + DXC TECHNOLOGY + PRIMUS GLOBALApplication Support Lead (IT Application Support & Database Development)Account: Application Services for Oil & Natural Gas, Upstream ApplicationsAccount/Team Size: 200+A Global Delivery Model, ITIL Framework, SLA Based DeliveryApplication Support and Management- Packaging & Deployment (SCCM & App-V); Configuring new applications/upgradation, retirement/decommissioned IT resources; Application availability and outage management. Access Provision with AD groups; Technical support to business users. CMDB for mapping IT resources. Coordination with all required support/Infra teams.Tieto Energy Components (EC)- a Hydrocarbon Accounting (HCA) and Management (HCM) Application. Primary Support for EC Conventional and Oil Sands Applications, SOX Audit, regular RFCs etc. Well creation, Daily & Monthly allocation. Scheduled job configuration and rerun.OSISoft PI- PI Historian database, PI Tag maintenance, Interfaces with Parcview, EC etc. Security Patching on all app/db servers.
Education
Jiwaji University (JU), Gwalior
Bachelor of Science - B. Sc., Mathematics, Physics and Geology
Maulana Azad National Institute of Technology
Master of Computer Applications - MCA
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.