Business System Analysis Specialist - Excel, VBA, SharePoint, Workflows, Dashboard Creation & SQL.
*Tools: PowerBI, PowerApps, Excel (Macros, Lookups, Pivot Table, Access, Outlook
*Sincere, diligent and result oriented Engineer along with an MBA - Marketing offering 12+ years of experience across the industry.
*Proficiency in using Excel, VBA, SharePoint, Workflows, Dashboard Creation, and SQL.
*Experience in tools: PowerBI, PowerApps, Excel (Macros, Lookups, Formulae and Pivot Tables), VBA, SharePoint, Access, SQL, Word, Outlook, Presentation.
*Designed reporting framework and builds reports out of scratch.
*Working independently as well as with team members to achieve team goals.
*Interacting with stakeholders for implementing changes in to process or reports.
*Ability to exercise tact and diplomacy and deal with people in a calm and effective manner in sometimes sensitive situations to resolve client issues with effective negotiation and persuasion skills to establish and maintain relationships
PROFESSIONAL SYNOPSIS
Business System Analysis Senior Specialist
*Working on Cost Model and other tools development and automation using Excel VBA, Sharepoint.
*Automating reports using Macros.
*Making presentation on power point for knowledge transfer.
*Email and Voice communication regarding reports or any other findings with concerned person.
*Working on SharePoint as developer using tools like InfoPath and SharePoint Designer for business process creation.
*Collaborating with team members to ensure hassle free reporting and other solutioning related tasks.
*Automation of various tasks related to solutioning ad other business related functions.
*Handling ad hoc queries.
*Experience comprises of Data Extraction, Data Cleaning, Data Preparation, Data validation and MIS Reporting Excel/VBA.
*Using Advance Excel formulae for data cleaning and preparation.
*Automating reports using Macros.
Excel VBA / SAS - Trainer
*Providing Training on Base and Advance SAS.
*Training on Advance Excel and VBA
*Worked on Projects for: Microsoft Excel / VAB and Microsoft Access.
*Presently associated with the institute as part time trainer.
Work Terms
• Available 24/7 via phone, email and skype
• Hard working professional
• Personal Attention to every project
• Good communication skills