Sameer Gupta Email & Phone Number

* 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.

Listed skills include Project Management, Microsoft Office, Requirements Analysis, Business Analysis, and 8 others.

• 

  National Institute Of Electronics & Information Technology (Nielit)