Shams E Azam
Gurgaon
Summary
Dedicated and highly skilled Developer with 4 years of experience in process automation, data analysis, and reporting. Proficient in VBA, Python, Power BI, Power Automate, and Power Apps. Seeking a challenging role to leverage expertise in developing custom solutions, enhancing data management, and driving operational efficiency.
Overview
4
4
years of professional experience
Work History
Senior Analyst
Wipro's Digital Operations And Platforms
11.2022 - Current
- Streamlined business processes through automation using VBA and Python, resulting in increased operational efficiency.
- Crafted custom Power Apps applications to facilitate data interaction from multiple databases and streamlined data collection from users.
- Engineered dynamic VBA tools for updating presentations with data from various sources, enhancing data-driven decision-making.
- Established SharePoint lists to track delivery team errors and presented data to clients through interactive Power BI dashboards, significantly improving project efficacy.
- Designed and maintained email tracking system using Power Automate Flow, ensuring automatic email request tracking and data storage in SharePoint online lists.
- Developed user-friendly dashboards and automated reports using VBA and Power BI.
- Collaborated seamlessly with cross-functional teams to identify and implement process improvements.
- Provided comprehensive technical support and training to end-users on VBA and Python-based tools and processes.
Engineer
Evalueserve India Pvt. Ltd
06.2021 - 11.2022
- Designed and implemented automation tools using VBA and Python, streamlining operations across various platforms.
- Developed web crawlers with Python and VBA for data extraction from websites, broadening data sources and insights.
- Automated operations within various Microsoft applications, including Outlook, Excel, PowerPoint, MS Access, and MS Word, resulting in annual saving of more than 1,000 man-hours.
- Adapted and optimized existing macros to meet evolving business requirements.
- Executed rigorous testing, maintenance, debugging, and documented procedures for every process.
- Ensured best practices were in place by reviewing code.
NOCC Engineer
Three D Integrated Solutions Ltd.
06.2020 - 05.2021
- Automated tasks efficiently by creating VBA programs.
- Utilized VBA in Excel to generate automated reports from complex data.
- Created over 10 live dashboards using Power BI to provide real-time health and status monitoring of network systems and their corresponding telecommunication links.
TOC Associate
Randstad India Pvt. Ltd
08.2019 - 03.2020
- Leveraged VBA to create MS Excel applications, enhancing automation and process regulation.
- Revolutionized tracking and reporting systems through MS Access and VBA, optimizing strategic planning.
- Developed tool that displays live weather data for 20+ regions or circles.
- Significantly improved project delivery time by creating Excel macros with VBA.
Education
B.Tech - Electirical & Electronics Engineering
Bharat Institute of Technology (AKTU)
Meerut06.2019
UP State Board (XII) -
JM Inter College
Azamgarh, UP04.2012
CBSE Board (X) -
Don Bosco School
Gorakhpur, UP04.2010
Skills
- Programming Languages: Visual Basic (VBA), Python
- Software: MS Office, Power BI, Tableau
- Data Analysis: , Advance Excel, Pandas, SQL
- Automation Tools: Power Automate, Power Apps
- Databases: SQL Server, MS Access, and SharePoint
- Web Technologies: HTML & CSS (Basic)
- Web Crawling: Selenium
Timeline
Senior Analyst
Wipro's Digital Operations And Platforms
11.2022 - Current
Engineer
Evalueserve India Pvt. Ltd
06.2021 - 11.2022
NOCC Engineer
Three D Integrated Solutions Ltd.
06.2020 - 05.2021
TOC Associate
Randstad India Pvt. Ltd
08.2019 - 03.2020
B.Tech - Electirical & Electronics Engineering
Bharat Institute of Technology (AKTU)
UP State Board (XII) -
JM Inter College
CBSE Board (X) -
Don Bosco School
Similar Profiles
Vikash OswalVikash Oswal
Senior Service Manager at Wipro Digital Operations And PlatformsSenior Service Manager at Wipro Digital Operations And Platforms
Malani SMalani S
Lead Analyst at Wipro digital operations and PlatformsLead Analyst at Wipro digital operations and Platforms
MD NOUSAD ALI MONDALMD NOUSAD ALI MONDAL
Senior Associate at Wipro Digital operations & PlatformsSenior Associate at Wipro Digital operations & Platforms