Tauseef Ahmad

E***, Rohan Tarang, Opposite Indian Oil Petrol Pump, Waked Pune 411057

Contact: +91-909*******; Email: ac89fs@r.postjobfree.com

Profile Highlight:

Oracle PL/SQL Developer - VirtusaPolaris (November 2015 – Till Date)

Total 7 years of experience in the IT Industry as a Software Developer

Expert proficiency in Oracle Database, PL/SQL, SQL, UNIX, Pro*C, C

Having database experience using Oracle 10g/11g, SQL, PL/SQL, Stored Functions, Procedures, Triggers, Exception Handling, Index, Views and Inline views, packages and dynamic SQL in PL/SQL.

Involved in Customer interaction for requirement gathering, demonstrations of designs of various modules and discussions on critical problems of Production Environment

Good understanding of Defect Prevention Strategies.

Involved in Maintenance and Production support.

TECHNICAL PROFICIENCY

Operating System: HP - UNIX 11i-v3, Windows 95/98/NT/2000/XP

Database Environment: Oracle RDBMS11g, Oracle RDBMS10g, Oracle RDBMS9i

Languages: PL/SQL, SQL, Pro*C, C

Tools: Telnet, SQL Developer, PLSQL Developer, Visual Source Safe, Edit Plus, Quest Toad 9.0, SQL*Plus

Special Software: RCS (UNIX)

PROFESSIONAL EXPERIENCE

VirtusaPolaris (formerly Polaris Consulting & Services Limited)

PL/SQL Developer Nov 2015 – Till Date

Project: GFDM (Global Financial Data Model), FRDM (Financial Reporting Data Model), RAY (Risk Authority)

Client: HSBC Technology and Services

Project Description: GFDM (Global Financial Data Model) and FRDM (Financial Reporting Data Model) are data warehouses, where all the feeds (or files) come from different trading source systems like Treat, Summit, Calypso, Impact etc. A feed represents important financial information of trading done on daily basis. After receiving files for respective system these feeds are being processed to keep trades into book entry form assigning ledgers to each trade and prepare data to be accessed by downstream systems for financial and regulatory purposes.

RAY is Risk Authority application that uses financial and regulatory data prepared by GFDM and FRDM to perform risk analytics and computation and calculate RWA (Risk Weighted Asset).

Work location: Pune

Designation: Team Lead

Significant Assignments and Responsibilities:

Development of code using PL/SQL, SQL and Unix scripting

Requirement gathering from Finance IT user team

Preparing design documents

Deployment of release in production

Involved in preparing architecture for FRDM (HSBC in-house application) and implementation in oracle which mimics RACE (licensed application – implemented Sybase) for regulatory purposes.

Tech Mahindra Limited

PL/SQL Developer June 2014 – Nov 2015

Project: MagNet [Managing Networks]

Client: O2-Telephonica (UK)

Project Description: This is a network inventory, planning and build application, comprises of 3 individual sections managing Transmission Lines (Magnet Lines), Core network planning (Magnet Plus) and Radio Networks planning and build (Magnet IPD).

Magnet lines application allows us to request and order transmission lines connection between two points.

This supports Finance team to manage the financial aspects of ordered lines such as reconciling invoices.

Magnet Plus is a planning tool which has been developed to enable the Core Network Plan and allocation of network element resources in the configuration of both the TAC and GSM networks.

Work location: Tech Mahindra Ltd. Hinjewadi, Pune

Designation: Senior Software Engineer

Significant Assignments and Responsibilities:

Development of code using PL/SQL.

Planning de-commissioning of Magnet Lines (one of the three component of MagNet application) application.

Prepared data synchronization interface from third party application.

Migration the existing data to another system.

Planning the steps behind migration of existing data to another system.

Infosys Limited

PL/SQL Developer December 2013 – May 2014

Project: Centralized Processing Centre (CPC) for Income Tax Returns

Client: Income Tax Department of India

Project Description: Enabling Centralized Processing of all E-filed Income tax returns and paper returns (Of Karnataka and Goa at Bangalore). CPC is a system driven process for determination, generation, issue, dispatch and credit of refunds and enables efficient and safe delivery of Income Tax refunds.

Work location: Centralized Processing Centre – Income Tax Department, Bangalore

Designation: Technology Analyst

Significant Assignments and Responsibilities:

Development of code using PL/SQL.

Involved in the continuous enhancements and fixing of production problems.

Involved in requirement gathering for system enhancements.

Created PL/SQL stored procedures, functions and packages to facilitate Indian citizens to update contact details, address and bank details even after filling the income tax return.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

CMC Ltd

PL/SQL Developer July 2010 – December 2013

Project: Central Depository Accounting Systems for Bombay Stock Exchange, India

Client: Centralized Depository System (India) Limited (CDSL)

Project Description: Central Depository Services Limited (CDSL) is the second Indian central securities depository based in Mumbai. Its main function is the holding securities either in certificated or uncertificated (dematerialized) form, to enable book entry transfer of securities along with opening demat account, pledge/unpledged against securities and generation of important reports related to transactions.

Work location: Bombay Stock Exchange, Mumbai

Designation: SeniorSoftware Engineer

Significant Assignments and Responsibilities:

Working on UNIX platform using languages like PL/SQL, SQL, C, pro*C and database as Oracle 10g, 11g.

Prepared design document for development of RGESS (Rajiv Gandhi Equity Saving Scheme) development.

Written codes for processing of files received from Exchanges (BSE & NSE) containing transaction values of RGESS transactions and respectively freeze that quantity for specified lockin period.

Written PL/SQL functions and triggers to generate report from report server (remote) while report setup is from main server.

Created SQL scripts and Shell scripts which provide a statistical data useful for preparing daily and monthly MIS reports

Created PL/SQL scripts for Inserting and Updating large amount of data to the Database

Working as a back-end Release co-ordinator

Handling critical key modules like OLIDT(Inter Depository Transfers), Signature Extraction, SMS, Reports etc. in the system

Developed fragment Scheduler programs that facilitate multiple instances of one program for report generation

Involved in development Signature Extraction of BO(Beneficiary Owner) for DP(Depository Participant) and RTA(Register Transfer Agent)

Involved in development DESTAT(Mutual Fund Demat), a requirement proposed by DP(Depository Participant) and RTA(Register Transfer Agent)

Developed program for generation of Random Audit Reports for Audit Department

Involved in DRS (Disaster Recovery Site) switching activity wherein the entire application is switched to the recovery site after which the system runs on the recovery site and then switched back to the main site

Handling the live problems occurring during settlement hours

Involved in Unit, Integrated and Benchmark testing. Preparing the necessary documents required as per the CMMI Level 5 standard. It includes preparation of Design Documentation, process Specification, Technical Manuals, Test plan etc.

Trainings and Awards:

Received “Special Appreciation Award” in 2013 from CMC Ltd

Induction Training at CMC House Mumbai (Duration: 3 days).

Oracle OCA Certification Program at CMC House Mumbai (Duration: 6 days).

EDUCATIONAL CREDENTIALS

B.E - Computer Science & Engineering (2010)

Rashtrasant Tukadoji Maharaj Nagpur University (RTMNU), Nagpur.

Higher Secondary School Certificate (12th) – Science (2005)

M. M. Rabbani Junior College, Kamptee Dist. Nagpur

Secondary School Certificate (10th) – Science (2003)

M. M. Rabbani High School, Kamptee Dist. Nagpur

Languages Known: English, Hindi, and Marathi

Particulars

Date of Birth: 02/09/1987

Nationality: Indian

Passport Number: L1808230

Father’s Name: Shakeel Ahmad

Hobbies: Volleyball, Football, Listening Music, Snooker

Permanent Address: V/798, J.N. Road, Waris Pura Kamptee - 441002, Dist. Nagpur

Reference:

All References are available upon request.

Declaration:

I consider myself familiar with Information Technology aspects and its standard of sophistication. I’m also confident of my ability to perform individual as well as team work. I hereby declare that the information furnished above is true to best of my knowledge.

Tauseef Ahmad

Contact this candidate