SUMMARY

• Have 8+ years of IT experience in Analysis, Design, Development, Implementation and support of RDBMS in Production, Development and Test environments using Oracle PLSQL in client server environments.
• Currently working as Technology Lead in Confidential
• ‘Senior Application Developer’ (Designation - Senior Software Engineer) at Confidential Information Services for 4 years.
• Have experience in Health Care/Insurance, Finance, Supply Chain and Product Management Domain.
• Advanced skills in Oracle 11g/10g/9i/8i database programming using PL/SQL
• Experience with performance tuning in Oracle 10g using Explain plan, Hints and by usage of best Indexes.
• Proficient in handling job schedule tools like Autosys & TWS (IBM workload scheduler)
• Good ITSM understanding of Problem, Change and Incident Management covering overall SLA Management and Metrics management.
• Expertise in ITSM tools like HP Service Manager, Team Track, HP Quality Center
• Basic knowledge of ETL tools like Datastage and Informatica.
• Knowledge on Eclipse IDE, JAVA, PowerBuilder, Unix shell scripting
• Thorough experience on software development methodology and Quality. Worked in various projects adhering to phases of software development life cycle which includes system study, analysis, design, development, testing and implementation.
• Excellent analytical skills, logical reasoning, interpersonal skills, problem solving skills, communication skills and leadership qualities to work in team.

TECHNICAL SKILLS

Operating System: WINDOWS XP, DOS, UNIX

Environment: UNIX

Database: Oracle 11g; 10g ; 8i, DB2

Languages: Oracle SQL, PL/SQL, JAVA/J2EE, C, ProC, COBOL, Informix 4gl

Tools: Autosys, IBM Tivoli Workload Scheduler, SQL Developer, SQL*plus, TOAD, Sybase Power Builder, MS Office, Eclipse, Soap UI, Datastage, Informatica, Quality Center, IBM Migration Toolkit, HP Service Manager

EDEcPackagesERP Package: LAWSON Financial

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Analysis of Business Service Requests and providing reports, fix and workarounds for issues in Production Environment.
• Monitoring Autosys for Handling Batch Support for job failures. dis ranges from Analysis of Incident tickets, providing quick work around, identifying root cause for possible defects in application.
• Providing Solutions to Client side on Production Issues

Confidential

Responsibilities:

• Analyzing teh existing systems and gather teh business requirements for new functionalities.
• Preparing Technical Design Document, RTM, UTP etc
• Development and enhancement of PL/SQL packages, stored procedures to meet teh business requirements.
• Generation of highly tuned complex reports using plsql.
• Tuning of existing code for performance improvement.
• Handled complete archiving of database schema tables and rebuild of indexes and tables.
• Solution Design for Process Automation for manual works done in teh project.
• Handled Oracle upgrade from 10g to 11g that involved planning, complete configuration changes, code changes, complete assistance to QA and UAT and deployment team.
• Analysis of Business Service Requests and providing reports and handle mass data patch or correction activities following program logic through anonymous blocks.
• Handling Batch Support for job failures. dis ranges from Analysis of Incident tickets, providing quick work around, identifying root cause for possible defects in application.
• Actively participating in War room and Providing Solutions to Client side on Production Issues
• Functional Support and design for Migration of Batch Jobs from Autosys to TWS
• SME for Billing area and created Functional Documents for teh same.
• Involved in QA related activities like Creating Test Scenarios, QA testing.
• Also involved in analysis on how to reduce total incident related count as a part of Continuous Improvement initiative and looking into new areas for process automation.
• Performed a role of Knowledge Moderator to maintain teh knowledge repository to provide teh easy access to documents and to reduce teh project dependency. Imparted oracle Trainings to new joiner batches

Confidential

Responsibilities:

• Preparation of Estimates and Statement of Work as per business requirements
• Preparation of Technical Design document (TD)
• Analysis of existing system & functionalities
• Creation of new screens/ adding new functionality to teh already existing screens using Sybase PowerBuilder.
• Coding of backend triggers, procedures, functions and packages in Oracle 8i using PL/SQL.
• Creation of interface files using UNIX and ProC.
• Creating Informatica ETL programs and workflows
• Completing Unit testing with different scenarios as per FR
• Completing Integration testing
• Necessary support in UAT phase
• Delivery of all teh phases of project after internal review.
• Involved in L2 production support activities
• Real Time problem diagnosis and solving of tickets raised by Users on teh production environment.
• Working extensively on teh maintenance of online screens, batch analysis, report requests and queries and inquiries by User.

Confidential

Responsibilities:

• Customization of existing LAWSON modules AP/AR/GL/Invoices etc. for teh project while upgrading ERP Lawson v8 to v9. Comfortable with Lawson online and batch programs, APIs, screens and reports. Worked on enhancement and development assignments.
• Data Conversion for converting data from Informix to DB2.
• Used java and UNIX for developing testing scripts for upgrade of client database from Informix to DB2.
• Development & Modification of Unix scripts and C programs for creating interface files for two or more systems
• SIT for Lawson Reimplementation Project on Lawson Release 9 applications.