Shushant Sharma
Summary
With over 10 years of experience in Data Analytics, Data Mining, and Data Visualization, I specialize in Master Data Management, automation through Alteryx Designer and Tableau, and SQL-driven data analysis. My expertise includes managing data flows from legacy systems (GBS, Insight, Mainframe) to target platforms (Oracle, SAP), as well as extensive work in financial applications testing, GL reconciliation, month-end closing, and financial reporting. I am skilled in mapping, JIRA story creation, PAPA tickets, Access Request Management, and SOX audits. My work also spans Cash & Check reconciliation, Asset Accounting, and Residual Analysis, driving efficiency, compliance, and improved decision-making across organizations.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Ast Manager (Legal Entity Database Management)
Bank of America
09.2022 - Current
- Data Element Management: Manage 185 critical legal entity data elements across various source systems (Blueprint, Special Purpose Vehicle, Variable Interest, Regulation W, Cesium) including ELEI ID, GCI ID, NAICS code, ownership, and parent company details.
- Data Synchronization & Quality Assurance: Track and ensure data consistency across source systems and LED, performing regular checks and ensuring data synchronization between systems.
- Quarterly Assertion & Controller Sign-Offs: Oversee quarterly assertion processes where controllers provide sign-offs on entity data, ensuring compliance and accuracy.
- Alteryx Model Development: Built 15 Alteryx models to automate data checks, reducing manual intervention to a supervisory level and significantly improving process efficiency.
- Efficiency Gains & Time Savings: Saved 2,500+ hours annually through the automation of data checks, including 100+ hours for monthly statistical reporting and 80+ hours annually by automating file extraction from Power Query.
- Process Improvement: Created JIRA stories, LAUX maps, and metrics to support system enhancements and ongoing data management improvements.
Team Leader (Finance Reference Data Management)
Bank Of America
10.2018 - 08.2022
- Streamlined Financial Data Flow & Reporting: Corrected and optimized financial data interfaces, saving 2,000+ hours annually through Alteryx Designer. Reduced 6 End User Computing (EUC) applications, streamlining reporting for SWAPS, debt-based, and foreign exchange instruments.
- Alteryx & SQL Development: Built and designed 4 complex Alteryx Designer reports with SQL-based queries from a Master Data Management (MDM) perspective, leveraging RDR database to improve financial reporting accuracy.
- Source-to-Target System Mapping Projects: Successfully completed 5 data flow projects, ensuring accurate mappings between source systems (GBS, Oracle, Insight, FCS, Mainframe) and the target SAP reporting system. This impacted entities across US, LATAM, EMEA, and APAC regions.
- Suspense Queue Development: Built a web-based suspense queue application to track and clear suspense from various source systems, reducing 5 EUCs. Conducted testing in UAT, SIT, and PROD environments, saving 500 hours annually.
- Data Visualization & Efficiency Gains: Developed 80+ Tableau reports and created 20+ interactive dashboards with filters, achieving a 30% improvement in reporting efficiency.
- Regulatory Reporting & Compliance: Identified and highlighted a Self-Identified Audit Issue (SIAI) related to noninterest vs. interest income, improving compliance with regulatory reporting policies.
- Data Migration & System Integrations: Completed 2 GBS-to-Oracle migration projects, supporting data consistency and integration across systems.
- Financial Reporting Accuracy & Account Reconciliation: Maintained and cleared suspense accounts impacting US GAAP, IFRS, and local ledgers for LATAM, EMEA, APAC, and US regions, ensuring financial reporting accuracy.
- Tableau Reporting to Senior Management: Reported data insights and visualizations via Tableau on the Enterprise Data Warehouse (EDW) to senior stakeholders, enhancing decision-making.
- Process Enhancement & JIRA Management: Created JIRA stories for application enhancements and new implementations; collaborated on testing with tech teams to improve workflows, including SAP GL Upload Tool and Interface Gateway Workflow, by creating comprehensive test scripts.
- Control & Compliance: Reviewed and approved process metrics and monthly Chart of Accounts maintenance requests, ensuring compliance from a control standpoint and acting as the primary SOX audit liaison.
Senior Accounts Executive (Revenue Recognition/Reporting)
Bharti Airtel Limited
07.2017 - 09.2018
- IFRS 15 Revenue Recognition & Reporting: Recognized and reported revenue for inbound, outbound, leased line, and VAS products, ensuring compliance with IFRS 15 standards.
- Deferred & Provisional Accounting: Managed deferred accounts, provisions, and debtors; reconciled Accounts Receivable (AR) with General Ledger (GL) to ensure trial balance accuracy.
- IFRS 9 Bad Debt Provisions: Prepared bad debt schedules at the console level, providing P&L insights and compliance with IFRS 9.
- International Project in Africa: Traveled to Nigeria and Africa to successfully migrate bad debt accounting, standardizing financial records and enhancing data accuracy.
- Client Communication & Recognition: Improved client relations by resolving queries effectively. Awarded for completing Nigeria’s revenue recognition process in the shortest span of time.
Senior Executive (Account Receivable)
Serco Global
07.2015 - 06.2017
- Post entries for revenue recognition as per IFRS 15 guidelines
- Preparing Variance reports by analyzing actual revenue received vs cost billed
- Preparing monthly reconciliation for our summary ledger to sub ledger accounts, highlight unbalanced line items and rectifying those in process on SAP
- Prepare and publish reconciliation for billed and un-billed revenue
- Helping team in month end closing by posting appropriate accruals for balanced P&L, balance sheet
- Prepare monthly AD-HOC reports for flash revenue versus actual revenue report!
- Raise credit and debit notes in S.A.P ERP
Senior Process Associate
Accenture Services
07.2014 - 07.2015
- Create and monitor a system of controls, procedures and forms for recordation of fixed assets
- Maintain Asset master data in assign assets to their respective class
- Maintain depreciation report assign those to company codes for two countries US and UK
- Book depreciation entries for all fixed asset related to regulatory policy
- Reconcile the balance in the fixed asset subsidiary ledger to summary-level accounts in GL
- Track company expenditures for fixed assets in comparison to the capital budget and management authorization
- Review and update the detailed schedule of fixed assets and accumulated depreciation
- Prepare audit schedules relating to fixed assets and assist the auditors in their queries
Executive
Go Realty Mart
12.2012 - 07.2014
- Company Overview: Company Closed
- Maintain daily petty cash register
- Maintain commission register for sales
- Prepare monthly bank reconciliation
- Prepare and publish monthly expense reports
- Company Closed
Education
Bachelor of Commerce -
Lucknow University
LucknowSkills
Alteryx Designer (Certified)
Tableau Dashboards
SQL Queries
Data Mining
Advanced Excel
VBA
End-User Application Testing
PowerPoint
MS Word
JIRA Dashboard
Access Request Management (ARM)
Certification
- Alteryx Designer Advanced Certification – Alteryx
- Alteryx Designer Core Certification – Alteryx
- Alteryx Designer Core Micro-Credential: Data Manipulation – Alteryx
- Alteryx Designer Core Micro-Credential: Data Preparation – Alteryx
- Alteryx Designer Core Micro-Credential: General Knowledge – Alteryx
- Alteryx Foundational Micro-Credential – Alteryx
Timeline
Ast Manager (Legal Entity Database Management)
Bank of America
09.2022 - Current
Team Leader (Finance Reference Data Management)
Bank Of America
10.2018 - 08.2022
Senior Accounts Executive (Revenue Recognition/Reporting)
Bharti Airtel Limited
07.2017 - 09.2018
Senior Executive (Account Receivable)
Serco Global
07.2015 - 06.2017
Senior Process Associate
Accenture Services
07.2014 - 07.2015
Executive
Go Realty Mart
12.2012 - 07.2014
Bachelor of Commerce -
Lucknow University
Similar Profiles
Sabien Brown Jr.Sabien Brown Jr.
Business Banking Centralized Specialist at Bank of AmericaBusiness Banking Centralized Specialist at Bank of America
ROSEMARY LOPEZROSEMARY LOPEZ
Customer Service Representative at Bank of AmericaCustomer Service Representative at Bank of America
Yara JovineYara Jovine
Relationship Banker at Bank of AmericaRelationship Banker at Bank of America
Nicholas ShakanNicholas Shakan
Vice President, Portfolio Manager at Bank of America Private BankVice President, Portfolio Manager at Bank of America Private Bank
Laxmikant MukkawarLaxmikant Mukkawar
Data Science Research Assistant at Seneca CollegeData Science Research Assistant at Seneca College