Sahil Shah Email & Phone Number

•Conduct JAD sessions with the stakeholders, end users, and SME, to determine the critical business processes and identify key functional requirements for user's terminal adhering to the order management systems•Provide financial planning and analysis support to risk solution department including reporting, analyzing, modeling, and presenting financial annual & quarterly results.•Gatherer analyzes, prepare and summarize recommendations for financial plans, securities analysis, acquisition activity, trended future requirements and operating forecasts. Risk Assessment, strategic impact, and short and long-term needs.•Develop SQL and SSIS ETL business intelligence solutions, data wrangling, migrate disparate source data into a centralized data mart structure for data mapping, data conversion.•Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data. Used Data mapping for collecting the data.•Highly skilled in migrating reports from legacy systems like Hyperion to Power BI using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Bookmarks, Slicers etc.•Performed leadership role in the design, build and deployment of executive-level dashboards and reports.•Worked extensively in Agile and Scrum development teams with project stakeholders, SMEs, and staff to understand the requirements and specifications for new applications along with enhancements to the existing applications•Experience in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports,Cascaded reports and Dashboard such as Graph, Chart, Gauge and Map.

•Executed SQL queries to validate accuracy of data.•Document BRD and FRD, define project scope, prioritization and maintain risk control, making sure all business functions and use cases are captured in the requirement.•Provide financial planning and analysis support to risk solution department including reporting, analyzing, modeling, and presenting financial annual & quarterly results.•Gatherer analyzes, prepare and summarize recommendations for financial plans, securities analysis, acquisition activity, trended future requirements and operating forecasts. Risk Assessment, strategic impact, and short and long-term needs.•Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data. Used Data mapping for collecting the data•Audited the Sales Invoices with the Online Sales Portal.•Made MIS reports and turned them into real time basis by using business Intelligence.•Made Reports which provide Daily, Weekly and monthly P&L and also lets us know whether a specific employee is profitable for the company and also its performance.•Collaborated with a team to prepare working papers using Excel.•Caught Fraud and business Malpractices.•Established operational objectives and work plans and delegated assignments to subordinate managers.•Effectively responded to incidents and other events as necessary.•Generated comprehensive reports regarding incidents, events, and important business matters.•Prepared financial pages for presentation to senior management.•Prepared quarterly LP financial reports .•Analyzed and researched reporting issues to improve accounting operations procedures.

Hook, Hampshire, Gb

• Implemented of recommendations from Basel Committee on banking supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel II.• Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on progress, issues and deliverables of project.• Coordinated with Finance & Regulatory Report Automation Project (Dodd Frank and Call Reporting Process) designed to enhance production efficiencies while decreasing operational risk by using automated reporting application .• Executed day-to-day phases of the audits as the in-charge auditor for both publicly traded and private clients, including audit planning, risk assessments, audit substantive testing, and financial statement in both US GAP and IFRS.• Assisted the Internal Audit Analyst for various work-streams within CCAR Audit - e.g. Basel III, Treasury/Liquidity, RWAs, Capital Policy/Planning, and Risk Identification.• Worked with Release Management, PMO, Executive Management, along with managers/staff in Development, ETT, UAT, Core Business and other areas, to plan, delivers, and track testing progress.• Organized JAD sessions in Agile SDLC environment with project managers, stakeholders and SMEs in business risk management to develop and recommend a trajectory plan for the introduction of derivatives.• Worked closely with the FP& A team • Used SAS/ETL to create reports from relational database or multi-dimensional cubes.

Mumbai, Maharashtra, In

• Processed receipt entries/payment entries, prepared debtors ageing reports, Cash Flow and generated revenue and payment reports.• Prepared and analyzed accounting records and financial statements reports and also established table of accounts.• ·Handled ledger accounts and kept check on any invoices or payments to ensure fiscal accuracy.• Improved methods to process a variety of entries including Check, EFT, Wire, Recurring, Utility payments, and Invoices, greatly reducing related administrative costs.• Consistently praised for the quality and timelines of reports, attention to detail, exemplary service delivery and team-player attitude

Mumbai, Maharashtra, In

• Processed receipt entries/payment entries, prepared debtors ageing reports, Cash Flow and generated payable reports.• Prepared and analyzed accounting records and financial statements reports and also established table of accounts.• Utilized a wide array of technology to develop, implement, modify, and document numerous accounting procedures.• Improved methods to process a variety of entries including Check, EFT, Wire, Recurring, Utility payments, and Invoices, greatly reducing related administrative costs.• Verified data integrity and accuracy.

Master Of Business Administration (M.B.A.), Finance

Master Of Commerce Part - 1, Accounting And Finance

Bachelor Of Commerce (B.Com.), Accounting And Finance