Software Designer
Software Designer looking for employment in London
Skills:
PeopleSoft v8.8 / 9.0, Application Engine Program, Component Interfaces, SQR, PeopleCode, Application Designer
Work Experience:
AMIT GIROTTEE
Email : amit_girottee@yahoo.co.in
Phone : +91 9871842881
Experience Summary
Over 9.8 years of total IT experience working with the fortune 500 companies. Extensive hands on SDLC experience having started out as a developer to managing engagements.
The following lists some of significant achievements during this time:
Lead the Royal Bank of Scotland India development Centres (RBS IDC) first PeopleSoft project delivery Business Take On (Mergers and Acquisitions) dual shore program by providing development and support services from teams based in UK and India.
Zero Defect Project deliveries.
Strive to continually deliver the highest quality deliverables within the stipulated timelines.
Excellent understanding of PeopleSoft base architecture with expertise in Human Capital Management (HCM).
Technical Expertise in configuration and customisation of key PeopleSoft HRMS 9.0/ 8.8 Modules including Administer Workforce, Self Service.
Designing & Development of GUI based Client Server Applications, mainly using -
o PeopleSoft - 8.8/ 9.0, PeopleTools v 8.48, v 8.43.12 , DB2 OS/390 7.1.1
o Developer 2000 & Oracle 8i.
Achieved 50% cost reduction by implementing PeopleSoft HCM 9.0 in UK, Republic of Ireland, India, Spain and Portugal for The Royal Bank of Scotland Group thereby delivering a savings of over £5 mn every year.
Adept at evaluating existing product functionality and translate business requirements into high-quality Functional and Technical Design specifications.
Excellent verbal and written communication skills.
Established team-player as well as a highly motivated self starter with a passion for detail and quality.
Experienced in deriving test scenarios, analysis of Test cases.
Strong debugging, problem solving and analytical skills with excellent understanding of system development methodologies, techniques and tools.
IT Skill Set
Operating System OS 390, SCO Unix, Red Hat Linux, Windows NT 4.x, Windows 95 98,Windows 3.13.11, DOS Ver 6.22,Novell Ver 3.11
Hardware Platforms Pentium Series, IBM PC- Compatible
RDBMS DB2 for OS/390 7.1.1, Oracle 8i, MS SQL Server 2000, Sybase, MySQL.
GUI/ Front Ends Windows NT, MS Windows
Programming Languages PeopleTools v 8.43.12/ 8.48 (Application Designer People Code, Application Engine Programs , Component Interfaces, File Layout, WorkFlow), SQR , Configuration Manager, Data Mover Ascential Datastage, Developer 2000, C under Unix & DOS, C++, Visual C++ 5.0,Visual Basic 6.0,VJ++ 1.0, Sun Java (Servlets,EJB,JSP,HTML, JavaScript, JDK 1.x , Jbuilder, FrontPage 98, JDBC),COBOL,CICS,JCL
Software Packages Test Director v7.2, Clear Case,MS VSS v1.5,
Specific Bank / Insurance Experience/Systems :
- PeopleSoft HRMS 8.8/9.0 customised for The Royal Bank of Scotland Group.
- CODIS (Churchill Online Direct Insurance System) developed for Churchill Insurance on Developer 2000, Oracle 8.1.7.3
Employment History
The Royal Bank of Scotland Group formerly Churchill India
Gurgaon, India
March 2003 September 2009
Desig : Software Designer
Earlier deployed in Scotland, Edinburgh for about 1 and half years as an onsite Implementation Manager.
Datamatics Staffing Services
Worked as a Contractor at Churchill India
September 2002 to March 2003
Neptune Information Solutions Ltd.(A Jindal Group IT Company)
February 2000 to September 2002
Projects Undertaken
Data Migration ABN AMRO Block 3 - GBR Employees
Client : ABN AMRO Bank
Location : Gurgaon
Duration : 6 months
Team Size : 5
Environment: PeopleTools v 8.48.08/ 9.0, DB2 for OS/390 7.1.1
The project is about replicating the steps of Application Engine Programs / Component Interfaces used in Data migration into SQRs for faster migration of employees of the acquired ABN AMRO Bank in HCM 9.0. The fields of all principle tables loaded by SQR run in a database are then compared one by one with the output of data load by Application engine programs. Any discrepancy between the source and destination load is reported and corrective action is taken to bring the two outputs in sync.
Responsibilities:
Business Engagement.
Resource and Task Management.
Zero Defect Delivery.
Managed the Global Operating Model project and Lead the offshore team.
Co-ordination with UK Business Analysts for Functional Requirement Specifications.
Handled Change Management Board.
Represented Project team at Project Control and Co-ordination board.
Conducted Implementation Plan walkthrough with all interested parties like DBAs, Storage Management, Application Product support etc.
Managed implementation and warranty support
Authored Personal Data, Bank and Contract Data SQRs for Data Migration.
Project Closure Report
ABN AMRO Block-1 - Austria, Switzerland Netherlands and GBR Employees
Client : ABN AMRO Bank
Location : Gurgaon
Duration : 10 months
Team Size : 3
Environment: PeopleTools v 8.48.08/9.0, DB2 for OS/390 7.1.1
The project is about data migration of current row take on of all active employees for Austria, Switzerland Netherlands and GBR Employees. Ascential Datastage is used for extraction of data from flat files and subsequent application of transformation rules. The data is then processed by application engine programs via Component Interfaces to load the employees into Global PeopleSoft HCM 9.0.
Responsibilities:
Resource Planning
Client Handling.
Managed the offshore team and co-ordinated with UK counterpart Project Manager
Authored Application Engine Program using Component Interfaces for Data Migration
Co-ordination with Business Analysts for Functional Requirement Specifications.
Handled change management board.
Conducted Implementation plan walkthrough with all interested parties like DBAs, Application Product Support etc
Managed Implementation.
Project Closure Report
Intra Team knowledge transfer.
Global Operating Model India , Spain and Portugal
Client : Royal Bank of Scotland
Location : Edinburgh,Scotland, Gurgaon
Duration : 10 months
Team Size : 5
Environment: PeopleTools v 8.48.08/9.0,SQR, DB2 for OS/390 7.1.1
The project involves Data Migration into PeopleSoft HCM 9.0, current row take-on of active employees and historical loading of Active and Non-active employees for India, Spain and Portugal. Ascential Datastage connects to the data sources for extraction of employee data followed by applying any transformation rules and stores it in staging table. The reference data mapped by file layout is processed via a PeopleSoft Component interface deployed with an Application Engine program. The employee data is loaded using SQR. Subsequently all the history transactions for active and non-active employees are also migrated using SQRs.
Responsibilities:
Client Engagement.
Task and Resource Planning.
Feasibility study and fit gap analysis.
Authored Application Engine Program and created Component Interfaces
Managed the Global project and Lead the onsite/offshore team.
Co-ordination with UK Business Analysts for Functional Requirement Specifications.
Intra Team knowledge transfer.
Data Scrambling
Client : Royal Bank of Scotland
Location : Gurgaon
Duration : 3 months
Team Size : 2
Environment: PeopleTools v 8.48.08/9.0, DB2 for OS/390 7.1.1
The project is about encrypting personal details of all RBS employees in order to protect their respective data. The datasets are unloaded from the Production and data scrambling COBOL routines are run against them on the mainframe which results into a scrambled datasets. These datasets are then integrated to provide a scrambled platform for development and testing databases.
Responsibilities:
Lead the offshore team.
Co-ordination with Business Analysts, DBAs, COBOL developers.
Global Operating Model UK, Republic of Ireland
Client : Royal Bank of Scotland
Location : Edinburgh,Scotland, Gurgaon
Duration : 6 months
Team Size : 5
Environment: PeopleTools v 8.48.08/9.0,SQR, DB2 for OS/390 7.1.1
The project involves PeopleSoft HCM 8.8 SP1 to 9.0 Data Migration of Hire row, current row take-on and historical loading of Active and Non-Active employees for UK and RoI. The reference and employee data is migrated using SQRs.
Responsibilities:
Business Engagement.
Resource Management
Authored SQRs for Data Migration from PS8.8 to 9.0
Co-ordination with UK Business Analysts for Functional Requirement Specifications.
Handled Change Management Board.
Implementation Planning and walkthrough with all interested parties
Managed implementation and warranty support.
User Identification Management
Client : Royal Bank of Scotland
Location : Edinburgh,Scotland
Duration : 6 months
Team Size : 2
Environment: PeopleTools v 8.43.12/8.8, DB2 for OS/390 7.1.1
User Identity Management (UIM) is a project to link user profile information from a number of systems (PeopleSoft, RACF etc.) in a central database to enable systematic processing of leavers, joiners and movers. For example when a new employee is entered in PeopleSoft the details will be passed to UIM and forwarded to other "security" systems for a new profile to be added with the appropriate roles and permissions.
Project and Task Planning
Involved in defining and gathering functional requirements
Developed Interface using SQRs.
Faced Change Management Board, Conducted Plan walkthrough, implementation and warranty support
Business Take On (BTO) - GT Dublin, Adam & Co., Coutts & Retail
Client : Royal Bank of Scotland-GT Dublin, Adam & Co., Coutts & Retail
Location : Edinburgh,Scotland
Duration : 8 months
Team Size : 5
Environment: PeopleTools v 8.43.12/8.8, DB2 for OS/390 7.1.1
The project is designed to load employee data from The Royal Bank of Scotlands mergers and acquisitions into PeopleSoft HRMS v8.8. The project is categorised into:
BTO Migration : The project involves migrating employees to the RBS Group HR & Payroll systems based on their current terms & conditions. The source data records reside on non-standard source systems (i.e. not the RBS Group systems).
BTO Integration : Integration is about changing terms and conditions of RBS employees whose HR and Payroll related records reside on the RBS Group systems already.
Responsibilities
Project planning, Leading the onsite team, strategic and tactical planning for Dual Shore Development and Support Model.
Involved in defining and gathering requirements, overall scope definition in terms of functional and technical requirements.
Developed PeopleSoft Application using Application Designer, PeopleCode, Application Engine, Component Interface, File Layout for inbound interface.
Authored Backout SQRs.
Change Management Boards, Planning implementation dates, Change freeze, conducting implementation plan walkthroughs with interested parties like DBAs, Batch Development, Storage Management, HRMS Admin. APS (Application Product Support), Business Analysts etc.
Essential Maintenance
Client : Royal Bank of Scotland
Location : Edinburgh,Scotland/Gurgaon,India
Duration : 1.8 Years
Team Size : 4
Environment: PeopleTools v 8.43.12/8.8, DB2 for OS/390 7.1.1
Essential Maintenance is application enhancement / post implementation maintenance project of the customised version of PeopleSoft HRMS 8.8 installed at the Royal Bank of Scotland and spans all stages of software development life cycle including design, development, testing, implementation and support.
Responsibilities
Involved in defining and gathering requirements, overall scope definition in terms of functional and technical requirements.
Designing, development (Application Designer People Code, Application Engine Programs , Component Interfaces, WorkFlow, Data Mover, SQRs, Process Scheduler etc), testing and maintenance of the assigned enhancements.
Involved in the customisation of existing SQR programs as per the client requirements
Resolve complex technical or project related issues
Ensured adherence to technical standards and design principles.
Customised pages based on user requirements.
Design and modify PeopleCode based on user requirements.
Documentation and Testing, preparing test cases, bug reports, code reviews.
CODIS Production Support System
Client : Churchill Insurance
Location : Gurgaon,India
Duration : 3 months
Team Size : 7
Environment: Developer 2000, Oracle 8i ,Pentium PC, Windows NT
A 24/7 helpdesk service for Churchill Online Direct Insurance System to assist users with technical problems related to the claims and any post warranty project support and maintenance.
Responsibilities
Client Handling
Picking up helpdesk calls to endeavour to clear all calls well within the contractual time.
Monitoring showstopper Daily/Weekly/Monthly reports and batch Jobs status.
Adhoc report generation for the Customer Service Agents/Business Analysts
Support to other functional areas like MIS, Print etc.
Post implementation Project Support and Maintenance
Software Configration Management
Group Operational Claims
Client : Churchill Insurance
Location : Gurgaon,India
Duration : 6 months
Team Size : 6
Environment: Developer 2000, Oracle 8i ,Pentium PC, Windows NT
GOC project is about changes required to the Churchill Online Direct Insurance Claims Systems such that new claim is automatically allocated to the correct offices and teams. All production car claims reports were to be split up against the Insurer and then on locations and teams. In the initial system multiple reports get generated for the insurer. The project required only one report to be generated for all locations and teams for an Insurer.
Responsibilities
Lead design efforts.
Played the role of a Technical Lead Analyst / Quality Representative/ Software Configuration Manager - Involved in gathering and defining requirements, overall scope definition in terms of functional and technical requirements.
Supported a team of 4 members in development and testing of the project.
Faced external project audits for CMM Level 4 certification
First Response Unit(FRU)
Client : Churchill Insurance
Location : Gurgaon,India
Duration : 6 months
Team Size : 7
Environment: Developer 2000, Oracle 8i ,Pentium PC, Windows NT
FRU is a generic system that records claims for CSG (Claims Service Group), on the first response basis, for policies underwritten by insurers other than Churchill Insurance. The project requires providing a suite of accident management services to the open market. It requires recording minimal required claim details in CODIS (Churchill Online Direct Insurance System) system, wherein the policy details may or may not be available, and to provide the basic services to the brokers or the open market.
Responsibilities
Involved in gathering and defining requirements, overall scope definition in terms of functional and technical requirements.
Designing, development, testing of the project.
Created Complex Program Specifications.
AGNet-2
Client : Comptroller and Auditor General of India(CAG)
Location : New Delhi
Duration : 3 Months
Team Size : 1
Environment: Red Hat Linux 7.2, Apache Web Server, PHP, Compaq Deskpro 350
AGNet-2 is a web-based application that allows sharing of points of contact information between members of the Global Working Groups. Its primary aim is to provide information to help identify designated points of contact for specific topic areas, so as to facilitate direct contact by e-mail, phone and fax.
Responsibilities
Installation & Maintenance of Red Hat Linux 7.2 O/s , MySQL Database server
Deployment of Apache Web Server and the global working group application
Troubleshooting , Debugging and maintenance of the application
Human Resources Management System & Payroll
Client : SOS Children Villages of India
Location : New Delhi
Duration : 7 Months
Team Size : 2
Environment: Developer 2000, Oracle 8i ,Pentium PC, Windows NT
A module of the integrated ERP suite, Trident HR & Payroll is a solution that integrates core functions like
- Personnel Information (Skills and Qualifications, Employment History & Salary, Medical Records, Records of leave, absenteeism, Late Coming & Excess Work, Family Details, Linkages to Payroll),
- Appraisals(Alternate Functions ,Strengths and weaknesses from Past Performance, Roles, Responsibilities & Objectives vs Achievements)
- Training & Development
- Data porting from Attendance record
- Paytype based earnings/deductions formula for Salary
- Earnings calculation
- Pay-slips generation
- Leave Encashment, ESI Coverage & Statutory Reports etc.
Responsibilities:
Responsible for the complete LLD , customisation and implementation of the customised product.
Coded Forms & Reports, Created the unit and integration test cases
Export Management System
Client : JAGUAR Over Seas Limited
Location : Delhi
Duration : 6 Months
Team Size : 5
Environment: Developer 2000, Oracle 8i ,Pentium PC, Windows NT
This is a highly parameterised system, which duly takes care of inflow and outflow of Export Orders & Goods in the company. Activity starts from Inquiry there after costing based on various parameters with various specifications, Quotation, Performa Invoice, Internal Work Order, Vendor Purchase Order, LC & Advance tracking and complete International standard Documentation.
Responsibilities:
Was responsible for Client Handling, system redesigning, Impact analysis & changes in SRS, HLD, LLD & Test case Documents.
Trident Materials Management
Client : Jamna NHK Alleward
Location : IMT Manesar
Duration : 6 Months
Team Size : 5
Environment: Developer 2000, Oracle 8i ,Pentium PC, Windows NT
The project was designed to automate the Inventory of the company working in retail, wholesale and distribution. This software offers the following features.
Inventory Control Input Material Received, generate reports on Total stock received, quantity on hand, Daily/Weekly/Monthly stock position reports, Reorder level for regular consumable etc.
Vendor Tracking - Supplier Status, Procurement(Indenting and Inquiries generation with tracking from all quotations received.
Generation and amendment of Purchase Orders Direct/Indirect/Fixed/Open/Jobwork.
Maintenance of different logical warehouses (Multi-Location stores, Store wise stock control levels for Max, Min and ROL.
Goods Receipts Note generation - System provides for accepting Challan and Inspection details.
GRN Rejection linked with Returnable Gate Pass to send the material out of company premises.
Gate Pass generation of type Returnable and Non-returnable,
Internal Receipts and Issues for store-to-store transactions.
Vendor-Item mappings for inquiry generation.
Item-warehouse mapping for Single Item multiple locations availability concept.
Payment terms and conditions codified for a standardized language of PO.
Responsibilities
Customisation and Implementation of the product.
Designing forms and reports as per the customisation requirements.
Trained the Users at various levels for effective use and maximum throughput from the system.
Trident Financials
Client L.P Castings
Location : Delhi , Bhiwadi (Rajasthan)
Duration : 10 months
Team Size : 5
Environment: Developer 2000, Oracle 8i ,Pentium PC, Windows NT
Trident Financials addresses the basic Ten (Ten) vouchers of any financial system, i.e. Cash & Bank Receipts & Payments, Purchases, Sales, Debit Notes, Credit Notes Journal Vouchers, Opening Balance vouchers. Each Voucher has a set of control dates i.e. Voucher Date, Authorisation Date and Posting Date and keeps track of the accountability and the time-stamp to provide a complete audit trail and chronology of events. The application also incorporates, five basic functional Areas Of finance ie Accounts Payable, Accounts Receivable, Reconciliation, Cheque Printing and Tax Deducted at Source.
Responsibilities:
Designing forms and reports as per the customisation requirements.
Integration with other modules of the ERP package
Troubleshooting and Debugging the existing code
Trained the Users at various levels for effective use and maximum throughput from the system.
Education:
Degree / Diploma Year University/ Educational Institute
Corporate Training in PeopleSoft HRMS 2004 PeopleSoft
Corporate Training in Mainframes MVS architecture, COBOL, CICS & JCL, WebSphere and DB2 2004 Interra Technologies
Corporate Training in Advanced Java 2004 New Horizons
Cleared 3 exams of DOE A Level 2001 Department Of Electronics
Corporate Training in Java 2000 NIIT
Certificate Course In Computing 2000 Indira Gandhi National Open University
GNIIT Professional Diploma in Network Centred Computing (Software), was awarded a gold medal for the best academic performance. 1999 NIIT
Economic(Hons) 1997 Delhi University College of Vocational Studies
Class Xll 1994 Air Force Bal Bharti School
---------------------------
