AJAY SINGH BUTOLA
Associate Senior Business Analyst
Navi Mumbai
Summary
Having 6+ years of experience in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) Oracle 10g/11g (SQL, PL/SQL, Stored Procedures, Triggers). Experience of report and dashboard development using data visualization tools like Power BI, Power BI services , Power Apps, Oracle BI publisher.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
Work History
Associate Senior Business Analyst
Burns & McDonnell India
Mumbai
01.2022 - Current
- Report creation in Power BI from scratch, which includes requirement gathering from stakeholders, Application of business rules on dataset, Data modelling, Report creation and then sharing and collaboration with end users.
- Created Procedures, Functions, Triggers using PL/SQL/SQL in Windows environment
- Granted resources, privileges, and role to users
- Actively participated in planning discussion, bug fixes, code quality improvements, code reviews
- Worked on reporting using RTF along with Oracle BI publisher
- Creation of power BI workspace / Assigning access to the end users / setting up email subscription /Schedule of dataset refresh / Personal data gateway setup have been performed
- Worked with different data sources like Oracle SQL, Azure DevOps, SharePoint List etc.
Business Analyst
Burns & McDonnell India
Mumbai
01.2021 - 01.2022
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Evaluated trends to understand competitive environments and assess current strategies.
- Developed several reports using Power BI & also have distributed them to required persons using Power BI service (Power BI Administration).
- Worked on Custom prints and Custom reports using Oracle BI publisher Tool
- Well versed with Complex DAX expressions to solve the business problems. Worked on YTD, MTD, QTD, MOM, YOY, QOQ etc. to showcase business performance in key business area.
- Always had detailed attention on data auditing to make sure all deliverables will not have any interruptions and client will be able to take right business decision.
Assistant Analyst
Burns & McDonnell India
Mumbai
01.2019 - 01.2021
- Worked on Oracle SQL developer for creation of data views and used the same in the power BI for reporting.
- Worked with different data sources like Oracle SQL, Azure DevOps, SharePoint List etc.
- Developed and deepened client relationships to cement profitable partnerships.
- Developed dashboards and reports using Microsoft Power BI tool
- Worked on reporting using RTF along with Oracle BI publisher.
Analyst
eClerx
Mumbai
08.2015 - 12.2019
- Was responsible for performing data analytics and generating insights as per business requirements
- Was responsible for creating Power BI apps and connecting them with live data sets for real-time analysis
- Developed Stored Procedures, functions, database Triggers and created Packages to access database
- Followed Agile Methodology
- Developed SQL queries/scripts to validate data such as count validation, null values, ensuring correct data insertion
Education
Bachelor of Engineering - Computer Science
B. N. College of Engineering And Technology, Dr APJ Abdul Kalam Technical University (AKTU) And Board of Technical Education, BTEUP
Lucknow 06.2010 - 06.2014
Skills
Microsoft Power BI Desktop
undefinedTimeline
Associate Senior Business Analyst
Burns & McDonnell India
01.2022 - Current
Business Analyst
Burns & McDonnell India
01.2021 - 01.2022
Assistant Analyst
Burns & McDonnell India
01.2019 - 01.2021
Analyst
eClerx
08.2015 - 12.2019
Bachelor of Engineering - Computer Science
B. N. College of Engineering And Technology, Dr APJ Abdul Kalam Technical University (AKTU) And Board of Technical Education, BTEUP
06.2010 - 06.2014
Similar Profiles
Akshay R. GaikwadAkshay R. Gaikwad
Associate Senior Civil Engineer at Burns & McDonnell IndiaAssociate Senior Civil Engineer at Burns & McDonnell India
ALESHA PEREIRAALESHA PEREIRA
Finance Executive at Burns & McDonnell India Private LimitedFinance Executive at Burns & McDonnell India Private Limited
PRITAM KADAMPRITAM KADAM
Senior Manager - Software Development at Burns & McDonnell India Pvt LtdSenior Manager - Software Development at Burns & McDonnell India Pvt Ltd