PROFESSIONAL SUMMARY:

• 7 years of experience in Database Development/Design and Production Support activities
• Have been working as Team Lead for On-site US team since March, 2011
• 5 years of experience in analysis, design, development, testing and implementation as Oracle PL/SQL Developer
• Hands on experience in writing UNIX Shell Scripts for automating the daily processesUsed UNIX Shell Scripts for FTP jobs
• Experienced in developing batch programs using PL/SQL and Shell Scripts and in using Import andSQL Loader Utility for loading data from flat files into Oracle tables.
• Tuned SQL queries using Explain Plan, TKProf, OptimizerHints, Indexes, Autotrace and Performed Refinement of the Database Design leading to significant improvement in system response time and efficiency
• Experience in developing PL/SQLStored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Bulk Collect, FORALL clause, Exception Handling
• Expertise in tools such as TOAD,SQL Plus, SQL developer, PL/SQL developer.
• Expertise in writing Stored Procedures and SQL Queries
• Extensive use of StarTeam for version management of code
• Actively coordinated and completed the QTP Automation POC for the Global Sales Application of the client
• Extensive experience in writingWindows Batch Scripts and scheduling using Windows Scheduler for automation
• 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
• Excellent knowledge in Software Development Life Cycle SDLC that includes requirements gathering, writing and reviewing 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
• Extensively used inbuilt Oracle PL/SQLpackages in application development.
• Experienced in the development and deployment of applications in Healthcare, Life Insurance, Auto Insurance domain. Defined, designed developed the use of reports by blending the financial knowledge of the client with the available technical know-how
• Over 3 years of overlapping experience in analysis, design, development, testing and implementation as SQL Server Developer
• Rich Experience in developing T-SQLStored Procedures, Functions, Database Triggers using features like Cursors, built in functions, temporary tables and table variables.
• Expertise in using tools such as MicrosoftSQL server Management Studio.
• Extensively used osql to run batch scripts in SQL Server 2008 R2
• Strong knowledge in using Micro Focus NetExpress for coding and debugging
• Worked as a part of team in 24x7 production environment and provided on-call support whenever needed
• Actively coordinated with Quality Team for User Acceptance Testing.
• Knowledge of job scheduling and using version control tools like VSS, CVS
• Strong programming and debugging skills in PL/SQL, SQL, T-SQL, MF Cobol and CoreJava
• Strong trouble-shooting, problem solving, analytical design skills and ability to grasp new tools and adapt to changing needs
• Excellent communication skills and ability to work individually as well as a team member

TECHNICAL EXPERTISE:

Programming Language s : PL/SQL, T-SQL, Java, J2EE, JSP, Vb Script, JavaScript, Windows Batch Scripting, UNIX Shell Script, 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, CVSTeam Developer 2.1, PVCS, Tracker, Bugzilla, JMeter, 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

PROJECT EXPERIENCE:

Confidential

Role: Team Lead/Developer

Confidential A fortune 100 company, has various lines of business and products. It has its IT development in various parts of US and worldwide. Confidential has two major systems Confidential Sales Illustration System and POS Point of Sale. For Russia and Gulf they had this systems. Now as part of strategic solution and anticipating more clients inflow a new Webservice base solution is also being built. The new systems Admin Module and MetConnect are being used to replace POS in Russia and Gulf.

Responsibilities:

• On-site Team Lead for Development and Maintenance team. Have an offshore team of 6 persons and on-site team of 3 persons.
• Extensive use of PL/SQL and SQL for our daily Production Support activities such as daily dashboard reports for GSP application.
• Production fixes and Performance tuning using index, bulk collect, forallclause 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.
• Have to work extensively with PL/SQL Packages, procedures and functions to run ad-hoc queries for our Russian customers.
• Have coordinated and successfully completed QTP Automation testing POC.
• Working on the database scrub store procedure for Russia 2.1D Pre-Production environment.
• Using Java Web Service 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
• Use of SOAP UI for sanity testing after each deployment.
• Compiling and review of SRS and Project plans for both Russia and Gulf Projects. Coordinating walk-through of SRS in-front of business.
• Compiling and reviewing of Approach Note for different intake items for Russia and Gulf systems.
• Use of UNIX Shell Scripting to ftp files from offshore to on-site locations and use the EAR file for deployment.
• Create users for testing purposes using Admin Module
• Coordinate between Russian and Gulf team to get a solution as per business need.
• Work with Poland Production support team to find resolution for any production bug and assign it to our production support team.
• Send fixed EAR to Poland support team so that they can deploy the fix in production support.
• Coordinate between BE offshore team, FE team and Middle-ware team to find solution for production issues.
• Coordinate between QA testing team, using HP Quality Center to identifybugs and try to find out resolution for the same.
• Run SQL scripts and deploy the same in testing environment.
• Debug code in case of any deployment related issues.
• Maintain 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 Lead/Developer

Responsibilities:

• Have 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.
• Have used PGP encryption to automate Decryption and SFTP process.
• Have worked on SQL server store procedures and SQL scripting.
• Have worked with BA and users to get better understanding of Client requirements for existing and new process.
• Have 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 Keyconstraints.
• 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 Tablesand 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 DatabaseTables.
• 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 GeneratingReports.
• Developed Data entry, query and reports request screens and tuned the SQLqueries.
• 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,PGP Encryption, Serena Version Manager, Windows Batch scripting, Team Developer 2.1,MF NetExpress, PVCS, Tracker, Bugzilla, PGP Keys, Microsoft SQL server Management Studio, 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.
• Have created scripts for housekeeping purpose.
• Tools used Rumba, BPE, Clarity, Auto SYS scheduler have monitored jobs using BPE.
• Have 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.
• Have created PL/SQL packages which will create flat files from Oracle and those flat files were loaded in Mainframe.
• Have used Auto-SYS for scheduling Inbound and Outbound jobs.
• Have used Mainframe terminal to check if the files are converted properly.
• Off-shore Team leader. Had one resources working under me

Confidential

Role: Vocational Teacher

Responsibilities:

• Have given training on Oracle and UNIX.
• Have conducted test and interview. Depending on their performance have given my feedback to the planer owner.

Environment: Unix, Oracle 9i, SQLPLUS, SQLLOADER

Confidential

Responsibility:

• Worked on developing the sql loader script and control file for the Surcharge feed.
• Writing 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 Web Service from another to get the required details.
• Adding new Coverage in the existing system.
• Off-shore Team leader. Was leading a team of five.

Environment:JAVA/J2EE,WebService,PL/SQL,UNIX ,Oracle 9i, 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.
• Have created shell script for the downstream feed jobs.
• Have created new screens for Salvage module.
• Have worked for new backend sql package for the new screen.
• Have worked on Caf architecture to add new flow for new business process.
• Have worked on Caf architecture to add new Java packages to support the new requirements.
• Off-shore Team leader. Had five people working under my supervision.

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

Confidential

Unified Inventory Interface Telecom

Responsibility:

• Handling Performance issues in IVVT and CIT test environment
• Being a Dataware house project we had to support ad hoc reporting, ETL mapping exectution, table and index rebuild
• IVVT and CIT testing support.
• IVVT and CIT code deployment .
• To make sure the IVVT and CIT database are running properly and checking the tablespace and other database related things.
• Running Unix scripts and also doing housekeeping in both Unix box as well as in the database.
• To maintain weblogic server and starting or stopping the database when needed.
• To deploy new applications during deployment and also housekeeping.
• To develop the database objects required for obtaining data from inbound systems.
• To deploy the OWB maps for data loading.
• To investigate on the cause of faulty data, if any.
• To take appropriate actions to get the erroneous data rectified.
• Working as Off-shore Team leader. Had two resources working under my supervision.

Environment:

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