ASHISH KUMAR JAIN

SUMMARY

• More than twelve years of extensive IT industry experience in maintenance, implementation, development and testing of business applications.

• Excellent skills in D2K 6i, D2K 5.0, Forms 4.5, Forms 3.0 as front-end tools.

• Exposure on Oracle RDBMS (Oracle 7.x, 8i, 9i, 10g) as back-end tools.

• Worked in various areas of Insurance, shipping, financial management, engineering, tax calculation, incentives calculation, ERP, retailing, telecom and manufacturing.

• Worked on applications, which have been migrated from MAINFRAME BULL to BULL EXIT (UNIX) for ORDER ENTRY MODULE.

• Worked on banking applications of NEWTON Core banking software.

• Worked on Business Intelligence and Data Warehousing applications

• Worked on Wholesale Banking applications of Wells Fargo Wholesale Banking Project

• Worked in VERISIGN Nextgen 2.0 telecom domain billing project

• Worked in Tyco electronics data warehousing services project at client site

• Worked in for Omega L4 team for the client HP

• Worked in Nor’easter project with CAPGEMINI for the client Fairpoint

• Shadowed one of the data migration project of Nor’easter

• Worked on Data migration and screen customization projects as part of Proserve team

EDUCATION

Bachelor’s in Mechanical Engineering, MMM Engg. College, Gorkahpur, India, 1991- 1995.

M.Tech in Industrial Metallurgical and Materials Sciences from IIT, Roorkee, India, 1995 to Jan’97.

OPERATING SYSTEMS

AIX 3.1, HP-UX V11.x, Windows 95, 98, NT, 2000, Professional, DOS.

HARDWARE

IBM-PC 386/486/Pentium, P-II, P-III, DELL-P-IV, RS–6000(IBM).

SOFTWARE / METHODOLOGIES

Oracle 7.2/7.3/8.i/9i/10g, D2K 5.0, 6i, Oracle Forms 3.0, Oracle Forms 4.5, Oracle Reports 3.0, 6i, PL/SQL, COBOL, Pro*COBOL, Pro*C, Unix, shell programming, AWK, C, SunOS 5.8,AIX 3.1

PROFESSIONAL WORK EXPERIENCE

• 24th of June, 09 till 20th of Jan, 2010 worked with ARISGLOBAL Software Pvt. Ltd, Bangalore, India

• 11th of July, 07 till 29th of May, 2009 worked with CAPGEMINI, Bangalore, India

• 2nd of Dec, 04 till 10th of July, 07 worked with MPHASIS an HP Company, Bangalore, India

• 18th of Aug, 04 till 1st of Dec, 04 worked with 3i Infotech, Bangalore, India.

• 19th of May, 03 till 05th Dec, 03 worked with GE Consumer Products at Bangalore, India.

• 06th of Dec, 02 till 05th of Feb, 03 worked with Binary Semantics Ltd, Gurgaon, India on contractual basis.

• 06th of March, 97 till 24th of June, 02: worked with Tata Consultancy Services, New Delhi, India.

24th of June 2009 till 20th of Jan, 2010: Team Leader, ARISGLOBAL Software Pvt. Ltd , Bangalore, India

• As part of five members team worked as a Team Leader for Proserve Team

• Writing PL/SQL scripts, packages, procedures and functions. Worked on data migration scripts for various clients like Takeda, Teva, Guerbet etc

• Troubleshooting various problems caused due to migration

• Worked on Screen customization for Arisg software for various clients like Lundbeck, Health Canada, Forest Labs etc

• Writing Functional Specification requirements documents by getting the requirements from the client

The project deals with the Pharmacovigilance safety system. If any drug causes any adverse reaction then it needs to be reported to authorities like MHLW, FDA etc within a specified time period depending upon the severity of adverse reaction. There are many other related products owned by Arisglobal like ARISg, ARISj, agXchange, agClinical, agSignals, agComposer etc.

ENVIRONMENT: oracle 9i, 10g, Internet Explorer 6.0., PL/SQL, SQL DEVELOPER, SQL*LOADER, PL/SQL Developer, VSS, JSP, HTML etc

6th of July 2008 till 31st of Jan, 09 : Senior Consultant, CAPGEMINI, Bangalore, India

• As part of five members team worked as a Module Leader for Nor’easter ( COEP/CPP modules) team working for the client Fairpoint

• Writing PL/SQL scripts, packages, procedures and functions. Working on back end applications.

• Modifying and writing shell scripts and batch run job scripts and also loading of data using Sql*Loader

• Monitoring jobs and taking care of any day to day failures and maintenance etc

• Troubleshooting various problems caused due to migration in other environments

• Data migration scripts in SQL SERVER 2005 for transferring the data from .xls files to the staging tables and then to the respective target tables

The project deals with telecom billing as well as other aspects like inventory management i.e. part of material management and power equipments management. Currently all the jobs needs to be moved to the production server INVINCIBLE from the UAT server constellation and I am working for CCP(capacity creation planning) and COEP(central office equipment property) modules.

ENVIRONMENT: oracle 10g, Internet Explorer 6.0., PL/SQL, HP-UX 11.x, TOAD 7.5.2.0 , SQL SERVER enterprise manager 8.0 ,SQL*LOADER etc

17th of October 2007 till 31st of June, 2008: Senior Consultant, CAPGEMINI, Bangalore, India

• As part of five members team worked as a Module Leader for Omega L4 team for the client Hewlett Packard

• Writing PL/SQL scripts, packages, procedures and functions. Working on back end applications.

• Modifying shell scripts and Perl scripts

The process includes calculation and payment of dividend to all the sales representatives who are involved in selling the products of HP all over the globe. Omega deals in all the currencies and omega cycle is run every month for calculation of dividend for all sales representatives.

ENVIRONMENT: oracle 9i, Internet Explorer 6.0., PL/SQL, OSF1 Alphas, TOAD 7.5.2.0, BO 6.5, Perl scripts, awk etc

09th of August 2006 till 10th of July, 07: Senior Systems Engineer, MPHASIS an HP Company, Bangalore, India

• As part of five members team worked as a Module Leader for Tyco Electronics Data warehousing team

• Writing PL/SQL scripts, packages, procedures and functions. Working on back end applications.

• Writing shell scripts which in turn call the load, validate populate and extraction procedures.

The process includes loading, validating and populating the data from a flat file into the database (called as ADR) and then extracting the relevant information onto a flat file from the database (called as PDR) using shell scripts which in turn calls PL/SQL packages ,procedures and functions

ENVIRONMENT: oracle 9i, Internet Explorer 5.0., PL/SQL, HP-UX V11.x, Editplus2, TOAD 7.5.2.0, VSS, P-IV, DAF Tools (DAF REGISTRATION Application and DAF Batch Console), File Transfer Service tool, CMG, Action Remedy tool, TextPad 4.7.3 32 bit edition, PrimoPDF, Maestro Job Scheduler etc

06th of July 2005 till 7th of Aug, 2006: Senior Systems Engineer, MPHASIS an HP Company, Bangalore, India

• As part of ten members team worked as a Project leader for Billing and Rating team of NEXTGEN 2.0 Billing system in telecom domain and it included analysis and modification of existing Nextgen 2.0 BILLING SYSTEM

• Wrote PL/SQL scripts, packages, procedures and functions. Working on back end applications.

• Fixed CR’s received from onshore

ENVIRONMENT: oracle 9i, Internet Explorer 5.0., PL/SQL, SCO UNIX REL 5.0, Editplus2, TOAD 7.5.2.0, MVS, CICS,COBOL, StarTeam 6.0,Visio 2003, DELL IV

10th of Jan 2005 till 15th of June, 2005: Senior Systems Engineer, MPHASIS an HP Company, Mumbai, LBP, India

• As part of 10-members team working for Wells Fargo bank (a USA based bank) for wholesale banking project and it includes analysis of AS IS documents and writing pl/sql scripts, packages, procedures and functions. Worked on back end applications.

• Wrote shell scripts for daemon processes and for calling oracle procedures through shell scripts

• Front end is My Customer View(MCV) through which data is visible/editable at the various levels

ENVIRONMENT: oracle 9i, Internet Explorer 5.0., PL/SQL, SunOS 5.8, Editplus2, TOAD 7.5.2.0, VSS (Visual Source Safe) tool for version control, My Customer View

2nd of Dec 2004 till 5th of Jan 05: Senior Systems Engineer, MPHASIS an HP Company, Bangalore, India

• As a part of 40-members team looking working for Data Warehousing practice and team called as BIPM TEAM spread across Bangalore and Mumbai and working for VISY pulp and paper(an Australia based company) project

• Wrote PL/SQL scripts

ENVIRONMENT: oracle 9i, Informatica 5.0, Internet Explorer 5.0., PL/SQL, TOAD 7.5.2.0

18th of Aug 2004 till 1st of Dec 2004: Senior Executive, 3i Infotech, Bangalore

• As a part of 20-members team and worked as a team lead for merging common changes in NEWTON Core Banking Software for various banks in India, Nepal and Thailand

• Enhancement in existing applications and development of new Pro*Cobol programs as ICICI-INFOTECH is coming out with a new base version of NEWTON CORE BANKING software

ENVIRONMENT: Newton 3.2.0.0(IMS Systems Banking s/w), Oracle 8i, HP-UX 11i, Red Hat 7.0, Pro*COBOL, Delphi 6.0, Benthic s/w: Golden: 32, the professional SQL tool for Oracle, Animator Tool for testing, Windows 2000 professional and P-IV Zenith, Internet Explorer 5.0

19th of May 2003 till 05th Dec 2003: Project Leader, GE Consumer Products, Bangalore, India

• As a part of two-members team looked after Order Entry module (part of commercial services) and its applications, which were, migrated from BULL to BULL EXIT

• Enhancement in existing applications on BULL and BULL EXIT

• Monitoring of the batch jobs along with their constraints on BULL

ENVIRONMENT: Oracle 8i, HP-UX V11.x, COBOL, Windows NT and P-IV DELL, CICS, Sametime Connect software

December 2002 till Jan 2003: Consultant, Maruti Udyog Ltd. (a Client of Binary Semantics Ltd.), Gurgaon, India

• As part of a 4-members team, responsible for requirements analysis and development of the Nagare Card System (a material management module and an ERP application)

• SQL reports generation using Forms 4.5 (CUI based)

• Developed the SQL scripts and forms through which the detail schedules can be calculated for each vendor so that inventory is always at its optimal value

• Less storage of Inventory and less transportation costs involved, efficient use of inventory

ENVIRONMENT: Oracle 8.i, AIX 3.1, T.O.A.D. IV, Windows 95 and Pentium.

Dec 2001 to June 2002: Consultant, Honda Siel Power Products Ltd, Rajendra Place, N.Delhi (a Client of TCS Delhi), India

• As part of a 15-members team, responsible for systems analysis and requirements of the client and developed the specifications, higher level design, lower level design, and development of a report (3.0) responsible for calculating the bonus for the various vendors of Honda Siel located in different parts throughout India

• The Project included the customization and writing new forms and reports in the ORDER MANAGEMENT module of Oracle Apps 11i implementation System

• This was the ERP product bought by Honda Siel Power Products Ltd from Oracle Corporation

• Also patches were applied in order to update the Oracle Apps system from 10.7 to 11.5.4. It was based on a 2-tier architecture , used utilities like ADADMIN, ADCTRL and ADPATCH

ENVIRONMENT: D2K 6i, Oracle 8.i, T.O.A.D. IV, Windows NT 4.0, Windows-95/98/NT and Pentium, Oracle forms and reports server, Tools like adctrl, adadmin, adpatch etc

Nov 2000 to Nov 2001: Consultant, Retek, Minneapolis, USA (a Client of TCS Mumbai).

• As part of a 5-members customer care level-1 team, responsible for problem analysis and replicating it in the various customized environments and suggesting out their solutions

• Retek markets the product RMS (Retek Merchandising System) and many other software of Oracle Corporation and takes care of various enhancements required by the client in the different versions of RMS. It is special software which accounts for various needs of goods, SKU’s etc at various stores and their placement with order and other shipping and cost attributes.

• Analysis of various problems rose by the different clients in different RMS versions and their solutions were suggested. Also used to do the GAP analysis for some clients

• This project was based on the retailing business and it was an ERP product and it was based on a 3-tier architecture

• I became PL in this project

ENVIRONMENT: D2K 6i, Oracle 8.i, T.O.A.D. IV, Windows NT 4.0, Windows 98, 2000 and Pentium, Oracle forms and reports server, Pro*C, Unix, Tivoli and Web Browser, RMS 7.0, RMS 8.0, RMS 9.0, RMS 10.0 .

Aug 2000 to Sept 2000: Consultant, CIMA-IBIS project (Certified Institute for Management Accountants Integrated Business Information System), CIMA is a client of TCS Delhi, based in UK.

• As part of a 2-members team, responsible for analysis and writing the scripts for the data migration

• CIMA is a body, which was interested for the global software on the web for the new entrants throughout the world

• Wrote the data migration scripts from the legacy system to the new system

ENVIRONMENT: D2K (Forms 5.0 and reports 3.0), PL/SQL, Oracle 8.i, Windows 95, T.O.A.D. IV, Windows NT 4.0, Pentium, RS-6000

Apr 2000 to July 2000: Consultant, P&ONL DRS project (Application Support Team), (Client of TCS Delhi), New Jersey, USA.

• As part of a 10-members team, responsible for analysis, maintaining and implementing the changes in the software on Forms 3.0 as required by the client

• Responsible for analysis, support and changing the Forms and the Pro *C code as per the changes required by the client

• Worked on Forms 3.0 and solved many problems related to enhancement in various forms

ENVIRONMENT: Forms 3.0, PL/SQL, UNIX, AWK, C Oracle 7.3.2, Windows 95, Pro*C, RS-6000

Oct 1999 to March 2000: Consultant, P&ONL DRS project (Technical Support Team), (a Client of TCS Delhi), London, UK.

• As part of a 7 members team, responsible for analysis, manipulation, monitoring, set up, installation of BRF Jobs on RS-6000 through a job scheduler JS-6000 through which jobs are submitted and BRF (Batch Request Facility) was the front end of the Job scheduler

• Also solved a couple of problems of the BAS module

ENVIRONMENT: Forms 3.0, PL/SQL, UNIX, AWK, C, Oracle 7.3.2, Windows 95, Pro *C, Perl, RS – 6000, PENTIUM

Nov 1998 to Sept 1999: Consultant, UTI Project (ULIP and US-64 schemes, a Client of TCS Delhi), Gulab Bhawan, New Delhi

• As part of a 5-members team, responsible for analysis, development, testing and implementation of the payment and financial management system for both the schemes of UTI

• UTI is a leading financial institution in India. ULIP and US-64 are the tax saving schemes of UTI. These schemes are unit based and covers life insurance and income tax benefits under section 90-L. The application software was developed in COBOL and UNIX AIX 3.1 by TCS

• Tax calculation, software maintenance and developed a few new applications in COBOL and UNIX to account for changing needs of the client

• Worked as Module Specialist

• The VAX developed software was customized according to the present system of COBOL

ENVIRONMENT: UNIX, AWK, C, Windows 95, COBOL, RS – 6000, PENTIUM

Oct 1998: Consultant, Income Tax Department, Implementation Project (a Client of TCS Delhi), Meerut, India

• As part of a 1-member team, responsible for analysis, testing and implementation of the IPAN software for calculating the Income Tax and verifying the people along with photographs and their signatures

• I was the sole person to handle the changing needs of the client. I had to troubleshoot any problem related to software starting from its implementation to any functional query. Starting and mounting the D/B on RS 6000 and helping the client by writing the SQL queries in order to process the information received from various centers distributed throughout in India

ENVIRONMENT: UNIX, Oracle 7.3.2, D2K (Forms 5.0 and Reports 2.5), Windows 95, RS – 6000, PENTIUM, Forms and reports Server

May 1997 to Aug 1998: Consultant, P&ONL DRS project (Product Support Team, a Client of TCS Dehi), New Delhi, India.

As part of a 100-members team, responsible for analysis, development, testing and implementation of the DRS (Documentation and Revenue System) system in India, UK, Australia and USA

• It was a maintenance project. I worked in the BOK (Booking) module (Product Support Team), which included fixing PR’s and CR’s. Then I worked in the Archival Module in the development team where the new programs were created using the new specifications

• Writing specs, coding, debugging and testing of software were the processing schedules. After that I worked in the Dancarg Module in which again there was a fresh development. After that in FORCO Module in the time of crisis. After that I worked in the VESPORT Module In, which I worked on Forms 3.0

• P&ONL are the largest company in shipping business and have got a worldwide network. DRS is an application S/W to meet the client’s business needs. It was originally written on AS/400 and then it was ported to UNIX based system AIX 3.1

ENVIRONMENT: Forms 3.0, PL/SQL, UNIX, AWK, C, Pro*COBOL Oracle 7.3.2, Windows 95/98/NT, Pro*C, Perl, RS – 6000, PENTIUM

Special Tools like MAKEDRS, XPRTF, XDSPF and XPFLF were also used

TRAINING RECEIVED: -

Year Title Location Org by

Mar-Jun ‘97 TCS: LEVEL – 1 TRAINING TCS – Delhi TCS

Aug ‘ 98 WINDOWS SDK PROGRAMMING TCS-Delhi TCS

May ’ 1999 ORACLE 7.0 & 8.0,DESIGNER 2000,

FORMS 4.5 & 5.0 & JAVA TCS – Delhi TCS

Jan ’ 2000 Business English Certification Course (BEC-2) TCS-Delhi TCS

Oct ’ 2000 RMS (Retek Merchandising System) TCS-Mumbai TCS

June ’ 2002 Oracle 9i DBA SQL STAR INTERNATIONAL, Delhi Self Managed

Aug ’ 2003 Six Sigma GE Consumer Products Bangalore GE Consumer Products

Jan’04-Feb’ 04 D2K 6i(Forms and reports) and PL/SQL SQL STAR INTERNATIONAL, Bangalore Self Managed

Mar’04 –Apr’04 COBOL, JCL, CICS, SAM, REXX, PL/1, ASSEMBLER, IMS DB/DC, DB2 7.0

ARCUS Technologies ,Bangalore Self Managed

Aug’04 OOAD Bangalore 3i Infotech

Oct’05 Billing System NextGen 2.0 MPHASIS BFL LTD, Bangalore Mphasis

Sept’ 07 Oracle 10g San IT Solutions, Bangalore Capgemini

Mar’08 Informatica 7.1 Bangalore Capgemini

Mar’08 BO 6.5 Bangalore Capgemini

Dec’08 MOSS 2007 Bangalore Capgemini

Aug’09-Sep’09 ARISg Training Bangalore Arisglobal

Jan’10 PMP Training IKOMPASS, Bangalore Self Managed

May’10-Jun’10 Java Level I &II Training Systems Domain, Bangalore Self Managed

TCS: LEVEL – 1 TRAINING

Year Title Location Org. by

1997 Graphical User Interface Delhi TCS

1997 Data Communication & Networking Delhi TCS

1997 Object Oriented Methods / Programming(C++) Delhi TCS

1997 Effective Technical Writing Delhi TCS

1997 Effective Presentation Delhi TCS

1997 Working in Team Effectively Delhi TCS

1997 Data Base Management Systems Delhi TCS

1997 QMS/ISO Delhi TCS

1997 Testing & Debugging Delhi TCS

1997 Review, Walkthrough & Inspection Delhi TCS

1997 Software Design Overview Delhi TCS

1997 Requirements Engineering Delhi TCS

1997 Software Development Process/ Maintenance Delhi TCS

1997 UNIX & C Delhi TCS

1997 Systems Engineering Delhi TCS

MPHASIS : LEVEL-1 TRAINING:

2005 QIP Bangalore MphasiS

TRAINING GIVEN:

Year Title Location Org By

Oct ’99 RDBMS TCS-Trivandrum TCS

Oct ‘99 UNIX TCS-Gurgaon TCS

Dec ‘04 ORACLE 9i features MPHASIS BFL LTD –Bangalore MPHASIS

Aug’05 PL/SQL MPHASIS BFL LTD – Bangalore MPHASIS

CERTIFICATE OBTAINED:

I have cleared the Oracle SQL 9i (part of OCA ) with 100% marks.

PERSONAL DETAILS:

Date of Birth 10-05-1973

Sex Male

Marital Status Married

Nationality INDIAN

Passport No. J0788204 valid till 23/6/2020

Email id e3efig@r.postjobfree.com

Permanent address for correspondence H.No.2519-A, Gill Colony, Near Krishna Sweets Workshop, Saharanpur U.P., PIN-247001, Phone No. 013*-******* begin_of_the_skype_highlighting              013*-*******      end_of_the_skype_highlighting begin_of_the_skype_highlighting              013*-*******      end_of_the_skype_highlighting

Local address for correspondence B-504, Aisshwarya Excellency, Opp TIN Factory, KR Puram, Old Madras Road, Bangalore-16, Mo: 098********

Place: Bangalore

Date 02-Jul-10 (ASHISH KUMAR JAIN)

End of Resume

*************

Contact this candidate