SUMMARY

• 11+ years of IT experience as an Oracle PL/SQL developer, System Analysis, Design, Development & Support of Oracle Servers 6.0, 8i, 9i, 10g, 11g,12c in Production, Staging, Development environments
• IT Expertise in all phases of the Software Development Life Cycle including analysis, Physical and Logical design, code development, testing, implementing and maintenance.
• Experience in Relational and Dimensional Data modeling, Physical and Logical Data modeling using Toad Data Modler.
• Have good experience in writing PL/SQL scripts for the database objects like Tables, Views, Procedures, Functions, Packages, Database Triggers, Indexes and Sequences.
• Experience in creating different kinds of Partitions on Tables for managing large tables to improve performance.
• Data loading from other databases and text files into Oracle Database using SQL*LOADER.
• Solid experience in performance tuning and Query Tuning (Generating Plan Table, Explain Plan, Optimize with Hints, Analyze, Indexing Strategy, SQL Trace, TKProf ).
• Experience in UTL FILE, DBMS JOBS, DBMS PROFILER, DBMS STATS, DBMS SCHEDULER packages.
• Experience in creating Materialized Views in data warehousing environment.
• Good at shell programming and setting the Crontab for all repetitive database processes in UNIX.
• Familiar with the junior DBA tasks like installing oracle server, creating and managing table spaces, creating users, providing privileges, adding data files.
• Extensive experience in working different FTP clients like SFTP, Win SCP.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail - oriented and problem solving skills in the technology arena.
• Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.

TECHNICAL SKILLS

Databases: Oracle 12c, Oracle 11g, Oracle 10g,Oracle 9i, Oracle 8i, Oracle 6

BI Tools: Crystal Reports XI/6

Utilities: SQL Loader, Export / Import, Expdp / Impdp

Languages: SQL, PL/SQL, UNIX Shell scripting, PERL scripting

Tools: Oracle Enterprise Manager, TOAD 12.1, Putty, F-Secure Client 5.3, SQL Developer 4.2, ERWIN 4.14/4.0, SOAP UI, Dynatrace, HP Load Runner, Toad data Modler, App Dynamics

Operating Systems: UNIX, Sun Solaris 5.8, 5.9, IBM AIX 5.2/5.3 Windows NT, Windows 95/98/2000, Windows XP, Windows 7

Others: MS Office (Word, Excel, PowerPoint, Excess) MS Visio, Adobe Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Application DBA/ Solution Architect

Responsibilities:

• Worked on Strategic Lineage Project to find and produce the End to End Lineages between Applications to meet regulatory commitment.
• Worked on Manta Tool which is a Code Scanning tool to scan different databases like Oracle, Netezza, Sybase IQ, MS SQL Server, Sybase ASE.
• Worked on Informatica EDC Tool which is Data Catalog tool for Object/Metdata Scanning and Data Profiling for Oracle, Netezza, Sybase IQ, MS SQL Server, Sybase ASE, HIVE, Teradata Databases.
• Worked on Solidatus tool which is designer tool to produced end to end Lineage between applications to meet Regulatory Commitment for FR2052 A, FFIEC101 Forms.
• Worked on Procuring hardware and Databases for Manta/Solidatus/Informatica EDC in UAT/PROD.
• Worked with Venders (Manta/Solidatus/Informatica EDC) on different use cases for CITI’s need and on installation in DEV/SIT region on cloud boxes and for Tool’s bug fixes.
• Worked on POC for Waterline ASG Rochade, Global IDs Tools for Strategic Data Lineage Project to validate the CITI’s use cases and tool performance.
• Worked on Performance Tuning on reporting queries to improve the performances in UAT/PROD environment in Finance Full Suite Project in NAM, APAC, EMEA, China, Mexico Region for Oracle, Netezza Databases.
• Worked on Writing SQL queries for generating trace of the data for FRY9C, FR2436, FRY14Q forms for Data Tracing Project.
• Worked on Raising Databases requests and Creating FIDs and migrating DSMT Feed and reference data in Data Verse Project.
• Worked on Different Projects in Parallel as per CITI’s need.

Confidential

Oracle Application DBA/ Data Modler

Responsibilities:

• Created Logical and Physical Data Models for Regulatory Reporting forms (US/LOCAL/INTERNATIONAL).
• Created Tables, Indexes, Views, Store Procedures, Triggers for based upon the logical data model.
• Worked on performance tuning on reporting queries in development, testing, production environment using AWR reports.
• Worked on educating UI/Reporting team for how to use the data model and write proper sql queries and worked with ETL team for data loading strategies.
• Worked with Production support team /L3 Support team to monitor and support the application in UAT/PROD environment.
• Worked with application users for archival and purging strategies on reporting data.
• Created DB Links between UAT/PROD environment and other databases for data retrieval and environment setup.
• Worked on migrating SYBASE tables into Oracle tables with data.
• Used Hints, Explain Plans, Indexes, partitions to improve the performance of the query.
• Worked on all database code migration from SIT (QA) to UAT/PRODFIX/PROD environment.
• Worked on onboarding ORASS (Oracle Cloud) into reginsight application.
• Worked on onboarding HERMES, RTC, RLM (Code Migration tool).
• Worked on PROD/UAT/SIT (QA) issues and defects.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in Production Daily Job Monitoring jobs using Cycle View.
• Working on solving production defects.
• Involved in data loading files through shell script.
• Worked on small modules assign by the project manager.
• Optimized and enhanced the existing procedures and SQL statements for the better performance using EXPLAIN PLAN to tune SQL queries.
• Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
• Generating csv report by using SQL scripts.

Confidential

Oracle Application DBA/Developer

Responsibilities:

• Involved in estimation, design, built, test, deployment, support phases in agile methodology.
• Worked with Product owner and Business Analyst to gather the business requirements.
• Installed oracle 11g server and created database in liquid servers.
• Created new schemas for liquid database for testing purpose.
• Created physical database design diagram in toad data modler and generated ddls from it.
• Created Tables, Indexes, Views, Packages, Functions for AUTOD Project.
• Wrote script to retrieve DDLs from database for all the database objects using DBMS METADATA package.
• Did unit testing for database module and QA testing for Java module.
• Used Associative array to find and then dynamically generate PL/SQL code blocks.
• Created triggers on table for audit and reporting and purpose.
• Created crystal reports for Texas State for EFS (Electronic Funding System) Texas Application.
• Worked on Soap UI for web service testing.
• Created packages and procedures for the client mobile and consumer mobile portal for Chase Quick Pay Application.
• Used ref-cursor to capture many rows within a PL/SQL block to send the data to Java middle tier.
• Performed Exception Handling on pre-defined and user-defined exceptions.
• Used DBMS PROFILER package to understand where the code is spending the most time, detect it and then optimize it.
• Optimized and enhanced the existing procedures and SQL statements for the better performance using EXPLAIN PLAN to tune SQL queries.
• Used Bulk Collect in the cursor to improve the performance of multi-row queries.
• Created function Based Index on table to improve the performance of the query.