Highlights:

Skills:Power BI, VBA, MS Excel, Analysis, Analytics, MS Office, Excel, Business Analysis, Data Analysis, Analyst, Strategist

Assistant Manager (Senior Business Analyst) 08/2012 - current
Genpact, Jaipur, Rajasthan India
Industry: Consulting
Promoted to Assistant Manager as one among the top performers.
Current work profile includes but not limited to: 1) Summarizing & presenting Productivity via Process Dashboards. 2) Suggesting Process improvement strategies by analyzing metrics and data- set. 3) Addressing and resolving adhoc queries received from Global Stake Holders and Leadership level that helps in effective decision making. 4) Provide Solution Strategies for metrics improvement by writing complex VBA codes and algorithms that simplify complex tasks. 5) Directly work with the offshore stakeholders and Leadership team to create effective Champion-Challenger and Excel/VBA based models to ascertain the performance of the teams/ Third party agencies. 6) Provide intermediate Excel training to several colleagues through formal classroom sessions. 7) Advanced level data analytics through utilization of Power Query, Pivots, OBIEE, Spotfire, Microsoft Excel/VBA. Promoted from Loan Analyst to Business Productivity Analyst. Primary job function includes but not limited to: 1) Running various Productivity and Analytical Models for business. 2) Design & Execute Activity Based Costing Models for stake holders. 3) Design queries for business and complex business problems solving. 4) Providing process Control by identifying Load Management areas and notify apt parties. 5) Proficient in usage of domain software (Business Intelligence/Business Objects, MS Excel) Joined as SME (Loan Analyst) and performed following: - Servicing Direct, Agented and Syndicated deals and responsible for operational activities in HNI Syndicated Corporate Loans keeping knowledge current on loan accounting, portfolios, clients, operational procedures, regulatory requirements, systems and controls. - Ensuring timely disbursement of funds, applying cash and ensuring transactions are in accordance with Legal requirements. - Proficient in handling accounts in Commercial, Energy and Healthcare segments. - Supervising the Audit requests received regarding the Credit Facilities. - Processing the change in Wiring Instructions for the Investors and Borrowers for Direct and Agented deals in both Ledger and Bank. - Minimizing risk by identifying the discrepancies and their root cause, notifying apt parties and taking appropriate action to resolve the issue. - Proficient in usage of domain software (ACBS, Siebel 8.1.1, Webcash, CTX+)--
Independent Training Professional 09/2007 - 07/2012
Infosys, Bank of America, Genpact, Air Hostess Academy, Gita Mittal Foundation, Jaipur, Mysore, Gurgaon, New Delhi, Multiple India
Industry: BFSI
Conducted training sessions with esteemed clients like Gita Mittal Foundation (Steel King Laxmi Niwas Mittal's family initiative for Skill Development programs) Infosys, Air Hostess Academy, Bank of America, Genpact on Soft Skills, Personality Development, Pre-Process and Competency Based Trainings. Reason to leave: Contract over
--
SME (Process Developer) 09/2005 - 04/2007
Genpact, Jaipur, Rajasthan India
Industry: Consulting
Joined as a Process Associate for a UK process. One among the fastest promotion holders as a Process Developer in the initial 12 months of tenure. Two times bronze award winner along with a Silver Award, too. Part of the Lean Team “Illuminati.” Selected to work for 3 processes in a day. New Accounts, RPC and Tele-RPC.
NEW ACCOUNTS: Maintained the database for the whole team along with the other teams under the umbrella of “BLEND”, such as Attendance Tracker and Process Joggers. Part of PCM shadowing. Successfully completed CLS & LEAN Trainings. Introduced the community website “ENIGMA”. Consecutive 2 times WEEKLY ICE contest champion. Leading the mentor-mentee program for the team. RPC: Maintained Dialer chat for the process directly with the UK clients. Introduced Vision Plus Jogger for the process. Part of the mentor-mentee program. TELE RPC: One of the steady performers. Again, maintained the dialer chat directly with the UK clients. Reason to leave: Joined Indian Army--

University of Rajasthan 07/2001 - 04/2004
Jaipur, Rajasthan, India
Degree: Bachelor's Degree
Major:Science
Three year full Degree program. Successfully graduated from the course as First Division aggregate.

Login to view resume: CV_Sumit-Satsangi - Analyst, VBA, Analysis, Strategist