MANDAR MANIK MCSA - BI Reporting | MBA – Finance (FT)
Bungalow No 6 "Girikunj", Devdarshan CHS, Dongri Pada, Near Vijaya Bank, Ghodbunder Road.
Thane. Maharashtra 400615.
https://www.linkedin.com/in/mandar-manik-/
“Anyone who stops learning is old, whether at twenty or eighty. Anyone who keeps learning stays
young.”
- Henry Ford
Core Competencies
A designated Microsoft Certified BI Reporting Professional with over 12 years of experience having a passion for
data analysis and making informed decisions backed by data. I strongly believe that with the advent in technology there
is no best solution to anything but only a better solution, the challenge is in identifying what best can you make of the
data at hand and make the most of what you have. My obsession with being productive and optimising processes has
been the driving force for me to learn tools like Power BI, Power Query and DAX which are very powerful.
Skilled in Data analysis, Data Visualization, Data Manipulation, Modelling, Dashboards and direct connectivity to data
sources in Excel and Power BI.
I am an avid listener and articulate speaker and look at myself as someone who understands the Business side of
things and can use not just Excel and Advance Formulas, Pivot Tables etc.. but also, the Power Tools like Power
Query, DAX, Advanced Visualisation using Power BI etc.
This makes me a complete package and perfectly suited for a Techno Functional kind of a role where I would be
able to express and demonstrate key artefacts relating to Impact Analysis, RCA, Productivity Trends and areas
of opportunities just to name a few by using the best tools available. I see more and more companies moving to
Self Service BI which would merge the IT and Operations role to quite an extent and hence I bring the best of
both worlds to the table!
Summary of Skills
Risk Management, Analytical Skills, Business Analysis, Data Analysis, Business Intelligence, Data Modelling
Data Visualization, Microsoft Power Query, Advanced Excel
Accomplishments
Encore Award (August 2017) - Core Value Champion for Accenture Operations in India
Service Excellence Award (August 2012) – by Head Operations Executive & Client Service Executive - Received
Service Excellence Award at JP Morgan Chase in Recognition for Superior Service, Proactive Mitigation of Issues and
Recognition by the Client Service Team Globally
Business Productivity Award - Zing Winner (productivity & efficiency) for the year 2010, 2012 (Liquidity Solutions) at
JP Morgan Chase.
Professional Experience
Project Manager – Analytics (Business Intelligence – Power BI/Azure/SQL)
HCL Technologies
-
-
10/2021 till Present
Mumbai, Maharashtra
I am responsible to create end to end solutions for projects for multiple teams of Operations for Service Desk,
CRM, Tech Support etc.
Our team caters to automate the manual tasks performed by our Operations counterparts by providing
customised solutions in Power BI. Each report is part of a tier structure which varies based on the report
functionality.
We manage the entire data lifecycle right from gathering data from multiple sources – setting up schedulers
using Power Automate – Loading the Data on MS Azure – Transforming the Data using Data Factory – Creating
Piplelines and loading the data in Azure Tables or SQL Database – Further cleaning the data if required using
Power Query – Creating complex formulas using DAX Measures – Measuring performance and creating efficient
measures and using advanced Data Modelling Techniques – Create customizable Dashboards which are very
easy to use and provide the necessary insights – Publishing the Data on PBI Service for consumption for the
end user.
Coordinate with multiple engagements including the end clients, leadership and tools and automation
counterparts to look for opportunities that can be taken and pro-actively take up projects while delivering
massive impact.
Manage a small team of Data Engineers, Data Scientists, Developers and being accountable for their
contributions in the overall scheme of things.
As part of my KPI I also coordinate with different teams and am on the look out to propose new technologies to
leadership displaying measurable capabilities and look for the efficient highly scalable solutions and not relying
on tools but rather focus or solving the problem at hand.
Professional Experience
Team Leader – Operations and Analytics (Content Moderation)
Accenture
11/2016 till 10/2021
Mumbai, Maharashtra
- Managing a team of roughly 20 people
- Major Responsibilities:
Tracking team performance and ensure that all the KPI’s are met consistently; Accuracy, Recall,
Precision, AHT being the major ones.
Doing RCA and identifying the pain points, then creating a customised plan to target those areas and
work on them. This enables to keep the team performance at the highest level. These typically include
working closely with a team member’s who are struggling with meeting the Accuracy target week on
week.
Collate data from AWS and consolidate the same for the entire process.
Providing Feedback in a very measurable and time driven manner so expectations are clearly
understood.
Optimise the process by creating Reports and Dashboards by using Advanced Excel, Pivot Tables
and Power Tools like Power Query, DAX, Power Pivot etc.
Sharp focus on the continuous improvements / enhancements and innovations to fix the data quality
issues / manual work around.
Track trending performance of various dimensions at a queue level, region wise, lead wise etc. and
find hidden insights or inconsistencies which can either be leveraged or rectified.
Prepare WBR’s and MBR’s which are vetted and then presented by my managers to leadership.
Client Engagement:
- Sharing Ideas and Insights with the Client to enable a better User Experience
- Attend Client calls and work strategically with partners to ensure that the day-to-day operations are aligned with
the long-term goals of the client and there is not much deviation.
- Coordinate with the Client Policy team on a weekly basis and discuss pain points and potential solutions that are
impacting User Experience.
- Quantify data and present to the client if there is an insight or idea which could benefit the client and the overall
User Experience.
- Good written and spoken communication to approach various Risk reporting teams, Operations, Technology and
other teams and to maintain a level of Client Partnership and Coordination.
Assistant Manager (Virtual Relationship Manager)
Aegis Ltd.
07/2015 to 08/2016
Mumbai, Maharashtra
Responsibilities:
- Understanding the Portfolio and Investment Objective of every scheme and guiding the customers to the best
suited product through Video chat.
- Worked closely with the Relationship Management team in preparing customized and interactive dashboards
- Partner effectively with the client and other internal business partners within the organization.
- Establish a Service Review process; planning, organizing and facilitating recurring meetings.
- Play a leadership role and assist other leaders in entrenching a “business and service culture” within the
organisation.
Team Leader
JP Morgan India Services Pvt Limited
07/2012 to 08/2014
Mumbai, Maharashtra
Promoted from a Senior Team Member to a Team Leader in June 2012.
Responsibilities (Operations)
-
Off-site analyst and team lead in the Strategy & Planning, Data Analytics team at JP Morgan - Mumbai
-
Ensure that a smooth maker/checker process is followed with no gaps and uncertainties and each member within
the team understands and performs his/her role to the fullest of potential.
Validating weekly and monthly reports for data quality exceptions.
Prepare timeliness and completeness metrics and report any inconsistencies to higher management.
To always be on top of any new updates/releases from Product/Technology and successfully implement it
within the team.
Worked across multiple ad-hoc and regular analytics projects including: KPI and customer data assessment, market
sizing, competitive intelligence, market shares, Quarterly performance dashboards
Prioritize tasks which I regard as a 'key' to success and inculcate the same within the team.
Served as a training partner to our offshore location Manila and trained the donor location (Tampa FL) on the tasks
done by my team here in Mumbai.
Worked on multiple systems and understood every aspect of it leaving nothing to chance and being proactive if the
system did not behave as desired by reaching out to the tech teams.
Conducted brain storming sessions to ensure participation of the team members and expand the team’s intellect to
increase confidence and interest within the team, while account for any noticeable area of improvement and filling
the gaps.
-
Senior Team Member
JPMorgan India Services Pvt Ltd
02/2009 to 06/2012
Mumbai, Maharashtra
Responsibilities:
-
Handling end to end operations of EOD, SDA and Reconciliation process.
Monitor the job queue and assign jobs to the team members.
Prioritize jobs depending on the cut-off and timely execute them.
Process and verify the transactions that are processed during the day.
Analyze, resolve issues and escalate whenever necessary.
Proactive input to improve system and team efficiency.
Work with other Senior Team Members/Team Leaders to touch base on the latest updates, value addition
opportunities while trying to absorb maximum knowledge being offered.
Ensured smooth functioning of process especially during high volumes.
Allocated jobs to the team and reconciled the jobs completed during the day.
Handled all kinds of escalations and issues in the absence of my Process Manager.
Inputting factors (daily interest rates) for securities which would calculate the daily interest.
Creating various reports which fetched data from the system and enabled consistency while reconciling data.
Technical Support Officer (TSO)
Convergys
Company Overview:
09/2008 to 02/2009
Thane, Maharashtra
Convergys is in agreement with an Australian-based company “Optus”, a leading integrated communications provider.
Convergys supplements Optus' domestic contact centre operations from a facility in India to help its clients balance the
demands of increasing revenue, improving customer satisfaction, and reducing overall cost using an optimal mix of
agent, technology, and analytics solutions.
Responsibilities:
-
Ranged from direct-to-consumer telecom technical support on topics ranging from mobile handsets to internet
access
to video-on-demand; with capabilities including live voice, chat and e-mail.
Reduce Average Handling Time (AHT)
Customer Satisfaction
-
Onsite Business Visits:
●
●
Business travel to Tampa (Florida) in 2009 for 6 weeks to be trained on Liquidity Solutions. I was also shortlisted
to visit the same site in 2010 – 11 for 10 weeks to support business.
Travelled to Atlanta (Georgia) in December 2016 for 2 weeks with business leads to establish client contact and
understanding the product before operations were moved to Mumbai
Education & Certifications
MCSA: BI Reporting
Issued by Microsoft
Passed 2020, January
MBA: Finance
Institute of Management & Computer Studies (Mumbai University)
2010
Thane, Maharashtra, India
Thane, Maharashtra, India
Bachelors in Commerce: Commerce
N.G Bedekar College of Commerce (Mumbai University)
Personal Information
DOB
Marital Status
Gender
Passport No
Validity
:
:
:
:
:
15th December 1984
Married
Male
J-th October 2020
Interests
Browsing, Sports, Music, Networking
2005
Thane, Maharashtra, India
