Chittaranjan Tandel OBJECTIVE

(1)

Chittaranjan Tandel

E-mail

§

[email protected]

Website

§

in.linkedin.com/pub/chittaranjan-tandel/b/612/882/ Phone

§

+919953945749

Address

§

40/1,East Patel Nagar, New Delhi-110008, India

OBJECTIVE

Intend to build a career with leading corporate of hi-tech environment with committed & dedicated people, having excellent inter-personal skills, dedication and professionalism, seeks to enhance self-growth and contribute to the growth and development of the organization.

PROFESSIONAL SUMMARY

·Total 8 years of Industry experience, good exposure on full life cycle implementation and error free maintenance of the system. Expertise in requirement gathering through Interview users to identify requirements and GAP analysis.

·Worked as a PL/SQL developer for a Debit Card Reconciliation System, the activities of DCRS involves in identifying various raw files like Switch, Branch (Finacle) files, MasterCard, NFS etc. These files are configured, processed and stored in the database. Also the transactions from different sources are Compared to verify whether the transactions are successful or unsuccessful (two or three way reconciliation). Also Accounting is done to determine the aggregate fees paid to various mediators like Visa and maestro. Various types of reports are generated as per need of the bank through front end and Back End Query Configuration. System is also used to handle the disputes from charge back (Issuer/Acquirer), CRM module, Cash in ATM Recon.

·Involved in the Post-implementation support and maintenance & Provide day-to-day support to users to ensure that issues do no longer exist.

·Worked as an Onsite resource for 27 months. Automated recurring issues, Involved in weekly meetings with Bankers, provided trainings to team members.

·Expertise in writing Scripts, Execution, Defects identifying, Defect tracking, as well as customization knowledge. Good collaboration skills in working with functional teams, other development resources, Basis support staff, business team leads, and business end users.

·Worked on many business processes like, Work flow management, Profit and Loss, Balance Sheets, Cash/Bank Fund flows, and General ledger.

IT SKILLS

IT Skills:

Lang uag es : Oracle (SQL/PLSQL), UNIX, LINUX,HTML,CSS database : Oracle9i,10g,11g, Ms-Access

Operating Systems : MS-DOS, Windows XP, Red Hat Linux, UNIX, IBM AIX.

(2)

ForYouandMe Online Services

October 2012 — Present

Financial Software & Systems Pvt Ltd

August 2011 — Sep 2012

InSolutions Global Pvt Ltd

May 2005 — July 2011

Computer Applications : Ms-Word, Ms-Excel, Ms-Access, PowerPoint, BUSY, Internet. Concepts :PL/SQL concepts like Performance tuning, Procedure, Functions, Packages,

Triggers, Cursor, Ref Cursors, Collections etc.

WORK EXPERIENCE

Senior Software Engineer

Exclusive online store that brings Pakistani fashion across the globe. Shop online from us for designer Pakistani suits, trendyfashionjwellery, latestfashion dresses from the house of Pakistani couture,designer suits,lawn silkcotton suits, long anarkali suits,unstitched dress materials, printed unstitched fabrics for girls & women. Our collection is perfect for every occasion - festive wear, party wear or a casual outing.

Roles & Responsibility:

1.Working as a ‘Senior Software Engineer’, was into development team size of 2. 2.Working as a Web Designer developing Html pages as per the requirement. 3.Maintenance of Website.

4.Functional and Technical testing of system.

Senior Software Engineer

Description: Merchant Acquiring Payment System(MAPS) is used to Reconcile the transactions which

takes place on the various POS Terminals ,POS (Point Of Sale) machines .Various Raw files like Switch , ,MasterCard , VISA , are Configured ,processed and stored in the database. Also the transactions from different sources are Compared to verify whether the transactions are successful or unsuccessful (two or three way reconciliation). Also Accounting is done to determine the aggregate fees paid to various mediators like Visa and maestro. Various types of reports are generated as per need of the bank through front end and Back End Query Configuration. System is also used to handle the disputes from chargeback (Issuer/Acquirer), CRM module and GEFU Generation.

1.Worked as a ‘Senior Software Engineer’, was into development team size of 3 for HDFC Bank.

2.Worked as a senior PL/SQL developer in developing code based on RFCs, by writing stored procedures, packages, triggers, cursors, Ref cursors.

3.Testing of file processing from System to Debug the Oracle Errors. 4.Performance Tuning Of Queries and Procedures.

5.Functional and Technical testing of system for various Reports. 6.Generations of Release scripts on Unix for UAT and Production. 7.Onsite Deployment and Implementation of System.

Team Lead(Product Development)

(3)

1. Project Experience:

·Project T itle : Debit Card Reconciliation System. ·Client : Punjab National Bank.

·Project T ype : Development.

·Environment : Oracle 10g r2, Oracle PL/SQL Toad, Linux As4. ·Duration : 2 Yrs 3 Months.

·Location : New Delhi.

Description: Debit Card Reconciliation System is used to Reconcile the transactions which takes place on the various ATM’s as well as on POS (Point Of Sale) machines .Various Raw files like Switch , Branch(Finacle) files ,MasterCard , NFS , are Configured ,processed and stored in the database. Also the transactions from different sources are Compared to verify whether the transactions are successful or unsuccessful (two or three way reconciliation). Also Accounting is done to determine the aggregate fees paid to various mediators like Visa and maestro. Various types of reports are generated as per need of the bank through front end and Back End Query Configuration. System is also used to handle the disputes from chargeback (Issuer/Acquirer), CRM module and CASH IN ATM Reconciliation.

1.Worked as a ‘Team Lead’, leading complete DCRS Module for PNB.

2.Worked as a senior PL/SQL developer in developing code based on RFCs. 3.Gap Analysis Of various Input Files Required for Reconciliation.

4.Back End Configuration of Raw files in various Tables. 5.Preparing Queries For Reconciliation with Relax Parameters. 6.Testing of file processing from System to Debug the Oracle Errors.

7.Preparing Procedures/Functions for Non-Configurable Modules of System. 8.Performance Tuning Of Queries and Procedures.

9.Functional and Technical testing of system for various Reports. 10.Generations of Release scripts on Linux for UAT and Production. 11.Onsite Deployment and Implementation of System.

12.Project Experience:

·Project T itle : Debit Card Reconciliation System. ·Client : ABN AMRO Bank

·Project T ype : Development.

·Environment : Oracle 10g r2, Oracle PL/SQL Toad, Linux As4. ·Duration : 6 Months.

·Location : Mumbai (offsite).

1.Worked as a ‘Software Engineer’, for DCRS Module.

(4)

3.Back End Configuration of Raw files in various Tables. 4.Preparing Queries For Reconciliation with Relax Parameters.

5.Involve in weekly meeting with Bankers regarding the development status. 6.Testing of file processing from System to Debug the Oracle Errors.

7.Preparing Procedures/Functions for Non-Configurable Modules of System. 8.Performance Tuning Of Queries and Procedures.

9.Functional and Technical testing of system for various Reports. 10.Generations of Release scripts on Linux for UAT and Production.

·Project T itle : Debit Card Reconciliation System. ·Client : Allahabad Bank

·Project T ype : Development/Maintenance.

·Environment : Oracle 9i, 10g r2, Oracle PL/SQL Toad, Linux As4. ·Duration : 1 Yr 3 Months.

·Location : Mumbai (onsite).

2.Worked as Pl/Sql developer for preparing adhoc reports required by bank. 3.Involved in meetings with banker regarding the new RFC/changes in system. 4.Performance tuning of Queries and Procedures.

5.Support and maintenance & Provide day-to-day support to users to ensure that issues do no longer exist. 6.Backup of Database and maintaining code version in Microsoft VSS.

·Project T itle : Debit Card Reconciliation System. ·Client : Central Bank of India.

·Project T ype : Development/Maintenance.

·Environment : Oracle 10g r2, Oracle PL/SQL Toad, Linux As4. ·Duration : 1 Yr.

·Location : Mumbai (onsite).

2.Worked as Pl/Sql developer for preparing adhoc reports required by bank. 3.Involved in meetings with banker regarding the new RFC/changes in system. 4.Performance tuning of Queries and Procedures.

(5)

Bachelor Of Arts

July 2001 — March 2004

HSC

August 1999 — March 2001

5.Support and maintenance & Provide day-to-day support to users to ensure that issues do no longer exist. 6.Backup of Database and maintaining code version in Microsoft VSS.

·Project T itle: Debit Card Issuance System/Credit Cards Division. ·Client: BOBCARDS LTD(Wholly Own Subsidiary Of BOB)

·Period: 1 yrs 5 months. ·Location: Mumbai.

1.Worked in Operations team of Bank.

2.ATM Pin Generation, Data Entry of New Card Holders.

3.Data Entry of Payment Received for all Credit cards Of Bank of Baroda.

QUALIFICATIONS

Academic Qualification:

BA Second class from Mumbai University(Elphinstone Colleg e) Mar 2004. HSC Second Class from Elphinstone Colleg e in Feb 2001.

SSC from Bharda New Hig h School (Mumbai Divisional Board) in Mar 1999. Professional Qualification:

Oracle Certified Professional from Oracle in Feb 2010.

Diploma In Computer Hardware & Maintenance from Kohinoor T echnical Institute Mumbai in Dec 2003. MS-CIT from Maharashtra Knowledg e Corporation Limited(Maharashtra State Board of T echnical Education) in Jun 2003.

EDUCATION

University of Mumbai

Obtained the BA degree with Second Class

Mumbai Divisional Board

Obtained HSC with Second Class

INTERESTS

Tech Savvy,Music,Cricket,Swimming

(6)

Mr Hardeep Singh 40/1,East Patel Nagar, New Delhi-110008 M: +919818157203

PERSONAL DETAILS

Personal Details:

Date of Birth : 6th March, 1984 Marital Status : Married. Nationality : Indian. Gender : Male.

Languages Known : English, Hindi, and Marathi.

Permanent Address : H-206, Siddhivinayak Residency, Shill Road,

Chittaranjan Tandel OBJECTIVE