Simran K C Email & Phone Number

Paris, FR

Louisville-Jefferson County, Kentucky, US

- Extracted datasets using SQL and advanced Excel functions (PIVOT tables, xlookups, IF functions) to analyze performance metrics, identifying cost-saving opportunities that enhanced operational efficiency.- Led 5+ ad-hoc projects with SQL, employing JOINs for data merging and GROUP BY for aggregating sales by product categories, providing insights for.

Marietta, Georgia, US

• Performed Current Expected Credit Loss analysis by creating Weighted Average Remaining Maturity (WARM) reports for banks and credit unions using SQL queries to extract large data sets and analyzing data through pivot.
• Extracted and analyzed large banking data sets to study the ongoing condition of deposits and loans of various banks across the US, using data cleaning tools, pivot tables, charts, dashboards, and slicers to analyze.
• Worked on the server-side of QwickAnalytics by managing data to ensure accuracy of financial metrics, performance ratios and other regulatory solutions used by subscribers as a tool to analyze and evaluate bank.
• Conducted financial research projects, developed, and maintained financial dashboards and visualization for easy data interpretation, presented to senior management and relevant stakeholders.
• Analyzed SEC financial statements to calculate performance ratios used by investment managers to make investment decisions.

Worcester, Massachusetts, US

• Instructing graduate and undergraduate students and teachers in computer lab technology and various software applications available at the SOM’s computer lab such as Tableau, KNIME, Power-BI, etc.,
• Developing detail spreadsheets using Excel, Pivot and SQL to assist professors and departments with research experiments, analyzing data, and developing forecasts.
• Monitoring students’ and visitors’ activities while on duty in the computer lab for the purpose of maintaining a safe environment that is conducive to learning.
• Supervising the operation of Carlson Hall, assisting professors and students at SOM and conducting events and information sessions.

• Supporting Senior Research Analyst with company specific research projects, model building, comparison of analyst expectations.
• Provide thorough equity and credit research on selected companies and communicate through written and oral presentation.
• Aggregate appropriate information for evaluation of new investment ideas in convertible securities, equities, warrants.
• Evaluating potential institutional clients and determining if they are appropriate targets, assisting in the preparation of marketing materials and administrative activities.
• Maintain and review industry analysis research for each of the company’s investments, prepare and distribute variety of periodical research summary reports.

Kathmandu, Bagmati, NP

• Managed the entire section under accounts payable using company specific software and implemented online data entry system which reduced invoice input time by 55%.
• Successfully decreased month-end closing tasks span from 7 days to 3 days with the effective use of the computerized accounting system.
• Administered the entire section under accounts payable, successfully increased the yearly accuracy report by 38% within two years.
• Led a team of 8 members where we worked together to redesign the accounts payable system, thereby increasing system efficiency by 50%

Kathmandu, NP

• Assisted with financial modeling, statistical analysis, and other special projects.
• Prepared and presented monthly financial analysis reports and data driven recommendations to the finance team.
• Involved in the estimation of budget and capital requirements under department managers.
• Assisted with day-to-day operations including invoice record and archiving for the yearly tax audit.

Master Of Science - Ms, Finance, General

Bachelor Of Business Administration - Bba, Accounting And Finance