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 communicationskills.
• 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:

SCM Package:Manugistics 7.2, JDA 7.4.2 Languages/Scripting:SQL, PL/SQL, Shell Scripting, PERLOperating systems:HPUX,AIX, Sun Solaris, Microsoft XPDatabases:Oracle 10g, Oracle 9x, Oralce 8i.General Tools:Toad, Remedy, MS Visio, SQL DeveloperConfiguration Tools:PVCS, CVS, Visual Source SafeJob Scheduling Tools:Autosys

Educational Qualifications Masters in Engineering in Systems and Information ConfidentialBachelor of Engineering in Electronics and Communication Confidential 

Project Details

Project: Project Mc Connell
Duration: Feb 2006 – January 2012.
Client: Confidential, Rye, NY, USA
Description:
Confidential has JDA 7.4.2 application to handle the complex Supply Chain solution for their business. The JDA Fulfillment component caters to the entire CONFIDENTIAL 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, Autosys

Project : PRISM
Duration : Mar 2004 – Jan 2006
Client : Confidential, Hopkinton, MA, USA
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,

Project : EAGLE - STAR
Duration: Feb 2001- Feb 2004
Client : Confidential, Newton, MA, USA
Description:
Confidential 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 

Project : GIM II (Global Investment Manager II), CALiPER 2000
Duration : Feb 2000- Jan 2001
Client : Confidential, Boston, MA, USA
Description:Confidential 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 accountusing 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.

Project : E-Commerce Application
Client : Confidential, Beverly, MA, USA
Duration: Jul 1999 – Jan 2000
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.

Environment: Oracle 8i PL/SQL, SQL, TOAD, PVCS, Sun Solaris

Project : WMS Yantra 
Duration : Feb 1999 – Jun 1999.
Client : Confidential, Acton, MA, USA
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