Project Manager Pl Sql

Srini Ramanujam

**** ***** **., **********, ** **095. Ph: 732-***-**** ********@*****.***

Team Lead /Analyst /Developer with over 10 years of experience

in Software field. Top performer, proven success on timely

completion of deliverables.

> More than 8 years in Oracle ERP 11i Financials, Manufacturing and

Distribution Modules

> Extensive Experience on PL /SQL, Workflow, Forms and Reports 6i.

> Expert in atriculating design and development concepts in

Technical Specification documents, using Oracle AIM methodology.

> Strong Business Perspective and proven ability to design

technical systems to meet mission critical applications.

> Experienced in remote management, which includes business users

across multiple locations in onsite, offsite, onsite-offshore

model

> Knowledge of Oracle 11g SOA Suite

> For references go to: http://www.linkedin.com/in/sr4oracle

> Visa Status: US Citizen

Skill Sets

> ERP: Oracle E-Business Suite 11i (OTL, AR, AP, GL, PO, INV, OM,

PA), Application Object Library

> Languages: PL/SQL, JavaScript, HTML, XML, Pro*C

> RDBMS: Oracle 8i, 9i, 10g, MS Access

> Tools: Workflow 2.6.2, Forms 6i, Reports 6i, XML Publisher, PL

SQL, TOAD 6.5, PVCS, SQL LOADER, XML, HTML, Discoverer.

Professional Experience

Company Duration Designation

Realogy Inc Nov 2008 - Mar 2009 Consultant/Contra

ctor

Various Companies Oct 2006 - Sep 2008 Consultant

American Institue of Certified Jan 2005 - Aug 2006 Sr. Tech Analyst

Public Accountants

Various Companies Feb 2004 - Nov 2004 Consultant

Igate Global Solutions Oct 1999 - 2003 Oracle Consultant

/Mastech Inc

Polaris Software Lab June 1998 - Oct Consultant

1999

Calisys Systems April 1997 - May Systems Analyst

1998

Educational Qualifications:

> Preparing for 11g SQL Fundamentals and PLSQL Advanced Programming

Oracle Certificaiton

> SOA 11g Essential Concepts at Oracle University (Feb 2010).

> Oracle Application Framework Training (Dec09 - Jan2010)

> Risk Management Course at Columbia University (Jan 2009 - June

2009)

> Attended a 1 day workshop conducted by Oracle on BPA - April 2008

> Attended a 2 day workshop conducted by Oracle on BPEL & Hyperion

- June/Aug 2007

> Certified on Oracle Developer/2000 and PL/SQL through Brainbench,

November 2001

> Certificate Course on Oracle Developer/2000, Bitech, India, 1996

> Bachelor's Degree in Mathematics, Madras University

> Bachelor's Degree in Electronics and Communication Engineering,

Institution of Engineers

Articles Published:

> Published an article on "Adding SQLDeveloper to Linux Start Menu"

at Oracle SQLDeveloper Tips and Tricks. (link to SQLDeveloper

Product Manager Blog: http://sueharper.blogspot.com/2010/04/sql-

developer-exchange-not-just-for.html )

Experience Details

Volunteer Mentor at Upwardly Global (May 2006 - present)

. Assist in Job Descriptions, Professional Assesment, Skills Assessment,

Mock Interviews, Assist in Resume preparations.

Client: Realogy Inc (as a Contractor through Canyon Associates)

Project: (Developer) Oracle E-Business Implementation Maintanence

(Release 11.5.10) (Oct 2008 - Mar 2009)

Environment: 11.5.10. Tools used: TOAD, PL SQL, XML Packages, HTML

Packages.

. Analyzed requirements /feasibility of requirements and developed custom

Receivables Interface, by creating PL SQL packages, to convert as well

as import data from Payables (all paid invoices) into receivables and

generate Receivable Invoices, on a regular basis.

. Customized Top25 Vendor HTML report by using Oracle HTML Packages to

create report. Designed a new report, which replaced an three step

process of using Discoverer to generate the report, and Excel to format

as well as to distribute it based on Business Unit; the new report

combined the formatting and distribution efforts into one-step

automatic process, thereby minimizing maintenance work.

. Modified/customized transferring profile data of a XML Vendor Report;

reduced from a present three step process involving, identifying and

generating XML file of profile data, manual additions to the file to

one which combined all the three into a single step process by using

Oracle PLSQL/XML Packages.

Client: Internal (Fujitsu) (remote work)

Project: (Project Lead) Oracle E-Business Implementation

Upgrade(Release 11.5.10) (Nov 2007 - Sep 2008)

Environment: Implementation of OTL & OIE. Tools used by the Team: Workflow,

JDeveloper, BPEL, TOAD, PL SQL, Reports.

. Analyzed and conducted feasibility study and assisted Project Manager

to develop & maintain Project Plan using MS Projects.

. Provided technical Estimates & prepared Status reports and communicated

with Business, User Community, Senior Management

. Responsible for delivery of the Technical & Business requirements

. Led Development OTL Approval workflow, by Customizng OTL Workflow,

desiging PLSQL Packages, to meet Fujitsu requirements

. Lead Implemention from Technical side, including filing/managing SR's.

. Manage Technical resources in India and/or US.

Client: Capital Blue Cross, Harrisburg, PA. (Apr 07-Jul 07)

Project: (Developer) Oracle E-Business Implementation

Upgrade(Release 11.5.10)

Environment: Project Upgrade to 11.5.10 from 11.0.3, XML Publisher 5.6.3,

Reports 6i, PL SQL

Upgrade from 11.0.3 to 11.5.10. Modified reports mainly in the Payables

. Support Business Analysts, Project Lead

. Reviewed reports and recommended reports for XML Publisher /Reports,

thereby reducing maintenance work.

. Developed reports in XML Publisher, Unit test code & create Technical

delivery documents

. Support Technical Personnel on various maintanence issues, including

raising Metalink SR

Client: Mactec, Atlanta, GA. (Oct 06 - May 07)

Project: (Lead Developer) Oracle E-Business Implementation

(Release 11.5.10) Environment: Oracle Version 9i, PL SQL,

Workflow 2.6.2

. Assisted Project Manager in providing estimates on Project Plan

. Modify iRequisition Approval Workflow to meet client Requirements, by

writing API's, PL SQL Packages, and customizing Workflow

. Customized Seeded PO Requisition Approval Workflow, and creating PLSQL

Packages. The workflow reroutes approvers based on value sets and

notifies a responsibility in case of failure.

. Customized PO Change Order Approval Workflow, so that whenever a

Requisition gets modifed after approval, the Requisition gets routed, in

accordance to the functional specifications.

. Modified Account Generator Workflow

. Provide direction and guidance to the team personnel

. Lead /represented a Team of 2 persons in Implementing Solution

Client: (Internal) American Institue of Certified Public Accountants

(Jan 05 - Aug 06)

Project: (Programmer Analyst) Oracle E-Business Implementation

(Release 11.5.7)

Successfully Analyzed and Implemented various projects across

Customer Relationship Management, Payroll, Financials.

Oracle Ebusiness Implementation (version 11.5.9)

> Analyzed /designed a Report for a Mail-in-Campaign for Student

Dues

> Improved Payroll efficiency by using a Workflow to generate

emails to Employees if a timecard is not Submitted/ Rejected/ Un-

Approved

> Desgined /developed an Audit Trail Program, which will scan

across all modules, dynamically by using PLSQL Packages, for any

changes which are Audited and provide a report on modified

Columns, old value and new value,using Custom Designed Tables and

existing ones.

> Independently developed /Implemented a Workflow based solution to

meet Sarbannes-Oxley requirement of informing Customers, if an

Order cannot be delivered on the Promise date. Created a DFF to

store item availability date, PL SQL Package and Workflow to pick

up data and send emails.

> Developed and Implemented a workflow based solution to enhance

Member application Process. The program will send an email to

prospective members based on the Application status and/or

request /confirm for further information as the case may be.

> Involved in Trouble-shooting and Customer Support, filing

/resolving TARS,evaluating Patches/Fixes.

> Assist in Feasibility study, identify alternative solutions for

gaps and /or enhancement requests.

> Modified a few reports in Discoverer

Client: Merrill Lynch, Jersey City, NJ July 04 - Nov 04

Project: (Developer) Oracle Ebusiness Implementation (version

11.5.9)

(Technical Consultant) Environment: Oracle, Reports 6i, PL SQL,

workflow 2.6.2

> Designed /Developed a functionality to send notifications

whenever a Non-Functional Currency Journal, exceeds pre-defined

Threshold limits; Notifications /email were sent out using

Workflow.

> Designed /Developed Custom Reports for Reconcillation of Data

Conversion using Oracle Reports Builder.

Client: Motorola, Libertyville, IL Feb 04 - July 04

Project: Sr. Techno-functional Consultant (Lead Developer /Team

Lead) Environment: Oracle, Reports 6i, PL SQL, Oracle 11.0.3

Implementation

> Created custom package to segregate Inter-company transactions

from AR Module

> Developed a program to Import data to custom Ledger system so as

to Create Inter-company AP Invoices.

> Modified Domestic Invoice Report to print serial no's for Items

In an order

> Modified Auto accounting Process in AR to fetch Accounts for

customer Transactions according to the Motorola requirements

> Used Kintana to migrate objects developed/modified from one

instance to the other.

> Used Clear case for Configuration Management.

Client: GE Medical Systems, Milwaukee, WI Mar' 03 - Dec' 03

Project: (Techno-Functional Consultant) Environment: Oracle 8i,

PL SQL, Oracle Ebusiness Implementation (version 11.5.7)

> Responsible for Auditing AP, AR Setups

> Interacted with various teams, both on-site and off-site to

resolve Implementation issues.

> Trouble Shoot Invoice Imports resulting from Intercompany

Transfers & resolve issues raised by various users

> Involved in creation of Supplier, Customer and Bank Sites

details.

Client: PGACummins, Minneapolis, MN Apr' 02 - Mar' 03

Project: (Programmer /Analyst) Environment: 10.7 SC, Oracle 8i,

Forms 6i, and Reports 6i, and PL SQL

Oracle ERP Post Implementation Support(version 10.7 SC)

> Designed and Implemented an add-on Order Processing Screen, which

updates an Order with Shipping details and warranty information

as well as generates shipping documents.

> Desgined /developed various adhoc reports.

Client: Fleetguard, Cookeville, TN Jun' 01 - Dec' 01

Project: (Programmer /Analyst) Environment: Oracle 8i, Forms 6i,

and Reports 6i, PL SQL

> Designed & Developed Barcode Information System to provide

scheduling and packing information for proper routing and

efficient transport of manufactured goods from Plant to

warehouses The system allocates warehouse for each shipment,

track order,while feeding OM system. This generates Packing

Slips, provides shipping and Freight Information.

Client: NCS Pearson, Minneapolis, MN Jan' 01 - Apr' 01

Project: (Programmer /Analyst) Environment: Oracle, Forms,

Reports, PL SQL Oracle Ebusiness Implementation (version 11.0)

> Resolve upgrade issues ( upgrade from 10.7 SC to 11.0)

> Customize existing reports, tuning reports, in Project

Accounting, GL, AP and AR

Client: AT&T Wireless, Redmond, WA Oct' 99 - Oct' 00

Project: (Programmer /Analyst) Environment: Sybase 11.0, SQL

> Subject Matter Expert on Conversion Programs

> Evaluate database changes, gather information and new data

requirements, determine impacts to existing data, define data

conversion rules, define data templates and processes, and manage

any data related issues

> Developed a Customer Care resolution system that captures

Resolution(s) given by a Sales Representative for a problem

(reason); whenever a Customer calls and reports a problem

(reason), this is logged and Sales rep will also track the

resolutions offered to the customer

Client: (Internal /External) Polaris Software Lab June 98- Oct'

99

Project: (Project Lead /Project Manager) Environment: Oracle,

Forms, Reports, PL SQL

Oracle ERP Implementation (version 10.7 SC)

> Prepared Project plan, Created WBS, Prioritized tasks, Task

allocation, and Issue resolution for the team members.

> Tracked, monitored and controlled project effects, effort

variation and escalate at appropriate levels.

> Designed & Developed a Customized Solution to Import /Integrate

Order Details using Lotus Notes as Order Capture screen and

import /generate Orders using Order management in Oracle

Applications (Version 10.7 SC)

> Implemented Oracle GL reports in BLINE - a Pro*C based solution.

Client: South India Corporation, Madras, India May 97 - May

98

Project: (Project Lead /System Analyst) Environment: Oracle,

Forms, Reports, PL SQL, and Designer 2000

> Designed, developed and Implemented Transport Management System,

for South India Corporation Pvt. Ltd., using Designer 2000,

forms, reports, PL SQL. The system generates Financial reports,

invoices, memos, track Sales and Purchases, Personnell and

Payroll.

Contact this candidate