Chetan Kumar Email and Phone Number

In my current role, I fortify the Business Accounting Finance (BFA) team's operational efficiency by automating manual processes using Google SQL resulting in reducing the time taken to generate comprehensive reports from five days to a single day, enhancing productivity and reporting frequency.I made several key contributions including: • Executed automation of manual processes, reducing the time taken for report generation by 80%.• Conducted rigorous sanity tests on scripts to ensure accuracy, facilitating user acceptance testing before production deployment.• Evaluated the integration of SAP S4/Hana cloud for treasury management to streamline financial risk management and debt and investment processes.

Collaborated with Risk Weighted Assets (RWA) business stakeholders as part of the Capital Planning and Quality Assurance team. I made several key contributions including:• Led efforts to align data with established standards while working closely with the Enterprise Chief Data Office (ECDO) and Financial Chief Data Office (FCDO) teams within the bank.• Ensured adherence to Basel requirements and contributed to data remediation efforts by developing a comprehensive data model and strategies for data cleansing. • Reviewed thoroughly to guarantee accuracy and adherence to standard and advanced Basel reporting methods. • Emphasized pivotal metrics like LGD, EAD, and PD. Analyzed large dataset files to identify key drivers and quarterly trends.• Directed the implementation of strategic projects for cross-exposure consent orders to enhance controls, improve the accuracy of RWA, and adhere to a compressed regulatory calendar.• Successfully managed wholesale banking book RWA delivery for various forecasting schedules such as CCAR, Monthly, yearly, and semi-annual plans.• Utilized Cognos IBM for ad-hoc report requests and provided further analysis to multiple teams for review.

Conducted comprehensive work on MRIA (Matter Requiring Immediate Attention) adhering to federal regulations on banking supervision while serving as a key player in the Asset Liability Management operations team. I made several key contributions including:• Led data sourcing initiatives, conducting extensive data lineage tracing and performing ETL processes to ensure necessary data was available in the designated DataMart for upstream integration into other reports.• Addressed data sourcing requirements for the updated 2052a (6g) requirements and the NSFR (Net Stable Funding Ratio).• Validated and verified data elements crucial for various reporting requirements, including 2052a, NSFR, and CCAR by collaborating with different Lines of Business (LOB) within the organization.• Played a crucial part in User Acceptance Testing (UAT), collaborating closely with end-users to identify and address emerging bugs or defects.• Performed detailed data analysis and profiling utilizing SQL and Excel. Analyzed gaps and created AS-IS and TO-BE workflows to improve understanding of current system workings and future system enhancements.• Successfully conducted comprehensive investigative work to gain a thorough understanding of the complete data lifecycle, onboarding processes, and data location within the organization.

Provided comprehensive solutions for multiple bank operations while working collaboratively with both internal teams and external vendors across the full Software Development Life Cycle (SDLC). I made several key contributions including:• Ensured smooth communication and coordination among cross-functional teams, contributing to successful project outcomes.• Made substantial contributions to defining system needs, coordinating with cross-functional teams, documenting ETL specifications, and producing extensive Data Mapping documentation. • Proficiently analyzed data using SQL and Excel to gain actionable insights and managed various stages of the SDLC, including updates and daily report generation for executive teams.• Developed comprehensive Data Mapping documentation to guide system development and implementation processes.• Played an instrumental role in conducting impact analyses on systems dependent on specific Data Marts and fulfilling ad-hoc report requests for diverse teams.• Oversaw project stages in the software development lifecycle (SDLC), curated JIRA boards, and produced daily executive update reports.• Conducted meticulous impact analyses on systems dependent on specific Data Marts, ensuring smooth operations.

Oversaw treasury business for numerous regulatory reporting needs, involving handling various projects that aimed at enhancing or replacing existing applications supported by treasury technology, including management of systems, such as Cash flow forecasting, LCR, 5G, CT core replacement, and NSFR.I made several key contributions including:• Developed and sustained functional specifications and detailed design documents to guide IT in implementing 5G reporting solutions.• Developed data mapping documents through comprehensive data analysis with Toad for Oracle.• Reviewed and analyzed data in Excel, providing actionable suggestions to enhance data availability for reporting.• Generated customized reports by developing simple to complex SQL queries based on requests from Business Stakeholders and technology teams.• Organized and led meetings with management and development teams to conduct requirement-gathering sessions aiming to determine functional, business, and system requirements.meets standards set by the guidline.

Operated as a key member of the Enterprise Data Management group at BNP Paribas, focusing on enhancing the accuracy and comprehensiveness of Asset Liability Management Treasury (ALMT) reporting for 5G Liquidity. I made several key contributions including:• Analyzed FARM data and created Functional Specifications (FRD) and detailed Design Documents (DDD), which provided valuable guidance for IT implementation in 5G reporting.• Thrived in identifying gaps and inaccuracies in reporting due to data quality within the internal database (FARM) and conducted robust analysis to provide actionable recommendations to the business.• Generated custom reports using complex SQL queries meeting the unique requests of Business Stakeholders and other technology teams.• Conducted thorough data lineage analysis and profiling, leading to the design and implementation of multiple schemas and views, significantly improving data accessibility for reporting purposes.• Collaborated with business stakeholders to conduct meticulous gap analysis and verify the adequacy of data in repositories for reporting purposes.

Played a key role in regulatory reporting for the Enterprise Information Technology department, primarily focusing on the Liquidity Analytics Reporting System. I made several key contributions including:• Orchestrated the creation and maintenance of critical business requirement documents, significantly enhancing the efficiency of system development efforts. • Generate insightful reports for various Lines of Business by leveraging advanced data blending features in Tableau.• Oversaw the creation and maintenance of vital business documents, including Business Requirement Documents, Use Case Specifications, and Functional Specifications (FRD). • Successfully managed the entire User Acceptance Testing process, ensuring the quality and accuracy of system enhancements before their final implementation.• Conducted comprehensive data lineage analysis and remediation, significantly improving the quality of data used in regulatory reporting.• Successfully facilitated meetings between management and development teams, effectively defining functional, business, and system requirements.• Managed the implementation of metadata standards, data governance, and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling.

Wells capital management utilizes a lot of 3rd party vendors to perform day to day trading activities. I am part of the WellsCap enterprise Technology team supporting the Portfolio accounting and operations team within the organization with their day to day smooth running of the business working with particularly (Advent APX systems, Odyssey AAA, SS&C Recon, fidelity) to name a few.

Wells Fargo Wholesale Loan Services for a system to be used for certifying the accuracy of loan data with Loan Data Integrity Certifier (LDIC). LDIC frontend is used by Wholesale Loan Services Group which enables the user the view/track and act upon all the BQR (Borrower Quality Rating) mismatch between ART (Asset Rating Tool) and SOR, BQR missing in ART and BQR variance across LOB’s (Line of Business) within LDIC.

The IRD department within Wells Fargo’s Wholesale works on multiple different Proof of Concepts each year. I was Part of the E-Bill Express Project that is a white label native application that will replicate the desktop version that Transactis offers to its customers currently. The E-bill express app will give the end users the ability to pay all their bills through one app and don’t have to worry about downloading multiple applications on their devices. It will support the following platforms Android and IOS for its first Implementation. I was Part of Liquidhub at Wells Fargo who handles multiple projects within the IRD team namely (E-Bill Express, WMS API, Passbook, Frontend and backend ESB, Payments SDK,).