SUMMARY

• Over 6 + years of techno functional experience in analysis, design, development, customization, testing, support and maintenance of IT projects in Oracle Applications R12 and 11i.
• Excellent experience on implementation, enhancements, upgrades, migrations and production support in Oracle 11i and R12 projects.
• Major Experience on Data Conversions and Interfaces.
• Have worked on Inventory, Bill of Materials, Routing, Inventory Transactions, Accounts Payable, Accounts Receivables, General Ledger, Purchasing modules.
• Hands on experience on J developer, Toad, and Oracle SQL Developer.
• Experience in application development, debugging, implementation, supporting dev team, testing of Oracle based ERP using SQL, PLSQL, Shell Scripting, Java, Database Triggers etc.
• Experience in working with PL/SQL packages and Stored Procedures.
• Have worked in report building which had usage of advance sql feature like PARTITION BY, CONNECT BY LISTAG, LEAD, LAG. Hierarchical queries.
• Involved in worked in Java project as intern wherein I was involved in creating login page.
• Involved in extensively on version control tools such as Rational (RTC) and Harvest.
• Familiar with tools like HP Quality Center, Rational (RTC), Alfresco Document Management system, PPM (Project Portfolio Management), Putty.
• Responsible for gathering requirements from end client, providing technical designs and working on the Build, Deployment and Support.
• Strong Analytical, Problem Solving and debugging skill with excellent understanding of system development metrics, techniques and tools.
• Excellent communication and verbal skills, team player, quick learner and self motivated.

TECHNICAL SKILLS

ERP: Oracle Applications E­Business Suite 11i/R12

Modules: PA, AP, Purchasing, Inventory, GL, AR, FA, OAT, Pricing

Programming: SQL, PL SQL, Shell Script, Java, Insight of Big Data, Java Advance SQL (LEAD, LAG, WITH, PIVOT, CONNECT BY PRIOR, RANK, DENSERANK, MODEL CLAUSE and CUBE).

Database: Oracle 9i/10g/11g

GUI: OA Framework, BI Publisher, Workflow Builder, Forms 10g

Tools: Toad, SQL Develop, SQL* Loader, Winscp, Putty, Harvest

Operating Systems: Unix, Windows

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler and Conversion lead

Responsibilities:

• My primary role in this project was as conversion lead where in lead team of 5.
• Worked on objects like creating issuance, recovery account, family plan, service providers and recovery account transactions.
• My role included developing new conversion objects on the basis of requirement.
• Interact with client/business users for requirement clarifications and issues related to data conversions.
• Debugging java objects to get to know the requirements and expectations of table.
• Requirements gathering from client teams and designing technical documents.
• Maintain Mock execution plan, dependency tracker and fixing defects tracker.
• Coordinate with offshore teams (around 15 resources) and with onshore functional team and third party teams.
• Extensively involved in performance tuning activities due to high volume of data.

Environment: s­: Benefit Management System, Java, Oracle SQL, SQL Developer and UNIX.

Confidential

Data Conversion Developer and Analyst

Responsibilities:

• This Project was an implementation of Oracle 12 EBS for North America Operations of "Air Liquide" along with customizations and interfaces to integrate legacy applications, third parties.
• Worked as Conversion specialist for INV, Purchasing, BOM Modules, Inventory transactions, Item Cost Conversion. Execute/Support mock conversions related to all conversions.
• CTL files to load data file into file.
• Suggested and Implemented Form Personalization on Item master form.
• Interacted with client/business users for requirement clarifications and issues related to data conversions
• Functionally involved in Inventory and BOM Conversion during Go - Live
• Tuned queries and generated error reports for the Client
• Co- Ordinated with Onshore/Offshore/Client team members to resolve the defects in inventory modules.
• I have strong knowledge in Inventory Module, especially "Item Conversion".
• I was involved in "Item Extended attribute" design and implementation which is integral part of the project as almost 30
• Interface interacts with "Item Extended attribute" object.
• Used Analytical queries like WITH, CONNECT BY PRIOR, RANK, DENSE RANK and MODEL CLAUSE to extract meaningful reports for the Client so that they can analyze data.

Environment: s ­: Oracle EBusiness Suite R12, PL/SQL, Java, OA Framework, Oracle Reports, Oracle SQL Developer, ToadRational, JDeveloper 10G, Oracle Forms, Advance SQL (LEAD, LAG, WITH, PIVOT, CONNECT BY PRIOR, RANK, DENSE RANK, MODEL CLAUSE and CUBE).

Confidential

Data Conversion Developer and Lead

Responsibilities:

• Worked as a Data Conversion specialist for Purchasing, AP, AR, INV, BOM, Routing, FND Attachments Modules .
• Execute/Support mock conversions related to all conversions.
• Automated the process of creating report of Conversion.
• Defect resolutions and tracking at the time of Mock Executions.
• Maintaining Dependency tracker while at the time of executions.
• CTL files to load data file into file.
• Worked/lead the team through 43 conversion objects spanning across modules. These involved extraction, Transforming and loading the data. Planned three mock executions for these conversions which involved both master and transactional data.
• Successfully planned and executed the transactional data conversions during cutover period of Go­live.
• Adhered to conversion processes and made sure to get the signoffs at each phase of the mock and production executions.
• Interact with client/business users for requirement clarifications and issues related to data conversions.
• Creation of XML Publisher reports with Excel and PDF outputs.
• Requirements gathering from client teams and designing technical documents.
• Maintain cutover plan, dependency tracker and delivery tracker on a regular basis.
• Coordinate with offshore teams (around 15 resources) and with onshore functional team and third party teams.
• Mapping source file fields to Oracle table columns
• Extensively involved in performance tuning activities due to high volume of data.

Environment: s ­: Oracle EBusiness Suite R12, PL/SQL, Java, OA Framework, Oracle Reports, Oracle SQL Developer, ToadRational, JDeveloper 10G, Oracle Forms, Advance SQL (LEAD, LAG, WITH, PIVOT, CONNECT BY PRIOR, RANK, DENSE RANK, MODEL CLAUSE and CUBE).

Confidential

Data Conversion Developer and Lead

Responsibilities:

• Worked as a Data Conversion specialist for PO, AP, AR, INV, BOM, Routing, FND Attachments Modules . Execute/Support mock conversions related to all conversions.
• Worked/lead the team through 20 conversion objects spanning across modules. These involved extraction, Transforming and loading the data. Planned three mock executions for these conversions which involved both master and transactional data.
• Adhered to conversion processes and made sure to get the signoffs at each phase of the mock and production executions.
• CTL files to load data file into file.
• Interact with client/business users for requirement clarifications and issues related to data conversions.
• Creation of XML Publisher reports with Excel and PDF outputs.
• Requirements gathering from client teams and designing technical documents.
• Maintain cutover plan, dependency tracker and delivery tracker on a regular basis.
• Coordinate with offshore teams (around 15 resources) and with onshore functional team and third party teams.
• Mapping source file fields to Oracle table columns
• Extensively involved in performance tuning activities due to high volume of data.

Environment: s ­: Oracle EBusiness Suite R12, PL/SQL, Java, OA Framework, Oracle Reports, Oracle SQL Developer, ToadRational, JDeveloper 10G.