Financial Analyst

Resume posted by ajeet gupta in IT.

Desired position type: Full-Time
Location: New Delhi Delhi, India

Contact ajeet gupta

Summary

Analyst with 4 years of experience. Skilled in R- programming / SAS/ SQL . and statistical modeling.

Education

Graduated in Commerce from Bihar University in 2007.

 

 

Experience

Financial Analyst- AON- (March-2016- Present )

Project Details:

  • Revenue Control Management- Order-to-Cash Operation.

Descriptions – Operation which supports by testing the recognition of revenue from contractual arrangements, evaluating the presentation of revenue—gross versus net revenue, testing whether revenue was recognized in the correct period, evaluating whether the financial statements include the required disclosures regarding revenue.

  • Imported data in R and SAS from different sources in different formats such as Excel, CSV, and database file.
  • Wrote  R script for data cleaning, handling missing values, Model Identification.
  • Created Time Series Model to forecast monthly contract submission for financial audit.
  • Wrote R script to highlight Contract Returned Type and major contributors.
  • Wrote function to extract sample data based on multiple audit criteria for quality control team.
  • Created macro variables using different method worked on different date functions and character functions available in SAS
  • Worked on different data type conversions and worked on SAS Procedures like proc contents, proc transpose, proc append proc sort, proc import, proc export etc.
  • Creating user defined formats by using Proc formats and data set lookup to increase the performance
  • Project Details:
    • Revenue Control Management- Order-to-Cash Operation.

     

    Descriptions – Operation which supports by testing the recognition of revenue from contractual arrangements, evaluating the presentation of revenue—gross versus net revenue, testing whether revenue was recognized in the correct period, evaluating whether the financial statements include the required disclosures regarding revenue.

  • Wrote SAS programs to performed ad-hoc analysis.
  • Created Regression Model to design Balance Score Card indicating 3 major KPI directly impacting Operational Quality.
  • Wrote  script for correlation matrix and regression analysis.
  • Performed exploratory data analysis.
  • Wrote R programs to performed ad-hoc analysis and data manipulation.

Analyst- ACCENTURE -March 2014- sept 2015 .

 

Project Details-

 Account Receivable Management – Order to Cash (B2B)

Description – Team supporting account receivable and bad debt optimization for the client who provides logistics Services across the globe that has average receivable for $400 million.

  • Imported data from different sources in different formats such as Excel, CSV, and database file.
  • Created Time Series Model to forecast monthly account receivable and overdue
  • Created various SAS Reports, Tables, Graphs and Summary analysis.
  • Wrote SAS programs to performed ad-hoc analysis and data manipulation.
  • Prepared monthly operational excellence report to highlights variances & related analysis.
  • Provide Bucket Analysis report indicating Account Receivables position and their composition by age and top clients in terms of outstanding receivables.
  • Prepared Forecasting & Prediction Dashboard highlighting weekly roll-over on account-receivables’ portfolio and segmenting major contributors in terms of future roll over.
  • Preparing Dispute management dashboard weekly   open dispute trend categorized by root cause and major contributor and impacted revenue.

Process Developer- GENPACT (Oct-2012- Feb-2014)

Project Details-

 

  • Late Stage Agency – Order to Cash (B2C) GE Capital Retail Bank.

Description – focused late stage collections that utilize payment-restructuring plans for greater collections results.

 

Tool –  Microsoft Excel.

 

Role-

    • Provided strong reporting and analytical information support to management team.
    • Performed data analysis and generating reports on periodic basis.
    • Provided weekly and monthly prediction reports highlighting magnitude of predictor.
    • Provided weekly and monthly employee productivity report highlighting top performer and their accuracy rate, weekly closed dispute trend with dispute resolution age.
    • Prepared Weekly Roll over Trend to Control Past due amount.

    Provided daily performance tracker report of employees to Management.

Skills

  • R-Programming (2-years)
  • SAS
  • SQL
  • Microsoft Excel.

Privacy Preference Center