SUMMARY:

• Overall 11+ years of experience in IT industry, 8+ years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments.
• Highly skilled and experienced PL SQL Developer with wide knowledge of a variety of programs and procedures. Adept at all types of data storage and extraction. Able to work well independently or as part of a team.
• Excellent expertise in Shell and Unix programming
• Experience in financial, retail and telecom domain.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Expertise in handling errors using Exceptions.
• Making structural changes to the database objects.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Experience in working high - transacted OLTP systems.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers.

TECHNICAL PROFICIENCY:

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored ProceduresTriggers), MS SQL SERVER 2000/2005/2008 , Terra Data and MS Access.

ETL Tools: SQL*Loader, ODI

Reporting Tools: Crystal Reports, Oracle Reports 2.5

Operating Systems: UNIX(Sun Solaris, LINUX, HP UNIX, AIX)Windows NT/98/95/2000& Windows XP.

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, XML, C and Cobol.

Tools: Toad, SQL Developer

DevOps Tools: Docker, Jenkins. Grunts and Jira

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Technology: Oracle 11g/SQL Server/Terra Data

Consultant

Responsibilities:

• Working with stored procedures and functions to extract data from three oracle schema to get alarm details, customer details, trouble ticket details and non troble ticket details.
• Extracing data from the Oracle Server loaded them into systems like SQL Server for analysis purpose
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Automated the External Retrace files loading using VBA
• Managing the daily Invertry, Sales cube

Confidential

Technology: Oracle 10g/11g

Consultant

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.

Confidential

Technology: Oracle 10g/11g

Spec-System Dev

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in migrating database from oracle 9i to 10g database.

Confidential

Technology: Oracle PLSQL, MS Access, SQL Developer

Senior Technical Analyst

Responsibilities:

• Monitoring alert log for errors, Resolving connection problems of users.
• Resolved several listener/TNS issues, Database and Apps Health checks.
• Daily and Weekly backups and Customer support over phone on 24x7 bases.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Confidential

Technology: Oracle 9i/10g

Junior Oracle DBA, PLSQL Developer

Responsibilities:

• Interact with business users to gather the details regarding the current manual reconciliation process and automate it using Access and Oracle PL SQL
• Interacted with the Middle Office to automate their current manual process by making PLSQL stored procedures and Excel Macros.
• Worked with the banking products Bonds, FX, Swaps, Options during automation
• Worked with T0 Risk and P/L Rollout program to generate the new reports as per the user’s requirements using Oracle PLSQL procedures and Excel Macros and Access.
• Monitoring space availability and provide Technical Supports to End users.
• Monitored the growth of Table spaces to see the fragmentation and available space for growth. Check for log and trace files
• Perform root cause analysis of difficult problems and their solutions.
• Managing Redo Log files in Archive log Mode for Online Backup.
• Monitored table spaces & their growth and took proper actions.
• Creating of database indexes on certain tables to improve query performance after thoroughly testing the same in the development environment.
• Cloning the database through RMAN as per the requirement.

Confidential

Technology: Oracle PL/ SQL, Bankware and UNIX Shell

PLSQL Developer, Analyst

Responsibilities:

• Supporting the daily extraction of data from core banking system(SIBS Silverlake) and other treasury systems(OPICS & KPLUS)
• Supporting Bancware(Sungard) system that aggregates data and transforms it to ALCO reports
• Re-engineering of ALCO process in Access database and converted related codes into Oracle.
• Gather user requirements and documenting the user requirements to migrate to new ALM product - Fermat.
• Interact with various source systems and implement changes for new products. This involved understanding the various bank products and their treatment for ALM process
• Involved in writing triggers, functions, stored procedures.

Confidential

Technology: VBA, MS Access, Oracle PL/SQL and SAP

Senior Consultant

Responsibilities:

• Main objective of this project is Migrating data from SAP, Excel and manual data to GSAP(Global SAP) using transformation tools which are designed by the central team which is located in UK.
• Involved in migrating all its county data into Global SAP by country wise and I played vital role in data migration for Singapore. My responsibilities included in Extracting data from SAP(P30) and transforming data based on DOS(Document Object Specification) with all the rules and making the LSMW files. .