SUMMARY

• Around 11+ years of proven experience in Information Technology industry with 9+ years of experience in the design, development and implementation of business/application software using Oracle databases 11g/10g/9i/8.x.
• Oracle Professional expertise in Oracle SQL, PL/SQL, UNIX, Shell Scripting, Perl Scripting, Sybase and ETL (Informatica) technology.
• Automation of Tasks in support environment with Shell Scripting, Perl Scripting, SQL and PL/SQL
• Expert in the development of stored Procedures, Functions, Packages and Triggers.
• Experience in development of database objects like tables, indexes, Materialized Views, Procedures and synonyms.
• Experience in advanced PL/SQL constructs like Oracle supplied Packages, Nested tables, Varrays, Records, Types, Dynamic SQL.
• Experience in writing Explicit Cursors and Handling Exceptions while developing the applications.
• Extensively involved in developing programs to import data from legacy system into oracle database using SQL*Loader.
• Experience in Query Optimization, Debugging, Tuning and improvising performance of the database, using the Oracle tools like Oracle Hints and Explain Plan etc.
• Strong PL/SQL programming skills and expertise with SQL tuning, performance tuning and Bulk binding techniques.
• Written Interface programs for importing data from feeder systems to Oracle using SQL*Loader, PL/SQL, UTL FILE packages and API's.
• Proficient in using Informatica ETL, Fact Tables, Dimension Tables, Star Schema Modeling, Erwin 4/3.x.
• Extensive experience in full life cycle of software development process including requirement gathering, design, coding, testing, debugging and maintenance.
• Expertise in Implementations, Customizations, Enhancements, Enterprise Application Integration, Upgrades, Oracle RDBMS and UNIX environments
• Having experience in developing custom applications using Oracle Application Express (APEX).
• Demonstrated professionalism as a team leader and team member, while continually striving to meet project needs with user requirements
• Worked on various process definition, standardization and process improvement initiatives that involved defining coding standards, change request management, configuration management, release management
• Lead manage offshore teams
• Used Version Controlling tools such as Visual Source Safe (VSS) and Clear Case.
• Highly intuitive, goal - oriented, analytical and go-getter with a positive attitude; Always looks for process improvement opportunities and opportunities to add value
• Accomplished technical consultant in Oracle platform used in developing and customizing Oracle and ETL transformation and migration projects.
• An organized, hard working, and highly motivated professional, with strong communication and interpersonal skills, and the ability to perform individually or as a dedicated team member

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS-Access, Sybase, Knowledge on Teradata

GUI: VBA with Excel and Access, Informatica 6.x,7.x,8.x

Oracle Tools: SQL* LOADER, PL/SQL developer, TOAD, SQL*PLUS

Documentation: MS Office

Utilities: SSH Tectia Terminal, Winscp, Putty

Languages: SQL, PL/SQL, Unix, Shell Scripting and PERL

Operating Sys: UNIX, Linux, Windows

Job Scheduler: Autosys, Tivoli

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coordinate Change requests.
• Day-to-day troubleshooting, maintenance and operational support for Oracle application, database and interfaces.
• Developed Stored Procedures for various validations while inserting data into the tables and developed PL/SQL Packages for incorporating the business rules.
• Involved in logical Data Modeling and physical Design of database
• Gathered and documented business requirements. Created the initial conceptual design and entity relationship diagrams and created the database objects.
• Worked on various backend Procedures, Functions and Cursors.
• Wrote PL/SQL procedures to validate database records.
• Involved in preparing test cases & unit testing.
• Extensively used UTL FILE to read and write files that are located on the server.
• Support the distribution of data and structure changes to multiple copies of the database with minimal production interruption
• Automation of tasks using shell scripting, Perl Scripting, SQL and PL/SQL.
• Used various Index algorithms like B-tree, Bitmap, Hints, BULK COLLECT and tuned sql queries to enhance the database performance.
• Designed and Developed AML tracking application using Oracle Application Express (APEX).
• Maintain the data integrity of the NCS
• Provide assistance to business and BT partners in the analysis and design stage of projects.
• Account to Business Partners by including Business approvers on all changes

Environment: s: Oracle, UNIX, Shell Scripting, Perl Scripting, VBA, Oracle Application Express (Oracle APEX), SQL and PL/SQL

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Interact with On Site and Clients and Gather Functional Requirements
• Convert Functional Requirements into Technical Specifications
• Generating Various Reports on Requirements.
• Developing the code
• Adhere to SLA for all applications.
• Peer Review of code before turning over to production.
• Involved in logical Data Modeling and physical Design of database
• Managing Monthly release for all applications development, bug fixes.
• Participate in Disaster Recovery tests.
• Integration of Informatica with Teradata.
• Automation of tasks using shell scripting, Perl Scripting, SQL and PL/SQL.
• Tuned SQL queries to enhance the database performance
• Training new team members.
• Involved in SQL Activities.

Environment: s: UNIX, Shell Scripting, Perl Scripting, SQL, PL/SQL and Informatica 8.6

Confidential, New York

Software Engineer

Responsibilities:

• Convert Functional Requirements into Technical specifications
• Generating Various Reports on Requirements.
• Adhere to SLA for all applications.
• Peer Review of code before turning over to production.
• Helping team members in doing R&D. (like reading PDF files on UNIX, resolving space issues etc)
• Integration of Informatica with Teradata.
• Managing Monthly release for all applications development, bug fixes.
• Participate in Disaster Recovery tests.
• Training new team members.
• Project Management activities, reporting overall monthly deliveries for all Change the Bank and Run the Bank Issues (enhancements and defect fixing), and Production issues.
• Involved in SQL Activities.

Environment: s: Informatica 7.1, Shell Scripting, Oracle SQL, PL/SQL, Sybase Toad and Autosys Job Scheduler.

Confidential

Consultant

Responsibilities:

• Monitoring and supporting the overnight EOD/BOD cycle of Global Plus Application.
• Resolving any issues that may arise during this period.
• Training new-comers in this process and making them independent in supporting EOD/BOD process.
• Delegating tasks to team members. Following up till the completion of the tasks.
• Understanding and debugging legacy Perl/Shell scripts.
• Developing new scripts to enhance the support of EOD/BOD process.
• Documentation of all issues and procedures adopted for their resolution.

Environment: s: Global Plus App, Vision Programming, UNIX and Shell Scripting

Confidential

Software Developer

Responsibilities:

• Create the Source to Target Mapping, which also lists the transformation rules.
• Involved in Developing Logics for the Transformations used in mapping design.
• Development of Technical Design documents and Test cases for the Jobs developed.
• Also involved in SIT and UAT interacting with end users
• Developed Mappings According to the Conceptual Design Provided From Onsite Team
• Understanding the Requirements from RDR (Requirements Definition Report)

Environment: s: Informatica,UNIX,Shell Scripting,Oracle 9i

Confidential

Web Developer

Responsibilities:

• Gathering requirments from the users
• Designing webpages for the sites using HTML.
• Writing validation scripts for frontside and server side
• Server side coding using ASP, Javascript and VB Script.

Environment: s: MSAccess as Back End, ASP 2.0 with VBScript as server side scripting, JavaScript as client side scripting, HTML as Document Language