Work Experience
Organization : Working independently on Freelance Projects.
Duration : Nov 2020 – Till Date
Industry : BFSI
Designation : Sr. Developer/Team Leader
Role : Coding and Testing
Environment : Windows 7, MS Excel VBA, MS Access VBA
Project Details : Excel Automation
--------------------------------------------------------------------------------------------------------------------------------
Organization : TekSystems (Worked for HSBC, Pune)
Duration : Dec 2018 – Nov 2020
Industry : Banking
Designation : Senior Excel VBA Developer (Worked as Developer in HSBC)
Responsibilities : Handling Scrum Team, Coding, Testing and Deployment
Environment : Windows 10, MS Access, MS SQL Server and MS Access VBA.
Description
- The tool is designed to extract Daily, Weekly, Monthly, Quarterly and Yearly reports for 47 Countries according to their currency value.
- Handling Scrum Team, Client Coordination along with Product Owner.
- Communicate with clients to understand business requirement and delivering the product on time.
--------------------------------------------------------------------------------------------------------------------------------
Organization : Working independently on Freelance Projects
Duration : Jul 2016 – Dec 2018
Industry : Freelance
Designation : Developer
Role : Coding and Testing
Environment : Windows 7, MS Excel VBA
Project Details : Excel Automation
--------------------------------------------------------------------------------------------------------------------------------
Organization : Thirdware Technology Solutions, Chennai (6 Month Contract)
Duration : Dec 2015 – Jul 2016
Industry : Automobile (Worked for Ford Global Technology & Business Center, Chennai)
Role : Technical Analyst
Environment : Windows 7, MS Access Database, MS Excel VBA and MS Access VBA
Project Details
- Designing, development, enhance the applications in MS Excel VBA, MS Access.
- Communicate with clients to understand the requirement and do the enhancement.
- Responsible for troubleshoot bugs, production support
--------------------------------------------------------------------------------------------------------------------------------
Organization : Wipro Ltd, Chennai
Achievements : Innovative Automation Award in Wipro Ltd, Chennai
Duration : May 2012 – Aug 2015
Industry : Finance and Accounts for US Client
Role : Senior Software Engineer - Business Optimization Services and Solutions
Environment : Windows 7, MS Access Database, MS Excel VBA and MS Access VBA
Project Details
- Developed more than 75 MS Excel VBA tools to extract Daily, Weekly, Monthly, Quarterly and Yearly reports as per the Client requirement.
- Holding ownership for 300+ database applications available with the client
- Responsible for Business optimizations, troubleshoot bugs, production support
- Designed, Writing Code, Developed, Enhancement for MS Excel VBA, MS ACCESS VBA.
- Actively involved in Upsizing (On site) the database applications from MS Access 97 to MS Access 2010.
- Manual testing – writing test case, bug fixing and bug reporting.
--------------------------------------------------------------------------------------------------------------------------------
Organization : Zensar Technologies Limited, Pune
Achievements : Developed “CSAT Database Tool” Survey Report and Successfully Deployed
Duration : October 2010 – April 2012
Industry : World's leading IT and Networking Industry (For Japan and Australia Client)
Role : Software Engineer
Environment : Windows 7, MS Access Database, MS Excel VBA and MS Access VBA
Project Details
- As a Team member of the Intelligence Metrics Reporting team, I am responsible for the following:
- Maintenance and up gradation of various tools designed in MS Excel VBA and MS Access Database.
- Developed Tool using MS Excel VBA, MS Access VBA and MS Access Database to extract Daily, Monthly and Yearly Reports for sales team.
- Involved in development, up gradation and maintenance of various sales related tools developed in MS Excel and MS Access.
- MS Excel VBA macro Enhancement.
- Manual testing – writing test case, executing it and bug reporting.
Training
- Undergone ITIL V3 Foundation Training.
--------------------------------------------------------------------------------------------------------------------------------
Organization : Tech Mahindra Pvt. Ltd., Pune
Duration : November 2009– September 2010
Industry : Services Provider US Client
Position : Senior Executive - MIS
Environment : MS Access Database, MS Excel VBA and Manual MS Excel Report
Project Details
- Developed Process Reports, Login Reports and Agent Reports Tool using Excel VBA and Ms-Access to extract Daily, Monthly and Yearly
- Preparing Manual Daily Reports, Weekly Reports and Monthly Reports for Management.
- Preparing Weekly Rosters and Transport Rosters.
- Maintain Employee attendance and attrition Tracker.
--------------------------------------------------------------------------------------------------------------------------------
Organization : Vertex Software Pvt Ltd., Pune
(An NTT Data Company - CMM L5)
Duration : August 2008 to October 2009
Industry : US Client (Microsoft)
Role : Executive - MIS
Environment : MS Excel VBA and MS Access VBA
Project Details
- Worked on platform like MS Excel VBA, MS-Access.
- Prepared the analytical reports/charts based on the data of advertising campaigns that are offered by different publisher like Yahoo, Google, MSN and AOL Network.
- Prepared the report of online marketing campaigns based on data that helps publisher to maximize the revenue and lower costs associated with the advertiser.
- Developed the program to automatically generate the analytical reports based on data of online advertising campaigns.
--------------------------------------------------------------------------------------------------------------------------------
Organization : Cequity Solutions Pvt Ltd., Mumbai
(Customer Equity Solutions)
Achievements : 1) Best Performance Award in Cequity
2) Developed “Time Sheet “Using VB 6.0, MS Access Database and Time sheet Report for Management.
Duration : January 2008 to July 2008
Industry : Service Provider (TataSky)
Role : Analyst Program & MIS
Environment : VB 6.0, MS Excel VBA and MS Access Database
Project Details : Cequity Solutions do the Analysis with the Client Database,
- Worked on platform like MS Execl VBA, MS Access Database.
- Do Analysis and give the best possible solution to the client.
--------------------------------------------------------------------------------------------------------------------------------
Organization : TNS ORSC India Pvt Ltd., Hyderabad
(Taylor Nelson Sofres is a leading market research and information group)
Achievements : 1) 12 CSAT Awards (Customer Satisfaction Award) from
TNS ORSC for the Client Satisfaction Rating (12 Bronze Awards and
4 Silver Awards)
- Developed Macros in MS Excel VBA.
Duration : From June 2006 to Jan 2008
Role : Charting Analyst
Environment : MS PowerPoint Presentation, MS Excel and MS Excel VBA
Responsibilities : TNS ORSC leading Market Research Company and give the best possible
- Creating Excel Charts with the raw data provided by the Client.
- PowerPoint Template Modifications according to client’s requirements.
- Formatting PowerPoint presentations
- Develop MS Excel VBA Macros for Clients Scorecards.
- Analyze data in MS Excel and generate PowerPoint Charts as per project specification.
