Business Analyst, Project manager, PeopleSoft Developer
Resume:
Sonia Kamra
*****.*****@*****.***
SUMMARY:
• 4.9 yrs of experience with Oracle Applications E-Business Suite.
• Currently working on Oracle Apps R12 with UnitedHealth Group as Senior Oracle Application Developer.
• Experience in Order Management, Financials and CRM.
• Expertise in complete software development life cycle that includes Techno-Business analysis, Requirement analysis, Design, Development, Testing, Deployment and Maintenance of Oracle Applications.
• Worked on Data Conversion activities, which involved extensive use of Oracle API’s.
• Experience in database-intensive applications on RDBMS making use of tables, database schemas, triggers and stored procedures.
• Expertise in technologies like Reports, Forms, SQL, PL/SQL, XML Publisher.
• Working knowledge of Version Control Systems like Visual Source Safe, Subversion.
• Got ' Pat on the Back ' award for exceptional performance and contribution to the project in Satyam.
• Got ‘On the Spot’ award from UnitedHealth Group for high quality work.
• Travelled onsite (Prescription Solutions CA, US) for 3 months on B1 for current project’s knowledge transfer.
• Completed training from Oracle University on 11i Oracle Order Management Fundamentals.
• Written Technical article on how to call webservices from pl/sql http://www.apps2fusion.com/at/79-sonia-kamra
• Providing Sql, Pl/sql Training to fresher in the organization.
• Completed training on “BPEL/SOA 11g Training” from Focusthread.com
• Oracle Certified Professional.
• Oracle E-Business Essentials certified.
TECHNICAL EXPOSURE:
Languages SQL, PL/SQL
Databases Oracle 10g, Oracle 9i, SQL Server 2000
Operating Systems Unix, Linux
Designing Tools Oracle Forms 9i, Reports 9i, JDeveloper, SOAPUI,XML Publisher
Version Control Tools Visual SourceSafe, Subversion
Domain Knowledge General Ledger, Accounts Payables, Purchasing, Inventory
PROFESSIONAL EXPERIENCE:
Employer: United Health Group
Client: Prescription Solutions (UHG/US)
Role: Oracle Application Technical Consultant
Duration: Oct 2008-Till Date
The project ‘IRIS’ is implementation of existing system RxExpress (Prescription Solutions) using
Oracle Applications R12.
Responsibilities:
• Data conversion activities. Working on Customer conversion, Prescription, Sales Order conversions.
• Worked on web services. Invoked web services from Pl/Sql.
• Developing Reports using Oracle developer Suite 10g and XML publisher.
• Developing Forms using Oracle Forms 10g.
• Written technical paper.
• Migrations using ITG tool.
• Worked on interfaces.
• Installation of Oracle SOA 11g and B2B components.
• Created XSD and ECS files (Canonical).
• Created build Script utilities for deploying the ESB and BPEL services that could be used over all applications
• Securing of web-services using simple authentication mechanism
• Implementing policies to multiple ESBs exposed on the server.
• Design the deployment BPEL and ESB processes for RAC clusters.
• Coordinating with Oracle for SRs and RCAs
• Performed on-call duties as requested by the client.
• Configuring the user realms to LDAP
• Implementing custom jars to invoke operations that are not present in default XPath operation provided by the JDeveloper
Environment: ORACLE SOA SUITE 11g, BPEL, OSB, Red Hat Linux, Java 1.5, J2EE, XML, XSD, XSL, WSDL, JDEVELOPER.
Employer: Satyam Computer Services Ltd.
Client: Fullerton India, New Delhi
Duration: Apr’08 – Sep’08
Role: Developer
This project was customization from Fullerton U.S.
Oracle Forms
• Requirement gathering from Client.
• Building Custom Forms.
• Customizing eBusiness center Form custom tabs.
Responsibilities:
Interacted with the customer to gather the requirements for designing the forms 9i.
Prepared Technical Design Documents for various modules.
Ensure compliance to all global standards including naming and software coding
Environment:
Oracle 11i, Sql, Pl/Sql, Forms 9i, SQL* Loader and UNIX.
Employer: Satyam Computer Services Ltd.
Client: Safexpress, New Delhi
Duration: Aug’07-Feb’08
Role: Developer
Safexpress is one of India’s leading logistics companies. Safexpress is in the process of revamping its legacy systems to address the limitations of the current IT systems and to facilitate the company’s growth to the next level.
Oracle Reports
• Enterprise reporting needs of Safexpress involve:
• Printing of forms like waybills, manifests, gate passes and so on
• Printing of standard operational reports like short-excess report, vehicle performance report etc
• Printing of standard MIS reports like monthly bookings that are generated on a predefined frequency (weekly, monthly etc).
• Standard and custom reports from Oracle E-business Suite
Responsibilities:
Interacted with the customer to gather the requirements for designing the report 9i.
Prepared Technical Design Documents for various modules.
Prepared the customized reports (AP,PO,GL).
Ensure compliance to all Safexpress global standards including naming and software coding
Supported the project for System Integration testing.
Environment:
Oracle 11i, Sql, Pl/Sql, Reports 9i, SQL* Loader and UNIX.
Employer: Satyam Computer Services Ltd.
Client: GE Oil & Gas Italy
Duration: Jul’06-May’07
Role: Developer
THERMODYN:
General Electric Oil & Gas, headquartered in Florence, Italy, is a leading provider of complete solutions for production and product handling for the Oil and Gas industry. Satyam team is participating in Third Phase of the multi-generational project with GE Oil and Gas and Thermodyn project teams. This third phase is specific to including the Thermodyn sub-business under the same Oracle 11i Financial and purchasing platform and its scope is limited only to Thermodyn go-live. Satyam team is required to carry out all technical activities on all the identified objects in the Oracle Applications 11i environment.
Responsibilities:
Interacted with the customer to gather the requirements, prepared the Use cases, Effort Estimations and Implementation Plans.
Prepared Technical Design Documents for various modules.
Involved in Designing the Database Objects using Normalization Techniques.
Designed & developed Interface programs to load data from different sources and written shell script programs for loading the data into staging tables and pl/sql stored programs for validating the data and pushing into standard interface tables
Extensively created Stored Procedures, Triggers and User Defined Functions in Oracle.
Prepared the customized reports.
Supported the project for System Integration testing.
Environment:
Oracle 11i, Sql, Pl/Sql, Reports 6i, Oracle Workflow, SQL* Loader and UNIX.
March’06 –May’06
Training on Oracle Applications in Satyam Computer Service Private Limited.
ACADEMICS:
Year of Passing Exam Passed
(Board/University) Name of School/College % of Marks
2005
B.E. (Electronics & Communication)
(Maharishi Dayanand University) B.R.C.M. College of Engineering and Technology 71%
PERSONAL INFORMATION:
Date of Birth: 2nd Sept 1984.
Father’s name: Mr. Ram Kumar Kamra
Language proficiency: English, Hindi
Contact this candidate