Professional background

• Senior Oracle PL/SQL ETL Developer with over 5 years of experience.
• Possesses expert skills in the development of applications utilizing Oracle tools including Oracle PL/SQL, SQL Plus, SQL Loader, Informatica and experience with PL/SQL back-end programming - Database Triggers, Packages, Stored Procedures, Functions, and Management of Schema Objects.
• Highly skilled in application design, user interface design, software and application development processes, and data modelling.
• Possesses thorough understanding of relational database architecture, data warehousing, from logical and physical design, with proficiency in data definition and data manipulation languages.
• Experienced in all phases of Software Development Life Cycle. Excellent coding, debugging, and problem solving skills.
• Keen ability to discover and analyze strategic business objectives. Sensitive to issues. Successful at envisioning better mousetraps and exemplifying best practices. Committed to excellence.
• Possess strong project management skills and proven track record of leading large complex implementation projects.

Experience Summary

• Experienced in the areas of modeling, design, implementation and support of large scale ETL and data extraction solutions.
• Experienced in development of software applications in Oracle 10g using SQL, PL/SQL in Windows NT/2000/XP and UNIX environments.
• Distinctive knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.
• Strong knowledge in Oracle cursor management and exception handling. Extensive experience in Database query tuning of Reports and troubleshooting Oracle Application issues.
• Experienced in writing complex SQL Queries and creating Materialized views.
• Experienced in using tools like TOAD, SQL Navigator, PL/SQL Developer and SQL Plus.
• Developed UNIX Shell Scripts using K Shell and commands.
• Fair knowledge in web based software development and usage of programming tool Java such as JDBC connection and establishing relationship with Oracle databases.
• Experienced in E-R modelling and Relational Object Relational Database concepts and coding. Excellent database normalization skills.
• Expertise in Extraction Transformation Loading (ETL) process using Informatica PowerCenter consisting of data transformation, data sourcing, mapping, conversion and loading.
• Extensive experience in system development, implementation, maintenance and conversion of varied information systems and testing tools.

Education

• Bachelor of Engineering in Electronics and Communication

Acquired Skills

DataWarehousing

• Informatica PowerCenter 8.6
• Repository Manager
• Designer
• Workflow Manager
• Workflow Monitor
• Mapping Designer

Business Intelligence

• Actuate 7

Data Modeling

• ER Studio

Databases

• Teradata query language
• Oracle 9i/10g
• MS SQL Server 2000/7.0/6.5
• Sybase SQL Server 12.0/11.x
• MS Access 7.0

Programming

• SQL
• PL/SQL
• Embedded SQL
• TOAD
• Unix Shell Scripting
• C
• Java
• HTML 4.0

Environment

• Win 7/2000/98/95
• Windows NT 4.0
• HP-UX

Employment History

The details of the assignment that I have handled are listed here.

Logistics Supply chain Management Application - SeeChange

Period

Jun 2007 – till date

Client

Confidential

Role

Application Architect

Project Description
Confidential is the leading intermodal and ocean transportation carrier serving North America, Asia and the Middle East. It is the world\'s sixth largest container transportation and shipping company, providing services to more than 140 countries.
SeeChange a portal based web application shipment lifecycle management system, which the APL customers use for their shipment bookings and tracking. This system also acts as a reporting tool using which the users generate reports on their shipments. SeeChange also facilitates the communication between Customs of different countries and participating carriers. The SeeChange application is a global roll out in multiple phases and in multiple regions (North America, Europe and Asia)
This project is based on J2EE architecture framework which also uses Actuate reporting tool, Informatica data warehousing tool and Oracle back end.

Solution Environment

SQL Navigator, Actuate, Informatica

Technologies

Oracle 10g, PL/SQL, Actuate, Informatica

Operating System

Windows 7/ 2000 / 98, Unix

Responsibilities

• Built the application backend using Oracle PL/SQL and developed report generation using Actuate.
• Prepared system architecture diagrams, data flow diagrams and user interface details for entire application.
• Designing of ER diagrams for Data Modelling was done using ERWIN Tools.
• Developed several complex queries in PL/SQL and Teradata to establish report generation for various custom cases.
• Designed database tables and procedures, Triggers, Functions using PL/SQL.
• Built and deployed the application onWebsphere application server.
• Written stored procedures in PL/SQL.
• Developed code to handlewebrequests involving Request Handlers, Business Objects, and Data Access Objects.
• Has coded different package structures based on the purpose and security issues handled by that particular package which assists developers in future enhancements or modifications of code
• Involved in making the client side validations with JavaScript.
• Involved in code reviews, system integration and testing (SIT). Developed unit test cases.
• Involved in user acceptance testing, fixing bugs and Production support.
• Used the IBM Clear Case for the versioning.
• Acted as a core contributor in business requirements analysis.
• Preparation and review of the Design and Impact analysis documents.
• Execution of gap analysis within the existing application and recommending suitable enhancement solutions with effort estimates.
• Mentoring the other team members.
• Handling Onsite coordinator role and pursuing E2E business activities with other interface teams.

Certifications

• Acquired Foundation certification on banking domain and logistics domain in Infosys Technologies Limited.
• Acquired J2EE certification in Infosys Technologies Limited.
• Completed the Generic and Stream Comprehension Training provided by the Infosys Global Education Centre.
• Acquired Infosys internal certification in Quality Foundation.

Technical Training

• Attended two months high-end training on J2EE at Infosys Technologies Ltd, Mysore. The core curriculum included was Object Oriented Concepts, Oracle, Core Java and J2EE.

Project Management Training

• Attended various leadership trainings offered by the InfosysLeadership Institute includes Interpersonal Effectiveness, Customer Orientation, Working in a Team,Time Management, Effective Meetings and BusinessCommunication.

Rewards and Recognition

• Received “High Flyer” award from Infosys for exhibiting consistent excellence and commitment towards achieving project objectives.
• Received “Star Programmer” award from Infosys for demonstrating excellent coding skills in application development.
• Received “Most Valuable Team Player” award from Infosys for creating value for customers.