Gaurav A

Associate Consultant

Dubai, Dubai, United Arab Emirates7 yrs 6 mos experience
Highly StableAI Enabled

Key Highlights

  • 9 years of diverse experience in business consulting.
  • Expertise in Power BI, Power Apps, and Power Automate.
  • Passionate about bridging business objectives with technology.
Stackforce AI infers this person is a Business Consultant with expertise in Data Analysis and Application Development in the Consulting industry.

Contact

Skills

Core Skills

Business ConsultingProject ManagementAgile Project ManagementData AnalysisApplication DevelopmentWorkflow AutomationBusiness AnalysisProcess Automation

Other Skills

Advanced ExcelAgile Application DevelopmentAgile EnvironmentAgile MethodologiesAnalytical SkillsAnalyticsAzure DevOpsBRDBudgetingBusiness AnalyticsBusiness RequirementsBusiness Support Systems (BSS)Business TransformationCharging SystemsCommunication

About

With 9 years of diverse experience in business consulting, I am currently thriving in a dynamic role at Ameriprise. As a seasoned Business Consultant, I specialize in leveraging technology to drive strategic initiatives. In my career journey, I have honed expertise in Power BI, Power Apps, and Power Automate, empowering organizations with robust data analysis, streamlined applications, and efficient workflows. My proficiency extends to SharePoint for collaborative solutions, Azure DevOps for seamless project management, Delta Share data for precision, and Dynamics 365 for effective customer relationship management. I am passionate about bridging the gap between business objectives and technological solutions, ensuring that each project I undertake delivers tangible value. My commitment to continuous learning allows me to stay at the forefront of industry trends, providing innovative solutions that propel businesses forward. Let's connect to explore collaboration opportunities and discuss how my skills can contribute to your organization's success.

Experience

7 yrs 6 mos
Total Experience
2 yrs 6 mos
Average Tenure
--
Current Experience

Ameriprise financial services, llc

Senior Consultant

Jun 2022Apr 2024 · 1 yr 10 mos · On-site

  • Agile Requirement Elicitation:
  • Use PMI ACP methodologies for agile requirement gathering.
  • Utilize collaboration tools like Microsoft Teams or Slack for efficient communication.
  • Data Analysis and Modeling:
  • Employ Power BI for comprehensive data analysis.
  • Implement Delta Share Data for real-time data synchronization.
  • Application Development:
  • Gather business application requirements using Power Apps.
  • Collaborate on development with Azure DevOps for version control.
  • Workflow Automation:
  • Identify and automate manual processes using Power Automate.
  • Integrate workflows into applications with Power Automate and Azure DevOps.
  • Collaboration and Document Management:
  • Leverage SharePoint for efficient document management and collaboration.
  • Define and document business processes within SharePoint.
  • Project Management with Azure DevOps:
  • Utilize Azure DevOps for project planning, tracking, and collaboration.
  • Implement Agile practices, including user stories and sprints.
  • Dynamics 365 Integration:
  • Understand and document business processes within Dynamics 365.
  • Integrate Dynamics 365 data using Power Automate and Delta Share Data.
  • Quality Assurance:
  • Implement testing strategies with Azure DevOps Test Plans.
  • Conduct thorough testing for Power Apps, Power Automate, and Dynamics 365.
  • Stakeholder Management:
  • Collaborate effectively using communication tools like Microsoft Teams.
  • Track progress and communicate using Azure DevOps.
  • Training and Documentation:
  • Create comprehensive documentation using Microsoft Word or Confluence.
  • Provide training on Power BI, Power Apps, Power Automate, and Dynamics 365 processes.
  • Continuous Improvement:
  • Monitor and enhance project processes with Azure DevOps analytics.
  • Utilize Dynamics 365 insights for ongoing business process refinement.
  • Apply agile project management principles.
  • Utilize Azure DevOps for efficient tracking and reporting.
Power BIPower AppsPower AutomateSharePointAzure DevOpsDynamics 365+2

Orange business services

2 roles

Senior Business Analyst

Promoted

Jan 2019Jun 2022 · 3 yrs 5 mos

  • Responsible for Defining data requirements, collection, recording, consolidation, reconciliation, analysis, reporting, and presentation of accounting and financial information to stakeholders.
  • Responsible for handling large Financial data sets, alteryx, analyzing data, extracting relevant information, and producing strategic conclusions into user-friendly Designs/Infographics for a diverse set of users.
  • Responsible for interacting with Clients, Senior Management and collecting data manually, creating templates, and structuring the database.
  • Performance analysis and suggest best approaches to the team to improve the performance.
  • Developing PowerBI Data Models, Data Preparation with Data Flows and designing PowerBI reports.
  • Strong experience and understanding of best practice principles in Data structuring, Data Management, Data Modelling, Data Analysis, Business Intelligence, and Reporting solution strategy, design, and implementation.
  • Has experience working on Power BI, preferably Power BI Certified DA-100
  • SQL(Experienced in SQL Query building)
  • Advance Excel & Reporting (well versed with advanced excel functions (pivot tables, Indirect, Name Ranges, VLOOKUP, XLOOKUP, Power Querying, DAX Creation, Creating Charts with slicers, bookmark etc.)
  • Excellent communication skills
  • Basic understanding of Microsoft products
  • Experience with Azure Data factory
Power BISQLAdvanced ExcelData ManagementData AnalysisBusiness Analysis

Business Analyst

Sep 2017Dec 2018 · 1 yr 3 mos

  • Working on automating the processes collaboration with Robotic process automation Team that increased the efficiency for the business users and decreasing the time. Utilized strong analytical and research techniques to identify gaps and inconsistencies within current measurement tools, allowing development of improved and cost effective business models. Provides interpretation of business rules and requirements for technical system upgrades while tracking progress Ensured enhanced processes and services are technically, operationally, and legally supported by analyzing and compiling business requirements solidifying successful implementation. Strengthened risk mitigation techniques and improved process efficiencies while meeting stringent regulatory requirements. Developed, coordinated, and implemented methodology and scope for multiple complex projects. Utilized strong analytical and research techniques to identify gaps and inconsistencies within current measurement tools, allowing development of improved and cost-effective business models. Developed fully automated dashboards by generating charts and pivots through VBA. Successfully delivered 50+ reports with end to end automation. Automated Monthly and Quarterly reports for SABE team using advance excel, VBA, and RPA UI Path.
  • i had use the below skkils.
  • MS visio, Microsoft Power BI, Data modeling data visualisation Business analyst analytical research data analysis advance excel data scrapping SQl SQL server DAX power apps powerapps power automate SSRS SSIS SSAS SCRUM Data Mining Azure BRD and FRD
RPAData AnalysisAdvanced ExcelSQLBusiness Analysis

Globallogic

Associate Analyst

Aug 2016Aug 2017 · 1 yr · India

  • Analyze data from various sources and deliver actionable
  • insights to various team within our Enterprise clients. Assisting in delivering well-organized reports, dashboards, data
  • analysis, and statistical models. Enhance and optimize existing reports, analysis processes. Evaluate 3rd Party tools for internal/client business
  • requirements. Actively gather and share domain related knowledge in forums
  • within the organization. Optimize existing processes, and provide ongoing feedback on
  • tools and processes.
  • Interpret customer feedback, monitor satisfaction, and help drive
  • programs to improve numbers.
  • Operated with different recruitment teams in monitoring progress of plans throughout the year by analyzing business information to identify process improvements for accelerating business efficiency and effectiveness. Created automated system solutions and workflows that eliminated complex manual processes and homegrown excel tools and solutions as directed. - Executed Reporting and preparing Dashboards for Recruitment teams including senior leadership and maintaining global engagement team databases. - Analyzed and managed large quantities of data and identified trends to provide meaningful insights by using advanced excel. - Responsible for Generating and distributing management reports in an accurate and timely manner. And Provided strong reporting and analytical information support to the management team. Performed data analysis for generating reports on a periodic basis. And also Generated both periodic and ad hoc reports as needed.
Data AnalysisReportingDashboard Creation

Education

Narsee Monjee Institute of Management Studies, Mumbai

Master of Business Administration - MBA — Information Technology

Jan 2018Jan 2020

KRISHNA ENGINERING COLLEGE, GHAZIABAD

Bachelor of Technology (B.Tech.) — Computer Science

Jan 2014Jan 2016

Dheradun public school

Class XII — CBSE Board

Jan 2011Jan 2012

Ingraham Institute English School

X — ICSE Board

Jan 2009Jan 2010

Stackforce found 100+ more professionals with Business Consulting & Project Management

Explore similar profiles based on matching skills and experience