ASHISH KUMAR JAIN Email acthn3@r.postjobfree.com

Mobilie 91-984*******

Oracle, Pl/sql, Unix, Perl, Shell Scripting, D2K, DWBI Consultant

Executive Profile

An IT professional with 16+ years of experience.

Expertise in programming using Oracle, SQL, PLSQL, UNIX, Shell Scripting, ETL, DWBI, SED,AWK, PERL, Oracle Performance Tuning, sql server, D2K 6i,10g, COBOL, Pro*COBOL, Pro*C, SSRS, Hyperion, SQR .

Cohesive Team Player with self motivation and strong leadership skills.

Strong problem solving, managerial, presentation and communication skills.

Career Graph

As Lead Consultant at Indecomm Global Services, Bangalore, India, [Feb 2011 – Jun 2015]

As Consultant at Xchanging Software Pvt. Ltd, Bangalore, India, [Oct 2010 – Dec 2010 ] on contractual basis

As Team Leader at Arisglobal Software Pvt. Ltd, Bangalore, India, [Jun 2009 – Jan 2010 ]

As Senior Consultant at Capgemini, Bangalore, India, [Jul 2007 – May 2009 ]

As Senior Systems Engineer at Mphasis, Bangalore, India, [Dec 2004 – Jul 2007 ]

As Senior Executive at 3I Infotech, Bangalore, India, [Aug 2004 – Nov 2004 ]

As Systems Analyst at GE Consumer Products, Bangalore, India, [May 2003 – Dec 2003 ]

As Consultant at Binary Semantics Ltd, Gurgaon, India, [Dec 2002 – Feb 2003] on contractual basis

As IT Analyst at Tata Consultancy Services, New Delhi, India [Mar 1997 – June 2002]

Overseas Assignments

UK Project Experience

1 UK Assignment

US Project Experience

2 US Assignments

Technical Skills

Languages

Primary: UNIX, Shell Scripting, SED, AWK, Perl, Oracle SQL /PLSQL, COBOL,

Secondary: XML, D2K,Pro*COBOL, PRO*C,SSRS,SQR,SQL SERVER, XML, Forms 3.0, D2K 5.0, 6i, 10g, Oracle Forms 4.5, Oracle Reports 3.0, 6i

RDBMS – Oracle 7i, Oracle 8i, Oracle 9i, Oracle10g, Oracle11g, sql server

Domain/s - Insurance, shipping, financial management, engineering, tax calculation, incentives calculation, ERP, retailing, material management, telecom billing, inventory planning, forecasting, advertisements billing, mobile advertising and manufacturing

Work Experience

INDECOMM GLOBAL SERVICES,BANGALORE, INDIA - [Feb 2011 – Jun 2015]

Project(s) Handled:

MSA- ISMnow (USA).

oAdvertisements scheduling and billing via Gabriel application.

oWorked on SSRS module for generating the reports. SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft Corporation

oSetting up of summary database

oWorked on SSRS module for generating the reports. SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft

Comscore Corporation (USA).

oGeneration of data migration reports on monthly basis.

oChecked the data and generating the reports on daily basis.

oMonitored the daily job scripts for various clients like Tmobile, Vodafone, Orange and O2.

oWrote PERL scripts for various jobs which runs daily, weekly, monthly and yearly.

Sony Corporation (USA).

oChecking the data quality every week once.

oTroubleshooting various problems related to performance issues

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of Oracle procedures, functions and packages and doing performance tuning

Providing Technical Guidance to the team members.

Participate in Reviews, verification of fixes in daily scrums with client

Accomplishments:

I was solely responsible for development and testing of various Oracle procedures/packages for production module. The PERL scripts were written in a very short span of time for the various jobs which used to run daily, weekly, monthly and yearly.

Project Type: Product Maintenance.

Role: Lead Consultant

Team Size: 5 - 15

Environment: Oracle 10g, oracle 11g, Internet Explorer 10.0., Gabriel 5.12.2, PL/SQL, SQR, SQL Server 2008, Business Intelligence Development Studio 2010 and 2008, SSRS, XML 1.0, Hyperion 8.5, SQL Developer 1.5, VSS etc

XCHANGING SOFTWARE PVT LTD,BANGALORE, INDIA - [Oct 2010 – Dec 2010]

Project(s) Handled:

Ovation Kangaroo (Australia).

oInsurance domain project dealing with performance related issues of various applications

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of Oracle procedures, functions and packages and doing performance tuning

Providing Technical Guidance to the team members.

Accomplishments:

I was solely responsible for development and testing of various Oracle procedures, packages and worked as a technical consultant for Policy Team. I was also involved in performance tuning of applications dealing with bulk data. I performance tuning some applications which were running slowly

Project Type: Product Maintenance.

Role: Lead Consultant

Team Size: 25

Environment: Oracle 9i, oracle 10g, Internet Explorer 6.0., PL/SQL, Unix, D2K 10g, TOAD 7.5.2.0 etc

ARISGLOBAL SOFTWARE PVT LTD, BANGALORE, INDIA - [Jun 2009 – Jan 2010]

Project(s) Handled:

Proserve Team.

oA pharmacovigilance domain project dealing with customization of various newly developed front end screens

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of Oracle procedures, functions and packages and doing performance tuning

Developing and customizing new screens for ARIG application

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

Accomplishments:

I was solely responsible for development and testing of various Oracle procedures, packages and worked as a TEAM LEADER for Proserve Team. I Worked on data migration scripts for various clients like Takeda, Teva, Guerbet etc. I also worked on developing the new screens and their customization for Arisg application for various clients like Lundbeck, Health Canada, Forest Labs etc

Project Type: Product Maintenance.

Role: Team Leader

Team Size: 30

Environment: Oracle 9i, 10g, Internet Explorer 6.0., PL/SQL, SQL developer, SQL*LOADER, PL/SQL Developer, Microsoft FRONTPAGE, VSS, JSP, HTML etc

CAPGEMINI,BANGALORE, INDIA - [Jul 2007 – May 2009]

Project(s) Handled:

Nor’easter (COEP/CPP modules) for the client Fairpoint (USA).

oProject deals with telecom billing as well as other aspects like inventory management.

oMonitoring jobs jobs and taking care of any day to day failures and maintenance etc

oWriting of Oracle procedures, functions and packages and doing performance tuning

oTroubleshooting various problems caused due to migration in other environments

Omega L4 (USA).

oCalculation and payment of dividends to all sales representatives .

oChecking the data and generating the reports on daily basis.

oMonitoring the daily job scripts for various clients like Tmobile, Vodafone, Orange and O2.

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of Oracle procedures, functions and packages and doing performance tuning

Writing unix shell scripts and also maintaining the existing applications

I also used to run batch jobs scripts and also used to load data using SQL*LOADER

Providing Technical Guidance to the team members

Participate in Reviews, verification of fixes in daily status update meetings with offshore team

Accomplishments:

I was solely responsible for development and testing of various Oracle procedures/packages for production module. Apart from that I was also involved in maintaining unix shell scripts and developing new shell scripts

Project Type: Product Maintenance.

Role: Lead Consultant

Team Size: 10-50

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,PVCS, Alphas, TOAD 7.5.2.0, BO 6.5, Perl scripts, awk etc

MPHASIS AN HP COMPANY,BANGALORE, INDIA - [Dec 2004 – Jul 2007]

Project(s) Handled:

TYCO Electronics (USA).

oWorked on solving Tyco Electronics Data Warehousing issues related to data migration.

oThe process involved ETL using staging table. The extraction of data using unix shell scripts, pl/sql procedures.

oThe 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)

Verisign (USA).

oThe project was meant for telecom billing. The process involved mediation, pre-rating, rating, and billing. The call detail record (CDR) was processed through the four processes and then used to get billed according to the rules and then invoice was sent to the various consumers

oWorked on PL/SQL scripts, packages, procedures and functions.

oFixing of CR’s received from onshore

Wells Fargo Bank (USA).

oIt was a wholesale banking project and it included analysis of AS IS documents

oWorked on writing pl/sql scripts, packages, procedures and functions. Worked on back end applications

oWrote shell scripts for daemon processes and for calling oracle procedures through shell scripts

oThe application had a front end view called as My Customer View(MCV), through which data was visible/editable at various hierarchy levels

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of Oracle procedures, functions and packages and writing shell scripts for daemon processes

Accomplishments:

I was solely responsible for development and testing of various Oracle procedures/packages for production module. Apart from that I was also involved in maintaining unix shell scripts and developing new shell scripts for daemon processes.

Project Type: Product Maintenance.

Role: Lead Consultant

Team Size: 15 - 30

Environment: oracle 9i, 10g, Internet Explorer 6.0., PL/SQL, SQL, Linux 2.6.18-128.el5PAE, PERL 5.8.5, sql server, Nexius JIRA, Task List Guru 2.306, VSS, MVS, CICS,COBOL, StarTeam 6.0,Visio 2003, 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 etc

3I INFOTECH PVT LTD,BANGALORE, INDIA - [Aug 2004 – Nov 2004]

Project(s) Handled:

3I Infotech (India).

oWorked on NEWTON core banking software system

oWorked as team lead for merging common changes in NEWTON Core Banking Software for various banks in India, Nepal and Thailand

oEnhanced Pro*COBOL programs as 3I Infotech came up with new base version of NEWTON CORE Banking software

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of Pro*COBOL programs and their maintenance and merging of changes and testing them

Providing Technical Guidance to the team members.

Accomplishments:

I was solely responsible for development and testing of various changes which were merged for the new core banking software

Project Type: Product Maintenance.

Role: Module Lead

Team Size: 20

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

GE CONSUMER PRODUCTS, BANGALORE, INDIA - [May 2003 – Dec 2003]

Project(s) Handled:

Order Entry module (USA).

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

oEnhancement in existing applications on BULL and BULL EXIT(Unix server)

oMonitored the batch jobs along with their constraints on BULL

Participated in Reviews, verification of fixes in daily status update meetings with offshore co-ordinator

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of COBOL programs and their maintenance by making changes and testing them

Accomplishments:

I was solely responsible for development, maintenance and testing of various changes which were made for the applications which were migrated on BULL EXIT

Project Type: Product Maintenance.

Role: Module Lead

Team Size: 2

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

BINARY SEMANTICS LTD, GURGAON, INDIA - [Dec 2002 – Feb 2003]

Project(s) Handled:

Nagare Card System (Maruti Udyog Ltd, India).

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

oSQL reports generation using Forms 4.5 (CUI based)

Responsibilities:

Requirement gathering and Technical Analysis.

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

Accomplishments:

I was solely responsible for development, maintenance and testing of various SQL reports for efficient use of inventory

Project Type: Product Maintenance.

Role: Module Lead

Team Size: 5

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

TATA CONSULTANCY SERVICES, NEW DELHI, INDIA - [Mar 1997 – Jun 2002]

Project(s) Handled:

Oracle Apps 11i Implementation (Honda Siel Power Products Ltd, INDIA).

oIt is a ERP product bought by Honda Siel Power Products from Oracle Corporation

oThe patches were applied in order to upgrade the Oracle Applications from 10.7 to 11.5.4. It was based on a 2-tier architecture, used utilities like ADADMIN, ADCTRL and ADPATCH

oAs 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

RETEK Minneapolis (USA).

oIt is an ERP product of Oracle Corporation. 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

oThe process involved 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

oAs 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

oI became PL in this project

UTI (India).

oUTI 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

oWorked on COBOL programs, shell scripting

oFixing of various issues on day to day basis

P&ONL (UK, USA).

oP&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

oWorked on writing Pro*COBOL programs, maintaining Forms 3.0. Also worked on back end testing of various applications after making changes

oWrote specs, coding, debugging and testing of software were the processing schedules.

Responsibilities:

Requirement gathering and Technical Analysis.

Solving technical problems in the day-to-day operations.

Writing of Pro*COBOL programs, writing shell scripts and worked on Y2K changes of VESPORT module, maintenance of Forms 3.0, writing of D2K 5.0 reports

Accomplishments:

I was solely responsible for development and testing of various Pro*COBOL programs for production module. Apart from that I was also involved in maintaining unix shell scripts and developing new shell scripts. Also worked on solving PRs and CRs

Project Type: Product Maintenance.

Role: Lead Consultant

Team Size: 15 - 200

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, UNIX, AWK, C, Windows 95, COBOL, D2K 5.0, 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 .

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

Personal Details

Education

: IIT, Roorkee, M.Tech(Industrial Metallurgical and Materials

Sciences),1995 - Jan’97

: MMM Engineering College, Gorakhpur, B.E.(Mechanical), 1991-95

Languages

Trainings

: English

: Hindi

: BEC-2, PL/SQL, JAVA, DBA 9i,SQL 9i,IBM Mainframes,

PMP, D2K 6i,Networking, ABAP/4, INFORMATICA 5.0, 9.6.1

SQL 9i exam (Part of OCA) cleared with 100% marks,

Six Sigma at GE Consumer Products, Bangalore,

Internal Quality Auditor(IQA) at IGS, Bangalore

I have given training on RDBMS at TCS,Trivandrum,

Oracle9i and Pl/sql, Unix at Systems Domain, Bangalore

I have taken interviews on oracle, pl/sql, unix,

shell scripting

Passport Validity

: valid till 23/6/2020

Marital Status : Married and having two kids

DOB : 10-MAY-1973

Place: Bangalore

Date :

(ASHISH KUMAR JAIN)

Contact this candidate