Ravi Ranjan Kumar

Ravi Ranjan Kumar Job Description Nirmaan NGO is seeking a Data Analyst to perform analysis and validation activities supporting an enterprise data warehousing program. Office of Information Technology (OIT), Data and Business Intelligence Support Services (DBIS) has been tasked with implementing Enterprise Data Warehouse and Business Intelligence (DW/BI) solutions. The Data Analyst will support the program by working with the user community to ensure that they are able to use the data analytics tools and that their resulting reports are accurate. Responsibilities: * Provide the business community with knowledge, skills, and abilities to utilize data analytics reporting tools effectively * Execute change management effectively by promoting the system's usefulness among the user community and ensuring end-user buy-in and satisfaction * Analyze and address any end user reporting requests * Assist to create training tailored to the sites' needs by utilizing in-class training, webinars, or any other training methods * Develop, publish, and revise course and instructional materials for training/ user groups * Evaluate training needs to support the development of learning objectives; collaborate with managers and subject matter experts on the learning objectives, content, and delivery of proposed courses. * Support the development of short- and long-term training initiatives to support organization's mission * Research, evaluate, and recommend external training programs, courses, materials, and instructors to ensure training and development needs are met. Data Analyst- - www.linkedin.com/in/ravi-ranjan-kumar-77702b263 Summary I am a detail-oriented Finance Analyst and Data Analyst with a proven track record in data reconciliation, analysis, and visualization. With expertise in Microsoft Excel, SQL, Power BI, Tableau and Python, I excels at converting complex datasets into meaningful insights. My experience at ASVG & Co. and Maral Overseas Ltd. showcases his ability to manage financial records, optimize business processes, and support decision-making through data-driven insights. Experience Finance Analyst at ASVG & Co. Mar 2024 - Present Conduct thorough reconciliation of client accounts against Paytm’s MIS to ensure accuracy in financial records. Utilize Excel for advanced data analysis, including pivot tables, VLOOKUP, and macros to manage large datasets effectively. Employ SQL queries to extract, manipulate, reconcile and analyze financial data from databases. Identify discrepancies in financial data and investigate the root causes to resolve them promptly. Prepare detailed reports highlighting reconciliation outcomes, discrepancies, and recommendations for process improvements. Collaborate with cross-functional teams to align financial data and maintain consistency across platforms. Ensure compliance with financial regulations and company policies during the reconciliation process. Provide insights and support decision-making by presenting clear and actionable financial data. Automate routine tasks using Excel and SQL to increase efficiency and reduce the potential for human error. Stay updated on the latest financial tools and technologies that can enhance reconciliation processes. Maral Overseas Ltd. Apr 2023 - Mar 2024 Perform stock analysis to monitor inventory levels and provide insights on stock optimization. Conduct Work-In-Progress (WIP) analysis to track production stages and ensure timely completion. Manage payment follow-ups to ensure timely collections and maintain cash flow. Allocate payments against invoices accurately to keep financial records up-to-date. Calculate interest on delayed payments and communicate with clients regarding the same. Verify orders to ensure accuracy in product specifications, quantities, and delivery schedules. Utilize Excel for data organization, analysis, and visualization to support decision-making. Develop and maintain dashboards in Excel to provide real-time insights into financial and operational metrics. Collaborate with finance and sales teams to reconcile accounts and streamline payment processes. Identify trends and patterns in data to forecast future stock needs and financial outcomes. IIFL Samasta Ltd. Aug 2018 - Nov 2020 Generate daily reports to capture and verify collection & disbursement data before COB and EOD. Ensure accuracy in the completion and publication of weekly and monthly reports following MIS guidelines. Conduct accounting report verification to maintain financial integrity and compliance. Manage credit scores and oversee risk view management to minimize financial risks. Adhere to company policies and code of conduct to uphold professional standards. Utilize Excel for data analysis, report generation, and maintaining accurate credit records. Projects Bank Loan Analysis Jul 2022 - Oct 2022 Data analyzed: Customer loan data (applications, credit reports, transaction history) Tools used: Excel, Tableau, Power BI, SQL, statistical and visualization techniques. Goal: Improve loan approval process by identifying key factors that influence approval (e.g., credit score, debt-to-income ratio). Anticipated impact: Reduced default risk, increased profitability (percentages to be determined based on analysis results) Adventure Works Cycles Project Oct 2022 - Jan 2023 Company: Multinational bicycle manufacturer . Goals: Increase market share, decrease cost of sales. Analysis focus: Identifying most valuable clients, expanding product availability online, reducing production expenses. Anticipated impact: Specific numerical targets for market share growth and cost reduction to be determined based on analysis results Skills Microsoft Excel SQL Power BI Tableau Python Data Analysis Data Visualization Business Intelligence Microsoft Office Word Microsoft PowerPoint Education High School secondary School Bachelor of Arts (Economics) Analytical and Problem-solving Quick Learner Good Communication Skills Ability to Work in a Team Strategic Time Allocation Certifications- Data Analyst Certification, ExcelR Solutions Data Analytics Internship, AI Variant Data Visualization by IBM, ExcelR Solutions Mar 2022 - Jul 2023 Jul 2023 - Jan 202 3 Jan 2023