DEVENDRA SINGH RAJPUT Safe Agile *.* Certified

Contact No: +1-901-***-**** E-Mail: ac9e7m@r.postjobfree.com

Techno-Lead Consultant

● Application Development ● Client Engagement ● Resource Management

“Versatile, high-energy technocrat with the distinction of executing prestigious Information Technology projects of large magnitude within strict time schedules”

“Proven competency in suggesting appropriate as well as technology-based solutions for enhancing functional efficiency of the organization and achieving business excellence”

Preferred Location: Anywhere Preferred Industry: IT

Profile Summary

A result-oriented professional with 12+ years of experience in Logistics, Banking & finance and insurance domain with Waterfall and Agile Development:

Project Execution Application Development Implementation and Support

Client Engagement Requirements Gathering and Analysis Technical Support

Documentation Coding & Testing Team Management

Extensive Client engagement and Customer facing experience with more than 5 years at onsite locations and currently working with FedEx from last 2 Years at Memphis [USA] Location.

Over 2.5 years of work experience at Onsite Chicago (USA) as Technical Consultant and 2.8 years of work experience at Onsite Glasgow (UK) as Technical Specialist.

Over 4 Years of Extensive experience as Oracle Applications Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications.

Created Inbound and outbound Interfaces to Store data into the staging table and base table.

Experience to work on Worked on API/Interface enhancements and development.

Overall 6 Years Profound working knowledge of Oracle 9i/10g/12c, SQL/PL-SQL, Oracle Forms/Reports and UNIX shell scripting.

Well acquainted with Integration, System, and Functional, Input domain, Validation, User Interface, Compatibility, User Acceptance Testing, Regression and Re-Testing.

Experience to work on Oracle Apps Forms and reports customization.

Extensively developed SQL Performance Tuning/Query Optimization solutions.

Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Object types and Records

Strong Leadership quality, analytical and problem solving skills, excellent communication, presentation skills and a good team player.

Expertise in handling the overall enterprise software application development life-cycle involving requirement analysis, system study, designing, testing, coding, de-bugging, project planning, maintenance & documentation.

Extensive experience in Agile development methodologies and related artifacts like Scrum meetings, User stories, Sprint Planning, Product Backlog, Sprint Backlog, Product owner and scrum team management, Sprint burn down and Release burn up charts, Estimations and Team Velocity.

Demonstrated abilities in implementing various systems according to business needs (as-is & to-be analysis) and reviewing process flow as per specifications.

Distinction of:

oIdentifying, conceptualizing and documenting appropriate technical solution approaches for various businesses scenarios and challenges

oManaging requirements gathering, collation of project functional and technical requirements; following-up with clients throughout the project lifecycle to ensure full understanding of needs and concerns

Resourceful in liaising with global clientele with proven expertise in setting up new business practices/ processes

Proven expertise in spearheading multiple projects from conceptualization & visualization to technology mapping and final execution of projects

Distinction of receiving Syntel SMART Value Award/Customer Delight Award from Syntel Ltd.

Innovative & creative professional with strong communication, analytical, interpersonal & negotiation skills

TECHNICAL SKILLS

Operating Systems: UNIX, Windows NT/95/98/2000/XP

Languages: SQL, PL/SQL

Databases: Oracle 9i/10g/12c

Application S/W: Oracle Forms 6i/9i/10g

Reporting Tools: Oracle Reports 6i/10g

Tools: SQL Developer, Toad 9.0, Load-Runner,

PL/SQL Developer 6.0, SQL *Plus, WSFtp, Lotus Notes, Putty, Oracle Designer, Serena PVCS

Domain: BNFS, Manufacturing ERP and Insurance

Others: SQL Loader, UNIX Shell Scripts

WORK EXPERIENCE

Sep’06 to Oct’07 Opus Software Solution (India) Pvt. Ltd., Pune Technical Associate

Nov’07 to Feb’09 KPIT Cummins Info System (India) Ltd., Pune Software Engineer

Since Mar’09 ATOS Syntel Inc. Sr. Technical Specialist

Key Result Areas: (across the tenure)

Software Development:

Managing the software development including design, development & troubleshooting of applications; conducting gap analysis including validation of needs in conjunction with onsite & offsite teams

Undertaking development & testing, defect & issue management for enterprise software applications and conducting reviews of codes & test cases; driving vision & lifecycle management for various applications development including value proposition & functionality, strategy elements (domain / business case & build) and training

Business Analysis:

Evaluating information gathered from multiple sources, decomposing higher information into details, investigating key business issues behind numbers and providing clear & concise analysis / recommendation

Project Execution:

Steering successful rollout of projects with accountability of defining scope, setting timelines, analyzing requirements, prioritizing tasks; handling project delivery as per functional & non-functional needs / using AIM (Application Implementation Methodology) for various releases

Monitoring project progress & outstanding issues and ensuring the quality & timeliness of deliverables; extending post-implementation support to the Development Team by defining standard practices and testing & documenting new or amended programs from supplied specifications as per agreed standards

Client Servicing:

Providing support in handling escalation from clients to resolve their concerns and addressing their queries (customer advocacy) from other departments for a smooth ride for customer’s diverse issues

CAREER HIGHLIGHTS

Supervised the design and creation of functional specifications and test plans for use by the team

Mapped requirements of clients as well as different Service Providers, Senior Management, Vendors / Consultants & other Stakeholders for ensuring effective translation of business needs into technology requirements in adherence with company’s objectives

Provided various technical suggestions, solutions and troubleshooting assistance during development and deployment of ARS and SLC class application

Interacted (onsite & offshore) with the client for requirement gathering; evaluated technical and commercial feasibility of solutions

Implemented appropriate methodology to add value to the consultants’ deliverables; worked with consultants in identifying process improvements in deliverables; developed methods to achieve delivery of desired results; acted as the quality control point for consultant deliverables

Delivered customized applications for AWACS processes that resulted in savings of up to 6 hours in effort and reduced costs by 40%, due to decreased cycle time and improved quality

Implemented appropriate methodology to add value to the consultants’ deliverables; worked with consultants in identifying process improvements in deliverables; developed methods to achieve delivery of desired results; acted as the quality control point for consultant deliverables

Prepared business presentations, evaluated architecture, provided technical direction, undertook effort estimation, tracking, risk management, status reporting and mentoring

Proficient in providing production support and provide critical and normal patches for technical and business related bugs

Partnered with the IT Leadership team and led the development of a streamlined and transparent demand management process

Imparted trainings on Oracle Upgrade versions to the client staff.

Recipient of awards such as Smart Value Award and Customer Delight for technical coordination for a large program

Experienced in:

oDeveloping SQL Performance Tuning/Query Optimization solutions

oData Modeling and Experience in the ETL process

oApplication development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Object types and Records. PL/SQL Tables, Table Partitions, Database links, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes

oAutonomous Transactions Materialized Views, Bulk Collects and Collections

Refer annexure for other projects

Academic Details

2005 Master of Computer Application (MCA) from RGPV, Bhopal (MP) India

2002 Bachelor of Science (B.Sc.) from RDVV, Jabalpur (MP) India

Certifications/Trainings

Agile Safe Training.

Agile Safe 4.6 Certified

PL/SQL Oracle 11g Training

Personal Effectiveness 2 Training

Personal Effectiveness 3 Training

LEAP I Training

LEAP2 Training

Agile Leve1 Certified

Lean Certified

BNFS Level 1 Certified (Banking)

Personal Details

Date of Birth: 25th June 1980

Current Address: 1123 Legacy Farm CT, Apt 09/101, Collierville TN -38017 US

Permanent Address: 1123 Legacy Farm CT, Apt 09/101, Collierville TN -38017 US

Languages Known: English & Hindi

ANNEXURE

PROJECTS OVERVIEW

With Syntel Inc. Collierville (USA)

Project : FedEx – FAST BILL/Refunds Employer: ATOS Syntel Ltd.

Client : FedEx Team Size: 15

Duration : Sep 2015 – till date Role: Technical Lead

Environment : Oracle 11g, Accounts Receivables (AR), SunOS 5.10, UNIX, SQL

Developer, SQL *Plus, Lotus Notes, Putty, SVN

Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.

Developing Inbound and outbound interfaces.

Interface Designing and Applications development.

Created Executables and Concurrent Programs and attaching with the respective responsibility.

Created Requests and Request Set to attach the PL/SQL procedures, SQL*Loader routine and Reports with Application.

Used Auto Invoice Interface to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.

Creating Unit Test Plan, Module Specification, Code review, implementation plan documents.

Doing Unit testing, development testing and preparing test evidence.

Doing end to end pre-invoice application screen testing from front end to back end to maintain integrity of the system.

Test Data preparation and Test Data management

Used SQL *Loader control file to import the customer information provided in the form of flat files into staging tables

Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.

Developed an interface to upload the legacy Journal data into the Oracle Application System, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations.

Involved in writing Test Planning coverage, Test cases and developing Test scripts using Test Manager.

Involved in filing bugs and verifying fixes and solved them using Quality center.

Project : CLASS-Student Loan Company Employer: Syntel Europe Ltd. UK

Client : SLC Glasgow, UK Team Size: 15

Duration : July 2013 – Aug - 2015 Role: Technical Lead

Description: The Student Loans Company is a non-profit making Government-owned organization set up in 1989 to provide loans and grants to students in universities and colleges in the UK.SLC provide financial support for people studying at universities and colleges throughout the United Kingdom.

That means that we pay loans and non-repayable grants for living costs and studying expenses and SLC provide loans to meet the costs of tuition fees, which we pay directly to universities and colleges on behalf of students.

SLC have 1.3 million student customers and 2.8 million customers’ no longer in higher education.

Environment : Oracle Forms/Reports, Oracle 10g, Toad 9.0, PL/SQL Developer 6.0. UNIX SunOS 5.10.

Project: Allstate Insurance - AMC App Support

Client: Allstate Chicago (US) Team Size: 11

Role: Technical Specialist Duration: Mar 2009 – June 2013

Description: Allstate Roadside services provider 24 hrs emergency roadside services to approximately 1.5 million members in USA via a national network of service providers. These services include billing, claims, customer service, dispatch and fulfillments. There are 3 main areas:

oWeb Applications: Used by Allstate customers and agents. Consists on n-tier J2EE application, the web pages are developed in JSP while oracle 10g is used as application database

oCall center – front end application: Used by service representatives to assist the customers. It has access to various modules like providers, products, ERS, customers, finance, claims etc. Built using oracle forms

oBackend-end application: Used for billing and reporting purposes like generation of reports, retrieving data from other systems, validating data and performing batch jobs

Environment: Oracle 10g, ETL Developer, Toad 9.0, PL/SQL Developer 6.0. SunOS 5.10, Forms 9i, Reports 9i.

With KPIT Cummins Info System Ltd, Pune

Project: Cummins Turbo Technologies Module: Leeds Pick Pack Ship Improvement

Client: Cummins Inc. Team Size: 3

Role: Software Engineer Duration: Oct 2008 – Feb 2009

Environment: Oracle 11i E-Business Suite, Oracle Developer 6i, Forms 6i, Reports 6i, Toad 7.0, PL/SQL Developer 6.0.

Project: Concur Expanses Management System

Client: Cummins Inc. – US Team Size: 4

Role: Software Engineer Duration: Nov 2007 – Sep-2008

Environment: Oracle 11i E-Business Suite, Oracle Developer 6i, Forms 6i, Reports 6i, Toad 7.0, PL/SQL Developer 6.0.

With Opus Software Solution (India) Pvt. Ltd. Pune

Project: Electra Card Collection Management System (CMS) Module: CMS (Collection Management System)

Client: Deutsche Bank Team Size: 5

Role: Technical Associate Duration: Sep 2006 – Oct 2007

Environment: Oracle 10g, Oracle Developer 6i/9i/10g, Forms 6i/9i/10g, Reports 6i/9i, Toad 7.0, PL/SQL Developer

6.0, UNIX

Contact this candidate