SUMMARY:

• Professional experience in using External Tables and Temporary tables.
• Programming work experience with Batch Scripting and shell scripting.
• In depth knowledge and experience in new features like Analytic functions, Bulk Bind, Merge, Case and PL/SQL supplied packages.
• Extensive experience on migration of PL/SQL scripts from 8i to9i and 9i to 10g.
• Professional experience in designing Logical and Physical data models using ERWIN.
• Solid experience in translating business requirements into creation of Database Objects and Database Architecture.
• Over 4 years of experience working in financial domain.
• Over 8 years of experience in IT industry with emphasis on Design, Development and Implementation of projects using Oracle Sql, PL/SQL .
• Solid experience Tuning of the SQL query, which takes long time to process the request using explain plan, auto trace and hints to reduce the response time.
• Professional experience in Oracle Queuing.
• Extensive knowledge and experience in SQL Server 2000/2005
• Extensive knowledge in Developing ETL mappings in Informatica.
• Proficient in programming languages like JAVA and .NET.
• Proficient in using version control systems like TortoiseSVN and PVCS.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS:

RDBMS/Databases: Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access.

Operating Systems: Windows XP/2000/2003 Server, UNIX /LINUX and Solaris.

Data Model ETL tools: ERWIN, Sql Developer and Informatica.

Languages: SQL, PL/SQL, Shell Script, C , Java, .NET, Visual Basic and MUMPS.

Tools/Utilities: OEM, TOAD, PLSQL Developer, Animate, Exports and Imports.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Oracle Developer

Responsibilities:

• Involved in reviewing the High Level Design Document and designed the Low level design document based on the HLD.
• Included temporary tables in the design for improving the performance.
• Used PLSQL Developer extensively to create the objects.
• Created control files for loading the files from the landing zone GIF into respective tables.
• Worked on the audit scripts for checking the audit rules.
• Used Animate for scheduling the jobs.
• Worked on the shell scripts.
• Added an additional functionality which sends email to GM whenever the file fails the audit.
• Included triggers to copy the before images whenever there is an update on generic tables.
• Involved in the performance tuning to improve efficiency.
• Created views to access the records from generic tables.
• Helped testers with the SQL queries and explained the functionality to them.
• Participated in the conference calls regarding the status updates.
• Worked closely with the client to ensure that the product is delivered as per their needs.
• Participated in UAT.
• Created reports using Cognos.

Environment: Oracle 10g, PLSQL Developer, Animate, PVCS, UNIX, Cognos

Confidential

Role: Oracle Developer

Responsibilities:

• Involved in designing VHIM VA health Information model and implemented normalized HDR database.
• Created Business VHIM Model from HL7 Messages, Logical Physical model using.
• Analyzing Data coming from HL7 Messages as per HIPAA rules
• Developed Pl/Sql Packages to Parse HL7 Messages generated by MUMPS.
• Responsible for Performance tuning of complex SQL Queries pertaining to various stored procedures, Triggers etc.
• Automized routine jobs using dbms job. On completion of these jobs an email will be sent out automatically UTL MAIL .
• Adding/ resizing Data files, Analyzing tables and Table space Management.
• Resolving database issues by checking alert log.
• Extensively involved in Data Migration activities using SQL Loader techniques Export and Import utilities.
• Designed Schemas and Profiles as per Enterprise management of VA.
• Responsible for the Performance Tuning tasks of the database. Used Explain Plans and TKPROF to get the statistical data for the Performance Tuning of the SQL queries and stored procedures.
• Data extraction from files to intermediate tables using UTL FILE/DBMS FILE TRANSFER.
• Involved in partitioning of very large tables using List and Range Partitioning.
• Involved in transferring the data between servers using Data Pump, Export Import.
• Tuning Complex SQL queries using AWR/ADDM Reports.
• PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Supporting Java Developers in developing SQL query and PL/SQL scripts.
• Extensively involved in Developing Views and Materialized Views.
• Used oracle utility packages like DBMS LOB, DBMS AQADM and DBMS AQELM in pl/sql codes.
• Create maintained cron jobs using Shell Scripts.

Environment: Oracle 9i/10g, Sql Server, Windows, UNIX, Dot net, ER Win, TOAD and Informatica

Confidential

Role: Oracle Developer

Responsibilities:

• Prepared technical specifications from business requirement document.
• Designed/developed tables, views, materialized view, stored procedures, packages and functions.
• Automized routine jobs using dbms job. On completion of these jobs an email will be sent out automatically UTL MAIL .
• Adding/ resizing Data files, Analyzing tables and Table space Management.
• Resolving database issues by checking alert log.
• Involved in designing schemas and profiles.
• Associated with DBA's in fixing performance related issues using Explain plan, SQL Trace and TKPROF utility.
• Creating synonyms to mask the owner of the object and easy management of privileges.
• Automized accessing data from web using UTL HTTP.
• Data extraction from files to intermediate tables using UTL FILE/DBMS FILE TRANSFER.
• Involved in partitioning of very large tables using List and Range Partitioning.
• Involved in transferring the data between servers using Data Pump, Export Import.
• Tuning Complex SQL queries using AWR/ADDM Reports.
• Build Reports using PL/SQL Procedures from the report table.
• Involved in the maintenance and enhancement of the application.
• Supporting other colleagues in developing the right SQL, PL/SQL script and query.
• Associated with DBA in monitoring the performance related issues.
• Used oracle utility packages like DBMS AQ, DBMS AQADM and DBMS AQELM in pl/sql codes.
• Create maintained cron jobs using Shell Scripts.

Environment: Oracle 9i/10g, Sql Server, Windows, UNIX, Dot net, ER Win, TOAD and Informatica

Confidential

Role: Oracle Pl/Sql Developer

Responsibilities:

• Gathering user requirements and designing Database accordingly which involves creating Logical Data model and Physical Data modeling.
• Creating many physical objects table, constraints, index, function to facilitate the smooth data retrieval
• Loading data into the intermediate tables using UTL FILE and Sql Loader.
• Designing, Developing Fine Tuning data-retrieval data-migration scripts.
• Automized sending the reports to bureaus and attorney using UTL SMTP.
• Involved in transferring the data between servers using EXPORT IMPORTS.
• Migration of scripts from oracle 9i to oracle 10g.
• Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables.
• Used Pl/Sql tables, array structures as a part of oracle collections.
• Extensively developed complex PL/SQL packages and implemented Oracle Replication.
• Used UTL JOB to automate the plsql procedures and packages.
• Worked as an administrator in monitoring the performance related issues using SQL Trace and TKPROF utility
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Oracle 9.2/10.2, Windows, UNIX, Dot net, ER Win, Sql Developer and SQL Loader