Gaurav Varma, PMP, CSM, ITIL V3                   E-Mail: varma_gaurav@rediffmail.com

                   Mobile: 9717996885 / 9718413339

 

Seeking a project management position with leadership responsibilities including problem solving, planning, organizing and managing budgets.

 

Professional Profile

• A Master’s degree in Computer Applications with over 11 + years of experience in IT Infrastructure planning & management, Project Management, Software Development & Designing in the IT sector.
• Skills in Oracle 8i/9i/10G, PL/SQL, Project Management, Data warehousing on HP-UX, Solaris and Windows platforms with complete understanding of all aspects of SSAD and SDLC.
• Agile Methodologies - Experienced in the use of Agile approaches including Scrum.
• Exposure in Software Quality Process SEI CMMi Level 5.
• Presently associated as a Sr. Systems Analyst using Oracle 10g.
• Executed prestigious software development assignments for the HDFC Bank, Arab Bank, Al Ghanim Financial Services, Shinsei Bank, ACOM (Japanese NBFC), Fuji Xerox (Asia Pacific), Anite Group PLC. Slough, UK, GE (Norway & Japan), GE – CRM Technologies, Gripwel Fasteners and LEX to develop Billing and invoicing application, @ComRes, ETL Movement, EBCDIC File Conversion, Credit Card Dedupe Processing, Automating Manufacturing Unit & Payroll Management System.

 

IT Certifications & Trainings

• Certified PMP.
• Certified Scrum Master
• ITIL V3 Foundation Certified. (Candidate No: ITIL/IN071588)
• Advanced Diploma in Software Export Technologies (ADSET) from ASSET International.
• M.C.A - Indira Gandhi National Open University.

Education

 

IT Skills

OS                   :                 HP-UX, Windows 9x/XP/NT4, DOS, UNIX, Solaris.

 

Languages         :                 PL/SQL, Pro*C, TSQL, Java 2, C, C++, COBOL

 

RDBMS             :                 Oracle7.3/8i/9i/10G, SQL Server 2000

 

Web development :                        HTML, ASP, JavaScript, VBScript.

 

Tools               :                 Toad, PL/SQL Developer, SQL*Loader, Forms 6, Reports 6.

 

Data warehousing    :                 Oracle Warehouse Builder, Informatica 7.1,

                                    Business Objects

 

Others             :                 MS-Project 2007, ClearCase, BugZilla, VSS, WinCVS.

 

Organizational Experience

 

May’08- Till date with Nucleus Software Exports Limited as Sr. Systems Analyst.

 

Nucleus Software Exports Limited is a leading global provider of software products for banks and financial institutions. Its product FinnOne™ is ranked as the 'World's No. 1 Selling Lending Software. FinnOne™ is a powerhouse of seamlessly integrated software modules built with the objective of providing operational and decision-making support to all the business lines of Banks and Financial Services Companies. 

Key Responsibilities;

• Project Management
• Requirement Analysis.
• Risk Identification, Analysis and Mitigation
• Providing technical guidance to the project team
• Monitor projects from concept to completion
• Project Delivery in defined schedule and budget

 

Key Projects Handled;

 

Currently managing 3 projects viz. Al Ghanim – Kuwait, Arab Bank – Jordan and HDFC Bank – India.

 

Al Ghanim and Arab Bank are implementation projects for Collections module. FinnOne Core collections module is being implemented at Arab Bank whereas for Al-Ghanim huge customisation is being done before implementation. Scrum Master for HDFC Bank enhancements where in the Bank raises change requests for enhancements as required for the existing FinnOne’s Lending module.

 

Involved in project management activities for all 3 projects along with project monitoring and tracking. Reporting the project status to project owner and customer on fortnightly basis. Involved in Estimation, RQA and Release of the change requests that are being raised by HDFC Bank.

 

Previous Projects:

 

Title: GE-Cards                                                              Team Size: 12

Client: Shinsei Financials, Japan

Environment: WindowsXP, Oracle10G,                            Role: Sr. Project Leader

PL/SQL, ClearCase                                                      (Offshore)

 

Scope: Shinsei Bank acquired the entire share capital of GE Consumer Finance (GECF), a wholly owned unit of the GE Japan. GE’s legacy mainframe system (Vision Plus) was to be migrated to Shinsei’s new Intel servers and a PC-based system. This is being done through reconciliation engine to show the equivalence of both the systems. Shinsei Bank migrating cards data into PowerCard system, developed and maintained by HPS (Hightech Payment System), Morocco. The reconciliation engine is being developed by Nucleus to show the equivalence of both the systems.

Functionality cover in this project is as follow.

• All Masters setup, Offline Sales (Networks/Merchant), Manual Operations, Customer Interfaces.
• External Interfaces (Customer Monthly Statement, Direct Debit Request, CVS Payments Receipts, CIC File).
• Internal Interfaces (DWH – Warehouse, MCS Delta Data, GL).

 

Title: CLASSIC – APS                                                     Team Size: 34

Client: ACOM, Japan

Environment: WindowsXP, Oracle10G,                            Role: Sr. Project Leader

PL/SQL, XML, ClearCase                                          (Offshore)

 

Scope: Application Processing System (APS) is the entry point for a loan-seeking customer as well as maintains customer database. The customer has the liberty to apply from the internet, ACM machines, customer care, by post or can directly visit the ACOM branch. The system performs de-duplication process to check customer’s status and creditability. The application processes various enquiries about customer and then let the application proceed for further processing. It is the source of all the other modules like Lending, Guarantee, Collection, Inquiry, etc. Credit bureau inquiry (JIC) is also made during calculation of Credit Limit. This is an enhancement of FinnOne, a complete lending product developed by Nucleus Software that caters the requirement of banking as well as Non-banking financial companies.

 

Sep’06-May’ 08 with Espire InfoLabs as Module Leader.

 

Key Responsibilities;

• Preparing and updating project documents as per CMMi guidelines.
• Query optimization and performance tuning.
• Code Review.
• Developed customized character based reports using Pro*C.
• CR life cycle Implementation.

 

Key Projects Handled;

 

Title: ABACUS                                                                                 Team Size: 10

Client: Fuji Xerox (Asia Pacific)

Environment: WindowsXP, Oracle9i,                                            Role: Team Leader

                     PL/SQL, Pro*C, VSS                                   (On-site as well as Offshore)

 

Scope: ABACUS is all about billing and payment modules of Fuji Xerox (Asia Pacific). The application has been developed using Developer 2000. Pro*C takes care of the generation and printing of the Invoices. It comprise of generation of Service and Leasing Contracts of Fuji Machines to their clients. After generation of Invoices the entries are transferred to AR of Oracle Financials. Had been to Singapore, Malaysia and Hong Kong for performance tuning on Client’s database.

 

Title: @ComRes                                                                              Team Size: 15

Client: Anite Group PLC., Slough, UK.

Environment: Windows XP, Oracle9i,                                     Role: Team Leader

                     PL/SQL, HTML, XML, JavaScript, VSS          (On-site as well as Offshore)

 

Scope: Anite provides a comprehensive range of business-critical IT solutions to private and public sector organisations. Anite develop and implement software, provide consultancy, systems integration and managed services. Anite deliver mobile phone software to the top telecommunications manufacturers and holiday booking systems for the travel industry. @ComRes is customized software developed by Anite, which is being used by UK’s travel industry.                         

 

Mar’05-Sep’06 with Saksoft Ltd as Sr. Consultant.

 

Key Responsibilities;

• Developing procedures, functions, packages, analysis, designing and unit testing.
• Query optimization and performance tuning.
• Mapping and Loading of ASCII feeds through Oracle Warehouse Builder.
• Creating tables, views, triggers, DTS packages.
• Loading of various source feed files through SQL*Loader utilities.
• Connected Oracle 9i to SQL Server using Oracle’s Heterogeneous Services ODBC agent.

 

Key Projects Handled;

 

Title: NO-GCMS                                                                          Team Size: 08

Client: GE, Norway

Environment: Solaris, Windows2K, Oracle9i,                                Role: Team Member

                     PL/SQL, SQL Server 2000                                                (Offshore)

 

Scope: This is a fully back-end application requiring ETL movement of data from SQL Server based Staging Area to Oracle based Data Mart of GE – Norway, which will be used further by GE – Norway’s web based application GCMS for campaign selection / de-selection purposes. The project required Oracle’s Heterogenous Transparent Gateway to connect to SQL Server database and a host of Packages and Procedures to enable the ETL process.

 

Title: EBCDIC file Conversion Loading                                            Team Size: 08

Client: GE, Japan

Environment: Solaris, Windows2K, Oracle9i,                                Role: Team Member

                     PL/SQL, Oracle Warehouse Builder                          (Offshore)

 

Scope: To develop a project for loading the ASCII files after EBCDIC file conversion through Oracle Warehouse Builder. The data representation in source files is in Japanese language. The process is to load the data in a specified time if any warning or error occurs during loading it has to be mailed to the support team.

 

Title: Credit Card Dedupe Processing                                       Team Size: 08

Client: HDFC Bank, Chennai

Environment: Windows2K, SQL Server 2000,                          Role: Team Member

                    TSQL, DTS                                                                          (Offshore as well as Onsite)

 

Scope: It is a Credit Card Deduplication processing Project developed for duplicate data identification, which categorize good, bad, referral, or new customer. Depending upon the category credit card is used to the customer. Was also involved in UAT of this application.

 

Title: GCMS                                                                                        Team Size: 06

Client: GE - CRM Technologies, Chennai

Environment: Windows2K, Oracle 9i,                                             Role: Team Member

                    PL/SQL                                                                                                                                                                     (On-site)

 

Scope: The GCRM team in Chennai mainly involves in ETL (Extraction Transformation and Load) process.  The objective is to extract data from (multiple) data sources, transforming it to make it a common platform across sources, product lines and functions. In the present scenario, the source of all the data is the Data Warehouse and the target is the CRM data mart.  We extract data from datamarts and use them to go through Deduplication Process to enable data to be available into the users schema.

 

Apr'03-Mar’05 with Gripwel Fasteners as Sr. Programmer (Sr. Officer).

 

Key Responsibilities;

• Initial study, Analysis, design.
• Developing forms, reports, analysis, designing, and testing.
• Database designing, SQL queries and performance tuning.
• Created and worked extensively on BOM, used mainly in production and packing.
• Scheduled backups and recovery plan.
• Arranging meetings with different departments.
• Implementation and training.

 

Title: GPROD                                                                          Team Size: 05

Environment: Win2K, D2K, Oracle8,                                             Role: Sr. Programmer

                     PL/SQL                                     

 

Scope: This is an in-house project. The Company Exports Tractor Linkage Parts to USA, GERMANY, UK and some European countries. Project includes departments like Gate, Receiving, QC, Production, Plating, Store (Consumable and WIP), Purchase, P&C, etc. Successfully implemented in departments like P&C, receiving, packing, purchase and Consumable Store.

 

Mar'00-Nov’02 with IT Vision Softech as Programmer Analyst.

 

Key Responsibilities;

• Developing procedures, functions, packages, forms, reports, testing and Implementation.
• Performance tuning.

 

Title: LEX                                                                               Team Size: 08

Client: Ali Exports, Kanpur

Environment: Oracle 8, PL/SQL                                               Role: Programmer Analyst

                       Forms6, Reports6, Win NT                   (Offshore as well as Onsite)

 

Scope: The package was developed for providing complete automation of factory (tannery) and export house involved in manufacturing in Leather goods. They have Export house in Delhi, Tannery & manufacturing unit in Kanpur. The project was to automate tannery, factory and office. It involves Costing, inventory and Payroll.

 

Title: HP                                                                                 Team Size: 08

Client: Briggs & Stratton, Ghaziabad

Environment: Oracle 8, PL/SQL                                               Role: Programmer Analyst

                       Forms6, Reports6, Win NT                   (Offshore as well as Onsite)

 

Scope: The project was developed for providing automation of departments like Gate, Store, QC, Rejection Store, HR (Payroll & Attendance), Spare Parts Department and Spare Part Depots (located at some major cities in India). It takes care of material from gate entry till despatch to the dealers and to depots. The application was developed as C/S, as well as for stand-alone machines (for depots).         

 

Personal Details

 

Number                   :  F-8812005 

Issuing Authority                    :  Republic of India

Place of Issue                   :  Ghaziabad (U.P.)

Date of Issue                          :  11/08/2006

 

Father’s Name          :  Late Sh. O.N. Varma

 

 

 

 

Read Less