Gaurav Varma

  

Senior Systems Analyst, Nucleus Software Exports Limited

Location: Noida, India

+919717996885

Certifications

Certified ScrumMaster

Biography

Gaurav Varma, PMP | CSM | ITIL V3           

Mobile: +91 9717 996 885 | E-Mail: gaurav4468@gmail.com     

Seeking opportunities as Project Manager / Technical Project Manager

  • A confident professional with 13+ years of IT experience in various verticals including Banking, Manufacturing and Travel.
  • Last associated with Nucleus Software Exports Limited, Noida as Senior Systems Analyst.
  • Experience in end-to-end implementation of various projects including Requirement gathering, Analysis, Design, Development, QA & Testing, Implementation and Production Support.
  • Managed medium to large size projects.
  • Experience in stakeholder management, cost management, time management, risk management, integration management and managing project deliveries.
  • Proven track record to deliver projects on schedule & under budget, problem solving and taking initiatives to enhance customer satisfaction.
  • Leadership qualities, team coordination, creative, innovative and interpersonal skills.
  • Exposure in Software Quality Process SEI CMMi Level 5.
  • Experience in developing ETL strategies and managing end-to-end Data Warehousing solutions.
  • Significant experience in Data warehouse concepts viz Star schema, snowflake.
  • Experience in Reconciliation of financial transactions between Legacy systems and Core applications.
  • Experienced in performance tuning.
  • Working experience as a Database Professional in Oracle (PL/SQL, D2K, OWB) and SQL Server.
  • Conversant with Databases (Oracle & SQL Server) & Data Modeling Tools viz. ERWIN.
  • Got an exposure into ETL tool viz. Informatica & OWB.
  • Strong working experience in Onshore/Offshore model.
  • Experience in the use of Waterfall and Agile Methodologies.
  • Worked with clients and end-users at onsite (UK, Singapore, Malaysia and Hong Kong).
  • A thorough professional capable of out of box thinking & generating new design solutions & ideas.

 

Skill Set

Primary Skill                :           Oracle

ETL Tools                       :           Informatica, Oracle Warehouse Builder (OWB)

Front End                       :           Oracle Forms & Reports, Visual Basic

RDBMS                          :           Oracle, SQL Server

Scripts                          :           UNIX Shell script

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

Operating Systems         :           Windows, Linux, UNIX

Modeling Tool                 :           ERWIN

Configuration Tool          :           ClearCase, Win CVS, SVN

Others                           :           JIRA, MS Project

 

Certifications

  • Project Management Professional (PMP). (#1488470), Feb’ 2012.
  • Certified Scrum Master (CSM). (# 000191603), May’ 2012.
  • IT Infrastructure Library (ITIL) V3 Foundation. (#ITIL/IN071588), Nov’ 2011.

 

Education

  • Masters in Computer Applications

Indira Gandhi National Open University, 2003

  • Advanced Diploma in Software Export Technologies (ADSET).

 

EMPLOYMENT HISTORY

 

Sr. Systems Analyst, May’08 to Feb’ 14 (69 months)

Nucleus Software Exports Limited, Noida, India.

Key Responsibilities;

  • Conducting analysis and preparing the technical requirements & specifications
  • Provide technical direction for the development, design, and systems integration.
  • Code Review and Testing for ensuring quality
  • Project Management
  • Risk Identification, Analysis and Mitigation
  • Monitor projects from concept to completion
  • Project Delivery in defined schedule and budget

 

Key Projects;

 

Project 1

Role: Project Manager (Offshore)

Client: Al Ghanim Financial Services, Kuwait

Team: 18

Al Ghanim is a very large collection agent with a huge customer base. For their lending business they are implementing FinnOne Suite by replacing their existing system. The project was successfully executed and implemented.

 

Responsibilities

  • Gathered technical and functional requirements
  • Built Proof of Concept (POC) for the client’s approval
  • Developed strategy of data migration
  • Responsible for project management throughout the entire project lifecycle.
  • Manage ISS (Information System Support) team for Infra related requirements.
  • Responsible for identifying, analyzing, measuring and managing project risks.
  • Ensure effective quality control processes are in place to monitor deliverable produced.

 

Project 2

Role: Scrum Master (Project Manager)

Client: HDFC Bank, Mumbai

Environment: WindowsXP, Oracle10G, PL/SQL, ClearCase, JIRA

Team: 16 (2 scrum teams including Product Owner)

Scrum Master for HDFC Bank CRM Next Enhancement for Lending module. Maintaining product backlog, sprint backlog, etc. in JIRA. Involved in project management activities and project monitoring and tracking.

 

Responsibilities

  • Gathered technical and functional requirements
  • Built Proof of Concept (POC) for the client’s approval
  • Developed strategy for data retrieval from Production and Archival Database.
  • Sprint planning, Maintaining product / sprint backlog
  • Holding daily stand-up scrum meetings, sprint review and retrospective meetings.
  • Responsible for identifying, analyzing, measuring and managing project risks.
  • Ensure effective quality control processes are in place to monitor deliverable produced.

 

Project 3

Role: Project Manager (Offshore)

Client: Arab Bank (Egypt & Palestine)

Environment: WindowsXP, Oracle10G, PL/SQL, ClearCase

Team: 14

This was an implementation project of standalone Collections module for Arab Bank (Egypt & Palestine). Standalone Collections module was customized for the customer specific needs. The implementation was completed within defined timeframe and under budget.

 

Responsibilities

  • Responsible for project management throughout the entire project lifecycle.
  • Managed ISS (Information System Support) team for Server procurement, Oracle License procurement, H/w setup, setting up SAN (Storage Area Network).
  • Managed team to ensure that all milestones are achieved within the agreed timeframe.
  • Responsible for identifying, analyzing, measuring and managing project risks.
  • Ensure effective quality control processes are in place to monitor deliverable produced.

 

Project 4

Project Name: GE-Cards

Role: Project Manager (Offshore)

Client: Shinsei Financials, Japan

Environment: WindowsXP, Oracle10G, Informatica, PL/SQL, ClearCase, Solaris    

Team: 18

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. Shinsei Bank migrating cards data into PowerCard system, developed and maintained by HPS (Hightech Payment System), Morocco. After processing, the data was moved to the Data Warehouse. Involved in the designing of data warehouse and developing ETL strategy.

 

Project 5

Project Name: CLASSIC – APS

Role: Project Manager (Offshore)

Client: ACOM, Japan

Environment: WindowsXP, Oracle10G, PL/SQL, XML, ClearCase               

Team: 34

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. Designed Oracle Streams AQ operations to create secure queues through which the application sends inquiries to the credit bureaus to get instant response. Designed the Data migration strategy and managed the migration team.

 

Module Leader (Team Leader), Sep’06-May’ 08 (20 months)

Espire InfoLabs, New Delhi, India.

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;

 

Project 1

Project Name: ABACUS

Role: Project Leader (On-site as well as Offshore)

Client: Fuji Xerox (Asia Pacific)

Environment: WindowsXP, Oracle9i, PL/SQL, Informatica, Pro*C, VSS, Sun Solaris

Team: 10

Scope: ABACUS comprises of 2 phases: Billing and payment modules and movement of data into the Data warehouse of Fuji Xerox (Asia Pacific). Phase 1 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.

Phase 2 consists of design, development and implementation of the Data Warehouse. Lead the development and implementation team. Was part of team responsible for performance tuning and analysis of client’s database at Singapore, Malaysia and Hong Kong.

 

Project 2

Project Name: @ComRes

Role: Project Leader (On-site as well as Offshore)

Client: Anite Group PLC., Slough, UK.

Environment: WindowsXP, Oracle9i, PL/SQL, Pro*C, VSS

Team: 10

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.

 

Sr. Consultant, Mar’05-Sep’06 (18 months)

Saksoft Ltd, Noida, India.

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;

Project 1

Project Name: NO-GCMS

Role: Team Leader (Offshore)

Client: GE, Norway.

Environment: Solaris, Oracle9i, PL/SQL, Informatica, SQL Server 2000

Team: 08

 

Project 2

Project Name: EBCDIC file Conversion Loading

Role: Team Member (Offshore)

Client: GE, Japan.

Environment: Solaris, Oracle9i, PL/SQL, Oracle Warehouse Builder, Informatica

Team: 08

 

Project 3

Project Name: Credit Card Dedupe Processing

Role: Team Member (Offshore as well as Onsite)

Client: HDFC Bank, Chennai.

Environment: Windows2K, SQL Server 2000, TSQL, DTS

Team: 08

 

Project 4

Project Name: GCMS

Role: Team Member (Onsite)

Client: GE - CRM Technologies, Chennai.

Environment: Windows2K, Oracle 9i, PL/SQL

Team: 06

 

Sr. Programmer, Apr'03-Mar’05 (23 months)

Gripwel Fasteners, Noida, India.

 

Key Responsibilities;

  • System 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.

 

Project Name: GPROD

Role: Sr. Programmer

Client: In House development

Environment: Win2K, Forms6, Reports6, Oracle8, PL/SQL

Team: 05

 

Programmer Analyst, Mar'00-Nov’02 (32 months)

IT Vision Softech, Noida, India.

Key Responsibilities;

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

 

Project 1

Project Name: LEX

Role: Programmer Analyst (Offshore as well as Onsite)

Client: Ali Exports, Kanpur

Environment: Win NT, Forms6, Reports6, Oracle8, PL/SQL

Team: 08

 

Project 2

Project Name: HP

Role: Programmer Analyst (Offshore as well as Onsite)

Client: Briggs & Stratton, Ghaziabad

Environment: Win NT, Forms6, Reports6, Oracle8, PL/SQL

Team: 08

 

Passport Details

Number                        :  F-8812005      

Issuing Authority           :  Republic of India

Place of Issue               :  Ghaziabad (U.P.)

Date of Issue                :  11/08/2006

Date of Expiry               :  10/08/2016