Summary:

• Over nine years of IT Experience in systems architecture, design, development, testing and Software Development Life Cycle (SDLC) Expertise
• Eight years of Experience with Oracle database including tools PLSQL, Forms, Reports, Discoverer, JDeveloper, Toad, SQL Loader, JAVA, Servlets, JSP,Export Import utilities
• Five years of experience with Case Management Systems in State Government like DVRS, Return-to-Work, On-Job-Training, Audits etc
• Highly skilled in Oracle 10g/9i/8i/8.0, PL/SQL, Forms6i/9i/10g,Reports10.1.Very good understanding of Object-Relational DBMS Architecture, Oracle processes, physical and logical structure of database, Distributed Database Systems, Client Server and Multi-tier architecture.
• Excellent Knowledge in PL/SQL Cartridge.
• Proficient knowledge on BO XI Architecture and new features.
• Worked extensively in developing and implementing Crystal reports/WebI on Business Objects Enterprise XI, XI REL2, Crystal Enterprise 8.0 thru 10, Business Objects Universe Design, Crystal Reports Explorer
• Extensive experience in programming with Java, EJB, Struts, Servlets, Java Server Pages, JDBC, PL/SQL, JNDI, JavaScript, XML, UNIX and strong practical knowledge in enterprise Application servers such as Bea WebLogic 8.1/7.0, IBM WebSphere 4.0.
• Excellent Knowledge in Struts/MVC Framework, Apache Tomcat 5.0, ANT and Enterprise Java Beans (EJB).
• Used various IDE’s like Eclipse 3.0, JDeveloper, and Weblogic workshop 8.1.
• Good experience on XML technologies like XSLT, SAXP, JDOM, and DTD with Java.
• Installed the Client tools i.e., Documentum Administrator, and Webtop.
• Extensive use of Documentum Administrator for User management and Security Management.

Confidential, NJ Jan 2011 till date
Job Description:

• Developed PL/SQL packages and SQL*LOADER routines for processing payments/Reserves/Claims/Activity notes/recovery data for Republic data conversion for worker compensation claims (WC) and responsible for data analysis and creating Oracle PL/SQL packages for processing Claims and loading Claims and Payment and for verification for dollar amounts and to automate using KORN shell scripting also involved in creating Maestro scheduler in Unix
• Developed 25 control files to load various data file and used hexa decimal character cleansing to load flat files are from cobol system to Oracle for the Republic data
• Developed and implemented and Pl/SQL packages for DCCI NCI Changes for carriers like AMTRUST and ZURICH
• Developed and loaded Unix shell scripts and automated the data conversion and loading and processing.
• Developed packages for data feeds using BULK COLLECT for improving performance
• Well efficient with tuning SQL and performance improvements and indexes and using Advanced features like BULK COLLECT and new features of Oracle.
• Involved in UAT and responsible for any data issues and resolving with QA and promoting document for production and check in/check out PL/SQL packages and control files
• Optimized PL/SQL procedures for performance and used autonomus transactions to log any errors and to rollback parent transactions in production implementation and exception handling.
• Developed PL/SQL packages and Unix KORN shell scripts and SQL*LOADER scripts and responsible for creating and loading of data file from Great American Insurance using standard interface layout and responsible for processing Property claims (PL) for GAI and deployed packages to production.
• Developed PL/SQL packages and KORN shell scripts to load data for City of Savannah payments and involved in voiding the old payments and loading the new payments and to associate the payments to Claims and also adjusting reserves using Total Incurred method.
• Developed triggers for data validation errors and failing transactions in case of Errors for data like missing Bill control number or Negative payments.
• Developed Packages for adjusting and setting reserves and implemented generic routines for setting up reserves for close claims

Project : Relationship Managemen

Environment: PLSQL, Oracle Forms 10g ids, Oracle Reports10g, Oracle 10g, Toad 9.6, SQL Loader, PL/SQL J2SE1.3,UNIX, Windows 2000, Adobe Acrobat,MS Excel, XML, and XSL.

• The individual has a permanent physical or mental impairment, which interferes with the ability to work, and Vocational rehabilitation services are necessary for the individual to prepare for, enter, engage in or keep gainful (paid) employment, and the individual with a disability can, will and wants to go to work. VR provides a wide range of services to help individuals with disabilities prepare for meaningful work. The Services received are arranged for and provided based on individual needs, so the length of time it takes to Prepare for employment is different for each person, as are the services provided.
• Worked as Senior Software Engineer to design a legacy system in Oracle 10g for DVRS (Division of Vocational Rehabilitation).
• Designing the System and creating PLSQL Packages and Procedures used for the System.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of services and cases.
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Attending the JAD sessions and Making Documentation for necessary changes.
• Oracle DBA, and Data management using SQL* Loader, DTS, and custom SQL,
• SQL tuning for Forms and Reports, writing; Assisted internal and external users with database issues;
• Created, updated, and maintained all Oracle PL/SQL
• Writing Conversion Scripts for Legacy Data conversion from Main Frame Cobol to Oracle 10g.
• Creating New Modules and tables for new Modules in the system with Application level security of the new module.
• Creating and modifying more than 50 Forms and more than 100 New Reports in Oracle 10g.
• Creating Database Objects like Tables, Views, Procedures, Triggers, Package, etc
• Maintaining Application under 3 separate Environments like Development, Test and Production.
• Debugging the Application Forms10g and Reports.
• Provided training for end users for generating their own report including complicated report.
• Improving Query performance with Explain plans and using Hint in SQL queries.
• Improving system performance with Table Indexes.
• Making Forms Section 508 compliance for Disability users to operate the system.

Environment: PL/SQL ,Oracle9ias, Oracle 9/10g ids, Oracle Reports10g, Business Objects 6.5.1/ XI r2 , Desktop Intelligence, Web Intelligence, CMS, Toad 9.6, SQL Loader, J2SE1.3, UNIX,Windows 2000, Sun Solaris, IIS, Adobe Acrobat,MS Excel, XML, and XSL.

Confidential, December 2004 July 2005

• Front End User Interface Design- Used Struts Framework, Swing, HTML, JSP, JavaScript, Java and Applet.
• Developed customized workflows, jobs and methods using Documentum tools.
• Involved in Creating customized object types.
• Developed web interface GUI using WDK, DFC, JSP, and JavaScript.
• Developed PERL scripts to generate custom reports.
• Developed JSP Custom Tags.
• Developed Java Based Socket Programs to read the files sent by PL/SQL.
• Customized WebTop features like Advanced Search, and Login by developing custom JSP and XML tags using WDK and DFC.
• Customized components for displaying and modifying the attributes for selected documents from the Docbase.
• Developed Typed Based Business Objects for Custom Object Types using BOF.
• Involved in writing DFC, API, DQL statements for retrieving data from the Docbase.
• Involved in writing Java Methods for auto activities in the Workflow.
• Developed client side customizations using DFC, API and DQL.
• Created users, groups, permission sets and ACLs using Documentum Administrator and Documentum Application Builder.
• Maintained LDAP Mailing Groups and users belonging to respective groups.
• Involved in Converting functional requirement Specifications into Design Requirements.

Environment: eContentServer 5.2.x, DQL, Documentum API, Documentum Application Builder, Documentum Administrator, WDK 5.2.x, DFC, WebTop, Samson, Toad 7, Java, Servlets, JSP, Struts1.1,Java Beans, PERL, WebLogic Application Server 8.1, Oracle 8i, Windows 2000.

Confidential, NJ July 2004 December 2004

• Developed an interface using Java, JSP, and Servlets to call the underlying documentum objects.
• The interface includes import, export, move, copy and other functionality which is achieved by embedding DFC calls with in the Servlets.
• Developed highly secured interface using Oracle PL/SQL, Java, and PERL.
• Developed customized workflows, jobs and methods using Documentum tools.
• Used Content Server 5.2.x as a Documentum Docbase repository.
• DFC is used to customize the workflows and life cycles.
• Involved in Creating customized object types.
• WF Manager is used to create workflow templates.
• Involved in writing, DFC, API, DQL statements for retrieving data from the Docbase.
• Developed client side customizations using DFC, API and DQL.
• Developed Search Customization in Webtop using JSP
• Developed Customized applications using WDK
• Developed Customized web browser-using Webtop.
• Implemented Documentum solutions that provide quick, easy and secure global access to all customer and business partner contracts throughout the contract lifecycle.

Environment: PL/SQL ,Java, JSP, Servlets, PERL, eContentServer 4.2/5.2.x, DQL, Documentum API, Documentum Application Builder,Unix,PERL, Documentum Administrator, WDK 5.2.x, DFC, WebTop, Samson, WebLogic Application Server 8.1, Oracle 8i, and Windows 2000.

Confidential, April 2002 January 2003
Developer/Support Analyst

• Involved in analyzing the requirement of BOF in existing framework.
• Customized WebPublisher Content control widget.
• Customized the title bar of the WebPublisher editor.
• Developed Java applications (class files) as pasrt of customizing the WebPublisher.
• Designed and developed the author able Thomson.com website.
• Developed xsl, xml and rules files for the content templates.
• Developed an application based on servlet and Jsp.
• Used DFC API with java application to retrieve the data from the docbase.
• Used Xalan API to transform the data received from the docbase to regular text.
• Implemented the integrated Omniture code, third party software to track the users of thomson.com
• Maintained the SCS and SDS functioning on daily basis.
• Worked with eRoom where the CR’s are updated and comments on the requested CR sent to the authors.
• Created scheduled jobs to publish the content templates (Press Releases, etc) on a regular basis.
• Configured publishing jobs for incremental and full refreshing.
• Created change sets for group publishing.
• Good with XMLSPY, SecureCRT and Eclipse IDE.
• Attended seminar on CYA hot back up techniques.

Environment: e-Content Server 5.2,Web Publisher 5.2, Documentum Administrator, DFC, DQL, Documentum API, Docbasic, J2SE1.3, Windows 2000, Sun Solaris, IIS, Adobe Acrobat, XML, XSL,PLSQL, Oracle8i, and BEA WebLogic Server.

Confidential, August 2001 April 2002
Project AUTO WEBBER

Automated tool for Web enabling using Confidential, for conversion of various document formats. It is a general purpose editor to enable conversions of data from various document formats such as Quark Express, PDF, Word documents etc., and web enabling the information by using customer specific tags in Confidential, Standard General Markup Language.

• Coded and tested the software.

Environment: PERL, Java, WebLogic Application Server, Oracle 8i, and Windows 2000.

Confidential, December 1999 July 2001

• Analyzed, designed, and coded “Greetings” module.

Environment: HTML, Applets, Servlets, Java1.1, and Socket programming.

Education:
Master’s in Computer Science
Bachelor of Engineer