PROFESSIONAL SUMMARY

I seek a position as a Developer/Analyst. I design, implement, tune and support database system. I also analyse the process of business to make it efficient for firm. I am a valuable asset to a project team as a designer and developer.

• Developer with 4 years of progressive experience in Analysis, Design, Development, Maintenance and Enhancement of commercial and business applications.

• Worked extensively in the field of Banking and Finance domain for Retirement Services.

• Have the knowledge of complete book hierarchy (Source to Ledger to Legal Entity)

• Have knowledge of complete flow of books in finance.

• Have knowledge of Private banking party system.

• Have profound Knowledge of Equity Markets, Clearing and Settlements domain.

• Have profound knowledge of Sybase 12.5/15, Oracle 9i/10g, Core Java, UNIX, XML/XSLT, VISIO, Erwin, ETL Tools.

• Have worked as Designer and Developer in number of Applications and Extracts.

• Hands on experience in the life cycle of Software Engineering – Requirements Analysis, Design, Development, Enhancement and Testing.

• Worked for around 6 months in Production support also.

• Hands on experience in TSQL/Data objects tuning for better performance.

• Have worked on CA Job scheduler.

WORK EXPERIENCE

• Working as a ‘Software Engineer’ in RBS India Development Centre, Gurgaon, India since Sept’10 to Present.

• Worked as an ‘Application Developer’ in JP Morgan, Mumbai, India since Jan’10 to 3rd Sept’10.

• Worked with Infosys Technologies LTD, Hyderabad, India as a ‘Software Engineer’ from Jan’08 to Dec’09.

• Training in SQL Star International New Delhi on Oracle 9i (SQL, PL/SQL, Forms & Reports).

STRENGTH

• Has worked on multiple languages like T-SQL, Core Java, PERL, SQL and PL/SQL, Shell scripting.

• Has good experience on Sybase ASE 12.5/15 and UNIX Tru64.

• Has worked on CA and autosys job scheduler.

• Has profound knowledge of database objects.

• Has a good skill in converting business problems into technical solutions.

• Strong interpersonal and communication skills with ability to maintain effective working relationships.

• Has good ability in learning new things and applying them at work.

TOOLS & TECHNOLOGIES

• Programming area - T-SQL, Core Java, PERL, SQL and PL/SQL, Shell scripting.

• RDBMS - ASE Sybase 12.5/15, Oracle 9i/10g.

• Web Related Tech - Java Script.

• Operating System - Windows 98/XP/2000/2003, Compaq UNIX Tru64 5.1.

EDUCATION

• B.Tech (Bachelor of Technology (Computer Science)) with 70%.

CERTIFICATION

• Oracle 10g DBA OCA with 98%

• Oracle 9i SQL with 99%.

• Oracle 9i PL/SQL with 88%.

• Oracle 9i Forms with 93%.

• Infosys Entry Level training (Duration – 2.5 Months) in Java.

ACHIVEMENTS

• Nominated for Wachovia R&R awards for Developer category.

• Awarded by ‘Person of the Quarter Award’ for remarkable performance in project.

• BCM MVP (Most Valuable Project) team award for Strategic partnership in H2 FY08.

PROFESSIONAL EXPERIENCE

Organization : RBS Gurgaon, India.

Duration : Sept’10 – Till Date

Role : Software Engineer

Project Details:

1. Static Data Mart (Sep’10-Till date)

Static data mart is a golden source of reference data for all the trading happened in real scenario. In SDM all the static information about the counter parties are being held, data is coming from upstream and being loaded to SDM. Its also being sent to downstream for their reference. The data use to come in form of flat files and being loaded using Sybase procedures. Extracts are also use to be generated on requirement basis.

Technologies Used: Sybase 15, Shell Scripting, Java, XML/XSLT, and Menu Tool (RBS Internal Job Scheduler).

Operating Systems: Windows XP, UNIX Tru64 5.1.

My Contribution:

• Requirement Gathering from Business people / Data control team.

• Preparation of Technical Specification document, Impact Analysis document and Test Plan.

• Developing application including consideration of high performance.

• Unit testing, integration testing and Bug Fixing.

• Maintaining the project against the guidelines provided by the Business people.

• Tuning of the existing and new created procedures.

Organization : JP Morgan, Mumbai

Duration : Jan’10 – 3rd Sept’10

Role : Application Developer

Project Details:

2. Morgan Markets Ratings Load (Apr’10-Aug’10)

Till date, there was a feed (Excel sheet) which was being loaded manually; this project is to make that feed automated. The excel sheet is being loaded to a defined folder. That folder has been mapped with UNIX directory and from there the file is being loaded. All the jobs for this project are being scheduled in CA job scheduler.

3. Third Party Custodian Data Migration (Jan’10-Apr’10)

In this migration, the third party custodian data is coming from One system(OMNI) through flat files, that data is being BCPed into work tables and then being loaded into database using ETL(ACD process). Then from there, the data is being propagated into other database to use in blotter reports. All the jobs for this project are being scheduled in CA job scheduler.

Technologies Used: Sybase 12.5, Shell Scripting, Perl Scripting, CA Job Scheduler.

Operating Systems: Windows XP, UNIX Tru64 5.1.

My Contribution:

• Requirement Gathering from higher management for Development and Enhancement.

• Preparation of Technical Specification document, Impact Analysis document and Test Plan.

• Developing application including consideration of high performance.

• Unit testing, integration testing and Bug Fixing.

• Maintaining the project against the guidelines provided by the higher management.

Organization : Infosys Technologies Ltd, Hyderabad.

Duration : Jan’08 – Dec’09

Role : Software Engineer

Client : Wachovia Bank Ltd. (Wells Fargo Bank)

Project Details:

4. NowTrac(K)-401(K) Application (Mar’08 – Dec’09)

NowTrac(k) is a surrounding application suite to the Wystar core consisting of 23 applications. It was developed as “internal” application which is used by business people within Wachovia network and has access to the Wystar Databases. This application provides the interface to multiple activities related to Cash management, Fees, Advice track, Confirms and Plan Setup.

5. Wystar Extracts (Mar’08 – Dec’09)

Wystar extracts are used to generate reports to update/synchronize the system for all types of transaction and other activities related to Plans/Participants. These are Auto triggered jobs scheduled on daily/Weekly/Monthly/yearly basis. These extracts are also used for third party vendors DUC/Newkirk for distribution to plan sponsor and participants.

6. Reverse Feeds for Allegiant (Oct’08 – Apr’09)

Reverse feeds are the regular feeds sent to Plan Sponsor consisting of deferral changes or suspension details of participant to fund. This is regular scheduled job from which plan sponsor keep tracks of the employee contribution to 401(K) plan to be deducted from payroll.

7. NowTrac(k) – Advice Track Development (July’08 – Sep’08)

and Maintenance

Advice Track is a program offered for 401k plan participants with Wachovia, to manage their stocks better. Each participant who opts for this program gets an advice from Morning Star Corporation for maintaining his portfolio. In accordance with that advice Wachovia bank would invest the balance of the participant to get the best returns possible.

The project consists of designing jobs for:

• Automating the process of Sending the investment portfolio information to Morning start Corp.

• Receipt of Advice for the participants from Morning star side.

• Defaulting a participant into Advice track program.

8. NowTrac(k) – Reporting Development & Maintenance (Mar’08 – June’08)

The project requires the development and maintenance of business reports. Various departments in Wachovia retirement service personnel deal with around 200 reports. The reports could be used for:

• Getting the demographic data of the participants

• Transactions of the entire participant or a single participant done in a certain time frame.

• Performances of the stocks in which the deferral amounts have been invested in.

These reports are made in Crystal reports format and ran by scheduler at the present time. A front end also exits, which enables business users themselves to execute any reports at anytime.

My Contribution:

• Requirement gathering from client.

• Designing and creation of reports using crystal reports tool.

• Generation of Sybase stored procedures which contain the core business logic or tuning the procedures for better performance.

• Bug fixing of reports showing wrong data.

• Adhering to standards of coding and configuration management.

• Documentations as Technical Specifications and Impact analysis.

• Unit test plans and Unit testing.

Technologies Used: Crystal Reports 11, Sybase ASE 12.5, Shell Scripting, Perl Scripting, Core Java.

Operating Systems: Windows XP, Unix Tru64 5.1.

PERSONAL DETAILS

• Date of Birth : 20.06.1987(DD.MM.YYYY)

• Nationality : Indian

• Gender : Male

• Marital Status : Un-Married

Mohit Kumar

+91 - 742-***-****

Contact this candidate