Summary





About 5 years of experience in software development in Logistics and Financial industry involved in all phases of project life cycle using SEI-CMM Level 5 and ISO 9000 - 2001 methodologies that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment
Around 5 years of technical experience with SQL, PL/SQL, Oracle 9/10/11i, Oracle Forms 6i, Oracle Report 6i, Oracle Forms 10g, Oracle Report 10g, Forms 10g, Reports 10g
Completed ORACLE Certified Associate OCA first certification
Excellent knowledge of Oracle Development tools PL/SQL, TOAD
Rich Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling and good in Oracle Forms and Reports.
Worked with databases like Oracle 10g, 9i, 8i, Access.
Extensive knowledge in SQL Tuning statements queries to enhance the database performance and availability
Very Good Knowledge of RDBMS fundamentals and Concepts.
Extensive experience in designing new databases, forms, web based application using Oracle as backend on Unix systems
Extensive knowledge of database designing, data modeling, query optimization, Unix platform
Adept with Entity- Relationship diagrams and used Data Modeling Tools like ERwin and TOAD.
Good Experience in developing dynamic web pages using PHP and HTML
Actively used methodologies for Change Management, Software Development methodologies, QA testing, Systems Testing, Performance Testing coordinated with Quality Team and User Acceptance Testing
Rich Experience in Unit and System testing as part of the Development Life Cycle
Participated in various JAD sessions, requirement analysis and product development sessions
Worked in production support for various Oracle based applications, enhanced performance, fixed defects on the go.
Strong interpersonal communication and team management skills, the ability to work with people of all technical levels


Employment

October, 2006 -  June, 2007

July, 2007 -  Present
Senior Programmer Analyst

ABN AMRO
Bank ranks among the top 10 banks in the world in size. Its international network is spread over 76 countries.

The current project deals with the maintenance, enhancement and production support for the ABN AMRO - WSS. This application support project intends to replace the existing system OMR with WSS globally. Services requested in this project are for the current ALM ASIA instance at Singapore site and the new deployments planned for EMEA, AMERICA and ASIA as per timelines provided.

Responsibilities -
Analyzed the changes to be made in system, existing defects and bottlenecks affecting business processes. Proposed solutions for these problems technically and to improve performance of whole system.
Discussed and explained these solutions to business teams. This was done considering and analyzing business workarounds as well..
Created test scenarios, test scripts, test data for exhaustive system testing.
Handled production support, fixed the major defects on the run.
Implemented enhancements in existing applications using Oracle and PL/SQL.
Developed PL/SQL- Packages, Procedures, Database Triggers and SQL Scripts to populate the historic data in the tables applying business logic.
Written many database triggers for automatic updating the tables and views.
Created a procedure to load the data from excel, CSV files Into Targeted Oracle Tables.
Created packages and procedures to update data tables.
Developed various Complex Queries, views for Generating Oracle Reports
Wrote complex SQL Scripts and was responsible for Performance tuning of such SQL Queries.
Involved in tuning of some interfaces Stored packages/procedures/functions to speed up the process.
involved in all phases of Unit and System Testing, UAT.
Used SQL Loader for extracting and loading data from flat files.

Environment Oracle 9i, PL/SQL, Oracle Forms 6i, Oracle Report 6i, Unix, PL/SQL Developer, SQL * Loader

Projects with FWL Technologies :

June, 2005 -  September, 2006
Senior Oracle Programmer

China Shipping is 1 of the biggest shipping carries in the world. They have container shipping, logistics, tracking, transport systems implemented in Oracle 9i. This project involved major modifications to existing system and designing and implementing new functionality.

Responsibilities -
Handled modules for Standing Data, Vessel Operations, Booking, Equipment, etc.
Implemented enhancements in existing applications using Oracle and PL/SQL.
Developed PL/SQL Stored Procedures, Functions, Cursors, Triggers, Packages and SQL queries using join conditions.
Created and managed primary data base objects like Tables, Views, Indexes, Sequences and Synonyms.
Developed and modified forms using Forms 6i and 10g as per customer needs.
Generating billing reports for a month computed on hourly basis using Oracle Reports.
Tuned used SQL Statements and PL/SQL Blocks and increased performance.
Implemented Export/Import Oracle utilities to move data to different testing environments.
involved in all phases of Unit and System Testing, UAT.
Created detailed documentation of enhancements for user approval.
Developed use cases and functional specifications and provided UML diagrams.
Conducted meetings with the different teams to understand the application, its dependencies and the environment.
Analyzed the changes to be made in system, existing defects.
Analyzed reporting processes, evaluated users needs and created functional specifications to implement new processes using Reports 9i.
Created test scenarios, test scripts, test data for exhaustive system testing.
Helped production support team after the implementation of the project, in debugging, analyzing production problems and fixing those.

Environment Oracle 9i, PL/SQL, Oracle Form 6i, Oracle Report 6i, Unix, PL/SQL Developer

July, 2004 -  May, 2005
Oracle Programmer

Education

Training

Oracle Certified Associate OCA first certification
TCS internal certification in Investment Banking with Grade A.
Projects with TCS :
Client - ABN AMRO , Singapore and USA
Samskip is a transport company which offers its customers comprehensive solutions regarding transport and transport related services throughout the world . They had logistics , transport systems implemented in Oracle 10g . This project involved creating new applications for logistics control .
Responsibilities -
Developed use cases and functional specifications and provided UML diagrams .
Assisted in the product planning and development cycles : from gathering requirements to writing specifications and shaping the software development process .
Analyzed the existing database structures that need to be used , any modifications needed .
Performed extensive Requirement Analysis , data analysis and gap analysis .
Heavy SQL query optimization was done and performance was improved significantly . Overall system performance was improved by 65% .
Designed new screens for this new application and additional screens for the existing system to link into to the new application
Designed and developed project document templates based on SDLC methodology .
Helped production support team after the implementation of the project , in debugging , analyzing production problems and fixing those .
Successfully implemented enhancements in existing applications using Oracle and PL/SQL .
Developed PL/SQL Stored Procedures , Functions , Cursors , Triggers , Packages and SQL queries using join , subqueries , scripts .
Successfully implemented enhancements in existing applications using Oracle and PL/SQL .
Developed and debugged the application screens and reports using forms 10g and Report 10g .
Optimization tuning was done for used SQL Statements and PL/SQL Blocks and increased performance .
Implemented Export/Import Oracle utilities to move data to different testing environments .
involved in all phases of Unit , Assembly and System Testing , UAT .
Environment Oracle 10g , Forms 10g , Reports 10g , Unix and shell scripting , TOAD


Skills

Operating System UNIX, WINDOWS XP or NT or 2000, DOS Language SQL, PL/SQL, Unix and shell scripts, Perl, HTML, XML, C, C++ JAVA, VB Script GUI Visual Basic 6.0, ASP, Developer 2000 D2K, Oracle Forms6i, Reports6i, Forms 10g, Reports 10g Reports Oracle Reports 9i, Oracle Reports 10g, Sql Reports 9i Packages Office Word, Excel, Access, Power Point RDBMS/ DBMS Oracle 9i, Oracle 10g, MS-Access Oracle Development Tools TOAD, PL/SQL developer, SQL Loader Programming Tools UML, Rational Unified Process RUP Version Control Tools PVCS, CVS, VSS