As a data analyst with a BTech in Information Technology from NIT Kurukshetra, one of the leading engineering institutes in India, I have a passion for solving complex business problems using data and technology. I have demonstrated my skills and proficiency in Python, SQL, Power BI and data analysis, earning gold badges from HackerRank and a LinkedIn certification.
Mobikwik
View- Website:
- mobikwik.com
- Employees:
- 506
-
Senior Data Analyst - Credit RiskMobikwik Jun 2024 - PresentGurugram, Haryana, India -
Analyst Risk And Information ManagementAmerican Express May 2023 - May 2024Gurugram, Haryana, IndiaSpearheaded the PRSA Validation team within the second line of Risk Management, utilizing SQL to pinpoint control discrepancies, testing gaps, and crucial components across all active Amex processes.Employed SQL queries to analyze established KRI metrics, identifying operational vulnerabilities, areas prone to risks, and pinpointing opportunities for potential new KRIs.Leveraged hive queries in conjunction with Power BI to craft monthly dashboards, highlighting key trends and insights… Show more Spearheaded the PRSA Validation team within the second line of Risk Management, utilizing SQL to pinpoint control discrepancies, testing gaps, and crucial components across all active Amex processes.Employed SQL queries to analyze established KRI metrics, identifying operational vulnerabilities, areas prone to risks, and pinpointing opportunities for potential new KRIs.Leveraged hive queries in conjunction with Power BI to craft monthly dashboards, highlighting key trends and insights in Operational Risk for informed stakeholder decision-making.Leveraged data analytics using SQL and Python to evaluate historical data, distinguishing essential patterns and discrepancies that contributed to the enhancement of PRSA standards.Orchestrated Quarterly IV Review strategies, harmonizing cross-departmental objectives, monitoring progress, and optimizing efficiency in rollout.Functioned as a Subject Matter Expert (SME) for the implementation risk domain, guaranteeing that processes underwent accurate validation and were consistent with risk guidelines.Conducted weekly Business Root Cause Analyses to pinpoint and underscore any deficiencies in meeting stipulated monthly or weekly targets. Show less -
Senior Lead AnalystAmerican Express Nov 2021 - Apr 2023Gurugram, Haryana, IndiaBuilt various dashboards for visibility of Business metrics, cards spend, overall portfolio growth etc. to get near real-time insights.Improved CAP scoring methodology; highlight the Error Matrix with Accuracy percentage as per the 4 checks of business conduct.Took initiative of creating a reliable data repository of 10000+ Signings, ensuring the accuracy & accessibility of Signings data.Streamlined the reporting process by creating the live MIS for monthly signings and enhances… Show more Built various dashboards for visibility of Business metrics, cards spend, overall portfolio growth etc. to get near real-time insights.Improved CAP scoring methodology; highlight the Error Matrix with Accuracy percentage as per the 4 checks of business conduct.Took initiative of creating a reliable data repository of 10000+ Signings, ensuring the accuracy & accessibility of Signings data.Streamlined the reporting process by creating the live MIS for monthly signings and enhances overall financial reporting efficiency.Led automation to reduce 60% man- hours using mix-bag technologies like Python, SQL and Cornerstone.Analyzed spend data for US Small & Medium Enterprise (SMEs) with an average deal size of 1 million+ Show less -
Associate ConsultantCubastion Consulting May 2021 - Nov 2021Gurugram, Haryana, IndiaCollaborated with a premier global automobile client, employing SQL, Python, and Power BI to deeply understand and outline their specific product requirement.Formulated strategic plans in Jira, overseeing daily product management and amplifying functionalities via API integrations.Engaged effectively with cross-functional teams, streamlining efforts between internal analytics, technology, and engineering departments and ensuring alignment using Confluence.Working Partnered with… Show more Collaborated with a premier global automobile client, employing SQL, Python, and Power BI to deeply understand and outline their specific product requirement.Formulated strategic plans in Jira, overseeing daily product management and amplifying functionalities via API integrations.Engaged effectively with cross-functional teams, streamlining efforts between internal analytics, technology, and engineering departments and ensuring alignment using Confluence.Working Partnered with leadership, harnessing the analytical power of SQL and Power BI to dissect, manage and interpret industry and competitor trends, delivering pivotal insights for the client. Show less -
AnalystJanmat Political Consulting Jan 2021 - Apr 2021Guwahati, Assam, IndiaInvolved with the research team to create Panchayat level report to get the idea of their problems and hot points for the election and divided the booth into 3 sets Safe, Favourable, and Dicult on basis of their previous election result.Organized Bike & Cycle rally in every Panchayat to boast the campaign process with more than 200 bikes & 50+ taxis.Collaborated with district team and local team for door to door campaign with Guhari Patra & Sankalp Patra -
Data AnalystThaari (Swiftonne Logistics Solutions Pvt. Ltd.) Mar 2019 - Jun 2020Gurugram, Haryana, IndiaAimed to create an integrated inter-city logistics web platform for all stakeholdersResponsibility: · Involved getting Shippers, Transporters, Brokers and Drivers, onboard on the platform to seamlessly collaborate, communicate, transact, and get benefited.
-
Software EngineerTulsana Consultancy Services Private Limited Nov 2018 - Feb 2019Noida, Uttar Pradesh, IndiaEngineered and optimized scalable content solutions tailored for e-commerce businesses via the EZDIA Crew Machine, leveraging SQL and Python for seamless backend implementations.Designed and refined test scenarios for the EZDIA Crew Machine, integrating Python scripts within the Selenium framework, all managed and tracked using Jira, to enhance test automation capabilities.Amplified software performance by 50% through meticulous parameter tuning, while concurrently developing and… Show more Engineered and optimized scalable content solutions tailored for e-commerce businesses via the EZDIA Crew Machine, leveraging SQL and Python for seamless backend implementations.Designed and refined test scenarios for the EZDIA Crew Machine, integrating Python scripts within the Selenium framework, all managed and tracked using Jira, to enhance test automation capabilities.Amplified software performance by 50% through meticulous parameter tuning, while concurrently developing and incorporating innovative features through robust and adaptable Python code. Show less
Ram Lakhan Education Details
Frequently Asked Questions about Ram Lakhan
What company does Ram Lakhan work for?
Ram Lakhan works for Mobikwik
What is Ram Lakhan's role at the current company?
Ram Lakhan's current role is Senior Credit Risk Analyst | NIT KKR.
What schools did Ram Lakhan attend?
Ram Lakhan attended National Institute Of Technology, Kurukshetra, Haryana.
Who are Ram Lakhan's colleagues?
Ram Lakhan's colleagues are Ayana Shukla, King Money, Kusum Kumari, Kamlesh Kumar Saini, Dharamvir Singh, Yashika Dwivedi, Kirti Nagpal.
Not the Ram Lakhan you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial