Rohit Malkani, PMP
Mobile no: +91-8879600697
Email: rkmalkani@yahoo.com
Location: Mumbai
Analytical Skill: MIS, SAS Reporting, Data mining and Business Analytics
Technical skill: Project Management (PMP), Tableau, UNIX, Python (Basics), Advanced
SAS programming, Teradata, SQL, Microsoft access, Excel, SDLC and UAT
Functional skill: Card services/BFSI, Mortgage, Foreign exchange (Fx) and Credit Bureau
Certifications: PMP (Project Management), Base SAS and Advanced SAS certified
Summary
15 years of experience in banking domain. Currently working with JP Morgan as
AVP/Associate and leading multiple teams of Business analytics and SAS/Tableau MIS
reporting. Strong focuses on Innovation, team development and process improvements.
Professional Experience
JPMorgan Services India Pvt. Ltd. (Sept 2011 – Current)
(MIS and SAS Reporting - Risk Management)
Associate Vice President MIS and SAS Reporting Feb 2015-Current
Associate MIS and SAS Reporting Jan 2014- Jan 2015
Analyst specialist II SAS Reports Validations Sept 2011- Dec 2013
Job details:
Leading a team to provide summarized data across multiple line of business such as
Credit cards, Business Banking and Auto Finance.
Manage data monitoring activities across all 3 NCRA i.e. Equifax, Experian and
Transunion
Automation of about 70+ report and monitoring 6000+ data elements
Periodically perform in-depth analysis of business functions and post implementation
strategies for improving the efficiency and effectiveness
Experience working in a management capacity, including delegating tasks, managing
people, contingency, resiliency planning and being accountable for the quality of the
team's work.
Career planning with alignment of organization's goals & personal aspirations.
Recruitment, training, appraisal, resource planning, business resiliency plan, building
organization capabilities like creating functional procedures etc.
Identify business impact and present recommendations to stake holders for further
analysis
Involved in project scope with multiple stakeholders including project manager
Ensure to share weekly, monthly and quarterly dashboard on Mumbai team
performance and monitor SLA for business processes and achievements
Ensure controlled environment and align with IT Risk automation development are in
compliance with corporate policies and procedures
Identification of various business groups/functions risk/issues and work together to
resolve them
Plan effectively to ensure controls are placed to avoid re-work within the team
Support validation of model changes and perform UAT
Manage Brain storming sessions with the team to increase efficiency and plan for end
state of the team
Achievements:
Established 3 new teams in Mumbai for Reporting using tools such as SAS, Access,
SQL, Oracle, Teradata, Tableau , Excel and UNIX
Automated 70% of manual efforts using UNIX and SAS technology
Synechron Technologies Pvt. Ltd. : (Dec. 2010 to Sept 2011)
Sr. Associate – QA
Client: Wachovia/Wells Fargo
Project: RFX (Retail Foreign Exchange) Wachovia and Wells Fargo Merger project
Duration: Mar 2011 to Sept 2011
Job details::
Perform UAT on the project implementation
Validate precision of tool of next-generation Wells Fargo foreign-EXCHANGE money-
transfer platform
Worked in collaboration with other team to verify the back end and front end data.
Submitted defects and followed up with the project manager to resolve issues
Responsible to work closely with onsite team and manage deliverable of off shore
team
Mentor and educate new hire with testing and business process
JPMorgan Chase (Mar 2006 – Nov. 2010)
Analyst specialist II Risk Management Aug 2008 – Dec 2010
Analyst specialist I Marketing Analytics Jan 2007 – Jul 2008
Analyst Operations Mar 2006 – Dec 2006
Job details:
Implementation of credit risk and fraud strategy by performing UAT and validation of
Chase Credit Card portfolio, Authorizations, Acquisitions and Portfolio offers
Use of technology such as UNIX, SQL, Base SAS system.
Work on daily, weekly and monthly reports
Streamlined the process of Outbound Acquisitions in invoice processing leading to
increase in efficiency.
Initiated and automated 40 telemarketing monthly and trend analysis by moving
them from excel to Microsoft Access.
Automating Data integrity checks using Microsoft Access.
Achievements:
Was awarded the Best team of the year Award (2008)
Was awarded the Challenger Award for 2nd Qtr, 2007.
Intelenet Global services: Mumbai, India (March 2003 – Feb 2006)
Job details::
Supporting operations sales and service queue with HSBC Credit card client
Achievements:
Was awarded as best associate in Dec. 2005 and Jan 2006
Education
Bachelor of Science (Bsc) from Mumbai University - 2001
Diploma in software technology from CMC Institute - 2002
Base SAS certification – 2012
Advanced SAS certification – 2013
PMP (Project Management Professional) certification - 2014
PGDM-HB in Finance from Prin. L. N. Welingkar Institute of Management
Development and Research – 2015-2017
