TANVY UPADHYAYA

MANAGER/DEVELOPER (ORACLE/EBS) · 732-***-****

Woodbridge, New Jersey

ad2mwr@r.postjobfree.com · www.linkedin.com/in/tanvy

PROFESSIONAL SUMMARY

Development [Domains: Banking/Finance, Retail & Healthcare]-

•13 years of programming experience as a Solutions Architect, Oracle Developer in Analysis, Design and Implementation of Business Applications using the Oracle RDBMS & ETL Logic

•Involved in all phases of the SDLC from analysis, design, development, testing, deployment

•Strong experience in Data warehouse concepts, ETL & Reports (SSIS & SSRS)

•Developed Complex database objects such as Stored procedures, Functions, Packages & Triggers using SQL & PL/SQL

•Experience in Dynamic SQL, PLSQL Collections & Exception Handling & Oracle Analytic Functions, Oracle hierarchical queries

•Experience in working with Cursors, Ref Cursors, Oracle Collections, Partitioned tables, Exchange Partition Options & Transportable tablespaces

•Experience in Performance Tuning- SQL tuning using Explain plan, SQL Trace, SQL Tuning Advisor, TOP commands, HINTS

•Experience with Oracle EBS – Finance modules mostly worked on AP & GL

•Extensive experience with Scrum, JIRA, AGILE methodologies

•Excellent communication, interpersonal & analytical skills and PROJECT management skills

TECHNOLOGY

•Stored Procedures, Triggers, Functions, Packages, Exception handling, PLSQL Collections, Bulk Collect, Cursors, Performance Tuning, Index management Partitioned tables, Global & Local Indexes, Code debugging

•MS – SSIS/SSRS, ETL, Data warehouse concepts, Oracle SQL*Loader

•Oracle Datapump utility, SQL Joins, Sub-queries, Analytic Functions, Oracle Functions, SQL_TRACE, TKPROF, Explain Plan, AWR

•SSIS & SSRS, SQL Loader, Oracle External tables

•Oracle EBS – AP & GL & XML reports

•Oracle Versions Exadata, 9i, 10g, 11g & 12c (RAC), SQL Server Versions 2008 R2 & 2016

•Oracle SQL Developer, TOAD, SSMS, BIDS, SCP, Win SCP, Putty

•SQL Trace, ADDM SQL Tuning advisor, AWR analysis, OEM Grid control

• Agile & Version control - Jira, TFS, SCRUM, VersionOne, ConnectWise, Git, Bitbucket, SharePoint,

SmartSheet

WORK EXPERIENCE

Project Analyst/Sr. Developer July 2021 – Present

Wakefern Food Corp.

Development of EBS finance AP & GL modules using appropriate responsibilities

Project Management – assigning project work allocation within team members, follow up

Involved in product upgrades, planning and business requirements

Communicating business/technical requirements to the team and users

Management of Oracle Apex applications, extensively worked on SQL coding for PRF (internal application)

Building SQL Queries for Oracle EBS reports

Developing Stored procedures, Functions, Triggers for internal applications

Extensive SQL coding for Oracle EBS customization of reports (GL, AP, AR modules)

Extensive SQL coding for Oracle SCM (I-procurement) reports and requisitions

Oracle Ipro Production support; Coordinating with users and store members for SCM requirements

Creating new user setup for Ipro; Ipro hierarchy management and testing requisitions

Creating new buyers setup in the Ipro & testing requisitions

Creating SR with Oracle support based on user experiencing errors and troubleshooting

Building ETL logic for consolidated reports using SSIS and Oracle (SFS Reports)

[Environment- Oracle 12c RAC Exadata, Oracle ERP- EBS Reports, Ipro, SCM]

ORACLE Developer/ Sr. Architect (Contract) September 2020 – July 2021

Insight Global Client- Bank of America [New York, USA]

Leading a team of 8 people for the Ladon Project, creating new reports using Oracle procedures with Python UI – HORIZON JIRA project

Migration of PL/SQL code and testing another schema/application

Developing Stored Procedures, Triggers, Functions, SQL Queries for metrics calculation, reconciliation, daily, monthly, quarterly data analysis

Code Release planning and release management (Python and Oracle)

Preparing scripts for migration of data from development to staging to Production release & version control

Modification of SQL queries for python related applications

[Environment- Oracle 12c RAC Exadata, PL/SQL]

ORACLE Applications Developer/ DBA (Contract) April 2019 – August 2020

Collabera Client- Fiserv, Tegra118 [New Jersey, USA]

Developing Stored Procedures, Triggers, Functions

Extensive PLSQL coding using Oracle Collections

Setting up multi-tenant schema and data population, code migration &ETL

Performance tuning/designing partitioned tables/ index management

Extensively working on partitioned tables, exchange partitions and developing related stored procedures

Preparing scripts for migration of data from development to staging to Production release & version control

Responsible for implementing Change Management & Version Control, both procedural and technical code

Designing E/R Models for better understanding of schema

[Environment- Oracle 12c RAC Exadata, Multi-Tenant Arc. PL/SQL]

Oracle DBA/Developer (Full time Permanent) June 2018 – April 2019

Ungerer & Company [New Jersey, USA]

Design E/R Models & solve critical database issues; space management

Apply PSU patches & design data migration plans

Implement Oracle FGA using custom made PL/SQL procedures, custom made functions to setup Oracle’s VPD & database maintenance tasks

Test & Implement Oracle’s RMAN backup & recovery policies

Performance tuning & designing database refresh procedures for test environments

[Environment- 2 node RAC Oracle 11gR2, SQL Server 2012, MySQL]

SR. Oracle Developer/DBA (Permanent) June 2012 – July 2017

Citiustech (Mumbai, India)

Worked on numerous US Healthcare domain projects for clients GE (General Electric), Hyland software, Ability Networks)

Working with clients, information architects, system admin and developers to define information flow helping to transform business requirements into environment specific databases

Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)

PL/SQL Development & Coding

Configuring TAF & database services, testing failover operations for RAC

Performed ongoing patches both rolling & downtime patches

•Performed Database Refresh from Production to QA, Staging and Development databases using shell script.

•Implementing BDD code and packages in the staging environment

•Configuring RMAN backup & testing recovery including flashback recovery

•Maintaining Recovery catalog database

•Creating RMAN auxiliary instance for developers testing environment

•Creating & Managing application users using Authstore application, post database refresh

[Environment- Max db. size 17 TB, OS- RHEL 5.x, Sun Solaris 5.10, Production (3 node RAC), Staging & Testing db.]

Sr. DBA/Developer (Contract) December 2011 – June 2012

Magna Infotech [Mumbai, India]

Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)

Developing and maintaining operational standards/procedures for Oracle

Optimizing database uptime/availability and performing database audits

Creating physical standby for failover and monitoring log sync operations

Managing user accounts

Performance tuning sql and instance

[Environment- Max db. size 5 TB, 2 node RAC setup, standalone databases & physical standby]

Oracle DBA (Permanent) March 2011-December 2011 & July 2007-June 2008

In-Solutions Global [Mumbai, India)

•Oracle Standalone Db. Installation, Design & Maintenance for new project at client side BOBCARDS.

•Implementing Physical Standby Db. on Production environment & Performing DR Drill activity

•Database Purge from Production to the Legacy database

•Monitoring databases for redo log gaps, database users & quota management, creating database objects & index management, DB Links, import & export of data using Datapump

•Creating, Scheduling & Monitoring database backups using RMAN & OEM

•Generating Explain plan, Statspack report & troubleshooting database performance issues

[Environment- Max db. Size 2 TB, Oracle 9i & 10g R2, RHEL 4x; Production & Test db. Standalone with physical standby]

EDUCATION

H.S.C. (Mumbai University, India)

Advance Diploma in Computing & Multimedia (3 years, full time). City College, LONDON.

O.C.P.- Oracle Certified Professional (9i)- YEAR 2004

M.C.S.E.- Microsoft Certified Solutions Expert- BI (Sql Server 2012)- YEAR 2014

PERSONAL DETAILS

Current Location- Woodbridge, New Jersey, USA

Work Authorization- U.S. Citizen

Contact this candidate