Waquarul Hassan

• Working on Business Intelligence analysis / Data Integration Analysis.
• Responsible to take care all the data integrations using Azure data factory, SSMS and other
related tools.
• Improving technical and functional capabilities in banking sector for any type of
default/write-off etc. as well as involved in analysis of existing ba n ki ng products.
• Work on performance optimization of multiple pipelines in ADF as well as on SQL side.
• Responsible to analyze and help analysts to create executive reports.
• Collaborating with different portfolio leads and Data Science team to understand requireme nts
and deliver BI solutions.
Environment and Technology used: MS-SQL, SSMS, SOQL, Salesforce, Tableau, Azure Data Factory - Data Flow
and Data Pipeline, MS-Excel

• Working on Portfolio management and Credit analysis for Maya Bank customers.
• Working and leading the launch of multiple new products for SME business as well as
involved in analysis of improvement in existing products.
• Worked on acquisition of customers based on white-listing criteria.
• Responsible to analyze and create executive reports.
• Monitor portfolio performance, identifying emerging risks in credit lending and analyze potential
credit loss / forecasting / decisioning based on that.
Environment and Technology used: SQL, Python, Tableau, SAS, AWS Redshift, JIRA, Databricks, MS-Excel, MS
PowerPoint

• Leading the team of Data Analysts providing business and data analytics to different portfolios for
Biz2Credit (A business loan -MSME lending firm in US)
• Scorecard development for assessing SME customers based on bank statement classification, bureau and
application inputs. Exercise includes cash flow analysis, lien analysis and stability testing.
• Work on BI tools for Risk models (Credit Risk scorecard Model) and build multiple reports for multiple
teams across the organization.
• Static Pool analysis (COVID analysis)-Recovery Ratio, Gross write off ratio, cash collection ratio,
payment past due (PmVD/PmVF) based on different investor portfolio.
• Involved in demand prioritization framework with respect to data requirement and report requirements.
• Good experience in Credit Risk for business loans (unsecured loans) and developed risk and underwriting
policies for multiple types of unsecured loans like MCA, PPP etc.
• Worked on evaluating the current policies, enhancement if required, cross strategies and monitoring
funnel performance (Calendar and cohort), portfolio performance, post loan disbursement performance,
charge-off/delinquency reason and analysis.
• Summarizing analysis and findings and share with top management.
• Support Model development team for model testing. To monitor and analyze trends and
performance over time.
• Part of PPP loans (SBA loans in US) framework and analysis
• Work on COVID-19 analysis-based bank statement analyzer factors such as DSCR, EBITDA etc.
• Worked with external investor for fulfillment of requirement specific to capital market i.e.
portfolio analysis
• Guidance to underwriting team and other stakeholders to ensure correct UW decisioning and
adherence to established policies.
• Auto decision rule engine-Gandalf for underwriters.
• Writing SQL queries as per requirement and hands on work experience in SAS.
• Also helping team in report generation using reporting tool Tableau, PowerBI, Intellicus, Pentaho and
Jasper.
• Worked on Agile as well as waterfall model.
• Analysis as per requirement and report to upper management which help them to make decision/s.
• Involved in demand plan, budgeting and capacity planning.
• Provided multiple cost-effectiveness initiatives.
Environment and Technology used: MySQL, PowerBI, SAS, AWS Redshift, JIRA, Intellicus, Jasper, Pentaho, MS
Excel, Agile, Waterfall

• Lead the team of Data Analysts providing business analytics to different functions of Airtel like
Marketing, Finance, RA etc. across PAN India.
• Requirement gathering from client for existing and new processes and ensuring on-time delivery.
• Providing domain/business consultation to both development and operations team.
• Mentoring new/existing resources by providing technical/business process guidance, to accomplish the
ongoing and upcoming assignments.
• Data Mining and analyzing and drawing conclusions to uncover the trends in telecom industry.
• Guide the business users and cross functional teams to understand the implemented business
logics behind the SQL/UNIX scripts and data loading process.
• Reconciling the data loading and rectify the issues by making required changes in the loading scripts.
• Facilitating Airtel managers in generating different campaigns based on different telecom KPIs.
• Executing and publishing BO Reports as per user data requirements.
• Database management by Performance tuning and monitoring of the business queries using Query
Patroller.
Environment and Technology used: DB2, UNIX, Data Stage, Business Objects, Cognos, Informatica, AutoSys,
Maximo, Query petroller