Resume Developer

SAURABH SINHA

E-Mail: ******************

Phone: + Show contacts

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 *********** 2019)

Extraction SAP Excel Files using VBA

Automation of Excel ******* using VBA

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

Roles of Modification existing VBA *******

PROFILE SUMMARY

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

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

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

PROFILE SUMMARY

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

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

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

• ••Involved in automation of writing macros for excel based *******

(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 ******* 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 ******* on periodic basis.

• ••Generate both periodic and ad hoc ******* 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:

• • ooVBA Invoice Macro (Save Invoice, Edit Invoice)

  • ooVBA with pivot table and chart

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