SUMMARY

• Over 6 years of extensive experience in Oracle 9i/10g/11g, MS SQL Server, SQL Server 2005/2008 Developer with major focus on SQL, PLSQL and T - SQL. Extensive development experience, achieved profound knowledge in insurance, marketing, IT and financial domains.
• Working knowledge of software development life cycle (SDLC) and agile methodology with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing various phases in a project environment, delivering products on timely manner.
• Over 6 years of experience as Oracle Developer with Extensive knowledge and work Experience in design and development of Database applications in Client/Server environment using Oracle Database and PL/SQL Programming.
• Experience in Design and maintenance of Telecommunication, Healthcare, Insurance, Banking and financial applications/ Domains.
• Expertise working with Oracle 10g, 9i, SQL&PL/SQL, SQL * Loader, XML, Shell Scripting and Discoverer.
• Extensive experience as Oracle Developer in developing and utilizing PL/SQL procedures, functions, packages, triggers, shell scripting, unit testing and also involved in data extraction, transformation and loading operations on oracle using SQL Loader.
• Experience in software development of databases that include design, analysis, development and deployment of software related to database application systems.
• Customized and developed Forms and reports using Forms 6i/9i/10g, Reports6i/i/10g/11g, Discoverer and Oracle BI Publisher.
• Experience in performance tuning and SQL optimization using (Hints, Explain Plan, Auto Trace, and TKPROF), restructuring tables, de-normalization tables.
• Adept Knowledge in writing UNIX shell scripts, DBMS JOB, DBMS SCHEDULER and UTL FILE utilities.
• Strong knowledge in Oracle 11g.
• Involved in project planning and scheduling, System design, Functional Specification, Design specification, preparation of impact analysis, Coding, system test plan, Testing, code review, coordinating user testing and user training, Project demonstration and Implementation.
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Possess strong communication and problem solving skills developed through a variety of projects.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena. Ability to work independently and also can be a great team player.
• Given 24/7 production support and involved in implementation of coding standards and Data Base change requests.

TECHNICAL SKILLS

Languages: C, C++, SQL, PL/SQL and JAVA with JDBC

RDBMS/DBMS: Oracle 9i/10g/11g, SQL Server 2000/2005/2008 , MS Access.

Operating systems: Windows 7/XP/2003/2000, UNIX, LINUX

Tools: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 4i/10g, BI Publisher, XML, TOAD, MS Office Tools, SQL Advantage.

ETL tools: Informatica Power Center, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert, BCP.

Data modeling: ERwin 4.0/7.x, Visio

Methodologies: agile, waterfall

Other skills: microsoft office suite (word,excel,power point), ms visio

Oracle Utilities: SQL*LOADER, UTL FILE, Export/Import functionality, Data Pump, FND LOAD

Version Control Software: Clear Case, VSS and PVCS

SR tracking /Ticketing systems: Smile, SYSAID, HP Quality Center, Service Center

Documentation Control: Quickr, MKS Integrity

PROFESSIONAL EXPERIENCE

Confidential, MA

PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Analyzed the data needs for the customized reports, created reports based on PLSQL procedures, Reports 6i and Discoverer.
• Loaded database tables from flat files, creating Control Files and utilizing SQL*Loader. Automated the SQL*Loader process to handle multiple files and archive the files after interfacing.
• Validated, loaded data into Oracle Database using DB links and external tables from CSV files.
• Designed and developed various OUTBOUND interfaces by generating files using UTL FILE utility and transmitting over secure channels using SFTP.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Responsible for performing code reviews.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, TKPROF, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed complex queries for SQL Server Reporting Services.
• Wrote Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in the database from GUI.
• Developed reports using complex queries as per client request as a part of production support.
• Worked on ETL tools like Power Center8.0 which are used for data integration and also mapping data.
• Worked on Oracle OLAP tool to produce analytic measures, including time-series calculations, financial models, and forecasts.
• Involved in XML parsing and loading XML files into the database.

Environment: Oracle 11g/10g and 9i, Toad, MS SQL SERVER 2005, SQL * Loader, PL/SQL, PL/SQL Developer SQL*PLUS, ETL Tools, IBM Rational 7.0.1

Confidential, Phoneix, AZ

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project
• Developed Requirement Specifications, Functional and Technical Design Documents.
• Transferred knowledge to paper using Architectural diagrams, process flows and documented the whole system which includes data modeling according to SDLC guidelines.
• Communicate with both technical and non-technical groups on a regular basis to pass along important information and to ensure the design and implements are understood by all parties.
• Maintain, troubleshoot, optimize and improve existing database applications and database objects
• Designed table structures, developed scripts to create tables, indexes, views.
• Involved in writing database triggers, procedures, functions in PL/SQL and incorporated business rules.
• Developed new stored procedures and modified existing ones using Oracle 10g.
• Developed the scanners as per the business requirements and transfer the data to other environment using generic loader.
• Developed scripts to extract data from one environment and load it in another environment.
• Performed tuning on the existing code for better performance.
• Millions of records are loaded into respective tables with a generic loader internal to the AMEX.
• Co-ordinate with Java Web Services team to generate the reports.
• Built reports using Reports6i for better formatting and ease of use by the client end users.
• Developed complex forms and worked on enhancements of existing forms using oracle forms 10g.
• Created Shell Scripts to transfer the data and to run the SQL Scripts and run the jobs.
• Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.
• Designed and developed user test scripts for the UAT and migration of the developed codes.
• Schedule the jobs with heavy dependencies.
• Tables, Views, Procedures, Alter Scripts and Perl Scripts are checked in CVS repository.
• Involved in 24/7 production support as per the need basis.

Environment: Oracle10g, Forms/Reports 6i, PL/SQL, TOAD, SQL*Loader, SQL*navigator, UNIX, CVS.

Confidential, Monroe, LA

Oracle Developer

Responsibilities:

• Developed Event Triggers, PL/SQL Program Units for Client Validations
• Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
• Developed Database procedures and functions to handle data manipulations and Computations on Server.
• Used SQL*Loader, PL/SQL procedures to facilitate data import to staging tables and then to base tables.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.
• Created PL/SQL packages to perform validations on imported data from legacy system before loading into Oracle tables.
• Used Materialized views in places where the data does not change very frequently.
• Developed UNIX shell scripts for batch jobs.
• Designed and developed Oracle Monthly Reports.
• Scheduling 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.
• Automated various kinds of backups using UNIX shell scripts.
• Created complex forms for 'Customer transaction loading' (GUI) for day to day business utility, using Forms9i.
• Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.
• Wrote Queries to retrieve data in XML format from the tables.
• Involved in supporting the Java web development team.
• Used FTP to transfer dump files from production server to testing server.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Oracle Database 9i, Windows XP, UNIX, SQL*PLUS, Oracle Reports 9i, Forms 9i, SQL Developer, PL/SQL, JAVA, JSP, Perl, UNIX Shell Scripting.

Confidential, Hartford, CT

Oracle Developer

Responsibilities:

• Responsible for preparing detailed design documents based on the business requirements.
• Developed PL/SQL programs such as triggers, procedures, functions and packages.
• Designed and developed Forms using 6i.
• Imported and Exported data from one table space to another and also loaded data from flat files to the staging area using SQL Loader in UNIX environment.
• Maintained summaries or aggregates on data using materialized views.
• Performed fine tuning on long running queries to reduce the execution time.
• Responsible for identifying database performance issues and tuning as necessary.
• Responsible for supporting user acceptance testing and responsible for defect tracking using test director
• Developed UNIX shell scripts.
• Involved in back end development and maintaining of oracle database.
• Developed several web based modules using HTML and JSP to meet end user requirements.

Environment: Oracle Database 9i, Windows 2000, UNIX, Forms 6i, SQL plus, SQL Loader, PL/SQL, UNIX Shell scripts, Perl, JAVA, HTML

Confidential

Oracle Developer

Responsibilities:

• Created PL/SQL packages and Database Triggers
• Developed, tested and executed SQL scripts and the PL/SQL blocks
• Developed reports based on the business requirements
• Developed user procedures and prepared user manuals for the new programs
• Maintained Design document and preformed testing.
• Custom development and registration of Tables and forms in the AOL.
• Gathered user specifications and system requirements for development process
• Converted Data stored in flat files into Oracle tables.
• Create triggers and writing procedures in Oracle to retrieve Information regarding the customer data.
• Generated complex Reports for the data coming from different vendors and customers.
• Loaded data into Oracle database using SQL* Loader.
• Developed online reporting system of the business users to see the transactions and reports.
• Interface development for the in-bound and out-bound data
• Trained end users for efficiency and usage of package and provided technical support.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Forms 6i, Reports 6i. Linux, Windows.