Mohammad Shariq

atwest Bank-Common Reporting Framework (COREP)

The project involved migration of OBIEE reports to tableau for transforming complex financial datasets into interactive, visual dashboards and Automated report generation, scheduling using Tableau Server.

• Worked on the design and development of COREP (Common Reporting) regulatory reports using Tableau & AWS.
• Developed more than 40 Data models, dashboards and drilldown reports under digital transformation activities for Improved data transparency and accuracy and minimizing audit findings.
• Collaborated with BAU users to understand regulatory reporting requirements.
• Integrated Tableau with enterprise data sources of AWS using live and extract connections.

Citi Bank-Data Concerns Remediation Management (DCRM)

• Led root cause analysis for data anomalies in BI dashboards for (FRY-9C, FFIEC Call report etc), coordinating with ETL and BAU teams to implement data validation rules, improving reporting accuracy by 30%.
• Analyzing the Pyspark based Data Pipeline to Identify the impacted Critical data element for different LOBs Deposit/Mortgage, Branded cards.
• Performing data lineage analysis starting from source data Product processor CNLR to down-stream data source Genesis/GFTS for the exam automation.
• Collaborated with Intake data owner for the detailed description of raised data inconsistency.
• Prepared user stories for the finding and shared with Engineering teams for remediation.

The Win-Loss Retail Reporting Suite is a business intelligence (BI) solution designed to analyze and report on sales performance across retail channels.

• Worked as Sr. Developer and Developed interactive Tableau based reporting suites comprising more than 40 dashboards to track key win-loss metrics such as: Win Ratio: % of successful sales vs opportunities, Loss breakdown and time-series trends for Win-Loss across region/products.
• Built parameter-driven views to filter reports dynamically by date range, region, product type, and store hierarchy.
• Integrated Tableau with the enterprise data warehouse Snowflake using custom SQL & extract connection to handle large retail datasets efficiently.
• Mentored the team member about project scope, functionalities, blocker etc.
• Reduced time to insights by 45% by replacing manual Excel reports with interactive dashboards.
• Analyzed large datasets to identify trends and patterns, providing actionable insights that informed strategic decision-making.
• Developed and maintained interactive dashboards using Tableau, enhancing data visualization for stakeholders across multiple departments.