SUMMARY

• Over 8+ years of experience in Software Development which includes implementing large - scale systems in web based Applications/Data Warehouse in diversified industry sectors including Banking and Telecom.
• Expertise in Client-Server application development using Oracle 19c/11g/10g/9i/ PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• TEMPEffectively made use ofIndexes, Table Partitioning, Materialized Views
• Good Understanding in Data warehouse concepts, ETL (Informatica)
• Created Tables, Views, Constraints, Indexes, Sequences, Synonyms
• Developed database objects likeProcedures, Functions, Packages and Triggers, Collection Types in PL/SQL.
• Experience in development, working with Data Migration, Data Conversion and Extraction/Transformation/Loading using client specific tool with Oracle.
• Data Migration (Conversion) Specialist for billing project for Confidential for Oracle RM&B (Revenue Management and Billing for Banking) implementation.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader from Flat Files
• Experience with Oracle Supplied Packages such asDBMS PROFILER andUTL FILE.
• Worked extensively onRef CursorandCollections.
• Worked with developing data entry/reporting pages in APEX.
• Extensive experience working on Waterfall and Agile development environments.
• Experience in SQLperformance tuningusing Cost-Based Optimization (CBO).
• Experience in Modeling Physical and Logical data model
• Worked on Control-M jobs to run in various servers and time-zone.
• Implemented advanced programming techniques like APEX COLLECTIONS, APEX MAIL etc., in APEX.
• Good noledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Experience inPerformance Tuning usingExplain PlanandHINTS.
• Exceptional experience in dealing with various databases like Oracle, DB2, SQL Server, MS Access, and Flat files.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Scripting Tools: Linux Shell Scripting

RDBMS: MS Access, MS SQL Server, Oracle 12c/19c/21c

Development Methodologies: Waterfall, Agile - scrum/XP

Version Managers: SVN, Bitbucket, Jenkin, RLM

Programming Languages: PL/SQL, HTML, Visual Basic 6.0 (VB), ASP 3.0

Languages: Java/J2ee,C, C++, HTML,CSS

Operating Systems: Windows 7/10, Red Hat Linux

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Oracle Developer (PL/SQL)

Responsibilities:

• Responsible for systems analysis, development enhancement, maintenance and support of Oracle based Oracle / VB based application
• Data Migration-Involved in operations analysis, technical design and implementation.
• Had meeting with BA for Requirement Clarifications and sign off.
• Analyzed Requirements and provided teh feedback on Requirements
• Created Technical Specification Document for Final Approval
• Provided available Industry Standard Architectures for teh current Requirements
• Involved in High Level Design Document creation
• Worked on Explain Plan to tune teh queries
• Designed User-Errors package and implemented as common standard for teh entire project
• Created SQL Script to load Data into Target System
• Worked with Production support team on 24/7 basis as required
• Involved in Weekly/Monthly release and Production support after deployment
• Worked on Bulk Collect/ForAll/Oracle Collections to improve teh performance of teh PL/SQL Block.
• Working with Agile methodology.
• Implemented Collections, Bulk Collect techniques and REF cursors for migration and invoice reconciliation.
• Experience with implementing role based security in APEX. Also worked with APEX application
• Involved in Agile environment, with constantly shifting priorities and business needs. Provided best practices in database related issues to application team
• Created SQL Loader Script to Extract Data From Different Source System
• Created ORACLE PL-SQL Script to do ETL Process
• Created Tables, Views, Procedures, Functions, synonyms, Sequences in Oracle Environment
• Created Python Script to process data and load into target environments
• Worked on Awk, Sed Linux Utilities to develop shell scripting
• Worked on Performance Tuning using AWR Report
• Analyzed SQL Queries and Tuned teh Long Running Query

Environment: Oracle 11g v2,Windows 7,Crontab, JavaScript, SQL Developer, Putty, RedHat Linux

Confidential, Basking Ridge, NJ

Sr Oracle Developer(PL/SQL)

Responsibilities:

• Developed, tested, debugged and documented Oracle PL/SQL Procedures, Functions and Packages in accordance with company policies, company standards and industry best practices
• Having good experience in Control-M to schedule scripts/Program in various regions
• Coordinated with teh front end design team to provide teh necessary stored procedures, packages and teh necessary insight into teh data
• Scheduled meetings and presented technical issues to business users and developers
• Tested coding modifications and assisted with application and system testing
• Involved in Application performance Checks, scalability and stability of database systems.
• Created Oracle Objects like Tables, Views, Indexes, Sequences,Synonyms
• Created Many Stored Procedures, Functions, Packages, Collection in pl/sql
• Used PL/SQL packages and Collections (Index-by tables, Nested tables) for product migration.
• Created automate script to clean up every Sunday using Crontab
• Created historical data in Invoice Creation process to support ETL team
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Worked closely with Data Architect in data modeling phase
• Having Onsite/Offshore model experience since teh project runs on 24/7 basis
• Used Explain Plan, HINTS to validate teh performance of teh SQL Queries
• Handled errors usingException Handlingextensively for teh ease of debugging and displaying teh error messages in teh application
• Created High level design documents for new Requirements
• Used SQL*Loader to load Monthly billing flat files

Environment: SQL Developer, Control-m, Shell Scripting, Oracle 11/12c, Red Hat Linux

Confidential

ORACLE PL/SQL Developer

Responsibilities:

• Had meeting with Users and BA, Report Owners to finalize teh Requirement
• Created Technical design document for teh Data model
• Involved in Low Level and High Level Design Document
• Created SQL Scripts in Oracle to validate teh deployment activities
• Worked on Bulk Collect/ForAll/Oracle Collections to improve teh performance of teh PL/SQL Block
• Created Tables, Views, Procedures, Functions, synonyms, Sequences in Oracle Environment
• Worked on Performance Tuning using PL/SQL features/SQL Queries
• Identified teh long Running SQL Queries in Oracle
• Worked on DDL/DML move from DEV,SIT,UAT to PROD System
• Supported L1 Team by writing teh Report specific Validation Script

Environment: Oracle 11g,Windows 10,Putty, RedHat Linux, SQL Developer