Sql Developer Resume
San Jose, CA
SUMMARY
- Having 17 years of industry experience encompassing a wide range of skill sets, roles and industry verticals, out of which 4 yrs. experience in Non - IT (Mechanical industry).
- Having 13 yrs. extensive experience in IT Industry with analysis, design, development,implementation, upgrade, support, roll-out and customizations of Oracle JD Edwards ERP applications.
- Strong expertise in JD Edwards Upgrade projects from JD Edwards World A 7.3 to JD Edwards Enterprise One(8.12,9.0,9.1 and 9.2) as well as JD EdwardsOneworldXE to JD Edwards EnterpriseOne 8.12.
- Sound knowledge and experience in JD Edwards Enterprise One Distribution (O2C, P2P, Inventory, Warehouse Management, Agreement Management and Advance Pricing) modules, Also having experience and sound knowledge on Finance and Manufacturing modules.
- More than Five years of sound on-site experience on JD Edwards upgrade(USA,UK and Belgium).
- Proficient in Embedded BI Publisher Reporting Tool (multi lingual) and E1 Pages.
- Extensive knowledge and exposure in C- business Functions development and Debugging,
- Having hands-on experience and sound knowledge in Business Services development and debugging.
- Sound knowledge on Z-processes and EDI Processing.
- Sound knowledge on Master Data Management.
- Proficient in JDE Integrations with MES(DSI), Kallik and BOX.com
- Proficient in SQL and PL/SQL querying tools/Languages.
- Proficient in JD Edwards World Programming, Full Life-Cycle implementation, Maintenance of EDI (ANSI X12,EDIFACT),ROBOT Administration and Web sphere MQ Series Administration.
- Proficient in analyzing and translating business requirements to technical requirements and architecture.
- Strong database skills and Certified Object Oriented Programmer in Java 2.0
- Experience in handling multiple roles (Techno-functional analyst, Senior Systems Analyst, System Admin (JDE World soft, EDI and ROBOT) and Software Developer).
- Executed software projects for Healthcare, Information, Services and Manufacturing Industries.
- Good communication skills, interpersonal skills, self-motivated, quick learner, team player. Have onsite client exposure and highly accepted by the client team in all the projects.
- Worked as the Landed developer cum RICE developer in the past projects.
TECHNICAL SKILLS
Databases: Sql2000/2005, Oracle 11gR2 and PL/SQL
ERP Expertise: JD Edwards one world Xe/Enterprise One 8.12, 9.0, 9.1 and 9.2 and JD Edwards World A 7.3
Middleware Expertise: EDI (ANSI X12 and EDIFACT) and MQ Series and Business Services
Functional Expertise: Oracle University and JDE Boot Camp Trained on Sales and Distribution module, Sound knowledgeand experience with Sales and Distribution Module( P2P, O2C, Inventory and Advance Pricing)
Languages: C, Java, CL/400, DB2/400 and RPG/400
BI Tools: BI Publisher/Create Forms and Pivot Link
EDI Tools: Trusted Link Inovis and Access 400
PROFESSIONAL EXPERIENCE
Confidential - San Jose, CASQL Developer
Responsibilities:
- Requirements gathering and translated to technical solution.
- Worked on production issues related to distribution.
- Worked on Tax-Recalculation RFC and provided FDD and TDD for implementation.
- Working on EDI 855,856 and 810 Implementation.
- Created several business services.
- Done several retrofits and created new BI publisher objects.
- Created UTP/test cases and done rigorous testing.
- Providing go-live and post go-live support.
SQL Developer
Responsibilities:
- Requirements gathering and translated to technical solution.
- Worked on productions Issues related to Several Interfaces in Product Data Management.
- Worked on production Issues related to AP-Payment process.
- Worked on production issues related to distribution.
- Worked on designing enhancements and translating them to technical solution.
- Actively participated in several Software Restoration Team Issues and provided on the spot solutions.
- Created validation documents for SRS, URS and IQ and OQ protocols.
SQL Developer
Responsibilities:
- Requirements gathering and translated to technical solution.
- Created new applications and reports.
- Created Sales Analysis by State UBE
- Created Pivot Link Custom Interface
- Created Inventory Valuation by Cost Component UBE
- Created BI Publisher Objects and Report definition for Statement of Account,Order Confirmation, Invoice and Purchase Order Print UBE.
- Created BI Translation objects for Korea,China and Germany.
- Created E1 Pages.
- Created interface for JDE E1 integration with ADSI.
- Created and worked on Entire Address Book Data Conversion programs and successfully uploaded all the Address Book Related tables into E1 9.1 from JD Edwards World soft A7.3.
- Worked on Pivot Link Interface to upload data into it from JD Edwards World Soft with source as JDE E1.
- Worked on Manage opportunity CRM application for enhancement.
- Worked on enhancement for JDE World A7.3 VAT Exception Report.
- Worked on modification of Pivot Link Programs in JDE World A7.3.
- Done event rule and C-business functions debugging.
- Resolved Production Issues.
SQL Developer
Responsibilities:
- Requirements gathering and translated to technical solution.
- Created new applications and reports.
- Created TDD from the provided FDD.
- Migrated data from master and transaction tables.
- Done trouble shooting for data migration issues.
- Done several retrofits and created new BI publisher objects.
- Created SQL queries for application usage.
- Created UTP and executed.
- Done enhancements for existing reports and applications.
- Created BI Publisher Objects and Report definition for Sales order and Procurement reports..
- Done extensive eventrule and VC++ debugging.
- Provided go-live support.
Confidential - San Jose, CA
SQL DeveloperResponsibilities:
- Requirements gathering translating to technical solution.
- Created new applications and reports.
- Modified or enhanced existing Objects
- Provided support for Production objects.
- Created SQL queries for application usage.
- Done enhancements to existing report templates using Create Forms.
- Design technical specs across all modules.
- Developed package build automation tool.
- Developed Master Data Management ( Address Book and Item Master )