7+Years Exp. as VBA developer(Excel , Access , PowerPoint, SQL,Word), Data Analyst , Asst. Manager(MIS) and Account Executive, Master in Computer Application
I worked more than 7 years on large corporate as well as small company to automate there daily routine task.
Basically , I worked from beginning to End project life cycle from gathering requirement to testing the code.
I worked on large data set to automate reporting including complex formula , chart , pivot tables.
Below are some technical points that I covered :
Develop, enhance, and maintain MS Office applications, and handle both frontend and backend development procedures.
Design, configure, develop, and implement enhancements and production fixes to existing systems.
Develop Microsoft Access Databases, including tables, queries, forms and reports, using standard IT processes, with data normalization and referential integrity.
Create and maintain technical documentation, including user manuals and guides
Analyze and revise existing system logic difficulties, and ensure that technical knowledge of all phases of application systems is maintained.
Use Visual Basic in Microsoft Applications, including Excel, Access, Word and PowerPoint, Outlook Mail.
Use Advanced Excel capabilities, including pivot tables, lookups, and complex formulas and graphing to streamline business processes.
Develop test plans and software documentation to support new releases and code modifications.
Confer with stack holder to gain understanding of needsAssist other staff with development activities.
Participate in code reviews to ensure best practices and established standards are in use.
Debug/code difficult functions/macros using VBA Programmatically manipulate worksheet and cell properties using VBA.
Create SQL Server views, stored procedures and queries, and actively mitigate potential security.