Gurjeet Kukreja

Email : ac4m05@r.postjobfree.com, Phone : +1-949-***-****

Linkedin : http://www.linkedin.com/pub/gurjeet-kukreja/1a/255/679

Experience Summary

Over 12+ years of experience in Design, Development, Conversion, Customization, Interfacing and Implementation of business applications using EBS Oracle Applications R11i/11.0.x/R12.

Extensive experience in Project Life Cycle including requirement gathering and Analysis,

Good experience in Database design, Database development, Application development, documentation, Test and Support.

Have completed 5 implementations for Oracle Applications Modules (OM, Inventory, AP, AR, GL, iStore, Quoting, Configurator), SQL, PL/SQL, Java J2EE, (XML) publisher.

Very good experience with Order-to-Cash, Procure to Pay (P2P) cycle, GL and Account Generator Workflow.

Evangelist of agile/scrum principles and methodology.

Proven ability to work creatively and analytically in a problem-solving environment.

2 years of Scrum experience.

Extensive experience in Oracle 12C, 10g/9i/8i and hands on experience writing Oracle SQL queries and Oracle PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors and using latest features to optimize performance (Bulk Collects, Collections, Ref Cursors, Materialized views, Global Temporary Tables).

Strong experience in all kinds of AOL objects, defining Logical Apps rules, defining Oracle Business Events and subscribing to them

Technically proficient in RICE (Reports, Interfaces, Configuration, Enhancements) methodologies in Oracle Supply Chain, Oracle Financials.

Experience in preparing AIM documents (MD50, MD70, MD120) during development and support and designing data/process flow diagrams using VISIO.

Proficient in writing and tuning complex SQL statements, complex joins co-related sub-queries and SQL statements.

Experience in tuning application using tools like Explain Plan, SQL*Trace and TKPROF for high efficiency.

Experienced in developing batch programs by using PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables.

Extensively worked with third party database tools like TOAD, SQL Navigator, SQL*PLUS, Jdeveloper.

Strong programming, debugging and problem solving skills and ability to translate customer requirements into technical solutions by utilizing business insights.

Ability to work within an aggressive and demanding project schedule and environment.

Excellent team player with strong analytical, presentation, and problem solving skills.

Technology

Below is a list of important hardware, software products, tools and methods that I have worked with.

Oracle Application Modules

Languages / RDBMS

Tools

Oracle Application Order Management, General Ledger, Configurator, Quoting, eContracts, eLicence (technical), iStore (technical & Functional)

PL/SQL, Java, JSP, Action Script 2.0, XML, HTML Oracle 12C,11g/10g/9i/8i

PLSQL Developer, Toad, Mercury IT Governance (Kintana), Oracle J-Developer, Flash, RWD, MS-Word, Tomcat 5.5, Harvest, Anthil

Qualifications:-

Master of Computer Applications (07-2002 to 06-2005) from Rajiv Gandhi Technical University, India. Major and Specialization in Dataware house and Simulations.

Professional Experience:

The details of the various assignments that I have handled are listed here, in chronological order:-

ACT(online Examination) Oct 2017 – Till Now

Iowa City, IW

Oracle Apps Techno Functional (iStore)

ACT is a nonprofit organization helping people achieve educational and workplace success. Our programs are designed to boost lifelong learning in schools and workplaces around the world. Whether it's guiding students along their learning paths, enabling companies to develop their workforce, fostering parent, teacher, and counselor understanding of student progress, guiding job seekers toward career success, or informing policymakers about education.

Function as a consultant to the business regarding systems operations and suggest continuous improvements in business processes and I or system operation

Working and maintaining online registration site

Participate in technical and functional group discussions and code reviews

Provide technical expertise and support to line of business

Write clear technical design documents based on analysis of business requirements

Understand and follow corporate SDLC standards and release management standards

WELLS FARGO Nov 2015 – July 2017

Charlotte, NC.

Oracle Apps Techno Functional (GL)

Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P) cycle, Fixed Asset to GL and Account Generator Workflow.

Functional responsibilities include: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.

Technical responsibilities include: interfacing the Modules, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, scheduling, producing, documentation and providing production support.

Develop, test, maintain and support customizations to Oracle E-Business Suite,PL/SQL code, UNIX shell scripts, OAF, ADF

Perform technical analysis and development on multiple moderate to large projects concurrently

Participate in technical and functional group discussions and code reviews

Provide technical expertise and support to line of business

Write clear technical design documents based on analysis of business requirements

Understand and follow corporate SDLC standards and release management standards

INGERSOLL RAND Nov 2012 – Nov 2015

Charlotte, NC.

Oracle Apps Techno Functional

Responsibilities:

(iStore, Configurator, Order Management)

Worked on various Interfaces to link between Oracle order management and legacy system.

iStore customizations like custom ATP form, background order creation process, providing various item type information in Direct Item Entry, Adding new address type checkout process, backlog report, advanced order search

Worked on OM interfaces like Creating Promotion in Oracle, Item Creation, Validation & adding it to Price list, Outbound interface to send Salespersons data from Oracle, Order Management Defaulting Dependencies Extension.

Worked on the XML Publisher reports to send Configurator Model Report in xls Format

Major role in developing MD70, core development and preparation of MD120 for several modules

Involved in analysis and development of major conversions and interfaces

Used SQL*Loader, UTL_FILE package and External Table concepts for loading data into the database tables through an automated process.

Involved in Optimizing SQL queries involving large tables.

Motorola Solutions

Schaumburg, IL, Aug 2011 – Nov 2012

Oracle CRM Techno-Functional / Agile Scrum Master

Responsibilities:-

Sales Suite (iStore, eLicense, eContracts, Scrum Master)

Worked as a functional / technical SME and Systems analyst with the business users, stake holders, and marketing personnel across the world to identify and solidify key requirements for an R12 iStore implementation, a transformation from their existing legacy system to Oracle ERP solutions.

Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations.

Protect development team from outside distractions, impediments or team conflicts, and maintain focus on product backlog and project timeline.

Work closely with project owner in backlog management and continuous delivery of features.

Educate and reinforce scrum methodology and agile framework to team members and key stakeholders.

Direct and lead development team from project initiation through delivery of final product.

Worked with the functional and business analysts and testing teams to prepare the customer requirements, business requirements MD50 / MD70 and BR100 documents.

Worked with appropriate OM / Inventory / Pricing / Receivables teams to setup appropriate touch point system setups and components.

Successfully lead the team to completed, UAT, CAT and Production release with minimal bugs and effectively provided production support across various browsers and devices such as iPad, Zoom, Kindle.

Perform a feasibility study for implementing Oracle CRM Service suite to replace the existing legacy system across Asia Pacific, Europe and American regions.

Conduct an exploratory analysis of the legacy system functionality and map it to Oracle suite.

Configure and setup Oracle service suite of modules and document the process within BR100.

INGERSOLL RAND Feb 2007 – Aug 2011

Davidson, NC.

Oracle Apps Technical

Responsibilities:-

Sales Suite (iStore, Configurator, OM)

Goal of the program was to implement Oracle iStore for the Oracle Apps 11i system.

Oracle iStore provided a way, to make the ordering process easier for end users because of its sophisticated web-based architecture.

Deployed over 30 custom iStore components, automating the Order Process.

Worked with the functional and business analysts and testing teams to prepare the customer requirements, business requirements MD50 / MD70 and BR100 documents.

Assumed ownership of the project initiative, and guided the various teams involved through implementation, testing, and into production.

Worked with appropriate OM / Inventory / Pricing / Receivables teams to setup appropriate touch point system setups and components.

Developed architecture designs, UAT user guides, test matrixes, and code.

Rio-Tinto Jan 2006- Feb 2007

Brisbane, Australia

Rio Tinto ABS Program

SAP E-learning program for employee to understand newly implemented system. Designing eLearning and classroom training courses of SAP based system, which included WBT and ILT materials for Rio Tinto’s ABS Program.

Responsibilities:-

e-Learning (WBT, LDT)

Deliverables included user guides, and instructor guides. It also included system simulations recorded and edited using RWD InfoPak

Multi-lingual support for Spanish, French, German, Dutch and English.

Customer Requirement Study, Preparation of Development Requirements from customer requirements

Involved in analysis and development of major conversions and interfaces

Participations in the code reviews and Technical design reviews in across all the modules.

Contact this candidate