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
•MS Excel with VBA
•J2EE (Servlet, JSP)
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
•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)
• 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
• 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
•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)
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
•MCA from IET College, Ghaziabad, Punjab Technical University in 2008
•B.Sc. (IT) from Punjab Technical University, UGC, Govt. of India in 2006
Date of Birth: 2nd March 1984
Languages Known: English & Hindi
Mailing Address: C-32, Mahesh Marg, Modinagar, Ghaziabad – 201204, Uttar Pradesh, India