EXECUTIVE SUMMARY:

• I am an Oracle Apps Techno Functional consultant at Tata consultancy services(TCS) with Master’s in Computer Science from Anna university Chennai India with 7.3 CGPA. I have around 8 years of professional software development experience in various roles spanning across most phases of software development.
• Strong Techno - Functional experience in Order to Cash(OTC) Process and Process to Pay(P2P) process
• Technical experience in following Oracle Modules - Order Management (OM), Inventory(INV), Purchase Ordering(PO), Warehouse management system(WMS), Oracle Field Services(OFS), Oracle Time & Labor (OTL), Oracle spares management (CSP), Oracle contracts core (OKC), Oracle projects (PA), Oracle pricing (QP), Human Resource Management System (HRMS)
• Worked with multiple interfacing systems such for Online Order Entry, EDI, Supplier Collaboration and multiple 3rd party logistics systems where responsibilities included functional design, data design and creating mapping specifications.
• Strong experience in translating business requirements into creation of Database Objects.
• Strong Experience in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Exposure in Oracle Application RICEW (Reports, Interfaces, Conversions, Extensions, Work flow) and API's development using the Development Suite/tools (like Oracle Forms, Oracle Reports, Oracle Applications Jdeveloper(OAF), PL/SQL, Work Flow Builder2.6, OBI/XML Publisher and SQL*Loader ).
• Extensive experience is Change Management, Incident Management, Risk management and Problem Management.
• Level one/two Production support experience for 3 Years dealing with APAC, EMEA and US based clients.
• Handled team of 9 people from different vendors and met project deadlines according to Client needs.
• Prepared BRD (Business Requirement Document Specifications) document that gives the detailed information about the requirements.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Experience in working Agile Rally tool.

TECHNICAL SKILLS:

ERP Applications: Oracle 12c Enterprise Edition Release 12.1.0.2, Release 12.1.0.1, Oracle database 11g Release 11.2.0.4

Modules: Order Management (OM), Inventory(INV), Purchase Ordering(PO), Warehouse management system(WMS), Oracle Field Services(OFS), Oracle Time & Labor (OTL), Oracle spares management (CSP), Oracle contracts core (OKC), Oracle projects (PA), Oracle pricing (QP)

Languages: SQL, PL/SQL, Unix shell Scripting, Java (Specific to Oracle framework), XML

GUI/Tools: Jdeveloper 10g/9i, Forms 10g/6i, SQL*Plus, SQL Developer

Databases: Oracle 12c/11g/10g, Greenplum, MySQL, MS Access

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Tableau 10.2

Utilities: Putty, WinSCP, IBM ClearCase, HP kintana, Teleologic DOORs (Document version control), BOX (Cloud content management)

Production Support Tools: BMC Incident Management, Service Now

WORK EXPERIENCE:

Confidential, Schenectady, NY

Oracle Apps Techno Functional Consultant

Platform: Oracle R12 Global Parts, Projects and Services

Environment : Oracle Applications 12.1.0.2 (OFS, OTL, OM, PO, INV, CSP, OKC, PA, QP), SQL, PL/SQL, Tableau 10.2, Green plum Database

Responsibilities:

• Techno Functional consultant in analyses and defining the requirements for Oracle Global Parts, Projects & Services reports in Tableau, migrated the report from Oracle 11i Apps and COGNOS reporting tool.
• Prepared Requirement documentation with Functional and Technical specifications for Interfaces and reports.
• Delivered more than 15 new reports, 50 (Minor/Major) enhancements with additional metrics which reduces business effort by 30%
• Optimized SQL queries and report’s UDF in Tableau for performance improvement
• Coordinated offshore team on development, support and maintenance activity of new reports and existing reports.
• Developed KPI ( Key performance Indicator ) for Oracle field Service request module with metrics based on Estimation vs Actual (Debriefed hours)
• Developed new reports on following oracle modules - Oracle Service contracts, Oracle Projects, Oracle filed service, Oracle Time & Labor, Oracle order management, Oracle Purchasing.
• Good Knowledge on Tableau reporting tool, Green plum Database.
• Converted reports from Oracle 11i and COGNOS reporting tool to Tableau.

Confidential, Schenectady, NY

Oracle Apps Techno Functional Consultant

Platform : Oracle Order to Cash Process

Environment : Oracle Applications 12.1.0.2 (PO, RFQ) , PL/SQL, SQL, Reports, UNIX, XML Publisher

Responsibilities:

• Techno Functional consultant in analyses and defining the requirements for two-way data integration between ERP and Enova PLM to Integrate PO and RFQ
• Prepared the Customer requirement document on behalf of business defining the scope and integration interval.
• Prepared Requirement documents with Functional and Technical specifications of Interfaces and reports.
• Prepared the unit test case and user acceptance test case documents .
• Coordinated different teams ( ERP, PLM and Informatica ) in development, testing and implementation process
• Developed Form personalization in Purchase order module to show the latest item revision automatically once Item is entered.
• Worked in XML Publisher for customized reports to show the success rate of purchase order and Request for quotes integration.
• Optimized PLSQL packages for performance improvement

Confidential, Schaumburg, IL

Oracle Apps Techno Functional Consultant

Platform : Oracle Order to Cash and Procure to Pay Process

Environment : Oracle Applications 12.1.0.2(WMS, OM, PO, INV), PL/SQL, SQL, Forms, Reports, XML Publisher, Clear case, Kintana, UNIX .

Responsibilities:

• Oracle apps Techno Functional consultant in analyses and defining the requirements for identify scopes for public and private business in Oracle Order to Cash and Procure to Pay process.
• Prepared Requirement documents with Functional and Technical specifications of Interfaces and reports.
• Prepared the unit test case and user acceptance test case documents.
• Organized and conducted trainings in Change management enabling SOX compliance .
• Developed reports for both Public and private business using Oracle Reports and XML publisher .
• Prepared Oracle application configuration document to guide Sys Admin team
• Migrated PL/SQL packages, Oracle reports with help of HP Kintana tool and ClearCase (documents version control)
• Coordinated with offshore team on development, testing and implementation.

Confidential

Oracle Apps Techno Functional Consultant

Platform : Oracle Order to Cash and Procure to Pay Process

Environment : Oracle Applications 12.1.0.1 , Oracle Applications 11.2.0.4, Oracle 10g, PL/SQL, SQL, Forms, Reports, XML publisher, Clear case, Kintana, UNIX .

Responsibilities:

• As a Technical resource on a development projects for reports, Integrations and workflows components for Oracle R12 project specializing in Order management, Returns, Purchasing, Inventory, Receivables, XML and BI publisher reporting .
• Developed numerous business audit reports in Order Management and Purchasing modules on lead times which reduces order processing time and tracking inventory across the system
• Prepared requirement documents with technical specifications
• Customized Oracle Sales order workflow which helps to calculate the sales person agent commission before Sales order booking.
• Developed customer facing documents such as Order acknowledgements, Shipping Documents, Commercial and Customer invoices using Oracle Reports and XML publisher .
• Prepared Oracle application configuration document to guide Sys Admin team
• Migrated PL/SQL packages, Oracle reports with help of HP Kintana tool and ClearCase (documents version control)
• Coordinated with onsite team on development, testing and implementation.
• Delivered more than 100 minor enhancements in both Oracle R12 and Oracle 11i applications which reduced manual business effort.
• Good understanding of database objects and ability to triage issues
• Created Materialized views to improve the report performance by 90%.