Aprajita Singh Kushwah

ac4i3y@r.postjobfree.com 734-***-**** https://www.linkedin.com/in/aprajita-singh-kushwah/

EDUCATION

Cleary University Ann Arbor, MI May 2017

MBA Analytics, Technology & Innovation GPA:3.92/4.00

IPS Academy Indore, India August 2011

Bachelor’s in Commerce Accounting & Finance

SOFTWARE SKILLS & REPORTING TOOLS

Software: Microsoft Office Suite including Word, Visio, Access, Excel, Outlook, PowerPoint

Reporting & Project Management Tools: SQL (Basics), Power Pivot, Rally, Jira

RELEVANT EXPERIENCE

Quicken Loans Detroit, MI Mar 2017 - Present

Reporting Analyst Intern

Assists Team Leader and Team Captain with day to day tasks and responsibilities and conduct various analysis related to maintaining records of payments and loan balances, providing timely communication, overseeing escrow and impound accounts, following up on delinquencies

Enabled improvement in team delivery commitments and capacity planning for sprints by identifying & tracking hidden tasks that increased customer satisfaction

Conducted meticulous GAP analysis while successfully reengineering key business processes to increase operational efficiency and alignment of business unit objectives

Worked closely with Product Owners, coordinating product backlog grooming and story estimation.

Wrote Business rules using Inrule and irAuthor tools to create the front end validation for the loan default process

Extracted data from Mortgage Service Provider (MSP) using Web APIs' and streamlined the process for the loan servicing system

Prepared the write-ups and created ERD, Data flow diagrams for the user stories

Automated the existing manually generated CFPB 5 day timer report for the business and decreased the downtime by 20%

Collected data from myriad sources of loan servicing platform including MSP, amp, On-base etc. and provided visibility to the end user by utilizing Tableau Dashboards

Cleary University Ann Arbor, MI Aug 2016 – Mar 2017

Graduate Assistant

Assist faculty and staff in maintaining prospective applicant data base. Provide office support for the admissions process and assist students with access to the University resources

Created a salary baseline comparison report based on CUPA versus GAASHRM standards (in order to calculate the Delta in terms of salary ranges based on specified roles within the university).

Designing course modules to suite the university standards, based on instructions provided by the administration team.

Working on Ad-hoc reports provided by the HR and Finance teams.

Perform a variety of administrative tasks including preparation of Power Point presentations, data entry and analysis, web site development, collating marketing materials and presentations.

Hinduja Global Solutions Hyderabad, India Oct 2012 – Aug 2015

Group Leader

Managed a team of 25 employees and was responsible towards achieving business goals and managing KPIs

Presented financial reconciliation, business invoices and client specific trending reports that helped in reversing close to $900K in accounts receivable

Created ROI reports for internal reporting, calculated monthly and weekly revenue goals and sphere headed project closures using HIPAA and Compliance guidelines

Provide financial support and analysis to Operations areas for strategic business decisions and cost savings initiatives

Identified financial impact through forecasting analysis on newly identified trends and findings by working closely with the reporting team

Involved in project status meetings, QA review meeting, System set-up and testing

Identified $600K using data analysis techniques that positively impact client revenues

Worked directly with the Associate Vice President on monthly, quarterly and annual P&L analyses to better forecast project profitability and operating result.

Created business documents and layouts as per HIPAA standards towards Electronic Data Interchange (EDI). Experienced in Process Documentation, Analysis and Implementation of 835, 837, 834 270, 271, 277/997 (X12 Standards) processes for both Provider and Payer side.

Assisted in streamlining a process for capturing business requirements that increased accuracy, efficiency, and productivity and participated in implementing a customized revenue forecasting reporting module for CRM software leading to greatly increased accuracy and flexibility within the first three months in the new role.

Followed Agile framework which included Iterative planning and sprint cycles

Created the financial reconciliation process on transactions pending greater than a year which created a great value add to the clients (Impact: Over $6M)

Deloitte Consulting Hyderabad, India Sept 2011 – Oct 2012

Associate Analyst

Worked on Contract Management that included reviewing client specific contracts and identified loopholes based on federal guidelines (US-Healthcare guidelines)

Identified and created SOPs and training necessities for the CSRs. Responsible for gathering CRM information and developing a comprehensive report once a month for management

Worked on reversing denials and provided resolution on the accounts receivable on critical accounts ageing for more than 180 days, categorized as ageing and uncollectable

Compiled and reviewed complex data to assess multimillion-dollar accounts, which was resolved leading to high dollar payments.

Conducted internal reviews under the guidance of Lead Financial Analyst's towards financial forecast reports and also assisted in report writing and FY budget reporting

Analyzed and interpreted monthly variances and trends between budgets and actual expenses

Gathered Requirements and created process flows towards denial reversals, billing and improved member services (by building process flows in a root-node format)

Contact this candidate