Project Oracle

RESUME

Deep K Tiwari

E-Mail: ************@*****.***

Cell +1-848-***-****

Summary of Work Experience and Proficiency

Oracle certified Associate (OCA) with 8+ years of experience in DB

Designing, application analysis, design, development, testing, and

implementation preferably using Oracle Tool Sets. In addition to technical

skills, having good exposure on handling a team, project planning and

estimation.

* Having 8+ year of Information technology experience including all

aspects of application life cycles.

* Having Good knowledge of Data base development like Procedure,

Package, Function, triggers etc .

* Having good experience in Performance tuning concepts Partition,

index management, Hints, Pipelined Functions, Bulk Bindings etc .

* Logical, Physical Data Modeling and Reverse Engineering has also

been part of my responsibility.

* Having in-depth knowledge of Oracle Database platform, in order to

deliver effective business solution.

* Analysis, Design & development of software in Oracle PL/SQL &

Developer 2000 (Forms 6i & Reports 6i).

* Domain knowledge :- HR applications, Manufacturing ( Customize

ERP

application)

* Having Experience to work on Production support project consist of

Ticket investigations, tracking the regular data loading jobs,

resolve the tickets etc.

* Having knowledge of Complex production Reports designing.

IT Skills

Domain Worked: HR, Finance ( Credit Card Application)

Manufacturing

Database: Oracle 8i, 9i, 10G, 11G

Language: PL/SQL, UNIX Shell Scripting

Oracle Tools: Toad, Oracle SQL Developer, SQL loader

UI : Form 6i,

Reporting Tool : Crystal Report and Oracle Report 6i

QA Tool : HP Quality Center .

Version Management Tool : PVCS, SVN .

Job Monitoring and Scheduling : CA workload center .

Education and Training

Education : Master of Computer Applications ( Post Graduation )

in 2005 .

: Bachelor Of Science ( Computer ) in 2001 .

Certification : OCA Certified from Oracle University

Professional Experience

1. <<<Project Name: Citicomp >>>

Client : Citigroup (Warren, NJ)

Environment : Oracle 11G

Role : Senior Tech Lead

Duration : Mar-2011 to Till Date

Project Description:

Citicomp is a Citigroup's global HR application for entire Citi's

employee that manages Salary, Bonus, Rating etc . This is

connected with global data warehousing and take feeds through

daily Jobs, process and keep data and then passes to payroll

department with different recommendation where there actual

financial activity to be done. Citicomp uses wide technologies like

Java, Oracle, UNIX, Crystal Reports, WEBI reports

Responsibilities:

. Working as a Oracle Developer and responsible for Customization, development of Oracle Objects and Doing performance Tuning

related staff using explain plan, stats gathering, indexing,

bulk binding etc .

. Involve in Project planning and estimation with Business

analysts.

. To indentify DB development part and dependencies among them.

. Database objects (Tables, Package, Function, Procedure etc)

design and develop by myself.

. Working as Onsite coordinator and explain functionality or

requirement to offshore team members, assigns task, work

estimates and Provide development approach if asked.

. To attend daily meeting with BA and business users to discuss

open issues and daily trackers issues.

. Assign QC bugs to team members and test upon completion .

. Involve in DB full build and deploy code in integrated dev

environment for more testing . Once it done then push it to UAT

environment.

. To open tickets for UAT and Prod deployment and coordinate with

release management team during Prod and UAT deployment.

. Developing SQL Scripts for Unit and integrated dev testing.

. To involve in Project specific hiring for Citigroup .

2. <<<Project Name: BIPSaas >>>

Company : IBM India (P) Ltd.

Client : American Express ( Atlanta, USA )

Environment : Java, Oracle 10g

Role : Team Lead

Duration : Sep-08 to Mar-11

Project Description:

BIP-SAAS (Buyer Initiative Payments) is a Credit card project

that enables

payment authorization for Supplier based on certain complex

Business logic, Keep

the status before and after transaction activities, Notify

Buyer supplier at each

stage etc .

As a Offshore Team Lead responsible for Analysis, Development,

Testing, Modification and Creating test scripts for DB objects For

BIP-SAAS (Buyer Imitative Payments ) project . Work done on all

releases and Critical CRs of BIP-Saas .

Responsibilities:

. Involve in Project planning and estimation.

. Analyzing the requirements, developing project standards and

process for database development.

. To Create test cases for newly develop object

. Assign QC tickets to team members and review task upon

completion.

. Provide Daily status of outstanding items, new items to onshore

team lead and Business analyst .

. To do understand CRs, Impact analysis and provide a feasible

solution .

. To assist other project team members to resolve their technical

and product related issues.

. Taken interviews for Project specific requirements.

. KT session for new members.

3. <<<Project Name: PowerERP >>>

Company : Omegacube Tech system .

Client : SRAF, SAP ( Itasca, IL )

Environment : Oracle 10G, Forms 6i, Report 6i

Role : Application Developer

Duration : May-08 to Sep-08

Project Description:

PowerERP is a Oracle web Based ERP product owned By Omega cube Tech systems

that has been customized for Various application like Supermarket,

Pharmacy, Hotel etc . It covers all module like other ERP products.

PowerERP mostly Focused on Medium and Small scale Organization .

Responsibilities:

. To design application mockup and send it to BA .

. Creating & customization forms and Reports for business

application.

. To create generic library for DB objects and maintain industry

standards.

. Creating & customization different database objects. Like

Procedure, Function, Triggers, Tables. Etc.

. Testing & Creating test scripts for UAT and Prod release.

. To Involve in Integrated deployment in other dev environment. Once

tested in dev environment then promote code it to Production .

. Take care QC tickets based on priorities and assigned it to team

lead after proper testing .

. To provide release notes to On-shore team lead after each

deployment.

. Provide Daily status to on-shore team leads.

4. <<<Project Name: Simplex ERP Solution >>>

Company : Simplex Castling Ltd ( Bhilai City, India )

Environment : Oracle 8i, Form 6i, Report 6i

Role : Senior Programmer cum Analyst .

Duration : Mar-07 to Apr-08

Project Description:

Simplex Casting is a Group of companies that manufacture iron steel

related products. Company has four big manufacturing units that

connects to each other through wireless system and has a centralized

Database system. Company has own ERP application based on Oracle and

it covers any tradition ERP package modules like Sales, marketing

Purchase, Store etc .

Responsibilities:

As a senior team member work done on ERP Design & implementation(In

house development ),co-ordinate with other members. To let them know

ERP functionality and limitations and providing techno functional

help.

. Involve in Project planning calls and provide estimations to

functional team members.

. To understand user requirement and create application according

to this.

. To create test cases for each requirements.

. Analysis and Database designing.

. Assigning task to team members and co-ordinate with them.

. To ensure the application as per the user specification and

maintain industry standards.

. To Create Forms and Report for application like sales,

purchase, inventory.

. Customization in application and reports based on CRs .

. To Create database objects like procedure, function, triggers

etc .

. To assign QC tickets to team members and review it upon

completion.

5. <<<Project Name: Oracle Based application for Various clients >>>

Company : Nexus software and Consultancy services, (Raipur City,India )

Client : Hotel Nest, Chitambra Super Market etc ., (Raipur

City,India )

Environment : Oracle 8i, Form 6i, Report 6i

Role : Tech Member

Duration : Mar-05 to Mar-07

Project Description:

As a software trainee work done on various projects that

includes Hotel

Management, Super market Automation, Roadways /

Transport Online Booking .

Responsibilities:

. Creating and customization Forms and Report for application .

. Creating and customization database objects like Triggers,

Procedure, and Functions etc as per the client requirement.

. Production bug fixing and testing.

. To create test scripts for Unit and integrated environment.

.

Contact this candidate