Playing Cricket
Malatesh Kumar H N
Snr Data Analyst
Bangalore
Summary
Career Summary:Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. A dynamic Professional with overall 13 years experience in Digital Payments , Business Operations, Client management, Application Monitoring, Data Analysis and Data modeling, Data Visualization and Function, Power Query DAX and Data Architect . Hands on experience in Microsoft Office, MYSQL, Tableau, Power BI MIS Reporting, Quicksight and Snowflake Transaction Monitoring with strong analytical and communication skills, looking for opportunities as Business operation Analyst / Data Analyst / Asst Manager. Key Skills: Tableau, Power BI , MySql , MS Office , Quicksight , Snowflake.
Overview
13
13
years of professional experience
5
5
years of post-secondary education
3
3
Language
Work History
Snr Data Analyst
Cloudberry360 Technologies
Bangalore
03.2023 - 07.2023
- Working on large set of client data and share the dashboards
- Working with the development team to implement data strategies, build data flows and develop data models
- Creating Dashboard and analyzing the data with the help Quicksight tool
- Sharing the analysis and data through AWS cloud and Snowflakes tool
- Sharing the large set of data through SFTP
- Working on multiple clients projects such as Raynair , Elvon , Barcley , EIB etc
- Maintaining and working on Master data and analyzing for Business decisions
- Designing and Developing various analytical dashboard reports from multiple data sources such as SFTP, Google sheets , share point etc
- Generating both periodic and ad hoc reports as needed based on the Management requirement
- Providing strong reporting and analytical information support to management team with help of Data Visualization, Charts and Dashboards
- Able to convert Business Requirements into Data specifications and requirements
- Involved in various projects related to Data Modeling / Data Analysis Design and development for data warehousing environments
Snr Business Operation Analyst
Wibmo Pvt Ltd
Bangalore, Karnataka
11.2017 - 03.2023
- Monitoring and Handling Live Digital/Online payment Transactions
- Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models
- Work with the development team to implement data strategies, build data flows and develop data models
- Performs data analyzes and design, and creates and maintains large, complex logical and physical data models, and metadata repositories
- Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs
- Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques
- Using Power BI, created dashboards and interactive visual reports
- Defined key performance indicators (KPIs) with specific objectives and track them regularly
- Analyze data and display it in reports to aid decision-making
- Convert business needs into technical specifications and establish a timetable for job completion
- Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis using Power BI to run DAX queries and functions
- Ability to work on large data sets and implemented Incremental Refreshes
- Create charts and data documentation with explanations of algorithms, parameters, models, and relationships
- Strong Power BI Development & Architecture Expertise
- Prior experience in data-related tasks
- Mastery in data analytics
- Should be proficient in software development
- Analytical thinking for converting data into relevant reports and graphics
- Capable of enabling row-level data security
- Knowledge of Power BI application security layer models
- Ability to run DAX queries on Power BI desktop
- Proficient in doing advanced-level computations on the data sets
- Currently working on multiple projects such as Bank of Baroda , Yes Bank and BDO
- Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective
- Working on large data sets through Tableau and creating dashboard for business decisions
- Maintaining and working on Master data and analyzing for Business decisions
- Conducted 80+ complex business problem analyses to reduce operational and financial risk as part of the client’s compliance strategy
- Applied regulatory standards and policies in procedural data analysis
- Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights
- Delivered 100% assigned tasks within the agreed budget
- Led an ETL project (SSIS) and delivered on time, meeting the client’s requirements 100%
- Built knowledge base of SAP BI architecture (included over 5 Business Objects tools)
- Perform DAX queries using Power BI Tools
- Help team implement important BI systems
- Increase company efficiency by 30% by identifying and adjusting key performance indicators
- Convert the company's goals and objectives into technical specifications to develop project timelines
- Analyze and present data to help the company make important decisions
- Working on 2.5 Cr Customer data and extracting customer data reports such as KYC
- Level reports , Cashback report etc with help of MySql
- Preparing and sharing Business Dashboard for day and Month wise to CEO and top management team for Business decisions
- Creating interactive dashboards with the help of Power BI by segregating Product wise , components wise as per the daily and month wise management requirement
- Monitoring the Live Mobile payments Transactions Scorecard by using Tableau Desktop
- Designing and Developing various analytical dashboard reports from multiple data sources such as Excel , Google sheets , share point etc
- Preparing and Publishing Daily, Weekly and Monthly LOB, LTD Reports with the help of
- Tableau as per the client requirements.
- Exercised leadership capabilities by successfully motivating and inspiring others.
Executive Operations
Flipkart India Pvt Ltd
Bangalore
12.2015 - 11.2017
- Generating PO’s and taking ownership on Seller Stock procurement in all Regional warehouses
- Handling Vendor on boarding and client management
- Handling all vendor issues regarding Big billion day
- Performing data analysis for generating reports on periodic basis by using Tableau and
- Advance Excel based on the client requirement
- Providing strong reporting and analytical information support to management team with help of Data Visualization, Charts and Dashboards
- Generating and distributing management reports in accurate and timely manner with
- Inside and Outside Stake Holders
- Generating both periodic and ad hoc reports as needed based on the Management and
- Seller requirement
- Participating in cross-functional meetings to resolve recurring Seller / Merchant issues
- Providing customer support and assistance in Merchant issue troubleshooting and resolution.
- Built and strengthened relationships across functional leadership areas to keep revenue development and operational plans interconnected and effective.
Reconciliation Specialist
J P MORGAN CHASE
Bangalore
01.2011 - 12.2015
- Responsible for Banking Operations & Reconciliation
- Customer Data Management
- Create MIS reports on the daily basis
- Working on Various tools like V-Lookup, H-Lookup, Pivotal Tables, Formulated Macros etc
- Responsible for Check processing and Managing the entries
- Initiatives:
- Have Created SAP Macro Which Pulls all the Reports such as TB, GL Line Item and
- Aging repots which helps to save Minimum 1 .15 hr per day
- Have Created SAP Macro which pulls the OIM Control Reports, TPS Balance Uploads which saves Minimum 1 Hour per day
- Created Process SOP’s and helped the team to get E2E Process Knowledge
- Also monitor customer account activity on an ongoing basis, report and keep records of potentially suspicious transactions
- Pro-active approach to improve internal QA system
- Responsible for providing Daily, Weekly, Monthly CAM Reports for the entire process
- Responsible for providing ARR Report and SLA Tracker Report for the entire Process.
Executive
Angel Broking
Bangalore
10.2007 - 10.2008
- Responsible for Banking Operations & Reconciliation
- Managing Receivables & Payables
- Customer Data Management
- Customer Interaction and QA
- Working closely with Stock Market Dealers & Stock Market Analysts
- Handling and solving the Customer Grievances and providing good service
- Have also supported Marketing by introducing New Client Resources
- Monthly reconciliation of the Monthly settlements-Fixed income
- Create MIS reports on the daily basis
- Initiatives:
- Monitor customer account activity on an ongoing basis, report and keep records of potentially suspicious transactions, and escalate any suspected money laundering activities and Bank
- Secrecy Act (B S A) related matters or issues immediately to the Compliance Support
- Officer(CSO)
- Adoption of new trading client by performing and verifying CIP(Customer Identification
- Program)and KYC Checks
- Creation of client trading account in all systems
- Creation and maintenance of client contact information both for trading and management accounts
Education
MBA - Finance & Marketing (Regular
C N K Reddy College of Business Management
Bangalore 10.2008 - 06.2010
BBA - Marketing & Entrepreneurship Development
JSS College, Karnatak University
Dharwad ,Karnataka , India 07.2004 - 06.2007
PUC - Commerce
JVPU College
SSLC (10th - undefined
JVHS, Karnataka Secondary Education & Examinations Board, Pvt. Ltd, Ltd, CMR Institute of Technology
Skills
Data validation
undefinedAdditional Information
- Personal Details: , Father’s Name N. S. Hemagiri Date of Birth, Sex Male Marital Status
Interests
Travelling
Playing Cricket
Am a Mid Order Right hand batsman always focus on staying at crease and moving score board and also am a Right hand medium phase bowler and always try to place myself to stand at Point Field . Have played Inter Level cricket matches in Wibmo Pvt Ltd and J P Morgan & Chase Company.
Timeline
Snr Data Analyst
Cloudberry360 Technologies
03.2023 - 07.2023
Snr Business Operation Analyst
Wibmo Pvt Ltd
11.2017 - 03.2023
Executive Operations
Flipkart India Pvt Ltd
12.2015 - 11.2017
Reconciliation Specialist
J P MORGAN CHASE
01.2011 - 12.2015
MBA - Finance & Marketing (Regular
C N K Reddy College of Business Management
10.2008 - 06.2010
Executive
Angel Broking
10.2007 - 10.2008
BBA - Marketing & Entrepreneurship Development
JSS College, Karnatak University
07.2004 - 06.2007
PUC - Commerce
JVPU College
SSLC (10th - undefined
JVHS, Karnataka Secondary Education & Examinations Board, Pvt. Ltd, Ltd, CMR Institute of Technology
Similar Profiles
SABIRA MELETHILSABIRA MELETHIL
Senior DevOps Engineer at Cloudberry360Senior DevOps Engineer at Cloudberry360
Chong Soo KenChong Soo Ken
Cloud Finance Speciallist (Cloud BG CFO) at Sparkoo Technologies (Malaysia) Sdn. Bhd (Cloud Subsidiary for Huawei Technologies (Malaysia) Sdn Bhd)Cloud Finance Speciallist (Cloud BG CFO) at Sparkoo Technologies (Malaysia) Sdn. Bhd (Cloud Subsidiary for Huawei Technologies (Malaysia) Sdn Bhd)
SRIRAM RSRIRAM R
Software Quality Analyst at GAVS Technologies (formerly Neurealm Technologies Pvt Ltd)Software Quality Analyst at GAVS Technologies (formerly Neurealm Technologies Pvt Ltd)
NAINIKA NAGIRIMADUGUNAINIKA NAGIRIMADUGU
Sr. Strategic Plan Specialist at Honeywell Technology SolutionsSr. Strategic Plan Specialist at Honeywell Technology Solutions
Debabrata DashDebabrata Dash
Consulting Member of Technical Staff at OracleConsulting Member of Technical Staff at Oracle