Mayank .

Capital Group (US Project):

• Objective: Enhanced data quality management, Tools: (SQL, Power BI)

• Configured DQ rules on large volume of data in various layers (Landing/Raw/Standard/Prepared) in S3, applying SCD transformations; worked on data profiling along with onshore team.
• Validated the quality of data by configuring rules by applying various checks, working on various dimensions (Completeness, Accuracy, Conformity, Consistency, Integrity, Uniqueness). Extracted and loaded business rule DQ metrics into Data Governance management dashboards.
• Created performance and data quality dashboards in Power BI Desktop representing the outliers in data by raising a flag as success or failure. Created KPIs, pie charts, bar charts and interactive dashboards for monitoring key business metrics.
• Developed reports and stories using Power BI for quick reviews to be presented to end users.
• Automated data refresh in Power BI and created schedule reports for stakeholders.
• Troubleshoot and optimized SQL queries to improve the query performance and database efficiency.

Standard Chartered

• Objective: Created Planning models, mass upload, Tools: (SAP Analytics Cloud)
• Utilized the mass upload functionality in SAP Analytics Cloud to streamline data integration and improve overall system efficiency
• Developed and implemented planning models in SAC to support strategic business planning and decision-making processes
• Designed and deployed interactive dashboards in SAC, providing valuable insights and data visualizations for improved reporting
• Collaborated with cross-functional teams to ensure accurate and timely data input, optimizing planning and forecasting workflows within SAC.

SPS (US Project)

• Objective: provided solutions to customers to assist them in resolving delinquency and avoiding foreclosure, Tools: (SQL, Power BI, Javascript, CI/CD Pipeline)
• Extracted, cleansed, and processed client data using SQL and Power BI for seamless analysis and reporting.
• Written several validation checks, regex and SQL queries using joins and aggregate functions to perform business logic.
• Collaborated with business stakeholders to gather requirements and translate them into technical solutions in Power BI.
• Worked on delivering end to end continuous integration/continuous delivery pipeline by integration tool.