RAKESH CHATWAL

*** ********* ****** 202-***-****

Cedar Park, Texas - 78613 VISA Status - Lawful Permanent Resident (Green Card holder) ad4uhl@r.postjobfree.com SUMMARY:

Rakesh has more than three years of experience as a Data Quality Analyst with Kestra Financial with a strong background in ensuring data accuracy, completeness, and consistency. He is experienced in developing and implementing data quality standards, conducting data audits, and identifying and resolving data quality issues using statistical analysis techniques and data analysis tools like SQL and Microsoft Excel. As a Data analyst, he has proven ability to collaborate with cross-functional teams to improve data integrity and optimize business processes. He also has more than three decades of international experience at The United States Embassy, India in the Financial Management Center specializing in budget management, cost planning and optimization, forecasting and annual financial planning. He has worked on several engagements where he was responsible to evaluate budget proposals and funding requests and conduct cost-benefit analysis to determine accurate requirement of funds to fulfill mission goals. He is seeking a challenging role where he can leverage his expertise to enhance data quality and drive informed decision making.

International Experience: India, USA

PROFESSIONAL EXPERIENCE

Kestra Financial Services, Austin,Texas Sep ‘20- Mar’24 Data Quality Analyst

● Developed and implemented data quality standards, resulting in 20% improvement in data accuracy within the first year.

● Conducted regular data audits and quality assessments, identifying and resolving 95% of data discrepancies and inconsistencies.

● Collaborated with cross-functional teams to improve data governance and compliance, ensuring adherence to regulatory requirements such as FINRA.

● Implemented data cleansing and validation techniques, reducing data errors by 15% and enhancing overall data integrity.

● Created customized reports and dashboards using EXCEL, providing actionable insights to stakeholders and enabling data-driven decision making.

● Participated in project teams to assess data quality requirements, contributing to successful project deliveries and customer satisfaction.

The Mission of the USA FSN Staff Provident Fund Trust, The US Embassy, New Delhi, India Jan ‘18- Dec ‘19 Provident Fund Accounting Analyst

● Responsible for planning investments of $43 million retirement fund of 1800 locally engaged staff of Mission India

● Monitored interest earning of $43 million corpus invested in government and private business and resolve discrepancies

● Reviewed market trends to invest $5.2 million of employee and employer contribution in most secured company bonds

● Optimized the provident fund software to resolve discrepancies of Mission employees and improve the system accuracy The United States Embassy, New Delhi, India Oct ‘10- Dec ‘17 Financial Management Analyst (Budgeting)

● Developed annual budget and procedures in WebRabit software to improve financial planning process and ensure internal financial control

● Determined financial objectives in US government developed software to provide accurate forecasts and funding

● Optimized budget spend plans and strategies for meeting mission goals and improving future resources planning

● Worked as a team leader to perform financial functions such as planning, budgeting, accounting and analysis to maintain a consolidated State budget of $15 million

The United States Embassy, New Delhi, India Oct ‘99- Sep ‘10 Financial Management Analyst (Accounting)

● Reviewed the availability of funds of the United States government and obligated the documents such as purchase request, travel orders and grants to meet the mission goals and objectives

● Maintained grade/steps to calculate salary and benefits requirements of more than 1000 employees in Mission India for a financial year

● Performed as an advisor to Financial Management Officers (FMO) on USG funding regulations and guidelines during the year and at crucial periods such as lack of appropriation and Continuing Resolution (CR) at the end of year

● Maintained financial data in Mission’s appropriate software and prepared periodic reports on financial progress of monthly/quarterly projects on collective balance of funds to ensure expenditures are in line with budget allocations at the embassy and consulates

● Compiled data and prepare reports for initial, mid-year and other data calls from the Bureau fund managers The United States Embassy, New Delhi, India Oct ‘93- Sep ‘99 Accounting Analyst (U.S. India Fund PL-480)

● Responsible for maintaining account books for PL-480 funds allocated to mission India for research and development of agriculture, science and technology, dairy and veterinary programs

● Reviewed the financial statements provided by various agricultural universities to release balance amounts of grants

● Performed on-site audits of financial statements and inventory of equipment purchased using grant funds

● Designed and implement accounting tools and procedures to ensure timely preparation of statutory books of accounts and records

● Prepared financial status reports and provided feedback to top management on financial performance, funds and variance analysis reports

● Reviewed advices of allotment, obligation and commitment documents, for funds control and validating fiscal data to ensure compliance with administrative and statutory requirements Notable Distinctions

● Worked as a principal advisor to the directors at Financial Management Centre (FMC) at US Embassy, New Delhi, India.

● Responsible for management of annual funding of $15 million for major agencies such as Foreign Agriculture Service

(FAS) representation and gift funds.

● Assisted the FMC Director/Deputy Director and Mission management on matters related to interpretation and applicability of fiscal policies and procedures

● As a senior employee of the section, coordinated and monitored budgeting and accounting functions of the agencies located at the US Embassy and four Consulates in India

● Prepared periodical status of funds and project reports for the Management at post and different offices at the Bureau in Washington D.C.

● Played an important role in providing management advisory services related to budgeting, accounting and support to various USG agencies at post and at time to other Missions in the region Training and Certifications

● RFMS/Momentum Financial System – main accounting system of DOS, US Embassy New Delhi, Feb 2007

● Attended ICASS workshop in Garmisch Germany and presented Post ICASS budget in the conference, October 2007

(ICASS is a mechanism to distribute administrative costs among participating agencies)

● Attended ICASS workshop in Morocco and presented post ICASS budget in the conference, November 2008

● E2 Solutions (PK-196 and PK197) – A software used by Department of State (DOS) for all travel related requirements – request, approval, obligation and processing of travel claims, New Delhi December 2008 SKILLS

● Software: Microsoft Office (Excel, PowerPoint and Word), SQL and JIRA

● Strong understanding of data governance and compliance standards

● Data cleansing and validation techniques

● Strong analytical, problem solving and communication skills EDUCATION

Delhi University, Delhi, India May ’79-May ‘82

Bachelor of Commerce

Contact this candidate