Ten years of IT industry experience with knowledge in Oracle PL/SQL, Unix and Oracle Applications.
Extensive experience with analysis, design, development, customizations and implementation of software applications including Oracle ERP applications.
Proficient in analyzing and translating business requirements to technical requirements.
Strong database skills, Object Oriented Programming and development knowledge
Experience in leading and managing teams. Handled multiple roles - Project Team Lead, IT Specialist, Technical Consultant, and Developer.
Executed software projects for Travel and Transport and Distribution.
Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
July 2009 to Present
Onsite Co-coordinator IBM Global Services, India
Client: UPS (United Parcel Service). As a Team Lead and Onsite Coordinator responsible for analysis, design, development, testing and implementation of customized solutions UPS (United Parcel Service). Currently located at client site in Wayne, NJ, USA. Responsibilities include:
Responsible for attending business requirement and functional requirement sessions and provide the analysis and the estimates for the requirements.
Prepare technical impact documents.
Provide solutions to meet the client requirement and prepare detail designs.
Prepare project plans for detail design, coding and unit testing and system testing.
Create project plans and resource allocation plans.
Co-ordinate between the offshore and the onsite regarding the requirement.
Create Detail Design review document which includes a summary of all the requirements per release and review the document with users of different applications.
Guide the developers regarding coding and unit testing.
Deliver the solutions to the client and attending review sessions.
Participate in system testing, integration testing and user acceptance testing.
Co-ordinate with different groups of users to perform user testing.
Provide post implementation support.
Co-ordinate with different groups of users during user testing.
Provide process improvement solutions to the client.
My current role is that of a team leader and onsite co-coordinator for UPS. The role required to provide process improvement solutions to the client. The following process improvements were designed and developed by me and has been hugely appreciated by the client. Introduced the concept of external tables resulting in reduction of processing time of pl/sql processes.
Shell script to check the successful completion of a process and sending out email notifications in case any errors occurred.
Shell script to check space in Unix directories and send email notifications in case of space shortage resulting in reducing the number of abends.
Generic shell script to check record lengths for files.
Shell script to update email IDs in email notification files.
Shell script to create report to show the data processed for all processes.
Shell script to automate clean up of space in Unix directories.
Environment: UNIX, Oracle 10g
Team Size: 12
January 2009 to June 2009
Client: Canadian Wheat Board. As an offshore team lead the responsibilities included:
Monitor the status of offshore scope.
Provide guidance to the offshore team regarding technical development.
Release developed objects to onsite.
Provide help to the offshore team during unit testing of offshore objects.
Hold weekly team meetings and maintain MOM for each meeting.
Make sure that all offshore development follows the quality guidelines.
Co-ordinate with onsite SME regarding functional and technical requirements.
Participate in internal audit.
Develop custom objects in pricing.
Environment: Oracle Apps R11
November 2008 to December 2008
IBM Global Services, India
Client: Alticor Inc. Responsibilities included:
To work in BPEL and SOA. Developing BPEL and ESB processes.
Integrating ESB with Oracle Applications. Develop inbound interface in BPEL and ESB.
Worked with a canonical data model.
Worked on R12 TCA APIs.
Environment: Oracle 10g, Oracle Apps R12, SOA, BPEL
June 2008 to October 2008
Client: IBM India Pvt. Ltd. Key responsibilities included:
To create a repository of conversions and interfaces across all modules of Oracle applications.
Develop the functional specifications.
Co-ordinate the team members to get the development work completed.
Provide technical clarity to the team members.
Review the deliverables.
Provide trainings to juniors and help them to develop their technical knowledge in Oracle Applications.
Monitor each object from initialization to completion.
Environment: Oracle Apps 11i and R12
Team Lead/Onsite Coordinator
September 2004 to September 2008
Client: Handleman Company. Joined the Handleman project in Sep 04 in Bangalore, as a developer in Oracle Applications. Received promotion to Senior Systems Engineer in Jun 06 and then to Team Lead/Onsite Coordinator in Nov, 06. Got Promoted to Band 7 in Dec06. As a Team Lead/Onsite Coordinator, my responsibilities include:
Leading an offshore team in delivering solution to the customer.
Responsible for analysis, design, development, testing and implementation of customized Oracle ERP solutions for new enhancements and development.
Creating technical and design documents based on client's functional needs and helping the offshore team to develop codes based on the technical requirements.
Providing functional and technical support for all issues as identified by client.
Responsible for all offshore deliverables and making sure that implementation of any new code is defect free.
Responsible for effective communication between the offshore team and the customer. Provide day to day direction to the offshore team and regular project status to the customer.
Responsible for managing estimates, tracking, change control, aspects of the project.
Leading the efforts including programming and testing that culminate in client acceptance of the results. Providing support to customer during user testing.
Utilize in-depth knowledge of functional and Technical experience in Oracle Applications to deliver solutions to customer.
Ensure that estimations are adhered to.
Have led the offshore team through various phases of the project like 'Wave2-Canada implementation', 'Wave3-TESCO Implementation' and currently working for Wave4-UK Implementation.
Environment: Oracle 9i, Oracle Apps 11i, D2K, UNIX, XML
Team Size: 6 to 10
Masters in Urban Planning
Bachelor's in Architecture
PL/SQL, Unix Shell Scripting, Oracle Applications, Datastage
ERP: Oracle Applications 11i
Development Tools: TOAD, SQL*PLUS, SQL*Developer, Developer 2000 - Forms 6i Reports 6i, Oracle Workflow, MS Visual Source Safe, BPEL, SOA, Datastage
Functional Modules: Finance, Manufacturing, Distribution/Order Management, Travel and Transport
RDBMS: Oracle 8i, 9i, 10g
Languages: Oracle PL/SQL, Unix Shell Scripting
O/S: Windows NT/2000/XP, UNIX, LINUX
Processes: IBM's QMS (Quality Management System)