BIKRAMJEET SINGH SYAL
(Offering *+ years of extensive corporate experience)
(Contact: ; Ph: 989-***-****)
Qualification:
Academic
Standard
School/University (College)
Year of Passing Exam
PGDBM
IMT Ghaziabad
Pursuing
B.Com
Delhi University
1998 - 2001
12th Standard
Gita Bal Niketan Public School, (CBSE Board)
1997 - 1998
10th Standard
Gita Bal Niketan Public School, (CBSE Board)
1995 - 1996
Professional
Have done SQT (Software Quality Testing) course from ATS Computers, Lajpat Nagar.
Have done 3+ years Advance diploma in Computers from STG, Faridabad.
Currently working for Bank of America as
(Team Leader - Oracle Support Consultant) (July 2013 - Till date)
Core responsibilities include:
Creation of Revaluation formula and setting up revaluation ranges etc.
Setup of Mass Allocation formula.
Request sets creation, scheduling and running.
Creation of KFF and DFF.
Reconciliation between the different applications of the bank for Accounts Payable
i.e Concur/Oracle/SAP make sure all is in sync.
Presenting the IC variance analysis of all LE controllers and taking calls, setting up
meetings and regular follow-ups.
Handle month-end activities single handedly.
Impart Trainings to onshore and offshore users thru calls, online web hosting and
presentations etc.
Rewards and Recognitions :
Received Bronze Award for by the LOB twice once in Q1'2014 and Q4'2014 for client
centric and performance.
Appreciated in by the LOB in the quarterly call
Appreciated by the management and have been given cheers points.
Worked for GE Capital ANZ Genpact as
(Oracle Apps Consultant) (Aug 2008 - June 2013)
Responsibilities handled:
Technologies
: Oracle Apps (11i)
: General ledger Module,
: Fixed Assets Module
: Accounts Payable Module
: PA Module (include Recs. preparation)
: Oracle BI Discoverer - 10g, 11i
Operating System
: Windows
Databases
: Oracle (Basics of SQL) & TOAD
Miscellaneous skills:
: MS-word, Ms- Excel, Powerpoint
AREA OF EXPERTISE IN ORACLE
Running of Remeasurement and Revaluations in Primary and reporting SOBs.
Preparation of Reconciliation for finding the variance between the projects been transferred from Oracle GL to Commercial Finance GL on daily basis.
Interfaces of Various Sub-Systems to Oracle GL.
Scheduling of auto request to automatically perform daily interfaces.
Running Year End Roll on yearly basis and resolving error faced while performing activity.
Additions, retirements and cost adjustments of Assets in FA module.
Adjustment of excess or short depreciation. Transfer of assets from one cost centre to another cost center.
Closing Period after resolving the discrepancies in FA Module.
Set-up of Project and extension of end date of project
Capitalizing and closing of project after all cost pertaining to project has been expensed or capitalized.
Interface of ET&L invoices for AP users.
Creation of new users, adding and deleting responsibilities for existing users, Password reset for the users in Oracle.
Creation of request set to automate interface process.
Projects Undertaken:
Remeasurement range review Project: - Appreciated in GE news letter for successful completion of project and migration of changes in production after PVT (production verification testing).
Zero Balance Closer Project: - Successfully closed 20000 strings in GL in 1 year after ensuring that there is no balances and transaction in all SOB (set of book) in last six month.
COA Simplification Project: - Under this Project I have closed 5000 sub accounts after ensuring that there is no balance and transaction in last six month in all SOB. Closed 200 Product codes which were not used since last 1 year.
Process Improvement Through Lean
Lean ideas tested and implemented in Oracle process improvement:
Month Process Improvement - After implementation of lean idea month end process total time was cut down by 5 hrs monthly hence saved ~60 hrs p.a & USD $1,522
Fixed Asset Process Improvement - After implementation of lean idea FA close cycle time reduced from 1hr to 20 min per invoice & USD $2675
Trainings Undergone
Lean
Six Sigma
Business communication skill, Presentation skill training
Oracle GL training, AP training, FA training & Project training
Excel training
Worked for Genworth as
(Process Associate) (May'2006 - Aug'2008)
The Genworth's Exception Mgmt. Team was required to issue life insurance policies, wherein we were involved in processing of exceptional tasks generated by Genius system as a fall out of data entry done by legal and medical data entry teams. In cases of any misses in the documents, we needed to follow-up with the agents and underwriters for the missing/pending documents so that policies can be issued on time. Performed at 6 Sigma level.
Timely prepared various insurance companies' variance report for our VP and got appreciated for the same
Filed a lean idea for automation of training sheet, which has been approved and implemented in the process.
Rewards and Recognitions :
Received ‘BUILD Award' from the business controller in Q2'08 for being quick learner of Oracle activities.
Received Bronze Award from AVP in Q4'08 for handling oracle piece independently for six month and giving exemplary performance and extended more than business hour in need of business.
Received ‘Team Award' from the biz controller for exemplary performance in Q4'09 for quarter close and successful transfer of IBS edit clearance which was done at biz end before.
Received ‘Expertise & Inclusiveness' from the Biz controller in Q2'10 for successful completion and implementation of Remeasurement Project and supporting Biz and delivering task timely and accurately.
Initiatives Other Than My Profile
Been Transport SPOC since Oct'09 and helping the team in any issues faced by them in relation to transport etc.
Helped my manager in organizing the Team Outing for Jim Corbett Park in Jan'10.
Have successfully organized a party twice on behalf of Genpact when the Financial Controller & US Reporting Leader was on GENPACT's visit in Nov'09 and now in July'10.
Actively participated in team activities like Bay Decoration & organizing a Dance number in the customer party etc.
TechBooks Intl. Pvt. Ltd.
(Data Analyst) Jun'2004 - May'2006
Designation : Data Processor
Platform Used : Windows, MS-Dos
Operating Packages : SGML/XML, HTML, LaTex, MS-Excel, MS-Word,
MS-PowerPoint.
Area of Work : Operations
Client : Cambridge University Press, McGraw Hill, Lippincott
Williams & Wilkins and Oxford University Press
Job Profile:
Involve reports generation : Collate data on daily basis received from various centers across India and generate reports on daily, weekly, Fortnight and quarterly basis and send across to the client.
Data formatting/conversion : In content transformation I was required to take static
information from the printed documents to electronic files
Date :
Place : (Bikramjeet Singh Syal)
Note: Minimum of 30 days notice period would be required before joining the company.