DEVENDRA SINGH RAJPUT Safe Agile *.* Certified
Contact No: +1-901-***-**** E-Mail: ******.********@*****.***
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