Sugam Chhabra Phone: +91-9011076117 01262-210858
Email :
OBJECTIVE
Seeking a career with a progressive organization where I can utilize my skills, knowledge and experience in a challenging role that allows for advancement and growth.
SKILL SET
· Operating System MS Windows, UNIX.
· Computer Languages C, C++, PL/SQL, UNIX scripting
· Databases Oracle9i, Ms Access, Oracle 10g
· Tools MS Office, TOAD., SQL Navigator, VSS (Configuration Management),
All Fusion Harvest Change Manager, Test Director, Mercury IT Governance (ITG Object Migrator ) Clear Quest, Clear Case, Mercury
Quality Center
· ERP software Oracle Apps, Oracle Reports6i, Oracle Forms6i, Workflow Builder , XML
Publisher Reports, Discoverer Reports
WORK EXPERIENCE
Working with Infosys Technologies Limited since 25th July 2005 as software engineer with Enterprise Solutions- Oracle Apps Practice, an Independent Business Unit of the company focused on comprehensive enterprise solutions covering the whole gamut of ERP, SCM, CRM and EAI etc.
Trainings/Certifications at Infosys Technologies Limited, India:
· Technical trainings undergone:
o RDBMS (Oracle8)
o PL/SQL (Oracle)
o Unix
o Financials- Receivables, Payables (Oracle Apps)
o P200 Oracle SD – PO, iProc, AP, FA
o P200 Oracle DVLP – Oracle Apps Technical
· Generic trainings undergone:
o Configuration Management.
o Software development life cycle.
o Client/Server Concepts
o Object Oriented Concepts
o Introduction to Web Architecture
o Soft Skills
· Certifications
o ES Enterprise Functions Certification
This certification focuses on the basics the four areas viz. Manufacturing (HTDM), Financials, HRMS and CRM.
PROJECT DETAILS
Project: WACHORSP (Oracle Apps 11.5.10.2)
Timeline: 1st June’09 – till date
Client: One of the leading banking corporation in the USA.
The client has implemented iProc, PO, OM-WMS, AP and FA. The project scope includes support of Oracle Apps 11.5.10.2.
Role: Team Lead – AP and FA
Responsibilities:
- Planning and Estimations for Change Requests as per user requirement. This typically involves Oracle Forms6i, coding and testing of PLSQL Packages and Interfaces.
-Planning and assigning work to the team.
-Coordinating with Onsite team to clarify on issues and synchronize deliveries.
-Managing Code Migration activity using ITG Object Migrator.
-Documentation, Design and Reviews of the deliverables for the team
Achievements:
-Successfully lead the team through entire duration of the project with excellent Issue Resolution stats.
-Conducted knowledge sharing sessions.
-Handled the team while coordinating defect-free deliveries ahead of schedules.
-Banded in A-group during Appraisal.
Tools: SQL Navigator, All Fusion Harvest Change Manager, Test Director, Mercury IT Governance (ITG Object Migrator ), Mercury Quality Center
Team size: 6 (peak strength).
Project: AETNA- MOD Reports (Oracle Apps 11.0.3 to Oracle Apps 11.5.10.2)
Timeline: 1st Feb 09 – 31st May 09
Client: One of the leading insurance company in the USA.
The client has implemented OM and AR. The project scope includes creation of 20 Oracle Reports and Performance Tests those reports.
Role: Onsite Coordinator and Team Lead
Responsibilities:
- Planning and Estimations of effort required for Report development and testing as per user requirement. This typically involves Oracle Reports 6i.
-Planning and assigning work to the team.
-Coordinating with Onsite team to clarify on issues and synchronize deliveries.
-Managing Code Migration activity using ITG Object Migrator.
-Documentation and reviews of the deliverables for the team.
Achievements:
-Successfully lead the team through UAT with excellent Issue Resolution stats.
-Conducted knowledge sharing sessions.
-Handled the team while coordinating defect-free deliveries ahead of schedules.
-Banded in A-group during Appraisal.
Tools: TOAD, All Fusion Harvest Change Manager, Test Director, Mercury IT Governance (ITG Object Migrator), Clear Quest
Team size: 5 (peak strength).
Project: AETNA- AR (Quality Assurance)
Timeline: 1st Dec’07 – 31st Jan’09
Client: One of the leading insurance company in the USA.
The client has implemented Oracle Account Receivables. The project scope includes testing of any new project, enhancement and production defects. It also includes coordinating with upstream and downstream applications for end-to-end testing.
Role: Onsite Coordinator
Responsibilities:
-Planning and Estimations of effort required for testing of enhancements, projects and defects.
-Planning and assigning work to the team.
-Coordinating with Client to clarify on requirement and synchronize delivery.
-Managing Code Migration activity using ITG Object Migrator.
-Analysis of the system after code-migration and improving the process.
-Documentation and reviews of the deliverables for the team.
-Implementing defect prevention processes in the team.
Achievements:
-Successfully lead the team through entire duration of the project
-Got excellent engagement feedback (7/7).
-Handled the team while coordinating defect-free deliveries ahead of schedules.
-Banded in CRR1 during Capability Relative ranking.
Tools: PLSQL editor, Clear Quest, Test Director, Mercury IT Governance (ITG Object Migrator), Clear Case
Team size: 10(peak strength).
Project: COLT – XNG Reports
Timeline: 1st Jun ’07 – 30th Nov’07
Client: One of the leading Telecom industry in UK
The client has implemented a custom application for Reporting Purpose which calls Oracle Reports and discoverer Reports. The project scope includes supporting already existing reports, developing new reports and suggesting and implementing process improvement.
Role: Team Lead
Responsibilities:
- Planning and Estimations for new developments and enhancements as per user requirement. This typically involves Oracle Reports, Discoverer Reports and PLSQL
-Planning and assigning work to the team and helping them with design and coding.
-Coordinating with Client to clarify on issues and synchronize deliveries.
-Managing Code Migration activity using ITG Object Migrator.
-Analysis of the system after code-migration and improving the process.
-Documentation and reviews of the deliverables for the team.
-Weekly Status Reporting
Achievements:
-Successfully lead the team through entire duration of the project with excellent Issue Resolution stats.
-Conducted knowledge sharing sessions.
-Issues Resolution within the specified SLA.
-Banded in A-group during Appraisal.
Tools: TOAD, All Fusion Harvest Change Manager, Test Director, Mercury IT Governance (ITG Object Migrator)
Team size: 3(peak strength).
Project: COLT – Oracle Apps 11i Support
Timeline: 31st Dec ’06 – 30th May’ 07
Client: One of the leading Telecom industry in UK
The client has implemented Inv, PO, AP, AR and GL. The project scope includes support of production issues and enhancements in the project.
Role: Software Developer - PO
Responsibilities:
- Estimation, Development and Testing of defects and enhancements as per user requirement. This typically involves Oracle Forms6i and XML Publisher.
-Coordinating with Onsite team to clarify on issues and synchronize deliveries.
-Managing Code Migration activity using ITG Object Migrator.
-Analysis of the system after code-migration and improving the process.
-Documentation and reviews of the deliverables for the team.
Achievements:
-Successfully handled the PO track through entire duration of the project with Excellent Resolution stats.
-Conducted knowledge sharing sessions.
-Provided defect-free deliveries ahead of schedules.
-Banded in A-group during Appraisal.
- Provided deliveries within the specified SLA
Tools: TOAD, All Fusion Harvest Change Manager, Test Director, Mercury IT Governance (ITG Object Migrator)
Team size: 6(peak strength).
Project: WACHUPGR (Oracle Apps 11.0.3 to 11.5.10.2).
Timeline: 1st Jan’06 – 30th Nov’06
Client: One of the leading banking corporation in the USA.
The project scope includes upgrade of iProcurement, PO, OM-WMS, AP and FA modules from Oracle Apps 11.0.3 to 11.5.10.2.
Role: Software Developer – iProc and PO
Responsibilities:
-Development and Upgrade of Oracle Apps components as per user requirement. This involved Oracle Forms6i, Oracle Workflows, coding and testing of PLSQL packages and interfaces.
-Documentation and reviews of the deliverables of the team.
-Coordinating with Onsite team to clarify on issues and synchronize deliveries
-Documentation and reviews of the deliverables of the team.
-Managing Code Migration activity using ITG Object Migrator.
-Analysis of the system after code-migration and improving the process.
Achievements:
-Customized and developed a complex PLSQL program that is used to get data from Inventory to iProcurement.
-Conducted numerous knowledge sharing sessions, both generic and enhancements specific.
-Identified the objects impacted due to upgrade activities using an in-house tool.
-Received CRR 1 (Consolidated Relative Ranking) during Appraisal.
Tools: TOAD (Oracle client), VSS, Oracle Reports6i, Oracle Forms6i, In-house Upgrade tool.
Team size: 40 (peak strength).
EDUCATIONAL QUALIFICATIONS
· B.I.S ( Bachelors in Information Science- 4 yrs) from Maharishi Dayanand University, Rohtak (University College, Rohtak) in 2004 with 76% marks
· XIIth (CBSE) from University Campus School, Rohtak (Haryana) in 2000 with 78.6% marks.
· Xth (CBSE) from University Campus School, Rohtak (Haryana) in 1998 with 65.2% marks.
PERSONAL DETAILS
Date of Birth : 27th Oct 1982
Present Address : Flat-5, Ajay Aptts, Aundh,
Pune
Permanent Address : 201-L,Model Town, Rohtak (Haryana) - 124001
Phone No. : 01262-210858
Languages : English, Hindi.
Passport No. : F5281741
Validity Period : 16 Nov 2005 to 15 Nov 2015
Visa / Work Permit : H1- B
Validity Period : 01 Nov 2007 to 17 Jun 2010