PUSHKAR GHANSHAM BALWADKAR

accj4n@r.postjobfree.com (Resi) +91-20-256***** (Mobile)

+91-937*******

1.5yrs in VB (ActiveX Dlls) and Oracle + Access and 7+yrs in VBA, VB.NET,

SQL, PL-SQL and iAvenue (CDC Saratoga) CRM (Asia-Pacific region)

PROFESSIONAL WORK EXPERIENCE

1. Synechron Technologies

Position held: Lead - Software Nov 2011

- Till Date

> Implemented Salesforce Add-In in Excel 2010 and utilize its

functionality in VBA.

> Replicated Salesforce Toolkit by creating DLL in .NET that replaced 32

bit Salesforce Toolkit to make it work in 64 bit MS Office.

> Analyse existing VBA solution and improve the performance and enhance it

further.

> Developed applications to automate the daily report generation and

sending task of the team.

> Developed simplified tool for users to enhance their usage of an VBA

application.

> Communicate with clients, gather requirements from them and analyze

their need.

> Analyse .NET applications, debugged and enhanced it further.

> Managing team by making team understand the client's requirement clearly

and achieve the result from the team within the defined deadline.

2. Zensar Technologies

Position held: Sr. Software Engineer

March 2011 - October 2011

> Design, develop and maintain databases in SQL Server.

> Analysed existing VBA solutions and .NET applications, debugged and

enhanced it further.

> Communicate with clients, gather requirements from them and analyze

their need.

> Analyze manual reports and automate it.

> Implemented Advance VBA capabilities to integrate data into other MS

Office program.

> Managing team by making team understand the client's requirement clearly

and achieve the result from the team within the defined deadline.

3. Sandvik Coromant, Sandvik Asia Ltd

Sandvik is a global industrial group with advanced products and

world-leading positions in selected areas.

Business areas include TOOLING, MINING and CONSTRUCUTION, MATERIALS

TECNOLOGY

Position held: Sr. Executive (CRM Competence Center) June

2006 - March 2011

> Implemented the iAvenue CRM system in Asia-Pacific region.

> Responsible for Administration, Maintenance and Up-gradation of the CRM

system.

> Responsible for Configuration of CRM system on Server as well as on

Client.

> Develop applications in VBA, VB.NET, ASP.NET and Lotus Notes for

enhancing the CRM system.

> Worked on VB6 to .NET migration projects.

> Circulate updated respective customer's Data to respective colleagues of

Asia Pacific region on daily basis in the form of .DWN files without

manually updating the DOWNLIST.DAT file.

> Develop many in-house customized softwares in VB.NET, C#.NET and ASP.NET

as per the requirement.

> Develop reports in Excel Macros using SQL Queries, VBA and circulate it

to all colleagues of Asia Pacific region. Also developed reports using

Crystal Reports.

> Developed solution for automatic modification of SQL Queries in Excel

Pivot tables with parameter using VBA.

> Developed solution for Converting RTF data into normal text for

displaying it in Excel reports.

> Troubleshooting user's problems.

> Training colleagues.

> Design and develop and maintain databases in SQL Server. Worked on PL-

SQL (Triggers, procedure, cursors, user defined functions)

> Improved the efficiency & time utilization of the dept as sales and

marketing people can concentrate on their core jobs without the hassles

of number crunching and presentation/ analysis.

4. Aaditya Infotech Jan

2005 - May 2006

Position held: Trainee Software Engineer

(Worked while pursuing MCS)

> Designed and developed database in Oracle and MS Access

> Developed ActiveX dlls in Visual Basic 6.0.

> Developed GUI applications in Visual Basic 6.0

> Tested the developed applications

> Studied existing applications, debugged and enhanced it further.

ACHIEVEMENTS

. Recognized as Out of the Ordinary Employee in Sandvik Coromant,

Sandvik Asia Ltd.

. Won 3 prizes for various activities in a personality development

workshop Dale Carnegie held in Sandvik Coromant, Sandvik Asia Ltd.

. Have participated in Mimicry competition in Pune. Won the best mimic

prize in Sakaal festival.

. Won Employee of the Month award in Synechron Technology for handling

an alien project solely and completed within a record time.

SKILLS AND KNOWLEDGE

. Outgoing personality and able to interact with people at all levels

. Excellent Communications and Presentation skills

. Able to influence and motivate others

. Excellent MS Offices skills - MS Word, Excel & PowerPoint

. Self motivated & resourceful with good problem-solving & analytical

skills

. A good team player

Education Details:

Examination Percentage School/College Year

MCS 67 % T. J. College 2006

BCS 55 % B. R. Gholap College 2004

H.S.C. 55 % Nowrosjee Wadia College of Arts Science and 2001

Commerce

S.S.C. 56 % St. Josephs Boys High School, Kirkee 1999

Computer Skills:

CRM iAvenue (CDC Software), Salesforce

Languages Excel VBA, VB.NET, VB6, ASP.NET, VBScript

Tools Microsoft Business Intelligence (SSIS, SSAS and

SSRS), QTP

Databases SQL Server, Microsoft Access, Oracle

Reporting Excel Pivot, Crystal Report, OBIEE

Operating Systems Known WINDOWS, DOS, LINUX

Personal Details

Address A/10, Kavita Apartments, 45 Aundh Road, Kirkee, Pune- 411020

Date of Birth 30th November 1983

Sex Male

Marital Status Single

Passport No F8859400

Visa B1 (United States Of America)

Hobbies Mimicking, Acting, Dancing, Meeting new people.

Contact this candidate