Oracle Pl/sql Developer Resume
Washington, DC
SUMMARY
- 10 Years of experience in IT industry across multiple technologies.
- Actively worked on SDLC processes such as requirements study and specification, analysis, designing, developing, integration, testing, implementing and supporting software systems.
- Excellent in handling and managing Fircosoft tools - Fircosoft Multilist Manager(FMM), Firco Utiliites Manager (FUM), Firco Files Filer (FFF),Firco Messages Filer (FMF).
- Experienced in total development life cycle of software product - application specification, design, development, testing and implementation.
- Worked on J2EE technologies, including Servlets, JSP, JDBC.
- Expertise in using WebSphere 5.* Application Servers.
- Good Knowledge in design patterns like MVC, Singleton..
- Worked extensively with Source control tools like CVS, Visual SourceSafe, Clear Case, ANT, Eclipse, WSAD,TOAD.
- Excellent communication, interpersonal and troubleshooting skills.
- Unix Shell Scripting, Scheduling Cron Jobs
- Struts 1.2, Jasper Reports, iReport Tool
- Strong experience with Core Java, SQL,Oracle PL/SQL, UNIX Shell Scripting,HTML, XML,Java, and JavaScript.
- Extensively Worked on SQL Scripts, Stored Procedures, Functions, Packages and Triggers.
- Understanding client needs and developing reports using Jasper Reports and iReport tool according to the requirements and specifications
- Ability to work in teams of varying sizes as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
- Efficient team player with strong analytical and problem solving skills, excellent communication skills, leadership and management abilities.
- Worked effectively on applications development and maintenance projects.
TECHNICAL SKILLS
Databases: Oracle 10g/9i/8i, MS SQL Server 2000
Tools: Putty, SQL*Plus, MS Visio, MS Project, Clarify, ClearCase, Jasper Reports, iReport Tool, TOAD,ANT,CVS,Eclipse, IBM WSAD(Websphere Studio Application Developer), Visual Safe Source, IBM WebSphere Application Server, Tomcat, IBM WebSphere MQ, Private Ark Client,Spring, Hibernate,Remedy,Oracle Application Server,JBoss
OS: Windows XP/2000/NT/98/95, UNIX (AIX, Solaris), Linux, MS DOS. Windows NT 4.0, UNIX (Sun Solaris 2.5 - 2.6), Windows Vista.
UNIX tools: C Shell, Bourne Shell, VI editor.
Programming: SQL, PL/SQL, UNIX Shell Scripting, Perl, HTML, XML, C, C++, Java.
PROFESSIONAL EXPERIENCE
Confidential
Oracle PL/SQL Developer
Responsibilities:
- Team Lead - Responsible for leading and mentoring a team of 5 people in Jasper Reports, and java development.
- Involved in Requirements Validation and Review Sessions and walk-through’s to understand the Business functions, project needs and to validate the requirements for accuracy.
- Involved in analyzing the project requirements and highlighting the issues encountered.
- Involved in interacting with various project teams to develop the procedures to improve the existing process.
- Involved in General and Detailed System Design to develop the new system as per the requirements.
- Configuring and Customizing the development Tools (Eclipse, TOAD, Oracle Application Server, CVS, Jasper Report,IReport Tool) as per the Project requirements.
- Responsible for developing Reports Module.
- Developed Shell Scripts . Schedule cron jobs.
- Worked closely with the project and program management, provided detailed status reports on current status of the project.
- Provided overview on what was accomplished and what’s remaining in terms of deliverables for every week.
- Developed Software Packages using UNIX Shell scripts, SQL, PL/SQL, XML and HTML.
- Developed complex PL/SQL Packages, Stored Procedures, Functions..
- Improved efficiency of delivering software through re-usable design and code.
- As a SME, trained new team members in the project, with report functionality and processes.
Environment: Oracle 10g, SQL, Java, J2EE, TOAD,CVS,Oracle,Jasper Reports, IReport Tool,Oracle Application Server (OAS),Struts,JSP,Eclipse PL/SQL Procedures,AJAX Reports,Unix Shell Scripting,Cron Jobs,Oracle Application Server
Confidential, Washington DC
Java Developer/Production Support Lead
Responsibilities:
- Accountable for handling production issues, Releasing new versions to Production, Monitoring the application,Maintaining report data/application and incident logs,Handling incidents (ticket) created by users,Configuring application in a high quality/timely manner and ensuring compliance with the Bank Secrecy Act .
- Evaluating requests from the Business user for account creation in Fircosoft tools.
- Regularly work with the end users to improve application performance / tuning and implementation of these to ensure future compliance.
- Key contributor to setting /configuring Fircosoft tools and environment that are included in Worldbank’s current Confidential procedures.
- Leading a team of 3 people. Responsible for assigning work and get the deliverables.
- Ensuring all new Confidential temporary hires receives their access to servers/application on a timely basis.
- Serve as subject matter expert on Confidential related questions and provide guidance to users relating to use of new tool, new features available in upcoming versions.
- Excellent knowledge of Fircosoft tools (Front End and Backend).Ability to troubleshoot any issues related to Fircosoft products(FFF, FMF, FFF classic, FUM, FMM).
Environment: Oracle 10g, PL/SQL Stored Procedures,TOAD,Java/J2EE,ClearCase,Unix-AIXLotus-Notes, Fircosoft Products - Fircosoft Files Filter Verify (FFF Verify), Firco Utiliites Manager (FUM), Firco Multilist Manager (FMM), Firco Files Filter Classic (FFF Classic)
Confidential, New York
Java,Pl/SQL Developer/Production Support Analyst
Responsibilities:
- Involved in handling production issues.
- Production roll out of new versions.
- Deploying .war files on to WebSphere Application Server.
- Monitoring the application,maintaining report data,incident logs and the application.
- Providing Training,Maintaining Reports recipients list,Handling incidents (ticket) created by users.
- Developed UNIX Shell Scripts to interface with database server, change environments, schedule events like auto shut down of server, run specific tasks in off peak hours.
- Worked on transformation of files using FTP to all UNIX servers at one time.
- Interacted with users and modified existing reports for code and output as per requests.
- Used DBMS JOB and DBMS SCHEDULER for job scheduling.
- Trained and developed user friendly user manuals for end users to develop simple discoverer report.
- Involved with end users to make enhancements.
- Developed PL/SQL code to customize reports.
- Confidential Application - Handling Production Support Issues (Tickets), Change Requests, Reports Maintainence, Updating Session Keys.
Environment: Oracle9i,SQL,PL/SQL,TOAD,Unix,Tomcat,Clarify,Private Ark Client, MQSUN Solaris.
Confidential
Java Developer
Responsibilities:
- Involved and played a significant role in all phases of development of the system right from the initial stage.
- Enhancing the application using General Motors (GM) framework.
- Conducted user meetings and sessions to identify the client requirements.
- Involved in analyzing the system by meeting the clients and obtaining their requirements.
- Played a major role in System Design of Estimate, Purchase Order, and Sales Rep. Module.
- Extensively involved in developing database objects tables, stored procedures and triggers.
- Involved in performing tuning.
- Generated Sales, Performance, Commission reports, Estimates, PO s between two dates etc.
- Supported the Quality assurance team in unit and integration testing.
Environment: Oracle 7.3/8i, SQL, PL/SQL, Crystal Report Writer, Windows NT.
Confidential
Java Developer
Responsibilities:
- Development and Maintanence.
- Involved in development of CustomerFileExport.
- Developed many JSP pages,Iframes,Java Classes.
- Successfully developed mail sending utility.
- Provided support to other screens used for Creation of Fuel Tickets and Purchase invoice, maintainence screens.
- Also involved in modification/updation of build file for deploying the code to server.
Environment: Java,JSP,ANT(Another Neat Tool),Tomcat
Confidential
Java Developer
Responsibilities:
- Development and Maintanence.
- Supporting finance tools like Returns, Pricing, SRC.
- Did following Major Enhancements in Returns Tool.
- Added $0 Returnability feature in Returns Tool.
- SHARE Enhancement:Approvers are now pulled from SHARE(Sales Hierarchy Advanced Repository Environment) database.
- Added Third Level Approver in the Returns Tool so that request greater than $250k can be approved by Third Level Approver.
- All the development/maintenance activites used Cisco Framework for its development.
- Implement the enhanced feature in the returns tool, which is used for returning items to CISCO.
Environment: Java Servlets, JSP,Secure Shell, Oracle PL/SQL,BES5.2
Confidential
Java Developer
Responsibilities:
- Development and Maintanence.
- Analysing and designing the system.
- Involved in coding using PL/SQL.
- Involved in the requirement analysis team, which included the responsibilities of understanding the requirement study, system specification, preparation of flow charts, preparation of use-case templates and in the preparation of system test cases.
- Involved in entire development life Cycle.
- Coding and testing of HR module.
Environment: Pentium,Windows 98, JSP,Oracle 8i,Java 2.0, JSP,Windows NT,PL/SQL.
Confidential
Java, Oracle PL/SQL Developer
Responsibilities:
- Development and Maintanence.
- Developed forms direct client and salary review.
- Designed and created database tables.
- Developed loader program written in PL/SQL.
- After reading and performing all manipulations it loads those data into various tables.
- Developed parser in Perl, which used to read a text file and produced a structured file, which was fed to above loader program.
Environment: Pentium, Windows ME & NT, Java Swings, JDBC, Oracle 8i, Perl 5.6, PL/SQL
Confidential
System Analyst
Responsibilities:
- Did internal review, prepared the reports and deliverables to the client.
- Used tools like TRACER 2000, VISION IMPACT (for COBOL) to find out the date effected code in the existing software.
Environment: Pentium, Windows NT, Tracer 2000.