Prateek Rastogi

Background

About Prateek Rastogi

Expert in Financial Planning, analysis and USGAAP accounting and reporting, seamlessly managing end-to-end HFM numbers and performing intricate financial analyses. Adept at leveraging SQL, Power BI, and advanced Excel skills to extract meaningful insights and drive strategic decision-making. Demonstrated expertise in budgeting, forecasting, and financial modeling. Committed to optimizing financial processes and delivering actionable recommendations for business growth. My core competencies lie in FP & A and R2R processes, where I've led cross-functional teams to deliver exceptional financial reporting and insights. My approach integrates robust analytical skills with a strategic vision, ensuring financial accuracy & operational excellence. Successfully managed FP & A, delivering accurate insights to support key business decisions. Data Analysis and Visualization: Proficient in creating dynamic dashboards and reports using Power BI, facilitating data-driven decision-making. Developed robust financial models to analyze trends, identify opportunities, and mitigate risks. Financial Modeling and Forecasting: Spearheaded financial modeling initiatives, aiding in accurate forecasting and budgeting. Utilized advanced Excel functions to streamline financial processes, ensuring precision and efficiency. Technical Skills: SQL: Expertise in crafting complex queries for data extraction, transformation, and analysis. Power BI: Proficient in creating visually compelling dashboards and reports to convey complex financial data. Advanced Excel: Skilled in utilizing advanced functions, pivot tables, and macros for comprehensive financial analysis. In our organization, my role involves marrying analytical prowess with strong business acumen to drive results and improve operational efficiency. This is achieved through a deep understanding of financial systems—SAP, HFM—and a commitment to excellence in General Ledger accounting, account reconciliations, and month-end closures. Six Sigma (GB),(BB) trained, tested and Certified • USGAAP • Record-to-Report • Financial Accounting and Reporting • Financial Planning and Analysis • Month-end Close • Financial Statements Preparation • Intercompany Accounting • Account Reconciliations • Process Improvement • Internal Control • Tools Expertise (Oracle, SAP, Tally ERP, DIT, FIT,SAS, ICWF tool, HFM, Tableau, Adaptive, Adv Excel, CMT etc.)