Sourabh Shukla
Mobile: +91-992*-***-***, Email: ******.*******@*****.***
SYNOPSIS
Around 5 years of experience in implementation and support of Oracle based business solutions for Corporate, Infrastructure, Legal, Software, Banking, Insurance and Real Estate sector services organizations.
Demonstrated capability in all functional phases of implementation – Requirements Study, Gap Analysis, Configuration, Testing, CRP, UAT, User Training and Go-Live and post Go Live support.
Currently, working as HRMS Consultant in techno-functional role, responsible for designing and implementing consulting solutions for the client and customizing and tailor fitting the client requirements in Oracle Apps
EDUCATIONAL QUALIFICATIONS
Degree Year College/University Major and Specialization
Bachelors of Engineering 2005 with 70% (First Class) Manoharbhai Institute of Engineering, Gondia, Maharashtra, India Computer Technology
HSC 2001 with 77.5% (Distinction) Maharashtra Board, India PCM
SSC 1999 with 81% (Distinction) Maharashtra Board, India All
PROFESSIONAL QUALIFICATIONS
Program or Course Coverage Period
Initial Learning Program by TATA Consultancy Services Ltd. , Trivandrum, India 1. System Engineering
2. Software Development Process
3. ISO 9000 and Quality Assurance
4. Foreign Language-Japanese Feb 2006 - Apr 2006
TCS Quality System 6-Sigma certification(Green Belt) ,IQMS, TATA Business Excellence Model May-2006
Roles Played
• Solution Architect
• Subject Matter Expert
• Functional Consultant
• Technical Lead and Data Migration Expert
ORGANIZATIONAL EXPERIENCE
Organization 1:- Capgemini India Pvt. Ltd.
Assignment # 1
Project: Oracle Applications R11 Core HRMS, Leave Management,
Learning Management post implementation support and R12 up gradation
Client: Reputed Client from Netherlands
Sector: Legal, Finance
Role: Solution Architect/Functional Consultant
Duration: March 2010 till date
Skills: Oracle Apps Release-11.5.10 (HRMS)
Description:
• Post Implementation work of full life cycle of Core HR, Leave Management and Learning Management
• This involves resolving support issues and bugs at run time in production environment and suggesting a better and correct solution for the same
• Analyzing the implementation and suggestion of solution gaps if any
• Analysis of the project with respect to the R12 upgrade
Organization 2:- KPMG India Pvt. Ltd.
Assignment # 1
Project: Oracle Applications R12 Purchasing, Core HRMS, Leave Management, i-Recruitment, Performance Management, Learning Management and Self Service Implementation
Client: Integreon Pvt. Ltd.
Sector: Legal, Finance
Role: Solution Architect/Functional Consultant, Technical Lead
Duration: Oct 2009 till March 2010
Skills: Oracle Apps Release-12.1 (HRMS), Oracle Discoverer 10g
Description:
• Implementation of full life cycle of Core HR, Leave Management,
i-Recruitment, Performance Management, Learning Management
and Self Service Implementation (India, US, UK and Philippines Localization).
• This involved designing Org structure, AS-IS process documents and requirement gathering
• Oracle Apps overview session, functionality matrix, responsibility matrix, data migration strategy/template, MIS reporting register preparation.
• Communicate out of scope requirements with valid reasoning
• Discuss with the team on the identified gaps and design To-Be document
• Present the To-Be business flow to the client, answer queries and gain approval of the design from the stake holders.
• Build solution design based on the requirements analyzed
• Build prototype of the solution and demonstrate to the client
• Guiding Technical team for the fast formulae and MIS reports logic
• Conduction of Conference Room Pilot, User Acceptance Testing, User Training sessions.
• Support the applications
• Raise change requests for changes in the configurations
• Track SR’s and send status update to stakeholders
Assignment # 2
Project: Self Services Implementation
Client: Linkwell Telesystems Pvt. Ltd., Hyderabad
Sector: Software
Duration: Oct 2009 – Nov 2009
Role: Solution Architect, Technical Consultant
Skills: Oracle Apps Release-12.1 SSHR
Description:
• Full life cycle end-to-end implementation of Self Service
• This involved requirement gathering and end-user training sessions/manuals. It also involved domain experience and best practice approach for designing approval hierarchy, deployment strategy, discoverer reports, and configuration manuals.
• Document, discuss and analyze requirements
• Communicate out of scope requirements with valid reasoning
• Build solution design based on the requirements analyzed
• Build prototype of the solution and demonstrate to the client
• Build and prepare solution for CRP, UAT (conference room pilot and user acceptance testing respectively)
• Approval Management Engine Setup for self service related transactions.
• Support the applications
Assignment # 3
Project: Oracle Financial Data Migration, Reconciliation and Post Go - Live Support
Client: Akruti City Ltd.
Sector: Real Estate and Construction
Role: Functional Consultant, Data Migration Lead
Duration: July 2009 till September 2009
Description:
• Preparation of Data Migration scripts to migrate the data from legacy system to the Oracle system of purchase orders, invoices and receipts.
• Reconciliation of data of AP and AR modules.
• Posting the entries in GL
• Matching of Trial Balance of Legacy system with Oracle’s Trial Balance
• Discussion with users for issue resolution of support related issues for modules like I – expense, HRMS, Projects, Purchasing, Sourcing, etc.
• Development of concurrent programs
• Bug Fixing and Run Time issue resolution
• Support the applications
• Track SR’s and send status update to stakeholders
Assignment # 4
Project: Oracle Leave Management Implementation in R11.5
Client: Kotak Life Insurance Ltd.
Sector: Insurance
Role: Solution Architect/Techno - Functional Consultant
Skills: Oracle Apps Release-12 (Core HR, Absence Management, AME).
Duration: Jan 2009 till July 2009
Description:
• Requirement Gathering for the Various processes like accruals,
Proration of leaves, types of leave, leave eligibility criteria, etc.
• Freezing the Client Requirements by discussing the gaps if any in the To Be processes
• Communicate out of scope requirements with valid reasoning
• Build solution design based on the requirements analyzed
• Build prototype of the solution and demonstrate to the client
• Build and prepare solution for CRP, UAT (conference room pilot and user acceptance testing respectively)
• Raise change requests for changes in the configurations
• Configuration of Accrual plans, fast formulae, absence types, etc.
• Preparation of Data Migration scripts to migrate the data from legacy system to the Oracle system
• Data migration of balances, plans tagging and absences
• Development of Discoverer Reports using Discoverer
• Development of concurrent programs
• All configuration and set up related activities
• Bug Fixing and Run Time issue resolution
• Customization of Oracle Leave Management system as per client requirements.
• Support the applications
• Track SR’s and send status update to stakeholders
Assignment # 5
Project: Oracle Applications R12 Core HR, SSHR Implementation
Client: Akruti City Ltd.
Sector: Real Estate and Construction
Role: Technical Consultant, Module Lead
Duration: March 2008 till December 2008
Skills: Oracle Apps Release-12 (Core HR and SSHR).
Description:
• Full life cycle end-to-end implementation of Core HR, Self Service .
• This involved requirement gathering and end-user training sessions/manuals.
• Freezing the requirements for Organization structure and work structures related data
• Communicate out of scope requirements with valid reasoning
• Discuss with the team on the identified gaps and design To-Be document
• Present the To-Be business flow to the client, answer queries and gain approval of the design from the stake holders.
• Build solution design based on the requirements analyzed
• Build prototype of the solution and demonstrate to the client
• Build and prepare solution for CRP, UAT (conference room pilot and user acceptance testing respectively)
• Preparation of Data Migration scripts to migrate the data from legacy system to the Oracle system
• Supervising the development of Discoverer Reports using Discoverer
• Development of concurrent programs
• All configuration and set up related activities
• Bug Fixing and Run Time issue resolution
• Approval Management setup for self service related transactions.
• Self Service HR setups and configuration related activities
• Track SR’s and send status update to stakeholders
Assignment # 6
Project: Oracle Purchasing and Sourcing Implementation in R12
Client: Akruti City Ltd.
Sector: Real Estate and Construction
Role: Team Member
Duration: March 2008 till December 2008
Description:
• Requirement Gathering for the Various processes like purchase orders, receipts, taxes, sourcing, RFQ’s, invoices. Advising client about the best practices for purchasing, requisitions, receipts, invoices.
• Freezing the Client Requirements by discussing the gaps if any in the To Be processes
• Configuration of Oracle AME Setups, taxes, inventory orgs, suppliers in Oracle Release 12
• Worked on tax setup for purchasing and setups of sub inventories in R12
• Customization of forms using custom.pll and Forms Personalization
• Preparation of Data Migration scripts to migrate the data from legacy system to the Oracle system
• Development of concurrent programs
• All configuration and set up related activities
• Bug Fixing and Run Time issue resolution
Assignment # 7
Project: Oracle Applications 11i HRMS Implementation and Enhancement
Client: Kotak Mahindra Bank Ltd.
Sector: Banking
Role: Functional Consultant
Duration: January 2008 till February 2008
Skills: Oracle Apps (Absence Management, Core HRMS) and Oracle Discoverer.
Description:
• Implementation of second phase involving Web ADI upload integrators, Position info customization, Appraisal process enhancement (including confirmation process), Alerts, Reports.
• Preparation of design documents, project manuals and reports/formulae customizations.
• Post implementation reviews of existing ERP solution and resolving functional/technical issues of first phase which included Absence Management, Core HRMS and Self Service HR.
• Impact analysis for cross-business group related configurations or changes.
• Provided monthly inputs on Steering committee and Marketing team meetings.
Organization 3:- TATA Consultancy Services Ltd.
Assignment # 1
Project: Oracle Applications 11i Core HR Application Enhancement, Global Payroll and Support
Client: G.E. (International)
Sector: Commercial & Consumer Fin, Corporate, Energy, Transportation
Role: Module Lead
Duration: April 2006 till January 2008
Skills: Oracle Apps (Core HRMS)
Description:
• Was Module Lead of a module called Interpay module which basically acted as an interface between OHR (Oracle Database of employees) and various Payroll systems (Like Hewitt, Personec, ADP etc) for the Payroll and Salary related information.
• This module is a combination of both Inbound and Outbound. It was used for data massaging and send the incremental data to payroll systems.
• Requirement Gathering for the Various Interfaces like Spain, Finland, Sweden and Czech Republic
• Communicate out of scope requirements with valid reasoning
• Discuss with the team on the identified gaps and design To-Be document
• Present the To-Be business flow to the client, answer queries and gain approval of the design from the stake holders.
• Development of concurrent programs for the Extract generation.
• Processing the salary of employees based on the requirements of the various customers.
• All configuration and set up related activities
• User acceptance Testing (UAT) and bug fixing
• Coordination between the payroll Team and Third party vendor for all the Extract
• Provide the incremental data load to the third party payroll systems on a daily basis.
• Monitoring the concurrent requests of the data files on a daily basis as part of Project Monitoring team
• Handled specific System Administration activities like User / Responsibility creation, Request Groups / Sets creation, Concurrent Programs, Executable creation, changes to Flex fields, Compensation and Work structures and monthly releases to Production.
• Global support to the users on day-to-day technical and functional issues.
• Worked in “Re-Organization” project which involved revamping of existing business hierarchy structure to new structure as per new business strategy. This also involved overall analysis of business logic and implementing it with enhanced security and reporting structure.
Assignment # 2
Project: Oracle Applications 11i Production Support and Monitoring
Client: G.E. (International)
Sector: Commercial & Consumer Finance, Corporate, Energy, Transportation.
Role: Module Leader
Duration: April 2006 till December 2006
Skills: Production support and monitoring (MCA - Mission Critical
Application)
Description:
• Responsible for supervising team in mission critical activities and monitoring the functioning of business extracts, security list maintenance and process control batch jobs.
• This involved monitoring of 400 concurrent jobs managing database of 0.4 million users across globe. Coordinating with Oracle for early resolution of business critical issues.
• Organized and styled mechanism for effective escalation and resolution of issues as a member of business continuity plan/disaster recovery plan (BCP/DRP) team.
Assignment # 3
Project: Oracle Applications Six Sigma DMAIC Project
Client: G.E. (International)
Sector: Quality improvement.
Role: Team Member
Duration: April 2006 till December 2006
Skills: DMAIC (6 Sigma), Core HRMS.
Description:
• Project involved giving access to users for minor flexfield updates.
• It was a DMAIC (Design Measure Analyze Improve Control) Six Sigma project aimed at eliminating number of steps in configuring the interfaces for GE payroll module called Interpay
• The project was successfully completed with an annual saving of around $36k.
• Big Y – Cost and Turn around time and Process improvement.
EMPLOYMENT HISTORY
Dates Organization Role
April 2010 – Till date
Jan 2008 – Mar 2010
Feb 2005 – Jan 2008
Capgemini Consulting Pvt. Ltd.
KPMG Advisory Services Pvt. Ltd.
TATA Consultancy Services Limited Technical Lead, Solution Architect
Technical Consultant/Functional Lead
Module Lead
RELEVANT SKILLS
EBS Oracle e-business suite for HRMS (11i,R12), Reports, Web ADI, AME, Personalization, OA Framework
Data Bases Oracle RDBMS 9i,10g
Languages PL/SQL , Java, C
Operating Systems Windows XP , Unix
Tools Tally 7.2, Oracle Discoverer 9i/10 g, Report Builder, WF builder, SQL Server 2005, PL/SQL Developer, Toad , SQL/Data loader, MS Office 2007, Visio/Project
Client Tools Kintana incident reporting tool, IPMS
( Integrated Project Management System )
ACCOMPLISHMENTS/PRESENTATIONS
• Project Star Award at Capgemini for contribution to the project
• Certified ITIL V3 Professional
• Letter of Appreciation and Cash prize from the Head of IT Advisory in KPMG for outstanding performance in the project
• Certificate of ‘Superior Performance’ and ‘Best Team Award’ at TCS
• Certified Green Belt associate (Six Sigma) at TCS
PERSONAL INFORMATION
Full Name: Sourabh Shukla
Discipline: IT Advisory
Date of Birth: 27 July 1983
Languages known: Hindi, English (Fluent), Marathi, Japanese(Basic)
Mobile: +91-992*-***-***
Email: ******.*******@*****.***