Hemantkumar Patel Email & Phone Number

Piscataway, New Jersey, Us

Managing Oracle 12C PL/SQL Projects development, Informatica ETL development for loading daily feeds, CCAR Reporting development at Deutsche Bank - Wall Street, Manhattan, New York - US.Responsibilities• Actively Working on Deutsche Bank CCAR-(Comprehensive Capital Analysis and Review) United States Federal Reserve regulatory Project as Oracle database developer.• Design and development of Oracle database Tables, Indexes, Constraints, Complex Views, Procedure, Functions and Packages for various modules of CCAR project.• Managing user privileges, synonyms and other objects in multiple database e.g ODS, FEED, LOB, MES.• Managing table’s and Index data into proper tablespace for better performance, move any index if created in data table space.• Closely working with DBA and production support team for database Geneos alerts on high resource consuming SQLs. Deep dive into explain plan (Access method, Join method, Join order etc) and identify best options e.g new index, index hint, sql joins. • Identify large tables’ data for archiving and use Oracle 12C new feature to Compress and archive at table level.• Convert normal table to partition table with proper index, for very large tables.• Identifying current Database and ETL processes to automate to remove manual activities. • Ensure all SQL, PL/SQL code are develop as per Deutsche bank standard and all changes are recorded for audit requirements.• Guide junior oracle developers and have code review with them to ensure better quality of code before deployment. • Development of new/existing Informatica workflows – linking different source, mapping, setting dynamic parameters, and target ODS database, and logging job status, file counts for auditing, configure workflows in Control-M.• Managing each release with Code management and deployment using IntelliJ, JIRA, and Git Bit Bucket.Environment: Oracle 12C, SQL Developer, ETL – Informatica 8, IntelliJ, Control-M, JIRA, Bit Bucket, Putty, Samba server.

Piscataway, New Jersey, Us

Managing Oracle 11g PL/SQL projects development along with Data Migration, Microsoft SSIS - Kingsways tools for ETL and BI Publisher Report Developer at NYC-Administration for Children's Services - Manhattan, New York - US.• Architect, Design and Develop Database Migration solutions for various projects. • Analyzing Business Process Model and design database Tables, Indexes and other objects.• Develop PL/SQL code as per business requirements using AGILE method.• Prepare Shell scripting to do Linux corn jobs such as daily scheduled jobs for different feed for application.• Development of ETL Package in SSIS and Kingsway to feed data from Oracle to Microsoft Dynamics 365 cloud database and Report design/develop Complex reports.• Code & Release management using TFS and DEVOPS for deployment to QA, UAT and Production. • Provided functional and technical guidance on database best practices to team members for Implementation.

Piscataway, New Jersey, Us

Managing Oracle 11g pl/sql projects development along with Unix shell scripting at Client Barnes and Noble - Manhattan, New York - US

Managing Large Projects - Implementation,Technical Consultant to project on Oracle pl/sql

Columbus, Ga, Us

Mba, Finance

B.E, Metallurgy