PROFESSIONAL SUMMARY:

• Lead Developer with total 7 years of experience in Development/Design and Support activities.
• 5 years of experience in analysis, design, development, testing and implementation as ORACLE PL/SQL DEVELOPER.
• Experienced in developing batch programs by using PL/SQL and shell scripts and in using Import and SQL Loader Utility for loading data from flat files into Oracle tables.
• Tuned SQL queries using explain plan, TKProf, optimizer Hints, Indexes, Autotrace and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Rich Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling.
• Strong in using tools such as TOAD, SQL Plus, SQL developer, PL/SQL developer.
• Strong in writing Stored Procedures and SQL queries.
• Expert in multiple RDBMS including Oracle 11g R2/9i, Microsoft SQL Server 2008 R2 and associated SQL Dialects such as PL/SQL, Transact SQL T-SQL
• Extensively used inbuilt Oracle PL/SQL packages in application development.
• Experience in analysis, design, development, testing and implementation as SQL Server DEVELOPER
• Rich Experience in developing T-SQL Stored Procedures, Functions, Database Triggers using features like Cursors, built in function, temporary tables and table variables.
• Strong in using tools such as Microsoft SQL server Management Studio. Have extensively used sql to run batch scripts in SQL Server 2008 R2.
• Strong programming and debugging skills in PL/SQL, SQL, T-SQL, MF Cobol and Java
• Extensive work exposure in writing UNIX shell scripts for automating the daily processes.
• Use of UNIX Shell scripts for FTP jobs.
• Extensive use of Starteam for check-in and check-out
• Actively coordinated and completed the QTP Automation POC for the Russian Client
• Extensive experience in writing Windows Batch scripting and scheduling using Windows Scheduler for automation.
• Excellent knowledge in Software Development Life Cycle SDLC that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• EAR deployment on WAS 6.1 using Admin Console.
• SQL script deployment in DEV region while promoting code.
• Experienced in the development and deployment of Healthcare, Life Insurance, Auto Insurance companies. Defined, designed developed the use of Reports by blending the financial knowledge of the client with the available technical know-how.
• Strong knowledge in using Micro Focus NetExpress for coding and debugging purpose.
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
• Actively coordinated with Quality Team and User Acceptance Testing.
• Knowledge of job scheduling and using version control tools like VSS, CVS
• Strong skills in objected oriented programming using Java
• Strong Trouble-shooting, Problem solving, Analytical Design Skills and ability to quickly master new software and adapt to changing needs
• Excellent communication skills and ability to work individually and as a member of a team.

Technical Expertise:

• Programming Language s : PL/SQL,T-SQL,Java,J2EE,JSP,VBScript,JavaScript,Windows Batch Scripting, UNIX Shell Script, Jmeter, Pro C , Gupta SQL Centura, MF Cobol
• Tools: SOAP UI, Eclipse, Microsoft SQL server Management Studio,WinSCP,RAD7.0, Toad for Oracle 9i, PL/SQL Developer, SQL Developer, QTP 11,Starteam 11, XML SPY,WAS Server 6.1, Serena, VSS, MF NetExpress, CVS Team Developer 2.1, PVCS, Tracker, Bugzilla, PGP Keys
• Database: Oracle 11g R2/9i, SQL Server 2008 R2
• Operating System: Windows 7/Vista/XP/98,Windows 2008 Server, HP-UNIX, Solaris, Mainframe

Key Competencies and Skills

Project experience:

Confidential

Role: Team Leader/Developer

Responsibilities:

• Lead Developer for Development and Maintenance team. Have a team of 9 people.
• Extensive use of PL/SQL and SQL for our daily Production activities such as daily dashboard reports for GSP.
• Production fixes and Performance tuning using index for the Russia Production and Gulf Production systems for both Admin Module and GSP
• Performance tuning for our GSP reporting and certificate creation process using TKProf, Explain Plan and SQL Trace.
• Working extensively with PL/SQL Packages, procedures and functions to run adhoc queries for our Russian customers.
• Coordinating and successfully complete QTP Automation testing POC.
• Working on the database scrub store procedure for Russia 2.1D Pre Production environment.
• Using Java WebService for our Back end WebService.
• EAR deployment in WAS 6.1 server using IBM Admin Console for both the MetConnect and Admin Console application.
• Work with Infrastructure team to setup LDAP server and WAS deployment for INT and UAT deployment
• Using SOAP UI for sanity testing after each deployment.
• Compiling and review of SRS and Project plans for both Russia and Gulf Projects. Coordinating SRS walkthrough of SRS in-front of business.
• Compiling and review of Approach Note for different intake items for Russia and Gulf.
• Using UNIX Shell Scripting to ftp files from offshore to onsite location and use the EAR file for deployment.
• Creating users for Testing purpose using Admin Module
• Coordinate between Russian and Gulf team to get a solution as per business need.
• Working with Poland Production support team to find resolution for any production bug and assign it to our production support team.
• Using to send fixed EAR to Poland support team so that they can deploy the fix in production support.
• Coordinating between BE team, FE team and Middleware team to find solution for production issues.
• Coordinating between QA testing team, using HP Quality Center to find out bug and try to find out resolution for the same.
• Using to do run SQL scripts and deploy SQL scripts in testing environment.
• Debugging code in case there was any deployment related issues.
• Maintaining code base using Star team.

Environment: Oracle 11G,XMLSpy, Start Team, Windows Batch scripting, TOAD, WinSCP, RAD 7.5, SOAP UI, WAS 6.1, WebService, HP Quality Center. UNIX

Confidential

Role: Team Leader/Developer

Responsibilities:

• Worked in different projects in Compass, from design to code deployment.
• Designing new screens for Compass.
• Batch automation process including the Member ID card generation process.
• Developing new screens for Fulfillment project as well as RSC Integration.
• EDI load process bug fixing and adding new validation report to the existing process.
• Used PGP encryption to automate Decryption and SFTP process.
• Worked on SQL server store procedures and SQL scripting.
• Worked with BA and users to get better understanding of Client requirements for existing and new process.
• Worked different production issues, for example Batch billing process, EDI Validation etc.
• Participated in Designing databases schemas to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, DB triggers, Indexes.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Involved in the Database Design Relational and Dimensional models using ERwin.
• Defined both logical views and physical data structure using ERwin.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Centura Gupta SQL,MF Cobol, SQL Server 2000, Microsoft SQL Server Management Studio, PGP Encryption, Serena Version Manager, Windows Batch scripting, Team Developer 2.1, MF NetExpress, PVCS, Tracker, Bugzilla, PGP Keys, WinSCP

Confidential

Role: Developer

Responsibilities:

• Worked on developing UNIX shell scripts that will call Clarity Data conversion tool to convert EBCDIC file to ASCII file.
• Created scripts for housekeeping purpose.
• Used Tools like Rumba, BPE, Clarity, Auto SYS scheduler have monitored jobs using BPE.
• Used SQL Loader to perform data load between Mainframe and Oracle Database. Have used automated shell scripts to run those jobs and upload the flat files received from Mainframe.
• Created PL/SQL packages which will create flat files from Oracle and those flat files were loaded in Mainframe.
• Used Auto-SYS for scheduling Inbound and Outbound jobs.
• Used Mainframe terminal to check if the files are converted properly.

Environment: Oracle 11G R2, Rumba, Clarity BPE, Autosys, HP UNIX.

Confidential

Role: Vocational Teacher

Responsibilities:

Environment: Oracle 9i, SQL PLUS, SQL LOADER, UNIX,

Confidential

Responsibility:

• Worked on developing the SQL loader script and control file for the Surcharge feed.
• Wrote shell script for the SQL loader for daily feed of Surcharge feed.
• Testing and Developing the Index Layout feed Java batch.
• Have worked on Java batch which picked up files from JMS MDB and updated Oracle tables using PL/SQL package.
• Writing shell script for the Java batch for daily feed of Index Layout feed.
• Design and Analysis for State Wise Rollout. Developing the XSD for the Short Pull WebService.
• Testing the Long Pull WebService for the coverage part.
• Generating the WSDL for the Short Pull WebService for the client in RAD7.0.
• Developing the server end components for the Short Pull WebService in RAD7.
• Working as a SPOC for DRC CRN Enhancement projects.
• Calling one WebService from another to get the required details. Adding new Coverage in the existing system.

Environment: PL/SQL, UNIX, Oracle 9i, JAVA/J2EE, WebService, RAD 7.0, Eclipse, PLSQL Developer, Toad, XMLSPY, Serena, VSS

Confidential

Role: Developer

Responsibility:

• Worked on developing SQL loader script and control file for the downstream feed file jobs.
• Created shell script for the downstream feed jobs.
• Created new screens for Salvage module.
• Worked for new backend SQL package for the new screen.
• Worked on Caf architecture to add new flow for new business process.
• Worked on Caf architecture to add new Java packages to support the new requirements.

Environment: PL/SQL, Oracle 9i, RAD 7.0, PLSQL Developer, JAVA/J2EE, Toad, UNIX, XMLSPY, Serena, VSS

Confidential

Responsibility:

• Handling Performance issues in IVVT and CIT test environment
• Being a Dataware house project we had to support ad hoc reporting, ETL mapping execution, table and index rebuild
• IVVT and CIT testing support. IVVT and CIT code deployment.
• Ensure the IVVT and CIT database are running properly and checking the tablespaces and other database related things.
• Running UNIX scripts and also doing housekeeping in both UNIX box as well as in the database.
• Maintain weblogic server and starting or stopping the database when needed.
• Deploy new applications during deployment and also housekeeping.
• Develop the database objects required for obtaining data from inbound systems.
• Deploy the OWB maps for data loading.
• Investigate on the cause of faulty data, if any.
• Take appropriate actions to get the erroneous data rectified.

Environment: SQL, PL/SQL, Oracle 9i, Toad for Oracle 9i, PL/SQL developer, SQL developer, Weblogic 8.1, CVS