خلاصہ

Versatile individual provide high strategies in Software Development Lifecycle and Oracle Apps DBA; recognized for delivering leading-edge tech solutions and develop packages for custom objects using SQL, PL & SQL Solution-focused, results-oriented, and innovative software project management professional with +7 years of experience and expertise in oracle forms & report development, API development SQL, PLSQL, data modeling, procedures packages, oracle ERP technical Skills, P2P supplier management system, inventory operations, oracle web logic server installation management and application deployment, RDBMS concepts, DML, DDL, TCL, and DCL. Skillful in implementation, upgrade, and customization of Oracle e-Business Suite Applications (Oracle Applications: 12.2.10, RDBMS : 19.0.0.0.0) including system study, development, post-implementation maintenance and support of Oracle EBS. Adeptly manage modules of Oracle Applications including Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), BOM. Well versed in data conversion, data migration, report generation and developing interfaces within several modules in oracle applications. Proven track record of utilizing RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows) and Procure to Pay (P2P), order to cash (O2C) life cycles, and business flows. Track outstanding deliverables, milestones, and change requests; monitor and enhance software development, troubleshooting, and QA process. High-performer and resourceful team player with exceptional skills in establishing relationships with management and team. Taskfocused person with the potential to propel an organization to top tier by utilizing interpersonal skills and thrive under work deadlines. ---------------------------------------------AREAS OF EXPERTISE---------------------------------------------- Oracle Forms Development • API Development SQL, PLSQL • Data Modeling • Procedures Packages • Oracle ERP Technical Skills • Oracle ERP (GL, AP, AR, Inventory, Assets, Purchasing) • Oracle ERP System Administrator • P2P Supplier Management System • Gate Pass System • Pre Costing • Inventory Operations • Oracle Inventory • WIP & Cost Management • Bills of Material • Enterprise Asset Management • DML, DDL, TCL, & DCL • Purchasing & Payables • General Ledger & Order Management • Receivables & Projects • Cross-Functional Leadership IT Skills: MS Word, MS Excel, MS PowerPoint, MS Outlook | Oracle Forms: Oracle Reports, Oracle Workflow, XML Publisher (BI Publisher), SQL, Loader, Toad, Putty| Languages: SQL, PL/SQL, JAVA, JAVA Scripting and HTML | Modules: General Ledger (GL), Fixed Assets (FA), Accounts Payable (AP), Accounts Receivables (AR), Purchase Order (PO), Inventory (INV) | Database: Oracle 10g/11g, 12c ,19C,SQL, PL/SQL, Oracle Forms | Oracle WebLogic Server: 12c(12.2.1.4.0) | ERP Application Version: R12.2.1.3 , R12.2.9 and R12.2.10. --------------------------------------------- CAREER CONTRIBUTIONS----------------------------------------------  Effectively Used SQL & PL/SQL features like Creating Table, Indexes, Triggers, Sequences, Cursors, and Ref Cursors.  Created Materialized views for performance tuning. Worked as a technical lead for the offshore team.  Developed Packages for Custom Objects using SQL, PL/SQL Administration System) into Oracle.  SQL*PLUS and P/L*SQL cursors (TOAD, PL/SQL Developer, command line)  Software Development Lifecycle (SDLC) skills compliant with SOX and ISO requirements  Leveraged Oracle’s open interface tables and related data conversions for Inventory/Items/On hand, Bills of Material, WIP, Costing, Purchasing, G/L, Payables and Receivable. 


 

پراجیکٹس

InHouse Application migrate to Application Server to web Logic Server
Oracle ERP Upgrade
Inventory Management System
Fair Price Shop (Inventory and sale system and invoice auto upload into ora
Service Improvement Advise (SIA)
Yarn Booking & Yarn Demand by production and yarn issuance by Godown
Pre Costing (JOC) & Yarn Inquiry
P2P Supplier’s Approval and Open in Apps
مزید دیکھیے

تجربہ

کمپنی کا لوگو
Oracle Developer / Oracle Techno - Functional Consultant
Kohinoor Maple Leaf Group – KRM Textile Unit
دسمبر ۲۰۱۴ - موجودہ | Lahore, Pakistan

Significantly supervise the design, construction, unit test, code review and bug fix of allocated modules including Oracle Application Development, Oracle application Financial R12.2.1.3 Customization and oracle functional support
Key Accomplishments:

Prepare custom reports for GL, AP AR, PO, and inventory, optimize forms personalization in AP, AR, GL, INV, and PO modules. Assure functional analysis into integration specifications and coordinate in data migration activities.
Formulate Modules Work and provide support to users including General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets (FA); deploy BOM & Routing generate in apps through API and Interface.
Assess suppliers update through APIs and devise auto submit concurrent programs from backend through PLSQL procedure with Oracle Apps API. Analyze PO Receipt Interface API and SRV approved by HOD Item automatically.
Follow policies regarding secure coding and standards and supervise user’s management, user’s responsibilities, menus, functions, request groups, profile options, concurrent programs and use XML Publisher and oracle reports.
Modify SQL, PL & SQL to develop queries for data and fix Bugs in Forms and Reports designed. Network Requisition to Pay (R2P), Record to Report (R2R), and Invoice to Cash (I2C) processes configuration and testing in Oracle Fusion.

Worked Modules in In House Application (Development)

Import LC Process System & Gate’s Operations
Store’s Operations & Godown’s Operations
Item’s Code Opening and approvals
Online Store’s SRV Approval & Online Godown SRV Approval
Request for Yarn Payment & Yarn Testing Lab
P2P Supplier’s Approval and Open in Apps.
Pre Costing (JOC) & Yarn Inquiry
Yarn Booking & Yarn Demand by production and yarn issuance by Godown
Service Improvement Advise (SIA)
Fair Price Shop (Inventory and sale system and invoice auto upload into oracle EBS through API).

کمپنی کا لوگو
Intern
A.F. Fergusson & Co.
جولائی ۲۰۱۴ - نومبر ۲۰۱۴ | Lahore, Pakistan

Assisted in ERP’s report development, report designing, construction test, code review and bug fix of allocated reports
Key Accomplishments:

Worked as 70% technical and 30% functional within Oracle E-Business Suite and examined reports designs with the functional consultant and developed BI publisher reports, applied patches, and checked queries.
Optimized team designs and maintains the Oracle and SQL Server database systems of house application data and collaborated with end-users and functional analysts to perform unit, system, and regression testing.
Researched software functionality and make recommendations by preparing documentation on detailed development, logic, and testing processes; analyzed and troubleshooted system issues in a timely manner.

تعلیم

Government College University
ایم فل, MS-CS‎
Computer Science
مکمل
2014
Government College University
بیچلرز, بی سی ایس / بی ایس, BS-CS‎
Computer Science
CGPA 2.7/4
2011

پیشہ ورانہ مہارتیں

ابتدائی ADF
ابتدائی AOF
متوسط Compliance Quality Control
متوسط CSS
متوسط CV Screening Skills
متوسط Database
متوسط Database Applications
متوسط ERWIN Data Modular
متوسط HTML
متوسط Integration
متوسط Oracel Apex
ماہر oracle developer Suit 10g
ماہر PLSQL
متوسط Product Customization
ماہر Query Language
ابتدائی Tablespaces
ماہر Toad 12
متوسط Warranty Quality Assurance Process

زبانیں

ماہر پنجابی
ماہر اردو
متوسط انگریزی