Resume

Sign in

Sales Software Engineer

Location:
Vasant Nagar, Karnataka, India
Salary:
65000
Posted:
December 14, 2019

Contact this candidate

Resume:

SAURABH SINHA

E-Mail: ada2mj@r.postjobfree.com

Phone: +918*********

SENIOR IT PROFESSIONAL

VBA Development ~ Project Execution ~ Automation ~ Manual Reporting

Extensive experience in executing full life-cycle development projects; ramping-up projects within time, budget & quality parameters, as per project management & best practice guidelines

Industry Preference: IT / Telecom / Oil

PROFILE SUMMARY

•Technocrat with nearly 3 years of experience in VBA Development, Project Execution, Application Programming and Team Management

IT SKILLS

•Windows

•MS Excel with VBA

•SQL Query!

•J2EE (Servlet, JSP)

•Internet Apllications

Total Experience 6

Relevent Exp 4 (VBA MS EXCEL)

3i Infotech Chennai India (Associate)

(July 30 2018-Mar 15 2019)

Extraction SAP Excel Files using VBA

Automation of Excel Reports using VBA

ARK Infotech -client Name(WIPRO) (VBA Developer) (April 27th 2016-Dec 2016)

Roles of Modification existing VBA Reports

PROFILE SUMMARY

•Created user defined functions, add-ins, menu bars, forms and user friendly interfaces that support various P&L reports and daily tasks.

•Developed multiple Excel/VBA Forms for data capture and report generation

Future Focus infotech-client(TCS) (Senior Developer) (Sept 7 2015-Nov 13 2015)

PROFILE SUMMARY

•These macros facilitated the collection of data, the set of reports and redefining of data values to be chatted.

•Involved in automation of daily & weekly call center reports using macros

•Extracted raw data from salesforce.com and executed macros regarding sales reports on monthly basis

•Involved in automation of writing macros for excel based reports

Centurylink Qwest, Noida (Software Engineer)

(May’13 - Oct’14)

Pre-Sales Report

• This report contains data about sales information of individual supervisors for Pre-Sales. The report extracts raw data from Sales-force. com which provides us the sales position from lowest to top bucket where lowest bucket is for Funnel state to highest at happy state. This is a daily report which shows the incremental sales from Least to highest bucket in a month. Each months report is incremental and target is to reach or surpass the forecasted sales, Macro automation included:-

o Creation of Charts

o Creation of multiple pivot tables

o Multiple workbooks used to generate final report

Time Reporting

• This report shows the Time Reporting orders that have not been completed. This helps dispatch to know which technicians are not completing their time reporting out each week.

• Generated By Macro

PROFILE SUMMARY

•Provide support and maintenance to existing management information systems (MIS)

•Generate and distribute management reports in accurate and timely manner.

•Develops MIS documentation to allow for smooth operations and easy system maintenance.

•Provide recommendations to update current MIS to improve reporting efficiency and consistency.

•Perform data analysis for generating reports on periodic basis.

•Generate both periodic and ad hoc reports as needed.

•Understand customer problems and provide appropriate technical solutions.

•Analyze business information to identify process improvements for increasing business efficiency and effectiveness.

•Participate in cross-functional meetings to resolve recurring customer issues.

Earthcom Technology Private Ltd., Modinagar (May’10 – May’13)

MIS

Involved in VBA Database Reporting including:

oVBA Invoice Macro (Save Invoice, Edit Invoice)

oVBA with pivot table and chart

oPivot Table using VBA (create, delete, refresh, hide fields & items)

PROFILE SUMMARY

•Evaluate all designs for project deliverables for all developers and assist team to supervise all work projects.

•Coordinate with all business analysts and application architects to maintain knowledge on all functional requirements and ensure compliance to all architecture standards.

•Prepare all documents for project standards and maintain accuracy in same and manage all technical resources to meet all requirements and perform tests on various processes in coordination with development teams.

•Administer all project issues and identify al risks and ensure mitigation within required timeframe and develop and perform tests on all JAVA and BPEL applications and design all J2EE applications according to business requirements.

•Analyze and modify all J2EE applications and prepare required documents.

Shaperz Technologies, Noida (Feb’09 – Feb’10)

Designation - J2EE (Servlet, JSP)

Writes and compiles servlet source code

Writes code for Dynamic website

ACADEMIC DETAILS

•MCA from IET College, Ghaziabad, Punjab Technical University in 2008

•B.Sc. (IT) from Punjab Technical University, UGC, Govt. of India in 2006

PERSONAL DETAILS

Date of Birth: 2nd March 1984

Languages Known: English & Hindi

Skype saursinha37

Mailing Address: C-32, Mahesh Marg, Modinagar, Ghaziabad – 201204, Uttar Pradesh, India



Contact this candidate