Profile

• 13 years of hands on experience in Oracle 10g, 9i, Oracle 8i, SQL, PL/SQL, UNIX shell scripting.
• Worked on Insurance Home/Auto , Consumer goods, Banking and Investment domains.
• Expertise in business process engineering and software development life cycle, including analysis, design, development and implementation of software applications.
• Excellent communication skills and ability to work efficiently in onsite-offshore model with cross-functional teams including application super-users, system end-users, functional analysts, business analysts and technical consultants.
• Excellent written and inter-personal communication skills.
• Extensive experience in client facing roles and working in multicultural, multi-geographic teams.
• Ability to be an effective team player and work under time constraints.
• Prepared Technical Specification documents based on the documents provided by the functional team.
• Used SQL Loader and UTL FILE for uploading flat file data into Staging Tables
• Develop processes for cleansing, transforming, extracting, integrating and loading data.
• Written complex queries to facilitate the supply of data to other teams.
• Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, Sql loader.

Proficiencies:

Project Details

Confidential

Description:

AVON has JDA 7.4.2 application to handle the complex Supply Chain solution for their business. The JDA Fulfillment component caters to the entire AVON manufacturing and warehouse replenishment and is used by Global Users. The JDA Demand component which takes care of the demand forecast for upcoming 84 weeks.

Responsibility:

• Responsible for performance tuning of PL/SQL custom packages, and Report 10g SQL queries
• Extensive package debugging and customizing
• Developed Reports for the user interface a data load using PL/SQL and SQL Loader and daemons, cron jobs calling UNIX scripts to download and manipulate files.
• Tuned many long running Oracle concurrent programs by enabling trace, checking explain and execution plans, with use of tkprof utility
• Coded, tested, debugged, documented, and maintained application programs
• Worked on SQR reporting
• Worked on report generation through Discoverer
• Developed Triggers and Stored procedures for retrieval of data from the database using TOAD tool
• Involved in development and deployment of application on Unix environment
• Conducted system impact testing for all customizations in approval process
• Troubleshooting performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan and TKPROF
• Conduct quality reviews of code developed by other development team members
• Worked extensively on packages, stored procedures, functions, PL/SQL, SQL report enhancement requests
• Used PL/SQL using external tables to load data.
• Experience in creating Triggers, Packages, Procedures, Functions, Cursors and Exception Handlers, Record Groups
• Worked extensively to debug extremely urgent Production system critical incidents and concurrent request failures
• Worked with cross-functional teams including application super-users, system end-users, financial analysts, business analysts, functional analysts etc
• Created Oracle PL/SQL functions, procedures, triggers, packages, records and collections
• Interacted with clients and end-users to do the requirements gathering, carry out analysis and design to meet their business requirement
• Wrote technical design documents for conversions, extensions, interfaces and report

Environment: Oracle 10g, PL/SQL, SQL, SQL Loader, TOAD, tkprof, AIX, PVCS, BMC, Remedy,

Confidential

Description:

PRISM Performance, Reliability, Interoperability and Solution Management is the integrating force that leads the delivery of superior product solutions throughout the product life cycle. The organization is responsible for verifying the quality of the solution enabler and the host ingenuity interfaces. To develop and support a suite of planning, management and tracking tools to assist in the resolution, reporting, management and qualifications process relating to problem fixes, test cases, systems and qualifications within the PRISM organization.

Responsibility:

• Part of Oracle development team
• Interacted with application super-users and senior functional analysts and gathered all the system information and studied the existing business process and legacy system.
• Interacted with clients and end-users to do the requirements gathering and carry out analysis and design to meet their business requirement
• Converted user requirements into functional and technical design documents
• QA and followed Peer code review
• Worked on data mapping for conversion from legacy system.
• Enhanced database programs using PL/SQL using TOAD tool
• Conduct quality reviews of code developed by other development team members
• Created Oracle PL/SQL functions, procedures, triggers, packages, records and collections
• Creating and Registering concurrent executables and concurrent programs
• Involved in requirement analysis, design, data mapping and client interaction
• Performed functional and technical testing for existing modules to understand existing business process
• Creating SQL scripts, Views, PL/SQL database objects
• Responsible for performance tuning of PL/SQL custom packages, SQL queries
• Created Oracle PL/SQL functions, procedures, triggers, packages, records and collections
• Followed peer review process for customization code review
• Created Oracle PL/SQL functions, procedures, triggers, packages, records and collections using TOAD tool.

Environment: Oracle 9i, Sun Solaris, TOAD, CVS,

Confidential

Description:

Eagle Investment Systems, Inc developed two products EAGLE STAR and EAGLE PACE. Eagle STAR is developed as a secure, web-based thin client system, which allows investment managers their clients to manage portfolios, access information, analyze data and record transactions anytime, anywhere. The objective of the project is to automate and centralize accounting balances and checks and increase product efficiency by implementing exception-based handling and reporting. Eagle PACE is an investment data ware house and sophisticated data hub, based upon thin client architecture

Responsibility:

• Part of Oracle development team
• Gather Requirements from the Marketing team for the new product EAGLE STAR
• Involved in the Complete Design and Development of Control center module
• Written Stored procedures for allocating income, expenses, realized and unrealized gains and losses to multi class funds with in EAGLE STAR accounting system, for complex data processing for capital stock investments and Net Asset Value NAV using PL/SQL, SQL
• Involved in the design of tables, indexes views.
• Tuned many long running Oracle concurrent programs by enabling trace, checking explain and execution plans, with use of TKPROF utility
• Developed Interface programs using OCI, Stored Procedures.
• Written PERL scripts to install the product EAGLE STAR at the client locations.
• Written shell scripts for batch jobs and miscellaneous tasks

Environment: Oracle 9i, PL/SQL, SQL, SQL Developer, Sun Solaris, CVS, PERL

Confidential

Description:

Fidelity has licensed the GIM II Global Investment Manager II , CALiPER 2000 products. The CALiPER 2000 is for the calculation and reporting of investment performances for large retail institutions. This is the performance product that utilizes data from external sources to produce rate of return ROR . It is a ROR engine and provides industry standard ROR for use by the site. Currently GIM II is used as the performance measurement product. This implementation requires converting data from GIM II database to CALiPER database and using the CALiPER 2000 for performance measurement of the investments.

Responsibility:

• Understanding the existing system implementation of CALiPER 2000
• Developed stored procedures and database triggers for Daily process, Monthly process, Quarterly, Yearly, since inception of the account using PL/SQL, SQL
• Involved in the testing of the CALiPER 2000 system
• Developed shell scripts csh to upload the data from GIM II to CALiPER 2000

Environment: Oracle 8i, PL/SQL SQL, SQL Loader, Sun Solaris, Visual Source Safe.

Confidential

Description:

This company has designed and developed an E-Commerce application to enable carriers, agencies and cost centers to do the rating, underwriting, billing and accounting. The application has a 3-tier architecture, having web server front end , engine middle tier and oracle database. The domain is Insurance for Auto/Home.

Responsibility:

• Developed stored procedures and database triggers for to generate billing schedules for the clients, who sign up for the insurance for auto/home using PL/SQL, SQL, and TOAD.
• Developed shell scripts for batch jobs.
• Involved in the Production Support.

Confidential

Description:

WMS Yantra is a highly scalable warehouse management system designed for high volume pick, pack, personalize and ship operations.

Responsibility:

• Understanding and analyzing the WMS Yantra product
• Providing Technical support to the Yantra Users and carrying out emergency code fixes.
• Handling of the enhancements, testing and go-live of the new patch codes.
• Developed Stored Procedures, Triggers, Shell scripts using PL/SQL, SQL

Environment: Oracle 8i, PL/SQL, SQL, HPUX, CVS