Prasanna_resume

PRASANNA SUNKAM

Cleveland, Ohio

Ph #:216-***-**** ♦E mail:********.******@*****.***♦

EXECUTIVE PROFILE:

Accomplished, motivated, problem solver, deeply driven, analytical thinker with 4 ½ years of IT consulting experience in implementing, customizing , testing and debugging Oracle Applications /Oracle e-Business suite. Worked on ongoing and overlapping deadlines in fast-paced environments, handle multiple assignments simultaneously and coordinated deliverables with key stakeholders in cross-functional groups and holds a BS degree in Computer Science.

TECHNICAL SNAPSHOT:

►Oracle Languages SQL (4+ yrs), PL/SQL (4+yrs), Java (< ½ yrs)

►Oracle Database Oracle Database 10g (4+yrs)

►Oracle Tools Reports 6i/10g (2+ yrs), Discoverer 4i/10g(3 yrs),TOAD (4 yrs),

XML Publisher (2 yrs), SQL * Loader (3+ yrs), Public APIs & other Seeded functions (4 yrs), Workflow builder 2.6 (1 ½ + yrs), Forms 6i (1+ yrs)

►Others CVS, Kintana/ITG Mercury, WinScp-ftp tool, UNIX, MS

Office suite

ORACLE APPLICATIONS 11i MODULE EXPERTISE:

HRMS SUPPLYCHAIN OTHERS

Core HR (4+ yrs) purchasing (2+ yrs) Account payables (1 yr)

Payroll (3 yrs) Inventory (2+ Yrs) Account Receivables (1 yr)

Advanced Order Management (2+ yrs) TCA (1+ yr)

Benefits (2 ½ yrs) Shipping (2+ yr) AOL (4 yrs)

i-recruitement (<1 yr) Pricing (< 1 yr) Quotes (1 yr)

Self service HR (<1 yr)

HIGH LEVEL PROFESSIONAL SUMMARY:

• Expertise in design, development and testing of Reports, Interfaces, Conversions, discoverer workbooks, XML publisher reports, Forms and workflows.

• Proficient in using SQL Plus, TOAD, Pl/sql developer, Reports 6i/10g, discoverer 4i/10g, workflow builder 2.6, Forms 6i, XML Publisher for both development and customizations as per client specifications.

• Developed various stored Procedures, Packages, Functions other database objects (custom tables, views and index) and used Oracle APIs.

• Good working knowledge of performance tuning and ETL methodology.

• Strong familiarity with AIM standards and authored Technical documentation (MD70).

• Extensively used Oracle metalink /my oracle support and worked with TAR (SR).

WORK HISTORY:

---------------------------------------------------------------------------------------------------------------------

May’07-Jun’09 Louisiana State University, Shreveport, Louisiana

Role: Oracle Apps Consultant

Worked with implementation team and implemented Oracle HRMS suite of applications for LSU health centre. Major work includes constant interaction with functional resources, interaction with end users, design and development of new objects using sql, pl/sql, reports, forms, discoverer and XML publisher, providing status updates to Project lead, data mapping from legacy systems to Oracle e-Business suite application, authoring technical (MD70) and unit test documentation. Specific Projects include >>>

• Implemented data migration of HR/PER locations.

• Implemented data conversion of HR/PER person address.

• Implemented HR/PER job migration.

• Implemented data conversion for HR employees.

• Implemented 401K Loan element inbound interface

• Implemented Payroll city tax wage outbound interface

For all the above programs, I designed, developed and tested sql scripts, pl/sql scripts, SQL * loader control files, concurrent programs, request sets, modified menus and used Oracle APIs, FND APIs and in code.

• Customized workflow process to sent notifications using HR hierarchy to appropriate supervisors to 3rd level with time out.

• Researched metalink( my Oracle support) for Oracle errors and identified required patches and solutions.

• Customized discoverer workbooks by creating items, conditions, parameters and developed new discoverer work books to serve business needs.

• Developed custom folders for discoverer.

• Participated in evaluation of Oracle i-recruitement module with functional person.

• Responsible for Unit Testing and Technical Design Documentation (MD70).

• Generated Trace files when required.

►Customized reports using oracle reports builder and XML publisher. Some of the reports include:

Pack slip report for a specific customer. (WSH)

Purchase detail report (PO)

On-hand quantities report (INV)

Advanced Benefits extract audit report (BEN).

Monthly employee benefits deduction report (BEN).

Environment: Oracle Applications11i (11.5.10), Oracle database 10g, Core Human Resource (HR/PER), Payroll(PAY), Benefits(BEN), i-recruitement, Inventory(MTL) Shipping (WSH), Purchasing (PO), CVS, Mercury tool, SQL, PL/SQL, SQL * plus, TOAD, Reports 6i , BI publisher , Discoverer desk top & administrator 10g, Forms 6i, Workflow2.6 and UNIX.

-------------------------------------------------------------------------------------------------------------------

Feb’06- May‘07 AT & T, Alpharetta, Georgia

Role: Oracle Apps Consultant

--------------------------------------------------------------------------------------------------------------------

I participated in on going support and some new customizations. Major work includes constant interaction with functional resources, interaction with end users, design and development of new objects using sql, pl/sql, reports, forms, discoverer and XML publisher, providing status updates to Project lead, data mapping from legacy systems to Oracle e-Business suite application, authoring technical (MD70) and unit test documentation. Specific Projects include >>

• Customized CTO change order (OM) workflow.

• Custom developed Associate information listing report (HR/PER/PAY) using report builder.

• Developed service contracts purge program that executes after service contracts conversion program being run. RA interface tables are used in this code.

• Identified pricing update program from available programs in CVS. There was no documentation available on this process, but users reported that in past someone from IT helped to get this job done. Identified right programs and executed the process right before last minute.

• Implemented Sales Order update inbound interface.

• Implemented HR/PER person address inbound interface .

• Implemented safety stock creation programs.

• Implemented Item conversion

For all the above programs, I designed, developed and tested sql scripts, pl/sql scripts, SQL * loader control files, concurrent programs, request sets, used Oracle APIs, FND APIs and open interfaces in code.

• Modified Form (HR/PER) using forms personalization feature

• Customized Form using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.

►Developed XML (BI) Publisher reports from Oracle .rdf files. Some of the reports includes:

Sales order acknowledge report (OM and WSH)

AR invoice report. (AR)

Back order detail report (OM, INV and WSH)

• Provided weekly status updates to Team Lead on all the issues.

• Responsible for Unit Testing and Technical Design Documentation (MD70).

• Worked closely with support team to resolve Kintana helpdesk tickets. Work includes adding new code, performance issues, modifying existing code and AOL objects.

Environment: Oracle Applications11i (11.5.10), Oracle database 10g, Core Human Resource(HR/PER),Payroll(PAY),Benefits(BEN),Pricing(QP),Inventory(INV),Order Management(OM),Shipping(WSH),Accounts receivables(AR), CVS, SQL, PL/SQL, SQL * plus, TOAD, Reports 6i , XML publisher, Kintana/ITG Mercury, WinScp-ftp tool, Discoverer desktop & administrator 4i, Forms 6i, Workflow2.6 and UNIX.

______________________________________________________________________________

De’04 – Feb’06 Bankers systems, St. Cloud, Minnesota

Role: Oracle Apps Consultant

I participated in on going support and some new customizations. Major work includes constant interaction with functional resources, interaction with end users, design and development of new objects using sql, pl/sql, reports, forms, discoverer and XML publisher, providing status updates to Project lead, data mapping from legacy systems to Oracle e-Business suite application, authoring technical (MD70) and unit test documentation. Specific projects include >>>

• Developed custom ad-hoc report to give Quotes information.

• Developed pl/sql programs for data extraction of sales orders, customer invoice and customer data using utl_file.

• Developed custom discoverer workbook that gives sales person information for quotes from sales module.

• Developed Vendor data extract programs using utl_file utility.

• Customized HR PAYROLL costing report.

• Researched metalink for Oracle errors and identified required patches and solutions.

• Used Oracle public APIs, private APIs, FND APIS, workflow APIs and open interfaces.

• Generated explain plan / execution plan for a given SQL to plan_table.

• Re-wrote SQL addressing performance issues.

• Interacted with end users when required.

• Created concurrent programs set ups, request sets, modified report groups, responsibilities, value sets etc as and when required.

• Provided weekly status updates to Team Lead on all the issues.

• Responsible for Unit Testing and Technical Design Documentation (MD70).

Environment: Oracle Applications11i (11.5.10), Oracle database 10g, Human Resource(HR/PER),Payroll(PAY),Benefits(BEN),Quotes(ASO),Order Management(OM),Purchasing(PO),Account Payables(AP), CVS, SQL, PL/SQL, SQL * plus, TOAD, Reports 6i , XML publisher , Discoverer desktop & administrator 4i, Forms 6i, Workflow2.6 and UNIX.

EDUCATION

BS (4 yrs) degree in Computer Science, Arkay College of Engineering, India.

Contact this candidate