SAURABH SINHA

E- M ail: adiulm@r.postjobfree.com

Phone : +91-821*******

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

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

•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)

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

•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)

•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)

•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)

•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

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