Permanent Address

Flat No:A-****,R* Block, Life Republic,Marunji, Hinjewadi,

Wakad,Pune-411057

Contact No.

+91-880*******

Email Id

adjvj5@r.postjobfree.com

Rajeev Thakur

Career Summary

Tech lead with around 13 Years of IT experience and having more than 10 years as an Oracle Developer in the analysis, Design, Development and Implementation of Business application in Telecom, Banking and Retail industry using Oracle RDBMS. Highly experience in software Design, Analysis, Coding, Development and Testing with specialization in ORACLE based client-server & multi tier Architecture, Database Design, and Development, Implementation, Production support. Rich development experience in creating SQL, Stored procedures, Functions, Packages, Database triggers, SQL Loader .Extensively followed agile methodology, especially Scrum process and Extreme programming for software development.

Skill Set

Lead the analysis, design, development, coding, debugging, testing and documenting activities to satisfy business requirements for large complex projects.

Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader.

Developed PL/SQL procedures and database triggers for the validation of input data and to implement business rules.

Created database objects like packages, procedures, and functions according to the client requirement.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.

Extracting the data from simple flat text files in the operational database.

Creation of database objects like tables, views, materialized views, procedures, packages using Oracle tools like SQL Loader.

Using Ref cursors and collections for accessing complex data resulted from the joining of a large number of tables in PL/SQL blocks and has experience with exception handling.

Optimized a lot of SQL statements and PL/SQL blocks by analyzing to execute the plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.

Having knowledge OEDQ, Python.

Extensively followed agile methodology to plan, track the projects and their corresponding issues using JIRA/ ALM tool.

Skilled with SVN, and GIT for version control.

Experience Portfolio:

Key Project Experience

Since June-2018– Till Date–Fulcrum Worldwide as Tech Lead

Client: Vocalink (MasterCard)

Project Title:

Vocalink runs, maintains and services the technical infrastructure that processes automated payments on behalf of Bacs and on a peak day 100 million transactions were securely processed through data centers. Maintaining a world-class payments infrastructure for the UK is a high priority for Vocalink.

Role:

Building and maintaining relationships by working in Payment domain for UK banking system and having in depth knowledge of Oracle SQL and PLSQL Development Along with performance tuning and Golden Gate. Identify issues and propose response action, and good understanding of data analysis and data mapping.

Responsibility:

Involved in development efforts towards successful project delivery. Provide technical leadership to teammates through coaching and mentorship.

Maintain high standards of software quality within the team by establishing good practices and habits.

Identify and encourage areas for growth and improvement within the team.

Design, develop, and unit test applications in accordance with established standards. Participate in peer-reviews of solution designs and related code.

Hands on with Coding & Debugging using tools like PL/SQL developer, Toad and UNIX, Golden Gate.

Hands on experience of Oracle PL/SQL, stored procedures, Advance Queue & SQL query tuning.

Extensively followed agile methodology to plan, track the projects and their corresponding issues using JIRA/ ALM tool.

Skilled with SVN, and GIT for version control.

Involved in POC to create test case automation scripts using PYTHON.

Key Project Experience

Since May-2016– June-2018–Tech Mahindra as Team Lead

Client: AT&T

Project Title: Data Transformation and Integration (DTI)

DTI provides services for receiving batch and near real-time data feeds from a variety of data sources, performing required data transformation and aggregation and replicating the integrated data to the various operational data stores in the data fabric layers of the enterprise. DTI is the central component that lies between Data Fabric layer and the Data Source layer and plays the critical role of updating the Data Fabric repositories with enterprise data from various ATT data sources.

Role:

Worked as a Team Lead for Development/Enhancement. Managing the successful delivery of projects, also plan, coordinate and lead activities across the full delivery lifecycle. This will include working closely with the department’s Project Managers, coordinating business analysts, architects and developers, as well as liaising with key project stakeholders as required .Working closely with other team leaders to ensure the structured and coordinated planning of team’s development.

Responsibility:

Involved in development efforts towards successful project delivery. Provide technical leadership to teammates through coaching and mentorship.

Maintain high standards of software quality within the team by establishing good practices and habits.

Identify and encourage areas for growth and improvement within the team.

Collaborate with other software developers, business analysts and software architects to plan, design, develop, test, and maintain web- and desktop-based business applications built on Microsoft technologies.

Assist in the collection and documentation of user requirements, development of user stories, estimates and work plans.

Prepare reports, manuals and other documentation on the status, operation and maintenance of software.

Design, develop, and unit test applications in accordance with established standards. Participate in peer-reviews of solution designs and related code.

Coding & Debugging using tools like PL/SQL developer, Toad and UNIX, Golden Gate.

Extensively followed agile methodology to plan, track the projects and their corresponding issues using JIRA/ ALM tool.

Skilled with SVN, and GIT for version control.

Key Project Experience

July 2014 - May 2016: Atos India LTD. as Tech Lead

Client: KPN

Project Title: VAMOS and 55 Apps (VAS Provisioning, Prepaid Korting)

Vamos is an application that comes under Ordering Business chain .It does works like New Subscription, Order Renewals and Order Validation. Also has a GUI user interface used by stores for selling products and adding new orders. The System is responsible for Order Entry and Order fulfillment System has been divided for following components like Order Entry, Order Fulfillment and Order management, Also different value added services are facilitated to customer on the basis of eligibility.

Role:

Worked as a Team Lead for Development/Enhancement and Migration activity for the project, Also Plan, coordinates and lead activities across the full delivery lifecycle.

Responsibility:

Handles production support/maintenance activity along with project migration activities which includes GO-Live of the applications with minimal post production issues.

Interacting with client and provide daily status report of the project.

Mentoring the cross application team members in case of any technical difficulties.

Creation of WOW, APM and other technical knowledge document per project level.

Handles Incident/Service request raised in SNOW within SLA.

Coding & Debugging PL/SQL subprograms, packages, procedures and functions, Collection, DB triggers using tools like PL/SQL developer, Toad.

Referred Standard Code review checklist to ensure compliance to coding standards.

Documented the unit test cases and their status in unit test case document.

Fixed the defects in test cycles and updated their root cause in quality Centre.

Hardware KPN Domain Network

Operating System Windows 2000/XP -Intel Pentium, UNIX

Languages Oracle SQL, Pl/SQL

Special Software TOAD, Pl/SQL Developer, Quality Center

Key Project Experience

Feb-2013 –Jun-2014: Infosys Technology Ltd. as Technology Lead.

Client: Barclays Finance

Project Title: Ceased & Deceased(C&D)

This project consists of search engine OEDQ which deals with security check for anti-social element while comparing the different screening process of customer list and world checklist. This includes rules and combination as well as logic setup in OEDQ tool to perform smart check.

Role:

Worked as a Technology Lead for Development/Enhancement project.

Responsibility:

Involved in understanding the all table structure in data model for the assigned module and gave the suggestions to onsite team member to optimize the Data model and meet project requirement.

Created the technical specification document which explains the functional requirement using High level data flow diagram using flowchart, screenshots & corresponding API (Procedure or function) signature, traceability matrix and all table structure.

Closely worked with client and other stakeholders in understanding client requirements, Creation of technical design document and delivering the jobs within SLA.

Coding & Debugging using OEDQ tool which internally invoke PL/SQL subprograms, packages, procedures and functions, Collection, DB triggers.

Referred Standard Code review checklist to ensure compliance to coding standards.

Documented the unit test cases and their status in unit test case document.

Fixed the defects in test cycles and updated their root cause in quality Centre.

Tracking and maintaining Weekly Status Report for the project.

Tracking and maintaining Defect Status Report for the project.

Unit Testing, Post Go live support & End user training

Hardware Barclays Domain Network

Operating System Windows 2000/XP -Intel Pentium, UNIX

Languages Oracle SQL, Pl/SQL

Tool Used OEDQ, TOAD

Special Software Pl/SQL Developer, Quality Center

Infosys-Phase2, Pune, India (Feb 2013 –June2014)

Key Project Experience

Nov 2010 – Feb-2013 – Tata Consultancy Services Ltd. as I.T Analyst .

Client: Cisco Systems (Channels & Sales)

Cisco Systems is an American multinational corporation that designs, manufactures, and sells networking equipment.

Project Title: Certification and Specialization Partner Program(CSAPP)

Project Description:

CSAPP is a tool created for Customer to provide facility to the Partners to entities for Cisco designates levels of engagement. These levels are defined as Certifications which in descending order are Gold, Silver, Premier or Select, and also different level of Specialization mainly categorized as Base, Master, Core And Architecture .The Certification and Specialization Application (CSAPP) allows new and registered partners to manage their qualifications.

Role:

Worked as a Module Lead for handling Development/Enhancement project.

Responsibility:

Participated in creation of Functional Requirement Document.

Closely worked with client and other stakeholders in understanding client requirements, Creation of technical design document and delivering the jobs within SLA.

Participated in analyzing the different ways of implementing the functionality.

Involved in understanding the all table structure in data model for the assigned module and gave the suggestions to onsite team member to optimize the Data model and meet project requirement.

Created the technical Design document which explains the Technical/functional requirement using High/Low level data flow diagram using flowchart, screenshots & corresponding API (Procedure or function) signature, traceability matrix and all table structure .

Explains the functional requirement using High level data flow diagram using flowchart, screenshots & corresponding API (Procedure or function) signature, traceability matrix and all table structure.

While coding, used optimized way of coding with tool like Toad, SQL Developer and use of index based on scalability and cardinality for the table data and query structure.

Coding & Debugging PL/SQL subprograms, packages, procedures, functions, Collection, DB triggers using tools like PL/SQL developer, Toad.

Referred Standard Code review checklist to ensure compliance to coding standards.

Documented the unit test cases and their status in unit test case document.

Versioning of code using version tool PVCS.

Deployment of the code using specific tool named as Kintana .

Interacting with client and giving daily status of the project

Fixed the defects in test cycles and updated root cause in quality centre.

Automating various manual process activities as a part of enhancement and bringing value to business.

Hardware Cisco Domain Network

Operating System Windows 2000/XP -Intel Pentium, UNIX

Languages Oracle SQL/Pl/SQL, UNIX

Special Software TOAD, Pl/SQL Developer, Quality Center, Dollar Universe ($U)

Cisco TCS, Mumbai, India (Nov 2010 – Feb 2013)

Key Project Experience

June 2007 - Oct 2010: Rolta India Pvt. Ltd. As Production Executive L-1

Client: Ameren

Central Illinois Public Service Company in United States. It is now a holding company for several Telecom, Power and energy companies.

Project Title: Ameren (Tool Migration)

Project Description:

This project involves migration of Ameren’s existing Framme data into the G-Tech environment. In accordance to the rule base provided, done the mapping of each and every attribute of table and data is converted into the G-Tech environment.

After migration validate the G-Tech data with Framme data by using AutoCAD, Microstation, Also by using PL/SQL validation routines to checks the integrity of the data as per the business rules and G-Tech model requirements.

Role:

Worked as a developer and provided post Production normalization Support to make system stable after project delivery. Also Involved in various GIS related project using AutoCAD and Microstation as primary tool.

Responsibility:

Interaction with the onsite/offshore team, and Business team for understanding the requirement.

Impact Analysis of the existing system with respect to new functionality.

Database Design, development according to new requirement includes database coding using Pl/Sql.

Unit test case preparation, test data preparation and unit testing

UAT/BAT QA Support.

Interacting with client and giving daily status of the project

Tracking and maintaining Defect Status Report for the project.

Hardware Ameren Domain Network

Operating System Windows 2000/XP -Intel Pentium

Tool AutoCAD, Microstation

Languages Oracle SQL/ PL/SQL

Special Software TOAD, Pl/SQL Developer, Quality Center, GTECH

Other Activities

Certification/Training Attended:

Year

Title

Location

Organized by

2019

Python

Pune

Ethans tech

2015

SCRUM Master

Pune

Novel vista

2015

ITIL Foundation

Pune

Novel vista

2011

Effective Presentation Skills

Mumbai

Tata Consultancy Services

2009

Oracle,PLSQL

Mumbai

Rolta India Ltd

2007

SQL, Basic Unix, Oracle and Java

Mumbai

Rolta India Ltd

Education:

Degree and Date

Institution / University

Major and Specialization

B.TECH in 2007

Allahabad Agricultural Institute-Deemed University

Electronics and Communication engineering

H.S.C in 2001

College Of Commerce, Patna

Science

SSC in 1999

St. Xavier’s High School, Patna

General

Name as on Passport

Passport Number

Date of Issue

Expiry Date

Place of Issue

Rajeev Thakur

T4393394

2nd May 2019

01st May 2029

PUNE,MAHARASHTRA (INDIA)

Passport Details:

Contact this candidate