Aug 2019 – Dec 2019 · 4 mos · Stamford, Connecticut

• Conducted initial analysis based on Income buckets and credit score using SAS to lay the ground work for predictive collections and on-boarding model
• Identify the Franchise Tax Areas that needs to be placed into Pay in advance category based on the 4 month churn rates of new customers

May 2018 – May 2019 · 1 yr · Stamford, Connecticut

• Built Tableau dashboards to measure the performance of vendors involved in collection tactics
• Automated business processes using Python, Excel VBA and SQL to increase team efficiency
• Created an automation to decrypt PGP encrypted files with sensitive customer information to strengthen confidentiality of data
• Performed validation tests using R on vendor collection data
• Develop and manage complex SQL queries in MS SQL server to manage daily collection activities and perform month end reporting and analysis

Jan 2018 – May 2018 · 4 mos · University of Texas at Dallas

• Account Reconciliation: Reconciled accounts in reports extracted from PeopleSoft with the e-procurement software
• Financial Analysis: Performed a Budget Burndown Analysis in Tableau to measure the spending rate versus the funding and perform interdepartmental transfers of funds through FMS module in PeopleSoft
• Reporting: Prepared an application using Excel VBA to integrate and automate the invoice generation process for 13 cost centers under the purview of Office of Research that increased the process efficiency by 100%

Jul 2015 – Jul 2017 · 2 yrs · Greater Hyderabad Area

• Detected various trends and patterns in panel data to develop custom routines for testing areas of audit interest such as Revenue, Expenditure, Inventory, A/R and A/P for a client with an annual budget of over 15,000 hours
• Designed quantitative methods using SAS and Tableau to identify areas of high risk, unusual patterns & trends within various business processes, that directly led to winning a 5-year contract extension on one of the fortune 500 clients
• Supervised a team for 4 professionals, responsible for application of general ledger analytics procedures as a part of mandatory anti-fraud guidelines, for over 50 audit clients with an overall annual budget of more than 10,000 hours
• Facilitated multiple training sessions in SAS, Excel VBA for the incoming new hires in Deloitte

Jul 2014 – Jun 2015 · 11 mos · Greater Hyderabad Area

• Processed data sets having more than 100 million rows using SAS to perform audit related analytics.
• Reconciled the client’s GL data with the Trial Balance by developing scripts in SAS and identified the scope for further analytics.
• Evaluated the fundamental characteristics of the organization's data through data profiling and identified/developed an inventory of associated potential risks.

May 2013 – Jul 2013 · 2 mos · Noida, Uttar Pradesh, India

• Developed a password protected tool in MS Access using Access VBA and SQL to maintain a record of purchases and inventories.

Oct 2012 – Oct 2012 · 0 mo · Noida, Uttar Pradesh, India

• Worked as a volunteer during the 2012 Formula One Airtel Indian Grand Prix and carried out the roles and responsibilities assigned, with utmost zeal and enthusiasm

Oct 2011 – Oct 2011 · 0 mo · Noida, Uttar Pradesh, India

• Worked as a volunteer during the 2011 Formula One Airtel Indian Grand Prix and carried out roles and responsibilities assigned in the corporate boxes, with utmost zeal and enthusiasm.