Senior Programmer Analyst Resume
SUMMARY:
- Have around 8 years of experience in IT and is into Oracle Applications having technical knowledge on SCM modules (INV, OM), Financial modules (AR, AP, GL), HRMS, Application Developer, System Administrator of Oracle Applications R12/11i.
- Have worked on various Oracle Tools and Technologies: RICE Components, SQL, PL/SQL, Forms, Reports, XML Publisher, Discoverer Reports and OAF etc.
- Have good knowledge on the Procure to Pay cycle and Order to Cash cycle.
- Have good experience in 11i and R12 Implementation projects (conversions and Interfaces) and support projects (Includes new developments, customizations, and extensions in both 11i and R12 applications).
- Have very good understanding of AIM methodology and onsite/offshore practice
- Have very good experience of designing/developing of various RICE components
- Have Good Communication, Co - ordination and team skills.
- Well organized with excellent leadership skills and commitment to deliver on schedule
TECHNICAL SKILLS:
Languages: SQL, PLSQL, C, Java
Tools: RICE Components, Discoverer 10g, Reports 6i/10g, Forms 6i, XML Publisher,, OAF, SQL* Loader, JDeveloper
ERP - Oracle Applications 11i, R12: HRMS, Account Receivables (AR), General Ledger (GL), Inventory (INV), Purchasing (PO), Order Management (OM), Accounts Payable (AP), System Administrator, Application Developer.
PROFESSIONAL EXPERIENCE:
Confidential
Senior Programmer AnalystResponsibilities:
- Developing Scripts and Technical design documents for Conversions (Implemented for 10 countries)
- Helping the functional team with Legacy to Oracle mapping
- Preparing Development standards, Conversion Strategy Integration strategy documents and Unit test case templates
- Working on preparing Instance Checklist and Review Checklists
Solution Environment: Oracle Applications R12, Oracle 10g database.
Tools: Oracle 10g, Sql, PL/SQL, TOAD, Formatter Plus
Confidential
Senior Programmer AnalystResponsibilities:
- Developing and Customizing the BI Publisher reports for UK, NL, IN, UAE, SL, AU, BR, US and BH countries
- Working on Citibank Credit Card Integration for Oracle
- Customizing BPA Invoice external template reports
- Working on OAF Customizations and Personalization’s in EAM and PO modules
- Performing development tasks such as writing extensive PL/SQL program units like procedures, functions, triggers and packages
- Preparing Unit test case documents, Migration documents etc
Solution Environment: Oracle Applications R12, Oracle 10g database.
Tools: Oracle 10g, SQL, PL/SQL, TOAD, Formatter Plus, JDeveloper
Confidential
Senior Technical Consultant
Responsibilities:
- Monitoring the daily Confidential run
- Coordinating with DBA and Project team to resolve the issues faced during the run
- Analyzing and Resolving the Task Defects raised by the QA team within the given SLA
Solution Environment: Oracle Applications 11.5.10
Tools: Confidential ($U), TOAD, Formatter Plus
Confidential
DeveloperResponsibilities:
- Working on the Data migration templates for Items and AR Invoices
- Creating temporary tables and SQL *Loader control files to load the legacy data into the temporary tables
- Creating insert scripts to insert records into Conversion staging table from temporary table
- Developing packages for mapping, validating the records in conversion staging tables
- Writing extensive PL/SQL Program units like procedures, functions, triggers and packages
- Developing CV060 and CV120 documents for conversions and MD070 and MD120 documents for reports
Solution Environment: Oracle Applications (11.5.10), Oracle 10g database
Tools: Oracle 10g, Reports 6i, PL/SQL, Formatter plus.
Confidential
Technical Consultant
Responsibilities:
- Planning and Estimating the timelines
- Analyzing the feasibility of the requirements
- Quality of the work
- Proceeding with development according to the process
- Managing the deliverables
- Fixing the issues in time
- Preparing the Technical and Installation documents
Solution Environment: Oracle Apps 11.5.10, Oracle Database 10g.
Tools: Oracle Reports 6i, Discover, XML Publisher, PL/SQL, Formatter Plus