SUMMARY

• More than 5 years of experience in the field of information technology, proven ability to leverage technology to improve business processes and problem solving, with special expertise in database development, support, monitoring, stored procedures, packages, triggers and performance tuning.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• 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 working in an Agile development environment.
• Have experience on security setup using Active directory integration.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Experience in Performance Tuning & Optimization of SQL statements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Experience in translating business requirements into creation of Database Objects.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in migration and conversion from MS Access/SQL - Server to Oracle.
• Strong in writing Stored Procedures and SQL queries.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Good understanding of the Oracle database, related utilities and tools.
• Have extensive experience in Performance tuning by analysing the execution plans of the query.
• Hands on experience in tracking down the bottlenecks in query using trace files.
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Experience in working with quality assurance and version controlling tools
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to learn new tools, concepts and environments.

PROFESSIONAL EXPERIENCE

Confidential

Senior PL/SQL Developer

Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical design documents and user Documents.
• Used SQL*Loader, PL/SQL procedures to facilitate data import to staging tables, interface tables and then to base tables.
• Used Materialized views in places where the data does not change very frequently.
• Scheduled the execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Used Materialized Views to simplify data-warehouse summary management and speed query processing at the same time.
• Developed several innovative approaches to building PL SQL database segments and utilizing them to extract information.
• Data analysis and find out the error data which encountered during the loading process and suggesting the proper resolution to the client.
• Implemented corporate database backup management policy by automating various kinds of backups using UNIX shell scripts.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.
• Developed Email Routing logic for validating, classifying and processing the incoming emails to Email Center.

Technology used: ORACLE 11g, PL/SQL, SQL*Loader, SQL-XML, Shell Scripting, SVN, Bit Bucket, J2EE & Weblogic 11.

Confidential

PL/SQL Developer

Responsibilities:

• Participated in this project right from requirements gathering till go-live
• Involved in the design of physical data model and definition of all the data structures required to hold and process billing alerts data.
• Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.
• Wrote SQL queries to developed test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
• Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Developed control files to load XML files received from ACLARA into staging.
• Developed stored procedures that parse, validate and process XML data and merge into relational tables.
• Developed Views and XML views as interfaces to spool Billing and Usage Information of customers is XML format, which is sent to ACLARA for sending actual alerts.
• Written shell scripts to be invoked from AUTOSYS Jobs in order to automate the entire process of receiving data from ACLARA, loading, parsing, validating, processing, extracting, packaging and sending back data to ACLARA
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Performed running tuning on long running queries for dashboards.
• Performed Unit and integration testing of all the modules I developed
• Responsibly followed build and release process

Technology used: ORACLE 11g, PL/SQL, SQL*Loader, SQL-XML, Shell Scripting, SVN, Bit Bucket, J2EE & Weblogic 11.