Employment Summary

• experience in the Software Industry
• Extensive experience in Oracle Financials, HRMS, CRM as a techno functional consultant.
• Worked independently, in a team environment and also as module lead.

Key Skills

• Good experience in using Application Implementation Methodology AIM and drafted MD70, MD120 documents.
• Extensive experience in Oracle E-Business suite as techno functional consultant which includes strong experience in Oracle Financials PTP module , CRM Install Base and Service Agreements modules , HRMS modules Self-service, iRecruitment, Appraisal and exposure to Core HR, Oracle Time and Labor OTL , Payroll functionalities.
• Robust Technical skills in JAVA, PL/SQL, SQL, OA Framework.
• Proficient Experience in iProcurement, iRecuritment, AOL and System Administration.
• Worked on both Waterfall Model and Agile Model.
• Experience in OA Framework Technology OAF and MVC Model-View-Controller Architecture
• Expertise in design, development and support of OAF, Reports, Interfaces, extensions, APIs and workflows in the Financials, HRMS modules in the Oracle Applications R12.
• Expertise with Unix Shell Scripting, Tuning using TKPROF/Trace and Explain Plan
• Extensive experience in Oracle Back-end server-side core and advanced PL/SQL Development i.e. Stored Procedures, Packages, Materialized Views, Synonyms, Sequences, Functions Triggers using PL/SQL Developer, Toad and SQL Navigator as development tools
• Also have experience working on System Administration activities like user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs and FNDLOAD.
• Good experience in developing XML Publisher reports and debugging Interface issues.
• Excellent client interaction skills, written and verbal communication skills.
• Good experience in analyzing business process, converting functional requirements into technical solutions, solution development and testing.
• Interaction with clients to ascertain the requirements and carryout Analysis Design to meet the business requirements.
• Proficient working in 24/7 Production Support and also handling Change Requests
• Robust experience in designing, developing and customizing Oracle Applications Framework pages. Worked on application's development using Oracle Database and Developer Suite
• Good understanding of all phases of SDLC by working extensively in each phase.
• Proficiency at grasping new technical concepts and utilizing the same in a productive manner and a Team player with excellent analytical and project co-ordination skills
• Good interpersonal skills, committed, Result oriented, Innovative, Hardworking with quest and zeal to learn new technologies. Experience in managing Cross-functional teams and global teams

Confidential

Senior Consultant at Deloitte Consulting

Project Objective

Gilead is a pharmaceutical drug manufacturing company with around 7.5 Billion USD annual revenue. The objective of this project was to replace legacy JDE ERP with Oracle EBS, and to support the application after go-live. Deloitte has completed the implementation in Oct-11 and has started supporting the application. All modules of RTR, PTP, OTC and PTM tracks were implemented.

Role

On-site technical and functional in-charge of PTP track comprising Brainware, Agile, iProcurement Single point of contact

Responsibilities

• Setup and manage the team to monitor critical scheduled EBS concurrent programs
• Co-coordinating on site and off shore teams and taking bottom line responsibility in troubleshooting P1, P2 issues resolution 24/7 .
• Perform high level assessment of the change in terms of technical functional alignment with architecture, level of complexity and rough order magnitude of efforts
• Report critical project metrics to client and Deloitte management
• Co-ordinate with Oracle/Brainware/Agile Support for any standard product issues and document and work closely to get the issues resolved in stipulated time
• Expertise in debugging issues with XML Publisher Reports and Interfaces.
• Ensure smooth completion of Month end Closure. Ensure deliverables are being delivered within stipulated time frame
• Prepare functional specifications document for the technical activities and get it approved by the client. Prepare documentation, provide production support, and educate the users by conducting trainings.
• Design, configure/develop, test deploy the changes/enhancements.
• Build knowledge repository - ensure that knowledge is validated and updated from time to time when incidents are being handled. Update BR100, MD050, and MD70 and maintain documentation repository up-to-date.
• Work and assist team members on technical issues and be actively involved in providing resolutions. Build good relation with business users, by using every opportunity to interact with them.
• Also travelled to client place in Europe couple of times to help customers on using the application and help them understand the processes and implementation specifics.

Confidential

Project Lead at Mahindra Satyam

.

Responsibilities

• Involved in research and Analysis which involves troubleshooting packages and procedures for critical issues.
• Analysis of enhancements, bug fixes, data issues and suggesting appropriate fixes for them.
• Involved in enhancing the application by closely interacting with QA Team as well as other dependent teams.
• Involved in testing the application, preparing unit test cases and fixing issues raised as part of Test Cycles
• Development of new API'S for Linking, Delinking and Moving in Service Contracts and Install Base.

Confidential

IT Consultant-II at Oracle

.

Responsibilities

• Involved in identifying the Problem Avoidance items and providing permanent fixes for the same.
• Worked as a Global Application Owner for Appraisal and iRecuritment, HAI modules
• Analyze and map the requirements into iRecruitment and Appraisal modules.
• Determine the gaps and workarounds.
• Involved in developing Talent Profile application using OA Framework.
• Worked as a single point of contact for supporting iRecruitment HAI instance.
• Involved in integration of Corp SSO for iRecruitment.
• Maintenance of 11i and R12 versions of iRecruitment and Appraisal modules.
• Worked on building new enhancements by designing the high-level and detailed architecture of the new solution
• Interact with the business users and understand the requirements. Assist them during their implementation or upgrades.
• Develop Proof Of Concepts POCs for the individual requirements and validate them with the users
• Develop the integrated solution based on the validated POCs
• Interacted with support and customers to resolve the issues

2. Member in the B2B

• Single point of Contact for the B2B Implementation team from India. Resolved many critical issues and helped in stabilizing the implementation.
• Sowmya was involved in design, coding, implementation and testing the solution, which interfaces Purchase order to Order Management.
• Involved in developing custom code to validate data sent by the customer before the payload gets interfaced to Order Management. Validations include mapping the customer data with TCA, identifying items sent with the Inventory, Pricing and so on.
• Developed various Alerts to identify orders stuck in the process using Alert Manager. Handled support issues.
• Delivered enhancements to the code to suite the various new features provided in the latest versions, preparation of setup documents and regression testing documents and conducting unit testing, integration testing and finally end-to-end testing.
• Managed the Quarterly Release Bundle Project.

3. Member of the Oracle Partner Ordering Portal team

• Worked on JSP Customizations for all the countries in which POP is implemented like Brazil, Canada etc.
• Involved in Modification of Store-OM integration hook, support issues on Oracle Linux store.
• Implemented Oracle Store to allow customers to buy Oracle Linux Support parts online. The site would sell only Linux parts.
• Involved in setting up the POP Site, Unit Test, and Integration test with OM for Singapore Operating Unit out of 12 countries released along with R12.
• Involved in OCAPAC Project for changing the Shipping Methods of Inventory Orgs.

Confidential

Programmer Analyst

Projects executed at Cognizant Technologies

Responsibilities

• Was involved in understanding and analyzing the basic system requirements.
• Worked in Analysis, Design and Integrating of Front Servlet, Service Locator, and JLog AMEX Components .
• Actively involved in Organization Process initiatives and used the internal tools like Prolite and QSmart.
• Involved in onsite interactions on daily/weekly basis in getting clarifications on requirements.
• Had taken care of the Code Reviews using PMD.

Responsibilities

• Sowmya worked in Analysis, Design and Integrating of Front Servlet, Service Locator, and JLog AMEX Components .
• Actively involved in the organization Process initiatives and used the internal tools like Prolite and QView.
• Had taken care of the Code Reviews using PMD.

Trainings Attended:

• Forms, Reports, SQL and PL/SQL.
• Java, J2EE and Oracle Application Framework.
• SOA, BPEL.
• AOL Foundation.
• Interpersonal Communication Skills workshop Soft Skill Training .