Yogini Shashikant Deshpande

Project Manager Responsibilities:

• Oversaw project planning, resource allocation, risk management, contract management, and stakeholder reporting to ensure timely project delivery.
• Managed asset services modernization program Integration Layer between bank's internal systems and TCS BaNCS to centralize and streamline asset data flow across entities hosted on Google Cloud.
• Led cross-functional teams in developing and implementing strategic solutions.
• Drove continuous improvement of project delivery process by providing strong leadership.
• Managed vendor and supplier contracts by assigning tasks and communicating deliverables to ensure alignment with project goals.
• Analyzed business processes to identify improvement areas and enhance overall operational efficiency.
• Determined project staffing needs and led resource management.
• Made changes to project scope and cost and implemented most effective change management processes to keep project up to date.
• Generated and tracked change orders and other contractual modifications affecting budget and schedule.

Business Analyst Responsibilities:

• Drafted functional specifications documents outlining project scope, objectives and deliverables.
• Created user stories in JIRA and acceptance criteria to guide development teams effectively.
• Designed test plans, scenarios, scripts, cases, and results matrices to validate APIs and DB integration

Tools Used:

JIRA

Google Cloud Storage (DB and File Storage)

Argo CD to analyze logs

Postman

Analyzed EPM engine data flows using MySQL to design and define Snowflake-based data warehouse objects (tables, views, mappings).

• Authored complex SQLs and Source to Target Mapping documents (STMs) to replicate EPM functionalities in a new ETL environment.
• Validated ETL pipelines with Airflow DAGs and ensured accuracy and completeness through rigorous reconciliation of results.
• Employed tools for data analysis and management to support data-driven decision-making.

Created comprehensive documentation, including Data Flow Diagrams and business process dependency diagrams, to enhance understanding of data processes.

MySQL DB

Snowflake

Airflow

MS Visio

• Defined and implemented CSR strategy for an entire business unit across multiple geographies.
• Assessed community needs to identify impactful partnership opportunities.
• Facilitated workshops to educate employees on individual and collective responsibility towards Sustainable Development Goals (SDGs) and community engagement.
• Coordinated employee volunteer activities supporting local charities aligned with company values.
• Collaborated with HR, Admin and project teams to integrate CSR initiatives into business operations
• Reported key performance indicators and impact outcomes to senior leadership, ensuring alignment with organizational goals.
• Worked in collaboration with corporate CSR team to ensure compliance with organization guidelines for CSR

• Designed and implemented data privacy framework to safeguard customer PII data.
• Identified and categorized PII data in accordance with GDPR compliance guidelines.
• Developed PL/SQL-based automation for masking, transforming, and replacing sensitive data.
• Designed data models for protected and unprotected datasets while managing ETL job scheduling.

• Conducted lineage analysis and maintained business glossary definitions using IBM IGC tool, enhancing data governance and consistency.
• Authored source-to-target mapping (STM) and technical requirement documents to ensure clear data flow and project alignment.
• Led system integration testing (SIT) and supported data preparation for UAT phases, ensuring successful project delivery and user acceptance.

• Coordinated communication between client and offshore teams as onsite ETL test manager for DWH projects, ensuring alignment on project requirements and timelines.
• Developed and reviewed complex SQL queries to validate business logic, enhancing data accuracy and integrity for stakeholders.
• Managed test metrics and defect tracking while reporting to stakeholders using HP ALM, providing insights for informed decision-making.

• Ensured data accuracy across multiple warehouse layers through SQL-based dependency testing and complex query writing.
• Designed test plans, cases, and automated regression scripts for ETL validation.
• Streamlined testing cycles by developing Excel macros to automate repetitive tasks.

• Conducted functional and accessibility testing to ensure compliance with WAI standards.
• Reported and tracked defects using HP ALM, enhancing process documentation for improved project clarity.
• Executed detailed manual testing for software applications at BT Global Services.
• Developed test cases based on user requirements and functional specifications.
• Collaborated with developers to identify and resolve software defects.