Hindi
Rohit Gupta
Senior Data Management Analyst
Bengaluru
Summary
Experienced data management professional with 8+ years of experience designing and implementing data solutions to drive strategic decisions. Skilled in Power BI, Power Automate, SQL, Alteryx, and Power Apps to streamline workflows, enhance reporting efficiency, and ensure data integrity. Proficient in developing interactive dashboards, automating processes, and implementing data governance. Collaborative team player translating complex data into actionable insights for informed decision-making.
Overview
11
11
years of professional experience
9
9
years of post-secondary education
3
3
Certifications
Work History
Senior Data Management Analyst
Wells Fargo
02.2023 - Current
- Collaborated with data stakeholders to gather requirements and design effective, scalable data management solutions.
- Performed daily and monthly report refresh activities, including executing Alteryx workflows and validating output accuracy.
- Developed automated workflows in Alteryx to streamline and optimize repetitive data processes, reducing manual effort.
- Created Power BI dashboards for tenant (application owner) monitoring, highlighting storage utilization and compliance with data lake storage standards.
- Enhanced and modernized the existing Power Apps-based Data Registration Tool , improving user interface, usability, and visual appeal to align with current UI/UX standards.
Data Quality Analyst
Teamware Solutions
12.2021 - 10.2022
- Create reports for executives to show quality and quantitative trends to define key metrics.
- Ingest data from Cube into SQL server via Dax Studio & perform data quality.
- Understanding business rules descriptions, defining detailed business rules descriptions by asking business partners the right questions and building rules in DQP.
- Read the reporting data in Azure Synapse and perform the data quality check on the selected attributes and write the result back to SQL server.
- Data quality check were performed in SQL code and the dimension covered- accuracy, completeness, uniqueness, validity, consistency.
- Completing Data Quality on time delivering results on Power bi reports scorecards in the right format.
Reporting Analyst
Accenture
12.2019 - 09.2021
- Visualize daily job insights and communicate the findings to process leads.
- Prepare daily metrics which needs to be completed within the team.
- Visualizing overall health of the revenue streams by categorizing each into current state.
- Creating RLS for sales team & sales director to view the respective region.
- Creating DAX query expressions as requested by the clients.
- Obtaining feedback from sales director to refine the report and process flow.
- Produced weekly and monthly revenue reports, identified new sales opportunities by 2.4x, decreased dispute resolution time by 33%, restored customer relationships and reduced customer churn rate by 25%.
- Automated creation of dashboards using Power BI to effectively track sale KPIs for all territories, resulting in increased accuracy of reports and improved efficiency by 40%.
Process Associate
Genpact
03.2016 - 02.2018
- Weekly client call to discuss the health of deductions taken by the customers.
- Pulling deduction from SAP (P-80) & clearing in the system.
- Validate whether the deductions taken by the customers are valid or invalid.
- Preparation of daily cash position report as per bank balances through online banking and prepare miscellaneous financial reports.
- Preparing month end reports & ensure smoother closing.
Audit Associate
KPMG
08.2014 - 12.2015
- Verification of Quarter/Yearly financial statements prepared by the Company like Balance Sheet, Income Statement, and Cash-Flow Statement.
- Identifying any mathematical errors in the Financial statements.
- Verifying Internal consistency between the Financial statements.
- To recognize potential audit issues or unusual relationships from basic analysis of the financial statements and communicate them to the Senior/Audit Manager/Engagement teams.
- Identifying and communicating auditing and accounting matters to senior associates, and managers.
- The main objective is to carry out routine substantive and controls-based audit testing for the multinational clients.
Education
MBA -
Techno India School Of Management Studies
01.2012 - 12.2014
Bachelor of Commerce (B.Com) - undefined
Syama Prasad College
06.2009 - 07.2012
ISC - undefined
GD Birla Centre For Education
06.2007 - 06.2009
ICSE - undefined
Lycee
07.2006 - 07.2007
Skills
Power Bi
SQL
DAX
Microsoft Excel
undefinedCertification
Alteryx Designer Core
Software
Bengali
English
Timeline
Alteryx Designer Core
07-2024
Senior Data Management Analyst
Wells Fargo
02.2023 - Current
Data Quality Analyst
Teamware Solutions
12.2021 - 10.2022
Data Analyst Associate (PL-300)
11-2021
Google Data Analytics
10-2021
Reporting Analyst
Accenture
12.2019 - 09.2021
Process Associate
Genpact
03.2016 - 02.2018
Audit Associate
KPMG
08.2014 - 12.2015
MBA -
Techno India School Of Management Studies
01.2012 - 12.2014
Bachelor of Commerce (B.Com) - undefined
Syama Prasad College
06.2009 - 07.2012
ISC - undefined
GD Birla Centre For Education
06.2007 - 06.2009
ICSE - undefined
Lycee
07.2006 - 07.2007
Similar Profiles
PATRICIA M. SCHERERPATRICIA M. SCHERER
Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors
Andrew S. HollenbachAndrew S. Hollenbach
Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Kaushik NamboorKaushik Namboor
Senior Consultant at Ernst & YoungSenior Consultant at Ernst & Young