Sameer Gupta Email and Phone Number
Sameer Gupta work email
- Valid
Sameer Gupta personal email
- Valid
* Total 18+ years of experience in PL/SQL development, DB Shell Scripting and DB optimization* Expertise in Data Expertise in Data Analysis, Data Extraction, Transformation, Loading, Performance Tuning of Applications and overall management of mission-critical database-related applications Analysis, Data Extraction, Transformation, Loading, Performance Tuning of Applications and overall management of mission-critical database related applications.* Worked extensively in Oracle development (9i/10g/11g/12c), including SQL and Stored Procedure-writing skills (PL/SQL), Oracle performance tuning and complete project development lifecycle.* Hands-on experience in writing UNIX shell scripts and managing all configuration level activities.* More than Two-year experience with OEDQ in Barclays to screening customers and generate new reports.* Hands-on experience to work over excel to help process automated (Using excel functions and writing simple macros etc.)*Strong database design and development fundamentals and experience in requirement analysis.* Engaged in database designing and modelling using Oracle, undertaking data analysis, database modelling, suggesting best DB model practices, DB replication strategies using MV, Remote DB Links, SQL Loader, and Physical Standby DB creation for BI Users; imparting DBA support involving PL\SQL coding, Call Webservices like BIP reports using soap services using PL/SQL scripts, RMAN and Data Guard implementation.* Imparting Database Architect Support; engaged in DB performance tuning using AWR REPOR analysis and other tools such as TKPROF, Stats Pack, and Explain Plan for reporting intensive DB.* Extensive experience in writing and tuning complex sub-queries, SQL, PL/SQL stored procedures functions, and triggers.* Expertise in Application Tuning by incorporating query optimization techniques such as using Bulk SQL, Bulk binding, Collections, providing hints and table partitions.* Experienced in gathering requirements, preparing program specifications for change requests and enhancements, performing Code reviews and Unit Tests, and providing production support to resolve critical production issues promptly.* Hands-on experience in working over Oracle Apex19.1 to create a Dashboard and minimum effort screen for daily file process status and Alerts for the Support team.* Architect and design high-quality, high-performance solutions that meet the requirements defined to solve the business needs.* Domain experience in Payment Services, Finance, Capital Market and Banking.
Ngts
View-
Senior ConsultantNgts Oct 2022 - PresentNcr
-
Lead Dev EngineerMastercard Aug 2021 - Oct 2022Pune, Maharashtra, India* Working as DB Team Lead and technically supporting to team and clientInvolving in business requirements, analysis for each and every new development and change* Understanding the Functional, Technical & Business requirements and designing Data Model and Design documents.* Responsible for writing/reviewing data load scripts, Creating Package, Procedures, Trigger* Responsible for delivering Work Orders in terms of providing Data Extracts, complex Sqls* Supporting Product… Show more * Working as DB Team Lead and technically supporting to team and clientInvolving in business requirements, analysis for each and every new development and change* Understanding the Functional, Technical & Business requirements and designing Data Model and Design documents.* Responsible for writing/reviewing data load scripts, Creating Package, Procedures, Trigger* Responsible for delivering Work Orders in terms of providing Data Extracts, complex Sqls* Supporting Product Owner/ Business Analysis in creating user stories and acceptance criteria.* Continuous discussion with business team to validate the business, preparing business impact analysis and Low-level document. * Mainly involving in PPM related requirements, Estimation, Analysis and design database. * Involving in design, review, testing, deploy, delivery and business support.* Managing short Team and Responsible for PPM delivery (End to End). Perform data analysis and generate ad-hoc reports for the queries by the business users. Writing UNIX shell scripts, Source Code maintenance.* Support on critical Go-Lives of the identified data batch feeds to production* Provide Support to L3 team for debug, enhancement, problem resolution etc.* Use of Splunk, Dynatrace tool for alerts, log management and monitoring critical activity Show less -
Pl/Sql Technical ManagerTech Mahindra Nov 2006 - Oct 2021Pune* Worked as DB Team Lead and technically supporting to team and client* Understanding the Functional, Technical & Business requirements and designing Data Model and Design documents.* Responsible for writing / reviewing data load scripts, Creating Package, Procedures, Triggers, BIP Report generation, Calling Web services using PL/Sql methods.* Supporting Product Owner/ Business Analysis in creating user stories and acceptance criteria.* Continuous discussion with business team… Show more * Worked as DB Team Lead and technically supporting to team and client* Understanding the Functional, Technical & Business requirements and designing Data Model and Design documents.* Responsible for writing / reviewing data load scripts, Creating Package, Procedures, Triggers, BIP Report generation, Calling Web services using PL/Sql methods.* Supporting Product Owner/ Business Analysis in creating user stories and acceptance criteria.* Continuous discussion with business team to validate the business, preparing business impact analysis and Low-level document. * Mainly involving in PPM related requirements, Estimation, Analysis and design database. * Involving in design, review, testing, deploy, delivery and business support.* Managing short Team and Responsible for PPM delivery (End to End). * Perform data analysis and generate ad-hoc reports for the queries by the business users. Writing UNIX shell scripts, Source Code maintenance.Responsible, Testing - unit testing & integration testing* Support on critical Go-Lives of the identified data batch feeds to production. Show less -
ProgrammerRoyal Datamatics Private Ltd Aug 2003 - Nov 2005New Delhi Area, India
Sameer Gupta Skills
Sameer Gupta Education Details
Frequently Asked Questions about Sameer Gupta
What company does Sameer Gupta work for?
Sameer Gupta works for Ngts
What is Sameer Gupta's role at the current company?
Sameer Gupta's current role is Lead PL/SQL developer| Data Modeller | DB Shell Scripting and DB optimization | Data Analysis using python MongoDB l Airflow.
What is Sameer Gupta's email address?
Sameer Gupta's email address is ir****@****hoo.com
What schools did Sameer Gupta attend?
Sameer Gupta attended National Institute Of Electronics & Information Technology (Nielit).
What skills is Sameer Gupta known for?
Sameer Gupta has skills like Project Management, Microsoft Office, Requirements Analysis, Business Analysis, Sdlc, Sql, Software Project Management, Oracle, Team Management, Pl/sql, Unix, Oracle Enterprise Data Quality Tool.
Not the Sameer Gupta you were looking for?
-
Sameer Gupta
Mumbai -
Sameer Gupta
Gurugram -
1sobha.com -
Sameer Gupta
Delhi, India -
Sameer Gupta
Bengaluru
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial