Data Project Manager

GITANJALI Contact No: - +91-902*******/844-***-****

Date of Birth: 03rd January, 1992 Email: - *********.****@*****.***

In pursuit of challenging assignments that would facilitate the maximum utilization and application of my broad skills and expertise in making a positive difference to the organization

Summary:

Total 4.3 years of professional experience in IT.

Worked on SCM (INV, OM and PO), General Ledger, and Account Payable modules in Oracle Apps R12 both as a functional level.

On General Ledger worked as a technical as Associate consultant.

Good experience on Developing Procedures, Packages, Functions, Views, and other database objects using SQL and PL/SQL.

Broad exposure to Interfaces (Inbound\Outbound), SQL, PL/SQL, XML Publisher, AOL Concept Etc

Good knowledge of P2P Cycle (Procure to Pay) and O2C (Order to Cash).

Having good knowledge of OAF.

Having Basic knowledge of Triggers, views, sequences, Constraints and other database objects.

Experience History

Currently working with Infosys, Pune since Nov-2014.

Worked as Oracle Finance Functional Consultant with IBM India Pvt. Ltd, Delhi from Feb-2014 to Oct-2014, and payroll company was Alignbiz Pvt. Ltd.

Worked as Oracle Associate Consultant in Blink Consulting Pvt. Ltd. Pune, India from August -2012 to Jan-2014.

Technical Profile:

ERP : Oracle Applications (E-Business Suite) R12/11i

ERP Modules: Oracle EBS 11i/R12 Order Management (OM), Inventory (INV), Purchasing (PO), General Ledger (GL), Account Payable (AP).

Languages : SQL, PLSQL, Rapid

Database : RACLE 9i/10g

Tools : Reports 6i/10g, Form 6i/10g, TOAD, SQL *Loader, XML Publisher, Oracle Application, Control-M, Data stage, Desktop Intelligence.

Functional Profile:

ERP : Oracle Applications (E-Business Suite) R12

ERP Modules : SCM (Inventory and PO), Financial modules of R12 (GL, AP and AR),

Languages known : SQL, PLSQL, Rapid

Database Technology : ORACLE 10g

Projects:

1)

Organization : Blink Consulting Pvt. Ltd. Pune, India.

Designation : Associate Consultant

Period : August -2012 to January -2014

Key Deliverables:

Worked on the SCM Modules and Finance Module.

Handling the Issues (Tickets) & Analyzing the root cause of the problem and giving fixes.

Analyzed and understood Functional Document (MD050) to understand the need of

Client.

Writing PL/SQL Procedures, Functions, and Packages and provided instant solutions to issues which were reported in the production instance.

Developed outbound interface to extract the data from the Oracle Apps Tables to the Flat file using UTL_File utility as per client requirement.

Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package.

Developed the inbound interface program to import the data from legacy system to Base Tables using SQL*Loader and PL/SQL packages to validate data.

Writing the SQL scripts to deploy into the Production Instance [Production Data Fix].

Coordination with onsite / offshore team and creating Weekly Status Report.

Reports:

Developed and customize Reports in PO using XML Publisher.

Developed and customize Reports in OM and INV Using XML Publisher.

Developed and Customize reports in GL Module using XML Publisher.

Developed and Customize reports in AP Module using XML Publisher.

Interface:

Worked on Purchase Order Interface to upload the Purchase Order data into Oracle apps Database Tables.

Worked on Item Interface to upload the Items data into Oracle Apps Base Table using SQL*LOADER.

Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package

2)

Organization : IBM India Pvt. Ltd.

Designation : Finance Consultant

Period : February -2014 to October -2014

Key Deliverables:

Coordinate with the client to understand current business process flow, analyzed requirements, and prepared functional specification documents.

Doing the setups to run the EBS front end like java installation etc.

Conducting training of the Clients about how to do work on EBS system.

Training includes how to create the invoice, payment, PO, Requisition, etc.

Interacting with Project Manager on daily basis and submitting status reports.

Handling issues related to financial support in payables and receivables.

Perform the Period closing and opening activities AP and AR.

Preparing GO-live Report at the end of the onsite support.

Setups:

Defining Flex fields, Cross Validation Rules, Security Rules.

Setting up the Set of Books i.e. Chart of Accounts, Calendar & Currency.

Defining the payment terms, distribution sets, Suppliers, Banks, Employee expenses etc.

Interface:

Worked on Purchase Order Interface to upload the Purchase Order data into Oracle apps

Database Tables.

Worked on Item Interface to upload the Items data into Oracle Apps Base Table using SQL*LOADER.

Developed Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package.

3)

Organization: Infosys

Designation: Senior Technology Support Executive

Client : HSBC

Scope : The project involves Support of Applications like GCRM (Global Customer Relation Management), GCM (Global Credit Module) etc.

Key Deliverables:

Monitoring daily Control-M Job.

. Solving different tickets based on SQL, PLSQL.

. Sending Mails about the daily feed.

. Managing health checks of all application like GCRM, GCM, EFOS, I2I etc.

4)

Organization : Infosys

Designation : Senior Technology Support Executive

Client : P&G

Key Deliverables:

Performed various Sys Admin responsibilities such as defining and registering concurrent programs and subsequently assigning them to their respective Request Groups, creation of Value set.

Monitoring daily Control-M Job.

Solving different tickets based on SQL, PLSQL.

Sending Mails about the daily feed.

Managing health checks of all application like GCRM, GCM, EFOS, I2I etc.

Running some of the Unix commands to run manually when some of the scheduled jobs get failed.

Conversion:

Developed Sales Order Conversion to load Historical Orders Data into Oracle Base Tables.

Formulated the test cases for conversion.

Resolved issues during the development and Customer Acceptance testing phases.

Design and developed technical document (CV060) for all conversion.

Providing support in Go-Live and to the Production system and resolving issues.

Academia

MCA in 2015 with 70 %

B.Sc (H) Computer Science from Delhi University in 2012 with 58.08%

HSC from CBSE Board in 2009 with 76.4%

SSC from CBSE Board in 2007 with 74.6%

Contact this candidate