Professional Summary:

Experience as a Data Analyst 7 Years of Data Governance, Data Quality, Data Lineage, QuickBase Developer, Doorstep Banking, ATM Monitoring, PCI - DSS, Reporting Specialist, MS Office 365 Formulas, Data visualization, Data Analysis and VBA, Macros, Power Query, Dashboards

Collecting, cleaning and analyzing large sets of data from various sources, such as databases, spreadsheets, and surveys.

Collating Business requirements, Analyzing the value and functional requirements, supportability considerations, Data Analysis, Data Quality, Data Modeling, Data Migration Bank to another Bank, Transaction monitoring

Supports managing software development project life cycle delivery from initiation to deployment including project estimation, planning, Documentation, Data Quality, Data Migration, Data Quality Reports, Preparing the Unstructured Data Analysis in tracking, scope control, risks & issues management, resource management and status reporting

Project Management support resources that can assist with a variety of project management tasks. Assist with improvements to the Operations Data - Invoice - Reporting process, Data Visualization (Power Bi), Power BI, VBA, Macros

Preparing Daily - Weekly - Monthly and Quarterly MIS reports in time, accuracy, and complete of the reports, PPT’s, Proficient in MS excel, VLOOKUP, XLOOPUP, PIVOT tables, Conditional formatting, data validation, Advanced Excel, SQL Macros, VBA, Slicer, MS Outlook, slicers, PowerPoint presentations, Nested VLOOKUP, Nested IF Functions, SUMIF, COUNTIF.VBA, VBA Macros, PowerPoint Presentations and Power Bi

Educational Qualifications:

Bachelor of Technology in E.C.E, Jawaharlal Nehru Technological University Hyderabad, Graduated 2015

Certifications

Microsoft Certified: Data Analytics Associate in Excel

Data Analytics Associate in Beginner's Intermediate's Leve Excel formulas in 2023

Project Management Analysis, Dashboards in Excel formulas & Data & Business Analyst Requirements, Teams in Dec 2022

Certified in Project management Foundations (Data Operations), Requirements, Teams in 2022

Professional Experience:

Organization

Intelligent Machines Lab Pvt Ltd Mar - 2023 to LWD 24 - Aug – 2023, Pune

Skills - Tools

QuickBase Developer, IT PMO, PowerPoint Presentations, Power Bi, VBA, Macros, ETL Tools, Alteryx Tool, Data Monitoring, Data Operations, Interactive Dashboards, SQL, IT Project

Roles and Responsibilities:

Develop and implement data governance policies, procedures, and standards to ensure data quality, integrity, and security.

Collaborate with cross-functional teams to define and document data governance requirements and objectives.

Establish and maintain a data governance framework, including data classification, data ownership, and data stewardship.

Conduct data quality assessments and audits to identify and resolve data issues and inconsistencies.

Define and enforce data governance roles and responsibilities across the organization.

Develop and deliver data governance training programs to educate employees on data governance principles and best practices.

Monitor and enforce compliance with data governance policies and procedures.

Collaborate with IT teams to implement data governance tools and technologies.

Lead data governance initiatives, such as data privacy and protection, data retention, and data lifecycle management.

Establish data governance metrics and reporting mechanisms to track the effectiveness of data governance efforts.

Stay updated on industry trends and best practices in data governance and recommend improvements to existing processes.

Collaborate with legal and compliance teams to ensure data governance practices align with regulatory requirements and industry standards. Develop Learning & Development interactive dashboards and cultivate data models.

Create detailed requirement documents that serve as a reference for development and Internal and External teams

Design, develop, update, and optimize Power BI dashboards, reports, and KPI scorecards to meet business requirements

Clean and format unorganized data into the required format using MS Excel techniques and formulas.

Prepare and publish reports to management and stakeholders to monitor and understand Service Level Agreements (SLAs).

Create reports, presentations, and dashboards for management, effectively communicating trends, patterns, predictions using relevant data

Project Details:

Organization: SiE-Brains Technology Services PVT LTD Client: KPMG Global Services Limited

Skills - Tools: Data Quality, Governance, Financial Budgeting, Forecasting, Variance, MS Excel, VBA Macros, Data Visualisation (Power Bi), Power BI, QuickBase Developer, Design, Implementation, Dashboards, MIS MGMT,

Duration: Mar - 2022 to Mar – 2023 Bangalore

Roles and Responsibilities:

Developing and monitoring detailed project plan to monitor and track project progress.

Conduct data quality assessments and audits to identify and resolve data issues and inconsistencies.

Define and enforce data governance roles and responsibilities across the organization.

Develop and deliver data governance training programs to educate employees on data governance principles and best practices.

Monitor and enforce compliance with data governance policies and procedures.

Collaborate with IT teams to implement data governance tools and technologies.

Lead data governance initiatives, such as data privacy and protection, data retention, and data lifecycle management.

Establish data governance metrics and reporting mechanisms to track the effectiveness of data governance efforts.

Stay updated on industry trends and best practices in data governance and recommend improvements to existing processes.

Collaborate with legal and compliance teams to ensure data governance practices align with regulatory requirements and industry standards. Develop Learning & Development interactive dashboards and cultivate data models.

Creating and distributing project dashboards and MIS reports to multiple stakeholders, which include data collection, reporting, trend analysis, and project metric presentations

Supports managing full project life cycle delivery from initiation to deployment including project estimation, planning, tracking, scope control, risks & issues management, resource management and status reporting

Creating and distributing project health dashboards and MIS reports to multiple stakeholders, which include data collection, reporting, trend analysis and project metric PowerPoint presentation?

Project Details:

Organization

Lancesoft India Pvt Ltd May - 2021 to Feb - 2022 ‘Bangalore

Client: HCL Technologies Ltd

Skills - Tools

Data analyst - Reporting (Project Analysis), VBA, Excel Macros reports, I TAP, TAG Manager Access, SQL, Smart recruit, Smart Verify, MIS Excel, Reporting analyst, ETL Tool, Power Query, Data Modelling, Data Mining

Project Scope: The role incumbent who can provide support to the team on reporting, data analytics, operations, and project management. Responsible for producing IT Portfolio status reporting including executive dashboards. Under the supervision of IT Leader, drives and tracks Project demand intake process, prioritization and provides full transparency through reporting. Working closely with IT leaders, leads and completes IT department capacity planning and refreshes on a monthly basis to show variations - gaps in meeting the business demand. Helps and supports new Employee - Contract onboarding process including ordering equipment.

Roles and Responsibilities:

Lead data governance initiatives, such as data privacy and protection, data retention, and data lifecycle management.

Establish data governance metrics and reporting mechanisms to track the effectiveness of data governance efforts.

Stay updated on industry trends and best practices in data governance and recommend improvements to existing processes.

Collaborate with legal and compliance teams to ensure data governance practices align with regulatory requirements and industry standards.

Create detailed requirement documents that serve as a reference for development and Internal and External teams

Design, develop, update, and optimize Power BI dashboards, reports, and KPI scorecards to meet business requirements

Clean and format unorganized data into the required format using MS Excel techniques and formulas.

Prepare and publish reports to management and stakeholders to monitor and understand Service Level Agreements (SLAs).

Create reports, presentations, and dashboards for management, effectively communicating trends, patterns, predictions using relevant data

In day to day Candidate Offered, Candidate Joined, Renege, Candidate Not Joined, DOJ extension reports

Day to day relationship management with vendors & lead all communication with the customer related to the report.

Develop the various trackers and proactive use the trackers and monitoring tools for day-to-day activity planning monitoring.

Provide updates to Infra - Management - Client through Daily - weekly - monthly reports.

Project Details:

Project: Doorstep Banking Service _ Banks Data Migration

Organization: Atyati Technologies

Skills - Tools: Business analyst (Advanced Excel, IBA Transactions, Data managing, Banks Migration), SQL, Data Operations, Reconciliations

Duration: Oct - 2020 to May - 2021 - Bangalore

Roles and Responsibilities:

Managing the project schedule and ensuring that deadlines are met

Develop and implement data governance policies, procedures, and standards to ensure data quality, integrity, and security.

Collaborate with cross-functional teams to define and document data governance requirements and objectives.

Establish and maintain a data governance framework, including data classification, data ownership, and data stewardship.

Conduct data quality assessments and audits to identify and resolve data issues and inconsistencies.

Define and enforce data governance roles and responsibilities across the organization.

Establishing and maintaining project management processes and tools to ensure consistent project delivery.

Managing the transition of the project to ongoing operations and maintenance.

Ensuring that project deliverables meet the required quality standards.

Managing project budgets and resources, including personnel and equipment. Identifying and mitigating project risks.

Establishing and maintaining project management processes and tools to ensure consistent project delivery.

Prepare Daily - Weekly - Monthly and Quarterly MIS reporting for the IFS practice Ensure the timeliness, accuracy, and completeness of the reporting.

Project Details:

Organization

Financial Software Systems Pvt Ltd Aug - 2015 to Oct - 2020 - Chennai

Client: DIT – Andhra Bank Data Centre

Skills - Tools

MS Excel, VBA Macros, Excel Formulas, VLOOKUP, HLOOKUP, SUMIF, COUNT, COUNTIF, LOOKUP Formulas, ADM TOOLS, FINACLE Tools, Dashboards, MIS Formulas and Functions, Reconciliation Transactions

Roles and Responsibilities:

Preparing daily report for Andhra banks using MIS Data Quality, Excel reports

Lead data governance initiatives, such as data privacy and protection, data retention, and data lifecycle management.

Establish data governance metrics and reporting mechanisms to track the effectiveness of data governance efforts.

Stay updated on industry trends and best practices in data governance and recommend improvements to existing processes.

Collaborate with legal and compliance teams to ensure data governance practices align with regulatory requirements and industry standards. Develop Learning & Development interactive dashboards and cultivate data models.

Automated real-time Electronic Journal data retrieval from the entire, multi-vendor, ATM network

ATM monitoring: Follow up with vendors, branches for File preparation and Call Center Handling

Reports related: ABK all transaction File sharing, cash position mails, ABK all transaction file uploading

Managing the transition of the project to ongoing operations and maintenance.

Ensuring that project deliverables meet the required quality standards.

Managing project budgets and resources, including personnel and equipment. Identifying and mitigating project risks.

Prepared monthly Performance Status Reports. Generated, maintained, analyzed Quality and Client Service reports.

Declaration:

I hereby declare that information and evidence given by me in the above are true to the best of my knowledge.

preferred Locations: Pune, Mumbai, Bangalore, Hyderabad Name: (SURESH YADAV)

Contact this candidate