PROFESSIONAL EXPERIENCE

• 8+ years of experience in gathering Business Requirements, analysis, design, development, Upgrading, testing, report generation and production support projects in Oracle Applications.
• Experience in providing technical Support (Analysis, Design, Development, and Testing) and team leadership (planning, collaboration) in the projects involved.
• Experience in developing projects for Financial, Insurance and Manufacturing Organizations.
• Strong Experience in AP, AR, GL, SCM, OM, HRMS, PA, INV, WIP modules of Oracle Applications.
• Hands on experience in O2C and P2P modules of oracle apps.
• Worked on Oracle 11i and R12 applications in the area of SCM modules of Oracle R11 / R12 E - Business suite such as Inventory, Purchase Order, Bill of Materials, and Order Management, AP,AR, GL, PA
• Worked on Upgrading, Implementing projects using different Oracle tools like OBIEE 10.1.3.2, BI Publisher, XML Publisher, Discoverer, Oracle Report Builder 6i/10G (Reporting Tools), Oracle Forms Builder 6i/10G, Source One/ Harvest(Version Control tools), Data Archiving and Purging Using ( Applimation Tool), VSS(Visual Source One)
• Hands on Experience with SQL, PL/SQL, and Advanced PL/SQL like Bulk collect, stored procedures, Functions.
• Experience in work flows in support projects.
• Hands on experience in Oracle Application Framework.
• Worked on RICE components
• Experience in Effectively handling performance issues
• Effective use of Metalinks for applying new patches, documents
• Worked on NLS(Language translators) for reports to be displayed in different languages
• Upgrading the code and tools to new version and migrating accordingly
• Work with the client side Functional Consultant on requirement understanding and prepare detail Technical design Documents
• Coordinate with Functional consultant while developing, testing, migrating
• Coordinate the offshore team as counterpart to onsite team
• Demonstrate client the easy usage of reports and application
• Analyze and understand the client business processes and functional design document and implement them technically in Oracle Financials and SCM modules.
• Prepare documents like MD70,MD65, MD120, CV40,CV60,CR Document, OLA(Operations level agreement),Score Cards
• Creating concurrent programs, executables, request groups and assigning to Responsibilities
• Experience in lookups, flexfields(DFF, KFF),enabling profile options, running the reports
• Experience in handling triggers in form level and also backend level
• Hands on experience in Oracle Alerts and PL/SQL alerts
• Experience in Bouncing the servers and applications
• Prepare Unit test cases and execution of test cases before migrating to production and documenting the test cases.
• Analyze the repeated issues and prepare the Workaround and permanent Fix
• Analyzing the business requirements with the user community and developing XML reports from conceptual stage to implementation, Interfaces
• Experience in Unix commands to prepare the tar files, migrations etc.
• Experience in different Java IDEs like Eclipse, JDeveloper.
• Knowledge of monitoring and running job in Informatica tool and scheduling jobs in Control-M which call the underlying Informatica jobs or unix scripts which in turn call Java components.
• Experience in using PVCS, SVN, CVS and Oracle Repository for version control.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Advanced PL/SQL, Core Java.

Oracle Technologies: XML publisher, BI publisher, Discoverer, OBIEE, Oracle Reports and form builder, work flows

Frameworks: Oracle Application Frame Work.

Application Servers: Oracle Applications 11i and R12

Databases: Oracle 8i/9i, MS-SQL Server, My SQL, DB2, Sybase, and MS Access.

IDE/Tools: JDeveloper, Eclipse, Toad, SQL developer, Winscp

Version Control Tools: VSS, Oracle Repository and CVS, Harvest.

Operating Systems: Windows NT, 98, 2000/XP/Vista and UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, OHIO

Technical lead

Responsibilities:

• Involved in requirement gathering, effort estimation, preparing technical design document, Development, unit testing, preparing the migration document and migrating the components.
• Involved in performance tuning of Oracle tables & stored procedures
• Designed and developed RICE components.
• Designed and developed reports using XML, BI publisher and OBIEE
• Involved in O2C(Order to cash) and P2P(Procure to Pay) full life cycle modules
• Developed components for PA, AP,AP,GL modules
• Developed Oracle Alerts, Workflows
• Handled components of Oracle Application Frame work personalization like VO,CO,AM, EO extensions, Page extensions
• Migrating the OAF extended objects from one instance to other instance
• Unit testing of the component developed
• Migrations of the components from once instance to another instance
• Scheduling the reports
• Enabling profile options and diagnostics.
• Fully supported Application Management team in addressing post Go-Live issues for the releases.
• Project is developed in agile methodology. New requirements are implemented based on the regular meeting with all groups.
• Mentored development team with architecture, design, coding guidelines, and testing standards.

Environment: Oracle 10g, Oracle Apps(R12), Winscp, Unix, Putty, Toad, WorkFlow builder, JDeveloper

Confidential

Technical Consultant

Responsibilities:

• Preparing TD documents, Developing the components
• Had KT from HP at Manila, Philippines
• Worked on Advance PL/SQL, Performance tuning, table space concepts
• Worked on bulk collect, stored procedures, functions
• Worked on RICE components
• Working on Webosa tools and OBIEE reporting tools
• Analyze, Understand and provide resolution for P1,P2 incidents
• Participation in OLA docs, QD score cards
• Guiding the team technically
• Working on HP service manager for incident management, FR, PR CR etc.
• Coordinating with clients through calls, mail communication
• Communicating client about the status of incidents
• Providing proactive solutions for recurring issues
• Work with the client team during enhancements requirements gathering
• Review of CR documents, SLA documents
• Performance tuning and DBA activities like handling table space issue
• Work on version control tool Harvest

Environment: Webosa, Trackers, sql/plsql Developer, Toad, SQL Plus, Dimensions, facts, Unix server, Winscp, Harvest tool, Control M

Confidential

Technical Consultant

Responsibilities:

• Upgrading the Financial modules AP,AR,GL,OM
• Worked on Oracle application system Administration by creating Users, assigning responsibilities to User, creating request groups, Profiles, Scheduling on Monthly and daily reports
• Migrating the Components after migrations
• Has worked in Advance PL/SQL for Bulk collect and performance tuning.
• Has worked on migration of components like responsibilities, request groups, forms, reports, SRS from once instance to another using SQL LDR queries
• Has worked on Oracle Reports Builder 6i, Oracle Forms Customization 6i
• Has worked on Discover reports implementation and migration to PROD
• Has worked on Interfaces like AP open invoices interface, GL set of books reports, FSG in Oracle application
• Preparing MD65, MD120, test case documents
• Has worked on Oracle workflow builder for support issues
• Identify business process impact on R 12 Upgrade
• Conduct calls with client Functional resources and discussing the technical possibilities
• Client interfacing and Co-ordination
• Unit Testing, System Integration Testing, Application testing
• Maintaining Version control tools source one

Environment: Oracle EBS R 12, Oracle EBS 11i, Interfaces, Conversions, BI Reports, Discoverer Reports, Forms, reports 6i, Work flow builder, XML Publisher reports

Confidential, Chicago

Technical Consultant

Responsibilities:

• Developing components of financials R12 modules
• Developed Interfaces, Reports in XML pub, BI pub and OBIEE tools
• Worked on FSG report generations for financial reports.
• Worked on migration of FSG using data links
• Worked on creation of new Attributes in DFF, Value sets, look ups etc.
• Has little experience on the concept of SLA(Sub ledger accounting) and FAH
• Worked on the reports using FSG, OBIEE, BI publisher reports
• Worked with third party functional consultants
• Client interfacing and Co-ordination
• Preparing Technical design MD70, migration, test case documents
• Project Monitoring and Control, offshore co-ordination, status reporting.
• Worked with Share point version control
• Worked on creating TAR files for migration purpose.
• Created .SH files for migration
• Hands on experience in SQL LDR scripts for migration of components from once instance to another instance
• Back end submission of reports using pl/sql queries

Environment: Oracle EBS R 12, Interfaces, Conversions, BI Reports, Discoverer Reports, OBIEE, FSG, XML Publisher reports.

Confidential, California

Technical Consultant

Responsibilities:

• Developed Interfaces, Conversions in R12 module
• Developed Pl/SQL interfaces like Inventory status, Item categories
• Involved in XML Publisher reports implementation, Migration of XML publisher reports etc.
• Involved in migration of reports from UAT to PROD using SQL LDR scripts
• Prepared technical design documents
• Client interfacing and Co-ordination
• Prepared unit tests

Environment: Oracle Apps R12, XML template builder, PL/SQL Developer

Confidential

Technical Consultant

Responsibilities:

• Upgrading the RICE components to R12 from 11i
• Testing the up gradation after migration to R12
• Creating value sets like pair, table, none etc.
• Implementation of new Interfaces in R12
• Onsite and Offshore team coordination
• Modifying the Work Flow’s according to new requirement
• Creating new responsibilities, request groups, users
• PL/SQL Scripts to submit reports from back end
• Functional Consultant interfacing and issue resolution
• Training and Knowledge management

Environment: Oracle EBS R 12, Oracle EBS 11i, oracle 9i and 10g

Confidential

Associate Consultant

Responsibilities:

• Requirement gathering and analysis
• Preparing the data backup plans
• Preparing SQL scripts for backup and deletion
• Implementing the solution
• Using applimation tool for data archiving and purging
• Performance tuning using PL/SQL, Advanced PL/SQL

Environment: Oracle EBS 11i, oracle 9i.

Confidential

Associate Consultant

Responsibilities:

• Technical analysis for development of fresh reports and modification of existing reports
• Using SQL LDR scripts, Reports builder for extracting the XML Files, Forms Builder to get the old version of the forms
• Development and upgrade of interface programs, Reports, Conversions
• Using Oracle Applications R12 for user creations, responsibility creations etc.
• Maintaining of Upgrade Methodology for version upgrade of Oracle Applications
• Modifying the PL/SQL code and testing whether the requirement matches the 6i output
• Modifying the work flow builder to R12 suitable architecture

Environment: Oracle EBS R 12, Oracle EBS 11i, SQL 9i and 10 G

Confidential

Associate Consultant

Responsibilities:

• Developed Interfaces
• Debugged the codes
• Developed the XML publisher reports
• Technical design, Testing
• Unit testing of the developed components.
• Involved in changing Report builder D2k Reports to XML publisher reports.
• Modifying the code and preparation of RTF reports with new layout.
• Involved in changing the reports in different languages
• Involved in Bucket concept in financial module
• Involved in PL/SQL, SQL coding and debugging

Environment: Oracle Applications 11i, Oracle 8 Database.

Confidential

Associate Consultant

Responsibilities:

• Developed reports in XML publisher using the D2k Reports
• Getting XML from Report builder 6i
• Changing the Triggers from Reports 6i with the same in XML publisher reports
• Involved in creation of reports in different languages
• Developed same reports in different languages using NLS functionality for different regions

Environment: Oracle Apps 11i and SQL, PL/SQL, Oracle 8 database, Oracle Report Builder 6i.

Confidential

Associate Consultant

Responsibilities:

• Development of Custom reports.
• Development of XML reports like Grades report, Positions report.
• Development of PL/SQL Alerts and oracle apps alerts
• Conversions/Interfaces
• Involved in development of Core HRMS interfaces
• Configured Approval Management of Customized Workflows.
• Involved in Work Flow builder enhancements
• Deployment of the Customizations.
• Technical design, Testing
• Unit testing of the developed components.

Environment: Oracle Applications 11.5.3, Reports6i, XML publisher Reports, Work flow builder, Template builder, PL/SQL Developer, source one.