Oracle Ebs, Plsql & Unix Lead, schenectady, New York Resume
SUMMARY:
- An IT Professional with 7+ Years of experience in Oracle EBS, PLSQL & Unix. Presently working in Confidential as IT Analyst. Has been working at onsite in United States for past 3+ years.
- 4+ years of experience to work as Project Technical Lead. Travelled to Europe for project roll outs.
- Led integration development for past 3 years . Along with project work, has been working as Governance, Risk & Compliance Lead for past 6 months.
- Played key roles in 3 successfully delivered Oracle ERP Implementation. Provided unflinching support for 2 Oracle ERP implementations.
- Expertise in Oracle EBS Supply Chain Modules along with Oracle EBS Technical.
- Well versed with onsite & offshore model of project execution.
- Rolled out Oracle R12 & 11i implementations, Enhancements, Support & Maintenance projects.
- Executed projects with Agile/Scrum methodology.
- Along with the IT experience, me has served as Professor for 3 months.
EXPERTISE AREA:
- Oracle PLSQL
- Oracle SQL
- Unix Shell Scripts
- SQL Loader
- Oracle APIs
- ETL (Extract, Transform and Load)
- Data Conversion
- Integration Development (SOA Middleware)
- Oracle Form (UI) Personalization
- Oracle RDF, XML & HTML Reports
- WebADI Development
- Oracle Forms development
- Oracle Workflows
- OAF
- Order Management
- Inventory
- Purchasing
- Work in Process
- Bills of Material
- HRMS
- Oracle Financial Basics - GL, AP & AR
- Time Log
TECHNICAL SKILLS:
Language / Platform
Software / ToolPLSQL Programming: Oracle PL/SQL Developer, PLSQL Toad, Forms & Reports Builder, SQL Developer
Unix Shell Script: WinSCP, Putty, Telnet, SSH Client
Version Control tool: CVS, MS- VSS
Migration Tools: HP PPM
Application Lifecycle Management: HP ALM, HP QCProject Management: Top Team
PROFESSIONAL EXPERIENCE:
Confidential
Oracle EBS, PLSQL & Unix Lead, Schenectady, New York
Responsibilities:
- Led Build Team for US and Europe Go-Live.
- Managed team size of 15 members.
- Integration Led for past 2 years. Built interface using SOA middleware.
- Leveraged Oracle Supply Chain Module expertise for automating business processes.
- ETL (Extract, Transform & Load) - Built Program to load data into Oracle data from third party systems.
- Built highly complex PLSQL & Unix program like Autoship Sales Order, IR ISO Receiving, Reconciliation reports, Drop-shipment, Integration Gateway, Manufacturing Time log report, Inventory Tracking Report. Received customer appreciation for defect free delivery and value addition to their processes.
- Implemented O2C and P2P cycles.
- Has shown potential in critical Go/No-Go situations. Developed program to fill process gaps identified at last minute during Production Go-Live. It was a life saver for everyone and received so many customer appreciations for the same.
- Governance, Risk and Compliance Lead for past 6 months.
- Worked with Business users to gather business requirement and converted business requirement to IT functional requirement.
- Designed and built PLSQL & Unix programs to accomplish functional requirements.
- Production deployment and migration through tools like ServiceNow, HP PPM and CVS.
- Helped and guided team to achieve on-time defect free delivery.
Oracle EBS, PLSQL & Unix Lead Programmer
Confidential, Houston, Texas
Responsibilities:
- Implemented Oracle Supply Chain Modules.
- Performance tuning of PLSQL programs and sql.
- Implemented Order to Cash end to end cycle.
- Gained experience in Oracle Supply chain modules.
- Worked on Oracle GL, AP and AR modules.
- PO, Item and BOM Conversion.
- Personalized Oracle Forms (User Interface) to handle highly complex custom business requirements.
- Carried out successful period closing.
- Prepared Project documents for Demo, Training and other purposes.
Oracle EBS, PLSQL & Unix Developer
Confidential
Responsibilities:
- Worked as single resource to support this project.
- Built reusable Unix programs like Email Notification Unix Shell Script which was proven useful in many automations.
- Deployed enhancements like Archive mechanism in Unix Shell Script to optimise system performance.
- Developed Auto-recovery program to recover system from unexpected failures. It was a value addition to the application.
- Got expertise in Unix shell scripts.
- Responsible for status reporting to client.
Senior Oracle PLSQL & Unix Developer
Confidential
Responsibilities:
- Implemented Drop ship functionality for GE Digital Energy Management business.
- Implemented Procure-to-pay end to end cycle.
- Built PO PDF reports.
- Worked on PO and Item conversion.
- Carried out successful Go-Live.
Oracle PLSQL & Unix Developer
Confidential
Responsibilities:
- Worked as a Developer.
- Developed program in Unix shell script.
- Worked on complex Oracle SQL and PLSQL requirements.
- Developed Oracle Forms and Reports.
- Executed SIT, UAT and Go-Live.
Trainee
Confidential
Responsibilities:
- Got Training in Unix, SQL and PLSQLduring Integration Training Session.
- Built soft skills.
- SDLC execution
- Got Training in C, C++, Java during Induction Training Session.
Professor
Confidential
Responsibilities:
- Conducted lectures for core electronics subjects like Electronics, Optical Fibre Communication, Antenna.
- Network Analysis Lab In-Charge.
- SPOC Faculty for Engineering third year.