Profile Snapshot
Pradeep is based out of Delhi & has studied Business Administration, BPT-Bachelor of Physiotherapy from Year 2009-2011 in APGC-Aggarwal PG College, Maharshi Dayanand University.
Pradeep Kumar is Skilled in MS Excel, Corel Draw, MySql and other talents.
Talents
-
Corel Draw... among 0 users in Delhi…among 0 users worldwide -
MS Excel... among 0 users in Delhi…among 0 users worldwide98.6percentile among worldwide users -
MySql... among 0 users in Delhi…among 0 users worldwide -
Adobe Photoshop... among 0 users in Delhi…among 0 users worldwide
Professional Path
VBA Developer
AON Hewitt
Full Time
Dec-2013 To
present
11 years 8 months
- ? Preparing project setups of the companies as per client’s usage and requirements in the organization and also responsible for MIS reporting by using MS Excel and VBA.
? Meeting with different key users to determine system and reporting requirements.
? Developed many software modules that are used to convert raw data into reports and Automate regular reports and generate custom reports as needed.
? Prepare different trackers like Production tracker, In-Progress report, Variance report, Leave Planner and Seat Utilization report through VBA.
? Deliver projects by maintaining quick TAT and highest quality standards execute it in MS Excel too.
? Managing and design Monthly, Weekly Dashboards & Daily Report Creating in MS-Excel through analysis and producing the actionable information.
? Working on the People soft 9.0 Implementation Project for Financial Operations within the organization.
? Extensive usage of VBA (Aggregate functions, Lookup, Pivot table, Macros). - ? Awarded Blue Ribbon Certificate by CFO for best quality work.
? Selected to provide Excel & VBA training to the different processes team members to ensure optimum performance out of 500 employees.
Financial Analyst
TCS
Full Time
Oct-2011 To
Aug-2013
1 years 10 months
- ? Perform analytical review of financial operations of the process; interpret financial data and project the financial probability of process; ensure timely presentation of financial information.
? Working knowledge of Master Feeder Strategy (Hedge Fund Structure).
? Calculate Gross Asset Value and Net Asset Value of different individual funds as well as of Funds of Funds (FOF).
? Prepare final working papers which include Trial Balance, Balance Sheet, Dividends, Accruals and Appraisals.
? P/L reconciliation with trial balance and find variance with the estimated P/L.
? Responsible for maintaining and ensuring completeness of process work papers and related documentations.
? Making all the new updates in the Processing Documents and reviewing them simultaneously which help in processing the job effectively and efficiently.
? Generate and create all the process related reports and deliver to management. - ? Awarded by Sr. Manager to deliver best service delivery in very short time.
? Awarded by GM to showcase our capabilities in front of prospect client.
» 5 Projects
Qualifications
Aggarwal PG College
Bachelor of Physiotherapy Business Administration
2009-2011
-%
My Story
Rated among Top 10% Excel Experts & VBA Expert in ELance.
With more than 4 years of professional experience in MS Excel, Macro (VBA), MS Access, MS Power Point, MS-Word, Tableau.
I am 100% committed to providing my clients with excellent quality of work within the agreed timeline and devotion to making your project the best it can be.
Other professional attributes include: great attention to detail, ability to work independently and efficiently, positive and productive attitude, etc.
With more than 4 years of professional experience in MS Excel, Macro (VBA), MS Access, MS Power Point, MS-Word, Tableau.
I am 100% committed to providing my clients with excellent quality of work within the agreed timeline and devotion to making your project the best it can be.
Other professional attributes include: great attention to detail, ability to work independently and efficiently, positive and productive attitude, etc.
