PROFESSIONAL SUMMARY:

• Over 9 years of experience in analysis, design, Application Development and Production Support using Oracle SQL, PL/SQL and UNIX.
• Excellent working and conceptual knowledge of SQL, PL/SQL, Oracle Forms 6i/4.5 and Oracle Reports 10g/6i/2.5, C, Java, UNIX Shell Scripting, XML and HTML.
• Involved in all the phases of SDLC - Analysis and Design, Data Modeling - ER Diagrams and Normalization, System Testing, Development, documentation and implementation on both Client/Server as well as Web-based applications.
• Experienced in Pharmacy,Banking, Manufacturing, Insurance Retail and Telecom domains.
• Proficient in developing Oracle PL/SQL Packages, Stored procedures, Functions, Triggers and Cursors. Also developed various applications using Oracle in-built packages.
• Extensive Working Experience in Toad.
• Extensively used PL/SQL to built Oracle Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Views and Materialized Views for processing data.
• Used DBMS utility packages like DBMS XMLGEN and UTL FILE to generate XML Files for interfaces with other system.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL.
• Data Conversion from Flat files to Oracle database using Oracle SQL* Loader.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Partitioning and Indexes
• Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and user’s documentation.
• Hands on Experience in UNIX Platform (HP-UX, AIX, Solaris) and expertise in Shell scripting Programming.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema & Snowflake Schema used in dimensional modeling.
• Data modeling and Design using Erwin and MS Visio.
• Worked on Development projects and troubleshooting the application and resolve bugs.
• Strong experience in client interaction and understanding business application, business data flow and data elements.
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Good communication, analytical and Interpersonal skills.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i/7.3, MS SQL Server, Sybase, MS-Access

Languages: SQL, PL/SQL, C, Java/J2EE, VB, XML, HTML, Shell Script, Perl Script

SQL Utilities: TKPROF, SQL*Loader, Export, Import

Reporting Tools: Oracle Reports 10g/6i/3.0/2.5, Discoverer 6i.

Office Applications: Microsoft Office 2003/XP/2000/97 (Word, Excel, PowerPoint)

Operating System: Sun Solaris10, Red Hat Linux 6, Windows XP/2000/NT/98

Scheduling Tools: Control-M, Autosys

Query Tools: SQL Developer 1.5, SQL Navigator, TOAD 8.x/7.x, SQL*PLUSPL/SQL Developer

Version Control: PVCS7.0, CVS, VSS, SCM

Oracle IZO: 007 Introduction to Oracle 9i: SQL.

Oracle IZO: 147 Programming with PL/SQL.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Programmer Analyst

Responsibilities:

• Created database objects like Tables, Sequences and Constraints as per the business requirement.
• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, database Triggers and Packages.
• Usage of Analytical functions in the packaged procedures.
• Developed UNIX shell scripts involves logic based on the input and call procedures and packages in the script.
• Loading of monthly loads from flat files into FDR staging tables using SQL* Loader.
• Maintenances of FDR Batch jobs runs daily, weekly, monthly and yearly in Control-M.
• Enhancement of EOY procedures from static to dynamic process.
• Created few procedures in USOGL FDR application for reporting purpose.
• Extensively involved in performance tuning of the pl/sql code and improved the running time of the jobs.
• Understanding the existing process and rewrite the code to improve the performance and not impacting the existing process.
• Introduction of Merge-Insert statements, create - Insert process for optimization of code.
• Usage of different Unix commands for the execution of Unix shell scripts.
• Usage of index hints, Append hint in the sql queries.
• Analyze the changes to do in the Unix shell scripts for Upgrading the servers and updation of the multiple scripts at a time.
• Analyzed the execution plan and the statistics of the optimizer and passed the hints and placed indexes wherever necessary.
• Involved in creating indexes, passing hints, analyzing the table statistics and table partitioning.
• Created numerous PL/SQL procedures using REF Cursors in it, these are used in developing reports.
• Used bulk load and bulk collect to load the data from non oracle data sources to improve the performance.
• Created test scripts documentation for all the procedures that I have created.
• Involved in production support, like monitoring the performance of the Unix jobs.
• Researching and resolving the problems occurred with the Jobs and also involved with the end user to resolve the problems.
• Created numerous views and materialized views based on the business requirement.
• Worked with different types of sub queries (Inline, correlated) and used loops to suit the business logic.
• Involved in the Technical specification walk through meetings with the business users, business owner and the managers.

Environment: Oracle11g and 10g, SQL, PL/SQL, Toad, SQL*Plus, SQL*Loader, Unix, Putty, Notepad ++,Winmerge,SQL Developer, PL/SQL Developer, Control-M.

Confidential, New York

Programmer Analyst

Responsibilities:

• Creation of global temporary tables to hold temporary data for manipulation of data in B3 system.
• Involved in analysis, Design, Development and test phases of the project.
• Developed Requirement Specifications, Functional (Business Terms) and Technical Design documents.
• Extensively involved in Writing PL/SQL Stored Procedures, Functions, Packages to meet the business requirements.
• Created custom partition tables for improvised performance.
• Worked on performance tuning and used Explain Plan, Tkprof, SQL-Trace for tuning the queries.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Extensive use of dynamic Merge statements.
• Use Execute Immediate with the sql queries for the manipulation of the tbl lookup table.
• Moved data from the old tables into the new tables using Sql*Loader
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Optimized existing queries for better performance and less impact on database.
• Used Dynamic SQL for interface programs and exception handling routines.
• Involved in the design and implementation of the process for loading the monthly loads coming from flat files in to staging tables in the Oracle Data base using SQL* Loader.
• Updation of the tasks in the Agile and responsible for the tasks as per mentioned.
• Involved communication with testing team and resolve the issues raised in the Agile.

Environment: Oracle11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Unix, Putty, Notepad++Winmerge, SQL Developer.

Confidential, New York

Programmer Analyst

Responsibilities:

• Involved in analysis, Design, Development and unit testing phases of the project.
• Analyzed the Requirements and developed Developed Functional (Business Terms) and Technical Design documents providing the approach of the system flow.
• Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Worked in Development, SQA, UAT and EDI environments of the FNX application.
• Involved in the code enhancement and addition of the code to the claim distribution which is the core and essential logic of the FNX application with the improvised performance.
• Usage of the DBMS AQ packages for enque and deque process of claim from one queue to other queue depends on the claim status.
• Calling Web service using SOAP(Request and Response) in pl/sql and extracting the required data from the web service response sent over using the xmltype functions.
• Generation of the HTML clob by converting the xmltype clob data using XSL style sheet and extensive use of xmltype functions to store the data in xml format.
• Used pipeline concept to increase the performance.
• Used DMBS utility set module and set action functions to register the actions performed in the program logic of FNX application.
• Write numerous pipelined functions on database objects for retrieval of claim details by increasing the performance.
• Development of different type of claim Benchmarks automatically, used for generating the charges to be negotiated from the claim total charges.
• Used Exception Handling to handle the errors and display in the application.
• Created few procedures in data warehousing for reporting purpose.
• Worked with different types of sub queries (Inline, correlated) and used loops to suit the business logic.
• Used Dynamic SQL for interface programs and exception handling routines.
• Unit test and smoke test of the developed code and preparation of the test case documentation.
• Involved with QA team and reviewing their test cases, recommending changes if required and fix the defects that logged in Quality Centre.
• Involved in the production support to monitor the performance of the ETL jobs and worked with the issues arises in it.
• Maintained good interpersonal skills with the team member and actively participated in the meetings.

Environment: Oracle11g and 9i, Reports10g, SQL, PL/SQL, Toad, SQL*Plus, Mercury Quality Center, SQL*Loader, Unix, SCM, Notepad ++,Winmerge,SQL Developer, PL/SQL Developer.

Confidential, Milwaukee, WI

Oracle PL/SQL Developer

Responsibilities:

• System analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Involved in creation of different database objects procedures, packages, functions, triggers, views and materialized views based on the requirements.
• Developed scripts for the continuous data pump to the tables based on the EFC volume metrics.
• Created jobs using DBMS JOB which run the scripts automatically for every specific period of time.
• Used Sys.utl smtp packages for creation of email programs.
• Participating in walkthroughs, Iteration design and problem resolution.
• Developed the system from the scratch and unit worked with testing team for the smoke test and performance tests.
• Analyzed the execution plan and the statistics of the optimizer and passed the hints and placed indexes wherever necessary.
• Involved in creation of oracle reports according to the requirements.
• Involved in monitoring the jobs and functionalities of various database objects.
• Optimized existing queries for better performance and less impact on database.
• Involved in using Export and Import utilities for exporting and importing of the data from and in to Databases.
• Involved in creating indexes, passing hints, analyzing the table statistics and table partitioning.
• Developed the pl/sql sustained model for the continuous flow of the developed oracle scripts.
• Involved in re writing of the sql queries to increase the performance of the queries.
• Developed sql queries from WMOS database and involved in tuning of the queries.
• Created bit map indexes and different type of hints to increase the performance.
• Solved the performance issues and made it to the sustainable application.
• Used Explain plan to know the statistics of the sql queries.
• Created number of database Triggers according to business rules using PL/SQL.
• Decrease the execution time of all the queries to a greater extent.
• Used Sql*Loader to load data from flat files in to Database tables.
• Used bulk load and bulk collect to load the data from non oracle data sources to improve the performance.
• Involved in creating Test plan documents and wrote test cases for various tasks after unit testing the application.

Environment: Oracle10g, SQL, PL/SQL, Toad, Reports 10g,SQL*Plus, Mercury Quality Center, SQL*Loader, Unix, VSS, Win 2000,SQL Developer, PL/SQL Developer.

Confidential, Milwaukee, WI

Oracle Developer

Responsibilities:

• Created technical specification documents providing the system flow based on the User requirements.
• Development and Enhancement of various procedures, packages and reports in the Reportal application that includes customer, client, client group, pharmacy details.
• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, database Triggers and Packages.
• Also involved in the Payment Management System applications and developed code for the email notifications.
• Involved in creation of outbound data files using UTL FILE script based on requirements.
• Loading the Data from outside sources (flat files) into member pay billing databases using SQL * Loader.
• Used Export and Import utilities for exporting and importing of the data from and in to Databases.
• Involved in development of various sql scripts that run daily, weekly and monthly.
• Customizing the existed packages and procedures with in the application based on the requirements.
• Creating database objects like tables, views, synonyms, procedures, functions and database triggers to meet the business requirements.
• Performance tuning of the queries using Explain Plan.
• Created numerous views and materialized views based on the business requirement.
• Usage of Bulk collect concept to increase the performance of the queries.
• Using the oracle supplied packages and collections like varrays, records and table types in the code.
• Usage of advanced pl/sql functions in the development of code according to the requirements.
• Writing UNIX shell scripts (used AWK, SED) to automate load process, scheduling batch jobs using Crontab.
• Unit testing and performance tuning of the developed code.
• Used Serena for version management.
• Creation of Test plan document after developing the code.
• Responsible for resolving the defects involved with the application in SQA.
• Batch process jobs schedule to run everyday using Unix shell scripting.
• Crated, handled and maintained the .SQL scripts and .CMD files according to the changes in the business requirements.

Environment: Oracle10g, SQL, PL/SQL, SQL*PLUS, Reports, TOAD 9.7.2,SQL*Loader, Serena 8.1.4

Confidential, Cedar Rapids, IA

Oracle Developer

Responsibilities:

• Responsible for creating the tables, enforcing the Constraints & Indexes.
• Extensively used SQL * loader to load data from flat files in to Database tables.
• Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures, database Triggers and Packages.
• Created technical specification documents for the new reports.
• Created standard report templates for Landscape and Portrait reports based on the business specifications and Confidential naming standards.
• Created numerous views and materialized views based on the business requirement.
• Batch process jobs schedule to run everyday using Unix shell scripting.
• Responsible for resolving the issues involved with the application in testing phase.
• Created Test cases for the reports and performed unit testing on them.
• Changed the triggers in the form and added functionality as per the requirement.
• Created, handled and maintained the .SQL scripts and .CMD files according to the changes in the business requirements.
• Tested the procedures and packages in the Sales comm. Application, pointing to Oracle 10g and solved the problems with the incompatibilities.
• Successfully deployed the database objects to the UAT, EDI and Production environments.
• Involved in production support for various applications and resolved the issues.
• Worked with the DBA and involved the impacts on the existing database upgrade from Oracle 9i to Oracle 10g.
• Tested all the procedures, functions, database triggers in oracle 10g database.
• Created Agent warning letters in AML (Anti Money Laundering) project using Oracle Reports 10g.
• Worked extensively on Database tuning using EXPLAIN plan and TKPROF.
• Involved in the table partitioning, which has more than 2 billion records in it.
• Involved in developing PERL scripts to get the processed and unprocessed records from vendors and updated the databases accordingly.
• Created processes for generating PL/SQL reports in UNIX server as out files and then ftp to the Retail services server where users can access these files.
• Automated the oracle reports using Autosys.
• Created procedures, functions and database triggers for Application Development Framework application.
• Created deployment scripts and instruction for the enhancements.

Environment: Oracle10g/9i, SQL, PL/SQL,SQL*PLUS,TOAD,SQL*Loader, Control - M, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Developed Requirement Specifications, Functional (Business Terms) and Technical Design documents.
• Validation rules were implemented by writing procedures during data input.
• Created Custom reports using Reports 2.5.
• Created stored procedures, Packages, Functions and triggers using SQL & PL/SQL.
• Developed database triggers where ever necessary.
• Involved in analyzing user/business requirements and mapping into technical specifications.
• Performed in depth of data analysis and prepared weekly, biweekly, monthly reports by using reports 2.5.
• Implemented a whole new security for the reports in the oracle database to prevent confidential data from being displayed to all users. The security is based on the standard concept of roles and privileges.
• All the security roles and privileges are stored in the database tables and the logic is implemented using functions and views. Promoted the security feature to the existing reports with a very minor code change in the actual reports.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Involved in Data migration using SQL * Loader from flat files into database tables.
• Solved day to day issues raised with SQL * Loader. Wrote Unix Shell scripts in UNIX.
• Extensive use of Bulk binds, Bulk Collects and Partitioning
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Involved in the design, development, testing and maintenance.
• Troubleshot production problems and worked effectively with other team members to identify and address problems.
• Provided input into project plans for database projects providing timelines and resources required.
• Responsible writing UNIX shell scripts and run batch jobs.

Environment: Oracle 8i/7.3, PL/SQL, SQL * PLUS, Sql * Loader Reports 2.5, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the team to study and gathered system requirements.
• Involved in designed the necessary table structures and table relations.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, procedures and packages.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Involved in the data modeling using Erwin.
• Involved in the customization of the oracle forms and reports.
• Maintained the data integrity and security using integrity constraints and Data base triggers. Involved in the application tuning of database by identifying the suitable Indexes.
• Involved in Data migration using SQL * Loader from flat files into database tables.
• Solved day to day issues raised with SQL * Loader. Wrote Unix Shell scripts in UNIX.
• Extensive use of Bulk binds, Bulk Collects and Partitioning.
• Attend regular tele-conference with client for co-ordination and reporting.
• Assist in proper execution of project by taking up status collection, communication and Quality related activities
• Secure ID coordinator, maintaining the secure id’s of whole Billing & Payments team.

Environment: Oracle 8i, SQL, PL/SQL, SQL * Loader, TOAD, UNIX Shell Scripting.