Neha Kohli

E-19, 1st Floor, Sham Nagar,

Vishnu Garden, New Delhi– 110018

Permanent Address

Flat No. 132 A, Block C,

Express View Apartment, Sector 105,

Noida – 201304

Mobile: +91-9871502663

Email:

CAREER OBJECTIVE:

  • Proclivity to Attain, maintain and further strive for a challenging position in the profession utilizing the skills and experienced possessed.

SKILL SUMMARY:

  • Total 5Years 1 month experience in Project Coordination, Data Warehousing, VBAMacros (Excel and Access Based), MIS, SQL, and Ms-Access providing quality work beginning from initiation and definition to deployment and support,and grown to Mentor. Good knowledge on Crystal Report and Visual Studio. Able to create and maintain high level reporting. Knowledge of Business Continuity Plan, Incident Management, Risk Analysis, UK Pension, SDLC (Software development Life Cycle) and OOP’s Concept.

•Role at present organization – Individual Contributor. Role at Previous organization - Assist 16 team members as Project/Business Coordinator

•Coordinating with Onshore Team – As a part of various projects involved in communicating with onshore team for resolution of queries and acquired various online trainings.

•Process Improvements (migrating excel based processes to automated platforms). Read & analyse adhoc work request (txt, dat, csv, xls data files) through VBA Applications (developed internally) and analyse input data to produce reports (excel, csv or text files). Handling testing and support to various projects.

•Manage Time & Budget Data to produce analytical reports – Process documentation,developing flowcharts, tracker documentation.

•Database Management - Create & Maintain databases (MS Access) with programmed applications.

•Specification – Calculation Programming to be specified including work flow.

•Mail Merge Project – involves Excel/.csv files using complex instructions to be processed.

DOMAIN Expertise:

  • Analysis & Reporting,Testing
  • Project/Business Coordinator
  • Creation &Maintaining Databases
  • Process improvements
  • UK Pension and Benefit Knowledge & Financial Knowledge
  • Business Continuity Plan, Incident Management and Risk Analysis Domain knowledge

TECHNICAL SKILLS:

Languages:-SQL, VBA Programming, Advance Excel expertise.

Platforms: - Win 9x, Win 2000, Win XP

Operating systems:-Windows 2003 Server/98/2000/XP

Database:-Migrating excel based processes to automated platforms, Sybase

CURRENT EMPLOYER:

Mercer India Pvt Ltd. – 1st May 2009 till Date:-

Working as Lead Implementation Analyst atMercer India Pvt. Ltd. Have SQL expertise. Developed various macros using VBA application and MS-Access. Identified risks involved in the project, analyze the requirement and helped generate report to deliver Business Intelligence Information in most user friendly & cost effective manner. Involved in assisting16 team members in assigning task, handling queries and providing resolution.

As a part of my profile, my role involved:-

Responsibilities:

  • Team Handling experience, involved in developing team projects, Dashboards
  • Involved in project management using SDLC (Software Development Life Cycle)
  • Work on Datawarehousing, SQL server, Ms-Access, Crystal Report and Visual Studio
  • Automate macrosin Excel (using VBA) and Ms-Access
  • Prepare Report Automation, MIS with Excel and Ms-Access
  • Involved in Migrating client work
  • Involved in Project Management
  • Creating SOP for the benefit basis programmed
  • Impart training to colleagues and helping in designing and programming
  • Involved in gathering new processes to the team.
  • Involve in different client related task

PREVIOUS EMPLOYER:

Patni Computer Systems Ltd:- 24thMarch, 2008 to 30th April, 2009 :-

Worked as an Executive with Patni Computer Systems Ltd

Mail merge work for various schemes has been complex in nature which is accomplished with VBA programming adding to current skill set.

Role involved:-

  • VBA Automation (using VBA and Ms-Access), Crystal Reporting
  • Project Coordinator
  • Analysis of documentation
  • Co-ordinate with client (UK) for resolution of queries & acquire information for projects
  • Programming various Mail Merge Project
  • UK Pension Knowledge

Wipro BPO Ltd: - 6th August 2007 to 19th March, 2008 :-

As a Level 2(Associate), job profile included troubleshooting of DSL which includes home networking, wireless setups, email clients setups, web hosting using Verizon web space etc. and provide customer service.

Role involved:-

  • Prepared different kind of reports – Daily Status Report, Weekly status report, Daily Bug report and Closeout Report.
  • Imparted and enhanced various knowledge skills.
  • Had been involved in DELL training for networking and various server related support.
  • Involved in training colleagues for system maintenance, home networking.
  • MIS Project Maintenance
  • VBA Automation (using VBA and Ms-Access)

EDUCATIONAL QUALIFICATION:

  • B.Tech (Computer Science Engineering) passed in 2007 having 73.74% (Honors) from DOON VALLEY INSTITUTE OF ENGINEERING & TECHNOLOGY (DIET), KARNAL under KUKUNIVERSITY
  • 10+2 in 2002 having 62.4% from TAGORE BAAL NIKETAN, KARNAL under CBSE.
  • 10th in 2000 having 67.0% from ST. THERESA’S CONVENTSCHOOL, KARNAL under CBSE.

TRANSITION & TRAINING ABROAD:

3 months training in U.K. which involved Project Handling and shared pension knowledge through Mercer, U.K. Transitioned Service Implementation process for Patni.

PROJECTS:

1)ONLINE SHOPPING - ASP .NET (Major Project): an online project made on ASP platform using database as the backend. It helps to shop various dairy products.

2)EVENT MANAGEMENT- JAVA (Minor Project):a project made on J2EE platform using database as the backend. It helps to maintain various events.

TRAININGS:

1)Undergone one and a half month training (July-August 2004) on Microsoft .NET, at CMS, NEW DELHI where I had also made project on CMS GROUP PROFILE.

2)Undergone one and a half month (July-August 2003) training on J2EE at NIIT, GURGAON, where I had made project on ONLINE SHOPPING.

REWARD & RECOGNITION:

1)Service Excellence Award – Received Service Excellence Award from UK as an appreciation for providing excellent service for client work.

2)Yellow Belt Certified – Received Yellow Belt Certified Award by gaining training on Yellow Belt and implementing improvement ideas at GOSS.

3)Pragati Award – Received 7 Pragati Awards at Mercer as provided excellent solution to work that had helped saved huge amount of hours for client work

4)Star of the Month – Received Star of the Month Award by working hard on the project

5)SleepTight Service Award – Received twice sleeptight service award for doing hardwork and providing excellent resolution to client.

6)Team of the Quarter – Received Team of the Quarter award by coordinating the team work

PERSONAL DETAILS:

Date of Birth : 23rd November 1984

Nationality : Indian

Strengths :Stays focus until completion of the assigned tasks, Flexible and willing to

take any work. Meet commitments.

Contact Number :+91- 9871502663

Email :

Passport No : F 9638921 (expires on 07/09/2016)

Permanent Address :Dr. R. K. Kohli,

H. No. 132A, Block - C, Super H.I.G. Flats, Sector 105, Noida